[Web-erp-svn] SF.net SVN: web-erp:[6920] trunk/OrderDetails.php

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

Revision: 6920
          http://sourceforge.net/p/web-erp/reponame/6920
Author:   exsonqu
Date:     2014-10-17 06:21:51 +0000 (Fri, 17 Oct 2014)
Log Message:
-----------
17/10/14 Exson: Add po line and due date result in OrderDetails.php.

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

Modified: trunk/OrderDetails.php
===================================================================
--- trunk/OrderDetails.php	2014-10-15 08:28:15 UTC (rev 6919)
+++ trunk/OrderDetails.php	2014-10-17 06:21:51 UTC (rev 6920)
@@ -144,7 +144,9 @@
 							quantity,
 							discountpercent,
 							actualdispatchdate,
-							qtyinvoiced
+							qtyinvoiced,
+							itemdue,
+							poline
 						FROM salesorderdetails INNER JOIN stockmaster
 						ON salesorderdetails.stkcode = stockmaster.stockid
 						WHERE orderno ='" . $_GET['OrderNumber'] . "'";
@@ -165,6 +167,7 @@
 				<th colspan="9"><h3>' . _('Order Line Details For Order No').' '.$_GET['OrderNumber'] . '</h3></th>
 			</tr>
 			<tr>
+				<th>' . _('PO Line') . '</th>
 				<th>' . _('Item Code') . '</th>
 				<th>' . _('Item Description') . '</th>
 				<th>' . _('Quantity') . '</th>
@@ -173,7 +176,7 @@
 				<th>' . _('Discount') . '</th>
 				<th>' . _('Total') . '</th>
 				<th>' . _('Qty Del') . '</th>
-				<th>' . _('Last Del') . '</th>
+				<th>' . _('Last Del') . '/' . _('Due Date') . '</th>
 			</tr>';
 		$k=0;
 		while ($myrow=DB_fetch_array($LineItemsResult)) {
@@ -189,10 +192,11 @@
 			if ($myrow['qtyinvoiced']>0){
 				$DisplayActualDeliveryDate = ConvertSQLDate($myrow['actualdispatchdate']);
 			} else {
-		  		$DisplayActualDeliveryDate = _('N/A');
+		  		$DisplayActualDeliveryDate = '<span style="color:red;">' . ConvertSQLDate($myrow['itemdue']) . '</span>';
 			}
 
-			echo 	'<td>' . $myrow['stkcode'] . '</td>
+			echo 	'<td>' . $myrow['poline'] . '</td>
+				<td>' . $myrow['stkcode'] . '</td>
 				<td>' . $myrow['description'] . '</td>
 				<td class="number">' . $myrow['quantity'] . '</td>
 				<td>' . $myrow['units'] . '</td>
@@ -230,4 +234,4 @@
 	}
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>