| | |
| | | <if test='comActActivityVO.type != null and comActActivityVO.type == 4'> |
| | | left join (select count(t.id) as socialCount,activity_id from com_act_act_regist t LEFT JOIN sys_user t1 on t.user_id = t1.user_id LEFT JOIN com_act_social_worker t2 on t1.phone = t2.telephone where t2.id is not null GROUP BY t.activity_id) so on a.id = so.activity_id |
| | | </if> |
| | | WHERE a.`status` != 1 AND a.community_id=#{comActActivityVO.communityId} |
| | | WHERE a.community_id=#{comActActivityVO.communityId} |
| | | <if test='comActActivityVO.type != null'> |
| | | AND a.type = #{comActActivityVO.type} |
| | | </if> |
| | |
| | | |
| | | <select id="selectActivityStatics" resultType="com.panzhihua.common.model.vos.community.PartyActivityStatics"> |
| | | select (select count(*) from com_act_activity where type = 3 and community_id = #{communityId}) activityCount, |
| | | (select count(*) from com_pb_member where community_id = #{communityId} ) memberCount |
| | | (select count(*) from com_pb_member where community_id = #{communityId} and audit_result=1 ) memberCount |
| | | </select> |
| | | |
| | | <select id="selectActivityChart" resultType="com.panzhihua.common.model.vos.community.PartyActivityTypeChart"> |