From ca9ec1a1037ea4b7ee9a85be0c3f15d9ae40e792 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期三, 21 七月 2021 18:01:04 +0800
Subject: [PATCH] 社区后台基础数据库bug修改
---
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 1a9f4fb..403aa58 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
@@ -109,6 +109,7 @@
"d.photo_pah, " +
"d.`discuss_subject`, " +
"d.type, " +
+ "u.type as userType, " +
"COUNT( DISTINCT c.id ) commentNum, " +
"COUNT( DISTINCT du.id ) signNum, " +
"if(u.type=1,u.name,a.name) userName, " +
@@ -148,6 +149,7 @@
"u.nick_name userNickName, " +
"u.`image_url`, " +
"u.phone, " +
+ "u.type as userType, " +
"c.`comment`, " +
"c.`parent_id`, " +
"c.`is_author`, " +
--
Gitblit v1.7.1