| | |
|---|
| | | updateTime,t1.create_by as createBy,t1.update_by as updateBy,t2.plate_number as plateNumber |
|---|
| | | from xp_task t1 |
|---|
| | | left join xp_vehicle t2 on t1.vehicle_id = t2.id |
|---|
| | | where t1.is_deleted = 0 |
|---|
| | | where t1.is_deleted = 0 and (t1.task_category =1 and t1.status != 2) |
|---|
| | | <if test="query.taskCategory != null"> |
|---|
| | | and t1.task_category = #{query.taskCategory} |
|---|
| | | </if> |
|---|
| | |
|---|
| | | and t1.task_urgency_level = #{query.taskUrgencyLevel} |
|---|
| | | </if> |
|---|
| | | <if test="query.status != null"> |
|---|
| | | -- 事故不在已处理中展示 |
|---|
| | | <if test="query.status == 2"> |
|---|
| | | and t1.task_category = 1 |
|---|
| | | </if> |
|---|
| | | and t1.status = #{query.status} |
|---|
| | | </if> |
|---|
| | | <if test="query.plateNumber != null and query.plateNumber != ''"> |
|---|
