db = new PDO( "mysql:host=".DB_HOST.";dbname=".DB_NAME, DB_USER, DB_PASS ); $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } public function getActiveCalls() { $stmt = $this->db->query("SELECT COUNT(*) FROM asteriskcdrdb.cdr WHERE disposition = 'ANSWERED' AND duration > 0"); return $stmt->fetchColumn(); } public function getQueueStats() { $stmt = $this->db->query(" SELECT q.name, COUNT(qm.uniqueid) as agents, SUM(IF(qm.status='Available',1,0)) as available FROM asterisk.queues q LEFT JOIN asterisk.queue_members qm ON q.name = qm.queue_name GROUP BY q.name "); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function getRecentCalls($limit = 10) { $stmt = $this->db->prepare(" SELECT calldate, src, dst, duration, disposition FROM asteriskcdrdb.cdr ORDER BY calldate DESC LIMIT :limit "); $stmt->bindValue(':limit', $limit, PDO::PARAM_INT); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function getSystemStatus() { // Simulated system status return [ 'cpu' => rand(10, 90), 'memory' => rand(20, 95), 'disk' => rand(5, 80) ]; } } $dashboard = new Dashboard(); ?> Issabel PBX Dashboard

Issabel PBX Dashboard

getActiveCalls() ?>

Active Calls

getSystemStatus(); ?>

CPU Usage

Memory Usage

Disk Usage

Queue Statistics

getQueueStats() as $queue): ?>

Queue	Agents	Available

Recent Calls

getRecentCalls() as $call): ?>

Time	From	To	Duration	Status
			s

db = new PDO( "mysql:host=".DB_HOST.";dbname=".DB_NAME, DB_USER, DB_PASS ); $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } public function getQueueStatus() { $stmt = $this->db->query(" SELECT q.name as queue_name, COUNT(DISTINCT qm.uniqueid) as total_agents, SUM(IF(qm.status='Available',1,0)) as available_agents, COUNT(qe.callid) as waiting_calls, MAX(IFNULL(qe.waittime,0)) as max_wait FROM asterisk.queues q LEFT JOIN asterisk.queue_members qm ON q.name = qm.queue_name LEFT JOIN asterisk.queue_entries qe ON q.name = qe.queue_name GROUP BY q.name "); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function getTodayStats() { $stmt = $this->db->query(" SELECT COUNT(*) as total_calls, SUM(IF(disposition='ANSWERED',1,0)) as answered, SUM(IF(disposition='NO ANSWER',1,0)) as missed, AVG(duration) as avg_duration FROM asteriskcdrdb.cdr WHERE DATE(calldate) = CURDATE() "); return $stmt->fetch(PDO::FETCH_ASSOC); } } $wallboard = new Wallboard(); $queues = $wallboard->getQueueStatus(); $stats = $wallboard->getTodayStats(); ?> Issabel PBX Wallboard

Today's Call Statistics

Total Calls

Answered

Missed

Avg Duration

Agents Available

Waiting Calls

Max Wait