package cn.com.goldenwater.dcproj.service.impl.importex;

import cn.com.goldenwater.dcproj.dao.*;
import cn.com.goldenwater.dcproj.dto.ExcelInspRsDto;
import cn.com.goldenwater.dcproj.model.*;
import cn.com.goldenwater.dcproj.param.AttAdXBaseParam;
import cn.com.goldenwater.dcproj.param.AttRsBaseParam;
import cn.com.goldenwater.dcproj.param.BisInspRsvrRgstrParam;
import cn.com.goldenwater.dcproj.param.ImpRsInfoParam;
import cn.com.goldenwater.dcproj.service.AttAdXBaseService;
import cn.com.goldenwater.dcproj.service.AttRsBaseService;
import cn.com.goldenwater.dcproj.service.BisInspRsvrRgstrService;
import cn.com.goldenwater.dcproj.service.ImpRsInfoService;
import cn.com.goldenwater.core.service.AbstractCrudService;
import cn.com.goldenwater.dcproj.utils.GeoUtil;
import cn.com.goldenwater.id.util.UuidUtil;
import com.github.pagehelper.PageHelper;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.io.InputStream;
import java.util.*;

/**
 * @author lune
 * @date 2019-7-23
 */
@Service
@Transactional
public class ImpRsInfoServiceImpl extends AbstractCrudService<ImpRsInfo, ImpRsInfoParam> implements ImpRsInfoService {

    @Autowired
    private ImpRsInfoDao impRsInfoDao;
    @Autowired
    private ImpPersInfoDao impPersInfoDao;
    @Autowired
    private AttAdXBaseService attAdXBaseService;
    @Autowired
    private AttRsBaseService attRsBaseService;
    @Autowired
    private BisInspRsvrRgstrService rsvrRgstrService;
    @Autowired
    private BisInspAllObjDao bisInspAllObjDao;
    @Autowired
    private AttRsBaseDao attRsBaseDao;
    @Autowired
    private AttJskejianFlkdisBaseDao jskejianFlkdisBaseDao;
    @Autowired
    private AttJskejianWaterBaseDao jskejianWaterBaseDao;
    @Autowired
    private AttJskejianEcofrdBaseDao jskejianEcofrdBaseDao;


    public ImpRsInfoServiceImpl(ImpRsInfoDao impRsInfoDao) {
        super(impRsInfoDao);
        this.impRsInfoDao = impRsInfoDao;
    }


    @Override
    public String insertList(List<ExcelInspRsDto> list, String mnth) {
        ImpRsInfo rsInfo = new ImpRsInfo();
        int i = 1;
        for (ExcelInspRsDto excelInspRs:list) {
            String province = excelInspRs.getProvince();
            String provinceCode;
            String city = excelInspRs.getCity();
            String cityCode;
            String country = excelInspRs.getCountry();
            String countryCode;
            String rsvrNm = excelInspRs.getRsvrNm();
            if(rsvrNm.contains("水库水库")){
                rsvrNm = rsvrNm.replaceAll("水库水库","水库");
            }else if(rsvrNm.contains("小二型")){
                rsvrNm = rsvrNm.replaceAll("小二型","");
            }
            String guimo = excelInspRs.getGuimo();
            String top = excelInspRs.getTop();
            String poor = excelInspRs.getPoor();
            String repeat = excelInspRs.getRepeat();
            String note = excelInspRs.getNote();
            String orgNm = excelInspRs.getOrgNm();

            String adCd="";
            Map<String, String> ads = getAdCds(province,city,country);
            provinceCode = ads.get("sheng");
            cityCode = ads.get("shi");
            countryCode = ads.get("xian");
            if(StringUtils.isNotBlank(countryCode)){
                adCd = countryCode;
            }else if(StringUtils.isNotBlank(cityCode)){
                adCd = cityCode;
            }else if(StringUtils.isNotBlank(provinceCode)){
                adCd = provinceCode;
            }
            ImpRsInfo impRsInfo = new ImpRsInfo();
            impRsInfo.setId(UuidUtil.uuid());
            impRsInfo.setSn(i+"");
            impRsInfo.setProCode(provinceCode);
            impRsInfo.setProName(province);
            impRsInfo.setCityCode(cityCode);
            impRsInfo.setCityName(city);
            impRsInfo.setCountyCode(countryCode);
            impRsInfo.setCountyName(country);
            Map<String, String> map = checkRsNm(rsvrNm, adCd);
            impRsInfo.setRsCode(map.get("rsCode"));
            impRsInfo.setRegId(map.get("regId"));
            impRsInfo.setObjId(map.get("objId"));
            impRsInfo.setRsName(rsvrNm);
            impRsInfo.setEngScal(guimo);
            impRsInfo.setIsPoor(poor);
            impRsInfo.setIsCheck(repeat);
            impRsInfo.setNote(note);
            impRsInfo.setTotCap(top);
            impRsInfo.setOrgId(getOrgId(orgNm));
            impRsInfo.setOrgNm(orgNm);
            impRsInfo.setMnth(mnth);
            if(StringUtils.isNotBlank(impRsInfo.getRegId())){
                Map<String, Object> param = new HashMap<>();
                param.put("regId",impRsInfo.getRegId());
                List<Map<String, Object>> groupList = impRsInfoDao.getRegGroupList(param);
                if(groupList!=null&&groupList.size()>0){
                    Map<String, Object> group = groupList.get(0);
                    impRsInfo.setOldGroupId(String.valueOf(group.get("ID")));
                }
            }
            impRsInfoDao.insert(impRsInfo);
            i++;
        }
        return null;
    }

