| | |
|---|
| | | " where cmpct.community_id = #{communityId}") |
|---|
| | | IndexBasicsStatisticsVO getScreenIndexByBasics(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT cmp.sex, count( cmpct.id ) AS sum, count( cmpct.id )/(select count(*) from com_mng_population_community_tags as cmpct \n" + |
|---|
| | | @Select("SELECT cmp.sex as type, count( cmpct.id ) AS sum, count( cmpct.id )*100/(select count(*) from com_mng_population_community_tags as cmpct \n" + |
|---|
| | | " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmpct.community_id = #{communityId} ) as percent FROM \n" + |
|---|
| | | " com_mng_population_community_tags as cmpct \n" + |
|---|
| | | " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmp.sex is not null and cmpct.community_id = #{communityId} GROUP BY cmp.sex") |
|---|
| | |
|---|
| | | |
|---|
| | | @Select("SELECT " + " count( id ) " + "FROM " + " com_mng_population_community_tags " + "WHERE " |
|---|
| | | + " community_id = #{communityId} ") |
|---|
| | | Integer getSpecialStatisticsByLabel(@Param("communityId") Long communityId); |
|---|
| | | Integer getSpecialStatistics(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT " + " count( egd.id ) AS gridTotal, " |
|---|
| | | + " ( select count(egmr.id) from event_grid_member_relation as egmr" |
|---|
