prepare("SELECT * FROM invoices WHERE booking_id = ?"); $inv_stmt->bind_param("i", $booking_id); $inv_stmt->execute(); $invoice = $inv_stmt->get_result()->fetch_assoc(); $is_print = isset($_GET['print']); ?>
= getSetting('site_description') ?>
#= $invoice ? $invoice['invoice_no'] : $booking['booking_id'] ?>
= htmlspecialchars($customer['name']) ?>
= htmlspecialchars($customer['email']) ?>
= htmlspecialchars($customer['phone']) ?>
= htmlspecialchars($customer['address']) ?>
Invoice Date: = date('d M Y', strtotime($invoice['invoice_date'] ?? $booking['created_at'])) ?>
Booking ID: = $booking['booking_id'] ?>
Event Date: = date('d M Y', strtotime($booking['event_date'])) ?>
Status: = ucfirst($booking['payment_status']) ?>
| # | Description | Category | Date | Amount (= getSetting('currency')?:'LKR' ?>) |
|---|---|---|---|---|
| = $row_idx++ ?> | = htmlspecialchars($booking['package_name']) ?> Package = htmlspecialchars($booking['package_description'] ?? '') ?> |
= htmlspecialchars($booking['category_name']) ?> | = date('d M Y', strtotime($booking['event_date'])) ?> | = number_format($pkg_price, 2) ?> |
| = $row_idx++ ?> | Transport Cost Driving distance: = number_format($distance, 2) ?> km from our office |
Transport | = date('d M Y', strtotime($booking['event_date'])) ?> | = number_format($trans_cost, 2) ?> |
| = $row_idx++ ?> | Payment - = ucfirst($p['payment_type']) ?> = $p['payment_method'] ?: 'Online' ?> | = $p['transaction_id'] ?: '-' ?> |
- | = date('d M Y', strtotime($p['created_at'])) ?> | - = number_format($p['amount'], 2) ?> |
Bank: = getSetting('bank_name') ?>
Account Name: = getSetting('bank_account_name') ?>
Account No: = getSetting('bank_account_no') ?>
Branch: = getSetting('bank_branch') ?>
| Subtotal | = number_format($booking['total_price'], 2) ?> |
| Advance Paid | - = number_format($booking['advance_amount'], 2) ?> |
| Balance Due | = number_format($booking['balance_amount'], 2) ?> |