Exemple #1
0
 public function getCountries($data = array())
 {
     $cache = 'countries.' . json_encode($data);
     $return = Cache::find($cache);
     if (is_array($return)) {
         return $return;
     }
     $sql = "SELECT * FROM PREFIX_country";
     $sort_data = array('name', 'iso_code_2', 'iso_code_3');
     if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
         $sql .= " ORDER BY " . $data['sort'];
     } else {
         $sql .= " ORDER BY name";
     }
     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 ($data['limit'] < 1) {
             $data['limit'] = 20;
         }
         $sql .= " LIMIT " . (int) $data['start'] . "," . (int) $data['limit'];
     }
     $return = $this->fetchAll($sql);
     Cache::set($cache, $return);
     return $return;
 }
Exemple #2
0
 public function getGeoZones($data = array())
 {
     if ($data) {
         $sql = "SELECT * FROM PREFIX_geo_zone";
         $sort_data = array('name', 'description');
         if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
             $sql .= " ORDER BY " . $data['sort'];
         } else {
             $sql .= " ORDER BY name";
         }
         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 ($data['limit'] < 1) {
                 $data['limit'] = 20;
             }
             $sql .= " LIMIT " . (int) $data['start'] . "," . (int) $data['limit'];
         }
         return $this->fetchAll($sql);
     } else {
         $data = Cache::find('geo_zone');
         if (!$data) {
             $data = $this->fetchAll("SELECT * FROM PREFIX_geo_zone ORDER BY name ASC");
             Cache::set('geo_zone', $data);
         }
         return $data;
     }
 }
 public function getWeightClasses($data = array())
 {
     if ($data) {
         $sql = "SELECT * FROM " . DB_PREFIX . "weight_class wc LEFT JOIN " . DB_PREFIX . "weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '" . (int) $this->config->get('config_language_id') . "'";
         $sort_data = array('title', 'unit', 'value');
         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['start']) || isset($data['limit'])) {
             if ($data['start'] < 0) {
                 $data['start'] = 0;
             }
             if ($data['limit'] < 1) {
                 $data['limit'] = 20;
             }
             $sql .= " LIMIT " . (int) $data['start'] . "," . (int) $data['limit'];
         }
         $query = $this->db->query($sql);
         return $query->rows;
     } else {
         $weight_class_data = Cache::find('weight_class.' . (int) $this->config->get('language_id'));
         if (!$weight_class_data) {
             $weight_class_data = $this->fetchAll("SELECT * FROM PREFIX_weight_class wc\n                    LEFT JOIN PREFIX_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)\n                    WHERE wcd.language_id = '" . (int) $this->config->get('language_id') . "'");
             Cache::set('weight_class.' . (int) $this->config->get('language_id'), $weight_class_data);
         }
         return $weight_class_data;
     }
 }
 public function getExtensions($type)
 {
     $cache = Cache::find('extensions.' . $this->config->get('config_store_id'), $type);
     if (!is_array($cache)) {
         $cache = Database::fetchAll("SELECT * FROM PREFIX_extension WHERE `type` = :type", array('type' => $type));
         Cache::set('extensions.' . $this->config->get('config_store_id'), $type, $cache);
     }
     return $cache;
 }
Exemple #5
0
 public function getZonesByCountryId($country_id)
 {
     $zone_data = Cache::find('zone.' . (int) $country_id);
     if (!$zone_data) {
         $zone_data = $this->fetchAll("SELECT * FROM PREFIX_zone WHERE country_id = :id AND status = 1 ORDER BY name", array('id' => $country_id));
         Cache::set('zone.' . (int) $country_id, $zone_data);
     }
     return $zone_data;
 }
