Call Center Stats

I'll create a PHP 5.4-compatible web application for Asterisk call center stats. Here's the initial structure: Call Center Stats

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { die("Database connection failed: " . $e->getMessage()); } // Set timezone date_default_timezone_set(TIMEZONE); ?> = ?"; $params[] = $dateFrom; } if ($dateTo) { $sql .= " AND time <= ?"; $params[] = $dateTo; } $stmt = $db->prepare($sql); $stmt->execute($params); return $stmt->fetchAll(PDO::FETCH_ASSOC); } function getAgentStatus($agent) { // Parse queue_log to determine current agent status // Returns: 'available', 'oncall', 'paused' } function getQueueStats($queue, $period = 'today') { // Calculate queue statistics for given period } function formatDuration($seconds) { $hours = floor($seconds / 3600); $minutes = floor(($seconds / 60) % 60); $seconds = $seconds % 60; return sprintf("%02d:%02d:%02d", $hours, $minutes, $seconds); } function logAction($action, $details = '') { global $db; $stmt = $db->prepare("INSERT INTO activity_log (user_id, action, details, ip_address, timestamp) VALUES (?, ?, ?, ?, NOW())"); $stmt->execute([ $_SESSION['user_id'], $action, $details, $_SERVER['REMOTE_ADDR'] ]); } ?>

Real-Time Dashboard

Last updated:

Queue Overview

Agent Status

Agent	Status	Calls	Duration

Recent Calls

Time	Caller ID	Queue	Agent	Status	Duration

'Not authenticated'])); } $response = [ 'queueData' => getQueueStats('all'), 'agentStatus' => '', 'recentCalls' => '' ]; // Generate agent status HTML $agents = getAgents(); foreach ($agents as $agent) { $status = getAgentStatus($agent['id']); $response['agentStatus'] .= " {$agent['name']} ".ucfirst($status)." {$agent['calls_today']} ".formatDuration($agent['talk_time'])." "; } // Generate recent calls HTML $calls = getRecentCalls(10); foreach ($calls as $call) { $response['recentCalls'] .= " {$call['time']} {$call['callerid']} {$call['queue']} {$call['agent']} {$call['status']} ".formatDuration($call['duration'])." "; } echo json_encode($response); ?> -- Database schema for Asterisk Call Center Stats CREATE TABLE IF NOT EXISTS users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, full_name VARCHAR(100) NOT NULL, role ENUM('admin', 'supervisor', 'agent') NOT NULL, email VARCHAR(100), extension VARCHAR(20), queues TEXT, -- Comma-separated list of queues this user can access last_login DATETIME, is_active BOOLEAN DEFAULT TRUE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS activity_log ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, action VARCHAR(100) NOT NULL, details TEXT, ip_address VARCHAR(45), timestamp DATETIME NOT NULL, FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE IF NOT EXISTS settings ( id INT AUTO_INCREMENT PRIMARY KEY, setting_key VARCHAR(100) NOT NULL UNIQUE, setting_value TEXT, description TEXT, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); -- Sample data INSERT INTO users (username, password, full_name, role, email, extension, queues) VALUES ('admin', '$2y$10$N9qo8uLOickgx2ZMRZoMy.MQRv/7Qy8Xg6U1d1e6d2tT0Jw6QyYbK', 'Admin User', 'admin', 'admin@example.com', '1000', 'sales,support'), ('supervisor1', '$2y$10$N9qo8uLOickgx2ZMRZoMy.MQRv/7Qy8Xg6U1d1e6d2tT0Jw6QyYbK', 'Supervisor One', 'supervisor', 'supervisor@example.com', '1001', 'sales,support'), ('agent1', '$2y$10$N9qo8uLOickgx2ZMRZoMy.MQRv/7Qy8Xg6U1d1e6d2tT0Jw6QyYbK', 'Agent One', 'agent', 'agent1@example.com', '1002', 'sales'); INSERT INTO settings (setting_key, setting_value, description) VALUES ('sla_threshold', '20', 'Maximum wait time in seconds before SLA is breached'), ('long_call_threshold', '600', 'Call duration in seconds considered too long'), ('date_format', 'Y-m-d H:i:s', 'Default date format for display'); /* Main Styles */ body { padding-top: 50px; font-family: 'Arial', sans-serif; } .main-content { margin-left: 220px; padding: 20px; transition: margin-left 0.3s; } /* Sidebar Styles */ .sidebar { position: fixed; top: 50px; bottom: 0; left: 0; width: 220px; padding: 20px 0; background-color: #f8f9fa; border-right: 1px solid #dee2e6; transition: all 0.3s; } /* Panel Styles */ .panel { margin-bottom: 20px; background-color: #fff; border: 1px solid transparent; border-radius: 4px; box-shadow: 0 1px 1px rgba(0,0,0,.05); } .panel-heading { padding: 10px 15px; border-bottom: 1px solid transparent; border-top-right-radius: 3px; border-top-left-radius: 3px; } /* Status Labels */ .label-available { background-color: #5cb85c; } .label-oncall { background-color: #5bc0de; } .label-paused { background-color: #f0ad4e; } .label-offline { background-color: #d9534f; } /* Dark Mode */ .dark-mode { background-color: #222; color: #eee; } .dark-mode .panel { background-color: #333; color: #eee; } .dark-mode .sidebar { background-color: #2c3e50; color: #eee; } $(document).ready(function() { // Initialize DataTables $('.table').DataTable({ responsive: true, paging: false, searching: false, info: false }); // Toggle dark mode $('#darkModeToggle').click(function() { $('body').toggleClass('dark-mode'); localStorage.setItem('darkMode', $('body').hasClass('dark-mode')); }); // Check for saved dark mode preference if (localStorage.getItem('darkMode') === 'true') { $('body').addClass('dark-mode'); } // Language switcher $('.language-switcher').click(function() { var lang = $(this).data('lang'); $.ajax({ url: 'ajax/set_language.php', method: 'POST', data: { language: lang }, success: function() { location.reload(); } }); }); // Real-time updates for dashboard if ($('#queueChart').length) { setInterval(function() { updateDashboard(); }, 5000); } }); This is the initial structure with core functionality. Would you like me to add any specific features or make adjustments to the existing implementation?