From cdd6551b190b981b807a3b95e9635c559ccc769d Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期一, 19 五月 2025 09:45:07 +0800
Subject: [PATCH] git ch

---
 server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java | 1002 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 967 insertions(+), 35 deletions(-)

diff --git a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java
index 2acd28e..11b1746 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java
@@ -1,20 +1,41 @@
 package com.doumee.service.business.impl;
 
+import com.alibaba.fastjson.JSONObject;
+import com.doumee.biz.system.SystemDictDataBiz;
+import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.exception.BusinessException;
+import com.doumee.core.model.LoginUserInfo;
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.Constants;
+import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
-import com.doumee.dao.business.UnionApplyMapper;
-import com.doumee.dao.business.model.UnionApply;
+import com.doumee.dao.business.*;
+import com.doumee.dao.business.dto.*;
+import com.doumee.dao.business.join.*;
+import com.doumee.dao.business.model.*;
+import com.doumee.dao.system.SystemUserMapper;
+import com.doumee.dao.system.model.SystemUser;
+import com.doumee.service.business.SmsEmailService;
 import com.doumee.service.business.UnionApplyService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.doumee.service.business.third.SignService;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.shiro.SecurityUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
-import org.springframework.util.CollectionUtils;
+import org.springframework.transaction.annotation.Transactional;
+import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
 
-import java.util.List;
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * 鍚堝苟鎶曚繚鍗曚俊鎭〃Service瀹炵幇
@@ -26,6 +47,49 @@
 
     @Autowired
     private UnionApplyMapper unionApplyMapper;
+
+    @Autowired
+    private UnionApplyJoinMapper unionApplyJoinMapper;
+
+    @Autowired
+    private SolutionsMapper solutionsMapper;
+
+    @Autowired
+    private CompanyMapper companyMapper;
+
+    @Autowired
+    private InsuranceApplyJoinMapper insuranceApplyJoinMapper;
+
+    @Autowired
+    private ApplyDetailJoinMapper applyDetailJoinMapper;
+
+    @Autowired
+    private MultifileMapper multifileMapper;
+
+    @Autowired
+    private SystemDictDataBiz systemDictDataBiz;
+
+    @Autowired
+    private SignService signService;
+
+    @Autowired
+    private SmsEmailService smsEmailService;
+    @Autowired
+    private ApplyLogMapper applyLogMapper;
+    @Autowired
+    private ApplyLogJoinMapper applyLogJoinMapper;
+
+    @Autowired
+    private MemberInsuranceJoinMapper memberInsuranceJoinMapper;
+    @Autowired
+    private MemberMapper memberMapper;
+    @Autowired
+    private SystemUserMapper systemUserMapper;
+
+    @Autowired
+    private CompanyDepartmentMapper companyDepartmentMapper;
+    @Value("${debug_model}")
+    private boolean debugModel;
 
     @Override
     public Integer create(UnionApply unionApply) {
@@ -87,78 +151,178 @@
     @Override
     public PageData<UnionApply> findPage(PageWrap<UnionApply> pageWrap) {
         IPage<UnionApply> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<UnionApply> queryWrapper = new QueryWrapper<>();
+        MPJLambdaWrapper<UnionApply> queryWrapper = new MPJLambdaWrapper<>();
         Utils.MP.blankToNull(pageWrap.getModel());
+        queryWrapper.selectAll(UnionApply.class);
+        queryWrapper.selectAs(Solutions::getName,UnionApply::getSolutionName)
+          .selectAs(Solutions::getMaxAge,UnionApply::getMaxAge)
+                .selectAs(Solutions::getMinAge,UnionApply::getMinAge)
+                .selectAs(Solutions::getPrice,UnionApply::getPrice)
+                .selectAs(Solutions::getTimeUnit,UnionApply::getTimeUnit)
+                .selectAs(Solutions::getOrtherInfo,UnionApply::getOrtherInfo)
+                .selectAs(Solutions::getSpecialAgreement,UnionApply::getSpecialAgreement)
+                .selectAs(Solutions::getSpecialInfo,UnionApply::getSpecialInfo);
+        queryWrapper.select("(select count(distinct(b.MEMBER_ID)) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum ");
+        queryWrapper.select(" ( select count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id  and a.status in ( 5 , 27 )  where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum");
+
+        if(pageWrap.getModel().getQueryFlag() == 1){
+            queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id=t.id " +
+                    "and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 0  ) as addApplyNum ");
+
+
+        }else  if(pageWrap.getModel().getQueryFlag() ==2){
+            queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id=t.id " +
+                    "and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 1  ) as changeApplyNum ");
+        }else{
+            queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id=t.id " +
+                    "and b.status = "+Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()+" and a.type = 0  ) as addApplyNum ");
+
+            queryWrapper.select("(select count(1) from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id=t.id " +
+                    "and b.status = "+Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()+" and a.type = 1  ) as changeApplyNum ");
+        }
+        queryWrapper.leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId);
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(Constants.equalsInteger(user.getType(),Constants.TWO)){
+            queryWrapper.eq(UnionApply::getCompanyId, user.getCompanyId());
+        }
+
         if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(UnionApply::getId, pageWrap.getModel().getId());
+            queryWrapper.eq(UnionApply::getId, pageWrap.getModel().getId());
+        }
+        if (pageWrap.getModel().getSolutionId() != null) {
+            queryWrapper.eq(UnionApply::getSolutionId, pageWrap.getModel().getSolutionId());
+        }
+        if (pageWrap.getModel().getHasApplying() != null) {
+            if(Constants.equalsInteger(pageWrap.getModel().getHasApplying() ,Constants.ONE)){
+                queryWrapper.exists(
+                        " ( select 1  from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id= t.id " +
+                                "        and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 0  ) "
+                );
+            }else if(Constants.equalsInteger(pageWrap.getModel().getHasApplying() ,Constants.TWO)){
+                queryWrapper.exists(
+                        " ( select 1  from apply_change a inner join insurance_apply b on a.apply_id = b.id  where b.union_apply_id= t.id " +
+                                "        and a.status = "+Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()+" and a.type = 1   ) "
+                );
+            }
+
         }
         if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCreator, pageWrap.getModel().getCreator());
