BulkConfigurationTransfer.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryLowQuantityNotification\Model\ResourceModel;

use Magento\Framework\App\ResourceConnection;
use Magento\Framework\DB\Adapter\DuplicateException;
use Magento\InventoryCatalogApi\Model\GetProductTypesBySkusInterface;
use Magento\InventoryConfigurationApi\Model\IsSourceItemManagementAllowedForProductTypeInterface;

class BulkConfigurationTransfer
{
    private $resourceConnection;

    private $getProductTypesBySkus;

    private $isSourceItemManagementAllowedForProductType;

    public function __construct(
        ResourceConnection $resourceConnection,
        GetProductTypesBySkusInterface $getProductTypesBySkus,
        IsSourceItemManagementAllowedForProductTypeInterface $isSourceItemManagementAllowedForProductType
    ) {
        $this->resourceConnection = $resourceConnection;
        $this->getProductTypesBySkus = $getProductTypesBySkus;
        $this->isSourceItemManagementAllowedForProductType = $isSourceItemManagementAllowedForProductType;
    }

    public function execute(
        array $skus,
        string $originSource,
        string $destinationSource
    ) {
        $tableName = $this->resourceConnection->getTableName('inventory_low_stock_notification_configuration');
        $connection = $this->resourceConnection->getConnection();

        $types = $this->getProductTypesBySkus->execute($skus);

        foreach ($types as $sku => $type) {
            if ($this->isSourceItemManagementAllowedForProductType->execute($type)) {
                foreach ($skus as $sku) {
                    $qry = $connection
                        ->select()
                        ->from($tableName, 'notify_stock_qty')
                        ->where('sku = ?', $sku)
                        ->where('source_code = ?', $originSource);

                    $res = $connection->fetchOne($qry);

                    $notifyStockQty = ($res === null || $res === false) ? null : (float) $res;
                    try {
                        $connection->insert(
                            $tableName,
                            [
                                'source_code' => $destinationSource,
                                'sku' => $sku,
                                'notify_stock_qty' => $notifyStockQty,
                            ]
                        );
                    } catch (DuplicateException $e) {
                        // Do not overwrite an existing configuration if the item was not assigned to the source
                        if ($res !== false) {
                            $connection->update(
                                $tableName,
                                ['notify_stock_qty' => $notifyStockQty],
                                $connection->quoteInto('sku = ?', $sku) . ' AND ' .
                                $connection->quoteInto('source_code = ?', $destinationSource)
                            );
                        }
                    }
                }
            }
        }
    }
}