IsSalableOptionSelectBuilder.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryConfigurableProduct\Plugin\Model\ResourceModel\Attribute;

use Magento\ConfigurableProduct\Model\ResourceModel\Attribute\OptionSelectBuilderInterface;
use Magento\Framework\DB\Select;
use Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface;
use Magento\InventorySalesApi\Api\Data\SalesChannelInterface;
use Magento\InventorySalesApi\Api\StockResolverInterface;
use Magento\Store\Model\StoreManagerInterface;

class IsSalableOptionSelectBuilder
{
    private $storeManager;

    private $stockResolver;

    private $stockIndexTableNameResolver;

    public function __construct(
        StoreManagerInterface $storeManager,
        StockResolverInterface $stockResolver,
        StockIndexTableNameResolverInterface $stockIndexTableNameResolver
    ) {
        $this->storeManager = $storeManager;
        $this->stockResolver = $stockResolver;
        $this->stockIndexTableNameResolver = $stockIndexTableNameResolver;
    }

    public function afterGetSelect(
        OptionSelectBuilderInterface $subject,
        Select $select
    ) {
        $websiteCode = $this->storeManager->getWebsite()->getCode();
        $stock = $this->stockResolver->execute(SalesChannelInterface::TYPE_WEBSITE, $websiteCode);
        $stockId = (int)$stock->getStockId();
        $stockTable = $this->stockIndexTableNameResolver->execute($stockId);

        $select->joinInner(
            ['stock' => $stockTable],
            'stock.sku = entity.sku',
            []
        )->where(
            'stock.is_salable = ?',
            1
        );

        return $select;
    }
}