From 50fb58286ed3b718c39a97e0987ee7561a295651 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期五, 04 七月 2025 17:56:41 +0800
Subject: [PATCH] git ch

---
 server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java | 2140 +++++++++++++++++++++++++++++++++++++----------------------
 1 files changed, 1,332 insertions(+), 808 deletions(-)

diff --git a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
index bd27772..e711bfd 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyServiceImpl.java
@@ -1,5 +1,6 @@
 package com.doumee.service.business.impl;
 
+import cn.hutool.core.util.IdcardUtil;
 import com.alibaba.fastjson.JSONObject;
 import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.annotation.excel.ExcelExporter;
@@ -13,13 +14,13 @@
 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.dto.SmsCheckDTO;
+import com.doumee.dao.business.dto.*;
 import com.doumee.dao.business.join.*;
 import com.doumee.dao.business.model.*;
+import com.doumee.dao.business.vo.ApplyPowerVO;
 import com.doumee.dao.business.vo.CountCyclePriceVO;
+import com.doumee.dao.business.vo.dataBoard.InsuranceDataVO;
+import com.doumee.dao.system.SystemUserMapper;
 import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.InsuranceApplyService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -35,6 +36,8 @@
 import io.swagger.models.auth.In;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.shiro.SecurityUtils;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
@@ -55,14 +58,12 @@
 public class InsuranceApplyServiceImpl implements InsuranceApplyService {
     @Value("${debug_model}")
     private boolean debugModel;
-
     @Autowired
     private InsuranceApplyMapper insuranceApplyMapper;
     @Autowired
     private SmsEmailService smsEmailService;
     @Autowired
     private ApplyChangeJoinMapper applyChangeMapper;
-
     @Autowired
     private SystemDictDataBiz systemDictDataBiz;
     @Autowired
@@ -71,34 +72,30 @@
     private CompanyMapper companyMapper;
     @Autowired
     private MemberInsuranceJoinMapper memberInsuranceJoinMapper;
-
     @Autowired
     private ApplyDetailMapper applyDetailMapper;
     @Autowired
     private ApplyDetailJoinMapper applyDetailJoinMapper;
-
     @Autowired
     private ApplyLogMapper applyLogMapper;
     @Autowired
     private SignService signService;
     @Autowired
     private MultifileMapper multifileMapper;
-
     @Autowired
     private ApplyLogJoinMapper applyLogJoinMapper;
-
     @Autowired
     private SolutionsMapper solutionsMapper;
-
     @Autowired
     private MemberMapper memberMapper;
     @Autowired
-    private DuSolutionMapper duSolutionMapper;
+    private MemberJoinMapper memberJoinMapper;
     @Autowired
     private DuSolutionJoinMapper duSolutionJoinMapper;
     @Autowired
-    private DuWorktypeMapper duWorktypeMapper;
-
+    private DuWorkTypeJoinMapper duWorkTypeJoinMapper;
+    @Autowired
+    private SolutionWorktypeJoinMapper solutionWorktypeJoinMapper;
     @Autowired
     private NoticesMapper noticesMapper;
     @Autowired
@@ -107,200 +104,16 @@
     private UnionChangeJoinMapper unionChangeJoinMapper;
     @Autowired
     private CompanySolutionMapper companySolutionMapper;
-
-    @Override
-    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer back(InsuranceApply insuranceApply) {
-        if(insuranceApply.getId() == null ||StringUtils.isBlank(insuranceApply.getCheckInfo())){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
-        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
-            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-        Solutions solutions = solutionsMapper.selectById(model.getSolutionId());
-        if(Objects.isNull(solutions)){
-            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈡柟妗堜俊鎭�");
-        }
-        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        InsuranceApply update = new InsuranceApply();
-        if(Constants.equalsInteger(solutions.getType(),Constants.ZERO)){
-            if(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-            }
-            update.setStatus(Constants.InsuranceApplyStatus.FAIL_RETURN.getKey());
-        }else{
-            if( !(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_MEMBER_LIST_SIGNATURE.getKey())
-            || Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey())
-            || Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey()))){
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-            }
-            update.setStatus(Constants.InsuranceApplyStatus.WTB_RETURN.getKey());
-        }
-
-        update.setEditDate(new Date());
-        update.setEditor(user.getId());
-        update.setCheckDate(update.getEditDate());
-        update.setCheckInfo(insuranceApply.getCheckInfo());
-        update.setCheckUserId(user.getId());
-        update.setId(model.getId());
-        insuranceApplyMapper.updateById(update);
-
-        //瀛樺偍寰呭姙淇℃伅
-        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.INSURANCE_APPLY;
-        //鍒犻櫎鍏朵粬寰呭姙
-        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
-                .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
-                .eq(Notices::getObjId,insuranceApply.getId()));
-        Notices notices = new Notices(noticeObjectType,Constants.ONE,insuranceApply.getId(),solutions.getName(),
-                model.getCompanyId(), Constants.NoticeType.FOUR);
-        noticesMapper.insert(notices);
+    @Autowired
+    private ContractJoinMapper contractJoinMapper;
+    @Autowired
+    private SystemUserMapper systemUserMapper;
+    @Autowired
+    private CompanyDepartmentMapper companyDepartmentMapper;
 
 
-        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.PLATFORM_RETURN;
-        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;
-
-    }
-    @Override
-    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer closeWtbForShop(InsuranceApply insuranceApply) {
-        if(insuranceApply.getId() == null ||StringUtils.isBlank(insuranceApply.getCheckInfo())){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
-
-        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
-            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-        //鍙湁瀹℃牳閫氳繃鐨勭姸鎬佸彲鍏抽棴
-        if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey())){
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-        }
-        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        InsuranceApply update = new InsuranceApply();
-        update.setEditDate(new Date());
-        update.setEditor(user.getId());
-        update.setStatus(Constants.InsuranceApplyStatus.WTB_CLOSED.getKey());
-        update.setCheckDate(update.getEditDate());
-        update.setCheckInfo(insuranceApply.getCheckInfo());
-        update.setCheckUserId(user.getId());
-        update.setId(model.getId());
-        insuranceApplyMapper.updateById(update);
-
-        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.SHOP_CLOSE_WTB_APPLY;
-        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;
-    }
-
-    @Override
-    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer uploadBaoxiandan(InsuranceApply insuranceApply) {
-        if(insuranceApply.getId() == null
-                || insuranceApply.getCode() == null
-                || insuranceApply.getStartTime() == null
-                || insuranceApply.getBaoxiandanFile() == null
-                ||StringUtils.isBlank( insuranceApply.getBaoxiandanFile() .getFileurl())
-                ||StringUtils.isBlank( insuranceApply.getBaoxiandanFile() .getName())){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-
-        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
-        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
-            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-        if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.SIGNATURE.getKey())){
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-        }
-        if(model.getApplyEndTime()== null || model.getStartTime().getTime()>model.getApplyEndTime().getTime() ){
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风敓鏁堝懆鏈熸椂闂翠笉绗﹀悎瑕佹眰锛岃纭鍚庝慨鏀归噸璇晘");
-        }
-        //璁$畻瀹為檯鎴鏃堕棿
-        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());
-        update.setEditor(user.getId());
-        update.setStatus(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey());
-        update.setCheckDate(update.getEditDate());
-        update.setCheckInfo(insuranceApply.getCheckInfo());
-        update.setCheckUserId(user.getId());
-        update.setId(model.getId());
-        update.setCode(insuranceApply.getCode());
-        update.setEndTime(actEndTime);
-        update.setStartTime(insuranceApply.getStartTime());
-        insuranceApplyMapper.updateById(update);
-
-        //淇敼鏄庣粏琛岀殑寮�濮嬬粨鏉熸棩鏈�
-        applyDetailMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda().set(ApplyDetail::getStartTime,insuranceApply.getStartTime())
-                .set(ApplyDetail::getEndTime,actEndTime).eq(ApplyDetail::getApplyId,model.getId()));
-
-        multifileMapper.update(null,new UpdateWrapper<Multifile>().lambda()
-                .eq(Multifile::getIsdeleted,Constants.ZERO)
-                .eq(Multifile::getObjType,Constants.MultiFile.BD_DONE_PDF.getKey())
-                .eq(Multifile::getObjId,update.getId())
-                .set(Multifile::getIsdeleted,Constants.ONE)
-                .set(Multifile::getEditDate,update.getEditDate())
-                .set(Multifile::getEditor,update.getEditor())
-        );
-
-        insuranceApply.getBaoxiandanFile().setIsdeleted(Constants.ZERO);
-        insuranceApply.getBaoxiandanFile().setCreator(user.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);
-        multifileMapper.insert(insuranceApply.getBaoxiandanFile());
-        update.setBaoxiandanFile(insuranceApply.getBaoxiandanFile());
-
-        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.UPLOAD_INSURANCE;
-        String info = "";
-        if(model.getApplyStartTime()!=null && model.getApplyStartTime().getTime()/1000!= insuranceApply.getStartTime().getTime()/1000){
-            info =applyLogType.getInfo();
-            info = info.replace("${param1}",DateUtil.getPlusTime2(model.getStartTime()));
-            info = info.replace("${param2}",DateUtil.getPlusTime2(insuranceApply.getStartTime()));
-        }
-        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());
-                memberInsurance.setRelationType(Constants.ZERO);
-                memberInsuranceList.add(memberInsurance);
-            }
-            memberInsuranceJoinMapper.insertBatchSomeColumn(memberInsuranceList);
-        }
-
-        return  1;
-    }
 
     @Override
     @Transactional(rollbackFor = {Exception.class,BusinessException.class})
@@ -318,8 +131,11 @@
         if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
             throw  new BusinessException(ResponseStatus.DATA_EMPTY);
         }
-        if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇峰綋鍓嶄笉鏀寔璇ユ搷浣渵");
+        if(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) ||
+                Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()) ){
+            if(model.getStartTime().getTime()<System.currentTimeMillis()){
+                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇峰綋鍓嶄笉鏀寔璇ユ搷浣渵");
+            }
         }
 
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
@@ -363,67 +179,7 @@
         return  1;
 
     }
-    @Override
-    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer dealBackApply(InsuranceApply insuranceApply) {
-        if(insuranceApply.getId() == null ||StringUtils.isBlank(insuranceApply.getCheckInfo())){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
 
-        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
-            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-
-        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        Constants.ApplyLogType applyLogType = null;
-        String info = "";
-        InsuranceApply update = new InsuranceApply();
-        if(insuranceApply.getDealBackApply() ==1){
-            //濡傛灉鏄┏鍥�,鍙兘鍙┏鍥炲凡绛剧珷鐘舵�佷笅鐨勯��鍥炵敵璇风姸鎬佽繘琛屾搷浣�
-            if(!(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_SIGNATURE.getKey())||
-                Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_WAIT_SIGNATURE.getKey())||
-                Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_UPLOAD.getKey())||
-                    Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey()))
-            ){
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-            }
-            applyLogType = Constants.ApplyLogType.PLATFORM_UN_AGREE_BACK;
-            info = applyLogType.getInfo();
-            info = info.replace("${param}", insuranceApply.getCheckInfo());
-            if( Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_SIGNATURE.getKey())){
-                update.setStatus(Constants.InsuranceApplyStatus.SIGNATURE.getKey());
-            }else if( Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_WAIT_SIGNATURE.getKey())){
-                update.setStatus(Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey());
-            }else if(  Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_UPLOAD.getKey())){
-                update.setStatus(Constants.InsuranceApplyStatus.UPLOAD.getKey());
-            }else if(  Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey())){
-                update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_CHECK_PASS.getKey());
-            }
-        }else{
-            //濡傛灉鏄悓鎰�,涓ょ鐢宠閫�鍥炵姸鎬侀兘鍙搷浣�
-            if(!(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_SIGNATURE.getKey())
-                    ||Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_WAIT_SIGNATURE.getKey())
-                    ||Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_UPLOAD.getKey()))){
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-            }
-            applyLogType = Constants.ApplyLogType.PLATFORM_AGREE_BACK;
-            update.setStatus(Constants.InsuranceApplyStatus.PLATFORM_RETURN.getKey());
-        }
-        update.setEditDate(new Date());
-        update.setEditor(user.getId());
-        update.setCheckDate(update.getEditDate());
-        update.setCheckInfo(insuranceApply.getCheckInfo());
-        update.setCheckUserId(user.getId());
-        update.setId(model.getId());
-        insuranceApplyMapper.updateById(update);
-
-        ApplyLog log = new ApplyLog(update,applyLogType.getName(),info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
-        applyLogMapper.insert(log);
-        return  1;
-
-
-    }
 
     @Override
     public  String getSignLink(Integer id) {
@@ -452,7 +208,7 @@
         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
         }
-        Company company = user.getCompany();
+        Company company = user.getShowCompany();
         if(debugModel){
             company = companyMapper.selectById(model.getCompanyId());
         }
@@ -482,11 +238,12 @@
         update.setId(model.getId());
         update.setEditor(user.getId());
         update.setEditDate(new Date());
+        update.setCheckUserId(user.getId());
+        update.setCheckDate(new Date());
         update.setSignApplyNo(applyNo);
         insuranceApplyMapper.updateById(update);
         return  link;
     }
-
 
     public String uploadSignFile(String link){
         try {
@@ -505,31 +262,48 @@
         }catch (Exception e){
         }
         return  null;
-
     }
-
 
     public Multifile   uploadSignedFileDo(InsuranceApply model,String fileurl,String fullUrl) {
         InsuranceApply update = new InsuranceApply();
+        Boolean retrial = false;
+        Solutions solutions = solutionsMapper.selectById(model.getSolutionId());
+        if(Constants.equalsInteger(solutions.getRetrial(),Constants.ONE)){
+           ApplyLog applyLog =  applyLogMapper.selectOne(new QueryWrapper<ApplyLog>().lambda()
+                    .eq(ApplyLog::getObjId,model.getId())
+                   .eq(ApplyLog::getObjType,Constants.ApplyLogType.PLATFORM_CHECK_PASS.getKey())
+                   .orderByDesc(ApplyLog::getCreateDate)
+                   .last(" limit 1 ")
+            );
+           if(Objects.nonNull(applyLog)){
+               SystemUser systemUser = systemUserMapper.selectById(applyLog.getCreator());
+               if(Objects.nonNull(systemUser) && Objects.nonNull(systemUser.getDepartmentId())){
+                   CompanyDepartment companyDepartment = companyDepartmentMapper.selectById(systemUser.getDepartmentId());
+                   if(Objects.nonNull(companyDepartment)&&Objects.nonNull(companyDepartment.getHeadId())){
+                       retrial = true;
+                       update.setRetrialId(companyDepartment.getHeadId());
+                   }
+               }
+           }
+        }
         update.setEditDate(new Date());
         update.setEditor(model.getCreator());
-        update.setStatus(Constants.InsuranceApplyStatus.SIGNATURE.getKey());
+        update.setStatus(retrial?Constants.InsuranceApplyStatus.REEXAMINE.getKey():Constants.InsuranceApplyStatus.SIGNATURE.getKey());
         update.setCheckDate(update.getEditDate());
         update.setCheckInfo("浼佷笟瀹屾垚绛剧讲");
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         insuranceApplyMapper.updateById(update);
-
         //瀛樺偍寰呭姙淇℃伅
         Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.INSURANCE_APPLY;
         //鍒犻櫎鍏朵粬寰呭姙
-        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda()
+                .eq(Notices::getObjType,noticeObjectType.getKey())
                 .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
                 .eq(Notices::getObjId,model.getId()));
         //骞冲彴寰呭姙
         Notices notices = new Notices(noticeObjectType,Constants.ZERO,model.getId(),model.getSolutionsName(),model.getCompanyId(),Constants.NoticeType.TWO);
         noticesMapper.insert(notices);
