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

[<sot...@us...>]

Revision: 4193
          http://weberp.svn.sourceforge.net/weberp/?rev=4193&view=rev
Author:   sotandeka
Date:     2011-01-09 12:12:33 +0000 (Sun, 09 Jan 2011)

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

Modified Paths:
--------------
    trunk/COGSGLPostings.php
    trunk/ConfirmDispatch_Invoice.php
    trunk/CounterSales.php
    trunk/CreditStatus.php
    trunk/Currencies.php

Modified: trunk/COGSGLPostings.php
===================================================================
--- trunk/COGSGLPostings.php	2011-01-09 11:57:43 UTC (rev 4192)
+++ trunk/COGSGLPostings.php	2011-01-09 12:12:33 UTC (rev 4193)
@@ -76,14 +76,14 @@
 
 	$ShowLivePostingRecords = true;
 
-	$sql = 'SELECT cogsglpostings.id,
+	$sql = "SELECT cogsglpostings.id,
 			cogsglpostings.area,
 			cogsglpostings.stkcat,
 			cogsglpostings.salestype,
 			chartmaster.accountname
 		FROM cogsglpostings LEFT JOIN chartmaster
 			ON cogsglpostings.glcode = chartmaster.accountcode
-				WHERE chartmaster.accountcode IS NULL';
+				WHERE chartmaster.accountcode IS NULL";
 
 	$result = DB_query($sql,$db);
 	if (DB_num_rows($result)>0){
@@ -124,11 +124,11 @@
 		echo '</table>';
 	}
 
-	$sql = 'SELECT cogsglpostings.id,
+	$sql = "SELECT cogsglpostings.id,
 			cogsglpostings.area,
 			cogsglpostings.stkcat,
 			cogsglpostings.salestype
-		FROM cogsglpostings';
+		FROM cogsglpostings";
 
 	$result = DB_query($sql,$db);
 
@@ -152,7 +152,7 @@
 
 			$result = DB_query($sql,$db);
 		}
-		$sql = 'SELECT accountcode FROM chartmaster WHERE accountcode =1';
+		$sql = "SELECT accountcode FROM chartmaster WHERE accountcode =1";
 		$result = DB_query($sql,$db);
 		if (DB_num_rows($result)==0){
 		/* account number 1 is not used, so insert a new account */
@@ -182,14 +182,14 @@
 	}
 
 	if ($ShowLivePostingRecords){
-		$sql = 'SELECT cogsglpostings.id,
+		$sql = "SELECT cogsglpostings.id,
 				cogsglpostings.area,
 				cogsglpostings.stkcat,
 				cogsglpostings.salestype,
 				chartmaster.accountname
 			FROM cogsglpostings,
 				chartmaster
-			WHERE cogsglpostings.glcode = chartmaster.accountcode';
+			WHERE cogsglpostings.glcode = chartmaster.accountcode";
 
 		$result = DB_query($sql,$db);
 
@@ -283,7 +283,7 @@
 } //end while loop
 DB_free_result($result);
 
-$sql = 'SELECT categoryid, categorydescription FROM stockcategory';
+$sql = "SELECT categoryid, categorydescription FROM stockcategory";
 $result = DB_query($sql,$db);
 
 echo "</select></td></tr><tr><td>" . _('Stock Category') . ":</td><td><select tabindex=2 name='StkCat'>
@@ -301,7 +301,7 @@
 
 DB_free_result($result);
 
-$sql = 'SELECT typeabbrev, sales_type FROM salestypes';
+$sql = "SELECT typeabbrev, sales_type FROM salestypes";
 $result = DB_query($sql,$db);
 
 echo "</select></td></tr><tr><td>" . _('Sales Type') . " / " . _('Price List') . ":</td>
@@ -347,4 +347,4 @@
 echo "<br><div class='centre'><input tabindex=5 type='Submit' name='submit' value=" . _('Enter Information') . "></form></div>";
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/ConfirmDispatch_Invoice.php
===================================================================
--- trunk/ConfirmDispatch_Invoice.php	2011-01-09 11:57:43 UTC (rev 4192)
+++ trunk/ConfirmDispatch_Invoice.php	2011-01-09 12:12:33 UTC (rev 4193)
@@ -36,7 +36,7 @@
 
 /*read in all the guff from the selected order into the Items cart  */
 
-	$OrderHeaderSQL = 'SELECT salesorders.orderno,
+	$OrderHeaderSQL = "SELECT salesorders.orderno,
 														salesorders.debtorno,
 														debtorsmaster.name,
 														salesorders.branchcode,
@@ -73,7 +73,7 @@
 												AND salesorders.debtorno = custbranch.debtorno
 												AND locations.loccode=salesorders.fromstkloc
 												AND debtorsmaster.currcode = currencies.currabrev
-												AND salesorders.orderno = "' . $_GET['OrderNumber'].'"';
+												AND salesorders.orderno = '" . $_GET['OrderNumber']."'";
 
 	$ErrMsg = _('The order cannot be retrieved because');
 	$DbgMsg = _('The SQL to get the order header was');
