Example #1
0
<?php

global $home_dir, $db, $data;
require_once $home_dir . 'classes/paging.php';
require_once $home_dir . 'models/category.m.php';
require_once $home_dir . 'models/product.m.php';
$categories_tree = Category::getCategoryTree($db);
$category = $categories_tree->findInChildren(intval($path[1]));
if (!isset($category)) {
    redirect('notfound');
}
$data['category'] = $category;
$page_title = $category->val('category_name');
$paging = Paging::getFromUrl(Product::getSortingItems());
$ids = $category->getSubTreeIDs();
$values = [];
$types = '';
foreach ($ids as $id) {
    $values[] = '?';
    $types .= 'i';
}
$products = Product::select($db, 'viewProducts', sprintf('product_category_id IN (%s)', implode(',', $values)), $ids, $types, $paging, $paging->getOrderBy());
$data['products'] = $products;
$data['paging'] = $paging;
$data['ids'] = $ids;