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-indexer
Model
ResourceModel
GetProductIdsBySourceItemIds.php
Go to the documentation of this file.
1
<?php
6
declare(strict_types=1);
7
8
namespace
Magento\InventoryIndexer\Model\ResourceModel
;
9
10
use
Magento\Framework\App\ResourceConnection
;
11
use
Magento\Inventory\Model\ResourceModel\SourceItem
;
12
use
Magento\InventoryApi\Api\Data\SourceItemInterface
;
13
17
class
GetProductIdsBySourceItemIds
18
{
22
private
$resource;
23
27
private
$productTableName;
28
33
public
function
__construct
(
34
ResourceConnection
$resource,
35
string
$productTableName
36
) {
37
$this->resource =
$resource
;
38
$this->productTableName = $productTableName;
39
}
40
47
public
function
execute
(array $sourceItemIds): array
48
{
49
$connection
= $this->resource->getConnection();
50
$select
=
$connection
->select()
51
->from(
52
[
'source_item'
=> $this->resource->getTableName(
SourceItem::TABLE_NAME_SOURCE_ITEM
)],
53
[]
54
)->where(
55
'source_item.'
.
SourceItem::ID_FIELD_NAME
.
' IN (?)'
,
56
$sourceItemIds
57
)->join(
58
[
'product'
=> $this->resource->getTableName($this->productTableName)],
59
'source_item.'
.
SourceItemInterface::SKU
.
' = product.sku'
,
60
[
'product.entity_id'
]
61
)->distinct();
62
63
return
$connection
->fetchCol(
$select
);
64
}
65
}
$resource
$resource
Definition:
bulk.php:12
Magento\InventoryApi\Api\Data\SourceItemInterface
Definition:
SourceItemInterface.php:20
$select
$select
Definition:
catalog_rule_10_off_not_logged_rollback.php:14
Magento\InventoryApi\Api\Data\SourceItemInterface\SKU
const SKU
Definition:
SourceItemInterface.php:25
Magento\Inventory\Model\ResourceModel\SourceItem\TABLE_NAME_SOURCE_ITEM
const TABLE_NAME_SOURCE_ITEM
Definition:
SourceItem.php:20
Magento\Inventory\Model\ResourceModel\SourceItem
Definition:
Collection.php:8
Magento\InventoryIndexer\Model\ResourceModel\GetProductIdsBySourceItemIds\execute
execute(array $sourceItemIds)
Definition:
GetProductIdsBySourceItemIds.php:47
Magento\InventoryIndexer\Model\ResourceModel\GetProductIdsBySourceItemIds\__construct
__construct(ResourceConnection $resource, string $productTableName)
Definition:
GetProductIdsBySourceItemIds.php:33
Magento\Inventory\Model\ResourceModel\SourceItem\ID_FIELD_NAME
const ID_FIELD_NAME
Definition:
SourceItem.php:21
Magento\InventoryIndexer\Model\ResourceModel\GetProductIdsBySourceItemIds
Definition:
GetProductIdsBySourceItemIds.php:17
Magento\Framework\App\ResourceConnection
Definition:
ResourceConnection.php:18
$connection
$connection
Definition:
bulk.php:13
Magento\InventoryIndexer\Model\ResourceModel
Definition:
GetProductIdsBySourceItemIds.php:8
Magento\Framework\App\ResourceConnection