[Web-erp-svn] SF.net SVN: web-erp:[6890] trunk/BOMs.php

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

Revision: 6890
          http://sourceforge.net/p/web-erp/reponame/6890
Author:   tehonu
Date:     2014-09-16 00:12:22 +0000 (Tue, 16 Sep 2014)
Log Message:
-----------
Use of usedforwo location flag in BOM

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

Modified: trunk/BOMs.php
===================================================================
--- trunk/BOMs.php	2014-09-15 05:11:09 UTC (rev 6889)
+++ trunk/BOMs.php	2014-09-16 00:12:22 UTC (rev 6890)
@@ -706,7 +706,14 @@
 				<td><select tabindex="2" name="LocCode">';
 
 		DB_free_result($result);
-		$sql = "SELECT locationname, locations.loccode FROM locations INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canupd=1";
+		$sql = "SELECT locationname, 
+					locations.loccode 
+				FROM locations 
+				INNER JOIN locationusers 
+					ON locationusers.loccode=locations.loccode 
+					AND locationusers.userid='" .  $_SESSION['UserID'] . "' 
+					AND locationusers.canupd=1
+				WHERE locations.usedforwo = 1";
 		$result = DB_query($sql,$db);
 
 		while ($myrow = DB_fetch_array($result)) {