[Web-erp-svn] SF.net SVN: web-erp:[7829] trunk

[<tu...@us...>]

Revision: 7829
          http://sourceforge.net/p/web-erp/reponame/7829
Author:   turbopt
Date:     2017-09-08 17:58:40 +0000 (Fri, 08 Sep 2017)
Log Message:
-----------
Z_ChangeLocationCode.php: Add missing locationusers table update, reported by Paul Becker in forums.

Modified Paths:
--------------
    trunk/Z_ChangeLocationCode.php
    trunk/doc/Change.log

Modified: trunk/Z_ChangeLocationCode.php
===================================================================
--- trunk/Z_ChangeLocationCode.php	2017-09-08 09:45:40 UTC (rev 7828)
+++ trunk/Z_ChangeLocationCode.php	2017-09-08 17:58:40 UTC (rev 7829)
@@ -138,6 +138,12 @@
 		$result = DB_query($sql,$ErrMsg,$DbgMsg,true);
 		echo ' ... ' . _('completed');
 
+		echo '<br />' . _('Changing the locationusers table records');
+		$sql = "UPDATE locationusers SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['OldLocationID'] . "'";
+		$ErrMsg = _('The SQL to update users records failed');
+		$result = DB_query($sql,$ErrMsg,$DbgMsg,true);
+		echo ' ... ' . _('completed');
+
 		echo '<br />' . _('Changing stock location records');
 		$sql = "UPDATE locstock SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['OldLocationID'] . "'";
 		$ErrMsg = _('The SQL to update stock location records failed');

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2017-09-08 09:45:40 UTC (rev 7828)
+++ trunk/doc/Change.log	2017-09-08 17:58:40 UTC (rev 7829)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+8/9/17 PaulT: Z_ChangeLocationCode.php: Add missing locationusers table update, reported by Paul Becker in forums.
 8/9/17 Phil: Fix portrait invoice email now has narrative of correct invocie number!
 8/9/17 Andrew Couling: Petty cash improvements to tax taken from Tim's work
 6/9/17 RChacon: Fix currency translation in PO_AuthorisationLevels.php.