Exemple #6
0
 public function getStores($data = array())
 {
     $store_data = Cache::find('store');
     if (!$store_data || !is_array($store_data) || empty($store_data)) {
         $store_data = Database::fetchAll("SELECT * FROM PREFIX_store ORDER BY url");
         Cache::set('store', $store_data);
     }
     return $store_data;
 }
 protected function index($setting)
 {
     $this->data['heading_title'] = Language::getVar('SUMO_PRODUCT_BESTSELLER');
     $this->load->model('catalog/product');
     $this->load->model('tool/image');
     if ($this->registry->get('builder')) {
         $this->data['settings'] = Cache::find('builder');
     }
     $this->data['products'] = array();
     $results = $this->model_catalog_product->getBestSellerProducts($setting['limit']);
     foreach ($results as $result) {
         if ($result['image']) {
             $image = $this->model_tool_image->resize($result['image'], $setting['image_width'], $setting['image_height']);
         } else {
             $image = false;
         }
         $swapimages = $this->model_catalog_product->getProductImages($result['product_id']);
         if ($swapimages) {
             $swapimage = $this->model_tool_image->resize($swapimages[0]['image'], $this->config->get('config_image_related_width'), $this->config->get('config_image_related_height'), 'h');
         } else {
             $swapimage = false;
         }
         if ($this->config->get('config_customer_price') && $this->customer->isLogged() || !$this->config->get('config_customer_price')) {
             $price = $this->currency->format($this->tax->calculate($result['price'], $result['tax_class_id'], $this->config->get('config_tax')));
         } else {
             $price = false;
         }
         if ((double) $result['special']) {
             $special = $this->currency->format($this->tax->calculate($result['special'], $result['tax_class_id'], $this->config->get('config_tax')));
         } else {
             $special = false;
         }
         if ($this->config->get('config_review_status')) {
             $rating = $result['rating'];
         } else {
             $rating = false;
         }
         if ($result['reviews']) {
             if ($result['reviews'] > 1) {
                 $reviews = Language::getVar('SUMO_PRODUCT_REVIEWS_PLURAL', $result['reviews']);
             } else {
                 $reviews = Language::getVar('SUMO_PRODUCT_REVIEWS_SINGULAR');
             }
         } else {
             $reviews = Language::getVar('SUMO_PRODUCT_REVIEWS_NONE');
         }
         $this->data['products'][] = array('product_id' => $result['product_id'], 'thumb' => $image, 'thumb_swap' => $swapimage, 'name' => $result['name'], 'price' => $price, 'special' => $special, 'rating' => $rating, 'reviews' => $reviews, 'href' => $this->url->link('product/product', 'path=' . $result['category_id'] . '&product_id=' . $result['product_id']));
     }
     if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/bestseller.tpl')) {
         $this->template = $this->config->get('config_template') . '/template/module/bestseller.tpl';
     } else {
         $this->template = 'default/template/module/bestseller.tpl';
     }
     if (count($this->data['products'])) {
         $this->render();
     }
 }
 public function getBlogs()
 {
     $data = Cache::find('blogs');
     if (count($data)) {
         return $data;
     }
     $query = $this->fetchAll("SELECT * FROM PREFIX_blog i LEFT JOIN PREFIX_blog_description id ON (i.blog_id = id.blog_id)  WHERE id.language_id = '" . (int) $this->config->get('language_id') . "' AND i.store_id = '" . (int) $this->config->get('store_id') . "' AND i.status = '1' AND i.publish_date < NOW() ORDER BY i.publish_date DESC");
     Cache::set('blogs', $query);
     return $query->rows;
 }
Exemple #9
0
 public function getZonesByCountryId($country_id)
 {
     $cache = 'zones.' . $country_id;
     $data = Cache::find($cache);
     if (!is_array($data) || !count($data)) {
         $data = $this->fetchAll("SELECT * FROM PREFIX_zone WHERE country_id = :id AND status = 1 ORDER BY name", array('id' => $country_id));
         Cache::set($cache, $data);
     }
     return $data;
 }
Exemple #10
0
 public function getDashboardItems()
 {
     $active = $this->getActiveMenu();
     $return = Cache::find('adi_' . md5($active));
     if (!is_array($return)) {
         $return = Database::fetchAll("\n                SELECT *\n                FROM PREFIX_admin_menu\n                WHERE parent_id = (SELECT menu_id FROM PREFIX_admin_menu WHERE url = :url)\n                    OR url = :url2\n                ORDER BY sort_order ASC, parent_id ASC", array('url' => $active, 'url2' => $active));
         Cache::set('admin_menu.adi_' . md5($active), $return);
     }
     return $return;
 }
 public function getOrderStatuses($data = array())
 {
     $cache = 'order_status.' . $this->config->get('language_id');
     $data = Cache::find($cache);
     if (is_array($data) && count($data)) {
         return $data;
     }
     $data = $this->fetchAll("SELECT order_status_id, name FROM PREFIX_order_status WHERE language_id = :id ORDER BY name", array('id' => $this->config->get('language_id')));
     Cache::set($cache, $data);
     return $data;
 }
Exemple #12
0
 public function getCountries()
 {
     $cache = 'countries';
     $data = Cache::find($cache);
     if (is_array($cache) && count($cache)) {
         return $data;
     }
     $data = self::fetchAll("SELECT * FROM PREFIX_country WHERE status = 1 ORDER BY name ASC");
     Cache::set($cache, $data);
     return $data;
 }
