| | |
| | | <if test="pageEventDTO.eventDealStatus!=null"> |
| | | AND event_deal_status = #{pageEventDTO.eventDealStatus} |
| | | </if> |
| | | <if test="pageEventDTO.isAll!=null and pageEventDTO.isAll = 1"> |
| | | AND event_deal_status in (1,2,4) |
| | | </if> |
| | | <if test="pageEventDTO.revokeType!=null"> |
| | | AND ( revoke_type = #{pageEventDTO.revokeType} OR revoke_type is null ) |
| | | </if> |
| | |
| | | AND update_at <![CDATA[<=]]> #{pageEventDTO.updateAtEnd} |
| | | </if> |
| | | </where> |
| | | <if test="pageEventDTO.sortColumns!=null"> |
| | | ORDER BY ${pageEventDTO.sortColumns} ${pageEventDTO.sortType} |
| | | </if> |
| | | order by event_deal_status asc,create_at desc |
| | | </select> |
| | | <select id="findPublicityByPage" resultType="com.panzhihua.common.model.vos.grid.EventVO" |
| | | parameterType="com.panzhihua.common.model.dtos.grid.PagePublicityEventDTO"> |