Invoice - ${inv.invoice_no}

import { db } from '../../database/db'; export class InvoicePdfService { /** * Generates printable enterprise HTML invoice with QR codes and VAT breakdown */ public static generatePrintableInvoiceHtml(invoiceNo: string): string { const inv = db.invoices.find(i => i.invoice_no === invoiceNo); if (!inv) throw new Error('Invoice not found'); const sub = db.subscribers.find(s => s.id === inv.subscriber_id); const pkg = db.packages.find(p => p.id === inv.package_id); const reseller = inv.reseller_id ? db.resellers.find(r => r.id === inv.reseller_id) : undefined; const tenant = db.tenants[0]; const companyName = reseller ? reseller.company_name : tenant.name; const companyPhone = reseller ? reseller.phone : '09612-888999'; const vatNo = tenant.vat_registration_no || 'VAT-99882211'; const footer = reseller ? reseller.invoice_footer : tenant.invoice_footer; const baseAmount = inv.amount; const vatAmount = inv.vat_amount || Number((baseAmount * 0.05).toFixed(2)); const totalAmount = inv.net_amount || (baseAmount + vatAmount); return ` Invoice - ${inv.invoice_no}

BILLED TO SUBSCRIBER

${sub?.full_name || 'Subscriber'}

Username: ${sub?.username}

Phone: ${sub?.phone}

Address: ${sub?.address || 'Dhaka, Bangladesh'}

INVOICE DETAILS

Invoice No: ${inv.invoice_no}

Billing Date: ${new Date(inv.created_at).toLocaleDateString('en-GB')}

Due / Renewal Date: ${new Date(inv.due_date).toLocaleDateString('en-GB')}

Payment Method: ${inv.payment_method || 'bKash Pay Bill'}

Description	Bandwidth Tier	Validity	Amount (BDT)
${pkg?.name \|\| 'Broadband Package'} Unlimited BDIX & YouTube Peering, Low Latency Fiber	${pkg?.speed_mbps \|\| 20} Mbps Full Duplex	30 Days	৳ ${baseAmount.toFixed(2)}

Package Subtotal: ৳ ${baseAmount.toFixed(2)}

Govt. 5% VAT (BTRC): ৳ ${vatAmount.toFixed(2)}

Total Payable: ৳ ${totalAmount.toFixed(2)}

`.trim(); } }