[Weberp-cvs] SF.net SVN: web-erp:[3816] trunk

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

Revision: 3816
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3816&view=rev
Author:   tim_schofield
Date:     2010-09-28 09:50:07 +0000 (Tue, 28 Sep 2010)

Log Message:
-----------
SQL quoting corrections and layout changes and improvements

Modified Paths:
--------------
    trunk/SuppTransGLAnalysis.php
    trunk/doc/Change.log.html

Modified: trunk/SuppTransGLAnalysis.php
===================================================================
--- trunk/SuppTransGLAnalysis.php	2010-09-28 09:23:01 UTC (rev 3815)
+++ trunk/SuppTransGLAnalysis.php	2010-09-28 09:50:07 UTC (rev 3816)
@@ -32,10 +32,10 @@
 		$_POST['GLCode'] = $_POST['AcctSelection'];
 	}
 
-	$sql = 'SELECT accountcode,
+	$sql = "SELECT accountcode,
 			accountname
 		FROM chartmaster
-		WHERE accountcode=' . $_POST['GLCode'];
+		WHERE accountcode='" . $_POST['GLCode'] . "'";
 	$result = DB_query($sql, $db);
 	if (DB_num_rows($result) == 0){
 		prnMsg(_('The account code entered is not a valid code') . '. ' . _('This line cannot be added to the transaction') . '.<br>' . _('You can use the selection box to select the account you want'),'error');
@@ -84,7 +84,7 @@
 	echo '<div class="centre"><p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/transactions.png" title="' . _('General Ledger') . '" alt="">' . ' '
 	. _('General Ledger Analysis of Credit Note From') . ' ' . $_SESSION['SuppTrans']->SupplierName;
 }
-echo '</p><table cellpadding=2>';
+echo '</p><table cellpadding=2 class=selection>';
 
 $TableHeader = '<tr>
 							<th>' . _('Account') . '</th>
@@ -116,21 +116,21 @@
 
 echo '<tr>
 	<td colspan=2 class=number><font size=4 color=BLUE>' . _('Total') . ':</font></td>
-	<td class=number><font size=4 color=BLUE><U>' . number_format($TotalGLValue,2) . '</U></font></td>
+	<td class=number><font size=2 color=navy><U>' . number_format($TotalGLValue,2) . '</U></font></td>
 	</tr>
 	</table>';
 
 
 if ($_SESSION['SuppTrans']->InvoiceOrCredit == 'Invoice'){
-	echo '<br><a href="' . $rootpath . '/SupplierInvoice.php?' . SID . '">' . _('Back to Invoice Entry') . '</a><hr>';
+	echo '<br /><a href="' . $rootpath . '/SupplierInvoice.php?' . SID . '">' . _('Back to Invoice Entry') . '</a>';
 } else {
-	echo '<br><a href="' . $rootpath . '/SupplierCredit.php?' . SID . '">' . _('Back to Credit Note Entry') . '</a><hr>';
+	echo '<br /><a href="' . $rootpath . '/SupplierCredit.php?' . SID . '">' . _('Back to Credit Note Entry') . '</a>';
 }
 
 /*Set up a form to allow input of new GL entries */
 echo '<form action="' . $_SERVER['PHP_SELF'] . '?' . SID . '" method="post">';
 
-echo '<table>';
+echo '<br /><table class=selection>';
 if (!isset($_POST['GLCode'])) {
 	$_POST['GLCode']='';
 }
@@ -172,9 +172,9 @@
 }
 echo '<tr>
 	<td>' . _('Narrative') . ':</td>
-	<td><TEXTAREA name="Narrative" cols=40 rows=2>' .  $_POST['Narrative'] . '</textarea></td>
+	<td><textarea name="Narrative" cols=40 rows=2>' .  $_POST['Narrative'] . '</textarea></td>
 	</tr>
-	</table>';
+	</table><br />';
 
 echo '<input type="submit" name="AddGLCodeToTrans" VALUE="' . _('Enter GL Line') . '">';
 

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-28 09:23:01 UTC (rev 3815)
+++ trunk/doc/Change.log.html	2010-09-28 09:50:07 UTC (rev 3816)
@@ -1,6 +1,7 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
-<p>28/09/10 Tim: SuppShiptChargesphp - Layout changes and improvements</p>
+<p>28/09/10 Tim: SuppTransGLAnalysis.php - SQL quoting corrections and layout changes and improvements</p>
+<p>28/09/10 Tim: SuppShiptCharges.php - Layout changes and improvements</p>
 <p>28/09/10 Tim: SuppPriceList.php - Layout changes and improvements</p>
 <p>27/09/10 Paul Thursby: Various default.css files -- Minor CSS corrections.</p>
 <p>27/09/10 Tim: SuppPaymentRun.php - SQL quoting corrections and layout changes and improvements</p>


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