ApplyConfigurationCondition.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryLowQuantityNotification\Model\ResourceModel\Rss\NotifyStock;

use Magento\CatalogInventory\Api\StockConfigurationInterface;
use Magento\Framework\App\ResourceConnection;
use Magento\Framework\DB\Select;

class ApplyConfigurationCondition
{
    private $configuration;

    private $resourceConnection;

    public function __construct(
        StockConfigurationInterface $stockConfiguration,
        ResourceConnection $resourceConnection
    ) {
        $this->configuration = $stockConfiguration;
        $this->resourceConnection = $resourceConnection;
    }

    public function execute(Select $select)
    {
        $configManageStock = $this->configuration->getManageStock();
        $configNotifyStockQty = $this->configuration->getNotifyStockQty();

        $connection = $this->resourceConnection->getConnection();
        $qtyCondition = $connection->getIfNullSql(
            'source_item_config.notify_stock_qty',
            $configNotifyStockQty
        );

        $globalManageStockEnabledCondition = implode(
            [
                $connection->prepareSqlCondition('legacy_stock_item.use_config_manage_stock', 1),
                $connection->prepareSqlCondition($configManageStock, 1),
                $connection->prepareSqlCondition('main_table.quantity', ['lt' => $qtyCondition]),
            ],
            ' ' . Select::SQL_AND . ' '
        );
        $globalManageStockDisabledCondition = implode(
            [
                $connection->prepareSqlCondition('legacy_stock_item.use_config_manage_stock', 0),
                $connection->prepareSqlCondition('legacy_stock_item.manage_stock', 1),
                $connection->prepareSqlCondition('main_table.quantity', ['lt' => $qtyCondition]),
            ],
            ' ' . Select::SQL_AND . ' '
        );

        $condition = implode(
            [
                $globalManageStockEnabledCondition,
                $globalManageStockDisabledCondition,
            ],
            ') ' . Select::SQL_OR . ' ('
        );

        $select->where('(' . $condition . ')');
    }
}