{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":61,"n_cols":31,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["工单编号","order_no",null,"order_no"]
["客服流水号","A.form_basic_data ->> 'serv_order' AS serv_order",null,"serv_order"]
["是否GIS拦截单","get_sys_name ( A.form_basic_data ->> 'is_gis_intercept' ) as is_gis_intercept",null,"is_gis_intercept"]
["受理渠道","get_sys_name ( A.form_basic_data ->> 'kd_acceptchannel' ) as kd_acceptchannel",null,"kd_acceptchannel"]
["受理号码","A.form_basic_data ->> 'kd_acceptno' AS kd_acceptno",null,"kd_acceptno"]
["主叫号码","A.form_basic_data ->> 'kd_callingno' AS kd_callingno",null,"kd_callingno"]
["客户级别","get_sys_name ( A.form_basic_data ->> 'custlevel' )  AS custlevel",null,"custlevel"]
["客户套餐","A.form_basic_data ->> 'kd_pkgname' AS kd_pkgname",null,"kd_pkgname",{"$nulls":4},"客服受理时间","客服要求回复时间","客服答复状态","答复是否超时","是否客服回单","是否客服退单","是否客服归档","是否客服重派","重派次数","催单次数","回单时间","投诉点环境（回单）","产品类型（回单）","业务类别（回单）","网络类型（回单）","问题责任归属（回单）","工单定性（回单）","问题解决结论（回单）","回单内容","退单时间","退单内容"]
["投诉级别","get_sys_name ( A.form_basic_data ->> 'kd_cpllevel' )  AS kd_cpllevel",null,"kd_cpllevel"]
["投诉内容","A.form_basic_data ->> 'kd_cplcontent' AS kd_cplcontent",null,"kd_cplcontent"]
["原投诉地市","A.form_basic_data ->> 'kd_city' AS kd_city",null,"kd_city"]
["原投诉区县","A.form_basic_data ->> 'kd_region' AS kd_region",null,"kd_region"]
["原投诉现象","get_sys_name ( A.form_basic_data ->> 'kd_faultphen' ) as kd_faultphen",null,"kd_faultphen"]
["原投诉网络类型","get_sys_name ( A.form_basic_data ->> 'kd_networktype' ) as kd_networktype",null,"kd_networktype"]
["原投诉经度","A.form_basic_data ->> 'kd_longitude' AS kd_longitude",null,"kd_longitude"]
["原投诉纬度","A.form_basic_data ->> 'kd_latitude' AS kd_latitude",null,"kd_latitude"]
["原投诉地址","A.form_basic_data ->> 'kd_cpladdress' AS kd_cpladdress",null,"kd_cpladdress"]
["客服受理时间","A.form_basic_data ->> 'kd_accepttime' AS kd_accepttime",null,"kd_accepttime"]
["客服要求回复时间","A.form_basic_data ->> 'kd_requestreplytime' AS kd_requestreplytime",null,"kd_requestreplytime"]
["客服答复状态","get_sys_name ( A.form_basic_data ->> 're_is_status' )  AS re_is_status",null,"re_is_status"]
["答复是否超时","get_sys_name ( A.form_basic_data ->> 'res_is_timeout' )  AS res_is_timeout",null,"res_is_timeout"]
["是否客服回单","get_sys_name ( A.form_basic_data ->> 'rceiptorder' )  AS rceiptorder",null,"rceiptorder"]
["是否客服退单","get_sys_name ( A.form_basic_data ->> 'returnorder' )  AS returnorder",null,"returnorder"]
["是否客服归档","get_sys_name ( A.form_basic_data ->> 'is_dealtype' )  AS is_dealtype",null,"is_dealtype"]
["是否客服重派","get_sys_name ( A.form_basic_data ->> 'is_reassign' )  AS is_reassign",null,"is_reassign"]
["重派次数","A.form_basic_data ->> 'reassign_num' AS reassign_num",null,"reassign_num"]
["催单次数","A.form_basic_data ->> 'reminders_num' AS reminders_num",null,"reminders_num"]
["投诉点环境（回单）","questionsencetext","complaint.kf_log","questionsencetext",{"$nulls":4},"系统接单时间","当前环节","当前处理人","工单历时","工单状态","归档类型","实际投诉地市","实际投诉区县","实际投诉经度","实际投诉纬度","实际投诉地址","实际投诉点环境","实际投诉点室内外","实际投诉现象","实际业务类型","实际网络类型","实际工单定性","实际工单责任归属","实际工单解决方案","实际问题是否解决","用户是否认可","归档说明","审核意见"]
["产品类型（回单）","producttext","complaint.kf_log","producttext"]
["业务类别（回单）","busitypetext","complaint.kf_log","busitypetext"]
["网络类型（回单）","acceptnettypetext","complaint.kf_log","acceptnettypetext"]
["问题责任归属（回单）","dutytext","complaint.kf_log","dutytext"]
["工单定性（回单）","tsreason","complaint.kf_log","tsreason"]
["问题解决结论（回单）","reasulttext","complaint.kf_log","reasulttext"]
["回单时间","order_hd_time","complaint.kf_log","order_hd_time"]
["回单内容","zjdfcontent","complaint.kf_log","zjdfcontent"]
["退单时间","order_td_time","complaint.kf_log","order_td_time"]
["退单内容","content","complaint.kf_log","content"]
["系统接单时间","create_time",null,"create_time"]
["当前环节","C.name_ AS node_name,",null,"node_name"]
["当前处理人","assignee_/A.form_basic_data ->> 'assign_name'",null,"assignee_"]
["工单历时","now()-create_time as worksheet_period",null,"worksheet_period"]
["工单状态","get_sys_name (a.order_state )  AS order_state",null,"order_state"]
["工单归档类型","get_sys_name ( A.form_basic_data ->> 'file_type' )  AS file_type",null,"file_type"]
["实际投诉地市","get_sys_name ( A.city ) AS city",null,"city "]
["实际投诉区县","get_sys_name ( A.region ) AS region",null,"region"]
["实际投诉经度","A.form_basic_data ->> 'yh_correct_lng' AS yh_correct_lng",null,"yh_correct_lng"]
["实际投诉纬度","A.form_basic_data ->> 'yh_correct_lat' AS yh_correct_lat",null,"yh_correct_lat"]
["实际投诉地址","A.form_basic_data ->> 'yh_correct_compaints_address' AS yh_correct_compaints_address",null,"yh_correct_compaints_address"]
["实际投诉点环境","get_sys_name ( A.form_basic_data ->> 'hc_complaints_environment' )  AS hc_complaints_environment",null,"hc_complaints_environment"]
["实际投诉点室内外","get_sys_name ( A.form_basic_data ->> 'hc_complaints_snw' )  AS hc_compaints_snw",null,"hc_compaints_snw"]
["实际投诉现象","get_sys_name ( A.form_basic_data ->> 'hc_complaints_netxx' )  AS hc_complaints_netxx",null,"hc_complaints_netxx"]
["实际业务类型","get_sys_name ( A.form_basic_data ->> 'hc_business_type' )  AS hc_business_type",null,"hc_business_type"]
["实际网络类型","get_sys_name ( A.form_basic_data ->> 'hc_network_type' )  AS hc_network_type",null,"hc_network_type"]
["实际工单定性","get_sys_name ( A.form_basic_data ->> 'hc_gddx' )  AS hc_gddx",null,"hc_gddx"]
["实际工单责任归属","get_sys_name ( A.form_basic_data ->> 'hc_gdzrgs' )  AS hc_gdzrgs",null,"hc_gdzrgs"]
["实际工单解决方案","get_sys_name ( A.form_basic_data ->> 'hc_solution' )  AS hc_solution",null,"hc_solution"]
["实际问题是否解决","get_sys_name ( A.form_basic_data ->> 'hc_is_solution' )  AS hc_is_solution",null,"hc_is_solution"]
["用户是否认可","get_sys_name ( A.form_basic_data ->> 'hc_user_approval' )  AS hc_user_approval",null,"hc_user_approval"]
["归档说明","A.form_basic_data ->> 'hc_gdsm' AS hc_gdsm",null,"hc_gdsm"]
["审核意见","F.form_basic_data ->> 'sh_dispose_explain'",null,"sh_dispose_explain"]

{"sheet":"Sheet2","index":1,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["工单编号","客服流水号","投诉地市","投诉区县","是否GIS拦截单","客服受理时间","投诉级别","受理号码","当前环节","客服要求答复时间","答复剩余时间","催单次数","是否重派","重派次数"]