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

import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.RemindBean;

/**
 * @author jeffy
 *
 * TODO 要更改此生成的類型注釋的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class AddRemindAction 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 自動生成方法存根
		HttpSession session = request.getSession();
			
		ActionErrors errors = new ActionErrors();
		
		String userZh = (String)session.getAttribute("current_user");
		
		if( userZh == null ) {
			errors.add("fail_1",new ActionError("add.remind.action.a"));
			saveErrors(request,errors);
			return (map.findForward("addremindfail"));
		}else {
			userZh = new String(userZh.getBytes("ISO-8859-1"),"GB2312");
		}
		
		String theme = null;
		theme = (String)((RemindBean)form).getTheme();
		if( theme == null ) {
			theme = "";
		}
		theme = new String(theme.getBytes("ISO-8859-1"),"GB2312");
		if( theme.equals("")) {
			theme = "*";
		}
		
		String content = null, tmp = null;
		content = (String)((RemindBean)form).getContent();
		if( content == null ) {
			content = "";
		}
		content = new String(content.getBytes("ISO-8859-1"),"GB2312");
		if( content.equals("")) {
			content = "*";
		} else if(content.length()>100) {
			tmp = content.substring(0,100);
			content = tmp;
		}
		
		DataStore ds = DataStore.getInstance();
		String sql = "insert ClientRemind(ZH,THEME,CONTENT,MAKEDATE) values('" +
			          userZh+"','" +
			          theme+"','" +
			          content+"',CURDATE())";
		
		ds.beginTransaction();
		
		try {
			ds.execute(sql);
		} catch(Exception e) {
			ds.ErrorOccur();
			ds.commitTransaction();
			errors.add("fail_2",new ActionError("add.remind.action.b"));
			saveErrors(request,errors);
			return (map.findForward("addremindfail"));
		}
		
		ds.commitTransaction();
		
		request.setAttribute("view","4");
		return (map.findForward("addremindok"));
	}
}