X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fmanage%2Fexchange_rates.php;h=493509f9d7a339eb3da2c23638b11b05972984db;hb=19b77e12bf5c056e3141032c62cc8d9ad7a21d6e;hp=5381831a52025e5c70eeb655f21fc37decaee129;hpb=fddc446ee6f00e8924d0777ca21ff8562f511464;p=fa-stable.git diff --git a/gl/manage/exchange_rates.php b/gl/manage/exchange_rates.php index 5381831a..493509f9 100644 --- a/gl/manage/exchange_rates.php +++ b/gl/manage/exchange_rates.php @@ -1,5 +1,14 @@ . +***********************************************************************/ $page_security = 9; $path_to_root="../.."; include($path_to_root . "/includes/db_pager.inc"); @@ -93,24 +102,6 @@ function display_rates($curr_code) { global $table_style; - $sql = "SELECT date_, rate_buy, id FROM " - .TB_PREF."exchange_rates " - ."WHERE curr_code='$curr_code' - ORDER BY date_ DESC"; - - $cols = array( - _("Date to Use From") => 'date', - _("Exchange Rate") => 'rate', - array('insert'=>true, 'fun'=>'edit_link'), - array('insert'=>true, 'fun'=>'del_link'), - ); - $table =& new_db_pager('orders_tbl', $sql, $cols); - if (list_updated('curr_abrev')) { - $table->set_sql($sql); - $table->set_columns($cols); - } - $table->width = "40%"; - display_db_pager($table); } //--------------------------------------------------------------------------------------------- @@ -144,9 +135,6 @@ function display_rate_edit() if (isset($_POST['get_rate'])) { $_POST['BuyRate'] = exrate_format(get_ecb_rate($_POST['curr_abrev'])); - if ($_POST['BuyRate'] == 0) { - display_error(_('This currency is not listed by ECB. Enter exchange rate manually.')); - } $Ajax->activate('BuyRate'); } small_amount_row(_("Exchange Rate:"), 'BuyRate', null, '', @@ -201,6 +189,19 @@ if ($_POST['curr_abrev'] != get_global_curr_code()) set_global_curr_code($_POST['curr_abrev']); +$sql = "SELECT date_, rate_buy, id FROM " + .TB_PREF."exchange_rates " + ."WHERE curr_code='".$_POST['curr_abrev']."' + ORDER BY date_ DESC"; + +$cols = array( + _("Date to Use From") => 'date', + _("Exchange Rate") => 'rate', + array('insert'=>true, 'fun'=>'edit_link'), + array('insert'=>true, 'fun'=>'del_link'), +); +$table =& new_db_pager('orders_tbl', $sql, $cols); + if (is_company_currency($_POST['curr_abrev'])) { @@ -211,7 +212,12 @@ else { br(1); - display_rates($_POST['curr_abrev']); + if (list_updated('curr_abrev')) { + $table->set_sql($sql); + $table->set_columns($cols); + } + $table->width = "40%"; + display_db_pager($table); br(1); display_rate_edit(); }