function toUAH_update()
{
$realty_ = new Realty();
//получаем актуальный курс
$er = new ExchangeRate();
$data = $er->getExchangeRateByChar3('USD');
$usd = floatval($data->rate) / floatval($data->size);
$data = $er->getExchangeRateByChar3('EUR');
$eur = floatval($data->rate) / floatval($data->size);
$data = $er->getExchangeRateByChar3('RUB');
$rur = floatval($data->rate) / floatval($data->size);
//SELECT * FROM `realty` where id = '37844731-3aaa-65b0-e84b-51b36762ab81'
//UPDATE `realty` SET `currency_uah` = ( `totalcost` * 0.25 ) WHERE id = '37844731-3aaa-65b0-e84b-51b36762ab81'
$query_usd = "UPDATE `realty` SET `currency_uah` = ( `totalcost` * {$usd} ) WHERE UPPER(currency) = 'USD'";
$query_eur = "UPDATE `realty` SET `currency_uah` = ( `totalcost` * {$eur} ) WHERE UPPER(currency) = 'EUR'";
$query_rur = "UPDATE `realty` SET `currency_uah` = ( `totalcost` * {$rur} ) WHERE UPPER(currency) = 'RUR'";
$query_uah = "UPDATE `realty` SET `currency_uah` = `totalcost` WHERE UPPER(currency) = 'UAH'";
$result = $realty_->db->query($query_usd, true);
$result = $realty_->db->query($query_eur, true);
$result = $realty_->db->query($query_rur, true);
$result = $realty_->db->query($query_uah, true);
}
