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

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

Revision: 4123
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4123&view=rev
Author:   tim_schofield
Date:     2010-10-28 09:27:33 +0000 (Thu, 28 Oct 2010)

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

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

Modified: trunk/PcExpensesTypeTab.php
===================================================================
--- trunk/PcExpensesTypeTab.php	2010-10-28 09:18:26 UTC (rev 4122)
+++ trunk/PcExpensesTypeTab.php	2010-10-28 09:27:33 UTC (rev 4123)
@@ -7,6 +7,9 @@
 $title = _('Maintenance Of Petty Cash Expenses For a Type Tab');
 include('includes/header.inc');
 
+echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/money_add.png" title="' . _('Payment Entry')
+	. '" alt="">' . ' ' . $title . '</p>';
+
 if (isset($_POST['SelectedType'])){
 	$SelectedType = strtoupper($_POST['SelectedType']);
 } elseif (isset($_GET['SelectedType'])){
@@ -73,8 +76,8 @@
 
 
 			$sql="DELETE FROM pctabexpenses
-				WHERE typetabcode='$SelectedTabs'
-				AND codeexpense='$SelectedType'";
+				WHERE typetabcode='".$SelectedTabs."'
+				AND codeexpense='".$SelectedType."'";
 			$ErrMsg = _('The Tab Type record could not be deleted because');
 			$result = DB_query($sql,$db,$ErrMsg);
 			prnMsg(_('Expense code').' '. $SelectedType .' '. _('for type of tab').' '. $SelectedTabs .' '. _('has been deleted') ,'success');
@@ -92,8 +95,7 @@
 or deletion of the records*/
 echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>';
 echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
-echo '<p><table border=1>'; //Main table
-echo '<td><table>'; // First column
+echo '<table class=selection>'; //Main table
 
 echo '<tr><td>' . _('Select Type of Tab') . ":</td><td><select name='SelectedTabs'>";
 
@@ -132,12 +134,12 @@
 	$sql = "SELECT pctabexpenses.codeexpense, pcexpenses.description
 			FROM pctabexpenses,pcexpenses
 			WHERE pctabexpenses.codeexpense=pcexpenses.codeexpense
-				AND pctabexpenses.typetabcode='$SelectedTabs'
+				AND pctabexpenses.typetabcode='".$SelectedTabs."'
 			ORDER BY pctabexpenses.codeexpense ASC";
 
 	$result = DB_query($sql,$db);
 
-	echo '<br><table BORDER=1>';
+	echo '<table class=selection>';
 	echo "<tr>
 		<th>" . _('Expense Code') . "</th>
 		<th>" . _('Description') . "</th>
@@ -173,8 +175,7 @@
 
 	echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>';
 	echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
-	echo '<p><table border=1>'; //Main table
-	echo '<td><table>'; // First column
+	echo '<br /><table  class=selection>'; //Main table
 
 
 
@@ -201,7 +202,6 @@
 
 	echo "<input type=hidden name='SelectedTabs' VALUE=" . $SelectedTabs . ">";
 
-   	echo '</table>'; // close table in first column
    	echo '</td></tr></table>'; // close main table
 
 	echo '<p><div class="centre"><input type=submit name=submit VALUE="' . _('Accept') . '"><input type=submit name=Cancel VALUE="' . _('Cancel') . '"></div>';

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-10-28 09:18:26 UTC (rev 4122)
+++ trunk/doc/Change.log.html	2010-10-28 09:27:33 UTC (rev 4123)
@@ -1,6 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
-<p>28/10/10 Tim: PcExpenses.php - SQL quoting corrections and layout changes and improvements</p>
+<p>28/10/10 Tim: PcExpensesTypeTab.php - SQL quoting corrections and layout changes and improvements</p>
 <p>28/10/10 Tim: PcTabs.php - SQL quoting corrections and layout changes and improvements</p>
 <p>28/10/10 Tim: PcTypeTabs.php - SQL quoting corrections and layout changes and improvements</p>
 <p>27/10/10 Tim: PcReportTab.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.