web-erp-svn

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

[<ex...@us...>]

Revision: 6235
          http://sourceforge.net/p/web-erp/reponame/6235
Author:   exsonqu
Date:     2013-08-16 03:39:48 +0000 (Fri, 16 Aug 2013)
Log Message:
-----------
16/08/2013 Exson: Fixed the account code max length in SuppTransGLAnalysis.php and make it html5 compatible. 

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

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2013-08-15 13:48:50 UTC (rev 6234)
+++ trunk/SuppTransGLAnalysis.php	2013-08-16 03:39:48 UTC (rev 6235)
@@ -187,7 +187,7 @@
 
 echo '<tr>
 		<td>' . _('Account Code') . ':</td>
-		<td><input type="text" name="GLCode" size="12" maxlength="11" value="' .  $_POST['GLCode'] . '" />
+		<td><input type="integer" pattern="[1-9][\d]{0,20}" title="'._('The input must be positive integer').'" placeholder="'._('Integer less than 20 digits').'" name="GLCode" size="21" maxlength="20" value="' .  $_POST['GLCode'] . '" />
 		<input type="hidden" name="JobRef" value="" /></td>
 	</tr>';
 echo '<tr>
@@ -217,7 +217,7 @@
 }
 echo '<tr>
 		<td>' . _('Amount') . ':</td>
-		<td><input type="text" class="number" name="Amount" size="12" maxlength="11" value="' .  locale_number_format($_POST['Amount'],$_SESSION['SuppTrans']->CurrDecimalPlaces) . '" /></td>
+		<td><input type="text" class="number" required="required" pattern="(?!^[-]?0[.,]0*$).{1,11}" title="'._('The amount must be numeric and cannot be zero').'" name="Amount" size="12" placeholder="'._('No zero numeric').'" maxlength="11" value="' .  locale_number_format($_POST['Amount'],$_SESSION['SuppTrans']->CurrDecimalPlaces) . '" /></td>
 	</tr>';
 
 if (!isset($_POST['Narrative'])) {
@@ -237,4 +237,4 @@
 echo '</div>
       </form>';
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

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

[<ex...@us...>]

Revision: 6253
          http://sourceforge.net/p/web-erp/reponame/6253
Author:   exsonqu
Date:     2013-08-19 09:36:26 +0000 (Mon, 19 Aug 2013)
Log Message:
-----------
19/8/2013 Exson: Fixed the type error to class is integer. Reported by Tim. 

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

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2013-08-19 08:43:50 UTC (rev 6252)
+++ trunk/SuppTransGLAnalysis.php	2013-08-19 09:36:26 UTC (rev 6253)
@@ -104,12 +104,12 @@
 	<table class="selection">';
 
 $TableHeader = '<tr>
-					<th class="ascending" onclick="SortSelect(this)">' . _('Account') . '</th>
-					<th class="ascending" onclick="SortSelect(this)">' . _('Name') . '</th>
-					<th class="ascending" onclick="SortSelect(this)">' . _('Amount') . '<br />' . _('in') . ' ' . $_SESSION['SuppTrans']->CurrCode . '</th>
+					<th>' . _('Account') . '</th>
+					<th>' . _('Name') . '</th>
+					<th>' . _('Amount') . '<br />' . _('in') . ' ' . $_SESSION['SuppTrans']->CurrCode . '</th>
 					<th>' . _('Narrative') . '</th>
-					<th class="ascending" onclick="SortSelect(this)">' . _('Tag') . '</th>
-				</tr>';
+					<th>' . _('Tag') . '</th>
+					</tr>';
 echo $TableHeader;
 $TotalGLValue=0;
 $i=0;
@@ -187,7 +187,7 @@
 
 echo '<tr>
 		<td>' . _('Account Code') . ':</td>
-		<td><input type="text" pattern="[a-zA-Z0-9_\-]*{0,20}" title="'._('The input must be positive integer').'" name="GLCode" size="21" maxlength="20" value="' .  $_POST['GLCode'] . '" />
+		<td><input class="integer" pattern="[1-9][\d]{0,20}" title="'._('The input must be positive integer').'" placeholder="'._('Integer less than 20 digits').'" name="GLCode" size="21" maxlength="20" value="' .  $_POST['GLCode'] . '" />
 		<input type="hidden" name="JobRef" value="" /></td>
 	</tr>';
 echo '<tr>

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

[<ex...@us...>]

Revision: 6255
          http://sourceforge.net/p/web-erp/reponame/6255
Author:   exsonqu
Date:     2013-08-19 09:56:23 +0000 (Mon, 19 Aug 2013)
Log Message:
-----------
19/8/2013 Exson: Fixed the account code pattern to make it compatible with the definition in GLAccounts.php 

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

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2013-08-19 09:37:10 UTC (rev 6254)
+++ trunk/SuppTransGLAnalysis.php	2013-08-19 09:56:23 UTC (rev 6255)
@@ -104,12 +104,12 @@
 	<table class="selection">';
 
 $TableHeader = '<tr>
-					<th>' . _('Account') . '</th>
-					<th>' . _('Name') . '</th>
-					<th>' . _('Amount') . '<br />' . _('in') . ' ' . $_SESSION['SuppTrans']->CurrCode . '</th>
+					<th class="ascending" onclick="SortSelect(this)">' . _('Account') . '</th>
+					<th class="ascending" onclick="SortSelect(this)">' . _('Name') . '</th>
+					<th class="ascending" onclick="SortSelect(this)">' . _('Amount') . '<br />' . _('in') . ' ' . $_SESSION['SuppTrans']->CurrCode . '</th>
 					<th>' . _('Narrative') . '</th>
-					<th>' . _('Tag') . '</th>
-					</tr>';
+					<th class="ascending" onclick="SortSelect(this)">' . _('Tag') . '</th>
+				</tr>';
 echo $TableHeader;
 $TotalGLValue=0;
 $i=0;
@@ -187,7 +187,7 @@
 
 echo '<tr>
 		<td>' . _('Account Code') . ':</td>
-		<td><input class="integer" pattern="[1-9][\d]{0,20}" title="'._('The input must be positive integer').'" placeholder="'._('Integer less than 20 digits').'" name="GLCode" size="21" maxlength="20" value="' .  $_POST['GLCode'] . '" />
+		<td><input type="text" pattern="[a-zA-Z0-9_-]{0,20}" title="'._('The input must be alpha-numeric characters').'" placeholder="'._('less than 20 alpha-numeric characters').'" name="GLCode" size="21" maxlength="20" value="' .  $_POST['GLCode'] . '" />
 		<input type="hidden" name="JobRef" value="" /></td>
 	</tr>';
 echo '<tr>

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

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

Revision: 7741
          http://sourceforge.net/p/web-erp/reponame/7741
Author:   tehonu
Date:     2017-03-21 03:50:39 +0000 (Tue, 21 Mar 2017)
Log Message:
-----------
Fixed bug where User was able to select all GL accounts not only the GL accounts she is authorized to.

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

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2017-03-19 12:52:53 UTC (rev 7740)
+++ trunk/SuppTransGLAnalysis.php	2017-03-21 03:50:39 UTC (rev 7741)
@@ -198,8 +198,12 @@
 		<br />' . _('otherwise select the account from the list') . ')</td>
 	<td><select name="AcctSelection">';
 
-$sql = "SELECT accountcode, accountname FROM chartmaster ORDER BY accountcode";
-
+$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
+		ORDER BY chartmaster.accountcode";
+		
 $result = DB_query($sql);
 echo '<option value=""></option>';
 while ($myrow = DB_fetch_array($result)) {

[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);