package com.ghsc.partybuild.controller;

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.core.type.TypeReference;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.github.pagehelper.PageInfo;
import com.ghsc.partybuild.controller.jsonmodel.RequsetData;
import com.ghsc.partybuild.model.*;
import com.ghsc.partybuild.service.*;
import com.ghsc.partybuild.util.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.math.BigDecimal;
import java.util.*;

/**
 * 创岗建区
 *
 * @author pj
 */
@RestController
@RequestMapping(value = "/api/cgjq")
public class CgjqController {

    @Autowired
    private CgjqService cgjqService;
    @Autowired
    private StringUtils stringUtils;
    @Autowired
    private UserService userService;
    @Autowired
    private DictionaryService dictionaryService;
    @Autowired
    private PartyService partyService;
    @Autowired
    private WordUtil wordUtil;
    @Autowired
    private FileService fileService;
    @Autowired
    private FileUtils fileUtils;
    @Autowired
    private PartyUserService partyUserService;

    //岗区配置、评分模板配置功能
    @ResponseBody
    @GetMapping("/getSettingPostareaList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getSettingPostareaList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) Integer cgjqType, @RequestParam(required = false) String partyCode,
                                                                                 @RequestParam(required = false) String userId, @RequestParam(required = false) String name,
                                                                                 @RequestParam(required = false) String headUserName, @RequestParam(required = false) Integer zzfbType) {
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(cgjqService.getSettingPostareaList(pageIndex, pageSize, cgjqType, partyCode, userId, name, headUserName, zzfbType));
        return result;
    }

    @ResponseBody
    @GetMapping("/getSettingPostareaUserList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getSettingPostareaUserList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) String seetingPostareaId, @RequestParam(required = false) Integer dutyUserType) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(cgjqService.getSettingPostareaUserList(pageIndex, pageSize, seetingPostareaId, dutyUserType));
        return result;
    }

    @ResponseBody
    @GetMapping("/getSettingScoreProjectList")
    public List<HashMap<String, Object>> getSettingScoreProjectList(@RequestParam(required = false) String partyCode, @RequestParam(required = true) Integer cgjqType, @RequestParam(required = false) Integer zzfbType) {
        List<HashMap<String, Object>> list = new ArrayList<>();
        list = cgjqService.getSettingScoreProjectList(partyCode, cgjqType, zzfbType);

        if (list.size() <= 0) {
            List<CfDictionary> dicProjectname = new ArrayList<>();
            //String[] projectname = new String[]{};
            if (cgjqType == 1) {
                dicProjectname = dictionaryService.getDictionaryListByDicTypeKey("cgjqProjectNameOfPost");
                //projectname = new String[]{"政治素质", "岗位技能", "工作业绩", "引领带动", "积分奖励", "积分清零"};
            } else {
                dicProjectname = dictionaryService.getDictionaryListByDicTypeKey("cgjqProjectNameOfArea");
                //projectname = new String[]{"团队协作", "技术业务", "尊章守纪", "队伍稳定", "积分奖励", "积分清零"};
            }
            for (int i = 0; i < dicProjectname.size(); i++) {
                HashMap<String, Object> item = new HashMap<>();
                item.put("PROJECTNAME", dicProjectname.get(i).getDicvalue());
                item.put("SORT", i + 1);
                list.add(item);
            }
        }

        return list;
    }

    @ResponseBody
    @GetMapping("/getSettingScoreProjectListOfScore")
    public List<HashMap<String, Object>> getSettingScoreProjectListOfScore(@RequestParam(required = false) String partyCode, @RequestParam(required = true) Integer cgjqType, @RequestParam(required = false) Integer zzfbType) {
        List<HashMap<String, Object>> list = new ArrayList<>();
        list = cgjqService.getSettingScoreProjectList(partyCode, cgjqType, zzfbType);

        return list;
    }

