[Web-erp-svn] SF.net SVN: web-erp:[7716] trunk/GLCashFlowsIndirect.php

[<te...@us...>]

Revision: 7716
          http://sourceforge.net/p/web-erp/reponame/7716
Author:   tehonu
Date:     2017-01-05 00:11:17 +0000 (Thu, 05 Jan 2017)
Log Message:
-----------
Fix warnings in http://www.weberp.org/forum/showthread.php?tid=2962. following Tim's solution.

Modified Paths:
--------------
    trunk/GLCashFlowsIndirect.php

Modified: trunk/GLCashFlowsIndirect.php
===================================================================
--- trunk/GLCashFlowsIndirect.php	2017-01-02 00:40:32 UTC (rev 7715)
+++ trunk/GLCashFlowsIndirect.php	2017-01-05 00:11:17 UTC (rev 7716)
@@ -76,8 +76,10 @@
 		$Title, '" /> ', // Icon title.
 		$Title, '<br />', // Page title, reporting statement.
 		stripslashes($_SESSION['CompanyRecord']['coyname']), '<br />'; // Page title, reporting entity.
-	$PeriodFromName = DB_fetch_array(DB_query('SELECT lastdate_in_period FROM `periods` WHERE `periodno`=' . $_POST['PeriodFrom']));
-	$PeriodToName = DB_fetch_array(DB_query('SELECT lastdate_in_period FROM `periods` WHERE `periodno`=' . $_POST['PeriodTo']));
+	$Result = DB_query('SELECT lastdate_in_period FROM `periods` WHERE `periodno`=' . $_POST['PeriodFrom']);
+	$PeriodFromName = DB_fetch_array($Result);
+	$Result = DB_query('SELECT lastdate_in_period FROM `periods` WHERE `periodno`=' . $_POST['PeriodTo']);
+	$PeriodToName = DB_fetch_array($Result);
 	echo _('From'), ' ', MonthAndYearFromSQLDate($PeriodFromName['lastdate_in_period']), ' ', _('to'), ' ', MonthAndYearFromSQLDate($PeriodToName['lastdate_in_period']), '<br />'; // Page title, reporting period.
 	include_once('includes/CurrenciesArray.php');// Array to retrieve currency name.
 	echo _('All amounts stated in'), ': ', _($CurrencyName[$_SESSION['CompanyRecord']['currencydefault']]), '</p>';// Page title, reporting presentation currency and level of rounding used.
@@ -97,7 +99,8 @@
 	// Gets the net profit for the period GL account:
 	if(!isset($_SESSION['PeriodProfitAccount'])) {
 		$_SESSION['PeriodProfitAccount'] = '';
-		$MyRow = DB_fetch_array(DB_query("SELECT confvalue FROM `config` WHERE confname ='PeriodProfitAccount'"));
+		$Result = DB_query("SELECT confvalue FROM `config` WHERE confname ='PeriodProfitAccount'");
+		$MyRow = DB_fetch_array($Result);
 		if($MyRow) {
 			$_SESSION['PeriodProfitAccount'] = $MyRow['confvalue'];
 		}
@@ -106,7 +109,8 @@
 	if(!isset($_SESSION['RetainedEarningsAccount'])) {
 		$_SESSION['RetainedEarningsAccount'] = '';
 /*		$MyRow = DB_fetch_array(DB_query("SELECT confvalue FROM `config` WHERE confname ='RetainedEarningsAccount'"));// RChacon: Standardise to config table? */
-		$MyRow = DB_fetch_array(DB_query("SELECT retainedearnings FROM companies WHERE coycode = 1"));
+		$Result = DB_query("SELECT retainedearnings FROM companies WHERE coycode = 1");
+		$MyRow = DB_fetch_array($Result);
 		if($MyRow) {
 			$_SESSION['RetainedEarningsAccount'] = $MyRow['confvalue'];
 		}
@@ -465,7 +469,8 @@
 					INNER JOIN chartdetails ON chartmaster.accountcode=chartdetails.accountcode
 					INNER JOIN accountgroups ON chartmaster.group_=accountgroups.groupname
 				WHERE accountgroups.pandl=1";
-		$MyRow1 = DB_fetch_array(DB_query($Sql));
+		$Result1 = DB_query($Sql);
+		$MyRow1 = DB_fetch_array($Result1);
 		echo	colDebitCredit($MyRow1['ActualProfit']),
 				colDebitCredit($MyRow1['LastProfit']),
 			'</tr>
@@ -482,7 +487,8 @@
 				WHERE accountgroups.pandl=0
 					AND chartdetails.accountcode!='" . $_SESSION['PeriodProfitAccount'] . "'
 					AND chartdetails.accountcode!='" . $_SESSION['RetainedEarningsAccount'] . "'";// Gets retained earnings by the complement method to include differences. The complement method: Changes(retained earnings) = -Changes(other accounts).
-		$MyRow2 = DB_fetch_array(DB_query($Sql));
+		$Result2 = DB_query($Sql);
+		$MyRow2 = DB_fetch_array($Result2);
 		echo	colDebitCredit($MyRow2['ActualRetained'] - $MyRow1['ActualProfit']),
 				colDebitCredit($MyRow2['LastRetained'] - $MyRow1['LastProfit']),
 			'</tr><tr>',