编辑备注

备注详细内容

作者李小龙

创建日期 02/三月/22

备注

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