public function page($page_no = 1)
{
$items_per_page = 2;
$cat_id = 2;
$offset = ($page_no - 1) * $items_per_page;
$limit = $items_per_page;
$category = new Category_Model($cat_id);
//$category = ORM::factory('category')->with('catagories_description')->find($cat_id); //without the lazy loading
echo $category->name . '<br>';
echo $category->catagories_description->description . '<br>';
$catalog_list = $category->limit($limit, $offset)->products;
//$catalog_list = $category->limit($limit, $offset)->like('products.name', 'ca')->products;
//$catalog_list = $category->limit($limit, $offset)->where('product_id >', 1)->products;
$catalog_total = $category->count_last_query();
echo 'this category has ' . $catalog_total . ' related products';
foreach ($catalog_list as $p) {
echo $p->name . '<br>';
echo $p->products_description->description . '<br>';
print_r($p->attributes);
}
$pagination = new Pagination(array('uri_segment' => 'page', 'total_items' => $catalog_total, 'items_per_page' => $items_per_page, 'style' => 'classic', 'auto_hide' => TRUE));
echo $pagination->render();
$profile = new Profiler();
}
