From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 09 六月 2025 11:54:00 +0800
Subject: [PATCH] 6.9新增登录失败冻结逻辑

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java |    6 +++---
 1 files changed, 3 insertions(+), 3 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 19accf3..aa86c6b 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,9 +34,9 @@
         + " 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);
 

--
Gitblit v1.7.1