From bd57081dc1bcd94e1e4043a9e0a7c6953d4bb9d4 Mon Sep 17 00:00:00 2001 From: nidapeng <jp@doumee.com> Date: 星期一, 01 四月 2024 19:19:01 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/1.0.1' into 1.0.1 --- server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java | 136 ++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 121 insertions(+), 15 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java index a92609d..da340b8 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java @@ -13,9 +13,11 @@ import com.doumee.dao.business.*; import com.doumee.dao.business.dto.*; import com.doumee.dao.business.join.ApplyDetailJoinMapper; +import com.doumee.dao.business.join.ApplyLogJoinMapper; import com.doumee.dao.business.join.InsuranceApplyJoinMapper; import com.doumee.dao.business.join.UnionApplyJoinMapper; import com.doumee.dao.business.model.*; +import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.SmsEmailService; import com.doumee.service.business.UnionApplyService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -34,10 +36,7 @@ import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import java.math.BigDecimal; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; -import java.util.Objects; +import java.util.*; import java.util.stream.Collectors; /** @@ -79,6 +78,8 @@ private SmsEmailService smsEmailService; @Autowired private ApplyLogMapper applyLogMapper; + @Autowired + private ApplyLogJoinMapper applyLogJoinMapper; @Value("${debug_model}") private boolean debugModel; @@ -236,13 +237,51 @@ } PageData<UnionApply> pageData = PageData.from(unionApplyJoinMapper.selectJoinPage(page,UnionApply.class, queryWrapper)); + if(pageData!=null && pageData.getRecords()!=null){ + for(UnionApply model : pageData.getRecords()){ + initStatusInfo(model); + } + } return pageData; + } + + private void initStatusInfo(UnionApply model) { + model.setStatusInfo(Constants.UnionApplyStatus.getName(Constants.formatIntegerNum(model.getStatus()))); } @Override public long count(UnionApply unionApply) { QueryWrapper<UnionApply> wrapper = new QueryWrapper<>(unionApply); return unionApplyMapper.selectCount(wrapper); + } + + @Override + public UnionApply findDetailForExport(UnionApply model){ + UnionApply insuranceApply = detail(model.getId()); + if(Objects.isNull(insuranceApply)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY); + } + + MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.selectAll(ApplyDetail.class); + queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName); + queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName); + queryWrapper.selectAs(Worktype::getName,ApplyDetail::getWorkTypeName); + queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); + queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); + queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId); + queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId); + queryWrapper.leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId); + queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); + queryWrapper.eq( ApplyDetail::getUnionApplyId,model.getId()); + List<ApplyDetail> detailList= applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); + //鏌ヨ鏄庣粏 + if(detailList!=null){ + insuranceApply.setInsureNum(detailList.size()); + insuranceApply.setApplyDetailList(detailList); + } + insuranceApply.setRemark(model.getRemark()); + return insuranceApply; } @@ -255,6 +294,7 @@ .selectAs(Solutions::getName,UnionApply::getSolutionName) .selectAs(Company::getName,UnionApply::getCompanyName) .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad where ad.UNION_APPLY_ID = t.id ) as insureNum") + .select(" ( select group_concat(DISTINCT(cd.name)) from insurance_apply ad left join company cd on ad.company_id = cd.id where ad.UNION_APPLY_ID = t.id ) as companyNames") .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) .leftJoin(Company.class,Company::getId,UnionApply::getCompanyId) .eq(UnionApply::getId,applyId) @@ -274,10 +314,59 @@ unionApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),unionApply.getStartTime())+1); } } + initStatusInfo(unionApply); + + //鏌ヨ闄勪欢鏁版嵁 + initImgData(unionApply); + //鏌ヨ鎿嶄綔璁板綍 + List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class, + new MPJLambdaWrapper<ApplyLog>() + .selectAll(ApplyLog.class) + .selectAs(SystemUser::getRealname,ApplyLog::getCreatorName) + .selectAs(Company::getName,ApplyLog::getCompanyName) + .selectAs(SystemUser::getType,ApplyLog::getCreatorType) + .leftJoin(SystemUser.class,SystemUser::getId,ApplyLog::getCreator) + .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) + .in(ApplyLog::getObjType,Constants.ApplyLogType.getTypeList(Constants.THREE)) + .eq(ApplyLog::getApplyId,unionApply.getId()) + .orderByAsc(ApplyLog::getCreateDate) + ); + unionApply.setApplyLogList(applyLogList); + return unionApply; } + private void initImgData(UnionApply model) { + List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() + .eq(Multifile::getObjId, model.getId()) + .in(Multifile::getObjType, Arrays.asList(new Integer[]{ + Constants.MultiFile.HBD_BD_APPLY_PDF.getKey() + ,Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey() + ,Constants.MultiFile.WTB_BD_DONE_PDF.getKey() })) + .eq(Multifile::getIsdeleted,Constants.ZERO) + .orderByAsc(Multifile::getId)); + if(multifiles!=null){ + String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() + +systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode(); + for(Multifile f : multifiles){ + if(StringUtils.isBlank(f.getFileurl())){ + continue; + } + f.setFileurlFull(path+f.getFileurl()); + if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_APPLY_PDF.getKey())){ + //绛剧讲鍓嶇殑鎶曚繚鍗� + model.setToubaodanFile(f); + }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey())){ + //绛剧讲鍚庣殑鎶曚繚鍗� + model.setToubaodanSignedFile(f); + }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_BD_DONE_PDF.getKey())){ + //鏈�绲備繚闄╁崟 + model.setBaoxiandanFile(f); + } + } + } + } @Override @@ -325,6 +414,8 @@ UnionApply unionApply = new UnionApply(); unionApply.setCreateDate(new Date()); unionApply.setCreator(user.getId()); + unionApply.setEditor(user.getId()); + unionApply.setEditDate(new Date()); unionApply.setCompanyId(user.getCompanyId()); unionApply.setStartTime(saveUnionApplyDTO.getStartDate()); unionApply.setEndTime(saveUnionApplyDTO.getEndDate()); @@ -381,7 +472,9 @@ if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炲晢鎴风敤鎴凤紝鏃犳硶杩涜璇ユ搷浣滐紒"); } - if(Objects.isNull(closeDTO)||Objects.isNull(closeDTO.getId())){ + if(Objects.isNull(closeDTO) + ||Objects.isNull(closeDTO.getId()) + ||StringUtils.isBlank(closeDTO.getReason())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } UnionApply unionApply = unionApplyMapper.selectById(closeDTO.getId()); @@ -400,15 +493,24 @@ //鍚堝苟鍗曠姸鎬佸浜庡緟鎶曚繚 if(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){ - //TODO 鍒犻櫎浼佷笟鎶曚繚鍗曠殑 绛剧讲鏁版嵁 - + multifileMapper.delete(new QueryWrapper<Multifile>() + .lambda() + .apply(" multifile.id in ( select i.id from insurance_apply i where i.UNION_APPLY_ID = "+unionApply.getId()+" ) ") + .eq(Multifile::getObjType,Constants.MultiFile.COMPANY_TBD_SIGNED.getKey())); } insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda() .set(InsuranceApply::getUnionApplyId,null) .set(InsuranceApply::getCheckDate,new Date()) + .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) + || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()), + InsuranceApply::getUnionApplyTbdStatus,Constants.ZERO) + .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) + || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()), + InsuranceApply::getApplyTbdNo,null) .set(InsuranceApply::getCheckUserId,user.getId()) .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey()) - .eq(InsuranceApply::getUnionApplyId,unionApply.getId())); + .eq(InsuranceApply::getUnionApplyId,unionApply.getId()) + ); applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda() .set(ApplyDetail::getUnionApplyId,null) @@ -427,8 +529,6 @@ info = info.replace("${param}", closeDTO.getReason()); ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info ,unionApply.getId(),applyLogType.getKey(),null, null); - applyLogMapper.insert(log); - applyLogMapper.insert(log); } @@ -449,13 +549,14 @@ if(Objects.isNull(unionApply)||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } + unionApply.setStatus(Constants.formatIntegerNum(unionApply.getStatus())); if(!unionApply.getCompanyId().equals(user.getCompanyId())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧烽潪鎮ㄧ殑鍚堝苟鍗曪紝鎮ㄦ棤娉曡繘琛屾搷浣滐紒"); } if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡瀹岀粨锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒"); } - if(unionApply.getStatus().equals(Constants.UnionApplyStatus.MERGE.getKey())){ + if(!unionApply.getStatus().equals(Constants.UnionApplyStatus.MERGE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡娴佽浆锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒"); } @@ -507,7 +608,7 @@ multifile.setCreateDate(new Date()); multifile.setObjId(uploadMultifileDTO.getBusinessId()); multifile.setCreateDate(new Date()); - multifile.setObjType(Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey()); + multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()); multifile.setType(Constants.TWO); multifile.setFileurl(uploadMultifileDTO.getFileurl()); multifile.setName(uploadMultifileDTO.getName()); @@ -709,7 +810,7 @@ .set(UnionApply::getCurrentFee,sumCurrFee) .eq(UnionApply::getId,unionApply.getId()) ); - //鍚堝苟鍗� 鎬讳繚鍗� + //鍚堝苟鍗� 鏂囦欢 if(StringUtils.isNotBlank(unionApplyBXDDTO.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setIsdeleted(Constants.ZERO); @@ -723,9 +824,14 @@ multifileMapper.insert(multifile); } - Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_TBD; - ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null + String info = ""; + if(Objects.nonNull(unionApplyBXDDTO.getStartTime())&&Objects.nonNull(unionApplyBXDDTO.getEndTime())){ + info =applyLogType.getInfo(); + info = info.replace("${param1}",DateUtil.getPlusTime2(unionApplyBXDDTO.getStartTime())); + info = info.replace("${param2}",DateUtil.getPlusTime2(unionApplyBXDDTO.getEndTime())); + } + ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply)); applyLogMapper.insert(log); -- Gitblit v1.9.3