✏ EDIT: payments.php

<?php
require_once __DIR__ . '/header.php';
// Fetch chits for filter
$conn = db_connect();
$chits = [];
$res = $conn->query("SELECT id, name FROM chit_groups ORDER BY name");
if ($res) {
    while ($row = $res->fetch_assoc()) {
        $chits[] = $row;
    }
    $res->free();
}
// Determine selected chit filter
$selectedChit = intval($_GET['chit_id'] ?? 0);
// Build query
$sql = "SELECT p.id, p.chit_id, p.member_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";
if ($selectedChit > 0) {
    $sql .= " WHERE p.chit_id = " . $selectedChit;
}
// Sort by chit and month
$sql .= " ORDER BY p.chit_id, p.month_no, p.member_id";

$payments = [];
$res2 = $conn->query($sql);
if ($res2) {
    while ($row = $res2->fetch_assoc()) {
        $payments[] = $row;
    }
    $res2->free();
}
$conn->close();
?>
<h2>Payments</h2>
<div class="row mb-3">
    <div class="col-md-4">
        <form method="get" class="d-flex align-items-end">
            <div class="me-2">
                <label class="form-label">Filter by Chit</label>
                <select name="chit_id" class="form-select" onchange="this.form.submit()">
                    <option value="0">All Chits</option>
                    <?php foreach ($chits as $c): ?>
                        <option value="<?php echo $c['id']; ?>" <?php if ($selectedChit === intval($c['id'])) echo 'selected'; ?>><?php echo e($c['name']); ?></option>
                    <?php endforeach; ?>
                </select>
            </div>
            <noscript><button type="submit" class="btn btn-primary">Filter</button></noscript>
        </form>
    </div>
</div>

<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>
                <th>Action</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($payments as $p): ?>
            <tr>
                <td><?php echo e($p['member_name']); ?></td>
                <td><?php echo e($p['chit_name']); ?></td>
                <td><?php echo e($p['month_no']); ?></td>
                <td>₹<?php echo number_format($p['amount'], 2); ?></td>
                <td>
                    <span class="badge <?php echo $p['status'] === 'paid' ? 'bg-success' : 'bg-danger'; ?>">
                        <?php echo ucfirst($p['status']); ?>
                    </span>
                </td>
                <td><?php echo $p['payment_date'] ? e($p['payment_date']) : '-'; ?></td>
                <td>
                    <?php if ($p['status'] === 'paid'): ?>
                        <button class="btn btn-sm btn-warning toggle-payment-btn" data-id="<?php echo $p['id']; ?>" data-action="pending">Mark Pending</button>
                    <?php else: ?>
                        <button class="btn btn-sm btn-success toggle-payment-btn" data-id="<?php echo $p['id']; ?>" data-action="paid">Mark Paid</button>
                    <?php endif; ?>
                </td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
</div>

[✗] CANCEL