-
         CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda()
                 .eq(CompanySolution::getIsdeleted,Constants.ZERO)
                 .eq(CompanySolution::getSolutionId,model.getSolutionId())
@@ -542,7 +316,6 @@
                     model.getId(),model.getSolutionsName(),companySolution.getShopId(),Constants.NoticeType.ZERO);
             noticesMapper.insert(shopNotices);
         }
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -573,14 +346,11 @@
     public Multifile   uploadFAQRSSignedFileDo(InsuranceApply model,String fileurl,String fullUrl) {
         InsuranceApply update = new InsuranceApply();
         update.setEditDate(new Date());
-        update.setEditor(model.getCreator());
         update.setStatus(Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey());
         update.setCheckDate(update.getEditDate());
         update.setCheckInfo("浼佷笟瀹屾垚绛剧讲鏂规纭涔�");
-        update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         insuranceApplyMapper.updateById(update);
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -593,9 +363,8 @@
         f.setInfo("浼佷笟瀹屾垚绛剧讲鏂规纭涔�");
         f.setName("鏂规纭涔�.pdf");
         multifileMapper.insert(f);
-
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.WTB_FINISH_FAQRS;
-        ApplyLog log = new ApplyLog(update,applyLogType.getName(), null
+        ApplyLog log = new ApplyLog(model,applyLogType.getName(), null
                 ,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
         applyLogMapper.insert(log);
         return  f;
@@ -618,7 +387,6 @@
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         insuranceApplyMapper.updateById(update);
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -631,7 +399,6 @@
         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));
@@ -649,14 +416,12 @@
     public Multifile   uploadApplyMemberListSignedFileDo(InsuranceApply model,String fileurl,String fullUrl) {
         InsuranceApply update = new InsuranceApply();
         update.setEditDate(new Date());
-        update.setEditor(model.getCreator());
         update.setStatus(Constants.InsuranceApplyStatus.WTB_COMPANY_MEMBER_LIST_SIGNATURE.getKey());
         update.setCheckDate(update.getEditDate());
         update.setCheckInfo("浼佷笟瀹屾垚绛剧讲浜哄憳鍚嶅崟");
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         insuranceApplyMapper.updateById(update);
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -669,15 +434,11 @@
         f.setInfo("浼佷笟瀹屾垚绛剧讲浜哄憳鍚嶅崟");
         f.setName("浜哄憳鍚嶅崟.pdf");
         multifileMapper.insert(f);
-
-
-
         //鏁版嵁鏃ュ織
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.WTB_FINISH_MEMBER_LIST;
-        ApplyLog log = new ApplyLog(update,applyLogType.getName(), null
+        ApplyLog log = new ApplyLog(model,applyLogType.getName(), null
                 ,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
         applyLogMapper.insert(log);
-
         Solutions solutions = solutionsMapper.selectById(model.getSolutionId());
         //寰呭姙閫氱煡
         if(Objects.nonNull(solutions)&&Objects.nonNull(solutions.getShopId())){
@@ -687,12 +448,9 @@
             notices.setParam1(model.getId().toString());
             noticesMapper.insert(notices);
         }
-
-
         return  f;
     }
-    
-    
+
     public Multifile  uploadChangeSignedFileDo(ApplyChange model,String fileurl,String fullurl) {
         Integer companyId = model.getCompanyId();
         ApplyChange update = new ApplyChange();
@@ -704,7 +462,6 @@
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         applyChangeMapper.updateById(update);
-
         //瀛樺偍寰呭姙淇℃伅
         Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.APPLY_CHANGE;
         if(model.getType().equals(Constants.ONE)){
@@ -718,7 +475,6 @@
                 companyId, Constants.NoticeType.TWO);
         notices.setParam1(model.getApplyId().toString());
         noticesMapper.insert(notices);
-
         Solutions solutions = solutionsMapper.selectById(model.getSolutionsId());
         //鍟嗘埛寰呭姙
         if(Objects.nonNull(solutions)&&Objects.nonNull(solutions.getShopId())){
@@ -727,7 +483,6 @@
             notices.setParam1(model.getApplyId().toString());
             noticesMapper.insert(shopNotices);
         }
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -740,15 +495,12 @@
         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);
-
         startSendEmail(f,model.getCompanyName(),model.getSolutionsName(),model.getSolutionEmail());
         return f;
     }
-
 
     public Multifile  uploadChangeMemberListSignedFileDo(ApplyChange model,String fileurl,String fullurl) {
         ApplyChange update = new ApplyChange();
@@ -760,7 +512,6 @@
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         applyChangeMapper.updateById(update);
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -777,12 +528,9 @@
         f.setInfo("浼佷笟瀹屾垚绛剧讲浜哄憳鍚嶅崟");
         f.setName("绛剧珷浜哄憳鍚嶅崟.pdf");
         multifileMapper.insert(f);
-
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_WTB_FINISH_MEMBER_LIST;
         ApplyLog log = new ApplyLog(update,applyLogType.getName(), null,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
         applyLogMapper.insert(log);
-
-
         Solutions solutions = solutionsMapper.selectById(model.getSolutionsId());
         //寰呭姙閫氱煡
         if(Objects.nonNull(solutions)&&Objects.nonNull(solutions.getShopId())){
@@ -809,9 +557,9 @@
         UnionApply update = new UnionApply();
         update.setEditDate(new Date());
         update.setEditor(model.getCreator());
-        update.setStatus(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey());
+        update.setStatus(Objects.nonNull(model.getRetrialId())?Constants.UnionApplyStatus.RETRIAL.getKey() : Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey());
         update.setCheckDate(update.getEditDate());
-        update.setCheckInfo("鍟嗘埛瀹屾垚绛剧讲");
+        update.setCheckInfo(Objects.nonNull(model.getRetrialId())?"寰呭瀹�":"瀹屾垚绛剧讲");
         update.setCheckUserId(model.getCreator());
         update.setId(model.getId());
         unionApplyJoinMapper.updateById(update);
@@ -828,12 +576,31 @@
         f.setInfo("鍟嗘埛绛剧讲鎶曚繚鍗�");
         f.setName("鍟嗘埛绛剧讲鎶曚繚鍗�.pdf");
         multifileMapper.insert(f);
+        List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectList(new QueryWrapper<InsuranceApply>().
+                lambda().eq(InsuranceApply::getUnionApplyId,model.getId()));
+        if(CollectionUtils.isNotEmpty(insuranceApplyList)){
+            for (InsuranceApply insuranceApply:insuranceApplyList) {
 
+                f.setId(null);
+                f.setIsdeleted(Constants.ZERO);
+                f.setCreateDate(new Date());
+                f.setObjType(Constants.MultiFile.BD_SIGNED_PDF.getKey());
+                f.setType(Constants.TWO);
+                f.setObjId(insuranceApply.getId());
+                f.setInfo("鎶曚繚鍗�");
+                f.setName("鎶曚繚鍗�.pdf");
+                multifileMapper.insert(f);
+                insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                        .set(InsuranceApply::getUnionApplyTbdStatus,Constants.TWO)
+                        .set(InsuranceApply::getEditDate,new Date())
+                        .eq(InsuranceApply::getId,insuranceApply.getId())
+                );
+            }
+        }
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_SIGNATURE_TBD;
         ApplyLog log = new ApplyLog(model,applyLogType.getName(), null
                 ,model.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(model));
         applyLogMapper.insert(log);
-
         return  f;
     }
 
@@ -852,7 +619,6 @@
         update.setStatus(Constants.UnionChangeStatus.UPLOAD_INSURANCE_POLICY.getKey());
         update.setId(model.getId());
         unionChangeJoinMapper.updateById(update);
-
         Multifile f = new Multifile();
         f.setIsdeleted(Constants.ZERO);
         f.setCreator(model.getCreator());
@@ -865,11 +631,119 @@
         f.setInfo("鎶曚繚鐢宠鍗� -鐢宠鍗�");
         f.setName("鎶曚繚鐢宠鍗�.pdf");
         multifileMapper.insert(f);
-
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_HBD_SIGNATURE_TBD;
         ApplyLog log = new ApplyLog(model,applyLogType.getName(), null
                 ,model.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(model));
         applyLogMapper.insert(log);
+        return  f;
+    }
+
+    public Multifile   uploadContractFirstSignedFileDo(Contract model,String fileurl,String fullUrl) {
+        Contract update = new Contract();
+        update.setEditDate(new Date());
+        update.setEditor(model.getCreator());
+        update.setFileSignUrl(fileurl);
+        update.setStatus(Constants.equalsInteger(model.getType(),Constants.ZERO)?Constants.ONE:Constants.THREE);
+        update.setId(model.getId());
+        contractJoinMapper.updateById(update);
+        Multifile f = new Multifile();
+        f.setIsdeleted(Constants.ZERO);
+        f.setCreator(model.getCreator());
+        f.setObjId(update.getId());
+        f.setCreateDate(update.getEditDate());
+        f.setObjType(Constants.MultiFile.CONTRACT_FIRST_PDF.getKey());
+        f.setType(Constants.TWO);
+        f.setFileurl(fileurl);
+        f.setFileurlFull(fullUrl);
+        f.setInfo("鍚堝悓绛剧讲鏂囦欢");
+        f.setName("鍚堝悓绛剧讲鏂囦欢.pdf");
+        multifileMapper.insert(f);
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.CONTRACT;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
+                .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
+                .eq(Notices::getObjId,model.getId()));
+        //鍙屾柟绛剧讲 鎵嶄細鍙戞柊閫氱煡
+        if(Constants.equalsInteger(model.getType(),Constants.ZERO)){
+            Notices notices = new Notices(noticeObjectType,
+                    Constants.equalsInteger(model.getSignType(),Constants.ZERO)?Constants.TWO:Constants.ONE
+                    ,model.getId(),this.getNoticeInfo(model,companyMapper.selectById(model.getCompanyId())),model.getCompanyId(),Constants.NoticeType.ZERO);
+            noticesMapper.insert(notices);
+        }
+        return  f;
+    }
+
+    public String getNoticeInfo(Contract contract,Company company){
+        String noticeInfo = contract.getName();
+        //鍟嗘埛淇℃伅
+        if(Constants.equalsInteger(contract.getSignType(),Constants.TWO)){
+            Company shop = companyMapper.selectById(contract.getPartyCompanyId());
+            noticeInfo  = noticeInfo + "("+shop.getName()+"/"+company.getName()+")";
+        }else{
+            noticeInfo  = noticeInfo + "(骞冲彴/"+company.getName()+")";
+        }
+        return noticeInfo;
+    }
+
+    public Multifile  uploadContractDoneSignedFileDo(Contract model,String fileurl,String fullUrl) {
+        Contract update = new Contract();
+        update.setEditDate(new Date());
+        update.setEditor(model.getCreator());
+        update.setDoneFileUrl(fileurl);
+        update.setStatus(Constants.THREE);
+        update.setId(model.getId());
+        contractJoinMapper.updateById(update);
+        Multifile f = new Multifile();
+        f.setIsdeleted(Constants.ZERO);
+        f.setCreator(model.getCreator());
+        f.setObjId(update.getId());
+        f.setCreateDate(update.getEditDate());
+        f.setObjType(Constants.MultiFile.CONTRACT_DONE_PDF.getKey());
+        f.setType(Constants.TWO);
+        f.setFileurl(fileurl);
+        f.setFileurlFull(fullUrl);
+        f.setInfo("鍚堝悓绛剧讲鏂囦欢");
+        f.setName("鍚堝悓绛剧讲鏂囦欢.pdf");
+        multifileMapper.insert(f);
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.CONTRACT;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
+                .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
+                .eq(Notices::getObjId,model.getId()));
+        return  f;
+    }
+
+
+    public Multifile  uploadCompanySolutionSignedFileDo(CompanySolution model,String fileurl,String fullUrl) {
+        CompanySolution update = new CompanySolution();
+        update.setEditDate(new Date());
+        update.setEditor(model.getCreator());
+        update.setFileSignUrl(fileurl);
+        update.setSignStatus(Constants.ONE);
+        update.setSignUserId(model.getEditor());
+        update.setSignDate(new Date());
+        update.setId(model.getId());
+        companySolutionMapper.updateById(update);
+        Multifile f = new Multifile();
+        f.setIsdeleted(Constants.ZERO);
+        f.setCreator(model.getCreator());
+        f.setObjId(update.getId());
+        f.setCreateDate(update.getEditDate());
+        f.setObjType(Constants.MultiFile.COMPANY_SOLUTION_SIGN_PDF.getKey());
+        f.setType(Constants.TWO);
+        f.setFileurl(fileurl);
+        f.setFileurlFull(fullUrl);
+        f.setInfo("鏂规纭涔�");
+        f.setName("鏂规纭涔�.pdf");
+        multifileMapper.insert(f);
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.SOLUTIONS;
+        //鍒犻櫎鍏朵粬寰呭姙
+        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
+                .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
+                .eq(Notices::getObjId,model.getId()));
 
         return  f;
     }
@@ -886,6 +760,24 @@
         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 testSendEmail(){
+        SmsEmail email = new SmsEmail();
+        email.setTitle("娴嬭瘯閭欢");
+        email.setEmail("94314517@qq.com");
+        email.setContent("鏉ヨ嚜浼佷笟銆愭祴璇曚紒涓氥�戝叧浜庝繚闄╂柟妗堛�愭祴璇曟柟妗堛�戠殑娴嬭瘯閭欢");
+        File file = Constants.getFileByNetFile("https://yybred.oss-cn-hangzhou.aliyuncs.com/apply/20250116/600faf2f-5ba2-44e2-9a96-c99052dc013d.pdf","1111.pdf");
+        if(file!=null && file.isFile()){
+            Map<String,Object> files = new HashMap<>();
+            files.put("name","娴嬭瘯鏂囦欢");
             files.put("file",file);
             email.setFileList(new ArrayList<>());
             email.getFileList().add(files);
@@ -954,7 +846,6 @@
 //                return;
             }
         }
-
         //濮旀墭淇� 浼佷笟绛剧讲浜哄憳鍚嶅崟
         applyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class,
                 new MPJLambdaWrapper<InsuranceApply>()
@@ -1013,9 +904,6 @@
 //                return;
             }
         }
-        
-        
-
         List<ApplyChange> chagneList = applyChangeMapper.selectJoinList(ApplyChange.class,
                 new MPJLambdaWrapper<ApplyChange>()
                 .selectAll(ApplyChange.class)
@@ -1046,7 +934,6 @@
 //                return;
             }
         }
-
         //濮旀墭淇� 鍔犲噺淇�/鎹㈠巶 绛剧讲浜哄憳鍚嶅崟
         chagneList = applyChangeMapper.selectJoinList(ApplyChange.class,
                 new MPJLambdaWrapper<ApplyChange>()
@@ -1078,12 +965,6 @@
 //                return;
             }
         }
-
-
-
-        /**
-         *鍚堝苟鎶曚繚鍗� 绛剧讲涓氬姟
-         */
         List<UnionApply> unionApplyList = unionApplyJoinMapper.selectJoinList(UnionApply.class,
                 new MPJLambdaWrapper<UnionApply>()
                         .selectAll(UnionApply.class)
@@ -1104,10 +985,6 @@
                 uploadUnionApplySignedFileDo(model,fileUrl,path+fileUrl);
             }
         }
-
-        /**
-         *鍚堝苟鍔犲噺淇濇崲鍘� 绛剧讲涓氬姟
-         */
         List<UnionChange> unionChangeList = unionChangeJoinMapper.selectJoinList(UnionChange.class,
                 new MPJLambdaWrapper<UnionChange>()
                         .selectAll(UnionChange.class)
@@ -1128,295 +1005,522 @@
                 uploadUnionChangeSignedFileDo(model,fileUrl,path+fileUrl);
             }
         }
