Magento Extensions Rating 2024
EXTENSIONS BY CATEGORY
B2B (Business-To-Business)
Blog
Customer
ERP (Enterprise Resource Planning)
Mega Menu
One Step Checkout
Order
POS (Point Of Sale)
Search
Shopping Cart
Sitemap
SEO
Social
Stock & Inventory Management
EXTENSIONS BY DEVELOPER
aheadWorks
Amasty
Boost My Shop
BSS Commerce
Magestore
MageWorx
Mirasvit
Templates Master
Wyomind
XTENTO
Magento 2 Documentation
Magento 2 Documentation
2.3
Documentation for Magento 2 CMS v2.3 (December 2018)
vendor
magento
module-inventory-sales
Model
ResourceModel
IsStockItemSalableCondition
MinQtyStockCondition.php
Go to the documentation of this file.
1
<?php
6
declare(strict_types=1);
7
8
namespace
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition
;
9
10
use
Magento\CatalogInventory\Api\StockConfigurationInterface
;
11
use
Magento\Framework\App\ResourceConnection
;
12
use
Magento\Framework\DB\Select
;
13
use
Magento\InventoryApi\Api\Data\SourceItemInterface
;
14
18
class
MinQtyStockCondition
implements
GetIsStockItemSalableConditionInterface
19
{
23
private
$configuration;
24
28
private
$resourceConnection;
29
34
public
function
__construct
(
35
StockConfigurationInterface
$configuration,
36
ResourceConnection
$resourceConnection
37
) {
38
$this->configuration =
$configuration
;
39
$this->resourceConnection =
$resourceConnection
;
40
}
41
46
public
function
execute
(
Select
$select
): string
47
{
48
$globalMinQty = (float)$this->configuration->getMinQty();
49
50
$quantityExpression = (string)$this->resourceConnection->getConnection()->getCheckSql(
51
'source_item.'
.
SourceItemInterface::STATUS
.
' = '
.
SourceItemInterface::STATUS_OUT_OF_STOCK
,
52
0,
53
SourceItemInterface::QUANTITY
54
);
55
$quantityExpression =
'SUM('
. $quantityExpression .
')'
;
56
57
$condition =
58
'(legacy_stock_item.use_config_min_qty = 1 AND '
. $quantityExpression .
' > '
. $globalMinQty .
')'
59
.
' OR '
60
.
'(legacy_stock_item.use_config_min_qty = 0 AND '
. $quantityExpression .
' > legacy_stock_item.min_qty)'
;
61
62
return
$condition;
63
}
64
}
Magento\InventoryApi\Api\Data\SourceItemInterface\QUANTITY
const QUANTITY
Definition:
SourceItemInterface.php:27
Magento\Framework\DB\Select
Definition:
Select.php:33
Magento\InventoryApi\Api\Data\SourceItemInterface\STATUS
const STATUS
Definition:
SourceItemInterface.php:28
$configuration
$configuration
Definition:
index.php:33
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition\MinQtyStockCondition
Definition:
MinQtyStockCondition.php:18
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition\GetIsStockItemSalableConditionInterface
Definition:
GetIsStockItemSalableConditionInterface.php:17
Magento\InventoryApi\Api\Data\SourceItemInterface
Definition:
SourceItemInterface.php:20
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition\MinQtyStockCondition\execute
execute(Select $select)
Definition:
MinQtyStockCondition.php:46
$select
$select
Definition:
catalog_rule_10_off_not_logged_rollback.php:14
Magento\InventoryApi\Api\Data\SourceItemInterface\STATUS_OUT_OF_STOCK
const STATUS_OUT_OF_STOCK
Definition:
SourceItemInterface.php:34
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition\MinQtyStockCondition\__construct
__construct(StockConfigurationInterface $configuration, ResourceConnection $resourceConnection)
Definition:
MinQtyStockCondition.php:34
Magento\CatalogInventory\Api\StockConfigurationInterface
Definition:
StockConfigurationInterface.php:17
$resourceConnection
$resourceConnection
Definition:
website_attribute_sync.php:32
Magento\Framework\App\ResourceConnection
Definition:
ResourceConnection.php:18
Magento\Framework\DB\Select
Definition:
ColumnsRenderer.php:6
Magento\Framework\App\ResourceConnection
Magento\InventorySales\Model\ResourceModel\IsStockItemSalableCondition
Definition:
BackordersCondition.php:8