package cn.ksource.web.controller.business.pages.cfg;

import java.io.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.ksource.core.util.*;
import cn.ksource.core.web.SysInfoMsg;
import cn.ksource.web.service.sl.SlaProjectService;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.CellRangeAddressList;
import org.apache.poi.hssf.util.HSSFColor;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.commons.CommonsMultipartFile;
import org.springframework.web.servlet.ModelAndView;

import cn.ksource.beans.CMDB_CI_BASE;
import cn.ksource.beans.FlowRecord;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.web.SysInfo;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.facade.cfg.CfgFacade;
import cn.ksource.web.facade.cfgcate.CfgcateFacade;
import cn.ksource.web.facade.customermanage.CustomerManageFacade;

@Controller
@RequestMapping("/business/pages/cfg")
@SuppressWarnings({"rawtypes", "unchecked"})
public class CfgController {
    @Resource
    private CfgFacade cfgFacade;
    @Resource
    private CfgcateFacade cfgcateFacade;
    @Resource
    private CustomerManageFacade customerFacade;



    /**
     * 配置管理
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgmanageList.html")
    public String cfgmanageList(Model model, HttpServletRequest request) {
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgmanageList";
    }

    @RequestMapping("cfgmanageData.html")
    public String cfgmanageData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgmanageData";
    }

    @RequestMapping("cfgmanageCount.html")
    public void cfgmanageCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        params.put("wc_flag", "1");
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }

    @RequestMapping("updateStatus.html")
    public void updateStatus(HttpServletRequest request, HttpServletResponse response) {
        String id = request.getParameter("id");
        String state = request.getParameter("state");
        CMDB_CI_BASE base = new CMDB_CI_BASE(id).getInstanceById();
        base.setState(ConvertUtil.obj2Integer(state)).update();
        WebUtil.write(response, "1");
    }


    /**
     * 配置管理
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgmainList.html")
    public String cfgmainList(Model model, HttpServletRequest request) {
        //客户列表
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgmainList";
    }

    @RequestMapping("cfgmainData.html")
    public String cfgmainData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("createId", WebUtil.getLoginedUserId(request));
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgmainData";
    }

    @RequestMapping("cfgmainCount.html")
    public void cfgmainCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("createId", WebUtil.getLoginedUserId(request));
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }

    /**
     * 配置审核
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgshList.html")
    public String cfgshList(Model model, HttpServletRequest request) {
        //客户列表
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgshList";
    }

    @RequestMapping("cfgshData.html")
    public String cfgshData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("dealId", WebUtil.getUserId(request));
        if (params.get("flag").equals("1")) {
            params.put("fstate", Constants.CFG_FLOW_DSH.toString());
        } else if(params.get("flag").equals("2")){
            params.put("templateKey", Constants.CFG_FLOW_DSH.toString());
        }
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgshData";
    }

    @RequestMapping("cfgshCount.html")
    public void cfgshCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("dealId", WebUtil.getUserId(request));
        if (params.get("flag").equals("1")) {
            params.put("fstate", Constants.CFG_FLOW_DSH.toString());
        } else {
            params.put("templateKey", Constants.CFG_FLOW_DSH.toString());
        }
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }

    /**
     * 编辑配置
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping(value = "editCfg.html", method = RequestMethod.GET)
    public String editCfg(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = new HashMap();
        Map params = new HashMap<String, String>();
        params.put("lv", "1");
        List lv1List = cfgcateFacade.getCfgcateList(params);
        params.clear();
        model.addAttribute("lv1List", lv1List);
        if (StringUtil.isNotBlank(id)) {
            info = cfgFacade.getCfgById(id);
            params.put("pid", info.get("lv1_id"));
            List lv2List = cfgcateFacade.getCfgcateList(params);
            model.addAttribute("lv2List", lv2List);
            params.put("pid", info.get("lv2_id"));
            List lv3List = cfgcateFacade.getCfgcateList(params);
            model.addAttribute("lv3List", lv3List);
            List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
            model.addAttribute("groupProps", groupProps);
            List mftList = cfgFacade.getMftList(info.get("cus_id").toString(), "1");
            model.addAttribute("mftList", mftList);
            List igtList = cfgFacade.getMftList(info.get("cus_id").toString(), "2");
            model.addAttribute("igtList", igtList);
        }
        model.addAttribute("info", info);
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/editCfg";
    }

    @RequestMapping(value = "editCfg.html", method = RequestMethod.POST)
    public ModelAndView doEditCfg(HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        Map user = WebUtil.getLoginUser(request).getLoginUser();
        params.put("create_id", user.get("ID").toString());
        params.put("create_name", user.get("ZSXM").toString());
        cfgFacade.saveCfg(params, request);
        String js = "window.top.query();"
                + "window.top.hideDialog('0');";
        return WebUtil.sysInfoPage(request, "操作成功！",
                js,
                SysInfo.Success, "");
    }

    /**
     * 获取配置分类
     *
     * @param request
     * @param response
     * @author chenlong
     */
    @RequestMapping(value = "getCfgcate.html", method = RequestMethod.POST)
    public void getCfgcate(HttpServletRequest request, HttpServletResponse response) {
        Map params = ParamsMapUtil.getParameterMap(request);
        List list = cfgcateFacade.getCfgcateList(params);
        WebUtil.write(response, JsonUtil.list2Json(list));
    }

