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

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

Revision: 3812
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3812&view=rev
Author:   tim_schofield
Date:     2010-09-27 21:28:29 +0000 (Mon, 27 Sep 2010)

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

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

Modified: trunk/SuppPaymentRun.php
===================================================================
--- trunk/SuppPaymentRun.php	2010-09-27 21:15:42 UTC (rev 3811)
+++ trunk/SuppPaymentRun.php	2010-09-27 21:28:29 UTC (rev 3812)
@@ -171,8 +171,8 @@
 				/*Now update the SuppTrans for the allocation made and the fact that it is now settled */
 
 				$SQL = "UPDATE supptrans SET settled = 1,
-                                     				alloc = " . $DetailTrans['trantotal'] . ",
-                                     				diffonexch = " . ($DetailTrans['diffonexch'] + $DiffOnExch)  . "
+                                     				alloc = '" . $DetailTrans['trantotal'] . "',
+                                     				diffonexch = '" . ($DetailTrans['diffonexch'] + $DiffOnExch)  . "'
                                  	WHERE type = " . $DetailTrans['type'] . '
 					AND transno = ' . $DetailTrans['transno'];
 
@@ -234,13 +234,16 @@
 	$title=_('Payment Run');
 	include('includes/header.inc');
 
+	echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/maintenance.png" title="' . _('Supplier Types')
+		. '" alt="">' . $title . '</p>';
+
 	if (isset($_POST['Currency']) AND !is_numeric($_POST['ExRate'])){
 		echo '<br>' . _('To process payments for') . ' ' . $_POST['Currency'] . ' ' . _('a numeric exchange rate applicable for purchasing the currency to make the payment with must be entered') . '. ' . _('This rate is used to calculate the difference in exchange and make the necessary postings to the General ledger if linked') . '.';
 	}
 
 	/* show form to allow input	*/
 
-	echo '<form action="' . $_SERVER['PHP_SELF'] . '?' . SID . '" method="POST"><table>';
+	echo '<form action="' . $_SERVER['PHP_SELF'] . '?' . SID . '" method="POST"><table class=selection>';
 
 	if (!isset($_POST['FromCriteria']) or strlen($_POST['FromCriteria'])<1){
 		$DefaultFromCriteria = '1';
@@ -346,7 +349,7 @@
 	echo '<tr><td>' . _('Starting Reference no (eg chq no)') . ':</td>
             <td><input type=text name="Ref" maxlength=11 size=12 VALUE=' . $_POST['Ref'] . '></td></tr>';
 
-	echo '</table><div class="centre"><input type=Submit Name="PrintPDF" Value="' . _('Print PDF Only') . '">
+	echo '</table><br /><div class="centre"><input type=Submit Name="PrintPDF" Value="' . _('Print PDF Only') . '">
                 <input type=Submit Name="PrintPDFAndProcess" Value="' . _('Print and Process Payments') . '"></div>';
 
 	include ('includes/footer.inc');

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-27 21:15:42 UTC (rev 3811)
+++ trunk/doc/Change.log.html	2010-09-27 21:28:29 UTC (rev 3812)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>27/09/10 Tim: SuppPaymentRun.php - SQL quoting corrections and layout changes and improvements</p>
 <p>27/09/10 Tim: SuppLoginSetup.php - SQL quoting corrections and layout changes and improvements</p>
 <p>27/09/10 Tim: SupplierTypes.php - SQL quoting corrections and layout changes and improvements</p>
 <p>27/09/10 Tim: SupplierTransInquiry.php - New script to show detail supplier transactions</p>


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