load->language('product/category');
$this->load->model('catalog/category');
$this->load->model('catalog/product');
$this->load->model('tool/image');
if (isset($this->request->get['filter'])) {
$filter = $this->request->get['filter'];
$this->document->setRobots('noindex,follow');
} else {
$filter = '';
}
if (isset($this->request->get['sort'])) {
$sort = $this->request->get['sort'];
$this->document->setRobots('noindex,follow');
} else {
// $sort = 'p.sort_order';
// $sort = 'p.‘rating’';
/*fix start FilterVier*/
$sort = 'warehouse';
if(!empty($fv_set['url_plus']) || isset($this->request->get['warehouse_id'])) {
$sort = 'p.sort_order';
}
}
if (isset($this->request->get['order'])) {
$order = $this->request->get['order'];
} else {
$order = 'ASC';
//$order = 'DESC';
}
if (isset($this->request->get['page'])) {
$page = $this->request->get['page'];
$this->document->setRobots('noindex,follow');
} else {
$page = 1;
}
if (isset($this->request->get['warehouse_id'])) {
$warehouse_id = $this->request->get['warehouse_id'];
$this->document->setRobots('noindex,follow');
} else {
$warehouse_id = '';
}
if (isset($this->request->get['limit'])) {
$limit = (int)$this->request->get['limit'];
$this->document->setRobots('noindex,follow');
} else {
$limit = $this->config->get($this->config->get('config_theme') . '_product_limit');
}
$data['breadcrumbs'] = array();
$data['breadcrumbs'][] = array(
'text' => $this->language->get('text_home'),
'href' => $this->url->link('common/home')
);
if (isset($this->request->get['path'])) {
$url = '';
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
$path = '';
$parts = explode('_', (string)$this->request->get['path']);
$category_id = (int)array_pop($parts);
$parts = $this->getPathByCategory($category_id);
$parts = explode('_', (string)$parts);
array_pop($parts);
foreach ($parts as $path_id) {
if (!$path) {
$path = (int)$path_id;
} else {
$path .= '_' . (int)$path_id;
}
$category_info = $this->model_catalog_category->getCategory($path_id);
if ($category_info) {
$data['breadcrumbs'][] = array(
'text' => $category_info['name'],
'href' => $this->url->link('product/category', 'path=' . $path . $url)
);
}
}
} else {
$category_id = 0;
}
$category_info = $this->model_catalog_category->getCategory($category_id);
if ($category_info) {
$this->document->setTitle($category_info['meta_title']);
if ($category_info['noindex'] <= 0) {
$this->document->setRobots('noindex,follow');
}
if ($category_info['meta_h1']) {
$data['heading_title'] = $category_info['meta_h1'];
} else {
$data['heading_title'] = $category_info['name'];
}
$this->document->setDescription($category_info['meta_description']);
$this->document->setKeywords($category_info['meta_keyword']);
$data['text_refine'] = $this->language->get('text_refine');
$data['text_empty'] = $this->language->get('text_empty');
$data['text_quantity'] = $this->language->get('text_quantity');
$data['text_manufacturer'] = $this->language->get('text_manufacturer');
$data['text_model'] = $this->language->get('text_model');
$data['text_price'] = $this->language->get('text_price');
$data['text_tax'] = $this->language->get('text_tax');
$data['text_points'] = $this->language->get('text_points');
$data['text_compare'] = sprintf($this->language->get('text_compare'), (isset($this->session->data['compare']) ? count($this->session->data['compare']) : 0));
$data['text_sort'] = $this->language->get('text_sort');
$data['text_limit'] = $this->language->get('text_limit');
$data['text_benefits'] = $this->language->get('text_benefits');
$data['button_cart'] = $this->language->get('button_cart');
$data['button_wishlist'] = $this->language->get('button_wishlist');
$data['button_compare'] = $this->language->get('button_compare');
$data['button_continue'] = $this->language->get('button_continue');
$data['button_list'] = $this->language->get('button_list');
$data['button_grid'] = $this->language->get('button_grid');
$data['text_show_category'] = $this->language->get('text_show_category');
$data['text_hide_category'] = $this->language->get('text_hide_category');
$data['text_show'] = $this->language->get('text_show');
// Set the last category breadcrumb
$data['breadcrumbs'][] = array(
'text' => $category_info['name'],
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'])
);
if ($category_info['image']) {
$data['thumb'] = $this->model_tool_image->resize($category_info['image'], $this->config->get($this->config->get('config_theme') . '_image_category_width'), $this->config->get($this->config->get('config_theme') . '_image_category_height'));
} else {
$data['thumb'] = '';
}
$data['description'] = html_entity_decode($category_info['description'], ENT_QUOTES, 'UTF-8');
$data['description_bottom'] = html_entity_decode($category_info['description_bottom'], ENT_QUOTES, 'UTF-8');
$data['compare'] = $this->url->link('product/compare');
$url = '';
if (isset($this->request->get['warehouse_id'])) {
$url .= '&warehouse_id=' . $this->request->get['warehouse_id'];
}
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
$data['c_categories'] = array();
$c_categories = $this->model_catalog_category->getCategories($category_id);
foreach ($c_categories as $result) {
if ($result['image']) {
$image = $this->model_tool_image->resize($result['image'], 120, 120);
} else {
$image = '/image/no_image.png';
}
$data['c_categories'][] = array(
'thumb' => $image,
'icon' => $data['moneymaker2_common_categories_icons_enabled'] && $this->config->get('moneymaker2_catalog_categories_child_icons') && isset($data['moneymaker2_common_categories_icons'][$result['category_id']]) ? $data['moneymaker2_common_categories_icons'][$result['category_id']] : null,
'name' => $result['name'],
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url)
);
}
$results =/*fix*/[];
$data['categories'] = array();
//$results = $this->model_catalog_category->getCategories($category_id);
foreach ($results as $result) {
$filter_data = array(
'filter_category_id' => $result['category_id'],
'filter_sub_category' => true
);
$data['categories'][] = array(
'name' => $result['name'] . ($this->config->get('config_product_count') ? ' (' . $this->model_catalog_product->getTotalProducts($filter_data) . ')' : ''),
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url)
);
}
$data['products'] = array();
$filter_data = array(
'filter_category_id' => $category_id,
'warehouse_id' => $warehouse_id,
'filter_filter' => $filter,
'sort' => $sort,
'order' => $order,
'start' => ($page - 1) * $limit,
'limit' => $limit
);
$product_total = $this->model_catalog_product->getTotalProducts($filter_data);
$results = $this->model_catalog_product->getProducts($filter_data);
// echo '';
// print_r($results);
// echo '
';
foreach ($results as $result) {
if ($result['image']) {
$image = $this->model_tool_image->resize($result['image'], $this->config->get($this->config->get('config_theme') . '_image_product_width'), $this->config->get($this->config->get('config_theme') . '_image_product_height'));
} else {
$image = $this->model_tool_image->resize('placeholder.png', $this->config->get($this->config->get('config_theme') . '_image_product_width'), $this->config->get($this->config->get('config_theme') . '_image_product_height'));
}
$images = array();
$results_images = $this->model_catalog_product->getProductImages($result['product_id']);
if ($results_images) {
$images[] = array(
'thumb' => $image,
);
foreach ($results_images as $result_images) {
$images[] = array(
'thumb' => $this->model_tool_image->resize($result_images['image'], $this->config->get($this->config->get('config_theme') . '_image_product_width'), $this->config->get($this->config->get('config_theme') . '_image_product_height')),
);
}
} else {
if ($result['image']) {
$images[] = array(
'thumb' => $image,
);
}
}
if ($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')), $this->session->data['currency']);
} else {
$price = false;
}
if ((float)$result['special']) {
$special = $this->currency->format($this->tax->calculate($result['special'], $result['tax_class_id'], $this->config->get('config_tax')), $this->session->data['currency']);
} else {
$special = false;
}
if ($this->config->get('config_tax')) {
$tax = $this->currency->format((float)$result['special'] ? $result['special'] : $result['price'], $this->session->data['currency']);
} else {
$tax = false;
}
if ($this->config->get('config_review_status')) {
$rating = (int)$result['rating'];
} else {
$rating = false;
}
if ($result['description_mini']) {
$description = utf8_substr(strip_tags(html_entity_decode($result['description_mini'], ENT_QUOTES, 'UTF-8')), 0);
} else {
$description = utf8_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, $this->config->get($this->config->get('config_theme') . '_product_description_length')) . '..';
}
$productbenefits = $this->model_catalog_product->getProductBenefitsbyProductId($result['product_id']);
$benefits = array();
foreach ($productbenefits as $benefit) {
if ($benefit['image'] && file_exists(DIR_IMAGE . $benefit['image'])) {
$bimage = $benefit['image'];
if ($benefit['type']) {
$bimage = $this->model_tool_image->resize($bimage, 25, 25);
} else {
$bimage = $this->model_tool_image->resize($bimage, 120, 60);
}
} else {
$bimage = 'no_image.jpg';
}
$benefits[] = array(
'benefit_id' => $benefit['benefit_id'],
'name' => $benefit['name'],
'description' => strip_tags(html_entity_decode($benefit['description'])),
'thumb' => $bimage,
'link' => $benefit['link'],
'type' => $benefit['type']
);
}
$stickers = $this->getStickers($result['product_id']) ;
$data['products'][] = array(
'manufacturer' => $result['manufacturer'],
'manufacturer_id' => $result['manufacturer_id'],
'product_id' => $result['product_id'],
'stock_status_id' => $result['stock_status_id'],
'reviews' => $result['reviews'],
'iheight' => $this->config->get($this->config->get('config_theme') . '_image_product_width'),
'iwidth' => $this->config->get($this->config->get('config_theme') . '_image_product_height'),
'thumb' => $image,
'images' => $images,
'name' => $result['name'],
'description' => $description,
'price' => $price,
'special' => $special,
'tax' => $tax,
'video' => $result['video'],
'sticker' => $stickers,
'benefits' => $benefits,
'quantity' => $result['quantity'],
'minimum' => $result['minimum'] > 0 ? $result['minimum'] : 1,
'rating' => $result['rating'],
'href' => $this->url->link('product/product', 'path=' . $this->request->get['path'] . '&product_id=' . $result['product_id'] . $url)
);
}
$data['is_admin'] = isset($this->session->data['token']) ? 1 : 0;
//Перемешивание товаров в категории
if(!isset($this->request->get['sort']) && ($sort == 'warehouse')) {
$shuffle_categories = [4303, 4398, 4300];
if (in_array($category_id, $shuffle_categories)) {
shuffle($data['products']);
}
}
// / Перемешивание товаров в категории
$url = '';
if (isset($this->request->get['warehouse_id'])) {
$url .= '&warehouse_id=' . $this->request->get['warehouse_id'];
}
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
$data['sorts'] = array();
$data['sorts'][] = array(
'text' => $this->language->get('text_default'),
'value' => 'p.sort_order-ASC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.sort_order&order=ASC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_name_asc'),
'value' => 'pd.name-ASC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=pd.name&order=ASC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_name_desc'),
'value' => 'pd.name-DESC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=pd.name&order=DESC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_price_asc'),
'value' => 'p.price-ASC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.price&order=ASC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_price_desc'),
'value' => 'p.price-DESC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.price&order=DESC' . $url)
);
if ($this->config->get('config_review_status')) {
$data['sorts'][] = array(
'text' => $this->language->get('text_rating_desc'),
'value' => 'rating-DESC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=rating&order=DESC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_rating_asc'),
'value' => 'rating-ASC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=rating&order=ASC' . $url)
);
}
$data['sorts'][] = array(
'text' => $this->language->get('text_model_asc'),
'value' => 'p.model-ASC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.model&order=ASC' . $url)
);
$data['sorts'][] = array(
'text' => $this->language->get('text_model_desc'),
'value' => 'p.model-DESC',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.model&order=DESC' . $url)
);
$url = '';
if (isset($this->request->get['warehouse_id'])) {
$url .= '&warehouse_id=' . $this->request->get['warehouse_id'];
}
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
$data['limits'] = array();
$limits = array_unique(array($this->config->get($this->config->get('config_theme') . '_product_limit'), 25, 50, 75, 100));
sort($limits);
foreach($limits as $value) {
$data['limits'][] = array(
'text' => $value,
'value' => $value,
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url . '&limit=' . $value)
);
}
$url = '';
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
/*fix start FilterVier*/
if(!empty($fv_set['url_plus'])) {$url .= $fv_set['url_plus'];}
/*end fix FilterVier*/
$warehouses = $this->model_catalog_product->getWarehouses();
$data['warehouses'] = array();
$data['warehouses'][] = array(
'text' => $this->language->get('custom_sort_shops_all'),
'value' => '',
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url)
);
// Исключённые ID складов
$excluded_warehouses = array(16, 188, 206);
foreach($warehouses as $warehouse) {
// Пропустить исключённые склады
if (in_array($warehouse['warehouse_id'], $excluded_warehouses)) {
continue;
}
$data['warehouses'][] = array(
'text' => $warehouse['name'],
'value' => $warehouse['warehouse_id'],
'href' => $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url . '&warehouse_id=' . $warehouse['warehouse_id'])
);
}
// echo '';
// print_r($data['warehouses']);
// echo '
';
$url = '';
if (isset($this->request->get['warehouse_id'])) {
$url .= '&warehouse_id=' . $this->request->get['warehouse_id'];
}
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
$pagination = new Pagination();
$pagination->total = $product_total;
$pagination->page = $page;
$pagination->limit = $limit;
$pagination->url = $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url . '&page={page}');
$data['pagination'] = $pagination->render();
$data['results'] = sprintf($this->language->get('text_pagination'), ($product_total) ? (($page - 1) * $limit) + 1 : 0, ((($page - 1) * $limit) > ($product_total - $limit)) ? $product_total : ((($page - 1) * $limit) + $limit), $product_total, ceil($product_total / $limit));
// http://googlewebmastercentral.blogspot.com/2011/09/pagination-with-relnext-and-relprev.html
$this->document->addLink($this->url->link('product/category', 'path=' . $category_info['category_id'], true), 'canonical');
if ($page == 2) {
$this->document->addLink($this->url->link('product/category', 'path=' . $category_info['category_id'], true), 'prev');
} elseif($page > 2) {
$this->document->addLink($this->url->link('product/category', 'path=' . $category_info['category_id'] . '&page='. ($page - 1), true), 'prev');
}
if ($limit && ceil($product_total / $limit) > $page) {
$this->document->addLink($this->url->link('product/category', 'path=' . $category_info['category_id'] . '&page='. ($page + 1), true), 'next');
}
$data['sort'] = $sort;
$data['warehouse_id'] = $warehouse_id;
$data['order'] = $order;
$data['limit'] = $limit;
/*$data['continue'] = $this->url->link('common/home');*/
/*fix_continue*/
$dop_url = ($warehouse_id) ? '&warehouse_id='.$warehouse_id : '';
$data[/*fix*/'continue']=$this->url->link('product/category','path='.$this->request->get['path'].$dop_url);
$data['column_left'] = $this->load->controller('common/column_left');
$data['column_right'] = $this->load->controller('common/column_right');
$data['content_top'] = $this->load->controller('common/content_top');
$data['content_bottom'] = $this->load->controller('common/content_bottom');
$data['footer'] = $this->load->controller('common/footer');
$data['header'] = $this->load->controller('common/header');
$this->response->setOutput($this->load->view('product/category', $data));
} else {
$url = '';
if (isset($this->request->get['path'])) {
$url .= '&path=' . $this->request->get['path'];
}
if (isset($this->request->get['warehouse_id'])) {
$url .= '&warehouse_id=' . $this->request->get['warehouse_id'];
}
if (isset($this->request->get['filter'])) {
$url .= '&filter=' . $this->request->get['filter'];
}
if (isset($this->request->get['sort'])) {
$url .= '&sort=' . $this->request->get['sort'];
}
if (isset($this->request->get['order'])) {
$url .= '&order=' . $this->request->get['order'];
}
if (isset($this->request->get['page'])) {
$url .= '&page=' . $this->request->get['page'];
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
$data['breadcrumbs'][] = array(
'text' => $this->language->get('text_error'),
'href' => $this->url->link('product/category', $url)
);
$this->document->setTitle($this->language->get('text_error'));
$data['heading_title'] = $this->language->get('text_error');
$data['text_error'] = $this->language->get('text_error');
$data['button_continue'] = $this->language->get('button_continue');
$data['continue'] = $this->url->link('common/home');
$this->response->addHeader($this->request->server['SERVER_PROTOCOL'] . ' 404 Not Found');
$data['column_left'] = $this->load->controller('common/column_left');
$data['column_right'] = $this->load->controller('common/column_right');
$data['content_top'] = $this->load->controller('common/content_top');
$data['content_bottom'] = $this->load->controller('common/content_bottom');
$data['footer'] = $this->load->controller('common/footer');
$data['header'] = $this->load->controller('common/header');
$this->response->setOutput($this->load->view('error/not_found', $data));
}
}
private function getStickers($product_id) {
$stickers = $this->model_catalog_product->getProductStickerbyProductId($product_id) ;
if (!$stickers) {
return;
}
$data['stickers'] = array();
foreach ($stickers as $sticker) {
$data['stickers'][] = array(
'position' => $sticker['position'],
'image' => HTTP_SERVER . 'image/' . $sticker['image']
);
}
return $this->load->view('product/stickers', $data);
}
private function getPathByCategory($category_id) {
$category_id = (int)$category_id;
if ($category_id < 1) return false;
static $path = null;
if (!is_array($path)) {
$path = $this->cache->get('category.seopath');
if (!is_array($path)) $path = array();
}
if (!isset($path[$category_id])) {
$max_level = 10;
$sql = "SELECT CONCAT_WS('_'";
for ($i = $max_level-1; $i >= 0; --$i) {
$sql .= ",t$i.category_id";
}
$sql .= ") AS path FROM " . DB_PREFIX . "category t0";
for ($i = 1; $i < $max_level; ++$i) {
$sql .= " LEFT JOIN " . DB_PREFIX . "category t$i ON (t$i.category_id = t" . ($i-1) . ".parent_id)";
}
$sql .= " WHERE t0.category_id = '" . $category_id . "'";
$query = $this->db->query($sql);
$path[$category_id] = $query->num_rows ? $query->row['path'] : false;
$this->cache->set('category.seopath', $path);
}
return $path[$category_id];
}
}