SQL获取数据

SELECT

创新互联公司于2013年创立，先为邳州等服务建站，邳州等地企业，进行企业商务咨询服务。为邳州企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

         COMPLAIN_CODE '投诉单号',

         ORDER_NO '订单号',

         RESPONSIBILITY '责任单位名称',

         CREATE_TIME '创建时间',

         COMPLAIN_TYPE '发起工单类型',

  DUTY_COMPLAIN_TYPE '定责投诉类型',

         COMPLAIN_SOUND_TYPE '声音归类',

         COMPLAIN_DATE '投诉日期',

         MEMO '情况说明',

  HANDLER1 "发起人工号",

  HANDLER2 "结束人工号",

  HANDLER_DATE1 "投诉开始时间",

  HANDLER_DATE2 "投诉结束时间",

         HANDLER_TYPE '处理类型',

         EOOR_SHIPPER_CONTACT '收货方联系人',

         EOOR_SHIPPER_CITY_NAME '发货地址城市',

         EOOR_CONSIGNEE_CITY_NAME '收货地址城市',

         EOOR_ORDER_TYPE '订单类型',

         SEND_DATE '发货时间',

         EOOR_SERVICE_MODE '服务类型',

         EOOS_SUPPLIER_FULL_NAME1'供应商全名',

         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

                            '货代业务线上化'

                   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 '发货'

                   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获取数据
地址分享：https://www.cdcxhl.com/article20/jchsco.html

成都网站建设公司_创新互联，为您提供网站改版、微信小程序、用户体验、响应式网站、网页设计公司、网站建设

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联