Exemple #13
0
 public function getTotalCategoriesByCategoryId($parent_id = 0)
 {
     $cacheFile = 'categories.totals-' . $parent_id . '-' . (int) $this->config->get('language-id') . '-' . (int) $this->config->get('store_id');
     $cache = Cache::find($cacheFile);
     if (is_array($cache) && count($cache)) {
         return $cache;
     }
     $result = self::query("SELECT COUNT(*) AS total FROM PREFIX_category c LEFT JOIN PREFIX_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int) $parent_id . "' AND c2s.store_id = '" . (int) $this->config->get('store_id') . "' AND c.status = '1'")->fetch();
     Cache::set($cacheFile, $result);
     return $result;
 }
Exemple #14
0
 public function getLayout($route)
 {
     $cacheFile = 'settings.layouts.' . $this->config->get('config_store_id');
     $cache = Cache::find($cacheFile, $route);
     if ($cache !== null) {
         return $cache;
     }
     $fallback = explode('/', $route);
     $result = Database::query("SELECT * FROM PREFIX_layout_route WHERE (:route LIKE CONCAT(route, '%') OR :fallback LIKE CONCAT(route, '%')) AND store_id = :store ORDER BY route DESC LIMIT 1", array('route' => $route, 'fallback' => $fallback[0] . '/', 'store' => $this->config->get('config_store_id')))->fetch();
     Cache::set($cacheFile, $route, $result['layout_id']);
     return $result['layout_id'];
 }
Exemple #15
0
 public function __construct($registry)
 {
     $this->db = $registry->get('db');
     $this->config = $registry->get('config');
     $lengths = Cache::find('lengths.' . $this->config->get('config_language_id'));
     if (!is_array($lengths)) {
         $lengths = Database::fetchAll("SELECT * FROM PREFIX_length_class AS lc LEFT JOIN PREFIX_length_class_description AS lcd ON (lc.length_class_id = lcd.length_class_id) WHERE lcd.language_id = :lang", array('lang' => $this->config->get('config_language_id')));
         Cache::set('lengths.' . $this->config->get('config_language_id'), $lengths);
     }
     foreach ($lengths as $result) {
         $this->lengths[$result['length_class_id']] = array('length_class_id' => $result['length_class_id'], 'title' => $result['title'], 'unit' => $result['unit'], 'value' => $result['value']);
     }
 }
Exemple #16
0
 public function __construct($registry)
 {
     $this->db = $registry->get('db');
     $this->config = $registry->get('config');
     $weights = Cache::find('weights.' . $this->config->get('config_language_id'));
     if (!is_array($weights)) {
         $weights = Database::fetchAll("SELECT * FROM PREFIX_weight_class AS wc LEFT JOIN PREFIX_weight_class_description AS wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = :lang", array('lang' => $this->config->get('config_language_id')));
         Cache::set('weights.' . $this->config->get('config_language_id'), $weights);
     }
     foreach ($weights as $result) {
         $this->weights[$result['weight_class_id']] = array('weight_class_id' => $result['weight_class_id'], 'title' => $result['title'], 'unit' => $result['unit'], 'value' => $result['value']);
     }
 }
Exemple #17
0
 public static function getVar($key, $extra = array(), $updateTime = true)
 {
     // If, for instance, an error occures before the setup has fully loaded...
     if (isset(self::$language_id) && class_exists('Sumo\\Cache')) {
         $cache_string = 'language_' . self::$language_id;
         $cache = Cache::find($cache_string, $key);
         if ($cache) {
             return self::parse($cache, $extra);
         }
         $list = Database::query("\n                SELECT value, key_id\n                FROM PREFIX_translations\n                RIGHT JOIN PREFIX_translations_keys\n                ON PREFIX_translations.key_id = PREFIX_translations_keys.id\n                WHERE language_id = " . self::$language_id . "\n                AND name = :key\n            ", array('key' => $key))->fetch();
         if (isset($list['value'])) {
             if (empty($list['value'])) {
                 $list['value'] = $key;
             }
             if ($updateTime) {
                 Database::query("UPDATE PREFIX_translations_keys SET date_used = :date WHERE id = :id", array('id' => $list['key_id'], 'date' => date('Y-m-d H:i:s')));
             }
             Cache::set($cache_string, $key, $list['value']);
             return self::parse($list['value'], $extra);
         } else {
             // Set the key as value
             $value = $key;
             // Check if the key is in the database
             $list2 = Database::query("SELECT id FROM PREFIX_translations_keys WHERE name = :key", array('key' => $key))->fetch();
             // Totally new translation_key should be added
             if (!isset($list2['id'])) {
                 Database::query("INSERT INTO PREFIX_translations_keys\n                        SET name        = :key,\n                            date_added  = :date", array('key' => $key, 'date' => date('Y-m-d H:i:s')));
             } else {
                 // Fallback language
                 $list3 = Database::query("SELECT value FROM PREFIX_translations WHERE key_id = :id AND language_id = :lid", array('id' => $list2['id'], 'lid' => self::$language['fallback']))->fetch();
                 if (!empty($list3['value'])) {
                     $value = $list3['value'];
                 } else {
                     // Absolute fallback, any translation that is not empty?
                     $list3 = Database::query("SELECT value FROM PREFIX_translations WHERE key_id = :id AND value != '' LIMIT 1", array('id' => $list2['id']))->fetch();
                     if (isset($list3['value'])) {
                         $value = $list3['value'];
                     }
                 }
             }
             if ($value != $key) {
                 Cache::set($cache_string, $key, $value);
             }
         }
     } else {
         $value = $key;
     }
     return self::parse($value, $extra);
 }
Exemple #18
0
 public function getSetting($group, $store_id = 0)
 {
     $cacheFile = 'settings.' . $store_id . '.' . strtolower($group);
     $data = Cache::find($cacheFile);
     if (is_array($data) || count($data)) {
         return $data;
     }
     $data = array();
     $result = Database::fetchAll("SELECT `key`, `value`, `serialized` FROM PREFIX_setting WHERE store_id = :id AND `group` = :group", array('id' => $store_id, 'group' => $group));
     foreach ($result as $list) {
         $data[$list['key']] = $result['serialized'] ? unserialize($result['value']) : $result['value'];
     }
     Cache::set($cacheFile, $data);
     return $data;
 }
 public function getManufacturers($data = array())
 {
     if ($data) {
         $sql = "SELECT * FROM PREFIX_manufacturer m LEFT JOIN PREFIX_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m2s.store_id = :store";
         $values = array();
         $values['store'] = $this->config->get('store_id');
         $sort_data = array('name', 'sort_order');
         if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
             $sql .= " ORDER BY :sort";
             $values['sort'] = $data['sort'];
         } else {
             $sql .= " ORDER BY name";
         }
         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 ($data['limit'] < 1) {
                 $data['limit'] = 20;
             }
             $values['start'] = $data['start'];
             $values['limit'] = $data['limit'];
             $sql .= " LIMIT :start,:limit";
         }
         $result = Database::fetchAll($sql, $values);
         return $result;
     } else {
         $manufacturer_data = Cache::find('manufacturer.' . (int) $this->config->get('store_id'));
         if (!$manufacturer_data) {
             $manufacturer_data = Database::fetchAll("SELECT * FROM PREFIX_manufacturer m LEFT JOIN PREFIX_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m2s.store_id = :store ORDER BY name", array('store' => $this->config->get('store_id')));
             Cache::set('manufacturer.' . (int) $this->config->get('store_id'), $manufacturer_data);
         }
         return $manufacturer_data;
     }
 }
 public function index()
 {
     $this->load->model('catalog/manufacturer');
     $this->load->model('tool/image');
     $this->document->setTitle(Language::getVar('SUMO_NOUN_MANUFACTURER_PLURAL'));
     $this->data['heading_title'] = Language::getVar('SUMO_NOUN_MANUFACTURER_PLURAL');
     $this->data['breadcrumbs'] = array();
     $this->data['breadcrumbs'][] = array('text' => Language::getVar('SUMO_NOUN_HOME'), 'href' => $this->url->link('common/home'), 'separator' => false);
     $this->data['breadcrumbs'][] = array('text' => Language::getVar('SUMO_NOUN_MANUFACTURER_PLURAL'), 'href' => $this->url->link('product/manufacturer'));
     $this->data['manufacturers'] = array();
     $cache = 'product.manufacturer.brand.overview';
     $data = Cache::find($cache);
     if (!is_array($data) || !count($data)) {
         $results = $this->model_catalog_manufacturer->getManufacturers();
         foreach ($results as $result) {
             if (is_numeric(utf8_substr($result['name'], 0, 1))) {
                 $key = '0 - 9';
             } else {
                 $key = utf8_substr(utf8_strtoupper($result['name']), 0, 1);
             }
             if (!isset($this->data['manufacturers'][$key])) {
                 $data[$key]['name'] = $key;
             }
             $result['href'] = $this->url->link('product/manufacturer/info', 'manufacturer_id=' . $result['manufacturer_id']);
             $data[$key]['manufacturer'][] = $result;
         }
         Cache::set($cache, $data);
     }
     $this->data['manufacturers'] = $data;
     $this->data['settings'] = $this->config->get('details_product_category_' . $this->config->get('template'));
     if (!is_array($this->data['settings']) || !count($this->data['settings'])) {
         $this->data['settings']['left'][] = $this->getChild('app/widgetsimplesidebar/', array('type' => 'manufacturerTree'));
         $this->data['settings']['left'][] = $this->getChild('app/widgetsimplesidebar/', array('type' => 'banner', 'location' => 'category'));
         //$this->data['settings']['bottom'][] = $this->getChild('app/widgetsimpleproduct', array('type' => 'latest', 'limit' => 6, 'manufacturer_id' => $manufacturer_id));
     }
     $this->template = 'product/manufacturer.tpl';
     $this->children = array('common/column_left', 'common/column_right', 'common/content_top', 'common/content_bottom', 'common/footer', 'common/header');
     $this->response->setOutput($this->render());
 }
