From e834a97738f65af115daae14116923e37aa3d2f8 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 18 四月 2025 11:35:42 +0800
Subject: [PATCH] zjh20250418

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java |  266 +++++++++++++++++++++--------------------------------
 1 files changed, 106 insertions(+), 160 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
index da5cfba..b13277d 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReservationController.java
@@ -163,7 +163,7 @@
                 }
             }
         } catch (Exception e) {
-            ExcelUtils.exportTemplate(response,"鍥綋棰勭害Excel妯$増",TjReservation.class);
+            ExcelUtils.exportTemplate(response, "鍥綋棰勭害Excel妯$増", TjReservation.class);
             throw new RuntimeException(e);
         }
     }
@@ -380,7 +380,7 @@
 
         List<String> wrongList = new ArrayList<>();
         List<TjReservation> rightList = new ArrayList<>();
-        List<TjReservation> yyList = new ArrayList<>();
+        List<String> yyList = new ArrayList<>();
         Map<String, Object> map = new HashMap<>();
         List<TjDwGrouping> groupingMans = null;//鐢�
         List<TjDwGrouping> groupingWoMans = null;//濂�
@@ -409,181 +409,126 @@
             int count = 0;//鎬昏浜烘暟
             int manCount = 0;//鐢风粍浜烘暟
             int woManCount = 0;//濂崇粍浜烘暟
-            List<String> ids=new ArrayList<>();
+            List<String> ids = new ArrayList<>();
 
