How does \Magento\Eav\Model\AttributeRepository::getList() work?

dmitry_fedyuk (Dmitrii Fediuk) April 25, 2016, 8:20pm 1

Context:

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L88-L91


/**
 * {@inheritdoc}
 */
public function getList($entityTypeCode, \Magento\Framework\Api\SearchCriteriaInterface $searchCriteria)

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L93-L99


if (!$entityTypeCode) {
    throw InputException::requiredField('entity_type_code');
}


/** @var \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection $attributeCollection */
$attributeCollection = $this->attributeCollectionFactory->create();
$this->joinProcessor->process($attributeCollection);

Details: How does \Magento\Framework\Api\ExtensionAttribute\JoinProcessor::process() work?

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L100-L111


$attributeCollection->addFieldToFilter('entity_type_code', ['eq' => $entityTypeCode]);
$attributeCollection->join(
    ['entity_type' => $attributeCollection->getTable('eav_entity_type')],
    'main_table.entity_type_id = entity_type.entity_type_id',
    []
);
$attributeCollection->joinLeft(
    ['eav_entity_attribute' => $attributeCollection->getTable('eav_entity_attribute')],
    'main_table.attribute_id = eav_entity_attribute.attribute_id',
    []
);
$entityType = $this->eavConfig->getEntityType($entityTypeCode);

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L113-L113


$additionalTable = $entityType->getAdditionalAttributeTable();

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L114-L120


if ($additionalTable) {
    $attributeCollection->join(
        ['additional_table' => $attributeCollection->getTable($additionalTable)],
        'main_table.attribute_id = additional_table.attribute_id',
        []
    );
}

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L121-L124


//Add filters from root filter group to the collection
foreach ($searchCriteria->getFilterGroups() as $group) {
    $this->addFilterGroupToCollection($group, $attributeCollection);
}

How does \Magento\Eav\Model\AttributeRepository::addFilterGroupToCollection() work?

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L125-L131


/** @var SortOrder $sortOrder */
foreach ((array)$searchCriteria->getSortOrders() as $sortOrder) {
    $attributeCollection->addOrder(
        $sortOrder->getField(),
        ($sortOrder->getDirection() == SortOrder::SORT_ASC) ? 'ASC' : 'DESC'
    );
}

github.com

magento/magento2/blob/958164/lib/internal/Magento/Framework/Api/SearchCriteria.php#L34-L42


/**
 * Get sort order.
 *
 * @return \Magento\Framework\Api\SortOrder[]|null
 */
public function getSortOrders()
{
    return $this->_get(self::SORT_ORDERS);
}

How does \Magento\Framework\Data\Collection\AbstractDb::getSize() work?

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L135-L136


// Group attributes by id to prevent duplicates with different attribute sets
$attributeCollection->addAttributeGrouping();

Details: How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work?

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L137-L138


$attributeCollection->setCurPage($searchCriteria->getCurrentPage());
$attributeCollection->setPageSize($searchCriteria->getPageSize());

$attributeCollection->getSelect()->assemble()

SELECT `main_table`.* FROM `eav_attribute` AS `main_table`
	INNER JOIN `eav_entity_type` AS `entity_type`
		ON main_table.entity_type_id = entity_type.entity_type_id
	LEFT JOIN `eav_entity_attribute` 
		ON main_table.attribute_id = eav_entity_attribute.attribute_id
	INNER JOIN `catalog_eav_attribute` AS `additional_table` 
		ON main_table.attribute_id = additional_table.attribute_id 
WHERE (`entity_type_code` = ''catalog_product'') AND (`attribute_set_id` != '''') 
GROUP BY `main_table`.`attribute_id`

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L140-L144


$attributes = [];
/** @var \Magento\Eav\Api\Data\AttributeInterface $attribute */
foreach ($attributeCollection as $attribute) {
    $attributes[] = $this->get($entityTypeCode, $attribute->getAttributeCode());
}

Details: How does \Magento\Eav\Model\AttributeRepository::get() work?

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/AttributeRepository.php#L145-L149


$searchResults = $this->searchResultsFactory->create();
$searchResults->setSearchCriteria($searchCriteria);
$searchResults->setItems($attributes);
$searchResults->setTotalCount($totalCount);
return $searchResults;

How is \Magento\Eav\Api\AttributeRepositoryInterface::getList() implemented?

How does \Magento\Framework\Api\ExtensionAttribute\JoinProcessor::process() work?

How does \Magento\Eav\Model\AttributeRepository::addFilterGroupToCollection() work?

How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work?