Exemple #21
0
 public function __construct($registry)
 {
     $this->config = $registry->get('config');
     $this->language = $registry->get('language');
     $this->request = $registry->get('request');
     $this->session = $registry->get('session');
     $currencies = Cache::find('currencies');
     if (!is_array($currencies)) {
         $currencies = Database::fetchAll("SELECT * FROM PREFIX_currency");
         Cache::set('currencies', $currencies);
     }
     foreach ($currencies as $result) {
         $this->currencies[$result['currency_id']] = $result;
     }
     if (isset($this->request->get['currency']) && array_key_exists($this->request->get['currency'], $this->currencies)) {
         $this->set($this->request->get['currency']);
     } elseif (isset($this->session->data['currency']) && array_key_exists($this->session->data['currency'], $this->currencies)) {
         $this->set($this->session->data['currency']);
     } elseif (isset($this->request->cookie['currency']) && array_key_exists($this->request->cookie['currency'], $this->currencies)) {
         $this->set($this->request->cookie['currency']);
     } else {
         $this->set($this->config->get('currency_id'));
     }
 }
Exemple #22
0
 public function getTotalReturns($data = array())
 {
     unset($data['start']);
     unset($data['limit']);
     $cache = 'return_total_cached.' . json_encode($data);
     $data = Cache::find($cache);
     if (!is_array($data) || !count($data)) {
         $fetch = $this->getReturns($data);
         $data = count($fetch);
         Cache::set($cache, $data);
     }
     return $data;
 }
