From 84e8a5e53cd8b56193211c8b99d1a43be2b46434 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 07 五月 2024 21:11:18 +0800
Subject: [PATCH] Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV

---
 pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DtoDivide.java  |    2 
 pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrDivideMapper.xml                              |   13 +++---
 pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java |   49 ++++++++++++------------
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoPr/PrDivide.java                    |    8 ++--
 pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrIntakeMapper.xml                              |    8 ++--
 5 files changed, 40 insertions(+), 40 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoPr/PrDivide.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoPr/PrDivide.java
index c88ed99..1a63f59 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoPr/PrDivide.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoPr/PrDivide.java
@@ -61,7 +61,7 @@
      */
     @JSONField(serializeUsing= ObjectWriterImplToString.class)
     @Schema(description = "鎵�鍦ㄦ潙ID", requiredMode = Schema.RequiredMode.REQUIRED)
-    @NotNull(message = "鎵�鍦ㄦ潙涓嶈兘涓虹┖")
+//    @NotNull(message = "鎵�鍦ㄦ潙涓嶈兘涓虹┖")
     private Long villageid;
 
     /**
@@ -84,7 +84,7 @@
      * 瑕嗙洊鏉�
      */
     @Schema(description = "瑕嗙洊鏉�", requiredMode = Schema.RequiredMode.REQUIRED)
