| | |
|---|
| | | + "(select COUNT(d.id) from com_act_discuss d where d.community_id = #{communityId})x1, " |
|---|
| | | + "(select COUNT(w.id) from com_act_micro_wish w where w.community_id = #{communityId})x2, " |
|---|
| | | + "(select COUNT(p.id) from com_act_easy_photo p where p.community_id = #{communityId})x3, " |
|---|
| | | + " COUNT( a.id ) x4 " + "FROM " + " com_pb_activity a " + "WHERE " + " a.community_id =#{communityId})t") |
|---|
| | | + " COUNT( a.id ) x4 " + "FROM " + " com_pb_activity a " + "WHERE " + " a.community_id = #{communityId})t") |
|---|
| | | String selectCommunityGovernanceTrendsVO(Long communityId); |
|---|
| | | |
|---|
| | | @Select(" " + " SELECT " |
|---|
| | |
|---|
| | | + " (select COUNT(pa.id) from com_pb_activity pa where DATE_FORMAT(pa.create_at,'%Y-%m-%d')=DATE_FORMAT(#{date},'%Y-%m-%d') and pa.community_id = #{communityId})pbActivity, " |
|---|
| | | + " COUNT( a.id ) actActivity " + " FROM " + " com_pb_activity a " + " WHERE " |
|---|
| | | + " DATE_FORMAT( a.create_at, '%Y-%m-%d' )=DATE_FORMAT(#{date},'%Y-%m-%d') " |
|---|
| | | + " AND a.community_id =#{communityId}") |
|---|
| | | + " AND a.community_id = #{communityId}") |
|---|
| | | CommunityActivitiesVO selectCommunityActivitiesVO(@Param("communityId") Long communityId, @Param("date") Date date); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " count( caa.id ) as totalNum, " |
|---|
