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

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

Revision: 4848
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4848&view=rev
Author:   daintree
Date:     2012-01-29 03:23:11 +0000 (Sun, 29 Jan 2012)
Log Message:
-----------
fix Z_ChangeStockCode.php for SalesCategories

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

Modified: trunk/Z_ChangeStockCode.php
===================================================================
--- trunk/Z_ChangeStockCode.php	2012-01-29 03:10:08 UTC (rev 4847)
+++ trunk/Z_ChangeStockCode.php	2012-01-29 03:23:11 UTC (rev 4848)
@@ -285,7 +285,13 @@
 		$result = DB_query($sql,$db,$ErrMsg,$DbgMsg,true);
 		echo ' ... ' . _('completed');
 	
+		echo '<br />' . _('Changing sales category information');
+		$sql = "UPDATE salescatprod SET stockid='" . $_POST['NewStockID'] . "' WHERE stockid='" . $_POST['OldStockID'] . "'";
+		$ErrMsg = _('The SQL to update the sales category records failed');
+		$result = DB_query($sql,$db,$ErrMsg,$DbgMsg,true);
+		echo ' ... ' . _('completed');
 	
+	
 		echo '<br />' . _('Changing any serialised item information');
 	
 	
@@ -297,6 +303,8 @@
 		$result = DB_query($sql,$db,$ErrMsg,$DbgMsg,true);
 		echo ' ... ' . _('completed');
 		
+			
+		
 		DB_ReinstateForeignKeys($db);
 		
 		$result = DB_Txn_Commit($db);

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2012-01-29 03:10:08 UTC (rev 4847)
+++ trunk/doc/Change.log	2012-01-29 03:23:11 UTC (rev 4848)
@@ -1,5 +1,7 @@
 webERP Change Log
 
+29/1/12 Phil: Alterations to API to fix SQL and to start work on adding InvoiceSalesOrder method
+29/1/12 Phil: Z_ChangeStockCode.php now alters SalesCategories of items being changed
 28/1/12 Ahmed.Fawzy: StockCategories.php fixes for numericvalue not displaying and errored with "minimum value is not numeric"
 28/1/12 Phil: ConfirmDispatch_Invoice.php corrected link to ConfirmDispatchControlled_Invoice.php to send $identifier to get the correct session variable containing the order to invoice
 28/1/12 Tim: SpecialOrder.php added $identifier to session class variable to avoid overlapping sessions in multiple tabs.

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