-    @Length(message = "瑕嗙洊鏉戜笉澶т簬{max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 1, max = 100)
+    @Length(message = "瑕嗙洊鏉戜笉澶т簬{max}瀛�", max = 100)
     private String villages;
 
     /**
@@ -104,7 +104,7 @@
      */
     @Schema(description = "鑱旂郴鐢佃瘽", requiredMode = Schema.RequiredMode.REQUIRED)
     //@NotBlank(message = "鑱旂郴鐢佃瘽涓嶈兘涓虹┖")
-    @Length(message = "鍐滆仈绯荤數璇濆繀椤粄max}浣嶆暟鎹�", min = 11, max = 11)
+    @Length(message = "鍐滆仈绯荤數璇濆繀椤粄max}浣嶆暟鎹�",  max = 11)
     private String phone;
 
     /**
@@ -125,7 +125,7 @@
      * 澶囨敞淇℃伅
      */
     @Schema(description = "澶囨敞", requiredMode = Schema.RequiredMode.NOT_REQUIRED)
-    @Length(message = "澶囨敞涓嶅ぇ浜巤max}瀛楋紝涓嶅皬浜巤min}瀛�", min = 1, max = 200)
+    @Length(message = "澶囨敞涓嶅ぇ浜巤max}瀛�", max = 200)
     private String remarks;
 
     /**
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrDivideMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrDivideMapper.xml
index f50103b..8f5ca51 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrDivideMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrDivideMapper.xml
@@ -239,9 +239,9 @@
         COUNT(*) AS recordCount
     FROM pr_divide divi
         INNER JOIN ba_block blo ON divi.blockId = blo.id
-        INNER JOIN ba_district country ON divi.countyId = country.id
-        INNER JOIN ba_district town ON divi.townId = town.id
-        INNER JOIN ba_district village ON divi.villageid = village.id
+        Left JOIN ba_district country ON divi.countyId = country.id
+        Left JOIN ba_district town ON divi.townId = town.id
+        Left JOIN ba_district village ON divi.villageid = village.id
         , (SELECT @i:=0) AS itable
     <where>
        divi. deleted = 0
@@ -275,16 +275,15 @@
       divi.operateDt
     FROM pr_divide divi
         INNER JOIN ba_block blo ON divi.blockId = blo.id
-        INNER JOIN ba_district country ON divi.countyId = country.id
-        INNER JOIN ba_district town ON divi.townId = town.id
-        INNER JOIN ba_district village ON divi.villageid = village.id
+        Left JOIN ba_district country ON divi.countyId = country.id
+        Left JOIN ba_district town ON divi.townId = town.id
+        Left JOIN ba_district village ON divi.villageid = village.id
         , (SELECT @i:=0) AS itable
     <where>
        divi. deleted = 0
       <if test = "divideName != null and divideName !=''">
         AND divi.name LIKE CONCAT('%',#{divideName},'%')
       </if>
-
 
       <if test = "blockId != null and blockId !=''">
         AND divi.blockId = #{blockId}
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrIntakeMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrIntakeMapper.xml
index c99a293..720841c 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrIntakeMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/PrIntakeMapper.xml
@@ -227,11 +227,11 @@
         AND ge.name LIKE CONCAT('%', #{intakeName}, '%')
       </if>
 
-      <if test = "divideId != null">
+      <if test = "divideId != null and divideId !=''">
         AND divi.id = #{divideId}
       </if>
 
-      <if test = "blockId != null">
+      <if test = "blockId != null and blockId !=''">
         AND blo.id = #{blockId}
       </if>
 
@@ -283,11 +283,11 @@
         AND ge.name LIKE CONCAT('%', #{intakeName}, '%')
       </if>
 
-      <if test = "divideId != null">
+      <if test = "divideId != null and divideId !=''">
         AND divi.id = #{divideId}
       </if>
 
-      <if test = "blockId != null">
+      <if test = "blockId != null and blockId !=''">
         AND blo.id = #{blockId}
       </if>
 
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java
index d89f165..167cecd 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java
@@ -134,20 +134,21 @@
         // 鎺ユ敹鏉戠紪鍙凤紙涓婚敭锛�
         Long villageId = po.getVillageId();
 
-        /**
-         * 鑾峰彇5绾ц鏀垮尯鍒掍俊鎭�
-         */
-        Map map_districts = Optional.ofNullable(divideSv.getDistrictsByVillageId(villageId)).orElse(new HashMap());
-        if(map_districts.size() <= 0) {
-            return BaseResponseUtils.buildFail("鍖哄垝淇℃伅鏈夎");
-        }
-
         PrDivide prDivide = DtoToDividePojo.INSTANCT.po2vo(po);
 
-        Long countryId = Long.parseLong(map_districts.get("countryId").toString());
-        Long townId = Long.parseLong(map_districts.get("townId").toString());
-        prDivide.setCountyid(countryId);
-        prDivide.setTownid(townId);
+        if (villageId!=null){
+            /**
+             * 鑾峰彇5绾ц鏀垮尯鍒掍俊鎭�
+             */
+            Map map_districts = Optional.ofNullable(divideSv.getDistrictsByVillageId(villageId)).orElse(new HashMap());
+            if(map_districts.size() <= 0) {
+                return BaseResponseUtils.buildFail("鍖哄垝淇℃伅鏈夎");
+            }
+            Long countryId = Long.parseLong(map_districts.get("countryId").toString());
+            Long townId = Long.parseLong(map_districts.get("townId").toString());
+            prDivide.setCountyid(countryId);
+            prDivide.setTownid(townId);
+        }
 
         Date operateTime = new Date();
         prDivide.setOperatedt(operateTime);
@@ -220,19 +221,19 @@
         // 鎺ユ敹鏉戠紪鍙凤紙涓婚敭锛�
         Long villageId = po.getVillageid();
 
-        /**
-         * 鑾峰彇5绾ц鏀垮尯鍒掍俊鎭�
-         */
-        Map map_districts = Optional.ofNullable(divideSv.getDistrictsByVillageId(villageId)).orElse(new HashMap());
-        if(map_districts.size() <= 0) {
-            return BaseResponseUtils.buildFail("鍖哄垝淇℃伅鏈夎");
+        if (villageId!=null){
+            /**
+             * 鑾峰彇5绾ц鏀垮尯鍒掍俊鎭�
+             */
+            Map map_districts = Optional.ofNullable(divideSv.getDistrictsByVillageId(villageId)).orElse(new HashMap());
+            if(map_districts.size() <= 0) {
+                return BaseResponseUtils.buildFail("鍖哄垝淇℃伅鏈夎");
+            }
+            Long countryId = Long.parseLong(map_districts.get("countryId").toString());
+            Long townId = Long.parseLong(map_districts.get("townId").toString());
+            po.setCountyid(countryId);
+            po.setTownid(townId);
         }
-
-        Long countryId = Long.parseLong(map_districts.get("countryId").toString());
-        Long townId = Long.parseLong(map_districts.get("townId").toString());
-
-        po.setCountyid(countryId);
-        po.setTownid(townId);
 
         Date operateTime = new Date();
         po.setOperatedt(operateTime);
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DtoDivide.java b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DtoDivide.java
index ee84f0c..996457b 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DtoDivide.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DtoDivide.java
@@ -22,7 +22,7 @@
      * 鎵�鍦ㄦ潙
      */
     @Schema(description = "鎵�鍦ㄦ潙ID", requiredMode = Schema.RequiredMode.REQUIRED)
-    @NotNull(message = "鎵�鍦ㄦ潙涓嶈兘涓虹┖")
+//    @NotNull(message = "鎵�鍦ㄦ潙涓嶈兘涓虹┖")
     private Long villageId;
 
     /**

--
Gitblit v1.8.0