set_focus('BuyRate');
return false;
}
-
+ if (get_date_exchange_rate($_POST['curr_abrev'], $_POST['date_']))
+ {
+ display_error( _("The exchange rate for the date is already there."));
+ set_focus('date_');
+ return false;
+ }
return true;
}
}
$selected_id = '';
+ clear_data();
}
//---------------------------------------------------------------------------------------------
return;
delete_exchange_rate($selected_id);
$selected_id = '';
+ clear_data();
}
//---------------------------------------------------------------------------------------------
function display_rates($curr_code)
{
- global $table_style;
}
function display_rate_edit()
{
- global $selected_id, $table_style2, $Ajax;
+ global $selected_id, $Ajax;
- start_table($table_style2);
+ start_table(TABLESTYLE2);
if ($selected_id != "")
{
set_global_curr_code($_POST['curr_abrev']);
-$sql = "SELECT date_, rate_buy, id FROM "
- .TB_PREF."exchange_rates "
- ."WHERE curr_code=".db_escape($_POST['curr_abrev'])."
- ORDER BY date_ DESC";
+$sql = get_sql_for_exchange_rates();
$cols = array(
_("Date to Use From") => 'date',
br(1);
$table->width = "40%";
+ if ($table->rec_count == 0)
+ $table->ready = false;
display_db_pager($table);
br(1);
display_rate_edit();