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

[<vv...@us...>]

Revision: 4818
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4818&view=rev
Author:   vvs2012
Date:     2012-01-19 19:18:16 +0000 (Thu, 19 Jan 2012)
Log Message:
-----------
Added missing ')' at the end of some INSERT statements. 

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

Modified: trunk/Stocks.php
===================================================================
--- trunk/Stocks.php	2012-01-19 13:30:22 UTC (rev 4817)
+++ trunk/Stocks.php	2012-01-19 19:18:16 UTC (rev 4818)
@@ -417,7 +417,7 @@
 												'" . GetPeriod(Date($_SESSION['DefaultDateFormat']),$db,true) . "',
 												'" . $NewStockAccount . "',
 												'" . $StockID . ' ' . _('Change stock category') . "',
-												'" . ($UnitCost* $StockQtyRow[0]) . "'";
+												'" . ($UnitCost* $StockQtyRow[0]) . "')";
 					$ErrMsg =  _('The stock cost journal could not be inserted because');
 					$DbgMsg = _('The SQL that was used to create the stock cost journal and failed was');
 					$result = DB_query($SQL,$db, $ErrMsg, $DbgMsg,true);
@@ -434,7 +434,7 @@
 												'" . GetPeriod(Date($_SESSION['DefaultDateFormat']),$db,true) . "',
 												'" . $OldStockAccount . "',
 												'" . $StockID . ' ' . _('Change stock category') . "',
-												'" . (-$UnitCost* $StockQtyRow[0]) . "'";
+												'" . (-$UnitCost* $StockQtyRow[0]) . "')";
 					$result = DB_query($SQL,$db, $ErrMsg, $DbgMsg,true);
 				
 				} /* end if the stock category changed and forced a change in stock cost account */
@@ -472,7 +472,7 @@
 													'" . GetPeriod(Date($_SESSION['DefaultDateFormat']),$db,true) . "',
 													'" . $NewWIPAct . "',
 													'" . $StockID . ' ' . _('Change stock category') . "',
-													'" . $WIPValue . "'";
+													'" . $WIPValue . "')";
 						$ErrMsg =  _('The WIP cost journal could not be inserted because');
 						$DbgMsg = _('The SQL that was used to create the WIP cost journal and failed was');
 						$result = DB_query($SQL,$db, $ErrMsg, $DbgMsg,true);
@@ -489,7 +489,7 @@
 													'" . GetPeriod(Date($_SESSION['DefaultDateFormat']),$db,true) . "',
 													'" . $OldWIPAccount . "',
 													'" . $StockID . ' ' . _('Change stock category') . "',
-													'" . (-$WIPValue) . "'";
+													'" . (-$WIPValue) . "')";
 						$result = DB_query($SQL,$db, $ErrMsg, $DbgMsg,true);
 					}
 				} /* end if the stock category changed and forced a change in WIP account */
@@ -1207,4 +1207,4 @@
 echo '</div>
 	</form>';
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2012-01-19 13:30:22 UTC (rev 4817)
+++ trunk/doc/Change.log	2012-01-19 19:18:16 UTC (rev 4818)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+19/1/12 Vitaly: Added missing ')' at the end of some INSERT statements.
 19/1/12 Phil: Check on deletion of a location to see if any purchase orders exist prior to deletion
 19/1/12 Phil:StockCheck.php fixed error in SQL two ANDs in calculating quantity demand reported by Ricard
 19/1/12 Paul Harness: SelectOrderItems.php $i++ - in code for frequently ordered items.

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