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

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

Revision: 3721
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3721&view=rev
Author:   tim_schofield
Date:     2010-09-08 21:35:49 +0000 (Wed, 08 Sep 2010)

Log Message:
-----------
Screen layout improvements. Correct the sql quoting

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

Modified: trunk/PDFSuppTransListing.php
===================================================================
--- trunk/PDFSuppTransListing.php	2010-09-08 21:32:24 UTC (rev 3720)
+++ trunk/PDFSuppTransListing.php	2010-09-08 21:35:49 UTC (rev 3721)
@@ -28,7 +28,7 @@
 	}
 
 	 echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '>';
-	 echo '<table>
+	 echo '<table class=selection>
 	 			<tr>
 				<td>' . _('Enter the date for which the transactions are to be listed') . ":</td>
 				<td><input type=text name='Date' maxlength=10 size=10 class=date alt='" . $_SESSION['DefaultDateFormat'] . "' VALUE='" . Date($_SESSION['DefaultDateFormat']) . "'></td>
@@ -44,7 +44,7 @@
 
 	 echo '</select></td></tr>';
 
-	 echo "</select></td></tr></table><div class='centre'><input type=submit name='Go' value='" . _('Create PDF') . "'></div>";
+	 echo "</select></td></tr></table><br><div class='centre'><input type=submit name='Go' value='" . _('Create PDF') . "'></div>";
 
 
 	 include('includes/footer.inc');
@@ -62,7 +62,7 @@
 		ovgst,
 		transtext
 	FROM supptrans
-	WHERE type=" . $_POST['TransType'] . "
+	WHERE type='" . $_POST['TransType'] . "'
 	AND date_format(inputdate, '%Y-%m-%d')='".FormatDateForSQL($_POST['Date'])."'";
 
 $result=DB_query($sql,$db,'','',false,false);

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-08 21:32:24 UTC (rev 3720)
+++ trunk/doc/Change.log.html	2010-09-08 21:35:49 UTC (rev 3721)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>08/09/10 Tim: PDFSuppTransListing.php - Screen layout improvements. Correct the sql quoting</p>
 <p>08/09/10 Tim: PDFStockTransfer.php - Correct the sql quoting</p>
 <p>08/09/10 Tim: PDFStockNegatives.php - Fix missing sql error message and correct the default date format in the heading</p>
 <p>08/09/10 Tim: PDFStockCheckComparison.php - Screen layout improvements. Correct the sql quoting</p>


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