<?php
include '../db.php';
$id = $_GET['id'];
$p = $conn->prepare("
    SELECT p.*, i.invoice_number, i.net_amount, c.name AS client_name
    FROM payments p
    JOIN invoices i ON p.invoice_id = i.id
    JOIN clients c ON i.client_id = c.id
    WHERE p.id = ?
");
$p->execute([$id]);
$data = $p->fetch();
?>

<h2>Payment Receipt</h2>
<p><strong>Client:</strong> <?= $data['client_name'] ?></p>
<p><strong>Invoice #:</strong> <?= $data['invoice_number'] ?></p>
<p><strong>Paid Amount:</strong> ?<?= $data['amount'] ?></p>
<p><strong>Payment Mode:</strong> <?= $data['mode'] ?></p>
<p><strong>Payment Date:</strong> <?= $data['paid_at'] ?></p>
<p><strong>Remarks:</strong> <?= nl2br($data['remarks']) ?></p>

<button onclick="window.print()">Print</button>
