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