web-erp-svn

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

[<dai...@us...>]

Revision: 5761
          http://sourceforge.net/p/web-erp/reponame/5761
Author:   daintree
Date:     2012-12-15 04:56:05 +0000 (Sat, 15 Dec 2012)
Log Message:
-----------
Customer login error check that they do not update URL GET orderno to view other peoples orders

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

Modified: trunk/OrderDetails.php
===================================================================
--- trunk/OrderDetails.php	2012-12-15 04:47:29 UTC (rev 5760)
+++ trunk/OrderDetails.php	2012-12-15 04:56:05 UTC (rev 5761)
@@ -59,6 +59,12 @@
 	$myrow = DB_fetch_array($GetOrdHdrResult);
 	$CurrDecimalPlaces = $myrow['decimalplaces'];
 	
+	if ($CustomerLogin ==1 AND $myrow['debtorno']!= $_SESSION['CustomerID']) {
+		prnMsg (_('Your customer login will only allow you to view your own purchase orders'),'error');
+		include('includes/footer.inc');
+		exit;
+	}
+	
 	echo '<table class="selection">
 			<tr>
 				<th colspan="4"><h3>'._('Order Header Details For Order No').' '.$_GET['OrderNumber'].'</h3></th>

[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
+?>

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

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

Revision: 7621
          http://sourceforge.net/p/web-erp/reponame/7621
Author:   exsonqu
Date:     2016-09-14 09:04:41 +0000 (Wed, 14 Sep 2016)
Log Message:
-----------
14/09/16: Exson: Add order line narrative and invoices link to sales order inquiry in OrderDetails.php.

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

Modified: trunk/OrderDetails.php
===================================================================
--- trunk/OrderDetails.php	2016-09-13 08:08:29 UTC (rev 7620)
+++ trunk/OrderDetails.php	2016-09-14 09:04:41 UTC (rev 7621)
@@ -64,7 +64,17 @@
 		include('includes/footer.inc');
 		exit;
 	}
+	//retrieve invoice number
+	$Invs = explode(' Inv ',$myrow['comments']);
+	$Inv = '';
+	foreach ($Invs as $value) {
+		if (is_numeric($value)) {
+			$Inv .= '<a href="' . $RootPath . '/PrintCustTrans.php?FromTransNo=' . $value . '&InvOrCredit=Invoice">'.$value.'</a>  ';
+		}
+	}
 
+
+
 	echo '<table class="selection">
 			<tr>
 				<th colspan="4"><h3>' . _('Order Header Details For Order No').' '.$_GET['OrderNumber'] . '</h3></th>
@@ -125,6 +135,9 @@
 				<th style="text-align: left">' . _('Comments'). ': </th>
 				<td colspan="3">' . $myrow['comments'] . '</td>
 			</tr>
+			<tr>	<th style="text-align: left">' . _('Invoices') . ': </th>
+				<td colspan="3">' . $Inv . '</td>
+			</tr>
 			</table>';
 }
 
@@ -146,7 +159,8 @@
 							actualdispatchdate,
 							qtyinvoiced,
 							itemdue,
-							poline
+							poline,
+							narrative
 						FROM salesorderdetails INNER JOIN stockmaster
 						ON salesorderdetails.stkcode = stockmaster.stockid
 						WHERE orderno ='" . $_GET['OrderNumber'] . "'";
@@ -177,6 +191,7 @@
 				<th>' . _('Total') . '</th>
 				<th>' . _('Qty Del') . '</th>
 				<th>' . _('Last Del') . '/' . _('Due Date') . '</th>
+				<th>' . _('Narrative') . '</th>
 			</tr>';
 		$k=0;
 		while ($myrow=DB_fetch_array($LineItemsResult)) {
@@ -205,6 +220,7 @@
 				<td class="number">' . locale_number_format($myrow['quantity'] * $myrow['unitprice'] * (1 - $myrow['discountpercent']),$CurrDecimalPlaces) . '</td>
 				<td class="number">' . locale_number_format($myrow['qtyinvoiced'],$myrow['decimalplaces']) . '</td>
 				<td>' . $DisplayActualDeliveryDate . '</td>
+				<td>' . $myrow['narrative'] . '</td>
 			</tr>';
 
 			$OrderTotal += ($myrow['quantity'] * $myrow['unitprice'] * (1 - $myrow['discountpercent']));