| | |
|---|
| | | Integer getSpecialStatisticsByLabel(@Param("label") String label,@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT " + " count( egd.id ) AS gridTotal, " |
|---|
| | | + " ( SELECT count( user_id ) FROM sys_user WHERE community_id = egd.grid_community_id AND type = 6 ) AS gridMemberTotal, " |
|---|
| | | + " ( select count(egmr.id) from event_grid_member_relation as egmr" |
|---|
| | | + " left join event_grid_data as egd1 on egd1.id = egmr.grid_id where egd1.grid_community_id = egd.grid_community_id ) AS gridMemberTotal, " |
|---|
| | | + " ( " + " SELECT " + " count( e.id ) " + " FROM " + " `event` AS e " |
|---|
| | | + " LEFT JOIN event_grid_data AS egd1 ON e.grid_id = egd1.id " + " WHERE " |
|---|
| | | + " egd1.grid_community_id = egd.grid_community_id " + " AND event_status = 2 " |
|---|