-            String errMsg="";
+//            String errMsg = "";
             for (TjReservation tjReservation : tjReservations) {
+                String name = tjReservation.getName();
                 String idCard = tjReservation.getIdCard();
                 String phoe = tjReservation.getPhoe();
-                idCard= idCard.replaceAll("[',锛�;.銆� 鈥樷�淽","");
+                name = name.replaceAll("[',锛�;.銆� 鈥樷�淽", "").replaceAll(" ", "");
+                phoe = phoe.replaceAll("[',锛�;.銆� 鈥樷�淽", "").replaceAll(" ", "");
+                idCard = idCard.replaceAll("[',锛�;.銆� 鈥樷�淽", "").replaceAll(" ", "");
 
                 if (!StringUtils.isBlank(idCard) || !StringUtils.isBlank(phoe) || null != tjReservation.getDwxm()) {
                     //灏嗙瀛﹁鏁扮殑鎵嬫満鍙疯浆鎹㈡垚鏂囨湰褰㈠紡
                     phoe = MatchUtils.translateToPlainStr(tjReservation.getPhoe());
 
-                    if(!ids.isEmpty() && ids.contains(tjReservation.getIdCard())){
+                    if (!ids.isEmpty() && ids.contains(idCard)) {
                         TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
-                        return AjaxResult.error("姝よ韩浠借瘉鍙�: "+tjReservation.getIdCard()+" 閲嶅,璇锋牳瀵瑰悗涓婁紶!");
+                        return AjaxResult.error("姝よ韩浠借瘉鍙�: " + tjReservation.getIdCard() + " 閲嶅,璇锋牳瀵瑰悗涓婁紶!");
                     }
 
-                    ids.add(tjReservation.getIdCard());
+                    ids.add(idCard);
 
-                    //                if (sfjysfzh.equalsIgnoreCase("Y") || sfjysjh.equalsIgnoreCase("Y")) {
-                    if ((sfjysfzh.equalsIgnoreCase("Y") && !MatchUtils.isIdCard(idCard)) ||
-                            (sfjysjh.equalsIgnoreCase("Y") && !MatchUtils.isMobileNO(phoe))) {
-                        wrongList.add(tjReservation.getName());
-                        errMsg="韬唤璇佸彿/鎵嬫満鍙� 鏍煎紡涓嶅噯纭�";
-                        log.info(tjReservation.getName()+idCard+MatchUtils.isIdCard(idCard)+MatchUtils.isMobileNO(phoe));
-                    }else {
+                    if (!Objects.equals(tjReservation.getSex(), MatchUtils.getSexByIdCard(idCard))){
+                        wrongList.add(tjReservation.getName() + " " + tjReservation.getIdCard()+"鎬у埆 涓嶅噯纭�");
+                        log.info(tjReservation.getName() + " " + idCard);
+                    }
 
-
-                        tjReservation.setPhoe(phoe);
-
-                        //骞撮緞
-                        tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
-                        //鍑虹敓鏃ユ湡
-                        try {
-                            tjReservation.setBirthday(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()));
-                        } catch (Exception e) {
-                            return AjaxResult.error("韬唤璇佸彿涓嶆纭�");
+                        if ((sfjysfzh.equalsIgnoreCase("Y") && !MatchUtils.isIdCard(idCard)) ||
+                                (sfjysjh.equalsIgnoreCase("Y") && !MatchUtils.isMobileNO(phoe))) {
+                            wrongList.add(tjReservation.getName() + " " + tjReservation.getIdCard()+"韬唤璇佸彿/鎵嬫満鍙� 鏍煎紡涓嶅噯纭�");
+//                            errMsg = "韬唤璇佸彿/鎵嬫満鍙� 鏍煎紡涓嶅噯纭�";
+                            log.info(tjReservation.getName() + " " + idCard + MatchUtils.isIdCard(idCard) + " " + phoe + " " + MatchUtils.isMobileNO(phoe));
                         }
+//                        else {
 
-                        TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm().trim()));
-                        if (null != dwDept) {
-                            for (TjDwGrouping groupingMan : groupingMans) {
-                                if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
-                                    tjReservation.setGroupingId(groupingMan.getId());
-                                    tjReservation.setGroupingName(groupingMan.getGroupingName());
-                                    tjReservation.setYsPrice(groupingMan.getYsPrice());
-                                    //鍚堣
-                                    hjMoney = hjMoney.add(groupingMan.getYsPrice());
-                                    count += 1;
-                                    //鐢风粍浜烘暟
-                                    manMoney = manMoney.add(groupingMan.getYsPrice());
-                                    manCount += 1;
-                                }
+                            tjReservation.setPhoe(phoe);
+
+                            tjReservation.setName(name);
+
+                            tjReservation.setIdCard(idCard);
+
+                            //骞撮緞
+                            tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard().replaceAll(" ", ""))));
+                            //鍑虹敓鏃ユ湡
+                            try {
+                                tjReservation.setBirthday(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard().replaceAll(" ", "")));
+                            } catch (Exception e) {
+//                            return AjaxResult.error("韬唤璇佸彿涓嶆纭�");
                             }
 
