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

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

Revision: 4800
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4800&view=rev
Author:   daintree
Date:     2012-01-16 09:24:14 +0000 (Mon, 16 Jan 2012)
Log Message:
-----------
StockReorderLevel only updates changed fields

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

Modified: trunk/StockReorderLevel.php
===================================================================
--- trunk/StockReorderLevel.php	2012-01-15 06:53:30 UTC (rev 4799)
+++ trunk/StockReorderLevel.php	2012-01-16 09:24:14 UTC (rev 4800)
@@ -70,10 +70,11 @@
 	}
 
 	if (isset($_POST['UpdateData']) 
+		AND $_POST['Old_' . $myrow['loccode']]!= filter_number_format($_POST[$myrow['loccode']]) 
 		AND is_numeric(filter_number_format($_POST[$myrow['loccode']])) 
-		AND $_POST[$myrow['loccode']]>=0){
+		AND filter_number_format($_POST[$myrow['loccode']])>=0){
 
-	   $myrow['reorderlevel'] = $_POST[$myrow['loccode']];
+	   $myrow['reorderlevel'] = filter_number_format($_POST[$myrow['loccode']]);
 	   $sql = "UPDATE locstock SET reorderlevel = '" . filter_number_format($_POST[$myrow['loccode']]) . "'
 	   		WHERE stockid = '" . $StockID . "'
 			AND loccode = '"  . $myrow['loccode'] ."'";
@@ -83,10 +84,13 @@
 
 	printf('<td>%s</td>
 			<td class="number">%s</td>
-			<td><input type="text" class="number" name="%s" maxlength="10" size="10" value="%s" /></td>',
+			<td><input type="text" class="number" name="%s" maxlength="10" size="10" value="%s" /></td>
+			<input type="hidden" name="Old_%s" value="%s" />',
 			$myrow['locationname'],
 			locale_number_format($myrow['quantity'],$myrow['decimalplaces']),
 			$myrow['loccode'],
+			$myrow['reorderlevel'],
+			$myrow['loccode'],
 			$myrow['reorderlevel']);
 	$j++;
 	If ($j == 12){

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2012-01-15 06:53:30 UTC (rev 4799)
+++ trunk/doc/Change.log	2012-01-16 09:24:14 UTC (rev 4800)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+16/1/12 Phil: Made StockReorderLevel.php just update changed fields rather than update all locations even though they may not have changed.
 8/1/12 Phil: Added new api functions to get tax group taxes, list tax authorities, get tax authority details and get tax authority tax rates, also to list and get payment methods
 8/1/12 Paul Harness: PcAuthorizeExpenses.php Compare date against SQL raw date format, then convert for display when deciding to display authorize checkbox.
 8/1/12 Paul Harness: PcClaimExpensesFromTab.php Use DefaultDateFormat for date in expense entry.

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