query("SELECT COUNT(*) as count FROM services WHERE status = 'active'");
$stats['services'] = $stmt->fetch()['count'];
// Total Gallery Images
$stmt = $db->query("SELECT COUNT(*) as count FROM gallery WHERE status = 'active'");
$stats['gallery'] = $stmt->fetch()['count'];
// Total Appointments
$stmt = $db->query("SELECT COUNT(*) as count FROM appointments");
$stats['total_appointments'] = $stmt->fetch()['count'];
// Pending Appointments
$stmt = $db->query("SELECT COUNT(*) as count FROM appointments WHERE status = 'pending'");
$stats['pending_appointments'] = $stmt->fetch()['count'];
// Today's Appointments
$stmt = $db->query("SELECT COUNT(*) as count FROM appointments WHERE appointment_date = CURDATE()");
$stats['today_appointments'] = $stmt->fetch()['count'];
// Total Enquiries
$stmt = $db->query("SELECT COUNT(*) as count FROM enquiries");
$stats['total_enquiries'] = $stmt->fetch()['count'];
// New Enquiries
$stmt = $db->query("SELECT COUNT(*) as count FROM enquiries WHERE status = 'new'");
$stats['new_enquiries'] = $stmt->fetch()['count'];
// Active Notices
$stmt = $db->query("SELECT COUNT(*) as count FROM notices WHERE status = 'active'");
$stats['active_notices'] = $stmt->fetch()['count'];
// Total Downloads
$stmt = $db->query("SELECT COUNT(*) as count FROM downloads WHERE status = 'active'");
$stats['downloads'] = $stmt->fetch()['count'];
// Total Users
$stmt = $db->query("SELECT COUNT(*) as count FROM users WHERE status = 'active'");
$stats['users'] = $stmt->fetch()['count'];
// Recent Appointments
$stmt = $db->query("SELECT * FROM appointments ORDER BY created_at DESC LIMIT 5");
$recent_appointments = $stmt->fetchAll();
// Recent Enquiries
$stmt = $db->query("SELECT * FROM enquiries ORDER BY created_at DESC LIMIT 5");
$recent_enquiries = $stmt->fetchAll();
include dirname(__DIR__) . '/includes/header.php';
?>