([\d|.]+)\s+{$curr_b}\s*%s";
if (preg_match($regexp, $contents, $matches))
{
@@ -170,18 +222,28 @@ function get_extern_rate($curr_b, $provider = 'ECB', $date)
if ($val != 0)
$val = 1 / $val;
}
+ }
+ elseif ($provider == 'BLOOMBERG')
+ {
+ $val = '';
+ $stmask = '';
+ $val = strstr($contents, $stmask);
+ $val = trim($val);
+ $val = substr($val, strlen($stmask));
+ $stmask = '
';
+ $val = strtok($val, $stmask);
+ $val = trim($val);
}
return $val;
} /* end function get_extern_rate */
//-----------------------------------------------------------------------------
-function get_sql_for_exchange_rates()
+function get_sql_for_exchange_rates($curr)
{
- $sql = "SELECT date_, rate_buy, id FROM "
- .TB_PREF."exchange_rates "
- ."WHERE curr_code=".db_escape($_POST['curr_abrev'])."
+ $sql = "SELECT date_, rate_buy, id
+ FROM ".TB_PREF."exchange_rates "
+ ."WHERE curr_code=".db_escape($curr)."
ORDER BY date_ DESC";
return $sql;
}
-?>
\ No newline at end of file