| | |
|---|
| | | " 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") |
|---|
| | | List<IndexPopulationSexStatisticsVO> getScreenIndexByPopulationSex(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " |
|---|
| | | + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " |
|---|
| | | + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " |
|---|
| | | + " e.happen_time DESC " + " LIMIT 8") |
|---|
| | | // @Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM " |
|---|
| | | // + " `event` AS e " + " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " + "WHERE " |
|---|
| | | // + " egd.grid_community_id = ${communityId} " + " AND e.event_deal_status IN ( 1, 4 ) " + "ORDER BY " |
|---|
| | | // + " e.happen_time DESC " + " LIMIT 8") |
|---|
| | | List<IndexEventListStatisticsVO> getScreenIndexByEventList(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " count( id ) AS microWishTotal, " |
|---|
