✏ EDIT: reports_summary.php

<?php
// Generates a simple summary report for a given date range. Only
// administrators may access this endpoint.

require_once __DIR__ . '/bootstrap.php';

require_admin();

$from = isset($_GET['from']) ? $_GET['from'] : null;
$to = isset($_GET['to']) ? $_GET['to'] : null;

if (!$from || !$to) {
    respond(null, 'from and to parameters are required (YYYY-MM-DD)');
}
// Sanitize date inputs
$fromDate = date('Y-m-d', strtotime($from));
$toDate = date('Y-m-d', strtotime($to));

try {
    // Bookings count and total
    $stmt = $pdo->prepare('SELECT COUNT(*) AS cnt, COALESCE(SUM(total_amount),0) AS total FROM bookings WHERE DATE(created_at) BETWEEN ? AND ?');
    $stmt->execute([$fromDate, $toDate]);
    $bookingStats = $stmt->fetch();
    // Payments total
    $stmt = $pdo->prepare('SELECT COALESCE(SUM(amount),0) AS total FROM payments WHERE DATE(created_at) BETWEEN ? AND ? AND status = "SUCCESS"');
    $stmt->execute([$fromDate, $toDate]);
    $paymentStats = $stmt->fetch();
    // Returns issues count
    $stmt = $pdo->prepare('SELECT COUNT(*) AS issues FROM bookings WHERE DATE(created_at) BETWEEN ? AND ? AND return_status = "ISSUE"');
    $stmt->execute([$fromDate, $toDate]);
    $issuesStats = $stmt->fetch();
    $bookingsTotal = (float)$bookingStats['total'];
    $paymentsTotal = (float)$paymentStats['total'];
    $outstanding = $bookingsTotal - $paymentsTotal;
    respond([
        'bookings_count' => (int)$bookingStats['cnt'],
        'bookings_total' => $bookingsTotal,
        'payments_total' => $paymentsTotal,
        'outstanding_amount' => $outstanding < 0 ? 0.0 : $outstanding,
        'returns_issues_count' => (int)$issuesStats['issues'],
    ]);
} catch (PDOException $e) {
    respond(null, 'Database error');
}

[✗] CANCEL