    @Override
    public String handleRsData(String mnth, String orgId) {
        ImpRsInfoParam impRsInfoParam = new ImpRsInfoParam();
        impRsInfoParam.setMnth(mnth);
        impRsInfoParam.setOrgId(orgId);
        List<ImpRsInfo> impRsInfos = impRsInfoDao.findList(impRsInfoParam);
        for (ImpRsInfo rsInfo:impRsInfos) {
            String orgIds = rsInfo.getOrgId();
            if(StringUtils.isBlank(orgId)){
                orgId = orgIds;
            }
            String proCode = rsInfo.getProCode();
            String cityCode = rsInfo.getCityCode();
            if(StringUtils.isNotBlank(cityCode)){
                cityCode = cityCode.substring(0,4);
            }
            String rsCode = rsInfo.getRsCode();
            String rsName = rsInfo.getRsName();
            String oldGroupId = rsInfo.getOldGroupId();
            String regId = rsInfo.getRegId();
            String objId = rsInfo.getObjId();
            if(StringUtils.isNotBlank(oldGroupId)){
                Map<String, Object> param = new HashMap<>();
                param.put("id",oldGroupId);
                List<Map<String, Object>> oldGroups = impPersInfoDao.getOldGroups(param);
                String persIds = "";
                for (Map<String, Object> oldGroup:oldGroups) {
                    String persId = String.valueOf(oldGroup.get("PERSID"));
                    persIds += persId+",";
                }
                if(StringUtils.isNotBlank(persIds)){
                    persIds = persIds.substring(0,persIds.length()-1);
                }
                param.put("id","001"+orgId);
                param.put("mnth",mnth);
                param.put("persIds",persIds);
                param.put("adCd",proCode);
                List<Map<String, Object>> newGroups = impPersInfoDao.getNewGroups(param);
                if(newGroups!=null&&newGroups.size()>0){
                    if(newGroups.size()==1){
                        Map<String, Object> newGroup = newGroups.get(0);
                        String newGroupId = String.valueOf(newGroup.get("ID"));
                        String newGroupNm = String.valueOf(newGroup.get("PNM"));
                        rsInfo.setGroupId(newGroupId);
                        rsInfo.setGroupNm(newGroupNm);
                        impRsInfoDao.update(rsInfo);
                        if(!oldGroupId.equals(newGroupId)){
                            BisInspAllObj bisInspAllObj = new BisInspAllObj();
                            bisInspAllObj.setId(newGroupId);
                            bisInspAllObj.setObjId(objId);
                            bisInspAllObjDao.update(bisInspAllObj);
                        }
                    }else {

                        param.put("regId",regId);
                        List<Map<String, Object>> newGroupsIds = impPersInfoDao.getNewGroups(param);
                        if(newGroupsIds!=null&&newGroupsIds.size()>0){
                            newGroups = newGroupsIds;
                        }
                        if(newGroups.size()==1){
                            Map<String, Object> newGroup = newGroups.get(0);
                            String newGroupId = String.valueOf(newGroup.get("ID"));
                            String newGroupNm = String.valueOf(newGroup.get("PNM"));
                            rsInfo.setGroupId(newGroupId);
                            rsInfo.setGroupNm(newGroupNm);
                            impRsInfoDao.update(rsInfo);
                            if(!oldGroupId.equals(newGroupId)){
                                BisInspAllObj bisInspAllObj = new BisInspAllObj();
                                bisInspAllObj.setId(newGroupId);
                                bisInspAllObj.setObjId(objId);
                                bisInspAllObjDao.update(bisInspAllObj);
                            }
                        }else {
                            String newGroupIds = "";
                            String newGroupNms = "";
                            boolean isHas = false;
                            for (Map<String, Object> newGroup:newGroups) {
                                String newGroupId = String.valueOf(newGroup.get("ID"));
                                String newGroupNm = String.valueOf(newGroup.get("PNM"));
                                if(oldGroupId.equals(newGroupId)){
                                    isHas = true;
                                    newGroupIds = newGroupId;
                                    newGroupNms = newGroupNm;
                                    break;
                                }
                                newGroupIds += newGroupId+",";
                                newGroupNms += newGroupNm+",";
                            }
                            if(isHas){
                                rsInfo.setGroupId(newGroupIds);
                                rsInfo.setGroupNm(newGroupNms);
                                impRsInfoDao.update(rsInfo);
                            }else{
                                if(StringUtils.isNotBlank(newGroupIds)){
                                    newGroupIds = newGroupIds.substring(0,newGroupIds.length()-1);
                                }
                                if(StringUtils.isNotBlank(newGroupNms)){
                                    newGroupNms = newGroupNms.substring(0,newGroupNms.length()-1);
                                }
                                rsInfo.setGroupId(newGroupIds);
                                rsInfo.setGroupNm(newGroupNms);
                                impRsInfoDao.update(rsInfo);
                                System.out.println("查询出多个督查组："+newGroupIds+"---"+newGroupNms);
                            }
                        }
                    }
                }else{
                    param.put("persIds","");
                    newGroups = impPersInfoDao.getNewGroups(param);
                    if(newGroups!=null&&newGroups.size()>0){
                        if(newGroups.size()==1){
                            Map<String, Object> newGroup = newGroups.get(0);
                            String newGroupId = String.valueOf(newGroup.get("ID"));
                            String newGroupNm = String.valueOf(newGroup.get("PNM"));
                            rsInfo.setGroupId(newGroupId);
                            rsInfo.setGroupNm(newGroupNm);
                            impRsInfoDao.update(rsInfo);
                            if(!oldGroupId.equals(newGroupId)){
                                BisInspAllObj bisInspAllObj = new BisInspAllObj();
                                bisInspAllObj.setId(newGroupId);
                                bisInspAllObj.setObjId(objId);
                                bisInspAllObjDao.update(bisInspAllObj);
                            }
                        }else{
                            param.put("adCd",cityCode);
                            newGroups = impPersInfoDao.getNewGroups(param);
                            if(newGroups!=null&&newGroups.size()>0){
                                if(newGroups.size()==1){
                                    Map<String, Object> newGroup = newGroups.get(0);
                                    String newGroupId = String.valueOf(newGroup.get("ID"));
                                    String newGroupNm = String.valueOf(newGroup.get("PNM"));
                                    rsInfo.setGroupId(newGroupId);
                                    rsInfo.setGroupNm(newGroupNm);
                                    impRsInfoDao.update(rsInfo);
                                    if(!oldGroupId.equals(newGroupId)){
                                        BisInspAllObj bisInspAllObj = new BisInspAllObj();
                                        bisInspAllObj.setId(newGroupId);
                                        bisInspAllObj.setObjId(objId);
                                        bisInspAllObjDao.update(bisInspAllObj);
                                    }
                                }else {
                                    for (Map<String, Object> newGroup:newGroups) {

                                    }
                                }
                            }else{
                                
                            }
                        }
                    }else {
                        System.out.println("原督查组未与现有督查组人员匹配上");
                    }
                }
            }else{
                Map<String, Object> param = new HashMap<>();
                param.put("id","001"+orgId);
                param.put("mnth",mnth);
                param.put("adCd",proCode);
                List<Map<String, Object>> newGroups = impPersInfoDao.getNewGroups(param);
                String newGroupId;
                String newGroupNm;
                if(newGroups!=null&&newGroups.size()>0){
                    newGroupId = String.valueOf(newGroups.get(0).get("ID"));
                    newGroupNm = String.valueOf(newGroups.get(0).get("PNM"));
                    BisInspAllObj bisInspAllObj = new BisInspAllObj();
                    AttRsBaseParam baseParam = new AttRsBaseParam();
                    baseParam.setRsCode(rsCode);
                    AttRsBase attRsBase = attRsBaseDao.getBy(baseParam);
                    BisInspRsvrRgstr b = new BisInspRsvrRgstr();
                    regId = UuidUtil.uuid();
                    b.setRgstrId(regId);
                    b.setObjId(newGroupId);
                    b.setRsCode(attRsBase.getRsCode());
                    b.setRsvrNm(newGroupNm);
                    b.setAdCode(attRsBase.getAdmDiv());
                    b.setRsvrAdmName(attRsBase.getRsAdmName());
                    if(attRsBase.getDamSizeHig()==null){
                        b.setDamMaxHigh(null);
                    }else {
                        b.setDamMaxHigh(Double.toString(attRsBase.getDamSizeHig()));
                    }
                    b.setEngScal(attRsBase.getEngScal());
                    if(StringUtils.isNotBlank(attRsBase.getLocation())){
                        b.setHystSite(attRsBase.getLocation());
                    }else {
                        b.setHystSite(attRsBase.getRsLoc());
                    }
                    if(attRsBase.getCenterYGd()!=null){
                        bisInspAllObj.setLttd(Double.parseDouble(attRsBase.getCenterYGd()));
                        b.setRsvrLat(Double.parseDouble(attRsBase.getCenterYGd()));
                    }
                    if(attRsBase.getCenterXGd()!=null){
                        bisInspAllObj.setLgtd(Double.parseDouble(attRsBase.getCenterXGd()));
                        b.setRsvrLong(Double.parseDouble(attRsBase.getCenterXGd()));
                    }
                    if(attRsBase.getCenterX()!=null){
                        bisInspAllObj.setLgtdpc(Double.parseDouble(attRsBase.getCenterX()));
                    }
                    if(attRsBase.getCenterY()!=null){
                        bisInspAllObj.setLttdpc(Double.parseDouble(attRsBase.getCenterY()));
                    }
                    b.setResCreateTime(attRsBase.getCompDate());
                    b.setTotCap(attRsBase.getTotCap());
                    b.setDamRegCode(attRsBase.getRegCode());
                    b.setDamType(attRsBase.getDamType());
                    b.setHasDamRegCode("1");
                    b.setState("0");
                    b.setCompDateStr(attRsBase.getCompDateStr());
                    b.setPresStat("0");
                    b.setBaseStat("0");
                    b.setResRunStat("0");
                    b.setViewStat("0");
                    b.setDataStat("0");
                    Date date = new Date();
                    b.setIntm(date);
                    b.setUptm(date);
                    rsvrRgstrService.insert(b);
                    objId = UuidUtil.uuid();
                    bisInspAllObj.setPtype("1");
                    bisInspAllObj.setId(newGroupId);
                    bisInspAllObj.setObjId(objId);
                    bisInspAllObj.setCode(rsCode);
                    bisInspAllObj.setNm(rsName);
                    bisInspAllObjDao.insert(bisInspAllObj);
                    rsInfo.setGroupId(newGroupId);
                    rsInfo.setGroupNm(newGroupNm);
                    rsInfo.setRegId(regId);
                    rsInfo.setObjId(objId);
                    impRsInfoDao.update(rsInfo);
                }else{

                }
            }
        }
        return null;
    }

