exec_query('invoices', ['*'], '', '', '', '', "record_id = " . intval($_GET['record_id']));
$invoice = $invoice_res->fetch_assoc();
if (!$invoice) {
ob_end_clean();
die("Invoice not found.");
}
$invoice_number = $invoice['invoice_no'];
$date_created = $invoice['date_created'];
$date_due = $invoice['date_due'];
$description = $invoice['description'];
$total = $invoice['total'];
// Build line items
$content_array = explode(';', $invoice['invoice_content']);
$content_table = '';
foreach ($content_array as $line) {
if (strlen($line) > 2) {
$info = explode(',', $line);
$content_table .= "
| $info[0] |
$info[1] |
R " . number_format($info[2], 2, '.', ',') . " |
$info[3] |
R " . number_format($info[4], 2, '.', ',') . " |
";
}
}
// Fetch company
$company_res = $db->exec_query('company', ['*']);
$company_info = $company_res->fetch_assoc();
$company_name = $company_info['company_name'];
$company_email = $company_info['email'];
$company_address = $company_info['address'];
$company_phone = $company_info['phone'];
$bank = $company_info['bank'];
$acc = $company_info['acc'];
$branch = $company_info['branch'];
// Fetch client
$client_res = $db->exec_query('clients', ['*'], '', '', '', '', "record_id = {$invoice['clients_id']}");
$client = $client_res->fetch_assoc();
$client_name = $client['clients_name'];
$client_email = $client['email'];
$client_address = $client['address'];
$client_phone = $client['cell'];
// Build HTML (identical to invoice.pdf.php)
$htmlContent = "
$description
| DESCRIPTION |
QUANTITY |
AMOUNT |
DISCOUNT |
SUB TOTAL |
$content_table
70% DEPOSID WITH ORDERING 30% WITH COLLECTOIN MUST BE PAID IN FULL IF ORDER IS APPROVED IT WILL TAKE 4 to 6 WEEKS
FOR DELIVERY PER SCULPTURE.
NOTICE
All Orders are subject to acceptance by Pro Art Moldings .
Acceptance of orders is based on the express condition that buyer agrees to all of the terms and conditions
contained herein. Acceptance of delivery by buyer will constitute buyer's assent to these terms and conditions. These
terms and conditions represent the complete agreement of the parties, and no terms or conditions in any way
adding to, modifying, or otherwise changing the provisions stated herein shall be binding upon manufacturer unless
made in writing, and signed and approved by an officer of manufacturer. No modification of any of these terms will
be affected by manufacturer's shipment of goods following receipt of buyer's purchase order, shipping request, or
similar forms containing printed terms and conditions conflicting or inconsistent with the terms herein
PRICES AND TERMS
All Pro Art Moldings products are made to order per the specifications of its customers. All orders must be in the
form of a legally binding purchase order with item name, applicable SKUs, quantity, finish, requested delivery date,
and pricing. Pro Art Moldings welcomes custom orders and will proceed upon customer approval of samples,
drawings, pricing, delivery and payment terms.
Prices are subject to change without notice. All product prices are exclusive of other charges and freight charges. All
prices are FOB shipping point at our workshop in Kiepersol Mpumalanga , South Africa. Product pricing does not
include shipping, storage, local delivery, cartoning, crating, packing, sales tax, or uncrating. These services may be
quoted as separate line items. All prices are in South African Rand.
A minimum deposit of fifty percent (50%) of the total purchase price is required to initiate order fulfillment. All
accounts shall be paid net when invoiced. A service charge of the lesser of 2% per month or the maximum
permissible rate will be added to all accounts not paid within sixty (60) days from the date of invoice for final balance
due. Orders must be paid in full, including any applicable or prescribed shipping, handling, crating and packing,
storage (see \"STORAGE\"), taxes, and service charges prior to shipping
PRICES AND TERMS
Orders may not be cancelled after ten (10) business days after deposit is received or purchase order accepted by Pro
Art Moldings After ten (10) business days, any deposit made by Buyer in connection with an order is nonrefundable
and may be applied to a future new order within ninety (90) days. Cancellations require prior written approval and
confirmation from Pro Art Moldings
";
// Generate PDF
$mpdf = new \Mpdf\Mpdf([
'margin_top' => 5,
'margin_bottom' => 1,
'margin_left' => 1,
'margin_right' => 1,
]);
$mpdf->Addpage('P');
$stylesheet = file_get_contents('Styles/pdf.css');
$mpdf->WriteHTML($stylesheet, \Mpdf\HTMLParserMode::HEADER_CSS);
$mpdf->WriteHTML($htmlContent);
// Clear buffer and stream as download — Save As dialog
$safe_client = preg_replace('/[^A-Za-z0-9]/', '_', $client_name);
$filename = 'Invoice_' . $invoice_number . '_' . $safe_client . '.pdf';
ob_end_clean();
$mpdf->Output($filename, 'D');
exit();