[Web-erp-svn] SF.net SVN: web-erp:[7742] trunk/SuppTransGLAnalysis.php

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

Revision: 7742
          http://sourceforge.net/p/web-erp/reponame/7742
Author:   tehonu
Date:     2017-03-21 03:58:00 +0000 (Tue, 21 Mar 2017)
Log Message:
-----------
Fix on previous commit

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

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2017-03-21 03:50:39 UTC (rev 7741)
+++ trunk/SuppTransGLAnalysis.php	2017-03-21 03:58:00 UTC (rev 7742)
@@ -201,7 +201,7 @@
 $sql = "SELECT chartmaster.accountcode, 
 			   chartmaster.accountname
 		FROM chartmaster 
-		INNER JOIN glaccountusers ON glaccountusers.accountcode=chartmaster.accountcode AND glaccountusers.userid='" .  $_SESSION['UserID'] . "' AND glaccountusers.canview=1
+		INNER JOIN glaccountusers ON glaccountusers.accountcode=chartmaster.accountcode AND glaccountusers.userid='" .  $_SESSION['UserID'] . "' AND glaccountusers.canupd=1
 		ORDER BY chartmaster.accountcode";
 		
 $result = DB_query($sql);