IsInvalidationRequiredForSource.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. /**
  3. * Copyright © Magento, Inc. All rights reserved.
  4. * See COPYING.txt for license details.
  5. */
  6. declare(strict_types=1);
  7. namespace Magento\InventoryIndexer\Model\ResourceModel;
  8. use Magento\Framework\App\ResourceConnection;
  9. use Magento\Inventory\Model\ResourceModel\Source;
  10. use Magento\Inventory\Model\ResourceModel\SourceItem;
  11. use Magento\Inventory\Model\ResourceModel\StockSourceLink;
  12. use Magento\InventoryApi\Api\Data\SourceInterface;
  13. /**
  14. * Is Inventory Indexer invalidation required after Source enabling or disabling.
  15. */
  16. class IsInvalidationRequiredForSource
  17. {
  18. /**
  19. * @var ResourceConnection
  20. */
  21. private $resourceConnection;
  22. /**
  23. * @param ResourceConnection $resourceConnection
  24. */
  25. public function __construct(
  26. ResourceConnection $resourceConnection
  27. ) {
  28. $this->resourceConnection = $resourceConnection;
  29. }
  30. /**
  31. * Returns 'true' only if Source 'enabled' value is changed, Source is linked to Stock and contains at least one
  32. * Source Item.
  33. *
  34. * @param string $sourceCode
  35. * @param bool $enabled
  36. * @return bool
  37. */
  38. public function execute(string $sourceCode, bool $enabled): bool
  39. {
  40. $connection = $this->resourceConnection->getConnection();
  41. $sourceTable = $this->resourceConnection->getTableName(Source::TABLE_NAME_SOURCE);
  42. $sourceItemTable = $this->resourceConnection->getTableName(SourceItem::TABLE_NAME_SOURCE_ITEM);
  43. $stockSourceLinkTable = $this->resourceConnection->getTableName(StockSourceLink::TABLE_NAME_STOCK_SOURCE_LINK);
  44. $select = $connection->select()
  45. ->from(
  46. ['sources' => $sourceTable],
  47. '(sources.' . SourceInterface::ENABLED . ' != ' . (int)$enabled . ')'
  48. )
  49. ->joinInner(
  50. ['source_item' => $sourceItemTable],
  51. 'sources.' . SourceInterface::SOURCE_CODE . '=' . 'source_item.' . SourceInterface::SOURCE_CODE,
  52. null
  53. )->joinInner(
  54. ['stock_source_link' => $stockSourceLinkTable],
  55. 'sources.' . SourceInterface::SOURCE_CODE . '=' . 'stock_source_link.' . SourceInterface::SOURCE_CODE,
  56. null
  57. )
  58. ->where('sources.' . SourceInterface::SOURCE_CODE . ' = ?', $sourceCode);
  59. return (bool)$connection->fetchOne($select);
  60. }
  61. }