springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
@@ -186,13 +186,27 @@ voList.add(vo); index++; } if(populationImportErrorVOList.isEmpty()){ //客户需要暂时注释,等客户处理完成需要恢复 // if(populationImportErrorVOList.isEmpty()){ // R r = communityService.listSavePopulationServeExcelVO(voList, communityId); // if (!R.isOk(r)) { // throw new ServiceException(r.getMsg()); // } // }else{ // throw new ServiceException("500", JSON.toJSONString(populationImportErrorVOList)); // } R r = communityService.listSavePopulationServeExcelVO(voList, communityId); if (!R.isOk(r)) { throw new ServiceException(r.getMsg()); String errMsg = r.getMsg(); List<ComMngPopulationImportErrorVO> errorList = JSON.parseArray(errMsg,ComMngPopulationImportErrorVO.class); if(!errorList.isEmpty()){ populationImportErrorVOList.addAll(errorList); } }else{ throw new ServiceException("500", JSON.toJSONString(populationImportErrorVOList)); }else{ if(!populationImportErrorVOList.isEmpty()){ throw new ServiceException("500", JSON.toJSONString(populationImportErrorVOList)); } } } catch (NumberFormatException e) { List<ComMngPopulationImportErrorVO> populationImportErrorVOList = new ArrayList<>(); springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityQuestnaireApi.java
@@ -18,6 +18,7 @@ import com.panzhihua.common.model.vos.community.questnaire.*; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.service.user.UserService; import com.panzhihua.common.utlis.ClazzUtils; import com.panzhihua.common.utlis.SFTPUtil; import com.panzhihua.community_backstage.config.SFTPConfig; import com.panzhihua.community_backstage.excel.CustomSheetWriteHandler; @@ -55,7 +56,7 @@ @ApiOperation(value = "分页查询调查问卷", response = QuestnaireListVo.class) @PostMapping("/page") public R page(@RequestBody PageQuestnaireDTO pageQuestnaireDTO) { LoginUserInfoVO loginUserInfo = this.getLoginUserInfo(); ClazzUtils.setIfStringIsEmpty(pageQuestnaireDTO); pageQuestnaireDTO.setForMasses(null); pageQuestnaireDTO.setForVolunteer(true); pageQuestnaireDTO.setForParty(true); springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/HouseApi.java
@@ -74,6 +74,7 @@ sysUserNoticeVO.setBusinessContent(""); sysUserNoticeVO.setBusinessTitle("您提交的" + comOpsHouseVO.getTitle() +"房屋出租审核已经审核通过"); sysUserNoticeVO.setBusinessId(comOpsHouseVO.getId()); sysUserNoticeVO.setBusinessContent(" "); sysUserNoticeVO.setStatus(0); sysUserNoticeVO.setBusinessStatus(2); R r2 = userService.addNotice(sysUserNoticeVO); @@ -93,6 +94,7 @@ sysUserNoticeVO.setBusinessTitle("您提交的" + comOpsHouseVO.getTitle() +"房屋出租审核已经被驳回"); sysUserNoticeVO.setBusinessId(comOpsHouseVO.getId()); sysUserNoticeVO.setStatus(0); sysUserNoticeVO.setBusinessContent("驳回原因:" + comOpsHouseVO.getReason()); sysUserNoticeVO.setBusinessStatus(1); R r2 = userService.addNotice(sysUserNoticeVO); if (R.isOk(r2)) { springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActQuestnaireDAO.java
@@ -52,9 +52,10 @@ " </if> \n" + "<if test='pageQuestnaireDTO.startTime != null '>\n" + " AND aq.create_at BETWEEN \n" + "#{pageComActDTO.startTime} \n" + " AND #{pageQuestnaireDTO.endTime}\n" + " AND aq.create_at <![CDATA[>=]]> #{pageQuestnaireDTO.startTime} \n" + "</if>" + "<if test='pageQuestnaireDTO.endTime != null '>\n" + " AND aq.create_at <![CDATA[<=]]> #{pageQuestnaireDTO.endTime} \n" + " </if> \n" + " ORDER BY \n" + " aq.create_at DESC" + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -255,11 +255,16 @@ index++; } //如果有错误,返回错误 //暂时注释,等客户完成任务需要恢复 /*if(!populationImportErrorVOList.isEmpty()){ return R.fail(JSON.toJSONString(populationImportErrorVOList)); } this.saveBatch(populationDOList);*/ this.saveBatch(populationDOList); if(!populationImportErrorVOList.isEmpty()){ return R.fail(JSON.toJSONString(populationImportErrorVOList)); } this.saveBatch(populationDOList); return R.ok("共计导入实有人口数量:" + populationDOList.size()); }