Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/amember.teamhydrashop.com/public_html/amember/library/Am/Model

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: CurrencyExchange.php

<?php
/**
 * Class represents records from table currency_exchange
 * {autogenerated}
 * @property int $rate_id
 * @property string $currency
 * @property date $date
 * @property double $rate
 * @see Am_Table
 */
class CurrencyExchange extends Am_Record
{
    function insert($reload = true)
    {
        if (empty($this->base)) {
            $this->base = Am_Currency::getDefault();
        }
        return parent::insert($reload);
    }
}

class CurrencyExchangeTable extends Am_Table
{
    protected $_key = 'rate_id';
    protected $_table = '?_currency_exchange';

/**
     * Get actual rate for currency to date
     * @param string $currency example "EUR"
     * @param type $date "2011-01-23"
     * @return double|null
     */
    function getRate($currency, $date)
    {
        $base = Am_Currency::getDefault();

$ret = $this->_db->selectCell(<<<CUT
            SELECT ROUND(IF(currency=?, rate, 1/rate), 6)
                FROM ?_currency_exchange
                WHERE
                    ((currency=? AND base=?) OR (currency=? AND base=?))
                    AND `date`<=?
                ORDER BY `date` DESC
                LIMIT 1;
CUT
            , $currency, $currency, $base, $base, $currency, $date);
        if (empty($ret)) $ret = 1.00;
        return $ret;
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: CurrencyExchange.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation