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

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

Revision: 3573
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3573&view=rev
Author:   tim_schofield
Date:     2010-07-06 21:58:25 +0000 (Tue, 06 Jul 2010)

Log Message:
-----------
Layout changes and correction to sql statement

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

Modified: trunk/CustomerTransInquiry.php
===================================================================
--- trunk/CustomerTransInquiry.php	2010-07-06 21:57:53 UTC (rev 3572)
+++ trunk/CustomerTransInquiry.php	2010-07-06 21:58:25 UTC (rev 3573)
@@ -14,7 +14,7 @@
 
 echo "<form action='" . $_SERVER['PHP_SELF'] . "' method=post>";
 
-echo '<table cellpadding=2><tr>';
+echo '<table cellpadding=2 class=selection><tr>';
 
 echo '<td>' . _('Type') . ":</td><td><select tabindex=1 name='TransType'> ";
 
@@ -44,8 +44,7 @@
 echo '<td>' . _('From') . ':</td><td><input tabindex="2" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" type="TEXT" name="FromDate" maxlength="10" size="11" VALUE="' . $_POST['FromDate'] . '"></td>';
 echo '<td>' . _('To') . ':</td><td><input tabindex="3" class="date" alt="'.$_SESSION['DefaultDateFormat'].'" type="TEXT" name="ToDate" maxlength="10" size="11" VALUE="' . $_POST['ToDate'] . '"></td>';
 
-echo "</tr></table><div class='centre'><input tabindex=4 type=submit name='ShowResults' VALUE='" . _('Show Transactions') . "'>";
-echo '<hr>';
+echo "</tr></table><br><div class='centre'><input tabindex=4 type=submit name='ShowResults' VALUE='" . _('Show Transactions') . "'>";
 
 echo '</form></div>';
 
@@ -70,7 +69,7 @@
 
    $sql = $sql . "trandate >='" . $SQL_FromDate . "' AND trandate <= '" . $SQL_ToDate . "'";
 	if  ($_POST['TransType']!='All')  {
-		$sql .= " AND type = " . $_POST['TransType'];
+		$sql .= " AND type = '" . $_POST['TransType']."'";
 	}
 	$sql .=  " ORDER BY id";
 
@@ -78,7 +77,7 @@
    $DbgMsg =  _('The SQL that failed was');
    $TransResult = DB_query($sql, $db,$ErrMsg,$DbgMsg);
 
-   echo '<table cellpadding=2 border=2>';
+   echo '<br><table cellpadding=2 class=selection>';
 
    $tableheader = "<tr>
 			<th>" . _('Type') . "</th>
@@ -181,4 +180,4 @@
 
 include('includes/footer.inc');
 
-?>
+?>
\ No newline at end of file

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-06 21:57:53 UTC (rev 3572)
+++ trunk/doc/Change.log.html	2010-07-06 21:58:25 UTC (rev 3573)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>05/07/10 Tim: Customers.php - Layout changes and correction to sql statement</p>
 <p>05/07/10 Tim: Customers.php - Layout changes</p>
 <p>05/07/10 Tim: CustomerReceipt.php - Corrections to sql statements</p>
 <p>05/07/10 Tim: CustomerInquiries.php - Layout changes</p>


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