/*
 * 創建日期 2005-12-10
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package bit.jeffy.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import bit.jeffy.db.DataStore;
import bit.jeffy.personal.RegisterBean;
import java.io.File;
import java.sql.ResultSet;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
 * @author jeffy
 *
 * TODO 要更改此生成的類型注釋的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class RegisterAction extends Action {

	/* （非 Javadoc）
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping map, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO 自動生成方法存根
		ActionErrors errors = new ActionErrors();
		
		String userZh = null;
		
		String userPwdf = null;
		
		String userPwds = null;
		
		String userXm = null;
		
		String userSex = null;
		
		String userMail = null;
		
		String userPhone = null;
		
		String userQq = null;
		
		String userDescription = null;
		
		String userPublic = null;
		
		String tmp = null;
		
	   	Pattern p = Pattern.compile("[a-zA-Z0-9_]*");
	   	Matcher m = null;
	   	
		//0表示不公開,1表示公開
		int if_public = 0;
		
		userZh = (String)((RegisterBean)form).getUserZh();
		if( userZh == null ) {
			errors.add("fail_1",new ActionError("Register.error.a"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}else {
			userZh = new String(userZh.getBytes("ISO-8859-1"),"GB2312");
		}
		
		if( userZh.equals("")) {
			errors.add("fail_1",new ActionError("Register.error.a"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		m = p.matcher ( userZh );
		if(!m.matches()) {
			errors.add("fail_8",new ActionError("Register.error.h"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
			
		userPwdf = (String)((RegisterBean)form).getUserPwdf();
		userPwds = (String)((RegisterBean)form).getUserPwds();
		if( userPwdf == null || userPwds == null ) {
			errors.add("fail_2",new ActionError("Register.error.b"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		userPwdf = new String(userPwdf.getBytes("ISO-8859-1"),"GB2312");	
		userPwds = new String(userPwds.getBytes("ISO-8859-1"),"GB2312");
		
		if( userPwdf.length() < 6 || userPwds.length() < 6 ) {
			errors.add("fail_3",new ActionError("Register.error.c"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		if( !userPwdf.equals(userPwds)) {
			errors.add("fail_4",new ActionError("Register.error.d"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		m = p.matcher ( userPwdf );
		if(!m.matches()) {
			errors.add("fail_9",new ActionError("Register.error.i"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		m = p.matcher ( userPwds );
		if(!m.matches()) {
			errors.add("fail_10",new ActionError("Register.error.i"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		
		
		userXm = (String)((RegisterBean)form).getUserXm();
		if( userXm == null ) {
			userXm = "";
		}
		userXm = new String(userXm.getBytes("ISO-8859-1"),"GB2312");
		if( userXm.equals("")) {
			userXm = "無資料";
		}
		
		userSex = (String)((RegisterBean)form).getUserSex();
		if( userSex == null ) {
			userSex = "";
		}
		userSex = new String(userSex.getBytes("ISO-8859-1"),"GB2312");
		if( userSex.equals("")) {
			userSex = "*";
		}
		
		userMail = (String)((RegisterBean)form).getUserMail();
		if( userMail == null ) {
			userMail = "";
		}
		userMail = new String(userMail.getBytes("ISO-8859-1"),"GB2312");
		if( userMail.equals("")) {
			userMail = "無資料";
		}
		
		userPhone = (String)((RegisterBean)form).getUserPhone();
		if( userPhone == null ) {
			userPhone = "";
		}
		userPhone = new String(userPhone.getBytes("ISO-8859-1"),"GB2312");
		if( userPhone.equals("")) {
			userPhone = "無資料";
		}
		
		userQq = (String)((RegisterBean)form).getUserQq();
		if( userQq == null ) {
			userQq = "";
		}
		userQq = new String(userQq.getBytes("ISO-8859-1"),"GB2312");
		if( userQq.equals("")) {
			userQq = "無資料";
		}
		
		userDescription = (String)((RegisterBean)form).getUserDescription();
		if( userDescription == null ) {
			userDescription = "此人身份不明";
		}
		userDescription = new String(userDescription.getBytes("ISO-8859-1"),"GB2312");
		if( userDescription.equals("")) {
			userDescription = "無資料";
		}
		if(userDescription.length()>100) {
			tmp = userDescription.substring(0,100);
			userDescription = tmp;
		}
		
		userPublic = (String)((RegisterBean)form).getUserPublic();
		if( userPublic == null) {
			userPublic = "";
		}
		userPublic = new String(userPublic.getBytes("ISO-8859-1"),"GB2312");
		if( userPublic.equals("公開") ) {
			if_public = 1;
		}else if( userPublic.equals("不公開") ) {
			if_public = 0;
		}else {
			if_public = 0;
		}
		
		//向數據庫操作
		DataStore ds = DataStore.getInstance();
		String sql_1 = "select * from Client where ZH='"+userZh+"'";
//		判斷帳戶是否已經存在
		ResultSet rs = null;
		rs = ds.read(sql_1);
		if( rs != null && rs.next() ) {
			errors.add("fail_5",new ActionError("Register.error.e"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		
		String sql_2 = "insert Client values('"+
						 userZh+"','"+
						 userPwdf+"','"+
						 userXm+"','"+
						 userSex+"','"+
						 userMail+"','"+
						 userPhone+"','"+
						 userQq+"','"+
						 userDescription+"','"+
						 if_public+"')";
		String sql_3 = "insert ClientFileSpace values('"+
						 userZh+"','10240','0','0')";
						 
		
		
		ds.beginTransaction();
		
		try {
			ds.execute(sql_2);
			ds.execute(sql_3);
		}catch(Exception e) {
			ds.ErrorOccur();
			ds.commitTransaction();
			errors.add("fail_6",new ActionError("Register.error.f"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}
		
		String dir = null;	
		File f = null;
		try {
			dir = servlet.getServletContext().getRealPath("/file/"+userZh);
			f = new File(dir);
			
			if( !f.isDirectory() )
		    	f.mkdir();
		}catch(Exception e) {
			ds.ErrorOccur();
			ds.commitTransaction();
			errors.add("fail_7",new ActionError("Register.error.g"));
			saveErrors(request,errors);
			return (map.findForward("registerfail"));
		}	  
		
		ds.commitTransaction();
		
		return (map.findForward("registerok"));

	}
}