[Web-erp-svn] SF.net SVN: web-erp:[7471] trunk/WorkOrderEntry.php

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

Revision: 7471
          http://sourceforge.net/p/web-erp/reponame/7471
Author:   exsonqu
Date:     2016-03-09 08:26:50 +0000 (Wed, 09 Mar 2016)
Log Message:
-----------
09/03/16 Exson: Fix the bug of wrong location selected when add items to the workorders in WorkOrderEntry.php.

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

Modified: trunk/WorkOrderEntry.php
===================================================================
--- trunk/WorkOrderEntry.php	2016-03-09 08:09:37 UTC (rev 7470)
+++ trunk/WorkOrderEntry.php	2016-03-09 08:26:50 UTC (rev 7471)
@@ -284,7 +284,7 @@
 									INNER JOIN bom
 										ON stockmaster.stockid=bom.component
 									WHERE bom.parent='" . $NewItem . "'
-										AND bom.loccode='" . $_POST['StockLocation'] . "'
+										AND bom.loccode=(SELECT loccode FROM workorders WHERE wo='" . $_POST['WO'] . "')
 										AND bom.effectiveafter<='" . Date('Y-m-d') . "'
 										AND bom.effectiveto>='" . Date('Y-m-d') . "'");
 		$CostRow = DB_fetch_array($CostResult);