From 560db6a1036201e7e2ac50f34ad4a418f17eaba6 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期一, 06 六月 2022 11:01:11 +0800
Subject: [PATCH] bug修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 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 ede19a7..fe59c53 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
@@ -216,6 +216,9 @@
"p.urban_status, " +
"p.img_width, " +
"p.img_height, " +
+ "p.evaluate_date, " +
+ "caepe.score," +
+ "caepe.`content`, " +
"p.handle_photo_list " +
"FROM " +
"com_act_easy_photo p " +
@@ -225,6 +228,7 @@
"LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id " +
"LEFT JOIN com_act c on p.community_id=c.community_id " +
"left join com_act_easy_photo_classify ca on ca.id = p.classify_id " +
+ "left join com_act_easy_photo_evaluate as caepe on caepe.service_id = p.id and caepe.service_type = 1 " +
"WHERE p.del_tag = 0 and p.id=#{id}")
ComActEasyPhotoVO detailEasyPhoto(Long id);
@Select("SELECT " +
@@ -292,7 +296,7 @@
"AND p.sponsor_id =#{comActEasyPhotoVO.sponsorId} " +
" </if> " +
"<if test='comActEasyPhotoVO.sponsorId == null or comActEasyPhotoVO.sponsorId==0'>" +
- "AND p.`status` in (2,4) and p.is_publicity = 1 " +
+ "AND p.`status` in (2,5) and p.is_publicity = 1 " +
" </if> " +
"<if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != ""'>" +
"AND (class.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.detail like concat(#{comActEasyPhotoVO.keyWord},'%')) " +
@@ -370,7 +374,7 @@
* @param communityId
* @return
*/
- List<ComActEasyPhotoVO> selectStatisticsList(@Param("communityId") Long communityId);
+ List<StatisticsCommVO> selectStatisticsList(@Param("communityId") Long communityId);
/**
* 获取居民自治统计数据
@@ -409,4 +413,12 @@
* @return
*/
IPage<ComActEasyPhotoVO> indexEasyPhotoList(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO);
+
+ /**
+ * 随手拍治安防控记录列表
+ * @param communityId
+ * @param pageSize
+ * @return
+ */
+ List<ComActEasyPhotoVO> getPartyBuildIngRecord(@Param("communityId") Long communityId, @Param("pageSize") Integer pageSize);
}
--
Gitblit v1.7.1