建站
咨詢
售后
建站咨詢
新聞中心
SELECT
COMPLAIN_CODE '投訴單號',
ORDER_NO '訂單號',
RESPONSIBILITY '責(zé)任單位名稱',
CREATE_TIME '創(chuàng)建時間',
COMPLAIN_TYPE '發(fā)起工單類型',
DUTY_COMPLAIN_TYPE '定責(zé)投訴類型',
COMPLAIN_SOUND_TYPE '聲音歸類',
COMPLAIN_DATE '投訴日期',
MEMO '情況說明',
HANDLER1 "發(fā)起人工號",
HANDLER2 "結(jié)束人工號",
HANDLER_DATE1 "投訴開始時間",
HANDLER_DATE2 "投訴結(jié)束時間",
HANDLER_TYPE '處理類型',
EOOR_SHIPPER_CONTACT '收貨方聯(lián)系人',
EOOR_SHIPPER_CITY_NAME '發(fā)貨地址城市',
EOOR_CONSIGNEE_CITY_NAME '收貨地址城市',
EOOR_ORDER_TYPE '訂單類型',
SEND_DATE '發(fā)貨時間',
EOOR_SERVICE_MODE '服務(wù)類型',
EOOS_SUPPLIER_FULL_NAME1'供應(yīng)商全名',
EOTS_LINK_TYPE '落地配'
FROM
(
SELECT
t.COMPLAIN_CODE,
t.ORDER_NO,
t.RESPONSIBILITY,
t.CREATE_TIME,
CASE t.COMPLAIN_TYPE
WHEN 'SAFETY' THEN
'安全類'
WHEN 'CUSTOMER' THEN
'客戶類'
WHEN 'AGEING' THEN
'時效類'
WHEN 'ACTION' THEN
'客戶體驗類'
WHEN 'DELIVERY' THEN
'配送類'
ELSE
'貨代業(yè)務(wù)線上化'
END 'COMPLAIN_TYPE',
t.COMPLAIN_SOUND_TYPE,
t.COMPLAIN_DATE,
t.MEMO,
t.DUTY_COMPLAIN_TYPE,
b. HANDLER 'HANDLER1',
b.HANDLER_TYPE,
c.EOOR_SHIPPER_CONTACT,
c.EOOR_SHIPPER_CITY_NAME,
c.EOOR_CONSIGNEE_CITY_NAME,
c.EOOR_ORDER_TYPE,
c.SEND_DATE,
c.EOOR_SERVICE_MODE,
d.EOOS_SUPPLIER_FULL_NAME 'EOOS_SUPPLIER_FULL_NAME1',
CASE e.EOTS_LINK_TYPE
when '21' THEN '收貨'
when '22' THEN '配單'
when '23' THEN '發(fā)貨'
when '24' THEN '裝機'
when '51' THEN '提貨主單'
when '61' THEN '提貨訂單'
when '62' THEN '貨代簽收'
when '71' THEN '落地配交接'
when '72' THEN '落地配分配'
ELSE
'落地配簽收'
END 'EOTS_LINK_TYPE',
min(b.HANDLER_DATE) 'HANDLER_DATE1'
FROM
cs_complained_info t
LEFT JOIN cs_complained_handle_record b ON b. CODE = t.COMPLAIN_CODE
LEFT JOIN eo_order c ON c.EOOR_ORDER_NO = t.ORDER_NO
LEFT JOIN eo_order_supplier d ON d.EOOS_ORDER_NO = t.ORDER_NO
LEFT JOIN eo_order_task_status e ON e.EOOR_ORDER_NO = t.ORDER_NO
WHERE
t.HANDLE_STATUS = "DONE"
AND T.ORDER_NO != " "
AND t.CREATE_TIME > "2017-1-1"
GROUP BY
t.COMPLAIN_CODE
) AS A
LEFT JOIN (
SELECT
t.COMPLAIN_CODE 'COMPLAIN_CODE2',
b. HANDLER 'HANDLER2',
max(b.HANDLER_DATE) 'HANDLER_DATE2'
FROM
cs_complained_info t
LEFT JOIN cs_complained_handle_record b ON b. CODE = t.COMPLAIN_CODE
LEFT JOIN eo_order c ON c.EOOR_ORDER_NO = t.ORDER_NO
LEFT JOIN eo_order_supplier d ON d.EOOS_ORDER_NO = t.ORDER_NO
LEFT JOIN eo_order_task_status e ON e.EOOR_ORDER_NO = t.ORDER_NO
WHERE
t.HANDLE_STATUS = "DONE"
AND b.HANDLER_RESULT = "FINISH"
AND T.ORDER_NO != " "
AND t.CREATE_TIME > "2017-1-1"
GROUP BY
t.COMPLAIN_CODE
) AS B ON A.COMPLAIN_CODE = B.COMPLAIN_CODE2
ORDER BY COMPLAIN_CODE DESC
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機、免備案服務(wù)器”等云主機租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。
網(wǎng)頁標(biāo)題：SQL獲取數(shù)據(jù)-創(chuàng)新互聯(lián)
地址分享：http://www.dlmjj.cn/article/egdhj.html
