[Web-erp-svn] SF.net SVN: web-erp:[7915] trunk/BankAccountBalances.php

[<dai...@us...>]

Revision: 7915
          http://sourceforge.net/p/web-erp/reponame/7915
Author:   daintree
Date:     2018-01-11 08:08:07 +0000 (Thu, 11 Jan 2018)
Log Message:
-----------


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

Modified: trunk/BankAccountBalances.php
===================================================================
--- trunk/BankAccountBalances.php	2018-01-11 07:49:09 UTC (rev 7914)
+++ trunk/BankAccountBalances.php	2018-01-11 08:08:07 UTC (rev 7915)
@@ -10,8 +10,8 @@
 
 echo '<p class="page_title_text"><img src="', $RootPath, '/css/', $_SESSION['Theme'], '/images/bank.png" title="', _('Bank Account Balances'), '" alt="" /> ',
 		_('Bank Account Balances'), '
-	</p<
-	table>
+	</p>
+	<table>
 		<tr>
 			<th>', _('Bank Account'), '</th>
 			<th>', _('Account Name'), '</th>
@@ -19,19 +19,18 @@
 			<th>', _('Balance in functional currency'), '</th>
 		</tr>';
 
-$SQL = "SELECT bankaccounts.accountcode,
-				currcode,
-				bankaccountname
+$SQL = "SELECT DISTINCT bankaccounts.accountcode,
+						currcode,
+						bankaccountname
 			FROM bankaccounts
 			INNER JOIN bankaccountusers
-				ON bankaccounts.accountcode=bankaccountusers.accountcode
-				AND userid='" . $_SESSION['UserID'] . "'";
+			ON bankaccounts.accountcode=bankaccountusers.accountcode
+			AND userid='" . $_SESSION['UserID'] . "'";
 $Result = DB_query($SQL);
 
 if (DB_num_rows($Result) == 0) {
 	echo _('There are no bank accounts defined that you have authority to see');
 } else {
-	
 	while ($MyBankRow = DB_fetch_array($Result)) {
 		$CurrBalanceSQL = "SELECT SUM(amount) AS balance FROM banktrans WHERE bankact='" . $MyBankRow['accountcode'] . "'";
 		$CurrBalanceResult = DB_query($CurrBalanceSQL);