<?php include '../db.php'; ?>
<h2>Pending Payments</h2>

<table border="1" cellpadding="5">
<tr>
    <th>Invoice</th><th>Client</th><th>Total</th><th>Paid</th><th>Pending</th>
</tr>
<?php
$rows = $conn->query("
    SELECT i.*, c.name AS client_name,
    COALESCE((SELECT SUM(amount) FROM payments WHERE invoice_id=i.id), 0) AS paid
    FROM invoices i
    JOIN clients c ON i.client_id = c.id
    HAVING paid < net_amount
")->fetchAll();

foreach ($rows as $r) {
    $pending = $r['net_amount'] - $r['paid'];
    echo "<tr>
        <td>{$r['invoice_number']}</td>
        <td>{$r['client_name']}</td>
        <td>?{$r['net_amount']}</td>
        <td>?{$r['paid']}</td>
        <td><strong>?{$pending}</strong></td>
    </tr>";
}
?>
</table>
