From e9d5fb4b01c383fa5b01bf5e730d4e3da73f266e Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 30 十二月 2021 11:27:15 +0800
Subject: [PATCH] 12/30 河门口大屏特殊修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComCvtBusinessDAO.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/ComCvtBusinessDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComCvtBusinessDAO.java
index 03631b3..fe3c561 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComCvtBusinessDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComCvtBusinessDAO.java
@@ -21,7 +21,7 @@
+ "<if test='pageComCvtBusinessDTO.name != null and pageComCvtBusinessDTO.name.trim() != ""'>"
+ " and a.name LIKE concat( '%', #{pageComCvtBusinessDTO.name}, '%' ) " + " </if> "
+ "<if test='pageComCvtBusinessDTO.communityId != null and pageComCvtBusinessDTO.communityId != 0'>"
- + " and a.community_id = #{pageComCvtBusinessDTO.communityId} " + " </if> " + " </where>"
+ + " and a.community_id = ${pageComCvtBusinessDTO.communityId} " + " </if> " + " </where>"
+ " order by a.create_at desc" + "</script>")
IPage<ComCvtBusinessVO> pageComCvtBusiness(Page page,
@Param("pageComCvtBusinessDTO") PageComCvtBusinessDTO pageComCvtBusinessDTO);
@@ -29,7 +29,7 @@
@Select("<script> " + "SELECT " + "t.* " + "FROM " + "com_cvt_business t " + " <where>"
+ "<if test='comCvtBusinessAppletsDTO.communityId != null and comCvtBusinessAppletsDTO.communityId != 0'>"
+ " t.area_flag = 1 " + " OR (" + " t.area_flag = 2 "
- + " AND EXISTS ( SELECT * FROM com_cvt_business_area t2 WHERE t2.business_id = t.id AND t2.community_id = #{comCvtBusinessAppletsDTO.communityId} ) \n"
+ + " AND EXISTS ( SELECT * FROM com_cvt_business_area t2 WHERE t2.business_id = t.id AND t2.community_id = ${comCvtBusinessAppletsDTO.communityId} ) \n"
+ " ) " + " </if> " + " </where>" + " order by t.create_at desc" + "</script>")
IPage<ComCvtBusinessVO> pageComCvtBusinessByServiceArea(Page page,
@Param("comCvtBusinessAppletsDTO") PageComCvtBusinessAppletsDTO comCvtBusinessAppletsDTO);
--
Gitblit v1.7.1