/*
 * 作者:荊明君
 * 時間:2007年12月11日
 * 功能:平臺操作人員管理-個人資料與密碼的修改。
 */
package com.mole.struts.action;

import java.util.ArrayList;

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.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mole.struts.bean.AdminInfoModifyBean;
import com.mole.struts.dao.DBConnector;
import com.mole.struts.form.AdminInfoModifyForm;

/**
 * MyEclipse Struts Creation date: 12-11-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class AdminInfoModifyAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ActionForward forward = null;

		String action = request.getParameter("action");
		if (action == null || action.equals("personal")) {// 顯示個人資料信息頁面
			forward = showAdminInfo(mapping, form, request);

		} else if (action.equals("onModify")) {// 修改個人資料
			forward = modifyAdminInfo(mapping, form, request);

		} else if (action.equals("password")) {// 顯示密碼修改頁面
			forward = mapping.findForward("goAdminInfoPassword");

		} else if (action.equals("onPassword")) {// 修改密碼
			forward = modifyAdminPassword(mapping, form, request);
		}
		return forward;
	}

	// 顯示個人資料信息頁面
	public ActionForward showAdminInfo(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {

		String loginId = (String) request.getSession().getAttribute("user");
		DBConnector db = new DBConnector();
		AdminInfoModifyBean info = new AdminInfoModifyBean();
		String sql = "SELECT LoginName,Password,Role,Name,Gender,ISNULL(Email,''),ISNULL(Telephone,''),ISNULL(CellPhone,''),ISNULL(Address,''),CreateDate,LastLogin from [administrator] where ID="
				+ loginId;
		ArrayList<Object[]> list = null;
		try {
			list = db.executeQuery(sql.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
		Object[] obj = list.get(0);
		info.setLoginName(obj[0].toString());
		info.setPassword(obj[1].toString());
		info.setRole(obj[2].toString());
		info.setName(obj[3].toString());
		info.setGender(obj[4].toString());
		info.setEmail(obj[5].toString());
		info.setTelephone(obj[6].toString());
		info.setCellphone(obj[7].toString());
		info.setAddress(obj[8].toString());
		info.setCreateDate(obj[9].toString().substring(0, 10));
		info.setLastLogin(obj[10].toString().substring(0, 10));

		request.setAttribute("info", info);
		return mapping.findForward("goAdminInfoModify");
	}

	// 修改個人資料
	public ActionForward modifyAdminInfo(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {

		String loginId = (String) request.getSession().getAttribute("user");
		HttpSession session = request.getSession();
		DBConnector db = new DBConnector();
		AdminInfoModifyForm adminInfoViewForm = (AdminInfoModifyForm) form;

		String name = adminInfoViewForm.getName();
		String gender = adminInfoViewForm.getGender();
		String telephone = adminInfoViewForm.getTelephone();
		String cellphone = adminInfoViewForm.getCellphone();
		String email = adminInfoViewForm.getEmail();
		String address = adminInfoViewForm.getAddress();

		int n = 0;
		try {
			String sql = "update [administrator] set name='" + name
					+ "',Gender='" + gender + "',Email='" + email
					+ "',Telephone='" + telephone + "',Cellphone='" + cellphone
					+ "',Address='" + address + "' where ID='" + loginId + "'";
			n = db.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();

		}
		if (n == 1) {
			session.setAttribute("title", "成功信息");
			session.setAttribute("message", "修改個人資料成功！");
			session.setAttribute("returnUrl",
					"adminInfoModify.do?action=personal");
			return mapping.findForward("goMessage");
		} else {
			session.setAttribute("title", "失敗信息");
			session.setAttribute("message", "修改個人資料失敗！");
			session.setAttribute("returnUrl",
					"adminInfoModify.do?action=personal");
			return mapping.findForward("goMessage");
		}
	}

	// 修改密碼
	public ActionForward modifyAdminPassword(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {

		String loginId = (String) request.getSession().getAttribute("user");
		HttpSession session = request.getSession();
		DBConnector db = new DBConnector();
		AdminInfoModifyForm adminInfoViewForm = (AdminInfoModifyForm) form;
		String password = adminInfoViewForm.getPassword();
		String newPassword = adminInfoViewForm.getNewPassword();

		String sql = "UPDATE administrator SET password='" + newPassword
				+ "' WHERE  ID=" + loginId + " AND Password='" + password + "'";
		int n = 0;
		try {
			n = db.executeUpdate(sql);
		} catch (Exception e1) {
			e1.printStackTrace();
		}
		if (n == 1) {
			session.setAttribute("title", "成功信息");
			session.setAttribute("message", "修改密碼成功！");
			session.setAttribute("returnUrl",
					"adminInfoModify.do?action=password");
			return mapping.findForward("goMessage");
		} else {
			session.setAttribute("title", "失敗信息");
			session.setAttribute("message", "修改密碼失敗！");
			session.setAttribute("returnUrl",
					"adminInfoModify.do?action=password");
			return mapping.findForward("goMessage");
		}
	}

}