Get all products by category/brand prestashop 1.7

[MrEduar]

Hi, I am trying to make a module that will get all the products of a specific category/brand.

For example, in my front office I have a select, in this select I can select multiple categories. If, for example, I select the category sunglasses and optical glasses, I would like to get all the products in these categories. And if the customer selects a brand within sunglasses, then I would like to get only the sunglasses of that specific brand.

Maybe something like this.

$products = Product::getProducts($langId, 0, 0, 'id_product', 'DESC', $categoryId, true);

But this would only bring me products within a single category. I need to get products within multiple categories and also the possibility to filter it by brands.


How can I achieve this?
Thank you in advance.

Edited October 8, 2021 by MrEduar (see edit history)

[MrEduar]

Up

[JulienPct]

Hello,

You need the products and all their categories if I understand correctly?

[MrEduar]

1 minute ago, JulienPct said:

Hello,

You need the products and all their categories if I understand correctly? 

Hello!
No, I need all products within multiple categories. If I select 2 or more categories, get all the products in those categories.

[JulienPct]

You said you wanted to create a module, why not create a DB query at the same time containing all the information you need?

I can understand that you want to use the existing ones so that you don't have any problem of lack of information. In this case, can't you override the query called by the getProducts() function?

[MrEduar]

Yes I could do it with raw SQL, but in fact prestashop does not have a method to get the products from multiple categories? Do I have to do it manually?

[JulienPct]

From memory PrestaShop has a method to retrieve products and a method to retrieve all its categories.
I don't remember a method to retrieve products based on categories.

Personally I would try to override the query called by getProducts() to add a test based on categories

[MrEduar]

Ok, thank you very much for your help. Regards