[Weberp-svn] SF.net SVN: weberp:[4051] trunk

[<tim...@us...>]

Revision: 4051
          http://weberp.svn.sourceforge.net/weberp/?rev=4051&view=rev
Author:   tim_schofield
Date:     2011-01-08 15:01:33 +0000 (Sat, 08 Jan 2011)

Log Message:
-----------
Correct the quotes in the sql literals

Modified Paths:
--------------
    trunk/Z_ReApplyCostToSA.php
    trunk/Z_RePostGLFromPeriod.php

Modified: trunk/Z_ReApplyCostToSA.php
===================================================================
--- trunk/Z_ReApplyCostToSA.php	2011-01-08 15:01:21 UTC (rev 4050)
+++ trunk/Z_ReApplyCostToSA.php	2011-01-08 15:01:33 UTC (rev 4051)
@@ -13,10 +13,10 @@
 echo "<form method='POST' action='" . $_SERVER['PHP_SELF'] . '?' . SID . "'>";
 echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
 
-$SQL = 'SELECT MonthName(lastdate_in_period) AS mnth,
+$SQL = "SELECT MonthName(lastdate_in_period) AS mnth,
 		YEAR(lastdate_in_period) AS yr,
 		periodno
-	FROM periods';
+	FROM periods";
 echo '<p><div class="centre">' . _('Select the Period to update the costs for') . ":<select name='PeriodNo'>";
 $result = DB_query($SQL,$db);
 
@@ -34,12 +34,12 @@
 echo '</form>';
 
 if (isset($_POST['UpdateSalesAnalysis']) AND $_POST['PeriodNo']!=0){
-	$sql = 'SELECT stockmaster.stockid,
+	$sql = "SELECT stockmaster.stockid,
 			materialcost+overheadcost+labourcost AS standardcost,
 			stockmaster.mbflag
 		FROM salesanalysis INNER JOIN stockmaster
 			ON salesanalysis.stockid=stockmaster.stockid
-		WHERE periodno=' . $_POST['PeriodNo']  . "
+		WHERE periodno='" . $_POST['PeriodNo']  . "'
 		AND stockmaster.mbflag<>'D'
 		GROUP BY stockmaster.stockid,
 			stockmaster.materialcost,

Modified: trunk/Z_RePostGLFromPeriod.php
===================================================================
--- trunk/Z_RePostGLFromPeriod.php	2011-01-08 15:01:21 UTC (rev 4050)
+++ trunk/Z_RePostGLFromPeriod.php	2011-01-08 15:01:33 UTC (rev 4051)
@@ -19,9 +19,9 @@
                                  <td>' . _('Select Period From') . ":</td>
                                  <td><select Name='FromPeriod'>";
 
-	$sql = 'SELECT periodno,
+	$sql = "SELECT periodno,
                        lastdate_in_period
-                FROM periods ORDER BY periodno';
+                FROM periods ORDER BY periodno";
 	$Periods = DB_query($sql,$db);
 
 	while ($myrow=DB_fetch_array($Periods,$db)){
@@ -46,7 +46,7 @@
 	$sql = 'UPDATE chartdetails SET actual =0 WHERE period >= ' . $_POST['FromPeriod'];
 	$UpdActualChartDetails = DB_query($sql,$db);
 
-	$ChartDetailBFwdResult = DB_query('SELECT accountcode, bfwd FROM chartdetails WHERE period=' . $_POST['FromPeriod'],$db);
+	$ChartDetailBFwdResult = DB_query("SELECT accountcode, bfwd FROM chartdetails WHERE period='" . $_POST['FromPeriod'] . "'",$db);
 	while ($ChartRow=DB_fetch_array($ChartDetailBFwdResult)){
 		$sql = 'UPDATE chartdetails SET bfwd =' . $ChartRow['bfwd'] . ' WHERE period > ' . $_POST['FromPeriod'] . ' AND accountcode=' . $ChartRow['accountcode'];
 		$UpdActualChartDetails = DB_query($sql,$db);


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