📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/domain/payments/completed.php
<?php include '../db.php'; ?> <h2>Completed Payments</h2> <table border="1" cellpadding="5"> <tr> <th>Invoice</th><th>Client</th><th>Total</th><th>Paid</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) { echo "<tr> <td>{$r['invoice_number']}</td> <td>{$r['client_name']}</td> <td>?{$r['net_amount']}</td> <td>?{$r['paid']}</td> </tr>"; } ?> </table>
Save
Cancel