����JFIF��`�`�����query("SELECT COUNT(*) FROM bikes")->fetchColumn(); $available_bikes = $pdo->query("SELECT COUNT(*) FROM bikes WHERE status = 'available'")->fetchColumn(); $pending_inspections = $pdo->query("SELECT COUNT(*) FROM inspection_bookings WHERE status = 'pending'")->fetchColumn(); $new_sell_requests = $pdo->query("SELECT COUNT(*) FROM sell_requests WHERE status = 'pending'")->fetchColumn(); $recent_activity = []; $stmt = $pdo->query("SELECT created_at, CONCAT('New Sell Request for ', model_name) as action, name as user, status FROM sell_requests ORDER BY created_at DESC LIMIT 3"); $recent_activity = array_merge($recent_activity, $stmt->fetchAll()); $stmt = $pdo->query("SELECT created_at, CONCAT('Inspection - ', preferred_date) as action, name as user, status FROM inspection_bookings ORDER BY created_at DESC LIMIT 3"); $recent_activity = array_merge($recent_activity, $stmt->fetchAll()); usort($recent_activity, function($a, $b) { return strtotime($b['created_at']) - strtotime($a['created_at']); }); $recent_activity = array_slice($recent_activity, 0, 5); ?> ReOwn Admin Dashboard

Dashboard Overview

Welcome, Admin

Total Bikes

Available Bikes

Pending Inspections

New Sell Requests

Recent Activity

0): ?>
Date Action User Status
No recent activity.