From 71d1c3d6e71f8effa93dab273a573b15ac43a2c2 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期五, 07 五月 2021 17:30:20 +0800
Subject: [PATCH] 修改bug

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java |    7 +++----
 1 files changed, 3 insertions(+), 4 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java
index bf35ce5..0873f6c 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java
@@ -69,12 +69,11 @@
     @Select("<script> \n"+
             "SELECT\n" +
             "nc.*,\n" +
-            "u.`name` AS releaseName,u.`type` as userType\n" +
-            ",ca.name as communityName\n" +
+            "u.`nick_name` AS releaseName,u.`type` as userType\n" +
+            ",u.name as communityName\n" +
             "FROM\n" +
             "com_act_neighbor_circle nc\n" +
-            "LEFT JOIN sys_user u ON nc.release_id = u.user_id\n" +
-            "left join com_act ca on u.community_id=ca.community_id \n" +
+            "LEFT JOIN sys_user u ON nc.release_id = u.user_id \n" +
             "<where>"+
             "nc.community_id = #{neighborCircleAdminDTO.communityId}  \n"+
             "<if test='neighborCircleAdminDTO.releaseContent != null and neighborCircleAdminDTO.releaseContent != &quot;&quot;'>" +

--
Gitblit v1.7.1