query("SELECT 1 FROM queue_log LIMIT 1"); } catch (Exception $e) { echo '

queue_log table not found in your database. Please check your Issabel/Asterisk configuration.

'; return; } $from = isset($_GET['from']) ? $_GET['from'] : date('Y-m-01'); $to = isset($_GET['to']) ? $_GET['to'] : date('Y-m-d'); // Get all queues in the date range $queues = array(); $q = $db->query("SELECT DISTINCT queuename FROM queue_log WHERE time BETWEEN '$from 00:00:00' AND '$to 23:59:59' AND queuename != ''"); while ($row = $q->fetch(PDO::FETCH_ASSOC)) { $queues[] = $row['queuename']; } $stats = array(); foreach ($queues as $queue) { // Calls entered $entered = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='ENTERQUEUE' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); // Calls answered $answered = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='CONNECT' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); // Calls abandoned $abandoned = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='ABANDON' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); // Calls completed (LEAVEQUEUE) $completed = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='LEAVEQUEUE' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); // Calls transferred (TRANSFER) $transferred = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='TRANSFER' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); // Max wait time for answered calls (CONNECT event, data2 is wait time in seconds) $waits = $db->query("SELECT data2 FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='CONNECT' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'"); $wait_sum = 0; $wait_count = 0; $max_wait = 0; $min_wait = null; while ($w = $waits->fetch(PDO::FETCH_ASSOC)) { $wait = intval($w['data2']); $wait_sum += $wait; $wait_count++; if ($wait > $max_wait) $max_wait = $wait; if ($min_wait === null || $wait < $min_wait) $min_wait = $wait; } $avg_wait = $wait_count ? round($wait_sum / $wait_count, 1) : 0; // Service Level: % answered within 20s (or your SLA) $sla_time = 20; $sla_count = $db->query("SELECT COUNT(*) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='CONNECT' AND data2 <= $sla_time AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); $sla = $answered ? round(($sla_count / $answered) * 100, 1) : 0; // Unique callers $unique_callers = $db->query("SELECT COUNT(DISTINCT data1) FROM queue_log WHERE queuename=".$db->quote($queue)." AND event='ENTERQUEUE' AND time BETWEEN '$from 00:00:00' AND '$to 23:59:59'")->fetchColumn(); $stats[] = array( 'queue' => $queue, 'entered' => $entered, 'answered' => $answered, 'abandoned' => $abandoned, 'completed' => $completed, 'transferred' => $transferred, 'avg_wait' => $avg_wait, 'max_wait' => $max_wait, 'min_wait' => $min_wait === null ? 0 : $min_wait, 'sla' => $sla, 'unique_callers' => $unique_callers ); } ?>

Queue Analytics (with Parsing)

No queue data found for the selected period.

Queue	Entered	Answered	Abandoned	Completed	Transferred	Unique Callers	Avg Wait (s)	Max Wait (s)	Min Wait (s)	SLA (≤20s)
										%

query("SELECT 1 FROM queue_log LIMIT 1"); } catch (Exception $e) { echo '

queue_log table not found in your database. Please check your Issabel/Asterisk configuration.

'; return; } // --- Call Metrics --- // Active calls (last 2 min, answered) $active_calls = $db->query("SELECT COUNT(*) FROM cdr WHERE disposition='ANSWERED' AND calldate >= NOW() - INTERVAL 2 MINUTE")->fetchColumn(); // Total calls today $today = date('Y-m-d'); $total_calls = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Answered, No Answer, Busy, Failed $answered = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND disposition='ANSWERED'")->fetchColumn(); $noanswer = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND disposition='NO ANSWER'")->fetchColumn(); $busy = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND disposition='BUSY'")->fetchColumn(); $failed = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND disposition='FAILED'")->fetchColumn(); // Inbound/Outbound $inbound = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND dstchannel != ''")->fetchColumn(); $outbound = $db->query("SELECT COUNT(*) FROM cdr WHERE DATE(calldate) = '$today' AND dstchannel = ''")->fetchColumn(); // Average duration $avg_duration = $db->query("SELECT AVG(duration) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Max duration $max_duration = $db->query("SELECT MAX(duration) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Min duration $min_duration = $db->query("SELECT MIN(duration) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Total billable seconds $total_billsec = $db->query("SELECT SUM(billsec) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Unique callers today $unique_callers = $db->query("SELECT COUNT(DISTINCT src) FROM cdr WHERE DATE(calldate) = '$today'")->fetchColumn(); // Waiting in queue: ENTERQUEUE events in last 5 min minus CONNECT and ABANDON in last 5 min $waiting_callids = array(); $q = $db->query("SELECT callid FROM queue_log WHERE event='ENTERQUEUE' AND time >= NOW() - INTERVAL 5 MINUTE"); while ($row = $q->fetch(PDO::FETCH_ASSOC)) { $waiting_callids[] = $row['callid']; } $queue_waiting = 0; if (count($waiting_callids)) { $in = "'".implode("','", $waiting_callids)."'"; $q2 = $db->query("SELECT callid FROM queue_log WHERE event IN ('CONNECT','ABANDON') AND time >= NOW() - INTERVAL 5 MINUTE AND callid IN ($in)"); $not_waiting = array(); while ($row = $q2->fetch(PDO::FETCH_ASSOC)) { $not_waiting[] = $row['callid']; } $queue_waiting = count(array_diff($waiting_callids, $not_waiting)); } // Agents online: AGENTLOGIN events in last 8 hours minus AGENTLOGOFF $agents = array(); $q = $db->query("SELECT agent FROM queue_log WHERE event='AGENTLOGIN' AND time >= NOW() - INTERVAL 8 HOUR"); while ($row = $q->fetch(PDO::FETCH_ASSOC)) { $agents[$row['agent']] = true; } $q = $db->query("SELECT agent FROM queue_log WHERE event='AGENTLOGOFF' AND time >= NOW() - INTERVAL 8 HOUR"); while ($row = $q->fetch(PDO::FETCH_ASSOC)) { unset($agents[$row['agent']]); } $agents_online = count($agents); // Longest wait in queue (today) $longest_wait = $db->query("SELECT MAX(data2) FROM queue_log WHERE event='CONNECT' AND DATE(time) = '$today'")->fetchColumn(); // Shortest wait in queue (today) $shortest_wait = $db->query("SELECT MIN(data2) FROM queue_log WHERE event='CONNECT' AND DATE(time) = '$today'")->fetchColumn(); // Service Level: % answered within 20s (today) $sla_time = 20; $answered_today = $db->query("SELECT COUNT(*) FROM queue_log WHERE event='CONNECT' AND DATE(time) = '$today'")->fetchColumn(); $sla_count = $db->query("SELECT COUNT(*) FROM queue_log WHERE event='CONNECT' AND data2 <= $sla_time AND DATE(time) = '$today'")->fetchColumn(); $sla = $answered_today ? round(($sla_count / $answered_today) * 100, 1) : 0; ?>

Total Calls Today

Answered

No Answer

Busy

Failed

Unique Callers

Inbound

Outbound

s

Avg Duration

Max Duration

Min Duration

Total Billsec

Waiting in Queue

Agents Online

Longest Wait (s)

Shortest Wait (s)

%

SLA (≤20s)

Wallboard auto-refreshes every 10 seconds.