X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fmanage%2Fexchange_rates.php;h=6d13b06bf90f3bd77b712eed49eaff45115ea39f;hb=6bcd87642330092910f5d6977845a76ac59350ac;hp=2f0cce3cffc70356bf5516c03c2c3e3886a3b247;hpb=bc426821d8ae6319bd9394ac275bb700e6394fc3;p=fa-stable.git diff --git a/gl/manage/exchange_rates.php b/gl/manage/exchange_rates.php index 2f0cce3c..6d13b06b 100644 --- a/gl/manage/exchange_rates.php +++ b/gl/manage/exchange_rates.php @@ -1,7 +1,17 @@ . +***********************************************************************/ +$page_security = 'SA_EXCHANGERATE'; +$path_to_root = "../.."; +include($path_to_root . "/includes/db_pager.inc"); include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/includes/date_functions.inc"); @@ -9,24 +19,14 @@ include_once($path_to_root . "/includes/ui.inc"); include_once($path_to_root . "/includes/banking.inc"); $js = ""; -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); -page(_("Exchange Rates"), false, false, "", $js); +page(_($help_context = "Exchange Rates"), false, false, "", $js); -//--------------------------------------------------------------------------------------------- +simple_page_mode(false); -if (isset($_GET['selected_id'])) -{ - $selected_id = $_GET['selected_id']; -} -elseif (isset($_POST['selected_id'])) -{ - $selected_id = $_POST['selected_id']; -} -else - $selected_id = ""; //--------------------------------------------------------------------------------------------- -function check_data() +function check_data($selected_id) { if (!is_date($_POST['date_'])) { @@ -34,19 +34,18 @@ function check_data() set_focus('date_'); return false; } - if (!check_num('BuyRate', 0)) + if (input_num('BuyRate') <= 0) { - display_error( _("The exchange rate must be numeric and greater than zero.")); + display_error( _("The exchange rate cannot be zero or a negative number.")); set_focus('BuyRate'); return false; } - if ($_POST['BuyRate'] <= 0) + if (!$selected_id && get_date_exchange_rate($_POST['curr_abrev'], $_POST['date_'])) { - display_error( _("The exchange rate cannot be zero or a negative number.")); - set_focus('BuyRate'); + display_error( _("The exchange rate for the date is already there.")); + set_focus('date_'); return false; } - return true; } @@ -56,14 +55,14 @@ function handle_submit() { global $selected_id; - if (!check_data()) + if (!check_data($selected_id)) return false; if ($selected_id != "") { update_exchange_rate($_POST['curr_abrev'], $_POST['date_'], - input_num('BuyRate'), input_num('BuyRate')); + input_num('BuyRate'), input_num('BuyRate')); } else { @@ -72,7 +71,8 @@ function handle_submit() input_num('BuyRate'), input_num('BuyRate')); } - return true; + $selected_id = ''; + clear_data(); } //--------------------------------------------------------------------------------------------- @@ -84,54 +84,35 @@ function handle_delete() if ($selected_id == "") return; delete_exchange_rate($selected_id); - - meta_forward($_SERVER['PHP_SELF']); + $selected_id = ''; + clear_data(); } //--------------------------------------------------------------------------------------------- - -function display_rates($curr_code) +function edit_link($row) { - global $table_style; - - $result = get_exchange_rates($curr_code); - - br(2); - start_table($table_style); - $th = array(_("Date to Use From"), _("Exchange Rate"), "", ""); - table_header($th); - - $k = 0; //row colour counter - - while ($myrow = db_fetch($result)) - { - - alt_table_row_color($k); - - label_cell(sql2date($myrow["date_"])); - label_cell(number_format2($myrow["rate_buy"], user_exrate_dec()), "nowrap align=right"); - edit_link_cell("selected_id=" . $myrow["id"]); - delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1"); + return button('Edit'.$row["id"], _("Edit"), true, ICON_EDIT); +} - end_row(); +function del_link($row) +{ + return button('Delete'.$row["id"], _("Delete"), true, ICON_DELETE); +} - } //END WHILE LIST LOOP +function display_rates($curr_code) +{ - end_table(); } //--------------------------------------------------------------------------------------------- function display_rate_edit() { - global $selected_id, $table_style2; + global $selected_id, $Ajax, $SysPrefs; + $xchg_rate_provider = ((isset($SysPrefs->xr_providers) && isset($SysPrefs->dflt_xr_provider)) + ? $SysPrefs->xr_providers[$SysPrefs->dflt_xr_provider] : 'ECB'); + start_table(TABLESTYLE2); - start_table($table_style2); - - if (isset($_POST['get_rate'])) - { - $_POST['BuyRate'] = exrate_format(get_ecb_rate($_POST['curr_abrev'])); - } if ($selected_id != "") { //editing an existing exchange rate @@ -139,24 +120,31 @@ function display_rate_edit() $myrow = get_exchange_rate($selected_id); $_POST['date_'] = sql2date($myrow["date_"]); - $_POST['BuyRate'] = exrate_format($myrow["rate_buy"]); + $_POST['BuyRate'] = maxprec_format($myrow["rate_buy"]); hidden('selected_id', $selected_id); hidden('date_', $_POST['date_']); - hidden('curr_abrev', $_POST['curr_abrev']); label_row(_("Date to Use From:"), $_POST['date_']); } else { + $_POST['date_'] = Today(); + $_POST['BuyRate'] = ''; date_row(_("Date to Use From:"), 'date_'); } - small_amount_row(_("Exchange Rate:"), 'BuyRate', null, '', - submit('get_rate',_("Get"), false), user_exrate_dec()); + if (isset($_POST['get_rate'])) + { + $_POST['BuyRate'] = + maxprec_format(retrieve_exrate($_POST['curr_abrev'], $_POST['date_'])); + $Ajax->activate('BuyRate'); + } + amount_row(_("Exchange Rate:"), 'BuyRate', null, '', + submit('get_rate',_("Get"), false, _('Get current rate from') . ' ' . $xchg_rate_provider , true), 'max'); end_table(1); - submit_add_or_update_center($selected_id == ""); + submit_add_or_update_center($selected_id == '', '', 'both'); display_note(_("Exchange rates are entered against the company currency."), 1); } @@ -172,33 +160,26 @@ function clear_data() //--------------------------------------------------------------------------------------------- -if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) -{ - - if (handle_submit()) - { - meta_forward($_SERVER['PHP_SELF']); - } -} +if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') + handle_submit(); //--------------------------------------------------------------------------------------------- -if (isset($_GET['delete'])) -{ - +if ($Mode == 'Delete') handle_delete(); -} + //--------------------------------------------------------------------------------------------- -echo "
"; -start_form(false, true); +start_form(); if (!isset($_POST['curr_abrev'])) $_POST['curr_abrev'] = get_global_curr_code(); +echo "
"; echo _("Select a currency :") . " "; -currencies_list('curr_abrev', $_POST['curr_abrev'], true); +echo currencies_list('curr_abrev', null, true, true); +echo "
"; // if currency sel has changed, clear the form if ($_POST['curr_abrev'] != get_global_curr_code()) @@ -207,9 +188,19 @@ if ($_POST['curr_abrev'] != get_global_curr_code()) $selected_id = ""; } -set_global_curr_code($_POST['curr_abrev']); +set_global_curr_code(get_post('curr_abrev')); + +$sql = get_sql_for_exchange_rates(get_post('curr_abrev')); -if (is_company_currency($_POST['curr_abrev'])) +$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(get_post('curr_abrev'))) { display_note(_("The selected currency is the company currency."), 2); @@ -218,11 +209,12 @@ if (is_company_currency($_POST['curr_abrev'])) else { - display_rates($_POST['curr_abrev']); - - hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter a New Exchange Rate")); + br(1); + $table->width = "40%"; + if ($table->rec_count == 0) + $table->ready = false; + display_db_pager($table); br(1); - display_rate_edit(); } @@ -230,4 +222,3 @@ end_form(); end_page(); -?>