-
-
-
+        List<Contract> contractFirstList = contractJoinMapper.selectJoinList(Contract.class,
+                new MPJLambdaWrapper<Contract>()
+                        .selectAll(Contract.class)
+                        .eq(Contract::getStatus,Constants.ZERO)
+                        .isNotNull(Contract::getApplyNo));
+        if(contractFirstList !=null && contractFirstList.size()>0 ){
+            for(Contract contract : contractFirstList){
+                String status = signService.linkFileStatus(contract.getApplyNo());
+                if(!StringUtils.equals(status,"3")){
+                    continue;
+                }
+                String link = signService.linkFile(contract.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    continue;
+                }
+                uploadContractFirstSignedFileDo(contract,fileUrl,path+fileUrl);
+            }
+        }
+        List<Contract> contractDoneList = contractJoinMapper.selectJoinList(Contract.class,
+                new MPJLambdaWrapper<Contract>()
+                        .selectAll(Contract.class)
+                        .eq(Contract::getStatus,Constants.ONE)
+                        .isNotNull(Contract::getDoneApplyNo));
+        if(contractDoneList !=null && contractDoneList.size()>0 ){
+            for(Contract contract : contractDoneList){
+                String status = signService.linkFileStatus(contract.getDoneApplyNo());
+                if(!StringUtils.equals(status,"3")){
+                    continue;
+                }
+                String link = signService.linkFile(contract.getDoneApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    continue;
+                }
+                uploadContractDoneSignedFileDo(contract,fileUrl,path+fileUrl);
+            }
+        }
+        List<CompanySolution> companySolutionList = companySolutionMapper.selectList(
+                new QueryWrapper<CompanySolution>().lambda()
+                        .eq(CompanySolution::getSignStatus,Constants.ZERO)
+                        .isNotNull(CompanySolution::getApplyNo));
+        if(companySolutionList !=null && companySolutionList.size()>0 ){
+            for(CompanySolution companySolution : companySolutionList){
+                String status = signService.linkFileStatus(companySolution.getApplyNo());
+                if(!StringUtils.equals(status,"3")){
+                    continue;
+                }
+                String link = signService.linkFile(companySolution.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    continue;
+                }
+                uploadCompanySolutionSignedFileDo(companySolution,fileUrl,path+fileUrl);
+            }
+        }
     }
+
     @Override
