YuCheng Hu
6ec1baf892
yuchenghu@hawebs.net git-svn-id: https://svn.code.sf.net/p/hawebs/svn@563 a2543c7e-f6e9-4f8a-8bff-1ffc34733512
1156 lines
40 KiB
PHP
1156 lines
40 KiB
PHP
<?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,'.',',');
|
|
$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/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;
|
|
}
|
|
?>
|