| Server IP : 85.193.89.191 / Your IP : 18.220.110.239 Web Server : Apache System : Linux 956367-cx40159.tmweb.ru 3.10.0-1160.105.1.el7.x86_64 #1 SMP Thu Dec 7 15:39:45 UTC 2023 x86_64 User : bitrix ( 600) PHP Version : 8.1.27 Disable Function : NONE MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/bitrix/www/bitrix/modules/currency/mysql/ |
Upload File : |
<?
use Bitrix\Currency;
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/currency/general/currency_rate.php");
class CCurrencyRates extends CAllCurrencyRates
{
public static function _get_last_rates($valDate, $cur)
{
global $DB;
$baseCurrency = Currency\CurrencyManager::getBaseCurrency();
$strSql = $DB->TopSql("
SELECT C.AMOUNT, C.AMOUNT_CNT, CR.RATE, CR.RATE_CNT
FROM
b_catalog_currency C
LEFT JOIN b_catalog_currency_rate CR ON (
C.CURRENCY = CR.CURRENCY AND CR.DATE_RATE < '".$DB->ForSql($valDate)."' AND CR.BASE_CURRENCY = '".$DB->ForSql($baseCurrency)."'
)
WHERE
C.CURRENCY = '".$DB->ForSql($cur)."'
ORDER BY
DATE_RATE DESC
", 1);
$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
return $db_res->Fetch();
}
}