From f5142bcef11bddb6c80ce7ba2ff083a58eab836a Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期六, 07 五月 2022 16:22:26 +0800
Subject: [PATCH] 花城优化
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml | 4 ++--
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidDangerMemberMapper.xml | 2 +-
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidDangerMemberMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidDangerMemberMapper.xml
index e9fe169..ecb80e9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidDangerMemberMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidDangerMemberMapper.xml
@@ -42,7 +42,7 @@
</if>
<if test="commonPage.isAddress !=null">
<if test="commonPage.isAddress == 0">
- and t2.local_city is null
+ and (t2.local_city is null OR LENGTH(TRIM(t2.local_city)) = 0)
</if>
<if test="commonPage.isAddress == 1">
and t2.local_city is not null AND LENGTH(TRIM(t2.local_city)) > 0
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
index bc166ae..37581db 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml
@@ -36,7 +36,7 @@
</if>
<if test="commonPage.isAddress !=null">
<if test="commonPage.isAddress == 0">
- and local_city is null
+ and (local_city is null OR LENGTH(TRIM(local_city)) = 0)
</if>
<if test="commonPage.isAddress == 1">
and local_city is not null AND LENGTH(TRIM(local_city)) > 0
@@ -72,7 +72,7 @@
</if>
<if test="commonPage.isAddress !=null">
<if test="commonPage.isAddress == 0">
- and local_city is null
+ and (local_city is null OR LENGTH(TRIM(local_city)) = 0)
</if>
<if test="commonPage.isAddress == 1">
and local_city is not null AND LENGTH(TRIM(local_city)) > 0
--
Gitblit v1.7.1