MinQtyStockCondition.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  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\InventorySales\Model\ResourceModel\IsStockItemSalableCondition;
  8. use Magento\CatalogInventory\Api\StockConfigurationInterface;
  9. use Magento\Framework\App\ResourceConnection;
  10. use Magento\Framework\DB\Select;
  11. use Magento\InventoryApi\Api\Data\SourceItemInterface;
  12. /**
  13. * Condition for min_qty configuration.
  14. */
  15. class MinQtyStockCondition implements GetIsStockItemSalableConditionInterface
  16. {
  17. /**
  18. * @var StockConfigurationInterface
  19. */
  20. private $configuration;
  21. /**
  22. * @var ResourceConnection
  23. */
  24. private $resourceConnection;
  25. /**
  26. * @param StockConfigurationInterface $configuration
  27. * @param ResourceConnection $resourceConnection
  28. */
  29. public function __construct(
  30. StockConfigurationInterface $configuration,
  31. ResourceConnection $resourceConnection
  32. ) {
  33. $this->configuration = $configuration;
  34. $this->resourceConnection = $resourceConnection;
  35. }
  36. /**
  37. * @inheritdoc
  38. * @SuppressWarnings(PHPMD.UnusedFormalParameter)
  39. */
  40. public function execute(Select $select): string
  41. {
  42. $globalMinQty = (float)$this->configuration->getMinQty();
  43. $quantityExpression = (string)$this->resourceConnection->getConnection()->getCheckSql(
  44. 'source_item.' . SourceItemInterface::STATUS . ' = ' . SourceItemInterface::STATUS_OUT_OF_STOCK,
  45. 0,
  46. SourceItemInterface::QUANTITY
  47. );
  48. $quantityExpression = 'SUM(' . $quantityExpression . ')';
  49. $condition =
  50. '(legacy_stock_item.use_config_min_qty = 1 AND ' . $quantityExpression . ' > ' . $globalMinQty . ')'
  51. . ' OR '
  52. . '(legacy_stock_item.use_config_min_qty = 0 AND ' . $quantityExpression . ' > legacy_stock_item.min_qty)';
  53. return $condition;
  54. }
  55. }