-                            for (TjDwGrouping groupingWoMan : groupingWoMans) {
-                                if (null != groupingWoMan && groupingWoMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingWoMan.getDwDeptId().equals(dwDept.getId())) {
-                                    tjReservation.setGroupingId(groupingWoMan.getId());
-                                    tjReservation.setGroupingName(groupingWoMan.getGroupingName());
-                                    tjReservation.setYsPrice(groupingWoMan.getYsPrice());
-                                    //鍚堣
-                                    hjMoney = hjMoney.add(groupingWoMan.getYsPrice());
-                                    count += 1;
-                                    woManMoney = woManMoney.add(groupingWoMan.getYsPrice());
-                                    woManCount += 1;
-                                }
-                            }
-                            for (TjDwGrouping groupingWz : groupingWzs) {
-                                if (null != groupingWz && groupingWz.getDwDeptId().equals(dwDept.getId())) {
-                                    tjReservation.setGroupingId(groupingWz.getId());
-                                    tjReservation.setGroupingName(groupingWz.getGroupingName());
-                                    tjReservation.setYsPrice(groupingWz.getYsPrice());
-                                    //鍚堣
-                                    hjMoney = hjMoney.add(groupingWz.getYsPrice());
-                                    count += 1;
-                                    if (tjReservation.getSex() == 0) {
-                                        manMoney = manMoney.add(groupingWz.getYsPrice());
+                            TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().
+                                    eq(TjDwDept::getDwDeptName, tjReservation.getDwxm().trim()).eq(TjDwDept::getDwId,dwId));
+                            if (null != dwDept) {
+                                for (TjDwGrouping groupingMan : groupingMans) {
+                                    if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
+                                        tjReservation.setGroupingId(groupingMan.getId());
+                                        tjReservation.setGroupingName(groupingMan.getGroupingName());
+                                        tjReservation.setYsPrice(groupingMan.getYsPrice());
+                                        //鍚堣
+                                        hjMoney = hjMoney.add(groupingMan.getYsPrice());
+                                        count += 1;
+                                        //鐢风粍浜烘暟
+                                        manMoney = manMoney.add(groupingMan.getYsPrice());
                                         manCount += 1;
                                     }
-                                    if (tjReservation.getSex() == 1) {
-                                        woManMoney = woManMoney.add(groupingWz.getYsPrice());
+                                }
+
+                                for (TjDwGrouping groupingWoMan : groupingWoMans) {
+                                    if (null != groupingWoMan && groupingWoMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingWoMan.getDwDeptId().equals(dwDept.getId())) {
+                                        tjReservation.setGroupingId(groupingWoMan.getId());
+                                        tjReservation.setGroupingName(groupingWoMan.getGroupingName());
+                                        tjReservation.setYsPrice(groupingWoMan.getYsPrice());
+                                        //鍚堣
+                                        hjMoney = hjMoney.add(groupingWoMan.getYsPrice());
+                                        count += 1;
+                                        woManMoney = woManMoney.add(groupingWoMan.getYsPrice());
                                         woManCount += 1;
                                     }
-
                                 }
-                            }
-                            LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
-                            wq.eq(TjReservation::getIdCard, tjReservation.getIdCard());
-                            wq.eq(TjReservation::getIsExpire, 2);
-                            TjReservation one = tjReservationService.getOne(wq);
-                            if (null != one) {
-                                yyList.add(one);
-                            }
-                            rightList.add(tjReservation);
-                        } else {
-                            wrongList.add(tjReservation.getName());
-                            errMsg="鎵�閫夐」鐩悕 涓嶆纭�";
-                        }
-                    }
-                    //                }
-                    //                else {
-                    //                    //灏嗙瀛﹁鏁扮殑鎵嬫満鍙疯浆鎹㈡垚鏂囨湰褰㈠紡
-                    //                    String str = MatchUtils.translateToPlainStr(tjReservation.getPhoe());
-                    //                    tjReservation.setPhoe(str);
-                    //
-                    //                    //骞撮緞
-                    //                    tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
-                    //                    //鍑虹敓鏃ユ湡
-                    //                    tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
-                    //
-                    //                    TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm()));
-                    //                    if (null != dwDept) {
-                    //                        for (TjDwGrouping groupingMan : groupingMans) {
-                    //                            if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
-                    //                                tjReservation.setGroupingId(groupingMan.getId());
-                    //                                tjReservation.setGroupingName(groupingMan.getGroupingName());
-                    //                                tjReservation.setYsPrice(groupingMan.getYsPrice());
-                    //                                //鍚堣
-                    //                                hjMoney = hjMoney.add(groupingMan.getYsPrice());
-                    //                                count += 1;
-                    //                                //鐢风粍浜烘暟
-                    //                                manMoney = manMoney.add(groupingMan.getYsPrice());
-                    //                                manCount += 1;
-                    //                            }
-                    //                        }
-                    //
-                    //                        for (TjDwGrouping groupingWoMan : groupingWoMans) {
-                    //                            if (null != groupingWoMan && groupingWoMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingWoMan.getDwDeptId().equals(dwDept.getId())) {
-                    //                                tjReservation.setGroupingId(groupingWoMan.getId());
-                    //                                tjReservation.setGroupingName(groupingWoMan.getGroupingName());
-                    //                                tjReservation.setYsPrice(groupingWoMan.getYsPrice());
-                    //                                //鍚堣
-                    //                                hjMoney = hjMoney.add(groupingWoMan.getYsPrice());
-                    //                                count += 1;
-                    //                                woManMoney = woManMoney.add(groupingWoMan.getYsPrice());
-                    //                                woManCount += 1;
-                    //                            }
-                    //                        }
-                    //                        for (TjDwGrouping groupingWz : groupingWzs) {
-                    //                            if (null != groupingWz && groupingWz.getDwDeptId().equals(dwDept.getId())) {
-                    //                                tjReservation.setGroupingId(groupingWz.getId());
-                    //                                tjReservation.setGroupingName(groupingWz.getGroupingName());
-                    //                                tjReservation.setYsPrice(groupingWz.getYsPrice());
-                    //                                //鍚堣
-                    //                                hjMoney = hjMoney.add(groupingWz.getYsPrice());
-                    //                                count += 1;
-                    //                                if (tjReservation.getSex() == 0) {
-                    //                                    manMoney = manMoney.add(groupingWz.getYsPrice());
-                    //                                    manCount += 1;
-                    //                                }
-                    //                                if (tjReservation.getSex() == 1) {
-                    //                                    woManMoney = woManMoney.add(groupingWz.getYsPrice());
-                    //                                    woManCount += 1;
-                    //                                }
-                    //
-                    //                            }
-                    //                        }
-                    //                        LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
-                    //                        wq.eq(TjReservation::getIdCard, tjReservation.getIdCard());
-                    //                        wq.eq(TjReservation::getIsExpire, 2);
-                    //                        TjReservation one = tjReservationService.getOne(wq);
-                    //                        if (null != one) {
-                    //                            yyList.add(one);
-                    //                        }
-                    //                        rightList.add(tjReservation);
-                    //                    } else {
-                    //                        wrongList.add(tjReservation.getName());
-                    //                    }
-                    //                }
+                                for (TjDwGrouping groupingWz : groupingWzs) {
+                                    if (null != groupingWz && groupingWz.getDwDeptId().equals(dwDept.getId())) {
+                                        tjReservation.setGroupingId(groupingWz.getId());
+                                        tjReservation.setGroupingName(groupingWz.getGroupingName());
+                                        tjReservation.setYsPrice(groupingWz.getYsPrice());
+                                        //鍚堣
+                                        hjMoney = hjMoney.add(groupingWz.getYsPrice());
+                                        count += 1;
+                                        if (tjReservation.getSex() == 0) {
+                                            manMoney = manMoney.add(groupingWz.getYsPrice());
+                                            manCount += 1;
+                                        }
+                                        if (tjReservation.getSex() == 1) {
+                                            woManMoney = woManMoney.add(groupingWz.getYsPrice());
+                                            woManCount += 1;
+                                        }
 
-                } else {
-                    wrongList.add(tjReservation.getName());
-                    errMsg="韬唤璇佸彿/鎵嬫満鍙�/椤圭洰鍚嶄负绌�";
+                                    }
+                                }
+                                LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
+                                wq.eq(TjReservation::getIdCard, tjReservation.getIdCard());
+                                wq.eq(TjReservation::getIsExpire, 2);
+                                TjReservation one = tjReservationService.getOne(wq);
+                                if (null != one) {
+                                    yyList.add(one.getName() + " " + tjReservation.getIdCard());
+                                } else {
+                                    rightList.add(tjReservation);
+                                }
+
+                            } else {
+                                wrongList.add(tjReservation.getName() + " " + tjReservation.getIdCard()+"璇ュ崟浣� 濂楅鍒嗙被鍚嶅~鍐� 涓嶆纭�");
+                            }
+//                        }
+
+                }
+                else {
+                    wrongList.add(tjReservation.getName()+"韬唤璇佸彿/鎵嬫満鍙�/濂楅鍒嗙被鍚嶅悕涓虹┖");
                 }
             }
