package cn.com.goldenwater.dcproj.controller.importex;

import cn.com.goldenwater.core.web.BaseController;
import cn.com.goldenwater.core.web.BaseResponse;
import cn.com.goldenwater.dcproj.dto.*;
import cn.com.goldenwater.dcproj.model.*;
import cn.com.goldenwater.dcproj.param.BriefReportParam;
import cn.com.goldenwater.dcproj.service.BriefReportService;
import cn.com.goldenwater.dcproj.service.OlBisInspOrgService;
import cn.com.goldenwater.dcproj.utils.WordUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * @author xuw
 * @date 2019-03-11
 */
@Api(value = "督查简报管理", tags = "督查简报管理")
@RestController
@RequestMapping("/dc/brief/report")
public class BriefReportController extends BaseController {

    private Logger logger = LoggerFactory.getLogger(getClass());

    @Autowired
    private BriefReportService briefReportService;
    @Autowired
    private OlBisInspOrgService olBisInspOrgService;
    @ApiOperation(value = "01获取所有水利督查信息（督查组、人员、省份）")
    @RequestMapping(value = "/getGroupPersPro", method = RequestMethod.GET)
    public BaseResponse<Map<String, Object>> getGroupPersPro() {
        Map<String, Object> map = briefReportService.getGroupPersPro(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "02根据时间获取问题信息（新增问题、累计问题、整改问题、整改率）")
    @RequestMapping(value = "/getPblmCount", method = RequestMethod.POST)
    public BaseResponse<Map<String, Object>> getPblmCount(@ApiParam(value = "新增开始时间（YYYY-MM-DD）", name = "sttm", required = false) @RequestParam(name = "sttm", required = false) String sttm,
                                                          @ApiParam(value = "新增结束时间（YYYY-MM-DD）", name = "entm", required = false) @RequestParam(name = "entm", required = false) String entm,
                                                          @ApiParam(value = "整改开始时间（YYYY-MM-DD）", name = "gsttm", required = false) @RequestParam(name = "gsttm", required = false) String gsttm,
                                                          @ApiParam(value = "整改结束时间（YYYY-MM-DD）", name = "gentm", required = false) @RequestParam(name = "gentm", required = false) String gentm) {
        Map<String, Object> map = briefReportService.getPblmCount(sttm, entm, gsttm, gentm,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "03根据时间获取各类问题统计")
    @RequestMapping(value = "/getAddPblmCount", method = RequestMethod.POST)
    public BaseResponse<Map<String, Object>> getAddPblmCount(@ApiParam(value = "新增开始时间（YYYY-MM-DD）", name = "sttm", required = false) @RequestParam(name = "sttm", required = false) String sttm,
                                                             @ApiParam(value = "新增结束时间（YYYY-MM-DD）", name = "entm", required = false) @RequestParam(name = "entm", required = false) String entm) {
        Map<String, Object> map = briefReportService.getAddPblmCount(sttm, entm,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "04根据时间和类型获取各类问题统计数量")
    @RequestMapping(value = "/getPblmCountByType", method = RequestMethod.POST)
    public BaseResponse<Map<String, Object>> getPblmCountByType(@ApiParam(value = "新增开始时间（YYYY-MM-DD）", name = "sttm", required = false) @RequestParam(name = "sttm", required = false) String sttm,
                                                                @ApiParam(value = "新增结束时间（YYYY-MM-DD）", name = "entm", required = false) @RequestParam(name = "entm", required = false) String entm,
                                                                @ApiParam(value = "类型（1:小水库,2:人饮,3:水毁）", name = "objType", required = false) @RequestParam(name = "objType", required = false) String objType) {
        Map<String, Object> map = briefReportService.getPblmCountByType(sttm, entm, objType,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "05获取小水库督查信息")
    @RequestMapping(value = "/getRsvrInfo", method = RequestMethod.GET)
    public BaseResponse<Map<String, Object>> getRsvrInfo() {
        Map<String, Object> map = briefReportService.getRsvrInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "06获取人饮督查信息")
    @RequestMapping(value = "/getVillInfo", method = RequestMethod.GET)
    public BaseResponse<Map<String, Object>> getVillInfo() {
        Map<String, Object> map = briefReportService.getVillInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "07获取水毁督查信息")
    @RequestMapping(value = "/getRectInfo", method = RequestMethod.GET)
    public BaseResponse<Map<String, Object>> getRectInfo() {
        Map<String, Object> map = briefReportService.getRectInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(map);
    }

    @ApiOperation(value = "08根据条件获取问题列表")
    @RequestMapping(value = "/getPblmList", method = RequestMethod.POST)
    public BaseResponse<List<Map<String, Object>>> getPblmList(@ApiParam(value = "开始时间（YYYY-MM-DD）sttm", name = "sttm", required = false) @RequestParam(name = "sttm", required = false) String sttm,
                                                               @ApiParam(value = "结束时间（YYYY-MM-DD）", name = "entm", required = false) @RequestParam(name = "entm", required = false) String entm,
                                                               @ApiParam(value = "问题严重程度（0:一般;1:较重;2:严重；3特别严重）", name = "cate", required = false) @RequestParam(name = "cate", required = false) String cate,
                                                               @ApiParam(value = "督查对象类型（1:小水库;2:人饮;3:水毁）", name = "objType", required = false) @RequestParam(name = "objType", required = false) String objType,
                                                               @ApiParam(value = "问题状态（0:暂存;1:上报;2:审核;3:审办;4:整改通知;5:整改反馈;6:销号;9:删除）", name = "stat", required = false) @RequestParam(name = "stat", required = false) String stat,
                                                               @ApiParam(value = "是否典型（0:否,1:是）", name = "ifCase", required = false) @RequestParam(name = "ifCase", required = false) String ifCase,
                                                               @ApiParam(value = "问题类型（0:小水库;1:行政村;2:水源地;3:农饮工程;4:水毁）", name = "villType", required = false) @RequestParam(name = "villType", required = false) String villType) {
        List<Map<String, Object>> list = briefReportService.getPblmList(sttm, entm, cate, objType, stat, ifCase, villType,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "09导出督查简报Word文档")
    @RequestMapping(value = "exportWord", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public void exportWord(HttpServletRequest request, HttpServletResponse response,
                           @ApiParam(value = "开始时间（YYYY-MM-DD）sttm", name = "sttm", required = false) @RequestParam String sttm,
                           @ApiParam(value = "结束时间（YYYY-MM-DD）", name = "entm", required = false) @RequestParam String entm) throws Exception {
        //获得数据，系统相关，就不展示了
        Map<String, Object> data = new HashMap<>();
        if (StringUtils.isBlank(entm)) {
            entm = request.getParameter("entm");
        }
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        String year = entm.substring(0, entm.indexOf("-"));
        String mnth = entm.substring(entm.indexOf("-") + 1, entm.lastIndexOf("-"));
        String day = entm.substring(entm.lastIndexOf("-") + 1);
        data.put("year", year);
        data.put("mnth", mnth);
        data.put("day", day);
        String stYear = sttm.substring(0, sttm.indexOf("-"));
        String stMnth = sttm.substring(sttm.indexOf("-") + 1, entm.lastIndexOf("-"));
        String stDay = sttm.substring(sttm.lastIndexOf("-") + 1);
        data.put("stYear", stYear);
        data.put("stMnth", stMnth);
        data.put("stDay", stDay);

        data.put("addMnth", mnth);
        data.put("addDay", day);
        data.put("alterMnth", mnth);
        data.put("alterDay", day);
        Calendar calll = Calendar.getInstance();
        calll.set(Calendar.YEAR, Integer.parseInt(year));
        calll.set(Calendar.MONTH, Integer.parseInt(mnth) - 1);
        calll.set(Calendar.DAY_OF_MONTH, Integer.parseInt(day));
        calll.add(Calendar.DAY_OF_MONTH, 1);
        Date date = calll.getTime();
        entm = sdf.format(date);

        Map<String, Object> map = briefReportService.getGroupPersPro(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("groupSum", map.get("groupNum"));
        data.put("persSum", map.get("persNum"));
        data.put("proSum", map.get("proNum"));

        map = new HashMap<>(4);
        map = briefReportService.getPblmCount(sttm, entm, sttm, entm,olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("addPblmSum", map.get("addNum"));
        data.put("pblmSum", map.get("countNum"));

        data.put("alterPblmSum", map.get("gNum"));
        data.put("alterPblmRate", map.get("gRate"));
        map = new HashMap<>(5);
        map = briefReportService.getAddPblmCount(sttm, entm,olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("addPblmSum", map.get("addSum"));
        data.put("addPblmOne", map.get("ySum"));
        data.put("addPblmVill", map.get("villNum"));
        data.put("addPblmRsvr", map.get("rsvrNum"));
        data.put("addPblmRect", map.get("rectNum"));
        map = new HashMap<>(6);
        map = briefReportService.getVillInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("groupSumVill", map.get("groupNum"));
        data.put("persSumVill", map.get("persNum"));
        data.put("proSumVill", map.get("proNum"));
        data.put("countrySumVill", map.get("countyNum"));
        data.put("villSumVill", map.get("villNum"));
        data.put("waterUserSum", map.get("wUserNum"));
        map = new HashMap<>(4);
        map = briefReportService.getPblmCountByType(sttm, entm, "2",olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("pblmSumVill", map.get("num"));
        data.put("pblmSumVillOne", map.get("num3"));
        data.put("pblmSumVillTwo", map.get("num2"));
        data.put("pblmSumVillThree", map.get("num1"));
        map = new HashMap<>(6);
        map = briefReportService.getRsvrInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("groupSumRsvr", map.get("groupNum"));
        data.put("persSumRsvr", map.get("persNum"));
        data.put("proSumRsvr", map.get("proNum"));
        data.put("rsvrSum", map.get("rsvrNum"));
        data.put("rsvrSumOne", map.get("rsvrNum1"));
        data.put("rsvrSumTwo", map.get("rsvrNum2"));
        map = new HashMap<>(4);
        map = briefReportService.getPblmCountByType(sttm, entm, "1",olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("pblmSumRsvr", map.get("num"));
        data.put("pblmSumRsvrOne", map.get("num3"));
        data.put("pblmSumRsvrTwo", map.get("num2"));
        data.put("pblmSumRsvrThree", map.get("num1"));
        map = new HashMap<>(3);
        map = briefReportService.getRectInfo(getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("groupSumRect", map.get("groupNum"));
        data.put("persSumRect", map.get("persNum"));
        data.put("proSumRect", map.get("proNum"));
        map = new HashMap<>(4);
        map = briefReportService.getPblmCountByType(sttm, entm, "3",olBisInspOrgService.getProvince(getCurrentOrgId()));
        data.put("pblmSumRect", map.get("num"));
        data.put("pblmSumRectOne", map.get("num3"));
        data.put("pblmSumRectTwo", map.get("num2"));
        data.put("pblmSumRectThree", map.get("num1"));
        WordUtils.exportMillCertificateWord(request, response, data);
    }

    @ApiOperation(value = "10单位分类统计--查询和导出人饮督查工作情况统计表")
    @RequestMapping(value = "getVillWork", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<VillWork>> getVillWork(HttpServletResponse response,
                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<VillWork> list = briefReportService.getVillWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "11单位分类统计--查询和导出小水库督查工作情况统计表")
    @RequestMapping(value = "getRsvrWork", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<RsvrWork>> getRsvrWork(HttpServletResponse response,
                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<RsvrWork> list = briefReportService.getRsvrWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "单位分类统计--查询和导出172重点工程建设督查工作情况统计表")
    @RequestMapping(value = "getEmpwtConWork", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<EmpwtConWork>> getEmpwtConWork(HttpServletResponse response,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<EmpwtConWork> list = briefReportService.getEmpwtConWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "单位分类统计--查询和导出172重点工程运行督查工作情况统计表")
    @RequestMapping(value = "getEmpwtRunWork", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<EmpwtRunWork>> getEmpwtRunWork(HttpServletResponse response,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<EmpwtRunWork> list = briefReportService.getEmpwtRunWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "单位分类统计--查询和导出水闸督查工作情况统计表")
    @RequestMapping(value = "getWagaWork", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<WagaWork>> getWagaWork(HttpServletResponse response,
                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<WagaWork> list = briefReportService.getWagaWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "12单位分类统计--查询和导出水毁督查工作情况统计表")
    @RequestMapping(value = "getRectWork", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<RectWork>> getRectWork(HttpServletResponse response,
                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<RectWork> list = briefReportService.getRectWork(response, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "13单位分类统计--查询和导出所有分类的督查工作情况统计表(流域机构合计)")
    @RequestMapping(value = "getVillRsvrRectWork", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<BriefWork>> getVillRsvrRectWork(HttpServletResponse response,
                                                             @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                             @ApiParam(value = "分类名称(模糊查询)", name = "typeName", required = false) @RequestParam(required = false) String typeName,
                                                             @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                             @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                             @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                             @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<BriefWork> list = briefReportService.getVillRsvrRectWork(response, orgName, typeName, isExport, sttm, entm, state,getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "14省+单位统计--查询和导出小水库的督查工作情况统计表")
    @RequestMapping(value = "getRsvrWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<RsvrWork>> getRsvrWorkByOrgPro(HttpServletResponse response,
                                                            @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                            @ApiParam(value = "人员id", name = "persid", required = false) @RequestParam(required = false) String persid,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<RsvrWork> list = briefReportService.getRsvrWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, persid, state,olBisInspOrgService.getProvince(getCurrentOrgId()));

        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "省+单位统计--查询和导出172重点工程建设的督查工作情况统计表")
    @RequestMapping(value = "getEmpwtConWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<EmpwtConWork>> getEmpwtConWorkByOrgPro(HttpServletResponse response,
                                                                    @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                                    @ApiParam(value = "人员id", name = "persid", required = false) @RequestParam(required = false) String persid,
                                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<EmpwtConWork> list = briefReportService.getEmpwtConWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, persid, state,olBisInspOrgService.getProvince(getCurrentOrgId()));

        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "省+单位统计--查询和导出172重点工程运行的督查工作情况统计表")
    @RequestMapping(value = "getEmpwtRunWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<EmpwtRunWork>> getEmpwtRunWorkByOrgPro(HttpServletResponse response,
                                                                    @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                                    @ApiParam(value = "人员id", name = "persid", required = false) @RequestParam(required = false) String persid,
                                                                    @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                                    @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                                    @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                                    @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                                    @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<EmpwtRunWork> list = briefReportService.getEmpwtRunWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, persid, state,olBisInspOrgService.getProvince(getCurrentOrgId()));

        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "省+单位统计--查询和导出水闸的督查工作情况统计表")
    @RequestMapping(value = "getWagaWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    public BaseResponse<List<WagaWork>> getWagaWorkByOrgPro(HttpServletResponse response,
                                                            @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                            @ApiParam(value = "人员id", name = "persid", required = false) @RequestParam(required = false) String persid,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<WagaWork> list = briefReportService.getWagaWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, persid, state,olBisInspOrgService.getProvince(getCurrentOrgId()));

        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "APP 小水库问题统计,手机app统计专用")
    @RequestMapping(value = "getRsvrWorkByOrgProApp", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<RsvrWork>> getRsvrWorkByOrgProApp(HttpServletResponse response,
                                                               @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                               @ApiParam(value = "人员id", name = "persid", required = false) @RequestParam(required = false) String persid,
                                                               @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                               @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                               @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                               @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<RsvrWork> list = briefReportService.getRsvrWorkByOrgPro(response, adName, orgName, "0", sttm, entm, persid, "",olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<String> nmes = new ArrayList<>();
        for (RsvrWork rsvrWork : list) {
            if (org.apache.commons.lang3.StringUtils.isBlank(rsvrWork.getNm())) {
                continue;
            }
            if (!nmes.contains(rsvrWork.getNm())) {
                nmes.add(rsvrWork.getNm());
            }
        }
        List<RsvrWork> workList = new ArrayList<>();
        int revrOne;
        int revrTwo;
        int pblmOne;
        int pblmTwo;
        int pblmThree;
        int pblmFour;
        for (String nm : nmes) {
            RsvrWork rsvr = new RsvrWork();
            rsvr.setNm(nm);
            rsvr.setAdName(nm);
            revrOne = 0;
            revrTwo = 0;
            pblmOne = 0;
            pblmTwo = 0;
            pblmThree = 0;
            pblmFour = 0;
            for (RsvrWork rsvrWork : list) {
                if (nm.equals(rsvrWork.getNm())) {
                    revrOne += rsvrWork.getRsvrOne();
                    revrTwo += rsvrWork.getRsvrTwo();
                    pblmOne += rsvrWork.getPblmOne();
                    pblmTwo += rsvrWork.getPblmTwo();
                    pblmThree += rsvrWork.getPblmThree();
                    pblmFour += rsvrWork.getPblmFour();

                }
            }
            rsvr.setRsvrOne(revrOne);
            rsvr.setRsvrTwo(revrTwo);
            rsvr.setPblmOne(pblmOne);
            rsvr.setPblmTwo(pblmTwo);
            rsvr.setPblmThree(pblmThree);
            rsvr.setPblmFour(pblmFour);
            rsvr.setPblm(pblmOne + pblmTwo + pblmThree + pblmFour);
            workList.add(rsvr);
        }
        return buildSuccessResponse(workList);
    }

    @ApiOperation(value = "15省+单位统计--查询和导出农饮的督查工作情况统计表")
    @RequestMapping(value = "getVillWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<VillWork>> getVillWorkByOrgPro(HttpServletResponse response,
                                                            @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<VillWork> list = briefReportService.getVillWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "16省+单位统计--查询和导出水毁的督查工作情况统计表")
    @RequestMapping(value = "getRectWorkByOrgPro", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<RectWork>> getRectWorkByOrgPro(HttpServletResponse response,
                                                            @ApiParam(value = "省份名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                            @ApiParam(value = "单位名称(模糊查询)", name = "orgName", required = false) @RequestParam(required = false) String orgName,
                                                            @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                            @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                            @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                            @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<RectWork> list = briefReportService.getRectWorkByOrgPro(response, adName, orgName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "17省+分类统计--查询和导出所有分类的督查工作情况统计表（行政区合计）")
    @RequestMapping(value = "getVillRsvrRectWorkByPro", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public BaseResponse<List<BriefWork>> getVillRsvrRectWorkByPro(HttpServletResponse response,
                                                                  @ApiParam(value = "单位名称(模糊查询)", name = "adName", required = false) @RequestParam(required = false) String adName,
                                                                  @ApiParam(value = "分类名称(模糊查询)", name = "typeName", required = false) @RequestParam(required = false) String typeName,
                                                                  @ApiParam(value = "开始时间", name = "sttm", required = false) @RequestParam(required = false) String sttm,
                                                                  @ApiParam(value = "结束时间", name = "entm", required = false) @RequestParam(required = false) String entm,
                                                                  @ApiParam(value = "督查状态", name = "state", required = false) @RequestParam(required = false) String state,
                                                                  @ApiParam(value = "是否导出(1:是，传其他是查询)", name = "isExport", required = false) @RequestParam(required = false) String isExport) {
        List<BriefWork> list = briefReportService.getVillRsvrRectWorkByPro(response, adName, typeName, isExport, sttm, entm, state,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（农饮）")
    @RequestMapping(value = "getRiverSupervisionCwsCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionCwsCount>> getRiverSupervisionCwsCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<RiverSupervisionCwsCount> list = briefReportService.getRiverSupervisionCwsCount(response, briefReportParam);
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（水库）")
    @RequestMapping(value = "getRiverSupervisionRivCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionRivCount>> getRiverSupervisionRivCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<RiverSupervisionRivCount> list = briefReportService.getRiverSupervisionRivCount(response, briefReportParam);
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（172重点工程建设）")
    @RequestMapping(value = "getRiverSupervisionEmpwtConCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionEmpwtCount>> getRiverSupervisionEmpwtConCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionEmpwtCount> list = briefReportService.getRiverSupervisionEmpwtConCount(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（172重点工程运行）")
    @RequestMapping(value = "getRiverSupervisionEmpwtRunCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionEmpwtCount>> getRiverSupervisionEmpwtRunCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionEmpwtCount> list = briefReportService.getRiverSupervisionEmpwtRunCount(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（水闸）")
    @RequestMapping(value = "getRiverSupervisionWagaCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionWagaCount>> getRiverSupervisionWagaCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionWagaCount> list = briefReportService.getRiverSupervisionWagaCount(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "流域督查统计（水毁）")
    @RequestMapping(value = "getRiverSupervisionWtdCount", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionWtdCount>> getRiverSupervisionWtdCount(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionWtdCount> list = briefReportService.getRiverSupervisionWtdCount(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()),getCurrentOrgId());
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取流域节点")
    @RequestMapping(value = "getRiverNode", method = RequestMethod.GET)
    public BaseResponse<List<RiverNode>> getRiverNode(@RequestParam String type) {
        List<RiverNode> list = briefReportService.getRiverNode(type,getCurrentOrgId(),olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（水库）")
    @RequestMapping(value = "getRiverPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionRivCount>> getRiverPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionRivCount> list = briefReportService.getRiverPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（人饮）")
    @RequestMapping(value = "getCwsPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionCwsCount>> getCwsPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionCwsCount> list = briefReportService.getCwsPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（水毁）")
    @RequestMapping(value = "getWtdstPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionWtdCount>> getWtdstPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionWtdCount> list = briefReportService.getWtdstPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（172重点工程建设）")
    @RequestMapping(value = "getEmpwtConPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionEmpwtCount>> getEmpwtConPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionEmpwtCount> list = briefReportService.getEmpwtConPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（172重点工程运行）")
    @RequestMapping(value = "getEmpwtRunPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionEmpwtCount>> getEmpwtRunPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionEmpwtCount> list = briefReportService.getEmpwtRunPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员业绩统计（水闸）")
    @RequestMapping(value = "getWagaPersAchive", method = RequestMethod.GET)
    public BaseResponse<List<RiverSupervisionWagaCount>> getWagaPersAchive(HttpServletResponse response, BriefReportParam briefReportParam) {
        List<RiverSupervisionWagaCount> list = briefReportService.getWagaPersAchive(response, briefReportParam,olBisInspOrgService.getProvince(getCurrentOrgId()));
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取行政区划 + 工作统计")
    @RequestMapping(value = "getWorkByObjType", method = RequestMethod.GET)
    public BaseResponse<List<BriefReportWorkDto>> getWorkByObjType(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<BriefReportWorkDto> list = briefReportService.getWorkByObjType(response, briefReportParam);
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取流域机构 + 工作统计")
    @RequestMapping(value = "getOrgWorkByObjType", method = RequestMethod.GET)
    public BaseResponse<List<BriefReportWorkDto>> getOrgWorkByObjType(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<BriefReportWorkDto> list = briefReportService.getOrgWorkByObjType(response, briefReportParam);
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取督查组 + 工作统计")
    @RequestMapping(value = "getGroupWorkByObjType", method = RequestMethod.GET)
    public BaseResponse<List<BriefReportWorkDto>> getGroupWorkByObjType(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<BriefReportWorkDto> list = briefReportService.getGroupWorkByObjType(response, briefReportParam);
        return buildSuccessResponse(list);
    }

    @ApiOperation(value = "获取人员统计 + 工作统计")
    @RequestMapping(value = "getPersWorkByObjType", method = RequestMethod.GET)
    public BaseResponse<List<BriefReportWorkDto>> getPersWorkByObjType(HttpServletResponse response, BriefReportParam briefReportParam) {
        briefReportParam.setProvince(olBisInspOrgService.getProvince(getCurrentOrgId()));
        List<BriefReportWorkDto> list = briefReportService.getPersWorkByObjType(response, briefReportParam);
        return buildSuccessResponse(list);
    }
}