📁 File Manager
Editing:
/home/wvl7mof7402e/www/domain/payments/add.php
<?php include '../db.php'; $invoices = $conn->query(" SELECT i.id, i.invoice_number, c.name AS client_name, i.net_amount, 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 ")->fetchAll(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $stmt = $conn->prepare("INSERT INTO payments (invoice_id, amount, mode, paid_at, remarks) VALUES (?, ?, ?, ?, ?)"); $stmt->execute([ $_POST['invoice_id'], $_POST['amount'], $_POST['mode'], $_POST['paid_at'], $_POST['remarks'] ]); header("Location: index.php"); exit; } ?> <h2>Add Payment</h2> <form method="post"> <label>Invoice:</label> <select name="invoice_id" required> <?php foreach ($invoices as $i) { $balance = $i['net_amount'] - $i['paid']; echo "<option value='{$i['id']}'>#{$i['invoice_number']} ({$i['client_name']}) - ?{$balance}</option>"; } ?> </select><br> <input type="number" step="0.01" name="amount" placeholder="Amount Paid" required><br> <select name="mode" required> <option>UPI</option> <option>Cash</option> <option>Bank Transfer</option> <option>Cheque</option> <option>Other</option> </select><br> <input type="date" name="paid_at" required><br> <textarea name="remarks" placeholder="Remarks (optional)"></textarea><br> <button type="submit">Save Payment</button> </form>
Save
Cancel