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

[<te...@us...>]

Revision: 5444
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5444&view=rev
Author:   tehonu
Date:     2012-06-20 08:52:04 +0000 (Wed, 20 Jun 2012)
Log Message:
-----------
Ricard: Added total QOH to NoSalesItems.php

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

Modified: trunk/NoSalesItems.php
===================================================================
--- trunk/NoSalesItems.php	2012-06-20 02:43:30 UTC (rev 5443)
+++ trunk/NoSalesItems.php	2012-06-20 08:52:04 UTC (rev 5444)
@@ -1,6 +1,6 @@
 <?php
 
-/* $Id: NoSalesItems.php 2012-05-12 Kapal Laut $*/
+/* $Id: NoSalesItems.php 2012-05-12 $*/
 
 /* Session started in session.inc for password checking and authorisation level check
 config.php is in turn included in session.inc*/
@@ -146,7 +146,7 @@
 	$SQL = $SQL. "ORDER BY stockmaster.stockid";	
 	$result = DB_query($SQL, $db);		
 	echo '<p class="page_title_text" align="center"><strong>' . _('No Sales Items') . '</strong></p>';
-	echo '<form action="PDFNoSalesItems2.php"  method="GET">
+	echo '<form action="PDFNoSalesItems.php"  method="GET">
 		<table class="selection">';
 	echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
 	$TableHeader = '<tr>
@@ -154,7 +154,8 @@
 						<th>' . _('Location') . '</th>
 						<th>' . _('Code') . '</th>
 						<th>' . _('Description') . '</th>
-						<th>' . _('On Hand') . '</th>
+						<th>' . _('Location QOH') . '</th>
+						<th>' . _('Total QOH') . '</th>
 						<th>' . _('Units') . '</th>		
 					</tr>';
 	echo $TableHeader;
@@ -171,18 +172,28 @@
 			echo '<tr class="OddTableRows">';
 			$k = 1;
 		}
+		$QOHResult = DB_query("SELECT sum(quantity)
+				FROM locstock
+				WHERE stockid = '" . $myrow['stockid'] . "'", $db);
+		$QOHRow = DB_fetch_row($QOHResult);
+		$QOH = $QOHRow[0];
+
+		$CodeLink = '<a href="' . $rootpath . '/SelectProduct.php?StockID=' . $myrow['stockid'] . '">' . $myrow['stockid'] . '</a>';
+
 		printf('<td class="number">%s</td>
 				<td>%s</td>
 				<td>%s</td>
 				<td>%s</td>
 				<td class="number">%s</td>	
 				<td class="number">%s</td>
+				<td>%s</td>
 				</tr>', 
 				$i,
 				$myrow['locationname'], 
-				$myrow['0'], 				
+				$CodeLink, 				
 				$myrow['description'], 
-				$myrow['quantity'], //onhand
+				$myrow['quantity'], //on hand on location selected only
+				$QOH, // total on hand 
 				$myrow['units'] //unit			
 				);
 		$i++;

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2012-06-20 02:43:30 UTC (rev 5443)
+++ trunk/doc/Change.log	2012-06-20 08:52:04 UTC (rev 5444)
@@ -1,4 +1,5 @@
 webERP Change Log
+20/06/2012 Ricard: Added total QOH to NoSalesItems.php. 
 20/06/2012 Ricard: Added opposite currency pair graph to ExchangeRateTrend.php. 
 19/06/2012 Ricard: Added new script Z_ChangeLocationCode. 
 17/06/2012 Ricard: Added a 2nd strategy for StockDispatch (items with overstock at FROM, RL=0 no matter if needed at TO). 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.