Search the Community

Доброго времени суток, попробовал модуль WebMe Категории на главной , вроде ничего, но в нем нету таких вещей как вывод описания и веса товара, которые ОЧЕНЬ нужны. возможно кто-то подскажет похожий модуль которые это умеет? или возможно кто-то подскажит как сделать вывод в этом? дополнительные поля необязательны т.к. вроде все есть в обычной сборке и выводится на детальной странице продукта сборка оригинальная OperCart 1.5.6 от 25го июля 13го года. контролер в каталоге: <?php class ControllerModuleWebmeCategoriesAtHomepage extends Controller { protected function index($setting) { $this->id = 'webme_categories_at_homepage'; $this->data['button_cart'] = $this->language->get('button_cart'); /* ===================================== */ $this->load->model('catalog/category'); $category_ids = explode("_", $this->config->get('webme_categories_at_homepage_category')); foreach ($category_ids as $cat_id) { $category_id = $cat_id; $category_info = $this->model_catalog_category->getCategory($category_id); if ($category_info) { $this->data['w_categories'][$category_id]['heading_title'] = $category_info['name']; $this->data['w_categories'][$category_id]['description'] = html_entity_decode($category_info['description'], ENT_QUOTES, 'UTF-8'); $this->data['w_categories'][$category_id]['href'] = $this->url->link('product/category', 'path='.$category_id); $this->load->model('tool/image'); if ($category_info['image']) { $image = $category_info['image']; } else { $image = ''; } $this->data['w_categories'][$category_id]['thumb'] = $this->model_tool_image->resize($image, $this->config->get('config_image_category_width'), $this->config->get('config_image_category_height')); $this->load->model('catalog/webme_categories_at_homepage'); $this->load->model('catalog/product'); $this->load->model('catalog/review'); $product_total = $this->model_catalog_webme_categories_at_homepage->getTotalProductsByCategoryId($category_id); if ($product_total) { $this->data['w_categories'][$category_id]['button_add_to_cart'] = $this->language->get('button_add_to_cart'); $this->data['w_categories'][$category_id]['products'] = array(); $w_sort_order = explode("-", $this->config->get('webme_categories_at_homepage_sort_by')); $sort = $w_sort_order["0"]; $order = $w_sort_order["1"]; $wProdLimit = $this->config->get('webme_categories_at_homepage_limit'); $data = array( 'filter_category_id' => $category_id, 'sort' => $sort, 'order' => $order, 'start' => 0, 'limit' => 4 ); if ($wProdLimit > 0) { if ($this->config->get('webme_categories_at_homepage_limit') > 0) { $data['limit'] = $this->config->get('webme_categories_at_homepage_limit'); } $results = $this->model_catalog_product->getProducts($data); } else { $results = $this->model_catalog_product->getProducts($data); } foreach ($results as $result) { if ($result['image']) { $image = $result['image']; } else { $image = 'no_image.jpg'; } 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 ((float)$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; } $options = $this->model_catalog_product->getProductOptions($result['product_id']); if ($options) { $add = $this->url->link('product/product', 'path='.$category_id.'&product_id='.$result['product_id']); } else { $add = $this->url->link('checkout/cart', 'product_id='.$result['product_id']); } $this->data['w_categories'][$category_id]['products'][] = array( 'product_id' => $result['product_id'], 'name' => $result['name'], 'model' => $result['model'], 'rating' => $rating, 'stars' => sprintf($this->language->get('text_stars'), $rating), 'thumb' => $this->model_tool_image->resize($image, $this->config->get('config_image_product_width'), $this->config->get('config_image_product_height')), 'price' => $price, 'options' => $options, 'special' => $special, 'href' => $this->url->link('product/product', 'path='.$category_id.'&product_id='.$result['product_id']), 'add' => $add ); } if (!$this->config->get('config_customer_price')) { $this->data['w_categories'][$category_id]['display_price'] = TRUE; } elseif ($this->customer->isLogged()) { $this->data['w_categories'][$category_id]['display_price'] = TRUE; } else { $this->data['w_categories'][$category_id]['display_price'] = FALSE; } } } /* ===================================== */ if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/webme_categories_at_homepage.tpl')) { $this->template = $this->config->get('config_template') . '/template/module/webme_categories_at_homepage.tpl'; } else { $this->template = 'default/template/module/webme_categories_at_homepage.tpl'; } $this->render(); } } } ?> модель: <?php class ModelCatalogWebmeCategoriesAtHomepage extends Model { public function getTotalProductsByCategoryId($category_id = 0) { $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "product_to_category p2c LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND p2c.category_id = '" . (int)$category_id . "'"); return $query->row['total']; } public function getProductsByCategoryId($category_id, $sort = 'p.sort_order', $order = 'ASC', $start = 0, $limit = 4) { $sql = "SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM " . DB_PREFIX . "review r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN " . DB_PREFIX . "stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2c.category_id = '" . (int)$category_id . "'"; $sort_data = array( 'pd.name', 'p.sort_order', 'special', 'rating', 'p.price', 'p.model', 'p.date_added' ); $show_random_products = $this->config->get('webme_categories_at_homepage_random'); if ($show_random_products == 1) { $sql .= " ORDER BY RAND()"; } else { if (in_array($sort, $sort_data)) { if ($sort == 'pd.name' || $sort == 'p.model') { $sql .= " ORDER BY LCASE(" . $sort . ")"; } else { $sql .= " ORDER BY " . $sort; } } else { $sql .= " ORDER BY p.sort_order"; } if ($order == 'DESC') { $sql .= " DESC"; } else { $sql .= " ASC"; } } if ($start < 0) { $start = 0; } $sql .= " LIMIT " . (int)$start . "," . (int)$limit; $query = $this->db->query($sql); return $query->rows; } } ?> tpl: <?php if (isset($w_categories)) { foreach ($w_categories as $w_category) { ?> <?php if (isset($w_category["products"])) { ?> <div class="box"> <div class="box-heading"><a href="<?php echo $w_category["href"]; ?>"><?php echo $w_category["heading_title"]; ?></a></div> <div class="box-content"> <div class="box-product"> <?php foreach ($w_category["products"] as $product) { ?> <div> <?php if ($product['thumb']) { ?> <div class="image"><a href="<?php echo $product['href']; ?>"><img src="<?php echo $product['thumb']; ?>" alt="<?php echo $product['name']; ?>" /></a></div> <?php } ?> <div class="name"><a href="<?php echo $product['href']; ?>"><?php echo $product['name']; ?></a></div> <?php if ($product['price']) { ?> <div class="price"> <?php if (!$product['special']) { ?> <?php echo $product['price']; ?> <?php } else { ?> <span class="price-old"><?php echo $product['price']; ?></span> <span class="price-new"><?php echo $product['special']; ?></span> <?php } ?> </div> <?php } ?> <?php if ($product['rating']) { ?> <div class="rating"><img src="catalog/view/theme/default/image/stars-<?php echo $product['rating']; ?>.png" alt="<?php echo $product['reviews']; ?>" /></div> <?php } ?> <div class="cart"><input type="button" value="<?php echo $button_cart; ?>" onclick="addToCart('<?php echo $product['product_id']; ?>');" class="button" /></div> </div> <?php } ?> </div> </div> </div> <?php } ?> <?php } // foreach ($w_categories as $w_category) { } // if (isset($w_categories)) { ?> буду ОЧЕНЬ благодарен за помощь и по возможности отблагодарю чем смогу