-    public   void dealSignResult(NotifyDataReq data){
+    public   String dealSignResult(NotifyDataReq data){
         if(data.getApplyNo() == null ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST);
         }
-        if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+        if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )
+                || Constants.equalsInteger(data.getSignStatus(), Constants.TWO )){
             //濡傛灉宸蹭繚鍏�,鍙笅杞界绾﹂檮浠�
             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(Solutions::getType,Constants.ZERO)
-                            .eq(InsuranceApply::getSignApplyNo,data.getApplyNo())
-                            .last("limit 1" ));
-            if(model != null && Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){
+           String r = dealXBTBBiz(path,data,"鐩翠繚-鎶曚繚鐢宠绛剧讲");
+           if(StringUtils.isNotBlank(r)){
+               return  r;
+           }
+            r = dealWTBQYQRSBiz(path,data,"濮旀墭淇�-浼佷笟鏂规纭涔︾缃�");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealWTBQYRYMQDBiz(path,data,"濮旀墭淇�-浼佷笟浜哄憳鍚嶅崟绛剧讲");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealWTBTBSQBiz(path,data,"濮旀墭淇�-鎶曚繚鐢宠涔︾缃�");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealZBJJBQYBiz(path,data,"鐩翠繚-鍔犲噺淇濅紒涓氱缃�");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealWTBJJBQYBiz(path,data,"濮旀墭淇�-鍔犲噺淇濅紒涓氱缃�");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealHBDSHBiz(path,data,"鎶曚繚鍚堝苟鍗�-鍟嗘埛绛剧讲绛剧讲");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealHBCHANGEQYBiz(path,data,"鍚堝苟鍔犲噺淇�/鎹㈠巶绛剧讲");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealContractFirstBiz(path,data,"鍚堝悓鎴戞柟绛剧讲");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealContractDoneBiz(path,data,"鍚堝悓浼佷笟/鍟嗘埛绛剧讲");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+            r = dealCompanySolutionBiz(path,data,"浼佷笟绛剧讲鏂规纭涔�");
+            if(StringUtils.isNotBlank(r)){
+                return  r;
+            }
+
+        }
+        return "鏃犲鐞嗘暟鎹�";
+    }
+
+    private String dealHBCHANGEQYBiz(String path, NotifyDataReq data, String title) {
+        UnionChange unionChange = unionChangeJoinMapper.selectOne(
+                new MPJLambdaWrapper<UnionChange>()
+                        .selectAll(UnionChange.class)
+                        .eq(UnionChange::getSignApplyNo,data.getApplyNo())
+                        .last(" limit 1 "));
+        if(unionChange == null){
+            return null;
+        }
+        if( Constants.equalsInteger(unionChange.getStatus(),Constants.UnionChangeStatus.MERGE.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
                 //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
-                String link = signService.linkFile(data.getApplyNo());
+                String link = signService.linkFile(unionChange.getSignApplyNo());
                 String fileUrl = uploadSignFile(link);
                 if(StringUtils.isBlank(fileUrl)){
                     //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadSignedFileDo(model,fileUrl,path+fileUrl);
-                return;
-            }
-            //濮旀墭淇� 浼佷笟鏂规纭涔�
-            InsuranceApply modelTBQRS = 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(Solutions::getType,Constants.ONE)
-                            .eq(InsuranceApply::getSignQrsNo,data.getApplyNo())
-                            .last("limit 1" ));
-            if(modelTBQRS != null && Constants.equalsInteger(modelTBQRS.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey())){
-                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
-                String link = signService.linkFile(data.getApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadFAQRSSignedFileDo(modelTBQRS,fileUrl,path+fileUrl);
-                return;
-            }
-
-
-
-            //濮旀墭淇� 浼佷笟绛剧讲浜哄憳鍚嶅崟
-            InsuranceApply modelMemberList = 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(Solutions::getType,Constants.ONE)
-                            .eq(InsuranceApply::getSignMemberListNo,data.getApplyNo())
-                            .last("limit 1" ));
-            if(modelMemberList != null && Constants.equalsInteger(modelMemberList.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey())){
-                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
-                String link = signService.linkFile(data.getApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadApplyMemberListSignedFileDo(modelMemberList,fileUrl,path+fileUrl);
-                return;
-            }
-
-
-            //濮旀墭淇� 鎶曚繚鐢宠涔︾缃�
-            InsuranceApply modelTBQSQ = 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(Solutions::getType,Constants.ONE)
-                            .eq(InsuranceApply::getApplyTbdNo,data.getApplyNo())
-                            .last("limit 1" ));
-            if(modelTBQRS != null && Constants.equalsInteger(modelTBQSQ.getUnionApplyTbdStatus(),Constants.ONE)){
-                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
-                String link = signService.linkFile(data.getApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadTBSQSSignedFileDo(modelTBQSQ,fileUrl,path+fileUrl);
-                return;
-            }
-
-            //鐩翠繚 鍔犲噺淇濅紒涓氱缃�
-            ApplyChange applyChange = applyChangeMapper.selectJoinOne(ApplyChange.class,
-                    new MPJLambdaWrapper<ApplyChange>()
-                            .selectAll(ApplyChange.class)
-                            .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
-                            .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail)
-                            .selectAs(Solutions::getId,ApplyChange::getSolutionsId)
-                            .selectAs(Company::getName,InsuranceApply::getCompanyName)
-                            .selectAs(InsuranceApply::getCompanyId,ApplyChange::getCompanyId)
-                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
-                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
-                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
-                            .eq(Solutions::getType,Constants.ZERO)
-                            .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);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadChangeSignedFileDo(applyChange,fileUrl,path+fileUrl);
-            }
-
-            //濮旀墭淇� 鍔犲噺淇濅紒涓氱缃�
-            ApplyChange applyChangeMemberList = applyChangeMapper.selectJoinOne(ApplyChange.class,
-                    new MPJLambdaWrapper<ApplyChange>()
-                            .selectAll(ApplyChange.class)
-                            .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
-                            .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail)
-                            .selectAs(Solutions::getId,ApplyChange::getSolutionsId)
-                            .selectAs(Company::getName,InsuranceApply::getCompanyName)
-                            .selectAs(InsuranceApply::getCompanyId,ApplyChange::getCompanyId)
-                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
-                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
-                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
-                            .eq(Solutions::getType,Constants.ONE)
-                            .eq(ApplyChange::getSignMemberListNo,data.getApplyNo()).last("limit 1" ));
-            if(applyChangeMemberList != null &&Constants.equalsInteger(applyChangeMemberList.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())){
-                String link = signService.linkFile(data.getApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadChangeMemberListSignedFileDo(applyChangeMemberList,fileUrl,path+fileUrl);
-            }
-
-
-            //鎶曚繚鍚堝苟鍗� 鍟嗘埛绛剧讲淇濆崟
-            UnionApply unionApply = unionApplyJoinMapper.selectOne(new QueryWrapper<UnionApply>()
-                    .lambda().eq(UnionApply::getSignApplyNo,data.getApplyNo()).last(" limit 1 "));
-            if(unionApply != null &&Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){
-                String link = signService.linkFile(data.getApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
-                }
-                uploadUnionApplySignedFileDo(unionApply,fileUrl,path+fileUrl);
-            }
-
-
-            /**
-             *鍚堝苟鍔犲噺淇濇崲鍘� 绛剧讲涓氬姟
-             */
-            UnionChange unionChange = unionChangeJoinMapper.selectOne(
-                    new MPJLambdaWrapper<UnionChange>()
-                            .selectAll(UnionChange.class)
-                            .eq(UnionChange::getSignApplyNo,data.getApplyNo())
-                            .last(" limit 1 "));
-            if(unionChange != null &&Constants.equalsInteger(unionChange.getStatus(),Constants.UnionChangeStatus.MERGE.getKey())){
-                String link = signService.linkFile(model.getSignApplyNo());
-                String fileUrl = uploadSignFile(link);
-                if(StringUtils.isBlank(fileUrl)){
-                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
-                    return;
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
                 }
                 uploadUnionChangeSignedFileDo(unionChange,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                unionChangeJoinMapper.update(null,new UpdateWrapper<UnionChange>().lambda()
+                        .set(UnionChange::getSignApplyNo,null)
+                        .eq(UnionChange::getSignApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealContractFirstBiz(String path, NotifyDataReq data, String title) {
+        Contract contract = contractJoinMapper.selectOne(new QueryWrapper<Contract>()
+                .lambda().
+                eq(Contract::getApplyNo,data.getApplyNo())
+                .last(" limit 1")
+        );
+
+        if(contract == null){
+            return null;
+        }
+        if( Constants.equalsInteger(contract.getStatus(),Constants.ONE)){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(contract.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+
+                uploadContractFirstSignedFileDo(contract,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                contractJoinMapper.update(null,new UpdateWrapper<Contract>().lambda()
+                        .set(Contract::getApplyNo,null)
+                        .eq(Contract::getApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealContractDoneBiz(String path, NotifyDataReq data, String title) {
+        Contract contract = contractJoinMapper.selectOne(new QueryWrapper<Contract>()
+                .lambda().
+                eq(Contract::getDoneApplyNo,data.getApplyNo())
+                .last(" limit 1")
+        );
+        if(contract == null){
+            return null;
+        }
+        if( Constants.equalsInteger(contract.getStatus(),Constants.THREE)){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(contract.getDoneApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadContractDoneSignedFileDo(contract,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                contractJoinMapper.update(null,new UpdateWrapper<Contract>().lambda()
+                        .set(Contract::getDoneApplyNo,null)
+                        .eq(Contract::getDoneApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+    private String dealCompanySolutionBiz(String path, NotifyDataReq data, String title) {
+        CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>()
+                .lambda().
+                eq(CompanySolution::getApplyNo,data.getApplyNo())
+                .last(" limit 1")
+        );
+        if(companySolution == null){
+            return null;
+        }
+        if( Constants.equalsInteger(companySolution.getSignStatus(),Constants.ZERO)){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(companySolution.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadCompanySolutionSignedFileDo(companySolution,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                companySolutionMapper.update(null,new UpdateWrapper<CompanySolution>().lambda()
+                        .set(CompanySolution::getApplyNo,null)
+                        .eq(CompanySolution::getApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealHBDSHBiz(String path, NotifyDataReq data, String title) {
+        //鎶曚繚鍚堝苟鍗� 鍟嗘埛绛剧讲淇濆崟
+        UnionApply unionApply = unionApplyJoinMapper.selectOne(new QueryWrapper<UnionApply>()
+                .lambda().eq(UnionApply::getSignApplyNo,data.getApplyNo()).last(" limit 1 "));
+        if(unionApply == null){
+            return null;
+        }
+        if( Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadUnionApplySignedFileDo(unionApply,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                unionApplyJoinMapper.update(null,new UpdateWrapper<UnionApply>().lambda()
+                        .set(UnionApply::getSignApplyNo,null)
+                        .eq(UnionApply::getSignApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+
+    }
+
+    private String dealWTBJJBQYBiz(String path, NotifyDataReq data, String title) {
+        //濮旀墭淇� 鍔犲噺淇濅紒涓氱缃�
+        ApplyChange applyChangeMemberList = applyChangeMapper.selectJoinOne(ApplyChange.class,
+                new MPJLambdaWrapper<ApplyChange>()
+                        .selectAll(ApplyChange.class)
+                        .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
+                        .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail)
+                        .selectAs(Solutions::getId,ApplyChange::getSolutionsId)
+                        .selectAs(Company::getName,InsuranceApply::getCompanyName)
+                        .selectAs(InsuranceApply::getCompanyId,ApplyChange::getCompanyId)
+                        .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+                        .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                        .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+                        .eq(Solutions::getType,Constants.ONE)
+                        .eq(ApplyChange::getSignMemberListNo,data.getApplyNo()).last("limit 1" ));
+        if(applyChangeMemberList == null){
+            return null;
+        }
+        if( Constants.equalsInteger(applyChangeMemberList.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadChangeMemberListSignedFileDo(applyChangeMemberList,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                applyChangeMapper.update(null,new UpdateWrapper<ApplyChange>().lambda()
+                        .set(ApplyChange::getSignMemberListNo,null)
+                        .eq(ApplyChange::getSignMemberListNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealZBJJBQYBiz(String path, NotifyDataReq data, String title) {
+        //鐩翠繚 鍔犲噺淇濅紒涓氱缃�
+        ApplyChange applyChange = applyChangeMapper.selectJoinOne(ApplyChange.class,
+                new MPJLambdaWrapper<ApplyChange>()
+                        .selectAll(ApplyChange.class)
+                        .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
+                        .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail)
+                        .selectAs(Solutions::getId,ApplyChange::getSolutionsId)
+                        .selectAs(Company::getName,InsuranceApply::getCompanyName)
+                        .selectAs(InsuranceApply::getCompanyId,ApplyChange::getCompanyId)
+                        .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+                        .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                        .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+                        .eq(Solutions::getType,Constants.ZERO)
+                        .eq(ApplyChange::getSignApplyNo,data.getApplyNo()).last("limit 1" ));
+        if(applyChange == null){
+            return null;
+        }
+        if( Constants.equalsInteger(applyChange.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadChangeSignedFileDo(applyChange,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                applyChangeMapper.update(null,new UpdateWrapper<ApplyChange>().lambda()
+                        .set(ApplyChange::getSignApplyNo,null)
+                        .eq(ApplyChange::getSignApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealWTBTBSQBiz(String path, NotifyDataReq data, String title) {
+        //濮旀墭淇� 鎶曚繚鐢宠涔︾缃�
+        InsuranceApply modelTBQSQ = 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(Solutions::getType,Constants.ONE)
+                        .eq(InsuranceApply::getApplyTbdNo,data.getApplyNo())
+                        .last("limit 1" ));
+        if(modelTBQSQ == null){
+            return null;
+        }
+        if( Constants.equalsInteger(modelTBQSQ.getUnionApplyTbdStatus(),Constants.ONE)){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadTBSQSSignedFileDo(modelTBQSQ,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                        .set(InsuranceApply::getApplyTbdNo,null)
+                        .eq(InsuranceApply::getApplyTbdNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealWTBQYRYMQDBiz(String path, NotifyDataReq data, String title) {
+        //濮旀墭淇� 浼佷笟绛剧讲浜哄憳鍚嶅崟
+        InsuranceApply modelMemberList = 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(Solutions::getType,Constants.ONE)
+                        .eq(InsuranceApply::getSignMemberListNo,data.getApplyNo())
+                        .last("limit 1" ));
+        if(modelMemberList == null){
+            return null;
+        }
+        if( Constants.equalsInteger(modelMemberList.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadApplyMemberListSignedFileDo(modelMemberList,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                        .set(InsuranceApply::getSignMemberListNo,null)
+                        .eq(InsuranceApply::getSignMemberListNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    private String dealWTBQYQRSBiz(String path, NotifyDataReq data, String title) {
+        //濮旀墭淇� 浼佷笟鏂规纭涔�
+        InsuranceApply modelTBQRS = 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(Solutions::getType,Constants.ONE)
+                        .eq(InsuranceApply::getSignQrsNo,data.getApplyNo())
+                        .last("limit 1" ));
+        if(modelTBQRS == null){
+            return null;
+        }
+        if(  Constants.equalsInteger(modelTBQRS.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey())){
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title+"鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadFAQRSSignedFileDo(modelTBQRS,fileUrl,path+fileUrl);
+                return title+"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                        .set(InsuranceApply::getSignQrsNo,null)
+                        .eq(InsuranceApply::getSignQrsNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
             }
 
-
-        }else if(Constants.equalsInteger(data.getSignStatus(), Constants.TWO )){
-            //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
-            insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
-                    .set(InsuranceApply::getSignApplyNo,null)
-                    .eq(InsuranceApply::getSignApplyNo,data.getApplyNo()));
-            applyChangeMapper.update(null,new UpdateWrapper<ApplyChange>().lambda()
-                    .set(ApplyChange::getSignApplyNo,null)
-                    .eq(ApplyChange::getSignApplyNo,data.getApplyNo()));
-            insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
-                    .set(InsuranceApply::getSignQrsNo,null)
-                    .eq(InsuranceApply::getSignQrsNo,data.getApplyNo()));
-            insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
-                    .set(InsuranceApply::getSignMemberListNo,null)
-                    .eq(InsuranceApply::getSignMemberListNo,data.getApplyNo()));
-            unionApplyJoinMapper.update(null,new UpdateWrapper<UnionApply>().lambda()
-                    .set(UnionApply::getSignApplyNo,null)
-                    .eq(UnionApply::getSignApplyNo,data.getApplyNo()));
-            applyChangeMapper.update(null,new UpdateWrapper<ApplyChange>().lambda()
-                    .set(ApplyChange::getSignMemberListNo,null)
-                    .eq(ApplyChange::getSignMemberListNo,data.getApplyNo()));
-            unionChangeJoinMapper.update(null,new UpdateWrapper<UnionChange>().lambda()
-                    .set(UnionChange::getSignApplyNo,null)
-                    .eq(UnionChange::getSignApplyNo,data.getApplyNo()));
         }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
+    }
+
+    /**
+     * 鎶曚繚鐩翠繚鐢宠绛剧讲
+     * @param path
+     * @param data
+     * @return
+     */
+    private String dealXBTBBiz(String path, NotifyDataReq data,String title) {
+        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(Solutions::getType,Constants.ZERO)
+                        .eq(InsuranceApply::getSignApplyNo,data.getApplyNo())
+                        .last("limit 1" ));
+        if(model == null){
+            return null;
+        }
+        if(  Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())){
+            //瀹屾垚绛剧讲宸插畬鎴愭搷浣�
+            if(Constants.equalsInteger(data.getSignStatus(), Constants.THREE )){
+                String link = signService.linkFile(data.getApplyNo());
+                String fileUrl = uploadSignFile(link);
+                if(StringUtils.isBlank(fileUrl)){
+                    //濡傛灉涓嬭浇澶辫触锛屾竻闄ゅ悎鍚岋紝涓嬫绛剧珷閲嶆柊鐢熸垚鏂板悎鍚�
+                    return title + "鍚堝悓涓嬭浇澶辫触锛岀瓑寰呬笅娆℃帹閫佸鐞�";
+                }
+                uploadSignedFileDo(model,fileUrl,path+fileUrl);
+                return title +"鐘舵�佸鐞嗘垚鍔�";
+            }else{
+                //濡傛灉宸叉嫆绛撅紝娓呴櫎鍚堝悓锛屼笅娆$绔犻噸鏂扮敓鎴愭柊鍚堝悓
+                insuranceApplyMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                        .set(InsuranceApply::getSignApplyNo,null)
+                        .eq(InsuranceApply::getSignApplyNo,data.getApplyNo()));
+                return title+"鍚堝悓鎷掔澶勭悊鎴愬姛";
+            }
+
+        }
+        return  title+"鐘舵�佸凡娴佽浆锛屼笉鍋氬鐞�";
     }
 
 
-    @Override
-    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer uploadToubaodan(InsuranceApply insuranceApply) {
-        if(insuranceApply.getId() == null
-                || insuranceApply.getToubaodanFile() == null
-                ||StringUtils.isBlank( insuranceApply.getToubaodanFile() .getFileurl())
-                ||StringUtils.isBlank( insuranceApply.getToubaodanFile() .getName())){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
-        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
-            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-        if(!(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.UPLOAD.getKey())
-                || Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey())
-                || Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.PLATFORM_CHECK_PASS.getKey()))){
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
-        }
-
-        Solutions solutions = solutionsMapper.selectById(model.getSolutionId());
-        if(Objects.isNull(solutions)){
-            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈡柟妗堜俊鎭�");
-        }
-
-        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        InsuranceApply update = new InsuranceApply();
-        update.setEditDate(new Date());
-        update.setEditor(user.getId());
-        update.setStatus(Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey());
-        update.setCheckDate(update.getEditDate());
-        update.setCheckInfo(insuranceApply.getCheckInfo());
-        update.setCheckUserId(user.getId());
-        update.setId(model.getId());
-        insuranceApplyMapper.updateById(update);
-
-        multifileMapper.update(null,new UpdateWrapper<Multifile>().lambda()
-                .eq(Multifile::getIsdeleted,Constants.ZERO)
-                .eq(Multifile::getObjType,Constants.MultiFile.BD_APPLY_PDF.getKey())
-                .eq(Multifile::getObjId,update.getId())
-                .set(Multifile::getIsdeleted,Constants.ONE)
-                .set(Multifile::getEditDate,update.getEditDate())
-                .set(Multifile::getEditor,update.getEditor())
-        );
-        insuranceApply.getToubaodanFile().setIsdeleted(Constants.ZERO);
-        insuranceApply.getToubaodanFile().setCreator(user.getId());
-        insuranceApply.getToubaodanFile().setObjId(update.getId());
-        insuranceApply.getToubaodanFile().setCreateDate(update.getEditDate());
-        insuranceApply.getToubaodanFile().setObjType(Constants.MultiFile.BD_APPLY_PDF.getKey());
-        insuranceApply.getToubaodanFile().setType(Constants.TWO);
-        multifileMapper.insert(insuranceApply.getToubaodanFile());
-        update.setToubaodanFile(insuranceApply.getToubaodanFile());
-
-        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.WAIT_SIGNATURE;
-        String info =applyLogType.getInfo();
-//        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);
-
-        //鍒犻櫎鍏朵粬寰呭姙
-        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.INSURANCE_APPLY;
-        noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,insuranceApply.getId()));
-
-        Notices notices = new Notices(noticeObjectType,Constants.ONE,model.getId(),solutions.getName(),
-                model.getCompanyId(), Constants.NoticeType.ONE);
-        noticesMapper.insert(notices);
-
-        return  1;
-
-    }
 
     /**
      * 瀹℃牳閫氳繃鎴栬�呬笉閫氳繃
@@ -1425,7 +1529,7 @@
      */
     @Override
     @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public Integer check(InsuranceApply insuranceApply) {
+    public Integer check(InsuranceApply insuranceApply,UnionApplyServiceImpl unionApplyServiceImpl) {
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         if(insuranceApply.getId() == null){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST);
@@ -1444,9 +1548,6 @@
                 throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
             }
         }else{
-            if(!Constants.equalsObject(user.getType(),Constants.TWO)){
-                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炲晢鎴风鏃犳硶杩涜璇ユ搷浣�");
-            }
             //濮旀墭淇濆緟绛剧讲銆佸緟瀹℃牳鍙繘琛岄��鍥炴搷浣�
             if(!(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey())
                     ||Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey())
@@ -1505,8 +1606,122 @@
         }
         ApplyLog log = new ApplyLog(update,applyLogType.getName(),info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
         applyLogMapper.insert(log);
-        return  1;
+        //2024骞�11鏈�8鏃�16:12:43 濡傛灉鏄鎵樻姇淇濆崟鍒欒嚜鍔ㄥ垱寤哄悎骞跺崟鏁版嵁
+        if(Constants.equalsInteger(insuranceApply.getDealBackApply(),Constants.ZERO) && Constants.equalsObject(solutions.getType(),Constants.ONE)){
+            SaveUnionApplyDTO saveUnionApplyDTO = new SaveUnionApplyDTO();
+            List<Integer> applyIds = new ArrayList<Integer>();
+            applyIds.add(update.getId());
+            saveUnionApplyDTO.setApplyIds(applyIds);
+            saveUnionApplyDTO.setBaseSolutionId(solutions.getBaseId());
+            saveUnionApplyDTO.setStartDate(model.getStartTime());
+            saveUnionApplyDTO.setEndDate(model.getEndTime());
+            unionApplyServiceImpl.merge(saveUnionApplyDTO);
+        }
 
+        return  1;
+    }
+
+    /**
+     * 澶嶅 瀹℃牳閫氳繃鎴栬�呬笉閫氳繃
+     * @param insuranceApply
+     * @return
+     */
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public Integer reexamineCheck(InsuranceApply insuranceApply) {
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(insuranceApply.getId() == null){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        InsuranceApply model = insuranceApplyMapper.selectById(insuranceApply.getId());
+
+        if(model == null ||!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        Solutions solutions = solutionsMapper.selectById(model.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈡柟妗堜俊鎭�");
+        }
+        if(Constants.equalsObject(solutions.getType(),Constants.ZERO)){
+            if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.REEXAMINE.getKey())){
+                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
+            }
+        }else{
+            if(Constants.equalsObject(user.getType(),Constants.ONE)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"浼佷笟鐢ㄦ埛鏃犳硶杩涜璇ユ搷浣�");
+            }
+            //濡傛灉鏄晢鎴风锛屽垯鍙兘鐢辨寚瀹氫汉杩涜澶勭悊
+            if(Constants.equalsInteger(user.getType(),Constants.TWO)){
+                if(!Constants.equalsInteger(model.getRetrialId(),user.getId())){
+                    throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炴偍鐨勫瀹℃暟鎹紝鏃犳硶杩涜瀹℃壒");
+                }
+            }else{
+                //濡傛灉鏄钩鍙扮锛屾牴鎹汉鍛樼被鍨嬪鐞� 濡傛灉鏄浐瀹氫汉鍛樺垯涓嶉檺鍒� 鍏朵粬浜哄憳闇�瑕佹瘮瀵�
+                if(!user.getFixed()){
+                    if(!Constants.equalsInteger(model.getRetrialId(),user.getId())){
+                        throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炴偍鐨勫瀹℃暟鎹紝鏃犳硶杩涜瀹℃壒");
+                    }
+                }
+            }
+            //濮旀墭淇濆緟绛剧讲銆佸緟瀹℃牳鍙繘琛岄��鍥炴搷浣�
+            if(!(Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey())
+                    ||Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE.getKey())
+                    ||Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_COMPANY_MEMBER_LIST_SIGNATURE.getKey())
+            )){
+                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
+            }
+        }
+
+        Constants.ApplyLogType applyLogType = null;
+        InsuranceApply update = new InsuranceApply();
+        update.setEditDate(new Date());
+        update.setEditor(user.getId());
+        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());
+            if(Constants.equalsObject(solutions.getType(),Constants.ONE)){
+                update.setStatus(Constants.InsuranceApplyStatus.WTB_RETURN.getKey());
+            }
+        }else{
+            applyLogType = Constants.ApplyLogType.PLATFORM_CHECK_PASS;
+            if(Constants.equalsObject(solutions.getType(),Constants.ONE)){
+                update.setStatus(Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey());
+            }else{
+                update.setStatus(Constants.InsuranceApplyStatus.SIGNATURE.getKey());
+            }
+        }
+        insuranceApplyMapper.updateById(update);
+
+        //瀛樺偍寰呭姙淇℃伅
+        Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.INSURANCE_APPLY;
+        if(Constants.equalsObject(solutions.getType(),Constants.ZERO)) {
+            //鍒犻櫎鍏朵粬寰呭姙
+            noticesMapper.delete(new QueryWrapper<Notices>().lambda()
+                    .eq(Notices::getObjType, noticeObjectType.getKey())
+                    .ne(Notices::getType, Constants.NoticeType.SIX.getStatus())
+                    .eq(Notices::getObjId, model.getId()));
+        }else{
+            //鍒犻櫎鍏ㄩ儴寰呭姙
+            noticesMapper.delete(new QueryWrapper<Notices>().lambda()
+                    .eq(Notices::getObjType, noticeObjectType.getKey())
+                    .eq(Notices::getObjId, model.getId()));
+        }
+
+
+        String info =applyLogType.getInfo();
+        if(StringUtils.isNotBlank(update.getCheckInfo())){
+            info = info.replace("${param}", update.getCheckInfo());
+        }else{
+            info = null;
+        }
+        ApplyLog log = new ApplyLog(update,applyLogType.getName(),info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
+        applyLogMapper.insert(log);
+        return  1;
     }
 
 
@@ -1517,14 +1732,18 @@
             || Objects.isNull(insuranceApply.getSolutionId())
             || Objects.isNull(insuranceApply.getApplyStartTime())
             || Objects.isNull(insuranceApply.getApplyEndTime())
+            || Objects.isNull(insuranceApply.getCompanyId())
             || !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(),"鐢ㄦ埛绫诲瀷閿欒锛氶潪浼佷笟鐢ㄦ埛鏃犳硶杩涜璇ユ搷浣�");
+
+        Company company = companyMapper.selectById(insuranceApply.getCompanyId());
+        if(Objects.isNull(company) || Constants.equalsInteger(company.getType(),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(),"鏈煡璇㈠埌鏂规淇℃伅");
@@ -1534,15 +1753,15 @@
         }
         if(solutions.getValidType().equals(Constants.ZERO)){
             if(DateUtil.getMontageDate(
-                    DateUtil.addDaysToDate(new Date(),solutions.getValidType()),0).getTime()>insuranceApply.getApplyStartTime().getTime()){
+                    DateUtil.addDaysToDate(new Date(),solutions.getValidTypeNum()),1).getTime()
+                    >insuranceApply.getApplyStartTime().getTime()){
                 throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"淇濆崟鐢熸晥璧锋湡閿欒");
             }
         }else{
-            if(DateUtil.getNextMonthFirst(new Date()).getTime()>insuranceApply.getApplyStartTime().getTime()){
+            if(DateUtil.getMontageDate(DateUtil.getNextMonthFirst(new Date()),1).getTime()>insuranceApply.getApplyStartTime().getTime()){
                 throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"淇濆崟鐢熸晥璧锋湡閿欒");
             }
         }
-
         List<ApplyDetail> applyDetailList = insuranceApply.getApplyDetailList();
         //鍒ゆ柇鏄惁瀛樺湪閲嶅淇℃伅
         List<String> idCardList = applyDetailList.stream().map(i->i.getIdcardNo()).collect(Collectors.toList());
@@ -1552,14 +1771,13 @@
         }
         Constants.InsuranceApplyStatus insuranceApplyStatus = Constants.InsuranceApplyStatus.UPLOAD;
         if(solutions.getType().equals(Constants.ONE)){
-            insuranceApplyStatus = Constants.InsuranceApplyStatus.WTB_UPLOAD;
+            insuranceApplyStatus = Constants.InsuranceApplyStatus.WTB_COMPANY_APPLY_SIGNATURE;
         }
         insuranceApply.setCreateDate(new Date());
         insuranceApply.setCreator(loginUserInfo.getId());
         insuranceApply.setEditor(loginUserInfo.getId());
         insuranceApply.setEditDate(new Date());
         insuranceApply.setIsdeleted(Constants.ZERO);
-        insuranceApply.setCompanyId(loginUserInfo.getCompanyId());
         insuranceApply.setCheckInfo(insuranceApplyStatus.getName());
         insuranceApply.setStartTime(insuranceApply.getApplyStartTime());
         insuranceApply.setCheckDate(new Date());
@@ -1567,26 +1785,24 @@
         insuranceApply.setCheckUserId(loginUserInfo.getId());
         insuranceApply.setStatus(insuranceApplyStatus.getKey());
         insuranceApply.setUnionApplyTbdStatus(Constants.ZERO);
-
         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());
+        insuranceApply.setFinalEndTime(countCyclePriceVO.getEndDate());
         insuranceApplyMapper.insert(insuranceApply);
-
-
         //澶勭悊涓嬬骇鏁版嵁
-        this.dealApplyDetailData(insuranceApply,solutions,applyDetailList,loginUserInfo,countCyclePriceVO);
+        this.dealApplyDetailData(insuranceApply,solutions,applyDetailList,loginUserInfo,countCyclePriceVO,true);
         InsuranceApply updBean = new InsuranceApply();
         updBean.setId(insuranceApply.getId());
         updBean.setFee(applyDetailList.stream().map(ApplyDetail::getFee).reduce(BigDecimal.ZERO,BigDecimal::add));
         insuranceApplyMapper.updateById(updBean);
+
         //瀛樺偍鏃ュ織鏁版嵁
         Constants.ApplyLogType applyLogType = Constants.ApplyLogType.UPLOAD;
         String info =applyLogType.getInfo();
-//        info = info.replace("${param}", update.getCheckInfo());
         ApplyLog log = new ApplyLog(insuranceApply,applyLogType.getName(),info,insuranceApply.getId(),applyLogType.getKey(),null, null);
         applyLogMapper.insert(log);
         
@@ -1614,11 +1830,8 @@
                 noticesMapper.insert(shopNotices);
             }
         }
-
         return insuranceApply.getId();
     }
-
-
 
 
     @Override
@@ -1680,7 +1893,7 @@
         }
 
         //澶勭悊涓嬬骇鏁版嵁
-        this.dealApplyDetailData(insuranceApply,solutions,applyDetailList,loginUserInfo,countCyclePriceVO);
+        this.dealApplyDetailData(insuranceApply,solutions,applyDetailList,loginUserInfo,countCyclePriceVO,false);
         insuranceApply.setFee(applyDetailList.stream().map(ApplyDetail::getFee).reduce(BigDecimal.ZERO,BigDecimal::add));
         insuranceApplyMapper.updateById(insuranceApply);
         //瀛樺偍鏃ュ織鏁版嵁
@@ -1706,41 +1919,114 @@
 
 
 
-    public void dealApplyDetailData(InsuranceApply insuranceApply,Solutions solutions,List<ApplyDetail> applyDetailList,LoginUserInfo loginUserInfo,CountCyclePriceVO  countCyclePriceVO){
-        //鏌ヨ淇濋櫓鏂规涓嬬殑鎵�鏈夋淳閬e崟浣�
-        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(),"鏁版嵁寮傚父锛氫繚闄╂柟妗堜笅鏈煡璇㈠埌娲鹃仯鍗曚綅");
-        }
-        //鏌ヨ鎵�鏈夋淳閬e崟浣嶄笅鐨勫伐绉�
-        List<Integer> duSolutionIdList = duSolutionList.stream().map(i->i.getId()).collect(Collectors.toList());
-        List<DuWorktype> duWorktypeList = duWorktypeMapper.selectList(new QueryWrapper<DuWorktype>().lambda()
-                .eq(DuWorktype::getIsdeleted,Constants.ZERO)
-                .eq(DuWorktype::getStatus,Constants.ONE)
-                .in(DuWorktype::getDuSolutionId,duSolutionIdList));
-        if(!CollectionUtils.isNotEmpty(duWorktypeList)){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏁版嵁寮傚父锛氫繚闄╂柟妗堜笅鏈煡璇㈠埌宸ョ淇℃伅");
-        }
 
+    private static Logger logger = LoggerFactory.getLogger(InsuranceApplyServiceImpl.class);
+
+    public void dealApplyDetailData(InsuranceApply insuranceApply,Solutions solutions,List<ApplyDetail> applyDetailList,
+                                    LoginUserInfo loginUserInfo,CountCyclePriceVO  countCyclePriceVO,Boolean checkNewData){
+        Long start = System.currentTimeMillis();
+        logger.error("澶勭悊淇濆崟鏁版嵁寮�濮嬫椂闂�:=========================>"+start);
+        //2024骞�11鏈�6鏃�15:01:34  鍔犲叆  鏂规閰嶇疆浜嗘湁娲鹃仯鍗曚綅 鎵嶄細鍘婚獙璇佹淳閬e崟浣嶆暟鎹�
+        List<DuSolution>  duSolutionList = new ArrayList<>();
+        List<DuWorktype> duWorktypeList = new ArrayList<>();
+        List<Integer> worktypeIdList = new ArrayList<>();
+        if(Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)){
+            //鏌ヨ淇濋櫓鏂规涓嬬殑鎵�鏈夋淳閬e崟浣�
+            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(checkNewData,DispatchUnit::getDataType,Constants.TWO)
+                    .eq(DuSolution::getStatus,Constants.ONE)
+                    .eq(DuSolution::getSolutionId,insuranceApply.getSolutionId())
+                    .apply(" t1.BASE_ID in ( select du.id from dispatch_unit du where du.STATUS = 0 and du.ISDELETED = 0 ) ")
+            );
+            if(!CollectionUtils.isNotEmpty(duSolutionList)){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝淇濋櫓鏂规涓嬫湭鏌ヨ鍒版淳閬e崟浣嶄俊鎭紝璇风‘淇濇淳閬e崟浣嶅拰宸ヤ綔閰嶇疆骞跺鏍搁�氳繃锛�");
+            }
+            //鏌ヨ鎵�鏈夋淳閬e崟浣嶄笅鐨勫伐绉�
+            List<Integer> duSolutionIdList = duSolutionList.stream().map(i->i.getId()).collect(Collectors.toList());
+            duWorktypeList = duWorkTypeJoinMapper.selectJoinList(DuWorktype.class,new MPJLambdaWrapper<DuWorktype>()
+                    .selectAll(DuWorktype.class)
+                    .innerJoin(Worktype.class,Worktype::getId,DuWorktype::getWorkTypeId)
+                    .eq(DuWorktype::getIsdeleted,Constants.ZERO)
+                    .eq(DuWorktype::getStatus,Constants.ONE)
+                    .eq(checkNewData,Worktype::getDataType,Constants.TWO)
+                    .in(DuWorktype::getDuSolutionId,duSolutionIdList));
+            if(!CollectionUtils.isNotEmpty(duWorktypeList)){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝淇濋櫓鏂规涓嬫湭鏌ヨ鍒板伐绉嶄俊鎭紝璇风‘淇濇淳閬e崟浣嶅拰宸ヤ綔閰嶇疆骞跺鏍搁�氳繃锛�");
+            }
+            worktypeIdList = duWorktypeList.stream().map(i->i.getWorkTypeId()).collect(Collectors.toList());
+        }else{
+            //鏌ヨ鏂规涓嬫墍鏈夊伐绉嶆暟鎹�
+            List<SolutionWorktype> solutionWorktypeList = solutionWorktypeJoinMapper.selectList(new QueryWrapper<SolutionWorktype>().lambda().eq(SolutionWorktype::getSolutionId,solutions.getId()));
+            if(CollectionUtils.isEmpty(solutionWorktypeList)){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝淇濋櫓鏂规涓嬫湭鏌ヨ鍒板伐绉嶄俊鎭�");
+            }
+            worktypeIdList = solutionWorktypeList.stream().map(i->i.getWorktypeId()).collect(Collectors.toList());
+        }
         if(CollectionUtils.isNotEmpty(applyDetailList)){
+            List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda()
+                    .eq(Member::getCompanyId,insuranceApply.getCompanyId())
+                    .eq(Member::getIsdeleted,Constants.ZERO));
+            List<String> idCodeList = new ArrayList<>();
+            for (ApplyDetail applyDetail:applyDetailList) {
+                idCodeList.add(applyDetail.getIdcardNo());
+            }
+            List<ApplyDetail> allDetailList =   this.getMemberSolutionList(solutions.getParentId(),idCodeList, insuranceApply.getStartTime()
+                    ,insuranceApply.getEndTime(),insuranceApply.getId());
+            List<Member> addMemberList = new ArrayList<>();
             for (int i = 0; i < applyDetailList.size(); i++) {
+                ApplyDetail applyDetail = applyDetailList.get(i);
+                Member member = null;
+                if(CollectionUtils.isNotEmpty(memberList)){
+                    Optional<Member>  optional = memberList.stream().filter(m->m.getIdcardNo().equals(applyDetail.getIdcardNo())).findFirst();
+                    if(optional.isPresent()){
+                        member = optional.get();
+                    }
+                }
+                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()));
+                    if(!IdcardUtil.isValidCard(applyDetail.getIdcardNo())){
+                        throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鎶曚繚鍛樺伐銆�"+member.getName()+"銆戣韩浠借瘉淇℃伅銆�"+applyDetail.getIdcardNo()+"銆戦敊璇�");
+                    }
+                    member.setIdcardNo(applyDetail.getIdcardNo());
+                    member.setApplyId(insuranceApply.getId());
+                    member.setDuId(applyDetail.getDuId());
+                    member.setWorktypeId(applyDetail.getWorktypeId());
+                    addMemberList.add(member);
+                }
+                //鏌ヨ浜哄憳淇℃伅鏄惁瀛樺湪鐩稿悓鐨勬柟妗堜笅鏄惁瀛樺湪 鍐茬獊鏁版嵁
+                this.checkMemberSolution( applyDetail.getIdcardNo(),allDetailList,applyDetail.getMemberName());
+//                this.checkMemberSolutionOld(solutions.getParentId(),member.getIdcardNo(),member.getName(),insuranceApply.getStartTime(),insuranceApply.getEndTime(),insuranceApply.getId());
+            }
+            if(CollectionUtils.isNotEmpty(addMemberList)){
+                memberJoinMapper.insert(addMemberList);
+            }
+            memberList.addAll(addMemberList);
+            for (int i = 0; i < applyDetailList.size(); i++) {
+                Long singlStart = System.currentTimeMillis();
+                logger.error("澶勭悊淇濆崟鍗曟潯鏁版嵁寮�濮嬫椂闂�:=========================>"+singlStart);
                 ApplyDetail applyDetail = applyDetailList.get(i);
                 if(Objects.isNull(applyDetail)
                         ||StringUtils.isBlank(applyDetail.getIdcardNo())
                         ||StringUtils.isBlank(applyDetail.getMemberName())
-                        ||Objects.isNull(applyDetail.getDuId())
+                        || (Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)&&Objects.isNull(applyDetail.getDuId()))
                         ||Objects.isNull(applyDetail.getWorktypeId())
                 ){
-                    throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鎶曚繚鍛樺伐淇℃伅鏁版嵁缂哄け");
+                    throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鎶曚繚鍛樺伐淇℃伅鏁版嵁缂哄け锛岃鎸夌収瑕佹眰濉啓鍛樺伐鐨勬湁鏁堜俊鎭紒");
                 }
+                applyDetail.setId(null);
+                applyDetail.setChangeStatus(Constants.ZERO);
                 applyDetail.setCreateDate(new Date());
                 applyDetail.setCreator(loginUserInfo.getId());
                 applyDetail.setIsdeleted(Constants.ZERO);
@@ -1748,37 +2034,30 @@
                 applyDetail.setEndTime(insuranceApply.getApplyEndTime());
                 applyDetail.setSortnum(i);
                 applyDetail.setApplyId(insuranceApply.getId());
-                Member member = new Member();
+
+                //鏍规嵁鍛樺伐韬唤璇佽繘琛屽垽鏂勾榫�
+                long age = Constants.getAgeByIdCard(applyDetail.getIdcardNo());
+                if(Objects.isNull(age)
+                        || age > solutions.getMaxAge()
+                        || age < solutions.getMinAge()){
+                    throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"銆�"+applyDetail.getMemberName()+"銆戝憳宸ュ勾榫勮秴鍑烘柟妗堥厤缃�,鏂规閰嶇疆銆�"+solutions.getMinAge()+" - "+solutions.getMaxAge()+"銆戯紒");
+                }
+
+                Member member = null;
                 if(Objects.isNull(applyDetail.getMemberId())){
+                    if(CollectionUtils.isNotEmpty(memberList)){
+                        Optional<Member>  optional = memberList.stream().filter(m->m.getIdcardNo().equals(applyDetail.getIdcardNo())).findFirst();
+                        if(optional.isPresent()){
+                            member = optional.get();
+                        }
+                    }
                     //鏌ヨ鏄惁瀛樺湪璇ョ敤鎴�
-                    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.setStartTime(applyDetail.getStartTime());
-                        member.setEndTime(applyDetail.getEndTime());
-                        member.setDuId(applyDetail.getDuId());
-                        member.setWorktypeId(applyDetail.getWorktypeId());
-                        memberMapper.insert(member);
-                    }else{
+                    if(!Objects.isNull(member)){
                         member.setApplyId(insuranceApply.getId());
                         member.setDuId(applyDetail.getDuId());
                         member.setWorktypeId(applyDetail.getWorktypeId());
-                        member.setStartTime(applyDetail.getStartTime());
-                        member.setEndTime(applyDetail.getEndTime());
                         memberMapper.updateById(member);
+                        applyDetail.setMemberName(member.getName());
                     }
                 }else{
                     member = memberMapper.selectById(applyDetail.getMemberId());
@@ -1788,17 +2067,8 @@
                     member.setApplyId(insuranceApply.getId());
                     member.setDuId(applyDetail.getDuId());
                     member.setWorktypeId(applyDetail.getWorktypeId());
-                    member.setStartTime(applyDetail.getStartTime());
-                    member.setEndTime(applyDetail.getEndTime());
                     memberMapper.updateById(member);
-                }
-
-                //鏍规嵁鍛樺伐韬唤璇佽繘琛屽垽鏂勾榫�
-                long age = Constants.getAgeByIdCard(member.getIdcardNo());
-                if(Objects.isNull(age)
-                    || age > solutions.getMaxAge()
-                    || age < solutions.getMinAge()){
-                    throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"銆�"+applyDetail.getMemberName()+"銆戝憳宸ュ勾榫勮秴鍑烘柟妗堥厤缃�,鏂规閰嶇疆銆�"+solutions.getMinAge()+" - "+solutions.getMaxAge()+"銆戯紒");
+                    applyDetail.setMemberName(member.getName());
                 }
                 applyDetail.setMemberId(member.getId());
                 applyDetail.setIdcardNo(member.getIdcardNo());
@@ -1808,24 +2078,214 @@
                 //鑾峰彇璁$畻鎬诲ぉ鏁�
                 Integer maxDays = DateUtil.calculateBetween(applyDetail.getStartTime(),applyDetail.getEndTime(),0);
                 if(Constants.equalsInteger(maxDays,0)||Objects.isNull(applyDetail.getFee())){
-                    throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鎶曚繚淇℃伅寮傚父锛氭�诲ぉ鏁颁笌鎬婚噾棰濋敊璇�");
+                    throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鎶曚繚淇℃伅寮傚父锛氭姇淇濇�诲ぉ鏁颁笌鎬婚噾棰濋敊璇�");
                 }
                 applyDetail.setPrice(
-                        applyDetail.getFee().divide(new BigDecimal(maxDays),2,RoundingMode.HALF_UP)
+                        applyDetail.getFee().divide(new BigDecimal(maxDays),7,RoundingMode.HALF_UP)
                 );
                 //楠岃瘉娲鹃仯鍗曚綅淇℃伅鏄惁瀛樺湪
-                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()+"銆戝憳宸ユ淳閬e崟浣嶆湭鏌ヨ鍒帮紒");
+                if(Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)){
+                    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()+applyDetail.getIdcardNo()+"銆戝憳宸ユ淳閬e崟浣嶆湭鏌ヨ鍒帮紒");
+                    }
                 }
-                if(duWorktypeList.stream().filter(d->d.getWorkTypeId().equals(applyDetail.getWorktypeId()))
+                if(worktypeIdList.stream().filter(d->Constants.equalsInteger(d,applyDetail.getWorktypeId()))
                         .collect(Collectors.toList()).size()<=Constants.ZERO){
-                    throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"銆�"+applyDetail.getMemberName()+"銆戝憳宸ュ伐绉嶄俊鎭湭鏌ヨ鍒帮紒");
+                    throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"銆�"+applyDetail.getMemberName()+applyDetail.getIdcardNo()+"銆戝憳宸ュ伐绉嶄俊鎭湭鏌ヨ鍒帮紒");
                 }
+                Long singlEnd = System.currentTimeMillis();
+                logger.error("澶勭悊淇濆崟鍗曟潯鏁版嵁缁撴潫鏃堕棿:=========================>"+singlEnd+";鑰楁椂锛�====銆�"+(singlStart-singlEnd));
             }
-            applyDetailJoinMapper.insertBatchSomeColumn(applyDetailList);
+            Long end = System.currentTimeMillis();
+            logger.error("澶勭悊鍗曟暟鎹粨鏉熸椂闂�:=========================>"+end +";鑰楁椂锛�====銆�"+(end-start));
+            applyDetailMapper.insert(applyDetailList);
         }
     }
 
+
+    /**
+     * 鏌ヨ 浼氬憳淇℃伅鍦ㄦ柟妗堜笅鏄惁瀛樺湪鍐茬獊鏁版嵁
+     */
+    public void checkMemberSolution(String idCode,List<ApplyDetail> allDetailList,String memberName){
+        List<ApplyDetail> applyDetailList = getMemberSolutionListByIdcode(idCode,allDetailList);
+        if(applyDetailList.size() >Constants.ZERO){
+            String companyName = applyDetailList.get(Constants.ZERO).getCompanyName();
+            if(StringUtils.isNotBlank(companyName)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝凡鍦ㄣ��"+companyName+"銆戝瓨鍦ㄤ繚闄�,璇疯仈绯诲鏈嶇‘璁�");
+            }else{
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝湪璇ヤ繚闄╂柟妗堜笅宸插瓨鍦ㄦ姇淇濊褰曪紝鏃犳硶杩涜璇ユ搷浣�");
+            }
+
+        };
+    }
+
+//    @Override
+//    public void checkMemberSolutionOld(Integer solutionParentId,String idCode, String memberName, Date startTime,Date endTime,Integer applyId){
+//        List<ApplyDetail> applyDetailList = new ArrayList<>();
+//        try {
+//            applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,
+//                    new MPJLambdaWrapper<ApplyDetail>()
+//                            .selectAll(ApplyDetail.class)
+//                            .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode)
+//                            .selectAs(Company::getName,ApplyDetail::getCompanyName)
+//                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+//                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+//                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+//                            .eq(ApplyDetail::getIdcardNo,idCode)
+//                            .eq(ApplyDetail::getIsdeleted,Constants.ZERO)
+//                            .eq(Solutions::getParentId,solutionParentId)
+//                            .ne(Objects.nonNull(applyId),InsuranceApply::getId,applyId)
+//                            .notIn(InsuranceApply::getStatus
+//                                    ,Constants.InsuranceApplyStatus.FAIL_RETURN.getKey()
+//                                    ,Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey()
+//                                    ,Constants.InsuranceApplyStatus.CLOSE.getKey()
+//                                    ,Constants.InsuranceApplyStatus.WTB_RETURN.getKey()
+//                                    ,Constants.InsuranceApplyStatus.WTB_CLOSED.getKey() )
+//                            .apply(" ( " +
+//                                    " '"+DateUtil.getPlusTime(startTime)+"'  <= t.start_time AND t.start_time < '"+DateUtil.getPlusTime(endTime)+"' " +
+//                                    " or " +
+//                                    "  ( '"+DateUtil.getPlusTime(startTime)+"' < t.end_time AND t.end_time < '"+DateUtil.getPlusTime(endTime)+"' )  " +
+//                                    " or " +
+//                                    " ( '"+DateUtil.getPlusTime(startTime)+"' > t.start_time AND '"+DateUtil.getPlusTime(endTime)+"' < t.end_time )" +
+//                                    " ) " ));
+//        }catch (Exception e){
+//        }
+//        if(applyDetailList.size() >Constants.ZERO){
+//            String companyName = applyDetailList.get(Constants.ZERO).getCompanyName();
+//            if(StringUtils.isNotBlank(companyName)){
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝凡鍦ㄣ��"+companyName+"銆戝瓨鍦ㄤ繚闄�,璇疯仈绯诲鏈嶇‘璁�");
+//            }else{
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝湪璇ヤ繚闄╂柟妗堜笅宸插瓨鍦ㄦ姇淇濊褰曪紝鏃犳硶杩涜璇ユ搷浣�");
+//            }
+//
+//        };
+//    }
+    private List<ApplyDetail> getMemberSolutionListByIdcode(String idCode, List<ApplyDetail> allDetailList) {
+        if(allDetailList == null || allDetailList.size()==0){
+            return  new ArrayList<>();
+        }
+        List<ApplyDetail> list = new ArrayList<>();
+        for(ApplyDetail d : allDetailList){
+            if(StringUtils.equals(d.getIdcardNo(),idCode)){
+                list.add(d);
+            }
+        }
+        return list;
+    }
+
+    public  List<ApplyDetail>  getMemberSolutionList(Integer solutionParentId,List<String> idCodeList, Date startTime,Date endTime,Integer applyId){
+        List<ApplyDetail> applyDetailList = new ArrayList<ApplyDetail>();
+        try {
+            applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,
+                    new MPJLambdaWrapper<ApplyDetail>()
+                            .selectAll(ApplyDetail.class)
+                            .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode)
+                            .selectAs(Company::getName,ApplyDetail::getCompanyName)
+                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+                            .in(ApplyDetail::getIdcardNo,idCodeList)
+                            .eq(ApplyDetail::getIsdeleted,Constants.ZERO)
+                            .eq(Solutions::getParentId,solutionParentId)
+                            .ne(Objects.nonNull(applyId),InsuranceApply::getId,applyId)
+                            .notIn(InsuranceApply::getStatus
+                                    ,Constants.InsuranceApplyStatus.FAIL_RETURN.getKey()
+                                    ,Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey()
+                                    ,Constants.InsuranceApplyStatus.CLOSE.getKey()
+                                    ,Constants.InsuranceApplyStatus.WTB_RETURN.getKey()
+                                    ,Constants.InsuranceApplyStatus.WTB_CLOSED.getKey() )
+                            .apply(" ( " +
+                                    " '"+DateUtil.getPlusTime(startTime)+"'  <= t.start_time AND t.start_time < '"+DateUtil.getPlusTime(endTime)+"' " +
+                                    " or " +
+                                    "  ( '"+DateUtil.getPlusTime(startTime)+"' < t.end_time AND t.end_time < '"+DateUtil.getPlusTime(endTime)+"' )  " +
+                                    " or " +
+                                    " ( '"+DateUtil.getPlusTime(startTime)+"' > t.start_time AND '"+DateUtil.getPlusTime(endTime)+"' < t.end_time )" +
+                                    " ) " ));
+        }catch (Exception e){
+        }
+      return applyDetailList;
+    }
+
+
+    public static void checkStaticMemberSolutionNew(Integer solutionId,Integer memberId,String memberIdCard,String memberName,Date startTime,
+                                                 Date endTime,ApplyDetailJoinMapper applyDetailJoinMapper){
+        List<ApplyDetail> applyDetailList = new ArrayList<ApplyDetail>();
+        try {
+            applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,
+                    new MPJLambdaWrapper<ApplyDetail>()
+                            .selectAll(ApplyDetail.class)
+                            .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode)
+                            .selectAs(Company::getName,ApplyDetail::getCompanyName)
+                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+                            .eq(ApplyDetail::getIdcardNo,memberIdCard)
+                            .eq(Solutions::getBaseId,solutionId)
+                            .eq(ApplyDetail::getIsdeleted,Constants.ZERO)
+                            .notIn(InsuranceApply::getStatus
+                                    ,Constants.InsuranceApplyStatus.CLOSE.getKey()
+                                    ,Constants.InsuranceApplyStatus.WTB_CLOSED.getKey() )
+                            .apply(" ( " +
+                                    " '"+DateUtil.getPlusTime(startTime)+"'  <= t.start_time AND t.start_time < '"+DateUtil.getPlusTime(endTime)+"' " +
+                                    " or " +
+                                    "  ( '"+DateUtil.getPlusTime(startTime)+"' < t.end_time AND t.end_time < '"+DateUtil.getPlusTime(endTime)+"' )  " +
+                                    " or " +
+                                    " ( '"+DateUtil.getPlusTime(startTime)+"' > t.start_time AND '"+DateUtil.getPlusTime(endTime)+"' < t.end_time )" +
+                                    " ) " ));
+        }catch (Exception e){
+
+        }
+        if(applyDetailList.size() >Constants.ZERO){
+            String companyName = applyDetailList.get(Constants.ZERO).getCompanyName();
+            String idCode = applyDetailList.get(Constants.ZERO).getIdcardNo();
+            if(StringUtils.isNotBlank(companyName)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝凡鍦ㄣ��"+companyName+"銆戝瓨鍦ㄤ繚闄�,璇疯仈绯诲鏈嶇‘璁�");
+            }else{
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝湪璇ヤ繚闄╂柟妗堜笅宸插瓨鍦ㄦ姇淇濊褰曪紝鏃犳硶杩涜璇ユ搷浣�");
+            }
+        };
+
+    }
+
+    public static void checkStaticMemberSolution(Integer solutionId,Integer memberId,String memberIdCard,String memberName,Date startTime,
+                                                 Date endTime,ApplyDetailJoinMapper applyDetailJoinMapper){
+        List<ApplyDetail> applyDetailList = new ArrayList<ApplyDetail>();
+        try {
+            applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,
+                    new MPJLambdaWrapper<ApplyDetail>()
+                            .selectAll(ApplyDetail.class)
+                            .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode)
+                            .selectAs(Company::getName,ApplyDetail::getCompanyName)
+                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+                            .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                            .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+                            .eq(ApplyDetail::getIdcardNo,memberIdCard)
+                            .eq(Solutions::getBaseId,solutionId)
+                            .eq(ApplyDetail::getIsdeleted,Constants.ZERO)
+                            .notIn(InsuranceApply::getStatus
+                                    ,Constants.InsuranceApplyStatus.CLOSE.getKey()
+                                    ,Constants.InsuranceApplyStatus.WTB_CLOSED.getKey() )
+                            .apply(" ( " +
+                                    " '"+DateUtil.getPlusTime(startTime)+"'  <= t.start_time AND t.start_time < '"+DateUtil.getPlusTime(endTime)+"' " +
+                                    " or " +
+                                    "  ( '"+DateUtil.getPlusTime(startTime)+"' < t.end_time AND t.end_time < '"+DateUtil.getPlusTime(endTime)+"' )  " +
+                                    " or " +
+                                    " ( '"+DateUtil.getPlusTime(startTime)+"' > t.start_time AND '"+DateUtil.getPlusTime(endTime)+"' < t.end_time )" +
+                                    " ) " ));
+        }catch (Exception e){
+
+        }
+        if(applyDetailList.size() >Constants.ZERO){
+            String companyName = applyDetailList.get(Constants.ZERO).getCompanyName();
+            String idCode = applyDetailList.get(Constants.ZERO).getIdcardNo();
+            if(StringUtils.isNotBlank(companyName)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝凡鍦ㄣ��"+companyName+"銆戝瓨鍦ㄤ繚闄�,璇疯仈绯诲鏈嶇‘璁�");
+            }else{
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ュ憳宸ャ��"+memberName+" "+idCode+"銆戝湪璇ヤ繚闄╂柟妗堜笅宸插瓨鍦ㄦ姇淇濊褰曪紝鏃犳硶杩涜璇ユ搷浣�");
+            }
+        };
+
+    }
 
     @Override
     public void deleteById(Integer id) {
@@ -1883,18 +2343,21 @@
             return  new ArrayList<>();
         }
         List<Integer> statusList = Constants.InsuranceApplyStatus.getKesByStatus(collectStatus);
