how to change category product list sql

[jxdyzwh]

i want to change product list sql
if (id_category=="3")
{
    $where =" where id_category not in (4,5)";
}
the webstite url is "index.php?id_category=3&controller=category"

how can i change the sql?

[vekia]

in this case you have to modify controller: controllers/front/categoryController.php

there is an sql query to get products from database. you can use your modification there.

[jxdyzwh]

controllers/front/categoryController.php is function assignProductList(),your say "get products from database" is here?

the function have code

        if (!$hookExecuted)
        {
            $this->context->smarty->assign('categoryNameComplement', '');//the program is not execution here
            $this->nbProducts = $this->category->getProducts(null, null, null, $this->orderBy, $this->orderWay, true);
            $this->pagination((int)$this->nbProducts); // Pagination must be call after "getProducts"
            $this->cat_products = $this->category->getProducts($this->context->language->id, (int)$this->p, (int)$this->n, $this->orderBy, $this->orderWay);
        }
        // Hook executed, use the override
        else
            // Pagination must be call after "getProducts"
            $this->pagination($this->nbProducts);
 

[aliabc]

categoryController.php

 

         $hookExecuted = false;
    /*    Hook::exec('actionProductListOverride', array(
            'nbProducts' => &$this->nbProducts,
            'catProducts' => &$this->cat_products,
            'hookExecuted' => &$hookExecuted,
        ));*/       //after comment out this , override  category work!

        // The hook was not executed, standard working
        if (!$hookExecuted)
        {

              //the program now  execution here

Edited September 9, 2014 by aliabc (see edit history)