花城-智慧社区
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
101captain
2021-10-18 c4c904031919bd0456cd14fca583d9fa9eea40d8 
 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);