-        if(collectStatus.equals(Constants.ApplyCollectStatus.DCD.getKey())){
+        if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.DCD.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBDCD.getKey()));
-        }else if(collectStatus.equals(Constants.ApplyCollectStatus.DSP.getKey())){
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.DSP.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBDSH.getKey()));
-        }else if(collectStatus.equals(Constants.ApplyCollectStatus.BZZ.getKey())){
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.BZZ.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBBZZ.getKey()));
-        }else if(collectStatus.equals(Constants.ApplyCollectStatus.YTH.getKey())){
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.YTH.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBYTH.getKey()));
-        }else if(collectStatus.equals(Constants.ApplyCollectStatus.YGB.getKey())){
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.YGB.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBYGB.getKey()));
-        }else if(collectStatus.equals(Constants.ApplyCollectStatus.DQYQZ.getKey())){
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.DQYQZ.getKey())){
             statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBDQS.getKey()));
+        }else if(Constants.equalsInteger(collectStatus,Constants.ApplyCollectStatus.YGQ.getKey())){
+            statusList.addAll(Constants.InsuranceApplyStatus.getKesByStatus(Constants.ApplyCollectStatus.WTBBZZ.getKey()));
+            statusList.add(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey());
         }
 
         return statusList;
@@ -1906,50 +2369,74 @@
         MPJLambdaWrapper<InsuranceApply> queryWrapper = new MPJLambdaWrapper<>();
         Utils.MP.blankToNull(pageWrap.getModel());
 
