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

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

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

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

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

Modified: trunk/PcTabs.php
===================================================================
--- trunk/PcTabs.php	2010-10-28 08:46:07 UTC (rev 4120)
+++ trunk/PcTabs.php	2010-10-28 09:08:59 UTC (rev 4121)
@@ -7,6 +7,9 @@
 $title = _('Maintenance Of Petty Cash Tabs');
 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['SelectedTab'])){
 	$SelectedTab = strtoupper($_POST['SelectedTab']);
 } elseif (isset($_GET['SelectedTab'])){
@@ -52,7 +55,7 @@
 			authorizer = '" . $_POST['SelectAuthorizer'] . "',
 			glaccountassignment = '" . $_POST['glaccountcash'] . "',
 			glaccountpcash = '" . $_POST['glaccountpcashtab'] . "'
-			WHERE tabcode = '$SelectedTab'";
+			WHERE tabcode = '".$SelectedTab."'";
 
 		$msg = _('The Tabs Of Code') . ' ' . $SelectedTab . ' ' .  _('has been updated');
 	} elseif ( $InputError !=1 ) {
@@ -115,7 +118,7 @@
 
 } elseif ( isset($_GET['delete']) ) {
 
-			$sql="DELETE FROM pctabs WHERE tabcode='$SelectedTab'";
+			$sql="DELETE FROM pctabs WHERE tabcode='".$SelectedTab."'";
 			$ErrMsg = _('The Tab record could not be deleted because');
 			$result = DB_query($sql,$db,$ErrMsg);
 			prnMsg(_('Tab type') .  ' ' . $SelectedTab  . ' ' . _('has been deleted') ,'success');
@@ -136,7 +139,7 @@
 		ORDER BY tabcode';
 	$result = DB_query($sql,$db);
 
-	echo '<br><table BORDER=1>';
+	echo '<br><table class=selection>';
 	echo "<tr>
 		<th>" . _('Tab Code') . "</th>
 		<th>" . _('User Name') . "</th>
@@ -209,14 +212,13 @@
 
 	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 '<p><table class=selection>'; //Main table
 
 
 	if ( isset($SelectedTab) AND $SelectedTab!='' ) {
 
 		$sql = "SELECT * FROM pctabs
-				WHERE tabcode='$SelectedTab'";
+				WHERE tabcode='".$SelectedTab."'";
 
 		$result = DB_query($sql, $db);
 		$myrow = DB_fetch_array($result);
@@ -233,7 +235,7 @@
 
 		echo "<input type=hidden name='SelectedTab' VALUE=" . $SelectedTab . ">";
 		echo "<input type=hidden name='tabcode' VALUE=" . $_POST['tabcode']. ">";
-		echo "<table> <tr><td>" . _('Tabcode') . ":</td><td>";
+		echo "<table class=selection> <tr><td>" . _('Tabcode') . ":</td><td>";
 
 		// We dont allow the user to change an existing type code
 
@@ -242,7 +244,7 @@
 	} else 	{
 
 		// This is a new type so the user may volunteer a type code
-		echo "<table><tr><td>" . _('Tabcode') . ":</td><td><input type='Text'
+		echo "<table class=selection><tr><td>" . _('Tabcode') . ":</td><td><input type='Text'
 				" . (in_array('TypeTabCode',$Errors) ? 'class="inputerror"' : '' ) ." name='tabcode'></td></tr>";
 
 	}
@@ -379,8 +381,6 @@
 	} //end while loop
 
 	echo '</select></td></tr>';
-
-   	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>';
@@ -391,4 +391,4 @@
 
 
 include('includes/footer.inc');
-?>
+?>
\ No newline at end of file

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-10-28 08:46:07 UTC (rev 4120)
+++ trunk/doc/Change.log.html	2010-10-28 09:08:59 UTC (rev 4121)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></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>
 <p>27/10/10 Tim: PcClaimExpensesFromTab.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.