+            queryWrapper.eq(UnionApply::getCreator, pageWrap.getModel().getCreator());
+        }
+        if (pageWrap.getModel().getQueryStartTime() != null) {
+            queryWrapper.ge(UnionApply::getCreateDate, pageWrap.getModel().getQueryStartTime() +" 00:00:00" );
+        }
+        if (pageWrap.getModel().getQueryEndTime() != null) {
+            queryWrapper.le(UnionApply::getCreateDate, pageWrap.getModel().getQueryEndTime() +" 23:59:59");
         }
         if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(UnionApply::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(UnionApply::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
+            queryWrapper.ge(UnionApply::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
+            queryWrapper.le(UnionApply::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
         }
         if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(UnionApply::getEditor, pageWrap.getModel().getEditor());
+            queryWrapper.eq(UnionApply::getEditor, pageWrap.getModel().getEditor());
         }
         if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(UnionApply::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(UnionApply::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
+            queryWrapper.ge(UnionApply::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
+            queryWrapper.le(UnionApply::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
         }
         if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(UnionApply::getIsdeleted, pageWrap.getModel().getIsdeleted());
+            queryWrapper.eq(UnionApply::getIsdeleted, pageWrap.getModel().getIsdeleted());
         }
         if (pageWrap.getModel().getRemark() != null) {
-            queryWrapper.lambda().eq(UnionApply::getRemark, pageWrap.getModel().getRemark());
+            queryWrapper.eq(UnionApply::getRemark, pageWrap.getModel().getRemark());
         }
         if (pageWrap.getModel().getSortnum() != null) {
-            queryWrapper.lambda().eq(UnionApply::getSortnum, pageWrap.getModel().getSortnum());
+            queryWrapper.eq(UnionApply::getSortnum, pageWrap.getModel().getSortnum());
         }
         if (pageWrap.getModel().getCompanyId() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCompanyId, pageWrap.getModel().getCompanyId());
+            queryWrapper.eq(UnionApply::getCompanyId, pageWrap.getModel().getCompanyId());
         }
         if (pageWrap.getModel().getEndTime() != null) {
-            queryWrapper.lambda().ge(UnionApply::getEndTime, Utils.Date.getStart(pageWrap.getModel().getEndTime()));
-            queryWrapper.lambda().le(UnionApply::getEndTime, Utils.Date.getEnd(pageWrap.getModel().getEndTime()));
+            queryWrapper.ge(UnionApply::getEndTime, Utils.Date.getStart(pageWrap.getModel().getEndTime()));
+            queryWrapper.le(UnionApply::getEndTime, Utils.Date.getEnd(pageWrap.getModel().getEndTime()));
         }
         if (pageWrap.getModel().getStartTime() != null) {
-            queryWrapper.lambda().ge(UnionApply::getStartTime, Utils.Date.getStart(pageWrap.getModel().getStartTime()));
-            queryWrapper.lambda().le(UnionApply::getStartTime, Utils.Date.getEnd(pageWrap.getModel().getStartTime()));
+            queryWrapper.ge(UnionApply::getStartTime, Utils.Date.getStart(pageWrap.getModel().getStartTime()));
+            queryWrapper.le(UnionApply::getStartTime, Utils.Date.getEnd(pageWrap.getModel().getStartTime()));
         }
         if (pageWrap.getModel().getCheckDate() != null) {
-            queryWrapper.lambda().ge(UnionApply::getCheckDate, Utils.Date.getStart(pageWrap.getModel().getCheckDate()));
-            queryWrapper.lambda().le(UnionApply::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate()));
+            queryWrapper.ge(UnionApply::getCheckDate, Utils.Date.getStart(pageWrap.getModel().getCheckDate()));
+            queryWrapper.le(UnionApply::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate()));
         }
         if (pageWrap.getModel().getCheckInfo() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCheckInfo, pageWrap.getModel().getCheckInfo());
+            queryWrapper.eq(UnionApply::getCheckInfo, pageWrap.getModel().getCheckInfo());
         }
         if (pageWrap.getModel().getCheckUserId() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCheckUserId, pageWrap.getModel().getCheckUserId());
+            queryWrapper.eq(UnionApply::getCheckUserId, pageWrap.getModel().getCheckUserId());
         }
         if (pageWrap.getModel().getCode() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCode, pageWrap.getModel().getCode());
+            queryWrapper.eq(UnionApply::getCode, pageWrap.getModel().getCode());
         }
         if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(UnionApply::getStatus, pageWrap.getModel().getStatus());
+            queryWrapper.eq(UnionApply::getStatus, pageWrap.getModel().getStatus());
         }
+        if (pageWrap.getModel().getQueryStatus() != null) {
+            if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.THREE)){
+                queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey());
+                queryWrapper.apply(" t.START_TIME < now()  and t.END_TIME > now() ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.SIX)){
+                queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey());
+                queryWrapper.apply("   t.END_TIME < now() ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.FIVE)){
+                queryWrapper.eq(UnionApply::getStatus, Constants.UnionApplyStatus.FINISH.getKey());
+                queryWrapper.apply("   t.START_TIME > now() ");
+            }else if(Constants.equalsInteger(pageWrap.getModel().getQueryStatus(),Constants.ZERO)){
+                queryWrapper.in(UnionApply::getStatus, Constants.UnionApplyStatus.MERGE.getKey(),Constants.UnionApplyStatus.RETRIAL.getKey());
+            }else{
+                queryWrapper.eq(UnionApply::getStatus, pageWrap.getModel().getQueryStatus());
+            }
+
+        }
+        
         if (pageWrap.getModel().getCurrentFee() != null) {
-            queryWrapper.lambda().eq(UnionApply::getCurrentFee, pageWrap.getModel().getCurrentFee());
+            queryWrapper.eq(UnionApply::getCurrentFee, pageWrap.getModel().getCurrentFee());
         }
         if (pageWrap.getModel().getFee() != null) {
-            queryWrapper.lambda().eq(UnionApply::getFee, pageWrap.getModel().getFee());
+            queryWrapper.eq(UnionApply::getFee, pageWrap.getModel().getFee());
         }
         if (pageWrap.getModel().getSignApplyNo() != null) {
-            queryWrapper.lambda().eq(UnionApply::getSignApplyNo, pageWrap.getModel().getSignApplyNo());
+            queryWrapper.eq(UnionApply::getSignApplyNo, pageWrap.getModel().getSignApplyNo());
         }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
+        if(pageWrap.getSorts().size() == 0){
+            queryWrapper.orderByDesc(UnionApply::getCreateDate );
+        }else {
+            for(PageWrap.SortData sortData: pageWrap.getSorts()) {
+                if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
+                    queryWrapper.orderByDesc(sortData.getProperty());
+                } else {
+                    queryWrapper.orderByAsc(sortData.getProperty());
+                }
             }
         }
-        return PageData.from(unionApplyMapper.selectPage(page, queryWrapper));
+
+        PageData<UnionApply> pageData = PageData.from(unionApplyJoinMapper.selectJoinPage(page,UnionApply.class, queryWrapper));
+        if(pageData!=null && pageData.getRecords()!=null){
+            for(UnionApply model : pageData.getRecords()){
+                initStatusInfo(model);
+            }
+        }
+        return pageData;
+    }
+
+    private void initStatusInfo(UnionApply model) {
+        model.setStatusInfo(Constants.UnionApplyStatus.getName(Constants.formatIntegerNum(model.getStatus())));
+
+        if(Constants.equalsInteger(model.getStatus(),Constants.UnionApplyStatus.FINISH.getKey())){
+            if(model.getStartTime().getTime()>System.currentTimeMillis()){
+                model.setStatusInfo("寰呯敓鏁�");
+            }else if(model.getEndTime().getTime()<System.currentTimeMillis()){
+                model.setStatusInfo("宸茶繃鏈�");
+            }else{
+                model.setStatusInfo("淇濋殰涓�");
+            }
+        }
+
     }
 
     @Override
