package com.ghsc.partybuild.controller;

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.PartyService;
import com.ghsc.partybuild.service.PartyTwoService;
import com.ghsc.partybuild.service.UserService;
import com.ghsc.partybuild.util.*;
import com.ghsc.partybuild.vo.*;
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.*;

@RestController
@RequestMapping(value = "/api/partyTowExt")
public class PartyTwoController {

    @Autowired
    private PartyTwoService partyTwoService;
    @Autowired
    private MapUtils mapUtils;
    @Autowired
    private StringUtils stringUtils;
    @Autowired
    private DateUtils dateUtils;
    @Autowired
    private UserService userService;
    @Autowired
    private PartyService partyService;

    @ResponseBody
    @GetMapping("/getDnpxxxList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getDnpxxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                        @RequestParam(required = false) String dzzmc,
                                                                        @RequestParam(required = false) String dzzdm,
                                                                        @RequestParam(required = false) String username,
                                                                        @RequestParam(required = false) String rybm,
                                                                        @RequestParam(required = false) Integer honourLevel,
                                                                        @RequestParam(required = false) String honourName,
                                                                        @RequestParam(required = false) String beginTime,
                                                                        @RequestParam(required = false) String endTime,
                                                                        @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) Integer pxlx, @RequestParam(required = false) String ssdzzdm ,@RequestParam(required = false)Integer honourType) {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getDnpxxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, ssdzzdm,honourType));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getDnpxxx")
    public RequsetData<DjDnpxxx> getDnpxxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc, @RequestParam(required = false) String pxlx) {
        RequsetData<DjDnpxxx> res = new RequsetData<>();

        DjDnpxxx model = partyTwoService.getDnpxxx(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjDnpxxx();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
            model.setPxlx(pxlx);
            model.setIscommend(0);
        } else {
            List<DjDnpxry> rylist = partyTwoService.getDnpxryList(model.getId());
            Map<String, Object> extdata = new HashMap<>(10);
         /*   List<String> userid = new ArrayList<>();
            List<String> username = new ArrayList<>();
            for (DjDnpxry ry : rylist) {
                userid.add(ry.getUserid());
                username.add(ry.getUsername());
            }
            extdata.put("userid", String.join(",", userid));
            extdata.put("username", String.join(",", username));*/
            res.setExtdata(extdata);
        }
        res.setItem(model);
        return res;
    }

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

        try {
            DjDnpxxx model = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnpxxx.class);
            UserItemVo[] recordList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<UserItemVo[]>() {
            });
            res = partyTwoService.saveDnpxxx(model, recordList);
        } catch (Exception e) {

            e.printStackTrace();
        }
        return res;
    }

    @ResponseBody
    @GetMapping("/delDnpxxx")
    public RequsetData<Integer> delDnpxxx(@RequestParam("id") String id, @RequestParam(required = false) String userid) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delDnpxxx(id, userid);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @ResponseBody
    @RequestMapping("/importDnpxxx")
    public RequsetData<List<Map<String, Object>>> importDnpxxx(@RequestBody Map<String, Object> reqMap) {
        RequsetData<List<Map<String, Object>>> res = new RequsetData<>();
        List<Map<String, Object>> errorInfo = new ArrayList<>();
        String message = "";
        try {
            List<Map<String, Object>> dataList = JsonMapper.jsonToObject(reqMap.get("dnpxxxList").toString(), new TypeReference<List<Map<String, Object>>>() {
            });
            partyTwoService.importDnpxxx(dataList);
        } catch (Exception e) {
            e.printStackTrace();
            message = e.toString();
        }
        if (errorInfo.size() <= 0 && stringUtils.IsNullOrEmpty(message)) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
            res.setItem(errorInfo);
        }
        return res;
    }

    @RequestMapping(value = "/exportDnpxxx", method = RequestMethod.GET)
    public void exportDnpxxx(HttpServletResponse response,
                             @RequestParam(required = false) String dzzmc,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) String username,
                             @RequestParam(required = false) String rybm,
                             @RequestParam(required = false) Integer honourLevel,
                             @RequestParam(required = false) String honourName,
                             @RequestParam(required = false) String beginTime,
                             @RequestParam(required = false) String endTime,
                             @RequestParam(required = false) Integer zzfbType,
                             @RequestParam(required = false) Integer pxlx) throws Exception {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getDnpxxxList(1, 100000, dzzdm, dzzmc, username, rybm, honourLevel, honourName, beginTime, endTime, zzfbType, pxlx, null,null).getList();

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

        //列名
        data.setName("党内评先信息");
        List<String> titles = new ArrayList();
        titles.add("荣誉名称");
        //titles.add("评先类型");
        if (pxlx == 1) {
            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("HONOURNAME"));
            //row.add("1".equals((String) item.get("PXLX")) ? "个人" : "组织");
            if (pxlx == 1) {
                row.add(item.get("USERNAME"));
            }
            row.add(item.get("DZZMC"));
            row.add(dateUtils.strFormat(item.get("HONOURTIME").toString()));
            row.add(item.get("LevelName"));
            row.add(item.get("honourTypeName"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党内评先信息.xlsx", data);
    }

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

        try {
            DjDnghbf dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjDnghbf.class);
            List<DjDnghbfmx> recordList = JsonMapper.jsonToObject(reqMap.get("recordList").toString(), new TypeReference<List<DjDnghbfmx>>() {
            });
            count = partyTwoService.saveDnghbf(dataModel, recordList, 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
    @RequestMapping("/saveDnghbfmx")
    public RequsetData<String> saveDnghbfmx(@RequestBody DjDnghbfmx bfmx) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        count = partyTwoService.saveDnghbfmx(bfmx);
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！");
        }
        return res;
    }

    @ResponseBody
    @RequestMapping("/getDnghbf")
    public RequsetData<DjDnghbf> getDnghbf(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjDnghbf> res = new RequsetData<>();

        DjDnghbf model = partyTwoService.getDnghbf(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjDnghbf();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
        }
        res.setItem(model);
        return res;
    }

    @ResponseBody
    @GetMapping("/getDnghbfList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                        @RequestParam(required = false) String dzzmc,
                                                                        @RequestParam(required = false) String dzzdm,
                                                                        @RequestParam(required = false) String username,
                                                                        @RequestParam(required = false) String rybm,
                                                                        @RequestParam(required = false) Integer careType,
                                                                        @RequestParam(required = false) Integer zzfbType,
                                                                        @RequestParam(required = false) String beginTime,
                                                                        @RequestParam(required = false) String endTime,
                                                                        @RequestParam(required = false) Integer helpformType) {
        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getDnghbfList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType));
        return result;
    }

    @ResponseBody
    @GetMapping("/getDnghbfDetailsList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfDetailsList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                               @RequestParam(required = false) String dzzmc,
                                                                               @RequestParam(required = false) String dzzdm,
                                                                               @RequestParam(required = false) String username,
                                                                               @RequestParam(required = false) String rybm,
                                                                               @RequestParam(required = false) Integer careType,
                                                                               @RequestParam(required = false) Integer zzfbType) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getDnghbfDetailsList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, careType, zzfbType));
        return result;
    }

    @ResponseBody
    @GetMapping("/getDnghbfmxList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getDnghbfmxList(
            @RequestParam(required = false) String dnghbId) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getDnghbfmxList(1, 10000, dnghbId));
        return result;
    }

    @ResponseBody
    @GetMapping("/delDnghbf")
    public RequsetData<Integer> delDnghbf(@RequestParam("id") String id, @RequestParam(required = false) String ghmxid) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delDnghbf(id, ghmxid);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportDnghbf", method = RequestMethod.GET)
    public void exportDnghbf(HttpServletResponse response,
                             @RequestParam(required = false) String dzzmc,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) String username,
                             @RequestParam(required = false) String rybm,
                             @RequestParam(required = false) Integer careType,
                             @RequestParam(required = false) Integer zzfbType,
                             @RequestParam(required = false) String beginTime,
                             @RequestParam(required = false) String endTime,
                             @RequestParam(required = false) Integer helpformType) throws Exception {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getDnghbfList(1, 100000, dzzdm, dzzmc, username, rybm, careType, zzfbType, beginTime, endTime, helpformType).getList();

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

        //列名
        data.setName("党内评先信息");
        List<String> titles = new ArrayList();
        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("USERNAME"));
            row.add(item.get("SZDZZMC"));
            row.add(dateUtils.strFormat(item.get("CAREDATE").toString()));
            row.add(item.get("HELPFORMTYPENAME"));
            row.add(item.get("AMOUNT"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党内关怀帮扶.xlsx", data);
    }

    @ResponseBody
    @GetMapping("/getZtdrxxList")
    public RequsetData<PageInfo<DjZtdrxxVo>> getZtdrxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                           @RequestParam(required = false) String dzzmc,
                                                           @RequestParam(required = false) String dzzdm,
                                                           @RequestParam(required = false) String title,
                                                           @RequestParam(required = false) Integer subjectType,
                                                           @RequestParam(required = false) String location,
                                                           @RequestParam(required = false) String beginTime,
                                                           @RequestParam(required = false) String endTime,
                                                           @RequestParam(required = false) Integer zzfbType) {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        RequsetData<PageInfo<DjZtdrxxVo>> result = new RequsetData<>();
        result.setItem(partyTwoService.getZtdrxxList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getZtdrxx")
    public RequsetData<DjZtdrxxVo> getZtdrxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjZtdrxxVo> res = new RequsetData<>();

        DjZtdrxxVo model = partyTwoService.getZtdrxx(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjZtdrxxVo();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
            model.setPersonnellist(new ArrayList<>());
        }
        res.setItem(model);
        return res;
    }

    @ResponseBody
    @RequestMapping("/saveZtdrxx")
    public RequsetData<String> saveZtdrxx(@RequestBody DjZtdrxxVo model) {

        RequsetData<String> res = partyTwoService.saveZtdrxx(model);

        return res;
    }

    @ResponseBody
    @GetMapping("/delZtdrxx")
    public RequsetData<Integer> delZtdrxx(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delZtdrxx(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportZtdrxx", method = RequestMethod.GET)
    public void exportZtdrxx(HttpServletResponse response,
                             @RequestParam(required = false) String dzzmc,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) String username,
                             @RequestParam(required = false) Integer honourLevel,
                             @RequestParam(required = false) String honourName,
                             @RequestParam(required = false) String beginTime,
                             @RequestParam(required = false) String endTime,
                             @RequestParam(required = false) Integer zzfbType) throws Exception {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        /**查询数据**/
        List<DjZtdrxxVo> dataList = partyTwoService.getZtdrxxList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();

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

        //列名
        data.setName("主题党日信息");
        List<String> titles = new ArrayList();
        titles.add("所属党组织");
        titles.add("时间");
        titles.add("地点");
        titles.add("主题");
        titles.add("内容");
        titles.add("类别");
        data.setTitles(titles);

        //数据
        List<List<Object>> rows = new ArrayList();
        for (DjZtdrxxVo item : dataList) {
            List<Object> row = new ArrayList();
            row.add(item.getDzzmc());
            row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
            row.add(item.getLocation());
            row.add(item.getTitle());
            row.add(item.getSubjectcontent());
            row.add(item.getSubjecttypename());
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "主题党日信息.xlsx", data);
    }
    @ResponseBody
    @GetMapping("/getZzsrList")
    public RequsetData<PageInfo<DjZzsrVo>> getZzsrList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                       @RequestParam(required = false) String dzzmc,
                                                       @RequestParam(required = false) String dzzdm,
                                                       @RequestParam(required = false) String title,
                                                       @RequestParam(required = false) Integer subjectType,
                                                       @RequestParam(required = false) String location,
                                                       @RequestParam(required = false) String beginTime,
                                                       @RequestParam(required = false) String endTime,
                                                       @RequestParam(required = false) Integer zzfbType) {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        RequsetData<PageInfo<DjZzsrVo>> result = new RequsetData<>();
        result.setItem(partyTwoService.getZzsrList(pageIndex, pageSize, dzzdm, dzzmc, title, subjectType, location, beginTime, endTime, zzfbType));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getZzsr")
    public RequsetData<DjZzsr> getZzsr(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjZzsr> res = new RequsetData<>();

        DjZzsr model = partyTwoService.getZzsr(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjZzsr();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
        }
        res.setItem(model);
        return res;
    }

    @ResponseBody
    @RequestMapping("/saveZzsr")
    public RequsetData<String> saveZzsr(@RequestBody DjZzsr model) {

        RequsetData<String> res = partyTwoService.saveZzsr(model);

        return res;
    }

    @ResponseBody
    @GetMapping("/delZzsr")
    public RequsetData<Integer> delZzsr(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delZzsr(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportZzsr", method = RequestMethod.GET)
    public void exportZzsr(HttpServletResponse response,
                           @RequestParam(required = false) String dzzmc,
                           @RequestParam(required = false) String dzzdm,
                           @RequestParam(required = false) String username,
                           @RequestParam(required = false) Integer honourLevel,
                           @RequestParam(required = false) String honourName,
                           @RequestParam(required = false) String beginTime,
                           @RequestParam(required = false) String endTime,
                           @RequestParam(required = false) Integer zzfbType) throws Exception {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);

        /**查询数据**/
        List<DjZzsrVo> dataList = partyTwoService.getZzsrList(1, 100000, dzzdm, dzzmc, username, honourLevel, honourName, beginTime, endTime, zzfbType).getList();

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

        //列名
        data.setName("政治生日信息");
        List<String> titles = new ArrayList();
        titles.add("所属党组织");
        titles.add("时间");
        titles.add("地点");
        titles.add("主题");
        titles.add("内容");
        titles.add("类别");
        data.setTitles(titles);

        //数据
        List<List<Object>> rows = new ArrayList();
        for (DjZzsrVo item : dataList) {
            List<Object> row = new ArrayList();
            row.add(item.getDzzmc());
            row.add(dateUtils.strFormat_short(item.getActivitytime().toString()));
            row.add(item.getLocation());
            row.add(item.getTitle());
            row.add(item.getSubjectcontent());
            row.add(item.getSubjecttypename());
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "政治生日信息.xlsx", data);
    }
    @ResponseBody
    @GetMapping("/getParyDjkpList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getParyDjkpList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize, @RequestParam(required = false) String dzzdm,
                                                                          @RequestParam(required = false) String selectdzzmc,
                                                                          @RequestParam(required = false) Integer year,
                                                                          @RequestParam(required = false) Integer showdxz,
                                                                          @RequestParam(required = false) Integer showdw,
                                                                          @RequestParam(required = false) Integer showdzb,
                                                                          @RequestParam(required = false) String selectdzzdm) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        List<String> selectdzzdmList = new ArrayList<>();
        if (!stringUtils.IsNullOrEmpty(selectdzzdm)) {
            selectdzzdmList = Arrays.asList(selectdzzdm.split(","));
        }
        result.setItem(partyTwoService.getParyDjkpList(pageIndex, pageSize, dzzdm,selectdzzmc, showdxz, year, showdw,showdzb,selectdzzdmList));
        return result;
    }

    @ResponseBody
    @GetMapping("/getDjkpxxList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getDjkpxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                        @RequestParam(required = false) String dzzmc,
                                                                        @RequestParam(required = false) String dzzdm,
                                                                        @RequestParam(required = false) Integer year,
                                                                        @RequestParam(required = false) Integer judgeLevel,
                                                                        @RequestParam(required = false) Integer zzfbType, @RequestParam(required = false) String ssdzzdm,
                                                                        @RequestParam(required = false) Integer showdw) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getDjkpxxList(pageIndex, pageSize, dzzdm, dzzmc, judgeLevel, year, zzfbType, ssdzzdm, showdw));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getDjkpxx")
    public RequsetData<DjDjkpxx> getDjkpxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjDjkpxx> res = new RequsetData<>();

        DjDjkpxx model = partyTwoService.getDjkpxx(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjDjkpxx();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
        }
        res.setItem(model);
        return res;
    }

    @ResponseBody
    @RequestMapping("/saveDjkpxx")
    public RequsetData<String> saveDjkpxx(@RequestBody DjDjkpxx model) {

        RequsetData<String> res = partyTwoService.saveDjkpxx(model);

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

        try {
            List<DjDjkpxx> dataList = JsonMapper.jsonToObject(reqMap.get("dataList").toString(), new TypeReference<List<DjDjkpxx>>() {
            });

            count = partyTwoService.saveDjkpxxByList(dataList, 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("/delDjkpxx")
    public RequsetData<Integer> delDjkpxx(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delDjkpxx(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportDjkpxx", method = RequestMethod.GET)
    public void exportDjkpxx(HttpServletResponse response,
                             @RequestParam(required = false) String dzzmc,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) Integer year,
                             @RequestParam(required = false) Integer judgeLevel,
                             @RequestParam(required = false) Integer zzfbType,
                             @RequestParam(required = false) Integer showdw) throws Exception {


        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getDjkpxxList(1, 100000, dzzdm, dzzmc, year, judgeLevel, zzfbType, null, showdw).getList();

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

        //列名
        data.setName("党建考评信息");
        List<String> titles = new ArrayList();
        titles.add("所属党组织");
        titles.add("年度");
        titles.add("第一季度评分");
        titles.add("第二季度评分");
        titles.add("第三季度评分");
        titles.add("第四季度评分");
      /*  if (showdw == 1) {
            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("DZZMC"));
            row.add(item.get("YEAR"));
            row.add(item.get("QUARTER1"));
            row.add(item.get("QUARTER2"));
            row.add(item.get("QUARTER3"));
            row.add(item.get("QUARTER4"));
          /*  if (showdw == 1) {
                row.add(item.get("ANNUALSCORE"));
            }*/
            row.add(item.get("JUDGELEVELNAME"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党建考评信息.xlsx", data);
    }


    @ResponseBody
    @GetMapping("/getJlcfxxList")
    public RequsetData<PageInfo<DjJlcfxxVo>> getJlcfxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                           @RequestParam(required = false) String dzzmc,
                                                           @RequestParam(required = false) String dzzdm,
                                                           @RequestParam(required = false) String username,
                                                           @RequestParam(required = false) String rybm,
                                                           @RequestParam(required = false) Integer offenceType,
                                                           @RequestParam(required = false) Integer punishType,
                                                           @RequestParam(required = false) String beginTime,
                                                           @RequestParam(required = false) String endTime,
                                                           @RequestParam(required = false) Integer zzfbType) {
        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        RequsetData<PageInfo<DjJlcfxxVo>> result = new RequsetData<>();
        result.setItem(partyTwoService.getJlcfxxList(pageIndex, pageSize, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getJlcfxx")
    public RequsetData<DjJlcfxx> getJlcfxx(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjJlcfxx> res = new RequsetData<>();

        DjJlcfxx model = partyTwoService.getJlcfxx(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjJlcfxx();
            model.setId(uuid.toString());
            model.setDzzdm(dzzdm);
            model.setDzzmc(dzzmc);
        }
        res.setItem(model);
        return res;
    }

    @ResponseBody
    @RequestMapping("/saveJlcfxx")
    public RequsetData<String> saveJlcfxx(@RequestBody DjJlcfxx model) {

        RequsetData<String> res = partyTwoService.saveJlcfxx(model);

        return res;
    }

    @ResponseBody
    @GetMapping("/delJlcfxx")
    public RequsetData<Integer> delJlcfxx(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delJlcfxx(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportJlcfxx", method = RequestMethod.GET)
    public void exportJlcfxx(HttpServletResponse response,
                             @RequestParam(required = false) String dzzmc,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) String username,
                             @RequestParam(required = false) String rybm,
                             @RequestParam(required = false) Integer offenceType,
                             @RequestParam(required = false) Integer punishType,
                             @RequestParam(required = false) String beginTime,
                             @RequestParam(required = false) String endTime,
                             @RequestParam(required = false) Integer zzfbType) throws Exception {


        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        /**查询数据**/
        List<DjJlcfxxVo> dataList = partyTwoService.getJlcfxxList(1, 100000, dzzdm, dzzmc, username, rybm, offenceType, punishType, beginTime, endTime, zzfbType).getList();

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

        //列名
        data.setName("党员受党的纪律处分信息");
        List<String> titles = new ArrayList();
        titles.add("姓名");
        titles.add("所属党组织");
        titles.add("批准日期");
        titles.add("处分类型");
        titles.add("违纪行为");
        titles.add("批准单位");
        titles.add("文号");
        data.setTitles(titles);

        //数据
        List<List<Object>> rows = new ArrayList();
        for (DjJlcfxxVo item : dataList) {
            List<Object> row = new ArrayList();
            row.add(item.getUsername());
            row.add(item.getDzzmc());
            row.add(dateUtils.strFormat_short(item.getApprovaldate().toString()));
            row.add(item.getPunishtypename());
            row.add(item.getOffence());
            row.add(item.getUnit());
            row.add(item.getSymbol());
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党员受党的纪律处分信息.xlsx", data);
    }

    @ResponseBody
    @GetMapping("/getTaskList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getTaskList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                      @RequestParam(required = false) String username,
                                                                      @RequestParam(required = false) String taskUser,
                                                                      @RequestParam(required = false) String taskName,
                                                                      @RequestParam(required = false) String beginTime,
                                                                      @RequestParam(required = false) String endTime,
                                                                      @RequestParam(required = false) String userid,
                                                                      @RequestParam(required = false) String day,
                                                                      @RequestParam(required = false) Integer isreceive) {
        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getTaskList(pageIndex, pageSize, username, taskUser, taskName, beginTime, endTime, day, userid,isreceive));
        return result;
    }

    @ResponseBody
    @GetMapping("/getTaskUserList")
    public RequsetData<List<DjTaskusers>> getTaskUserList(@RequestParam(required = false) String taskid) {
        RequsetData<List<DjTaskusers>> result = new RequsetData<>();
        result.setItem(partyTwoService.getTaskUserList(taskid));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getTask")
    public RequsetData<DjTask> getTask(@RequestParam(required = false) String id) {
        RequsetData<DjTask> res = new RequsetData<>();

        DjTask model = partyTwoService.getTask(id);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjTask();
            model.setId(uuid.toString());
            model.setTasktime(new Date());
            model.setCreateuserid(userService.getLoginUser().getUserid());
            model.setCreateusername(userService.getUserInfobyId(userService.getLoginUser().getUserid()).getName());
        }else{
            Map<String, Object> extdata=new HashMap<String, Object>();
            extdata.put("isReceiveTask",partyTwoService.isReceiveTask(id,userService.getLoginUser().getUserid()));
            res.setExtdata(extdata);
        }
        res.setItem(model);

        return res;
    }

    @ResponseBody
    @RequestMapping("/receiveTask")
    public RequsetData<Integer> receiveTask(@RequestParam(required = false) String id) {
        int count = partyTwoService.receiveTask(id, userService.getLoginUser().getUserid());
        RequsetData<Integer> res = new RequsetData<>();
        res.setItem(count);
        return res;
    }
    @ResponseBody
    @RequestMapping("/resetSubmit")
    public RequsetData<Integer> resetSubmit(@RequestParam(required = false) String id) {
        int count = partyTwoService.resetSubmit(id);
        RequsetData<Integer> res = new RequsetData<>();
        res.setItem(count);
        return res;
    }
    @ResponseBody
    @RequestMapping("/saveTask")
    public RequsetData<String> saveTask(@RequestBody Map<String, Object> reqMap) {
        RequsetData<String> res = new RequsetData<String>();
        int count = 0;
        String message = "";
        ObjectMapper mapper = new ObjectMapper();

        try {
            DjTask dataModel = mapper.readValue(mapper.writeValueAsString(reqMap.get("dataModel")).toString(), DjTask.class);
            List<DjTaskusers> userList = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<List<DjTaskusers>>() {
            });
            List<QtTaskpubcolumn> columnList =
            JsonMapper.jsonToObject(reqMap.get("columnList").toString(), new TypeReference<List<QtTaskpubcolumn>>() {
            });
            String flowId = reqMap.get("flowId").toString();

            count = partyTwoService.saveTask(dataModel, userList, columnList,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;
    }

    @RequestMapping(value = "/exportTask", method = RequestMethod.GET)
    public void exportTask(HttpServletResponse response,
                           @RequestParam(required = false) String username,
                           @RequestParam(required = false) String taskUser,
                           @RequestParam(required = false) String taskName,
                           @RequestParam(required = false) String beginTime,
                           @RequestParam(required = false) String endTime,
                           @RequestParam(required = false) String userid,
                           @RequestParam(required = false) String day) throws Exception {


        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getTaskList(1, 9999, username, taskUser, taskName, beginTime, endTime, day, userid,null).getList();

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

        //列名
        data.setName("通知信息");
        List<String> titles = new ArrayList();
        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("TASKNAME"));
            row.add(item.get("USERNAME"));
            row.add(dateUtils.strFormat_long(item.get("TASKTIME").toString()));
            row.add(dateUtils.strFormat_long(item.get("ENDTIME").toString()));
            row.add(item.get("SENDDEPART"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "任务信息.xlsx", data);
    }

    @ResponseBody
    @GetMapping("/delTask")
    public RequsetData<Integer> delTask(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delTask(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }
    @ResponseBody
    @GetMapping("/taskterminate")
    public RequsetData<Integer> taskterminate(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.terminateTask(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("终止失败！");
        } else {
            result.setMsg("终止成功！");
        }
        return result;
    }
    @ResponseBody
    @GetMapping("/getPartyTotalInfo")
    public RequsetData<HashMap<String, Object>> getPartyTotalInfo(@RequestParam("dzzdm") String dzzdm, @RequestParam("yearMonth") String yearMonth, @RequestParam("year") String year) {
        RequsetData<HashMap<String, Object>> result = new RequsetData<>();
        result.setItem(partyTwoService.getPartyTotalInfo(dzzdm, yearMonth, year));
        return result;
    }

    @ResponseBody
    @GetMapping("/getfundsBudgetList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getfundsBudgetList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                             @RequestParam(required = false) String dzzmc,
                                                                             @RequestParam(required = false) String dzzdm,
                                                                             @RequestParam(required = false) Integer year) {

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getfundsBudgetList(pageIndex, pageSize, dzzdm, dzzmc, year));
        return result;
    }

    @ResponseBody
    @RequestMapping("/getfundsBudget")
    public RequsetData<DjFundsbudget> getfundsBudget(@RequestParam("id") String id, @RequestParam("dzzdm") String dzzdm, @RequestParam("dzzmc") String dzzmc) {
        RequsetData<DjFundsbudget> res = new RequsetData<>();

        DjFundsbudget model = partyTwoService.getfundsBudget(id);
        Map<String, Object> map = new HashMap<>(10);
        if (model == null) {
            UUID uuid = UUID.randomUUID();
            model = new DjFundsbudget();
            model.setFundsbudgetid(uuid.toString());
            model.setPartycode(dzzdm);
            map.put("dzzmc", dzzmc);
        } else {
            map.put("dzzmc", partyService.getPartyByDm(dzzdm).getDzzmc());
        }
        res.setItem(model);
        res.setExtdata(map);
        return res;
    }

    @ResponseBody
    @RequestMapping("/savefundsBudget")
    public RequsetData<String> savefundsBudget(@RequestBody DjFundsbudget model) {

        RequsetData<String> res = partyTwoService.savefundsBudget(model);

        return res;
    }

    @ResponseBody
    @GetMapping("/delfundsBudget")
    public RequsetData<Integer> delfundsBudget(@RequestParam("id") String id) {

        RequsetData<Integer> result = new RequsetData<>();
        int row = partyTwoService.delfundsBudget(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @RequestMapping(value = "/exportfundsBudget", method = RequestMethod.GET)
    public void exportfundsBudget(HttpServletResponse response,
                                  @RequestParam(required = false) String dzzmc,
                                  @RequestParam(required = false) String dzzdm,
                                  @RequestParam(required = false) Integer year) throws Exception {


        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getfundsBudgetList(1, 100000, dzzdm, dzzmc, year).getList();

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

        //列名
        data.setName("党组织工作经费预算信息");
        List<String> titles = new ArrayList();
        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("DZZMC"));
            row.add(item.get("YEAR"));
            row.add(item.get("BUDGETFUNDS"));
            row.add(item.get("ACTIVITYFUNDS"));
            row.add(item.get("REWARDFUNDS"));
            row.add(item.get("ACTUALEXPEND"));
            row.add(item.get("GRDATION"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党组织工作经费预算信息.xlsx", data);
    }

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

        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getZtdrSummary(pageIndex, pageSize, dzzdm, year));
        return result;
    }

    @RequestMapping(value = "/exportZtdrSummary", method = RequestMethod.GET)
    public void exportZtdrSummary(HttpServletResponse response,
                                  @RequestParam(required = false) String dzzmc,
                                  @RequestParam(required = false) String dzzdm,
                                  @RequestParam(required = false) Integer year) throws Exception {


        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getZtdrSummary(1, 100000, dzzdm, year).getList();

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

        //列名
        data.setName("党内生活统计信息");
        List<String> titles = new ArrayList();
        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("DZZMC"));
            row.add(item.get("YEAR"));
            row.add(item.get("党员大会"));
            row.add(item.get("支委会"));
            row.add(item.get("党小组会"));
            row.add(item.get("党课"));
            row.add(item.get("主题党日"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "党内生活统计信息.xlsx", data);
    }

    @ResponseBody
    @GetMapping("/getMzpyjgList")
    public RequsetData<List<HashMap<String, Object>>> getMzpyjgList() {
        RequsetData<List<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getMzpyjgList());
        return result;
    }

    @ResponseBody
    @GetMapping("/getMzpybhgclqkList")
    public RequsetData<List<HashMap<String, Object>>> getMzpybhgclqkList() {
        RequsetData<List<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getMzpybhgclqkList());
        return result;
    }

    @ResponseBody
    @GetMapping("/getMzpyxxList")
    public RequsetData<PageInfo<HashMap<String, Object>>> getMzpyxxList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,
                                                                        @RequestParam(required = false) String rybm,
                                                                        @RequestParam(required = false) String dzzdm,
                                                                        @RequestParam(required = false) String username,
                                                                        @RequestParam(required = false) String beginTime,
                                                                        @RequestParam(required = false) String endTime,
                                                                        @RequestParam(required = false) String pyjg) {
        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        RequsetData<PageInfo<HashMap<String, Object>>> result = new RequsetData<>();
        result.setItem(partyTwoService.getMzpyxxList(pageIndex, pageSize, username, rybm, dzzdm, beginTime, endTime, pyjg));
        return result;
    }

    @RequestMapping(value = "/exportMzpyxx", method = RequestMethod.GET)
    public void exportMzpyxx(HttpServletResponse response,
                             @RequestParam(required = false) String rybm,
                             @RequestParam(required = false) String dzzdm,
                             @RequestParam(required = false) String username,
                             @RequestParam(required = false) String beginTime,
                             @RequestParam(required = false) String endTime,
                             @RequestParam(required = false) String pyjg) throws Exception {

        beginTime = dateUtils.strFormat_short(beginTime);
        endTime = dateUtils.strFormat_short(endTime);
        /**查询数据**/
        List<HashMap<String, Object>> dataList = partyTwoService.getMzpyxxList(1, 9999, username, rybm, dzzdm, beginTime, endTime, pyjg).getList();

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

        //列名
        data.setName("民主评议信息");
        List<String> titles = new ArrayList();
        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("DZZMC"));
            row.add(item.get("XM"));
            row.add(item.get("KZPYRQ"));
            row.add(item.get("JSPYRQ"));
            row.add(item.get("PYJGMC"));
            rows.add(row);
        }
        data.setRows(rows);

        excelHelper.exportExcel(response, "民主评议信息集.xlsx", data);
    }

    @ResponseBody
    @GetMapping("/getMzpyById")
    public RequsetData<ZzMzpyxxVo> getMzpyById(@RequestParam(required = false) String id) {
        RequsetData<ZzMzpyxxVo> res = new RequsetData<>();

        ZzMzpyxxVo model = partyTwoService.getMzpyById(id);
        if (model == null || (model != null && stringUtils.IsNullOrEmpty(model.getMzpyxxbs()))) {
            UUID uuid = UUID.randomUUID();
            model = new ZzMzpyxxVo();
            model.setMzpyxxbs(uuid.toString());
        }

        res.setItem(model);
        return res;
    }

    @ResponseBody
    @PostMapping("/saveMzpy")
    public RequsetData<String> saveMzpy(@RequestBody ZzMzpyxxVo data) {
        RequsetData<String> res = new RequsetData<String>();

        int count = partyTwoService.saveMzpy(data);
        if (count > 0) {
            res.setSuccess(true);
            res.setMsg("保存成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("保存失败！");
        }
        return res;
    }

    @ResponseBody
    @GetMapping("/deleteMzpy")
    public RequsetData<Integer> deleteMzpy(String id) {
        RequsetData<Integer> result = new RequsetData<>();

        int row = partyTwoService.deleteMzpyById(id);
        result.setItem(row);
        if (row == 0) {
            result.setSuccess(false);
            result.setMsg("删除失败！");
        } else {
            result.setMsg("删除成功！");
        }
        return result;
    }

    @ResponseBody
    @RequestMapping("/importMzpy")
    public RequsetData<List<Map<String, Object>>> importMzpy(@RequestBody Map<String, Object> reqMap) {
        RequsetData<List<Map<String, Object>>> res = new RequsetData<>();
        List<Map<String, Object>> errorInfo = new ArrayList<>();
        String message = "";
        try {
            List<ZzMzpyxxVo> dataList = JsonMapper.jsonToObject(reqMap.get("mzpyList").toString(), new TypeReference<List<ZzMzpyxxVo>>() {
            });
            partyTwoService.importMzpy(dataList);
        } catch (Exception e) {
            e.printStackTrace();
            message = e.toString();
        }
        if (errorInfo.size() <= 0 && stringUtils.IsNullOrEmpty(message)) {
            res.setSuccess(true);
            res.setMsg("操作成功！");
        } else {
            res.setSuccess(false);
            res.setMsg("操作失败！" + message);
            res.setItem(errorInfo);
        }
        return res;
    }

    @ResponseBody
    @GetMapping("/getMzpyTotalList")
    public RequsetData<List<HashMap<String, Object>> > getMzpyTotalList(@RequestParam(required = false) String dzzdm) {
        RequsetData<List<HashMap<String, Object>> > result = new RequsetData<>();
        result.setItem(partyTwoService.getMzpyTotalList(dzzdm));
        return result;
    }

    @ResponseBody
    @GetMapping("/getleaderUserList")
    public RequsetData<PageInfo<HashMap<String, Object>> > getleaderUserList(@RequestParam("pageindex") int pageIndex, @RequestParam("pagesize") int pageSize,@RequestParam(required = false) String username,@RequestParam(required = false) Integer usertype) {
        RequsetData<PageInfo<HashMap<String, Object>> > result = new RequsetData<>();
        result.setItem(partyTwoService.getleaderUserList(pageIndex,pageSize,username,usertype));
        return result;
    }
    @ResponseBody
    @RequestMapping("/importDnghbf")
    public RequsetData<List<Map<String, Object>>> importDnghbf(HttpServletResponse response,@RequestBody Map<String, Object> reqMap) {
        ArrayList<Map<String, Object>> dnghbflist = JsonMapper.jsonToObject(reqMap.get("userList").toString(), new TypeReference<ArrayList<Map<String, Object>>>() {
        });
        RequsetData<List<Map<String, Object>>> result = new RequsetData<>();
        try {
            List<Map<String, Object>> errorInfo = partyTwoService.importDnghbf(dnghbflist);
            if (errorInfo.size() == 0) {
                result.setSuccess(true);
                result.setMsg("导入成功。");
            } else {
                result.setSuccess(false);
                result.setMsg("导入失败，详情请下载错误提示文件查看。");
                result.setItem(errorInfo);
            }
        } catch (Exception ex) {
            result.setSuccess(false);
            result.setMsg("导入失败，" + ex.getMessage());
        }
        return result;
    }
}