web-erp-svn

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

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

Revision: 7223
          http://sourceforge.net/p/web-erp/reponame/7223
Author:   exsonqu
Date:     2015-03-13 02:31:54 +0000 (Fri, 13 Mar 2015)
Log Message:
-----------
13/03/15 Exson: Fixed the undefined index noise in SelectWorkOrder.php.

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

Modified: trunk/SelectWorkOrder.php
===================================================================
--- trunk/SelectWorkOrder.php	2015-03-13 02:30:47 UTC (rev 7222)
+++ trunk/SelectWorkOrder.php	2015-03-13 02:31:54 UTC (rev 7223)
@@ -158,11 +158,11 @@
 		echo '</select> &nbsp;&nbsp;
 			<select name="ClosedOrOpen">';
 
-		if ($_GET['ClosedOrOpen']=='Closed_Only'){
+		if (isset($_GET['ClosedOrOpen']) AND $_GET['ClosedOrOpen']=='Closed_Only'){
 			$_POST['ClosedOrOpen']='Closed_Only';
 		}
 
-		if ($_POST['ClosedOrOpen']=='Closed_Only'){
+		if (isset($_POST['ClosedOrOpen']) AND $_POST['ClosedOrOpen']=='Closed_Only'){
 			echo '<option selected="selected" value="Closed_Only">' . _('Closed Work Orders Only') . '</option>';
 			echo '<option value="Open_Only">' . _('Open Work Orders Only')  . '</option>';
 		} else {
@@ -400,4 +400,4 @@
 }
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

[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']),