package com.doumee.service.business.impl; import com.alibaba.fastjson.JSONObject; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.LoginUserInfo; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; import com.doumee.dao.business.*; import com.doumee.dao.business.dto.*; 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; import com.doumee.service.business.UnionApplyService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.doumee.service.business.third.SignService; import com.github.yulichang.wrapper.MPJLambdaWrapper; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; /** * 合并投保单信息表Service实现 * @author 江蹄蹄 * @date 2024/03/12 11:34 */ @Service public class UnionApplyServiceImpl implements UnionApplyService { @Autowired private UnionApplyMapper unionApplyMapper; @Autowired private UnionApplyJoinMapper unionApplyJoinMapper; @Autowired private SolutionsMapper solutionsMapper; @Autowired private CompanyMapper companyMapper; @Autowired private InsuranceApplyJoinMapper insuranceApplyJoinMapper; @Autowired private ApplyDetailJoinMapper applyDetailJoinMapper; @Autowired private MultifileMapper multifileMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private SignService signService; @Autowired private SmsEmailService smsEmailService; @Autowired private ApplyLogMapper applyLogMapper; @Autowired private ApplyLogJoinMapper applyLogJoinMapper; @Autowired private MemberInsuranceJoinMapper memberInsuranceJoinMapper; @Value("${debug_model}") private boolean debugModel; @Override public Integer create(UnionApply unionApply) { unionApplyMapper.insert(unionApply); return unionApply.getId(); } @Override public void deleteById(Integer id) { unionApplyMapper.deleteById(id); } @Override public void delete(UnionApply unionApply) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(unionApply); unionApplyMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } unionApplyMapper.deleteBatchIds(ids); } @Override public void updateById(UnionApply unionApply) { unionApplyMapper.updateById(unionApply); } @Override public void updateByIdInBatch(List unionApplys) { if (CollectionUtils.isEmpty(unionApplys)) { return; } for (UnionApply unionApply: unionApplys) { this.updateById(unionApply); } } @Override public UnionApply findById(Integer id) { return unionApplyMapper.selectById(id); } @Override public UnionApply findOne(UnionApply unionApply) { QueryWrapper wrapper = new QueryWrapper<>(unionApply); return unionApplyMapper.selectOne(wrapper); } @Override public List findList(UnionApply unionApply) { QueryWrapper wrapper = new QueryWrapper<>(unionApply); return unionApplyMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); queryWrapper.selectAll(UnionApply.class); 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)){ queryWrapper.eq(UnionApply::getCompanyId, user.getCompanyId()); } if (pageWrap.getModel().getId() != null) { queryWrapper.eq(UnionApply::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getSolutionId() != null) { queryWrapper.eq(UnionApply::getSolutionId, pageWrap.getModel().getSolutionId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(UnionApply::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getQueryStartTime() != null) { queryWrapper.ge(UnionApply::getCreateDate, pageWrap.getModel().getQueryStartTime() +" 00:00:00" ); } if (pageWrap.getModel().getQueryEndTime() != null) { queryWrapper.le(UnionApply::getCreateDate, pageWrap.getModel().getQueryEndTime() +" 23:59:59"); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(UnionApply::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(UnionApply::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(UnionApply::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(UnionApply::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(UnionApply::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(UnionApply::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(UnionApply::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.eq(UnionApply::getSortnum, pageWrap.getModel().getSortnum()); } if (pageWrap.getModel().getCompanyId() != null) { queryWrapper.eq(UnionApply::getCompanyId, pageWrap.getModel().getCompanyId()); } if (pageWrap.getModel().getEndTime() != null) { queryWrapper.ge(UnionApply::getEndTime, Utils.Date.getStart(pageWrap.getModel().getEndTime())); queryWrapper.le(UnionApply::getEndTime, Utils.Date.getEnd(pageWrap.getModel().getEndTime())); } if (pageWrap.getModel().getStartTime() != null) { queryWrapper.ge(UnionApply::getStartTime, Utils.Date.getStart(pageWrap.getModel().getStartTime())); queryWrapper.le(UnionApply::getStartTime, Utils.Date.getEnd(pageWrap.getModel().getStartTime())); } if (pageWrap.getModel().getCheckDate() != null) { queryWrapper.ge(UnionApply::getCheckDate, Utils.Date.getStart(pageWrap.getModel().getCheckDate())); queryWrapper.le(UnionApply::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate())); } if (pageWrap.getModel().getCheckInfo() != null) { queryWrapper.eq(UnionApply::getCheckInfo, pageWrap.getModel().getCheckInfo()); } if (pageWrap.getModel().getCheckUserId() != null) { queryWrapper.eq(UnionApply::getCheckUserId, pageWrap.getModel().getCheckUserId()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.eq(UnionApply::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(UnionApply::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getCurrentFee() != null) { queryWrapper.eq(UnionApply::getCurrentFee, pageWrap.getModel().getCurrentFee()); } if (pageWrap.getModel().getFee() != null) { queryWrapper.eq(UnionApply::getFee, pageWrap.getModel().getFee()); } if (pageWrap.getModel().getSignApplyNo() != null) { queryWrapper.eq(UnionApply::getSignApplyNo, pageWrap.getModel().getSignApplyNo()); }if(pageWrap.getSorts().size() == 0){ queryWrapper.orderByDesc(UnionApply::getCreateDate ); }else { for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } } PageData 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 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 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 detailList= applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); //查询明细 if(detailList!=null){ insuranceApply.setInsureNum(detailList.size()); insuranceApply.setApplyDetailList(detailList); } insuranceApply.setRemark(model.getRemark()); return insuranceApply; } @Override public UnionApply detail(Integer applyId){ UnionApply unionApply = unionApplyJoinMapper.selectJoinOne(UnionApply.class, new MPJLambdaWrapper() .selectAll(UnionApply.class) .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) .last(" limit 1 ") ); unionApply.setServiceDays(Constants.ZERO); if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){ //如果当前时间大于结束日期 则使用结束日期对比开始日期 if(DateUtil.compareDate(new Date(),unionApply.getEndTime())>=Constants.ZERO){ unionApply.setServiceDays( DateUtil.daysBetweenDates(unionApply.getEndTime(),unionApply.getStartTime())+1 ); }else if(DateUtil.compareDate(unionApply.getStartTime(),new Date())>=Constants.ZERO){ //未开始 unionApply.setServiceDays(Constants.ZERO); }else{ unionApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),unionApply.getStartTime())+1); } } initStatusInfo(unionApply); //查询附件数据 initImgData(unionApply); //查询操作记录 List applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class, new MPJLambdaWrapper() .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 multifiles = multifileMapper.selectList(new QueryWrapper().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 @Transactional(rollbackFor ={BusinessException.class,Exception.class} ) public Integer merge(SaveUnionApplyDTO saveUnionApplyDTO){ LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户，无法进行该操作"); } if(Objects.isNull(saveUnionApplyDTO) || Objects.isNull(saveUnionApplyDTO.getApplyIds()) || saveUnionApplyDTO.getApplyIds().size() == 0 || Objects.isNull(saveUnionApplyDTO.getStartDate()) || Objects.isNull(saveUnionApplyDTO.getEndDate()) || saveUnionApplyDTO.getStartDate().getTime()>saveUnionApplyDTO.getEndDate().getTime() || Objects.isNull(saveUnionApplyDTO.getBaseSolutionId()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } Solutions solutions = solutionsMapper.selectOne(new QueryWrapper().lambda(). eq(Solutions::getType,Constants.ONE) .eq(Solutions::getIsdeleted,Constants.ZERO) .eq(Solutions::getDataType,Constants.ZERO) .eq(Solutions::getId,saveUnionApplyDTO.getBaseSolutionId())); //查询方案数据 if(solutions == null){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，方案信息有误，请刷新页面重试"); } List insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class, new MPJLambdaWrapper() .selectAll(InsuranceApply.class) .selectAs(Solutions::getBaseId,InsuranceApply::getSolutionBaseId) .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) .eq(InsuranceApply::getIsdeleted, Constants.ZERO) .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey()) .eq(Solutions::getBaseId,saveUnionApplyDTO.getBaseSolutionId()) .in(InsuranceApply::getId,saveUnionApplyDTO.getApplyIds()) .isNull(InsuranceApply::getUnionApplyId) ); //查询数据是否存在未处于审批通过的数据 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()); unionApply.setEditor(user.getId()); unionApply.setEditDate(new Date()); unionApply.setCompanyId(user.getCompanyId()); unionApply.setStartTime(saveUnionApplyDTO.getStartDate()); unionApply.setEndTime(saveUnionApplyDTO.getEndDate()); unionApply.setCheckDate(new Date()); unionApply.setStatus(Constants.UnionApplyStatus.MERGE.getKey()); unionApply.setCheckUserId(user.getId()); unionApply.setCurrentFee(BigDecimal.ZERO); unionApply.setIsdeleted(Constants.ZERO); unionApply.setSolutionId(solutions.getId()); Integer maxDays = DateUtil.calculateBetween(saveUnionApplyDTO.getStartDate(),saveUnionApplyDTO.getEndDate(),0); List applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper().lambda().select(ApplyDetail::getId,ApplyDetail::getPrice) .in(ApplyDetail::getApplyId,saveUnionApplyDTO.getApplyIds()) .eq(ApplyDetail::getIsdeleted,Constants.ZERO)); if(applyDetailList.size()==0){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，存在委托投保申请记录信息有误，请返回查看申请人员是否为空！"); } unionApply.setFee(applyDetailList.stream().map(i->Constants.formatBigdecimal(i.getPrice()).multiply(new BigDecimal(maxDays))).reduce(BigDecimal.ZERO,BigDecimal::add)); unionApplyMapper.insert(unionApply); insuranceApplyJoinMapper.update(null,new UpdateWrapper().lambda() .set(InsuranceApply::getUnionApplyId,unionApply.getId()) .set(InsuranceApply::getCheckDate,new Date()) .set(InsuranceApply::getCheckUserId,user.getId()) .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()) .in(InsuranceApply::getId,saveUnionApplyDTO.getApplyIds())); applyDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyDetail::getUnionApplyId,unionApply.getId()) .in(ApplyDetail::getApplyId,saveUnionApplyDTO.getApplyIds())); Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD; ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply)); applyLogMapper.insert(log); return unionApply.getId(); } /** * 取消保单合并 * @param closeDTO */ @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public void cancelMerge(CloseDTO closeDTO){ LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户，无法进行该操作！"); } if(Objects.isNull(closeDTO) ||Objects.isNull(closeDTO.getId()) ||StringUtils.isBlank(closeDTO.getReason())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } UnionApply unionApply = unionApplyMapper.selectById(closeDTO.getId()); if(Objects.isNull(unionApply)||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } 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.CLOSE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已关闭"); } //合并单状态处于待投保 if(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){ multifileMapper.delete(new QueryWrapper() .lambda() .apply(" multifile.id in ( select i.id from insurance_apply i where i.UNION_APPLY_ID = "+unionApply.getId()+" ) ") .eq(Multifile::getObjType,Constants.MultiFile.BD_APPLY_PDF.getKey())); } insuranceApplyJoinMapper.update(null,new UpdateWrapper().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()) ); applyDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyDetail::getUnionApplyId,null) .eq(ApplyDetail::getUnionApplyId,unionApply.getId())); unionApplyMapper.update(null,new UpdateWrapper().lambda() .set(UnionApply::getCheckDate,new Date()) .set(UnionApply::getCheckUserId,user.getId()) .set(UnionApply::getStatus,Constants.UnionApplyStatus.CLOSE.getKey()) .eq(UnionApply::getId,unionApply.getId()) ); Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_CLOSE; String info =applyLogType.getInfo(); info = info.replace("${param}", closeDTO.getReason()); ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info ,unionApply.getId(),applyLogType.getKey(),null, null); applyLogMapper.insert(log); } @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public void uploadToubaodan(UploadMultifileDTO uploadMultifileDTO){ if(uploadMultifileDTO.getBusinessId() == null ||StringUtils.isBlank( uploadMultifileDTO.getFileurl()) ||StringUtils.isBlank( uploadMultifileDTO.getName())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户，无法进行该操作！"); } UnionApply unionApply = unionApplyMapper.selectById(uploadMultifileDTO.getBusinessId()); 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())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已流转，您无法进行该操作！"); } if(CollectionUtils.isNotEmpty(uploadMultifileDTO.getMultifileList())){ List multifileList = uploadMultifileDTO.getMultifileList(); for (Multifile multifile:multifileList) { if(Objects.isNull(multifile.getObjId()) ||Objects.isNull(multifile.getName()) ||Objects.isNull(multifile.getFileurl())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"企业投保单附件参数错误"); } InsuranceApply insuranceApply = insuranceApplyJoinMapper.selectOne(new QueryWrapper().lambda() .eq(InsuranceApply::getId,multifile.getObjId()) .eq(InsuranceApply::getUnionApplyId,uploadMultifileDTO.getBusinessId()) ); if(Objects.isNull(insuranceApply)){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"企业投保单未查询到"); } multifile.setIsdeleted(Constants.ZERO); multifile.setCreator(user.getId()); multifile.setCreateDate(new Date()); multifile.setCreateDate(new Date()); multifile.setObjType(Constants.MultiFile.BD_APPLY_PDF.getKey()); multifile.setType(Constants.TWO); multifileMapper.insert(multifile); insuranceApplyJoinMapper.update(null,new UpdateWrapper().lambda() .set(InsuranceApply::getUnionApplyTbdStatus,Constants.ONE) .set(InsuranceApply::getEditDate,new Date()) .set(InsuranceApply::getEditor,user.getId()) .eq(InsuranceApply::getId,multifile.getObjId()) ); } } unionApply.setCheckDate(new Date()); unionApply.setCheckUserId(user.getId()); unionApply.setStatus(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()); unionApply.setEditor(user.getId()); unionApply.setEditDate(new Date()); unionApplyMapper.updateById(unionApply); Multifile multifile = new Multifile(); multifile.setIsdeleted(Constants.ZERO); multifile.setCreator(user.getId()); multifile.setCreateDate(new Date()); multifile.setObjId(uploadMultifileDTO.getBusinessId()); multifile.setCreateDate(new Date()); multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()); multifile.setType(Constants.TWO); 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); } /** * 合并单 - 投保申请签署 * @return */ @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public String getSignLink(SmsCheckDTO smsCheckDTO) { if(Objects.isNull(smsCheckDTO) || Objects.isNull(smsCheckDTO.getBusinessId()) || StringUtils.isBlank(smsCheckDTO.getCode()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } //验证 验证码 if(!debugModel){ smsEmailService.validateCode(smsCheckDTO.getCode()); } LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户，无法进行该操作！"); } UnionApply unionApply = unionApplyJoinMapper.selectById(smsCheckDTO.getBusinessId()); if(unionApply == null ||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId()); if(Objects.isNull(solutions)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息"); } if(!Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该合并单状态已流转，当前不支持该操作~"); } Multifile f = multifileMapper.selectOne(new QueryWrapper().lambda() .eq(Multifile::getObjId,unionApply.getId()) .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())){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取待签章文件失败，请联系确认合并保单是否正确！"); } Company company = companyMapper.selectById(unionApply.getCompanyId()); if(company== null || StringUtils.isBlank( company.getEmail()) || !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，商户尚未具备在线签章条件，请联系平台管理员确认~"); } String url = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode()+f.getFileurl(); String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode(); notifyUrl = notifyUrl.replace("${type}","0").replace("${id}", unionApply.getId().toString()); String applyNo = signService.applySign(company.getName(),url,company.getName(),company.getCode(),company.getEmail(),null,company.getSignId(),notifyUrl); if(StringUtils.isBlank(applyNo) ){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！"); } String link = signService.signLink(applyNo,company.getName(),company.getCode()); if(StringUtils.isBlank(link) ){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！"); } UnionApply update= new UnionApply(); update.setId(unionApply.getId()); update.setEditor(user.getId()); update.setEditDate(new Date()); update.setSignApplyNo(applyNo); unionApplyJoinMapper.updateById(update); return link; } @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public void uploadBXD(UnionApplyBXDDTO unionApplyBXDDTO){ if(Objects.isNull(unionApplyBXDDTO) || Objects.isNull(unionApplyBXDDTO.getId()) || Objects.isNull(unionApplyBXDDTO.getStartTime()) || Objects.isNull(unionApplyBXDDTO.getEndTime()) || StringUtils.isBlank(unionApplyBXDDTO.getCode()) || StringUtils.isBlank(unionApplyBXDDTO.getFileUrl()) || StringUtils.isBlank(unionApplyBXDDTO.getFileName()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户，无法进行该操作！"); } UnionApply unionApply = unionApplyJoinMapper.selectById(unionApplyBXDDTO.getId()); 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())){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该合并单状态已流转，当前不支持该操作~"); } //加价参数 List unionApplyBXDDetailDTOList = unionApplyBXDDTO.getUnionApplyBXDDDetailDTOList(); //所有投保申请保单明细行 List applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper().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); //实际已经产生费用的天数 Integer useDays = 0 ; if(unionApplyBXDDTO.getStartTime().compareTo(new Date()) <= 0 && unionApplyBXDDTO.getEndTime().compareTo(new Date()) >= 0 ){ //当前日期在开始结束日期之内 useDays = DateUtil.calculateBetween(unionApplyBXDDTO.getStartTime(),new Date(),0); }else if(unionApplyBXDDTO.getStartTime().compareTo(new Date()) <= 0&&unionApplyBXDDTO.getEndTime().compareTo(new Date()) <= 0){ //当前日期在结束日期之后 useDays = -1; } BigDecimal sumFee = BigDecimal.ZERO; BigDecimal sumCurrFee = BigDecimal.ZERO; List insuranceApplyList = insuranceApplyJoinMapper.selectList(new QueryWrapper() .lambda().eq(InsuranceApply::getUnionApplyId,unionApply.getId())); for (InsuranceApply insuranceApply:insuranceApplyList) { List applyDetails = applyDetailList.stream() .filter(m->Constants.equalsInteger(m.getApplyId(),(insuranceApply.getId()))).collect(Collectors.toList()); if(CollectionUtils.isEmpty(applyDetails)){ continue; } BigDecimal price = Constants.formatBigdecimal(applyDetails.get(Constants.ZERO).getPrice()); Optional 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(CollectionUtils.isNotEmpty(applyDetailList)){ List 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().lambda() .set(InsuranceApply::getUnionApplyTbdStatus,Constants.THREE) .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_DONE.getKey()) .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::getEditDate,new Date()) .set(InsuranceApply::getEditor,user.getId()) .set(InsuranceApply::getCode,unionApplyBXDDTO.getCode()) .eq(InsuranceApply::getId,insuranceApply.getId())); //更新投保单明细金额 applyDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyDetail::getPrice,price) .set(ApplyDetail::getFee, price.multiply(new BigDecimal(maxDays))) .set(ApplyDetail::getCurrentFee,currentFee) .set(ApplyDetail::getEditDate,new Date()) .set(ApplyDetail::getEditor,user.getId()) .set(ApplyDetail::getStartTime,unionApplyBXDDTO.getStartTime()) .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() .lambda() .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()) ); //合并单 文件 if(StringUtils.isNotBlank(unionApplyBXDDTO.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setIsdeleted(Constants.ZERO); multifile.setCreator(user.getId()); multifile.setCreateDate(new Date()); multifile.setObjId(unionApply.getId()); multifile.setObjType(Constants.MultiFile.WTB_BD_DONE_PDF.getKey()); multifile.setType(Constants.TWO); multifile.setFileurl(unionApplyBXDDTO.getFileUrl()); multifile.setName(unionApplyBXDDTO.getFileName()); multifileMapper.insert(multifile); } Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_BXD; 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); } @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public void updateUnionApplyCurrentFee(Integer id){ List unionApplyList = unionApplyJoinMapper.selectJoinList(UnionApply.class,new MPJLambdaWrapper() .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 insuranceApplyList = insuranceApplyJoinMapper .selectList(new QueryWrapper().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); } } } } }