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

---
 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java |    6 ++++--
 1 files changed, 4 insertions(+), 2 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 e0980ef..fef4b5e 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
@@ -96,7 +96,8 @@
             "  ( t.old_people = 1, '特服家庭,', '' ), " +
             " IF " +
             "  ( t.key_personnel = 1, '重点人员,', '' )  " +
-            " ) tags  " +
+            " ) tags,  " +
+            " t.create_at  as createAt" +
             "FROM " +
             " sys_user_input t " +
             " LEFT JOIN com_mng_struct_area t1 ON t.area_id = t1.id  " +
@@ -166,7 +167,8 @@
             "  ( t.old_people = 1, '特服家庭,', '' ), " +
             " IF " +
             "  ( t.key_personnel = 1, '重点人员,', '' )  " +
-            " ) tags  " +
+            " ) tags,  " +
+            " t.create_at  as createAt" +
             "FROM " +
             " sys_user_input t " +
             " LEFT JOIN com_mng_struct_area t1 ON t.area_id = t1.id  " +

--
Gitblit v1.7.1