Mrthdrb

In admin, I want to add column of category and also add category filter in product grid.

How to do this?

Please help me.

Thanks.

To add category column in product grid, add this below code in your product_listing.xml file :

<?xml version="1.0" encoding="UTF-8"?>
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
 <listingToolbar name="listing_top">
 <filters name="listing_filters">
 <filterSelect name="category_id" provider="$ $.parentName " component="Magento_Ui/js/form/element/ui-select" template="ui/grid/filters/elements/ui-select">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="filterOptions" xsi:type="boolean">true</item>
 <item name="levelsVisibility" xsi:type="number">1</item>
 </item>
 </argument>
 <settings>
 <options class="VendorModuleModelCategoryCategoryList"/>
 <caption translate="true">– Please Select a Category –</caption>
 <label translate="true">Categories</label>
 <dataScope>category_id</dataScope>
 <imports>
 <link name="visible">componentType = column, index = $ $.index :visible</link>
 </imports>
 </settings>
 </filterSelect>
 </filters>
 </listingToolbar>
 <columns name="product_columns" class="MagentoCatalogUiComponentListingColumns">
 <column name="category_id" class="VendorModuleUiComponentListingColumnCategory">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="label" xsi:type="string" translate="true">Categories</item>
 <item name="sortOrder" xsi:type="number">35</item>
 </item>
 </argument>
 </column>
 </columns>
</listing>

Now, we need to override prepareDataSource() method. To get category values in the prepareDataSource() method like below code :

VendorModuleUiComponentListingColumnCategory.php

<?php

namespace VendorModuleUiComponentListingColumn;

use MagentoFrameworkViewElementUiComponentFactory;
use MagentoFrameworkViewElementUiComponentContextInterface;

class Category extends MagentoUiComponentListingColumnsColumn


 /**
 * @var MagentoCatalogModelProductFactory
 */
 private $productFactory;

 /**
 * @var MagentoCatalogModelCategoryFactory
 */
 private $categoryFactory;

 /**
 * [__construct description]
 * @param ContextInterface $context [description]
 * @param UiComponentFactory $uiComponentFactory [description]
 * @param array $components [description]
 * @param array $data [description]
 * @param MagentoCatalogModelProductFactory $productFactory [description]
 * @param MagentoCatalogModelCategoryFactory $categoryFactory [description]
 */
 public function __construct(
 ContextInterface $context,
 UiComponentFactory $uiComponentFactory,
 array $components = [],
 array $data = [],
 MagentoCatalogModelProductFactory $productFactory,
 MagentoCatalogModelCategoryFactory $categoryFactory
 ) 
 parent::__construct($context, $uiComponentFactory, $components, $data);
 $this->productFactory = $productFactory;
 $this->categoryFactory = $categoryFactory;
 

 /**
 * Prepare date for category column
 * @param array $dataSource [description]
 * @return array
 */
 public function prepareDataSource(array $dataSource)
 
 $fieldName = $this->getData('name');
 if (isset($dataSource['data']['items'])) 
 foreach ($dataSource['data']['items'] as &$item) 
 $productId = $item['entity_id'];
 $product = $this->productFactory->create()->load($productId);
 $categoryIds = $product->getCategoryIds();
 $categories = [];
 if (count($categoryIds)) 
 foreach ($categoryIds as $categoryId) 
 $categoryData = $this->categoryFactory->create()->load($categoryId);
 $categories[] = $categoryData->getName();
 
 
 $item[$fieldName] = implode(',', $categories);
 
 
 return $dataSource;
 

create di.xml file for override class :

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
 <preference for="MagentoCatalogUiDataProviderProductProductDataProvider" type="VendorModuleUiDataProviderProductProductDataProvider" />
</config>

Now, add method addFilter() to VendorModuleUiDataProviderProductProductDataProvider.php

<?php

namespace VendorModuleUiDataProviderProduct;

class ProductDataProvider extends MagentoCatalogUiDataProviderProductProductDataProvider

 /**
 * For filter grid according to category
 * @param MagentoFrameworkApiFilter $filter
 */
 public function addFilter(MagentoFrameworkApiFilter $filter)
 
 if ($filter->getField() == 'category_id') 
 $this->getCollection()->addCategoriesFilter(['in' => $filter->getValue()]);
 elseif (isset($this->addFilterStrategies[$filter->getField()])) 
 $this->addFilterStrategies[$filter->getField()]
 ->addFilter(
 $this->getCollection(),
 $filter->getField(),
 [$filter->getConditionType() => $filter->getValue()]
 );
 else 
 parent::addFilter($filter);
 
 

And last to add Options to the category filter dropdown :

VendorModuleModelCategoryCategoryList.php

<?php

namespace VendorModuleModelCategory;

use MagentoCatalogModelCategory as CategoryModel;

class CategoryList implements MagentoFrameworkOptionArrayInterface


 /**
 * @var MagentoCatalogModelResourceModelCategoryCollectionFactory
 */
 private $categoryCollectionFactory;
 /**
 * [__construct description]
 * @param MagentoCatalogModelResourceModelCategoryCollectionFactory $collectionFactory [description]
 */
 public function __construct(
 MagentoCatalogModelResourceModelCategoryCollectionFactory $collectionFactory
 ) 
 $this->categoryCollectionFactory = $collectionFactory;
 

 /**
 * Get list of categories
 * @return array
 */
 public function toOptionArray()
 
 $collection = $this->categoryCollectionFactory->create();
 $collection->addAttributeToSelect(['name', 'is_active', 'parent_id']);
 $categoryById = [
 CategoryModel::TREE_ROOT_ID => [
 'value' => CategoryModel::TREE_ROOT_ID,
 'optgroup' => null,
 ],
 ];
 foreach ($collection as $category) 
 foreach ([$category->getId(), $category->getParentId()] as $categoryId) 
 if (!isset($categoryById[$categoryId])) 
 $categoryById[$categoryId] = ['value' => $categoryId];
 
 

 $categoryById[$category->getId()]['is_active'] = $category->getIsActive();
 $categoryById[$category->getId()]['label'] = $category->getName();
 $categoryById[$category->getParentId()]['optgroup'][] = &$categoryById[$category->getId()];
 

 return $categoryById[CategoryModel::TREE_ROOT_ID]['optgroup'];
 

Hope, It will helpful for you.