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/MemberServiceImpl.java |  306 ++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 245 insertions(+), 61 deletions(-)

diff --git a/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
index fc48ad9..ed874fd 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -10,14 +10,18 @@
 import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
+import com.doumee.dao.business.InsuranceApplyMapper;
 import com.doumee.dao.business.MemberMapper;
 import com.doumee.dao.business.SolutionsMapper;
 import com.doumee.dao.business.WorktypeMapper;
 import com.doumee.dao.business.dto.MemberImport;
 import com.doumee.dao.business.dto.MemberQueryDTO;
+import com.doumee.dao.business.dto.MemberReduceImport;
 import com.doumee.dao.business.dto.WorktypeImport;
+import com.doumee.dao.business.join.ApplyDetailJoinMapper;
 import com.doumee.dao.business.join.DispatchUnitJoinMapper;
 import com.doumee.dao.business.join.MemberJoinMapper;
+import com.doumee.dao.business.join.SolutionWorktypeJoinMapper;
 import com.doumee.dao.business.model.*;
 import com.doumee.service.business.MemberService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -29,6 +33,7 @@
 import lombok.extern.java.Log;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.shiro.SecurityUtils;
+import org.checkerframework.checker.units.qual.C;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.web.multipart.MultipartFile;
@@ -53,12 +58,18 @@
 
     @Autowired
     private DispatchUnitJoinMapper dispatchUnitJoinMapper;
+    @Autowired
+    private ApplyDetailJoinMapper applyDetailJoinMapper;
 
     @Autowired
     private WorktypeMapper worktypeMapper;
 
     @Autowired
     private SolutionsMapper solutionsMapper;
+    @Autowired
+    private InsuranceApplyMapper insuranceApplyMapper;
+    @Autowired
+    private SolutionWorktypeJoinMapper solutionWorktypeJoinMapper;
 
     @Override
     public Integer create(Member member) {
@@ -304,6 +315,9 @@
                                 " and ad.END_TIME >= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"' and ad.START_TIME <= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"' and ad.isdeleted = 0 " +
                                 " and ad.member_id = t.id ") ;
         if(!Objects.isNull(memberQueryDTO.getInsuranceApplyId())){
+            if(Objects.isNull(memberQueryDTO.getValidTime())){
+                memberQueryDTO.setValidTime(new Date());
+            }
             lambdaWrapper = new MPJLambdaWrapper<Member>()
                     .select(Member::getId,Member::getName,Member::getIdcardNo)
                     .selectAs(Worktype::getId,Member::getWorktypeId)
@@ -326,29 +340,38 @@
                     .eq(InsuranceApply::getId,memberQueryDTO.getInsuranceApplyId())
                     .and(StringUtils.isNotBlank(memberQueryDTO.getName()),i->i.like(Member::getName,memberQueryDTO.getName())
                             .or().like(Member::getIdcardNo,memberQueryDTO.getName()))
-                    .le(!Objects.isNull(memberQueryDTO.getValidTime()),ApplyDetail::getStartTime,memberQueryDTO.getValidTime())
+//                    .le(!Objects.isNull(memberQueryDTO.getValidTime()),ApplyDetail::getStartTime,memberQueryDTO.getValidTime())
                     .ge(!Objects.isNull(memberQueryDTO.getValidTime()),ApplyDetail::getEndTime,memberQueryDTO.getValidTime())
                     .in(CollectionUtils.isNotEmpty(memberQueryDTO.getSubtractMemberIds()),Member::getId,memberQueryDTO.getSubtractMemberIds())
                     .exists(!Objects.isNull(memberQueryDTO.getInsuranceApplyId())&&!Objects.isNull(memberQueryDTO.getValidTime()),
                             " select 1 from apply_detail ad where ad.apply_id = "+memberQueryDTO.getInsuranceApplyId()+"" +
-                                    " and ad.END_TIME >= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"' and ad.START_TIME <= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"' and ad.isdeleted = 0 " +
+                                    " and ad.END_TIME >= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"'" +
+//                                    " and ad.START_TIME <= '"+DateUtil.DateToStr(memberQueryDTO.getValidTime(),"yyyy-MM-dd HH:mm:ss.SSS")+"'" +
+                                    " and ad.isdeleted = 0 " +
                                     " and ad.member_id = t.id ");
         }
         List<Member> memberList = memberJoinMapper.selectJoinList(Member.class,lambdaWrapper);
