| | |
|---|
| | | + "AND a.`status` != 1 AND a.`status` != 6 " + " </if> " + "<if test='comActActivityVO.beginAt != null '>" |
|---|
| | | + "AND a.begin_at <![CDATA[ >= ]]> #{comActActivityVO.beginAt} AND a.end_at <![CDATA[ <= ]]> #{comActActivityVO.endAt} " |
|---|
| | | + " </if> " + "<if test='comActActivityVO.type != null and comActActivityVO.type==1 '>" |
|---|
| | | + "AND a.volunteer_max!=0 " + " </if> " |
|---|
| | | + "<if test='comActActivityVO.type != null and comActActivityVO.type==2 '>" + "AND a.volunteer_max=0 " |
|---|
| | | + " </if> " + " group by a.id " + " order by a.status asc,a.publish_at desc " + "</script>") |
|---|
| | | + "AND a.volunteer_max!=0 and is_project = 0 " + " </if> " |
|---|
| | | + "<if test='comActActivityVO.type != null and comActActivityVO.type==2 '>" + "AND a.volunteer_max=0 and is_project = 0 " |
|---|
| | | + " </if> " |
|---|
| | | + "<if test='comActActivityVO.type != null and comActActivityVO.type==4 '>" + "AND is_project = 1 " |
|---|
| | | + " </if> " |
|---|
| | | + " group by a.id " + " order by a.status asc,a.publish_at desc " + "</script>") |
|---|
| | | IPage<ComActActivityVO> pageActivity(Page page, @Param("comActActivityVO") ComActActivityVO comActActivityVO); |
|---|
| | | |
|---|
| | | // @Select("SELECT " + "u.name sponsorName, " + "ca.name communityName, " |
|---|