    @ResponseBody
    @RequestMapping("/getPostareaById")
    public RequsetData<CgjqSettingPostarea> getPostareaById(@RequestParam("id") String id, @RequestParam(required = false) String dzzdm, @RequestParam(required = false) Integer cgjqType) {
        //返回信息
        RequsetData<CgjqSettingPostarea> res = new RequsetData<>();
        //扩展信息
        HashMap<String, Object> extData = new HashMap<String, Object>();
        String message = "";

        try {
            //定义变量
            //岗区信息
            CgjqSettingPostarea model = cgjqService.getPostareaById(id);

            if (model == null || (model != null && stringUtils.IsNullOrEmpty(model.getSeetingpostareaid()))) {

                if (partyService.isPartyZb(dzzdm) == 0) {
                    throw new Exception("请选择党支部或党小组");
                }

                UUID uuid = UUID.randomUUID();
                model = new CgjqSettingPostarea();
                model.setSeetingpostareaid(uuid.toString());
                model.setCgjqtype(cgjqType);
                model.setCreateuserid(userService.getLoginUser().getUserid());
                model.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
                model.setCreatetime(new Date());
                model.setPartycode(dzzdm);

            }

            if (!stringUtils.IsNullOrEmpty(model.getPartycode())) {
                ZzZzqkxx zzZzqkxx = partyService.getPartyByDm(model.getPartycode());
                if (zzZzqkxx != null && !stringUtils.IsNullOrEmpty(zzZzqkxx.getDzzdm())) {

                    model.setPartyname(zzZzqkxx.getDzzmc());
                }
            }

            res.setItem(model);
        } catch (Exception e) {
            e.printStackTrace();
            message = e.getMessage();
            res.setSuccess(false);
        }
        res.setMsg(message);
        res.setExtdata(extData);

        return res;
    }

