top level cats with links to subcats, subcat count, and product count here are some prints:
here is the model function that is not very optimized but does the job
Code: Select all
public function getCategoriesLevel($parent_id) {
$category_data = array();
$query = $this->db->query("SELECT *, (select count(product_id) from product_to_category where category_id in (c.category_id) or category_id in (select category_id from category where parent_id in (c.category_id)) ) as count_products, (select count(*) from category where parent_id in (c.category_id)) as subcategories FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->language->getId() . "' ORDER BY c.sort_order, cd.name ASC");
foreach ($query->rows as $result) {
$category_data[] = array(
'category_id' => $result['category_id'],
'name' => $this->getPath($result['category_id'], $this->language->getId()),
'sort_order' => $result['sort_order'],
'subcategories' => $result['subcategories'],
'count_products'=> $result['count_products']
);
}
return $category_data;
}in the products page a thumb pic with expanding option would be nice and helpful like this:
- it would be useful if the information pages would have options (when edited) to be listed in the top menu or footer.
- a tag cloud module would be nice
- also a 'latest products' page and 'Newest' as a sorting option for the products in the front end.
- the image class has a watermark function but it it not used in admin. i have used it but with some work