-        if(!Objects.isNull(memberQueryDTO.getInsuranceApplyId())&&Objects.isNull(memberQueryDTO.getValidTime())){
+        if(!Objects.isNull(memberQueryDTO.getInsuranceApplyId())&&Objects.nonNull(memberQueryDTO.getValidTime())){
             if(CollectionUtils.isNotEmpty(memberList)){
                 Solutions solutions = solutionsMapper.selectById(memberList.get(Constants.ZERO).getSolutionId());
-                Date  reduceEndTime = DateUtil.getMontageDate(
-                        DateUtil.afterDateByType(new Date(),0,solutions.getDelValidDays()),3);
-                memberList = memberList.stream().filter(member->member.getDetailStartTime().getTime()<=reduceEndTime.getTime()
-                        &&member.getDetailEndTime().getTime()>=reduceEndTime.getTime()).collect(Collectors.toList());
+//                Date  reduceEndTime = DateUtil.getMontageDate(
+//                        DateUtil.afterDateByType(new Date(),0,solutions.getDelValidDays()),3);
+//                Date  reduceEndTime = DateUtil.getMontageDate(new Date(),3);
                 for (Member member:memberList) {
-                    //鍑忎繚涓氬姟 浣跨敤 閫夋嫨浜哄憳 鏍规嵁鏃ユ湡瀹炴椂鏌ヨ
-                    member.setFee(
-                    Constants.reduceFee(solutions,
-                            Objects.isNull(member.getDetailServerCost())?
-                            solutions.getPrice():solutions.getPrice().add(member.getDetailServerCost()),member.getStartTime(),member.getEndTime(),member.getDetailStartTime(),
-                            reduceEndTime).subtract(member.getFee()));
+                    //濡傛灉褰撳墠鏃ユ湡 灏忎簬 浜哄憳淇濆崟鏄庣粏璁板綍鐨勫紑濮嬫椂闂� 鍒欎娇鐢ㄥ紑濮嬫棩鏈�  寮�濮嬫棩鏈� = 缁撴潫鏃ユ湡  涓� 璐圭敤鍏ㄩ儴閫�鍥�
+//                    if(System.currentTimeMillis()<=member.getStartTime().getTime()){
+//                        member.setFee(solutions.getPrice().multiply(new BigDecimal(-1)));
+                    if(System.currentTimeMillis()<=member.getDetailStartTime().getTime()){
+                            member.setFee(member.getFee().multiply(new BigDecimal(-1)));
+                    }else{
+                        Date  reduceEndTime = DateUtil.getMontageDate(
+                            DateUtil.afterDateByType(new Date(),0,solutions.getDelValidDays()),3);
+                        member.setFee(
+                                Constants.reduceFee(solutions,
+                                        Objects.isNull(member.getDetailServerCost())?
+                                                solutions.getPrice():solutions.getPrice().add(member.getDetailServerCost()),member.getStartTime(),member.getEndTime(),member.getDetailStartTime(),
+                                        reduceEndTime).subtract(member.getFee()));
+                    }
                 }
             }
 
@@ -359,21 +382,140 @@
     }
 
     @Override
-    public List<MemberImport> importBatch(MultipartFile file,Integer  solutionId){
+    public List<MemberReduceImport> importReduceBatch(MultipartFile file, Integer  applyId){
+        if(applyId == null  ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝璇烽�夋嫨鏈夋晥鐨勬柟妗堝啀杩涜鎿嶄綔锛�");
+        }
         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         if(!loginUserInfo.getType().equals(Constants.ONE)){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氫汉鍛樻棤娉曡繘琛岃鎿嶄綔");
         }
-        List<Member> list =  memberJoinMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>()
-                .selectAll(Member.class)
-                .selectAs(DispatchUnit::getName,Member::getDuName)
-                .selectAs(Worktype::getName,Member::getWorkTypeName)
-                .leftJoin(DispatchUnit.class,DispatchUnit::getId,Member::getDuId)
-                .leftJoin(Worktype.class,Worktype::getId,Member::getWorktypeId)
-                .isNotNull(Member::getIdcardNo)
-                .eq(Member::getCompanyId,loginUserInfo.getCompanyId())
-                .eq(Member::getIsdeleted,Constants.ZERO)
-        );
+        ExcelImporter ie = null;
+        List<MemberReduceImport> dataList =null;
+        try {
+            ie = new ExcelImporter(file,1,0);
+            dataList = ie.getDataList(MemberReduceImport.class,null);
+        }  catch (Exception e) {
+            e.printStackTrace();
+        }
+        if(dataList == null || dataList.size() ==0){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝褰曞叆鏁版嵁涓虹┖锛�");
+        }
+
+        InsuranceApply insuranceApply = insuranceApplyMapper.selectById(applyId);
+        if (Objects.isNull(insuranceApply) || !Constants.equalsInteger(insuranceApply.getCompanyId(),loginUserInfo.getCompanyId())) {
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝淇濆崟淇℃伅涓嶅瓨鍦紝璇峰埛鏂伴〉闈㈤噸璇曪紒");
+        }
+        if (!(Constants.equalsInteger(insuranceApply.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+                ||Constants.equalsInteger(insuranceApply.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+        )) {
+            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "瀵逛笉璧凤紝淇濆崟褰撳墠鐘舵�佷笉鏀寔璇ユ搷浣滐紒");
+        }
+        if (DateUtil.compareDate(insuranceApply.getEndTime(),new Date()) >= Constants.ZERO ) {
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "淇濆崟宸茶繃淇濓紝涓嶆敮鎸佽鎿嶄綔");
+        }
+        Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌淇濋櫓鏂规");
+        }
+//        Date  reduceEndTime = DateUtil.getMontageDate(
+//                DateUtil.afterDateByType(new Date(),0,solutions.getDelValidDays()),3);
+
+//        Date  reduceEndTime = DateUtil.getMontageDate(new Date(),3);
+        int index = Constants.TWO;
+        Map<String,String> idCardMap = new HashMap<>();
+        for(MemberReduceImport model : dataList){
+            //鏍¢獙鍙傛暟鏄惁鍚堟硶
+            validReduceImportParam(model,idCardMap,index);
+            index += 1;
+        }
+        index = Constants.TWO;
+        for(MemberReduceImport model : dataList){
+            ApplyDetail detail =applyDetailJoinMapper.selectJoinOne(ApplyDetail.class,new MPJLambdaWrapper<ApplyDetail>()
+                            .selectAll(ApplyDetail.class)
+                            .selectAs(Worktype::getName,ApplyDetail::getWorkTypeName)
+                            .selectAs(DispatchUnit::getName,ApplyDetail::getDuName)
+//                            .selectAs(InsuranceApply::getStartTime,ApplyDetail::getStartTime)
+//                            .selectAs(InsuranceApply::getEndTime,ApplyDetail::getEndTime)
+                            .selectAs(InsuranceApply::getServerCost,ApplyDetail::getDetailServerCost)
+                            .leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId)
+                            .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId)
+                            .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId)
+                            .eq(ApplyDetail::getApplyId,insuranceApply.getId())
+                            .eq(ApplyDetail::getApplyId,insuranceApply.getId())
+                            .eq(ApplyDetail::getIdcardNo,model.getIdCard())
+                         /*   .le(ApplyDetail::getStartTime,DateUtil.getMontageDate(new Date(),1))*/
+                            .ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(new Date(),3))
+                            .orderByAsc(ApplyDetail::getEndTime)
+                            .last(" limit 1 ")
+            );
+            if(detail == null){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "褰撳墠淇濆崟涓嬶紝鍛樺伐銆�" + model.getName()+model.getIdCard() + "銆戦潪鍦ㄤ繚浜哄憳锛屾棤娉曡繘琛岃鎿嶄綔");
+            }
+            if(!StringUtils.equals(model.getName(), detail.getMemberName())){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "褰撳墠淇濆崟涓嬶紝鍛樺伐銆�" +model.getName()+ model.getIdCard() + "銆戜笌鍏剁櫥璁板湪淇濊褰曞鍚嶄笉涓�鑷达紝璇锋牳瀹炲~鍐欐纭啀鎿嶄綔");
+            }
+            if(!Constants.equalsInteger(Constants.ZERO, detail.getChangeStatus())){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "褰撳墠淇濆崟涓嬶紝鍛樺伐銆�" +model.getName()+ model.getIdCard() + "銆戝凡杩涜杩囧噺淇濈敵璇凤紝涓嶈兘鍐嶆杩涜璇ユ搷浣�");
+            }
+            model.setDuId(detail.getDuId());
+            model.setDuName(detail.getDuName());
+            model.setWorktypeId(detail.getWorktypeId());
+            model.setMemberId(detail.getMemberId());
+            model.setWorkTypeName(detail.getWorkTypeName());
+            //濡傛灉褰撳墠鏃ユ湡 灏忎簬 浜哄憳淇濆崟鏄庣粏璁板綍鐨勫紑濮嬫椂闂� 鍒欎娇鐢ㄥ紑濮嬫棩鏈�  寮�濮嬫棩鏈� = 缁撴潫鏃ユ湡  涓� 璐圭敤鍏ㄩ儴閫�鍥�
+            if(System.currentTimeMillis()<=detail.getStartTime().getTime()){
+                model.setFee(solutions.getPrice().multiply(new BigDecimal(-1)));
+            }else{
+                Date  reduceEndTime = DateUtil.getMontageDate(
+                        DateUtil.afterDateByType(new Date(),0,solutions.getDelValidDays()),3);
+                model.setFee(
+                        Constants.reduceFee(solutions,
+                                Objects.isNull(detail.getDetailServerCost())?solutions.getPrice():solutions.getPrice().add(detail.getDetailServerCost()),
+                                insuranceApply.getStartTime(),
+                                insuranceApply.getEndTime(),
+                                detail.getStartTime(),
+                                reduceEndTime).subtract(detail.getFee()));
+            }
+            index += 1;
+        }
+        return dataList;
+    }
+
+    private void validReduceImportParam(MemberReduceImport model, Map<String, String> idCardMap, int index) {
+        if(StringUtils.isBlank(model.getName())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹鍚嶄笉鑳戒负绌猴紒");
+        }
+        if(StringUtils.isBlank(model.getIdCard())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉鍙蜂笉鑳戒负绌猴紒");
+        }
+        if(StringUtils.isBlank(model.getIdCard())||model.getIdCard().length()!=18){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉銆�"+model.getIdCard()+"銆戞牸寮忎笉姝g‘锛�");
+        }
+        if(!IdcardUtil.isValidCard(model.getIdCard())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉銆�"+model.getIdCard()+"銆戜俊鎭笉姝g‘锛�");
+        }
+        if(Objects.nonNull(idCardMap.get(model.getIdCard()))){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鏂囨。涓"+index+"琛屾暟鎹韩浠借瘉鍙枫��"+model.getIdCard()+"銆戝瓨鍦ㄧ浉鍚屾暟鎹紒");
+        }
+        idCardMap.put(model.getIdCard(), model.getIdCard());
+    }
+    @Override
+    public List<MemberImport> importBatch(MultipartFile file,Integer  solutionId){
+        if(solutionId == null  ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝璇烽�夋嫨鏈夋晥鐨勬柟妗堝啀杩涜鎿嶄綔锛�");
+        }
+        LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        if(!loginUserInfo.getType().equals(Constants.ONE)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氫汉鍛樻棤娉曡繘琛岃鎿嶄綔");
+        }
+        if(Objects.isNull(solutionId)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍙傛暟閿欒 - 鏂规淇℃伅");
+        }
+        Solutions solutions = solutionsMapper.selectById(solutionId);
+        if(Objects.isNull(solutions)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鏂规淇℃伅");
+        }
         ExcelImporter ie = null;
         List<MemberImport> dataList =null;
         try {
@@ -385,17 +527,21 @@
         if(dataList == null || dataList.size() ==0){
             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝褰曞叆鏁版嵁涓虹┖锛�");
         }
-        List<String> idCardList = dataList.stream().map(m->m.getIdCard()).collect(Collectors.toList());
-        Set<String> set = new HashSet<>(idCardList);
-        if(idCardList.size() != set.size()){
-            throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝褰曞叆鏁版嵁瀛樺湪韬唤璇佸彿鐩稿悓鏁版嵁锛�");
+        int index = Constants.TWO;
+        Map<String,String> idCardMap = new HashMap<>();
+        for(MemberImport model : dataList){
+            //鏍¢獙鍙傛暟鏄惁鍚堟硶
+            validImportParam(model,idCardMap,dataList,index,solutions);
+            index += 1;
         }
         List<DispatchUnit> dispatchUnitList = new ArrayList<>();
-        if(!Objects.isNull(solutionId)){
-            dispatchUnitList  = dispatchUnitJoinMapper.selectJoinList(DispatchUnit.class,
+        List<SolutionWorktype> solutionWorktypeList = new ArrayList<>();
+        //2024骞�11鏈�6鏃�15:39:10 鍔犲叆 鏍规嵁鏂规鏄惁鏈変繚闄╂柟妗堣繘琛屽垽鏂�
+        if(Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)){
+            dispatchUnitList    = dispatchUnitJoinMapper.selectJoinList(DispatchUnit.class,
                     new MPJLambdaWrapper<DispatchUnit>()
                             .selectAll(DispatchUnit.class)
-                            .select("(select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.solution_id="+solutionId+" limit 1) as du_solution_id" )
+                            .select("(select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.solution_id="+solutionId+"  order by b.CHECK_DATE desc  limit 1) as du_solution_id" )
                             .eq(DispatchUnit::getIsdeleted,Constants.ZERO)
                             .eq(DispatchUnit::getStatus,Constants.ZERO)
                             .eq(DispatchUnit::getDataType,Constants.TWO)
@@ -414,38 +560,41 @@
                     dispatchUnit.setWorktypeList(worktypeList);
                 }
             }
+        }else{
+            //鏂规涓嶉�夋嫨娲鹃仯鍗曚綅鎯呭喌涓嬬殑涓氬姟
+            solutionWorktypeList = solutionWorktypeJoinMapper.selectJoinList(SolutionWorktype.class,
+                    new MPJLambdaWrapper<SolutionWorktype>()
+                            .selectAll(SolutionWorktype.class)
+                            .selectAs(Worktype::getName,SolutionWorktype::getWorktypeName)
+                            .leftJoin(Worktype.class,Worktype::getId,SolutionWorktype::getWorktypeId)
+                            .eq(SolutionWorktype::getSolutionId,solutions.getId())
+            );
+            if(CollectionUtils.isEmpty(solutionWorktypeList)){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝淇濋櫓鏂规涓嬫湭鏌ヨ鍒板伐绉嶄俊鎭�");
+            }
         }
-        long index = Constants.TWO;
+
+        index = Constants.TWO;
         for(MemberImport model : dataList){
-            if(StringUtils.isBlank(model.getIdCard())||model.getIdCard().length()!=18){
-                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉淇℃伅寮傚父锛�");
-            }
-            if(!IdcardUtil.isValidCard(model.getIdCard())){
-                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉淇℃伅寮傚父锛�");
-            }
-            if(StringUtils.isBlank(model.getName())){
-                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹鍚嶄俊鎭紓甯革紒");
-            }
-            index = index + Constants.ONE;
-            if(CollectionUtils.isNotEmpty(list)){
-                Optional<Member>  memberOptional= list.stream().filter(m->m.getIdcardNo().equals(model.getIdCard())).findFirst();
-                if(memberOptional.isPresent()){
-                    Member member =  memberOptional.get();
-                    model.setIdCard(member.getIdcardNo());
-                    model.setSex(member.getSex());
-                }else{
-                    model.setSex(Constants.getSexByIdCard(model.getIdCard()));
-                }
-            }else{
-                model.setSex(Constants.getSexByIdCard(model.getIdCard()));
-            }
-            if(StringUtils.isNotBlank(model.getDuName())&&CollectionUtils.isNotEmpty(dispatchUnitList)){
+            //妫�鏌ユ淳閬e崟浣嶅拰宸ョ鏈夋晥鎬�
+            dealDuAndWorktype(model,index,dispatchUnitList,solutions,solutionWorktypeList);
+            index += 1;
+            model.setSex(Constants.getSexByIdCard(model.getIdCard()));
+        }
+        return dataList;
+    }
+
+
+    private void dealDuAndWorktype(MemberImport model, int index, List<DispatchUnit> dispatchUnitList , Solutions  solutions,List<SolutionWorktype> solutionWorktypeList) {
+        //2024骞�11鏈�6鏃�15:39:10 鍔犲叆 鏍规嵁鏂规鏄惁鏈変繚闄╂柟妗堣繘琛屽垽鏂�
+        if(Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)){
+            if(CollectionUtils.isNotEmpty(dispatchUnitList)){
                 Optional<DispatchUnit>  dispatchUnitOptional= dispatchUnitList.stream().filter(m->m.getName().equals(model.getDuName())).findFirst();
                 if(dispatchUnitOptional.isPresent()){
                     DispatchUnit dispatchUnit =  dispatchUnitOptional.get();
                     model.setDuId(dispatchUnit.getId());
                     if(StringUtils.isNotBlank(model.getWorkTypeName())&&CollectionUtils.isNotEmpty(dispatchUnit.getWorktypeList())){
-                        Optional<Worktype>  worktypeOptional= dispatchUnit.getWorktypeList().stream().filter(m->m.getName().equals(model.getWorkTypeName())).findFirst();
+                        Optional<Worktype>  worktypeOptional= dispatchUnit.getWorktypeList().stream().filter(m->m.getName().replaceAll(" ","").equals(model.getWorkTypeName().replaceAll(" ",""))).findFirst();
                         if(worktypeOptional.isPresent()){
                             Worktype worktype = worktypeOptional.get();
                             model.setWorktypeId(worktype.getId());
@@ -454,13 +603,48 @@
                 }
             }
             if(Objects.isNull(model.getDuId())){
-                model.setWorkTypeName(null);
-                model.setDuName(null);
-            }else if(Objects.isNull(model.getWorktypeId())){
-                model.setWorkTypeName(null);
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹淳閬e崟浣嶃��"+model.getDuName()+"銆戜笉姝g‘锛�");
+            }
+        }else{
+            Optional<SolutionWorktype>  worktypeOptional= solutionWorktypeList.stream().filter(m->m.getWorktypeName().replaceAll(" ","")
+                    .equals(model.getWorkTypeName().replaceAll(" ",""))).findFirst();
+            if(worktypeOptional.isPresent()){
+                SolutionWorktype worktype = worktypeOptional.get();
+                model.setWorktypeId(worktype.getId());
             }
         }
-        return dataList;
+        if(Objects.isNull(model.getWorktypeId())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹伐绉嶃��"+model.getWorkTypeName()+"銆戜笉姝g‘锛�");
+        }
+    }
+
+    private void validImportParam(MemberImport model, Map<String, String> idCardMap, List<MemberImport> dataList,int index,Solutions solutions) {
+        if(StringUtils.isBlank(model.getName())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹鍚嶄笉鑳戒负绌猴紒");
+        }
+        if(StringUtils.isBlank(model.getIdCard())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉鍙蜂笉鑳戒负绌猴紒");
+        }
+        //2024骞�11鏈�6鏃�15:39:10 鍔犲叆 鏍规嵁鏂规鏄惁鏈変繚闄╂柟妗堣繘琛屽垽鏂�
+        if(Constants.equalsInteger(solutions.getHasDispatchUnit(),Constants.ZERO)){
+            if(StringUtils.isBlank(model.getDuName())){
+                throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹淳閬e崟浣嶄笉鑳戒负绌猴紒");
+            }
+        }
+        if(StringUtils.isBlank(model.getWorkTypeName())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹伐绉嶄笉鑳戒负绌猴紒");
+        }
+        if(StringUtils.isBlank(model.getIdCard())||model.getIdCard().length()!=18){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉銆�"+model.getIdCard()+"銆戞牸寮忎笉姝g‘锛�");
+        }
+        if(!IdcardUtil.isValidCard(model.getIdCard())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉銆�"+model.getIdCard()+"銆戜俊鎭笉姝g‘锛�");
+        }
+        if(Objects.nonNull(idCardMap.get(model.getIdCard()))){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鏂囨。涓"+index+"琛屾暟鎹韩浠借瘉鍙枫��"+model.getIdCard()+"銆戝瓨鍦ㄧ浉鍚屾暟鎹紒");
+        }
+        idCardMap.put(model.getIdCard(), model.getIdCard());
+
     }
 
 

--
Gitblit v1.9.3