| | |
| | | |
| | | <if test="query.sortType != null"> |
| | | <if test="query.sortType == 1"> |
| | | order by t1.task_urgency_level, t1.create_time desc |
| | | <if test="query.sortRule == 1"> |
| | | order by t1.task_urgency_level asc, t1.create_time desc |
| | | </if> |
| | | <if test="query.sortRule == 2"> |
| | | desc, t1.create_time desc |
| | | order by t1.task_urgency_level desc, t1.create_time desc |
| | | </if> |
| | | </if> |
| | | <if test="query.sortType == 2"> |
| | | order by t2.plate_number, t1.create_time desc |
| | | <if test="query.sortRule == 1"> |
| | | order by t2.plate_number, t1.create_time desc |
| | | </if> |
| | | <if test="query.sortRule == 2"> |
| | | desc, t1.create_time desc |
| | | order by t2.plate_number desc, t1.create_time desc |
| | | </if> |
| | | </if> |
| | | <if test="query.sortType == 3"> |