Exemple #23
0
    public function ajax()
    {
        // Contains results
        $bind = array();
        $data = array();
        if (isset($this->request->get['keyword'])) {
            // Parse all keywords to lowercase
            $keywords = strtolower($this->request->get['keyword']);
            // Perform search only if we have some keywords
            if (strlen($keywords) >= 2) {
                $cache = 'products.search.' . $keywords;
                $data = Cache::find($cache);
                if (!is_array($data) || !count($data)) {
                    $this->load->model('catalog/product');
                    $data = array();
                    $parts = explode(' ', $keywords);
                    $add = '';
                    // Generating search
                    $partcount = 1;
                    foreach ($parts as $part) {
                        $part = '%' . strtolower($part) . '%';
                        $add .= ' AND (LOWER(pd.name) LIKE :part_' . $partcount;
                        $bind['part_' . $partcount] = $part;
                        $partcount++;
                        $add .= ' OR LOWER(p.model) LIKE :part_' . $partcount;
                        $bind['part_' . $partcount] = $part;
                        $partcount++;
                        $add .= ' OR LOWER(p.model_2) LIKE :part_' . $partcount;
                        $bind['part_' . $partcount] = $part;
                        $partcount++;
                        $add .= ' OR LOWER(pd.tag) LIKE :part_' . $partcount;
                        $bind['part_' . $partcount] = $part;
                        $partcount++;
                        $add .= ' )';
                    }
                    $sql = 'SELECT pd.product_id
                    FROM PREFIX_product_description AS pd
                    LEFT JOIN PREFIX_product AS p
                        ON p.product_id = pd.product_id
                    LEFT JOIN PREFIX_product_to_store AS p2s
                        ON p2s.product_id = pd.product_id

                    WHERE 1 = 1 ' . $add . '
                        AND p.status = 1
                        AND pd.language_id = ' . (int) $this->config->get('language_id') . '
                        AND p2s.store_id =  ' . (int) $this->config->get('store_id') . '
                    ORDER BY LOWER(tag) ASC, LOWER(pd.name) ASC, LOWER(p.model) ASC
                    LIMIT 15';
                    $data = Database::fetchAll($sql, $bind);
                    if ($data && count($data)) {
                        $basehref = 'product/product&keyword=' . $this->request->get['keyword'] . '&product_id=';
                        foreach ($data as $key => $list) {
                            $product = $this->model_catalog_product->getProduct($list['product_id']);
                            if ((!$product['stock_visible'] || $product['stock_visible'] == 2 && !$this->config->get('display_stock_empty')) && $product['quantity'] <= 0) {
                                unset($data[$key]);
                                continue;
                            }
                            $data[$key] = array('name' => htmlspecialchars_decode($product['name'], ENT_QUOTES), 'href' => $this->url->link('product/product', 'path=unknown&product_id=' . $product['product_id'] . '&keyword=' . $this->request->get['keyword']));
                        }
                    } else {
                        exit('meh, failure');
                    }
                    Cache::set($cache, $data);
                }
            }
        }
        $this->response->setOutput(json_encode($data));
    }
