fj-dc/.svn/pristine/df/dffd43ce4278e3e7d76b7ad0fbcb71e1c43eed44.svn-base

package cn.com.goldenwater.dcproj.utils.export;

import cn.com.goldenwater.dcproj.dao.AttAdBaseDao;
import cn.com.goldenwater.dcproj.dao.AttAdXBaseDao;
import cn.com.goldenwater.dcproj.dao.AttCwsBaseDao;
import cn.com.goldenwater.dcproj.dto.BisInspRsvrRgstrPcDto;
import cn.com.goldenwater.dcproj.dto.BisInspRsvrRgstrPcDtoVo;
import cn.com.goldenwater.dcproj.dto.BisInspWtdstDetailDto;
import cn.com.goldenwater.dcproj.model.*;
import cn.com.goldenwater.dcproj.param.AttAdXBaseParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.util.*;

import static cn.com.goldenwater.dcproj.utils.export.ExcelSkFieldLists.*;
import static cn.com.goldenwater.dcproj.utils.export.FieldFormat.*;
import static cn.com.goldenwater.dcproj.utils.export.FieldFormatDispatch.getFormatValue;
import static cn.com.goldenwater.dcproj.utils.export.FieldFormatSkExp.*;

/**
 * @ClassName ExcelFieldUtil
 * @Description 配置Excel数据字段
 * @Author liyz
 * @Date 2019/3/13 9:58
 * @Version 1.0
 **/
@Component
public class ExcelFieldUtil {

    @Autowired
    private AttAdBaseDao attAdBaseDao;
    @Autowired
    private AttAdXBaseDao attAdXBaseDao;
    @Autowired
    private AttCwsBaseDao attCwsBaseDao;

