Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/vendor/magento/module-catalog/Model/ResourceModel/Product/Attribute/ |
<?php
/**
* Copyright © Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
namespace Magento\Catalog\Model\ResourceModel\Product\Attribute;
/**
* Catalog product EAV additional attribute resource collection
*
* @api
* @since 100.0.2
*/
class Collection extends \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection
{
/**
* Entity factory
*
* @var \Magento\Eav\Model\EntityFactory
*/
protected $_eavEntityFactory;
/**
* @param \Magento\Framework\Data\Collection\EntityFactory $entityFactory
* @param \Psr\Log\LoggerInterface $logger
* @param \Magento\Framework\Data\Collection\Db\FetchStrategyInterface $fetchStrategy
* @param \Magento\Framework\Event\ManagerInterface $eventManager
* @param \Magento\Eav\Model\EntityFactory $eavEntityFactory
* @param \Magento\Eav\Model\Config $eavConfig
* @param \Magento\Framework\DB\Adapter\AdapterInterface $connection
* @param \Magento\Framework\Model\ResourceModel\Db\AbstractDb $resource
*/
public function __construct(
\Magento\Framework\Data\Collection\EntityFactory $entityFactory,
\Psr\Log\LoggerInterface $logger,
\Magento\Framework\Data\Collection\Db\FetchStrategyInterface $fetchStrategy,
\Magento\Framework\Event\ManagerInterface $eventManager,
\Magento\Eav\Model\Config $eavConfig,
\Magento\Eav\Model\EntityFactory $eavEntityFactory,
\Magento\Framework\DB\Adapter\AdapterInterface $connection = null,
\Magento\Framework\Model\ResourceModel\Db\AbstractDb $resource = null
) {
$this->_eavEntityFactory = $eavEntityFactory;
parent::__construct($entityFactory, $logger, $fetchStrategy, $eventManager, $eavConfig, $connection, $resource);
}
/**
* Resource model initialization
*
* @return void
*/
protected function _construct()
{
$this->_init(
\Magento\Catalog\Model\ResourceModel\Eav\Attribute::class,
\Magento\Eav\Model\ResourceModel\Entity\Attribute::class
);
}
/**
* Initialize select object
*
* @return $this
*/
protected function _initSelect()
{
$entityTypeId = (int)$this->_eavEntityFactory->create()->setType(
\Magento\Catalog\Model\Product::ENTITY
)->getTypeId();
$columns = $this->getConnection()->describeTable($this->getResource()->getMainTable());
unset($columns['attribute_id']);
$retColumns = [];
foreach ($columns as $labelColumn => $columnData) {
$retColumns[$labelColumn] = $labelColumn;
if ($columnData['DATA_TYPE'] == \Magento\Framework\DB\Ddl\Table::TYPE_TEXT) {
$retColumns[$labelColumn] = 'main_table.' . $labelColumn;
}
}
$this->getSelect()->from(
['main_table' => $this->getResource()->getMainTable()],
$retColumns
)->join(
['additional_table' => $this->getTable('catalog_eav_attribute')],
'additional_table.attribute_id = main_table.attribute_id'
)->where(
'main_table.entity_type_id = ?',
$entityTypeId
);
return $this;
}
/**
* Specify attribute entity type filter.
* Entity type is defined.
*
* @param int $typeId
* @return $this
* @SuppressWarnings(PHPMD.UnusedFormalParameter)
*/
public function setEntityTypeFilter($typeId)
{
return $this;
}
/**
* Return array of fields to load attribute values
*
* @return string[]
*/
protected function _getLoadDataFields()
{
$fields = array_merge(
parent::_getLoadDataFields(),
[
'additional_table.is_global',
'additional_table.is_html_allowed_on_front',
'additional_table.is_wysiwyg_enabled'
]
);
return $fields;
}
/**
* Remove price from attribute list
*
* @return $this
*/
public function removePriceFilter()
{
return $this->addFieldToFilter('main_table.attribute_code', ['neq' => 'price']);
}
/**
* Specify "is_visible_in_advanced_search" filter
*
* @return $this
*/
public function addDisplayInAdvancedSearchFilter()
{
return $this->addFieldToFilter('additional_table.is_visible_in_advanced_search', 1);
}
/**
* Specify "is_filterable" filter
*
* @return $this
*/
public function addIsFilterableFilter()
{
return $this->addFieldToFilter('additional_table.is_filterable', ['gt' => 0]);
}
/**
* Add filterable in search filter
*
* @return $this
*/
public function addIsFilterableInSearchFilter()
{
return $this->addFieldToFilter('additional_table.is_filterable_in_search', ['gt' => 0]);
}
/**
* Specify filter by "is_visible" field
*
* @return $this
*/
public function addVisibleFilter()
{
return $this->addFieldToFilter('additional_table.is_visible', 1);
}
/**
* Specify "is_searchable" filter
*
* @return $this
*/
public function addIsSearchableFilter()
{
return $this->addFieldToFilter('additional_table.is_searchable', 1);
}
/**
* Specify filter for attributes that have to be indexed
*
* @param bool $addRequiredCodes
* @return $this
*/
public function addToIndexFilter($addRequiredCodes = false)
{
$conditions = [
'additional_table.is_searchable = 1',
'additional_table.is_visible_in_advanced_search = 1',
'additional_table.is_filterable > 0',
'additional_table.is_filterable_in_search = 1',
'additional_table.used_for_sort_by = 1',
];
if ($addRequiredCodes) {
$conditions[] = $this->getConnection()->quoteInto(
'main_table.attribute_code IN (?)',
['status', 'visibility']
);
}
$this->getSelect()->where(sprintf('(%s)', implode(' OR ', $conditions)));
return $this;
}
/**
* Specify filter for attributes used in quick search
*
* @return $this
*/
public function addSearchableAttributeFilter()
{
$this->getSelect()->where(
'additional_table.is_searchable = 1 OR ' . $this->getConnection()->quoteInto(
'main_table.attribute_code IN (?)',
['status', 'visibility']
)
);
return $this;
}
/**
* Add is used in grid filter
*
* @return $this
*/
public function addIsUsedInGridFilter()
{
return $this->addFieldToFilter('additional_table.is_used_in_grid', 1);
}
}