Exemple #24
0
 public function rewrite($link)
 {
     $link = str_replace('common/home', '', $link);
     $cache = Cache::find('rewrites', $link);
     if ($cache && !empty($cache)) {
         return $cache;
     }
     $url_info = parse_url(str_replace('&amp;', '&', $link));
     if (!empty($url_info['query'])) {
         $url_info['query'] .= '&';
     } else {
         $url_info['query'] = '';
     }
     if (!empty($url_info['path'])) {
         $url_info['query'] .= 'route=' . ltrim(str_replace('.html', '', $url_info['path']), '/');
     }
     $url = '';
     $data = array();
     if (isset($url_info['query'])) {
         parse_str($url_info['query'], $data);
         foreach ($data as $key => $value) {
             if (isset($data['route'])) {
                 if ($data['route'] == 'product/product' && $key == 'product_id' || ($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') {
                     $product = Database::query("SELECT *\n                            FROM PREFIX_url_alias\n                            WHERE `query` = :query\n                            AND (\n                                language_id = :lang\n                                OR language_id = ''\n                            )", array('query' => $key . '=' . $value, 'lang' => $this->config->get('language_id')))->fetch();
                     if (is_array($product)) {
                         $url = rtrim($url, '/') . '/' . strtolower($product['keyword']);
                         $url_info['path'] = '';
                         unset($data[$key]);
                     }
                 } elseif ($key == 'path') {
                     if ($value == 'unknown') {
                         if (isset($data['product_id'])) {
                             $check = Database::query("SELECT category_id FROM PREFIX_product_to_category WHERE product_id = :id ORDER BY category_id DESC LIMIT 1", array('id' => $data['product_id']))->fetch();
                             if (isset($check['category_id'])) {
                                 $path = Database::query("SELECT category_id, path_id, level FROM PREFIX_category_path WHERE path_id = :id", array('id' => $check['category_id']))->fetch();
                                 if ($path['category_id'] == $path['path_id'] && $path['level'] == 0) {
                                     //$desc = Database::query("SELECT name FROM PREFIX_category_description WHERE category_id = :id AND language_id = :lang", array('id' => $check['category_id'], 'lang' => $this->config->get('language_id')))->fetch();
                                     //$url = rtrim($url, '/') . '/' . strtolower($desc['name']) . '/';
                                     $check = Database::query("SELECT * FROM PREFIX_url_alias WHERE `query` = 'category_id=" . (int) $check['category_id'] . "' AND language_id = :lang", array('lang' => $this->config->get('language_id')))->fetch();
                                     if (is_array($check)) {
                                         $url = rtrim($url, '/') . '/' . strtolower($check['keyword']) . '/';
                                         $url_info['path'] = '';
                                     }
                                     $url_info['path'] = '';
                                 } else {
                                     $paths = Database::fetchAll("SELECT path_id FROM PREFIX_category_path WHERE category_id = :id ORDER BY level ASC", array('id' => $path['category_id']));
                                     foreach ($paths as $path) {
                                         $check = Database::query("SELECT * FROM PREFIX_url_alias WHERE `query` = 'category_id=" . (int) $path['path_id'] . "' AND language_id = :lang", array('lang' => $this->config->get('language_id')))->fetch();
                                         if (is_array($check)) {
                                             $url = rtrim($url, '/') . '/' . strtolower($check['keyword']) . '/';
                                             $url_info['path'] = '';
                                         }
                                         //$url = rtrim($url, '/') . '/' . strtolower($desc['name']) . '/';
                                     }
                                     //$url = rtrim($url, '/') . '/-iets-/';
                                 }
                             }
                         }
                         $url_info['path'] = '';
                     } else {
                         $categories = explode('_', $value);
                         foreach ($categories as $category) {
                             $check = Database::query("SELECT * FROM PREFIX_url_alias WHERE `query` = 'category_id=" . (int) $category . "' AND language_id = :lang", array('lang' => $this->config->get('language_id')))->fetch();
                             if (is_array($check)) {
                                 $url = rtrim($url, '/') . '/' . strtolower($check['keyword']) . '/';
                                 $url_info['path'] = '';
                             }
                         }
                     }
                     unset($data[$key]);
                 } else {
                     if ($data['route'] == 'information/information' && $key == 'information_id') {
                         $page = Database::query("SELECT *\n                            FROM PREFIX_url_alias\n                            WHERE `query` = :query\n                            AND (\n                                language_id = :lang\n                                OR language_id = ''\n                            )", array('query' => 'information_id=' . $value, 'lang' => $this->config->get('language_id')))->fetch();
                         if (is_array($page)) {
                             // check for subpage
                             $check = Database::query("\n                                SELECT parent_id\n                                FROM PREFIX_information\n                                WHERE information_id = " . (int) $value)->fetch();
                             if ($check['parent_id']) {
                                 $query2 = Database::query("\n                                    SELECT *\n                                    FROM PREFIX_url_alias\n                                    WHERE `query` = :query\n                                    AND (\n                                        language_id = " . (int) $this->config->get('language_id') . "\n                                        OR language_id = ''\n                                    )", array('query' => $key . '=' . (int) $check['parent_id']))->fetch();
                                 if (count($query2)) {
                                     $url = rtrim($url, '/') . '/' . $query2['keyword'];
                                 }
                             }
                             $url = rtrim($url, '/') . '/' . strtolower($page['keyword']);
                             $url_info['path'] = '';
                             unset($data[$key]);
                         }
                     } else {
                         if ($data['route'] == 'information/blog' && $key == 'blog_id') {
                             $query = Database::query("\n                            SELECT *\n                            FROM PREFIX_url_alias\n                            WHERE `query` = :query\n                            AND (\n                                language_id = " . (int) $this->config->get('language_id') . "\n                                OR language_id = ''\n                            )", array('query' => $key . '=' . $value))->fetch();
                             if (count($query)) {
                                 $url = rtrim($url, '/') . '/blog/' . $query['keyword'];
                                 $url_info['path'] = '';
                                 unset($data[$key]);
                             }
                         }
                     }
                 }
             }
         }
     }
     if ($url) {
         unset($data['route']);
         $query = '';
         if ($data) {
             foreach ($data as $key => $value) {
                 if (is_array($value)) {
                     foreach ($value as $k => $v) {
                         $query .= '&' . $key . '[' . $k . ']=' . $v;
                     }
                 } else {
                     $query .= '&' . $key . '=' . $value;
                 }
             }
             if ($query) {
                 $query = '?' . trim($query, '&');
             }
         }
         $return_url = str_replace('/index.php', '', $url_info['path']);
         $return_url = str_replace($url, '', $return_url) . $url . $query;
         Cache::set('rewrites', $link, $return_url);
         return $return_url;
     } else {
         Cache::set('rewrites', $link, $link);
         return $link;
     }
 }
Exemple #25
0
 protected function index($setting)
 {
     $this->language->load('module/latest');
     $this->data['heading_title'] = $this->language->get('heading_title');
     $this->data['button_cart'] = $this->language->get('button_cart');
     $this->load->model('catalog/product');
     $this->load->model('tool/image');
     if ($this->registry->get('builder')) {
         $this->data['settings'] = Cache::find('builder', 'home');
         $this->data['settings']['category'] = Cache::find('builder', 'category');
     }
     if (isset($this->data['settings']['latest_products_limit'])) {
         $setting['limit'] = $this->data['settings']['latest_products_limit'];
     }
     $this->data['products'] = array();
     $data = array('sort' => 'p.date_added', 'order' => 'DESC', 'start' => 0, 'limit' => $setting['limit']);
     $tmp = array();
     if (isset($this->request->get['path'])) {
         $tmp = explode('_', $this->request->get['path']);
     } else {
         if (isset($this->request->get['category_id'])) {
             $tmp = explode('_', $this->request->get['category_id']);
         }
     }
     if (!count($tmp)) {
     } else {
         if (count($tmp) == 1) {
             $data['filter_category_id'] = $tmp[0];
         } else {
             $data['filter_category_id'] = $tmp[0];
             $data['filter_sub_category'] = $tmp[1];
         }
     }
     $results = $this->model_catalog_product->getProducts($data);
     foreach ($results as $result) {
         if ($result['image']) {
             $image = $this->model_tool_image->resize($result['image'], $setting['image_width'], $setting['image_height']);
         } else {
             $image = false;
         }
         $swapimages = $this->model_catalog_product->getProductImages($result['product_id']);
         if ($swapimages) {
             $swapimage = $this->model_tool_image->resize($swapimages[0]['image'], $setting['image_width'], $setting['image_height']);
         } else {
             $swapimage = false;
         }
         if ($this->config->get('config_customer_price') && $this->customer->isLogged() || !$this->config->get('config_customer_price')) {
             $price = $this->currency->format($this->tax->calculate($result['price'], $result['tax_class_id'], $this->config->get('config_tax')));
         } else {
             $price = false;
         }
         if ((double) $result['special']) {
             $special = $this->currency->format($this->tax->calculate($result['special'], $result['tax_class_id'], $this->config->get('config_tax')));
         } else {
             $special = false;
         }
         if ($this->config->get('config_review_status')) {
             $rating = $result['rating'];
         } else {
             $rating = false;
         }
         if (!empty($result['parent_id'])) {
             $result['category_id'] .= '_' . $result['parent_id'];
         }
         $this->data['products'][] = array('product_id' => $result['product_id'], 'thumb' => $image, 'thumb_swap' => $swapimage, 'name' => $result['name'], 'price' => $price, 'special' => $special, 'rating' => $rating, 'reviews' => sprintf($this->language->get('text_reviews'), (int) $result['reviews']), 'href' => $this->url->link('product/product', 'path=' . $result['category_id'] . '&product_id=' . $result['product_id']));
     }
     if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/latest.tpl')) {
         $this->template = $this->config->get('config_template') . '/template/module/latest.tpl';
     } else {
         $this->template = 'default/template/module/latest.tpl';
     }
     $this->render();
 }
