From f76377ffd111434d90c5aaf5507cd33a982d4aa6 Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期四, 10 十二月 2020 18:06:16 +0800
Subject: [PATCH] 小程序,社区活动,微心愿,随手拍完成未测试
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
index f86a01e..d28a3b3 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
@@ -22,6 +22,8 @@
"p.id,\n" +
"u.`name` sponsor_name,\n" +
"u.phone sponsor_phone,\n" +
+ "count(pu.id)giveThumbsUpNum,\n" +
+ "u.image_url,\n" +
"p.happen_addr,\n" +
"su.`name` handler_name,\n" +
"p.`status`,\n" +
@@ -30,6 +32,7 @@
"FROM\n" +
"com_act_easy_photo p\n" +
"JOIN sys_user u ON p.sponsor_id = u.user_id \n" +
+ "left join com_act_easy_photo_user pu ON p.id = pu.easy_photo_id \n" +
"<if test='comActEasyPhotoVO.sponsorName != null and comActEasyPhotoVO.sponsorName.trim() != ""'>" +
"AND u.`name` = #{comActEasyPhotoVO.sponsorName} \n" +
" </if> " +
@@ -48,12 +51,17 @@
"AND p.create_at BETWEEN #{comActEasyPhotoVO.createBegin} \n" +
"AND #{comActEasyPhotoVO.createEnd}" +
" </if> " +
+ "<if test='comActEasyPhotoVO.sponsorId != null and comActEasyPhotoVO.sponsorId != 0'>" +
+ "AND p.sponsor_id =#{comActEasyPhotoVO.sponsorId} \n" +
+ " </if> " +
+ " group by p.id "+
"</script>")
IPage<ComActEasyPhotoVO> pageEasyPhoto(Page page, @Param("comActEasyPhotoVO") ComActEasyPhotoVO comActEasyPhotoVO);
@Select("SELECT \n" +
"p.id,\n" +
"p.create_at,\n" +
"u.`name`,\n" +
+ "u.`image_url`,\n" +
"u.phone,\n" +
"p.detail,\n" +
"p.happen_addr,\n" +
--
Gitblit v1.7.1