    /**
     * 1.暗访调研行政村统计表
     *
     * @param list list
     * @return 数据集合
     */
    List<Map<String, Object>> getBisInspSecsurveyVlgDataList(List<BisInspSecsurveyVlg> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspSecsurveyVlg bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();
            AttAdXBaseParam attAdXBaseParam = new AttAdXBaseParam();
            if (bis.getVillageCode() != null && !"".equals(bis.getVillageCode())) {
                attAdXBaseParam.setAdCode(bis.getVillageCode());
                AttAdXBase attAdXBase = attAdXBaseDao.getBy(attAdXBaseParam);
                if (attAdXBase != null) {
                    map.put("adNm", formatCheckNull(attAdXBase.getAdFullName()));
                } else {
                    map.put("adNm", formatCheckNull(bis.getAdNm()));
                }
            } else {
                map.put("adNm", formatCheckNull(bis.getAdNm()));
            }

            map.put("isPoverty", formatRadio(bis.getIsPoverty()));
            map.put("isFluexc", formatRadio(bis.getIsFluexc()));
            map.put("isMtarea", formatRadio(bis.getIsMtarea()));
            map.put("isCenwtSupply", formatRadio(bis.getIsCenwtSupply()));
            map.put("watersupplyPer", formatRate(bis.getWatersupplyPer()));
            map.put("visitDate", bis.getVisitDate());
            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 2.村内农村饮水工程设施运行维护情况表
     *
     * @param list list
     * @return 数据集合
     */
    List<Map<String, Object>> getBisInspVlgdrinkFacOperDataList(List<BisInspVlgdrinkFacOper> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspVlgdrinkFacOper bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();
            AttAdXBaseParam attAdXBaseParam = new AttAdXBaseParam();
            attAdXBaseParam.setAdCode(bis.getAdCode());
            AttAdXBase attAdXBase = attAdXBaseDao.getBy(attAdXBaseParam);
            if (attAdXBase != null) {
                // 行政村名(*县*乡镇*村)
                map.put("adnm", formatCheckNull(attAdXBase.getAdFullName()));
            } else {
                map.put("adnm", formatCheckNull(bis.getAdnm()));
            }
            // 是否需要设置管水员
            map.put("isNdAdmin", formatIsAdmin(bis.getIsNdAdmin()));
            // 是否设置管水员
            map.put("isAdmin", formatIsAdmin(bis.getIsAdmin()));
            // 管水员姓名
            map.put("adminNm", formatCheckNull(bis.getAdminNm()));
            // 管水员年龄
            map.put("adminAge", formatCheckNull(bis.getAdminAge()));
            // 管水员性质
            map.put("adminPro", formateAdminPro(bis.getAdminPro()));
            // 管水员工资（元/年）
            map.put("salary", bis.getSalary());
            // 运行维护费用（元/年）
            map.put("operFee", bis.getOperFee());
            // 除水费收入外的运行维护费用来源
            map.put("otherFeeOrg", formateOtherFeeOrg(bis.getOtherFeeOrg()));
            // 费用说明
            map.put("feeCommons", bis.getFeeCommons());
            // 暗访日期
            map.put("visitDate", bis.getVisitDate());

            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 3.用水户情况表
     *
     * @param list list
     * @return 数据集合
     */
    public List<Map<String, Object>> getBisInspWateruserInfoDataList(List<BisInspWateruserInfo> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspWateruserInfo bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();
            // 调查地点（*县*乡镇*村）
            map.put("villageNm", formatCheckNull(bis.getVillageNm()));
            // 户主姓名
            map.put("userNm", formatCheckNull(bis.getUserNm()));
            // 电话
            map.put("telphone", formatCheckNull(bis.getTelphone()));
            // 对应工程名称
            map.put("cwsName", formatCheckNull(bis.getCwsName()));

            // -------------------------------------------------------------------
            // 水质
            // -------------------------------------------------------------------
            // 水质是否良好
            map.put("isQualityGood", formatRadio(bis.getIsQualityGood()));
            // 是否存在问题
            map.put("isQualityProblem", formatRadio(bis.getIsQualityProblem()));

            // 水量
            // 是否供水入户
            map.put("isSplyHome", formatRadio(bis.getIsSplyHome()));
            // 是否24小时供水
            map.put("is24hSupply", formatRadio(bis.getIs24hSupply()));
            // 是否存在问题
            map.put("isWaterProblem", formatRadio(bis.getWaterProblem()));

            // 水价收费
            // 是否计量收费
            map.put("isCalFee", formatRadio(bis.getIsCalFee()));
            // 是否存在问题
            map.put("isFeeProblem", formatRadio(bis.getFeeProblem()));

            // 供水服务
            // 是否存在问题
            map.put("isSplyProblem", formatRadio(bis.getIsSplyProblem()));
            // 总体评价
            map.put("evaluate", formatEvaluate(bis.getEvaluate()));

            // 暗访日期
            map.put("visitDate", formatCheckNull(bis.getVisitDate()));

            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 4.农村饮水工程运行管理情况表
     *
     * @param list list
     * @return 数据集合
     */
    public List<Map<String, Object>> getBisInspVlgdrinkProjManageDataList(List<BisInspVlgdrinkProjManage> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspVlgdrinkProjManage bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();
            // 省 市 县
            String province = "";
            String city = "";
            String county = "";
            String code = null;
            try {
                String cwsCode = bis.getCwsCode();
                AttCwsBase attCwsBase = attCwsBaseDao.get(cwsCode);
                if (attCwsBase != null) {
                    code = attCwsBase.getAddvcd();
                }
            } catch (Exception e) {
                System.out.println("编码不正常呀");
            }
            if (code != null) {
                province = attAdBaseDao.fingAdUp(code.substring(0, 2) + "0000000000").getAdName();
                city = attAdBaseDao.fingAdUp(code.substring(0, 4) + "00000000").getAdName();
                county = attAdBaseDao.fingAdUp(code.substring(0, 6) + "000000").getAdName();
            }
            map.put("province", formatCheckNull(province));
            map.put("city", formatCheckNull(city));
            map.put("county", formatCheckNull(county));

            // 工程名称
            map.put("pjnm", formatCheckNull(bis.getPjnm()));
            // 所在地
            map.put("villageNm", formatCheckNull(bis.getVillageNm()));
            // 建成年份
            map.put("buildYear", formatCheckNull(bis.getBuildYear()));
            // 设计供水规模(m³/d)
            map.put("planSupplyScale", formatCheckNull(bis.getPlanSupplyScale()));
            // 实际供水规模（m³/d)
            map.put("supplyScale", formatCheckNull(bis.getSupplyScale()));
            // 覆盖人口(万人)
            map.put("personNum", formatCheckNull(bis.getPersonNum()));
            // 管网漏损率（%）
            map.put("pipeDamagePer", formatRate(bis.getPipeDamagePer()));
            // 工程类别
            map.put("projectType", formatProjectType(bis.getProjectType()));
            // 是否24小时不间断供水
            map.put("is24hSupply", formatBoo(bis.getIs24hSupply()));

            // 水质保障
            // 净化设施设备
            // 是否配备
            map.put("isHavecleanEqui", formatBoo(bis.getIsHavecleanEqui()));
            // 是否正常运行
            map.put("isCleanequiG", formatBoo(bis.getIsCleanequiG()));

            // 消毒设备
            // 是否配备
            map.put("isHavedisinfect", formatBoo(bis.getIsHavedisinfect()));
            // 消毒方式
            map.put("disinfectType", formatDisinfectType(bis.getDisinfectType()));
            // 是否正常运行
            map.put("isDisinfectGood", formatBoo(bis.getIsDisinfectGood()));

            // 水质检测报告
            // 有无报告
            map.put("isHavereport", formatExistRadio(bis.getIsHavereport()));
            // 是否达标
            map.put("isQuailtyGood", formatBoo(bis.getIsQuailtyGood()));

            // 千吨万人水厂水质化验室
            // 是否配备
            map.put("isHaveLab", formatBoo(bis.getIsHaveLab()));
            // 是否开展日检
            map.put("isDailyCheck", formatBoo(bis.getIsDailyCheck()));
            // 水质是否达标
            map.put("isDailycheckGood", formatBoo(bis.getIsDailycheckGood()));

            // 运行管理
            // 有无取水许可证
            map.put("isInsLicence", formatExistRadio(bis.getIsInsLicence()));
            // 有无卫生许可证
            map.put("isSanLicence", formatExistRadio(bis.getIsSanLicence()));

            // 自动化控制系统
            // 是否配备
            map.put("isAutosystem", formatBoo(bis.getIsAutosystem()));
            // 是否正常运行
            map.put("isAutosysGood", formatBoo(bis.getIsAutosysGood()));

            // 视频安防系统
            // 是否配备
            map.put("isVideoSystem", formatBoo(bis.getIsVideoSystem()));
            // 是否正常运行
            map.put("isVideosysGood", formatBoo(bis.getIsVideosysGood()));

            // 水费水价
            // 执行水价（元/ m³）
            map.put("waterFee", formatCheckNull(bis.getWaterFee()));
            // 全成本（元/ m³）
            map.put("waterCost", formatCheckNull(bis.getWaterCost()));
            // 运行成本（元/ m³）
            map.put("operCost", formatCheckNull(bis.getOperCost()));
            // 水费回收率（%）
            map.put("feeRecyclePer", formatRate(bis.getFeeRecyclePer()));

            // 管理主体
            map.put("manager", formatManager(bis.getManager()));
            // 是否配备供水服务热线电话
            map.put("isHaveHotline", formatBoo(bis.getIsHaveHotline()));
            // 填报状态
            map.put("status", formatStatus(bis.getStatus()));
            // 暗访日期
            map.put("visitDate", formatCheckNull(bis.getVisitDate()));
            // 记录人员
            map.put("recPers2", formatCheckNull(bis.getRecPers2()));
            // 记录人员电话
            map.put("recPersTel", formatCheckNull(bis.getRecPersTel()));
            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 5.千人以上供水工程水源地保护情况表
     *
     * @param list list
     * @return 数据集合
     */
    public List<Map<String, Object>> getBisInspProSourceProtectDataList(List<BisInspProSourceProtect> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspProSourceProtect bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();
            map.put("waterSourceNm", bis.getWaterSourceNm());
            AttAdXBaseParam attAdXBaseParam = new AttAdXBaseParam();
            if (bis.getAdCode() != null && !"".equals(bis.getAdCode())) {
                attAdXBaseParam.setAdCode(bis.getAdCode());
                AttAdXBase attAdXBase = attAdXBaseDao.getBy(attAdXBaseParam);
                if (attAdXBase != null) {
                    map.put("villageNm", formatCheckNull(attAdXBase.getAdFullName()));
                } else {
                    map.put("villageNm", formatCheckNull(bis.getVillageNm()));
                }
            } else {
                map.put("villageNm", formatCheckNull(bis.getVillageNm()));
            }
            map.put("cwsCode", bis.getCwsCode());
            map.put("planInsAmount", bis.getPlanInsAmount());
            map.put("sourceType", formatSourceType(bis.getSourceType()));
            map.put("waterQuality", formatWaterQuality(bis.getWaterQuality()));
            map.put("isProtectArea", formatRadio(bis.getIsProtectArea()));
            map.put("isProtectMark", formatRadio(bis.getIsProtectMark()));
            map.put("isPollSource", formatRadio(bis.getIsPollSource()));
            map.put("isSpare", formatRadio(bis.getIsSpare()));
            map.put("visitDate", bis.getVisitDate());
            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 6.管理责任体系落实情况表
     *
     * @param list 原始数据
     * @return 封装好的数据
     */
    public List<Map<String, Object>> getBisInspManageResponsibilityDataList(List<BisInspManageResponsibility> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspManageResponsibility bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();

            // 省 市 县
            String province = "";
            String city = "";
            String county = "";
            String code = bis.getAdCode();
            if (code != null) {
                province = attAdBaseDao.fingAdUp(code.substring(0, 2) + "0000000000").getAdName();
                city = attAdBaseDao.fingAdUp(code.substring(0, 4) + "00000000").getAdName();
                county = attAdBaseDao.fingAdUp(code.substring(0, 6) + "000000").getAdName();
            }
            map.put("province", formatCheckNull(province));
            map.put("city", formatCheckNull(city));
            map.put("county", formatCheckNull(county));

            // 农村人口（万人）
            map.put("personAmount", formatCheckNull(bis.getPersonAmount()));
            // 集中供水率（%）
            map.put("focusSupplyPerc", formatRate(bis.getFocusSupplyPerc()));
            // 自来水普及率（%）
            map.put("waterSupplyPerc", formatRate(bis.getWaterSupplyPerc()));

            // 三个责任
            // 地方人民政府主体责任是否明确
            map.put("isGovRes", formatBoo(bis.getIsGovRes()));
            // 水利部门行业监管责任是否明确
            map.put("isConRes", formatBoo(bis.getIsConRes()));
            // 供水单位运行管理责任是否到位
            map.put("isDeptRes", formatBoo(bis.getIsDeptRes()));

            // 三项制度
            // 是否建立县级运行管理机构
            map.put("isCntyDept", formatBoo(bis.getIsCntyDept()));
            // 是否建立县级运行管理办法
            map.put("isCntyFunc", formatBoo(bis.getIsCntyFunc()));
            // 是否落实县级运行管理经费
            map.put("isCntyFee", formatBoo(bis.getIsCntyFee()));

            // 县级水质检测中心
            // 是否正常开展水质巡检
            map.put("isQuailtyChk", formatBoo(bis.getIsQuailtyChk()));
            // 2018年落实运行经费（万元）
            map.put("pracFee", formatCheckNull(bis.getPracFee()));

            // 暗访日期
            map.put("visitDate", formatCheckNull(bis.getVisitDate()));
            // 县级水行政主管部门参加人员
            map.put("accompany", formatCheckNull(bis.getAccompany()));
            // 暗访组（人）
            map.put("visitorIds", formatCheckNull(bis.getVisitorId()));
            // 记录人员
            map.put("recPers2", formatCheckNull(bis.getRecPers2()));
            // 记录人员电话
            map.put("recPersTel", formatCheckNull(bis.getRecPersTel()));
            // 填报状态
            map.put("status", formatBaseStat(bis.getStatus()));

            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 7.水毁修复项目暗访情况表
     *
     * @param list list
     * @return 数据集合
     */
    public List<Map<String, Object>> getBisInspWtdstDtoDataList(List<BisInspWtdstDetailDto> list) {
        List<Map<String, Object>> dataList = new ArrayList<>();
        for (BisInspWtdstDetailDto bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();

            String province = "";
            String city = "";
            String county = "";
            String code = bis.getLocAd();
            if (code != null) {
                province = attAdBaseDao.fingAdUp(code.substring(0, 2) + "0000000000").getAdName();
                city = attAdBaseDao.fingAdUp(code.substring(0, 4) + "00000000").getAdName();
                county = attAdBaseDao.fingAdUp(code.substring(0, 6) + "000000").getAdName();
            }
            map.put("province", formatCheckNull(province));
            map.put("city", formatCheckNull(city));
            map.put("county", formatCheckNull(county));
            map.put("wtdstNm", bis.getWtdstNm());
            map.put("locNm", bis.getLocNm());
            map.put("wtdstType", bis.getWtdstType());
            map.put("mangNm", bis.getMangNm());
            map.put("loac", bis.getLoac());
            map.put("disContent", bis.getDisContent());
            map.put("wkstate", formatWkstate(bis.getWkstate()));
            map.put("planTm", bis.getPlanTm());
            map.put("problmNum", bis.getProblmNum());
            map.put("adNm", bis.getAdNm());
            map.put("note", bis.getNote());
            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 8.小水库督查情况
     *
     * @param list list
     * @return 数据集合
     */
    public List<Map<String, Object>> getBisInspRsvrRgstrPcDtoDataList(List<BisInspRsvrRgstrPcDtoVo> list) {
        List<Map<String, Object>> dataList = new LinkedList<>();
        for (BisInspRsvrRgstrPcDtoVo bis : list) {
            Map<String, Object> map = new LinkedHashMap<>();

            BisInspRsvrRgstrPcDto bisInspRsvrRgstrPcDto = bis.getBisInspRsvrRgstrPcDto();
            map.put("nm", formatCheckNull(bisInspRsvrRgstrPcDto.getNm()));
            map.put("rsCode", formatCheckNull(bisInspRsvrRgstrPcDto.getCode()));
            // 组长名称
            map.put("groupLeader", formatCheckNull(bisInspRsvrRgstrPcDto.getGroupLeader()));
            // 组长电话
            map.put("groupLeaderTel", formatCheckNull(bisInspRsvrRgstrPcDto.getGroupLeader()));
            // 联络员电话
            map.put("liaisonManTel", formatCheckNull(bisInspRsvrRgstrPcDto.getLiaisonManTel()));
            // 联络员
            map.put("liaisonMan", formatCheckNull(bisInspRsvrRgstrPcDto.getLiaisonMan()));

            AttRsBaseCrrct attRsBaseCrrct = bis.getAttRsBaseCrrct();

            if (attRsBaseCrrct != null) {
                // 1 加入基础信息
                // 水库位置
                map.put("rsLoc", attRsBaseCrrct.getRsLoc() == null ? "" : attRsBaseCrrct.getRsLoc());
                // 建成时间
                map.put("compDate", formatCompDate(attRsBaseCrrct.getCompDate()));
                // 工程规模
                map.put("engScal1", formatEngScal(attRsBaseCrrct.getEngScal()));
                // 总库容(万m³)
                map.put("totCap", attRsBaseCrrct.getTotCap() == null ? "" : attRsBaseCrrct.getTotCap());
                //最大坝高(m)
                map.put("damSizeHig", attRsBaseCrrct.getDamSizeHig() == null ? "" : attRsBaseCrrct.getDamSizeHig());
                //主坝坝型
                map.put("damTypeStr1", formatDamType(attRsBaseCrrct.getDamTypeStr()));
                // 注册登记号
                map.put("regCode", attRsBaseCrrct.getRegCode() == null ? "" : attRsBaseCrrct.getRegCode());
                // 未注册
                map.put("regCode2", "");
            } else {
                AttRsBase attRsBase = bis.getAttRsBase();
                // 所在地点
                map.put("rsLoc", attRsBase.getRsLoc() == null ? "" : attRsBase.getRsLoc());
                // 建成时间
                map.put("compDate", formatCompDate(attRsBase.getCompDate()));
                // 工程规模
                map.put("engScal1", formatEngScal(attRsBase.getEngScal()));
                // 总库容(万m³)
                map.put("totCap", attRsBase.getTotCap() == null ? "" : attRsBase.getTotCap());
                //最大坝高(m)
                map.put("damSizeHig", attRsBase.getDamSizeHig() == null ? "" : attRsBase.getDamSizeHig());
                //主坝坝型
                map.put("damTypeStr1", formatDamType(attRsBase.getDamTypeStr()));
                // 注册登记号
                map.put("regCode", attRsBase.getRegCode() == null ? "" : attRsBase.getRegCode());
                // 未注册
                map.put("regCode2", "");
            }

            // 2.重点环节落实情况
            BisInspBaseExt bisInspBaseExt = bis.getBisInspBaseExt();
            map.put("emerPlanSameExta", formatEmerPlanSameExta(bisInspBaseExt.getEmerPlanSameExta()));
            map.put("emerPlanSameAppr", formatEmerPlanSameExta(bisInspBaseExt.getEmerPlanSameAppr()));
            map.put("emerPlanSameSpeed", formatEmerPlanSameExta(bisInspBaseExt.getEmerPlanSameSpeed()));
            map.put("emerPlanSameEme", formatEmerPlanSameExta(bisInspBaseExt.getEmerPlanSameEme()));
            map.put("schPlanSameExta", formatEmerPlanSameExta(bisInspBaseExt.getSchPlanSameExta()));
            map.put("schPlanSameAppr", formatEmerPlanSameExta(bisInspBaseExt.getSchPlanSameAppr()));
            map.put("schPlanSameSpeed", formatEmerPlanSameExta(bisInspBaseExt.getSchPlanSameSpeed()));
            map.put("rainForc", formatEmerPlanSameExta(bisInspBaseExt.getRainForc()));


            // 3.责任人落实情况
            BisInspBasePresExt bisInspBasePresExt = bis.getBisInspBasePresExt();
            // 是否有行政责任人
            map.put("hasWiunWaoLegPers", formatEmerPlanSameExta(bisInspBasePresExt.getHasWiunWaoLegPers()));
            // 责任人名称
            map.put("wiunWaoLegPers", bisInspBasePresExt.getWiunWaoLegPers() == null ? "" : bisInspBasePresExt.getWiunWaoLegPers());
            // 责任人电话
            map.put("wiunWaoLegPersTel", bisInspBasePresExt.getWiunWaoLegPersTel() == null ? "" : bisInspBasePresExt.getWiunWaoLegPersTel());
            // 责任人职务
            map.put("wiunWaoLegPersDuty", bisInspBasePresExt.getWiunWaoLegPersDuty() == null ? "" : bisInspBasePresExt.getWiunWaoLegPersDuty());
            // 履职情况
            map.put("wiunWaoLegPersResu", formatWiunWaoLegPersResu(bisInspBasePresExt.getWiunWaoLegPersResu()));
            // 是否有技术责任人
            map.put("hasTechPers", formatEmerPlanSameExta(bisInspBasePresExt.getHasTechPers()));
            // 责任人名称
            map.put("techPers", bisInspBasePresExt.getTechPers() == null ? "" : bisInspBasePresExt.getTechPers());
            // 责任人电话
            map.put("techPersTel", bisInspBasePresExt.getTechPersTel() == null ? "" : bisInspBasePresExt.getTechPersTel());
            // 责任人职务
            map.put("techPersDuty", bisInspBasePresExt.getTechPersDuty() == null ? "" : bisInspBasePresExt.getTechPersDuty());
            // 履职情况
            map.put("techPersResu", formatWiunWaoLegPersResu(bisInspBasePresExt.getTechPersResu()));
            // 是否有巡查责任人
            map.put("hasPatrolPers", formatEmerPlanSameExta(bisInspBasePresExt.getHasPatrolPers()));
            // 责任人名称
            map.put("patrolPers", bisInspBasePresExt.getPatrolPers() == null ? "" : bisInspBasePresExt.getPatrolPers());
            // 责任人职务
            map.put("patrolPersDuty", formatPatrolPersDuty(bisInspBasePresExt.getPatrolPersDuty()));
            // 巡查责任人履职情况
            map.put("patrolPersResu", formatWiunWaoLegPersResu(bisInspBasePresExt.getPatrolPersResu()));
            // 管理机构
            // 是否有专门管理机构
            map.put("specialManage", formatEmerPlanSameExta(bisInspBasePresExt.getSpecialManage()));
            // 管理机构名称
            map.put("manaOrg", formatCheckNull(bisInspBasePresExt.getManaOrg()));
            // 管理机构性质
            map.put("orgProp", formatCheckNull(bisInspBasePresExt.getOrgProp()));
            // 管理机构经费来源
            map.put("fundSour", formatCheckNull(bisInspBasePresExt.getFundSour()));
            // 管理机构经费每年数额
            map.put("fundSourCount", bisInspBasePresExt.getFundSourCount() == null ? "" : bisInspBasePresExt.getFundSourCount());
            //无管理机构是否有管护人员,1是，2否
            map.put("noManHasPres", formatEmerPlanSameExta(bisInspBasePresExt.getNoManHasPres()));
            // 是否参加过培训 1是，2否
            map.put("hasAttendTrain", formatEmerPlanSameExta(bisInspBasePresExt.getHasAttendTrain()));
            // 管护报酬（万元/年）
            map.put("patrolReward", bisInspBasePresExt.getPatrolReward() == null ? "" : bisInspBasePresExt.getPatrolReward());
            // 经费来源
            map.put("patrolFundSour", bisInspBasePresExt.getPatrolFundSour() == null ? "" : bisInspBasePresExt.getPatrolFundSour());
            // 是否开展巡查 1是，2否
            map.put("hasExtPatrol", formatEmerPlanSameExta(bisInspBasePresExt.getHasExtPatrol()));
            // 巡视频次
            map.put("protalRate", bisInspBasePresExt.getProtalRate() == null ? "" : bisInspBasePresExt.getProtalRate());
            // 巡视检查记录是否完整 1是，2否
            map.put("isPatrolMsgComp", formatEmerPlanSameExta(bisInspBasePresExt.getIsPatrolMsgComp()));
            // 有险情是否即时报告 1是，2否
            map.put("hasRepDangReal", formatEmerPlanSameExta(bisInspBasePresExt.getHasRepDangReal()));
            // 险情报告对象
            map.put("dangReportObj", formatEmerPlanSameExta(bisInspBasePresExt.getDangReportObj()));
            // 是否有报告记录 1是，2否
            map.put("hasReport", formatEmerPlanSameExta(bisInspBasePresExt.getHasReport()));
            // 是否知晓防洪限制水位  1是，2否
            map.put("hasFlLowLimLev", formatEmerPlanSameExta(bisInspBasePresExt.getHasFlLowLimLev()));
            // 是否知晓安全应急（防汛）应急预案 1是，2否
            map.put("hasKnowEmerPlanSame", formatEmerPlanSameExta(bisInspBasePresExt.getHasKnowEmerPlanSame()));


            // 4.水库工程实体和运行管理情况
            BisInspSafeExtManage bisInspSafeExtManage = bis.getBisInspSafeExtManage();
            // 安全总体评价
            map.put("safeComment", formatSafeComment(bisInspSafeExtManage.getSafeComment()));
            // 是否正常蓄水运行
            map.put("hasRetainRegular", formatRetainRegular(bisInspSafeExtManage.getRetainRegular()));
            // 有缺陷但能蓄水
            map.put("noRetainRegular", formatKnowResManager(bisInspSafeExtManage.getNoRetainRegular()));
            //不具备正常蓄水条件
            map.put("canNotRetainWater", formatHasRetainRegular(bisInspSafeExtManage.getHasRetainRegular()));

            // 挡水物
            // 是否明显漏水
            // 漏水是否影响安全
            map.put("leakMakeSafe", formatEmerPlanSameExta(bisInspSafeExtManage.getLeakMakeSafe()));
            //是否有变形或不稳定情况
            map.put("hasAstable", formatEmerPlanSameExta(bisInspSafeExtManage.getHasAstable()));

            // 泄洪建筑物运行状况
            // 是否设置泄洪建筑物
            map.put("hasSetMainFl", formatEmerPlanSameExta(bisInspSafeExtManage.getHasSetMainFl()));
            // 泄洪建筑物是否运行正常
            map.put("isMainFlNormal", formatEmerPlanSameExta(bisInspSafeExtManage.getIsMainFlNormal()));

            // 放水建筑物运行情况
            // 是否设置放水建筑物
            map.put("hasSetPourFl", formatEmerPlanSameExta(bisInspSafeExtManage.getHasSetPourFl()));
            // 放水建筑物是否运行正常
            map.put("pourFyIsNormal", formatPourFyIsNormal(bisInspSafeExtManage.getPourFyIsNormal()));

            // 是否设置防洪限制水位 HavFlLowLimLev
            map.put("havFlLowLimLev", formatEmerPlanSameExta(bisInspSafeExtManage.getHavFlLowLimLev()));
            // 超汛限水位运行
            map.put("gtFlLowLimLev", formatEmerPlanSameExta(bisInspSafeExtManage.getFlLowLimLevNote()));

            // 是否注册登记
            map.put("manageRegRelNote", formatEmerPlanSameExta(bisInspSafeExtManage.getManagePersNote()));
            // 注册信息真实
            map.put("ifManageRegRel", formatEmerPlanSameExta(bisInspSafeExtManage.getIfManageRegRel()));
            // 安全鉴定
            map.put("extDamSafeAppr", formatEmerPlanSameExta(bisInspSafeExtManage.getExtDamSafeAppr()));
            // 最近一次鉴定时间

            // 是否有专门管理机构
            map.put("hasSpeManage", formatEmerPlanSameExta(bisInspSafeExtManage.getHasSpeManage()));
            // 是否有管护人员
            map.put("hasManagePers", formatEmerPlanSameExta(bisInspSafeExtManage.getHasManagePers()));
            // 是否有稳定经济来源
            map.put("hasWdEmnic", formatEmerPlanSameExta(bisInspSafeExtManage.getHasWdEmnic()));
            // 正常运行
            map.put("retainRegular", formatRetainRegular(bisInspSafeExtManage.getRetainRegular()));
            // 是否正常运行
            map.put("dikeHasLeak", formatEmerPlanSameExta(bisInspSafeExtManage.getDikeHasLeak()));

            // 水库除险加固
            // 是否进行除险加固 IfReinForce
            map.put("ifReinForce", formatEmerPlanSameExta(bisInspSafeExtManage.getIfReinForce()));
            // 实施情况
            map.put("ifComplateAccAll", formatIfComplateAccAll(bisInspSafeExtManage.getIfComplateAcc()));

            // 公示情况
            // 是否设置水库公示牌
            map.put("ifDamWarnLogo", formatEmerPlanSameExta(bisInspSafeExtManage.getIfDamWarnLogo()));

            // 5 走访情况
            List<BisInspPreList> bisInspPreList = bis.getBisInspPreList();
            // 走访人数
            int viewPreNum = bisInspPreList.size();
            // 走访人姓名
            String viewPreName = "";
            // 是否知晓水库管护人员
            String knowResManager = "";
            // 对管护责任人的评价
            String managerComment = "";
            for (BisInspPreList bipre : bisInspPreList) {
                // 多个人的名字合成一个字段
                viewPreName += bipre.getViewPreName() + " ";
                knowResManager = bipre.getKnowResManager();
                managerComment = bipre.getManagerComment();
            }
            // 走访人数
            map.put("viewPreNum", viewPreNum);
            // 走访人姓名
            map.put("viewPreName", viewPreName);
            // 是否知晓水库管护人员
            map.put("knowResManager", formatKnowResManager(knowResManager));
            // 对管护责任人的评价
            map.put("managerComment", formatManagerComment(managerComment));

            // 省 市 县
            HashMap<Object, Object> hashMap = bis.getHashMap();
            map.put("province", hashMap.get("province").toString());
            map.put("city", hashMap.get("city").toString());
            map.put("county", hashMap.get("county").toString());

            dataList.add(map);
        }
        return dataList;
    }

    /**
     * 要填报的水库模板
     */
    public List<Map<String, Object>> getBisInspRsvrRgstrPcDtoTemplate(List<BisInspRsvrRgstrPcDtoVo> list) {

        List<Map<String, Object>> dataList = new LinkedList<>();
        for (BisInspRsvrRgstrPcDtoVo bis : list) {
            LinkedHashMap<String, Object> map = new LinkedHashMap<>();

            //BisInspRsvrRgstrPcDto表 基础信息 填报的基础信息不是这个表，但是要同步到这个表
            BisInspRsvrRgstrPcDto bisInspRsvrRgstrPcDto = bis.getBisInspRsvrRgstrPcDto();
            // 督查组
            map.put("groupName", formatCheckNull(bisInspRsvrRgstrPcDto.getUpGroupName()));
            // 督查状态
            map.put("state", formatState(bisInspRsvrRgstrPcDto.getState()));

            // 1.基础信息 由两个表组成，如果AttRsBaseCrrct表无数据，则取AttRsBase表
            AttRsBaseCrrct attRsBaseCrrct = bis.getAttRsBaseCrrct();
            if (attRsBaseCrrct != null) {
                this.setMapValue(attRsBaseCrrct, baseCrrctKeysArray, map);
            } else {
                AttRsBase attRsBase = bis.getAttRsBase();
                this.setMapValue(attRsBase, baseCrrctKeysArray, map);
            }

            // 放入行政区划
            HashMap<Object, Object> hashMap = bis.getHashMap();
            String province = hashMap.get("province").toString();
            String city = hashMap.get("city").toString();
            String county = hashMap.get("county").toString();
            map.put("adFullName", province + city + county);

            // 放入objId
            map.put("rgstrId", bisInspRsvrRgstrPcDto.getRgstrId());

            // 2.重点环节落实情况
            BisInspBaseExt bisInspBaseExt = bis.getBisInspBaseExt();
            this.setMapValue(bisInspBaseExt, baseExtKeysArray, map);

            // 3.责任人落实情况
            BisInspBasePresExt bisInspBasePresExt = bis.getBisInspBasePresExt();
            this.setMapValue(bisInspBasePresExt, presExtKeysArray, map);

            // 4.水库工程实体和运行管理情况
            BisInspSafeExtManage bisInspSafeExtManage = bis.getBisInspSafeExtManage();
            this.setMapValue(bisInspSafeExtManage, safeExtManageKeysArray, map);

            // 5 走访情况
            List<BisInspPreList> bisInspPreList = bis.getBisInspPreList();
            this.setMapValue(bisInspPreList, preListKeysArray, map);

            // 工程实体
            BisInspRsvrProject bisInspRsvrProject = bis.getBisInspRsvrProject();
            this.setMapValue(bisInspRsvrProject, safeExtManageKeysArray, map);

            // 6 效益发挥情况
            BisInspRsvrBenefits bisInspRsvrBenefits = bis.getBisInspRsvrBenefits();
            this.setMapValue(bisInspRsvrBenefits, benefitsArray, map);
            // diskRunInfo hasSetMainF 字段和 工程实体里的 挡水建筑物 重复，单独处理
            map.put("diskRunInfo2", isShiFou(bisInspRsvrBenefits.getDiskRunInfo()));
            map.put("hasSetMainFl2", formatCheckNull(bisInspRsvrBenefits.getHasSetMainFl()));


            dataList.add(map);
        }
        return dataList;

    }

    /**
     * 用反射简化赋值流程，通过对象和属性名称给Map赋值
     */
    private void setMapValue(Object obj, String[] names, LinkedHashMap<String, Object> map) {
        if (obj == null) {
            for (String name : names) {
                map.put(name, "");
            }
            return;
        }
        Method[] methods = obj.getClass().getMethods();
        for (Method method : methods) {
            for (String name : names) {
                if (("get" + name).toLowerCase().equals(method.getName().toLowerCase())) {
                    try {
                        map.put(name, getFormatValue("sk", name, formatCheckNull(method.invoke(obj)), false));
                    } catch (IllegalAccessException e) {
                        e.printStackTrace();
                    } catch (InvocationTargetException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }


}