| 1: | <?php
|
| 2: | namespace Opencart\Catalog\Model\Localisation;
|
| 3: | |
| 4: | |
| 5: | |
| 6: | |
| 7: |
|
| 8: | class Language extends \Opencart\System\Engine\Model {
|
| 9: | |
| 10: | |
| 11: |
|
| 12: | private array $data = [];
|
| 13: |
|
| 14: | |
| 15: | |
| 16: | |
| 17: | |
| 18: | |
| 19: | |
| 20: |
|
| 21: | public function getLanguage(int $language_id): array {
|
| 22: | if (isset($this->data[$language_id])) {
|
| 23: | return $this->data[$language_id];
|
| 24: | }
|
| 25: |
|
| 26: | $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "language` WHERE `language_id` = '" . (int)$language_id . "'");
|
| 27: |
|
| 28: | $language = $query->row;
|
| 29: |
|
| 30: | if ($language) {
|
| 31: | $language['image'] = HTTP_SERVER;
|
| 32: |
|
| 33: | if (!$language['extension']) {
|
| 34: | $language['image'] .= 'catalog/';
|
| 35: | } else {
|
| 36: | $language['image'] .= 'extension/' . $language['extension'] . '/catalog/';
|
| 37: | }
|
| 38: |
|
| 39: | $language['image'] .= 'language/' . $language['code'] . '/' . $language['code'] . '.png';
|
| 40: | }
|
| 41: |
|
| 42: | $this->data[$language_id] = $language;
|
| 43: |
|
| 44: | return $language;
|
| 45: | }
|
| 46: |
|
| 47: | |
| 48: | |
| 49: | |
| 50: | |
| 51: | |
| 52: | |
| 53: |
|
| 54: | public function getLanguageByCode(string $code): array {
|
| 55: | if (isset($this->data[$code])) {
|
| 56: | return $this->data[$code];
|
| 57: | }
|
| 58: |
|
| 59: | $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "language` WHERE `code` = '" . $this->db->escape($code) . "'");
|
| 60: |
|
| 61: | $language = $query->row;
|
| 62: |
|
| 63: | if ($language) {
|
| 64: | $language['image'] = HTTP_SERVER;
|
| 65: |
|
| 66: | if (!$language['extension']) {
|
| 67: | $language['image'] .= 'catalog/';
|
| 68: | } else {
|
| 69: | $language['image'] .= 'extension/' . $language['extension'] . '/catalog/';
|
| 70: | }
|
| 71: |
|
| 72: | $language['image'] .= 'language/' . $language['code'] . '/' . $language['code'] . '.png';
|
| 73: | }
|
| 74: |
|
| 75: | $this->data[$code] = $language;
|
| 76: |
|
| 77: | return $language;
|
| 78: | }
|
| 79: |
|
| 80: | |
| 81: | |
| 82: | |
| 83: | |
| 84: |
|
| 85: | public function getLanguages(): array {
|
| 86: | $sql = "SELECT * FROM `" . DB_PREFIX . "language` WHERE `status` = '1' ORDER BY `sort_order`, `name`";
|
| 87: |
|
| 88: | $results = $this->cache->get('language.' . md5($sql));
|
| 89: |
|
| 90: | if (!$results) {
|
| 91: | $query = $this->db->query($sql);
|
| 92: |
|
| 93: | $results = $query->rows;
|
| 94: |
|
| 95: | $this->cache->set('language.' . md5($sql), $results);
|
| 96: | }
|
| 97: |
|
| 98: | $language_data = [];
|
| 99: |
|
| 100: | foreach ($results as $result) {
|
| 101: | $image = HTTP_SERVER;
|
| 102: |
|
| 103: | if (!$result['extension']) {
|
| 104: | $image .= 'catalog/';
|
| 105: | } else {
|
| 106: | $image .= 'extension/' . $result['extension'] . '/catalog/';
|
| 107: | }
|
| 108: |
|
| 109: | $language_data[$result['code']] = [
|
| 110: | 'language_id' => $result['language_id'],
|
| 111: | 'name' => $result['name'],
|
| 112: | 'code' => $result['code'],
|
| 113: | 'image' => $image . 'language/' . $result['code'] . '/' . $result['code'] . '.png',
|
| 114: | 'locale' => $result['locale'],
|
| 115: | 'extension' => $result['extension'],
|
| 116: | 'sort_order' => $result['sort_order'],
|
| 117: | 'status' => $result['status']
|
| 118: | ];
|
| 119: | }
|
| 120: |
|
| 121: | return $language_data;
|
| 122: | }
|
| 123: | }
|
| 124: | |