Skip to content

页面暂无导出功能,数据库导出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

页脚:版权前显示的信息