📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/domain/billing/invoice_pdf.php
<?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(); ?>
Save
Cancel