package mrgf.action;

import java.util.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import mrgf.other.*;
import mrgf.form.ManageMerchandiseForm;
import mrgf.hibernate.*;

public class ManageMerchandiseAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
        ManageMerchandiseForm merchandiseForm = (ManageMerchandiseForm) form;
        String parameter = mapping.getParameter();
        String forward = "";
        HttpSession session = request.getSession();
        Hibernate hn = new Hibernate();
        //進(jìn)入商品管理
        if (parameter.equals("manageMerchandise")) {
            forward = "manage_merchandise";
        }
        //添加新商品
        if (parameter.equals("manageMerchandiseAdd")) {
            forward = "manage_merchandise_add";
        }
        //由商品主類返回商品子類
        if (parameter.equals("returnSonSorts")) {
            String sid = request.getParameter("fatherSort");
            int id = Integer.parseInt(sid);
            String hql = "from MerchandiseSort where id=" + id;
            List fatherSorts = (List) hn.query(hql);
            Set sonSorts = ((MerchandiseSort) fatherSorts.get(0)).getSonSorts();
            request.setAttribute("sonSorts", sonSorts);
            hql = "from MerchandiseSort where photo<>'0' and id<>" + id;
            List otherFatherSorts = hn.query(hql);
            for (int i = 0; i < otherFatherSorts.size(); i++) {
                fatherSorts.add(otherFatherSorts.get(i));
            }
            request.setAttribute("fatherSorts", fatherSorts);
            String requestPage = request.getParameter("requestPage");
            if (requestPage.equals("selectMerchandise")) {
                forward = "manage_merchandise";
            } else {
                forward = "manage_merchandise_add";
            }
        }
        //提交添加新商品
        if (parameter.equals("addMerchandise")) {
            //上傳商品圖片
            //取上傳文件欲放置的位置
            String dir = servlet.getServletContext().getRealPath("/image/MerchandisePhoto");
            SpecialMethod sm = new SpecialMethod();
            try {
                //通過該方法上傳圖片并將圖片名稱及大小存放到form中
                sm.upload(dir, merchandiseForm);
            } catch (Exception ex) {
                System.out.println("------在上傳圖片時(shí)拋出異常，內(nèi)容如下：");
                ex.printStackTrace();
            }
            //保存商品信息
            MerchandiseInfo info = new MerchandiseInfo();
            info.setPhoto(sm.toChinese(merchandiseForm.getMerchandisePhotoName()));
            info.setName(sm.toChinese(merchandiseForm.getMerchandiseName()));
            info.setSortId(merchandiseForm.getMerchandiseSonSort());
            info.setType(merchandiseForm.getMerchandiseType());
            info.setPrice(merchandiseForm.getMerchandisePrice());
            info.setIntroduce(sm.toChinese(merchandiseForm.getMerchandiseIntroduce()));
            info.setRemark("<NULL>");
            if (merchandiseForm.getMerchandiseRemark().length() > 0) {
                info.setRemark(sm.toChinese(merchandiseForm.getMerchandiseRemark()));
            }
            info.setHead("n");
            hn.save(info);
            forward = "manage_merchandise_add";
        }
        //查詢現(xiàn)有商品
        if (parameter.equals("selectMerchandise")) {
            String hql = "from MerchandiseInfo where id>0";
            if (merchandiseForm.getMerchandiseName().length() > 0) {
                hql = hql + " and name like '%" +
                      merchandiseForm.getMerchandiseName() + "%'";
            } else {
                hql = hql + " and sortId=" +
                      merchandiseForm.getMerchandiseSonSort();
            }
            session.setAttribute("MerchandiseSelectHql", hql);
            List merchandises = hn.query(hql);
            request.setAttribute("merchandises", merchandises);
            forward = "manage_merchandise";
        }
        //刪除指定商品
        if (parameter.equals("deleteMerchandise")) {
            String merchandiseId = request.getParameter("merchandiseId");
            int id = Integer.parseInt(merchandiseId);
            String hql = "from MerchandiseInfo where id=" + id;
            hn.delete(hql);
            hql = (String) session.getAttribute("MerchandiseSelectHql");
            List merchandises = hn.query(hql);
            request.setAttribute("merchandises", merchandises);
            forward = "manage_merchandise";
        }
        //查看現(xiàn)有商品詳細(xì)信息
        if (parameter.equals("seeMerchandiseInfo")) {
            String merchandiseId = request.getParameter("merchandiseId");
            int id = Integer.parseInt(merchandiseId);
            String hql = "from MerchandiseInfo where id=" + id;
            MerchandiseInfo merchandiseInfo = (MerchandiseInfo) hn.queryOne(hql);
            request.setAttribute("merchandiseInfo", merchandiseInfo);
            forward = "manage_merchandise_info";
        }
        //查看現(xiàn)有商品詳細(xì)信息返回
        if (parameter.equals("seeMerchandiseInfoReturn")) {
            String hql = (String) session.getAttribute("MerchandiseSelectHql");
            List merchandises = hn.query(hql);
            request.setAttribute("merchandises", merchandises);
            forward = "manage_merchandise";
        }
        //提交修改的現(xiàn)有商品詳細(xì)信息
        if (parameter.equals("updateMerchandiseInfo")) {
            String merchandiseId = request.getParameter("merchandiseId");
            int id = Integer.parseInt(merchandiseId);
            String hql = "from MerchandiseInfo where id=" + id;
            MerchandiseInfo info = (MerchandiseInfo) hn.queryOne(hql);
            info.setName(merchandiseForm.getMerchandiseName());
            info.setSortId(merchandiseForm.getMerchandiseSonSort());
            info.setType(merchandiseForm.getMerchandiseType());
            info.setPrice(merchandiseForm.getMerchandisePrice());
            if (!merchandiseForm.getInHead().equals(merchandiseForm.getInHeadOfOld())) {
                if (merchandiseForm.getInHead().equals("y")) { // 改為放于首頁
                    hql = "select count(*)from MerchandiseInfo where head='y'";
                    int num = hn.count(hql);
                    System.out.println("----------------- num="+num);
                    if (num < 5) {
                        info.setHead("y");
                        request.setAttribute("setHeadInfo", "放于首頁成功，首頁未放滿，請(qǐng)繼續(xù)添加其他商品！！！");
                    } else if (num == 5) {
                        info.setHead("y");
                        request.setAttribute("setHeadInfo", "放于首頁成功，首頁已放滿！！！");
                    } else {
                        request.setAttribute("setHeadInfo", "放于首頁失敗，首頁已放滿，請(qǐng)先刪除其他商品！！！");
                    }
                } else { // 改為不放于首頁
                    info.setHead("n");
                    request.setAttribute("setHeadInfo", "請(qǐng)?jiān)傧蚴醉撎砑右患唐罚。。?quot;);
                }
            }
            info.setIntroduce(merchandiseForm.getMerchandiseIntroduce());
            info.setRemark("<NULL>");
            if (merchandiseForm.getMerchandiseRemark().length() > 0) {
                info.setRemark(merchandiseForm.getMerchandiseRemark());
            }
            hn.update(info);
            request.setAttribute("merchandiseInfo", info);
            forward = "manage_merchandise_info";
        }
        return mapping.findForward(forward);
    }
}