| | |
| | | "com_act_activity a \n" + |
| | | "join sys_user u on a.sponsor_id=u.user_id\n" + |
| | | "left join com_act_act_sign s on a.id=s.activity_id \n"+ |
| | | " where a.community_id=#{comActActivityVO.communityId}" + |
| | | " where 1=1 " + |
| | | |
| | | "<if test='comActActivityVO.choice == 0 '>" + |
| | | "AND d.community_id=#{comActActivityVO.communityId}\n" + |
| | | " </if> " + |
| | | |
| | | "<if test='comActActivityVO.activityName != null and comActActivityVO.activityName.trim() != ""'>" + |
| | | " and a.activity_name like concat(#{comActActivityVO.activityName},'%') \n" + |
| | | " </if> " + |