| | |
| | | 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.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.SystemUserMapper; |
| | | 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.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; |
| | |
| | | import com.github.xiaoymin.knife4j.core.util.CollectionUtils; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | import java.math.RoundingMode; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | |
| | | private SmsEmailService smsEmailService; |
| | | @Autowired |
| | | private ApplyLogMapper applyLogMapper; |
| | | @Autowired |
| | | private ApplyLogJoinMapper applyLogJoinMapper; |
| | | |
| | | @Autowired |
| | | private MemberInsuranceJoinMapper memberInsuranceJoinMapper; |
| | | @Autowired |
| | | private MemberMapper memberMapper; |
| | | @Autowired |
| | | private SystemUserMapper systemUserMapper; |
| | | |
| | | @Autowired |
| | | private CompanyDepartmentMapper companyDepartmentMapper; |
| | | @Value("${debug_model}") |
| | | private boolean debugModel; |
| | | |
| | |
| | | MPJLambdaWrapper<UnionApply> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.selectAll(UnionApply.class); |
| | | queryWrapper.selectAs(Solutions::getName,UnionApply::getSolutionName); |
| | | queryWrapper.select("(select count(b.id) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum "); |
| | | queryWrapper.leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId); |
| | | 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) |
| | | .select(" (select c.NAME from insurance_apply i left join company c on i.COMPANY_ID = c.id where i.UNION_APPLY_ID = t.id limit 1 ) ",UnionApply::getCompanyName); |
| | | queryWrapper.select("(select count(distinct(b.MEMBER_ID)) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum "); |
| | | queryWrapper.select(" ( select count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id and a.status in ( 5 , 27 ) where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum"); |
| | | |
| | | if(pageWrap.getModel().getQueryFlag() == 1){ |
| | | 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 a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 0 ) as addApplyNum "); |
| | | |
| | | |
| | | }else if(pageWrap.getModel().getQueryFlag() ==2){ |
| | | 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 a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 1 ) as changeApplyNum "); |
| | | }else{ |
| | | 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().getHasApplying() != null) { |
| | | if(Constants.equalsInteger(pageWrap.getModel().getHasApplying() ,Constants.ONE)){ |
| | | queryWrapper.exists( |
| | | " ( select 1 from apply_change a inner join insurance_apply b on a.apply_id = b.id where b.union_apply_id= t.id " + |
| | | " and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 0 ) " |
| | | ); |
| | | }else if(Constants.equalsInteger(pageWrap.getModel().getHasApplying() ,Constants.TWO)){ |
| | | queryWrapper.exists( |
| | | " ( select 1 from apply_change a inner join insurance_apply b on a.apply_id = b.id where b.union_apply_id= t.id " + |
| | | " and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 1 ) " |
| | | ); |
| | | } |
| | | |
| | | } |
| | | if (pageWrap.getModel().getCreator() != null) { |
| | | queryWrapper.eq(UnionApply::getCreator, pageWrap.getModel().getCreator()); |
| | |
| | | if (pageWrap.getModel().getStatus() != null) { |
| | | queryWrapper.eq(UnionApply::getStatus, pageWrap.getModel().getStatus()); |
| | | } |
| | | if (pageWrap.getModel().getQueryStatus() != null) { |
| | | if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.THREE)){ |
| | | queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey()); |
| | | queryWrapper.apply(" t.START_TIME < now() and t.END_TIME > now() "); |
| | | }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.SIX)){ |
| | | queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey()); |
| | | queryWrapper.apply(" t.END_TIME < now() "); |
| | | }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.FIVE)){ |
| | | queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey()); |
| | | queryWrapper.apply(" t.START_TIME > now() "); |
| | | }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.ZERO)){ |
| | | queryWrapper.in(UnionApply::getStatus, Constants.UnionApplyStatus.MERGE.getKey(),Constants.UnionApplyStatus.RETRIAL.getKey()); |
| | | }else{ |
| | | queryWrapper.eq(UnionApply::getStatus, pageWrap.getModel().getQueryStatus()); |
| | | } |
| | | |
| | | } |
| | | |
| | | if (pageWrap.getModel().getCurrentFee() != null) { |
| | | queryWrapper.eq(UnionApply::getCurrentFee, pageWrap.getModel().getCurrentFee()); |
| | | } |
| | |
| | | } |
| | | if (pageWrap.getModel().getSignApplyNo() != null) { |
| | | queryWrapper.eq(UnionApply::getSignApplyNo, pageWrap.getModel().getSignApplyNo()); |
| | | }if(pageWrap.getSorts().size() == 0){ |
| | | } |
| | | if(pageWrap.getSorts().size() == 0){ |
| | | queryWrapper.orderByDesc(UnionApply::getCreateDate ); |
| | | }else { |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | |
| | | } |
| | | |
| | | PageData<UnionApply> pageData = PageData.from(unionApplyJoinMapper.selectJoinPage(page,UnionApply.class, queryWrapper)); |
| | | if(pageData!=null && pageData.getRecords()!=null){ |
| | | for(UnionApply model : pageData.getRecords()){ |
| | | initStatusInfo(model); |
| | | } |
| | | } |
| | | return pageData; |
| | | } |
| | | |
| | | private void initStatusInfo(UnionApply model) { |
| | | model.setStatusInfo(Constants.UnionApplyStatus.getName(Constants.formatIntegerNum(model.getStatus()))); |
| | | |
| | | if(Constants.equalsInteger(model.getStatus(),Constants.UnionApplyStatus.FINISH.getKey())){ |
| | | if(model.getStartTime().getTime()>System.currentTimeMillis()){ |
| | | model.setStatusInfo("待生效"); |
| | | }else if(model.getEndTime().getTime()<System.currentTimeMillis()){ |
| | | model.setStatusInfo("已过期"); |
| | | }else{ |
| | | model.setStatusInfo("保障中"); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public long count(UnionApply unionApply) { |
| | | QueryWrapper<UnionApply> wrapper = new QueryWrapper<>(unionApply); |
| | | return unionApplyMapper.selectCount(wrapper); |
| | | } |
| | | |
| | | @Override |
| | | public UnionApply findDetailForExport(UnionApply model){ |
| | | UnionApply insuranceApply = detail(model.getId()); |
| | | if(Objects.isNull(insuranceApply)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | |
| | | MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(ApplyDetail.class); |
| | | queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName); |
| | | queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName); |
| | | queryWrapper.selectAs(Worktype::getName,ApplyDetail::getWorkTypeName); |
| | | queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); |
| | | queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); |
| | | queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId); |
| | | queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
| | | queryWrapper.eq( ApplyDetail::getUnionApplyId,model.getId()); |
| | | List<ApplyDetail> detailList= applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); |
| | | //查询明细 |
| | | if(detailList!=null){ |
| | | insuranceApply.setInsureNum(detailList.size()); |
| | | insuranceApply.setApplyDetailList(detailList); |
| | | } |
| | | insuranceApply.setRemark(model.getRemark()); |
| | | return insuranceApply; |
| | | } |
| | | |
| | | |
| | |
| | | new MPJLambdaWrapper<UnionApply>() |
| | | .selectAll(UnionApply.class) |
| | | .selectAs(Solutions::getName,UnionApply::getSolutionName) |
| | | .selectAs(Solutions::getDelOnlyReplace,UnionApply::getDelOnlyReplace) |
| | | .selectAs(Solutions::getHasDispatchUnit,UnionApply::getHasDispatchUnit) |
| | | .selectAs(Solutions::getSignType,UnionApply::getSignType) |
| | | .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 count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id and a.status in ( 5 , 27 ) where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum") |
| | | .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) |
| | |
| | | unionApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),unionApply.getStartTime())+1); |
| | | } |
| | | } |
| | | initStatusInfo(unionApply); |
| | | |
| | | //查询附件数据 |
| | | initImgData(unionApply); |
| | | //查询操作记录 |
| | | List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class, |
| | | new MPJLambdaWrapper<ApplyLog>() |
| | | .selectAll(ApplyLog.class) |
| | | .selectAs(SystemUser::getRealname,ApplyLog::getCreatorName) |
| | | .selectAs(Company::getName,ApplyLog::getCompanyName) |
| | | .selectAs(SystemUser::getType,ApplyLog::getCreatorType) |
| | | .leftJoin(SystemUser.class,SystemUser::getId,ApplyLog::getCreator) |
| | | .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
| | | .in(ApplyLog::getObjType,Constants.ApplyLogType.getTypeList(Constants.THREE)) |
| | | .eq(ApplyLog::getApplyId,unionApply.getId()) |
| | | .orderByAsc(ApplyLog::getCreateDate) |
| | | ); |
| | | unionApply.setApplyLogList(applyLogList); |
| | | |
| | | return unionApply; |
| | | } |
| | | |
| | | |
| | | private void initImgData(UnionApply model) { |
| | | List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() |
| | | .eq(Multifile::getObjId, model.getId()) |
| | | .in(Multifile::getObjType, Arrays.asList(new Integer[]{ |
| | | Constants.MultiFile.HBD_BD_APPLY_PDF.getKey() |
| | | ,Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey() |
| | | ,Constants.MultiFile.WTB_BD_DONE_PDF.getKey() })) |
| | | .eq(Multifile::getIsdeleted,Constants.ZERO) |
| | | .orderByAsc(Multifile::getId)); |
| | | if(multifiles!=null){ |
| | | String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() |
| | | +systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode(); |
| | | for(Multifile f : multifiles){ |
| | | if(StringUtils.isBlank(f.getFileurl())){ |
| | | continue; |
| | | } |
| | | f.setFileurlFull(path+f.getFileurl()); |
| | | if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_APPLY_PDF.getKey())){ |
| | | //签署前的投保单 |
| | | model.setToubaodanFile(f); |
| | | }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey())){ |
| | | //签署后的投保单 |
| | | model.setToubaodanSignedFile(f); |
| | | }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_BD_DONE_PDF.getKey())){ |
| | | //最終保险单 |
| | | model.setBaoxiandanFile(f); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | | @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 |
| | |
| | | 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(),"对不起,方案信息有误,请刷新页面重试"); |
| | | } |
| | | //根据方案查询对应的结束日期 |
| | | CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO(); |
| | | countCyclePriceDTO.setSolutions(solutions); |
| | | countCyclePriceDTO.setStartDate(saveUnionApplyDTO.getStartDate()); |
| | | Date endTime = Constants.getCountCyclePriceVO(countCyclePriceDTO).getEndDate(); |
| | | if(saveUnionApplyDTO.getEndDate().getTime()>endTime.getTime()) { |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "对不起,结束日期超出方案可允许日期周期,请更改后重试!"); |
| | | } |
| | | List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class, |
| | | new MPJLambdaWrapper<InsuranceApply>() |
| | |
| | | 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.setCompanyId(user.getCompanyId()); |
| | | unionApply.setEditor(user.getId()); |
| | | unionApply.setEditDate(new Date()); |
| | | if(Constants.equalsInteger(user.getType(),Constants.ZERO)){ |
| | | unionApply.setCompanyId(solutions.getShopId()); |
| | | }else{ |
| | | unionApply.setCompanyId(user.getCompanyId()); |
| | | } |
| | | unionApply.setStartTime(saveUnionApplyDTO.getStartDate()); |
| | | unionApply.setEndTime(saveUnionApplyDTO.getEndDate()); |
| | | unionApply.setCheckDate(new Date()); |
| | | unionApply.setStatus(Constants.UnionApplyStatus.MERGE.getKey()); |
| | | |
| | | if(Constants.equalsInteger(solutions.getRetrial(),Constants.ONE)){ |
| | | SystemUser systemUser = systemUserMapper.selectById(user.getId()); |
| | | if(Objects.nonNull(systemUser) && Objects.nonNull(systemUser.getDepartmentId())){ |
| | | CompanyDepartment companyDepartment = companyDepartmentMapper.selectById(systemUser.getDepartmentId()); |
| | | if(Objects.nonNull(companyDepartment)&&Objects.nonNull(companyDepartment.getHeadId())){ |
| | | unionApply.setRetrialId(companyDepartment.getHeadId()); |
| | | } |
| | | } |
| | | } |
| | | if(Constants.equalsInteger(solutions.getSignType(), Constants.ZERO)){ |
| | | unionApply.setStatus(Constants.UnionApplyStatus.MERGE.getKey()); |
| | | }else if(Constants.equalsInteger(solutions.getSignType(), Constants.ONE)){ |
| | | unionApply.setStatus(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()); |
| | | }else{ |
| | | if(Objects.nonNull(unionApply.getRetrialId())){ |
| | | unionApply.setStatus(Constants.UnionApplyStatus.RETRIAL.getKey()); |
| | | }else{ |
| | | unionApply.setStatus(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.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<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper<ApplyDetail>().lambda().select(ApplyDetail::getId,ApplyDetail::getPrice) |
| | | List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,new MPJLambdaWrapper<ApplyDetail>() |
| | | .select(ApplyDetail::getId,ApplyDetail::getPrice,ApplyDetail::getStartTime,ApplyDetail::getEndTime,ApplyDetail::getFee) |
| | | .selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo) |
| | | .selectAs(Member::getName,ApplyDetail::getMemberName) |
| | | .leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId) |
| | | .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)); |
| | | |
| | | BigDecimal fee = BigDecimal.ZERO; |
| | | for (ApplyDetail applyDetail:applyDetailList) { |
| | | //查询人员信息是否存在相同的方案下是否存在 冲突数据 |
| | | InsuranceApplyServiceImpl.checkStaticMemberSolution(solutions.getBaseId(), |
| | | applyDetail.getMemberId(),applyDetail.getIdcardNo(),applyDetail.getMemberName(),unionApply.getStartTime(),unionApply.getEndTime(), |
| | | applyDetailJoinMapper); |
| | | fee =fee.add( |
| | | Constants.reduceFee(solutions,solutions.getPrice(),applyDetail.getStartTime(),applyDetail.getEndTime(),saveUnionApplyDTO.getStartDate(),saveUnionApplyDTO.getEndDate()) |
| | | ); |
| | | } |
| | | unionApply.setFee(fee); |
| | | unionApplyMapper.insert(unionApply); |
| | | |
| | | if(Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){ |
| | | //查询企业签章的文件 |
| | | Integer applyId = insuranceApplyList.get(Constants.ZERO).getId(); |
| | | Multifile m = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda().eq(Multifile::getObjId,applyId) |
| | | .eq(Multifile::getObjType,Constants.MultiFile.MEMBER_LIST_LATTER.getKey()) |
| | | .last(" limit 1 ") |
| | | ); |
| | | if(Objects.isNull(m)){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未查询到保单企业签署文件"); |
| | | } |
| | | Multifile multifile = new Multifile(); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | | multifile.setObjId(unionApply.getId()); |
| | | multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()); |
| | | multifile.setFileurl(m.getFileurl()); |
| | | multifileMapper.insert(multifile); |
| | | } |
| | | insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().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<ApplyDetail>().lambda() |
| | | .set(ApplyDetail::getUnionApplyId,unionApply.getId()) |
| | | .in(ApplyDetail::getApplyId,saveUnionApplyDTO.getApplyIds())); |
| | |
| | | applyLogMapper.insert(log); |
| | | |
| | | return unionApply.getId(); |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor ={BusinessException.class,Exception.class} ) |
| | | public Integer reexamineCheck(UnionApply unionApply){ |
| | | LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
| | | UnionApply model = unionApplyMapper.selectById(unionApply.getId()); |
| | | if(Objects.isNull(unionApply)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | if(!Constants.equalsInteger(model.getStatus(),Constants.UnionApplyStatus.RETRIAL.getKey())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,合并单业务已流转,您无法进行该操作!"); |
| | | } |
| | | unionApply.setEditor(user.getId()); |
| | | unionApply.setEditDate(new Date()); |
| | | //如果是商户端,则只能由指定人进行处理 |
| | | if(Constants.equalsInteger(user.getType(),Constants.TWO)){ |
| | | if(!Constants.equalsInteger(model.getRetrialId(),user.getId())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非您的复审数据,无法进行审批"); |
| | | } |
| | | }else{ |
| | | //如果是平台端,根据人员类型处理 如果是固定人员则不限制 其他人员需要比对 |
| | | if(!user.getFixed()){ |
| | | if(!Constants.equalsInteger(model.getRetrialId(),user.getId())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非您的复审数据,无法进行审批"); |
| | | } |
| | | } |
| | | } |
| | | Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_REEXAMINE_PASS; |
| | | String info = applyLogType.getInfo(); |
| | | unionApply.setStatus(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()); |
| | | unionApplyMapper.updateById(unionApply); |
| | | ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info |
| | | ,unionApply.getId(),applyLogType.getKey(),null, null); |
| | | applyLogMapper.insert(log); |
| | | return unionApply.getId(); |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | |
| | | @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(!(Constants.equalsInteger(user.getType(),Constants.ZERO)||Constants.equalsInteger(user.getType(),Constants.TWO))){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"企业用户,无法进行该操作!"); |
| | | } |
| | | if(Objects.isNull(closeDTO)||Objects.isNull(closeDTO.getId())){ |
| | | if(Objects.isNull(closeDTO) |
| | | ||Objects.isNull(closeDTO.getId()) |
| | | ||StringUtils.isBlank(closeDTO.getReason())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | UnionApply unionApply = unionApplyMapper.selectById(closeDTO.getId()); |
| | | if(Objects.isNull(unionApply)||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | if(!unionApply.getCompanyId().equals(user.getCompanyId())){ |
| | | if(Constants.equalsInteger(user.getType(),Constants.TWO)&&!unionApply.getCompanyId().equals(user.getCompanyId())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起非您的合并单,您无法进行操作!"); |
| | | } |
| | | if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){ |
| | |
| | | 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())){ |
| | | //TODO 删除企业投保单的 签署数据 |
| | | |
| | | multifileMapper.delete(new QueryWrapper<Multifile>() |
| | | .lambda() |
| | | .apply(" multifile.id in ( select i.id from insurance_apply i where i.UNION_APPLY_ID = "+unionApply.getId()+" ) ") |
| | | .eq(Multifile::getObjType,Constants.MultiFile.BD_APPLY_PDF.getKey())); |
| | | } |
| | | insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda() |
| | | .set(InsuranceApply::getUnionApplyId,null) |
| | | .set(InsuranceApply::getCheckDate,new Date()) |
| | | .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) |
| | | || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()), |
| | | InsuranceApply::getUnionApplyTbdStatus,Constants.ZERO) |
| | | .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey()) |
| | | || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()), |
| | | InsuranceApply::getApplyTbdNo,null) |
| | | .set(InsuranceApply::getCheckUserId,user.getId()) |
| | | .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey()) |
| | | .eq(InsuranceApply::getUnionApplyId,unionApply.getId())); |
| | | .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_RETURN.getKey()) |
| | | .eq(InsuranceApply::getUnionApplyId,unionApply.getId()) |
| | | ); |
| | | |
| | | applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda() |
| | | .set(ApplyDetail::getUnionApplyId,null) |
| | |
| | | ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info |
| | | ,unionApply.getId(),applyLogType.getKey(),null, null); |
| | | applyLogMapper.insert(log); |
| | | |
| | | applyLogMapper.insert(log); |
| | | } |
| | | |
| | | |
| | |
| | | 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(),"非商户用户,无法进行该操作!"); |
| | | } |
| | | // 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); |
| | | } |
| | | 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<Multifile> 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<InsuranceApply>().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.COMPANY_TBD_SIGNED.getKey()); |
| | | multifile.setType(Constants.TWO); |
| | | multifileMapper.insert(multifile); |
| | | |
| | | insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda() |
| | | .set(InsuranceApply::getUnionApplyTbdStatus,Constants.ONE) |
| | | .set(InsuranceApply::getEditDate,new Date()) |
| | | .set(InsuranceApply::getEditor,user.getId()) |
| | | .eq(InsuranceApply::getId,multifile.getObjId()) |
| | | ); |
| | | |
| | | unionApply.setStatus(Constants.formatIntegerNum(unionApply.getStatus())); |
| | | if(Constants.equalsInteger(user.getType(),Constants.TWO)){ |
| | | 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(),"对不起,合并单业务已流转,您无法进行该操作!"); |
| | | } |
| | | |
| | | unionApply.setCheckDate(new Date()); |
| | | unionApply.setCheckUserId(user.getId()); |
| | |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setObjId(uploadMultifileDTO.getBusinessId()); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setObjType(Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey()); |
| | | multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()); |
| | | multifile.setType(Constants.TWO); |
| | | multifile.setFileurl(uploadMultifileDTO.getFileurl()); |
| | | multifile.setName(uploadMultifileDTO.getName()); |
| | | 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); |
| | | |
| | | } |
| | | |
| | | |
| | |
| | | public String getSignLink(SmsCheckDTO smsCheckDTO) { |
| | | if(Objects.isNull(smsCheckDTO) |
| | | || Objects.isNull(smsCheckDTO.getBusinessId()) |
| | | || StringUtils.isBlank(smsCheckDTO.getCode()) |
| | | // || StringUtils.isBlank(smsCheckDTO.getCode()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | //验证 验证码 |
| | | if(!debugModel){ |
| | | smsEmailService.validateCode(smsCheckDTO.getCode()); |
| | | } |
| | | // 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); |
| | |
| | | } |
| | | 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())){ |
| | |
| | | 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); |
| | | String applyNo = signService.applySignDoByParam(company.getName(),url,company.getName(),company.getCode(),company.getEmail(),null,company.getSignId(),notifyUrl,new Float(0.7)); |
| | | |
| | | if(StringUtils.isBlank(applyNo) ){ |
| | | throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起,获取在线签章地址失败,请稍后重试!"); |
| | |
| | | || 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); |
| | | } |
| | | 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())){ |
| | | if(!unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,该合并单状态已流转,当前不支持该操作~"); |
| | | } |
| | | Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId()); |
| | | if(Objects.isNull(solutions)){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息"); |
| | | } |
| | | //根据方案查询对应的结束日期 |
| | | CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO(); |
| | | countCyclePriceDTO.setSolutions(solutions); |
| | | countCyclePriceDTO.setStartDate(unionApplyBXDDTO.getStartTime()); |
| | | Date endTime = Constants.getCountCyclePriceVO(countCyclePriceDTO).getEndDate(); |
| | | if(unionApplyBXDDTO.getEndTime().getTime()>endTime.getTime()) { |
| | | 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) |
| | | .in(ApplyDetail::getUnionApplyId,unionApply.getId())); |
| | | List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,new MPJLambdaWrapper<ApplyDetail>() |
| | | .selectAll(ApplyDetail.class) |
| | | .selectAs(DispatchUnit::getName,ApplyDetail::getDuName) |
| | | .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode) |
| | | .selectAs(Solutions::getId,ApplyDetail::getSolutionId) |
| | | .selectAs(Solutions::getName,ApplyDetail::getSolutionName) |
| | | .selectAs(Worktype::getName,ApplyDetail::getWorkTypeName) |
| | | .selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo) |
| | | .selectAs(Member::getName,ApplyDetail::getMemberName) |
| | | .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId) |
| | | .leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId) |
| | | .leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId) |
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId) |
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
| | | .in(ApplyDetail::getUnionApplyId,unionApply.getId())); |
| | | unionApplyBXDDTO.setEndTime(DateUtil.getMontageDate(unionApplyBXDDTO.getEndTime(),2)); |
| | | //总天数 |
| | | Integer maxDays = DateUtil.calculateBetween(unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime(),0); |
| | | //实际已经产生费用的天数 |
| | |
| | | //当前日期在结束日期之后 |
| | | 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 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())){ |
| | | BigDecimal price = Constants.formatBigdecimal(applyDetails.get(Constants.ZERO).getPrice()); |
| | | Optional<UnionApplyBXDDetailDTO> unionApplyBXDDDetailTO= unionApplyBXDDetailDTOList.stream().filter( |
| | | m->m.getApplyId().equals(insuranceApply.getId())).findFirst(); |
| | | BigDecimal serverCost = BigDecimal.ZERO; |
| | | if(unionApplyBXDDDetailTO.isPresent()){ |
| | | UnionApplyBXDDetailDTO unionApplyBXDDetailDTO = unionApplyBXDDDetailTO.get(); |
| | | serverCost = unionApplyBXDDetailDTO.getServerMoney(); |
| | | //上传保单信息 |
| | | Multifile multifile = new Multifile(); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | | multifile.setCreator(user.getId()); |
| | |
| | | multifile.setObjId(insuranceApply.getId()); |
| | | multifile.setObjType(Constants.MultiFile.BD_DONE_PDF.getKey()); |
| | | multifile.setType(Constants.TWO); |
| | | multifile.setFileurl(unionApplyBXDDDetailTO.getFileUrl()); |
| | | multifile.setName(unionApplyBXDDDetailTO.getFileName()); |
| | | multifile.setFileurl(unionApplyBXDDTO.getFileUrl()); |
| | | multifile.setName(unionApplyBXDDTO.getFileName()); |
| | | multifileMapper.insert(multifile); |
| | | insuranceApply.setUnionApplyTbdStatus(Constants.ONE); |
| | | }else{ |
| | | insuranceApply.setUnionApplyTbdStatus(Constants.ZERO); |
| | | |
| | | |
| | | // 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 = solutions.getPrice().add(serverCost); |
| | | }else if(useDays>0){ |
| | | currentFee = Constants.produceFee(solutions,solutions.getPrice().add(serverCost) |
| | | ,unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime(), |
| | | unionApplyBXDDTO.getStartTime() |
| | | ); |
| | | } |
| | | //生成投保记录 |
| | | 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())) { |
| | | |
| | | //查询人员信息是否存在相同的方案下是否存在 冲突数据 |
| | | InsuranceApplyServiceImpl.checkStaticMemberSolution(solutions.getBaseId(), |
| | | applyDetail.getMemberId(),applyDetail.getIdcardNo(),applyDetail.getMemberName(),unionApply.getStartTime(),unionApply.getEndTime(), |
| | | applyDetailJoinMapper); |
| | | |
| | | applyDetail.setPrice(price); |
| | | applyDetail.setFee(price.multiply(new BigDecimal(maxDays)).add(serverCost)); |
| | | applyDetail.setStartTime(unionApplyBXDDTO.getStartTime()); |
| | | applyDetail.setEndTime(unionApplyBXDDTO.getEndTime()); |
| | | |
| | | |
| | | MemberInsurance memberInsurance = new MemberInsurance(applyDetail,user.getId()); |
| | | memberInsurance.setBdCode(unionApplyBXDDTO.getCode()); |
| | | memberInsurance.setRelationType(Constants.ZERO); |
| | | memberInsuranceList.add(memberInsurance); |
| | | //更新员工投保时间 |
| | | memberMapper.update(null,new UpdateWrapper<Member>() |
| | | .lambda() |
| | | .set(Member::getStartTime,memberInsurance.getStartTime()) |
| | | .set(Member::getEndTime,memberInsurance.getEndTime()) |
| | | .set(Member::getDuId,memberInsurance.getDuId()) |
| | | .set(Member::getWorktypeId,memberInsurance.getWorktypeId()) |
| | | .eq(Member::getId, memberInsurance.getMemberId()) |
| | | ); |
| | | |
| | | } |
| | | memberInsuranceJoinMapper.insert(memberInsuranceList); |
| | | } |
| | | BigDecimal detailFee = Constants.reduceFee(solutions,solutions.getPrice().add(serverCost),insuranceApply.getStartTime(),insuranceApply.getFinalEndTime(), |
| | | unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime()); |
| | | |
| | | BigDecimal applyFee = detailFee.multiply(new BigDecimal(applyDetails.size())); |
| | | |
| | | Date finalEndTime = endTime; |
| | | |
| | | //更新投保申请单 |
| | | 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::getFee,applyFee) |
| | | .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::getServerCost,serverCost) |
| | | .set(InsuranceApply::getCode,unionApplyBXDDTO.getCode()) |
| | | .set(InsuranceApply::getFinalEndTime,finalEndTime) |
| | | .eq(InsuranceApply::getId,insuranceApply.getId())); |
| | | //更新投保单明细金额 |
| | | applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda() |
| | | .set(ApplyDetail::getPrice,price) |
| | | .set(ApplyDetail::getFee, price.multiply(new BigDecimal(maxDays))) |
| | | .set(ApplyDetail::getFee, detailFee) |
| | | .set(ApplyDetail::getCurrentFee,currentFee) |
| | | .set(ApplyDetail::getEditDate,new Date()) |
| | | .set(ApplyDetail::getEditor,user.getId()) |
| | |
| | | .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))); |
| | | sumFee = sumFee.add(applyFee); |
| | | 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()) |
| | | ); |
| | | //合并单 总保单 |
| | | //合并单 文件 |
| | | if(StringUtils.isNotBlank(unionApplyBXDDTO.getFileUrl())){ |
| | | Multifile multifile = new Multifile(); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | |
| | | multifileMapper.insert(multifile); |
| | | } |
| | | |
| | | |
| | | Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_TBD; |
| | | ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null |
| | | 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<UnionApply> unionApplyList = unionApplyJoinMapper.selectJoinList(UnionApply.class,new MPJLambdaWrapper<UnionApply>() |
| | | .selectAll(UnionApply.class) |
| | | .eq(UnionApply::getIsdeleted,Constants.ZERO) |
| | | .eq(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH.getKey()) |
| | | .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); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |