package com.shopping.action;

import java.io.*;
import java.util.*;

import javax.servlet.http.*;

import com.comm.*;
import com.comm.upload.*;
import com.comm.util.*;
import com.comm.vo.*;
import com.shopping.business.*;
import org.apache.struts.action.*;

public class ManageAction extends BaseAction {

    //訂單
    public ActionForward toOrder(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) throws
            Exception {
        //設置查詢條件
        GenericVO gvo = new GenericVO();
        ListVO lvo = new ListVO();
        gvo = AppUtil.convertParameters(request, gvo); //將request 中的參數設置到cvo\uFFFD?
        lvo.setItemsPerPage(30);
        lvo = AppUtil.processListVO(lvo, request); //設置ListVO
        gvo.setListVO(lvo);

        //查詢數據
        lvo = new GoodsMgr().searchOrder(gvo);

        gvo.setListVO(lvo);

        //設置頁面數據
        request.setAttribute("bean", gvo);
        return mapping.findForward("toOrder");
    }

    public ActionForward toOrderDetail(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {

        //獲得訂單詳細信息
        GenericVO ovo = new GoodsMgr().getOrderDetail(BaseUtil.toInt(request.
                getParameter("order_id")));
        //獲取訂購商品
        Vector ogv = new GoodsMgr().getGoodsByOrderNo(ovo.getItemStr("NO"));
        ovo.add("GOODS", ogv);
        //獲取收貨地址信息
        GenericVO addr = new GoodsMgr().getAddressDetail(BaseUtil.toInt(ovo.
                getItem(
                        "ADDRESS_ID")));
        ovo.add("ADDR", addr);
        //取得付款方式
        GenericVO pvo1 = new GoodsMgr().getPayMethodDetail(BaseUtil.toInt(ovo.
                getItem("PAYMETHOD_ID")));
        GenericVO pvo2 = new GoodsMgr().getPostMethodDetail(BaseUtil.toInt(
                ovo.getItem("POSTMETHOD_ID")));
        ovo.add("PAYMETHOD", pvo1);
        ovo.add("POSTMETHOD", pvo2);

        //清除購物車信??
        request.getSession().removeAttribute("CART");

        request.setAttribute("bean", ovo);
        return mapping.findForward("toOrderDetail");
    }

    public ActionForward toOrderStatus(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {
        Vector r = new UserMgr().getOrderStatusByOrderNo(request.getParameter(
                "orderno"));

        request.setAttribute("ORDERSTATUS", r);
        return mapping.findForward("toOrderStatus");
    }

    public ActionForward doOrderStatusChange(ActionMapping mapping,
                                             ActionForm form,
                                             HttpServletRequest request,
                                             HttpServletResponse response) throws
            Exception {
        //記錄訂單狀???
        GenericVO tvo = new GenericVO();
        tvo.add("ORDERNO", request.getParameter("orderno"));
        tvo.add("STATUS", request.getParameter("status"));
        tvo.add("STATUSNAME",
                AppUtil.getOrderStatusName(BaseUtil.toInt(request.
                getParameter("status"))));
        tvo.add("DESCRIPTION",
                AppUtil.getOrderStatusDescription(BaseUtil.toInt(request.
                getParameter("status"))));
        new UserMgr().addOrderStatus(tvo);

        //更改orders表status的狀??
        new GoodsMgr().updateOrder(request.getParameter("orderno"), "status",
                                   BaseUtil.toInteger(request.getParameter(
                                           "status")));

        return mapping.findForward("doOrderStatusChange");
    }

    public ActionForward toOrderStatusAdd(ActionMapping mapping,
                                          ActionForm form,
                                          HttpServletRequest request,
                                          HttpServletResponse response) throws
            Exception {
        return mapping.findForward("toOrderStatusAdd");
    }

    public ActionForward doOrderStatusAdd(ActionMapping mapping,
                                          ActionForm form,
                                          HttpServletRequest request,
                                          HttpServletResponse response) throws
            Exception {
        return mapping.findForward("doOrderStatusAdd");
    }

    //商品
    public ActionForward toGoodsManage(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {
        //設置查詢條件
        GenericVO gvo = new GenericVO();
        ListVO lvo = new ListVO();
        gvo = AppUtil.convertParameters(request, gvo); //將request 中的參數設置到cvo\uFFFD?
        lvo.setItemsPerPage(30);
        lvo = AppUtil.processListVO(lvo, request); //設置ListVO
        gvo.setListVO(lvo);

        //查詢數據
        lvo = new GoodsMgr().searchGoods(gvo);

        gvo.setListVO(lvo);

        //設置頁面數據
        request.setAttribute("bean", gvo);
        return mapping.findForward("toGoodsManage");
    }

    public ActionForward toGoodsAdd(ActionMapping mapping, ActionForm form,
                                    HttpServletRequest request,
                                    HttpServletResponse response) throws
            Exception {
        return mapping.findForward("toGoodsAdd");
    }

    public ActionForward toGoodsEditor(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {
        //得到??有品??
        Vector bv = new GoodsMgr().getBrand();
        //得到??級分??
        Vector gtv = new GoodsMgr().getTopGoodsType();

        //得到要修改的商品信息
        if (request.getParameter("goods_id") != null) {
            GenericVO gvo = new GoodsMgr().getGoodsDetail(BaseUtil.toInt(
                    request.getParameter("goods_id")));
            request.setAttribute("BV", bv);
            request.setAttribute("GTV", gtv);
            request.setAttribute("bean", gvo);
            return mapping.findForward("toGoodsEditor2");
        }

        request.setAttribute("BV", bv);
        request.setAttribute("GTV", gtv);
        return mapping.findForward("toGoodsEditor");
    }

    public ActionForward getGoodsBrandLogo2(ActionMapping mapping,
                                            ActionForm form,
                                            HttpServletRequest request,
                                            HttpServletResponse response) throws
            Exception {
        if (!request.getParameter("brand_id").equalsIgnoreCase("")) {
            GenericVO bvo = new GoodsMgr().getBrandDetail(BaseUtil.toInt(
                    request.getParameter("brand_id")));
            request.setAttribute("LOGO2", bvo.getItem("LOGO2"));
        } else {
            request.setAttribute("LOGO2", "");
        }
        return mapping.findForward("getGoodsBrandLogo2");
    }

    public ActionForward getGoodsTypeByPid(ActionMapping mapping,
                                           ActionForm form,
                                           HttpServletRequest request,
                                           HttpServletResponse response) throws
            Exception {
        Vector r = new GoodsMgr().getGoodsTypeByPid(BaseUtil.toInt(request.
                getParameter("goodstype_id")));

        request.setAttribute("RESULT", r);
        return mapping.findForward("getGoodsTypeByPid");
    }

    public ActionForward doGoodsAdd(ActionMapping mapping, ActionForm form,
                                    HttpServletRequest request,
                                    HttpServletResponse response) throws
            Exception {
        try {
            //上傳圖片
            // 新建??個SmartUpload對象
            SmartUpload su = new SmartUpload();
            // 上傳初始??
            su.initialize(request.getSession().getServletContext(),
                          (HttpServletRequest) request,
                          (HttpServletResponse) response);
            // 設定上傳限制
            // 1.限制每個上傳文件的最大長度???
            su.setMaxFileSize(10000000);
            // 2.限制總上傳數據的長度??
            // su.setTotalMaxFileSize(20000);
            // 3.設定允許上傳的文件（通過擴展名限制）,僅允許doc,txt文件??
            su.setAllowedFilesList("jpg,gif,JPG,GIF");
            // 4.設定禁止上傳的文件（通過擴展名限制）,禁止上傳帶有exe,bat,jsp, htm, html擴展名的文件和沒有擴展名的文?? ??
            // su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
            // 上傳文件
            su.upload();
            // 將上傳文件全部保存到指定目錄
            su.save("/images/goodsphotoes");
            // 逐一提取上傳文件信息，同時可保存文件??
            for (int i = 0; i < su.getFiles().getCount(); i++) {
                SmartFile file = su.getFiles().getFile(i);
                // 若文件不存在則繼??
                if (file.isMissing()) {
                    continue;
                }
                //得到文件??

                String fileName = su.getFileNames()[i];
                //生成縮小圖片
                ImgUtil iutil = new ImgUtil();
                String tfileName = fileName.substring(0, fileName.indexOf(".")) +
                                   "_s." + file.getFileExt();
                iutil.reduce(getServlet().getServletContext().getRealPath("/") +
                             fileName,
                             getServlet().getServletContext().getRealPath("/") +
                             tfileName, 125, 125);

                SmartRequest sr = su.getRequest();
                String name = sr.getParameter("name");
                String brandId = sr.getParameter("brand_id");
                String goodsTypeId = sr.getParameter("goodstype_id");
                String goodsTypeId2 = sr.getParameter("goodstype_id2");
                String photo = fileName;
                String price1 = sr.getParameter("price1");
                String price2 = sr.getParameter("price2");
                String dot = sr.getParameter("dot");
                String weight = sr.getParameter("weight");
                String kucun = sr.getParameter("kucun");
                String description = sr.getParameter("description");

                GenericVO gvo = new GenericVO();
                gvo.add("NAME", name);
                gvo.add("BRAND_ID", brandId);
                gvo.add("GOODSTYPE_ID", goodsTypeId);
                gvo.add("GOODSTYPE_ID2", goodsTypeId2);
                gvo.add("PHOTO", photo);
                gvo.add("SPHOTO", tfileName);
                gvo.add("PRICE1", price1);
                gvo.add("PRICE2", price2);
                gvo.add("DOT", dot);
                gvo.add("WEIGHT", weight);
                gvo.add("KUCUN", kucun);
                gvo.add("DESCRIPTION", description);
                int goodsId = new GoodsMgr().addGoods(gvo);
                request.setAttribute("GOODS_ID", "" + goodsId);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
            throw new AppException(ex);
        }
        return mapping.findForward("doGoodsAdd");
    }

    public ActionForward doGoodsDelete(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {
        new GoodsMgr().deleteGoods(BaseUtil.toInt(request.getParameter(
                "goods_id")));

        request.setAttribute("GOODS_ID", request.getParameter("goods_id"));
        return mapping.findForward("doGoodsDelete");
    }

    public ActionForward toGoodsDetail(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) throws
            Exception {
        int goodsId = BaseUtil.toInt(request.getParameter("goods_id"));