    /**
     * @Description //TODO 保存岗区配置信息
     * @Date 9:53 2019/9/20
     * @Param [reqMap]
     **/
    @ResponseBody
    @RequestMapping("/savePostarea")
    public RequsetData<String> savePostarea(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        ObjectMapper mapper = new ObjectMapper();

        try {
            CgjqSettingPostarea dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), CgjqSettingPostarea.class);
            List<PostareaUserJsonData> userJsonList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<List<PostareaUserJsonData>>() {
            });

            List<CgjqSettingPostareaUser> userList = new ArrayList<>();
            if (userJsonList.size() > 0) {
                for (PostareaUserJsonData user : userJsonList) {
                    CgjqSettingPostareaUser umodel = new CgjqSettingPostareaUser();
                    umodel.setSeetingpostareauserid(UUID.randomUUID().toString());
                    umodel.setSeetingpostareaid(dataModel.getSeetingpostareaid());
                    umodel.setUserid(user.getRybm());
                    umodel.setUsername(user.getXm());
                    umodel.setCreatetime(new Date());
                    umodel.setXb(user.getXb());
                    umodel.setMobile(user.getMobile());
                    umodel.setDutyusertype(user.getDutyusertype());
                    umodel.setPost(user.getPost());
                    userList.add(umodel);
                }
            }

            count = cgjqService.savePostarea(dataModel, userList);

        } catch (Exception e) {

            e.printStackTrace();
            message = e.getMessage();
        }
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
        }
        return res;
    }


    @ResponseBody
    @RequestMapping("/addPost")
    public RequsetData<String> addPost(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        ObjectMapper mapper = new ObjectMapper();

        try {
            CgjqSettingPostarea dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), CgjqSettingPostarea.class);
            List<PostareaUserJsonData> userJsonList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<List<PostareaUserJsonData>>() {
            });

            List<CgjqSettingPostarea> userList = new ArrayList<>();
            if (userJsonList.size() > 0) {
                for (PostareaUserJsonData user : userJsonList) {
                    CgjqSettingPostarea umodel = new CgjqSettingPostarea();
                    umodel.setSeetingpostareaid(UUID.randomUUID().toString());
                    umodel.setName(dataModel.getName());
                    umodel.setPartycode(dataModel.getPartycode());
                    umodel.setPartyname(dataModel.getPartyname());
                    umodel.setCgjqtype(dataModel.getCgjqtype());
                    umodel.setHeaduserid(user.getRybm());
                    umodel.setHeadusername(user.getXm());
                    umodel.setCreateuserid(userService.getLoginUser().getUserid());
                    umodel.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
                    umodel.setCreatetime(new Date());
                    userList.add(umodel);
                }
            }

            count = cgjqService.addPost(userList);

        } catch (Exception e) {

            e.printStackTrace();
            message = e.getMessage();
        }
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
        }
        return res;
    }

    @ResponseBody
    @RequestMapping("/deletePostareaById")
    public RequsetData<String> deletePostareaById(@RequestParam("id") String id) {
        RequsetData<String> res = new RequsetData<>();
        int count = cgjqService.delPostarea(id);
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("删除成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("删除失败！");
        }
        return res;
    }


    /**
     * @Description //TODO 保存岗区配置信息
     * @Date 9:53 2019/9/20
     * @Param [reqMap]
     **/
    @ResponseBody
    @RequestMapping("/saveScoreProject")
    public RequsetData<String> saveScoreProject(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        try {
            if (reqMap.get("dzzdm") == null) {
                throw new Exception("归属部门为空，请选择支部!");
            }
            List<ScoreProjectJsonData> projectJsonList = JsonMapper.jsonToObject(reqMap.get("projectList").toString(), new TypeReference<List<ScoreProjectJsonData>>() {
            });
            Integer cgjqType = Integer.parseInt(reqMap.get("cgjqType").toString());
            String dzzdm = reqMap.get("dzzdm").toString();
            String dzzmc = "";
            ZzZzqkxx zzZzqkxx = partyService.getPartyByDm(dzzdm);
            dzzmc = zzZzqkxx.getDzzmc();

            List<CgjqSeetingScoreproject> projectList = new ArrayList<>();
            if (projectJsonList.size() > 0) {
                for (ScoreProjectJsonData item : projectJsonList) {
                    CgjqSeetingScoreproject model = new CgjqSeetingScoreproject();
                    model.setSeetingprojectid(stringUtils.IsNullOrEmpty(item.getSeetingprojectid()) ? UUID.randomUUID().toString() : item.getSeetingprojectid());
                    model.setProjectname(item.getProjectname());
                    model.setContent(item.getContent());
                    model.setScorerefer(item.getScorerefer());
                    model.setSort(item.getSort());

                    model.setPartycode(dzzdm);
                    model.setPartyname(dzzmc);

                    model.setCgjqtype(cgjqType);

                    projectList.add(model);
                }
            }

            count = cgjqService.saveScoreProject(projectList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());

        } catch (Exception e) {

            e.printStackTrace();
            message = e.getMessage();
        }
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
        }
        return res;
    }


    //岗区评分功能

    @ResponseBody
    @GetMapping("/getPostareaScoreList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getPostareaScoreList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) Integer cgjqType
            , @RequestParam(required = false) Integer year, @RequestParam(required = false) Integer quarter,
                                                                               @RequestParam(required = false) String partyCode,
                                                                               @RequestParam(required = false) String userId, @RequestParam(required = false) String name,
                                                                               @RequestParam(required = false) String headUserName, @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) Integer gqtype) {
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(cgjqService.getPostareaScoreList(pageIndex, pageSize, cgjqType, year, quarter, partyCode, userId, name, headUserName, zzfbType, gqtype,null));
        return result;
    }

    @RequestMapping(value = "/exportPostareaScore", method = RequestMethod.GET)
    public void exportPostareaScore(HttpServletResponse response,
                                    @RequestParam(required = false) Integer cgjqType
            , @RequestParam(required = false) Integer year, @RequestParam(required = false) Integer quarter,
                                    @RequestParam(required = false) String partyCode,
                                    @RequestParam(required = false) String userId, @RequestParam(required = false) String name,
                                    @RequestParam(required = false) String headUserName, @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) Integer gqtype) throws Exception {

        /**查询数据**/
        List<HashMap<String, Object>> dataList = cgjqService.getPostareaScoreList(1, 100000, cgjqType, year, quarter, partyCode, userId, name, headUserName, zzfbType, gqtype,null).getList();

        ExcelHelper excelHelper = new ExcelHelper();
        ExcelHelper.ExcelData data = excelHelper.new ExcelData();

        //列名
        data.setName("创岗建区季度评分信息");
        List<String> titles = new ArrayList();

        if (cgjqType == 1) {
            titles.add("岗位名称");
            titles.add("岗位人员");
            titles.add("所在党支部");
            titles.add("年度");
            titles.add("季度");
            titles.add("总分数");
            titles.add("是否党员先锋岗");
        } else {
            titles.add("责任区名称");
            titles.add("负责人");
            titles.add("所在党支部");
            titles.add("年度");
            titles.add("季度");
            titles.add("总分数");
            titles.add("是否红旗责任区");
        }

        data.setTitles(titles);

        //数据
        List<List<Object>> rows = new ArrayList();
        for (HashMap<String, Object> item : dataList) {
            List<Object> row = new ArrayList();

            row.add(item.get("NAME"));
            row.add(item.get("HEADUSERNAME"));
            row.add(item.get("PARTYNAME"));
            row.add(item.get("YEAR"));
            row.add(item.get("QUARTER"));
            row.add(item.get("SCORE"));
            row.add(item.get("GQTYPE") != null ? (item.get("GQTYPE").toString().equals("1") ? "是" : "否") : "");

            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "创岗建区季度评分信息.xlsx", data);
    }


    @ResponseBody
    @GetMapping("/getPostareaScoreUserList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getPostareaScoreUserList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam("postAreaScoreId") String postAreaScoreId, @RequestParam(required = false) Integer dutyUserType) {
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(cgjqService.getPostareaScoreUserList(pageIndex, pageSize, postAreaScoreId, dutyUserType));
        return result;
    }

    @ResponseBody
    @GetMapping("/getPostareaScoreProjectList")
    public List<HashMap<String, Object>> getPostareaScoreProjectList(@RequestParam("postAreaScoreId") String postAreaScoreId) {
        return cgjqService.getPostareaScoreProjectList(postAreaScoreId);
    }


    @ResponseBody
    @RequestMapping("/getPostareaScoreById")
    public RequsetData<CgjqPostareaScore> getPostareaScoreById(@RequestParam("id") String id, @RequestParam(required = false) Integer cgjqType) {
        //返回信息
        RequsetData<CgjqPostareaScore> res = new RequsetData<>();
        //扩展信息
        HashMap<String, Object> extData = new HashMap<String, Object>();
        String message = "";

        try {
            //定义变量
            //岗区评分信息
            CgjqPostareaScore model = cgjqService.getPostareaScoreById(id);
            if (model == null || (model != null && stringUtils.IsNullOrEmpty(model.getSeetingpostareaid()))) {
                UUID uuid = UUID.randomUUID();
                model = new CgjqPostareaScore();
                model.setPostareascoreid(uuid.toString());
                model.setCgjqtype(cgjqType);
                model.setGqtype(0);
                model.setCreateuserid(userService.getLoginUser().getUserid());
                model.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
                model.setCreatetime(new Date());
            }

            model.setPartyname(partyService.getPartyName(model.getPartycode()));

            res.setItem(model);
        } catch (Exception e) {
            e.printStackTrace();
            message = e.getMessage();
            res.setSuccess(false);
        }
        res.setMsg(message);
        res.setExtdata(extData);

        return res;
    }


    /**
     * @Description //TODO 保存岗区评分信息
     * @Date 9:53 2019/9/20
     * @Param [reqMap]
     **/
    @ResponseBody
    @RequestMapping("/savePostareaScore")
    public RequsetData<String> savePostareaScore(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        ObjectMapper mapper = new ObjectMapper();

        try {
            CgjqPostareaScore dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), CgjqPostareaScore.class);
            List<ScoreProjectJsonData> projectJsonList = JsonMapper.jsonToObject(reqMap.get("projectList").toString(), new TypeReference<List<ScoreProjectJsonData>>() {
            });

            //验证数据
            CgjqPostareaScore dbModel = cgjqService.getPostareaScoreByQuarter(dataModel.getSeetingpostareaid(), dataModel.getYear(), dataModel.getQuarter());
            if (dbModel != null && !stringUtils.IsNullOrEmpty(dbModel.getPostareascoreid()) && !dataModel.getPostareascoreid().equals(dbModel.getPostareascoreid())) {
                throw new Exception("该岗位已有" + dataModel.getYear() + "年" + dataModel.getQuarter() + "季度评分!");
            }

            List<CgjqPostareaScoreUser> userList = new ArrayList<>();
            List<CgjqPostareaScoreProject> projectList = new ArrayList<>();
            List<HashMap<String, Object>> dbUser = cgjqService.getSettingPostareaUserList(1, 10000, dataModel.getSeetingpostareaid(), null).getList();
            for (HashMap<String, Object> item : dbUser) {
                CgjqPostareaScoreUser umodel = new CgjqPostareaScoreUser();
                umodel.setScoreuserid(UUID.randomUUID().toString());
                umodel.setPostareascoreid(dataModel.getPostareascoreid());
                umodel.setUserid(item.get("USERID") != null ? item.get("USERID").toString() : "");
                umodel.setUsername(item.get("USERNAME") != null ? item.get("USERNAME").toString() : "");
                umodel.setXb(item.get("XB") != null ? item.get("XB").toString() : "");
                umodel.setMobile(item.get("MOBILE") != null ? item.get("MOBILE").toString() : "");
                umodel.setDutyusertype(Integer.parseInt(item.get("DUTYUSERTYPE").toString()));
                umodel.setPost(item.get("POST") != null ? item.get("POST").toString() : "");
                umodel.setCreatetime(new Date());

                userList.add(umodel);
            }
            if (projectJsonList.size() > 0) {
                for (ScoreProjectJsonData item : projectJsonList) {
                    CgjqPostareaScoreProject model = new CgjqPostareaScoreProject();
                    model.setScoreprojectid(stringUtils.IsNullOrEmpty(item.getScoreprojectid()) ? UUID.randomUUID().toString() : item.getScoreprojectid());
                    model.setPostareascoreid(dataModel.getPostareascoreid());
                    model.setSeetingprojectid(dataModel.getSeetingpostareaid());
                    model.setProjectname(item.getProjectname());
                    model.setContent(item.getContent());
                    model.setScorerefer(item.getScorerefer());
                    model.setSort(item.getSort());
                    model.setReason(item.getReason());
                    model.setInitialscore(item.getInitialscore().intValue());
                    model.setCgjqscorechecktype(item.getCgjqscorechecktype());
                    model.setScore(item.getScore().intValue());

                    projectList.add(model);
                }
            }

            count = cgjqService.savePostareaScore(dataModel, userList, projectList, userService.getLoginUser().getUserid(), userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());

        } catch (Exception e) {

            e.printStackTrace();
            message = e.getMessage();
        }
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
        }
        return res;
    }


    @ResponseBody
    @GetMapping("/getPostareaScoreOrderList")
    public List<HashMap<String, Object>> getPostareaScoreOrderList(@RequestParam("partyCode") String partyCode, @RequestParam("cgjqType") Integer cgjqType, @RequestParam("year") Integer year, @RequestParam("quarter") Integer quarter, @RequestParam(required = false) Integer zzfbType) {
        return cgjqService.getPostareaScoreOrderList(partyCode, cgjqType, year, quarter, zzfbType);
    }


    @ResponseBody
    @RequestMapping("/updateScoreLevel")
    public RequsetData<String> updateScoreLevel(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        ObjectMapper mapper = new ObjectMapper();

        try {
            String postAreaScoreId = reqMap.get("postAreaScoreId").toString();
            Integer scoreLevel = Integer.parseInt(reqMap.get("scoreLevel").toString());
            String userId = userService.getLoginUser().getUserid();

            CgjqPostareaScore model = cgjqService.getPostareaScoreById(postAreaScoreId);
            model.setScorelevel(scoreLevel);
            count = cgjqService.updatePostareaScore(model, userId, userService.getUserInfobyId(userId).getName());


        } catch (Exception e) {

            e.printStackTrace();
            message = e.getMessage();
        }
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
        }
        return res;
    }


    @RequestMapping(value = "/exportPostareaScoreOrder", method = RequestMethod.GET)
    public void exportPostareaScoreOrder(HttpServletResponse response,
                                         @RequestParam("partyCode") String partyCode, @RequestParam("cgjqType") Integer cgjqType, @RequestParam("year") Integer year, @RequestParam("quarter") Integer quarter, @RequestParam(required = false) Integer zzfbType) throws Exception {

        /**查询数据**/
        List<HashMap<String, Object>> dataList = cgjqService.getPostareaScoreOrderList(partyCode, cgjqType, year, quarter, zzfbType);

        ExcelHelper excelHelper = new ExcelHelper();
        ExcelHelper.ExcelData data = excelHelper.new ExcelData();

        //列名
        data.setName("季度评分信息");
        List<String> titles = new ArrayList();
        if (cgjqType == 1) {
            titles.add("责任岗名称");
            titles.add("岗位成员");
        } else {
            titles.add("责任区名称");
            titles.add("负责人");
        }
        titles.add("所在党支部");
        titles.add("年度");
        titles.add("季度");
        titles.add("季度积分");
        titles.add("排名");
        titles.add("评定等级");
        data.setTitles(titles);

        //数据
        List<List<Object>> rows = new ArrayList();
        for (HashMap<String, Object> item : dataList) {
            List<Object> row = new ArrayList();
            row.add(item.get("NAME"));
            row.add(item.get("HEADUSERNAME"));
            row.add(item.get("PARTYNAME"));
            row.add(item.get("YEAR"));
            row.add(item.get("QUARTER"));
            row.add(item.get("SCORE"));
            row.add(item.get("ORDERID"));
            row.add(item.get("SCORELEVELNAME"));

            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "季度评分信息.xlsx", data);
    }


    @ResponseBody
    @GetMapping("/getSettingPostareaOfScoreList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getSettingPostareaOfScoreList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                                        @RequestParam("year") Integer year, @RequestParam("quarter") Integer quarter,
                                                                                        @RequestParam(required = false) Integer cgjqType, @RequestParam(required = false) String partyCode,
                                                                                        @RequestParam(required = false) String userId, @RequestParam(required = false) String name,
                                                                                        @RequestParam(required = false) String headUserName) {
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(cgjqService.getSettingPostareaOfScoreList(pageIndex, pageSize, year, quarter, cgjqType, partyCode, userId, name, headUserName));
        return result;
    }


    @ResponseBody
    @RequestMapping("/deletePostareaScoreById")
    public RequsetData<String> deletePostareaScoreById(@RequestParam("id") String id) {
        RequsetData<String> res = new RequsetData<>();
        int count = cgjqService.deletePostareaScore(id);
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("删除成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("删除失败！");
        }
        return res;
    }

    /**
     * @Description //TODO 生成word文档
     * @Date 9:30 2019/10/8
     * @Param [id]
     **/
    @RequestMapping(value = "/createWord", method = RequestMethod.GET)
    public void createWord(HttpServletResponse response, @RequestParam("id") String id) {

        try {
            //岗区评分信息
            CgjqPostareaScore model = cgjqService.getPostareaScoreById(id);
            HashMap<String, Object> userMap = partyUserService.getPartyUserInfoByRybm(model.getHeaduserid());
            List<HashMap<String, Object>> userList = cgjqService.getPostareaScoreUserList(1, 100000, id, null).getList();
            List<CfDictionary> dicScoreLevel = dictionaryService.getDictionaryListByDicTypeKey("scoreLevel");
            CfDictionary cfDictionary = dictionaryService.getDicByKey(model.getScorelevel(), dicScoreLevel);
            //评定级别名称
            String scoreLevelName = cfDictionary != null ? cfDictionary.getDicvalue() : "";

            /** 用于组装word页面需要的数据 */
            Map<String, Object> dataMap = new HashMap<String, Object>();
            // 组装数据
            dataMap.put("quarter", model.getQuarter());
            dataMap.put("partyName", model.getPartyname());
            dataMap.put("postareaName", model.getName());
            dataMap.put("headUserName", model.getHeadusername());
            dataMap.put("score", model.getScore());
            dataMap.put("scoreLevelName", scoreLevelName);
            //职务名称
            dataMap.put("zwmc", (userMap != null && userMap.get("DNZWMC") != null) ? userMap.get("DNZWMC").toString() : "");
            //党员数量
            dataMap.put("dysl", userList.stream().filter(it -> "1".equals(it.get("DUTYUSERTYPE").toString())).count());
            //群众数量
            dataMap.put("qzsl", userList.stream().filter(it -> "2".equals(it.get("DUTYUSERTYPE").toString())).count());

            /** 生成word */
            //文件名称
            String fileName = model.getCgjqtype() == 1 ? "党员先锋岗评比申报表" : "红旗责任区评比申报表";
            wordUtil.createWord(response, dataMap, fileName, fileName);

        } catch (Exception e) {

            e.printStackTrace();

        }
    }


}

