From c83cf9d2d82a0a29a15e38f4566eb470b9a3517b Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期二, 22 二月 2022 09:57:51 +0800
Subject: [PATCH] 抽奖相关提交
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActivityDAO.java | 26 +++++++++++++++++++++++---
1 files changed, 23 insertions(+), 3 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 82d3d98..2eb4543 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
@@ -61,9 +61,14 @@
+ "AND a.`status` != 1 AND a.`status` != 6 " + " </if> " + "<if test='comActActivityVO.beginAt != null '>"
+ "AND a.begin_at <![CDATA[ >= ]]> #{comActActivityVO.beginAt} AND a.end_at <![CDATA[ <= ]]> #{comActActivityVO.endAt} "
+ " </if> " + "<if test='comActActivityVO.type != null and comActActivityVO.type==1 '>"
- + "AND a.volunteer_max!=0 " + " </if> "
- + "<if test='comActActivityVO.type != null and comActActivityVO.type==2 '>" + "AND a.volunteer_max=0 "
- + " </if> " + " group by a.id " + " order by a.status asc,a.publish_at desc " + "</script>")
+ + "AND a.volunteer_max!=0 and is_project = 0 " + " </if> "
+ + "<if test='comActActivityVO.type != null and comActActivityVO.type==2 '>" + "AND a.volunteer_max=0 and is_project = 0 "
+ + " </if> "
+ + "<if test='comActActivityVO.type != null and comActActivityVO.type==4 '>" + "AND is_project = 1 "
+ + " </if> "
+ + "<if test='comActActivityVO.projectId != null'>" + "AND project_id = #{comActActivityVO.projectId} "
+ + " </if> "
+ + " group by a.id " + " order by a.status asc,a.publish_at desc " + "</script>")
IPage<ComActActivityVO> pageActivity(Page page, @Param("comActActivityVO") ComActActivityVO comActActivityVO);
// @Select("SELECT " + "u.name sponsorName, " + "ca.name communityName, "
@@ -231,4 +236,19 @@
* @return
*/
int addActivityType(@Param("comActActivityTypeVO") ComActActivityTypeVO comActActivityTypeVO);
+
+ /**
+ * 查询项目活动列表
+ * @param page
+ * @return
+ */
+ IPage<ActActivityListVO> selectProjectActivity(Page page);
+
+ /**
+ * 根据社工id查询活动列表
+ * @param page
+ * @param id
+ * @return
+ */
+ IPage<ActActivityListVO> selectActivityBySocialWorker(Page page,@Param("id")Long id);
}
--
Gitblit v1.7.1