|  |  | 
 |  |  | import com.doumee.core.utils.Utils; | 
 |  |  | import com.doumee.core.utils.aliyun.ALiYunUtil; | 
 |  |  | import com.doumee.dao.business.*; | 
 |  |  | import com.doumee.dao.business.dto.CountCyclePriceDTO; | 
 |  |  | import com.doumee.dao.business.dto.InsuranceApplyOptDTO; | 
 |  |  | import com.doumee.dao.business.dto.InsuranceApplyQueryDTO; | 
 |  |  | import com.doumee.dao.business.join.ApplyDetailJoinMapper; | 
 |  |  | import com.doumee.dao.business.join.ApplyLogJoinMapper; | 
 |  |  | import com.doumee.dao.business.join.InsuranceApplyJoinMapper; | 
 |  |  | 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.InsuranceApplyService; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.metadata.IPage; | 
 |  |  | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; | 
 |  |  | import com.doumee.service.business.SmsEmailService; | 
 |  |  | import com.doumee.service.business.third.EmailService; | 
 |  |  | import com.doumee.service.business.third.SignService; | 
 |  |  | import com.github.xiaoymin.knife4j.core.util.CollectionUtils; | 
 |  |  | import com.github.yulichang.wrapper.MPJLambdaWrapper; | 
 |  |  | 
 |  |  | import org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.apache.shiro.SecurityUtils; | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | import org.springframework.beans.factory.annotation.Value; | 
 |  |  | import org.springframework.stereotype.Service; | 
 |  |  | import org.springframework.transaction.annotation.Transactional; | 
 |  |  |  | 
 |  |  | import java.io.File; | 
 |  |  | import java.math.BigDecimal; | 
 |  |  | import java.util.*; | 
 |  |  | import java.util.stream.Collectors; | 
 |  |  | 
 |  |  |  */ | 
 |  |  | @Service | 
 |  |  | public class InsuranceApplyServiceImpl implements InsuranceApplyService { | 
 |  |  |     @Value("${debug_model}") | 
 |  |  |     private boolean debugModel; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private InsuranceApplyMapper insuranceApplyMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private ApplyChangeMapper applyChangeMapper; | 
 |  |  |     private SmsEmailService smsEmailService; | 
 |  |  |     @Autowired | 
 |  |  |     private ApplyChangeJoinMapper applyChangeMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private SystemDictDataBiz systemDictDataBiz; | 
 |  |  |     @Autowired | 
 |  |  |     private InsuranceApplyJoinMapper insuranceApplyJoinMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private CompanyMapper companyMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private MemberInsuranceJoinMapper memberInsuranceJoinMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private ApplyDetailMapper applyDetailMapper; | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private DuSolutionMapper duSolutionMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private DuSolutionJoinMapper duSolutionJoinMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private DuWorktypeMapper duWorktypeMapper; | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |         InsuranceApply update = new InsuranceApply(); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  |         update.setEditor(user.getId()); | 
 |  |  |         update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_RETURN.getKey()); | 
 |  |  |         update.setStatus(Constants.InsuranceApplyStatus.FAIL_RETURN.getKey()); | 
 |  |  |         update.setCheckDate(update.getEditDate()); | 
 |  |  |         update.setCheckInfo(insuranceApply.getCheckInfo()); | 
 |  |  |         update.setCheckUserId(user.getId()); | 
 |  |  | 
 |  |  |         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.SIGNATURE.getKey())){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,该申请状态已流转,当前不支持该操作~"); | 
 |  |  |         } | 
 |  |  |         if(model.getApplyEndTime()== null || insuranceApply.getStartTime().getTime()>insuranceApply.getApplyEndTime().getTime() ){ | 
 |  |  |         if(model.getApplyEndTime()== null || model.getStartTime().getTime()>model.getApplyEndTime().getTime() ){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,该申请生效周期时间不符合要求,请确认后修改重试~"); | 
 |  |  |         } | 
 |  |  |         //计算实际截止时间 | 
 |  |  |         Date actEndTime = new Date(insuranceApply.getApplyEndTime().getTime() + (insuranceApply.getStartTime().getTime() - model.getApplyStartTime().getTime())); | 
 |  |  |         Date actEndTime = new Date(model.getApplyEndTime().getTime() + (insuranceApply.getStartTime().getTime() - model.getApplyStartTime().getTime())); | 
 |  |  |         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); | 
 |  |  |         InsuranceApply update = new InsuranceApply(); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  | 
 |  |  |  | 
 |  |  |         insuranceApply.getBaoxiandanFile().setIsdeleted(Constants.ZERO); | 
 |  |  |         insuranceApply.getBaoxiandanFile().setCreator(user.getId()); | 
 |  |  |         insuranceApply.getToubaodanFile().setObjId(update.getId()); | 
 |  |  |         insuranceApply.getBaoxiandanFile().setObjId(update.getId()); | 
 |  |  |         insuranceApply.getBaoxiandanFile().setCreateDate(update.getEditDate()); | 
 |  |  |         insuranceApply.getBaoxiandanFile().setObjType(Constants.MultiFile.BD_DONE_PDF.getKey()); | 
 |  |  |         insuranceApply.getBaoxiandanFile().setType(Constants.TWO); | 
 |  |  | 
 |  |  |         } | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(), info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         applyLogMapper.insert(log); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         //存储员工信息投保记录 | 
 |  |  |         //查询单据明细记录 | 
 |  |  |         MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>(); | 
 |  |  |         queryWrapper.selectAll(ApplyDetail.class); | 
 |  |  |         queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName); | 
 |  |  |         queryWrapper.selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode); | 
 |  |  |         queryWrapper.selectAs(Solutions::getId,ApplyDetail::getSolutionId); | 
 |  |  |         queryWrapper.selectAs(Solutions::getName,ApplyDetail::getSolutionName); | 
 |  |  |         queryWrapper.selectAs(Worktype::getName,ApplyDetail::getWorkTypeName); | 
 |  |  |         queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); | 
 |  |  |         queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); | 
 |  |  |         queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId); | 
 |  |  |         queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId); | 
 |  |  |         queryWrapper.leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId); | 
 |  |  |         queryWrapper.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId); | 
 |  |  |         queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId); | 
 |  |  |         queryWrapper.eq(ApplyDetail::getApplyId,insuranceApply.getId()); | 
 |  |  |         List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,queryWrapper); | 
 |  |  |  | 
 |  |  |         if(CollectionUtils.isNotEmpty(applyDetailList)){ | 
 |  |  |             List<MemberInsurance> memberInsuranceList = new ArrayList<>(); | 
 |  |  |             for (ApplyDetail applyDetail:applyDetailList) { | 
 |  |  |                 MemberInsurance memberInsurance = new MemberInsurance(applyDetail,user.getId()); | 
 |  |  |                 memberInsuranceList.add(memberInsurance); | 
 |  |  |             } | 
 |  |  |             memberInsuranceJoinMapper.insertBatchSomeColumn(memberInsuranceList); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         return  1; | 
 |  |  |  | 
 |  |  |     } | 
 |  |  | 
 |  |  |         param.getBaoxiandanFile().setObjType(Constants.MultiFile.BD_DONE_PDF.getKey()); | 
 |  |  |         param.getBaoxiandanFile().setType(Constants.TWO); | 
 |  |  |         multifileMapper.insert(param.getBaoxiandanFile()); | 
 |  |  |  | 
 |  |  |         update.setStatus(model.getStatus()); | 
 |  |  |         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.PALTFORM_EDIT_BD; | 
 |  |  |         String info =  applyLogType.getInfo(); | 
 |  |  |         info = info.replace("${param}",param.getCheckInfo()); | 
 |  |  | 
 |  |  |         if(id == null ){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         InsuranceApply model = insuranceApplyMapper.selectById(id); | 
 |  |  |         MPJLambdaWrapper wrapper=  new MPJLambdaWrapper<InsuranceApply>() | 
 |  |  |                 .selectAll(InsuranceApply.class) | 
 |  |  |                 .selectAs(Solutions::getSignKeyword,InsuranceApply::getSignKeyword) | 
 |  |  |                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                 .eq(InsuranceApply::getId,id) | 
 |  |  |                 .last("limit 1"); | 
 |  |  |  | 
 |  |  |         InsuranceApply model = insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class,wrapper); | 
 |  |  |         if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.DATA_EMPTY); | 
 |  |  |         } | 
 |  |  | 
 |  |  |         Constants.ApplyLogType applyLogType = null; | 
 |  |  |         String info = ""; | 
 |  |  |             //如果是驳回,只能可驳回已签章状态下的退回申请状态进行操作 | 
 |  |  |         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_WAIT_SIGNATURE.getKey())){ | 
 |  |  |         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,该申请状态已流转,当前不支持该操作~"); | 
 |  |  |         } | 
 |  |  |         Company company = user.getCompany(); | 
 |  |  |         if(company== null || StringUtils.isBlank( company.getEmail()) || !Constants.equalsInteger(company.getSignStatus(),Constants.ONE)){ | 
 |  |  |         if(debugModel){ | 
 |  |  |             company = companyMapper.selectById(model.getCompanyId()); | 
 |  |  |         } | 
 |  |  |         if(company== null || StringUtils.isBlank( company.getEmail()) || !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,企业尚未具备在线签章条件,请联系平台管理员确认~"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  | 
 |  |  |         String url = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode()+f.getFileurl(); | 
 |  |  |         String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode(); | 
 |  |  |         notifyUrl = notifyUrl.replace("${type}","0").replace("${id}",model.getId().toString()); | 
 |  |  |         String applyNo = signService.applySign(company.getName(),url,company.getName(),company.getCode(),company.getEmail(),null,company.getSignId(),notifyUrl); | 
 |  |  |         String applyNo = signService.applySign(company.getName(),url,company.getName(),company.getCode(),company.getEmail(),model.getSignKeyword(),company.getSignId(),notifyUrl); | 
 |  |  |         if(StringUtils.isBlank(applyNo) ){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起,获取在线签章地址失败,请稍后重试!"); | 
 |  |  |         } | 
 |  |  |         String link = signService.signLink(applyNo,company.getEmail(),company.getCode()); | 
 |  |  |         String link = signService.signLink(applyNo,company.getName(),company.getCode()); | 
 |  |  |         if(StringUtils.isBlank(link) ){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起,获取在线签章地址失败,请稍后重试!"); | 
 |  |  |         } | 
 |  |  | 
 |  |  |                 return tempFileName; | 
 |  |  |             } | 
 |  |  |         }catch (Exception e){ | 
 |  |  |  | 
 |  |  |         } | 
 |  |  |         return  null; | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     public Integer uploadSignedFileDo(InsuranceApply model,String fileurl) { | 
 |  |  |     public Multifile   uploadSignedFileDo(InsuranceApply model,String fileurl,String fullUrl) { | 
 |  |  |         InsuranceApply update = new InsuranceApply(); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  |         update.setEditor(model.getCreator()); | 
 |  |  |         update.setStatus(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()); | 
 |  |  |         update.setStatus(Constants.InsuranceApplyStatus.SIGNATURE.getKey()); | 
 |  |  |         update.setCheckDate(update.getEditDate()); | 
 |  |  |         update.setCheckInfo("企业完成签署"); | 
 |  |  |         update.setCheckUserId(model.getCreator()); | 
 |  |  | 
 |  |  |         f.setObjType(Constants.MultiFile.BD_SIGNED_PDF.getKey()); | 
 |  |  |         f.setType(Constants.TWO); | 
 |  |  |         f.setFileurl(fileurl); | 
 |  |  |         f.setFileurlFull(fullUrl); | 
 |  |  |         f.setInfo("投保单企业签约合同"); | 
 |  |  |         f.setName("投保单签约合同.pdf"); | 
 |  |  |         multifileMapper.insert(f); | 
 |  |  |         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.SIGNATURE; | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(), null,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         applyLogMapper.insert(log); | 
 |  |  |         return  1; | 
 |  |  |  | 
 |  |  |         startSendEmail(f, model.getCompanyName(),model.getSolutionsName(),model.getSolutionEmail()); | 
 |  |  |         return  f; | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |     public Integer uploadChangeSignedFileDo(ApplyChange model,String fileurl) { | 
 |  |  |     public Multifile  uploadChangeSignedFileDo(ApplyChange model,String fileurl,String fullurl) { | 
 |  |  |         ApplyChange update = new ApplyChange(); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  |         update.setEditor(model.getCreator()); | 
 |  |  | 
 |  |  |         f.setObjType(Constants.equalsInteger(Constants.ZERO,model.getType())?Constants.MultiFile.CA_APPLY_JIAJIAN_SIGN.getKey() : Constants.MultiFile.CA_APPLY_CHANGEUNIT_SIGN.getKey()); | 
 |  |  |         f.setType(Constants.TWO); | 
 |  |  |         f.setFileurl(fileurl); | 
 |  |  |         f.setFileurlFull(fullurl); | 
 |  |  |         f.setInfo("企业申请表签署文件"); | 
 |  |  |         f.setName("签章申请表.pdf"); | 
 |  |  |         multifileMapper.insert(f); | 
 |  |  |         Constants.ApplyLogType applyLogType =Constants.equalsInteger(Constants.ZERO,model.getType())? Constants.ApplyLogType.CA_JIAJIAN_APPLY_SIGN: Constants.ApplyLogType.CA_CHANGUNIT_APPLY_SIGN; | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(), null,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         applyLogMapper.insert(log); | 
 |  |  |         return  1; | 
 |  |  |  | 
 |  |  |         startSendEmail(f,model.getCompanyName(),model.getSolutionsName(),model.getSolutionEmail()); | 
 |  |  |         return f; | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     private void startSendEmail(Multifile f, String companyName, String solutionsName, String solutionEmail) { | 
 |  |  |         if(StringUtils.isBlank(solutionEmail) || f==null|| StringUtils.isBlank(f.getFileurl())){ | 
 |  |  |             return; | 
 |  |  |         } | 
 |  |  |         SmsEmail email = new SmsEmail(); | 
 |  |  |         email.setTitle(f.getInfo()); | 
 |  |  |         email.setEmail(solutionEmail); | 
 |  |  |         email.setContent("来自企业【"+companyName+"】关于保险方案【"+solutionsName+"】的"+f.getInfo()); | 
 |  |  |         File file = Constants.getFileByNetFile(f.getFileurlFull(),f.getName()); | 
 |  |  |         if(file!=null && file.isFile()){ | 
 |  |  |             Map<String,Object> files = new HashMap<>(); | 
 |  |  |             files.put("name",f.getName()); | 
 |  |  |             files.put("file",file); | 
 |  |  |             email.setFileList(new ArrayList<>()); | 
 |  |  |             email.getFileList().add(files); | 
 |  |  |             smsEmailService.sendEmail(email); | 
 |  |  |             file.delete();//发送后删除临时文件 | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public   void dealWaitSignedData(){ | 
 |  |  |         List<InsuranceApply> applyList = insuranceApplyMapper.selectList(new QueryWrapper<InsuranceApply>().lambda() | 
 |  |  |                 .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WAIT_SIGNATURE) | 
 |  |  |         List<InsuranceApply> applyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class, | 
 |  |  |                 new MPJLambdaWrapper<InsuranceApply>() | 
 |  |  |                 .selectAll(InsuranceApply.class) | 
 |  |  |                 .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
 |  |  |                 .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail) | 
 |  |  |                 .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
 |  |  |                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                 .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
 |  |  |                 .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey()) | 
 |  |  |                 .isNotNull(InsuranceApply::getSignApplyNo)); | 
 |  |  |         String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+ | 
 |  |  |                 systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode(); | 
 |  |  |         if(applyList !=null && applyList.size()>0 ){ | 
 |  |  |             for(InsuranceApply model : applyList){ | 
 |  |  |                 String status = signService.linkFileStatus(model.getSignApplyNo()); | 
 |  |  |                 if(!StringUtils.equals(status,"3")){ | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 String link = signService.linkFile(model.getSignApplyNo()); | 
 |  |  |                 String fileUrl = uploadSignFile(link); | 
 |  |  |                 if(StringUtils.isBlank(fileUrl)){ | 
 |  |  |                     //如果下载失败,清除合同,下次签章重新生成新合同 | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |                 uploadSignedFileDo(model,fileUrl); | 
 |  |  |                 uploadSignedFileDo(model,fileUrl,path+fileUrl); | 
 |  |  |                 return; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         List<ApplyChange> chagneList = applyChangeMapper.selectList(new QueryWrapper<ApplyChange>().lambda() | 
 |  |  |                 .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.UPLOAD) | 
 |  |  |         List<ApplyChange> chagneList = applyChangeMapper.selectJoinList(ApplyChange.class, | 
 |  |  |                 new MPJLambdaWrapper<ApplyChange>() | 
 |  |  |                 .selectAll(ApplyChange.class) | 
 |  |  |                 .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
 |  |  |                 .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail) | 
 |  |  |                 .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
 |  |  |                 .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) | 
 |  |  |                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                 .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
 |  |  |                 .eq(ApplyChange::getStatus,Constants.ApplyChangeStatus.UPLOAD.getKey()) | 
 |  |  |                 .isNotNull(ApplyChange::getSignApplyNo)); | 
 |  |  |         if(chagneList !=null && chagneList.size()>0 ){ | 
 |  |  |             for(ApplyChange model : chagneList){ | 
 |  |  |                 String status = signService.linkFileStatus(model.getSignApplyNo()); | 
 |  |  |                 if(!StringUtils.equals(status,"3")){ | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 String link = signService.linkFile(model.getSignApplyNo()); | 
 |  |  |                 String fileUrl = uploadSignFile(link); | 
 |  |  |                 if(StringUtils.isBlank(fileUrl)){ | 
 |  |  |                     //如果下载失败,清除合同,下次签章重新生成新合同 | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |                 uploadChangeSignedFileDo(model,fileUrl); | 
 |  |  |                 uploadChangeSignedFileDo(model,fileUrl,path+fileUrl); | 
 |  |  |                 return; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  | 
 |  |  |         } | 
 |  |  |         if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){ | 
 |  |  |             //如果已保全,可下载签约附件 | 
 |  |  |             InsuranceApply model = insuranceApplyMapper.selectOne(new QueryWrapper<InsuranceApply>().lambda().eq(InsuranceApply::getSignApplyNo,data.getApplyNo()).last("limit 1" )); | 
 |  |  |             if(model != null && Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_WAIT_SIGNATURE.getKey())){ | 
 |  |  |             String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+ | 
 |  |  |                     systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode(); | 
 |  |  |             InsuranceApply model = insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class, | 
 |  |  |                     new MPJLambdaWrapper<InsuranceApply>() | 
 |  |  |                             .selectAll(InsuranceApply.class) | 
 |  |  |                             .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
 |  |  |                             .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail) | 
 |  |  |                             .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
 |  |  |                             .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                             .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
 |  |  |                             .eq(InsuranceApply::getSignApplyNo,data.getApplyNo()) | 
 |  |  |                             .last("limit 1" )); | 
 |  |  |             if(model != null && Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){ | 
 |  |  |                 //完成签署已完成操作 | 
 |  |  |                 String link = signService.linkFile(data.getApplyNo()); | 
 |  |  |                 String fileUrl = uploadSignFile(link); | 
 |  |  | 
 |  |  |                     //如果下载失败,清除合同,下次签章重新生成新合同 | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |                 uploadSignedFileDo(model,fileUrl); | 
 |  |  |                 uploadSignedFileDo(model,fileUrl,path+fileUrl); | 
 |  |  |                 return; | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             ApplyChange applyChange = applyChangeMapper.selectOne(new QueryWrapper<ApplyChange>().lambda().eq(ApplyChange::getSignApplyNo,data.getApplyNo()).last("limit 1" )); | 
 |  |  |             ApplyChange applyChange = applyChangeMapper.selectJoinOne(ApplyChange.class, | 
 |  |  |                     new MPJLambdaWrapper<ApplyChange>() | 
 |  |  |                             .selectAll(ApplyChange.class) | 
 |  |  |                             .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
 |  |  |                             .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail) | 
 |  |  |                             .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
 |  |  |                             .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) | 
 |  |  |                             .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                             .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
 |  |  |                             .eq(ApplyChange::getSignApplyNo,data.getApplyNo()).last("limit 1" )); | 
 |  |  |             if(applyChange != null &&Constants.equalsInteger(applyChange.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())){ | 
 |  |  |                 String link = signService.linkFile(data.getApplyNo()); | 
 |  |  |                 String fileUrl = uploadSignFile(link); | 
 |  |  | 
 |  |  |                     //如果下载失败,清除合同,下次签章重新生成新合同 | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |                 uploadChangeSignedFileDo(applyChange,fileUrl); | 
 |  |  |                 uploadChangeSignedFileDo(applyChange,fileUrl,path+fileUrl); | 
 |  |  |             } | 
 |  |  |         }else if(Constants.equalsInteger(data.getSignStatus(), Constants.TWO )){ | 
 |  |  |             //如果已拒签,清除合同,下次签章重新生成新合同 | 
 |  |  | 
 |  |  |  | 
 |  |  |         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.WAIT_SIGNATURE; | 
 |  |  |         String info =applyLogType.getInfo(); | 
 |  |  |         info = info.replace("${param}", update.getCheckInfo()); | 
 |  |  | //        info = info.replace("${param}", update.getCheckInfo()); | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(),StringUtils.isNotBlank(update.getCheckInfo())?info:"",update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         applyLogMapper.insert(log); | 
 |  |  |         return  1; | 
 |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 审核通过 | 
 |  |  |      * 审核通过或者不通过 | 
 |  |  |      * @param insuranceApply | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {Exception.class,BusinessException.class}) | 
 |  |  |     public Integer check(InsuranceApply insuranceApply) { | 
 |  |  |         if(insuranceApply.getId() == null ||StringUtils.isBlank(insuranceApply.getCheckInfo())){ | 
 |  |  |         if(insuranceApply.getId() == null || StringUtils.isBlank(insuranceApply.getCheckInfo())){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId()); | 
 |  |  | 
 |  |  |         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.UPLOAD.getKey())){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,该申请状态已流转,当前不支持该操作~"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         Constants.ApplyLogType applyLogType = null; | 
 |  |  |         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); | 
 |  |  |         InsuranceApply update = new InsuranceApply(); | 
 |  |  |         update.setEditDate(new Date()); | 
 |  |  |         update.setEditor(user.getId()); | 
 |  |  |         update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_CHECK_PASS.getKey()); | 
 |  |  |         update.setCheckDate(update.getEditDate()); | 
 |  |  |         update.setCheckInfo(insuranceApply.getCheckInfo()); | 
 |  |  |         update.setCheckUserId(user.getId()); | 
 |  |  |         update.setId(model.getId()); | 
 |  |  |         if(insuranceApply.getDealBackApply() ==1){ | 
 |  |  |             //如果是不通过 | 
 |  |  |             applyLogType = Constants.ApplyLogType.PLATFORM_RETURN ; | 
 |  |  |             update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_RETURN.getKey()); | 
 |  |  |         }else{ | 
 |  |  |             applyLogType = Constants.ApplyLogType.PLATFORM_CHECK_PASS; | 
 |  |  |             update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_CHECK_PASS.getKey()); | 
 |  |  |         } | 
 |  |  |         insuranceApplyMapper.updateById(update); | 
 |  |  |  | 
 |  |  |         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.PLATFORM_CHECK_PASS; | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(),null,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         String info =applyLogType.getInfo(); | 
 |  |  |         info = info.replace("${param}", update.getCheckInfo()); | 
 |  |  |         ApplyLog log = new ApplyLog(update,applyLogType.getName(),info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update)); | 
 |  |  |         applyLogMapper.insert(log); | 
 |  |  |         return  1; | 
 |  |  |  | 
 |  |  | 
 |  |  |         if(!loginUserInfo.getType().equals(Constants.ONE)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"用户类型错误:非企业用户无法进行该操作"); | 
 |  |  |         } | 
 |  |  |         Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId()); | 
 |  |  |         if(Objects.isNull(solutions)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         List<ApplyDetail> applyDetailList = insuranceApply.getApplyDetailList(); | 
 |  |  |         //判断是否存在重复信息 | 
 |  |  |         List<Integer> memberIdList = applyDetailList.stream().map(i->i.getMemberId()).collect(Collectors.toList()); | 
 |  |  |         Set<Integer> set = new HashSet<>(memberIdList); | 
 |  |  |         if(memberIdList.size() != set.size()){ | 
 |  |  |         List<String> idCardList = applyDetailList.stream().map(i->i.getIdcardNo()).collect(Collectors.toList()); | 
 |  |  |         Set<String> set = new HashSet<>(idCardList); | 
 |  |  |         if(idCardList.size() != set.size()){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"员工信息存在重复信息"); | 
 |  |  |         } | 
 |  |  |         Constants.InsuranceApplyStatus insuranceApplyStatus = Constants.InsuranceApplyStatus.UPLOAD; | 
 |  |  | 
 |  |  |         insuranceApply.setIsdeleted(Constants.ZERO); | 
 |  |  |         insuranceApply.setCompanyId(loginUserInfo.getCompanyId()); | 
 |  |  |         insuranceApply.setCheckInfo(insuranceApplyStatus.getName()); | 
 |  |  |         insuranceApply.setStartTime(insuranceApply.getApplyStartTime()); | 
 |  |  |         insuranceApply.setCheckDate(new Date()); | 
 |  |  |         insuranceApply.setCurrentFee(BigDecimal.ZERO); | 
 |  |  |         insuranceApply.setCheckUserId(loginUserInfo.getId()); | 
 |  |  |         insuranceApply.setStatus(insuranceApplyStatus.getKey()); | 
 |  |  |  | 
 |  |  |         CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO(); | 
 |  |  |         countCyclePriceDTO.setSolutionsId(insuranceApply.getSolutionId()); | 
 |  |  |         countCyclePriceDTO.setStartDate(insuranceApply.getStartTime()); | 
 |  |  |         CountCyclePriceVO  countCyclePriceVO = this.getCountCyclePriceVO(countCyclePriceDTO); | 
 |  |  |         insuranceApply.setApplyEndTime(countCyclePriceVO.getEndDate()); | 
 |  |  |         insuranceApply.setEndTime(countCyclePriceVO.getEndDate()); | 
 |  |  |         insuranceApplyMapper.insert(insuranceApply); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         //处理下级数据 | 
 |  |  |         this.dealApplyDetailData(insuranceApply,applyDetailList,loginUserInfo,countCyclePriceVO); | 
 |  |  |         InsuranceApply updBean = new InsuranceApply(); | 
 |  |  |         updBean.setId(insuranceApply.getId()); | 
 |  |  |         updBean.setFee(applyDetailList.stream().map(ApplyDetail::getFee).reduce(BigDecimal.ZERO,BigDecimal::add)); | 
 |  |  |         insuranceApplyMapper.updateById(updBean); | 
 |  |  |         //存储日志数据 | 
 |  |  |         this.saveApplyLog(insuranceApply,insuranceApplyStatus,null); | 
 |  |  |         return insuranceApply.getId(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {Exception.class,BusinessException.class}) | 
 |  |  |     public Integer updateData(InsuranceApply insuranceApply) { | 
 |  |  |         if (Objects.isNull(insuranceApply) | 
 |  |  |                 || Objects.isNull(insuranceApply.getId()) | 
 |  |  |                 || Objects.isNull(insuranceApply.getSolutionId()) | 
 |  |  |                 || Objects.isNull(insuranceApply.getApplyStartTime()) | 
 |  |  |                 || Objects.isNull(insuranceApply.getApplyEndTime()) | 
 |  |  |                 || !CollectionUtils.isNotEmpty(insuranceApply.getApplyDetailList()) | 
 |  |  |         ) { | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); | 
 |  |  |         if(!loginUserInfo.getType().equals(Constants.ONE)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"用户类型错误:非企业用户无法进行该操作"); | 
 |  |  |         } | 
 |  |  |         InsuranceApply dbInsuranceApply = insuranceApplyMapper.selectById(insuranceApply.getId()); | 
 |  |  |         if(Objects.isNull(dbInsuranceApply)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到修改对象信息"); | 
 |  |  |         } | 
 |  |  |         if(!(dbInsuranceApply.getStatus().equals(Constants.InsuranceApplyStatus.PLATFORM_RETURN.getKey()) | 
 |  |  |                     || dbInsuranceApply.getStatus().equals(Constants.InsuranceApplyStatus.FAIL_RETURN.getKey())) | 
 |  |  |         ){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"状态错误,当前状态无法进行该操作"); | 
 |  |  |         } | 
 |  |  |         List<ApplyDetail> applyDetailList = insuranceApply.getApplyDetailList(); | 
 |  |  |         //判断是否存在重复信息 | 
 |  |  |         List<String> idCardList = applyDetailList.stream().map(i->i.getIdcardNo()).collect(Collectors.toList()); | 
 |  |  |         Set<String> set = new HashSet<>(idCardList); | 
 |  |  |         if(idCardList.size() != set.size()){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"员工信息存在重复信息"); | 
 |  |  |         } | 
 |  |  |         Constants.InsuranceApplyStatus insuranceApplyStatus = Constants.InsuranceApplyStatus.UPLOAD; | 
 |  |  |         insuranceApply.setEditDate(new Date()); | 
 |  |  |         insuranceApply.setEditor(loginUserInfo.getId()); | 
 |  |  |         insuranceApply.setIsdeleted(Constants.ZERO); | 
 |  |  |         insuranceApply.setCompanyId(loginUserInfo.getCompanyId()); | 
 |  |  |         insuranceApply.setCheckInfo(insuranceApplyStatus.getName()); | 
 |  |  |         insuranceApply.setStartTime(insuranceApply.getApplyStartTime()); | 
 |  |  |         insuranceApply.setCheckDate(new Date()); | 
 |  |  |         insuranceApply.setCurrentFee(BigDecimal.ZERO); | 
 |  |  |         insuranceApply.setCheckUserId(loginUserInfo.getId()); | 
 |  |  |         insuranceApply.setStatus(insuranceApplyStatus.getKey()); | 
 |  |  |  | 
 |  |  |         CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO(); | 
 |  |  |         countCyclePriceDTO.setSolutionsId(insuranceApply.getSolutionId()); | 
 |  |  |         countCyclePriceDTO.setStartDate(insuranceApply.getStartTime()); | 
 |  |  |         CountCyclePriceVO  countCyclePriceVO = this.getCountCyclePriceVO(countCyclePriceDTO); | 
 |  |  |         insuranceApply.setApplyEndTime(countCyclePriceVO.getEndDate()); | 
 |  |  |         insuranceApply.setEndTime(countCyclePriceVO.getEndDate()); | 
 |  |  |  | 
 |  |  |         applyDetailMapper.delete(new QueryWrapper<ApplyDetail>().lambda().eq(ApplyDetail::getApplyId,insuranceApply.getId())); | 
 |  |  |         //处理下级数据 | 
 |  |  |         this.dealApplyDetailData(insuranceApply,applyDetailList,loginUserInfo,countCyclePriceVO); | 
 |  |  |         insuranceApply.setFee(applyDetailList.stream().map(ApplyDetail::getFee).reduce(BigDecimal.ZERO,BigDecimal::add)); | 
 |  |  |         insuranceApplyMapper.updateById(insuranceApply); | 
 |  |  |         //存储日志数据 | 
 |  |  |         this.saveApplyLog(insuranceApply,insuranceApplyStatus,null); | 
 |  |  |         return insuranceApply.getId(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     public void dealApplyDetailData(InsuranceApply insuranceApply,List<ApplyDetail> applyDetailList,LoginUserInfo loginUserInfo,CountCyclePriceVO  countCyclePriceVO){ | 
 |  |  |         Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId()); | 
 |  |  |         if(Objects.isNull(solutions)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息"); | 
 |  |  |         } | 
 |  |  |         //查询保险方案下的所有派遣单位 | 
 |  |  |         List<DuSolution> duSolutionList = duSolutionMapper.selectList(new QueryWrapper<DuSolution>().lambda() | 
 |  |  |                         .eq(DuSolution::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .eq(DuSolution::getStatus,Constants.ONE) | 
 |  |  |         List<DuSolution>  duSolutionList = duSolutionJoinMapper.selectJoinList(DuSolution.class,new MPJLambdaWrapper<DuSolution>() | 
 |  |  |                 .selectAll(DuSolution.class) | 
 |  |  |                 .innerJoin(DispatchUnit.class,DispatchUnit::getId,DuSolution::getDispatchUnitId) | 
 |  |  |                 .eq(DispatchUnit::getCompanyId,insuranceApply.getCompanyId()) | 
 |  |  |                 .eq(DispatchUnit::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(DispatchUnit::getUnitStatus,Constants.ONE) | 
 |  |  |                 .eq(DuSolution::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(DuSolution::getStatus,Constants.ONE) | 
 |  |  |                 .eq(DuSolution::getSolutionId,insuranceApply.getSolutionId())); | 
 |  |  |         if(!CollectionUtils.isNotEmpty(duSolutionList)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"数据异常:保险方案下未查询到派遣单位"); | 
 |  |  | 
 |  |  |         if(!CollectionUtils.isNotEmpty(duWorktypeList)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"数据异常:保险方案下未查询到工种信息"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         if(CollectionUtils.isNotEmpty(applyDetailList)){ | 
 |  |  |             for (int i = 0; i < applyDetailList.size(); i++) { | 
 |  |  |                 ApplyDetail applyDetail = applyDetailList.get(i); | 
 |  |  |                 if(Objects.isNull(applyDetail) | 
 |  |  |                         ||Objects.isNull(applyDetail.getMemberId()) | 
 |  |  |                         ||StringUtils.isBlank(applyDetail.getIdcardNo()) | 
 |  |  |                         ||StringUtils.isBlank(applyDetail.getMemberName()) | 
 |  |  |                         ||Objects.isNull(applyDetail.getDuId()) | 
 |  |  |                         ||Objects.isNull(applyDetail.getWorktypeId()) | 
 |  |  |                 ){ | 
 |  |  | 
 |  |  |                 applyDetail.setCreateDate(new Date()); | 
 |  |  |                 applyDetail.setCreator(loginUserInfo.getId()); | 
 |  |  |                 applyDetail.setIsdeleted(Constants.ZERO); | 
 |  |  |                 applyDetail.setStartTime(insuranceApply.getApplyStartTime()); | 
 |  |  |                 applyDetail.setEndTime(insuranceApply.getApplyEndTime()); | 
 |  |  |                 applyDetail.setSortnum(i); | 
 |  |  |                 applyDetail.setApplyId(insuranceApply.getId()); | 
 |  |  |                 Member member = new Member(); | 
 |  |  |                 if(Objects.isNull(applyDetail.getMemberId())){ | 
 |  |  |                     throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"【"+applyDetail.getMemberName()+"】员工信息存在异常数据!"); | 
 |  |  |                     //查询是否存在该用户 | 
 |  |  |                     member = memberMapper.selectOne(new QueryWrapper<Member>().lambda() | 
 |  |  |                             .eq(Member::getCompanyId,insuranceApply.getCompanyId()) | 
 |  |  |                             .eq(Member::getIsdeleted,Constants.ZERO) | 
 |  |  |                             .eq(Member::getIdcardNo,applyDetail.getIdcardNo()) | 
 |  |  |                             .last(" limit 1") | 
 |  |  |                     ); | 
 |  |  |                     if(Objects.isNull(member)){ | 
 |  |  |                         member = new Member(); | 
 |  |  |                         member.setCreateDate(new Date()); | 
 |  |  |                         member.setCreator(loginUserInfo.getId()); | 
 |  |  |                         member.setIsdeleted(Constants.ZERO); | 
 |  |  |                         member.setName(applyDetail.getMemberName()); | 
 |  |  |                         member.setCompanyId(insuranceApply.getCompanyId()); | 
 |  |  |                         member.setSex(Constants.getSexByIdCard(applyDetail.getIdcardNo())); | 
 |  |  |                         member.setIdcardNo(applyDetail.getIdcardNo()); | 
 |  |  |                         member.setApplyId(insuranceApply.getId()); | 
 |  |  |                         member.setDuId(applyDetail.getDuId()); | 
 |  |  |                         member.setWorktypeId(applyDetail.getWorktypeId()); | 
 |  |  |                         memberMapper.insert(member); | 
 |  |  |                     }else{ | 
 |  |  |                         member.setApplyId(insuranceApply.getId()); | 
 |  |  |                         member.setDuId(applyDetail.getDuId()); | 
 |  |  |                         member.setWorktypeId(applyDetail.getWorktypeId()); | 
 |  |  |                         memberMapper.updateById(member); | 
 |  |  |                     } | 
 |  |  |                 }else{ | 
 |  |  |                     member = memberMapper.selectById(applyDetail.getMemberId()); | 
 |  |  |                     if(Objects.isNull(member)){ | 
 |  |  |                         throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"【"+applyDetail.getMemberName()+"】员工信息存在异常数据!"); | 
 |  |  |                     } | 
 |  |  |                     member.setApplyId(insuranceApply.getId()); | 
 |  |  |                     member.setDuId(applyDetail.getDuId()); | 
 |  |  |                     member.setWorktypeId(applyDetail.getWorktypeId()); | 
 |  |  |                     memberMapper.updateById(member); | 
 |  |  |                 } | 
 |  |  |                 Member member = memberMapper.selectById(applyDetail.getMemberId()); | 
 |  |  |                 if(Objects.isNull(member)){ | 
 |  |  |                     throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"【"+applyDetail.getMemberName()+"】员工信息存在异常数据!"); | 
 |  |  |                 } | 
 |  |  |                 applyDetail.setMemberId(member.getId()); | 
 |  |  |                 applyDetail.setIdcardNo(member.getIdcardNo()); | 
 |  |  |                 applyDetail.setSex(member.getSex()); | 
 |  |  |                 applyDetail.setFee(Constants.countDetailFee(solutions,insuranceApply.getApplyEndTime(),insuranceApply.getApplyStartTime())); | 
 |  |  |                 applyDetail.setFee(countCyclePriceVO.getCyclePrice()); | 
 |  |  |                 //验证派遣单位信息是否存在 | 
 |  |  |                 if(duSolutionList.stream().filter(d->d.getDispatchUnitId().equals(applyDetail.getDuId())).collect(Collectors.toList()).size()<=Constants.ZERO){ | 
 |  |  |                     throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"【"+applyDetail.getMemberName()+"】员工派遣单位未查询到!"); | 
 |  |  |                 } | 
 |  |  |                 if(duWorktypeList.stream().filter(d->d.getDuSolutionId().equals(applyDetail.getDuId())&&d.getWorkTypeId().equals(applyDetail.getWorktypeId())) | 
 |  |  |                 if(duWorktypeList.stream().filter(d->d.getWorkTypeId().equals(applyDetail.getWorktypeId())) | 
 |  |  |                         .collect(Collectors.toList()).size()<=Constants.ZERO){ | 
 |  |  |                     throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"【"+applyDetail.getMemberName()+"】员工工种信息未查询到!"); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             applyDetailJoinMapper.insertBatchSomeColumn(applyDetailList); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         //存储日志数据 | 
 |  |  |         this.saveApplyLog(insuranceApply,insuranceApplyStatus,null); | 
 |  |  |         return insuranceApply.getId(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     public void saveApplyLog(InsuranceApply insuranceApply,Constants.InsuranceApplyStatus insuranceApplyStatus,String content){ | 
 |  |  |         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); | 
 |  |  | 
 |  |  |         //企业人员查看本企业数据 | 
 |  |  |         if(loginUserInfo.getType().equals(Constants.ONE)){ | 
 |  |  |             queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId()); | 
 |  |  |         }else{ | 
 |  |  |             if(loginUserInfo.getCompanyIdList()!=null && loginUserInfo.getCompanyIdList().size()>0){ | 
 |  |  |                 queryWrapper.in(InsuranceApply::getCompanyId, loginUserInfo.getCompanyIdList()); | 
 |  |  |             }else{ | 
 |  |  |                 queryWrapper.eq(InsuranceApply::getCompanyId, -1); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getSolutionId() != null) { | 
 |  |  |             queryWrapper.eq(InsuranceApply::getSolutionId, pageWrap.getModel().getSolutionId()); | 
 |  |  | 
 |  |  |         if (pageWrap.getModel().getStatus() != null) { | 
 |  |  |             queryWrapper.eq(InsuranceApply::getStatus, pageWrap.getModel().getStatus()); | 
 |  |  |         } | 
 |  |  |         for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |             if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                 queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |             } else { | 
 |  |  |                 queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |         if(CollectionUtils.isNotEmpty(pageWrap.getSorts())){ | 
 |  |  |             for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |                 if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                     queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |                 } else { | 
 |  |  |                     queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         }else{ | 
 |  |  |             queryWrapper.orderByDesc(InsuranceApply::getCreateDate); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         PageData<InsuranceApply> pageData = PageData.from(insuranceApplyJoinMapper.selectJoinPage(page,InsuranceApply.class, queryWrapper)); | 
 |  |  |         if(pageData.getRecords()!=null){ | 
 |  |  |             for (InsuranceApply apply : pageData.getRecords()){ | 
 |  |  | 
 |  |  |         //企业人员查看本企业数据 | 
 |  |  |         if(loginUserInfo.getType().equals(Constants.ONE)){ | 
 |  |  |             queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId()); | 
 |  |  |         }else{ | 
 |  |  |             if(loginUserInfo.getCompanyIdList()!=null && loginUserInfo.getCompanyIdList().size()>0){ | 
 |  |  |                 queryWrapper.in(InsuranceApply::getCompanyId, loginUserInfo.getCompanyIdList()); | 
 |  |  |             }else{ | 
 |  |  |                 queryWrapper.eq(InsuranceApply::getCompanyId, -1); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         if (model.getSolutionId() != null) { | 
 |  |  |             queryWrapper.eq(InsuranceApply::getSolutionId, model.getSolutionId()); | 
 |  |  | 
 |  |  |         MPJLambdaWrapper wrapper=  new MPJLambdaWrapper<InsuranceApply>() | 
 |  |  |                 .selectAll(InsuranceApply.class) | 
 |  |  |                 .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
 |  |  |                 .selectAs(Company::getName,ApplyLog::getCompanyName) | 
 |  |  |                 .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
 |  |  |                 .select(" ( select count(1) from apply_detail ad  where ad.apply_id = t.id ) as insureNum") | 
 |  |  |                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
 |  |  |                 .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
 |  |  | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         insuranceApply.setInsureNum(applyDetailMapper.selectCount(new QueryWrapper<ApplyDetail>().lambda().eq(ApplyDetail::getApplyId,insuranceApply.getId()) | 
 |  |  |                 .eq(ApplyDetail::getIsdeleted,Constants.ZERO))); | 
 |  |  |         if(insuranceApply.getStartTime().compareTo(new Date())<0  && insuranceApply.getEndTime().compareTo(new Date()) > 0 ){ | 
 |  |  |             insuranceApply.setLoseEfficacyDays(DateUtil.daysBetweenDates(insuranceApply.getEndTime(),new Date())); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         initApplyStatus(insuranceApply); | 
 |  |  |  | 
 |  |  |         //查询附件数据 | 
 |  |  | 
 |  |  |         List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class, | 
 |  |  |                 new MPJLambdaWrapper<ApplyLog>() | 
 |  |  |                         .selectAll(ApplyLog.class) | 
 |  |  |                         .selectAs(Member::getName,ApplyLog::getCreatorName) | 
 |  |  |                         .selectAs(SystemUser::getRealname,ApplyLog::getCreatorName) | 
 |  |  |                         .selectAs(Company::getName,ApplyLog::getCompanyName) | 
 |  |  |                         .leftJoin(Member.class,Member::getId,ApplyLog::getCreator) | 
 |  |  |                         .leftJoin(Company.class,Company::getId,Member::getCompanyId) | 
 |  |  |                         .leftJoin(SystemUser.class,SystemUser::getId,ApplyLog::getCreator) | 
 |  |  |                         .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) | 
 |  |  |                         .eq(ApplyLog::getApplyId,insuranceApply.getId()) | 
 |  |  |                         .orderByAsc(ApplyLog::getCreateDate) | 
 |  |  |         ); | 
 |  |  | 
 |  |  |                 f.setFileurlFull(path+f.getFileurl()); | 
 |  |  |                 if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.BD_APPLY_PDF.getKey())){ | 
 |  |  |                     //签署前的投保单 | 
 |  |  |                     model.setBaoxiandanFile(f); | 
 |  |  |                     model.setToubaodanFile(f); | 
 |  |  |                 }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.BD_SIGNED_PDF.getKey())){ | 
 |  |  |                     //签署后的投保单 | 
 |  |  |                     model.setToubaodanSignedFile(f); | 
 |  |  |                 }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.BD_DONE_PDF.getKey())){ | 
 |  |  |                     //最終保险单 | 
 |  |  |                     model.setBaoxiandanFile(f); | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 if(model.getStatus().equals(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){ | 
 |  |  |                     //如果当前时间大于结束日期 则使用结束日期对比开始日期 | 
 |  |  |                     if(DateUtil.compareDate(new Date(),model.getEndTime())>=Constants.ZERO){ | 
 |  |  |                         model.setServiceDays(DateUtil.daysBetweenDates(model.getEndTime(),model.getStartTime())); | 
 |  |  |                     }else if(DateUtil.compareDate(model.getStartTime(),new Date())>=Constants.ZERO){ | 
 |  |  |                         //未开始 | 
 |  |  |                         model.setServiceDays(Constants.ZERO); | 
 |  |  |                     }else{ | 
 |  |  |                         model.setServiceDays(DateUtil.daysBetweenDates(new Date(),model.getStartTime())); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  | 
 |  |  |                 .selectAs(DispatchUnit::getName,ApplyDetail::getDuName) | 
 |  |  |                 .leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId) | 
 |  |  |                 .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId) | 
 |  |  |                 .eq(InsuranceApply::getId,model.getId()); | 
 |  |  |                 .eq(ApplyDetail::getApplyId,model.getId()); | 
 |  |  |         //查询明细 | 
 |  |  |         List<ApplyDetail> detailList =applyDetailJoinMapper.selectJoinList(ApplyDetail.class,wrapper1); | 
 |  |  |         if(detailList!=null){ | 
 |  |  | 
 |  |  |      */ | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {Exception.class}) | 
 |  |  |     public void updateApplyCurrentFee(){ | 
 |  |  |     public void updateApplyCurrentFee(Integer id){ | 
 |  |  |         List<InsuranceApply> insuranceApplyList = insuranceApplyMapper.selectList(new QueryWrapper<InsuranceApply>().lambda() | 
 |  |  |                 .eq(InsuranceApply::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) | 
 |  |  |                 .ge(InsuranceApply::getStartTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 00:00:00") | 
 |  |  |                 .le(InsuranceApply::getEndTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 23:59:59") | 
 |  |  |                 .eq(!Objects.isNull(id),InsuranceApply::getId,id) | 
 |  |  |                 .le(InsuranceApply::getStartTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 00:00:00") | 
 |  |  |                 .ge(InsuranceApply::getEndTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 23:59:59") | 
 |  |  |         ); | 
 |  |  |  | 
 |  |  |         if(CollectionUtils.isNotEmpty(insuranceApplyList)){ | 
 |  |  | 
 |  |  |                 List<ApplyDetail> applyDetailList = applyDetailMapper.selectList(new QueryWrapper<ApplyDetail>().lambda().eq(ApplyDetail::getApplyId,insuranceApply.getId())); | 
 |  |  |                 if(CollectionUtils.isNotEmpty(applyDetailList)){ | 
 |  |  |                     for (ApplyDetail applyDetail: applyDetailList) { | 
 |  |  |                         applyDetail.setCurrentFee(Constants.countDetailFee(solutions,new Date(),applyDetail.getStartTime())); | 
 |  |  |                         applyDetailMapper.updateById(applyDetail); | 
 |  |  |                         //2024-1-30 10:04:24 修改 根据实际天数进行计算 当前费用  总金额/总天数*实际天数 | 
 |  |  |                         Integer maxDays = DateUtil.calculateBetween(applyDetail.getStartTime(),applyDetail.getEndTime(),0) + 1 ; | 
 |  |  |                         BigDecimal fee = applyDetail.getFee(); | 
 |  |  |                         if(applyDetail.getStartTime().compareTo(new Date()) <= 0 && applyDetail.getEndTime().compareTo(new Date()) >= 0 ){ | 
 |  |  |                             Integer days =  DateUtil.calculateBetween(applyDetail.getStartTime(),new Date(),0) + 1 ; | 
 |  |  |                             applyDetail.setCurrentFee(fee.divide(BigDecimal.valueOf(maxDays),2, BigDecimal.ROUND_HALF_UP).multiply(BigDecimal.valueOf(days))); | 
 |  |  |                             applyDetailMapper.updateById(applyDetail); | 
 |  |  |                         } | 
 |  |  | //                        DateUtil.daysBetweenDates(applyDetail.getEndTime(),applyDetail.getStartTime()); | 
 |  |  | //                        applyDetail.setCurrentFee(Constants.countDetailFee(solutions,new Date(),applyDetail.getStartTime())); | 
 |  |  | //                        applyDetailMapper.updateById(applyDetail); | 
 |  |  |                         sumAmount = sumAmount.add(applyDetail.getCurrentFee()); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public CountCyclePriceVO getCountCyclePriceVO(CountCyclePriceDTO countCyclePriceDTO){ | 
 |  |  |         if(Objects.isNull(countCyclePriceDTO) | 
 |  |  |             || Objects.isNull(countCyclePriceDTO.getSolutionsId()) | 
 |  |  |             || Objects.isNull(countCyclePriceDTO.getStartDate()) | 
 |  |  |         ){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         Solutions solutions = solutionsMapper.selectById(countCyclePriceDTO.getSolutionsId()); | 
 |  |  |         if(Objects.isNull(solutions)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息"); | 
 |  |  |         } | 
 |  |  |         return Constants.countPriceVO(countCyclePriceDTO.getStartDate(),solutions); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  |