Exemple #26
0
 public function getProductRelated($product_id)
 {
     $products = Cache::find('products.related.' . $product_id);
     if (!is_array($products)) {
         $product_ids = Database::fetchAll("\n            SELECT *\n            FROM PREFIX_product_related AS pr\n            LEFT JOIN PREFIX_product AS p\n                ON (pr.related_id = p.product_id)\n            LEFT JOIN PREFIX_product_to_store AS p2s\n                ON (p.product_id = p2s.product_id)\n            WHERE pr.product_id = '" . (int) $product_id . "'\n                AND p.status = '1'\n                AND p2s.store_id = '" . (int) $this->config->get('store_id') . "'");
         $products = array();
         foreach ($product_ids as $list) {
             $products[] = $this->getProduct($list['product_id']);
         }
         Cache::set('products.related.' . $product_id, $products);
     }
     return $products;
 }
Exemple #27
0
 public function getInformationParents($store_id)
 {
     $cache = 'cms_information.parents.' . $store_id;
     $items = Cache::find($cache);
     if (is_array($items) && count($items)) {
         return $items;
     }
     $items = array();
     $data = $this->fetchAll("SELECT i.information_id, id.title\n            FROM PREFIX_information AS i\n            LEFT JOIN PREFIX_information_description AS id\n                ON i.information_id = id.information_id\n            LEFT JOIN PREFIX_information_to_store AS its\n                ON i.information_id = its.information_id\n            WHERE i.parent_id       = 0\n                AND id.language_id  = :lang\n                AND its.store_id    = :store", array('lang' => $this->config->get('language_id'), 'store' => $store_id));
     foreach ($data as $list) {
         $items[$list['information_id']] = $list['title'];
     }
     Cache::set($cache, $items);
     return $items;
 }