+/*        //鏁版嵁鏉冮檺寮�濮�--------------------start----------------
+        LoginUserInfo userInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(userInfo!=null && userInfo.getDepartIdList()!=null){
+            if(  userInfo.getDepartIdList().size() ==0){
+                //鍙湅鑷繁
+                queryWrapper.and(wrapper ->{
+                    wrapper.eq(InsuranceApply::getCreator,userInfo.getId());
+                });
+            }else{
+                //鏉冮檺鑼冨洿鍐�
+                queryWrapper.and(wrapper ->{
+                    wrapper.in(SystemUser::getDepartmentId ,userInfo.getDepartIdList());
+                });
+            }
+        }*/
+
+
         List<Integer> statusList = this.getCollectStatus(pageWrap.getModel().getStatusCollect());
 
         queryWrapper.selectAll(InsuranceApply.class);
         queryWrapper.selectAs(Company::getName,InsuranceApply::getCompanyName);
         queryWrapper.selectAs(Solutions::getName,InsuranceApply::getSolutionsName);
         queryWrapper.selectAs(Solutions::getType,InsuranceApply::getSolutionType);
+        queryWrapper.selectAs(Solutions::getHasDispatchUnit,InsuranceApply::getHasDispatchUnit);
         queryWrapper.selectAs(Solutions::getMaxAge,InsuranceApply::getMaxAge);
         queryWrapper.selectAs(Solutions::getMinAge,InsuranceApply::getMinAge);
         queryWrapper.selectAs(Solutions::getPrice,InsuranceApply::getPrice);
         queryWrapper.selectAs(Solutions::getTimeUnit,InsuranceApply::getTimeUnit);
