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