From 7b4a1a1a8026427e2ed7fe71f0869f560417cfe2 Mon Sep 17 00:00:00 2001 From: puhanshu <a9236326> Date: 星期四, 10 三月 2022 14:11:57 +0800 Subject: [PATCH] 大屏修改 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynDOMapper.xml | 14 +++++++------- 1 files changed, 7 insertions(+), 7 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 02a6c2a..90448dc 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 @@ -111,13 +111,13 @@ <select id="pagePartyBuildIngAct" resultType="com.panzhihua.common.model.vos.partybuilding.PartyBuildingActivityVO"> SELECT - a.id, - a.activity_name AS name, - a.publish_at AS releaseTime, - a.cover - FROM com_act_activity a - WHERE a.community_id = #{pageBaseDTO.communityId} AND a.`status` IN ( 3, 4, 5 ) - ORDER BY a.publish_at desc + id, + activity_name AS name, + publish_at AS releaseTime, + cover + FROM com_act_activity + WHERE community_id = #{pageBaseDTO.communityId} AND `status` IN ( 3, 4, 5 ) AND `type` = 3 + ORDER BY publish_at desc </select> <select id="pagePartyBuildIngDiscuss" resultType="com.panzhihua.common.model.vos.community.ComActDiscussVO"> -- Gitblit v1.7.1