query("SELECT DISTINCT payment_method FROM sales ORDER BY payment_method"); $payment_methods = $payment_methods_stmt->fetchAll(PDO::FETCH_COLUMN); // Filter logic $start_date = $_GET['start_date'] ?? ''; $end_date = $_GET['end_date'] ?? ''; $payment_method = $_GET['payment_method'] ?? ''; $sql = "SELECT * FROM sales"; $conditions = []; $params = []; if ($start_date) { $conditions[] = "sale_date >= ?"; $params[] = $start_date . ' 00:00:00'; } if ($end_date) { $conditions[] = "sale_date <= ?"; $params[] = $end_date . ' 23:59:59'; } if ($payment_method) { $conditions[] = "payment_method = ?"; $params[] = $payment_method; } if (count($conditions) > 0) { $sql .= " WHERE " . implode(' AND ', $conditions); } $sql .= " ORDER BY sale_date DESC"; $sales_stmt = $pdo->prepare($sql); $sales_stmt->execute($params); $sales = $sales_stmt->fetchAll(PDO::FETCH_ASSOC); ?>

Sales Reports

Filter Sales
Clear Export to CSV
Filtered Sales
0): ?>
ID Date Total Amount Payment Method Actions
$ Receipt
No sales found matching your criteria.