fj-dc/.svn/pristine/0a/0a90e7d054fd5cfebe55f15d5ad714de61341054.svn-base

package cn.com.goldenwater.dcproj.utils;

import cn.com.goldenwater.dcproj.constValue.AdCodeLabel;
import cn.com.goldenwater.dcproj.constValue.SplitValue;
import cn.com.goldenwater.dcproj.dto.BisInspRgstrDto;
import cn.com.goldenwater.dcproj.model.BisInspPblm;
import cn.com.goldenwater.dcproj.model.BisZhejiangCheckPlan;
import cn.com.goldenwater.dcproj.model.KeyRegPblm;
import cn.com.goldenwater.dcproj.utils.expExcel.ExcelExport;
import cn.com.goldenwater.dcproj.utils.expExcel.ExportAbstract;
import cn.com.goldenwater.target.CheckException;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

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

public class InspPblmUtils {

    public static String Subordinate(String AD_CODE) {
        String start = "^";
        if ("000000000000".equals(AD_CODE) || "ROOT".equals(AD_CODE) || "".equals(AD_CODE)) {
            AD_CODE = start;
        } else {
            if (AD_CODE.length() == 12) {
                String sub = AD_CODE.substring(2, 12);
                if ("0000000000".equals(sub)) {
                    AD_CODE = AD_CODE.substring(0, 2);
                } else {
                    String sub1 = AD_CODE.substring(4, 12);
                    if ("00000000".equals(sub1)) {
                        AD_CODE = AD_CODE.substring(0, 4);
                    } else {
                        String sub2 = AD_CODE.substring(6, 12);
                        if ("000000".equals(sub2)) {
                            AD_CODE = AD_CODE.substring(0, 6);
                        } else {
                            String sub3 = AD_CODE.substring(9, 12);
                            if ("000".equals(sub3)) {
                                AD_CODE = AD_CODE.substring(0, 9);
                            }
                        }
                    }
                }
            }
        }
        return AD_CODE;
    }

    public static String plbmCateDesc(String pblmCate) {
        if ("0".equals(pblmCate)) {
            return "一般";
        }
        if ("1".equals(pblmCate)) {
            return "较重";
        }
        if ("2".equals(pblmCate)) {
            return "严重";
        }
        if ("3".equals(pblmCate)) {
            return "特别严重";
        }
        return "";
    }

    public static String getSheetDesc(String type) {
        if (type == null) {
            return "问题列表";
        }
        switch (type) {
            case "vill":
                return "人饮，行政村，水源地问题列表";
            case "track":
                return "水毁问题列表";
            case "grw":
                return "地下水问题列表";
            case "waga":
                return "水闸问题列表";
            case "rever":
                return "小水库问题列表";
            case "jsfl":
                return "河湖四乱问题列表";
            case "jswa":
                return "非法采砂问题列表";
            case "prd":
                return "水保问题列表";
            case "ecofrd":
                return "中央环保督查问题列表";
            case "wtcrr":
                return "节水载体复核问题列表";
            case "wtgt":
                return "取水许可管理复核问题列表";
            case "wrws":
                return "水资源管理及节水管理复核问题列表";
            default:
                return "问题列表";
        }
    }

    public static void ExportNew(HttpServletResponse response, String type, List<KeyRegPblm> pblmList, String name) {
        List<Map<String, String>> mapList = new ArrayList<>();
        for (BisInspPblm inspPblm : pblmList) {
            mapList.add(getMap(inspPblm, type));
        }

        writeXlsx(type, response, name, mapList);

    }

    public static void writeXlsxCommon(String type, HttpServletResponse response, String name, List<Map<String, String>> mapList) {
        ExportAbstract export = new ExcelExport();
        // 设置文件名
        export.setFileName(InspPblmUtils.getSheetDesc(type));
        // 设置标题
        export.setTitle(InspPblmUtils.getSheetDesc(type));
        // 设置文件格式为 xls
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_ps_export(true);
        export.setExport_bzip(false);
        export.setCols(defaultGetCols(type));
        export.setGroupable(false);
        export.setLevel(1);
        export.setLocksize(0);
        try {
            export.Export(response);
            export.ExportHeadForCustom(response);
            export.ContinueExport(mapList);
            export.EndExport();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static ArrayList<Object> defaultGetCols(String type) {
        ArrayList<Object> cols = new ArrayList<>();
        String[] rvlksfArr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "NAME[详细地点]", "DESCRIBE[历史情况描述]"
                , "ORGNM[督查组]", "PERSNAME[上报人]", "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]",
                "PBLMDESCBZ[问题描述]", "INSPPBLMDESC[详细描述]"};

        String[] acclrtArr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]", "INSPPBLMDESC[详细描述]",
                "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        String[] dinas1Arr = new String[]{"ADFULLNAME[所在地（市、区）]", "ORGNM[督查组]", "NAME[项目（活动）名称]", "RVNAME[所在河道名称]",
                "RVLOC[河道起止位置或范围]", "PROGRESS[项目（活动）进展情况]", "PBLMDESCBZ[问题]"};

