package mrgf.action;

import java.util.List;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import mrgf.form.ManageOrderForm;
import mrgf.other.Hibernate;
import mrgf.hibernate.*;
import java.util.Calendar;

public class ManageOrderAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
        ManageOrderForm manageOrderForm = (ManageOrderForm) form;
        String parameter = mapping.getParameter();
        String forward = "";
        HttpSession session = request.getSession();
        Hibernate hn = new Hibernate();
        //管理員登錄
        if (parameter.equals("managerLand")) {
            forward = "manager_land";
        }
        if (parameter.equals("managerLandSubmit")) {
            String managerName = manageOrderForm.getManager();
            String hql = "from ManagerInfo where manager='" + managerName + "'";
            ManagerInfo manager = (ManagerInfo) hn.queryOne(hql);
            forward = "manager_land";
            if (manager != null &&
                manageOrderForm.getPassword().equals(manager.getPassword())) {
                session.setAttribute("manager", managerName);
                hql = "from OrderInfo where consignment='new'";
                List orders = hn.query(hql);
                request.setAttribute("orders", orders);
                session.setAttribute("orders", orders);
                forward = "manage_index";
            }
        }
        //管理員退出
        if (parameter.equals("managerExit")) {
            session.removeAttribute("manager");
            forward = "index";
        }
        //進(jìn)入首頁
        if (parameter.equals("manageIndex")) {
            String hql = "from OrderInfo where consignment='new'";
            List orders = hn.query(hql);
            session.setAttribute("orders", orders);
            forward = "manage_index";
        }
        //進(jìn)入定單管理
        if (parameter.equals("manageOrder")) {
            forward = "manage_order";
        }
        //查看定單詳細(xì)內(nèi)容
        if (parameter.equals("manageOrderParticular")) {
            String orderId = request.getParameter("orderId");
            String hql = "from OrderInfo where id='" + orderId + "'";
            OrderInfo order = (OrderInfo) hn.queryOne(hql);
            request.setAttribute("order", order);
            forward = "manage_order_particular";
        }
        //從定單詳細(xì)內(nèi)容返回到前一頁
        if (parameter.equals("returnFromOrderParticular")) {
            String leadPage = (String) session.getAttribute("leadPage");
            if (leadPage.equals("/manage_index.jsp")) {
                forward = "manage_index";
            } else {
                forward = "manage_order";
            }
        }

        //搜索定單
        if (parameter.equals("searchManageOrder")) {
            String hql = "from OrderInfo where total>0";
            //判斷是否輸入定單編號(hào)
            if (manageOrderForm.getOrderId().length() == 14) {
                hql = hql + " and id='" + manageOrderForm.getOrderId() + "'";
            }
            //判斷是否輸入定單總額
            int min = 0;
            int max = 0;
            if (manageOrderForm.getMinOrderMoney().length() > 0) {
                min = Integer.parseInt(manageOrderForm.getMinOrderMoney());
            }
            if (manageOrderForm.getMaxOrderMoney().length() > 0) {
                max = Integer.parseInt(manageOrderForm.getMaxOrderMoney());
            }
            if (min != 0 && max != 0) {
                hql = hql + " and money between " + min + " and " + max;
            } else if (min != 0) {
                hql = hql + " and money>=" + min;
            } else if (max != 0) {
                hql = hql + " and money<=" + max;
            } else {}
            //判斷是否輸入客戶名稱
            if (manageOrderForm.getUsername().length() > 0) {
                hql = hql + " and username='" + manageOrderForm.getUsername() +
                      "'";
            }
            //判斷是否輸入日期條件
            Calendar now = Calendar.getInstance();
            int year = now.get(Calendar.YEAR);
            int month = now.get(Calendar.MONTH) + 1;
            String beginDate = "";
            if (manageOrderForm.getDayBegin().length() > 0) {
                beginDate = manageOrderForm.getDayBegin();
                if (manageOrderForm.getMonthBegin().length() > 0) {
                    beginDate = manageOrderForm.getMonthBegin() + "-" +
                                beginDate;
                } else {
                    beginDate = month + "-" + beginDate;
                }
                if (manageOrderForm.getYearBegin().length() > 0) {
                    beginDate = manageOrderForm.getYearBegin() + "-" +
                                beginDate;
                } else {
                    beginDate = year + "-" + beginDate;
                }
            }
            String endDate = "";
            if (manageOrderForm.getDayEnd().length() > 0) {
                endDate = manageOrderForm.getDayEnd();
                if (manageOrderForm.getMonthEnd().length() > 0) {
                    endDate = manageOrderForm.getMonthEnd() + "-" + endDate;
                } else {
                    endDate = month + "-" + endDate;
                }
                if (manageOrderForm.getYearEnd().length() > 0) {
                    endDate = manageOrderForm.getYearEnd() + "-" + endDate;
                } else {
                    endDate = year + "-" + endDate;
                }
            }
            if (beginDate.length() > 7 && endDate.length() > 7) {
                hql = hql + " and dates between '" + beginDate + "' and '" +
                      endDate + "'";
            } else if (beginDate.length() > 7) {
                hql = hql + " and dates>='" + beginDate + "'";
            } else if (endDate.length() > 7) {
                hql = hql + " and dates<='" + endDate + "'";
            } else {}
            //判斷是否選擇發(fā)貨情況
            if (!manageOrderForm.getConsignment().equals("all")) {
                hql = hql + " and consignment='" +
                      manageOrderForm.getConsignment() + "'";
            }
            List orders = hn.query(hql);
            session.setAttribute("orders", orders);
            forward = "manage_order";
        }

        //刪除定單
        if (parameter.equals("deleteOrder")) {
            String orderId = request.getParameter("orderId");
            String hql = "from OrderInfo where id='" + orderId + "'";
            hn.delete(hql);
            hql = "from OrderInfo where consignment='new'";
            List orders = hn.query(hql);
            session.setAttribute("orders", orders);
            forward = "manage_index";
        }

        //接受定單
        if (parameter.equals("acceptOrder")) {
            String orderId = request.getParameter("orderId");
            String hql = "from OrderInfo where id='" + orderId + "'";
            OrderInfo orderInfo = (OrderInfo) hn.queryOne(hql);
            orderInfo.setConsignment("yes");
            hn.update(orderInfo);
            hql = "from OrderInfo where consignment='new'";
            List orders = hn.query(hql);
            session.setAttribute("orders", orders);
            forward = "manage_index";
        }

        return mapping.findForward(forward);
    }
}