| | |
|---|
| | | select count(cmpct.id) as populationTotal , |
|---|
| | | (select count(cmpct.id) from com_mng_population_community_tags cmpct left join com_mng_population cmp on cmpct.population_id = cmp.id where cmpct.community_id = ${communityId} and cmp.out_or_local = 1) as localTotal , |
|---|
| | | (select count(cmpct.id) from com_mng_population_community_tags cmpct left join com_mng_population cmp on cmpct.population_id = cmp.id where cmpct.community_id = ${communityId} and cmp.out_or_local = 2) as outTotal , |
|---|
| | | (select count(cmpct.id) from com_mng_population_community_tags cmpct left join com_mng_population cmp on cmpct.population_id = cmp.id where cmpct.community_id = ${communityId} and cmpct.label is not null and cmpct.label !='') as specialTotal , |
|---|
| | | (select count(cmpct.id) from com_mng_population_community_tags cmpct left join com_mng_population cmp on cmpct.population_id = cmp.id where cmpct.community_id = ${communityId} and (cmpct.label like '%吸毒%' or cmpct.label like '%矫正%' or cmpct.label like '%重精%' or cmpct.label like '%刑满%' |
|---|
| | | or cmpct.label like '%上访%' or cmpct.label like '%退役%' or cmpct.label like '%残疾%' or cmpct.label like '%低保%')) as specialTotal , |
|---|
| | | (select count(DISTINCT `name`) from com_mng_village where community_id = ${communityId}) as villageTotal , |
|---|
| | | (select count(id) from com_mng_building where act_id = ${communityId}) as buildNum , |
|---|
| | | (select count(id) from com_mng_population_community_tags where community_id = ${communityId} and label LIKE CONCAT('%','吸毒人员','%')) as drugTotal , |
|---|
