prepare("UPDATE bookings SET status = 'approved' WHERE id = :id AND status = 'pending'");
$stmt->execute([':id' => $bookingId]);
// Calculate commissions
calculate_commissions($bookingId);
$message = "Booking #$bookingId has been approved and commissions have been processed.";
} catch (Exception $e) {
$error = "Error approving booking: " . $e->getMessage();
}
} elseif ($action === 'reject') {
$stmt = $db->prepare("UPDATE bookings SET status = 'rejected' WHERE id = :id AND status = 'pending'");
$stmt->execute([':id' => $bookingId]);
$message = "Booking #$bookingId has been rejected.";
}
}
// 3. Fetch Bookings
$db = db();
$stmt = $db->query("SELECT b.*, u.name as user_name, u.email as user_email FROM bookings b JOIN users u ON b.user_id = u.id ORDER BY b.created_at DESC");
$bookings = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Manage Bookings