Add custom conditions to product collection in Magento 2

To add custom conditions to product collection, you need to override build() function. I hope you have a custom module with basic skeletons like registration.php and module.xml file,

Path: app/code/Magemonkeys/FilterSearch/etc/frontend/di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <!-- Magento Catalog search module's IndexBuilder.php plugin file -->
    <type name="Magento\CatalogSearch\Model\Search\IndexBuilder">
        <plugin name="Magemonkeys_FilterSearch::custom_filterSearchr_conditions"
                type="Magemonkeys\FilterSearch\Plugin\CatalogSearch\Model\Search\IndexBuilder" />
    </type>
</config>

<?xml version="1.0"?>

<plugin name="Magemonkeys_FilterSearch::custom_filterSearchr_conditions"

type="Magemonkeys\FilterSearch\Plugin\CatalogSearch\Model\Search\IndexBuilder" />

</type>

</config>

Path: app/code/Magemonkeys/FilterSearch/Plugin/CatalogSearch/Model/Search/IndexBuilder.php

<?php
namespace Magemonkeys\FilterSearch\Plugin\CatalogSearch\Model\Search;

use Magento\Framework\Search\RequestInterface;

class IndexBuilder
{

    public function __construct(
        \Magento\Store\Model\StoreManagerInterface $storeManager,
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory
    ) {
        $this->storeManager = $storeManager;
        $this->_productCollectionFactory = $productCollectionFactory;
    }

    public function aroundBuild(\Magento\CatalogSearch\Model\Search\IndexBuilder $subject, callable $proceed, RequestInterface $request)
    {
        $select = $proceed($request);
        /* customization by magemonkeys */
        	$storeId = $this->storeManager->getStore()->getStoreId();
            $query = 'WHERE_CUSTOM_CONDITION';
            $select->where($query);
        /* customization by magemonkeys end here */
        return $select;
    }

}

<?php

namespace Magemonkeys\FilterSearch\Plugin\CatalogSearch\Model\Search;

use Magento\Framework\Search\RequestInterface;

class IndexBuilder

{

public function __construct(

\Magento\Store\Model\StoreManagerInterface $storeManager,

\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory

) {

$this->storeManager = $storeManager;

$this->_productCollectionFactory = $productCollectionFactory;

}

public function aroundBuild(\Magento\CatalogSearch\Model\Search\IndexBuilder $subject, callable $proceed, RequestInterface $request)

{

$select = $proceed($request);

/* customization by magemonkeys */

$storeId = $this->storeManager->getStore()->getStoreId();

$query = 'WHERE_CUSTOM_CONDITION';

$select->where($query);

/* customization by magemonkeys end here */

return $select;

}

Fill the below form if you have any Magento programming need.

Add an image programmatically from any url in Magento 2
[crayon-63d3ea6d52ea9234721324/] Using above fucntion Images can be imported directly from...
Magento 2 : Override the Category view block file
Override view block using di.xml and add the below code...
How to check list of Layout XML called for a specific page in Magento 2?
You can check a list of called layout XML for...
Magento 2 : Setup PWA from Scratch
Follow the below steps to install and set up PWA...
How to remove leading zero’s from the order, invoice and shipment number in Magento 2?
If you want to remove all leading zero's from order,...

Author Info

Magento Certified Developer

Hire J. Lakum

Let’s have a call

Fill the form & Get Installation Support