From 03e7f875fb31d592af1066a63cad2e185c79b5ce Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期二, 08 六月 2021 17:12:54 +0800
Subject: [PATCH] 修改随手拍、微心愿、一起议昵称显示问题
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDiscussDAO.java | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDiscussDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDiscussDAO.java
index 4f72973..62a8724 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDiscussDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDiscussDAO.java
@@ -103,6 +103,7 @@
"COUNT( DISTINCT c.id ) commentNum,\n" +
"COUNT( DISTINCT du.id ) signNum,\n" +
"if(u.type=1,u.name,a.name) userName,\n" +
+ "if(u.type=1,u.nick_name,a.name) userNickName,\n" +
"if(du.id is not null,1,0) haveSign,\n" +
"if(ou.id is not null,1,0) haveVote,\n" +
"u.image_url,\n" +
@@ -135,6 +136,7 @@
"select * from ("+
"SELECT\n" +
"u.`name` userName,\n" +
+ "u.`nick_name` userNickName,\n" +
"u.`image_url`,\n" +
"u.phone,\n" +
"c.`comment`,\n" +
--
Gitblit v1.7.1