@JsonIgnoreProperties(ignoreUnknown = true)
class PostareaUserJsonData {
    private String rybm;
    private String xm;
    private String szdzbdm;
    private String dzzmc;
    private String xb;
    private String mobile;
    private Integer dutyusertype;
    private String post;

    public String getRybm() {
        return rybm;
    }

    public void setRybm(String rybm) {
        this.rybm = rybm;
    }

    public String getXm() {
        return xm;
    }

    public void setXm(String xm) {
        this.xm = xm;
    }

    public String getSzdzbdm() {
        return szdzbdm;
    }

    public void setSzdzbdm(String szdzbdm) {
        this.szdzbdm = szdzbdm;
    }

    public String getDzzmc() {
        return dzzmc;
    }

    public void setDzzmc(String dzzmc) {
        this.dzzmc = dzzmc;
    }

    public String getXb() {
        return xb;
    }

    public void setXb(String xb) {
        this.xb = xb;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    public Integer getDutyusertype() {
        return dutyusertype;
    }

    public void setDutyusertype(Integer dutyusertype) {
        this.dutyusertype = dutyusertype;
    }

    public String getPost() {
        return post;
    }

    public void setPost(String post) {
        this.post = post;
    }
}

@JsonIgnoreProperties(ignoreUnknown = true)
class ScoreProjectJsonData {
    private String seetingprojectid;
    private String projectname;
    private String content;
    private String scorerefer;
    private Integer sort;
    private BigDecimal score;
    private String reason;
    private BigDecimal initialscore;
    private Integer cgjqscorechecktype;
    private String scoreprojectid;


