From 3c1dc61a89e0434e65f92940c04f2cca17cd4182 Mon Sep 17 00:00:00 2001
From: DESKTOP-71BH0QO\L、ming <172680469@qq.com>
Date: 星期一, 12 四月 2021 11:19:20 +0800
Subject: [PATCH] fix：修改社区动态and社区活动分页查询参数
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java
index 72f3fae..9ac40ab 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java
@@ -55,7 +55,12 @@
"com_act_activity a \n" +
"join sys_user u on a.sponsor_id=u.user_id\n" +
"left join com_act_act_sign s on a.id=s.activity_id \n"+
- " where a.community_id=#{comActActivityVO.communityId}" +
+ " where 1=1 " +
+
+ "<if test='comActActivityVO.choice == 0 '>" +
+ "AND d.community_id=#{comActActivityVO.communityId}\n" +
+ " </if> " +
+
"<if test='comActActivityVO.activityName != null and comActActivityVO.activityName.trim() != ""'>" +
" and a.activity_name like concat(#{comActActivityVO.activityName},'%') \n" +
" </if> " +
--
Gitblit v1.7.1