query("SELECT COALESCE(SUM(total_price),0) as rev FROM bookings WHERE DATE(event_date) = '$today' AND status NOT IN ('cancelled')")->fetch_assoc()['rev'];
$total_revenue = $conn->query("SELECT COALESCE(SUM(total_price),0) as rev FROM bookings WHERE status NOT IN ('cancelled')")->fetch_assoc()['rev'];
$upcoming = $conn->query("SELECT b.*, p.name as pname, c.name as cname FROM bookings b JOIN packages p ON b.package_id=p.id JOIN categories c ON b.category_id=c.id WHERE b.event_date >= '$today' AND b.status NOT IN ('cancelled','completed') ORDER BY b.event_date ASC LIMIT 5");
$recent_customers = $conn->query("SELECT * FROM customers ORDER BY created_at DESC LIMIT 5");
$monthly_revenue = $conn->query("SELECT DATE_FORMAT(event_date,'%b') as mon, COALESCE(SUM(total_price),0) as rev FROM bookings WHERE YEAR(event_date)=YEAR(CURDATE()) AND status NOT IN ('cancelled') GROUP BY MONTH(event_date) ORDER BY MONTH(event_date)");
?>
Dashboard
Pending: Today:
Upcoming Events
| Booking | Customer | Package | Date | Status |
|---|
fetch_assoc()): ?>
| | | | |
Recent Customers
| Name | Email | Joined |
|---|
fetch_assoc()): ?>
| | |
Monthly Revenue