From b8129d34235cc9af66642d4a44bc68df2debd2ba Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期一, 23 八月 2021 19:20:36 +0800 Subject: [PATCH] bug修复 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java | 4 ++-- 1 files changed, 2 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 be971e5..b4f3910 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 @@ -271,7 +271,7 @@ "left JOIN com_act_easy_photo_comment c ON p.id = c.easy_photo_id " + "left JOIN com_act_easy_photo_classify class ON p.classify_id = class.id " + " <where>" + - " p.del_tag = 0 and p.is_publicity = 1 " + + " p.del_tag = 0 " + "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + " and p.community_id=#{comActEasyPhotoVO.communityId} " + " </if> " + @@ -282,7 +282,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.`status` in (2,4) 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},'%')) " + -- Gitblit v1.7.1