select dispatch.accept_name as '查勘员姓名',dispatch.accept_account as '查勘员员工代码',
dispatch.regist_no as '报案号',task.license_no as '车牌号',dispatch.create_time as '任务流入时间',
dispatch.out_time as '任务流出时间',case dispatch.handle_type when '0' then '送修发起' when '1' then '送修放弃'
when '2' then '改派' end as '任务操作'
 from et_repair_task_dispatch dispatch left join et_repair_task task on dispatch.task_id=task.task_id
 where dispatch.create_time between '2018-01-01' and '2018-02-01' and dispatch.handle_type in ('0','1','2')