| | |
| | | @Select("select count(id) as populationTotal " + |
| | | ",(select count(id) from com_mng_population where act_id = #{communityId} and out_or_local = 1) as localTotal " + |
| | | ",(select count(id) from com_mng_population where act_id = #{communityId} and out_or_local = 2) as outTotal " + |
| | | ",(select count(id) from com_mng_population where act_id = #{communityId} and label is null) as specialTotal " + |
| | | ",(select count(id) from com_mng_population where act_id = #{communityId} and label is not null) as specialTotal " + |
| | | " from com_mng_population as cmp where act_id = #{communityId}") |
| | | ComMngPopulationTotalVO getPopulationTotalByAdmin(@Param("communityId") Long communityId); |
| | | } |