2010-06-18 04:07:55 +00:00
< ? php
/*********************************************************************************
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*
********************************************************************************/
/**
* Function to generate Invoice pdf
*/
function get_invoice_pdf ()
{
require_once ( 'include/tcpdf/pdf.php' );
require_once ( 'include/tcpdf/pdfconfig.php' );
require_once ( 'include/database/PearDatabase.php' );
require_once ( 'modules/Invoice/Invoice.php' );
global $adb , $app_strings , $focus , $current_user ;
// would you like and end page? 1 for yes 0 for no
$endpage = " 1 " ;
$id = $_REQUEST [ 'record' ];
//retreiving the vtiger_invoice info
$focus = new Invoice ();
$focus -> retrieve_entity_info ( $_REQUEST [ 'record' ], " Invoice " );
$focus -> apply_field_security ();
$account_name = getAccountName ( $focus -> column_fields [ account_id ]);
$invoice_no = $focus -> column_fields [ invoice_no ];
$sql = " select currency_symbol from vtiger_currency_info where id=? " ;
$result = $adb -> pquery ( $sql , array ( $focus -> column_fields [ 'currency_id' ]));
$currency_symbol = $adb -> query_result ( $result , 0 , 'currency_symbol' );
// **************** BEGIN POPULATE DATA ********************
// populate data
if ( $focus -> column_fields [ " salesorder_id " ] != '' )
$so_name = getSoName ( $focus -> column_fields [ " salesorder_id " ]);
else
$so_name = '' ;
$po_name = $focus -> column_fields [ " vtiger_purchaseorder " ];
$valid_till = $focus -> column_fields [ " duedate " ];
$valid_till = getDisplayDate ( $valid_till );
$bill_street = $focus -> column_fields [ " bill_street " ];
$bill_city = $focus -> column_fields [ " bill_city " ];
$bill_state = $focus -> column_fields [ " bill_state " ];
$bill_code = $focus -> column_fields [ " bill_code " ];
$bill_country = $focus -> column_fields [ " bill_country " ];
$contact_name = getContactName ( $focus -> column_fields [ " contact_id " ]);
$ship_street = $focus -> column_fields [ " ship_street " ];
$ship_city = $focus -> column_fields [ " ship_city " ];
$ship_state = $focus -> column_fields [ " ship_state " ];
$ship_code = $focus -> column_fields [ " ship_code " ];
$ship_country = $focus -> column_fields [ " ship_country " ];
$conditions = from_html ( $focus -> column_fields [ " terms_conditions " ]);
$description = from_html ( $focus -> column_fields [ " description " ]);
$status = $focus -> column_fields [ " invoicestatus " ];
// Company information
$add_query = " select * from vtiger_organizationdetails " ;
$result = $adb -> pquery ( $add_query , array ());
$num_rows = $adb -> num_rows ( $result );
if ( $num_rows > 0 )
{
$org_name = $adb -> query_result ( $result , 0 , " organizationname " );
$org_address = $adb -> query_result ( $result , 0 , " address " );
$org_city = $adb -> query_result ( $result , 0 , " city " );
$org_state = $adb -> query_result ( $result , 0 , " state " );
$org_country = $adb -> query_result ( $result , 0 , " country " );
$org_code = $adb -> query_result ( $result , 0 , " code " );
$org_phone = $adb -> query_result ( $result , 0 , " phone " );
$org_fax = $adb -> query_result ( $result , 0 , " fax " );
$org_website = $adb -> query_result ( $result , 0 , " website " );
$logo_name = $adb -> query_result ( $result , 0 , " logoname " );
}
//NOTE : Removed currency symbols and added with Grand Total text. it is enough to show the currency symbol in one place
//we can also get the NetTotal, Final Discount Amount/Percent, Adjustment and GrandTotal from the array $associated_products[1]['final_details']
//get the Associated Products for this Invoice
$focus -> id = $focus -> column_fields [ " record_id " ];
$associated_products = getAssociatedProducts ( " Invoice " , $focus );
$num_products = count ( $associated_products );
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes and adjustment
$final_details = $associated_products [ 1 ][ 'final_details' ];
//getting the Net Total
$price_subtotal = number_format ( $final_details [ " hdnSubTotal " ], 2 , '.' , ',' );
//Final discount amount/percentage
$discount_amount = $final_details [ " discount_amount_final " ];
$discount_percent = $final_details [ " discount_percentage_final " ];
if ( $discount_amount != " " )
$price_discount = number_format ( $discount_amount , 2 , '.' , ',' );
else if ( $discount_percent != " " )
{
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = " ( " . number_format ( $discount_percent , 2 , '.' , ',' ) . " %) " ;
$price_discount = number_format ((( $discount_percent * $final_details [ " hdnSubTotal " ]) / 100 ), 2 , '.' , ',' );
}
else
$price_discount = " 0.00 " ;
//Adjustment
$price_adjustment = number_format ( $final_details [ " adjustment " ], 2 , '.' , ',' );
//Grand Total
$price_total = number_format ( $final_details [ " grandTotal " ], 2 , '.' , ',' );
//To calculate the group tax amount
if ( $final_details [ 'taxtype' ] == 'group' )
{
$group_tax_total = $final_details [ 'tax_totalamount' ];
$price_salestax = number_format ( $group_tax_total , 2 , '.' , ',' );
$group_total_tax_percent = '0.00' ;
$group_tax_details = $final_details [ 'taxes' ];
for ( $i = 0 ; $i < count ( $group_tax_details ); $i ++ )
{
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details [ $i ][ 'percentage' ];
}
}
//S&H amount
$sh_amount = $final_details [ 'shipping_handling_charge' ];
$price_shipping = number_format ( $sh_amount , 2 , '.' , ',' );
//S&H taxes
$sh_tax_details = $final_details [ 'sh_taxes' ];
$sh_tax_percent = '0.00' ;
for ( $i = 0 ; $i < count ( $sh_tax_details ); $i ++ )
{
$sh_tax_percent = $sh_tax_percent + $sh_tax_details [ $i ][ 'percentage' ];
}
$sh_tax_amount = $final_details [ 'shtax_totalamount' ];
$price_shipping_tax = number_format ( $sh_tax_amount , 2 , '.' , ',' );
$prod_line = array ();
$lines = 0 ;
//This is to get all prodcut details as row basis
for ( $i = 1 , $j = $i - 1 ; $i <= $num_products ; $i ++ , $j ++ )
{
$product_name [ $i ] = $associated_products [ $i ][ 'productName' . $i ];
$subproduct_name [ $i ] = split ( " <br> " , $associated_products [ $i ][ 'subprod_names' . $i ]);
//$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
$comment [ $i ] = $associated_products [ $i ][ 'comment' . $i ];
$product_id [ $i ] = $associated_products [ $i ][ 'hdnProductId' . $i ];
$qty [ $i ] = $associated_products [ $i ][ 'qty' . $i ];
$unit_price [ $i ] = number_format ( $associated_products [ $i ][ 'unitPrice' . $i ], 2 , '.' , ',' );
$list_price [ $i ] = number_format ( $associated_products [ $i ][ 'listPrice' . $i ], 2 , '.' , ',' );
$list_pricet [ $i ] = $associated_products [ $i ][ 'listPrice' . $i ];
$discount_total [ $i ] = $associated_products [ $i ][ 'discountTotal' . $i ];
//aded for 5.0.3 pdf changes
$product_code [ $i ] = $associated_products [ $i ][ 'hdnProductcode' . $i ];
$taxable_total = $qty [ $i ] * $list_pricet [ $i ] - $discount_total [ $i ];
$producttotal = $taxable_total ;
$total_taxes = '0.00' ;
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " )
{
$total_tax_percent = '0.00' ;
//This loop is to get all tax percentage and then calculate the total of all taxes
for ( $tax_count = 0 ; $tax_count < count ( $associated_products [ $i ][ 'taxes' ]); $tax_count ++ )
{
$tax_percent = $associated_products [ $i ][ 'taxes' ][ $tax_count ][ 'percentage' ];
$total_tax_percent = $total_tax_percent + $tax_percent ;
$tax_amount = (( $taxable_total * $tax_percent ) / 100 );
$total_taxes = $total_taxes + $tax_amount ;
}
$producttotal = $taxable_total + $total_taxes ;
$product_line [ $j ][ " Tax " ] = number_format ( $total_taxes , 2 , '.' , ',' ) . " \n ( $total_tax_percent %) " ;
$price_salestax += $total_taxes ;
}
$prod_total [ $i ] = number_format ( $producttotal , 2 , '.' , ',' );
$product_line [ $j ][ " Product Code " ] = $product_code [ $i ];
$product_line [ $j ][ " Qty " ] = $qty [ $i ];
$product_line [ $j ][ " Price " ] = $list_price [ $i ];
$product_line [ $j ][ " Discount " ] = $discount_total [ $i ];
$product_line [ $j ][ " Total " ] = $prod_total [ $i ];
$lines ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$prod_line [ $j ] = 1 ;
for ( $count = 0 ; $count < count ( $subproduct_name [ $i ]); $count ++ ){
if ( $lines % 12 != 0 ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] ++ ;
}
else {
$j ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] = 2 ;
$lines ++ ;
}
$lines ++ ;
}
if ( $comment [ $i ] != '' ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $comment [ $i ]);
$prod_line [ $j ] ++ ;
$lines ++ ;
}
}
$price_salestax = number_format ( $price_salestax , 2 , '.' , ',' );
// ************************ END POPULATE DATA ***************************8
//print_r($lines);die;
$page_num = '1' ;
$pdf = new PDF ( 'P' , 'mm' , 'A4' );
$pdf -> Open ();
//STARTS - Placement of products in pages as per the lines count
$lines_per_page = " 12 " ;
$prod_cnt = 0 ;
$num_pages = ceil (( $lines / $lines_per_page ));
$tmp = 0 ;
for ( $count = 0 ; $count < $num_pages ; $count ++ ){
for ( $k = $tmp ; $k < $j ; $k ++ ){
if ( $prod_cnt != 12 ){
$products [ $count ][] = $k ;
$prod_cnt += $prod_line [ $k ];
} else {
$tmp = $k ;
$prod_cnt = 0 ;
break ;
}
}
}
//ENDS - Placement of products in pages as per the lines count
for ( $l = 0 ; $l < $num_pages ; $l ++ )
{
$line = array ();
if ( $num_pages == $page_num )
$lastpage = 1 ;
/*while($current_product != $page_num*$products_per_page)
{
$line[]=$product_line[$current_product];
$current_product++;
}/*/
foreach ( $products [ $l ] as $index => $key ){
$line [] = $product_line [ $key ];
}
$pdf -> AddPage ();
include ( " modules/Invoice/pdf_templates/header.php " );
include ( " include/tcpdf/templates/body.php " );
//if bottom > 145 then we skip the Description and T&C in every page and display only in lastpage
//if you want to display the description and T&C in each page then set the display_desc_tc='true' and bottom <= 145 in pdfconfig.php
if ( $display_desc_tc == 'true' )
if ( $bottom <= 145 )
{
include ( " modules/Invoice/pdf_templates/footer.php " );
}
$page_num ++ ;
if (( $endpage ) && ( $lastpage ))
{
$pdf -> AddPage ();
include ( " modules/Invoice/pdf_templates/header.php " );
include ( " modules/Invoice/pdf_templates/lastpage/body.php " );
include ( " modules/Invoice/pdf_templates/lastpage/footer.php " );
}
}
return $pdf ;
}
/**
* Function to generate PurchaseOrder pdf
*/
function get_po_pdf () {
require_once ( 'include/tcpdf/pdf.php' );
require_once ( 'include/tcpdf/pdfconfig.php' );
require_once ( 'include/database/PearDatabase.php' );
require_once ( 'modules/PurchaseOrder/PurchaseOrder.php' );
global $adb , $app_strings , $current_user ;
// would you like and end page? 1 for yes 0 for no
$endpage = " 1 " ;
$id = $_REQUEST [ 'record' ];
//retreiving the vtiger_invoice info
$focus = new PurchaseOrder ();
$focus -> retrieve_entity_info ( $_REQUEST [ 'record' ], " PurchaseOrder " );
$focus -> apply_field_security ();
$vendor_name = getVendorName ( $focus -> column_fields [ vendor_id ]);
$po_no = $focus -> column_fields [ purchaseorder_no ];
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " ) {
$product_taxes = 'true' ;
} else {
$product_taxes = 'false' ;
}
$sql = " select currency_symbol from vtiger_currency_info where id=? " ;
$result = $adb -> pquery ( $sql , array ( $focus -> column_fields [ 'currency_id' ]));
$currency_symbol = $adb -> query_result ( $result , 0 , 'currency_symbol' );
// **************** BEGIN POPULATE DATA ********************
$reqno = $focus -> column_fields [ " requisition_no " ];
$trno = $focus -> column_fields [ " tracking_no " ];
$valid_till = $focus -> column_fields [ " duedate " ];
$valid_till = getDisplayDate ( $valid_till );
$bill_street = $focus -> column_fields [ " bill_street " ];
$bill_city = $focus -> column_fields [ " bill_city " ];
$bill_state = $focus -> column_fields [ " bill_state " ];
$bill_code = $focus -> column_fields [ " bill_code " ];
$bill_country = $focus -> column_fields [ " bill_country " ];
$contact_name = getContactName ( $focus -> column_fields [ " contact_id " ]);
$ship_street = $focus -> column_fields [ " ship_street " ];
$ship_city = $focus -> column_fields [ " ship_city " ];
$ship_state = $focus -> column_fields [ " ship_state " ];
$ship_code = $focus -> column_fields [ " ship_code " ];
$ship_country = $focus -> column_fields [ " ship_country " ];
$conditions = from_html ( $focus -> column_fields [ " terms_conditions " ]);
$description = from_html ( $focus -> column_fields [ " description " ]);
$status = $focus -> column_fields [ " postatus " ];
// Company information
$add_query = " select * from vtiger_organizationdetails " ;
$result = $adb -> query ( $add_query );
$num_rows = $adb -> num_rows ( $result );
if ( $num_rows > 0 )
{
$org_name = $adb -> query_result ( $result , 0 , " organizationname " );
$org_address = $adb -> query_result ( $result , 0 , " address " );
$org_city = $adb -> query_result ( $result , 0 , " city " );
$org_state = $adb -> query_result ( $result , 0 , " state " );
$org_country = $adb -> query_result ( $result , 0 , " country " );
$org_code = $adb -> query_result ( $result , 0 , " code " );
$org_phone = $adb -> query_result ( $result , 0 , " phone " );
$org_fax = $adb -> query_result ( $result , 0 , " fax " );
$org_website = $adb -> query_result ( $result , 0 , " website " );
$logo_name = $adb -> query_result ( $result , 0 , " logoname " );
}
//Population of Product Details - Starts
//we can cut and paste the following lines in a file and include that file here is enough. For that we have to put a new common file. we will do this later
//NOTE : Removed currency symbols and added with Grand Total text. it is enough to show the currency symbol in one place
//we can also get the NetTotal, Final Discount Amount/Percent, Adjustment and GrandTotal from the array $associated_products[1]['final_details']
//get the Associated Products for this Invoice
$focus -> id = $focus -> column_fields [ " record_id " ];
$associated_products = getAssociatedProducts ( " PurchaseOrder " , $focus );
$num_products = count ( $associated_products );
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes and adjustment
$final_details = $associated_products [ 1 ][ 'final_details' ];
//getting the Net Total
$price_subtotal = number_format ( $final_details [ " hdnSubTotal " ], 2 , '.' , ',' );
//Final discount amount/percentage
$discount_amount = $final_details [ " discount_amount_final " ];
$discount_percent = $final_details [ " discount_percentage_final " ];
if ( $discount_amount != " " )
$price_discount = number_format ( $discount_amount , 2 , '.' , ',' );
else if ( $discount_percent != " " )
{
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = " ( " . number_format ( $discount_percent , 2 , '.' , ',' ) . " %) " ;
$price_discount = number_format ((( $discount_percent * $final_details [ " hdnSubTotal " ]) / 100 ), 2 , '.' , ',' );
}
else
$price_discount = " 0.00 " ;
//Adjustment
$price_adjustment = number_format ( $final_details [ " adjustment " ], 2 , '.' , ',' );
//Grand Total
$price_total = number_format ( $final_details [ " grandTotal " ], 2 , '.' , ',' );
//To calculate the group tax amount
if ( $final_details [ 'taxtype' ] == 'group' )
{
$group_tax_total = $final_details [ 'tax_totalamount' ];
$price_salestax = number_format ( $group_tax_total , 2 , '.' , ',' );
$group_total_tax_percent = '0.00' ;
$group_tax_details = $final_details [ 'taxes' ];
for ( $i = 0 ; $i < count ( $group_tax_details ); $i ++ )
{
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details [ $i ][ 'percentage' ];
}
}
//S&H amount
$sh_amount = $final_details [ 'shipping_handling_charge' ];
$price_shipping = number_format ( $sh_amount , 2 , '.' , ',' );
//S&H taxes
$sh_tax_details = $final_details [ 'sh_taxes' ];
$sh_tax_percent = '0.00' ;
for ( $i = 0 ; $i < count ( $sh_tax_details ); $i ++ )
{
$sh_tax_percent = $sh_tax_percent + $sh_tax_details [ $i ][ 'percentage' ];
}
$sh_tax_amount = $final_details [ 'shtax_totalamount' ];
$price_shipping_tax = number_format ( $sh_tax_amount , 2 , '.' , ',' );
$prod_line = array ();
$lines = 0 ;
//This is to get all prodcut details as row basis
for ( $i = 1 , $j = $i - 1 ; $i <= $num_products ; $i ++ , $j ++ )
{
$product_name [ $i ] = $associated_products [ $i ][ 'productName' . $i ];
$subproduct_name [ $i ] = split ( " <br> " , $associated_products [ $i ][ 'subprod_names' . $i ]);
//$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
$comment [ $i ] = $associated_products [ $i ][ 'comment' . $i ];
$product_id [ $i ] = $associated_products [ $i ][ 'hdnProductId' . $i ];
$qty [ $i ] = $associated_products [ $i ][ 'qty' . $i ];
$unit_price [ $i ] = number_format ( $associated_products [ $i ][ 'unitPrice' . $i ], 2 , '.' , ',' );
$list_price [ $i ] = number_format ( $associated_products [ $i ][ 'listPrice' . $i ], 2 , '.' , ',' );
$list_pricet [ $i ] = $associated_products [ $i ][ 'listPrice' . $i ];
$discount_total [ $i ] = $associated_products [ $i ][ 'discountTotal' . $i ];
//aded for 5.0.3 pdf changes
$product_code [ $i ] = $associated_products [ $i ][ 'hdnProductcode' . $i ];
$taxable_total = $qty [ $i ] * $list_pricet [ $i ] - $discount_total [ $i ];
$producttotal = $taxable_total ;
$total_taxes = '0.00' ;
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " )
{
$total_tax_percent = '0.00' ;
//This loop is to get all tax percentage and then calculate the total of all taxes
for ( $tax_count = 0 ; $tax_count < count ( $associated_products [ $i ][ 'taxes' ]); $tax_count ++ )
{
$tax_percent = $associated_products [ $i ][ 'taxes' ][ $tax_count ][ 'percentage' ];
$total_tax_percent = $total_tax_percent + $tax_percent ;
$tax_amount = (( $taxable_total * $tax_percent ) / 100 );
$total_taxes = $total_taxes + $tax_amount ;
}
$producttotal = $taxable_total + $total_taxes ;
$product_line [ $j ][ " Tax " ] = number_format ( $total_taxes , 2 , '.' , ',' ) . " \n ( $total_tax_percent %) " ;
$price_salestax += $total_taxes ;
}
$prod_total [ $i ] = number_format ( $producttotal , 2 , '.' , ',' );
$product_line [ $j ][ " Product Code " ] = $product_code [ $i ];
$product_line [ $j ][ " Qty " ] = $qty [ $i ];
$product_line [ $j ][ " Price " ] = $list_price [ $i ];
$product_line [ $j ][ " Discount " ] = $discount_total [ $i ];
$product_line [ $j ][ " Total " ] = $prod_total [ $i ];
$lines ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$prod_line [ $j ] = 1 ;
for ( $count = 0 ; $count < count ( $subproduct_name [ $i ]); $count ++ ){
if ( $lines % 12 != 0 ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] ++ ;
}
else {
$j ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] = 2 ;
$lines ++ ;
}
$lines ++ ;
}
if ( $comment [ $i ] != '' ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $comment [ $i ]);
$prod_line [ $j ] ++ ;
$lines ++ ;
}
}
$price_salestax = number_format ( $price_salestax , 2 , '.' , ',' );
//echo '<pre>Product Details ==>';print_r($product_line);echo '</pre>';
//echo '<pre>';print_r($associated_products);echo '</pre>';
//Population of Product Details - Ends
// ************************ END POPULATE DATA ***************************8
$page_num = '1' ;
$pdf = new PDF ( 'P' , 'mm' , 'A4' );
$pdf -> Open ();
// $num_pages=ceil(($num_products/$products_per_page));
//STARTS - Placement of products in pages as per the lines count
$lines_per_page = " 12 " ;
$prod_cnt = 0 ;
$num_pages = ceil (( $lines / $lines_per_page ));
$tmp = 0 ;
for ( $count = 0 ; $count < $num_pages ; $count ++ ){
for ( $k = $tmp ; $k < $j ; $k ++ ){
if ( $prod_cnt != 12 ){
$products [ $count ][] = $k ;
$prod_cnt += $prod_line [ $k ];
} else {
$tmp = $k ;
$prod_cnt = 0 ;
break ;
}
}
}
//ENDS - Placement of products in pages as per the lines count
$current_product = 0 ;
for ( $l = 0 ; $l < $num_pages ; $l ++ )
{
$line = array ();
if ( $num_pages == $page_num )
$lastpage = 1 ;
/*while($current_product != $page_num*$products_per_page)
{
$line[]=$product_line[$current_product];
$current_product++;
}/*/
foreach ( $products [ $l ] as $index => $key ){
$line [] = $product_line [ $key ];
}
$pdf -> AddPage ();
include ( " modules/PurchaseOrder/pdf_templates/header.php " );
include ( " include/tcpdf/templates/body.php " );
//if bottom > 145 then we skip the Description and T&C in every page and display only in lastpage
//if you want to display the description and T&C in each page then set the display_desc_tc='true' and bottom <= 145 in pdfconfig.php
if ( $display_desc_tc == 'true' )
if ( $bottom <= 145 )
{
include ( " modules/PurchaseOrder/pdf_templates/footer.php " );
}
$page_num ++ ;
if (( $endpage ) && ( $lastpage ))
{
$pdf -> AddPage ();
include ( " modules/PurchaseOrder/pdf_templates/header.php " );
include ( " modules/PurchaseOrder/pdf_templates/lastpage/body.php " );
include ( " modules/PurchaseOrder/pdf_templates/lastpage/footer.php " );
}
}
return $pdf ;
}
/**
* Function to generate SalesOrder pdf
*/
function get_so_pdf () {
require_once ( 'include/tcpdf/pdf.php' );
require_once ( 'include/tcpdf/pdfconfig.php' );
require_once ( 'include/database/PearDatabase.php' );
require_once ( 'modules/SalesOrder/SalesOrder.php' );
global $adb , $app_strings , $current_user ;
// would you like and end page? 1 for yes 0 for no
$endpage = " 1 " ;
$id = $_REQUEST [ 'record' ];
//retreiving the vtiger_invoice info
$focus = new SalesOrder ();
$focus -> retrieve_entity_info ( $_REQUEST [ 'record' ], " SalesOrder " );
$focus -> apply_field_security ();
$account_name = getAccountName ( $focus -> column_fields [ account_id ]);
$so_no = $focus -> column_fields [ salesorder_no ];
$sql = " select currency_symbol from vtiger_currency_info where id=? " ;
$result = $adb -> pquery ( $sql , array ( $focus -> column_fields [ 'currency_id' ]));
$currency_symbol = $adb -> query_result ( $result , 0 , 'currency_symbol' );
// **************** BEGIN POPULATE DATA ********************
// populate data
if ( $focus -> column_fields [ " quote_id " ] != '' )
$quote_name = getQuoteName ( $focus -> column_fields [ " quote_id " ]);
else
$quote_name = '' ;
$po_name = $focus -> column_fields [ " purchaseorder " ];
$subject = $focus -> column_fields [ " subject " ];
$valid_till = $focus -> column_fields [ " duedate " ];
$valid_till = getDisplayDate ( $valid_till );
$bill_street = $focus -> column_fields [ " bill_street " ];
$bill_city = $focus -> column_fields [ " bill_city " ];
$bill_state = $focus -> column_fields [ " bill_state " ];
$bill_code = $focus -> column_fields [ " bill_code " ];
$bill_country = $focus -> column_fields [ " bill_country " ];
$contact_name = getContactName ( $focus -> column_fields [ " contact_id " ]);
$ship_street = $focus -> column_fields [ " ship_street " ];
$ship_city = $focus -> column_fields [ " ship_city " ];
$ship_state = $focus -> column_fields [ " ship_state " ];
$ship_code = $focus -> column_fields [ " ship_code " ];
$ship_country = $focus -> column_fields [ " ship_country " ];
$conditions = from_html ( $focus -> column_fields [ " terms_conditions " ]);
$description = from_html ( $focus -> column_fields [ " description " ]);
$status = $focus -> column_fields [ " sostatus " ];
// Company information
$add_query = " select * from vtiger_organizationdetails " ;
$result = $adb -> pquery ( $add_query , array ());
$num_rows = $adb -> num_rows ( $result );
if ( $num_rows > 0 )
{
$org_name = $adb -> query_result ( $result , 0 , " organizationname " );
$org_address = $adb -> query_result ( $result , 0 , " address " );
$org_city = $adb -> query_result ( $result , 0 , " city " );
$org_state = $adb -> query_result ( $result , 0 , " state " );
$org_country = $adb -> query_result ( $result , 0 , " country " );
$org_code = $adb -> query_result ( $result , 0 , " code " );
$org_phone = $adb -> query_result ( $result , 0 , " phone " );
$org_fax = $adb -> query_result ( $result , 0 , " fax " );
$org_website = $adb -> query_result ( $result , 0 , " website " );
$logo_name = $adb -> query_result ( $result , 0 , " logoname " );
}
//Population of Product Details - Starts
//we can cut and paste the following lines in a file and include that file here is enough. For that we have to put a new common file. we will do this later
//NOTE : Removed currency symbols and added with Grand Total text. it is enough to show the currency symbol in one place
//we can also get the NetTotal, Final Discount Amount/Percent, Adjustment and GrandTotal from the array $associated_products[1]['final_details']
//get the Associated Products for this Invoice
$focus -> id = $focus -> column_fields [ " record_id " ];
$associated_products = getAssociatedProducts ( " SalesOrder " , $focus );
$num_products = count ( $associated_products );
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes and adjustment
$final_details = $associated_products [ 1 ][ 'final_details' ];
//getting the Net Total
$price_subtotal = number_format ( $final_details [ " hdnSubTotal " ], 2 , '.' , ',' );
//Final discount amount/percentage
$discount_amount = $final_details [ " discount_amount_final " ];
$discount_percent = $final_details [ " discount_percentage_final " ];
if ( $discount_amount != " " )
$price_discount = number_format ( $discount_amount , 2 , '.' , ',' );
else if ( $discount_percent != " " )
{
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = " ( " . number_format ( $discount_percent , 2 , '.' , ',' ) . " %) " ;
$price_discount = number_format ((( $discount_percent * $final_details [ " hdnSubTotal " ]) / 100 ), 2 , '.' , ',' );
}
else
$price_discount = " 0.00 " ;
//Adjustment
$price_adjustment = number_format ( $final_details [ " adjustment " ], 2 , '.' , ',' );
//Grand Total
$price_total = number_format ( $final_details [ " grandTotal " ], 2 , '.' , ',' );
//To calculate the group tax amount
if ( $final_details [ 'taxtype' ] == 'group' )
{
$group_tax_total = $final_details [ 'tax_totalamount' ];
$price_salestax = number_format ( $group_tax_total , 2 , '.' , ',' );
$group_total_tax_percent = '0.00' ;
$group_tax_details = $final_details [ 'taxes' ];
for ( $i = 0 ; $i < count ( $group_tax_details ); $i ++ )
{
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details [ $i ][ 'percentage' ];
}
}
//S&H amount
$sh_amount = $final_details [ 'shipping_handling_charge' ];
$price_shipping = number_format ( $sh_amount , 2 , '.' , ',' );
//S&H taxes
$sh_tax_details = $final_details [ 'sh_taxes' ];
$sh_tax_percent = '0.00' ;
for ( $i = 0 ; $i < count ( $sh_tax_details ); $i ++ )
{
$sh_tax_percent = $sh_tax_percent + $sh_tax_details [ $i ][ 'percentage' ];
}
$sh_tax_amount = $final_details [ 'shtax_totalamount' ];
$price_shipping_tax = number_format ( $sh_tax_amount , 2 , '.' , ',' );
$prod_line = array ();
$lines = 0 ;
//This is to get all prodcut details as row basis
for ( $i = 1 , $j = $i - 1 ; $i <= $num_products ; $i ++ , $j ++ )
{
$product_name [ $i ] = $associated_products [ $i ][ 'productName' . $i ];
$subproduct_name [ $i ] = split ( " <br> " , $associated_products [ $i ][ 'subprod_names' . $i ]);
//$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
$comment [ $i ] = $associated_products [ $i ][ 'comment' . $i ];
$product_id [ $i ] = $associated_products [ $i ][ 'hdnProductId' . $i ];
$qty [ $i ] = $associated_products [ $i ][ 'qty' . $i ];
$unit_price [ $i ] = number_format ( $associated_products [ $i ][ 'unitPrice' . $i ], 2 , '.' , ',' );
2010-08-21 19:34:11 +00:00
$list_price [ $i ] = number_format ( $associated_products [ $i ][ 'listPrice' . $i ], 2 , '.' , ',' );
2010-06-18 04:07:55 +00:00
$list_pricet [ $i ] = $associated_products [ $i ][ 'listPrice' . $i ];
$discount_total [ $i ] = $associated_products [ $i ][ 'discountTotal' . $i ];
//aded for 5.0.3 pdf changes
$product_code [ $i ] = $associated_products [ $i ][ 'hdnProductcode' . $i ];
$taxable_total = $qty [ $i ] * $list_pricet [ $i ] - $discount_total [ $i ];
$producttotal = $taxable_total ;
$total_taxes = '0.00' ;
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " )
{
$total_tax_percent = '0.00' ;
//This loop is to get all tax percentage and then calculate the total of all taxes
for ( $tax_count = 0 ; $tax_count < count ( $associated_products [ $i ][ 'taxes' ]); $tax_count ++ )
{
$tax_percent = $associated_products [ $i ][ 'taxes' ][ $tax_count ][ 'percentage' ];
$total_tax_percent = $total_tax_percent + $tax_percent ;
$tax_amount = (( $taxable_total * $tax_percent ) / 100 );
$total_taxes = $total_taxes + $tax_amount ;
}
$producttotal = $taxable_total + $total_taxes ;
$product_line [ $j ][ " Tax " ] = number_format ( $total_taxes , 2 , '.' , ',' ) . " \n ( $total_tax_percent %) " ;
$price_salestax += $total_taxes ;
}
$prod_total [ $i ] = number_format ( $producttotal , 2 , '.' , ',' );
$product_line [ $j ][ " Product Code " ] = $product_code [ $i ];
$product_line [ $j ][ " Qty " ] = $qty [ $i ];
$product_line [ $j ][ " Price " ] = $list_price [ $i ];
$product_line [ $j ][ " Discount " ] = $discount_total [ $i ];
$product_line [ $j ][ " Total " ] = $prod_total [ $i ];
$lines ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$prod_line [ $j ] = 1 ;
for ( $count = 0 ; $count < count ( $subproduct_name [ $i ]); $count ++ ){
if ( $lines % 12 != 0 ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] ++ ;
}
else {
$j ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] = 2 ;
$lines ++ ;
}
$lines ++ ;
}
if ( $comment [ $i ] != '' ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $comment [ $i ]);
$prod_line [ $j ] ++ ;
$lines ++ ;
}
}
$price_salestax = number_format ( $price_salestax , 2 , '.' , ',' );
//echo '<pre>Product Details ==>';print_r($product_line);echo '</pre>';
//echo '<pre>';print_r($associated_products);echo '</pre>';
//Population of Product Details - Ends
// ************************ END POPULATE DATA ***************************8
$page_num = '1' ;
$pdf = new PDF ( 'P' , 'mm' , 'A4' );
$pdf -> Open ();
// $num_pages=ceil(($num_products/$products_per_page));
//STARTS - Placement of products in pages as per the lines count
$lines_per_page = " 12 " ;
$prod_cnt = 0 ;
$num_pages = ceil (( $lines / $lines_per_page ));
$tmp = 0 ;
for ( $count = 0 ; $count < $num_pages ; $count ++ ){
for ( $k = $tmp ; $k < $j ; $k ++ ){
if ( $prod_cnt != 12 ){
$products [ $count ][] = $k ;
$prod_cnt += $prod_line [ $k ];
} else {
$tmp = $k ;
$prod_cnt = 0 ;
break ;
}
}
}
//ENDS - Placement of products in pages as per the lines count
$current_product = 0 ;
for ( $l = 0 ; $l < $num_pages ; $l ++ )
{
$line = array ();
if ( $num_pages == $page_num )
$lastpage = 1 ;
/*while($current_product != $page_num*$products_per_page)
{
$line[]=$product_line[$current_product];
$current_product++;
}/*/
foreach ( $products [ $l ] as $index => $key ){
$line [] = $product_line [ $key ];
}
$pdf -> AddPage ();
include ( " modules/SalesOrder/pdf_templates/header.php " );
include ( " include/tcpdf/templates/body.php " );
//if bottom > 145 then we skip the Description and T&C in every page and display only in lastpage
//if you want to display the description and T&C in each page then set the display_desc_tc='true' and bottom <= 145 in pdfconfig.php
if ( $display_desc_tc == 'true' )
if ( $bottom <= 145 )
{
include ( " modules/SalesOrder/pdf_templates/footer.php " );
}
$page_num ++ ;
if (( $endpage ) && ( $lastpage ))
{
$pdf -> AddPage ();
include ( " modules/SalesOrder/pdf_templates/header.php " );
include ( " modules/SalesOrder/pdf_templates/lastpage/body.php " );
include ( " modules/SalesOrder/pdf_templates/lastpage/footer.php " );
}
}
return $pdf ;
}
/**
* Function to generate Quote pdf
*/
function get_quote_pdf () {
require_once ( 'include/tcpdf/pdf.php' );
require_once ( 'include/tcpdf/pdfconfig.php' );
require_once ( 'include/database/PearDatabase.php' );
require_once ( 'modules/Quotes/Quotes.php' );
global $adb , $app_strings , $current_user ;
// would you like and end page? 1 for yes 0 for no
$endpage = " 1 " ;
$focus = new Quotes ();
$focus -> retrieve_entity_info ( $_REQUEST [ 'record' ], " Quotes " );
$focus -> apply_field_security ();
$account_name = getAccountName ( $focus -> column_fields [ account_id ]);
$quote_no = $focus -> column_fields [ quote_no ];
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " ) {
$product_taxes = 'true' ;
} else {
$product_taxes = 'false' ;
}
$sql = " select currency_symbol from vtiger_currency_info where id=? " ;
$result = $adb -> pquery ( $sql , array ( $focus -> column_fields [ 'currency_id' ]));
$currency_symbol = $adb -> query_result ( $result , 0 , 'currency_symbol' );
// **************** BEGIN POPULATE DATA ********************
$account_id = $focus -> column_fields [ account_id ];
$quote_id = $_REQUEST [ 'record' ];
// Quote Information
$valid_till = $focus -> column_fields [ " validtill " ];
$valid_till = getDisplayDate ( $valid_till );
$bill_street = $focus -> column_fields [ " bill_street " ];
$bill_city = $focus -> column_fields [ " bill_city " ];
$bill_state = $focus -> column_fields [ " bill_state " ];
$bill_code = $focus -> column_fields [ " bill_code " ];
$bill_country = $focus -> column_fields [ " bill_country " ];
$contact_name = getContactName ( $focus -> column_fields [ " contact_id " ]);
$ship_street = $focus -> column_fields [ " ship_street " ];
$ship_city = $focus -> column_fields [ " ship_city " ];
$ship_state = $focus -> column_fields [ " ship_state " ];
$ship_code = $focus -> column_fields [ " ship_code " ];
$ship_country = $focus -> column_fields [ " ship_country " ];
$conditions = from_html ( $focus -> column_fields [ " terms_conditions " ]);
$description = from_html ( $focus -> column_fields [ " description " ]);
$status = $focus -> column_fields [ " quotestage " ];
// Company information
$add_query = " select * from vtiger_organizationdetails " ;
$result = $adb -> pquery ( $add_query , array ());
$num_rows = $adb -> num_rows ( $result );
if ( $num_rows > 0 )
{
$org_name = $adb -> query_result ( $result , 0 , " organizationname " );
$org_address = $adb -> query_result ( $result , 0 , " address " );
$org_city = $adb -> query_result ( $result , 0 , " city " );
$org_state = $adb -> query_result ( $result , 0 , " state " );
$org_country = $adb -> query_result ( $result , 0 , " country " );
$org_code = $adb -> query_result ( $result , 0 , " code " );
$org_phone = $adb -> query_result ( $result , 0 , " phone " );
$org_fax = $adb -> query_result ( $result , 0 , " fax " );
$org_website = $adb -> query_result ( $result , 0 , " website " );
$logo_name = $adb -> query_result ( $result , 0 , " logoname " );
}
//Population of Product Details - Starts
//we can cut and paste the following lines in a file and include that file here is enough. For that we have to put a new common file. we will do this later
//NOTE : Removed currency symbols and added with Grand Total text. it is enough to show the currency symbol in one place
//we can also get the NetTotal, Final Discount Amount/Percent, Adjustment and GrandTotal from the array $associated_products[1]['final_details']
//get the Associated Products for this Invoice
$focus -> id = $focus -> column_fields [ " record_id " ];
$associated_products = getAssociatedProducts ( " Quotes " , $focus );
$num_products = count ( $associated_products );
//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes and adjustment
$final_details = $associated_products [ 1 ][ 'final_details' ];
//getting the Net Total
$price_subtotal = number_format ( $final_details [ " hdnSubTotal " ], 2 , '.' , ',' );
//Final discount amount/percentage
$discount_amount = $final_details [ " discount_amount_final " ];
$discount_percent = $final_details [ " discount_percentage_final " ];
if ( $discount_amount != " " )
$price_discount = number_format ( $discount_amount , 2 , '.' , ',' );
else if ( $discount_percent != " " )
{
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
$final_price_discount_percent = " ( " . number_format ( $discount_percent , 2 , '.' , ',' ) . " %) " ;
$price_discount = number_format ((( $discount_percent * $final_details [ " hdnSubTotal " ]) / 100 ), 2 , '.' , ',' );
}
else
$price_discount = " 0.00 " ;
//Adjustment
$price_adjustment = number_format ( $final_details [ " adjustment " ], 2 , '.' , ',' );
//Grand Total
$price_total = number_format ( $final_details [ " grandTotal " ], 2 , '.' , ',' );
//To calculate the group tax amount
if ( $final_details [ 'taxtype' ] == 'group' )
{
$group_tax_total = $final_details [ 'tax_totalamount' ];
$price_salestax = number_format ( $group_tax_total , 2 , '.' , ',' );
$group_total_tax_percent = '0.00' ;
$group_tax_details = $final_details [ 'taxes' ];
for ( $i = 0 ; $i < count ( $group_tax_details ); $i ++ )
{
$group_total_tax_percent = $group_total_tax_percent + $group_tax_details [ $i ][ 'percentage' ];
}
}
//S&H amount
$sh_amount = $final_details [ 'shipping_handling_charge' ];
$price_shipping = number_format ( $sh_amount , 2 , '.' , ',' );
//S&H taxes
$sh_tax_details = $final_details [ 'sh_taxes' ];
$sh_tax_percent = '0.00' ;
for ( $i = 0 ; $i < count ( $sh_tax_details ); $i ++ )
{
$sh_tax_percent = $sh_tax_percent + $sh_tax_details [ $i ][ 'percentage' ];
}
$sh_tax_amount = $final_details [ 'shtax_totalamount' ];
$price_shipping_tax = number_format ( $sh_tax_amount , 2 , '.' , ',' );
$prod_line = array ();
$lines = 0 ;
//This is to get all prodcut details as row basis
for ( $i = 1 , $j = $i - 1 ; $i <= $num_products ; $i ++ , $j ++ )
{
$product_name [ $i ] = $associated_products [ $i ][ 'productName' . $i ];
$subproduct_name [ $i ] = split ( " <br> " , $associated_products [ $i ][ 'subprod_names' . $i ]);
//$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
$comment [ $i ] = $associated_products [ $i ][ 'comment' . $i ];
$product_id [ $i ] = $associated_products [ $i ][ 'hdnProductId' . $i ];
$qty [ $i ] = $associated_products [ $i ][ 'qty' . $i ];
$unit_price [ $i ] = number_format ( $associated_products [ $i ][ 'unitPrice' . $i ], 2 , '.' , ',' );
$list_price [ $i ] = number_format ( $associated_products [ $i ][ 'listPrice' . $i ], 2 , '.' , ',' );
$list_pricet [ $i ] = $associated_products [ $i ][ 'listPrice' . $i ];
$discount_total [ $i ] = $associated_products [ $i ][ 'discountTotal' . $i ];
//aded for 5.0.3 pdf changes
$product_code [ $i ] = $associated_products [ $i ][ 'hdnProductcode' . $i ];
$taxable_total = $qty [ $i ] * $list_pricet [ $i ] - $discount_total [ $i ];
$producttotal = $taxable_total ;
$total_taxes = '0.00' ;
if ( $focus -> column_fields [ " hdnTaxType " ] == " individual " )
{
$total_tax_percent = '0.00' ;
//This loop is to get all tax percentage and then calculate the total of all taxes
for ( $tax_count = 0 ; $tax_count < count ( $associated_products [ $i ][ 'taxes' ]); $tax_count ++ )
{
$tax_percent = $associated_products [ $i ][ 'taxes' ][ $tax_count ][ 'percentage' ];
$total_tax_percent = $total_tax_percent + $tax_percent ;
$tax_amount = (( $taxable_total * $tax_percent ) / 100 );
$total_taxes = $total_taxes + $tax_amount ;
}
$producttotal = $taxable_total + $total_taxes ;
$product_line [ $j ][ " Tax " ] = number_format ( $total_taxes , 2 , '.' , ',' ) . " \n ( $total_tax_percent %) " ;
$price_salestax += $total_taxes ;
}
$prod_total [ $i ] = number_format ( $producttotal , 2 , '.' , ',' );
$product_line [ $j ][ " Product Code " ] = $product_code [ $i ];
$product_line [ $j ][ " Qty " ] = $qty [ $i ];
$product_line [ $j ][ " Price " ] = $list_price [ $i ];
$product_line [ $j ][ " Discount " ] = $discount_total [ $i ];
$product_line [ $j ][ " Total " ] = $prod_total [ $i ];
$lines ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$prod_line [ $j ] = 1 ;
for ( $count = 0 ; $count < count ( $subproduct_name [ $i ]); $count ++ ){
if ( $lines % 12 != 0 ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] ++ ;
}
else {
$j ++ ;
$product_line [ $j ][ " Product Name " ] = decode_html ( $product_name [ $i ]);
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $subproduct_name [ $i ][ $count ]);
$prod_line [ $j ] = 2 ;
$lines ++ ;
}
$lines ++ ;
}
if ( $comment [ $i ] != '' ){
$product_line [ $j ][ " Product Name " ] .= " \n " . decode_html ( $comment [ $i ]);
$prod_line [ $j ] ++ ;
$lines ++ ;
}
}
$price_salestax = number_format ( $price_salestax , 2 , '.' , ',' );
//echo '<pre>Product Details ==>';print_r($product_line);echo '</pre>';
//echo '<pre>';print_r($associated_products);echo '</pre>';
//Population of Product Details - Ends
// ************************ END POPULATE DATA ***************************8
$page_num = '1' ;
$pdf = new PDF ( 'P' , 'mm' , 'A4' );
$pdf -> Open ();
// $num_pages=ceil(($num_products/$products_per_page));
//STARTS - Placement of products in pages as per the lines count
$lines_per_page = " 12 " ;
$prod_cnt = 0 ;
$num_pages = ceil (( $lines / $lines_per_page ));
$tmp = 0 ;
for ( $count = 0 ; $count < $num_pages ; $count ++ ){
for ( $k = $tmp ; $k < $j ; $k ++ ){
if ( $prod_cnt != 12 ){
$products [ $count ][] = $k ;
$prod_cnt += $prod_line [ $k ];
} else {
$tmp = $k ;
$prod_cnt = 0 ;
break ;
}
}
}
//ENDS - Placement of products in pages as per the lines count
$current_product = 0 ;
for ( $l = 0 ; $l < $num_pages ; $l ++ )
{
$line = array ();
if ( $num_pages == $page_num )
$lastpage = 1 ;
/*while($current_product != $page_num*$products_per_page)
{
$line[]=$product_line[$current_product];
$current_product++;
}/*/
foreach ( $products [ $l ] as $index => $key ){
$line [] = $product_line [ $key ];
}
$pdf -> AddPage ();
include ( " modules/Quotes/pdf_templates/header.php " );
include ( " include/tcpdf/templates/body.php " );
//if bottom > 145 then we skip the Description and T&C in every page and display only in lastpage
//if you want to display the description and T&C in each page then set the display_desc_tc='true' and bottom <= 145 in pdfconfig.php
if ( $display_desc_tc == 'true' )
if ( $bottom <= 145 )
{
include ( " modules/Quotes/pdf_templates/footer.php " );
}
$page_num ++ ;
if (( $endpage ) && ( $lastpage ))
{
$pdf -> AddPage ();
include ( " modules/Quotes/pdf_templates/header.php " );
include ( " modules/Quotes/pdf_templates/lastpage/body.php " );
include ( " modules/Quotes/pdf_templates/lastpage/footer.php " );
}
}
return $pdf ;
}
?>
