5 include_once($path_to_root . "/includes/session.inc");
7 include_once($path_to_root . "/includes/date_functions.inc");
8 include_once($path_to_root . "/includes/ui.inc");
9 include_once($path_to_root . "/includes/banking.inc");
13 $js .= get_js_date_picker();
14 page(_("Exchange Rates"), false, false, "", $js);
16 //---------------------------------------------------------------------------------------------
18 if (isset($_GET['selected_id']))
20 $selected_id = $_GET['selected_id'];
22 elseif (isset($_POST['selected_id']))
24 $selected_id = $_POST['selected_id'];
28 //---------------------------------------------------------------------------------------------
32 if (!is_date($_POST['date_']))
34 display_error( _("The entered date is invalid."));
37 if (!is_numeric($_POST['BuyRate']))
39 display_error( _("The exchange rate must be numeric."));
42 if ($_POST['BuyRate'] <= 0)
44 display_error( _("The exchange rate cannot be zero or a negative number."));
51 //---------------------------------------------------------------------------------------------
53 function handle_submit()
60 if ($selected_id != "")
63 update_exchange_rate($_POST['curr_abrev'], $_POST['date_'], $_POST['BuyRate'],
69 add_exchange_rate($_POST['curr_abrev'], $_POST['date_'], $_POST['BuyRate'],
76 //---------------------------------------------------------------------------------------------
78 function handle_delete()
82 if ($selected_id == "")
84 delete_exchange_rate($selected_id);
86 meta_forward($_SERVER['PHP_SELF']);
89 //---------------------------------------------------------------------------------------------
91 function display_rates($curr_code)
95 $result = get_exchange_rates($curr_code);
98 start_table($table_style);
99 $th = array(_("Date to Use From"), _("Exchange Rate"), "", "");
102 $k = 0; //row colour counter
104 while ($myrow = db_fetch($result))
107 alt_table_row_color($k);
109 label_cell(sql2date($myrow["date_"]));
110 label_cell(number_format2($myrow["rate_buy"], user_exrate_dec()), "nowrap align=right");
111 edit_link_cell("selected_id=" . $myrow["id"]);
112 delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
116 } //END WHILE LIST LOOP
121 //---------------------------------------------------------------------------------------------
123 function display_rate_edit()
125 global $selected_id, $table_style2;
127 start_table($table_style2);
129 if (isset($_POST['get_rate']))
131 $_POST['BuyRate'] = get_ecb_rate($_POST['curr_abrev']);
132 $_POST['BuyRate'] = number_format($_POST['BuyRate'], user_exrate_dec());
134 if ($selected_id != "")
136 //editing an existing payment terms
138 $myrow = get_exchange_rate($selected_id);
140 $_POST['date_'] = sql2date($myrow["date_"]);
141 $_POST['BuyRate'] = $myrow["rate_buy"];
143 hidden('selected_id', $selected_id);
144 hidden('date_', $_POST['date_']);
145 hidden('curr_abrev', $_POST['curr_abrev']);
147 label_row(_("Date to Use From:"), $_POST['date_']);
151 date_row(_("Date to Use From:"), 'date_');
153 text_row(_("Exchange Rate:"), 'BuyRate', null, 15, 12, "", submit('get_rate',_("Get"), false));
157 submit_add_or_update_center($selected_id == "");
159 display_note(_("Exchange rates are entered against the company currency."), 1);
162 //---------------------------------------------------------------------------------------------
164 function clear_data()
166 unset($_POST['selected_id']);
167 unset($_POST['date_']);
168 unset($_POST['BuyRate']);
171 //---------------------------------------------------------------------------------------------
173 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
178 meta_forward($_SERVER['PHP_SELF']);
182 //---------------------------------------------------------------------------------------------
184 if (isset($_GET['delete']))
190 //---------------------------------------------------------------------------------------------
193 start_form(false, true);
195 if (!isset($_POST['curr_abrev']))
196 $_POST['curr_abrev'] = get_global_curr_code();
198 echo _("Select a currency :") . " ";
199 currencies_list('curr_abrev', $_POST['curr_abrev'], true);
201 // if currency sel has changed, clear the form
202 if ($_POST['curr_abrev'] != get_global_curr_code())
208 set_global_curr_code($_POST['curr_abrev']);
210 if (is_company_currency($_POST['curr_abrev']))
213 display_note(_("The selected currency is the company currency."), 2);
214 display_note(_("The company currency is the base currency so exchange rates cannot be set for it."), 1);
219 display_rates($_POST['curr_abrev']);
221 hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter a New Exchange Rate"));