-        queryWrapper.select(" DATEDIFF( t.END_TIME ,now()  ) AS loseEfficacyDays  ");
-        queryWrapper.select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.apply_id = t.id ) as insureNum");
+        queryWrapper.select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad left join  apply_change a on a.id = ad.APPLY_CHANGE_ID  where t.id = a.APPLY_ID  and a.status = 2  )",InsuranceApply::getChangeMoney);
+//        queryWrapper.select(" case when t.START_TIME > now() then  0 when t.END_TIME >= now() then DATEDIFF(   now() ,t.START_TIME  ) when t.END_TIME <= now() then  DATEDIFF( t.END_TIME,  t.START_TIME )+1  else 0 end loseEfficacyDays   ");
+        queryWrapper.select(" DATEDIFF( t.END_TIME,  t.START_TIME )+1 as loseEfficacyDays ");
+        queryWrapper.select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.apply_id = t.id   ) as insureNum");
+        queryWrapper.select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id  and a.status in ( 5 , 27 )  where ad.apply_id = t.id and ad.END_TIME > now() and ad.START_TIME < now() ) as guaranteeNum");
         if(!Objects.isNull(pageWrap.getModel())&&!Objects.isNull(pageWrap.getModel().getType())){
-            queryWrapper.select(" ifnull(( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status  = 1 and td.INSURANCE_APPLY_ID = t.id ),0) as taxesMoney");
+            queryWrapper.select(" ifnull(( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ),0) as taxesMoney");
             queryWrapper.select(" ( select td.CREATE_DATE from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status = 1 and td.INSURANCE_APPLY_ID = t.id order by td.CREATE_DATE desc limit 1 ) as taxesLast ");
         }
         queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId);
         queryWrapper.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId);
+        queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,InsuranceApply::getCreator);
         queryWrapper.eq(InsuranceApply::getIsdeleted,Constants.ZERO);
         queryWrapper.eq(pageWrap.getModel().getBaseSolutionId()!=null,Solutions::getBaseId,pageWrap.getModel().getBaseSolutionId());
         queryWrapper.in(statusList.size()>0,InsuranceApply::getStatus,statusList);
         queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getSolutionName()),Solutions::getName,pageWrap.getModel().getSolutionName());
-        if(Constants.equalsInteger(pageWrap.getModel().getStatusCollect(),Constants.ApplyCollectStatus.YGQ.getKey()) ){
-            //濡傛灉鏄凡閬庢湡
-//            queryWrapper.eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey());
-            queryWrapper.lt(InsuranceApply::getEndTime, Utils.Date.getStart(new Date()));
-        }else if(Constants.equalsInteger(pageWrap.getModel().getStatusCollect(),Constants.ApplyCollectStatus.BZZ.getKey()) ){
-            //濡傛灉鏄繚闅滀腑
-//            queryWrapper.eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey());
-            queryWrapper.gt(InsuranceApply::getEndTime, Utils.Date.getStart(new Date()));
-        }
+//        if(Constants.equalsInteger(pageWrap.getModel().getStatusCollect(),Constants.ApplyCollectStatus.YGQ.getKey()) ){
+//            //濡傛灉鏄凡杩囨湡
+//            queryWrapper.lt(InsuranceApply::getEndTime, Utils.Date.getStart(new Date()));
+//        }else if(Constants.equalsInteger(pageWrap.getModel().getStatusCollect(),Constants.ApplyCollectStatus.BZZ.getKey()) ){
+//            //濡傛灉鏄繚闅滀腑
+//            queryWrapper.gt(InsuranceApply::getEndTime, Utils.Date.getStart(new Date()));
+//        }
         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
 
         //浼佷笟浜哄憳鏌ョ湅鏈紒涓氭暟鎹�
         if(loginUserInfo.getType().equals(Constants.ONE)){
             queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId());
+            //2024骞�10鏈�29鏃�15:14:28 鍔犲叆  浼佷笟鍚堝苟2绫绘姇淇濇暟鎹�
+            if(pageWrap.getModel().getSolutionType()!=null && Constants.equalsInteger(pageWrap.getModel().getSolutionType(),Constants.ZERO)){
+                queryWrapper.eq(Solutions::getType,pageWrap.getModel().getSolutionType());
+            }
         }else if(loginUserInfo.getType().equals(Constants.TWO)){
             //濡傛灉鏄晢鎴锋煡鐪�
-            if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==0){
-                queryWrapper.exists("select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t.company_id and cs.shop_id="+loginUserInfo.getCompanyId());
-            }else if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==1){
+            if(pageWrap.getModel().getSolutionType()!=null && Constants.equalsInteger(pageWrap.getModel().getSolutionType(),Constants.ZERO)){
+                queryWrapper.exists("select cs.id from company_solution cs left join solutions s on cs.solution_id=s.id where cs.isdeleted=0 and s.base_id=t1.base_id and cs.shop_id="+loginUserInfo.getCompanyId());
+            }else if(pageWrap.getModel().getSolutionType()!=null && Constants.equalsInteger(pageWrap.getModel().getSolutionType(),Constants.ONE)){
                 queryWrapper.eq(Solutions::getShopId,loginUserInfo.getCompanyId());
             }else{
-                queryWrapper.apply("((t1.type=0 and exists(select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t.company_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" +
+                queryWrapper.apply("((t1.type=0 and exists(select cs.id from company_solution cs left join solutions s on cs.solution_id=s.id where cs.isdeleted=0 and s.base_id=t1.base_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" +
                         "t1.type=1 and t1.shop_id="+loginUserInfo.getCompanyId()+"))") ;
             }
         }else{
@@ -1959,6 +2446,9 @@
                 queryWrapper.eq(InsuranceApply::getCompanyId, -1);
             }
             queryWrapper.eq(pageWrap.getModel().getCompanyId()!=null,InsuranceApply::getCompanyId, pageWrap.getModel().getCompanyId());
+        }
+        if (pageWrap.getModel().getCompanyId() != null) {
+            queryWrapper.eq(InsuranceApply::getCompanyId, pageWrap.getModel().getCompanyId());
         }
         if (pageWrap.getModel().getSolutionId() != null) {
             queryWrapper.eq(InsuranceApply::getSolutionId, pageWrap.getModel().getSolutionId());
@@ -1993,6 +2483,18 @@
         if (pageWrap.getModel().getStatus() != null) {
             queryWrapper.in(InsuranceApply::getStatus, pageWrap.getModel().getStatus().split(","));
         }
+
+        if (pageWrap.getModel().getTimeOut() != null) {
+            if(Constants.equalsInteger(pageWrap.getModel().getTimeOut(),Constants.ZERO)){
+                queryWrapper.apply("  t.START_TIME  > now() ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getTimeOut(),Constants.ONE)){
+                queryWrapper.apply("  now()  between  t.START_TIME  and t.END_TIME  ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getTimeOut(),Constants.TWO)){
+                queryWrapper.apply("  t.END_TIME  < now() ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getTimeOut(),Constants.THREE)){
+                queryWrapper.apply("  t.END_TIME  > now() ");
+            }
+        }
         if (pageWrap.getModel().getLoseEfficacy() != null && pageWrap.getModel().getLoseEfficacy() ==1) {
             queryWrapper.apply("  DATEDIFF(t.END_TIME,CURRENT_DATE() ) <= 5  and t.END_TIME >= now() ");
         }
@@ -2011,24 +2513,15 @@
         PageData<InsuranceApply> pageData = PageData.from(insuranceApplyJoinMapper.selectJoinPage(page,InsuranceApply.class, queryWrapper));
         if(pageData.getRecords()!=null){
             for (InsuranceApply apply : pageData.getRecords()){
-                initApplyStatus(apply) ;
+                Constants.initApplyStatus(apply) ;
+                apply.setChangeMoney(Constants.getTwoPoint(apply.getChangeMoney()));
+                apply.setFee(Constants.getTwoPoint(apply.getFee()));
              }
         }
         return pageData;
     }
 
-    public void    initApplyStatus(InsuranceApply apply){
-        apply.setStatusCollect(Constants.InsuranceApplyStatus.getCollectStatus(apply.getStatus()));
-        if(Constants.equalsInteger(apply.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
-            //濡傛灉宸插畬鎴�
-            if(apply.getEndTime()==null || System.currentTimeMillis()>apply.getEndTime().getTime()){
-                apply.setStatusCollect(Constants.THREE);//宸茶繃鏈�
-            }
-        }
-        setServiceDays(apply);
-        apply.setStatusInfo(Constants.ApplyCollectStatus.getName(apply.getStatusCollect()));
 
-    }
 
     @Override
     public List<InsuranceApply> findListByDTO(InsuranceApplyQueryDTO model) {
@@ -2040,6 +2533,7 @@
         queryWrapper.selectAs(Solutions::getName,InsuranceApply::getSolutionsName);
         queryWrapper.selectAs(Solutions::getType,InsuranceApply::getSolutionType);
         queryWrapper.select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.apply_id = t.id ) as insureNum");
+        queryWrapper.select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id  and a.status in ( 5 , 27 )  where ad.apply_id = t.id and ad.END_TIME > now() and ad.START_TIME < now() ) as guaranteeNum");
         queryWrapper.select(" ( select max(ac.APPLY_START_TIME) from apply_change ac  where ac.apply_id = t.id and ac.status = 2 ) as lastChangeDate");
         queryWrapper.select(" ( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ) as taxesMoney ");
         queryWrapper.select(" ( select td.CREATE_DATE from taxes ts inner join tax_detial td on td.TAX_ID = ts.id  where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id order by td.CREATE_DATE desc limit 1 ) as taxesLast ");
@@ -2182,25 +2676,33 @@
                 .selectAs(Solutions::getTimeUnit,InsuranceApply::getTimeUnit)
                 .selectAs(Solutions::getType,InsuranceApply::getSolutionType)
                 .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
+                .selectAs(Solutions::getHasDispatchUnit,InsuranceApply::getHasDispatchUnit)
                 .selectAs(Company::getName,InsuranceApply::getCompanyName)
+                .selectAs(Solutions::getCorrectWarnTime,InsuranceApply::getCorrectWarnTime)
+                .select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad left join  apply_change a on a.id = ad.APPLY_CHANGE_ID  where t.id = a.APPLY_ID  and a.status = 2  )",InsuranceApply::getChangeMoney)
                 .select(" ( select max(ac.APPLY_START_TIME) from apply_change ac  where ac.apply_id = t.id and ac.status = 2 ) as lastChangeDate")
                 .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.apply_id = t.id ) as insureNum")
+                .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id  and a.status in ( 5 , 27 )  where ad.apply_id = t.id and ad.END_TIME > now() and ad.START_TIME < now() ) as guaranteeNum")
                 .select(" t3.name as shopName")
                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
                 .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
                 .leftJoin(Company.class,Company::getId,Solutions::getShopId)
                 .eq(InsuranceApply::getId,id)
                 .last("limit 1");
-
         InsuranceApply insuranceApply = insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class,wrapper);
         if(Objects.isNull(insuranceApply)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY);
         }
+        this.dealDataDetail(insuranceApply);
+        return insuranceApply;
+    }
 
+    public void dealDataDetail(InsuranceApply insuranceApply){
         Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
         if(Objects.isNull(solutions)){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
         }
+        insuranceApply.setCorrectWarnTime(solutions.getCorrectWarnTime());
         if(solutions.getDataType().equals(Constants.ONE)){
             Solutions newVersionSolution = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda().eq(Solutions::getBaseId,solutions.getBaseId()).eq(Solutions::getDataType,Constants.TWO).last("limit 1"));
             if(Objects.isNull(newVersionSolution)){
@@ -2213,9 +2715,11 @@
         if(insuranceApply.getStartTime().compareTo(new Date())<0  && insuranceApply.getEndTime().compareTo(new Date()) > 0 ){
             insuranceApply.setLoseEfficacyDays(DateUtil.daysBetweenDates(insuranceApply.getEndTime(),new Date()));
         }
-        initApplyStatus(insuranceApply);
+        Constants.initApplyStatus(insuranceApply);
         //鏌ヨ闄勪欢鏁版嵁
         initImgData(insuranceApply);
+        insuranceApply.setChangeMoney(Constants.getTwoPoint(insuranceApply.getChangeMoney()));
+        insuranceApply.setFee(Constants.getTwoPoint(insuranceApply.getFee()));
         //鏌ヨ鎿嶄綔璁板綍
         List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class,
                 new MPJLambdaWrapper<ApplyLog>()
@@ -2230,28 +2734,25 @@
                         .orderByAsc(ApplyLog::getCreateDate)
         );
         insuranceApply.setApplyLogList(applyLogList);
-        return insuranceApply;
     }
 
