From a22c110d080fe4387cd7b29a9bd36a727eb5944a Mon Sep 17 00:00:00 2001
From: manailin <261030956@qq.com>
Date: 星期三, 08 十二月 2021 09:49:36 +0800
Subject: [PATCH] [新增]打印业务慢日志
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java | 11 +++++++----
1 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
index 4d503bf..a0636a7 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
@@ -34,16 +34,16 @@
+ " from com_mng_population_house where village_id = #{villageId}")
ComMngVillageVO getStatisticsCount(@Param("villageId") Long villageId);
- @Select("select count(village_id) as villageTotal"
- + ",(select count(village_id) from com_mng_village where community_id = #{communityId} and type = 1) as townTotal"
- + ",(select count(village_id) from com_mng_village where community_id = #{communityId} and type = 2) as countrysideTotal"
+ @Select("select count(distinct `name`) as villageTotal"
+ + ",(select count(distinct `name`) from com_mng_village where community_id = #{communityId} and type = 1) as townTotal"
+ + ",(select count(distinct `name`) from com_mng_village where community_id = #{communityId} and type = 2) as countrysideTotal"
+ " from com_mng_village where community_id = #{communityId}")
ComMngVillageTotalVO getVillageStatisticsCount(@Param("communityId") Long communityId);
@Select("select village_id,alley,house_num,group_at,type,address,update_at from com_mng_village where village_id = #{villageId}")
ComMngVillageVO getVillageById(@Param("villageId") Long villageId);
- @Select("<script> " + "SELECT " + " village_id, " + " `name` AS userName, " + " build_sum, " + " address, "
+ @Select("<script> " + "SELECT " + " village_id, " + " `name` AS userName, " + " IFNULL((select count(id) from com_mng_building where village_id = cmv.village_id),0) as buildSum, " + " address, "
+ " create_at as createAt, " + " lng, " + " lat, "
+ " ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id ) AS userSum, "
+ " ( SELECT count( id ) FROM com_mng_population_house WHERE village_id = cmv.village_id ) AS houseNum, "
@@ -66,6 +66,9 @@
IPage<PageComMngVillageVO> getGridVillageList(Page page,
@Param("villageListAppDTO") ComMngVillageListAppDTO villageListAppDTO);
+ IPage<PageComMngVillageVO> getGridVillageListApp(Page page,
+ @Param("villageListAppDTO") ComMngVillageListAppDTO villageListAppDTO);
+
@Select("<script> " + "SELECT " + " alley, " + " house_num as doorNum, " + " `name` AS userName, " + " build_sum, "
+ " address, " + " create_at as createAt, "
+ " ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id ) AS userSum, "
--
Gitblit v1.7.1