[Web-erp-svn] SF.net SVN: web-erp:[7694] trunk/SelectWorkOrder.php

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

Revision: 7694
          http://sourceforge.net/p/web-erp/reponame/7694
Author:   exsonqu
Date:     2016-12-02 12:57:29 +0000 (Fri, 02 Dec 2016)
Log Message:
-----------
02/12/16 Exson: Add location code and reference to Work Orders search result in SelectWorkOrder.php.

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

Modified: trunk/SelectWorkOrder.php
===================================================================
--- trunk/SelectWorkOrder.php	2016-12-02 08:48:17 UTC (rev 7693)
+++ trunk/SelectWorkOrder.php	2016-12-02 12:57:29 UTC (rev 7694)
@@ -266,7 +266,9 @@
 								woitems.qtyreqd,
 								woitems.qtyrecd,
 								workorders.requiredby,
-								workorders.startdate
+								workorders.startdate,
+								workorders.reference,
+								workorders.loccode
 						FROM workorders
 						INNER JOIN woitems ON workorders.wo=woitems.wo
 						INNER JOIN stockmaster ON woitems.stockid=stockmaster.stockid
@@ -286,7 +288,9 @@
 									woitems.qtyreqd,
 									woitems.qtyrecd,
 									workorders.requiredby,
-									workorders.startdate
+									workorders.startdate,
+									workorders.reference,
+									workorders.loccode
 							FROM workorders
 							INNER JOIN woitems ON workorders.wo=woitems.wo
 							INNER JOIN stockmaster ON woitems.stockid=stockmaster.stockid
@@ -304,7 +308,9 @@
 									woitems.qtyreqd,
 									woitems.qtyrecd,
 									workorders.requiredby,
-									workorders.startdate
+									workorders.startdate,
+									workorders.reference,
+									workorders.loccode
 							FROM workorders
 							INNER JOIN woitems ON workorders.wo=woitems.wo
 							INNER JOIN locationusers ON locationusers.loccode=workorders.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1
@@ -330,6 +336,7 @@
 					<th>' . _('Receive') . '</th>
 					<th>' . _('Costing') . '</th>
 					<th>' . _('Paperwork') . '</th>
+					<th>' . _('Location') . '</th>
 					<th class="ascending">' . _('Item') . '</th>
 					<th class="ascending">' . _('Quantity Required') . '</th>
 					<th class="ascending">' . _('Quantity Received') . '</th>
@@ -366,6 +373,7 @@
 					<td><a href="%s">' . _('Receive') . '</a></td>
 					<td><a href="%s">' . _('Costing') . '</a></td>
 					<td><a href="%s">' . _('Print W/O') . '</a></td>
+					<td>%s</td>
 					<td>%s - %s</td>
 					<td class="number">%s</td>
 					<td class="number">%s</td>
@@ -374,12 +382,13 @@
 					<td>%s</td>
 					</tr>',
 					$ModifyPage,
-					$myrow['wo'],
+					$myrow['wo'].'['.$myrow['reference'] . ']',
 					$Status_WO,
 					$Issue_WO,
 					$Receive_WO,
 					$Costing_WO,
 					$Printing_WO,
+					$myrow['loccode'],
 					$myrow['stockid'],
 					$myrow['description'],
 					locale_number_format($myrow['qtyreqd'],$myrow['decimalplaces']),