From 02bc3bfe47e3d5311a0bb041c94e70a34b1ca73c Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期二, 09 四月 2024 09:03:01 +0800 Subject: [PATCH] git ch --- server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java | 173 +++++++++++++++++++++++++++++++++++++++------------------ 1 files changed, 119 insertions(+), 54 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 da340b8..a2e652a 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 @@ -12,10 +12,7 @@ import com.doumee.core.utils.Utils; 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.join.*; import com.doumee.dao.business.model.*; import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.SmsEmailService; @@ -26,7 +23,6 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.doumee.service.business.third.SignService; import com.github.yulichang.wrapper.MPJLambdaWrapper; -import io.swagger.models.auth.In; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; @@ -36,6 +32,7 @@ import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import java.math.BigDecimal; +import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; @@ -81,6 +78,8 @@ @Autowired private ApplyLogJoinMapper applyLogJoinMapper; + @Autowired + private MemberInsuranceJoinMapper memberInsuranceJoinMapper; @Value("${debug_model}") private boolean debugModel; @@ -147,8 +146,22 @@ MPJLambdaWrapper<UnionApply> queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); queryWrapper.selectAll(UnionApply.class); - queryWrapper.selectAs(Solutions::getName,UnionApply::getSolutionName); + queryWrapper.selectAs(Solutions::getName,UnionApply::getSolutionName) + .selectAs(Solutions::getMaxAge,UnionApply::getMaxAge) + .selectAs(Solutions::getMinAge,UnionApply::getMinAge) + .selectAs(Solutions::getPrice,UnionApply::getPrice) + .selectAs(Solutions::getTimeUnit,UnionApply::getTimeUnit) + .selectAs(Solutions::getOrtherInfo,UnionApply::getOrtherInfo) + .selectAs(Solutions::getSpecialAgreement,UnionApply::getSpecialAgreement) + .selectAs(Solutions::getSpecialInfo,UnionApply::getSpecialInfo); queryWrapper.select("(select count(b.id) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum "); + + queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id where b.union_apply_id=t.id " + + "and b.status = "+Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()+" and a.type = 0 ) as addApplyNum "); + + queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id where b.union_apply_id=t.id " + + "and b.status = "+Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()+" and a.type = 1 ) as changeApplyNum "); + queryWrapper.leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId); LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(Constants.equalsInteger(user.getType(),Constants.TWO)){ @@ -390,7 +403,7 @@ eq(Solutions::getType,Constants.ONE) .eq(Solutions::getIsdeleted,Constants.ZERO) .eq(Solutions::getDataType,Constants.ZERO) - .eq(Solutions::getBaseId,saveUnionApplyDTO.getBaseSolutionId())); + .eq(Solutions::getId,saveUnionApplyDTO.getBaseSolutionId())); //鏌ヨ鏂规鏁版嵁 if(solutions == null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝鏂规淇℃伅鏈夎锛岃鍒锋柊椤甸潰閲嶈瘯"); @@ -410,7 +423,7 @@ if(insuranceApplyList.size()!=saveUnionApplyDTO.getApplyIds().size()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀛樺湪鏁版嵁宸插鐞嗭紝璇峰埛鏂伴噸璇�"); } - + saveUnionApplyDTO.setEndDate(DateUtil.getMontageDate(saveUnionApplyDTO.getEndDate(),2)); UnionApply unionApply = new UnionApply(); unionApply.setCreateDate(new Date()); unionApply.setCreator(user.getId()); @@ -496,7 +509,7 @@ 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())); + .eq(Multifile::getObjType,Constants.MultiFile.BD_APPLY_PDF.getKey())); } insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda() .set(InsuranceApply::getUnionApplyId,null) @@ -580,7 +593,7 @@ multifile.setCreator(user.getId()); multifile.setCreateDate(new Date()); multifile.setCreateDate(new Date()); - multifile.setObjType(Constants.MultiFile.COMPANY_TBD_SIGNED.getKey()); + multifile.setObjType(Constants.MultiFile.BD_APPLY_PDF.getKey()); multifile.setType(Constants.TWO); multifileMapper.insert(multifile); @@ -613,6 +626,13 @@ multifile.setFileurl(uploadMultifileDTO.getFileurl()); multifile.setName(uploadMultifileDTO.getName()); multifileMapper.insert(multifile); + + + Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_TBD; + ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null + ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply)); + applyLogMapper.insert(log); + } @@ -651,7 +671,7 @@ } Multifile f = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda() .eq(Multifile::getObjId,unionApply.getId()) - .eq(Multifile::getObjType,Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey()) + .eq(Multifile::getObjType,Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()) .eq(Multifile::getIsdeleted,Constants.ZERO) .last("limit 1")); if(f == null || StringUtils.isBlank(f.getFileurl())){ @@ -695,7 +715,8 @@ || Objects.isNull(unionApplyBXDDTO.getStartTime()) || Objects.isNull(unionApplyBXDDTO.getEndTime()) || StringUtils.isBlank(unionApplyBXDDTO.getCode()) - || Objects.isNull(unionApplyBXDDTO.getUnionApplyBXDDDetailTOList()) + || StringUtils.isBlank(unionApplyBXDDTO.getFileUrl()) + || StringUtils.isBlank(unionApplyBXDDTO.getFileName()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } @@ -707,15 +728,17 @@ if(unionApply == null ||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } - if(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())){ + if(!unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ュ悎骞跺崟鐘舵�佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵"); } //鍔犱环鍙傛暟 - List<UnionApplyBXDDDetailTO> unionApplyBXDDDetailTOList = unionApplyBXDDTO.getUnionApplyBXDDDetailTOList(); + List<UnionApplyBXDDetailDTO> unionApplyBXDDetailDTOList = unionApplyBXDDTO.getUnionApplyBXDDDetailDTOList(); //鎵�鏈夋姇淇濈敵璇蜂繚鍗曟槑缁嗚 - List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper<ApplyDetail>().lambda().select(ApplyDetail::getPrice) + List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper<ApplyDetail>().lambda() + .select(ApplyDetail::getId,ApplyDetail::getApplyId,ApplyDetail::getPrice) .in(ApplyDetail::getUnionApplyId,unionApply.getId())); + unionApplyBXDDTO.setEndTime(DateUtil.getMontageDate(unionApplyBXDDTO.getEndTime(),2)); //鎬诲ぉ鏁� Integer maxDays = DateUtil.calculateBetween(unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime(),0); //瀹為檯宸茬粡浜х敓璐圭敤鐨勫ぉ鏁� @@ -727,62 +750,75 @@ //褰撳墠鏃ユ湡鍦ㄧ粨鏉熸棩鏈熶箣鍚� useDays = -1; } - BigDecimal sumFee = BigDecimal.ZERO; BigDecimal sumCurrFee = BigDecimal.ZERO; - - for (UnionApplyBXDDDetailTO unionApplyBXDDDetailTO:unionApplyBXDDDetailTOList) { - InsuranceApply insuranceApply = insuranceApplyJoinMapper.selectById(unionApplyBXDDDetailTO.getApplyId()); - if(Objects.isNull(insuranceApply)||!Constants.equalsInteger(insuranceApply.getIsdeleted(),Constants.ZERO)){ - throw new BusinessException(ResponseStatus.DATA_EMPTY); - } - if(!insuranceApply.getStatus().equals(Constants.InsuranceApplyStatus.PLATFORM_CHECK_PASS.getKey())){ - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ユ姇淇濆崟鐘舵�佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵"); - } - List<ApplyDetail> applyDetails = applyDetailList.stream().filter(m->m.getApplyId().equals(unionApplyBXDDDetailTO.getApplyId())).collect(Collectors.toList()); + List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectList(new QueryWrapper<InsuranceApply>() + .lambda().eq(InsuranceApply::getUnionApplyId,unionApply.getId())); + for (InsuranceApply insuranceApply:insuranceApplyList) { + List<ApplyDetail> applyDetails = applyDetailList.stream() + .filter(m->Constants.equalsInteger(m.getApplyId(),(insuranceApply.getId()))).collect(Collectors.toList()); if(CollectionUtils.isEmpty(applyDetails)){ - throw new BusinessException(ResponseStatus.DATA_EMPTY); + continue; } - //鎻愪氦鍚庣殑鏂颁环鏍� 鍔犱笂鏈嶅姟璐� - BigDecimal price = applyDetails.get(Constants.ZERO).getPrice().add(unionApplyBXDDDetailTO.getServerMoney()); - //瀹為檯宸蹭骇鐢熻垂鐢� + BigDecimal price = Constants.formatBigdecimal(applyDetails.get(Constants.ZERO).getPrice()); + + Optional<UnionApplyBXDDetailDTO> unionApplyBXDDDetailTO= unionApplyBXDDetailDTOList.stream().filter( + m->m.getApplyId().equals(insuranceApply.getId())).findFirst(); + if(unionApplyBXDDDetailTO.isPresent()){ + UnionApplyBXDDetailDTO unionApplyBXDDetailDTO = unionApplyBXDDDetailTO.get(); + + BigDecimal dayServerMoney = unionApplyBXDDetailDTO.getServerMoney().divide(new BigDecimal(maxDays),2, RoundingMode.HALF_UP); + + price = Constants.formatBigdecimal(price).add(Constants.formatBigdecimal(dayServerMoney)); + //涓婁紶淇濆崟淇℃伅 + if(StringUtils.isNotBlank(unionApplyBXDDetailDTO.getFileUrl())){ + Multifile multifile = new Multifile(); + multifile.setIsdeleted(Constants.ZERO); + multifile.setCreator(user.getId()); + multifile.setCreateDate(new Date()); + multifile.setObjId(insuranceApply.getId()); + multifile.setObjType(Constants.MultiFile.BD_DONE_PDF.getKey()); + multifile.setType(Constants.TWO); + multifile.setFileurl(unionApplyBXDDetailDTO.getFileUrl()); + multifile.setName(unionApplyBXDDetailDTO.getFileName()); + multifileMapper.insert(multifile); + insuranceApply.setUnionApplyTbdStatus(Constants.ONE); + }else{ + insuranceApply.setUnionApplyTbdStatus(Constants.ZERO); + } + } + //瀹為檯宸蹭骇鐢熻垂鐢紙鍗曚汉锛� BigDecimal currentFee = BigDecimal.ZERO; if(useDays==-1){ currentFee = new BigDecimal(maxDays).multiply(price); }else if(useDays>0){ currentFee = new BigDecimal(useDays).multiply(price); } - //涓婁紶淇濆崟淇℃伅 - if(StringUtils.isNotBlank(unionApplyBXDDDetailTO.getFileUrl())){ - Multifile multifile = new Multifile(); - multifile.setIsdeleted(Constants.ZERO); - multifile.setCreator(user.getId()); - multifile.setCreateDate(new Date()); - multifile.setObjId(insuranceApply.getId()); - multifile.setObjType(Constants.MultiFile.BD_DONE_PDF.getKey()); - multifile.setType(Constants.TWO); - multifile.setFileurl(unionApplyBXDDDetailTO.getFileUrl()); - multifile.setName(unionApplyBXDDDetailTO.getFileName()); - multifileMapper.insert(multifile); - insuranceApply.setUnionApplyTbdStatus(Constants.ONE); - }else{ - insuranceApply.setUnionApplyTbdStatus(Constants.ZERO); + //鐢熸垚鎶曚繚璁板綍 + if(CollectionUtils.isNotEmpty(applyDetailList)){ + List<MemberInsurance> memberInsuranceList = new ArrayList<>(); + for (ApplyDetail applyDetail:applyDetailList.stream() + .filter(m->Constants.equalsInteger(m.getApplyId(),(insuranceApply.getId()))).collect(Collectors.toList())) { + applyDetail.setPrice(price); + applyDetail.setFee(price.multiply(new BigDecimal(maxDays))); + MemberInsurance memberInsurance = new MemberInsurance(applyDetail,user.getId()); + memberInsurance.setRelationType(Constants.ZERO); + memberInsuranceList.add(memberInsurance); + } + memberInsuranceJoinMapper.insertBatchSomeColumn(memberInsuranceList); } + //鏇存柊鎶曚繚鐢宠鍗� insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda() - .set(InsuranceApply::getFee, - new BigDecimal(applyDetails.size()) - .multiply(price) - ) + .set(InsuranceApply::getUnionApplyTbdStatus,Constants.THREE) .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_DONE.getKey()) - .set(InsuranceApply::getUnionApplyTbdStatus,3) .set(InsuranceApply::getFee,price.multiply(new BigDecimal(applyDetails.size())).multiply(new BigDecimal(maxDays))) .set(InsuranceApply::getCurrentFee,currentFee.multiply(new BigDecimal(applyDetails.size()))) .set(InsuranceApply::getStartTime,unionApplyBXDDTO.getStartTime()) .set(InsuranceApply::getEndTime,unionApplyBXDDTO.getEndTime()) - .set(InsuranceApply::getUnionApplyTbdStatus,insuranceApply.getUnionApplyTbdStatus()) .set(InsuranceApply::getEditDate,new Date()) .set(InsuranceApply::getEditor,user.getId()) + .set(InsuranceApply::getCode,unionApplyBXDDTO.getCode()) .eq(InsuranceApply::getId,insuranceApply.getId())); //鏇存柊鎶曚繚鍗曟槑缁嗛噾棰� applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda() @@ -795,17 +831,18 @@ .set(ApplyDetail::getEndTime,unionApplyBXDDTO.getEndTime()) .in(ApplyDetail::getId,applyDetails.stream().map(m->m.getId()).collect(Collectors.toList())) ); - sumFee = sumFee.add(price.multiply(new BigDecimal(applyDetails.size())).multiply(new BigDecimal(maxDays))); sumCurrFee = sumCurrFee.add(currentFee.multiply(new BigDecimal(applyDetails.size()))); } + unionApplyMapper.update(null,new UpdateWrapper<UnionApply>() .lambda() - .set(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH) + .set(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH.getKey()) .set(UnionApply::getEditDate,new Date()) .set(UnionApply::getEditor,user.getId()) .set(UnionApply::getStartTime,unionApplyBXDDTO.getStartTime()) .set(UnionApply::getEndTime,unionApplyBXDDTO.getEndTime()) + .set(UnionApply::getCode,unionApplyBXDDTO.getCode()) .set(UnionApply::getFee,sumFee) .set(UnionApply::getCurrentFee,sumCurrFee) .eq(UnionApply::getId,unionApply.getId()) @@ -824,7 +861,7 @@ multifileMapper.insert(multifile); } - Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_TBD; + Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_BXD; String info = ""; if(Objects.nonNull(unionApplyBXDDTO.getStartTime())&&Objects.nonNull(unionApplyBXDDTO.getEndTime())){ info =applyLogType.getInfo(); @@ -838,4 +875,32 @@ } + + + @Override + @Transactional(rollbackFor = {Exception.class,BusinessException.class}) + public void updateUnionApplyCurrentFee(Integer id){ + List<UnionApply> unionApplyList = unionApplyJoinMapper.selectJoinList(UnionApply.class,new MPJLambdaWrapper<UnionApply>() + .selectAll(UnionApply.class) + .eq(UnionApply::getIsdeleted,Constants.ZERO) + .eq(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH) + .eq(!Objects.isNull(id),UnionApply::getId,id) + .le(UnionApply::getStartTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 00:00:00") + .ge(UnionApply::getEndTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 23:59:59") + ); + + if(CollectionUtils.isNotEmpty(unionApplyList)){ + for (UnionApply unionApply:unionApplyList) { + List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper + .selectList(new QueryWrapper<InsuranceApply>().lambda() + .eq(InsuranceApply::getUnionApplyId,unionApply.getId())); + if(CollectionUtils.isNotEmpty(insuranceApplyList)){ + unionApply.setCurrentFee(insuranceApplyList.stream().map(m->m.getCurrentFee()).reduce(BigDecimal.ZERO,BigDecimal::add)); + unionApplyMapper.updateById(unionApply); + } + } + } + } + + } -- Gitblit v1.9.3