Exporting & Printing.Custom Single Record

Appearance

View mode
Number of cards in a row Here you can select the number of cards to be placed in a row for each of supported screen resolutions. Your current resolution is highlighted in this way.
	Large desktop
	Desktop
	Tablet
	Phone

This page demonstrates how to customize export to PDF and the Print form for a single record. For this purpose you need to override the export/pdf_record.tpl and view/print_grid.tpl templates respectively (note that the sales_invoice.tpl template is shared between those templates to avoid code duplication) and point PHP Generator to use modified templates with the OnGetCustomTemplate event.

Click any of or buttons to see the generated invoice. Click the button to get familiar with the event handler code.

        protected function doGetCustomTemplate($type, $part, $mode, &$result, &$params)
        {
            if (($part == PagePart::RecordCard && $mode == PageMode::ExportPdf) ||
              ($part == PagePart::Grid && $mode == PageMode::PrintOneRecord)) {
                
              $invoiceDetails = array();
              $invoiceId = GetApplication()->GetGETValue('pk0');
              $sql =
                  'SELECT product_name, product_number, quantity, unit_price, (quantity * unit_price) AS total ' .  
                  'FROM invoice_detail ' . 
                  'INNER JOIN product ON product.id = invoice_detail.product_id ' .
                  'WHERE invoice_header_id = %d';   
              $this->GetConnection()->ExecQueryToArray(sprintf($sql, $invoiceId), $invoiceDetails);
              
              $invoiceTotal = 0;
              foreach ($invoiceDetails as $invoiceDetail) {
                  $invoiceTotal += $invoiceDetail['total']; 
              }
              
              $params['InvoiceDetails'] = $invoiceDetails;
              $params['InvoiceNumber'] = 'SI-' . sprintf('%03d', $invoiceId);
              $params['InvoiceSubtotal'] = $invoiceTotal; 
              $params['InvoiceTax'] = $invoiceTotal*0.06; 
              $params['InvoiceTotal'] = $params['InvoiceSubtotal'] + $params['InvoiceTax']; 
            
              if ($mode == PageMode::ExportPdf) {
                  $result = 'sales_invoice_pdf.tpl';
              } else {
                  $result = 'sales_invoice_print.tpl';
              }
            }
            if ($part == PagePart::PrintLayout && $mode == PageMode::PrintOneRecord) {
                $result = 'sales_invoice_print_layout.tpl';
            }
        }

{include file="custom_templates/sales_invoice.tpl" InvoiceDate=$Grid.Row.invoice_date.DisplayValue InvoiceCustomer=$Grid.Row.customer_id.DisplayValue BillToAddress=$Grid.Row.bill_to_address.DisplayValue}

<div id="sales-invoice-content">

    <table class="invoice-header" width="100%" align="center">
        <tr>
            <td>
                <table width="100%">
                    <tr>
                        <td width="50%" style="text-align: left;">
                            <img src="external_data/images/company_logo.png" style="max-height:80px;">
                        </td>
                        <td width="50%" style="text-align: right;font-size: 4em;font-weight: bold;">
                            Sales Invoice
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <table width="100%">
                    <tr>
                        <td width="70%" style="text-align: left;">
                            Company Name, Inc.<br>
                            5553 Cash Avenue<br>
                            Phoenix, AZ 85004
                        </td>
                        <td width="30%">
                            <table class="invoice-info">
                                <tr>
                                    <th style="width: 100px;text-align: right;">Date:</th>
                                    <td style="text-align: center;">{$InvoiceDate}</td>
                                </tr>
                                <tr>
                                    <th style="width: 100px;text-align: right;">Invoice #:</th>
                                    <td style="text-align: center;">{$InvoiceNumber}</td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td style="text-align: left">
                <table style="margin-top:20px">
                    <tr>
                        <td style="text-align: left">
                            <strong>Bill to:</strong>
                        </td>
                    </tr>
                    <tr>
                        <td style="text-align: left">
                            {$InvoiceCustomer}<br>
                            {$BillToAddress}
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
    <table class="invoice-detail" align="center">
        <tr>
            <th>
                #
            </th>
            <th>
                Item
            </th>
            <th>
                Description
            </th>
            <th>
                Quantity
            </th>
            <th>
                Unit Price
            </th>
            <th>
                Line Total
            </th>
        </tr>
        {foreach from=$InvoiceDetails item=detail name=foo}
            <tr>
                <td style="text-align:center;">
                    {$smarty.foreach.foo.index+1}
                </td>
                <td style="text-align:left;">
                    [{$detail.product_number}]
                </td>
                <td style="text-align:left;">
                    {$detail.product_name}
                </td>
                <td style="text-align:center;">
                    {$detail.quantity}
                </td>
                <td style="text-align:right;">
                    ${$detail.unit_price|number_format:2}
                </td>
                <td style="text-align:right;">
                    ${$detail.total|number_format:2}
                </td>
            </tr>
        {/foreach}
        <tr>
            <td colspan="6" style="border:0">
                <hr>
            </td>
        </tr>
        <tr>
            <td colspan="4" style="border:0">
            </td>
            <th style="text-align:right;">
                Subtotal:
            </th>
            <td style="text-align:right;">
                ${$InvoiceSubtotal|number_format:2}
            </td>
        </tr>
        <tr>
            <td colspan="4" style="border:0">
            </td>
            <th style="text-align:right;">
                Tax rate:
            </th>
            <td style="text-align:right;">
                6%
            </td>
        </tr>
        <tr>
            <td colspan="4" style="border:0">
            </td>
            <th style="text-align:right;">
                Tax:
            </th>
            <td style="text-align:right;">
                ${$InvoiceTax|number_format:2}
            </td>
        </tr>
        <tr>
            <td colspan="4" style="border:0">
            </td>
            <th style="text-align:right;">
                Total:
            </th>
            <td style="text-align:right;">
                ${$InvoiceTotal|number_format:2}
            </td>
        </tr>
    </table>

    <div style="text-align: center">
        <p><em>Total payment due in 30 days</em></p>
        <p><small>If you have any questions about this invoice, please contact<br>
            Martha Hamilton, Phone: (802) 555-3623, Email: m.hamilton@example.com</small></p>
        <p><strong>Thank You For Your Business!</strong></p>
    </div>

</div>

{include file="custom_templates/sales_invoice.tpl" InvoiceDate=$Rows[0][1] InvoiceCustomer=$Rows[0][2] BillToAddress=$Rows[0][3]}

		Invoice Date	Customer	Bill To Address
	Invoice Detail	2018-04-02	James Goodridge	5725 Glaze Drive, San Francisco, CA 94109
	Invoice Detail	2018-04-09	Patrick Smith	5375 Clearland Circle, Seattle, WA 98104
	Invoice Detail	2018-05-01	Linda Madson	207 Concerto Circle, Salem, OR 97301
	Invoice Detail	2018-04-24	Anne Brown	594 Tossing Way, Detroit, MI 48226
	Invoice Detail	2018-04-22	Paul Davis	2342 Peachwillow, Denver, CO 80203
	Invoice Detail	2018-05-07	Rebecca Taylor	1192 Parkway Drive, Mill Valley, NE 68601
There are no records to display

	Column	Order

Legend
New	Recently added or significantly updated pages.
Pro	Pages illustrating features available only in the Professional edition of PHP Generator.

Created with PHP Generator for MySQL. Want to learn more? Download the demo project!

Exporting & Printing.Custom Single Record

Page settings

Appearance

Multiple Sort

Filter builder

About this demo

Change your password

Change password for user ''