GetRatesData(); } function GetRatesData() { $cache_key = 'currency_rates[%CurrSerial%]'; $rates = $this->Application->getCache($cache_key); $primary = $this->Application->GetPrimaryCurrency(); if ($rates === false) { $this->Conn->nextQueryCachable = true; $sql = 'SELECT ISO, RateToPrimary FROM ' . $this->Application->getUnitOption('curr', 'TableName') . ' WHERE Status = ' . STATUS_ACTIVE; $rates = $this->Conn->Query($sql); $this->Application->setCache($cache_key, $rates); } foreach ($rates as $rate) { $this->SetRate($primary, $rate['ISO'], $rate['RateToPrimary']); } } function GetRate($source_cur, $target_cur, $units = 1) { $source_cur = ($source_cur == 'PRIMARY') ? $this->Application->GetPrimaryCurrency() : $source_cur; $target_cur = ($target_cur == 'PRIMARY') ? $this->Application->GetPrimaryCurrency() : $target_cur; if($source_cur == $target_cur) { return 1; } if($this->ExchangeRates[$target_cur]['TARGET'] == $source_cur) { $rate = ($this->ExchangeRates[$target_cur]['RATE'] == 0) ? false : 1 / $this->ExchangeRates[$target_cur]['RATE']; } elseif($this->ExchangeRates[$source_cur]['TARGET'] == $target_cur) { $rate = $this->ExchangeRates[$source_cur]['RATE']; } else { $rate = ($this->ExchangeRates[$target_cur]['RATE'] == 0) ? false : $this->ExchangeRates[$source_cur]['RATE'] / $this->ExchangeRates[$target_cur]['RATE']; } $rate *= $units; return $rate; } function Convert($amount, $source_cur, $target_cur) { return $amount * $this->GetRate($source_cur, $target_cur); } function SetRate($source_cur, $target_cur, $rate, $units = 1) { $this->ExchangeRates[$target_cur]['TARGET'] = $source_cur; $this->ExchangeRates[$target_cur]['ID'] = $target_cur; $this->ExchangeRates[$target_cur]['RATE'] = $rate; $this->ExchangeRates[$target_cur]['UNITS'] = $units; } function StoreRates($currencies=null) { $curr_object = $this->Application->recallObject('curr', null, Array ('skip_autoload' => true)); /* @var $curr_object kDBItem */ if ($currencies) { if (!is_array($currencies)) { $currencies = explode(',', $currencies); } } else { $currencies = array_keys($this->ExchangeRates); } foreach ($currencies as $id) { $rate = $this->GetRate($id, 'PRIMARY'); if ($rate) { $curr_object->Clear(); $curr_object->Load($id, 'ISO'); $curr_object->SetDBField('RateToPrimary', $rate); $curr_object->SetDBField('Modified_date', adodb_mktime()); $curr_object->SetDBField('Modified_time', adodb_mktime()); $curr_object->Update(); } } } }