From be0301e67768fb183df7e29f411a7e54dbf15c40 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 08 五月 2024 10:37:58 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/1.0.1' into 1.0.1 --- server/service/src/main/java/com/doumee/service/business/impl/UnionChangeServiceImpl.java | 601 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 487 insertions(+), 114 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/UnionChangeServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/UnionChangeServiceImpl.java index ade3466..1efb65a 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/UnionChangeServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/UnionChangeServiceImpl.java @@ -1,5 +1,7 @@ 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; @@ -11,15 +13,13 @@ 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.join.ApplyChagneDetailJoinMapper; -import com.doumee.dao.business.join.ApplyChangeJoinMapper; -import com.doumee.dao.business.join.ApplyDetailJoinMapper; -import com.doumee.dao.business.join.MemberInsuranceJoinMapper; +import com.doumee.dao.business.dto.*; +import com.doumee.dao.business.join.*; import com.doumee.dao.business.model.*; import com.doumee.dao.business.vo.CountCyclePriceVO; +import com.doumee.dao.system.model.SystemUser; +import com.doumee.dao.system.vo.BigDecimalVO; +import com.doumee.service.business.SmsEmailService; import com.doumee.service.business.UnionChangeService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; @@ -31,10 +31,13 @@ import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; +import java.math.RoundingMode; +import java.util.Arrays; import java.util.Date; import java.util.List; import java.util.Objects; @@ -52,7 +55,13 @@ private UnionChangeMapper unionChangeMapper; @Autowired + private UnionChangeJoinMapper unionChangeJoinMapper; + + @Autowired private ApplyChangeJoinMapper applyChangeJoinMapper; + + @Autowired + private UnionApplyMapper unionApplyMapper; @Autowired private ApplyChagneDetailJoinMapper applyChagneDetailJoinMapper; @@ -81,6 +90,18 @@ @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); @@ -126,6 +147,93 @@ 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.ONE)){ + maxDays = DateUtil.daysBetweenDates(applyChagneDetail.getEndTime(),DateUtil.getMontageDate(unionChange.getApplyStartTime(),3)); + } + 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())).add(applyChagneDetail.getFee()); + } + } + unionChange.setFee(fee.setScale(2, RoundingMode.HALF_UP)); + //鏌ヨ鎿嶄綔璁板綍 + 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); @@ -141,59 +249,80 @@ @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)) { @@ -202,7 +331,8 @@ 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 @@ -214,27 +344,45 @@ @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) || Objects.isNull(saveUnionChangeDTO.getApplyIds()) - || Objects.isNull(saveUnionChangeDTO.getApplyDate()) + || Objects.isNull(saveUnionChangeDTO.getAddValidDate()) + || Objects.isNull(saveUnionChangeDTO.getDelValidDate()) || Objects.isNull(saveUnionChangeDTO.getUnionApplyId()) || Objects.isNull(saveUnionChangeDTO.getBusinessType()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } + + UnionApply unionApply = unionApplyMapper.selectById(saveUnionChangeDTO.getUnionApplyId()); + if(Objects.isNull(unionApply)){ + throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏈煡璇㈠埌鍚堝苟淇濆崟鏁版嵁"); + } + //鍒ゆ柇鎵瑰崟鏃ユ湡 鍚堝苟鍗曠殑鎵瑰崟鐢熸晥鏈熷湪涓� 淇濆崟璧锋湡鐨勬鏃� 鍒颁繚鍗曟鏈� + //鑾峰彇寮�濮嬫棩鏈熸鏃� + if(saveUnionChangeDTO.getAddValidDate().getTime()<DateUtil.afterDateByType(unionApply.getStartTime(),0,1).getTime() + || saveUnionChangeDTO.getAddValidDate().getTime()> unionApply.getEndTime().getTime()){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍚堝苟鍗曠殑鎵瑰崟鍔犱繚鐢熸晥鏈熼敊璇�"); + } + if(saveUnionChangeDTO.getDelValidDate().getTime()<DateUtil.afterDateByType(unionApply.getStartTime(),0,1).getTime() + || saveUnionChangeDTO.getDelValidDate().getTime()> unionApply.getEndTime().getTime()){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍚堝苟鍗曠殑鎵瑰崟鍔犱繚鐢熸晥鏈熼敊璇�"); + } + List<ApplyChange> applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class, new MPJLambdaWrapper<ApplyChange>() .selectAll(ApplyChange.class) .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) .eq(ApplyChange::getIsdeleted, Constants.ZERO) .eq(InsuranceApply::getUnionApplyId,saveUnionChangeDTO.getUnionApplyId()) - .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.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) @@ -247,9 +395,13 @@ UnionChange unionChange = new UnionChange(); unionChange.setCreateDate(new Date()); unionChange.setCreator(user.getId()); + unionChange.setEditDate(new Date()); + unionChange.setEditor(user.getId()); unionChange.setShopId(user.getCompanyId()); + unionChange.setIsdeleted(Constants.ZERO); unionChange.setUnionApplyId(saveUnionChangeDTO.getUnionApplyId()); - unionChange.setApplyStartTime(saveUnionChangeDTO.getApplyDate()); + unionChange.setApplyStartTime(DateUtil.getMontageDate(saveUnionChangeDTO.getAddValidDate(),1)); + unionChange.setDelValidTime(DateUtil.getMontageDate(saveUnionChangeDTO.getDelValidDate(),1)); unionChange.setType(saveUnionChangeDTO.getBusinessType()); unionChange.setStatus(Constants.UnionChangeStatus.MERGE.getKey()); unionChangeMapper.insert(unionChange); @@ -258,12 +410,19 @@ .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(); } @@ -274,19 +433,27 @@ /** * 鍙栨秷淇濆崟鍚堝苟 - * @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(),"瀵逛笉璧烽潪鎮ㄧ殑鍚堝苟鍗曪紝鎮ㄦ棤娉曡繘琛屾搷浣滐紒"); } @@ -301,33 +468,106 @@ .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) + .selectAs(Company::getName,UnionChange::getShopName) + .selectAs(Solutions::getName,UnionChange::getSolutionsName) + .selectAs(UnionApply::getCode,UnionChange::getApplyCode) + .selectAs(UnionApply::getStartTime,UnionChange::getStartTime) + .selectAs(UnionApply::getEndTime,UnionChange::getEndTime) + .leftJoin(UnionApply.class,UnionApply::getId,UnionChange::getUnionApplyId) + .leftJoin(Company.class,Company::getId,UnionChange::getShopId) + .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) + .eq(UnionChange::getId,unionChangeId) + .last(" limit 1 ") + ); + //浼佷笟鍚嶇О + List<ApplyChange> applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class,new MPJLambdaWrapper<ApplyChange>() + .selectAll(ApplyChange.class) + .selectAs(Company::getName,ApplyChange::getCompanyName) + .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) + .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) + .eq(ApplyChange::getUnionChangeId,unionChangeId) + ); + + String companyNames = String.join(",",applyChangeList.stream().map(m->m.getCompanyName()).collect(Collectors.toList())); + + List<ApplyChagneDetail> applyChagneDetailList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,new MPJLambdaWrapper<ApplyChagneDetail>() + .selectAll(ApplyChagneDetail.class) + .selectAs(Member::getName,ApplyChagneDetail::getMemberName) + .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo) + .selectAs(Member::getSex,ApplyChagneDetail::getSex) + .selectAs(Company::getName,ApplyChagneDetail::getCompanyName) + .select("t2.name",ApplyChagneDetail::getWorkTypeName) + .select("t3.name",ApplyChagneDetail::getDuName) + .select("t4.name",ApplyChagneDetail::getOldWorkTypeName) + .select("t5.name",ApplyChagneDetail::getOldDuName) + .leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId) + .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId) + .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId) + .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId) + .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId) + .leftJoin(Company.class,Company::getId,Member::getCompanyId) + .eq(ApplyChagneDetail::getUnionChangeId,unionChangeId) + ); + + unionChange.setCompanyNames(companyNames); + unionChange.setApplyChagneDetailList(applyChagneDetailList); + return unionChange; + } + /** * 鍚堝苟鍗曪紙鍔犲噺淇�/鎹㈠巶锛� - 鎶曚繚鐢宠绛剧讲 - * @param 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 = unionChangeMapper.selectById(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); } @@ -340,7 +580,7 @@ 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()); @@ -350,11 +590,10 @@ String fileUrl = null; if(Constants.equalsObject(unionChange.getType(), Constants.ONE)){ -// fileUrl = ExcelExporter.build(ApplyChange.class).exportChangeUnitExcelToPdf(model,"鎹㈠巶鐢宠琛�","琚繚闄╀汉"); + fileUrl = ExcelExporter.build(UnionChange.class).exportUnionChangeOtherUnitExcelToPdf(unionChange,"鎹㈠巶鐢宠琛�"); }else{ -// fileUrl = ExcelExporter.build(ApplyChange.class).exportJiajianBaoExcelToPdf(model,"鍔犲噺淇濈敵璇疯〃","琚繚闄╀汉"); + fileUrl = ExcelExporter.build(UnionChange.class).exportUnionChangeExcelToPdf(unionChange,"鍔犲噺淇濈敵璇疯〃"); } - String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode(); notifyUrl = notifyUrl.replace("${type}","0").replace("${id}",unionChange.getId().toString()); String applyNo = signService.applySignLocalFile(company.getName(),company.getName(),fileUrl,company.getCode(),company.getEmail(),"鍚堝苟鍗曪紙鍔犲噺淇�/鎹㈠巶锛夌敵璇风缃�",company.getSignId(),notifyUrl); @@ -383,8 +622,8 @@ 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); @@ -394,6 +633,12 @@ if(Objects.isNull(unionChange)||!Constants.equalsInteger(unionChange.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } + if(!Constants.equalsInteger(unionChange.getType(),Constants.ONE)&& + unionChangeBXDDTO.getDelValidTime() == null ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + 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(),"瀵逛笉璧烽潪鎮ㄧ殑鍚堝苟鍗曪紝鎮ㄦ棤娉曡繘琛屾搷浣滐紒"); } @@ -403,9 +648,24 @@ 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(),"瀵逛笉璧凤紝鍚堝苟鍗曠姸鎬佸凡娴佽浆"); } + UnionApply unionApply = unionApplyMapper.selectById(unionChange.getUnionApplyId()); + if(Objects.isNull(unionApply)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鍚堝苟淇濆崟淇℃伅"); + } + //鍒ゆ柇鎵瑰崟鏃ユ湡 鍚堝苟鍗曠殑鎵瑰崟鐢熸晥鏈熷湪涓� 淇濆崟璧锋湡鐨勬鏃� 鍒颁繚鍗曟鏈� + //鑾峰彇寮�濮嬫棩鏈熸鏃� + if(unionChangeBXDDTO.getApplyDate().getTime()<DateUtil.afterDateByType(unionApply.getStartTime(),0,1).getTime() + || unionChangeBXDDTO.getApplyDate().getTime()> unionApply.getEndTime().getTime()){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍚堝苟鍗曠殑鎵瑰崟鍔犱繚鐢熸晥鏈熼敊璇�"); + } + if(unionChangeBXDDTO.getDelValidTime().getTime()<DateUtil.afterDateByType(unionApply.getStartTime(),0,1).getTime() + || unionChangeBXDDTO.getDelValidTime().getTime()> unionApply.getEndTime().getTime()){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍚堝苟鍗曠殑鎵瑰崟鍑忎繚鐢熸晥鏈熼敊璇�"); + } + List<ApplyChange> applyChangeList = applyChangeJoinMapper.selectJoinList(ApplyChange.class, new MPJLambdaWrapper<ApplyChange>() @@ -414,22 +674,116 @@ .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(StringUtils.isBlank(m.getName()) + || StringUtils.isBlank(m.getFileurl()) ){ + continue; + } + 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 oldModel = applyChange; applyChange.setApplyStartTime(unionChangeBXDDTO.getApplyDate()); - applyChange.setValidTime(unionChangeBXDDTO.getApplyDate()); + applyChange.setDelValidTime(unionChangeBXDDTO.getDelValidTime()); +// 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()); + applyChange.setCode(unionChangeBXDDTO.getCode()); + applyChange.setValidCode(unionChangeBXDDTO.getCode()); + applyChange.setCheckUserId(user.getId()); + List<ApplyChagneDetail> allList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, + new MPJLambdaWrapper<ApplyChagneDetail>() + .selectAll(ApplyChagneDetail.class) + .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo) + .selectAs(Solutions::getTimeUnit, ApplyChagneDetail::getSolutionTimeUnit) + .selectAs(Solutions::getPrice, ApplyChagneDetail::getSolutionPrice) + .selectAs(Worktype::getName, ApplyChagneDetail::getWorkTypeName) + .selectAs(DispatchUnit::getName, ApplyChagneDetail::getDuName) + .selectAs(Member::getName, ApplyChagneDetail::getMemberName) + .selectAs(Solutions::getName,ApplyChagneDetail::getSolutionsName) + .selectAs(InsuranceApply::getCode,ApplyChagneDetail::getApplyCode) + .leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId) + .leftJoin(Member.class, Member::getId, ApplyChagneDetail::getMemberId) + .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyChange::getApplyId) + .leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId) + .leftJoin(Worktype.class, Worktype::getId, ApplyChagneDetail::getWorktypeId) + .leftJoin(DispatchUnit.class, DispatchUnit::getId, ApplyChagneDetail::getDuId) + .eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId())); this.dealApplyChangeDetail(applyChange,allList); + applyChangeJoinMapper.updateById(applyChange); + + //瀛樺偍鎵瑰崟瀹屾垚淇℃伅 + Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_PLATFORM_APPROVE; + String info = ""; + if(applyChange.getValidTime()!=null && applyChange.getValidTime().getTime()/1000!= applyChange.getApplyStartTime().getTime()/1000){ + info =applyLogType.getInfo(); + info = info.replace("${param1}",DateUtil.getPlusTime2(applyChange.getValidTime())); + info = info.replace("${param2}",DateUtil.getPlusTime2(applyChange.getApplyStartTime())); + } + ApplyLog log = new ApplyLog(applyChange,applyLogType.getName(), info,applyChange.getId(),applyLogType.getKey(),JSONObject.toJSONString(oldModel), JSONObject.toJSONString(applyChange)); + applyLogMapper.insert(log); + } } unionChangeMapper.update(null,new UpdateWrapper<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::getDelValidTime,unionChangeBXDDTO.getDelValidTime()) + .set(UnionChange::getApplyStartTime,unionChangeBXDDTO.getApplyDate()) + .set(UnionChange::getCode,unionChangeBXDDTO.getCode()) .eq(UnionChange::getId,unionChangeBXDDTO.getId()) ); + + + Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_UPLOAD_INSURANCE; + ApplyLog log = new ApplyLog(unionChange,applyLogType.getName(), null + ,unionChange.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionChange)); + applyLogMapper.insert(log); + +// if(true){ +// throw new BusinessException(ResponseStatus.NOT_ALLOWED); +// } } @@ -437,44 +791,33 @@ public void dealApplyChangeDetail(ApplyChange applyChange,List<ApplyChagneDetail> applyChagneDetailList){ - 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(); + BigDecimalVO bigDecimalVO = new BigDecimalVO(); + bigDecimalVO.setTotalFee(BigDecimal.ZERO); + bigDecimalVO.setCurrentFee(BigDecimal.ZERO); 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,bigDecimalVO); }else if(Constants.equalsInteger(detail.getType(),Constants.ONE)){ - this.reduceChangeDetailData(applyChange,detail,applyDetail,price,currentFee,totalFee); + this.reduceChangeDetailData(applyChange,detail,bigDecimalVO); }else{ - this.otherChangeDetailData(applyChange,detail,applyDetail,price); + this.otherChangeDetailData(applyChange,detail); } } - if (totalFee.compareTo(new BigDecimal(0)) != 0) { + if (bigDecimalVO.getTotalFee().compareTo(new BigDecimal(0)) != 0) { //濡傛灉淇濆崟閲戦鍙戠敓缂栫爜锛屾洿鏂版�讳繚鍗曢噾棰� insuranceApplyMapper.update(null, new UpdateWrapper<InsuranceApply>().lambda() - .setSql(" fee = ifnull(fee,0)+" + totalFee) - .setSql(" current_fee = ifnull(current_fee,0)+" + currentFee) + .setSql(" fee = ifnull(fee,0)+" + bigDecimalVO.getTotalFee()) + .setSql(" current_fee = ifnull(current_fee,0)+" + bigDecimalVO.getCurrentFee()) .set(InsuranceApply::getEditor, applyChange.getEditor()) .set(InsuranceApply::getEditDate, applyChange.getEditDate()) .eq(InsuranceApply::getId, applyChange.getApplyId()) ); - applyChangeJoinMapper.update(null, new UpdateWrapper<ApplyChange>().lambda() - .set(ApplyChange::getFee,totalFee) - .set(ApplyChange::getEditor, applyChange.getEditor()) - .set(ApplyChange::getEditDate, applyChange.getEditDate()) - .eq(ApplyChange::getId, applyChange.getApplyId()) - ); + applyChange.setFee(bigDecimalVO.getTotalFee()); } } @@ -484,12 +827,9 @@ * 鍔犱繚鏁版嵁澶勭悊 * @param applyChange * @param detail - * @param price - * @param currentFee - * @param totalFee */ - public void addChangeDetailData(ApplyChange applyChange,ApplyChagneDetail detail - ,BigDecimal price,BigDecimal currentFee,BigDecimal totalFee){ + public void addChangeDetailData(ApplyChange applyChange, ApplyChagneDetail detail + , BigDecimalVO bigDecimalVO){ //鏌ヨ鍔犱繚浜哄憳鏄惁瀛樺湪 鍐茬獊鐨� 淇濆崟鏄庣粏鏁版嵁 if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>() .lambda() @@ -501,16 +841,22 @@ 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)); + add.setCurrentFee(new BigDecimal(days).multiply(detail.getPrice())); }else{ add.setCurrentFee(BigDecimal.ZERO); } + + add.setPrice(detail.getPrice()); add.setApplyId(applyChange.getApplyId()); add.setValidCode(applyChange.getValidCode()); add.setFee(detail.getFee()); @@ -525,10 +871,9 @@ 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)); + add.setFee(new BigDecimal(countDays).multiply(detail.getPrice())); applyDetailJoinMapper.insert(add); detail.setFee(add.getFee()); @@ -537,28 +882,33 @@ .set(ApplyChagneDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 1)) .eq(ApplyChagneDetail::getId,detail.getId()) ); - - totalFee = totalFee.add(add.getFee()); - currentFee = currentFee.add(add.getCurrentFee()); + bigDecimalVO.setTotalFee(bigDecimalVO.getTotalFee().add(add.getFee())); + bigDecimalVO.setCurrentFee(bigDecimalVO.getCurrentFee().add(add.getCurrentFee())); MemberInsurance memberInsurance = new MemberInsurance(detail, applyChange, applyChange.getEditor(), add.getId(),applyChange.getSolutionsId()); memberInsurance.setStartTime(add.getStartTime()); memberInsurance.setEndTime(add.getEndTime()); memberInsurance.setRelationType(Constants.ONE); + memberInsurance.setPdCode(applyChange.getValidCode()); memberInsuranceJoinMapper.insert(memberInsurance); + + memberMapper.update(null,new UpdateWrapper<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()) + ); + } /** * 鍑忎繚鏁版嵁澶勭悊 * @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,BigDecimalVO bigDecimalVO){ //鏌ヨ鍛樺伐鏄湪涓诲崟涓� 鏄惁瀛樺湪鐢熸晥涓殑鏁版嵁 ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda() .eq(ApplyDetail::getApplyId, applyChange.getApplyId()) @@ -573,49 +923,61 @@ BigDecimal pullFee = BigDecimal.ZERO; //鍑忎繚鍑忓皯鐨勯噾棰� BigDecimal reduceFee = BigDecimal.ZERO; - if (DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2),applyChange.getApplyStartTime()) > 0) { + Date reduceDate = DateUtil.getMontageDate(applyChange.getApplyStartTime(),3); + if (reduceDate.getTime() < DateUtil.getMontageDate(new Date(), 2).getTime()) { //璁$畻澶氭墸閲戦 - 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(reduceDate,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.daysBetweenDates(oldModel.getEndTime(),reduceDate); 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) .setSql(" current_fee = ifnull(current_fee,0)+" + pullFee) - .set(oldModel.getStartTime().compareTo(applyChange.getApplyStartTime())!=0,ApplyDetail::getEndTime, DateUtil.getMontageDate(applyChange.getApplyStartTime(), 3)) - .set(oldModel.getStartTime().compareTo(applyChange.getApplyStartTime())==0,ApplyDetail::getEndTime, DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) + .set(oldModel.getStartTime().compareTo(reduceDate)!=0,ApplyDetail::getEndTime, reduceDate) + .set(oldModel.getStartTime().compareTo(reduceDate)==0,ApplyDetail::getEndTime, DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) .set(ApplyDetail::getEditor, applyChange.getEditor()) .set(ApplyDetail::getEditDate, applyChange.getEditDate()) .eq(ApplyDetail::getId, oldModel.getId()) ); - totalFee = totalFee.add(reduceFee); - currentFee = currentFee.add(pullFee); + + bigDecimalVO.setTotalFee(bigDecimalVO.getTotalFee().add(reduceFee)); + bigDecimalVO.setCurrentFee(bigDecimalVO.getCurrentFee().add(pullFee)); //淇敼 鍛樺伐鎶曚繚鏄庣粏璁板綍 鍘嗗彶鏁版嵁 memberInsuranceJoinMapper.update(null, new UpdateWrapper<MemberInsurance>().lambda() .setSql(" fee = ifnull(fee,0)+" + reduceFee) - .set(oldModel.getStartTime().compareTo(applyChange.getApplyStartTime())!=0,MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 3)) - .set(oldModel.getStartTime().compareTo(applyChange.getApplyStartTime())==0,MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) + .set(oldModel.getStartTime().compareTo(reduceDate)!=0,MemberInsurance::getEndTime,reduceDate) + .set(oldModel.getStartTime().compareTo(reduceDate)==0,MemberInsurance::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) .eq(MemberInsurance::getRelationId, oldModel.getId()) + ); + + + memberMapper.update(null,new UpdateWrapper<Member>() + .lambda() + .set(Member::getStartTime,oldModel.getStartTime()) + .set(oldModel.getStartTime().compareTo(reduceDate)!=0,Member::getEndTime,reduceDate) + .set(oldModel.getStartTime().compareTo(reduceDate)==0,Member::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 2)) + .set(Member::getDuId,oldModel.getDuId()) + .set(Member::getWorktypeId,oldModel.getWorktypeId()) + .eq(Member::getId, oldModel.getMemberId()) ); //淇敼涓氬姟鏄庣粏琛屾暟鎹疄闄呮壒鍗曟棩鏈� applyChagneDetailJoinMapper.update(null,new UpdateWrapper<ApplyChagneDetail>().lambda() - .setSql(" fee = ifnull(fee,0)+" + reduceFee) - .set(ApplyChagneDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(), 3)) +// .setSql(" fee = ifnull(fee,0)+" + reduceFee) + .set(ApplyChagneDetail::getFee,reduceFee) + .set(ApplyChagneDetail::getEndTime,reduceDate) .eq(ApplyChagneDetail::getId,detail.getId()) ); } - 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); - //鏌ヨ鍑忎繚浜哄憳鏄惁瀛樺湪 鍐茬獊鐨� 淇濆崟鏄庣粏鏁版嵁 if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>() .lambda() @@ -643,8 +1005,8 @@ //褰撳墠鏃ユ湡澶т簬鎵瑰崟鏃ユ湡 闇�瑕佸洖婊氭暟鎹疄闄呮暟鎹� 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(); @@ -659,7 +1021,7 @@ //淇敼 鍛樺伐鎶曚繚鏄庣粏璁板綍 鍘嗗彶鏁版嵁 memberInsuranceJoinMapper.update(null,new UpdateWrapper<MemberInsurance>().lambda() - .set(MemberInsurance::getEndTime,applyStartTime) + .set(MemberInsurance::getEndTime,DateUtil.getMontageDate(applyStartTime,3)) .set(MemberInsurance::getFee,oldFee) .eq(MemberInsurance::getRelationId,oldModel.getId()) ); @@ -689,7 +1051,7 @@ add.setFromId(detail.getId()); applyDetailJoinMapper.insert(add); - MemberInsurance memberInsurance = new MemberInsurance(applyDetail,applyChange.getId()); + MemberInsurance memberInsurance = new MemberInsurance(add,applyChange.getId()); memberInsurance.setSolutionId(detail.getSolutionId()); memberInsurance.setWorktypeName(detail.getWorkTypeName()); memberInsurance.setDuName(detail.getDuName()); @@ -719,6 +1081,17 @@ } + Member member = memberMapper.selectById(detail.getMemberId()); + if(Objects.isNull(member)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鍛樺伐鏁版嵁"); + } + member.setApplyId(applyChange.getApplyId()); + member.setDuId(detail.getDuId()); + member.setWorktypeId(detail.getWorktypeId()); + member.setStartTime(detail.getStartTime()); + member.setEndTime(detail.getEndTime()); + memberMapper.updateById(member); + -- Gitblit v1.9.3