CreateLegacyStockStatusView.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryCatalog\Setup\Patch\Schema;

use Magento\Framework\Setup\Patch\SchemaPatchInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\InventoryCatalogApi\Api\DefaultStockProviderInterface;
use Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface;

class CreateLegacyStockStatusView implements SchemaPatchInterface
{
    private $schemaSetup;

    private $defaultStockProvider;

    private $stockIndexTableNameResolver;

    public function __construct(
        SchemaSetupInterface $schemaSetup,
        DefaultStockProviderInterface $defaultStockProvider,
        StockIndexTableNameResolverInterface $stockIndexTableNameResolver
    ) {
        $this->schemaSetup = $schemaSetup;
        $this->stockIndexTableNameResolver = $stockIndexTableNameResolver;
        $this->defaultStockProvider = $defaultStockProvider;
    }

    public function getAliases()
    {
        return [];
    }

    public function apply()
    {
        $this->schemaSetup->startSetup();
        $defaultStockId = $this->defaultStockProvider->getId();
        $viewToLegacyIndex = $this->stockIndexTableNameResolver->execute($defaultStockId);
        $legacyStockStatusTable = $this->schemaSetup->getTable('cataloginventory_stock_status');
        $productTable = $this->schemaSetup->getTable('catalog_product_entity');
        $sql = "CREATE
                SQL SECURITY INVOKER
                VIEW {$viewToLegacyIndex}
                  AS
                    SELECT
                    DISTINCT    
                      legacy_stock_status.product_id,
                      legacy_stock_status.website_id,
                      legacy_stock_status.stock_id,
                      legacy_stock_status.qty quantity,
                      legacy_stock_status.stock_status is_salable,
                      product.sku
                    FROM {$legacyStockStatusTable} legacy_stock_status
                      INNER JOIN {$productTable} product
                        ON legacy_stock_status.product_id = product.entity_id;";
        $this->schemaSetup->getConnection()->query($sql);
        $this->schemaSetup->endSetup();

        return $this;
    }

    public static function getDependencies()
    {
        return [];
    }
}