| | |
|---|
| | | <if test="param.auctionSalesroomId!=null and param.auctionSalesroomId != ''"> |
|---|
| | | AND ta.auction_salesroom_id = #{param.auctionSalesroomId} |
|---|
| | | </if> |
|---|
| | | <if test="param.backupStatus!=null and param.backupStatus != ''"> |
|---|
| | | AND ta.backup_status = #{param.backupStatus} |
|---|
| | | </if> |
|---|
| | | AND ta.backup_status = false |
|---|
| | | ORDER BY |
|---|
| | | CASE |
|---|
| | | WHEN status = 0 THEN 2 |
|---|
| | |
|---|
| | | WHEN status = 0 THEN 2 |
|---|
| | | WHEN status = 1 THEN 1 |
|---|
| | | WHEN status = 2 THEN 3 |
|---|
| | | END,status desc ,start_time ASC |
|---|
| | | END,status desc ,start_time DESC |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="pageMemberAuctionSalesroomWdList" resultType="com.ruoyi.system.api.domain.AuctionSalesroom"> |
|---|
