| | |
| | | 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; |
| | |
| | | ); |
| | | |
| | | if(!Objects.isNull(unionChange)){ |
| | | //查询加减保明细数据 |
| | | List<ApplyChagneDetail> applyChangeList = applyChagneDetailJoinMapper |
| | | .selectList(new QueryWrapper<ApplyChagneDetail>() |
| | | .lambda() |
| | | .eq(ApplyChagneDetail::getIsdeleted,Constants.ZERO) |
| | | .ne(ApplyChagneDetail::getType,Constants.TWO) |
| | | .eq(ApplyChagneDetail::getUnionChangeId,unionChange.getId())); |
| | | BigDecimal fee = BigDecimal.ZERO; |
| | | for (ApplyChagneDetail applyChagneDetail:applyChangeList) { |
| | | Integer maxDays = DateUtil.calculateBetween(unionChange.getApplyStartTime(),applyChagneDetail.getEndTime(),0); |
| | | if(applyChagneDetail.getType().equals(Constants.ZERO)){ |
| | | fee = fee.add(new BigDecimal(maxDays).multiply(applyChagneDetail.getPrice())); |
| | | }else{ |
| | | fee = fee.subtract(new BigDecimal(maxDays).multiply(applyChagneDetail.getPrice())); |
| | | } |
| | | } |
| | | unionChange.setFee(fee); |
| | | //查询操作记录 |
| | | List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class, |
| | | new MPJLambdaWrapper<ApplyLog>() |
| | |
| | | .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)) |
| | | .in(ApplyLog::getObjType,Constants.ApplyLogType.getTypeList(Constants.FOUR)) |
| | | .eq(ApplyLog::getApplyId,unionChange.getId()) |
| | | .orderByAsc(ApplyLog::getCreateDate) |
| | | ); |
| | | unionChange.setApplyLogList(applyLogList); |
| | | } |
| | | initFiles(unionChange); |
| | | return unionChange; |
| | | } |
| | | |
| | | private void initFiles(UnionChange unionChange) { |
| | | List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().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(); |
| | | 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())){ |
| | | //签署后申请单 |
| | | unionChange.setPidanFile(f); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | |
| | | unionChange.setShopId(user.getCompanyId()); |
| | | unionChange.setIsdeleted(Constants.ZERO); |
| | | unionChange.setUnionApplyId(saveUnionChangeDTO.getUnionApplyId()); |
| | | unionChange.setApplyStartTime(saveUnionChangeDTO.getApplyDate()); |
| | | unionChange.setApplyStartTime(DateUtil.getMontageDate(saveUnionChangeDTO.getApplyDate(),1)); |
| | | unionChange.setType(saveUnionChangeDTO.getBusinessType()); |
| | | unionChange.setStatus(Constants.UnionChangeStatus.MERGE.getKey()); |
| | | unionChangeMapper.insert(unionChange); |
| | |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
| | | if(user.getType().equals(Constants.TWO)){ |
| | | user.setType(Constants.formatIntegerNum(user.getType())); |
| | | if(!user.getType().equals(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(!unionChange.getShopId().equals(user.getCompanyId())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起非您的合并单,您无法进行操作!"); |
| | | } |
| | |
| | | |
| | | applyChagneDetailJoinMapper.update(null,new UpdateWrapper<ApplyChagneDetail>().lambda() |
| | | .set(ApplyChagneDetail::getUnionChangeId,null) |
| | | .in(ApplyChagneDetail::getApplyId,unionChange.getId())); |
| | | .eq(ApplyChagneDetail::getUnionChangeId,unionChange.getId())); |
| | | |
| | | unionChangeMapper.update(null,new UpdateWrapper<UnionChange>().lambda() |
| | | .set(UnionChange::getStatus,Constants.UnionApplyStatus.CLOSE.getKey()) |
| | | .set(UnionChange::getStatus,Constants.UnionChangeStatus.CLOSE.getKey()) |
| | | .eq(UnionChange::getId,unionChange.getId()) |
| | | ); |
| | | |
| | | Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_UPLOAD; |
| | | 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 |
| | |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public UnionChange unionChangeDetail(Integer unionChangeId){ |
| | | |
| | | if(Objects.isNull(unionChangeId)){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | UnionChange unionChange = unionChangeJoinMapper.selectJoinOne(UnionChange.class, |
| | | new MPJLambdaWrapper<UnionChange>() |
| | | .selectAll(UnionChange.class) |
| | |
| | | ); |
| | | //企业名称 |
| | | List<ApplyChange> applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class,new MPJLambdaWrapper<ApplyChange>() |
| | | .selectAll(ApplyChange.class) |
| | | .selectAs(Company::getName,ApplyChange::getCompanyName) |
| | | .leftJoin(Company.class,Company::getId,ApplyChange::getCompanyId) |
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) |
| | | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) |
| | | .eq(ApplyChange::getUnionChangeId,unionChangeId) |
| | | ); |
| | | |
| | |
| | | } |
| | | 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); |
| | | } |
| | |
| | | if(unionChange.getStatus().equals(Constants.UnionChangeStatus.CLOSE.getKey())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,合并单业务已关闭"); |
| | | } |
| | | if(unionChange.getStatus().equals(Constants.UnionChangeStatus.MERGE.getKey())){ |
| | | if(!unionChange.getStatus().equals(Constants.UnionChangeStatus.MERGE.getKey())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,合并单状态已流转"); |
| | | } |
| | | Company company = companyMapper.selectById(user.getCompanyId()); |
| | |
| | | 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(!unionChange.getShopId().equals(user.getCompanyId())){ |
| | | 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())){ |
| | | if(!unionChange.getStatus().equals(Constants.UnionChangeStatus.UPLOAD_INSURANCE_POLICY.getKey())){ |
| | | throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起,合并单状态已流转"); |
| | | } |
| | | |
| | |
| | | ||StringUtils.isBlank(m.getFileurl()) |
| | | ||StringUtils.isBlank(m.getName()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"加减保/换厂业务批单文件信息缺失"); |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"批单文件信息缺失"); |
| | | } |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | | multifile.setCreator(user.getId()); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setObjType(Constants.MultiFile.CA_PD_PDF.getKey()); |
| | | multifile.setType(Constants.TWO); |
| | | multifileMapper.insert(multifile); |
| | | m.setId(null); |
| | | m.setIsdeleted(Constants.ZERO); |
| | | m.setCreator(user.getId()); |
| | | m.setCreateDate(new Date()); |
| | | m.setObjType(Constants.MultiFile.CA_PD_PDF.getKey()); |
| | | m.setType(Constants.TWO); |
| | | multifileMapper.insert(m); |
| | | } |
| | | } |
| | | |
| | | |
| | | if(CollectionUtils.isNotEmpty(applyChangeList)){ |
| | | for (ApplyChange applyChange:applyChangeList) { |
| | | applyChange.setApplyStartTime(unionChangeBXDDTO.getApplyDate()); |
| | |
| | | applyChange.setEditDate(new Date()); |
| | | applyChange.setEditor(user.getId()); |
| | | applyChange.setStatus(Constants.ApplyChangeStatus.APPROVE.getKey()); |
| | | List<ApplyChagneDetail> allList = applyChagneDetailJoinMapper.selectList(new QueryWrapper<ApplyChagneDetail>().lambda().eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId())); |
| | | List<ApplyChagneDetail> allList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, |
| | | new MPJLambdaWrapper<ApplyChagneDetail>().selectAll(ApplyChagneDetail.class) |
| | | .selectAs(Member::getName,ApplyChagneDetail::getMemberName ) |
| | | .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo ) |
| | | .leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId) |
| | | .eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId())); |
| | | this.dealApplyChangeDetail(applyChange,allList); |
| | | applyChange.setCode(unionChangeBXDDTO.getCode()); |
| | | applyChange.setCheckUserId(user.getId()); |
| | |
| | | .set(UnionChange::getStatus,Constants.UnionChangeStatus.FINISH.getKey()) |
| | | .set(UnionChange::getEditDate,new Date()) |
| | | .set(UnionChange::getEditor,user.getId()) |
| | | .set(UnionChange::getValidTime,unionChangeBXDDTO.getApplyDate()) |
| | | .set(UnionChange::getApplyStartTime,unionChangeBXDDTO.getApplyDate()) |
| | | .set(UnionChange::getCode,unionChangeBXDDTO.getCode()) |
| | | .eq(UnionChange::getId,unionChangeBXDDTO.getId()) |
| | | ); |
| | | |
| | |
| | | ApplyLog log = new ApplyLog(unionChange,applyLogType.getName(), null |
| | | ,unionChange.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionChange)); |
| | | applyLogMapper.insert(log); |
| | | |
| | | if(true){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | |
| | | BigDecimal totalFee = BigDecimal.ZERO; |
| | | BigDecimal currentFee = BigDecimal.ZERO; |
| | | //查询最后记录 获取对应单价 |
| | | ApplyDetail applyDetail = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda().eq(ApplyDetail::getApplyId,applyChange.getApplyId()).last(" limit 1 ")); |
| | | if(Objects.isNull(applyDetail)){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到保单明细数据"); |
| | | } |
| | | //获取单价 |
| | | BigDecimal price = applyDetail.getPrice(); |
| | | for (ApplyChagneDetail detail:applyChagneDetailList) { |
| | | Member member = memberMapper.selectById(detail.getMemberId()); |
| | | if(Objects.isNull(member)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据"); |
| | | } |
| | | if (Constants.equalsInteger(detail.getType(), Constants.ZERO)) { |
| | | this.addChangeDetailData(applyChange,detail,price,currentFee,totalFee); |
| | | this.addChangeDetailData(applyChange,detail,detail.getPrice(),currentFee,totalFee); |
| | | }else if(Constants.equalsInteger(detail.getType(),Constants.ONE)){ |
| | | this.reduceChangeDetailData(applyChange,detail,applyDetail,price,currentFee,totalFee); |
| | | this.reduceChangeDetailData(applyChange,detail,currentFee,totalFee); |
| | | }else{ |
| | | this.otherChangeDetailData(applyChange,detail,applyDetail,price); |
| | | this.otherChangeDetailData(applyChange,detail); |
| | | } |
| | | } |
| | | |
| | |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下,加保人员【" + detail.getMemberName() + "】存在日期冲突的数据"); |
| | | } |
| | | //总天数 |
| | | Integer countDays = DateUtil.daysBetweenDates(DateUtil.getMontageDate(detail.getEndTime(), 2), applyChange.getApplyStartTime()); |
| | | Integer countDays = DateUtil.calculateBetween(applyChange.getApplyStartTime(),DateUtil.getMontageDate(detail.getEndTime(), 2),0); |
| | | |
| | | //加保 |
| | | ApplyDetail add = new ApplyDetail(); |
| | | if(new Date().compareTo(DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2))>=0){ |
| | | Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2), applyChange.getApplyStartTime()) + 1; |
| | | Integer days = DateUtil.calculateBetween(applyChange.getApplyStartTime(),DateUtil.getMontageDate(new Date(), 2),0); |
| | | //如果已已产生费用,计算已已产生费用 |
| | | add.setCurrentFee(new BigDecimal(days).multiply(price)); |
| | | }else{ |
| | |
| | | add.setSex(Constants.getSexByIdCard(detail.getIdcardNo())); |
| | | add.setMemberName(detail.getMemberName()); |
| | | add.setDuId(detail.getDuId()); |
| | | add.setStartTime(applyChange.getApplyStartTime()); |
| | | add.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1)); |
| | | add.setEndTime(DateUtil.getMontageDate(detail.getEndTime(), 2)); |
| | | add.setFee(new BigDecimal(countDays).multiply(price)); |
| | |
| | | * 减保数据处理 |
| | | * @param applyChange |
| | | * @param detail |
| | | * @param applyDetail |
| | | * @param price |
| | | * @param currentFee |
| | | * @param totalFee |
| | | */ |
| | | public void reduceChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail,ApplyDetail applyDetail |
| | | ,BigDecimal price,BigDecimal currentFee,BigDecimal totalFee){ |
| | | public void reduceChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail,BigDecimal currentFee,BigDecimal totalFee){ |
| | | //查询员工是在主单下 是否存在生效中的数据 |
| | | ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda() |
| | | .eq(ApplyDetail::getApplyId, applyChange.getApplyId()) |
| | |
| | | BigDecimal pullFee = BigDecimal.ZERO; |
| | | //减保减少的金额 |
| | | BigDecimal reduceFee = BigDecimal.ZERO; |
| | | if (DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2),applyChange.getApplyStartTime()) > 0) { |
| | | if (DateUtil.calculateBetween(applyChange.getApplyStartTime(),DateUtil.getMontageDate(new Date(), 2),0) > 0) { |
| | | //计算多扣金额 |
| | | Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2), applyChange.getApplyStartTime()) + 1; |
| | | pullFee = new BigDecimal(days).multiply(price).multiply(new BigDecimal(-1)); |
| | | |
| | | Integer days = DateUtil.calculateBetween(applyChange.getApplyStartTime(),DateUtil.getMontageDate(new Date(), 2),0); |
| | | pullFee = new BigDecimal(days).multiply(detail.getPrice()).multiply(new BigDecimal(-1)); |
| | | } |
| | | //计算投保明细应减少的天数 |
| | | Integer reduceDays = DateUtil.daysBetweenDates(DateUtil.getMontageDate(applyDetail.getEndTime(), 2), applyChange.getApplyStartTime()) + 1; |
| | | Integer reduceDays = DateUtil.calculateBetween(applyChange.getApplyStartTime(),DateUtil.getMontageDate(oldModel.getEndTime(), 2),0); |
| | | if(reduceDays>0){ |
| | | reduceFee = new BigDecimal(reduceDays).multiply(price).multiply(new BigDecimal(-1)); |
| | | reduceFee = new BigDecimal(reduceDays).multiply(detail.getPrice()).multiply(new BigDecimal(-1)); |
| | | } |
| | | applyDetailJoinMapper.update(null, new UpdateWrapper<ApplyDetail>().lambda() |
| | | .setSql(" fee = ifnull(fee,0)+" + reduceFee) |
| | |
| | | ); |
| | | } |
| | | |
| | | public void otherChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail,ApplyDetail applyDetail,BigDecimal price){ |
| | | public void otherChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail){ |
| | | |
| | | //实际批单生效日期 |
| | | Date applyStartTime = DateUtil.getMontageDate(applyChange.getApplyStartTime(),1); |
| | |
| | | //当前日期大于批单日期 需要回滚数据实际数据 |
| | | Boolean flag = DateUtil.getMontageDate(new Date(),2).compareTo(DateUtil.getMontageDate(applyStartTime,2))>0; |
| | | //换厂后历史记录的费用 fee |
| | | Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(applyStartTime,3),DateUtil.getMontageDate(oldModel.getStartTime(),1))+1; |
| | | BigDecimal oldFee = new BigDecimal(days).multiply(price); |
| | | 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(); |
| | | |
| | |
| | | add.setFromId(detail.getId()); |
| | | applyDetailJoinMapper.insert(add); |
| | | |
| | | MemberInsurance memberInsurance = new MemberInsurance(applyDetail,applyChange.getId()); |
| | | MemberInsurance memberInsurance = new MemberInsurance(oldModel,applyChange.getId()); |
| | | memberInsurance.setSolutionId(detail.getSolutionId()); |
| | | memberInsurance.setWorktypeName(detail.getWorkTypeName()); |
| | | memberInsurance.setDuName(detail.getDuName()); |