✏ EDIT: reports.php

<?php
require_once __DIR__ . '/header.php';

// Fetch lists for filters
$conn = db_connect();
$members = [];
$chits = [];
$res = $conn->query("SELECT id, name FROM members ORDER BY name");
if ($res) {
    while ($row = $res->fetch_assoc()) {
        $members[] = $row;
    }
    $res->free();
}
$res = $conn->query("SELECT id, name FROM chit_groups ORDER BY name");
if ($res) {
    while ($row = $res->fetch_assoc()) {
        $chits[] = $row;
    }
    $res->free();
}

// Get filters
$memberFilter = intval($_GET['member_id'] ?? 0);
$chitFilter   = intval($_GET['chit_id'] ?? 0);
$monthFilter  = intval($_GET['month_no'] ?? 0);

// Build query
$sql = "SELECT p.id, p.month_no, p.amount, p.payment_date, p.status, m.name AS member_name, c.name AS chit_name
        FROM payments p
        JOIN members m ON p.member_id = m.id
        JOIN chit_groups c ON p.chit_id = c.id WHERE 1";
if ($memberFilter > 0) {
    $sql .= " AND p.member_id = " . $memberFilter;
}
if ($chitFilter > 0) {
    $sql .= " AND p.chit_id = " . $chitFilter;
}
if ($monthFilter > 0) {
    $sql .= " AND p.month_no = " . $monthFilter;
}
$sql .= " ORDER BY p.payment_date DESC";

$transactions = [];
$res = $conn->query($sql);
if ($res) {
    while ($row = $res->fetch_assoc()) {
        $transactions[] = $row;
    }
    $res->free();
}
$conn->close();
?>
<h2>Reports</h2>
<form method="get" class="row g-3 mb-3">
    <div class="col-md-3">
        <label class="form-label">Member</label>
        <select name="member_id" class="form-select" onchange="this.form.submit()">
            <option value="0">All</option>
            <?php foreach ($members as $m): ?>
                <option value="<?php echo $m['id']; ?>" <?php if ($memberFilter === intval($m['id'])) echo 'selected'; ?>><?php echo e($m['name']); ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="col-md-3">
        <label class="form-label">Chit</label>
        <select name="chit_id" class="form-select" onchange="this.form.submit()">
            <option value="0">All</option>
            <?php foreach ($chits as $c): ?>
                <option value="<?php echo $c['id']; ?>" <?php if ($chitFilter === intval($c['id'])) echo 'selected'; ?>><?php echo e($c['name']); ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="col-md-3">
        <label class="form-label">Month #</label>
        <select name="month_no" class="form-select" onchange="this.form.submit()">
            <option value="0">All</option>
            <?php for ($i=1; $i<=12; $i++): ?>
                <option value="<?php echo $i; ?>" <?php if ($monthFilter === $i) echo 'selected'; ?>><?php echo $i; ?></option>
            <?php endfor; ?>
        </select>
    </div>
    <noscript>
        <div class="col-md-2 d-flex align-items-end">
            <button type="submit" class="btn btn-primary">Filter</button>
        </div>
    </noscript>
</form>

<div class="table-responsive">
    <table class="table table-striped table-bordered align-middle">
        <thead class="table-dark">
            <tr>
                <th>Member</th>
                <th>Chit</th>
                <th>Month #</th>
                <th>Amount</th>
                <th>Status</th>
                <th>Payment Date</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($transactions as $t): ?>
            <tr>
                <td><?php echo e($t['member_name']); ?></td>
                <td><?php echo e($t['chit_name']); ?></td>
                <td><?php echo e($t['month_no']); ?></td>
                <td>₹<?php echo number_format($t['amount'], 2); ?></td>
                <td><span class="badge <?php echo $t['status'] === 'paid' ? 'bg-success' : 'bg-danger'; ?>"><?php echo ucfirst($t['status']); ?></span></td>
                <td><?php echo $t['payment_date'] ? e($t['payment_date']) : '-'; ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
</div>
<?php
require_once __DIR__ . '/footer.php';

[✗] CANCEL