| | |
| | | resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO"> |
| | | SELECT activity_type AS filed, COUNT(id) AS num |
| | | FROM com_act_activity |
| | | WHERE community_id = ${communityId} |
| | | WHERE community_id = ${communityId} AND `status` IN(2,3,4,5) |
| | | <if test="isResidentAct"> |
| | | AND `type` = 2 |
| | | </if> |
| | |
| | | SELECT filed, SUM(num) AS num FROM ( |
| | | SELECT DATE_FORMAT( publish_at, '%Y-%m' ) AS filed, COUNT(id) AS num |
| | | FROM com_act_activity |
| | | WHERE community_id = ${communityId} |
| | | WHERE community_id = ${communityId} AND `status` IN(2,3,4,5) |
| | | <if test="isResidentAct"> |
| | | AND `type` = 2 |
| | | </if> |
| | |
| | | resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO"> |
| | | SELECT COUNT(id) AS num |
| | | FROM com_act_activity |
| | | WHERE community_id = ${communityId} |
| | | WHERE community_id = ${communityId} AND `status` IN(2,3,4,5) |
| | | <if test="isResidentAct"> |
| | | AND `type` = 2 |
| | | </if> |