5 include_once($path_to_root . "/includes/session.inc");
7 page(_("Exchange Rates"));
9 include_once($path_to_root . "/includes/date_functions.inc");
10 include_once($path_to_root . "/includes/ui.inc");
11 include_once($path_to_root . "/includes/banking.inc");
13 //---------------------------------------------------------------------------------------------
15 if (isset($_GET['selected_id']))
17 $selected_id = $_GET['selected_id'];
19 elseif (isset($_POST['selected_id']))
21 $selected_id = $_POST['selected_id'];
25 //---------------------------------------------------------------------------------------------
29 if (!is_date($_POST['date_']))
31 display_error( _("The entered date is invalid."));
34 if (!is_numeric($_POST['BuyRate']))
36 display_error( _("The exchange rate must be numeric."));
39 if ($_POST['BuyRate'] <= 0)
41 display_error( _("The exchange rate cannot be zero or a negative number."));
48 //---------------------------------------------------------------------------------------------
50 function handle_submit()
57 if ($selected_id != "")
60 update_exchange_rate($_POST['curr_abrev'], $_POST['date_'], $_POST['BuyRate'],
66 add_exchange_rate($_POST['curr_abrev'], $_POST['date_'], $_POST['BuyRate'],
73 //---------------------------------------------------------------------------------------------
75 function handle_delete()
79 if ($selected_id == "")
81 delete_exchange_rate($selected_id);
83 meta_forward($_SERVER['PHP_SELF']);
86 //---------------------------------------------------------------------------------------------
88 function display_rates($curr_code)
92 $result = get_exchange_rates($curr_code);
95 start_table($table_style);
96 $th = array(_("Date to Use From"), _("Exchange Rate"), "", "");
99 $k = 0; //row colour counter
101 while ($myrow = db_fetch($result))
104 alt_table_row_color($k);
106 label_cell(sql2date($myrow["date_"]));
107 label_cell(number_format2($myrow["rate_buy"], user_exrate_dec()), "nowrap align=right");
108 edit_link_cell("selected_id=" . $myrow["id"]);
109 delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
113 } //END WHILE LIST LOOP
118 //---------------------------------------------------------------------------------------------
120 function display_rate_edit()
122 global $selected_id, $table_style2;
124 start_table($table_style2);
126 if (isset($_POST['get_rate']))
128 $_POST['BuyRate'] = get_ecb_rate($_POST['curr_abrev']);
129 $_POST['BuyRate'] = number_format($_POST['BuyRate'], user_exrate_dec());
131 if ($selected_id != "")
133 //editing an existing payment terms
135 $myrow = get_exchange_rate($selected_id);
137 $_POST['date_'] = sql2date($myrow["date_"]);
138 $_POST['BuyRate'] = $myrow["rate_buy"];
140 hidden('selected_id', $selected_id);
141 hidden('date_', $_POST['date_']);
142 hidden('curr_abrev', $_POST['curr_abrev']);
144 label_row(_("Date to Use From:"), $_POST['date_']);
148 date_row(_("Date to Use From:"), 'date_');
150 text_row(_("Exchange Rate:"), 'BuyRate', null, 15, 12, "", submit('get_rate',_("Get"), false));
154 submit_add_or_update_center($selected_id == "");
156 display_note(_("Exchange rates are entered against the company currency."), 1);
159 //---------------------------------------------------------------------------------------------
161 function clear_data()
163 unset($_POST['selected_id']);
164 unset($_POST['date_']);
165 unset($_POST['BuyRate']);
168 //---------------------------------------------------------------------------------------------
170 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
175 meta_forward($_SERVER['PHP_SELF']);
179 //---------------------------------------------------------------------------------------------
181 if (isset($_GET['delete']))
187 //---------------------------------------------------------------------------------------------
190 start_form(false, true);
192 if (!isset($_POST['curr_abrev']))
193 $_POST['curr_abrev'] = get_global_curr_code();
195 echo _("Select a currency :") . " ";
196 currencies_list('curr_abrev', $_POST['curr_abrev'], true);
198 // if currency sel has changed, clear the form
199 if ($_POST['curr_abrev'] != get_global_curr_code())
205 set_global_curr_code($_POST['curr_abrev']);
207 if (is_company_currency($_POST['curr_abrev']))
210 display_note(_("The selected currency is the company currency."), 2);
211 display_note(_("The company currency is the base currency so exchange rates cannot be set for it."), 1);
216 display_rates($_POST['curr_abrev']);
218 hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter a New Exchange Rate"));