    /**
     * 配置模板
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping(value = "cfgTemplate.html")
    public String cfgTemplate(Model model, HttpServletRequest request) {
        String linkId = request.getParameter("linkId");
        List groupProps = cfgcateFacade.getPropTemplate(linkId, null);
        model.addAttribute("info", new HashMap());
        model.addAttribute("groupProps", groupProps);
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgTemplate";
    }

    /**
     * 配置详情
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgDetail.html")
    public String cfgDetail(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgById(id);
        List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
        model.addAttribute("groupProps", groupProps);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgDetail";
    }

    /**
     * 跳转到过保查询
     *
     * @param model
     * @param request
     */
    @RequestMapping("cfgGbcxList.html")
    public String cfgGbcxList(Model model, HttpServletRequest request) {
        List<Map> gbState = new ArrayList<Map>();
        for (Integer key : Constants.CFG_GB_STATE_MAP.keySet()) {
            Map map = new HashMap();
            map.put("DATAKEY", key);
            map.put("DATAVALUE", Constants.getCFG_GB_STATE(key));
            if(key!=5) {
                gbState.add(map);
            }
        }
        model.addAttribute("gbState", gbState);
        //获取客户列表
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgGbcxList";
    }

    /**
     * 过保查询数据查询
     *
     * @param pageInfo
     * @param model
     * @param request
     * @return
     */
    @RequestMapping("cfgGbcxData.html")
    public String cfgGbcxData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgGbcxData";
    }

    /**
     * 过保查询数据总数
     *
     * @param model
     * @param request
     * @param response
     */
    @RequestMapping("cfgGbcxCount.html")
    public void cfgGbcxCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }

    /**
     * 提交审核
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping(value = "comitSh.html", method = RequestMethod.GET)
    public String comitSh(Model model, HttpServletRequest request) {
        String cfgId = request.getParameter("cfgId");
        Map info = cfgFacade.getCfgById(cfgId);
        List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
        model.addAttribute("groupProps", groupProps);
        model.addAttribute("info", info);
        return "/business/pages/cfg/comitSh";
    }

    @RequestMapping(value = "comitSh.html", method = RequestMethod.POST)
    public ModelAndView doComitSh(FlowRecord flowRecord, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        flowRecord.setDealId(WebUtil.getUserId(request));
        flowRecord.setDealName(WebUtil.getUserName(request));
        flowRecord.setTemplateKey(Constants.CFG_FLOW_XZ);
        if (params.get("isNext").equals("1")) {
            params.put("state", Constants.CFG_FLOW_DSH.toString());
        } else {
            params.put("state", Constants.CFG_FLOW_WC.toString());
        }
        cfgFacade.doToNext(params, flowRecord);
        String js = "window.top.query();"
                + "window.top.hideDialog('do');";
        return WebUtil.sysInfoPage(request, "操作成功！",
                js,
                SysInfo.Success, "");
    }


    /**
     * 提交审核
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping(value = "cfgShTab.html", method = RequestMethod.GET)
    public String cfgShTab(Model model, HttpServletRequest request) {
        return "/business/pages/cfg/cfgShTab";
    }

    @RequestMapping(value = "cfgSh.html", method = RequestMethod.GET)
    public String cfgSh(Model model, HttpServletRequest request) {
        String cfgId = request.getParameter("cfgId");
        Map info = cfgFacade.getCfgById(cfgId);
        List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
        model.addAttribute("groupProps", groupProps);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgSh";
    }

    @RequestMapping(value = "cfgSh.html", method = RequestMethod.POST)
    public ModelAndView doCfgSh(FlowRecord flowRecord, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        flowRecord.setDealId(WebUtil.getUserId(request));
        flowRecord.setDealName(WebUtil.getUserName(request));
        flowRecord.setTemplateKey(Constants.CFG_FLOW_DSH);
        if (params.get("flag").equals("1")) {
            if (params.get("isNext").equals("1")) {
                params.put("state", Constants.CFG_FLOW_DSH.toString());
            } else {
                params.put("state", Constants.CFG_FLOW_WC.toString());
            }
        } else {
            params.put("state", Constants.CFG_FLOW_SB.toString());
        }
        cfgFacade.doToNext(params, flowRecord);
        String js = "window.top.query();"
                + "window.top.hideDialog('do');";
        return WebUtil.sysInfoPage(request, "操作成功！",
                js,
                SysInfo.Success, "");
    }


    @RequestMapping(value = "cfgDetailTab.html")
    public String cfgDetailTab(Model model, HttpServletRequest request) {
        return "/business/pages/cfg/cfgDetailTab";
    }

    /**
     * 配置管理
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgcxList.html")
    public String cfgcxList(Model model, HttpServletRequest request) {
        //获取客户列表
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgcxList";
    }

    @RequestMapping("cfgcxData.html")
    public String cfgcxData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        //查询状态是正常的（0未启用 1正常；2废弃；3维护中； 4备用；）
        params.put("state","1");
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgcxData";
    }

    @RequestMapping("cfgcxCount.html")
    public void cfgcxCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        params.put("state","1");
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }

    @RequestMapping("cfgInfoIndex.html")
    public String cfgInfoIndex(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgByIdTwo(id,request);
        List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
        model.addAttribute("groupProps", groupProps);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgInfoIndex";
    }

    /**
     * 配置关联工单
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgLinkOrder.html")
    public String cfgLinkOrder(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgById(id);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgLinkOrder";
    }

    @RequestMapping("cfgLinkOrderData.html")
    public String cfgLinkOrderData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgLinkOrderData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgLinkOrderData";
    }

    @RequestMapping("cfgLinkOrderCount.html")
    public void cfgLinkOrderCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgLinkOrderCount(params).toString());
    }


    /**
     * 配置关联工单
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgLinkKnow.html")
    public String cfgLinkKnow(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgById(id);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgLinkKnow";
    }

    @RequestMapping("cfgLinkKnowData.html")
    public String cfgLinkKnowData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgLinkKnowData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgLinkKnowData";
    }

    @RequestMapping("cfgLinkKnowCount.html")
    public void cfgLinkKnowCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgLinkKnowCount(params).toString());
    }

    /**
     * 配置文档
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgDoc.html")
    public String cfgDoc(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgById(id);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgDoc";
    }

    @RequestMapping("cfgDocData.html")
    public String cfgDocData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgDocData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgDocData";
    }

    @RequestMapping("cfgDocCount.html")
    public void cfgDocCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgDocCount(params).toString());
    }

    /**
     * 日常巡检指标
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgDailyItem.html")
    public String cfgDailyItem(Model model, HttpServletRequest request) {
        model.addAttribute("type",1);
        return "/business/pages/cfg/cfgDailyItem";
    }

    @RequestMapping("cfgDailyItemData.html")
    public String cfgDailyItemData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgDailyItemData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgDailyItemData";
    }

    @RequestMapping("cfgDailyItemCount.html")
    public void cfgDailyItemCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgDailyItemCount(params).toString());
    }


    /**
     * 例行维护指标
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgRemindItem.html")
    public String cfgRemindItem(Model model, HttpServletRequest request) {
        model.addAttribute("type",2);
        return "/business/pages/cfg/cfgRemindItem";
    }

    @RequestMapping("cfgRemindItemData.html")
    public String cfgRemindItemData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgRemindItemData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgRemindItemData";
    }

    @RequestMapping("cfgRemindItemCount.html")
    public void cfgRemindItemCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgRemindItemCount(params).toString());
    }

    /**
     * 健康检查
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgHealthItem.html")
    public String cfgHealthItem(Model model, HttpServletRequest request) {
        model.addAttribute("type",3);
        return "/business/pages/cfg/cfgHealthItem";
    }

    @RequestMapping("cfgHealthItemData.html")
    public String cfgHealthItemData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgHealthItemData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgHealthItemData";
    }

    @RequestMapping("cfgHealthItemCount.html")
    public void cfgHealthItemCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgHealthItemCount(params).toString());
    }

    /**
     * 配置关系
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgRelationList.html")
    public String cfgRelationList(Model model, HttpServletRequest request) {
        return "/business/pages/cfg/cfgRelationList";
    }

    @RequestMapping("cfgRelationData.html")
    public String cfgRelationData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgRelationData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgRelationData";
    }

    @RequestMapping("cfgRelationCount.html")
    public void cfgRelationCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgRelationCount(params).toString());
    }

    @RequestMapping("relationci.html")
    public String relationci(Model model, HttpServletRequest request) {
        Map<Integer, String> links = Constants.CFG_RELATION_Map;
        List<Map> list = new ArrayList<Map>();
        for (int key : links.keySet()) {
            Map map = new HashMap();
            map.put("id", key);
            map.put("text", Constants.CFG_RELATION_Map.get(key));
            list.add(map);
        }
        model.addAttribute("links", list);
        return "/business/pages/cfg/relationci";
    }

    /**
     * 添加配置关联关系列表数据
     */
    @RequestMapping("selectrelationLink.html")
    public ModelAndView selectrelationLink(HttpServletRequest request) {
        ModelAndView modelAndView = new ModelAndView("/business/pages/cfg/selectrelationLink");
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        List<Map> relation = cfgFacade.queryRelationLink(params);
        modelAndView.addObject("devices", relation);
        return modelAndView;
    }

    /**
     * 保存关联信息
     */
    @RequestMapping(value = "saveRelation.html", method = RequestMethod.POST)
    public void saveRelation(HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("userId", WebUtil.getUserId(request));
        params.put("userName", WebUtil.getUserName(request));
        String result = cfgFacade.saveRelation(params);
        WebUtil.write(response, result);
    }

    /**
     * 跳转到修改配置关系页面
     */
    @RequestMapping(value = "updateRelation.html", method = RequestMethod.GET)
    public ModelAndView updateRelation(HttpServletRequest request) {
        ModelAndView modelAndView = new ModelAndView("/business/pages/cfg/updateRelation");
        String id = request.getParameter("id");
        Map relation = cfgFacade.getRelationById(id);
        modelAndView.addObject("relationing", relation);
        Map<Integer, String> links = Constants.CFG_RELATION_Map;
        List<Map> list = new ArrayList<Map>();
        for (int key : links.keySet()) {
            Map map = new HashMap();
            map.put("id", key);
            map.put("text", Constants.CFG_RELATION_Map.get(key));
            list.add(map);
        }
        modelAndView.addObject("links", list);
        return modelAndView;
    }

    /**
     * 保存关联信息
     */
    @RequestMapping(value = "updateRelation.html", method = RequestMethod.POST)
    public void doUpdateRelation(HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        String result = cfgFacade.updateRelation(params);
        WebUtil.write(response, result);
    }

    /**
     * 删除关联关系
     *
     * @param request
     * @param response
     * @author chenlong
     */
    @RequestMapping("delrelation.html")
    public void delrelation(HttpServletRequest request, HttpServletResponse response) {
        String id = request.getParameter("id");
        cfgFacade.delRelationById(id);
        WebUtil.write(response, "1");
    }


    /**
     * 健康检查
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping("cfgLink.html")
    public String cfgRelation(Model model, HttpServletRequest request) {
        String id = request.getParameter("id");
        Map info = cfgFacade.getCfgById(id);
        model.addAttribute("info", info);
        return "/business/pages/cfg/cfgLink";
    }

    @RequestMapping("cfgLinkData.html")
    public String cfgLinkData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        pageInfo = cfgFacade.getCfgLinkData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgLinkData";
    }

    @RequestMapping("cfgLinkCount.html")
    public void cfgLinkCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        WebUtil.write(response, cfgFacade.getCfgLinkCount(params).toString());
    }

    @RequestMapping("getMftList.html")
    public void getMftList(HttpServletRequest request, HttpServletResponse response) {
        String cusId = request.getParameter("cusId");
        String type = request.getParameter("type");
        List list = cfgFacade.getMftList(cusId, type);
        WebUtil.write(response, JsonUtil.list2Json(list));
    }


    /**
     * 打印二维码
     */
    @RequestMapping("printCode.html")
    public ModelAndView printCode(HttpServletRequest request) {
        ModelAndView modelAndView = new ModelAndView("/business/pages/cfg/printCode");
        String ciId = request.getParameter("ciId");
        Map info = cfgFacade.getCfgById(ciId);
        modelAndView.addObject("detail", info);
        String url = Constants.QRCODE_URL + ciId;
        modelAndView.addObject("QRKEY", url);
        return modelAndView;
    }

    /**
     * 维保方案制定
     *
     * @param model
     * @param request
     * @return
     * @author chenlong
     */
    @RequestMapping(value = "editItem.html", method = RequestMethod.GET)
    public String editItem(Model model, HttpServletRequest request) {
        Map<String, String> param = ParamsMapUtil.getParameterMap(request);
        String id = param.get("id");
        Map ci = cfgFacade.getCfgById(id);
        List<Map> rcList = cfgFacade.getRcItemList(param);
        List<Map> lxList = cfgFacade.getRemindItemList(param);
        List<Map> jkList = cfgFacade.getHealthItemList(param);
        model.addAttribute("rcList", rcList)
                .addAttribute("lxList", lxList)
                .addAttribute("jkList", jkList)
                .addAttribute("ci", ci);
        return "/business/pages/cfg/editItem";
    }

    @RequestMapping(value = "editItem.html", method = RequestMethod.POST)
    public ModelAndView doEditItem(Model model, HttpServletRequest request) {
        Map<String, String> param = ParamsMapUtil.getParameterMap(request);
        cfgFacade.saveItem(param);
        String js = "window.top.hideDialog('0');";
        return WebUtil.sysInfoPage(request, "操作成功！",
                js,
                SysInfo.Success, "");
    }

    @RequestMapping("uploadBatch.html")
    public ModelAndView uploadBatch() {
        ModelAndView mv = new ModelAndView("/business/pages/cfg/uploadBatch");
        return mv;
    }

    @RequestMapping("doUploadBatchCiInfo.html")
    public ModelAndView doUploadBatchCiInfo(@RequestParam(value = "file", required = false) CommonsMultipartFile file, HttpServletRequest request) {
        String flag = cfgFacade.doUploadBatchCiInfo(file, request);
        if (flag == null) {
            return WebUtil.sysInfoPage(request, "操作成功！",
                    "window.top.query();window.top.hideDialog('uploadBatch');",
                    SysInfo.Success, "");
        } else {
            SysInfoMsg msg = new SysInfoMsg();
            msg.setText(flag);
            return WebUtil.sysInfoPage(request, "操作失败！",
                    "window.top.hideDialog('uploadBatch');",
                    SysInfo.Error, "", msg);
        }

    }


    /**
     * 模板下载
     *
     * @param request
     * @param response
     */
    @RequestMapping(value = "downloadExecelTemplate.html")
    public void excelTemplate(HttpServletRequest request,
                              HttpServletResponse response) {
        String name = request.getParameter("full_cate_name");
        String cate = request.getParameter("full_cate_id").split("-")[2];
        //通用属性
        Map props = cfgFacade.queryCommonProps();
        //扩展属性
        List<Map> groupProps = cfgFacade.queryGroupProps(cate);
//        if(groupProps.size()>0){
//        	for(Map map:groupProps){
//        		String gname=ConvertUtil.obj2StrBlank(map.get("GROUP_NAME"));
//        		List<Map> list=(List<Map>)map.get("props1");
//        		if(list.size()>0){
//        			for(Map mapa:list){
//        				String nameTwo=ConvertUtil.obj2StrBlank(mapa.get("COLUMNNAME"));
//        				nameTwo=gname+"+"+nameTwo;
//        				mapa.put("COLUMNNAME", nameTwo);
//        			}
//        		}
//        		map.put("props1", list);
//        	}
//        }
        String basePath = request.getSession().getServletContext()
                .getRealPath("");
        FileInputStream fileIS = null;
        HSSFWorkbook wb = null;
        OutputStream os = null;
        try {
            fileIS = new FileInputStream(basePath + "/upload/template/template.xls");
            wb = new HSSFWorkbook(fileIS);
            HSSFSheet sheet = wb.getSheetAt(0);

            HSSFCellStyle cellStyleRed = wb.createCellStyle();
            HSSFFont fontStyleRed = wb.createFont();
            fontStyleRed.setColor(HSSFColor.RED.index);
            fontStyleRed.setFontHeightInPoints((short) 12);
            cellStyleRed.setFont(fontStyleRed);
            cellStyleRed.setAlignment(HSSFCellStyle.ALIGN_CENTER);
            cellStyleRed.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

            HSSFCellStyle cellStyleBlack = wb.createCellStyle();
            HSSFFont fontStyleBlack = wb.createFont();
            fontStyleBlack.setColor(HSSFColor.BLACK.index);
            fontStyleBlack.setFontHeightInPoints((short) 12);
            cellStyleBlack.setFont(fontStyleBlack);
            cellStyleBlack.setAlignment(HSSFCellStyle.ALIGN_CENTER);
            cellStyleBlack.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

            HSSFRow row1 = sheet.getRow(1);
            List<Map> textareaProp = (List<Map>) props.get("textareaProp");
            if (null == row1) {
                row1 = sheet.createRow(1);
            }
            //从第14列开始
            int index = 14;
            for (int i = 0; i < textareaProp.size(); i++) {
                String value = textareaProp.get(i).get("COLUMNNAME").toString();
                String dataType = textareaProp.get(i).get("DATATYPE").toString();
                String allowNull = textareaProp.get(i).get("allowNull").toString();
                HSSFCell cell = row1.getCell(index);
                if (cell == null) {
                    cell = row1.createCell(index);
                }
                if ("6".equals(dataType)) {
                    String itemsValue = "";
                    List<Map> items = (List<Map>) textareaProp.get(i).get(
                            "items");
                    if (items != null) {
                        for (int j = 0; j < items.size(); j++) {
                            if (j == 0) {
                                itemsValue += "(多选：";
                            }
                            itemsValue += items.get(j).get("ITEMVALUE");
                            if (j < items.size() - 1) {
                                itemsValue += "，";
                            } else {
                                itemsValue += ")";
                            }
                        }
                    }
                    cell.setCellValue(value + itemsValue);
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    index++;
                } else if ("1".equals(dataType)) {
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    String minvalues = "0";
                    String maxvalues = String.valueOf(Integer.MAX_VALUE);
                    if (textareaProp.get(i).get("MINVALUES") != null) {
                        minvalues = textareaProp.get(i).get("MINVALUES").toString();
                    }
                    if (textareaProp.get(i).get("MAXVALUES") != null) {
                        maxvalues = textareaProp.get(i).get("MAXVALUES").toString();
                    }
                    HSSFDataValidation dataValidation = setDataValidationNumber(2, 200, index, index, minvalues, maxvalues);
                    sheet.addValidationData(dataValidation);
                    cell.setCellValue(value + "[" + minvalues + "~" + maxvalues + "]");
                    index++;
                } else {
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    cell.setCellValue(value);
                    index++;
                }

            }
            List<Map> commonProps = (List<Map>) props.get("commonProp");
            for (int i = 0; i < commonProps.size(); i++) {
                String value = commonProps.get(i).get("COLUMNNAME").toString();
                String dataType = commonProps.get(i).get("DATATYPE").toString();
                String allowNull = commonProps.get(i).get("allowNull").toString();
                HSSFCell cell = row1.getCell(index);
                if (cell == null) {
                    cell = row1.createCell(index);
                }
                if ("5".equals(dataType)) {
                    List<Map> list = (List<Map>) commonProps.get(i).get("items");
                    cell.setCellValue(value);
                    if (list != null) {
                        HSSFDataValidation dataValidationSelect = setDataValidationSelect(2, 200, index, index, (List<Map>) commonProps.get(i).get(
                                "items"));
                        sheet.addValidationData(dataValidationSelect);
                    }
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    index++;
                } else if ("1".equals(dataType)) {
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    String minvalues = "0";
                    String maxvalues = String.valueOf(Integer.MAX_VALUE);
                    if (commonProps.get(i).get("MINVALUES") != null) {
                        minvalues = commonProps.get(i).get("MINVALUES").toString();
                    }
                    if (commonProps.get(i).get("MAXVALUES") != null) {
                        maxvalues = commonProps.get(i).get("MAXVALUES").toString();
                    }
                    HSSFDataValidation dataValidation = setDataValidationNumber(2, 200, index, index, minvalues, maxvalues);
                    sheet.addValidationData(dataValidation);
                    cell.setCellValue(value + "[" + minvalues + "~" + maxvalues + "]");
                    index++;
                } else {
                    if ("2".equals(allowNull)) {
                        cell.setCellStyle(cellStyleRed);
                    } else {
                        cell.setCellStyle(cellStyleBlack);
                    }
                    cell.setCellValue(value);
                    index++;
                }

            }
            HSSFCell cellBzsm = row1.getCell(index);
            if (cellBzsm == null) {
                cellBzsm = row1.createCell(index);
            }
            cellBzsm.setCellValue("备注说明");
            cellBzsm.setCellStyle(cellStyleBlack);
            index++;

            for (int i = 0; i < groupProps.size(); i++) {
            	String gname=ConvertUtil.obj2StrBlank(((Map) groupProps.get(i)).get("GROUP_NAME"));
                List<Map> props_1 = (List<Map>) ((Map) groupProps.get(i)).get("props1");//含有多选
                List<Map> props_ = (List<Map>) ((Map) groupProps.get(i)).get("props");//含有单选
                if (props_1 != null) {
                    for (int j = 0; j < props_1.size(); j++) {
                        HSSFCell cell = row1.getCell(index);
                        if (cell == null) {
                            cell = row1.createCell(index);
                        }
                        String dataType = props_1.get(j).get("DATATYPE").toString();
                        String allowNull = props_1.get(j).get("allowNull").toString();
                        String columnName = gname+"+"+props_1.get(j).get("COLUMNNAME").toString();
                        if ("6".equals(dataType)&&props_1.get(j).get("items")!=null) {
                            String itemsValue = "";
                            List<Map> items = (List<Map>) (props_1.get(j).get("items"));
                            for (int k = 0; k < items.size(); k++) {
                                if (k == 0) {
                                    itemsValue += "(多选：";
                                }
                                itemsValue += items.get(k).get("ITEMVALUE");
                                if (k < items.size() - 1) {
                                    itemsValue += "，";
                                } else {
                                    itemsValue += ")";
                                }
                            }
                            cell.setCellValue(columnName + itemsValue);
                            if ("2".equals(allowNull)) {
                                cell.setCellStyle(cellStyleRed);
                            } else {
                                cell.setCellStyle(cellStyleBlack);
                            }
                            index++;
                        } else {
                            cell.setCellValue(columnName);
                            if ("2".equals(allowNull)) {
                                cell.setCellStyle(cellStyleRed);
                            } else {
                                cell.setCellStyle(cellStyleBlack);
                            }
                            index++;
                        }
                    }
                }
                if (props_ != null) {
                    for (int j = 0; j < props_.size(); j++) {
                        HSSFCell cell = row1.getCell(index);
                        if (cell == null) {
                            cell = row1.createCell(index);
                        }
                        String dataType = props_.get(j).get("DATATYPE").toString();
                        String allowNull = props_.get(j).get("allowNull").toString();
                        String columnName =gname+"+"+ props_.get(j).get("COLUMNNAME").toString();
                        if ("5".equals(dataType)) {
                            HSSFDataValidation dataValidation = setDataValidationSelect(2, 200, index, index, (List<Map>) props_.get(j).get(
                                    "items"));
                            sheet.addValidationData(dataValidation);
                            cell.setCellValue(columnName);
                            if ("2".equals(allowNull)) {
                                cell.setCellStyle(cellStyleRed);
                            } else {
                                cell.setCellStyle(cellStyleBlack);
                            }
                            index++;
                        } else if ("1".equals(dataType)) {
                            if ("2".equals(allowNull)) {
                                cell.setCellStyle(cellStyleRed);
                            } else {
                                cell.setCellStyle(cellStyleBlack);
                            }
                            String minvalues = "0";
                            String maxvalues = String.valueOf(Integer.MAX_VALUE);
                            if (props_.get(j).get("MINVALUES") != null&&!ConvertUtil.obj2Str(props_.get(j).get("MINVALUES")).equals("")) {
                                minvalues = props_.get(j).get("MINVALUES").toString();
                            }
                            if (props_.get(j).get("MAXVALUES") != null&&!ConvertUtil.obj2Str(props_.get(j).get("MAXVALUES")).equals("")) {
                                maxvalues = props_.get(j).get("MAXVALUES").toString();
                            }
                            HSSFDataValidation dataValidation = setDataValidationNumber(2, 200, index, index, minvalues, maxvalues);
                            sheet.addValidationData(dataValidation);
                            cell.setCellValue(columnName + "[" + minvalues + "~" + maxvalues + "]");
                            index++;
                        } else {
                            cell.setCellValue(columnName);
                            if ("2".equals(allowNull)) {
                                cell.setCellStyle(cellStyleRed);
                            } else {
                                cell.setCellStyle(cellStyleBlack);
                            }
                            index++;
                        }
                    }
                }
            }

            //第一行为提示信息
            HSSFRow row0 = sheet.getRow(0);
            if (null == row0) {
                row0 = sheet.createRow(0);
            }
            CellRangeAddress hebingCell = new CellRangeAddress(0, 0, 0, index - 1);
            sheet.addMergedRegion(hebingCell);
            HSSFCell cell = row0.getCell(0);
            if (cell == null) {
                cell = row0.createCell(0);
            }
            cell.setCellValue("提示：1.红色字段为必填字段。 2.导入模板中，含有数据验证的，可以手动输入，但是输入的内容必须与数据验证中的数据一致，否则会有‘输入值非法’等提示。 3.多选文本,请用逗号隔开（中英文逗号均可）。 4.日期格式为:yyyyMMdd,例如19990101");
            HSSFCellStyle cellStyleRed1 = wb.createCellStyle();
            HSSFFont fontStyleRed1 = wb.createFont();
            fontStyleRed1.setColor(HSSFColor.RED.index);
            fontStyleRed1.setFontHeightInPoints((short) 12);
            cellStyleRed1.setFont(fontStyleRed1);
            cellStyleRed1.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
            cellStyleRed1.setAlignment(HSSFCellStyle.ALIGN_LEFT);
            cell.setCellStyle(cellStyleRed1);


            int[] col = {};
            List<HSSFDataValidation> dataValidationList = setHSSFDataValidationList(2, 200, col, col, request);
            for (int i = 0; i < dataValidationList.size(); i++) {
                sheet.addValidationData(dataValidationList.get(i));
            }

            for (int i = 0; i < index; i++) {
                sheet.setColumnWidth(i, 25 * 256);
            }

            os = new FileOutputStream(basePath + "/upload/template/配置采集-配置资料模板.xls");
            wb.write(os);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                if (null != fileIS) {
                    fileIS.close();
                }
                if (null != os) {
                    os.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        try {
            DownloadUtil.download(response, new File(basePath + "/upload/template/配置采集-配置资料模板.xls"), name + ".xls", false);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    /**
     * 扩展数据准备-下拉框
     *
     * @param startRow
     * @param endRow
     * @param startCol
     * @param endCol
     * @return
     */
    private HSSFDataValidation setDataValidationSelect(int startRow, int endRow, int startCol, int endCol, List<Map> items) {
        CellRangeAddressList regions = new CellRangeAddressList(startRow, endRow, startCol, endCol);
        List<String> item = new ArrayList<String>();
        if(items!=null) {
            for (int i = 0; i < items.size(); i++) {
                item.add(items.get(i).get("ITEMVALUE").toString());
            }
        }
        DVConstraint constraint = DVConstraint.createExplicitListConstraint(item.toArray(new String[item.size()]));
        HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint);
        return dataValidation;
    }

    /**
     * 扩展数据准备-数字
     *
     * @param startRow
     * @param endRow
     * @param startCol
     * @param endCol
     * @return
     */
    private HSSFDataValidation setDataValidationNumber(int startRow, int endRow, int startCol, int endCol, String start, String end) {
        CellRangeAddressList regions = new CellRangeAddressList(startRow, endRow, startCol, endCol);
        DVConstraint constraint = DVConstraint.createNumericConstraint(DVConstraint.ValidationType.INTEGER, DVConstraint.OperatorType.BETWEEN, start, end);
        HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint);
        return dataValidation;
    }

    /**
     * 获取基本信息中的下拉选项
     *
     * @param startRow 起始行
     * @param endRow   终止行
     * @param startCol 起始列
     * @param endCol   终止列
     * @param request
     * @return
     */
    private List<HSSFDataValidation> setHSSFDataValidationList(int startRow, int endRow, int[] startCol, int[] endCol, HttpServletRequest request) {
        //项目名称
        List statusList = customerFacade.getCusList();
        List<String> status = new ArrayList<String>();
        for (int i = 0; i < statusList.size(); i++) {
            String value = ((Map) statusList.get(i)).get("name").toString();
            status.add(value);
        }

        List<DVConstraint> constraints = new ArrayList<DVConstraint>();
        DVConstraint constraintStatus = DVConstraint.createExplicitListConstraint(status.toArray(new String[status.size()]));
        constraints.add(constraintStatus);
        CellRangeAddressList regions = null;
        List<HSSFDataValidation> dataValidationList = new ArrayList<HSSFDataValidation>();
        for (int i = 0; i < startCol.length; i++) {
            regions = new CellRangeAddressList(startRow, endRow, startCol[i], endCol[i]);
            HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraints.get(i));
            dataValidationList.add(dataValidation);
        }
        return dataValidationList;
    }


	/**
	 * 配置关系图
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("relationImg.html")
	public String relationImg(Model model,HttpServletRequest request,HttpServletResponse response){
		String flowId = request.getParameter("flowId");
		String ciId = request.getParameter("id");
		CMDB_CI_BASE ci = new CMDB_CI_BASE(ciId).getInstanceById();
		List<Map> mainlist = cfgFacade.getMainCiRelationDetail(ciId);
		List<Map> sublist = cfgFacade.getSubCiRelationDetail(ciId);
		model.addAttribute("mainlist", mainlist);
		model.addAttribute("sublist", sublist);
		model.addAttribute("ci", ci);
		return "/business/pages/cfg/relationImg";
	}
	/**
     * 配置审计
     *
     * @param model
     * @param request
     * @return
     * @author 高发展
     */
    @RequestMapping("cfgmanageSjList.html")
    public String cfgmanageSjList(Model model, HttpServletRequest request) {
        List<Map> cusList = customerFacade.getCusList();
        model.addAttribute("cusList", cusList);
        return "/business/pages/cfg/cfgmanageSjList";
    }

    @RequestMapping("cfgmanageSjData.html")
    public String cfgmanageSjData(PageInfo pageInfo, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        pageInfo = cfgFacade.getCfgData(pageInfo, params);
        model.addAttribute("pageInfo", pageInfo);
        return "/business/pages/cfg/cfgmanageSjData";
    }

    @RequestMapping("cfgmanageSjCount.html")
    public void cfgmanageSjCount(Model model, HttpServletRequest request, HttpServletResponse response) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("fstate_wc", Constants.CFG_FLOW_WC.toString());
        params.put("wc_flag", "1");
        WebUtil.write(response, cfgFacade.getCfgCount(params).toString());
    }
    /**
     * 提交审计
     *
     * @param model
     * @param request
     * @return
     * @author gaofazhan
     */
    @RequestMapping(value = "comitSj.html", method = RequestMethod.GET)
    public String comitSj(Model model, HttpServletRequest request) {
        String cfgId = request.getParameter("cfgId");
        Map info = cfgFacade.getCfgById(cfgId);
        List groupProps = cfgcateFacade.getPropTemplate(ConvertUtil.obj2StrBlank(info.get("lv3_id")), ConvertUtil.obj2StrBlank(info.get("id")));
        model.addAttribute("groupProps", groupProps);
        model.addAttribute("info", info);
        return "/business/pages/cfg/comitSj";
    }
    /**
     *  审计
     * @param flowRecord
     * @param model
     * @param request
     * @return
     */
    @RequestMapping(value = "comitSj.html", method = RequestMethod.POST)
    public ModelAndView doComitSj(FlowRecord flowRecord, Model model, HttpServletRequest request) {
        Map<String, String> params = ParamsMapUtil.getParameterMap(request);
        params.put("user_id", WebUtil.getUserId(request));
        params.put("user_name", WebUtil.getUserName(request));
        params.put("sj_time", ConvertUtil.obj2Str(DateUtil.getCurrentDate14()));
        cfgFacade.saveSj(params);
        String js = "window.top.query();"
                + "window.top.hideDialog('do');";
        return WebUtil.sysInfoPage(request, "操作成功！",
                js,
                SysInfo.Success, "");
    }

}