From d0875e8da50625ef0ce083a568de7c8b044aaf4c Mon Sep 17 00:00:00 2001
From: yanghui <2536613402@qq.com>
Date: 星期一, 21 十一月 2022 10:09:15 +0800
Subject: [PATCH] #feat 商家运营数据统计
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java
index 462be53..1c6ec16 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java
@@ -29,11 +29,14 @@
@Select("<script> " + "SELECT d.*,\n" + "u.name userName,u.type as userType\n" + "FROM\n" + "com_ops_house d\n"
+ " LEFT JOIN sys_user u ON d.user_id = u.user_id\n"
+ + " LEFT JOIN com_act ca ON d.community_id = ca.community_id\n"
+ " LEFT JOIN com_mng_struct_area sa ON d.house_community_id = sa.id \n" + "where 1=1 "
+ "<if test='pageComOpsHouseDTO.communityId != null '>"
- + "AND ( d.community_id = #{pageComOpsHouseDTO.communityId} or sa.community_id = #{pageComOpsHouseDTO.communityId} )\n"
+ + "AND ( d.community_id = ${pageComOpsHouseDTO.communityId} or sa.community_id = ${pageComOpsHouseDTO.communityId} )\n"
+ + " </if> "
+ + "<if test='pageComOpsHouseDTO.areaCode != null '>"
+ + "AND ca.area_code = #{pageComOpsHouseDTO.areaCode}"
+ " </if> " +
-
"<if test='pageComOpsHouseDTO.userId != null '>" + "AND d.user_id=#{pageComOpsHouseDTO.userId} \n" + " </if> "
+ "<if test='pageComOpsHouseDTO.orient != null '>" + "AND d.orient=#{pageComOpsHouseDTO.orient} \n" + " </if> "
+ "<if test='pageComOpsHouseDTO.houseType != null '>" + "AND d.house_type=#{pageComOpsHouseDTO.houseType} \n"
@@ -45,7 +48,7 @@
+ "AND d.brn <![CDATA[ >= ]]> 4 \n" + " </if> " +
"<if test='pageComOpsHouseDTO.houseCommunityId != null '>"
- + "AND d.house_community_id = #{pageComOpsHouseDTO.houseCommunityId} \n" + " </if> "
+ + "AND d.house_community_id = ${pageComOpsHouseDTO.houseCommunityId} \n" + " </if> "
+ "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status < 4 '>"
+ "AND d.status=#{pageComOpsHouseDTO.status} \n" + " </if> "
+ "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status ==4 '>"
--
Gitblit v1.7.1