query("SELECT COUNT(*) FROM vehicles")->fetchColumn(); $activeVehicles = $pdo->query("SELECT COUNT(*) FROM vehicles WHERE is_active = 1")->fetchColumn(); $sedans = $pdo->query("SELECT COUNT(*) FROM vehicles WHERE category = 'Executive Sedan'")->fetchColumn(); $suvs = $pdo->query("SELECT COUNT(*) FROM vehicles WHERE category = 'Luxury SUV'")->fetchColumn(); // ---- Optional: fetch additional stats (bookings, revenue, etc.) ---- // If you have a bookings table, you can query more metrics here. // For demonstration, we keep placeholders. $totalBookings = 0; // replace with actual query $totalRevenue = 0; // replace with actual query $pendingBookings = 0; // replace with actual query ?> Kafunda City Rides – Admin Dashboard

Dashboard

Overview of your vehicle fleet and key metrics.

Total Vehicles

All vehicles in fleet

Active Vehicles

Available for booking

Sedans

Executive Sedan category

SUVs

Luxury SUV category

Add New Vehicle Manage Vehicles

Top Booked Vehicles

  • Vehicle

    Toyota Land Cruiser

    Plate: UBA 123A • 12 Bookings
    Top
  • Vehicle

    Mercedes-Benz E-Class

    Plate: UBA 456B • 9 Bookings
    2nd
  • Vehicle

    Range Rover Sport

    Plate: UBA 789C • 7 Bookings
    3rd

Maintenance Due

View All
  • Vehicle

    Toyota Hiace

    Plate: UBA 012D
    Oil Change Due in 2 days
  • Vehicle

    Nissan Patrol

    Plate: UBA 345E
    Brake Service Overdue

Recent Bookings

  • Customer

    John Doe

    Mercedes S-Class • $250
    Completed
  • Customer

    Jane Smith

    Range Rover • $300
    Processing
  • Customer

    Robert Brown

    Toyota Land Cruiser • $180
    Pending