• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Register
  • Login
Bagisto Forum

Bagisto

  • Register
  • Login
  • Search
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups

Get product category on export

General Discussion
2
2
189
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L
    LilD last edited by 10 Jun 2021, 16:20

    How can I get product category in this query builder?

     $queryBuilder = DB::table('product_flat')
                ->leftJoin('products', 'product_flat.product_id', '=', 'products.id')
                ->leftJoin('attribute_families', 'products.attribute_family_id', '=', 'attribute_families.id')
                ->leftJoin('product_inventories', 'product_flat.product_id', '=', 'product_inventories.product_id')
                ->select(
                    'product_flat.locale',
                    'product_flat.channel',
                    'product_flat.product_id',
                    'products.sku as product_sku',
                    'product_flat.name as product_name',
                    'products.type as product_type',
                    'product_flat.status',
                    'product_flat.price',
                    'attribute_families.name as attribute_family',
                    DB::raw('SUM(DISTINCT ' . DB::getTablePrefix() . 'product_inventories.qty) as quantity')
                );
    
    1 Reply Last reply Reply Quote 0
    • devansh-webkul
      devansh-webkul last edited by 11 Jun 2021, 05:20

      Hi @LilD,

      Use this,

      ->leftJoin('product_categories', 'product_flat.product_id', '=', 'product_categories.product_id')
      ->leftJoin('category_translations', 'product_categories.category_id', '=', 'category_translations.category_id')
      ->select(
          ...
          'category_translations.name as category_name',
          ...
      );
      

      Rest you need to add some Datagrid stuffs, like adding columns, etc.

      1 Reply Last reply Reply Quote 0
      2 out of 2
      • First post
        2/2
        Last post