How does \Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable::getChildrenIds() work?

dmitry_fedyuk · April 30, 2016, 7:25pm

Context: How does \Magento\ConfigurableProduct\Model\Product\Type\Configurable::getChildrenIds() work?

magento/magento2/blob/958164/app/code/Magento/ConfigurableProduct/Model/ResourceModel/Product/Type/Configurable.php#L120-L131


/**
 * Retrieve Required children ids
 * Return grouped array, ex array(
 *   group => array(ids)
 * )
 *
 * @param int|array $parentId
 * @param bool $required
 * @return array
 * @SuppressWarnings(PHPMD.UnusedFormalParameter)
 */
public function getChildrenIds($parentId, $required = true)

github.com

magento/magento2/blob/958164/app/code/Magento/ConfigurableProduct/Model/ResourceModel/Product/Type/Configurable.php#L133-L147


$select = $this->getConnection()->select()->from(
    ['l' => $this->getMainTable()],
    ['product_id', 'parent_id']
)->join(
    ['p' => $this->getTable('catalog_product_entity')],
    'p.' . $this->getProductEntityLinkField() . ' = l.parent_id',
    []
)->join(
    ['e' => $this->getTable('catalog_product_entity')],
    'e.entity_id = l.product_id AND e.required_options = 0',
    []
)->where(
    'p.entity_id IN (?)',
    $parentId
);

SELECT `l`.`product_id`, `l`.`parent_id`
FROM
		`catalog_product_super_link` AS `l`
	INNER JOIN
		`catalog_product_entity` AS `p` ON p.entity_id = l.parent_id
 	INNER JOIN
 		`catalog_product_entity` AS `e`
	ON
			e.entity_id = l.product_id
		AND
			e.required_options = 0
WHERE (p.entity_id IN ('128'))

github.com

magento/magento2/blob/958164/app/code/Magento/ConfigurableProduct/Model/ResourceModel/Product/Type/Configurable.php#L149-L152


$childrenIds = [0 => []];
foreach ($this->getConnection()->fetchAll($select) as $row) {
    $childrenIds[0][$row['product_id']] = $row['product_id'];
}

github.com

magento/magento2/blob/958164/app/code/Magento/ConfigurableProduct/Model/ResourceModel/Product/Type/Configurable.php#L154-L154


return $childrenIds;