| | |
|---|
| | | "count(if(s.is_volunteer=0,s.id,null))participant_now,\n"+ |
|---|
| | | "a.participant_max,\n" + |
|---|
| | | "a.sign_up_begin,\n" + |
|---|
| | | "a.sign_up_end\n" + |
|---|
| | | "a.sign_up_end,\n" + |
|---|
| | | "ca.name as communityName \n" + |
|---|
| | | "FROM\n" + |
|---|
| | | "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}" + |
|---|
| | | "left join com_act ca on a.community_id=ca.community_id \n"+ |
|---|
| | | " where 1=1 " + |
|---|
| | | |
|---|
| | | "<if test='comActActivityVO.choice == 0 '>" + |
|---|
| | | "AND a.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> " + |
|---|
