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

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

Revision: 6876
          http://sourceforge.net/p/web-erp/reponame/6876
Author:   tehonu
Date:     2014-09-11 09:39:28 +0000 (Thu, 11 Sep 2014)
Log Message:
-----------
More on "used for WO Productions" flag

Modified Paths:
--------------
    trunk/WorkOrderIssue.php
    trunk/WorkOrderReceive.php

Modified: trunk/WorkOrderIssue.php
===================================================================
--- trunk/WorkOrderIssue.php	2014-09-11 09:34:57 UTC (rev 6875)
+++ trunk/WorkOrderIssue.php	2014-09-11 09:39:28 UTC (rev 6876)
@@ -581,8 +581,12 @@
 		<td>';
 
 if (!isset($_POST['IssueItem'])){
-	$LocResult = DB_query("SELECT locations.loccode, locationname FROM locations
-								INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canupd=1",$db);
+	$LocResult = DB_query("SELECT locations.loccode,locationname 
+							FROM locations
+							INNER JOIN locationusers 
+								ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' 
+								AND locationusers.canupd=1
+							WHERE locations.usedforwo = 1",$db);
 
 	echo '<select name="FromLocation">';
 

Modified: trunk/WorkOrderReceive.php
===================================================================
--- trunk/WorkOrderReceive.php	2014-09-11 09:34:57 UTC (rev 6875)
+++ trunk/WorkOrderReceive.php	2014-09-11 09:39:28 UTC (rev 6876)
@@ -847,7 +847,12 @@
 if (!isset($_POST['IntoLocation'])){
 		$_POST['IntoLocation']=$WORow['loccode'];
 }
-$LocResult = DB_query("SELECT locations.loccode, locationname FROM locations INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canupd=1",$db);
+$LocResult = DB_query("SELECT locations.loccode,locationname 
+						FROM locations
+						INNER JOIN locationusers 
+							ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' 
+							AND locationusers.canupd=1
+						WHERE locations.usedforwo = 1",$db);
 while ($LocRow = DB_fetch_array($LocResult)){
 	if ($_POST['IntoLocation'] ==$LocRow['loccode']){
 		echo '<option selected="selected" value="' . $LocRow['loccode'] .'">' . $LocRow['locationname'] . '</option>';