activate('BuyRate'); } small_amount_row(_("Exchange Rate:"), 'BuyRate', null, '', submit('get_rate',_("Get"), false, _('Get current ECB rate') , true), user_exrate_dec()); end_table(1); submit_add_or_update_center($selected_id == '', '', true); display_note(_("Exchange rates are entered against the company currency."), 1); } //--------------------------------------------------------------------------------------------- function clear_data() { unset($_POST['selected_id']); unset($_POST['date_']); unset($_POST['BuyRate']); } //--------------------------------------------------------------------------------------------- if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') handle_submit(); //--------------------------------------------------------------------------------------------- if ($Mode == 'Delete') handle_delete(); //--------------------------------------------------------------------------------------------- start_form(false, true); if (!isset($_POST['curr_abrev'])) $_POST['curr_abrev'] = get_global_curr_code(); echo ""; echo _("Select a currency :") . " "; currencies_list('curr_abrev', null, true); echo ""; // if currency sel has changed, clear the form if ($_POST['curr_abrev'] != get_global_curr_code()) { clear_data(); $selected_id = ""; } 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'])) { display_note(_("The selected currency is the company currency."), 2); display_note(_("The company currency is the base currency so exchange rates cannot be set for it."), 1); } else { br(1); 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(); } end_form(); end_page(); ?>