package com.doumee.service.business.impl; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.extension.api.R; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.annotation.excel.ExcelExporter; 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.business.vo.CountCyclePriceVO; import com.doumee.dao.system.model.SystemUser; import com.doumee.dao.system.vo.BigDecimalVO; import com.doumee.service.business.SmsEmailService; import com.doumee.service.business.UnionChangeService; 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.xiaoymin.knife4j.core.util.CollectionUtils; 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.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.*; import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; /** * 加减保换厂合并单信息表Service实现 * @author 江蹄蹄 * @date 2024/03/12 11:34 */ @Service public class UnionChangeServiceImpl implements UnionChangeService { @Autowired private UnionChangeMapper unionChangeMapper; @Autowired private UnionChangeJoinMapper unionChangeJoinMapper; @Autowired private ApplyChangeJoinMapper applyChangeJoinMapper; @Autowired private UnionApplyMapper unionApplyMapper; @Autowired private ApplyChagneDetailJoinMapper applyChagneDetailJoinMapper; @Autowired private CompanyMapper companyMapper; @Autowired private SolutionsMapper solutionsMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private SignService signService; @Autowired private MemberMapper memberMapper; @Autowired private ApplyDetailJoinMapper applyDetailJoinMapper; @Autowired private MemberInsuranceJoinMapper memberInsuranceJoinMapper; @Autowired private InsuranceApplyMapper insuranceApplyMapper; @Value("${debug_model}") private boolean debugModel; @Autowired private SmsEmailService smsEmailService; @Autowired private MultifileMapper multifileMapper; @Autowired private ApplyLogMapper applyLogMapper; @Autowired private ApplyLogJoinMapper applyLogJoinMapper; @Override public Integer create(UnionChange unionChange) { unionChangeMapper.insert(unionChange); return unionChange.getId(); } @Override public void deleteById(Integer id) { unionChangeMapper.deleteById(id); } @Override public void delete(UnionChange unionChange) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(unionChange); unionChangeMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } unionChangeMapper.deleteBatchIds(ids); } @Override public void updateById(UnionChange unionChange) { unionChangeMapper.updateById(unionChange); } @Override public void updateByIdInBatch(List unionChanges) { if (CollectionUtils.isEmpty(unionChanges)) { return; } for (UnionChange unionChange: unionChanges) { this.updateById(unionChange); } } @Override public UnionChange findById(Integer id) { return unionChangeMapper.selectById(id); } @Override public UnionChange getDetail(Integer id){ UnionChange unionChange = unionChangeJoinMapper.selectJoinOne(UnionChange.class, new MPJLambdaWrapper() .selectAll(UnionChange.class) .selectAs(UnionApply::getCode,UnionChange::getApplyCode) .selectAs(Solutions::getName,UnionChange::getSolutionsName) .selectAs(UnionApply::getStartTime,UnionChange::getStartTime) .selectAs(UnionApply::getEndTime,UnionChange::getEndTime) .selectAs(Solutions::getDelOnlyReplace,UnionChange::getDelOnlyReplace) .selectAs(Company::getName,UnionChange::getShopName) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 0 )",UnionChange::getAddNum) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 1 )",UnionChange::getDelNum) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 2 )",UnionChange::getChangeNum) .leftJoin(UnionApply.class,UnionApply::getId,UnionChange::getUnionApplyId) .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) .leftJoin(Company.class,Company::getId,UnionChange::getShopId) .eq(UnionChange::getId,id) .last(" limit 1 ") ); if(!Objects.isNull(unionChange)){ //查询加减保明细数据 List applyChangeList = applyChagneDetailJoinMapper .selectList(new QueryWrapper() .lambda() .eq(ApplyChagneDetail::getIsdeleted,Constants.ZERO) .ne(ApplyChagneDetail::getType,Constants.TWO) .eq(ApplyChagneDetail::getUnionChangeId,unionChange.getId())); BigDecimal fee = applyChangeList.stream().map(m->m.getFee()).reduce(BigDecimal.ZERO,BigDecimal::add); unionChange.setFee(fee.setScale(6, RoundingMode.HALF_UP)); //查询操作记录 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.FOUR)) .eq(ApplyLog::getApplyId,unionChange.getId()) .orderByAsc(ApplyLog::getCreateDate) ); unionChange.setApplyLogList(applyLogList); if(StringUtils.isBlank(unionChange.getShopName())){ unionChange.setShopName( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PLAT_COMPANY_NAME).getCode() ); } } initFiles(unionChange); unionChange.setFee(Constants.getTwoPoint(unionChange.getFee())); return unionChange; } private void initFiles(UnionChange unionChange) { List multifiles = multifileMapper.selectList(new QueryWrapper().lambda() .eq(Multifile::getObjId, unionChange.getId() ) .in(Multifile::getObjType, Arrays.asList(new Integer[]{Constants.MultiFile.WTB_CA_TBD_PDF.getKey(),Constants.MultiFile.WTB_CA_DONE_PDF.getKey()})) .eq(Multifile::getIsdeleted,Constants.ZERO)); if(multifiles!=null){ String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode(); List pidanFileList = new ArrayList<>(); for(Multifile f : multifiles){ if(StringUtils.isBlank(f.getFileurl())){ continue; } f.setFileurlFull(path+f.getFileurl()); if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_CA_TBD_PDF.getKey())){ //签署后申请单 unionChange.setApplyFile(f); } if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_CA_DONE_PDF.getKey())){ pidanFileList.add(f);; } } unionChange.setPidanFileList(pidanFileList); } } @Override public UnionChange findOne(UnionChange unionChange) { QueryWrapper wrapper = new QueryWrapper<>(unionChange); return unionChangeMapper.selectOne(wrapper); } @Override public List findList(UnionChange unionChange) { QueryWrapper wrapper = new QueryWrapper<>(unionChange); return unionChangeMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(UnionChange.class); pageWrap.getModel().setIsdeleted(Constants.ZERO); queryWrapper.selectAs(UnionApply::getCode,UnionChange::getApplyCode); queryWrapper.selectAs(Solutions::getName,UnionChange::getSolutionsName) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 0 )",UnionChange::getAddNum) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 1 )",UnionChange::getDelNum) .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 2 )",UnionChange::getChangeNum); queryWrapper.leftJoin(UnionApply.class,UnionApply::getId,UnionChange::getUnionApplyId); queryWrapper.leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId); LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(Constants.equalsInteger(user.getType(),Constants.TWO)){ queryWrapper.eq(UnionChange::getShopId, user.getCompanyId()); } Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(UnionChange::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(UnionChange::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getSolutionsName() != null) { queryWrapper.eq(Solutions::getName, pageWrap.getModel().getSolutionsName()); } if (pageWrap.getModel().getQueryStartTime() != null) { queryWrapper.ge(UnionChange::getCreateDate, pageWrap.getModel().getQueryStartTime() +" 00:00:00" ); } if (pageWrap.getModel().getQueryEndTime() != null) { queryWrapper.le(UnionChange::getCreateDate, pageWrap.getModel().getQueryEndTime() +" 23:59:59"); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(UnionChange::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(UnionChange::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(UnionChange::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(UnionChange::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(UnionChange::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(UnionChange::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(UnionChange::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.eq(UnionChange::getSortnum, pageWrap.getModel().getSortnum()); } if (pageWrap.getModel().getShopId() != null) { queryWrapper.eq(UnionChange::getShopId, pageWrap.getModel().getShopId()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.eq(UnionChange::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getApplyStartTime() != null) { queryWrapper.ge(UnionChange::getApplyStartTime, Utils.Date.getStart(pageWrap.getModel().getApplyStartTime())); queryWrapper.le(UnionChange::getApplyStartTime, Utils.Date.getEnd(pageWrap.getModel().getApplyStartTime())); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(UnionChange::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getValidTime() != null) { queryWrapper.ge(UnionChange::getValidTime, Utils.Date.getStart(pageWrap.getModel().getValidTime())); queryWrapper.le(UnionChange::getValidTime, Utils.Date.getEnd(pageWrap.getModel().getValidTime())); } if (pageWrap.getModel().getValidCode() != null) { queryWrapper.eq(UnionChange::getValidCode, pageWrap.getModel().getValidCode()); } if (pageWrap.getModel().getType() != null) { queryWrapper.eq(UnionChange::getType, pageWrap.getModel().getType()); } if (pageWrap.getModel().getSignApplyNo() != null) { queryWrapper.eq(UnionChange::getSignApplyNo, pageWrap.getModel().getSignApplyNo()); } if(pageWrap.getSorts().size() == 0){ queryWrapper.orderByDesc(UnionChange::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(unionChangeJoinMapper.selectJoinPage(page,UnionChange.class, queryWrapper)); for (UnionChange unionChange:pageData.getRecords()) { unionChange.setFee(Constants.getTwoPoint(unionChange.getFee())); } return pageData; } @Override public long count(UnionChange unionChange) { QueryWrapper wrapper = new QueryWrapper<>(unionChange); return unionChangeMapper.selectCount(wrapper); } @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer merge(SaveUnionChangeDTO saveUnionChangeDTO){ LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!(Constants.equalsInteger(user.getType(),Constants.ZERO) || Constants.equalsInteger(user.getType(),Constants.TWO))){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户平台用户，无法进行该操作"); } // if(saveUnionChangeDTO.getBusinessType().equals(Constants.ZERO)||Objects.isNull(saveUnionChangeDTO.getApplyDate())){ // //2024年5月9日14:59:24 修改 默认入当前天 // saveUnionChangeDTO.setApplyDate(DateUtil.getMontageDate(new Date(),1)); // } if(Objects.isNull(saveUnionChangeDTO) || Objects.isNull(saveUnionChangeDTO.getApplyIds()) || Objects.isNull(saveUnionChangeDTO.getApplyDate()) || Objects.isNull(saveUnionChangeDTO.getUnionApplyId()) || Objects.isNull(saveUnionChangeDTO.getBusinessType()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } UnionApply unionApply = unionApplyMapper.selectById(saveUnionChangeDTO.getUnionApplyId()); if(Objects.isNull(unionApply)){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到合并保单数据"); } Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId()); if(Objects.isNull(solutions)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保险方案"); } if(saveUnionChangeDTO.getBusinessType().equals(Constants.ZERO)){ // saveUnionChangeDTO.setApplyDate(unionApply.getStartTime()); if(unionApply.getStartTime().getTime()>System.currentTimeMillis()){ saveUnionChangeDTO.setAddValidDate(unionApply.getStartTime()); saveUnionChangeDTO.setDelValidDate(unionApply.getStartTime()); }else{ saveUnionChangeDTO.setAddValidDate(saveUnionChangeDTO.getApplyDate()); saveUnionChangeDTO.setDelValidDate(saveUnionChangeDTO.getApplyDate()); //根据申请日期 处理加减保的 实际生效日期 if(Objects.nonNull(solutions.getAddValidDays())){ saveUnionChangeDTO.setAddValidDate( DateUtil.afterDateByType(saveUnionChangeDTO.getApplyDate(),0,solutions.getAddValidDays()) ); }else{ saveUnionChangeDTO.setAddValidDate(saveUnionChangeDTO.getApplyDate()); } if(Objects.nonNull(solutions.getDelValidDays())){ saveUnionChangeDTO.setDelValidDate( DateUtil.afterDateByType(saveUnionChangeDTO.getApplyDate(),0,solutions.getDelValidDays()) ); }else{ saveUnionChangeDTO.setDelValidDate(saveUnionChangeDTO.getApplyDate()); } //判断批单日期 合并单的批单生效期在为 保单起期的次日 到保单止期 //获取开始日期次日 if(saveUnionChangeDTO.getAddValidDate().getTime() unionApply.getEndTime().getTime()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"合并单的批单加保生效期错误"); } if(saveUnionChangeDTO.getDelValidDate().getTime() unionApply.getEndTime().getTime()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"合并单的批单减保生效期错误"); } } }else{ // if(saveUnionChangeDTO.getApplyDate().getTime() unionApply.getEndTime().getTime()){ // throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"合并单的换厂生效期错误"); // } saveUnionChangeDTO.setApplyDate(unionApply.getStartTime()); saveUnionChangeDTO.setAddValidDate(saveUnionChangeDTO.getApplyDate()); } List applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class, new MPJLambdaWrapper() .selectAll(ApplyChange.class) .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) .eq(ApplyChange::getIsdeleted, Constants.ZERO) .eq(InsuranceApply::getUnionApplyId,saveUnionChangeDTO.getUnionApplyId()) .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()) .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_DONE.getKey()) .eq(ApplyChange::getType,saveUnionChangeDTO.getBusinessType()) // .le(InsuranceApply::getStartTime,DateUtil.getCurrDateTime()) .in(ApplyChange::getId,saveUnionChangeDTO.getApplyIds()) .isNull(ApplyChange::getUnionChangeId) ); //查询数据是否存在未处于审批通过的数据 if(applyChangeList.size()!=saveUnionChangeDTO.getApplyIds().size()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"请检查所有申请单的状态及期望生效时间是否满足当前流转操作，请返回刷新重试！"); } UnionChange unionChange = new UnionChange(); unionChange.setCreateDate(new Date()); unionChange.setCreator(user.getId()); unionChange.setEditDate(new Date()); unionChange.setEditor(user.getId()); if(Constants.equalsInteger(user.getType(),Constants.TWO)){ unionChange.setShopId(user.getCompanyId()); }else{ unionChange.setShopId(saveUnionChangeDTO.getShopId()); } unionChange.setIsdeleted(Constants.ZERO); unionChange.setUnionApplyId(saveUnionChangeDTO.getUnionApplyId()); unionChange.setApplyStartTime(DateUtil.getMontageDate(saveUnionChangeDTO.getAddValidDate(),1)); unionChange.setDelValidTime(DateUtil.getMontageDate(saveUnionChangeDTO.getDelValidDate(),1)); unionChange.setType(saveUnionChangeDTO.getBusinessType()); // if(Constants.equalsInteger(solutions.getSignType(),Constants.ZERO)){ // // }else if(Constants.equalsInteger(solutions.getSignType(),Constants.ONE)){ // unionChange.setStatus(Constants.UnionChangeStatus.MERGE.getKey()); // }else{ // unionChange.setStatus(Constants.UnionChangeStatus.UPLOAD_INSURANCE_POLICY.getKey()); // } unionChange.setStatus(Constants.UnionChangeStatus.MERGE.getKey()); unionChangeMapper.insert(unionChange); applyChangeJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChange::getUnionChangeId,unionChange.getId()) .set(ApplyChange::getCheckDate,new Date()) .set(ApplyChange::getCheckUserId,user.getId()) .set(ApplyChange::getStatus,Constants.ApplyChangeStatus.WTB_TOUBAOING.getKey()) .in(ApplyChange::getId,saveUnionChangeDTO.getApplyIds()) ); applyChagneDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChagneDetail::getUnionChangeId,unionChange.getId()) .in(ApplyChagneDetail::getApplyChangeId,saveUnionChangeDTO.getApplyIds())); Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_UPLOAD; ApplyLog log = new ApplyLog(unionChange,applyLogType.getName(), null ,unionChange.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionChange)); applyLogMapper.insert(log); return unionChange.getId(); } /** * 取消保单合并 * @param closeDTO */ @Override @Transactional(rollbackFor = {Exception.class,BusinessException.class}) public void cancelMerge(CloseDTO closeDTO){ if(Objects.isNull(closeDTO) ||Objects.isNull(closeDTO.getId()) ||StringUtils.isBlank(closeDTO.getReason())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); user.setType(Constants.formatIntegerNum(user.getType())); if(!(Constants.equalsInteger(user.getType(),Constants.ZERO) || Constants.equalsInteger(user.getType(),Constants.TWO))){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户平台用户，无法进行该操作！"); } UnionChange unionChange = unionChangeMapper.selectById(closeDTO.getId()); if(Objects.isNull(unionChange)||!Constants.equalsInteger(unionChange.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } unionChange.setStatus(Constants.formatIntegerNum(unionChange.getStatus())); unionChange.setShopId(Constants.formatIntegerNum(unionChange.getShopId())); if(!(Constants.equalsInteger(user.getType(),Constants.ZERO)||unionChange.getShopId().equals(user.getCompanyId()))){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起非您的合并单，您无法进行操作！"); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.FINISH.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已完结，您无法进行该操作！"); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.CLOSE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已关闭"); } applyChangeJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChange::getUnionChangeId,null) .set(ApplyChange::getCheckDate,new Date()) .set(ApplyChange::getCheckUserId,user.getId()) .set(ApplyChange::getStatus,Constants.ApplyChangeStatus.CLOSE.getKey()) .in(ApplyChange::getUnionChangeId,unionChange.getId()) ); applyChagneDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChagneDetail::getUnionChangeId,null) .eq(ApplyChagneDetail::getUnionChangeId,unionChange.getId())); unionChangeMapper.update(null,new UpdateWrapper().lambda() .set(UnionChange::getStatus,Constants.UnionChangeStatus.CLOSE.getKey()) .eq(UnionChange::getId,unionChange.getId()) ); Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_CLOSE; String info =applyLogType.getInfo(); info = info.replace("${param}", closeDTO.getReason()); ApplyLog log = new ApplyLog(unionChange,applyLogType.getName(), info ,unionChange.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionChange)); applyLogMapper.insert(log); } @Override public UnionChange unionChangeDetail(Integer unionChangeId){ if(Objects.isNull(unionChangeId)){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } UnionChange unionChange = unionChangeJoinMapper.selectJoinOne(UnionChange.class, new MPJLambdaWrapper() .selectAll(UnionChange.class) .selectAs(Company::getName,UnionChange::getShopName) .selectAs(Solutions::getName,UnionChange::getSolutionsName) .selectAs(UnionApply::getCode,UnionChange::getApplyCode) .selectAs(UnionApply::getStartTime,UnionChange::getStartTime) .selectAs(UnionApply::getEndTime,UnionChange::getEndTime) .leftJoin(UnionApply.class,UnionApply::getId,UnionChange::getUnionApplyId) .leftJoin(Company.class,Company::getId,UnionChange::getShopId) .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) .eq(UnionChange::getId,unionChangeId) .last(" limit 1 ") ); //企业名称 List applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class,new MPJLambdaWrapper() .selectAll(ApplyChange.class) .selectAs(Company::getName,ApplyChange::getCompanyName) .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) .eq(ApplyChange::getUnionChangeId,unionChangeId) ); String companyNames = String.join(",",applyChangeList.stream().map(m->m.getCompanyName()).collect(Collectors.toList())); List applyChagneDetailList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,new MPJLambdaWrapper() .selectAll(ApplyChagneDetail.class) .selectAs(Member::getName,ApplyChagneDetail::getMemberName) .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo) .selectAs(Member::getSex,ApplyChagneDetail::getSex) .selectAs(Company::getName,ApplyChagneDetail::getCompanyName) .select("t2.name",ApplyChagneDetail::getWorkTypeName) .select("t3.name",ApplyChagneDetail::getDuName) .select("t4.name",ApplyChagneDetail::getOldWorkTypeName) .select("t5.name",ApplyChagneDetail::getOldDuName) .leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId) .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId) .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId) .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId) .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId) .leftJoin(Company.class,Company::getId,Member::getCompanyId) .eq(ApplyChagneDetail::getUnionChangeId,unionChangeId) ); unionChange.setCompanyNames(companyNames); unionChange.setApplyChagneDetailList(applyChagneDetailList); return unionChange; } /** * 合并单（加减保/换厂） - 投保申请签署 * @param smsCheckDTO * @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(); UnionChange unionChange = this.unionChangeDetail(smsCheckDTO.getBusinessId()); unionChange.setStatus(Constants.formatIntegerNum(unionChange.getStatus())); if(Objects.isNull(unionChange)||!Constants.equalsInteger(unionChange.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } String companyName = ""; String creditCode = ""; String email = ""; String signId = ""; if(Constants.equalsInteger(user.getType(),Constants.TWO)){ if(!unionChange.getShopId().equals(user.getCompanyId())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起非您的合并单，您无法进行操作！"); } Company company = companyMapper.selectById(user.getCompanyId()); if(company== null || StringUtils.isBlank( company.getEmail()) || !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，企业尚未具备在线签章条件，请联系平台管理员确认~"); } companyName = company.getName(); creditCode = company.getCode(); email = company.getEmail(); signId = company.getSignId(); }else{ companyName = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PLAT_COMPANY_NAME).getCode(); creditCode = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PLAT_CREDIT_CODE).getCode(); email = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PLAT_EMAIL).getCode(); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.FINISH.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已完结，您无法进行该操作！"); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.CLOSE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已关闭"); } if(!unionChange.getStatus().equals(Constants.UnionChangeStatus.MERGE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单状态已流转"); } String fileUrl = null; if(Constants.equalsObject(unionChange.getType(), Constants.ONE)){ fileUrl = ExcelExporter.build(UnionChange.class).exportUnionChangeOtherUnitExcelToPdf(unionChange,"换厂申请表"); }else{ fileUrl = ExcelExporter.build(UnionChange.class).exportUnionChangeExcelToPdf(unionChange,"加减保申请表"); } String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode(); notifyUrl = notifyUrl.replace("${type}","0").replace("${id}",unionChange.getId().toString()); String applyNo = signService.applySignLocalFileByParam(companyName,companyName,fileUrl,creditCode,email,"合并单（加减保/换厂）申请签署",null,notifyUrl,new Float(0.7)); //临时使用 // fileUrl = "https://yybred.oss-cn-hangzhou.aliyuncs.com/apply/20241230/a0d128f2-ba6c-4ad4-b86b-b2610a513d41.pdf"; // String applyNo = signService.applySignWidthQifengSet(companyName,fileUrl,companyName,creditCode,email,"人员名单签章",null,notifyUrl,new Float(0.7)); if(StringUtils.isBlank(applyNo) ){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！"); } String link = signService.signLink(applyNo,companyName,creditCode); if(StringUtils.isBlank(link) ){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！"); } UnionChange update= new UnionChange(); update.setId(unionChange.getId()); update.setEditor(user.getId()); update.setEditDate(new Date()); update.setSignApplyNo(applyNo); unionChangeMapper.updateById(update); return link; } @Autowired private RedisTemplate redisTemplate;// Redis操作类，对这个使用不熟悉的，可以参考前面的博客 private static final String KEY_PREFIX = "unionchange:upload:"; @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public void uploadBXD(UnionChangeBXDDTO unionChangeBXDDTO){ try{ if(Objects.nonNull(redisTemplate.opsForValue().get(KEY_PREFIX+unionChangeBXDDTO.getId()))){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"请勿重复提交"); }; redisTemplate.opsForValue().set(KEY_PREFIX+unionChangeBXDDTO.getId(), unionChangeBXDDTO.getId(), 30000, TimeUnit.SECONDS); if(Objects.isNull(unionChangeBXDDTO) || Objects.isNull(unionChangeBXDDTO.getId()) || Objects.isNull(unionChangeBXDDTO.getApplyDate()) // || StringUtils.isBlank(unionChangeBXDDTO.getName()) // || StringUtils.isBlank(unionChangeBXDDTO.getFileurl()) || StringUtils.isBlank(unionChangeBXDDTO.getCode()) || CollectionUtils.isEmpty(unionChangeBXDDTO.getPidanFileList()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); UnionChange unionChange = unionChangeMapper.selectById(unionChangeBXDDTO.getId()); if(Objects.isNull(unionChange)||!Constants.equalsInteger(unionChange.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } if(!Constants.equalsInteger(unionChange.getType(),Constants.ONE)&& unionChangeBXDDTO.getDelValidTime() == null ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } unionChangeBXDDTO.setApplyId(unionChange.getUnionApplyId()); unionChange.setStatus(Constants.formatIntegerNum(unionChange.getStatus())); unionChange.setShopId(Constants.formatIntegerNum(unionChange.getShopId())); if(Constants.equalsInteger(user.getType(),Constants.TWO) && !unionChange.getShopId().equals(user.getCompanyId())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起非您的合并单，您无法进行操作！"); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.FINISH.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已完结，您无法进行该操作！"); } if(unionChange.getStatus().equals(Constants.UnionChangeStatus.CLOSE.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单业务已关闭"); } if(!unionChange.getStatus().equals(Constants.UnionChangeStatus.UPLOAD_INSURANCE_POLICY.getKey())){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，合并单状态已流转"); } UnionApply unionApply = unionApplyMapper.selectById(unionChange.getUnionApplyId()); if(Objects.isNull(unionApply)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到合并保单信息"); } Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId()); if(Objects.isNull(solutions)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保险方案"); } if(unionChange.getType().equals(Constants.ZERO)){ //判断批单日期 合并单的批单生效期在为 保单起期的次日 到保单止期 //获取开始日期次日 if(unionChangeBXDDTO.getApplyDate().getTime() unionApply.getEndTime().getTime()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"合并单的批单加保生效期错误"); } if(unionChangeBXDDTO.getDelValidTime().getTime() unionApply.getEndTime().getTime()){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"合并单的批单减保生效期错误"); } }else{ if(unionChangeBXDDTO.getApplyDate().getTime() applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class, new MPJLambdaWrapper() .selectAll(ApplyChange.class) .selectAs(InsuranceApply::getSolutionId,ApplyChange::getSolutionsId) .selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode) .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) .eq(ApplyChange::getUnionChangeId,unionChange.getId())); List pidanFileList = unionChangeBXDDTO.getPidanFileList(); for (Multifile pidanFile:pidanFileList) { if(StringUtils.isBlank( pidanFile.getFileurl()) ||StringUtils.isBlank( pidanFile .getName())) { throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"批单文件参数错误"); } pidanFile.setIsdeleted(Constants.ZERO); pidanFile.setCreator(user.getId()); pidanFile.setObjId(unionChange.getId()); pidanFile.setCreateDate(new Date()); pidanFile.setObjType(Constants.MultiFile.WTB_CA_DONE_PDF.getKey()); pidanFile.setType(Constants.TWO); } multifileMapper.insertBatchSomeColumn(pidanFileList); for (ApplyChange applyChange:applyChangeList) { for (Multifile pidanFile:pidanFileList) { Multifile m = new Multifile(); m.setId(null); m.setIsdeleted(Constants.ZERO); m.setCreator(user.getId()); m.setCreateDate(new Date()); m.setObjId(applyChange.getId()); m.setFileurl(pidanFile.getFileurl()); m.setName(pidanFile.getName()); m.setObjType(Constants.MultiFile.CA_PD_PDF.getKey()); m.setType(Constants.TWO); multifileMapper.insert(m); } } if(CollectionUtils.isNotEmpty(applyChangeList)){ for (ApplyChange applyChange:applyChangeList) { ApplyChange oldModel = applyChange; applyChange.setApplyStartTime(unionChangeBXDDTO.getApplyDate()); applyChange.setDelValidTime(unionChangeBXDDTO.getDelValidTime()); // applyChange.setValidTime(unionChangeBXDDTO.getApplyDate()); applyChange.setEditDate(new Date()); applyChange.setEditor(user.getId()); applyChange.setStatus(Constants.ApplyChangeStatus.APPROVE.getKey()); applyChange.setCode(unionChangeBXDDTO.getCode()); applyChange.setValidCode(unionChangeBXDDTO.getCode()); applyChange.setCheckUserId(user.getId()); List allList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, new MPJLambdaWrapper() .selectAll(ApplyChagneDetail.class) .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo) .selectAs(Solutions::getTimeUnit, ApplyChagneDetail::getSolutionTimeUnit) .selectAs(Solutions::getPrice, ApplyChagneDetail::getSolutionPrice) .selectAs(Worktype::getName, ApplyChagneDetail::getWorkTypeName) .selectAs(DispatchUnit::getName, ApplyChagneDetail::getDuName) .selectAs(Member::getName, ApplyChagneDetail::getMemberName) .selectAs(Solutions::getName,ApplyChagneDetail::getSolutionsName) .selectAs(InsuranceApply::getCode,ApplyChagneDetail::getApplyCode) .selectAs(InsuranceApply::getServerCost,ApplyChagneDetail::getServerCost) .leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId) .leftJoin(Member.class, Member::getId, ApplyChagneDetail::getMemberId) .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyChange::getApplyId) .leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId) .leftJoin(Worktype.class, Worktype::getId, ApplyChagneDetail::getWorktypeId) .leftJoin(DispatchUnit.class, DispatchUnit::getId, ApplyChagneDetail::getDuId) .eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId())); this.dealApplyChangeDetail(applyChange,allList,solutions); applyChangeJoinMapper.updateById(applyChange); //存储批单完成信息 Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_PLATFORM_APPROVE; String info = ""; if(applyChange.getValidTime()!=null && applyChange.getValidTime().getTime()/1000!= applyChange.getApplyStartTime().getTime()/1000){ info =applyLogType.getInfo(); info = info.replace("${param1}",DateUtil.getPlusTime2(applyChange.getValidTime())); info = info.replace("${param2}",DateUtil.getPlusTime2(applyChange.getApplyStartTime())); } ApplyLog log = new ApplyLog(applyChange,applyLogType.getName(), info,applyChange.getId(),applyLogType.getKey(),JSONObject.toJSONString(oldModel), JSONObject.toJSONString(applyChange)); applyLogMapper.insert(log); } } unionChangeMapper.update(null,new UpdateWrapper().lambda() .set(UnionChange::getStatus,Constants.UnionChangeStatus.FINISH.getKey()) .set(UnionChange::getEditDate,new Date()) .set(UnionChange::getEditor,user.getId()) .set(UnionChange::getValidTime,unionChangeBXDDTO.getApplyDate()) .set(UnionChange::getDelValidTime,unionChangeBXDDTO.getDelValidTime()) .set(UnionChange::getApplyStartTime,unionChangeBXDDTO.getApplyDate()) .set(UnionChange::getCode,unionChangeBXDDTO.getCode()) .eq(UnionChange::getId,unionChangeBXDDTO.getId()) ); Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_UPLOAD_INSURANCE; ApplyLog log = new ApplyLog(unionChange,applyLogType.getName(), null ,unionChange.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionChange)); applyLogMapper.insert(log); }catch (Exception e){ e.printStackTrace(); }finally { redisTemplate.delete(KEY_PREFIX + unionChangeBXDDTO.getId()); } } public void dealApplyChangeDetail(ApplyChange applyChange,List applyChagneDetailList,Solutions solutions){ BigDecimalVO bigDecimalVO = new BigDecimalVO(); bigDecimalVO.setTotalFee(BigDecimal.ZERO); bigDecimalVO.setCurrentFee(BigDecimal.ZERO); InsuranceApply insuranceApply = insuranceApplyMapper.selectById(applyChange.getApplyId()); List addList = applyChagneDetailList.stream().filter(f->Constants.equalsInteger(f.getType(),Constants.ZERO)).collect(Collectors.toList()); List reduceList = applyChagneDetailList.stream().filter(f->Constants.equalsInteger(f.getType(),Constants.ONE)).collect(Collectors.toList()); List changeList = applyChagneDetailList.stream().filter(f->Constants.equalsInteger(f.getType(),Constants.TWO)).collect(Collectors.toList()); for (ApplyChagneDetail detail:reduceList) { Member member = memberMapper.selectById(detail.getMemberId()); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据"); } this.reduceChangeDetailData(applyChange,detail,insuranceApply,solutions,bigDecimalVO); } for (int i = 0; i < addList.size(); i++) { ApplyChagneDetail detail = addList.get(i); Member member = memberMapper.selectById(detail.getMemberId()); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据"); } this.addChangeDetailData(applyChange,detail,insuranceApply,solutions,bigDecimalVO,reduceList,i); } for (ApplyChagneDetail detail:changeList) { Member member = memberMapper.selectById(detail.getMemberId()); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据"); } this.otherChangeDetailData(applyChange,detail,insuranceApply); } //如果保单金额发生编码，更新总保单金额 insuranceApplyMapper.update(null, new UpdateWrapper().lambda() .setSql(bigDecimalVO.getTotalFee().compareTo(new BigDecimal(0)) != 0," fee = ifnull(fee,0)+" + bigDecimalVO.getTotalFee()) .setSql(bigDecimalVO.getCurrentFee().compareTo(new BigDecimal(0)) != 0," current_fee = ifnull(current_fee,0)+" + bigDecimalVO.getCurrentFee()) .set(InsuranceApply::getEditor, applyChange.getEditor()) .set(InsuranceApply::getEditDate, applyChange.getEditDate()) .eq(InsuranceApply::getId, applyChange.getApplyId()) ); applyChange.setFee(bigDecimalVO.getTotalFee()); } /** * 加保数据处理 * @param applyChange * @param detail */ public void addChangeDetailData(ApplyChange applyChange, ApplyChagneDetail detail,InsuranceApply insuranceApply,Solutions solutions , BigDecimalVO bigDecimalVO,List reduceList,Integer i){ //查询人员信息是否存在相同的方案下是否存在 冲突数据 InsuranceApplyServiceImpl.checkStaticMemberSolution(solutions.getBaseId(), detail.getMemberId(),detail.getIdcardNo(),detail.getMemberName(),DateUtil.getMontageDate(applyChange.getApplyStartTime(),1),DateUtil.getMontageDate(detail.getEndTime(),2), applyDetailJoinMapper); //加保 ApplyDetail add = new ApplyDetail(); BigDecimal fee = Objects.isNull(insuranceApply.getServerCost())? solutions.getPrice(): solutions.getPrice().add(insuranceApply.getServerCost()); add.setFee(Constants.addFee (solutions,fee,insuranceApply.getStartTime(),insuranceApply.getFinalEndTime(),applyChange.getApplyStartTime(),insuranceApply.getEndTime())); if(new Date().compareTo(DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1))>=0){ add.setCurrentFee( Constants.produceFee(solutions,fee,insuranceApply.getStartTime(),insuranceApply.getEndTime(),DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1)) ); }else{ add.setCurrentFee(BigDecimal.ZERO); } add.setPrice(detail.getPrice()); add.setApplyId(applyChange.getApplyId()); add.setValidCode(applyChange.getValidCode()); add.setIsdeleted(Constants.ZERO); add.setCreator(applyChange.getEditor()); add.setCreateDate(applyChange.getEditDate()); add.setMemberId(detail.getMemberId()); add.setMemberName(detail.getMemberName()); add.setWorktypeId(detail.getWorktypeId()); add.setIsdeleted(Constants.ZERO); add.setIdcardNo(detail.getIdcardNo()); add.setSex(Constants.getSexByIdCard(detail.getIdcardNo())); add.setMemberName(detail.getMemberName()); add.setDuId(detail.getDuId()); add.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1)); add.setEndTime(DateUtil.getMontageDate(detail.getEndTime(), 2)); add.setRemark(detail.getRemark()); add.setUnionApplyId(insuranceApply.getUnionApplyId()); add.setChangeStatus(Constants.ZERO); if(Constants.equalsInteger(solutions.getDelOnlyReplace(),Constants.ONE) && Constants.equalsInteger(solutions.getTimeUnit(),solutions.getInsureCycleUnit()) && i < reduceList.size() ){ add.setReduceId(reduceList.get(i).getApplyDetailId()); } applyDetailJoinMapper.insert(add); detail.setFee(Objects.isNull(add.getReduceId())?add.getFee():BigDecimal.ZERO); bigDecimalVO.setTotalFee(bigDecimalVO.getTotalFee().add(add.getFee())); //如果不是替换业务的加保数据 则添加实际产生费用 if(Objects.isNull(add.getReduceId())){ bigDecimalVO.setCurrentFee(bigDecimalVO.getCurrentFee().add(add.getCurrentFee())); } applyChagneDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChagneDetail::getFee,detail.getFee()) .set(ApplyChagneDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1)) .eq(ApplyChagneDetail::getId,detail.getId()) ); MemberInsurance memberInsurance = new MemberInsurance(detail, applyChange, applyChange.getEditor(), add.getId(),applyChange.getSolutionsId()); memberInsurance.setStartTime(add.getStartTime()); memberInsurance.setEndTime(add.getEndTime()); memberInsurance.setRelationType(Constants.ONE); memberInsurance.setPdCode(applyChange.getValidCode()); memberInsuranceJoinMapper.insert(memberInsurance); memberMapper.update(null,new UpdateWrapper() .lambda() .set(Member::getStartTime,memberInsurance.getStartTime()) .set(Member::getEndTime,memberInsurance.getEndTime()) .set(Member::getDuId,memberInsurance.getDuId()) .set(Member::getEditDate,applyChange.getEditDate()) .set(Member::getEditor,applyChange.getEditor()) .set(Member::getWorktypeId,memberInsurance.getWorktypeId()) .eq(Member::getId, memberInsurance.getMemberId()) ); // if(1==1){ // throw new BusinessException(ResponseStatus.NOT_ALLOWED); // } } /** * 减保数据处理 * @param applyChange * @param detail */ public void reduceChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail,InsuranceApply insuranceApply,Solutions solutions ,BigDecimalVO bigDecimalVO){ //查询员工是在主单下 是否存在生效中的数据 ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper().lambda() .eq(ApplyDetail::getApplyId, applyChange.getApplyId()) .eq(ApplyDetail::getMemberId, detail.getMemberId()) .orderByDesc(ApplyDetail::getCreateDate) .last("limit 1")); // if (oldModel == null || oldModel.getStartTime() == null || oldModel.getStartTime().getTime() > applyChange.getDelValidTime().getTime()) { // throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "对不起，用户【" + detail.getMemberName() + "】当前批减日期不支持减保操作！"); // } // if(oldModel.getStartTime().getTime()>applyChange.getDelValidTime().getTime()||oldModel.getEndTime().getTime() oldModel.getStartTime().getTime()){ reduceDate = DateUtil.getMontageDate(applyChange.getDelValidTime(), 3); //减保记录操作后的总费用 reduceFee = Constants.reduceFee( solutions,fee,insuranceApply.getStartTime(),insuranceApply.getFinalEndTime(),oldModel.getStartTime(),reduceDate) ; }else if(reduceDate.getTime()0){ pullFee = reduceFee; } } UpdateWrapper updateWrapper = new UpdateWrapper(); updateWrapper.lambda() .setSql(" fee = " + reduceFee) .setSql(" current_fee = " + pullFee) .set(ApplyDetail::getEndTime, reduceDate) .set(applyChange.getDelValidTime().getTime() <= oldModel.getStartTime().getTime(),ApplyDetail::getChangeStatus,Constants.TWO) .set(ApplyDetail::getEditor, applyChange.getEditor()) .set(ApplyDetail::getEditDate, applyChange.getEditDate()) .eq(ApplyDetail::getId, oldModel.getId()); BigDecimal reduceMoney = BigDecimal.ZERO; if(Constants.equalsInteger(solutions.getDelOnlyReplace(),Constants.ONE) && Constants.equalsInteger(solutions.getTimeUnit(),solutions.getInsureCycleUnit())){ if(reduceDate.getTime()<=oldModel.getStartTime().getTime()){ reduceFee = BigDecimal.ZERO; updateWrapper.lambda().set(ApplyDetail::getFee,reduceFee) .set(ApplyDetail::getChangeStatus,Constants.TWO); }else{ reduceMoney = solutions.getPrice().multiply(new BigDecimal(-1)); //标记数据已被替换 updateWrapper.lambda().set(ApplyDetail::getReduceMoney,reduceMoney) .set(ApplyDetail::getChangeStatus,Constants.ONE); } detail.setApplyDetailId(oldModel.getId()); } bigDecimalVO.setTotalFee(bigDecimalVO.getTotalFee().add(reduceFee).subtract(oldModel.getFee()).add(reduceMoney)); bigDecimalVO.setCurrentFee(bigDecimalVO.getCurrentFee().add(pullFee).subtract(oldModel.getCurrentFee())); applyDetailJoinMapper.update(null, updateWrapper); List oldMemberInsurance = memberInsuranceJoinMapper.selectList(new QueryWrapper().lambda().eq(MemberInsurance::getRelationId,oldModel.getId())); for (MemberInsurance memberInsurance:oldMemberInsurance) { //记录数据早于批单日期 if(memberInsurance.getStartTime().getTime()>reduceDate.getTime()){ memberInsurance.setIsValid(Constants.ONE); }else if(memberInsurance.getEndTime().getTime()>=reduceDate.getTime() && memberInsurance.getStartTime().getTime()<=reduceDate.getTime()){ memberInsurance.setFee(reduceFee); memberInsurance.setEndTime(reduceDate); } memberInsuranceJoinMapper.updateById(memberInsurance); } memberMapper.update(null,new UpdateWrapper() .lambda() .set(Member::getStartTime,oldModel.getStartTime()) .set(Member::getEndTime,reduceDate) .set(Member::getDuId,oldModel.getDuId()) .set(Member::getWorktypeId,oldModel.getWorktypeId()) .eq(Member::getId, oldModel.getMemberId()) ); //修改业务明细行数据实际批单日期 applyChagneDetailJoinMapper.update(null,new UpdateWrapper().lambda() .set(ApplyChagneDetail::getFee,reduceFee.subtract(oldModel.getFee())) .set(ApplyChagneDetail::getEndTime,reduceDate) .eq(ApplyChagneDetail::getId,detail.getId()) ); detail.setApplyDetailId(oldModel.getId()); } public void otherChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail,InsuranceApply insuranceApply){ //实际批单生效日期 Date applyStartTime = DateUtil.getMontageDate(applyChange.getApplyStartTime(),1); //查询减保人员是否存在 冲突的 保单明细数据 /*if(applyDetailJoinMapper.selectCount(new QueryWrapper() .lambda() .eq(ApplyDetail::getApplyId,applyChange.getApplyId()) .eq(ApplyDetail::getIdcardNo,detail.getIdcardNo()) .le(ApplyDetail::getStartTime,applyStartTime) .ge(ApplyDetail::getEndTime,applyStartTime) )<=Constants.ZERO){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，换厂人员【" + detail.getMemberName() + "】未查询到符合批单日期的数据"); } */ //查询员工是在主单下 是否存在生效中的数据 ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper().lambda() .eq(ApplyDetail::getApplyId, applyChange.getApplyId()) .eq(ApplyDetail::getMemberId, detail.getMemberId()) .le(ApplyDetail::getStartTime,applyStartTime) .ge(ApplyDetail::getEndTime,applyStartTime) .orderByDesc(ApplyDetail::getCreateDate) .last("limit 1")); if(oldModel == null ){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，用户【"+detail.getMemberName()+"】原保单信息有误，批单日期未在保单日期内！"); } MemberInsurance memberInsurance = new MemberInsurance(detail,applyChange,applyChange.getEditor(),null,insuranceApply.getSolutionId()); memberInsurance.setSolutionId(detail.getSolutionId()); memberInsurance.setWorktypeName(detail.getWorkTypeName()); memberInsurance.setDuName(detail.getDuName()); memberInsurance.setApplyChangeId(detail.getApplyChangeId()); memberInsurance.setSolutionName(detail.getSolutionsName()); memberInsurance.setPdCode(applyChange.getValidCode()); memberInsurance.setBdCode(insuranceApply.getCode()); memberInsurance.setRelationType(Constants.ONE); memberInsurance.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(),1)); memberInsurance.setEndTime(oldModel.getEndTime()); applyDetailJoinMapper.update(null, new UpdateWrapper().lambda() .set(ApplyDetail::getEditor,applyChange.getEditor()) .set(ApplyDetail::getEditDate,applyChange.getEditDate()) .set(ApplyDetail::getDuId,detail.getDuId()) .set(ApplyDetail::getWorktypeId,detail.getWorktypeId()) .eq(ApplyDetail::getId,oldModel.getId()) ); // memberInsuranceJoinMapper.update(null,new UpdateWrapper().lambda() // .set(MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),3)) // .eq(MemberInsurance::getRelationId,oldModel.getId()) // ); memberInsuranceJoinMapper.update(null,new UpdateWrapper().lambda() .eq(MemberInsurance::getApplyId,applyChange.getApplyId()) .eq(MemberInsurance::getMemberId,detail.getMemberId()) .le(MemberInsurance::getStartTime,applyStartTime) .ge(MemberInsurance::getEndTime,applyStartTime) .set(insuranceApply.getStartTime().compareTo(applyChange.getApplyStartTime())!=0, MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 3)) .set(insuranceApply.getStartTime().compareTo(applyChange.getApplyStartTime())==0, MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) // .ne(MemberInsurance::getId,memberInsurance.getId()) // .eq(MemberInsurance::getRelationId,oldModel.getId()) ); memberInsuranceJoinMapper.insert(memberInsurance); // //如果实际批单日期 和 原记录日期相等 则直接修改记录派遣单位与工种信息 // if(applyStartTime.compareTo(oldModel.getStartTime())!=Constants.ZERO){ // //当前日期大于批单日期 需要回滚数据实际数据 // Boolean flag = DateUtil.getMontageDate(new Date(),2).compareTo(DateUtil.getMontageDate(applyStartTime,2))>0; // //换厂后历史记录的费用 fee // Integer days = DateUtil.calculateBetween(DateUtil.getMontageDate(applyStartTime,3),DateUtil.getMontageDate(oldModel.getStartTime(),1),0); // BigDecimal oldFee = new BigDecimal(days).multiply(detail.getPrice()); // BigDecimal fee = oldModel.getFee(); // BigDecimal oldCurrentFee = oldModel.getCurrentFee(); // // applyDetailJoinMapper.update(null, new UpdateWrapper().lambda() // .set(ApplyDetail::getEditor,applyChange.getEditor()) // .set(ApplyDetail::getEditDate,applyChange.getEditDate()) // .set(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyStartTime,3)) // .set(ApplyDetail::getFee,oldFee) // .set(flag,ApplyDetail::getCurrentFee,oldFee) // .eq(ApplyDetail::getId,oldModel.getId()) // ); // // //修改 员工投保明细记录 历史数据 // memberInsuranceJoinMapper.update(null,new UpdateWrapper().lambda() // .set(MemberInsurance::getEndTime,DateUtil.getMontageDate(applyStartTime,3)) // .set(MemberInsurance::getFee,oldFee) // .eq(MemberInsurance::getRelationId,oldModel.getId()) // ); // // ApplyDetail add = new ApplyDetail(); // add.setApplyId(oldModel.getApplyId()); // add.setCreateDate(new Date()); // add.setCreator(applyChange.getEditor()); // add.setMemberId(oldModel.getMemberId()); // add.setIdcardNo(detail.getIdcardNo()); // add.setSex(Constants.getSexByIdCard(detail.getIdcardNo())); // add.setMemberName(detail.getMemberName()); // add.setStartTime(DateUtil.getMontageDate(applyStartTime,1)); // add.setEndTime(oldModel.getEndTime()); // add.setDuId(detail.getDuId()); // add.setWorktypeId(detail.getWorktypeId()); // add.setIdcardNo(oldModel.getIdcardNo()); // add.setFee(fee.subtract(oldFee)); // add.setIsdeleted(Constants.ZERO); // if(flag){ // add.setCurrentFee(oldCurrentFee.multiply(oldFee)); // }else{ // add.setCurrentFee(BigDecimal.ZERO); // } // add.setSex(oldModel.getSex()); // add.setMemberName(oldModel.getMemberName()); // add.setFromId(detail.getId()); // applyDetailJoinMapper.insert(add); // // MemberInsurance memberInsurance = new MemberInsurance(add,applyChange.getId()); // memberInsurance.setSolutionId(detail.getSolutionId()); // memberInsurance.setWorktypeName(detail.getWorkTypeName()); // memberInsurance.setDuName(detail.getDuName()); // memberInsurance.setApplyChangeId(detail.getApplyChangeId()); // memberInsurance.setSolutionName(detail.getSolutionsName()); // memberInsurance.setPdCode(applyChange.getValidCode()); // memberInsurance.setBdCode(applyChange.getApplyCode()); // memberInsurance.setRelationType(Constants.ONE); // memberInsuranceJoinMapper.insert(memberInsurance); // // }else{ // applyDetailJoinMapper.update(null, new UpdateWrapper().lambda() // .set(ApplyDetail::getEditor,applyChange.getEditor()) // .set(ApplyDetail::getEditDate,applyChange.getEditDate()) // .set(ApplyDetail::getDuId,detail.getDuId()) // .set(ApplyDetail::getWorktypeId,detail.getWorktypeId()) // .eq(ApplyDetail::getId,oldModel.getId()) // ); // //员工投保明细记录 历史数据 // memberInsuranceJoinMapper.update(null,new UpdateWrapper().lambda() // .set(MemberInsurance::getDuId,detail.getDuId()) // .set(MemberInsurance::getDuName,detail.getDuName()) // .set(MemberInsurance::getWorktypeId,detail.getWorktypeId()) // .set(MemberInsurance::getWorktypeName,detail.getWorkTypeName()) // .eq(MemberInsurance::getRelationId,oldModel.getId()) // ); // // } Member member = memberMapper.selectById(detail.getMemberId()); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据"); } member.setApplyId(applyChange.getApplyId()); member.setDuId(detail.getDuId()); member.setWorktypeId(detail.getWorktypeId()); member.setStartTime(detail.getStartTime()); member.setEndTime(detail.getEndTime()); memberMapper.updateById(member); } }