change logic brand homepage for categories

1 files changed, 18 insertions, 6 deletions

diff --git a/indoteknik_api/controllers/api_v1/brand_homepage.py b/indoteknik_api/controllers/api_v1/brand_homepage.py
index a6a17e88..37018745 100644
--- a/indoteknik_api/controllers/api_v1/brand_homepage.py
+++ b/indoteknik_api/controllers/api_v1/brand_homepage.py
@@ -24,13 +24,25 @@ class BrandHomepage(controller.Controller):
                 ('product_rating', '>', 0),
                 ('x_manufacture', '=', brand_homepage.manufacture_id.id)
             ]
-            products = request.env['product.template'].search(query_product, order='product_rating desc', limit=8)
+            products = request.env['product.template'].search(query_product, order='product_rating desc', limit=12)
 
             categories = []
-            for product in products:
-                for c in product.public_categ_ids:
-                    categories.append(c.name)
-            categories = list(dict.fromkeys(categories))
+            # for product in products:
+            #     for c in product.public_categ_ids:
+            #         categories.append(c.name)
+            # categories = list(dict.fromkeys(categories))
+            # product_categories = request.env['product.template'].read_group([
+            #     ('public_categ_ids', '!=', False),
+            #     ('x_manufacture', '=', brand_homepage.manufacture_id.id)
+            # ], fields=['public_categ_ids'], groupby=['public_categ_ids'], limit=10)
+            # for product_category in product_categories:
+            #     for c in product_category.public_categ_ids:
+            #         categories.append(c.name)
+            # categories = list(dict.fromkeys(categories))
+
+            commerce_categories = request.env['product.public.category'].search([
+                ('product_tmpl_ids.x_manufacture', '=', brand_homepage.manufacture_id.id)
+            ], limit=8)
 
             data.append({
                 'sequence': brand_homepage.sequence,
@@ -39,7 +51,7 @@ class BrandHomepage(controller.Controller):
                 'image': base_url + 'api/image/website.brand.homepage/image/' + str(
                     brand_homepage.id) if brand_homepage.image else '',
                 'url': brand_homepage.url,
-                'categories': [y for y in categories],
+                'categories': [y.name for y in commerce_categories],
                 'products': [request.env['product.template'].api_single_response(x) for x in products]
             })