AddIsInStockFieldToCollection.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryCatalog\Model\ResourceModel;

use Magento\Catalog\Model\ResourceModel\Product\Collection;
use Magento\InventoryIndexer\Indexer\IndexStructure;
use Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface;

class AddIsInStockFieldToCollection
{
    private $stockIndexTableProvider;

    public function __construct(
        StockIndexTableNameResolverInterface $stockIndexTableProvider
    ) {
        $this->stockIndexTableProvider = $stockIndexTableProvider;
    }

    public function execute($collection, int $stockId)
    {
        $tableName = $this->stockIndexTableProvider->execute($stockId);

        $collection->getSelect()->join(
            ['inventory_in_stock' => $tableName],
            'e.sku = inventory_in_stock.sku',
            []
        )->where('inventory_in_stock.' . IndexStructure::IS_SALABLE . ' = ?', 1);
    }
}