[Solved] Can't find Products query...

[web_br]

Hi,

I just want to modify the query that returns the products to be displayed in product-list.tpl. In, classes/Product.php, I did find and modify the query for new products (getNewProducts) but... where is the REAL getProducts function? If I change anything in getProducts, no change at all... even if I change the name of the function... no error whatsoever... Am I missing something here?

Thanks

[JohnDoe5268]

I have the same problem, does anyone knows where find this variable ?

[web_br]

Hi John ;-)

I finally found the method to get category products in classes/Category (getProducts)

[gonandriy]

Can you provide link on page with products list?

[web_br]

Not sure I'm following you...

[gonandriy]

Not need. if you already found solution.

[JohnDoe5268]

Thanx

In fact, I search where is the $products variable defined, but i'dont find it in the getProducts function :/

[web_br]

It is defined in the Category Controller around line 140 :
self::$smarty->assign(array('products' => (isset($cat_products) AND $cat_products) ? $cat_products : NULL,

[JohnDoe5268]

Ho dude it's right

By the way, do you know how to shuffle this array in another ? I've tried this but it doesn't work :

self::$smarty->assign(array(
                   'products' => (isset($cat_products) AND $cat_products) ? $cat_products : NULL,
//The new array        'products_rand' => shuffle((isset($cat_products) AND $cat_products) ? $cat_products : NULL),
                   'id_category' => (int)($this->category->id),
                   'id_category_parent' => (int)($this->category->id_parent),
                   'return_category_name' => Tools::safeOutput($this->category->name),
                   'path' => Tools::getPath((int)($this->category->id)),
                   'add_prod_display' => Configuration::get('PS_ATTRIBUTE_CATEGORY_DISPLAY'),
                   'categorySize' => Image::getSize('category'),
                   'mediumSize' => Image::getSize('medium'),
                   'thumbSceneSize' => Image::getSize('thumb_scene'),
                   'homeSize' => Image::getSize('home')
               ));

[web_br]

isset($cat_products) AND $cat_products will return a boolean not an array. Try to shuffle the $cat_products variable before it is assigned to $smarty

[JohnDoe5268]

And I recall it by the same way ?
Like this ?

$cat_products_rand = shuffle($cat_products);

               self::$smarty->assign(array(
                   'products' => (isset($cat_products) AND $cat_products) ? $cat_products : NULL,
                   'products_rand' => (isset($cat_products_rand) AND $cat_products_rand) ? $cat_products_rand : NULL,
                   'id_category' => (int)($this->category->id),
                   'id_category_parent' => (int)($this->category->id_parent),
                   'return_category_name' => Tools::safeOutput($this->category->name),
                   'path' => Tools::getPath((int)($this->category->id)),
                   'add_prod_display' => Configuration::get('PS_ATTRIBUTE_CATEGORY_DISPLAY'),
                   'categorySize' => Image::getSize('category'),
                   'mediumSize' => Image::getSize('medium'),
                   'thumbSceneSize' => Image::getSize('thumb_scene'),
                   'homeSize' => Image::getSize('home')
               ));

[web_br]

Yes. Now your shuffled array will be available in your .tpl file. {$products_rand}

[JohnDoe5268]

It will shuffle $cat_products, but i've find the solution :
I had just to declare $cat_products_rand in two steps :

$cat_products_rand = $cat_products;
shuffle($cat_products_rand);

Thanks for your help web_br !