requireAdmin();
$user = $auth->getCurrentUser();
$db = Database::getInstance();
// Get system statistics
$stats = [
'total_companies' => $db->fetchOne("SELECT COUNT(*) as count FROM companies")['count'],
'active_companies' => $db->fetchOne("SELECT COUNT(*) as count FROM companies WHERE status = 'active'")['count'],
'trial_companies' => $db->fetchOne("SELECT COUNT(*) as count FROM companies WHERE status = 'trial'")['count'],
'total_users' => $db->fetchOne("SELECT COUNT(*) as count FROM users")['count'],
'active_users' => $db->fetchOne("SELECT COUNT(*) as count FROM users WHERE status = 'active'")['count'],
'total_projects' => $db->fetchOne("SELECT COUNT(*) as count FROM projects")['count'],
'active_projects' => $db->fetchOne("SELECT COUNT(*) as count FROM projects WHERE status = 'active'")['count'],
'total_tasks' => $db->fetchOne("SELECT COUNT(*) as count FROM tasks")['count'],
'completed_tasks' => $db->fetchOne("SELECT COUNT(*) as count FROM tasks WHERE status = 'completed'")['count']
];
// Get revenue statistics
$revenue = [
'mrr' => $db->fetchOne("
SELECT SUM(
CASE
WHEN plan = 'starter' THEN 10
WHEN plan = 'business' THEN 20
WHEN plan = 'enterprise' THEN 35
ELSE 0
END
) as total
FROM companies WHERE status = 'active'
")['total'] ?? 0,
'arr' => 0
];
$revenue['arr'] = $revenue['mrr'] * 12;
// Get recent activities
$recentActivities = $db->fetchAll("
SELECT al.*, u.name as user_name, c.name as company_name
FROM audit_logs al
JOIN users u ON al.user_id = u.id
JOIN companies c ON al.company_id = c.id
ORDER BY al.created_at DESC
LIMIT 10
");
// Get growth metrics
$growthData = $db->fetchAll("
SELECT DATE(created_at) as date, COUNT(*) as new_companies
FROM companies
WHERE created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)
GROUP BY DATE(created_at)
ORDER BY date ASC
");
$pageTitle = 'Admin Dashboard';
include '../includes/header.php';
?>
C$
+12.5% from last month
| Total Companies |
|
| Active Companies |
|
| Trial Companies |
|
| Total Users |
|
| Active Users |
|
| Total Projects |
|
| Active Projects |
|
| Total Tasks |
|
| Completed Tasks |
|