    public String getSeetingprojectid() {
        return seetingprojectid;
    }

    public void setSeetingprojectid(String seetingprojectid) {
        this.seetingprojectid = seetingprojectid;
    }

    public String getProjectname() {
        return projectname;
    }

    public void setProjectname(String projectname) {
        this.projectname = projectname;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getScorerefer() {
        return scorerefer;
    }

    public void setScorerefer(String scorerefer) {
        this.scorerefer = scorerefer;
    }

    public Integer getSort() {
        return sort;
    }

    public void setSort(Integer sort) {
        this.sort = sort;
    }

    public BigDecimal getScore() {
        return score;
    }

    public void setScore(BigDecimal score) {
        this.score = score;
    }

    public String getReason() {
        return reason;
    }

    public void setReason(String reason) {
        this.reason = reason;
    }

    public BigDecimal getInitialscore() {
        return initialscore;
    }

    public void setInitialscore(BigDecimal initialscore) {
        this.initialscore = initialscore;
    }

    public Integer getCgjqscorechecktype() {
        return cgjqscorechecktype;
    }

    public void setCgjqscorechecktype(Integer cgjqscorechecktype) {
        this.cgjqscorechecktype = cgjqscorechecktype;
    }

    public String getScoreprojectid() {
        return scoreprojectid;
    }

    public void setScoreprojectid(String scoreprojectid) {
        this.scoreprojectid = scoreprojectid;
    }
}