-    private void setServiceDays(InsuranceApply insuranceApply) {
-        //璁剧疆鍦ㄤ繚鏃堕暱锛堝ぉ鏁帮級
-        insuranceApply.setServiceDays(Constants.ZERO);
-        if(insuranceApply.getStatus().equals(Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())){
-            //濡傛灉褰撳墠鏃堕棿澶т簬缁撴潫鏃ユ湡 鍒欎娇鐢ㄧ粨鏉熸棩鏈熷姣斿紑濮嬫棩鏈�
-            if(DateUtil.compareDate(new Date(),insuranceApply.getEndTime())>=Constants.ZERO){
-                insuranceApply.setServiceDays(
-                        DateUtil.daysBetweenDates(insuranceApply.getEndTime(),insuranceApply.getStartTime())+1
-                );
-            }else if(DateUtil.compareDate(insuranceApply.getStartTime(),new Date())>=Constants.ZERO){
-                //鏈紑濮�
-                insuranceApply.setServiceDays(Constants.ZERO);
-            }else{
-                insuranceApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),insuranceApply.getStartTime())+1);
-            }
-        }
-    }
+
 
     private void initImgData(InsuranceApply model) {
+        String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()
+                +systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode();
+        //鏌ヨ鏂规纭涔�
+        CompanySolution companySolution =companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda().eq(CompanySolution::getSolutionId,model.getSolutionId()).eq(CompanySolution::getCompanyId,model.getCompanyId()).last("limit 1"));
+        if(Objects.nonNull(companySolution)){
+            Multifile multifile = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda()
+                    .eq(Multifile::getObjId,companySolution.getId())
+                    .eq(Multifile::getObjType,Constants.MultiFile.COMPANY_SOLUTION_SIGN_PDF.getKey())
+                    .eq(Multifile::getIsdeleted,Constants.ZERO).last("limit 1"));
+            if(Objects.nonNull(multifile)){
+                multifile.setFileurlFull(path + multifile.getFileurl());
+                model.setFanganFile(multifile);
+            }
+        }
         List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda()
                 .eq(Multifile::getObjId, model.getId())
                 .in(Multifile::getObjType,Arrays.asList(new Integer[]{Constants.MultiFile.BD_APPLY_PDF.getKey()
@@ -2262,8 +2763,6 @@
                 .eq(Multifile::getIsdeleted,Constants.ZERO)
                 .orderByAsc(Multifile::getId));
         if(multifiles!=null){
-            String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()
-                    +systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode();
             for(Multifile f : multifiles){
                 if(StringUtils.isBlank(f.getFileurl())){
                     continue;
@@ -2281,22 +2780,7 @@
                 }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.MEMBER_LIST_LATTER.getKey())){
                     //鐢宠鍗�
                     model.setShenqingdanFile(f);
-                }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_CONFIRMATION_LATTER.getKey())){
-                    //绛剧讲鍚庣‘璁や功
-                    model.setFanganFile(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()));
-//                    }
-//                }
             }
         }
     }
@@ -2307,6 +2791,8 @@
                 .selectAs(Solutions::getName,InsuranceApply::getSolutionsName)
                 .selectAs(Solutions::getType,InsuranceApply::getSolutionType)
                 .selectAs(Company::getName,InsuranceApply::getCompanyName)
+                .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.apply_id = t.id ) as insureNum")
+                .select(" ifnull(( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id  and a.status in ( 5 , 27 )  where ad.apply_id = t.id and ad.END_TIME > now()  and ad.START_TIME < now() ),0) as guaranteeNum")
                 .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
                 .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
                 .eq(InsuranceApply::getId,model.getId())
@@ -2323,11 +2809,12 @@
                 .selectAs(DispatchUnit::getName,ApplyDetail::getDuName)
                 .leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId)
                 .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId)
+                .ge(ApplyDetail::getEndTime,DateUtil.getPlusTime2(new Date()))
                 .eq(ApplyDetail::getApplyId,model.getId());
         //鏌ヨ鏄庣粏
         List<ApplyDetail> detailList =applyDetailJoinMapper.selectJoinList(ApplyDetail.class,wrapper1);
         if(detailList!=null){
-            insuranceApply.setInsureNum(detailList.size());
+//            insuranceApply.setInsureNum(detailList.size());
             insuranceApply.setApplyDetailList(detailList);
         }
         insuranceApply.setRemark(model.getRemark());
@@ -2392,30 +2879,24 @@
             noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey())
                             .ne(Notices::getType,Constants.NoticeType.SIX.getStatus())
                     .eq(Notices::getObjId,insuranceApply.getId()));
-            if(!loginUserInfo.getCompanyId().equals(insuranceApply.getCompanyId())){
-                Notices notices = new Notices(noticeObjectType,Constants.ZERO,insuranceApply.getId(),solutions.getName(),
-                        insuranceApply.getCompanyId(), Constants.NoticeType.THREE);
-                noticesMapper.insert(notices);
+
+            Notices notices = new Notices(noticeObjectType,Constants.ZERO,insuranceApply.getId(),solutions.getName(),
+                    insuranceApply.getCompanyId(), Constants.NoticeType.THREE);
+            noticesMapper.insert(notices);
+
+
+            CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda()
+                    .eq(CompanySolution::getIsdeleted,Constants.ZERO)
+                    .eq(CompanySolution::getSolutionId,solutions.getId())
+                    .eq(CompanySolution::getCompanyId,insuranceApply.getCompanyId())
+                    .last("limit 1")
+            );
+            //鍟嗘埛寰呭姙
+            if(Objects.nonNull(companySolution)&&Objects.nonNull(companySolution.getShopId())){
+                Notices shopNotices = new Notices(noticeObjectType,Constants.TWO,
+                        insuranceApply.getId(),solutions.getName(),companySolution.getShopId(),Constants.NoticeType.THREE);
+                noticesMapper.insert(shopNotices);
             }
-
-
-//            CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda()
-//                    .eq(CompanySolution::getIsdeleted,Constants.ZERO)
-//                    .eq(CompanySolution::getSolutionId,solutions.getId())
-//                    .eq(CompanySolution::getCompanyId,insuranceApply.getCompanyId())
-//                    .last("limit 1")
-//            );
-//            //鍟嗘埛寰呭姙
-//            if(Objects.nonNull(companySolution)&&Objects.nonNull(companySolution.getShopId())){
-//                Notices shopNotices = new Notices(noticeObjectType,Constants.TWO,
-//                        insuranceApply.getId(),solutions.getName(),companySolution.getShopId(),Constants.NoticeType.THREE);
-//                noticesMapper.insert(shopNotices);
-//            }
-
-
-
-
-
 
         }else if(insuranceApplyOptDTO.getOptType().equals(Constants.TWO)){
             insuranceApplyStatus =  Constants.InsuranceApplyStatus.CLOSE;
@@ -2480,41 +2961,44 @@
      */
     @Override
     @Transactional(rollbackFor = {Exception.class,BusinessException.class})
-    public void updateApplyCurrentFee(Integer id){
+    public void updateApplyCurrentFee(Integer id,Integer unionId){
         List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class,new MPJLambdaWrapper<InsuranceApply>()
                 .selectAll(InsuranceApply.class)
                 .eq(InsuranceApply::getIsdeleted,Constants.ZERO)
-                .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey())
+                .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey())
                 .eq(!Objects.isNull(id),InsuranceApply::getId,id)
+                .eq(!Objects.isNull(unionId),InsuranceApply::getUnionApplyId,unionId)
                 .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)){
             for (InsuranceApply insuranceApply:insuranceApplyList) {
-//                Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
-//                if(Objects.isNull(solutions)){
-//                    continue;
-//                }
+                Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
+                if(Objects.isNull(solutions)){
+                    continue;
+                }
                 BigDecimal sumAmount = BigDecimal.ZERO;
                 List<ApplyDetail> applyDetailList = applyDetailMapper
                         .selectList(new QueryWrapper<ApplyDetail>().lambda()
+                                .ne(ApplyDetail::getChangeStatus,Constants.TWO)
                                 .eq(ApplyDetail::getApplyId,insuranceApply.getId()));
                 if(CollectionUtils.isNotEmpty(applyDetailList)){
                     for (ApplyDetail applyDetail: applyDetailList) {
-                        //2024-1-30 10:04:24 淇敼 鏍规嵁瀹為檯澶╂暟杩涜璁$畻 褰撳墠璐圭敤  鎬婚噾棰�/鎬诲ぉ鏁�*瀹為檯澶╂暟
-//                        Integer maxDays = DateUtil.calculateBetween(applyDetail.getStartTime(),applyDetail.getEndTime(),0);
-                        BigDecimal fee = applyDetail.getFee();
+                        BigDecimal fee =  Objects.isNull(insuranceApply.getServerCost())?
+                                solutions.getPrice():
+                                solutions.getPrice().add(insuranceApply.getServerCost());
+                        //鍦ㄥ紑濮嬬粨鏉熸棩鏈熶箣闂�
                         if(applyDetail.getStartTime().compareTo(new Date()) <= 0 && applyDetail.getEndTime().compareTo(new Date()) >= 0 ){
-                            Integer days =  DateUtil.calculateBetween(applyDetail.getStartTime(),new Date(),0);
-                            applyDetail.setCurrentFee(new BigDecimal(days).multiply(applyDetail.getPrice()));
-                            //applyDetail.setCurrentFee(fee.divide(BigDecimal.valueOf(maxDays),2, BigDecimal.ROUND_HALF_UP).multiply(BigDecimal.valueOf(days)));
+                            applyDetail.setCurrentFee(Constants.produceFee(solutions,fee,insuranceApply.getStartTime(),insuranceApply.getFinalEndTime(),applyDetail.getStartTime()));
                             applyDetailMapper.updateById(applyDetail);
-                        }else if(applyDetail.getStartTime().compareTo(new Date()) <= 0&&applyDetail.getEndTime().compareTo(new Date()) <= 0){
-                            applyDetail.setCurrentFee(fee);
+                        }else  if(applyDetail.getStartTime().compareTo(new Date()) <= 0&&applyDetail.getEndTime().compareTo(new Date()) <= 0){
+                            //鍦ㄧ粨鏉熸棩鏈熶箣鍚�
+                            applyDetail.setCurrentFee(applyDetail.getFee());
                             applyDetailMapper.updateById(applyDetail);
                         }
-                        sumAmount = sumAmount.add(applyDetail.getCurrentFee());
+                        if(Constants.equalsInteger(applyDetail.getChangeStatus(),Constants.ZERO) || applyDetail.getEndTime().getTime()>System.currentTimeMillis()){
+                            sumAmount = sumAmount.add(applyDetail.getCurrentFee());
+                        }
                     }
                 }
                 insuranceApply.setCurrentFee(sumAmount);
@@ -2574,13 +3058,13 @@
     public  String getSignTBQRSLink(SmsCheckDTO smsCheckDTO) {
         if(Objects.isNull(smsCheckDTO)
             || Objects.isNull(smsCheckDTO.getBusinessId())
-                || StringUtils.isBlank(smsCheckDTO.getCode())
+//                || StringUtils.isBlank(smsCheckDTO.getCode())
         ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST);
         }
-        if(!debugModel){
-            smsEmailService.validateCode(smsCheckDTO.getCode());
-        }
+//        if(!debugModel){
+//            smsEmailService.validateCode(smsCheckDTO.getCode());
+//        }
         MPJLambdaWrapper wrapper=  new MPJLambdaWrapper<InsuranceApply>()
                 .selectAll(InsuranceApply.class)
                 .selectAs(Solutions::getSignKeyword,InsuranceApply::getSignKeyword)
@@ -2605,7 +3089,7 @@
         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_UPLOAD.getKey())){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
         }
-        Company company = user.getCompany();
+        Company company = user.getShowCompany();
         if(debugModel){
             company = companyMapper.selectById(model.getCompanyId());
         }
@@ -2656,6 +3140,7 @@
                 .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId)
                 .isNull(ApplyDetail::getFromId)
                 .eq(ApplyDetail::getApplyId,model.getId())
+                .orderByAsc(ApplyDetail::getId)
         );
         model.setApplyDetailList(applyDetailList);
         return model;
@@ -2670,14 +3155,14 @@
     public String getMemberListOnlineSignLink(SmsCheckDTO smsCheckDTO) {
         if(Objects.isNull(smsCheckDTO)
                 || Objects.isNull(smsCheckDTO.getBusinessId())
-                || StringUtils.isBlank(smsCheckDTO.getCode())
+//                || StringUtils.isBlank(smsCheckDTO.getCode())
         ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST);
         }
         //楠岃瘉 楠岃瘉鐮�
-        if(!debugModel){
-            smsEmailService.validateCode(smsCheckDTO.getCode());
-        }
+//        if(!debugModel){
+//            smsEmailService.validateCode(smsCheckDTO.getCode());
+//        }
         InsuranceApply model = this.queryApplyDetail(smsCheckDTO.getBusinessId());
         if(Objects.isNull(model)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇繚鍗曚俊鎭�");
@@ -2689,7 +3174,7 @@
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔绛剧珷鎿嶄綔锛�");
         }
         LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-        Company company = user.getCompany();
+        Company company = user.getShowCompany();
         if(debugModel){
             company = companyMapper.selectById(model.getCompanyId());
         }
@@ -2703,10 +3188,11 @@
         if(solutions.getType().equals(Constants.ZERO)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝闈炲鎵樹繚鏂规淇濆崟锛屾棤娉曡繘琛岃鎿嶄綔!");
         }
-        String fileUrl =  ExcelExporter.build(InsuranceApply.class).exportApplyExcelToPdf(model,"浜哄憳鍚嶅崟");
+        String fileUrl = ExcelExporter.build(InsuranceApply.class).exportApplyExcelToPdf(model,"浜哄憳鍚嶅崟");
         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.applySignLocalFile(company.getName(),company.getName(),fileUrl,company.getCode(),company.getEmail(),"鎶曚繚鍚嶅崟绛剧珷",company.getSignId(),notifyUrl);
+        String applyNo = signService.applySignLocalFileByParam(company.getName(),company.getName(),fileUrl,company.getCode(),company.getEmail(),"鎶曚繚鍚嶅崟绛剧珷",company.getSignId(),notifyUrl,new Float(0.7));
+//        String applyNo = signService.applySign(company.getName(),fileUrl,company.getName(),company.getCode(),company.getEmail(),model.getSignKeyword(),company.getSignId(),notifyUrl);
         if(StringUtils.isBlank(applyNo) ){
             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鑾峰彇鍦ㄧ嚎绛剧珷鍦板潃澶辫触锛岃绋嶅悗閲嶈瘯锛�");
         }
@@ -2733,14 +3219,14 @@
     public  String getSignWTBTBDLink(SmsCheckDTO smsCheckDTO) {
         if(Objects.isNull(smsCheckDTO)
                 || Objects.isNull(smsCheckDTO.getBusinessId())
-                || StringUtils.isBlank(smsCheckDTO.getCode())
+//                || StringUtils.isBlank(smsCheckDTO.getCode())
         ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST);
         }
         //楠岃瘉 楠岃瘉鐮�
-        if(!debugModel){
-            smsEmailService.validateCode(smsCheckDTO.getCode());
-        }
+//        if(!debugModel){
+//            smsEmailService.validateCode(smsCheckDTO.getCode());
+//        }
         MPJLambdaWrapper wrapper=  new MPJLambdaWrapper<InsuranceApply>()
                 .selectAll(InsuranceApply.class)
                 .selectAs(Solutions::getSignKeyword,InsuranceApply::getSignKeyword)
@@ -2769,7 +3255,7 @@
         if(!Constants.equalsInteger(model.getStatus(),Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey())){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ョ敵璇风姸鎬佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
         }
-        Company company = user.getCompany();
+        Company company = user.getShowCompany();
         if(debugModel){
             company = companyMapper.selectById(model.getCompanyId());
         }
@@ -2803,4 +3289,42 @@
         return  link;
     }
 
+
+
+
+
+    /**
+     * 鏍规嵁淇濆崟鏌ヨ鏄惁鍙互杩涜鍔犲噺淇濇搷浣�
+     * @param applyPowerDTO
+     * @return
+     */
+    @Override
+    public ApplyPowerVO getApplyPower(ApplyPowerDTO applyPowerDTO){
+        if(Objects.isNull(applyPowerDTO)
+        || Objects.isNull(applyPowerDTO.getApplyId())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鍙傛暟閿欒");
+        }
+        if(Objects.isNull(applyPowerDTO.getBeginDate())){
+            applyPowerDTO.setBeginDate(new Date());
+        }
+        InsuranceApply insuranceApply = insuranceApplyMapper.selectById(applyPowerDTO.getApplyId());
+        if(Objects.isNull(insuranceApply)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(insuranceApply.getIsdeleted().equals(Constants.ONE)){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"鏁版嵁宸插垹闄�,鏃犳硶杩涜璇ユ搷浣�");
+        }
+        Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
+        }
+        ApplyPowerVO applyPowerVO = Constants.getApplyPowerStatic(applyPowerDTO,insuranceApply,solutions);
+        return applyPowerVO;
+    }
+
+
+
+
 }
+
+

--
Gitblit v1.9.3