aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJesús <heckyel@hyperbola.info>2020-11-25 22:11:05 -0500
committerJesús <heckyel@hyperbola.info>2020-11-25 22:11:05 -0500
commit1ba813fcd1262e3dc82999142c4c14809eb1c561 (patch)
tree30517d10d44d928cd555d75c0a6bdb8cb230f40e
parent7ee210e15025635076d89e7865fc39a3baae3d2a (diff)
downloadlibrecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.tar.lz
librecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.tar.xz
librecart-1ba813fcd1262e3dc82999142c4c14809eb1c561.zip
Fix whitespace
-rw-r--r--public/admin/model/localisation/currency.php230
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'];
+ }
}