SELECT
SDD.ID AS ID,
SDO.DESCRIPTION AS ORGNAME,
SDC.REGIST_NO AS REGIST_NO,
SDC.USER_NAME AS USER_NAME,
SDD.SURVEY_NAME AS SURVEY_NAME,
SDD.SURVEY_ORGNAME AS SURVEY_ORG_NAME,
SDD.YARDMAN_NUMBER AS YARDMAN_NUMBER,
SDD.YARDMAN_NAME AS YARDMAN_NAME,
SDD.loss_name AS loss_name,
SDD.SURVEY_PLACE AS SURVEY_PLACE,
CASE
SDD.loss_type
WHEN 1 THEN
'标的车'
WHEN 2 THEN
'三者车'
WHEN 3 THEN
'本车司机'
WHEN 4 THEN
'本车车上人员'
WHEN 5 THEN
'三者人员'
WHEN 6 THEN
'车上物'
WHEN 7 THEN
'三者物'
END AS loss_type_name,
CASE
SDD.LOSS_NO
WHEN 0 THEN
'查勘任务' ELSE '定损任务'
END AS LOSS_NO_NAME,
CASE
SDD.DISPATCH_TYPE
WHEN 0 THEN
'修理厂查勘'
WHEN 1 THEN
'普通查勘'
WHEN 2 THEN
'视频查勘'
WHEN 3 THEN
'客户自助'
WHEN 4 THEN
'预约'
WHEN 5 THEN
'转分公司'
WHEN 6 THEN
'申请改派'
END AS DISPATCH_TYPE_NAME,
CASE
SDD.STATUS
WHEN '1' THEN
'未调度'
WHEN '2' THEN
'已调度'
WHEN '3' THEN
'申请改派'
WHEN '10' THEN
'已接受'
WHEN '11' THEN
'已联系'
WHEN '12' THEN
'已到达'
WHEN '13' THEN
'已完成'
WHEN '99' THEN
'已注销'
WHEN '100' THEN
'转分公司调度'
WHEN '101' THEN
'核心已改派'
WHEN '102' THEN
'转常规'
END AS STATUS_NAME,
SDC.COMPENSATIONCODE AS COMPENSATIONCODE,
SDC.REGIST_DATE AS REGIST_DATE,
SDC.DAMAGE_DATE AS DAMAGE_DATE,
SDD.DISPATCH_TIME AS DISPATCH_TIME,
SDD.SURVEY_DATE AS SURVEY_DATE,
SDD.CREATE_TIME AS CREATE_TIME,
SDD.DISPATCH_REMARK AS DISPATCH_REMARK,
CASE
SDC.isVehicleInsurance
WHEN 1 THEN
'车险'
WHEN 0 THEN
'非车险'
END AS isVehicleInsurance_name,
SDC.COMPENSATIONORG AS COMPENSATIONORG
FROM
sd_dispatch_item SDD
LEFT JOIN sd_case_info SDC ON SDD.CASE_INFO_ID = SDC.ID
LEFT JOIN sd_org_info SDO ON SDC.ORG_ID = SDO.ID
WHERE
1 = 1
AND SDC.ORG_ID = '00320'
AND DISPATCH_TIME >= '2022-01-01 00:00:00'
AND SDD.DISPATCH_TIME < '2022-01-31 23:59:59'
AND SDD.STATUS != '1'
LIMIT 0,
10
改进
重要
李小龙
SELECT
SDD.ID AS ID,
SDO.DESCRIPTION AS ORGNAME,
SDC.REGIST_NO AS REGIST_NO,
SDC.USER_NAME AS USER_NAME,
SDD.SURVEY_NAME AS SURVEY_NAME,
SDD.SURVEY_ORGNAME AS SURVEY_ORG_NAME,
SDD.YARDMAN_NUMBER AS YARDMAN_NUMBER,
SDD.YARDMAN_NAME AS YARDMAN_NAME,
SDD.loss_name AS loss_name,
SDD.SURVEY_PLACE AS SURVEY_PLACE,
CASE
SDD.loss_type
WHEN 1 THEN
'标的车'
WHEN 2 THEN
'三者车'
WHEN 3 THEN
'本车司机'
WHEN 4 THEN
'本车车上人员'
WHEN 5 THEN
'三者人员'
WHEN 6 THEN
'车上物'
WHEN 7 THEN
'三者物'
END AS loss_type_name,
CASE
SDD.LOSS_NO
WHEN 0 THEN
'查勘任务' ELSE '定损任务'
END AS LOSS_NO_NAME,
CASE
SDD.DISPATCH_TYPE
WHEN 0 THEN
'修理厂查勘'
WHEN 1 THEN
'普通查勘'
WHEN 2 THEN
'视频查勘'
WHEN 3 THEN
'客户自助'
WHEN 4 THEN
'预约'
WHEN 5 THEN
'转分公司'
WHEN 6 THEN
'申请改派'
END AS DISPATCH_TYPE_NAME,
CASE
SDD.STATUS
WHEN '1' THEN
'未调度'
WHEN '2' THEN
'已调度'
WHEN '3' THEN
'申请改派'
WHEN '10' THEN
'已接受'
WHEN '11' THEN
'已联系'
WHEN '12' THEN
'已到达'
WHEN '13' THEN
'已完成'
WHEN '99' THEN
'已注销'
WHEN '100' THEN
'转分公司调度'
WHEN '101' THEN
'核心已改派'
WHEN '102' THEN
'转常规'
END AS STATUS_NAME,
SDC.COMPENSATIONCODE AS COMPENSATIONCODE,
SDC.REGIST_DATE AS REGIST_DATE,
SDC.DAMAGE_DATE AS DAMAGE_DATE,
SDD.DISPATCH_TIME AS DISPATCH_TIME,
SDD.SURVEY_DATE AS SURVEY_DATE,
SDD.CREATE_TIME AS CREATE_TIME,
SDD.DISPATCH_REMARK AS DISPATCH_REMARK,
CASE
SDC.isVehicleInsurance
WHEN 1 THEN
'车险'
WHEN 0 THEN
'非车险'
END AS isVehicleInsurance_name,
SDC.COMPENSATIONORG AS COMPENSATIONORG
FROM
sd_dispatch_item SDD
LEFT JOIN sd_case_info SDC ON SDD.CASE_INFO_ID = SDC.ID
LEFT JOIN sd_org_info SDO ON SDC.ORG_ID = SDO.ID
WHERE
1 = 1
AND SDC.ORG_ID = '00320'
AND DISPATCH_TIME >= '2022-01-01 00:00:00'
AND SDD.DISPATCH_TIME < '2022-01-31 23:59:59'
AND SDD.STATUS != '1'
LIMIT 0,
10