java/zhihuishenqu.git

			@@ -153,6 +153,7 @@
			"cmp.label, " +
			"cmp.marriage, " +
			"cmp.culture_level, " +
			"cmp.profession, " +
			"cmp.out_or_local, " +
			"cmp.census_register, " +
			"cmp.healthy, " +
			@@ -274,6 +275,15 @@
			",(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 not null) as specialTotal " +
			",(select count(village_id) from com_mng_village where community_id = #{communityId}) as villageTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','吸毒人员','%')) as drugTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','社区矫正','%')) as correctTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','精神障碍患者','%')) as majorTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','邪教人员','%')) as cultTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','刑满释放','%')) as rehabilitationTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','重点人员','%')) as keyTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','退役军人','%')) as veteransTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','残疾人','%')) as disabilityTotal " +
			",(select count(id) from com_mng_population where act_id = #{communityId} and label LIKE CONCAT('%','低保户','%')) as lowSecurityTotal " +
			" from com_mng_population as cmp where act_id = #{communityId}")
			ComMngPopulationTotalVO getPopulationTotalByAdmin(@Param("communityId") Long communityId);