From cd8b3aff5714c8cd6a017d95869dcd506f586525 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 19 五月 2022 17:50:53 +0800
Subject: [PATCH] 花城E+bug更新

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java |  664 ++++++++++++++++++++++++++++++++-----------------------
 1 files changed, 388 insertions(+), 276 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
index 7048cdb..32bfb24 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -1115,39 +1115,49 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveDrugPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveDrugPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationDrugMistakeExcelVO mistake = new ComMngPopulationDrugMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setDrugMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
+
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -1411,39 +1421,49 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveCorrectPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveCorrectPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationCorrectMistakeExcelVO mistake = new ComMngPopulationCorrectMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setCorrectMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
+
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -1707,39 +1727,49 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveMajorPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveMajorPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationMajorMistakeExcelVO mistake = new ComMngPopulationMajorMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setMajorMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
+
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -2003,39 +2033,49 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveCultPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveCultPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationCultMistakeExcelVO mistake = new ComMngPopulationCultMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setCultMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
+
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -2301,39 +2341,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveRehabilitationPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveRehabilitationPopulationHouse(vo, comMngVillageDO, communityId,
-                            areaPath, populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationRehabilitationMistakeExcelVO mistake = new ComMngPopulationRehabilitationMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setRehabilitationMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -2598,39 +2647,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveKeyPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveKeyPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationKeyMistakeExcelVO mistake = new ComMngPopulationKeyMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setKeyMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -2894,39 +2952,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveSentencePopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveSentencePopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationSentenceMistakeExcelVO mistake = new ComMngPopulationSentenceMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setSentenceMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -3190,39 +3257,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveVeteransPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveVeteransPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationVeteransMistakeExcelVO mistake = new ComMngPopulationVeteransMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setVeteransMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -3486,39 +3562,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveDisabilityPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveDisabilityPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationDisabilityMistakeExcelVO mistake = new ComMngPopulationDisabilityMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setDisabilityMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -3787,39 +3872,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                    communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                && house.getUnitNo().equals(vo.getUnitNo())
-                                && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveLowSecurityPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveLowSecurityPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                            populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationLowSecurityMistakeExcelVO mistake = new ComMngPopulationLowSecurityMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setLowSecurityMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -4083,39 +4177,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                        communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                    && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                    && house.getUnitNo().equals(vo.getUnitNo())
-                                    && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    saveElderPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = saveElderPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                                populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationElderMistakeExcelVO mistake = new ComMngPopulationElderMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setElderMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;
@@ -4382,39 +4485,48 @@
                 log.info("开始查询小区街路巷是否存在完成");
 
                 log.info("开始查询房屋是否存在");
-                // 先判断房屋是否存在
                 ComMngPopulationHouseDO populationHouseDO = null;
-                String houseKey =
-                        communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
-                if (isOnly(houseKey, houseMap)) {
-                    if (!houseList.isEmpty()) {
-                        for (ComMngPopulationHouseDO house : houseList) {
-                            if (house.getVillageId().equals(comMngVillageDO.getVillageId())
-                                    && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
-                                    && house.getUnitNo().equals(vo.getUnitNo())
-                                    && house.getHouseNo().equals(vo.getHouseNo())) {
-                                populationHouseDO = house;
-                                break;
+                // 先判断房屋是否存在
+                if(StringUtils.isNotEmpty(vo.getFloor())&&StringUtils.isNotEmpty(vo.getHouseNo())&&StringUtils.isNotEmpty(vo.getUnitNo())){
+                    String houseKey =
+                            communityId + comMngVillageDO.getVillageId() + vo.getFloor() + vo.getUnitNo() + vo.getHouseNo();
+                    if (isOnly(houseKey, houseMap)) {
+                        if (!houseList.isEmpty()) {
+                            for (ComMngPopulationHouseDO house : houseList) {
+                                if (house.getVillageId().equals(comMngVillageDO.getVillageId())
+                                        && house.getCommunityId().equals(communityId) && house.getFloor().equals(vo.getFloor())
+                                        && house.getUnitNo().equals(vo.getUnitNo())
+                                        && house.getHouseNo().equals(vo.getHouseNo())) {
+                                    populationHouseDO = house;
+                                    break;
+                                }
                             }
                         }
+                        if (populationHouseDO == null) {
+                            // 房屋信息不存在建立房屋信息
+                            populationHouseDO =
+                                    savePensionPopulationHouse(vo, comMngVillageDO, communityId, areaPath, populationActVO.getName());
+                            houseList.add(populationHouseDO);
+                        }
+                    } else {
+                        populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
                     }
-                    if (populationHouseDO == null) {
-                        // 房屋信息不存在建立房屋信息
-                        populationHouseDO = savePensionPopulationHouse(vo, comMngVillageDO, communityId, areaPath,
-                                populationActVO.getName());
-                        houseList.add(populationHouseDO);
-                    }
-                } else {
-                    populationHouseDO = (ComMngPopulationHouseDO)houseMap.get(houseKey);
+                    vo.setHouseId(populationHouseDO.getId());
+                    log.info("查询房屋是否存在完成");
+                }else {
+                    ComMngPopulationPensionMistakeExcelVO mistake = new ComMngPopulationPensionMistakeExcelVO();
+                    BeanUtils.copyProperties(vo, mistake);
+                    setPensionMistake(mistake, vo);
+                    mistake.setMistake("房屋数据填报不完整" );
+                    mistakes.add(mistake);
+                    log.info("房屋数据填报不完整");
+                    continue;
                 }
-                vo.setHouseId(populationHouseDO.getId());
-                log.info("开始查询房屋是否存在完成");
 
                 if (StringUtils.isEmpty(vo.getName()) && StringUtils.isEmpty(vo.getCardNo())) {
                     // 空户处理完房屋信息,直接返回
                     continue;
                 }
-                String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey);
                 // 判断实有人口是否已存在
                 log.info("开始查询实有人口是否已存在");
                 ComMngPopulationDO populationDO = null;

--
Gitblit v1.7.1