@@ -166,4 +330,772 @@
         QueryWrapper<UnionApply> wrapper = new QueryWrapper<>(unionApply);
         return unionApplyMapper.selectCount(wrapper);
     }
+
+    @Override
+    public      UnionApply findDetailForExport(UnionApply model){
+        UnionApply insuranceApply = detail(model.getId());
+        if(Objects.isNull(insuranceApply)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+
+        MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.selectAll(ApplyDetail.class);
+        queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName);
+        queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName);
+        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(Company.class,Company::getId,Member::getCompanyId);
+        queryWrapper.eq(  ApplyDetail::getUnionApplyId,model.getId());
+        List<ApplyDetail> detailList=  applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper);
+        //鏌ヨ鏄庣粏
+        if(detailList!=null){
+            insuranceApply.setInsureNum(detailList.size());
+            insuranceApply.setApplyDetailList(detailList);
+        }
+        insuranceApply.setRemark(model.getRemark());
+        return insuranceApply;
+    }
+
+
+
+    @Override
+    public UnionApply detail(Integer applyId){
+        UnionApply unionApply = unionApplyJoinMapper.selectJoinOne(UnionApply.class,
+                new MPJLambdaWrapper<UnionApply>()
+                        .selectAll(UnionApply.class)
+                        .selectAs(Solutions::getName,UnionApply::getSolutionName)
+                        .selectAs(Solutions::getDelOnlyReplace,UnionApply::getDelOnlyReplace)
+                        .selectAs(Solutions::getHasDispatchUnit,UnionApply::getHasDispatchUnit)
+                        .selectAs(Solutions::getSignType,UnionApply::getSignType)
+                        .selectAs(Company::getName,UnionApply::getCompanyName)
+                        .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad  where ad.UNION_APPLY_ID = t.id ) as insureNum")
+                .select(" ( select count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id  and a.status in ( 5 , 27 )  where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum")
+                        .select(" ( select group_concat(DISTINCT(cd.name)) from insurance_apply ad left join company cd on ad.company_id = cd.id where ad.UNION_APPLY_ID = t.id ) as companyNames")
+                        .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId)
+                        .leftJoin(Company.class,Company::getId,UnionApply::getCompanyId)
+                        .eq(UnionApply::getId,applyId)
+                        .last(" limit 1 ")
+        );
+        unionApply.setServiceDays(Constants.ZERO);
+        if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){
+            //濡傛灉褰撳墠鏃堕棿澶т簬缁撴潫鏃ユ湡 鍒欎娇鐢ㄧ粨鏉熸棩鏈熷姣斿紑濮嬫棩鏈�
+            if(DateUtil.compareDate(new Date(),unionApply.getEndTime())>=Constants.ZERO){
+                unionApply.setServiceDays(
+                        DateUtil.daysBetweenDates(unionApply.getEndTime(),unionApply.getStartTime())+1
+                );
+            }else if(DateUtil.compareDate(unionApply.getStartTime(),new Date())>=Constants.ZERO){
+                //鏈紑濮�
+                unionApply.setServiceDays(Constants.ZERO);
+            }else{
+                unionApply.setServiceDays(DateUtil.daysBetweenDates(new Date(),unionApply.getStartTime())+1);
+            }
+        }
+        initStatusInfo(unionApply);
+
+        //鏌ヨ闄勪欢鏁版嵁
+        initImgData(unionApply);
+        //鏌ヨ鎿嶄綔璁板綍
+        List<ApplyLog> applyLogList = applyLogJoinMapper.selectJoinList(ApplyLog.class,
+                new MPJLambdaWrapper<ApplyLog>()
+                        .selectAll(ApplyLog.class)
+                        .selectAs(SystemUser::getRealname,ApplyLog::getCreatorName)
+                        .selectAs(Company::getName,ApplyLog::getCompanyName)
+                        .selectAs(SystemUser::getType,ApplyLog::getCreatorType)
+                        .leftJoin(SystemUser.class,SystemUser::getId,ApplyLog::getCreator)
+                        .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId)
+                        .in(ApplyLog::getObjType,Constants.ApplyLogType.getTypeList(Constants.THREE))
+                        .eq(ApplyLog::getApplyId,unionApply.getId())
+                        .orderByAsc(ApplyLog::getCreateDate)
+        );
+        unionApply.setApplyLogList(applyLogList);
+
+        return unionApply;
+    }
+
+    private void initImgData(UnionApply model) {
+        List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda()
+                .eq(Multifile::getObjId, model.getId())
+                .in(Multifile::getObjType, Arrays.asList(new Integer[]{
+                        Constants.MultiFile.HBD_BD_APPLY_PDF.getKey()
+                        ,Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey()
+                        ,Constants.MultiFile.WTB_BD_DONE_PDF.getKey() }))
+                .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;
+                }
+                f.setFileurlFull(path+f.getFileurl());
+                if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_APPLY_PDF.getKey())){
+                    //绛剧讲鍓嶇殑鎶曚繚鍗�
+                    model.setToubaodanFile(f);
+                }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.HBD_BD_SIGNED_PDF.getKey())){
+                    //绛剧讲鍚庣殑鎶曚繚鍗�
+                    model.setToubaodanSignedFile(f);
+                }else if(Constants.equalsInteger(f.getObjType(),Constants.MultiFile.WTB_BD_DONE_PDF.getKey())){
+                    //鏈�绲備繚闄╁崟
+                    model.setBaoxiandanFile(f);
+                }
+            }
+        }
+    }
+
+
+    @Override
+    @Transactional(rollbackFor ={BusinessException.class,Exception.class} )
+    public Integer merge(SaveUnionApplyDTO saveUnionApplyDTO){
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(Objects.isNull(saveUnionApplyDTO)
+            || Objects.isNull(saveUnionApplyDTO.getApplyIds())
+            || saveUnionApplyDTO.getApplyIds().size() == 0
+            || Objects.isNull(saveUnionApplyDTO.getStartDate())
+            || Objects.isNull(saveUnionApplyDTO.getEndDate())
+            || saveUnionApplyDTO.getStartDate().getTime()>saveUnionApplyDTO.getEndDate().getTime()
+            || Objects.isNull(saveUnionApplyDTO.getBaseSolutionId())
+        ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        Solutions solutions = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda().
+                eq(Solutions::getType,Constants.ONE)
+                .eq(Solutions::getIsdeleted,Constants.ZERO)
+                .eq(Solutions::getDataType,Constants.ZERO)
+                .eq(Solutions::getId,saveUnionApplyDTO.getBaseSolutionId()));
+        //鏌ヨ鏂规鏁版嵁
+        if(solutions == null){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝鏂规淇℃伅鏈夎锛岃鍒锋柊椤甸潰閲嶈瘯");
+        }
+        //鏍规嵁鏂规鏌ヨ瀵瑰簲鐨勭粨鏉熸棩鏈�
+        CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO();
+        countCyclePriceDTO.setSolutions(solutions);
+        countCyclePriceDTO.setStartDate(saveUnionApplyDTO.getStartDate());
+        Date endTime =  Constants.getCountCyclePriceVO(countCyclePriceDTO).getEndDate();
+        if(saveUnionApplyDTO.getEndDate().getTime()>endTime.getTime()) {
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝缁撴潫鏃ユ湡瓒呭嚭鏂规鍙厑璁告棩鏈熷懆鏈燂紝璇锋洿鏀瑰悗閲嶈瘯锛�");
+        }
+        List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class,
+                new MPJLambdaWrapper<InsuranceApply>()
+                        .selectAll(InsuranceApply.class)
+                        .selectAs(Solutions::getBaseId,InsuranceApply::getSolutionBaseId)
+                        .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                        .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+                        .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_BUSINESS_CHECK_PASS.getKey())
+                        .eq(Solutions::getBaseId,saveUnionApplyDTO.getBaseSolutionId())
+                        .in(InsuranceApply::getId,saveUnionApplyDTO.getApplyIds())
+                        .isNull(InsuranceApply::getUnionApplyId)
+        );
+        //鏌ヨ鏁版嵁鏄惁瀛樺湪鏈浜庡鎵归�氳繃鐨勬暟鎹�
+        if(insuranceApplyList.size()!=saveUnionApplyDTO.getApplyIds().size()){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀛樺湪鏁版嵁宸插鐞嗭紝璇峰埛鏂伴噸璇�");
+        }
+        saveUnionApplyDTO.setEndDate(DateUtil.getMontageDate(saveUnionApplyDTO.getEndDate(),2));
+        UnionApply unionApply = new UnionApply();
+        unionApply.setCreateDate(new Date());
+        unionApply.setCreator(user.getId());
+        unionApply.setEditor(user.getId());
+        unionApply.setEditDate(new Date());
+        if(Constants.equalsInteger(user.getType(),Constants.ZERO)){
+            unionApply.setCompanyId(solutions.getShopId());
+        }else{
+            unionApply.setCompanyId(user.getCompanyId());
+        }
+        unionApply.setStartTime(saveUnionApplyDTO.getStartDate());
+        unionApply.setEndTime(saveUnionApplyDTO.getEndDate());
+        unionApply.setCheckDate(new Date());
+
+        if(Constants.equalsInteger(solutions.getRetrial(),Constants.ONE)){
+                SystemUser systemUser = systemUserMapper.selectById(user.getId());
+                if(Objects.nonNull(systemUser) && Objects.nonNull(systemUser.getDepartmentId())){
+                    CompanyDepartment companyDepartment = companyDepartmentMapper.selectById(systemUser.getDepartmentId());
+                    if(Objects.nonNull(companyDepartment)&&Objects.nonNull(companyDepartment.getHeadId())){
+                        unionApply.setRetrialId(companyDepartment.getHeadId());
+                    }
+                }
+        }
+        if(Constants.equalsInteger(solutions.getSignType(), Constants.ZERO)){
+            unionApply.setStatus(Constants.UnionApplyStatus.MERGE.getKey());
+        }else if(Constants.equalsInteger(solutions.getSignType(), Constants.ONE)){
+            unionApply.setStatus(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey());
+        }else{
+            if(Objects.nonNull(unionApply.getRetrialId())){
+                unionApply.setStatus(Constants.UnionApplyStatus.RETRIAL.getKey());
+            }else{
+                unionApply.setStatus(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey());
+            }
+        }
+        unionApply.setCheckUserId(user.getId());
+        unionApply.setCurrentFee(BigDecimal.ZERO);
+        unionApply.setIsdeleted(Constants.ZERO);
+        unionApply.setSolutionId(solutions.getId());
+
+        List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,new MPJLambdaWrapper<ApplyDetail>()
+                .select(ApplyDetail::getId,ApplyDetail::getPrice,ApplyDetail::getStartTime,ApplyDetail::getEndTime,ApplyDetail::getFee)
+                .selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo)
+                .selectAs(Member::getName,ApplyDetail::getMemberName)
+                .leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId)
+                .in(ApplyDetail::getApplyId,saveUnionApplyDTO.getApplyIds())
+                .eq(ApplyDetail::getIsdeleted,Constants.ZERO));
+        if(applyDetailList.size()==0){
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝瀛樺湪濮旀墭鎶曚繚鐢宠璁板綍淇℃伅鏈夎锛岃杩斿洖鏌ョ湅鐢宠浜哄憳鏄惁涓虹┖锛�");
+        }
+        BigDecimal fee = BigDecimal.ZERO;
+        for (ApplyDetail applyDetail:applyDetailList) {
+            //鏌ヨ浜哄憳淇℃伅鏄惁瀛樺湪鐩稿悓鐨勬柟妗堜笅鏄惁瀛樺湪 鍐茬獊鏁版嵁
+            InsuranceApplyServiceImpl.checkStaticMemberSolution(solutions.getBaseId(),
+                    applyDetail.getMemberId(),applyDetail.getIdcardNo(),applyDetail.getMemberName(),unionApply.getStartTime(),unionApply.getEndTime(),
+                    applyDetailJoinMapper);
+            fee =fee.add(
+                    Constants.reduceFee(solutions,solutions.getPrice(),applyDetail.getStartTime(),applyDetail.getEndTime(),saveUnionApplyDTO.getStartDate(),saveUnionApplyDTO.getEndDate())
+            );
+        }
+        unionApply.setFee(fee);
+        unionApplyMapper.insert(unionApply);
+        if(Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){
+            //鏌ヨ浼佷笟绛剧珷鐨勬枃浠�
+            Integer applyId = insuranceApplyList.get(Constants.ZERO).getId();
+            Multifile m = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda().eq(Multifile::getObjId,applyId)
+                    .eq(Multifile::getObjType,Constants.MultiFile.MEMBER_LIST_LATTER.getKey())
+                    .last(" limit  1 ")
+            );
+            if(Objects.isNull(m)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏈煡璇㈠埌淇濆崟浼佷笟绛剧讲鏂囦欢");
+            }
+            Multifile multifile = new Multifile();
+            multifile.setCreateDate(new Date());
+            multifile.setIsdeleted(Constants.ZERO);
+            multifile.setObjId(unionApply.getId());
+            multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey());
+            multifile.setFileurl(m.getFileurl());
+            multifileMapper.insert(multifile);
+        }
+        insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                .set(InsuranceApply::getUnionApplyId,unionApply.getId())
+                .set(InsuranceApply::getCheckDate,new Date())
+                .set(InsuranceApply::getCheckUserId,user.getId())
+                .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey())
+                .in(InsuranceApply::getId,saveUnionApplyDTO.getApplyIds()));
+        applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda()
+                .set(ApplyDetail::getUnionApplyId,unionApply.getId())
+                .in(ApplyDetail::getApplyId,saveUnionApplyDTO.getApplyIds()));
+
+
+
+        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD;
+        ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null
+                ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply));
+        applyLogMapper.insert(log);
+
+        return unionApply.getId();
+    }
+
+
+
+    @Override
+    @Transactional(rollbackFor ={BusinessException.class,Exception.class} )
+    public Integer reexamineCheck(UnionApply unionApply){
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        UnionApply model = unionApplyMapper.selectById(unionApply.getId());
+        if(Objects.isNull(unionApply)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(!Constants.equalsInteger(model.getStatus(),Constants.UnionApplyStatus.RETRIAL.getKey())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡娴佽浆锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒");
+        }
+        unionApply.setEditor(user.getId());
+        unionApply.setEditDate(new Date());
+        //濡傛灉鏄晢鎴风锛屽垯鍙兘鐢辨寚瀹氫汉杩涜澶勭悊
+        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(),"闈炴偍鐨勫瀹℃暟鎹紝鏃犳硶杩涜瀹℃壒");
+                }
+            }
+        }
+        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_REEXAMINE_PASS;
+        String info = applyLogType.getInfo();
+        unionApply.setStatus(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey());
+        unionApplyMapper.updateById(unionApply);
+        ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info
+                ,unionApply.getId(),applyLogType.getKey(),null, null);
+        applyLogMapper.insert(log);
+        return unionApply.getId();
+
+
+    }
+
+
+
+
+    /**
+     * 鍙栨秷淇濆崟鍚堝苟
+     * @param closeDTO
+     */
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public void cancelMerge(CloseDTO closeDTO){
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(!(Constants.equalsInteger(user.getType(),Constants.ZERO)||Constants.equalsInteger(user.getType(),Constants.TWO))){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"浼佷笟鐢ㄦ埛锛屾棤娉曡繘琛岃鎿嶄綔锛�");
+        }
+        if(Objects.isNull(closeDTO)
+                ||Objects.isNull(closeDTO.getId())
+                ||StringUtils.isBlank(closeDTO.getReason())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        UnionApply unionApply = unionApplyMapper.selectById(closeDTO.getId());
+        if(Objects.isNull(unionApply)||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(Constants.equalsInteger(user.getType(),Constants.TWO)&&!unionApply.getCompanyId().equals(user.getCompanyId())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧烽潪鎮ㄧ殑鍚堝苟鍗曪紝鎮ㄦ棤娉曡繘琛屾搷浣滐紒");
+        }
+        if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡瀹岀粨锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒");
+        }
+        if(unionApply.getStatus().equals(Constants.UnionApplyStatus.CLOSE.getKey())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡鍏抽棴");
+        }
+
+
+        //鍚堝苟鍗曠姸鎬佸浜庡緟鎶曚繚
+        if(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())
+        || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){
+            multifileMapper.delete(new QueryWrapper<Multifile>()
+                    .lambda()
+                    .apply(" multifile.id in ( select i.id  from insurance_apply i where i.UNION_APPLY_ID = "+unionApply.getId()+" ) ")
+                    .eq(Multifile::getObjType,Constants.MultiFile.BD_APPLY_PDF.getKey()));
+        }
+        insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                .set(InsuranceApply::getUnionApplyId,null)
+                .set(InsuranceApply::getCheckDate,new Date())
+                .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())
+                        || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()),
+                        InsuranceApply::getUnionApplyTbdStatus,Constants.ZERO)
+                .set(unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())
+                        || unionApply.getStatus().equals(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey()),
+                        InsuranceApply::getApplyTbdNo,null)
+                .set(InsuranceApply::getCheckUserId,user.getId())
+                .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_RETURN.getKey())
+                .eq(InsuranceApply::getUnionApplyId,unionApply.getId())
+        );
+
+        applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda()
+                .set(ApplyDetail::getUnionApplyId,null)
+                .eq(ApplyDetail::getUnionApplyId,unionApply.getId()));
+
+        unionApplyMapper.update(null,new UpdateWrapper<UnionApply>().lambda()
+                .set(UnionApply::getCheckDate,new Date())
+                .set(UnionApply::getCheckUserId,user.getId())
+                .set(UnionApply::getStatus,Constants.UnionApplyStatus.CLOSE.getKey())
+                .eq(UnionApply::getId,unionApply.getId())
+        );
+
+
+        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_CLOSE;
+        String info =applyLogType.getInfo();
+        info = info.replace("${param}", closeDTO.getReason());
+        ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info
+                ,unionApply.getId(),applyLogType.getKey(),null, null);
+        applyLogMapper.insert(log);
+    }
+
+
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public void uploadToubaodan(UploadMultifileDTO uploadMultifileDTO){
+        if(uploadMultifileDTO.getBusinessId() == null
+                ||StringUtils.isBlank( uploadMultifileDTO.getFileurl())
+                ||StringUtils.isBlank( uploadMultifileDTO.getName())){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+//        if(!user.getType().equals(Constants.TWO)){
+//            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炲晢鎴风敤鎴凤紝鏃犳硶杩涜璇ユ搷浣滐紒");
+//        }
+        UnionApply unionApply = unionApplyMapper.selectById(uploadMultifileDTO.getBusinessId());
+        if(Objects.isNull(unionApply)||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        unionApply.setStatus(Constants.formatIntegerNum(unionApply.getStatus()));
+        if(Constants.equalsInteger(user.getType(),Constants.TWO)){
+            if(!unionApply.getCompanyId().equals(user.getCompanyId())){
+                throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧烽潪鎮ㄧ殑鍚堝苟鍗曪紝鎮ㄦ棤娉曡繘琛屾搷浣滐紒");
+            }
+        }
+
+        if(unionApply.getStatus().equals(Constants.UnionApplyStatus.FINISH.getKey())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡瀹岀粨锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒");
+        }
+        if(!unionApply.getStatus().equals(Constants.UnionApplyStatus.MERGE.getKey())){
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝鍚堝苟鍗曚笟鍔″凡娴佽浆锛屾偍鏃犳硶杩涜璇ユ搷浣滐紒");
+        }
+
+        unionApply.setCheckDate(new Date());
+        unionApply.setCheckUserId(user.getId());
+        unionApply.setStatus(Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey());
+        unionApply.setEditor(user.getId());
+        unionApply.setEditDate(new Date());
+        unionApplyMapper.updateById(unionApply);
+
+        Multifile multifile = new Multifile();
+        multifile.setIsdeleted(Constants.ZERO);
+        multifile.setCreator(user.getId());
+        multifile.setCreateDate(new Date());
+        multifile.setObjId(uploadMultifileDTO.getBusinessId());
+        multifile.setCreateDate(new Date());
+        multifile.setObjType(Constants.MultiFile.HBD_BD_APPLY_PDF.getKey());
+        multifile.setType(Constants.TWO);
+        multifile.setFileurl(uploadMultifileDTO.getFileurl());
+        multifile.setName(uploadMultifileDTO.getName());
+        multifileMapper.insert(multifile);
+
+
+        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_TBD;
+        ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), null
+                ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply));
+        applyLogMapper.insert(log);
+
+    }
+
+
+    /**
+     * 鍚堝苟鍗� - 鎶曚繚鐢宠绛剧讲
+     * @return
+     */
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public  String getSignLink(SmsCheckDTO smsCheckDTO) {
+        if(Objects.isNull(smsCheckDTO)
+                || Objects.isNull(smsCheckDTO.getBusinessId())
+//                || StringUtils.isBlank(smsCheckDTO.getCode())
+        ){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        //楠岃瘉 楠岃瘉鐮�
+//        if(!debugModel){
+//            smsEmailService.validateCode(smsCheckDTO.getCode());
+//        }
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        UnionApply unionApply = unionApplyJoinMapper.selectById(smsCheckDTO.getBusinessId());
+        if(unionApply == null ||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈡柟妗堜俊鎭�");
+        }
+
+        if(!Constants.equalsInteger(unionApply.getStatus(),Constants.UnionApplyStatus.WAIT_SIGNATURE.getKey())){
+            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ュ悎骞跺崟鐘舵�佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
+        }
+        Multifile f = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda()
+                .eq(Multifile::getObjId,unionApply.getId())
+                .eq(Multifile::getObjType,Constants.MultiFile.HBD_BD_APPLY_PDF.getKey())
+                .eq(Multifile::getIsdeleted,Constants.ZERO)
+                .last("limit 1"));
+        if(f == null || StringUtils.isBlank(f.getFileurl())){
+            throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鑾峰彇寰呯绔犳枃浠跺け璐ワ紝璇疯仈绯荤‘璁ゅ悎骞朵繚鍗曟槸鍚︽纭紒");
+        }
+
+        Company company =  companyMapper.selectById(unionApply.getCompanyId());
+        if(company== null || StringUtils.isBlank( company.getEmail()) || !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){
+            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鍟嗘埛灏氭湭鍏峰鍦ㄧ嚎绛剧珷鏉′欢锛岃鑱旂郴骞冲彴绠$悊鍛樼‘璁");
+        }
+
+        String url = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode()+f.getFileurl();
+        String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode();
+        notifyUrl = notifyUrl.replace("${type}","0").replace("${id}", unionApply.getId().toString());
+
+        String applyNo = signService.applySignDoByParam(company.getName(),url,company.getName(),company.getCode(),company.getEmail(),null,company.getSignId(),notifyUrl,new Float(0.7));
+
+        if(StringUtils.isBlank(applyNo) ){
+            throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鑾峰彇鍦ㄧ嚎绛剧珷鍦板潃澶辫触锛岃绋嶅悗閲嶈瘯锛�");
+        }
+        String link = signService.signLink(applyNo,company.getName(),company.getCode());
+        if(StringUtils.isBlank(link) ){
+            throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鑾峰彇鍦ㄧ嚎绛剧珷鍦板潃澶辫触锛岃绋嶅悗閲嶈瘯锛�");
+        }
+        UnionApply update= new UnionApply();
+        update.setId(unionApply.getId());
+        update.setEditor(user.getId());
+        update.setEditDate(new Date());
+        update.setSignApplyNo(applyNo);
+        unionApplyJoinMapper.updateById(update);
+        return  link;
+    }
+
+
+
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public void uploadBXD(UnionApplyBXDDTO unionApplyBXDDTO){
+        if(Objects.isNull(unionApplyBXDDTO)
+            || Objects.isNull(unionApplyBXDDTO.getId())
+            || Objects.isNull(unionApplyBXDDTO.getStartTime())
+            || Objects.isNull(unionApplyBXDDTO.getEndTime())
+            || StringUtils.isBlank(unionApplyBXDDTO.getCode())
+            || StringUtils.isBlank(unionApplyBXDDTO.getFileUrl())
+            || StringUtils.isBlank(unionApplyBXDDTO.getFileName())
+        ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+
+        UnionApply unionApply = unionApplyJoinMapper.selectById(unionApplyBXDDTO.getId());
+        if(unionApply == null ||!Constants.equalsInteger(unionApply.getIsdeleted(),Constants.ZERO)){
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(!unionApply.getStatus().equals(Constants.UnionApplyStatus.UPLOAD_INSURANCE_POLICY.getKey())){
+            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ュ悎骞跺崟鐘舵�佸凡娴佽浆锛屽綋鍓嶄笉鏀寔璇ユ搷浣渵");
+        }
+        Solutions solutions = solutionsMapper.selectById(unionApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
+        }
+        //鏍规嵁鏂规鏌ヨ瀵瑰簲鐨勭粨鏉熸棩鏈�
+        CountCyclePriceDTO countCyclePriceDTO = new CountCyclePriceDTO();
+        countCyclePriceDTO.setSolutions(solutions);
+        countCyclePriceDTO.setStartDate(unionApplyBXDDTO.getStartTime());
+        Date endTime =  Constants.getCountCyclePriceVO(countCyclePriceDTO).getEndDate();
+        if(unionApplyBXDDTO.getEndTime().getTime()>endTime.getTime()) {
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝缁撴潫鏃ユ湡瓒呭嚭鏂规鍙厑璁告棩鏈熷懆鏈燂紝璇锋洿鏀瑰悗閲嶈瘯锛�");
+        }
+        //鍔犱环鍙傛暟
+        List<UnionApplyBXDDetailDTO> unionApplyBXDDetailDTOList = unionApplyBXDDTO.getUnionApplyBXDDDetailDTOList();
+
+        //鎵�鏈夋姇淇濈敵璇蜂繚鍗曟槑缁嗚
+        List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectJoinList(ApplyDetail.class,new MPJLambdaWrapper<ApplyDetail>()
+                        .selectAll(ApplyDetail.class)
+                .selectAs(DispatchUnit::getName,ApplyDetail::getDuName)
+                .selectAs(InsuranceApply::getCode,ApplyDetail::getApplyCode)
+                .selectAs(Solutions::getId,ApplyDetail::getSolutionId)
+                .selectAs(Solutions::getName,ApplyDetail::getSolutionName)
+                .selectAs(Worktype::getName,ApplyDetail::getWorkTypeName)
+                .selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo)
+                .selectAs(Member::getName,ApplyDetail::getMemberName)
+                .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId)
+                .leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId)
+                .leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId)
+                .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+                .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+                .in(ApplyDetail::getUnionApplyId,unionApply.getId()));  
+        unionApplyBXDDTO.setEndTime(DateUtil.getMontageDate(unionApplyBXDDTO.getEndTime(),2));
+        //鎬诲ぉ鏁�
+        Integer maxDays = DateUtil.calculateBetween(unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime(),0);
+        //瀹為檯宸茬粡浜х敓璐圭敤鐨勫ぉ鏁�
+        Integer useDays = 0 ;
+        if(unionApplyBXDDTO.getStartTime().compareTo(new Date()) <= 0 && unionApplyBXDDTO.getEndTime().compareTo(new Date()) >= 0 ){
+            //褰撳墠鏃ユ湡鍦ㄥ紑濮嬬粨鏉熸棩鏈熶箣鍐�
+            useDays =  DateUtil.calculateBetween(unionApplyBXDDTO.getStartTime(),new Date(),0);
+        }else if(unionApplyBXDDTO.getStartTime().compareTo(new Date()) <= 0&&unionApplyBXDDTO.getEndTime().compareTo(new Date()) <= 0){
+            //褰撳墠鏃ユ湡鍦ㄧ粨鏉熸棩鏈熶箣鍚�
+            useDays =  -1;
+        }
+        BigDecimal sumFee = BigDecimal.ZERO;
+        BigDecimal sumCurrFee = BigDecimal.ZERO;
+        List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectList(new QueryWrapper<InsuranceApply>()
+                .lambda().eq(InsuranceApply::getUnionApplyId,unionApply.getId()));
+        for (InsuranceApply insuranceApply:insuranceApplyList) {
+            List<ApplyDetail> applyDetails = applyDetailList.stream()
+                    .filter(m->Constants.equalsInteger(m.getApplyId(),(insuranceApply.getId()))).collect(Collectors.toList());
+            if(CollectionUtils.isEmpty(applyDetails)){
+                continue;
+            }
+            BigDecimal price = Constants.formatBigdecimal(applyDetails.get(Constants.ZERO).getPrice());
+            Optional<UnionApplyBXDDetailDTO> unionApplyBXDDDetailTO= unionApplyBXDDetailDTOList.stream().filter(
+                    m->m.getApplyId().equals(insuranceApply.getId())).findFirst();
+            BigDecimal serverCost = BigDecimal.ZERO;
+            if(unionApplyBXDDDetailTO.isPresent()){
+                UnionApplyBXDDetailDTO unionApplyBXDDetailDTO = unionApplyBXDDDetailTO.get();
+                serverCost = unionApplyBXDDetailDTO.getServerMoney();
+                //涓婁紶淇濆崟淇℃伅
+                Multifile multifile = new Multifile();
+                multifile.setIsdeleted(Constants.ZERO);
+                multifile.setCreator(user.getId());
+                multifile.setCreateDate(new Date());
+                multifile.setObjId(insuranceApply.getId());
+                multifile.setObjType(Constants.MultiFile.BD_DONE_PDF.getKey());
+                multifile.setType(Constants.TWO);
+                multifile.setFileurl(unionApplyBXDDTO.getFileUrl());
+                multifile.setName(unionApplyBXDDTO.getFileName());
+                multifileMapper.insert(multifile);
+                insuranceApply.setUnionApplyTbdStatus(Constants.ONE);
+
+
+//                if(StringUtils.isNotBlank(unionApplyBXDDetailDTO.getFileUrl())){
+//                    Multifile multifile = new Multifile();
+//                    multifile.setIsdeleted(Constants.ZERO);
+//                    multifile.setCreator(user.getId());
+//                    multifile.setCreateDate(new Date());
+//                    multifile.setObjId(insuranceApply.getId());
+//                    multifile.setObjType(Constants.MultiFile.BD_DONE_PDF.getKey());
+//                    multifile.setType(Constants.TWO);
+//                    multifile.setFileurl(unionApplyBXDDetailDTO.getFileUrl());
+//                    multifile.setName(unionApplyBXDDetailDTO.getFileName());
+//                    multifileMapper.insert(multifile);
+//                    insuranceApply.setUnionApplyTbdStatus(Constants.ONE);
+//                }else{
+//                    insuranceApply.setUnionApplyTbdStatus(Constants.ZERO);
+//                }
+            }
+            //瀹為檯宸蹭骇鐢熻垂鐢紙鍗曚汉锛�
+            BigDecimal currentFee = BigDecimal.ZERO;
+            if(useDays==-1){
+                currentFee = solutions.getPrice().add(serverCost);
+            }else if(useDays>0){
+                currentFee = Constants.produceFee(solutions,solutions.getPrice().add(serverCost)
+                        ,unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime(),
+                        unionApplyBXDDTO.getStartTime()
+                );
+            }
+            //鐢熸垚鎶曚繚璁板綍
+            if(CollectionUtils.isNotEmpty(applyDetailList)){
+                List<MemberInsurance> memberInsuranceList = new ArrayList<>();
+                for (ApplyDetail applyDetail:applyDetailList.stream()
+                        .filter(m->Constants.equalsInteger(m.getApplyId(),(insuranceApply.getId()))).collect(Collectors.toList())) {
+
+                    //鏌ヨ浜哄憳淇℃伅鏄惁瀛樺湪鐩稿悓鐨勬柟妗堜笅鏄惁瀛樺湪 鍐茬獊鏁版嵁
+                    InsuranceApplyServiceImpl.checkStaticMemberSolution(solutions.getBaseId(),
+                            applyDetail.getMemberId(),applyDetail.getIdcardNo(),applyDetail.getMemberName(),unionApply.getStartTime(),unionApply.getEndTime(),
+                            applyDetailJoinMapper);
+
+                    applyDetail.setPrice(price);
+                    applyDetail.setFee(price.multiply(new BigDecimal(maxDays)).add(serverCost));
+                    applyDetail.setStartTime(unionApplyBXDDTO.getStartTime());
+                    applyDetail.setEndTime(unionApplyBXDDTO.getEndTime());
+
+
+                    MemberInsurance memberInsurance = new MemberInsurance(applyDetail,user.getId());
+                    memberInsurance.setBdCode(unionApplyBXDDTO.getCode());
+                    memberInsurance.setRelationType(Constants.ZERO);
+                    memberInsuranceList.add(memberInsurance);
+                    //鏇存柊鍛樺伐鎶曚繚鏃堕棿
+                    memberMapper.update(null,new UpdateWrapper<Member>()
+                            .lambda()
+                            .set(Member::getStartTime,memberInsurance.getStartTime())
+                            .set(Member::getEndTime,memberInsurance.getEndTime())
+                            .set(Member::getDuId,memberInsurance.getDuId())
+                            .set(Member::getWorktypeId,memberInsurance.getWorktypeId())
+                            .eq(Member::getId, memberInsurance.getMemberId())
+                    );
+
+                }
+                memberInsuranceJoinMapper.insertBatchSomeColumn(memberInsuranceList);
+            }
+            BigDecimal detailFee = Constants.reduceFee(solutions,solutions.getPrice().add(serverCost),insuranceApply.getStartTime(),insuranceApply.getFinalEndTime(),
+                    unionApplyBXDDTO.getStartTime(),unionApplyBXDDTO.getEndTime());
+
+            BigDecimal applyFee =  detailFee.multiply(new BigDecimal(applyDetails.size()));
+
+            Date finalEndTime =  endTime;
+
+            //鏇存柊鎶曚繚鐢宠鍗�
+            insuranceApplyJoinMapper.update(null,new UpdateWrapper<InsuranceApply>().lambda()
+                    .set(InsuranceApply::getUnionApplyTbdStatus,Constants.THREE)
+                    .set(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+                    .set(InsuranceApply::getFee,applyFee)
+                    .set(InsuranceApply::getCurrentFee,currentFee.multiply(new BigDecimal(applyDetails.size())))
+                    .set(InsuranceApply::getStartTime,unionApplyBXDDTO.getStartTime())
+                    .set(InsuranceApply::getEndTime,unionApplyBXDDTO.getEndTime())
+                    .set(InsuranceApply::getEditDate,new Date())
+                    .set(InsuranceApply::getEditor,user.getId())
+                    .set(InsuranceApply::getServerCost,serverCost)
+                    .set(InsuranceApply::getCode,unionApplyBXDDTO.getCode())
+                    .set(InsuranceApply::getFinalEndTime,finalEndTime)
+                    .eq(InsuranceApply::getId,insuranceApply.getId()));
+            //鏇存柊鎶曚繚鍗曟槑缁嗛噾棰�
+            applyDetailJoinMapper.update(null,new UpdateWrapper<ApplyDetail>().lambda()
+                    .set(ApplyDetail::getPrice,price)
+                    .set(ApplyDetail::getFee, detailFee)
+                    .set(ApplyDetail::getCurrentFee,currentFee)
+                    .set(ApplyDetail::getEditDate,new Date())
+                    .set(ApplyDetail::getEditor,user.getId())
+                    .set(ApplyDetail::getStartTime,unionApplyBXDDTO.getStartTime())
+                    .set(ApplyDetail::getEndTime,unionApplyBXDDTO.getEndTime())
+                    .in(ApplyDetail::getId,applyDetails.stream().map(m->m.getId()).collect(Collectors.toList()))
+            );
+            sumFee = sumFee.add(applyFee);
+            sumCurrFee = sumCurrFee.add(currentFee.multiply(new BigDecimal(applyDetails.size())));
+        }
+
+        unionApplyMapper.update(null,new UpdateWrapper<UnionApply>()
+                .lambda()
+                .set(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH.getKey())
+                .set(UnionApply::getEditDate,new Date())
+                .set(UnionApply::getEditor,user.getId())
+                .set(UnionApply::getStartTime,unionApplyBXDDTO.getStartTime())
+                .set(UnionApply::getEndTime,unionApplyBXDDTO.getEndTime())
+                .set(UnionApply::getCode,unionApplyBXDDTO.getCode())
+                .set(UnionApply::getFee,sumFee)
+                .set(UnionApply::getCurrentFee,sumCurrFee)
+                .eq(UnionApply::getId,unionApply.getId())
+        );
+        //鍚堝苟鍗� 鏂囦欢
+        if(StringUtils.isNotBlank(unionApplyBXDDTO.getFileUrl())){
+            Multifile multifile = new Multifile();
+            multifile.setIsdeleted(Constants.ZERO);
+            multifile.setCreator(user.getId());
+            multifile.setCreateDate(new Date());
+            multifile.setObjId(unionApply.getId());
+            multifile.setObjType(Constants.MultiFile.WTB_BD_DONE_PDF.getKey());
+            multifile.setType(Constants.TWO);
+            multifile.setFileurl(unionApplyBXDDTO.getFileUrl());
+            multifile.setName(unionApplyBXDDTO.getFileName());
+            multifileMapper.insert(multifile);
+        }
+
+        Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_UPLOAD_BXD;
+        String info = "";
+        if(Objects.nonNull(unionApplyBXDDTO.getStartTime())&&Objects.nonNull(unionApplyBXDDTO.getEndTime())){
+            info =applyLogType.getInfo();
+            info = info.replace("${param1}",DateUtil.getPlusTime2(unionApplyBXDDTO.getStartTime()));
+            info = info.replace("${param2}",DateUtil.getPlusTime2(unionApplyBXDDTO.getEndTime()));
+        }
+        ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info
+                ,unionApply.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(unionApply));
+        applyLogMapper.insert(log);
+
+
+    }
+
+
+
+
+    @Override
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public void updateUnionApplyCurrentFee(Integer id){
+        List<UnionApply> unionApplyList = unionApplyJoinMapper.selectJoinList(UnionApply.class,new MPJLambdaWrapper<UnionApply>()
+                .selectAll(UnionApply.class)
+                .eq(UnionApply::getIsdeleted,Constants.ZERO)
+                .eq(UnionApply::getStatus,Constants.UnionApplyStatus.FINISH.getKey())
+                .eq(!Objects.isNull(id),UnionApply::getId,id)
+                .le(UnionApply::getStartTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 00:00:00")
+                .ge(UnionApply::getEndTime,DateUtil.getDate(new Date(),"yyyy-MM-dd") + " 23:59:59")
+        );
+
+        if(CollectionUtils.isNotEmpty(unionApplyList)){
+            for (UnionApply unionApply:unionApplyList) {
+                List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper
+                        .selectList(new QueryWrapper<InsuranceApply>().lambda()
+                                .eq(InsuranceApply::getUnionApplyId,unionApply.getId()));
+                if(CollectionUtils.isNotEmpty(insuranceApplyList)){
+                    unionApply.setCurrentFee(insuranceApplyList.stream().map(m->m.getCurrentFee()).reduce(BigDecimal.ZERO,BigDecimal::add));
+                    unionApplyMapper.updateById(unionApply);
+                }
+            }
+        }
+    }
+
+
 }

--
Gitblit v1.9.3