Appearance
页面暂无导出功能,数据库导出sql如下
sql
SELECT
t1.call_result_fmt as '呼叫结果',
t2.cust_name as '客户信息-客户名称',
t2.cust_no as '客户信息-客户编码',
t2.ou_name as '客户信息-业务实体',
t2.usage_name as '客户信息-用途',
t1.agent_name as '成员信息-开票员姓名',
-- b.成员信息,展示开票员姓名、所在部门(展示大区-分公司-班组);
t3.grp_name as '成员信息-班组',
t1.call_data as '分公司',
t1.c_start_time as '开始时间',
t1.a_answer_time as '应答时间',
t1.c_end_time as '结束时间',
t1.billsec as '通话时长(秒)-总时长',
t1.talksec as '通话时长(秒)-对话时长',
t1.queue_sec as '通话时长(秒)-排队时长',
t2.event_names as '呼叫原因',
t1.hangup_fmt as '挂机方',
t1.call_direction as '呼叫类型',
t2.note as '备注',
t2.content as '待办事项',
t1.customer as '用户号码',
t1.dnis as '外显号码',
t1.call_id as '话单ID',
t1.vad_result_code as '语音检测结果-编码',
t1.vad_result_name as '语音检测结果-名称',
t1.ringsec as '振铃时长',
IF(t1.call_result != 1 and t1.ringsec = 0, '未触达', '已触达') as '触达类型'
FROM tb_call_history t1
LEFT JOIN tb_call_work_order t2 ON t2.username = t1.agent AND t2.call_id = t1.call_id
LEFT JOIN tb_call_employee t3 ON t3.username = t1.agent
where t1.call_data is not NULL
and t1.c_start_time >= '2026-05-01-00:00:00'
ORDER BY t1.c_start_time,t1.call_data