工作手机


SELECT
        s.student_no,
        cr.student_intention_id,
        cr.content,
        tcr.start_time as '呼叫座席时间',
        tcr.answer_time as '座席接听时间',
        tcr.bridge_time as '客户接听时间',
        tcr.end_time as '挂机时间',
        timestampdiff(second,tcr.bridge_time,tcr.end_time)/60 as '天润通话时长/分钟',
        (case tcr.`status` when 33 then '双方接听' when 30 then '座席未接听' when 31 then '座席接听' when 32 then '客户未接听' else '' end) '天润通话状态',
        wwpc.begin_time as '拨打开始时间',
        wwpc.end_time as '拨打结束时间',
        wwpc.calling_seconds/60 '工作手机拨打时间'
FROM
        view_communication_record cr
LEFT JOIN
        view_student s on s.student_intention_id = cr.student_intention_id
LEFT JOIN
        view_user_info u on u.user_id  = cr.communication_person
LEFT JOIN
        view_tms_call_record tcr on tcr.record_id = cr.communication_record_id
LEFT JOIN
        bidata.will_work_phone_call_recording wwpc on wwpc.id = cr.communication_record_id
WHERE
        s.student_no in ()
文档更新时间: 2019-08-19 11:54   作者:admin