    @Override
    public String insertFlkdisList(MultipartFile file) {
        List<ExcelInspRsDto> rsvrObjList=new ArrayList<>();
        InputStream is = null;
        try {
            is = file.getInputStream();
            // 构造 XSSFWorkbook 对象，strPath 传入文件路径
            XSSFWorkbook xwb = new XSSFWorkbook(is);
            // 读取第一章表格内容
            XSSFSheet sheet = xwb.getSheetAt(1);
            // 定义 row、cell
            XSSFRow row;
            String cell;
            for (int i = sheet.getFirstRowNum()+3; i < sheet.getPhysicalNumberOfRows(); i++) {
                row = sheet.getRow(i);
                ExcelInspRsDto rsvrObj = new ExcelInspRsDto();
                int total = row.getPhysicalNumberOfCells();
                AttJskejianFlkdisBase jskejianFlkdisBase = new AttJskejianFlkdisBase();
                String shi="";
                String xian="";
                String lkName="";
                String cun="";
                String jdu="";
                String jfen="";
                String jm="";
                String wdu="";
                String wfen="";
                String wm="";
                String xianz="";
                String xiangz="";
                String cunz="";
                String pblmdesc="";
                String pblmType="";
                String zhan="";
                String cai="";
                String dui="";
                String jian="";
                String qita="";
                String xiao="";
                for (int j = row.getFirstCellNum(); j < total; j++) {
                    if(row.getCell(j)==null){
                        continue;
                    }
                    cell = row.getCell(j).toString();
                    cell = cell.trim();
                    if(j==1){
                        shi = cell;
                    }else if(j==2){
                        xian = cell;
                    }else if(j==3){
                        lkName = cell;
                    }else if(j==4){
                        cun = cell;
                    }else if(j==5){
                        jdu = cell;
                    }else if(j==6){
                        jfen = cell;
                    }else if(j==7){
                        jm = cell;
                    }else if(j==8){
                        wdu = cell;
                    }else if(j==9){
                        wfen = cell;
                    }else if(j==10){
                        wm = cell;
                    }else if(j==11){
                        xianz = cell;
                    }else if(j==12){
                        xiangz = cell;
                    }else if(j==13){
                        cunz = cell;
                    }else if(j==14){
                        pblmdesc = cell;
                    }else if(j==15){
                        zhan = cell;
                        if(StringUtils.isNotBlank(cell)) {
                            pblmType="1";
                        }
                    }else if(j==16){
                        cai = cell;
                        if(StringUtils.isNotBlank(cell)) {
                            pblmType="2";
                        }
                    }else if(j==17){
                        dui = cell;
                        if(StringUtils.isNotBlank(cell)) {
                            pblmType="3";
                        }
                    }else if(j==18){
                        jian = cell;
                        if(StringUtils.isNotBlank(cell)) {
                            pblmType="4";
                        }
                    }else if(j==19){
                        qita = cell;
                        if(StringUtils.isNotBlank(cell)) {
                            pblmType="5";
                        }
                    }else if(j==20){
                        xiao = cell;
                        if(xiao.contains(".")){
                            xiao = xiao.substring(0,xiao.indexOf("."));
                        }
                    }
                }
                jskejianFlkdisBase.setId(UuidUtil.uuid());
                String name = lkName + "("+shi+xian+cun+")";
                jskejianFlkdisBase.setName(name);
                String adCode = getAdCd("福建省",shi,xian);
                jskejianFlkdisBase.setAdCode(adCode);
                jskejianFlkdisBase.setAdName(xian);
                jskejianFlkdisBase.setRvReaLkName(lkName);
                jskejianFlkdisBase.setLocation(cun);
                jskejianFlkdisBase.setContRvonNameDuty(xianz);
                jskejianFlkdisBase.setTownRvonNameDuty(xiangz);
                jskejianFlkdisBase.setVilgRvonNameDuty(cunz);
                jskejianFlkdisBase.setPblmDesc(pblmdesc);
                jskejianFlkdisBase.setPblmType(pblmType);
                jskejianFlkdisBase.setRectConc(xiao);
                double d = 0.0;
                double f = 0.0;
                double m = 0.0;
                if(StringUtils.isNotBlank(jdu)) {
                    d = Double.parseDouble(jdu);
                }
                if(StringUtils.isNotBlank(jfen)) {
                    f = Double.parseDouble(jfen);
                }
                if(StringUtils.isNotBlank(jm)) {
                    m = Double.parseDouble(jm);
                }
                double fen = f + (m / 60);
                double du = (fen / 60) + Math.abs(d);
                if (d < 0) {
                    du = -du;
                }
                jskejianFlkdisBase.setCenterX(Double.parseDouble(String.format("%.8f", du)));
                d = 0.0;
                f = 0.0;
                m = 0.0;
                if(StringUtils.isNotBlank(wdu)) {
                    d = Double.parseDouble(wdu);
                }
                if(StringUtils.isNotBlank(wfen)) {
                    f = Double.parseDouble(wfen);
                }
                if(StringUtils.isNotBlank(wm)) {
                    m = Double.parseDouble(wm);
                }
                fen = f + (m / 60);
                du = (fen / 60) + Math.abs(d);
                if (d < 0) {
                    du = -du;
                }
                jskejianFlkdisBase.setCenterY(Double.parseDouble(String.format("%.8f", du)));
                Map<String, Double> map = GeoUtil.wgs84togcj02(jskejianFlkdisBase.getCenterX(),jskejianFlkdisBase.getCenterY());
                jskejianFlkdisBase.setGdX(map.get("lon"));
                jskejianFlkdisBase.setGdY(map.get("lat"));
                jskejianFlkdisBaseDao.insert(jskejianFlkdisBase);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
    @Override
    public String insertWaterList(MultipartFile file) {
        InputStream is = null;
        try {
            is = file.getInputStream();
            // 构造 XSSFWorkbook 对象，strPath 传入文件路径
            XSSFWorkbook xwb = new XSSFWorkbook(is);
            // 读取第一章表格内容
            XSSFSheet sheet = xwb.getSheetAt(0);
            // 定义 row、cell
            XSSFRow row;
            String cell;
            for (int i = sheet.getFirstRowNum()+3; i < sheet.getPhysicalNumberOfRows(); i++) {
                row = sheet.getRow(i);
                int total = row.getPhysicalNumberOfCells();
                AttJskejianWaterBase jskejianWaterBase = new AttJskejianWaterBase();
                String shi="";
                String xian="";
                String lkName="";
                String xiang = "";
                String cun="";
                String jdfm="";
                String wdfm="";
                String pblmdesc="";
                String pblmType="";
                for (int j = row.getFirstCellNum(); j < total; j++) {
                    if(row.getCell(j)==null){
                        continue;
                    }
                    cell = row.getCell(j).toString();
                    cell = cell.trim();
                    if(j==1){
                        shi = cell;
                    }else if(j==2){
                        xian = cell;
                    }else if(j==3){
                        lkName = cell;
                    }else if(j==4){
                        xiang = cell;
                    }else if(j==5){
                        cun = cell;
                    }else if(j==6){
                        jdfm = cell;
                    }else if(j==7){
                        wdfm = cell;
                    }else if(j==8){
                        pblmType = cell;
                    }else if(j==9){
                        pblmdesc = cell;
                    }
                }
                jskejianWaterBase.setId(UuidUtil.uuid());
                String name = lkName + "("+shi+xian+xiang+cun+")";
                jskejianWaterBase.setName(name);
                String adCode = getAdCd("福建省",shi,xian);
                jskejianWaterBase.setAdCode(adCode);
                jskejianWaterBase.setAdName(xian);
                jskejianWaterBase.setRvReaLkName(lkName);
                jskejianWaterBase.setLocation(shi+xian+xiang+cun);
                jskejianWaterBase.setAerialPoint(cun);
                jskejianWaterBase.setPblmDesc(pblmdesc);
                jskejianWaterBase.setPblmType(pblmType);
                jskejianWaterBase.setRectConc("1");
                Double x = changeToDu(jdfm);
                jskejianWaterBase.setCenterX(Double.parseDouble(String.format("%.8f", x)));
                Double y = changeToDu(wdfm);
                jskejianWaterBase.setCenterY(Double.parseDouble(String.format("%.8f", y)));
                Map<String, Double> map = GeoUtil.wgs84togcj02(jskejianWaterBase.getCenterX(),jskejianWaterBase.getCenterY());
                jskejianWaterBase.setGdX(map.get("lon"));
                jskejianWaterBase.setGdY(map.get("lat"));
                jskejianWaterBaseDao.insert(jskejianWaterBase);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
    @Override
    public String insertEcofrdList(MultipartFile file) {
        InputStream is = null;
        try {
            is = file.getInputStream();
            // 构造 XSSFWorkbook 对象，strPath 传入文件路径
            XSSFWorkbook xwb = new XSSFWorkbook(is);
            // 读取第一章表格内容
            XSSFSheet sheet = xwb.getSheetAt(0);
            // 定义 row、cell
            XSSFRow row;
            String cell;
            for (int i = sheet.getFirstRowNum()+1; i < sheet.getPhysicalNumberOfRows(); i++) {
                row = sheet.getRow(i);
                int total = row.getPhysicalNumberOfCells();
                AttJskejianEcofrdBase jskejianEcofrdBase = new AttJskejianEcofrdBase();
                String shi="";
                String xian="";
                for (int j = row.getFirstCellNum(); j < total; j++) {
                    if(row.getCell(j)==null){
                        continue;
                    }
                    cell = row.getCell(j).toString();
                    if(StringUtils.isNotBlank(cell)){
                        cell = cell.replaceAll(" ","");
                        cell=cell.replaceAll("[\\t\\n\\r]", "");//将内容区域的回车换行去除
                    }
                    if(j==1){
                        shi = cell;
                    }else if(j==2){
                        xian = cell;
                    }else if(j==3){
                        jskejianEcofrdBase.setAccepNum(cell);
                    }else if(j==4){
                        jskejianEcofrdBase.setAssignNum(cell);
                    }else if(j==5){
                        jskejianEcofrdBase.setReportContent(cell);
                    }else if(j==6){
                        jskejianEcofrdBase.setBiz(cell);
                    }else if(j==7){

                    }else if(j==8){
                        jskejianEcofrdBase.setHostUnit(cell);
                    }else if(j==9){
                        jskejianEcofrdBase.setSptUnit(cell);
                    }else if(j==10){

                    }else if(j==11){
                        jskejianEcofrdBase.setIsOver(cell);
                    }else if(j==12){

                    }else if(j==13){
                        jskejianEcofrdBase.setInvstVfctn(cell);
                    }else if(j==14){
                        jskejianEcofrdBase.setTrtmtRctftn(cell);
                    }else if(j==15){
                        jskejianEcofrdBase.setOpinion(cell);
                    }else if(j==16){
                        jskejianEcofrdBase.setOffice(cell);
                    }
                }
                jskejianEcofrdBase.setId(UuidUtil.uuid());
                String adCode = getAdCd("福建省",shi,xian);
                jskejianEcofrdBase.setAdCode(adCode);
                jskejianEcofrdBase.setAdName(xian);
                jskejianEcofrdBase.setLocation("福建省"+shi+xian);
                jskejianEcofrdBaseDao.insert(jskejianEcofrdBase);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
    /**
     * 度分秒转经纬度
     * @param dms 116°25'7.85"
     * @return 116.418847
     */
    public static double changeToDu(String dms) {
        if (dms == null) {
            return 0;
        }
        try {
            dms = dms.replace(" ", "");
            String[] str2 = dms.split("°");
            if (str2.length < 2) {
                return 0;
            }
            int d = Integer.parseInt(str2[0]);
            String[] str3 = str2[1].split("\'");
            if (str3.length < 2) {
                return 0;
            }
            int f = Integer.parseInt(str3[0]);
            String str4 = str3[1].substring(0, str3[1].length() - 1);
            double m = Double.parseDouble(str4);

            double fen = f + (m / 60);
            double du = (fen / 60) + Math.abs(d);
            if (d < 0) {
                du = -du;
            }
            return du;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return 0;
    }

    public String getAdCd(String sheng,String shi, String xian){
        String adCd = "";
        AttAdXBaseParam attAdXBaseParam = new AttAdXBaseParam();
        AttAdXBase attAdXBase;
        if(StringUtils.isNotBlank(sheng)){
            attAdXBaseParam.setAdName(sheng);
            attAdXBaseParam.setAdGrad("2");
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                String shengCode = attAdXBase.getAdCode();
                attAdXBaseParam.setAdFcode(shengCode);
                adCd = shengCode;
            }else {
                attAdXBaseParam.setAdName("");
                attAdXBaseParam.setAdFullName(sheng);
                attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                if(attAdXBase!=null){
                    String shengCode = attAdXBase.getAdCode();
                    attAdXBaseParam.setAdFcode(shengCode);
                    adCd = shengCode;
                }
            }
        }
        if(StringUtils.isNotBlank(shi)){
            attAdXBaseParam.setAdName(shi);
            attAdXBaseParam.setAdGrad("3");
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                String shiCode = attAdXBase.getAdCode();
                attAdXBaseParam.setAdFcode(shiCode);
                adCd = shiCode;
            }else {
                attAdXBaseParam.setAdName("");
                attAdXBaseParam.setAdFullName(shi);
                attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                if(attAdXBase!=null){
                    String shiCode = attAdXBase.getAdCode();
                    attAdXBaseParam.setAdFcode(shiCode);
                    adCd = shiCode;
                }
            }
        }
        if(StringUtils.isNotBlank(xian)){
            attAdXBaseParam.setAdName(xian);
            attAdXBaseParam.setAdGrad("4");
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                adCd = attAdXBase.getAdCode();
            }else{
                attAdXBaseParam.setAdName("");
                attAdXBaseParam.setAdFullName(xian);
                attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                if(attAdXBase!=null){
                    adCd = attAdXBase.getAdCode();
                }
            }
        }
        return adCd;
    }

    public Map<String, String> getAdCds(String sheng, String shi, String xian){
        Map<String, String> map = new HashMap<>();
        AttAdXBaseParam attAdXBaseParam = new AttAdXBaseParam();
        attAdXBaseParam.setAdName(sheng);
        attAdXBaseParam.setAdGrad("2");
        AttAdXBase attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
        if(attAdXBase!=null){
            String shengCode = attAdXBase.getAdCode();
            attAdXBaseParam.setAdFcode(shengCode);
            map.put("sheng",shengCode);
        }else {
            attAdXBaseParam.setAdName("");
            attAdXBaseParam.setAdFullName(sheng);
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                String shengCode = attAdXBase.getAdCode();
                attAdXBaseParam.setAdFcode(shengCode);
                map.put("sheng",shengCode);
            }
        }
        if(StringUtils.isNotBlank(shi)){
            attAdXBaseParam.setAdName(shi);
            attAdXBaseParam.setAdGrad("3");
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                String shiCode = attAdXBase.getAdCode();
                attAdXBaseParam.setAdFcode(shiCode);
                map.put("shi",shiCode);
            }else {
                attAdXBaseParam.setAdName("");
                attAdXBaseParam.setAdFullName(shi);
                attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                if(attAdXBase!=null){
                    String shiCode = attAdXBase.getAdCode();
                    attAdXBaseParam.setAdFcode(shiCode);
                    map.put("shi",shiCode);
                }else {
                    attAdXBaseParam.setAdFcode("");
                    attAdXBaseParam.setAdCode(map.get("sheng").substring(0,2));
                }
            }
        }else{
            attAdXBaseParam.setAdFcode("");
            attAdXBaseParam.setAdCode(map.get("sheng").substring(0,2));
        }
        if(StringUtils.isNotBlank(xian)){
            attAdXBaseParam.setAdName(xian);
            attAdXBaseParam.setAdGrad("4");
            attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
            if(attAdXBase!=null){
                String xianCode = attAdXBase.getAdCode();
                map.put("xian",xianCode);
                if (StringUtils.isBlank(map.get("shi"))){
                    map.put("shi",attAdXBase.getAdFcode());
                }
            }else{
                attAdXBaseParam.setAdName("");
                attAdXBaseParam.setAdFullName(xian);
                attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                if(attAdXBase!=null){
                    String xianCode = attAdXBase.getAdCode();
                    map.put("xian",xianCode);
                    if (StringUtils.isBlank(map.get("shi"))){
                        map.put("shi",attAdXBase.getAdFcode());
                    }
                }else{
                    if(xian.endsWith("县")||xian.endsWith("区")){
                        xian = xian.substring(0,xian.length()-1);
                    }
                    attAdXBaseParam.setAdName(xian);
                    attAdXBaseParam.setAdGrad("4");
                    attAdXBase = attAdXBaseService.getBy(attAdXBaseParam);
                    if(attAdXBase!=null){
                        String xianCode = attAdXBase.getAdCode();
                        map.put("xian",xianCode);
                        if (StringUtils.isBlank(map.get("shi"))){
                            map.put("shi",attAdXBase.getAdFcode());
                        }
                    }
                }
            }
        }
        return map;
    }

    public String getOrgId(String orgNm){
        String orgId = "";
        if("长江委".equals(orgNm)){
            orgId= "020";
        }else if("黄委".equals(orgNm)){
            orgId= "021";
        }else if("淮委".equals(orgNm)){
            orgId= "022";
        }else if("海委".equals(orgNm)){
            orgId= "023";
        }else if("珠江委".equals(orgNm)){
            orgId= "024";
        }else if("松辽委".equals(orgNm)){
            orgId= "025";
        }else if("太湖局".equals(orgNm)){
            orgId= "026";
        }else if("部督查办".equals(orgNm)){
            orgId= "027";
        }
        return orgId;
    }

    public Map<String, String> checkRsNm(String rsvrNm, String adCd){
        Map<String, String> map;
        map = checkRgstrs(rsvrNm, adCd);
        if(StringUtils.isBlank(map.get("rsCode"))){
            map = checkRsBase(rsvrNm, adCd);
        }
        return map;
    }
    public Map<String, String> checkRgstrs(String rsvrNm, String adCd){
        Map<String, String> map = new HashMap<>();
        BisInspRsvrRgstrParam bisInspRsvrRgstrParam = new BisInspRsvrRgstrParam();
        bisInspRsvrRgstrParam.setAdCode(adCd);
        bisInspRsvrRgstrParam.setRsvrNm(rsvrNm);
        List<BisInspRsvrRgstr> rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
        if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
            if(rsvrRgstrs.size()>1){
                for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                    String name = rsvrRgstr.getRsvrNm();
                    if(rsvrNm.equals(name)){
                        map.put("rsCode",rsvrRgstr.getRsCode());
                        map.put("rsName",rsvrRgstr.getRsvrNm());
                        map.put("regId",rsvrRgstr.getRgstrId());
                        map.put("objId",rsvrRgstr.getObjId());
                    }
                }
            }else{
                BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                map.put("rsCode",rsvrRgstr.getRsCode());
                map.put("rsName",rsvrRgstr.getRsvrNm());
                map.put("regId",rsvrRgstr.getRgstrId());
                map.put("objId",rsvrRgstr.getObjId());
            }
            if(StringUtils.isBlank(map.get("rsCode"))){
                bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,4));
                rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                    if(rsvrRgstrs.size()>1){
                        for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                            String name = rsvrRgstr.getRsvrNm();
                            if(rsvrNm.equals(name)){
                                map.put("rsCode",rsvrRgstr.getRsCode());
                                map.put("rsName",rsvrRgstr.getRsvrNm());
                                map.put("regId",rsvrRgstr.getRgstrId());
                                map.put("objId",rsvrRgstr.getObjId());
                            }
                        }
                    }else{
                        BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                        map.put("rsCode",rsvrRgstr.getRsCode());
                        map.put("rsName",rsvrRgstr.getRsvrNm());
                        map.put("regId",rsvrRgstr.getRgstrId());
                        map.put("objId",rsvrRgstr.getObjId());
                    }
                    if(StringUtils.isBlank(map.get("rsCode"))){
                        bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,2));
                        rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                        if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                            if(rsvrRgstrs.size()>1){
                                for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                    String name = rsvrRgstr.getRsvrNm();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",rsvrRgstr.getRsCode());
                                        map.put("rsName",rsvrRgstr.getRsvrNm());
                                        map.put("regId",rsvrRgstr.getRgstrId());
                                        map.put("objId",rsvrRgstr.getObjId());
                                    }
                                }
                            }else{
                                BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                                map.put("rsCode",rsvrRgstr.getRsCode());
                                map.put("rsName",rsvrRgstr.getRsvrNm());
                                map.put("regId",rsvrRgstr.getRgstrId());
                                map.put("objId",rsvrRgstr.getObjId());
                            }
                        }
                    }
                }
            }
        }else{
            bisInspRsvrRgstrParam.setRsvrNm(rsvrNm.replaceAll("水库",""));
            rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
            if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                if(rsvrRgstrs.size()>1){
                    for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                        String name = rsvrRgstr.getRsvrNm();
                        if(rsvrNm.equals(name)){
                            map.put("rsCode",rsvrRgstr.getRsCode());
                            map.put("rsName",rsvrRgstr.getRsvrNm());
                            map.put("regId",rsvrRgstr.getRgstrId());
                            map.put("objId",rsvrRgstr.getObjId());
                        }
                    }
                }else{
                    BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                    map.put("rsCode",rsvrRgstr.getRsCode());
                    map.put("rsName",rsvrRgstr.getRsvrNm());
                    map.put("regId",rsvrRgstr.getRgstrId());
                    map.put("objId",rsvrRgstr.getObjId());
                }
                if(StringUtils.isBlank(map.get("rsCode"))){
                    bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,4));
                    rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                    if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                        if(rsvrRgstrs.size()>1){
                            for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                String name = rsvrRgstr.getRsvrNm();
                                if(rsvrNm.equals(name)){
                                    map.put("rsCode",rsvrRgstr.getRsCode());
                                    map.put("rsName",rsvrRgstr.getRsvrNm());
                                    map.put("regId",rsvrRgstr.getRgstrId());
                                    map.put("objId",rsvrRgstr.getObjId());
                                }
                            }
                        }else{
                            BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                            map.put("rsCode",rsvrRgstr.getRsCode());
                            map.put("rsName",rsvrRgstr.getRsvrNm());
                            map.put("regId",rsvrRgstr.getRgstrId());
                            map.put("objId",rsvrRgstr.getObjId());
                        }
                        if(StringUtils.isBlank(map.get("rsCode"))){
                            bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,2));
                            rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                            if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                                if(rsvrRgstrs.size()>1){
                                    for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                        String name = rsvrRgstr.getRsvrNm();
                                        if(rsvrNm.equals(name)){
                                            map.put("rsCode",rsvrRgstr.getRsCode());
                                            map.put("rsName",rsvrRgstr.getRsvrNm());
                                            map.put("regId",rsvrRgstr.getRgstrId());
                                            map.put("objId",rsvrRgstr.getObjId());
                                        }
                                    }
                                }else{
                                    BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                                    map.put("rsCode",rsvrRgstr.getRsCode());
                                    map.put("rsName",rsvrRgstr.getRsvrNm());
                                    map.put("regId",rsvrRgstr.getRgstrId());
                                    map.put("objId",rsvrRgstr.getObjId());
                                }
                            }
                        }
                    }else{
                        bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,2));
                        rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                        if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                            if(rsvrRgstrs.size()>1){
                                for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                    String name = rsvrRgstr.getRsvrNm();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",rsvrRgstr.getRsCode());
                                        map.put("rsName",rsvrRgstr.getRsvrNm());
                                        map.put("regId",rsvrRgstr.getRgstrId());
                                        map.put("objId",rsvrRgstr.getObjId());
                                    }
                                }
                            }else{
                                BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                                map.put("rsCode",rsvrRgstr.getRsCode());
                                map.put("rsName",rsvrRgstr.getRsvrNm());
                                map.put("regId",rsvrRgstr.getRgstrId());
                                map.put("objId",rsvrRgstr.getObjId());
                            }
                        }
                    }
                }
            }else{
                bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,4));
                rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                    if(rsvrRgstrs.size()>1){
                        for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                            String name = rsvrRgstr.getRsvrNm();
                            if(rsvrNm.equals(name)){
                                map.put("rsCode",rsvrRgstr.getRsCode());
                                map.put("rsName",rsvrRgstr.getRsvrNm());
                                map.put("regId",rsvrRgstr.getRgstrId());
                                map.put("objId",rsvrRgstr.getObjId());
                            }
                        }
                    }else{
                        BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                        map.put("rsCode",rsvrRgstr.getRsCode());
                        map.put("rsName",rsvrRgstr.getRsvrNm());
                        map.put("regId",rsvrRgstr.getRgstrId());
                        map.put("objId",rsvrRgstr.getObjId());
                    }
                    if(StringUtils.isBlank(map.get("rsCode"))){
                        bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,2));
                        rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                        if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                            if(rsvrRgstrs.size()>1){
                                for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                    String name = rsvrRgstr.getRsvrNm();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",rsvrRgstr.getRsCode());
                                        map.put("rsName",rsvrRgstr.getRsvrNm());
                                        map.put("regId",rsvrRgstr.getRgstrId());
                                        map.put("objId",rsvrRgstr.getObjId());
                                    }
                                }
                            }else{
                                BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                                map.put("rsCode",rsvrRgstr.getRsCode());
                                map.put("rsName",rsvrRgstr.getRsvrNm());
                                map.put("regId",rsvrRgstr.getRgstrId());
                                map.put("objId",rsvrRgstr.getObjId());
                            }
                        }
                    }
                }else{
                    bisInspRsvrRgstrParam.setAdCode(adCd.substring(0,2));
                    rsvrRgstrs = rsvrRgstrService.findList(bisInspRsvrRgstrParam);
                    if(rsvrRgstrs!=null&&rsvrRgstrs.size()>0){
                        if(rsvrRgstrs.size()>1){
                            for (BisInspRsvrRgstr rsvrRgstr:rsvrRgstrs) {
                                String name = rsvrRgstr.getRsvrNm();
                                if(rsvrNm.equals(name)){
                                    map.put("rsCode",rsvrRgstr.getRsCode());
                                    map.put("rsName",rsvrRgstr.getRsvrNm());
                                    map.put("regId",rsvrRgstr.getRgstrId());
                                    map.put("objId",rsvrRgstr.getObjId());
                                }
                            }
                        }else{
                            BisInspRsvrRgstr rsvrRgstr = rsvrRgstrs.get(0);
                            map.put("rsCode",rsvrRgstr.getRsCode());
                            map.put("rsName",rsvrRgstr.getRsvrNm());
                            map.put("regId",rsvrRgstr.getRgstrId());
                            map.put("objId",rsvrRgstr.getObjId());
                        }
                    }
                }
            }
        }
        return map;
    }

    public Map<String, String> checkRsBase(String rsvrNm, String adCd){
        Map<String, String> map = new HashMap<>();
        AttRsBaseParam rsBaseParam = new AttRsBaseParam();
        rsBaseParam.setAdmDiv(adCd);
        rsBaseParam.setRsName(rsvrNm);
        List<AttRsBase> rsBaseList = attRsBaseService.findRsList(rsBaseParam);
        if(rsBaseList!=null&&rsBaseList.size()>0){
            if(rsBaseList.size()>1){
                for (AttRsBase attRs:rsBaseList) {
                    String name = attRs.getRsName();
                    if(rsvrNm.equals(name)){
                        map.put("rsCode",attRs.getRsCode());
                    }
                }
            }else{
                AttRsBase attRs = rsBaseList.get(0);
                map.put("rsCode",attRs.getRsCode());
            }
            if(StringUtils.isBlank(map.get("rsCode"))){
                rsBaseParam.setAdmDiv(adCd.substring(0,4));
                rsBaseParam.setRsName(rsvrNm);
                rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                if(rsBaseList!=null&&rsBaseList.size()>0){
                    if(rsBaseList.size()>1){
                        for (AttRsBase attRs:rsBaseList) {
                            String name = attRs.getRsName();
                            if(rsvrNm.equals(name)){
                                map.put("rsCode",attRs.getRsCode());
                            }
                        }
                    }else{
                        AttRsBase attRs = rsBaseList.get(0);
                        map.put("rsCode",attRs.getRsCode());
                    }
                    if(StringUtils.isBlank(map.get("rsCode"))){
                        rsBaseParam.setAdmDiv(adCd.substring(0,2));
                        rsBaseParam.setRsName(rsvrNm);
                        rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                        if(rsBaseList!=null&&rsBaseList.size()>0){
                            if(rsBaseList.size()>1){
                                for (AttRsBase attRs:rsBaseList) {
                                    String name = attRs.getRsName();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",attRs.getRsCode());
                                    }
                                }
                            }else{
                                AttRsBase attRs = rsBaseList.get(0);
                                map.put("rsCode",attRs.getRsCode());
                            }
                        }
                    }
                }
            }
        }else{
            rsBaseParam.setRsName(rsvrNm.replaceAll("水库",""));
            rsBaseList = attRsBaseService.findRsList(rsBaseParam);
            if(rsBaseList!=null&&rsBaseList.size()>0){
                if(rsBaseList.size()>1){
                    for (AttRsBase attRs:rsBaseList) {
                        String name = attRs.getRsName();
                        if(rsvrNm.equals(name)){
                            map.put("rsCode",attRs.getRsCode());
                        }
                    }
                }else{
                    AttRsBase attRs = rsBaseList.get(0);
                    map.put("rsCode",attRs.getRsCode());
                }
                if(StringUtils.isBlank(map.get("rsCode"))){
                    rsBaseParam.setAdmDiv(adCd.substring(0,4));
                    rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                    if(rsBaseList!=null&&rsBaseList.size()>0){
                        if(rsBaseList.size()>1){
                            for (AttRsBase attRs:rsBaseList) {
                                String name = attRs.getRsName();
                                if(rsvrNm.equals(name)){
                                    map.put("rsCode",attRs.getRsCode());
                                }
                            }
                        }else{
                            AttRsBase attRs = rsBaseList.get(0);
                            map.put("rsCode",attRs.getRsCode());
                        }
                        if(StringUtils.isBlank(map.get("rsCode"))){
                            rsBaseParam.setAdmDiv(adCd.substring(0,2));
                            rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                            if(rsBaseList!=null&&rsBaseList.size()>0){
                                if(rsBaseList.size()>1){
                                    for (AttRsBase attRs:rsBaseList) {
                                        String name = attRs.getRsName();
                                        if(rsvrNm.equals(name)){
                                            map.put("rsCode",attRs.getRsCode());
                                        }
                                    }
                                }else{
                                    AttRsBase attRs = rsBaseList.get(0);
                                    map.put("rsCode",attRs.getRsCode());
                                }
                            }
                        }
                    }else{
                        rsBaseParam.setAdmDiv(adCd.substring(0,2));
                        rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                        if(rsBaseList!=null&&rsBaseList.size()>0){
                            if(rsBaseList.size()>1){
                                for (AttRsBase attRs:rsBaseList) {
                                    String name = attRs.getRsName();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",attRs.getRsCode());
                                    }
                                }
                            }else{
                                AttRsBase attRs = rsBaseList.get(0);
                                map.put("rsCode",attRs.getRsCode());
                            }
                        }
                    }
                }
            }else{
                rsBaseParam.setAdmDiv(adCd.substring(0,4));
                rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                if(rsBaseList!=null&&rsBaseList.size()>0){
                    if(rsBaseList.size()>1){
                        for (AttRsBase attRs:rsBaseList) {
                            String name = attRs.getRsName();
                            if(rsvrNm.equals(name)){
                                map.put("rsCode",attRs.getRsCode());
                            }
                        }
                    }else{
                        AttRsBase attRs = rsBaseList.get(0);
                        map.put("rsCode",attRs.getRsCode());
                    }
                    if(StringUtils.isBlank(map.get("rsCode"))){
                        rsBaseParam.setAdmDiv(adCd.substring(0,2));
                        rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                        if(rsBaseList!=null&&rsBaseList.size()>0){
                            if(rsBaseList.size()>1){
                                for (AttRsBase attRs:rsBaseList) {
                                    String name = attRs.getRsName();
                                    if(rsvrNm.equals(name)){
                                        map.put("rsCode",attRs.getRsCode());
                                    }
                                }
                            }else{
                                AttRsBase attRs = rsBaseList.get(0);
                                map.put("rsCode",attRs.getRsCode());
                            }
                        }
                    }
                }else{
                    rsBaseParam.setAdmDiv(adCd.substring(0,2));
                    rsBaseList = attRsBaseService.findRsList(rsBaseParam);
                    if(rsBaseList!=null&&rsBaseList.size()>0){
                        if(rsBaseList.size()>1){
                            for (AttRsBase attRs:rsBaseList) {
                                String name = attRs.getRsName();
                                if(rsvrNm.equals(name)){
                                    map.put("rsCode",attRs.getRsCode());
                                }
                            }
                        }else{
                            AttRsBase attRs = rsBaseList.get(0);
                            map.put("rsCode",attRs.getRsCode());
                        }
                    }
                }
            }

        }
        return map;
    }

    public static List<ExcelInspRsDto> getRsvrObjListByFile(MultipartFile file){
        List<ExcelInspRsDto> rsvrObjList=new ArrayList<>();
        try{
            InputStream is = file.getInputStream();
            // 构造 XSSFWorkbook 对象，strPath 传入文件路径
            XSSFWorkbook xwb = new XSSFWorkbook(is);
            // 读取第一章表格内容
            XSSFSheet sheet = xwb.getSheetAt(1);
            // 定义 row、cell
            XSSFRow row;
            String cell;
            // 循环输出表格中的内容

            for (int i = sheet.getFirstRowNum()+3; i < sheet.getPhysicalNumberOfRows(); i++) {
                row = sheet.getRow(i);
                ExcelInspRsDto rsvrObj = new ExcelInspRsDto();
                int total = row.getPhysicalNumberOfCells();
                for (int j = row.getFirstCellNum(); j < total; j++) {
                    cell = row.getCell(j).toString();
                    cell = cell.trim();
                    if(j==1){
                        rsvrObj.setProvince(cell);
                    }
                    if(j==2){
                        if(cell.contains("市辖区")){
                            rsvrObj.setProvince(rsvrObj.getProvince()+"");
                        }else{
                            if(rsvrObj.getProvince().contains("省")) {
                                rsvrObj.setProvince(rsvrObj.getProvince());
                            }else {
                                rsvrObj.setProvince(rsvrObj.getProvince() );
                            }
                        }
                        rsvrObj.setCity(cell);
                    }
                    if(j==3){
                        rsvrObj.setCountry(cell);
                    }
                    if(j==4){
                        rsvrObj.setRsvrNm(cell);
                    }
                    if(j==5){
                        rsvrObj.setGuimo(encagl(cell));
                    }
                    if(j==6){
                        rsvrObj.setTop(cell);
                    }
                    if(j==7){
                        rsvrObj.setPoor(isPoor(cell));
                    }
                    if(j==8){
                        rsvrObj.setRepeat(isPoor(cell));
                    }
                    if(j==9){
                        rsvrObj.setNote(cell);
                    }
                    if(j==10){
                        rsvrObj.setOrgNm(cell);
                        if("长委".equals(cell)){
                            rsvrObj.setOrgNm("长江委");
                        }
                    }
                }
                rsvrObjList.add(rsvrObj);
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        return rsvrObjList;
    }

    private static String isPoor(String cell) {
        if (StringUtils.isBlank(cell) && "否".equals(cell)) {
            return "2";
        }
        return "1";
    }
    private static String encagl(String desc) {
        if ("小Ⅱ".equals(desc)) {
            return "5";
        }
        if ("小Ⅰ".equals(desc)) {
            return "4";
        }

        return "";
    }
}