/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
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.Page;
import com.mole.struts.dao.CustomerRecordDAO;

/**
 * MyEclipse Struts Creation date: 11-04-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action path="/customerRecord" name="customerRecordForm"
 *                input="customerRecord.jsp" scope="request" validate="true"
 */
public class CustomerRecordAction 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) {
		String LoginID = String.valueOf(request.getSession().getAttribute(
				"user"));
		if (LoginID == null)
			return mapping.findForward("goLogin");
		CustomerRecordDAO dao = new CustomerRecordDAO();
		String str = dao.getPublic(LoginID);
		String end = "";
		String time = request.getParameter("datetime");
		String select = request.getParameter("select");
		// 生成列表
		ArrayList store;
		try {
			store = dao.getStoreInfo(LoginID);
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "錯誤信息");
			session.setAttribute("message", "用戶名或密碼錯誤，請重新登陸！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		if (select != null && !select.equals("all"))
			end = " and a.StoreID='" + select + "'";
		if (time != null && !time.equals(""))
			end += " and convert(varchar(10),a.DealDate,120) like'" + time
					+ "'";
		Page page = new Page();
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));
		int count = dao.getCount(LoginID, end);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		ArrayList<Object[]> list;
		try {
			list = dao.getRecord(LoginID, end, page.getCurrentPage(), page
					.getPageSize());
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "錯誤信息");
			session.setAttribute("message", "用戶名或密碼錯誤，請重新登陸！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		if (list == null)
			return mapping.findForward("getInfoSuccess");
		request.setAttribute("Public", str);
		request.setAttribute("Page", page);
		request.setAttribute("selected", select);
		request.setAttribute("oneday", time);
		request.setAttribute("store", store);
		request.setAttribute("record", list);
		return mapping.findForward("getInfoSuccess");
	}
}