From 1e7df4ae6d61d3313be22ab8bc93676f6219e297 Mon Sep 17 00:00:00 2001 From: puhanshu <a9236326> Date: 星期三, 17 八月 2022 09:39:29 +0800 Subject: [PATCH] 清单获取筛选 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml index 58d4259..234c656 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml @@ -713,7 +713,7 @@ left join com_act_neighbor_circle_topic as canct on canct.id = canc.topic_id left join com_act as ca on ca.community_id = canc.community_id LEFT JOIN com_act_activity t ON canc.id = t.relation_id - where is_del = 2 and canc.status = 2 and canc.solve_status in (2,3,4) and canc.community_id = ${neighborCircleAppDTO.communityId} AND t.id IS NULL + where is_del = 2 and canc.status = 2 AND canc.order_type = 1 and canc.solve_status in (2,3,4) and canc.community_id = ${neighborCircleAppDTO.communityId} AND t.id IS NULL <if test='neighborCircleAppDTO.topicId != null '> and canc.topic_id = #{neighborCircleAppDTO.topicId} </if> -- Gitblit v1.7.1