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

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

Revision: 3670
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3670&view=rev
Author:   tim_schofield
Date:     2010-07-26 17:52:30 +0000 (Mon, 26 Jul 2010)

Log Message:
-----------
Sql quoting corrections and layout changes

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

Modified: trunk/PDFCustTransListing.php
===================================================================
--- trunk/PDFCustTransListing.php	2010-07-26 16:34:18 UTC (rev 3669)
+++ trunk/PDFCustTransListing.php	2010-07-26 17:52:30 UTC (rev 3670)
@@ -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,
 		invtext
 	FROM debtortrans
-	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);
@@ -75,7 +75,7 @@
 			prnMsg(_('The SQL used to get the transaction information that failed was') . ':<br>' . $SQL,'error');
 	}
 	include('includes/footer.inc');
-  	exit;
+	exit;
 } elseif (DB_num_rows($result) == 0){
 	$title = _('Payment Listing');
 	include('includes/header.inc');

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-26 16:34:18 UTC (rev 3669)
+++ trunk/doc/Change.log.html	2010-07-26 17:52:30 UTC (rev 3670)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>26/07/10 Tim: PDFCustTransListing.php - Sql quoting corrections and layout changes</p>
 <p>26/07/10 Tim: PDFCustomerList.php - Sql quoting corrections and layout changes</p>
 <p>26/07/10 Tim: PDFChequeListing.php - Sql quoting corrections, add javascript date picker, and layout changes</p>
 <p>26/07/10 Tim: PDFBankingSummary.php - Sql quoting corrections</p>


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