X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep202.php;h=2eb27559689efe240c53f395c0a60089ea79f773;hb=7ce9ff6a73214a39ff495f04b330563212b43acb;hp=b443e6d79579c7de37c91992476f66847f1669ab;hpb=b37623cf1de2cfce6825744557d76475f002321f;p=fa-stable.git

diff --git a/reporting/rep202.php b/reporting/rep202.php
index b443e6d7..2eb27559 100644
--- a/reporting/rep202.php
+++ b/reporting/rep202.php
@@ -1,12 +1,12 @@
 <?php
 /**********************************************************************
     Copyright (C) FrontAccounting, LLC.
-	Released under the terms of the GNU General Public License, GPL, 
-	as published by the Free Software Foundation, either version 3 
+	Released under the terms of the GNU General Public License, GPL,
+	as published by the Free Software Foundation, either version 3
 	of the License, or (at your option) any later version.
     This program is distributed in the hope that it will be useful,
     but WITHOUT ANY WARRANTY; without even the implied warranty of
-    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 $page_security = 'SA_SUPPLIERANALYTIC';
@@ -65,15 +65,17 @@ function get_invoices($supplier_id, $to)
 
 function print_aged_supplier_analysis()
 {
-    global $comp_path, $path_to_root, $systypes_array;
+    global $path_to_root, $systypes_array;
 
     $to = $_POST['PARAM_0'];
     $fromsupp = $_POST['PARAM_1'];
     $currency = $_POST['PARAM_2'];
 	$summaryOnly = $_POST['PARAM_3'];
-    $graphics = $_POST['PARAM_4'];
-    $comments = $_POST['PARAM_5'];
-	$destination = $_POST['PARAM_6'];
+    $no_zeros = $_POST['PARAM_4'];
+    $graphics = $_POST['PARAM_5'];
+    $comments = $_POST['PARAM_6'];
+	$destination = $_POST['PARAM_7'];
+
 	if ($destination)
 		include_once($path_to_root . "/reporting/includes/excel_report.inc");
 	else
@@ -88,7 +90,7 @@ function print_aged_supplier_analysis()
 		$from = _('All');
 	else
 		$from = get_supplier_name($fromsupp);
-    $dec = user_price_dec();
+    	$dec = user_price_dec();
 
 	if ($summaryOnly == 1)
 		$summary = _('Summary Only');
@@ -101,6 +103,10 @@ function print_aged_supplier_analysis()
 	}
 	else
 		$convert = false;
+
+	if ($no_zeros) $nozeros = _('Yes');
+	else $nozeros = _('No');
+
 	$PastDueDays1 = get_company_pref('past_due_days');
 	$PastDueDays2 = 2 * $PastDueDays1;
 	$nowdue = "1-" . $PastDueDays1 . " " . _('Days');
@@ -114,15 +120,16 @@ function print_aged_supplier_analysis()
 
 	$aligns = array('left',	'left',	'left',	'right', 'right', 'right', 'right',	'right');
 
-    $params =   array( 	0 => $comments,
-    				    1 => array('text' => _('End Date'), 'from' => $to, 'to' => ''),
-    				    2 => array('text' => _('Supplier'), 'from' => $from, 'to' => ''),
-    				    3 => array('text' => _('Currency'),'from' => $currency,'to' => ''),
-                    	4 => array('text' => _('Type'), 'from' => $summary,'to' => ''));
+    	$params =   array( 	0 => $comments,
+    				1 => array('text' => _('End Date'), 'from' => $to, 'to' => ''),
+    				2 => array('text' => _('Supplier'), 'from' => $from, 'to' => ''),
+    				3 => array('text' => _('Currency'),'from' => $currency,'to' => ''),
+                    		4 => array('text' => _('Type'), 'from' => $summary,'to' => ''),
+				5 => array('text' => _('Suppress Zeros'), 'from' => $nozeros, 'to' => ''));
 
 	if ($convert)
 		$headers[2] = _('currency');
-    $rep = new FrontReport(_('Aged Supplier Analysis'), "AgedSupplierAnalysis", user_pagesize());
+    	$rep = new FrontReport(_('Aged Supplier Analysis'), "AgedSupplierAnalysis", user_pagesize());
 
     $rep->Font();
     $rep->Info($params, $cols, $headers, $aligns);
@@ -145,31 +152,32 @@ function print_aged_supplier_analysis()
 
 	while ($myrow=db_fetch($result))
 	{
-		if (!$convert && $currency != $myrow['curr_code'])
-			continue;
-		$rep->fontSize += 2;
-		$rep->TextCol(0, 2,	$myrow['name']);
-		if ($convert)
-		{
-			$rate = get_exchange_rate_from_home_currency($myrow['curr_code'], $to);
-			$rep->TextCol(2, 3,	$myrow['curr_code']);
-		}
-		else
-			$rate = 1.0;
-		$rep->fontSize -= 2;
+		if (!$convert && $currency != $myrow['curr_code']) continue;
+
+		if ($convert) $rate = get_exchange_rate_from_home_currency($myrow['curr_code'], $to);
+		else $rate = 1.0;
+
 		$supprec = get_supplier_details($myrow['supplier_id'], $to);
 		foreach ($supprec as $i => $value)
 			$supprec[$i] *= $rate;
-		$total[0] += ($supprec["Balance"] - $supprec["Due"]);
-		$total[1] += ($supprec["Due"]-$supprec["Overdue1"]);
-		$total[2] += ($supprec["Overdue1"]-$supprec["Overdue2"]);
-		$total[3] += $supprec["Overdue2"];
-		$total[4] += $supprec["Balance"];
+
 		$str = array($supprec["Balance"] - $supprec["Due"],
 			$supprec["Due"]-$supprec["Overdue1"],
 			$supprec["Overdue1"]-$supprec["Overdue2"],
 			$supprec["Overdue2"],
 			$supprec["Balance"]);
+
+		if ($no_zeros && array_sum($str) == 0) continue;
+
+		$rep->fontSize += 2;
+		$rep->TextCol(0, 2,	$myrow['name']);
+		if ($convert) $rep->TextCol(2, 3,	$myrow['curr_code']);
+		$rep->fontSize -= 2;
+		$total[0] += ($supprec["Balance"] - $supprec["Due"]);
+		$total[1] += ($supprec["Due"]-$supprec["Overdue1"]);
+		$total[2] += ($supprec["Overdue1"]-$supprec["Overdue2"]);
+		$total[3] += $supprec["Overdue2"];
+		$total[4] += $supprec["Balance"];
 		for ($i = 0; $i < count($str); $i++)
 			$rep->AmountCol($i + 3, $i + 4, $str[$i], $dec);
 		$rep->NewLine(1, 2);
@@ -228,9 +236,8 @@ function print_aged_supplier_analysis()
 		$pg->type      = $graphics;
 		$pg->skin      = $graph_skin;
 		$pg->built_in  = false;
-		$pg->fontfile  = $path_to_root . "/reporting/fonts/Vera.ttf";
 		$pg->latin_notation = ($decseps[$_SESSION["wa_current_user"]->prefs->dec_sep()] != ".");
-		$filename = $comp_path.'/'.user_company(). "/pdf_files/test.png";
+		$filename = company_path(). "/pdf_files/". uniqid("").".png";
 		$pg->display($filename, true);
 		$w = $pg->width / 1.5;
 		$h = $pg->height / 1.5;
@@ -243,4 +250,4 @@ function print_aged_supplier_analysis()
     $rep->End();
 }
 
-?>
\ No newline at end of file
+?>