diff options
author | Jesús <heckyel@hyperbola.info> | 2020-11-25 22:11:05 -0500 |
---|---|---|
committer | Jesús <heckyel@hyperbola.info> | 2020-11-25 22:11:05 -0500 |
commit | 1ba813fcd1262e3dc82999142c4c14809eb1c561 (patch) | |
tree | 30517d10d44d928cd555d75c0a6bdb8cb230f40e | |
parent | 7ee210e15025635076d89e7865fc39a3baae3d2a (diff) | |
download | librecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.tar.lz librecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.tar.xz librecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.zip |
Fix whitespace
-rw-r--r-- | public/admin/model/localisation/currency.php | 230 |
1 files changed, 115 insertions, 115 deletions
diff --git a/public/admin/model/localisation/currency.php b/public/admin/model/localisation/currency.php index 7ea4769..8db7cd7 100644 --- a/public/admin/model/localisation/currency.php +++ b/public/admin/model/localisation/currency.php @@ -1,159 +1,159 @@ <?php class ModelLocalisationCurrency extends Model { - public function addCurrency($data) { - $this->db->query("INSERT INTO " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW()"); + public function addCurrency($data) { + $this->db->query("INSERT INTO " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW()"); - $currency_id = $this->db->getLastId(); + $currency_id = $this->db->getLastId(); - if ($this->config->get('config_currency_auto')) { - $this->refresh(true); - } + if ($this->config->get('config_currency_auto')) { + $this->refresh(true); + } - $this->cache->delete('currency'); + $this->cache->delete('currency'); - return $currency_id; - } + return $currency_id; + } - public function editCurrency($currency_id, $data) { - $this->db->query("UPDATE " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW() WHERE currency_id = '" . (int)$currency_id . "'"); + public function editCurrency($currency_id, $data) { + $this->db->query("UPDATE " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW() WHERE currency_id = '" . (int)$currency_id . "'"); - $this->cache->delete('currency'); - } + $this->cache->delete('currency'); + } - public function deleteCurrency($currency_id) { - $this->db->query("DELETE FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'"); + public function deleteCurrency($currency_id) { + $this->db->query("DELETE FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'"); - $this->cache->delete('currency'); - } + $this->cache->delete('currency'); + } - public function getCurrency($currency_id) { - $query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'"); + public function getCurrency($currency_id) { + $query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'"); - return $query->row; - } + return $query->row; + } - public function getCurrencyByCode($currency) { - $query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($currency) . "'"); + public function getCurrencyByCode($currency) { + $query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($currency) . "'"); - return $query->row; - } + return $query->row; + } - public function getCurrencies($data = array()) { - if ($data) { - $sql = "SELECT * FROM " . DB_PREFIX . "currency"; + public function getCurrencies($data = array()) { + if ($data) { + $sql = "SELECT * FROM " . DB_PREFIX . "currency"; - $sort_data = array( - 'title', - 'code', - 'value', - 'date_modified' - ); + $sort_data = array( + 'title', + 'code', + 'value', + 'date_modified' + ); - if (isset($data['sort']) && in_array($data['sort'], $sort_data)) { - $sql .= " ORDER BY " . $data['sort']; - } else { - $sql .= " ORDER BY title"; - } + if (isset($data['sort']) && in_array($data['sort'], $sort_data)) { + $sql .= " ORDER BY " . $data['sort']; + } else { + $sql .= " ORDER BY title"; + } - if (isset($data['order']) && ($data['order'] == 'DESC')) { - $sql .= " DESC"; - } else { - $sql .= " ASC"; - } + if (isset($data['order']) && ($data['order'] == 'DESC')) { + $sql .= " DESC"; + } else { + $sql .= " ASC"; + } - if (isset($data['start']) || isset($data['limit'])) { - if ($data['start'] < 0) { - $data['start'] = 0; - } + if (isset($data['start']) || isset($data['limit'])) { + if ($data['start'] < 0) { + $data['start'] = 0; + } - if ($data['limit'] < 1) { - $data['limit'] = 20; - } + if ($data['limit'] < 1) { + $data['limit'] = 20; + } - $sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit']; - } + $sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit']; + } - $query = $this->db->query($sql); + $query = $this->db->query($sql); - return $query->rows; - } else { - $currency_data = $this->cache->get('currency'); + return $query->rows; + } else { + $currency_data = $this->cache->get('currency'); - if (!$currency_data) { - $currency_data = array(); + if (!$currency_data) { + $currency_data = array(); - $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency ORDER BY title ASC"); + $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency ORDER BY title ASC"); - foreach ($query->rows as $result) { - $currency_data[$result['code']] = array( - 'currency_id' => $result['currency_id'], - 'title' => $result['title'], - 'code' => $result['code'], - 'symbol_left' => $result['symbol_left'], - 'symbol_right' => $result['symbol_right'], - 'decimal_place' => $result['decimal_place'], - 'value' => $result['value'], - 'status' => $result['status'], - 'date_modified' => $result['date_modified'] - ); - } + foreach ($query->rows as $result) { + $currency_data[$result['code']] = array( + 'currency_id' => $result['currency_id'], + 'title' => $result['title'], + 'code' => $result['code'], + 'symbol_left' => $result['symbol_left'], + 'symbol_right' => $result['symbol_right'], + 'decimal_place' => $result['decimal_place'], + 'value' => $result['value'], + 'status' => $result['status'], + 'date_modified' => $result['date_modified'] + ); + } - $this->cache->set('currency', $currency_data); - } + $this->cache->set('currency', $currency_data); + } - return $currency_data; - } - } + return $currency_data; + } + } - public function refresh($force = false) { - $currency_data = array(); + public function refresh($force = false) { + $currency_data = array(); - if ($force) { - $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'"); - } else { - $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "' AND date_modified < '" . $this->db->escape(date('Y-m-d H:i:s', strtotime('-1 day'))) . "'"); - } + if ($force) { + $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'"); + } else { + $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "' AND date_modified < '" . $this->db->escape(date('Y-m-d H:i:s', strtotime('-1 day'))) . "'"); + } - foreach ($query->rows as $result) { - $currency_data[] = $this->config->get('config_currency') . $result['code'] . '=X'; - $currency_data[] = $result['code'] . $this->config->get('config_currency') . '=X'; - } + foreach ($query->rows as $result) { + $currency_data[] = $this->config->get('config_currency') . $result['code'] . '=X'; + $currency_data[] = $result['code'] . $this->config->get('config_currency') . '=X'; + } - $curl = curl_init(); + $curl = curl_init(); - curl_setopt($curl, CURLOPT_URL, 'http://download.finance.yahoo.com/d/quotes.csv?s=' . implode(',', $currency_data) . '&f=sl1&e=.json'); - curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); - curl_setopt($curl, CURLOPT_HEADER, false); - curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 30); - curl_setopt($curl, CURLOPT_TIMEOUT, 30); + curl_setopt($curl, CURLOPT_URL, 'http://download.finance.yahoo.com/d/quotes.csv?s=' . implode(',', $currency_data) . '&f=sl1&e=.json'); + curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); + curl_setopt($curl, CURLOPT_HEADER, false); + curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 30); + curl_setopt($curl, CURLOPT_TIMEOUT, 30); - $content = curl_exec($curl); + $content = curl_exec($curl); - curl_close($curl); + curl_close($curl); - $line = explode("\n", trim($content)); - - for ($i = 0; $i < count($line); $i = $i + 2) { - $currency = utf8_substr($line[$i], 4, 3); - $value = utf8_substr($line[$i], 11, 6); + $line = explode("\n", trim($content)); + + for ($i = 0; $i < count($line); $i = $i + 2) { + $currency = utf8_substr($line[$i], 4, 3); + $value = utf8_substr($line[$i], 11, 6); if ((float)$value < 1 && isset($line[$i + 1]) && is_numeric(($line[$i + 1]))) { - $value = (1 / utf8_substr($line[$i + 1], 11, 6)); - } + $value = (1 / utf8_substr($line[$i + 1], 11, 6)); + } - if ((float)$value) { - $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE code = '" . $this->db->escape($currency) . "'"); - } - } + if ((float)$value) { + $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE code = '" . $this->db->escape($currency) . "'"); + } + } - $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '1.00000', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'"); + $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '1.00000', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'"); - $this->cache->delete('currency'); - } + $this->cache->delete('currency'); + } - public function getTotalCurrencies() { - $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "currency"); + public function getTotalCurrencies() { + $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "currency"); - return $query->row['total']; - } + return $query->row['total']; + } } |