运营后台首页模块开发以及实有房屋导入接口开发

huanghongfa

2021-10-15 089660d464ee9423dd724177ba5fa82afb9d5920

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationConfirmServeExcelListen.java

@@ -95,54 +95,54 @@
            for (Map<Integer, String> oneData : list) {
                ComMngPopulationServeExcelVO vo = new ComMngPopulationServeExcelVO();
                // 姓名和身份证都为空,为空户，无需操作,否则就解析年龄，性别，出生年月日
                if (StringUtils.isNotEmpty(oneData.get(0)) || StringUtils.isNotEmpty(oneData.get(1))) {
                    if (StringUtils.isEmpty(oneData.get(0))) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第1列");
                        importErrorVO.setErrorMsg("名字不可为空，请填写姓名");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setName(oneData.get(0));
                    if (StringUtils.isEmpty(oneData.get(1))) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第2列" + oneData.get(1));
                        importErrorVO.setErrorMsg("身份证号不可为空，请填写身份证号");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }

                    // 判断身份证号码位数
                    if (oneData.get(1).length() != 18) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第2列" + oneData.get(1));
                        importErrorVO.setErrorMsg("身份证号位数有误，请检查身份证号码是否正确");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setCardNo(oneData.get(1));
                    // 根据身份证号码解析年龄以及性别
                    // 获取用户生日
                    String birthday = vo.getCardNo().substring(6, 14);
                    if (StringUtils.isNotEmpty(birthday)) {
                        String year = birthday.substring(0, 4);
                        String month = birthday.substring(4, 6);
                        String day = birthday.substring(6, 8);
                        vo.setBirthday(year + "-" + month + "-" + day);
                    }
                    // //设置用户年龄
                    // vo.setAge(AgeUtils.getAgeFromBirthTime(birthday));
                    // 获取用户性别
                    int sex = Integer.parseInt(vo.getCardNo().substring(16, 17));
                    if (sex % 2 == 1) {
                        vo.setSex(PopulSexEnum.nan.getCode());
                    } else {
                        vo.setSex(PopulSexEnum.nv.getCode());
                    }
                }
//                if (StringUtils.isNotEmpty(oneData.get(0)) || StringUtils.isNotEmpty(oneData.get(1))) {
//                    if (StringUtils.isEmpty(oneData.get(0))) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第1列");
//                        importErrorVO.setErrorMsg("名字不可为空，请填写姓名");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setName(oneData.get(0));
//                    if (StringUtils.isEmpty(oneData.get(1))) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第2列" + oneData.get(1));
//                        importErrorVO.setErrorMsg("身份证号不可为空，请填写身份证号");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//
//                    // 判断身份证号码位数
//                    if (oneData.get(1).length() != 18) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第2列" + oneData.get(1));
//                        importErrorVO.setErrorMsg("身份证号位数有误，请检查身份证号码是否正确");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setCardNo(oneData.get(1));
//                    // 根据身份证号码解析年龄以及性别
//                    // 获取用户生日
//                    String birthday = vo.getCardNo().substring(6, 14);
//                    if (StringUtils.isNotEmpty(birthday)) {
//                        String year = birthday.substring(0, 4);
//                        String month = birthday.substring(4, 6);
//                        String day = birthday.substring(6, 8);
//                        vo.setBirthday(year + "-" + month + "-" + day);
//                    }
//                    // //设置用户年龄
//                    // vo.setAge(AgeUtils.getAgeFromBirthTime(birthday));
//                    // 获取用户性别
//                    int sex = Integer.parseInt(vo.getCardNo().substring(16, 17));
//                    if (sex % 2 == 1) {
//                        vo.setSex(PopulSexEnum.nan.getCode());
//                    } else {
//                        vo.setSex(PopulSexEnum.nv.getCode());
//                    }
//                }
                if (StringUtils.isNotEmpty(oneData.get(2))) {
                    // String nation = oneData.get(2);
                    // if(!nation.contains("族")){
@@ -158,18 +158,18 @@
                if (StringUtils.isNotEmpty(oneData.get(3))) {
                    vo.setPoliticalOutlook(PopulPoliticalOutlookEnum.getCodeByName(oneData.get(3)));
                }
                if (StringUtils.isNotEmpty(oneData.get(4))) {
                    Integer isOk = PopulHouseUseEnum.getCodeByName(oneData.get(4));
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第5列");
                        importErrorVO.setErrorMsg("您填写的是否租住有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setIsRent(isOk);
                }
//                if (StringUtils.isNotEmpty(oneData.get(4))) {
//                    Integer isOk = PopulHouseUseEnum.getCodeByName(oneData.get(4));
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第5列");
//                        importErrorVO.setErrorMsg("您填写的是否租住有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setIsRent(isOk);
//                }
                if (StringUtils.isNotEmpty(oneData.get(5))) {

                    // String ra = convertRelation(oneData.get(5));
@@ -201,50 +201,50 @@
                    }

                }
                if (StringUtils.isEmpty(oneData.get(6))) {
                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                    importErrorVO.setErrorPosition("第" + index + "行，第7列");
                    importErrorVO.setErrorMsg("街路巷不可为空");
                    populationImportErrorVOList.add(importErrorVO);
                    index++;
                    continue;
                }
                vo.setRoad(oneData.get(6));
                if (StringUtils.isEmpty(oneData.get(7))) {
                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                    importErrorVO.setErrorPosition("第" + index + "行，第8列");
                    importErrorVO.setErrorMsg("小区号不可为空");
                    populationImportErrorVOList.add(importErrorVO);
                    index++;
                    continue;
                }
                vo.setDoorNo(oneData.get(7).trim());
                if (StringUtils.isEmpty(oneData.get(8))) {
                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                    importErrorVO.setErrorPosition("第" + index + "行，第9列");
                    importErrorVO.setErrorMsg("楼排号不可为空");
                    populationImportErrorVOList.add(importErrorVO);
                    index++;
                    continue;
                }
                vo.setFloor(oneData.get(8).trim());
                if (StringUtils.isEmpty(oneData.get(9))) {
                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                    importErrorVO.setErrorPosition("第" + index + "行，第10列");
                    importErrorVO.setErrorMsg("单元号不可为空");
                    populationImportErrorVOList.add(importErrorVO);
                    index++;
                    continue;
                }
                vo.setUnitNo(oneData.get(9).trim());
                if (StringUtils.isEmpty(oneData.get(10))) {
                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                    importErrorVO.setErrorPosition("第" + index + "行，第11列");
                    importErrorVO.setErrorMsg("户室不可为空");
                    populationImportErrorVOList.add(importErrorVO);
                    index++;
                    continue;
                }
//                if (StringUtils.isEmpty(oneData.get(6))) {
//                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                    importErrorVO.setErrorPosition("第" + index + "行，第7列");
//                    importErrorVO.setErrorMsg("街路巷不可为空");
//                    populationImportErrorVOList.add(importErrorVO);
//                    index++;
//                    continue;
//                }
//                vo.setRoad(oneData.get(6));
//                if (StringUtils.isEmpty(oneData.get(7))) {
//                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                    importErrorVO.setErrorPosition("第" + index + "行，第8列");
//                    importErrorVO.setErrorMsg("小区号不可为空");
//                    populationImportErrorVOList.add(importErrorVO);
//                    index++;
//                    continue;
//                }
//                vo.setDoorNo(oneData.get(7).trim());
//                if (StringUtils.isEmpty(oneData.get(8))) {
//                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                    importErrorVO.setErrorPosition("第" + index + "行，第9列");
//                    importErrorVO.setErrorMsg("楼排号不可为空");
//                    populationImportErrorVOList.add(importErrorVO);
//                    index++;
//                    continue;
//                }
//                vo.setFloor(oneData.get(8).trim());
//                if (StringUtils.isEmpty(oneData.get(9))) {
//                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                    importErrorVO.setErrorPosition("第" + index + "行，第10列");
//                    importErrorVO.setErrorMsg("单元号不可为空");
//                    populationImportErrorVOList.add(importErrorVO);
//                    index++;
//                    continue;
//                }
//                vo.setUnitNo(oneData.get(9).trim());
//                if (StringUtils.isEmpty(oneData.get(10))) {
//                    ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                    importErrorVO.setErrorPosition("第" + index + "行，第11列");
//                    importErrorVO.setErrorMsg("户室不可为空");
//                    populationImportErrorVOList.add(importErrorVO);
//                    index++;
//                    continue;
//                }
                vo.setHouseNo(oneData.get(10).trim());
                if (StringUtils.isNotEmpty(oneData.get(11))) {
                    vo.setBuildPurpose(oneData.get(11).trim());
@@ -252,42 +252,42 @@
                if (StringUtils.isNotEmpty(oneData.get(12))) {
                    vo.setBuildArea(oneData.get(12).trim());
                }
                if (StringUtils.isNotEmpty(oneData.get(13))) {
                    Integer isOk = PopulHouseStatusEnum.getCodeByName(oneData.get(13).trim());
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第14列");
                        importErrorVO.setErrorMsg("您填写的房屋状态有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setHouseStatus(isOk);
                }
                if (StringUtils.isNotEmpty(oneData.get(14))) {
                    Integer isOk = PopulHousePurposeEnum.getCodeByName(oneData.get(14).trim());
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第15列");
                        importErrorVO.setErrorMsg("您填写的房屋用途有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setHousePurpose(PopulHousePurposeEnum.getCodeByName(oneData.get(14).trim()));
                }
                if (StringUtils.isNotEmpty(oneData.get(15))) {
                    Integer isOk = PopulHouseControlStatusEnum.getCodeByName(oneData.get(15));
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第16列");
                        importErrorVO.setErrorMsg("您填写的管控状态有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setControlStatus(isOk);
                }
//                if (StringUtils.isNotEmpty(oneData.get(13))) {
//                    Integer isOk = PopulHouseStatusEnum.getCodeByName(oneData.get(13).trim());
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第14列");
//                        importErrorVO.setErrorMsg("您填写的房屋状态有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setHouseStatus(isOk);
//                }
//                if (StringUtils.isNotEmpty(oneData.get(14))) {
//                    Integer isOk = PopulHousePurposeEnum.getCodeByName(oneData.get(14).trim());
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第15列");
//                        importErrorVO.setErrorMsg("您填写的房屋用途有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setHousePurpose(PopulHousePurposeEnum.getCodeByName(oneData.get(14).trim()));
//                }
//                if (StringUtils.isNotEmpty(oneData.get(15))) {
//                    Integer isOk = PopulHouseControlStatusEnum.getCodeByName(oneData.get(15));
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第16列");
//                        importErrorVO.setErrorMsg("您填写的管控状态有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setControlStatus(isOk);
//                }

                if (StringUtils.isNotEmpty(oneData.get(16))) {
                    vo.setPhone(oneData.get(16).trim());
@@ -295,34 +295,34 @@
                if (StringUtils.isNotEmpty(oneData.get(17))) {
                    vo.setNativePlace(oneData.get(17).trim());
                }
                if (StringUtils.isNotEmpty(oneData.get(18))) {
                    Integer isOk = PopulCultureLevelEnum.getCodeByName(oneData.get(18));
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第19列");
                        importErrorVO.setErrorMsg("您填写的文化程度有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setCultureLevel(isOk);
                }
                if (StringUtils.isNotEmpty(oneData.get(19))) {
                    // String ma = convertMarriage(oneData.get(19));
                    Integer isOk = PopulMarriageEnum.getCodeByName(oneData.get(19));
                    if (isOk.equals(-1)) {
                        // vo.setMarriageStr(ma);
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第20列");
                        importErrorVO.setErrorMsg("您填写的婚姻状况有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    } else {
                        vo.setMarriage(isOk);
                    }

                }
//                if (StringUtils.isNotEmpty(oneData.get(18))) {
//                    Integer isOk = PopulCultureLevelEnum.getCodeByName(oneData.get(18));
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第19列");
//                        importErrorVO.setErrorMsg("您填写的文化程度有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setCultureLevel(isOk);
//                }
//                if (StringUtils.isNotEmpty(oneData.get(19))) {
//                    // String ma = convertMarriage(oneData.get(19));
//                    Integer isOk = PopulMarriageEnum.getCodeByName(oneData.get(19));
//                    if (isOk.equals(-1)) {
//                        // vo.setMarriageStr(ma);
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第20列");
//                        importErrorVO.setErrorMsg("您填写的婚姻状况有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    } else {
//                        vo.setMarriage(isOk);
//                    }
//
//                }
                if (StringUtils.isNotEmpty(oneData.get(20))) {
                    vo.setHealthy(oneData.get(20).trim());
                }
@@ -339,18 +339,18 @@
                if (StringUtils.isNotEmpty(oneData.get(24))) {
                    vo.setWorkCompany(oneData.get(24).trim());
                }
                if (StringUtils.isNotEmpty(oneData.get(25))) {
                    Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25));
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第26列");
                        importErrorVO.setErrorMsg("您填写的本地/外地有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setOutOrLocal(isOk);
                }
//                if (StringUtils.isNotEmpty(oneData.get(25))) {
//                    Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25));
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第26列");
//                        importErrorVO.setErrorMsg("您填写的本地/外地有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setOutOrLocal(isOk);
//                }
                if (StringUtils.isNotEmpty(oneData.get(26))) {
                    vo.setCensusRegister(oneData.get(26).trim());
                }
@@ -359,18 +359,18 @@
                } else {
                    vo.setResidence(PopulIsOkEnum.getCodeByName(oneData.get(27).trim()));
                }
                if (StringUtils.isNotEmpty(oneData.get(28))) {
                    Integer isOk = PopulPersonTypeEnum.getCodeByName(oneData.get(28));
                    if (isOk.equals(-1)) {
                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
                        importErrorVO.setErrorPosition("第" + index + "行，第30列");
                        importErrorVO.setErrorMsg("您填写的人员类型有误");
                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        continue;
                    }
                    vo.setPersonType(isOk);
                }
//                if (StringUtils.isNotEmpty(oneData.get(28))) {
//                    Integer isOk = PopulPersonTypeEnum.getCodeByName(oneData.get(28));
//                    if (isOk.equals(-1)) {
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行，第30列");
//                        importErrorVO.setErrorMsg("您填写的人员类型有误");
//                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        continue;
//                    }
//                    vo.setPersonType(isOk);
//                }
                if (StringUtils.isNotEmpty(oneData.get(29))) {
                    vo.setCountry(oneData.get(29).trim());
                }
@@ -464,7 +464,7 @@
            e.printStackTrace();
            List<ComMngPopulationImportErrorVO> populationImportErrorVOList = new ArrayList<>();
            ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
            importErrorVO.setErrorPosition("第" + index + "行");
//            importErrorVO.setErrorPosition("第" + index + "行");
            importErrorVO.setErrorMsg("数据格式有误，请检查文档内数据");
            populationImportErrorVOList.add(importErrorVO);
            throw new ServiceException("500", JSON.toJSONString(populationImportErrorVOList));
@@ -472,7 +472,7 @@
            e1.printStackTrace();
            List<ComMngPopulationImportErrorVO> populationImportErrorVOList = new ArrayList<>();
            ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
            importErrorVO.setErrorPosition("第" + index + "行");
//            importErrorVO.setErrorPosition("第" + index + "行");
            importErrorVO.setErrorMsg("数据格式有误，请检查文档内数据");
            populationImportErrorVOList.add(importErrorVO);
            throw new ServiceException("500", JSON.toJSONString(populationImportErrorVOList));