From 04c96f26282f021fcc59b40d6f11f172fc070af8 Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期五, 22 一月 2021 17:31:41 +0800
Subject: [PATCH] 新增接口一起议
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java | 29 +++++++++++++++++++----------
1 files changed, 19 insertions(+), 10 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
index bb653af..3d4bda3 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
@@ -50,19 +50,28 @@
" </if> " +
"</script>")
List<ComActVO> listCommunity(ComActVO comActVO);
+
@Select("select district_name from com_mng_struct_area_district where district_adcode=#{areaCode}")
String selectAreaName(String areaCode);
@Select("<script> " +
- "select id,"+
- " <where>" +
- "<if test='nameCn != null and nameCn.trim() != ""'>" +
- " </if> " +
- "<if test='nameCn != null and nameCn.trim() != ""'>" +
- " </if> " +
- "<if test='nameCn != null and nameCn.trim() != ""'>" +
- " </if> " +
- " </where>" +
- "</script>")
+ "SELECT\n" +
+ "a.* \n" +
+ "FROM\n" +
+ "com_act a \n" +
+ " <where>" +
+ "<if test='pageComActDTO.name != null and pageComActDTO.name.trim() != ""'>" +
+ "and a.name LIKE concat( #{pageComActDTO.name}, '%' ) \n" +
+ " </if> " +
+ "<if test='pageComActDTO.areaCode != null and pageComActDTO.areaCode.trim() != ""'>" +
+ "AND a.area_code = #{pageComActDTO.areaCode} \n" +
+ " </if> " +
+ "<if test='pageComActDTO.createAtBegin != null '>" +
+ "AND a.create_at BETWEEN " +
+ "#{pageComActDTO.createAtBegin} \n" +
+ "AND #{pageComActDTO.createAtEnd}" +
+ " </if> " +
+ " </where>" +
+ "</script>")
IPage<ComActVO> pageCommunity(Page page, @Param("pageComActDTO") PageComActDTO pageComActDTO);
}
--
Gitblit v1.7.1