From a3a28d61f8786e275f8db3db8c04e17bdb4c2bbe Mon Sep 17 00:00:00 2001
From: Null <281575458@qq.com>
Date: 星期六, 20 三月 2021 12:11:58 +0800
Subject: [PATCH] 小区名称搜索

---
 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java |   10 +++++-----
 1 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
index 4dd3947..e0980ef 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
@@ -83,7 +83,7 @@
             " END AS sex, " +
             " t.phone, " +
             " YEAR ( now( ) ) - YEAR ( substring( t.id_card, 7, 8 ) ) age, " +
-            " t1.area_name, " +
+            " t1.area_name as areaName, " +
             " t.political_outlook politicalOutlook, " +
             " CONCAT( " +
             " IF " +
@@ -108,8 +108,8 @@
             "<if test='pageInputUserDTO.phone != null and pageInputUserDTO.phone.trim() != &quot;&quot;'>" +
             " and t.phone like concat(#{pageInputUserDTO.phone},'%')  " +
             " </if> " +
-            "<if test='pageInputUserDTO.areaId != null and pageInputUserDTO.areaId.trim() != &quot;&quot;'>" +
-            " and t.area_id = #{pageInputUserDTO.areaId}  " +
+            "<if test='pageInputUserDTO.areaName != null and pageInputUserDTO.areaName.trim() != &quot;&quot;'>" +
+            "AND t1.`area_name` like concat(#{pageInputUserDTO.areaName},'%')   " +
             " </if> " +
             " group by t.id_card "+
             "</script>")
@@ -153,7 +153,7 @@
             " END AS sex, " +
             " t.phone, " +
             " YEAR ( now( ) ) - YEAR ( substring( t.id_card, 7, 8 ) ) age, " +
-            " t1.area_name, " +
+            " t1.area_name as areaName, " +
             " t.political_outlook politicalOutlook, " +
             " CONCAT( " +
             " IF " +
@@ -181,7 +181,7 @@
             " and t.phone like concat(#{pageInputUserDTO.phone},'%')  " +
             " </if> " +
             "<if test='pageInputUserDTO.areaName != null and pageInputUserDTO.areaName.trim() != &quot;&quot;'>" +
-            "AND t.`area_name` like concat(#{pageInputUserDTO.areaName},'%')   " +
+            "AND t1.`area_name` like concat(#{pageInputUserDTO.areaName},'%')   " +
             " </if> " +
             "<if test='pageInputUserDTO.tags != null and pageInputUserDTO.tags.trim() != &quot;&quot;'>" +
             " and t.tags like concat('%',#{pageInputUserDTO.tags},'%')  " +

--
Gitblit v1.7.1