[Web-erp-svn] SF.net SVN: web-erp:[7962] trunk

[<tu...@us...>]

Revision: 7962
          http://sourceforge.net/p/web-erp/reponame/7962
Author:   turbopt
Date:     2018-02-16 07:11:14 +0000 (Fri, 16 Feb 2018)
Log Message:
-----------
Paul Becker (PaulT commit): AgedControlledInventory.php: Add UOM to output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8091&pid=14286#pid14286)

Modified Paths:
--------------
    trunk/AgedControlledInventory.php
    trunk/doc/Change.log

Modified: trunk/AgedControlledInventory.php
===================================================================
--- trunk/AgedControlledInventory.php	2018-02-16 06:51:24 UTC (rev 7961)
+++ trunk/AgedControlledInventory.php	2018-02-16 07:11:14 UTC (rev 7962)
@@ -11,8 +11,7 @@
 include('includes/header.php');
 
 echo '<p class="page_title_text">
-		<img src="'.$RootPath.'/css/'.$Theme.'/images/inventory.png" title="' . _('Inventory') .
-'" alt="" /><b>' . $Title. '</b>
+		<img src="', $RootPath, '/css/', $Theme, '/images/inventory.png" title="', _('Inventory'), '" alt="" /><b>', $Title, '</b>
 	</p>';
 
 $sql = "SELECT stockserialitems.stockid,
@@ -20,6 +19,7 @@
 				stockserialitems.serialno,
 				stockserialitems.quantity,
 				stockmoves.trandate,
+				stockmaster.units,
 				stockmaster.materialcost+stockmaster.labourcost+stockmaster.overheadcost AS cost,
 				createdate,
 				decimalplaces
@@ -46,24 +46,25 @@
 
 echo '<table>
 		<tr>
-			<th class="ascending">' . _('Stock') . '</th>
-			<th class="ascending">' . _('Description') . '</th>
-			<th class="ascending">' . _('Batch') . '</th>
-			<th class="ascending">' . _('Quantity Remaining') . '</th>
-			<th class="ascending">' . _('Inventory Value') . '</th>
-			<th class="ascending">' . _('Date') . '</th>
-			<th class="ascending">' . _('Days Old') . '</th>
+			<th class="ascending">', _('Stock'), '</th>
+			<th class="ascending">', _('Description'), '</th>
+			<th class="ascending">', _('Batch'), '</th>
+			<th class="ascending">', _('Quantity Remaining'), '</th>
+			<th class="ascending">', _('Units'), '</th>
+			<th class="ascending">', _('Inventory Value'), '</th>
+			<th class="ascending">', _('Date'), '</th>
+			<th class="ascending">', _('Days Old'), '</th>
 		</tr>';
 
 while ($LocQtyRow=DB_fetch_array($LocStockResult)) {
 
-	$DaysOld=floor(($Today - strtotime($LocQtyRow['createdate']))/(60*60*24));
-	$TotalQty +=$LocQtyRow['quantity'];
+	$DaysOld = floor(($Today - strtotime($LocQtyRow['createdate']))/(60*60*24));
+	$TotalQty += $LocQtyRow['quantity'];
 	$DispVal =  '-----------';
 
 	if (in_array($PricesSecurity, $_SESSION['AllowedPageSecurityTokens']) OR !isset($PricesSecurity)) {
-		$DispVal =locale_number_format(($LocQtyRow['quantity']*$LocQtyRow['cost']),$LocQtyRow['decimalplaces']);
-		$TotalVal +=($LocQtyRow['quantity'] *$LocQtyRow['cost']);
+		$DispVal = locale_number_format(($LocQtyRow['quantity']*$LocQtyRow['cost']),$LocQtyRow['decimalplaces']);
+		$TotalVal += ($LocQtyRow['quantity'] * $LocQtyRow['cost']);
 	}
 
 	printf('<tr class="striped_row">
@@ -71,6 +72,7 @@
 			<td>%s</td>
 			<td>%s</td>
 			<td class="number">%s</td>
+			<td>%s</td>
 			<td class="number">%s</td>
 			<td>%s</td>
 			<td class="number">%s</td>
@@ -79,6 +81,7 @@
 			$LocQtyRow['description'],
 			$LocQtyRow['serialno'],
 			locale_number_format($LocQtyRow['quantity'],$LocQtyRow['decimalplaces']),
+			$LocQtyRow['units'],
 			$DispVal,
 			ConvertSQLDate($LocQtyRow['createdate']),
 			$DaysOld
@@ -87,9 +90,9 @@
 
 echo '<tfoot>
 			<tr class="striped_row">
-				<td colspan="3"><b>' . _('Total') . '</b></td>
-				<td class="number"><b>' . locale_number_format($TotalQty,2) . '</b></td>
-				<td class="number"><b>' . locale_number_format($TotalVal,2) . '</b></td>
+				<td colspan="3"><b>', _('Total'), '</b></td>
+				<td class="number"><b>', locale_number_format($TotalQty,2), '</b></td>
+				<td class="number"><b>', locale_number_format($TotalVal,2), '</b></td>
 				<td colspan="2"></td>
 			</tr>
 		</tfoot>

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2018-02-16 06:51:24 UTC (rev 7961)
+++ trunk/doc/Change.log	2018-02-16 07:11:14 UTC (rev 7962)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+16/2/18  Paul Becker (PaulT commit): AgedControlledInventory.php: Add UOM to output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8091&pid=14286#pid14286)
 16/2/18  Paul Becker (PaulT commit): Z_ChangeSalesmanCode.php: New script to change a salesman code. (Forum contribution: http://www.weberp.org/forum/showthread.php?tid=8094)
 13/2/18  Paul Becker (PaulT commit): InternalStockRequestFulfill.php: Minor change to remove number from input field committed with 7946, and add attributes on two input fields. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8089&pid=14266#pid14266)
 12/2/18  PaulT: Remove $db parameter from PeriodExists(), CreatePeriod(), CalcFreightCost(), CheckForRecursiveBOM(), DisplayBOMItems() and a few other functions.