From ceecc9afe5fcea887eb9889747d05ff1e6222308 Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期一, 14 三月 2022 09:51:26 +0800
Subject: [PATCH] bug修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml | 2 +-
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml
index a170787..124a610 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml
@@ -332,7 +332,7 @@
<select id="pageCourtyardDiscuss" resultType="com.panzhihua.common.model.vos.community.ComActDiscussVO">
SELECT id, `type`, discuss_subject, photo_pah, create_at FROM com_act_discuss
WHERE community_id = #{pageBaseDTO.communityId}
- AND content_type = 2 AND is_del = 2 AND photo_pah IS NOT NULL
+ AND content_type = 2 AND is_del = 2
<if test="pageBaseDTO.param3 != null">
AND `type` = #{pageBaseDTO.param3}
</if>
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml
index 035aa23..7867f5c 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml
@@ -175,7 +175,7 @@
FROM com_mng_volunteer_mng t1
INNER JOIN com_mng_volunteer_org_team t2 ON t1.team_id = t2.id
INNER JOIN com_mng_volunteer_org_team t3 ON t1.org_id = t3.id
- WHERE t1.community_id = #{communityId}
+ WHERE t1.community_id = #{communityId} AND t1.state = 2
</select>
<select id="pageVolunteerExamine"
resultType="com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO">
--
Gitblit v1.7.1