<?php
require('../fpdf/fpdf.php');
include '../db.php';

$id = $_GET['id'];
$stmt = $conn->prepare("SELECT i.*, c.name FROM invoices i JOIN clients c ON i.client_id=c.id WHERE i.id=?");
$stmt->execute([$id]);
$invoice = $stmt->fetch();

$items = $conn->prepare("SELECT * FROM invoice_items WHERE invoice_id=?");
$items->execute([$id]);
$items = $items->fetchAll();

$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);

$pdf->Cell(0,10,"Invoice: " . $invoice['invoice_number'],0,1);
$pdf->SetFont('Arial','',12);
$pdf->Cell(0,10,"Client: " . $invoice['name'],0,1);
$pdf->Cell(0,10,"Date: " . $invoice['created_at'],0,1);
$pdf->Ln();

$pdf->SetFont('Arial','B',12);
$pdf->Cell(60,10,"Service Type",1);
$pdf->Cell(80,10,"Description",1);
$pdf->Cell(40,10,"Amount (?)",1,1,'R');

$pdf->SetFont('Arial','',12);
foreach ($items as $item) {
    $pdf->Cell(60,10,$item['service_type'],1);
    $pdf->Cell(80,10,$item['description'],1);
    $pdf->Cell(40,10,number_format($item['amount'],2),1,1,'R');
}

$pdf->Cell(140,10,"Subtotal",1);
$pdf->Cell(40,10,number_format($invoice['total_amount'],2),1,1,'R');

$pdf->Cell(140,10,"GST (" . number_format($invoice['gst_percentage'],2) . "%)",1);
$pdf->Cell(40,10,number_format($invoice['gst_amount'],2),1,1,'R');

$pdf->Cell(140,10,"Total",1);
$pdf->Cell(40,10,number_format($invoice['net_amount'],2),1,1,'R');

$pdf->Output();
?>
