| | |
| | | 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.utils.DateUtil; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.business.*; |
| | | import com.doumee.dao.business.dto.SaveUnionApplyDTO; |
| | | import com.doumee.dao.business.dto.SaveUnionChangeDTO; |
| | | import com.doumee.dao.business.dto.UnionChangeBXDDTO; |
| | | 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.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 org.apache.commons.lang3.StringUtils; |
| | | import org.apache.shiro.SecurityUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | |
| | | @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 unionChangeMapper.selectById(id); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public UnionChange getDetail(Integer id){ |
| | | UnionChange unionChange = unionChangeJoinMapper.selectJoinOne(UnionChange.class, |
| | | new MPJLambdaWrapper<UnionChange>() |
| | | .selectAll(UnionChange.class) |
| | | .selectAs(UnionApply::getCode,UnionChange::getApplyCode) |
| | | .selectAs(Solutions::getName,UnionChange::getSolutionsName) |
| | | .selectAs(UnionApply::getStartTime,UnionChange::getStartTime) |
| | | .selectAs(UnionApply::getEndTime,UnionChange::getEndTime) |
| | | .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<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>() |
| | | .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); |
| | | } |
| | | 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 |
| | | public UnionChange findOne(UnionChange unionChange) { |
| | | QueryWrapper<UnionChange> wrapper = new QueryWrapper<>(unionChange); |
| | |
| | | @Override |
| | | public PageData<UnionChange> findPage(PageWrap<UnionChange> pageWrap) { |
| | | IPage<UnionChange> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<UnionChange> queryWrapper = new QueryWrapper<>(); |
| | | MPJLambdaWrapper<UnionChange> 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.lambda().eq(UnionChange::getId, pageWrap.getModel().getId()); |
| | | queryWrapper.eq(UnionChange::getId, pageWrap.getModel().getId()); |
| | | } |
| | | if (pageWrap.getModel().getCreator() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getCreator, pageWrap.getModel().getCreator()); |
| | | queryWrapper.eq(UnionChange::getCreator, pageWrap.getModel().getCreator()); |
| | | } |
| | | |
| | | 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.lambda().ge(UnionChange::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); |
| | | queryWrapper.lambda().le(UnionChange::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); |
| | | 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.lambda().eq(UnionChange::getEditor, pageWrap.getModel().getEditor()); |
| | | queryWrapper.eq(UnionChange::getEditor, pageWrap.getModel().getEditor()); |
| | | } |
| | | if (pageWrap.getModel().getEditDate() != null) { |
| | | queryWrapper.lambda().ge(UnionChange::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); |
| | | queryWrapper.lambda().le(UnionChange::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); |
| | | 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.lambda().eq(UnionChange::getIsdeleted, pageWrap.getModel().getIsdeleted()); |
| | | queryWrapper.eq(UnionChange::getIsdeleted, pageWrap.getModel().getIsdeleted()); |
| | | } |
| | | if (pageWrap.getModel().getRemark() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getRemark, pageWrap.getModel().getRemark()); |
| | | queryWrapper.eq(UnionChange::getRemark, pageWrap.getModel().getRemark()); |
| | | } |
| | | if (pageWrap.getModel().getSortnum() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getSortnum, pageWrap.getModel().getSortnum()); |
| | | queryWrapper.eq(UnionChange::getSortnum, pageWrap.getModel().getSortnum()); |
| | | } |
| | | if (pageWrap.getModel().getShopId() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getShopId, pageWrap.getModel().getShopId()); |
| | | queryWrapper.eq(UnionChange::getShopId, pageWrap.getModel().getShopId()); |
| | | } |
| | | if (pageWrap.getModel().getCode() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getCode, pageWrap.getModel().getCode()); |
| | | queryWrapper.eq(UnionChange::getCode, pageWrap.getModel().getCode()); |
| | | } |
| | | if (pageWrap.getModel().getApplyStartTime() != null) { |
| | | queryWrapper.lambda().ge(UnionChange::getApplyStartTime, Utils.Date.getStart(pageWrap.getModel().getApplyStartTime())); |
| | | queryWrapper.lambda().le(UnionChange::getApplyStartTime, Utils.Date.getEnd(pageWrap.getModel().getApplyStartTime())); |
| | | 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.lambda().eq(UnionChange::getStatus, pageWrap.getModel().getStatus()); |
| | | queryWrapper.eq(UnionChange::getStatus, pageWrap.getModel().getStatus()); |
| | | } |
| | | if (pageWrap.getModel().getValidTime() != null) { |
| | | queryWrapper.lambda().ge(UnionChange::getValidTime, Utils.Date.getStart(pageWrap.getModel().getValidTime())); |
| | | queryWrapper.lambda().le(UnionChange::getValidTime, Utils.Date.getEnd(pageWrap.getModel().getValidTime())); |
| | | 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.lambda().eq(UnionChange::getValidCode, pageWrap.getModel().getValidCode()); |
| | | queryWrapper.eq(UnionChange::getValidCode, pageWrap.getModel().getValidCode()); |
| | | } |
| | | if (pageWrap.getModel().getType() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getType, pageWrap.getModel().getType()); |
| | | queryWrapper.eq(UnionChange::getType, pageWrap.getModel().getType()); |
| | | } |
| | | if (pageWrap.getModel().getSignApplyNo() != null) { |
| | | queryWrapper.lambda().eq(UnionChange::getSignApplyNo, pageWrap.getModel().getSignApplyNo()); |
| | | queryWrapper.eq(UnionChange::getSignApplyNo, pageWrap.getModel().getSignApplyNo()); |
| | | } |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
| | |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | } |
| | | } |
| | | return PageData.from(unionChangeMapper.selectPage(page, queryWrapper)); |
| | | PageData<UnionChange> pageData = PageData.from(unionChangeJoinMapper.selectJoinPage(page,UnionChange.class, queryWrapper)); |
| | | return pageData; |
| | | } |
| | | |
| | | @Override |
| | |
| | | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = {BusinessException.class,Exception.class}) |
| | | public Integer merge(SaveUnionChangeDTO saveUnionChangeDTO){ |
| | | LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
| | | if(user.getType().equals(Constants.TWO)){ |
| | | if(!user.getType().equals(Constants.TWO)){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户用户,无法进行该操作"); |
| | | } |
| | | if(Objects.isNull(saveUnionChangeDTO) |
| | |
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) |
| | | .eq(ApplyChange::getIsdeleted, Constants.ZERO) |
| | | .eq(InsuranceApply::getUnionApplyId,saveUnionChangeDTO.getUnionApplyId()) |
| | | .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.COMPANY_SIGN.getKey()) |
| | | .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) |
| | | .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()) |
| | | .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_DONE.getKey()) |
| | | .eq(ApplyChange::getType,saveUnionChangeDTO.getBusinessType()) |
| | | .in(ApplyChange::getId,saveUnionChangeDTO.getApplyIds()) |
| | | .isNull(ApplyChange::getUnionChangeId) |
| | |
| | | unionChange.setCreateDate(new Date()); |
| | | unionChange.setCreator(user.getId()); |
| | | 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); |
| | |
| | | .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<ApplyChagneDetail>().lambda() |
| | | .set(ApplyChagneDetail::getUnionChangeId,unionChange.getId()) |
| | | .in(ApplyChagneDetail::getApplyId,saveUnionChangeDTO.getApplyIds())); |
| | | .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 id |
| | | * @param closeDTO |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
| | | public void cancelMerge(Integer id){ |
| | | 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(); |
| | | 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(id); |
| | | 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(),"对不起非您的合并单,您无法进行操作!"); |
| | | } |
| | |
| | | .set(ApplyChange::getUnionChangeId,null) |
| | | .set(ApplyChange::getCheckDate,new Date()) |
| | | .set(ApplyChange::getCheckUserId,user.getId()) |
| | | .set(ApplyChange::getStatus,Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()) |
| | | .in(ApplyChange::getUnionChangeId,unionChange.getId()) |
| | | ); |
| | | |
| | | 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_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<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) |
| | | ); |
| | | |
| | |
| | | |
| | | /** |
| | | * 合并单(加减保/换厂) - 投保申请签署 |
| | | * @param id |
| | | * @param smsCheckDTO |
| | | * @return |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
| | | public String getSignLink(Integer id) { |
| | | if(id == null ){ |
| | | 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(id); |
| | | 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(unionChangeBXDDTO) |
| | | || Objects.isNull(unionChangeBXDDTO.getId()) |
| | | || Objects.isNull(unionChangeBXDDTO.getApplyDate()) |
| | | || StringUtils.isBlank(unionChangeBXDDTO.getFileName()) |
| | | || StringUtils.isBlank(unionChangeBXDDTO.getFileUrl()) |
| | | || StringUtils.isBlank(unionChangeBXDDTO.getName()) |
| | | || StringUtils.isBlank(unionChangeBXDDTO.getFileurl()) |
| | | || StringUtils.isBlank(unionChangeBXDDTO.getCode()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | |
| | | 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(),"对不起,合并单状态已流转"); |
| | | } |
| | | |
| | |
| | | .selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode) |
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) |
| | | .eq(ApplyChange::getUnionChangeId,unionChange.getId())); |
| | | |
| | | //存储合并单保险单 |
| | | Multifile multifile = new Multifile(); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | | multifile.setCreator(user.getId()); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setObjId(unionChangeBXDDTO.getId()); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setObjType(Constants.MultiFile.WTB_CA_DONE_PDF.getKey()); |
| | | multifile.setType(Constants.TWO); |
| | | multifile.setFileurl(unionChangeBXDDTO.getFileurl()); |
| | | multifile.setName(unionChangeBXDDTO.getName()); |
| | | multifileMapper.insert(multifile); |
| | | |
| | | if(CollectionUtils.isNotEmpty(unionChangeBXDDTO.getApplyChangeBXDList())){ |
| | | //查询是否不存在当前合并单的数据 |
| | | if(applyChangeJoinMapper.selectCount(new QueryWrapper<ApplyChange>() |
| | | .lambda().ne(ApplyChange::getUnionChangeId,unionChangeBXDDTO.getId()) |
| | | .in(ApplyChange::getId, |
| | | unionChangeBXDDTO.getApplyChangeBXDList().stream().map(m->m.getObjId()).collect(Collectors.toList()) |
| | | ) |
| | | )>Constants.ZERO){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"批单明细记录存在非本合并单数据"); |
| | | }; |
| | | for (Multifile m:unionChangeBXDDTO.getApplyChangeBXDList()) { |
| | | if(Objects.isNull(m.getObjId()) |
| | | ||StringUtils.isBlank(m.getFileurl()) |
| | | ||StringUtils.isBlank(m.getName()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"批单文件信息缺失"); |
| | | } |
| | | 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.setValidTime(unionChangeBXDDTO.getApplyDate()); |
| | | applyChange.setEditDate(new Date()); |
| | | applyChange.setEditor(user.getId()); |
| | | List<ApplyChagneDetail> allList = applyChagneDetailJoinMapper.selectList(new QueryWrapper<ApplyChagneDetail>().lambda().eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId())); |
| | | applyChange.setStatus(Constants.ApplyChangeStatus.APPROVE.getKey()); |
| | | 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()); |
| | | applyChangeJoinMapper.updateById(applyChange); |
| | | } |
| | | } |
| | | unionChangeMapper.update(null,new UpdateWrapper<UnionChange>().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::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); |
| | | |
| | | 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()); |