Exemple #28
0
 public function getProductStores($product_id)
 {
     $cache = 'products.stores.' . $product_id;
     $return = Cache::find($cache);
     if (is_array($return) && count($return)) {
         return $return;
     }
     $product_store_data = array();
     $query = $this->fetchAll("SELECT * FROM PREFIX_product_to_store WHERE product_id = " . (int) $product_id);
     foreach ($query as $result) {
         $product_store_data[] = $result['store_id'];
     }
     Cache::set($cache, $product_store_data);
     return $product_store_data;
 }
Exemple #29
0
 public function getCategoriesAsList($parentID = 0, $level = 0)
 {
     if ($parentID == 0) {
         $cache = Cache::find('category_as_list');
         if (is_array($cache) && count($cache)) {
             return $cache;
         }
     }
     $sql = "\n            SELECT c.category_id, cts.store_id, cd.name, c.sort_order, parent_id, c.status, cd.meta_description, cd.description, cd.meta_keyword\n            FROM PREFIX_category AS c\n            LEFT JOIN PREFIX_category_to_store AS cts\n                ON cts.category_id = c.category_id\n            LEFT JOIN PREFIX_category_description AS cd\n                ON cd.category_id = c.category_id\n            WHERE parent_id = " . (int) $parentID . "\n                AND cd.language_id = '" . (int) $this->config->get('language_id') . "'\n            ORDER BY parent_id, sort_order";
     $query = $this->query($sql);
     $return = array();
     foreach ($query->fetchAll() as $row) {
         $row['level'] = $level;
         $return[] = $row;
         if (($subCategories = $this->getCategoriesAsList($row['category_id'], $level + 1)) !== false) {
             $return = array_merge($return, $subCategories);
         }
     }
     if ($parentID == 0) {
         Cache::set('category_as_list', $return);
         return $return;
     }
     if (empty($return)) {
         return false;
     }
     return $return;
 }
Exemple #30
0
 public function getLanguages($data = array())
 {
     if (count($data)) {
         $sql = "SELECT * FROM PREFIX_language ";
         $sort_data = array('name', 'code', 'sort_order');
         if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
             $sql .= " ORDER BY " . $data['sort'];
         } else {
             $sql .= " ORDER BY sort_order, name";
         }
         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 ($data['limit'] < 1) {
                 $data['limit'] = 20;
             }
             $sql .= " LIMIT " . (int) $data['start'] . "," . (int) $data['limit'];
         }
         return $this->fetchAll($sql);
     } else {
         $language_data = Cache::find('language');
         if (!$language_data || !count($language_data)) {
             $language_data = array();
             $default_language = $this->config->get('language_id');
             $query = $this->fetchAll("SELECT * FROM PREFIX_language WHERE status = 1 ORDER BY sort_order, name");
             foreach ($query as $result) {
                 $result['is_default'] = $default_language == $result['language_id'] ? true : false;
                 $language_data[$result['language_id']] = $result;
             }
             Cache::set('language', $language_data);
         }
         return $language_data;
     }
 }