+
+
             if (!yyList.isEmpty()) {
                 map.put("list", yyList);
                 map.put("hjMoney", hjMoney);
@@ -593,7 +538,7 @@
             if (!wrongList.isEmpty()) {
                 map.put("list", wrongList);
                 map.put("hjMoney", hjMoney);
-                return AjaxResult.error("鎿嶄綔澶辫触, 璇疯鐪熸牳瀵逛俊鎭悗閲嶆柊瀵煎叆!!!"+errMsg, map);
+                return AjaxResult.error("鎿嶄綔澶辫触, 璇疯鐪熸牳瀵归敊璇俊鎭悗閲嶆柊瀵煎叆!!!", map);
             } else {
                 map.put("list", rightList);
                 map.put("count", count);
@@ -606,7 +551,7 @@
             }
         } catch (NoTransactionException e) {
 //            throw new RuntimeException(e);
-            log.error(String.valueOf(e),e.getMessage());
+            log.error(String.valueOf(e), e.getMessage());
             return AjaxResult.error();
         }
     }
@@ -934,21 +879,21 @@
         JSONObject parseObj = JSONUtil.parseObj(payTypeGlTjType);
         if (null != rightList && !rightList.isEmpty()) {
 
-            List<String> ids=new ArrayList<>();
+            List<String> ids = new ArrayList<>();
 
             for (TjReservation reservation : rightList) {
 
-                if(!ids.isEmpty() && ids.contains(reservation.getIdCard())){
+                if (!ids.isEmpty() && ids.contains(reservation.getIdCard())) {
                     TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
-                    return AjaxResult.error("姝よ韩浠借瘉鍙�: "+reservation.getIdCard()+" 閲嶅,璇锋牳瀵瑰悗涓婁紶!");
+                    return AjaxResult.error("姝よ韩浠借瘉鍙�: " + reservation.getIdCard() + " 閲嶅,璇锋牳瀵瑰悗涓婁紶!");
 
                 }
-                reservation.setName(reservation.getName().replaceAll("銆�","").replaceAll(" ",""));
+                reservation.setName(reservation.getName().replaceAll("銆�", "").replaceAll(" ", ""));
                 ids.add(reservation.getIdCard());
 
                 TjDwGrouping dwGrouping = dwGroupingService.getById(reservation.getGroupingId());
 
-                TjDwDept dwDept = dwDeptService.getById(dwGrouping.getDwDeptId());
+//                TjDwDept dwDept = dwDeptService.getById(dwGrouping.getDwDeptId());
 
                 LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
                 wq.eq(TjReservation::getIdCard, reservation.getIdCard());
@@ -1046,13 +991,14 @@
 
     /**
      * 鍥綋棰勭害浣撴淇℃伅 鑱斿姩涓嬫媺妗�
+     *
      * @param pid
      * @param type
      * @return
      */
     @GetMapping("/linkage")
     public String linkage(@RequestParam("pid") String pid, @RequestParam("type") String type) {
-        switch (type){
+        switch (type) {
             case "1":
                 List<DictComp> list = dictCompService.list();
                 List<HashMap<String, Object>> collect = list.stream().map(i -> {
@@ -1073,7 +1019,7 @@
                 return JSONUtil.toJsonStr(collect1);
             case "3":
                 LambdaQueryWrapper<TjDwGrouping> wrapper = new LambdaQueryWrapper<>();
-                wrapper.eq(TjDwGrouping::getDwDeptId,pid);
+                wrapper.eq(TjDwGrouping::getDwDeptId, pid);
                 List<TjDwGrouping> list2 = tjDwGroupingService.list(wrapper);
                 List<HashMap<String, Object>> collect2 = list2.stream().map(i -> {
                     HashMap<String, Object> hashMap = new HashMap<>();

--
Gitblit v1.8.0