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

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

Revision: 3562
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3562&view=rev
Author:   tim_schofield
Date:     2010-07-04 22:02:28 +0000 (Sun, 04 Jul 2010)

Log Message:
-----------
Corrections to sql statements and layout changes

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

Modified: trunk/CreditStatus.php
===================================================================
--- trunk/CreditStatus.php	2010-07-04 22:01:58 UTC (rev 3561)
+++ trunk/CreditStatus.php	2010-07-04 22:02:28 UTC (rev 3562)
@@ -213,7 +213,7 @@
 
 		echo "<input type=hidden name='SelectedReason' VALUE='" . $SelectedReason . "'>";
 		echo "<input type=hidden name='ReasonCode' VALUE='" . $_POST['ReasonCode'] . "'>";
-		echo "<table><tr><td>". _('Status Code') .':</td><td>';
+		echo "<table class=selection><tr><td>". _('Status Code') .':</td><td>';
 		echo $_POST['ReasonCode'] . '</td></tr>';
 
 	} else { //end of if $SelectedReason only do the else when a new record is being entered

Modified: trunk/Currencies.php
===================================================================
--- trunk/Currencies.php	2010-07-04 22:01:58 UTC (rev 3561)
+++ trunk/Currencies.php	2010-07-04 22:02:28 UTC (rev 3562)
@@ -26,6 +26,8 @@
 
 $Errors = array();
 
+echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/money_add.png" title="' . _('Search') . '" alt="">' . ' ' . $title.'<br>';
+
 if (isset($_POST['submit'])) {
 
 	//initialise no input errors assumed initially before we test
@@ -96,7 +98,7 @@
 					currency='" . $_POST['CurrencyName'] . "',
 					country='". $_POST['Country']. "',
 					hundredsname='" . $_POST['HundredsName'] . "',
-					rate=" .$_POST['ExchangeRate'] . "
+					rate='" .$_POST['ExchangeRate'] . "'
 					WHERE currabrev = '" . $SelectedCurrency . "'";
 
 		$msg = _('The currency definition record has been updated');
@@ -112,7 +114,7 @@
 					'" . $_POST['Abbreviation'] . "',
 					'" . $_POST['Country'] . "',
 					'" . $_POST['HundredsName'] .  "',
-					" . $_POST['ExchangeRate'] . ")";
+					'" . $_POST['ExchangeRate'] . "')";
 
 		$msg = _('The currency definition record has been added');
 	}
@@ -141,7 +143,7 @@
 		prnMsg(_('Cannot delete this currency because customer accounts have been created referring to this currency') .
 		 	'<br>' . _('There are') . ' ' . $myrow[0] . ' ' . _('customer accounts that refer to this currency'),'warn');
 	} else {
-		$sql= "SELECT COUNT(*) FROM suppliers WHERE suppliers.currcode = '$SelectedCurrency'";
+		$sql= "SELECT COUNT(*) FROM suppliers WHERE suppliers.currcode = '".$SelectedCurrency."'";
 		$result = DB_query($sql,$db);
 		$myrow = DB_fetch_row($result);
 		if ($myrow[0] > 0)
@@ -178,7 +180,7 @@
 	$sql = 'SELECT currency, currabrev, country, hundredsname, rate FROM currencies';
 	$result = DB_query($sql, $db);
 
-	echo '<table border=1>';
+	echo '<table class=selection>';
 	echo '<tr><td></td>
 			<th>' . _('ISO4217 Code') . '</th>
 			<th>' . _('Currency Name') . '</th>
@@ -192,6 +194,8 @@
 	/*Get published currency rates from Eurpoean Central Bank */
 	if ($_SESSION['UpdateCurrencyRatesDaily'] != '0') {
 		$CurrencyRatesArray = GetECBCurrencyRates();
+	} else {
+		$CurrencyRatesArray = array();
 	}
 
 	while ($myrow = DB_fetch_row($result)) {
@@ -297,14 +301,14 @@
 
 		echo '<input type="hidden" name="SelectedCurrency" VALUE="' . $SelectedCurrency . '">';
 		echo '<input type="hidden" name="Abbreviation" VALUE="' . $_POST['Abbreviation'] . '">';
-		echo '<table><tr>
+		echo '<table class=selection><tr>
 			<td>' . _('ISO 4217 Currency Code').':</td>
 			<td>';
 		echo $_POST['Abbreviation'] . '</td></tr>';
 
 	} else { //end of if $SelectedCurrency only do the else when a new record is being entered
 		if (!isset($_POST['Abbreviation'])) {$_POST['Abbreviation']='';}
-		echo '<table><tr>
+		echo '<table class=selection><tr>
 			<td>' ._('Currency Abbreviation') . ':</td>
 			<td><input ' . (in_array('Abbreviation',$Errors) ?  'class="inputerror"' : '' ) .' type="Text" name="Abbreviation" value="' . $_POST['Abbreviation'] . '" size=4 maxlength=3></td></tr>';
 	}
@@ -331,11 +335,11 @@
 	echo '</td></tr>';
 	echo '</table>';
 
-	echo '<div class="centre"><input type="Submit" name="submit" value='._('Enter Information').'></div>';
+	echo '<br><div class="centre"><input type="Submit" name="submit" value='._('Enter Information').'></div>';
 
 	echo '</form>';
 
 } //end if record deleted no point displaying form to add record
 
 include('includes/footer.inc');
-?>
+?>
\ No newline at end of file

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-04 22:01:58 UTC (rev 3561)
+++ trunk/doc/Change.log.html	2010-07-04 22:02:28 UTC (rev 3562)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>04/07/10 Tim: Currencies.php - Corrections to sql statements and layout changes</p>
 <p>04/07/10 Tim: CreditStatus.php - Corrections to sql statements and layout changes</p>
 <p>04/07/10 Tim: Credit_Invoice.php - Minor bug fixes layout changes and corrections to sql statements</p>
 <p>04/07/10 Tim: ConfirmDispatchControlled_Invoice.php - Force the LineNo variable to be read as integer</p>


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