SQL獲取數(shù)據(jù)

SELECT

創(chuàng)新互聯(lián)公司于2013年創(chuàng)立，先為邳州等服務(wù)建站，邳州等地企業(yè)，進(jìn)行企業(yè)商務(wù)咨詢服務(wù)。為邳州企業(yè)網(wǎng)站制作PC+手機+微官網(wǎng)三網(wǎng)同步一站式服務(wù)解決您的所有建站問題。

         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

文章名稱：SQL獲取數(shù)據(jù)
地址分享：http://muchs.cn/article20/jchsco.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站改版、微信小程序、用戶體驗、響應(yīng)式網(wǎng)站、網(wǎng)頁設(shè)計公司、網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)

外貿(mào)網(wǎng)站建設(shè)