@@ -122,7 +122,7 @@
 
 /*now populate the line items array with the sales order details records */
 
-		$LineItemsSQL = 'SELECT stkcode,
+		$LineItemsSQL = "SELECT stkcode,
 					stockmaster.description,
 					stockmaster.controlled,
 					stockmaster.serialised,
@@ -147,9 +147,9 @@
 						stockmaster.overheadcost AS standardcost
 				FROM salesorderdetails INNER JOIN stockmaster
 				 	ON salesorderdetails.stkcode = stockmaster.stockid
-				WHERE salesorderdetails.orderno ="' . $_GET['OrderNumber'] . '"
+				WHERE salesorderdetails.orderno ='" . $_GET['OrderNumber'] . "'
 				AND salesorderdetails.quantity - salesorderdetails.qtyinvoiced >0
-				ORDER BY salesorderdetails.orderlineno';
+				ORDER BY salesorderdetails.orderlineno";
 
 		$ErrMsg = _('The line items of the order cannot be retrieved because');
 		$DbgMsg = _('The SQL that failed was');
@@ -420,13 +420,13 @@
 		$FreightCost =0;
   	}
   	if (!is_numeric($BestShipper)){
-  		$SQL =  'SELECT shipper_id FROM shippers WHERE shipper_id=' . $_SESSION['Default_Shipper'];
+  		$SQL =  "SELECT shipper_id FROM shippers WHERE shipper_id=" . $_SESSION['Default_Shipper'];
 		$ErrMsg = _('There was a problem testing for a default shipper because');
 		$TestShipperExists = DB_query($SQL,$db, $ErrMsg);
 		if (DB_num_rows($TestShipperExists)==1){
 			$BestShipper = $_SESSION['Default_Shipper'];
 		} else {
-			$SQL =  'SELECT shipper_id FROM shippers';
+			$SQL =  "SELECT shipper_id FROM shippers";
 			$ErrMsg = _('There was a problem testing for a default shipper');
 			$TestShipperExists = DB_query($SQL,$db, $ErrMsg);
 			if (DB_num_rows($TestShipperExists)>=1){
@@ -1659,4 +1659,4 @@
 echo '</form>';
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/CounterSales.php
===================================================================
--- trunk/CounterSales.php	2011-01-09 11:57:43 UTC (rev 4192)
+++ trunk/CounterSales.php	2011-01-09 12:12:33 UTC (rev 4193)
@@ -786,7 +786,7 @@
 	echo '</td><th valign="bottom">'; //for the master table
 	echo '<table class="selection">'; // a new nested table in the second column of master table
 	//now the payment stuff in this column
-	$PaymentMethodsResult = DB_query('SELECT paymentid, paymentname FROM paymentmethods',$db);
+	$PaymentMethodsResult = DB_query("SELECT paymentid, paymentname FROM paymentmethods",$db);
 
 	echo '<tr><td>' . _('Payment Type') . ':</td><td><select name="PaymentMethod">';
 	while ($PaymentMethodRow = DB_fetch_array($PaymentMethodsResult)){
@@ -798,7 +798,7 @@
 	}
 	echo '</select></td></tr>';
 
-	$BankAccountsResult = DB_query('SELECT bankaccountname, accountcode FROM bankaccounts',$db);
+	$BankAccountsResult = DB_query("SELECT bankaccountname, accountcode FROM bankaccounts",$db);
 
 	echo '<tr><td>' . _('Banked to') . ':</td><td><select name="BankAccount">';
 	while ($BankAccountsRow = DB_fetch_array($BankAccountsResult)){
@@ -2300,4 +2300,4 @@
 }
 echo '</form>';
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>

Modified: trunk/CreditStatus.php
===================================================================
--- trunk/CreditStatus.php	2011-01-09 11:57:43 UTC (rev 4192)
+++ trunk/CreditStatus.php	2011-01-09 12:12:33 UTC (rev 4193)
@@ -144,7 +144,7 @@
 links to delete or edit each. These will call the same page again and allow update/input
 or deletion of the records*/
 
-	$sql = 'SELECT reasoncode, reasondescription, dissallowinvoices FROM holdreasons';
+	$sql = "SELECT reasoncode, reasondescription, dissallowinvoices FROM holdreasons";
 	$result = DB_query($sql, $db);
 
 	echo '<table class=selection>';

Modified: trunk/Currencies.php
===================================================================
--- trunk/Currencies.php	2011-01-09 11:57:43 UTC (rev 4192)
+++ trunk/Currencies.php	2011-01-09 12:12:33 UTC (rev 4193)
@@ -177,7 +177,7 @@
 links to delete or edit each. These will call the same page again and allow update/input
 or deletion of the records*/
 
-	$sql = 'SELECT currency, currabrev, country, hundredsname, rate FROM currencies';
+	$sql = "SELECT currency, currabrev, country, hundredsname, rate FROM currencies";
 	$result = DB_query($sql, $db);
 
 	echo '<table class=selection>';
@@ -343,4 +343,4 @@
 } //end if record deleted no point displaying form to add record
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>


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