AddStockStatusToSelect.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryCatalog\Model\ResourceModel;

use Magento\Framework\DB\Select;
use Magento\InventoryIndexer\Indexer\IndexStructure;
use Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface;

class AddStockStatusToSelect
{
    private $stockIndexTableNameResolver;

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

    public function execute(Select $select, int $stockId)
    {
        $tableName = $this->stockIndexTableNameResolver->execute($stockId);

        $select->joinLeft(
            ['stock_status' => $tableName],
            'e.sku = stock_status.sku',
            [IndexStructure::IS_SALABLE]
        );
    }
}