        String[] dinas3Arr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[项目（活动）名称]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "RVNAME[所在河道名称]", "RVLOC[河道起止位置或范围]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]",
                "INSPPBLMDESC[详细描述]", "NOTE[备注]"};

        String[] fourArr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "ATTACHBZ[附件名称]", "SNNUM[序号]", "VILLTYPE[责任单位性质]", "NEWVILLNAME[责任单位名称]",
                "INSPPBLMDESC[详细描述]", "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        String[] villArr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "LOC[地址]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]", "INSPPBLMDESC[详细描述]",
                "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        String[] defualtArr = new String[]{"CITY[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]", "INSPPBLMDESC[详细描述]",
                "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        String[] rsvrsdArr = new String[]{"PROVINCE[省]", "CITY[市]", "COUNTRY[县]", "NAME[督查名称]", "ORGNM[督查组]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]", "PBLMDESCBZ[问题描述]", "INSPPBLMDESC[详细描述]",
                "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        String[] importArr = new String[]{"PROVINCE[省]", "CITY[市]", "COUNTRY[县]", "OBJNAME[督查对象名称]", "PERSNAME[上报人]",
                "COLLTIME[督查时间]", "INSPPBLMNAME[问题类别]", "CHECKPOINT[检查事项]", "INSPPBLMDESC[详细描述]",
                "PBLMREASON[产生问题原因分析]", "PBLMSGGTN[整改意见]"};

        switch (type) {
            case "rvlksf":
                cols.addAll(Arrays.asList(rvlksfArr));
                break;
            case "acclrt":
                cols.addAll(Arrays.asList(acclrtArr));
                break;
            case "dinas-1":
                cols.addAll(Arrays.asList(dinas1Arr));
                break;
            case "dinas-3":
                cols.addAll(Arrays.asList(dinas3Arr));
                break;
            case "79":
                cols.addAll(Arrays.asList(villArr));
                break;
            case "4":
            case "7":
            case "99":
            case "100":
                cols.addAll(Arrays.asList(fourArr));
                break;
            case "115":
                cols.addAll(Arrays.asList(rsvrsdArr));
                break;
            case "116":
                cols.addAll(Arrays.asList(rsvrsdArr));
                break;
            case "999":
                cols.addAll(Arrays.asList(importArr));
                break;
            default:
                cols.addAll(Arrays.asList(defualtArr));
        }

        return cols;
    }

    private static void writeXlsx(String type, HttpServletResponse response, String name, List<Map<String, String>> mapList) {
        ExportAbstract export = new ExcelExport();
        export.setFileName(InspPblmUtils.getSheetDesc(type));
        export.setExport_ps_export(true);
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_bzip(false);
        export.setTitle(InspPblmUtils.getSheetDesc(type));
        ArrayList<Object> cols = new ArrayList<Object>();
        cols.add("PROVINCE[省]");
        cols.add("CITY[市]");
        cols.add("COUNTRY[县]");
        cols.add("RSNAME[" + name + "]");
        if ("rever".equals(type) || "bigrever".equals(type)) {
            cols.add("INSPPBLMNAME[督查水库问题类别]");
        }
        if ("vill".equals(type)) {
            cols.add("INSPPBLMNAME[督查人饮问题类别]");
        }
        if ("track".equals(type)) {
            cols.add("INSPPBLMNAME[督查水毁问题类别]");
        }
        if ("waga".equals(type)) {
            cols.add("INSPPBLMNAME[督查水闸问题类别]");
        }
        if ("grw".equals(type)) {
            cols.add("INSPPBLMNAME[督查地下水问题类别]");

        }
        if ("keyReg".equals(type)) {
            cols.add("INSPPBLMNAME[督查172重点工程问题类别]");

        }
        if ("wtcrr".equals(type)) {
            cols.add("INSPPBLMNAME[节水载体复核问题类别]");
        }
        if ("wtgt".equals(type)) {
            cols.add("INSPPBLMNAME[取水许可管理复核问题类别]");
        }
        if ("wrws".equals(type)) {
            cols.add("INSPPBLMNAME[水资源管理及节水管理复核问题类别]");
        }
        cols.add("INSPPBLMDESC[问题描述]");
        cols.add("IFCASEPBLM[典型]");
        if (!"grw".equals(type) || !"vill".equals(type)) {
            cols.add("INSPPBLMCATE[程度]");
        }
        cols.add("PERSNAME[上报人]");
        cols.add("ORGNM[所在组]");
        if ("rever".equals(type) || "keyReg".equals(type) || "waga".equals(type) || "bigrever".equals(type)) {
            cols.add("ATTACH[附件]");
            cols.add("SNNUM[附件序号]");
        }
        cols.add("COLLTIME[上报时间]");
        cols.add("HASVEDIO[是否包含多媒体文件]");
        export.setCols(cols);
        export.setGroupable(false);
        export.setLevel(1);
        export.setLocksize(0);
        try {
            export.Export(response);
            export.ExportHeadForCustom(response);
            export.ContinueExport(mapList);
            export.EndExport();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static Map<String, String> getMap(BisInspPblm inspPblm, String type) {
        Map<String, String> map = new HashMap<>();
        map.put("IFCASEPBLM", "1".equals(inspPblm.getIfCasePblm()) ? "是" : "否");
        if (!"grw".equals(type) || !"vill".equals(type)) {
            map.put("INSPPBLMCATE", InspPblmUtils.plbmCateDesc(inspPblm.getInspPblmCate()));
        }
        if (StringUtils.isNotBlank(inspPblm.getAdFullName())) {
            if (inspPblm.getAdFullName().contains("-")) {
                String[] arrays = inspPblm.getAdFullName().split("-");
                if (arrays.length == 3) {
                    map.put("PROVINCE", arrays[0]);
                    map.put("CITY", arrays[1]);
                    map.put("COUNTRY", arrays[2]);
                }
                if (arrays.length == 2) {
                    map.put("PROVINCE", arrays[0]);
                    map.put("CITY", arrays[1]);
                    map.put("COUNTRY", "");
                }
            } else {
                map.put("PROVINCE", "");
                map.put("CITY", "");
                map.put("COUNTRY", "");
            }
        }

        map.put("RSNAME", inspPblm.getNm());
        map.put("INSPPBLMNAME", inspPblm.getInspPblmName());
        map.put("INSPPBLMDESC", inspPblm.getInspPblmDesc());
        map.put("PERSNAME", inspPblm.getPersName());
        map.put("ORGNM", inspPblm.getOrgNm());
        if (StringUtils.isNotBlank(inspPblm.getAttach())) {
            map.put("ATTACH", inspPblm.getAttach());
            if (StringUtils.isNotBlank(inspPblm.getSheet()) && !"1".equals(inspPblm.getSheet())) {
                map.put("ATTACH", inspPblm.getAttach() + "-" + inspPblm.getSheet());
            }
            map.put("SNNUM", inspPblm.getSnNum());
        }
        map.put("COLLTIME", new SimpleDateFormat("yyyy-MM-dd").format(inspPblm.getCollTime()));
        if ("1".equals(inspPblm.getHasVedio())) {
            map.put("HASVEDIO", "是");
        } else {
            map.put("HASVEDIO", "否");
        }

        return map;
    }

    public static void Export(HttpServletResponse response, String type, List<BisInspPblm> pblmList, String name) {
        List<Map<String, String>> mapList = new ArrayList<>();
        for (BisInspPblm inspPblm : pblmList) {
            mapList.add(getMap(inspPblm, type));
        }
        writeXlsx(type, response, name, mapList);

    }

    public static HSSFWorkbook getWb() {
        ExportAbstract export = new ExcelExport();
        return export.getWb();
    }

    public static HttpServletResponse Export_new(HttpServletResponse response) throws Exception {
        ExportAbstract export = new ExcelExport();
        return export.Export_new(response);
    }

    public static Map<String, String> getLength(String province) {
        Map<String, String> params = new HashMap<>();
        String length = "2";
        String otherLength = "0000000000";
        if (!province.startsWith(AdCodeLabel.START_PARENT_ADCODE)) {
            int total = province.length();
            int min = province.replace(AdCodeLabel.START_PARENT_ADCODE, "").length();
            length = min + "";
            StringBuffer buffer = new StringBuffer();
            for (int i = 0; i < total - min; i++) {
                buffer.append("0");
            }
            otherLength = buffer.toString();
        }
        params.put("length", length);
        params.put("otherLength", otherLength);
        return params;
    }

    public static String getKeyPblms(List<KeyRegPblm> keypblmList) {
        String pblms = "";
        for (KeyRegPblm bisInspPblm : keypblmList) {
            pblms += bisInspPblm.getPblmId() + ",";
        }
        pblms = pblms.substring(0, pblms.length() - 1);
        pblms = "'" + pblms + "'";
        pblms = pblms.replace(",", "','");
        return pblms;
    }

    public static String getPblms(List<BisInspPblm> pblmList) {
        String pblms = "";
        for (BisInspPblm bisInspPblm : pblmList) {
            pblms += bisInspPblm.getPblmId() + ",";
        }
        pblms = pblms.substring(0, pblms.length() - 1);
        pblms = "'" + pblms + "'";
        pblms = pblms.replace(",", "','");
        return pblms;
    }

    public static List<BisInspPblm> setPblmList(List<BisInspPblm> pblmList) {
        if (pblmList == null || pblmList.isEmpty()) {
            throw new CheckException("未查到具体数据，无法导出!!");
        }
        for (BisInspPblm inspPblm : pblmList) {
            inspPblm.setInspPblmsName(inspPblm.getPblmNameBz());
            inspPblm.setCheckPoint(inspPblm.getCheckPointBz());
            inspPblm.setSnNum(inspPblm.getSnNumBz());
        }
        return pblmList;
    }

    public static List<KeyRegPblm> setKeyPblmList(List<KeyRegPblm> pblmList) {
        if (pblmList == null || pblmList.isEmpty()) {
            throw new CheckException("未查到具体数据，无法导出!!");
        }
        for (KeyRegPblm inspPblm : pblmList) {
            inspPblm.setInspPblmsName(inspPblm.getPblmNameBz());
            inspPblm.setCheckPoint(inspPblm.getCheckPointBz());
            inspPblm.setSnNum(inspPblm.getSnNumBz());
        }
        return pblmList;
    }

    public static String toChinese(String number) {
        String resultString = "";
        String[] s1 = {"零", "一", "二", "三", "四", "五", "六", "七", "八", "九"};
        String[] s2 = {"十", "百", "千", "万", "十", "百", "千", "亿", "十", "百"};
        int n = number.length();
        for (int i = 0; i < n; i++) {
            int num = number.charAt(i) - '0';
            if (num != 0 && i != n - 1) {
                resultString += s1[num] + s2[n - 2 - i];
            } else if (num == 0 && i == n - 1) {
                resultString += "";
            } else {
                resultString += s1[num];
            }
        }
        return resultString;
    }

    public static List<BisInspRgstrDto> changeList(List<BisInspRgstrDto> list) {
        if (list.size() > 0) {
            for (BisInspRgstrDto rgstrDto : list) {
                String adFullName = rgstrDto.getAdName();
                if (StringUtils.isBlank(adFullName)) {
                    continue;
                }
                if (adFullName.contains(SplitValue.HENG_SPLIT)) {
                    String[] split = adFullName.split(SplitValue.HENG_SPLIT);
                    if (split.length == 3) {
                        rgstrDto.setProvince(split[0]);
                        rgstrDto.setCity(split[1]);
                        rgstrDto.setCountry(split[2]);
                    }
                    if (split.length == 2) {
                        rgstrDto.setProvince(split[0]);
                        rgstrDto.setCity(split[1]);
                        rgstrDto.setCountry("");
                    }
                } else {
                    rgstrDto.setProvince(adFullName);
                }
            }
        }
        return list;
    }

    public static void ExportWorkNew(HttpServletResponse response, List<BisZhejiangCheckPlan> bisZhejiangCheckPlanList, String name) {
        List<Map<String, String>> mapList = new ArrayList<>();
        for (BisZhejiangCheckPlan inspPblm : bisZhejiangCheckPlanList) {
            mapList.add(getNewMap(inspPblm));
        }
        writeNewXlsx(response, name, mapList);
    }

    private static Map<String, String> getNewMap(BisZhejiangCheckPlan inspPblm) {
        Map<String, String> map = new HashMap<>();
        map.put("YEAR", inspPblm.getYear());
        map.put("MONTH", inspPblm.getMonth());
        map.put("WORKNM", inspPblm.getWokerNm());
        map.put("WORKNMDESC", inspPblm.getWorkerNmDesc());
        map.put("CONTENT", "".equals(inspPblm.getContent()) ? "" : inspPblm.getContent());
        if ("1".equals(inspPblm.getCheckWay())) {
            map.put("CHECKWAY", "明查");
        } else if ("2".equals(inspPblm.getCheckWay())) {
            map.put("CHECKWAY", "暗访");
        } else {
            map.put("CHECKWAY", "明查暗访组合");
        }
        map.put("ORGNAME", "".equals(inspPblm.getOrgName()) ? "" : inspPblm.getOrgName());
        map.put("INSPNAME", "".equals(inspPblm.getInspName()) ? "" : inspPblm.getInspName());
        map.put("DEPARTNM", "".equals(inspPblm.getDepartNm()) ? "" : inspPblm.getDepartNm());
        map.put("CHECKENDDATE", inspPblm.getCheckEndDate() == null ? "" : inspPblm.getCheckEndDate());
        map.put("CHECKSTTDDATE", inspPblm.getCheckSttdDate() == null ? "" : inspPblm.getCheckSttdDate());
        map.put("PERSNAME", "".equals(inspPblm.getPersName()) ? "" : inspPblm.getPersName());
        if ("1".equals(inspPblm.getState())) {
            map.put("STATE", "待审核");
        } else if ("2".equals(inspPblm.getState())) {
            map.put("STATE", "待反馈");
        } else {
            map.put("STATE", "已下发");
        }
        return map;
    }

    private static void writeNewXlsx(HttpServletResponse response, String name, List<Map<String, String>> mapList) {
        ExportAbstract export = new ExcelExport();
        export.setFileName(name);
        export.setExport_ps_export(true);
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_bzip(false);
        export.setTitle(name);
        ArrayList<Object> cols = new ArrayList<Object>();
        cols.add("YEAR[年度]");
        cols.add("MONTH[月份]");
        cols.add("WORKNM[事项名称]");
        cols.add("WORKNMDESC[事项详细名称]");
        cols.add("CONTENT[检查内容]");
        cols.add("CHECKWAY[检查方式]");
        cols.add("ORGNAME[机构名称]");
        cols.add("INSPNAME[督查类型]");
        cols.add("DEPARTNM[责任处室]");
        cols.add("CHECKENDDATE[督查结束时间]");
        cols.add("CHECKSTTDDATE[督查开始时间]");
        cols.add("PERSNAME[操作人]");
        cols.add("STATE[事项状态]");
        export.setCols(cols);
        export.setGroupable(false);
        export.setLevel(1);
        export.setLocksize(0);
        try {
            export.Export(response);
            export.ExportHeadForCustom(response);
            export.ContinueExport(mapList);
            export.EndExport();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static void writeProblemListXlsx(HttpServletResponse response, String name, List<Map<String, String>> mapList) {
        ExportAbstract export = new ExcelExport();
        export.setFileName("问题清单");
        export.setTitle("问题清单");
        export.setExport_ps_export(true);
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_bzip(false);

        ArrayList<Object> cols = new ArrayList<>();
        cols.add("CITY[市]");
        cols.add("COUNTRY[区县]");
        cols.add("RECT_STATE[整改状态]");
        cols.add("CHECK_NAME[检查名称]");
        cols.add("PROBLEM_TYPE[问题类型]");
        cols.add("PROBLEM_VALUE[问题赋值]");
        cols.add("PROBLEM_NATURE[问题性质]");
        cols.add("PROJECT_NAME[工程或项目名称]");
        cols.add("PROJECT_TYPE[工程类型]");
        cols.add("CHECK_ITEM[检查项目或问题]");
        cols.add("PROBLEM_DESC[问题描述]");
        cols.add("PROBLEM_DESCS[问题详细描述]");
        cols.add("LEGAL_BASIS[法律依据]");
        cols.add("MODIFY_TIME[问题清单修改时限]");
        cols.add("RESPONSIBLE_UNIT[责任单位]");
        cols.add("CONTACT_PERSON[联系人]");
        cols.add("CONTACT_PHONE[联系电话]");
        cols.add("RECT_MEASURE[整改措施和整改情况]");
        cols.add("PROBLEM_NO[问题编号]");
        cols.add("REVIEW_CONCLUSION[复核整改措施复核结论]");
        cols.add("NOTE[备注]");

        export.setCols(cols);
        export.setGroupable(false);
        export.setLevel(1);
        export.setLocksize(0);

        try {
            export.Export(response);
            export.ExportHeadForCustom(response);
            export.ContinueExport(mapList);
            export.EndExport();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void ExportProblemList(HttpServletResponse response, List<BisInspPblm> pblmList, String name) {
        List<Map<String, String>> mapList = new ArrayList<>();
        for (BisInspPblm inspPblm : pblmList) {
            mapList.add(getProblemListMap(inspPblm));
        }
        writeProblemListXlsx(response, name, mapList);
    }

    private static Map<String, String> getProblemListMap(BisInspPblm inspPblm) {
        Map<String, String> map = new HashMap<>();

        // 市、区县 - 从adFullName解析
        if (StringUtils.isNotBlank(inspPblm.getAdFullName())) {
            if (inspPblm.getAdFullName().contains("-")) {
                String[] arrays = inspPblm.getAdFullName().split("-");
                if (arrays.length >= 2) {
                    map.put("CITY", arrays[1]); // 市
                }
                if (arrays.length >= 3) {
                    map.put("COUNTRY", arrays[2]); // 区县
                }
            }
        }

        // 整改状态 - 根据dataStat映射
        map.put("RECT_STATE", "");
//        String dataStat = inspPblm.getDataStat();
//        switch (dataStat) {
//            case "0":
//                map.put("RECT_STATE", "暂存");
//                break;
//            case "1":
//                map.put("RECT_STATE", "已提交");
//                break;
//            case "2":
//                map.put("RECT_STATE", "已上报");
//                break;
//            case "3":
//                map.put("RECT_STATE", "退回");
//                break;
//            case "4":
//                map.put("RECT_STATE", "审核定稿");
//                break;
//            case "6":
//                map.put("RECT_STATE", "整改通知");
//                break;
//            case "7":
//                map.put("RECT_STATE", "整改反馈");
//                break;
//            case "8":
//                map.put("RECT_STATE", "销号");
//                break;
//            default:
//                map.put("RECT_STATE", "");
//                break;
//        }

        // 检查名称 - 使用nm或objName
        map.put("CHECK_NAME", StringUtils.defaultString(inspPblm.getBaseObjType()));

        // 问题类型 - 使用inspPblmName
        map.put("PROBLEM_TYPE", StringUtils.defaultString(inspPblm.getInspPblmName()));

        // 问题赋值 - 使用inspPblmDesc
        map.put("PROBLEM_VALUE", "");

        // 问题性质 - 使用inspPblmCate
        map.put("PROBLEM_NATURE", "");

        // 工程或项目名称 - 使用rsName或objName
        map.put("PROJECT_NAME", StringUtils.defaultString(inspPblm.getRsName(), inspPblm.getObjName()));

        // 工程类型 - 使用rePtype或objType描述
        map.put("PROJECT_TYPE", StringUtils.defaultString(inspPblm.getEngrType()));

        // 检查项目或问题 - 使用checkPointBz
        map.put("CHECK_ITEM", StringUtils.defaultString(inspPblm.getCheckPointBz()));

        // 问题描述 - 使用pblmDescBz
        map.put("PROBLEM_DESC", StringUtils.defaultString(inspPblm.getPblmDescBz()));
        map.put("PROBLEM_DESCS", StringUtils.defaultString(inspPblm.getInspPblmDesc()));

        // 法律依据 - 使用relBasis
        map.put("LEGAL_BASIS", "");

        // 问题清单修改时限 - 使用collTime
        map.put("MODIFY_TIME", "");

        // 责任单位 - 使用inspPblmOrgName或orgNm
        map.put("RESPONSIBLE_UNIT", StringUtils.defaultString(inspPblm.getInspPblmOrgName()));

        // 联系人 - 使用persName
        map.put("CONTACT_PERSON", "");

        // 联系电话 - 从其他字段获取，暂时为空
        map.put("CONTACT_PHONE", "");

        // 整改措施和整改情况 - 使用note或pblmSggtn
        map.put("RECT_MEASURE", StringUtils.defaultString(inspPblm.getPblmSggtn()));

        // 问题编号 - 使用pblmId或pblmNo
        map.put("PROBLEM_NO", "");

        // 复核整改措施复核结论 - 使用reviOpin或reviConc
        map.put("REVIEW_CONCLUSION", StringUtils.defaultString(inspPblm.getReviOpin(), inspPblm.getReviConc()));

        // 备注 - 使用note
        map.put("NOTE", StringUtils.defaultString(inspPblm.getNote()));

        return map;
    }
}