Tag: Magento

Filtering with layered navigation on attribute 1, attribute 2 and attribute 3, I get the parent product because the child products have filtered attributes like child product 1 => attribute 1, child product 2 => attribute 2 and attribute 3, but I need to show this parent product which one child has 3 attributes together, for example child 1 => attribute 1, attribute 2 and attribute 3.
Is it possible ?
Plugin bellow

IndexBuilder.php

      <?php

namespace VendorModulePluginCatalogSearchModelSearch;
use MagentoFrameworkDBSelect;
use MagentoFrameworkSearchRequestFilterInterface;
use MagentoFrameworkSearchRequestFilterBoolExpression;
use MagentoFrameworkSearchRequestQueryFilter;
use MagentoFrameworkSearchRequestInterface;
use MagentoFrameworkSearchRequestQueryInterface as RequestQueryInterface;
use MagentoFrameworkAppResourceConnection;
use MagentoCatalogApiCategoryRepositoryInterface;
use MagentoCatalogModelCategoryFactory;
use MagentoCatalogModelProduct;
use MagentoFrameworkDataHelperPostHelper;

class IndexBuilder
{
    /**
    * @var MagentoFrameworkAppConfigScopeConfigInterface
    */
    protected $scopeConfig;

    /**
    * @var MagentoStoreModelStoreManagerInterface
    */
    protected $storeManager;
    protected $_stockFilter;
    private   $layerResolver;
    protected $categoryRepository;
    protected $_categoryCollectionFactory;
    protected $_date;
    protected $_filterData;
    protected $_productRepository;
    protected $_productDependant;
     /**
     * @var MagentoCatalogModelResourceModelProduct
     */
    private $resourceProduct;
    /**
     * @var MagentoCatalogModelCategoryFactory
     */
    protected $_categoryFactory;
    protected $_registry;
    protected $_request;
    private $resourceConfigurable;

    public function __construct(
        MagentoStoreModelStoreManagerInterface $storeManager,
        MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory,
        MagentoCatalogModelProductVisibility $productVisibility,
        MagentoCatalogHelperCategory $categoryHelper,
        MagentoFrameworkRegistry $registry,
        MagentoCatalogInventoryHelperStock $stockFilter,
        MagentoCatalogModelLayerResolver $layerResolver,
        CategoryRepositoryInterface $categoryRepository,
        MagentoCatalogModelResourceModelCategoryCollectionFactory $categoryCollectionFactory,
        CategoryFactory $categoryFactory,
        MagentoFrameworkAppRequestHttp $request,
        MagentoFrameworkStdlibDateTimeTimezoneInterface $date,
         ShoogaSearchByFilterModelFilterData $filterData,
         ShoogaLinkedDependantsModelFilterData $productDependant,
        MagentoCatalogModelProductRepository $productRepository,
        MagentoCatalogModelResourceModelProduct $resourceProduct,
        MagentoConfigurableProductModelResourceModelProductTypeConfigurable $resourceConfigurable
    ) {
        $this->storeManager = $storeManager;
        $this->_productCollectionFactory = $productCollectionFactory; 
        $this->_productVisibility = $productVisibility;
        $this->categoryHelper = $categoryHelper;
        $this->_registry = $registry;
        $this->_stockFilter = $stockFilter;
        $this->layerResolver = $layerResolver;
        $this->categoryRepository = $categoryRepository;
        $this->_categoryCollectionFactory = $categoryCollectionFactory;
        $this->_categoryFactory = $categoryFactory;
        $this->_request = $request;
        $this->_date =  $date;
        $this->_filterData = $filterData;
        $this->_productRepository = $productRepository;
        $this->_productDependant = $productDependant;
        $this->resourceProduct = $resourceProduct;
        $this->resourceConfigurable = $resourceConfigurable;
    }

    /**
    * Build index query
    *
    * @param $subject
    * @param callable $proceed
    * @param RequestInterface $request
    * @return Select
    * @SuppressWarnings(PHPMD.UnusedFormatParameter)
    */
    public function aroundBuild($subject, callable $proceed, RequestInterface $request) {
        $select = $proceed($request);
        $storeId = $this->storeManager->getStore()->getStoreId();
        $rootCatId = $this->storeManager->getStore($storeId)->getRootCategoryId();
        $productUniqueIds = $this->getCustomCollectionQuery();
        $select->where('search_index.entity_id IN (' . join(',', $productUniqueIds) . ')');

        return $select;
    }
        public function getProductsSkus($id){
      return $this->resourceProduct->getProductsSku($id);
    }
    public function getCurrentCategory()
    {        
        return $this->_registry->registry('current_category');
    }
  
    /**
    *
    * @return ProductIds()
    */
    public function getCustomCollectionQuery() {
       
        $todayStartOfDayDate = $this->_date->date()->setTime(0, 0, 0)->format('Y-m-d H:i:s');
        $todayEndOfDayDate = $this->_date->date()->setTime(23, 59, 59)->format('Y-m-d H:i:s');
        $websiteId = $this->storeManager->getStore()->getWebsiteId();
        $collection = $this->_productCollectionFactory->create();
        $collection->addAttributeToSelect('*');
        $collection->addAttributeToSelect(array('entity_id','sku'));
        
      
               $collection->addAttributeToFilter(
        'news_from_date',
        (
            'or' => (
                0 => ('date' => true, 'to' => $todayEndOfDayDate),
                1 => ('is' => new Zend_Db_Expr('null')),
            )
        ),
        'left'
    )->addAttributeToFilter(
        'news_to_date',
        (
            'or' => (
                0 => ('date' => true, 'from' => $todayStartOfDayDate),
                1 => ('is' => new Zend_Db_Expr('null')),
            )
        ),
        'left'
    )->addAttributeToFilter(
        (
            ('attribute' => 'news_from_date', 'is' => new Zend_Db_Expr('not null')),
            ('attribute' => 'news_to_date', 'is' => new Zend_Db_Expr('not null')),
        )
    );

        $collection->setOrder('sort_order', 'ASC');
            
    
       
        $collection->addWebsiteFilter($websiteId);
        $collection->setVisibility($this->_productVisibility->getVisibleInSiteIds());
        $collection->addAttributeToFilter('status',MagentoCatalogModelProductAttributeSourceStatus::STATUS_ENABLED);
        $collection->setPageSize(
                    $collection->getSize()
                )->setCurPage(
                    1
                );
       /*You can write your custom logic here...*/

        $getProductAllIds = $collection->getAllIds();
        $getProductUniqueIds = array_unique($getProductAllIds);
        return $getProductUniqueIds;
    }

    

}