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