From ac37b4257946f9b628904cf92aa0638f3353d8fe Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期一, 04 九月 2023 14:40:42 +0800
Subject: [PATCH] 修改后台社区动态加载不出来
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml
index dcc2921..562b694 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml
@@ -195,11 +195,14 @@
</if>
ORDER BY d.is_topping DESC, d.create_at DESC
</select>
+
+<!-- COUNT(u.id)readNum, LEFT JOIN com_act_dyn_user u ON d.id = u.dyn_id-->
+
<select id="pageDynamicByAdmin" resultType="com.panzhihua.common.model.vos.community.ComActDynVO">
- SELECT d.id, d.title, COUNT(u.id)readNum, d.`status`, d.`content`, d.`cover`, d.`type`, d.`cover_mode`,
+ SELECT d.id, d.title,d.`status`, d.`content`, d.`cover`, d.`type`, d.`cover_mode`,
d.is_topping, d.publish_at, d.create_at, cadt.`name` as typeName, ca.name as communityName,d.release_time
FROM com_act_dyn d
- LEFT JOIN com_act_dyn_user u ON d.id = u.dyn_id
+
LEFT JOIN com_act_dyn_type as cadt ON cadt.id = d.type
LEFT JOIN com_act ca ON d.community_id = ca.community_id
WHERE 1=1
--
Gitblit v1.7.1