[Web-erp-svn] SF.net SVN: web-erp:[6456] trunk/DailyBankTransactions.php

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

Revision: 6456
          http://sourceforge.net/p/web-erp/reponame/6456
Author:   tehonu
Date:     2013-11-29 12:32:08 +0000 (Fri, 29 Nov 2013)
Log Message:
-----------
Restriction by userid

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

Modified: trunk/DailyBankTransactions.php
===================================================================
--- trunk/DailyBankTransactions.php	2013-11-29 07:30:02 UTC (rev 6455)
+++ trunk/DailyBankTransactions.php	2013-11-29 12:32:08 UTC (rev 6456)
@@ -26,8 +26,11 @@
 					bankaccounts.accountcode,
 					bankaccounts.currcode
 			FROM bankaccounts,
-				chartmaster
-			WHERE bankaccounts.accountcode=chartmaster.accountcode";
+				chartmaster, 
+				bankaccountusers
+			WHERE bankaccounts.accountcode=chartmaster.accountcode
+				AND bankaccounts.accountcode=bankaccountusers.accountcode
+			AND bankaccountusers.userid = '" . $_SESSION['UserID'] ."'";
 
 	$ErrMsg = _('The bank accounts could not be retrieved because');
 	$DbgMsg = _('The SQL used to retrieve the bank accounts was');