Flat Class Reference

Inheritance diagram for Flat:

Public Member Functions
	__construct (\Magento\Framework\Model\ResourceModel\Db\Context $context, \Magento\Framework\Indexer\Table\StrategyInterface $tableStrategy, \Magento\Catalog\Model\CategoryFactory $categoryFactory, \Magento\Catalog\Model\ResourceModel\Category\CollectionFactory $categoryCollectionFactory, \Magento\Store\Model\StoreManagerInterface $storeManager, \Magento\Catalog\Model\Config $catalogConfig, \Magento\Framework\Event\ManagerInterface $eventManager, $connectionName=null, \Magento\Catalog\Model\ResourceModel\Category\Flat\CollectionFactory $categoryFlatCollectionFactory=null)
	setStoreId ($storeId)
	getStoreId ()
	getMainTable ()
	getMainStoreTable ($storeId=\Magento\Store\Model\Store::DEFAULT_STORE_ID)
	addInactiveCategoryIds ($ids)
	getInactiveCategoryIds ()
	addChildNodes ($children, $path, $parent)
	getNodes ($parentId, $recursionLevel=0, $storeId=0)
	getCategories ($parent, $recursionLevel=0, $sorted=false, $asCollection=false, $toLoad=true)
	getNodeById ($nodeId, $nodes=null)
	getAttribute ($attribute)
	getChildrenAmount ($category, $isActiveFlag=true)
	getProductCount ($category)
	getParentCategories ($category, $isActive=true)
	getParentDesignCategory ($category)
	getChildrenCategories ($category)
	isInRootCategoryList ($category)
	getChildren ($category, $recursive=true, $isActive=true, $sortByPosition=false)
	getAllChildren ($category)
	checkId ($id)
	getAnchorsAbove (array $filterIds, $storeId=0)
	getProductsPosition ($category)
Public Member Functions inherited from AbstractResource
	__construct (\Magento\Framework\Model\ResourceModel\Db\Context $context, \Magento\Framework\Indexer\Table\StrategyInterface $tableStrategy, $connectionName=null)
	reindexAll ()
	getIdxTable ($table=null)
	syncData ()
	insertFromTable ($sourceTable, $destTable, $readToIndex=true)
	insertFromSelect ($select, $destTable, array $columns, $readToIndex=true)
	clearTemporaryIndexTable ()
Public Member Functions inherited from AbstractDb
	__construct (\Magento\Framework\Model\ResourceModel\Db\Context $context, $connectionName=null)
	__sleep ()
	__wakeup ()
	getIdFieldName ()
	getMainTable ()
	getTable ($tableName)
	getConnection ()
	load (\Magento\Framework\Model\AbstractModel $object, $value, $field=null)
	save (\Magento\Framework\Model\AbstractModel $object)
	delete (\Magento\Framework\Model\AbstractModel $object)
	addUniqueField ($field)
	resetUniqueField ()
	unserializeFields (\Magento\Framework\Model\AbstractModel $object)
	getUniqueFields ()
	hasDataChanged ($object)
	getChecksum ($table)
	afterLoad (\Magento\Framework\DataObject $object)
	beforeSave (\Magento\Framework\DataObject $object)
	afterSave (\Magento\Framework\DataObject $object)
	beforeDelete (\Magento\Framework\DataObject $object)
	afterDelete (\Magento\Framework\DataObject $object)
	serializeFields (\Magento\Framework\Model\AbstractModel $object)
Public Member Functions inherited from AbstractResource
	__construct ()
	getConnection ()
	beginTransaction ()
	addCommitCallback ($callback)
	commit ()
	rollBack ()
	getValidationRulesBeforeSave ()

Protected Member Functions
	_construct ()
	_initInactiveCategoryIds ()
	_loadNodes ($parentNode=null, $recursionLevel=0, $storeId=0, $skipMenuFilter=false)
Protected Member Functions inherited from AbstractResource
	_getIndexAdapter ()
Protected Member Functions inherited from AbstractDb
	_init ($mainTable, $idFieldName)
	_setResource ($connections, $tables=null)
	_setMainTable ($mainTable, $idFieldName=null)
	_getConnection ($resourceName)
	_getLoadSelect ($field, $value, $object)
	_initUniqueFields ()
	_prepareDataForSave (\Magento\Framework\Model\AbstractModel $object)
	_prepareValueForSave ($value, $type)
	_checkUnique (\Magento\Framework\Model\AbstractModel $object)
	_afterLoad (\Magento\Framework\Model\AbstractModel $object)
	_beforeSave (\Magento\Framework\Model\AbstractModel $object)
	_afterSave (\Magento\Framework\Model\AbstractModel $object)
	_beforeDelete (\Magento\Framework\Model\AbstractModel $object)
	_afterDelete (\Magento\Framework\Model\AbstractModel $object)
	_serializeFields (\Magento\Framework\Model\AbstractModel $object)
	prepareDataForUpdate ($object)
	isObjectNotNew (\Magento\Framework\Model\AbstractModel $object)
	saveNewObject (\Magento\Framework\Model\AbstractModel $object)
	updateObject (\Magento\Framework\Model\AbstractModel $object)
	processAfterSaves (\Magento\Framework\Model\AbstractModel $object)
	isModified (\Magento\Framework\Model\AbstractModel $object)
	processNotModifiedSave (\Magento\Framework\Model\AbstractModel $object)
Protected Member Functions inherited from AbstractResource
	_construct ()
	_serializeField (DataObject $object, $field, $defaultValue=null, $unsetEmpty=false)
	_unserializeField (DataObject $object, $field, $defaultValue=null)
	_prepareDataForTable (DataObject $object, $table)
	_prepareTableValueForSave ($value, $type)
	_getColumnsForEntityLoad (\Magento\Framework\Model\AbstractModel $object, $tableName)
	getSerializer ()

Protected Attributes
	$_storeId
	$_loaded = false
	$_nodes = []
	$_inactiveCategoryIds
	$_eventManager
	$_catalogConfig
	$_storeManager
	$_categoryCollectionFactory
	$_categoryFactory
Protected Attributes inherited from AbstractResource
	$tableStrategy
Protected Attributes inherited from AbstractDb
	$_resources
	$connectionName = \Magento\Framework\App\ResourceConnection::DEFAULT_CONNECTION
	$_connections = []
	$_resourceModel
	$_tables = []
	$_mainTable
	$_idFieldName
	$_isPkAutoIncrement = true
	$_useIsObjectNew = false
	$_mainTableFields
	$_uniqueFields = null
	$_serializableFields = []
	$transactionManager
	$objectRelationProcessor
Protected Attributes inherited from AbstractResource
	$serializer
	$_logger

Detailed Description

Category flat model

@SuppressWarnings(PHPMD.LongVariable) @SuppressWarnings(PHPMD.CouplingBetweenObjects)

Definition at line 17 of file Flat.php.

Constructor & Destructor Documentation

__construct()

__construct	(	\Magento\Framework\Model\ResourceModel\Db\Context	$context,
		\Magento\Framework\Indexer\Table\StrategyInterface	$tableStrategy,
		\Magento\Catalog\Model\CategoryFactory	$categoryFactory,
		\Magento\Catalog\Model\ResourceModel\Category\CollectionFactory	$categoryCollectionFactory,
		\Magento\Store\Model\StoreManagerInterface	$storeManager,
		\Magento\Catalog\Model\Config	$catalogConfig,
		\Magento\Framework\Event\ManagerInterface	$eventManager,
			$connectionName = null,
		\Magento\Catalog\Model\ResourceModel\Category\Flat\CollectionFactory	$categoryFlatCollectionFactory = null
	)

Constructor

Parameters

\Magento\Framework\Model\ResourceModel\Db\Context	$context
\Magento\Framework\Indexer\Table\StrategyInterface	$tableStrategy
\Magento\Catalog\Model\CategoryFactory	$categoryFactory
CollectionFactory	$categoryCollectionFactory
\Magento\Store\Model\StoreManagerInterface	$storeManager
\Magento\Catalog\Model\Config	$catalogConfig
\Magento\Framework\Event\ManagerInterface	$eventManager
string	$connectionName
\Magento\Catalog\Model\ResourceModel\Category\Flat\CollectionFactory | null	$categoryFlatCollectionFactory

Definition at line 101 of file Flat.php.

      {
        $this->_categoryFactory = $categoryFactory;
        $this->_categoryCollectionFactory = $categoryCollectionFactory;
        $this->_storeManager = $storeManager;
        $this->_catalogConfig = $catalogConfig;
        $this->_eventManager = $eventManager;
        $this->categoryFlatCollectionFactory = $categoryFlatCollectionFactory ?: ObjectManager::getInstance()
            ->get(\Magento\Catalog\Model\ResourceModel\Category\Flat\CollectionFactory::class);
        parent::__construct($context, $tableStrategy, $connectionName);
    }

Member Function Documentation

_construct()

_construct ( )

protected

Resource initializations

Returns

void

Definition at line 127 of file Flat.php.

    {
        $this->_init('catalog_category_flat', 'entity_id');
    }

_initInactiveCategoryIds()

_initInactiveCategoryIds ( )

protected

Retrieve inactive categories ids

Returns

$this

Definition at line 209 of file Flat.php.

    {
        $this->_inactiveCategoryIds = [];
        $this->_eventManager->dispatch('catalog_category_tree_init_inactive_category_ids', ['tree' => $this]);
        return $this;
    }

_loadNodes()

_loadNodes (   $parentNode = null,   $recursionLevel = 0,   $storeId = 0,   $skipMenuFilter = false  )

protected

Load nodes by parent id

Parameters

\Magento\Catalog\Model\Category | int	$parentNode
integer	$recursionLevel
integer	$storeId
bool	$skipMenuFilter

Returns

array

Definition at line 239 of file Flat.php.

    {
        $_conn = $this->getConnection();
        $startLevel = 1;
        $parentPath = '';
        if ($parentNode instanceof \Magento\Catalog\Model\Category) {
            $parentPath = $parentNode->getPath();
            $startLevel = $parentNode->getLevel();
        } elseif (is_numeric($parentNode)) {
            $selectParent = $_conn->select()->from(
                $this->getMainStoreTable($storeId)
            )->where(
                'entity_id = ?',
                $parentNode
            )->where(
                'store_id = ?',
                $storeId
            );
            $parentNode = $_conn->fetchRow($selectParent);
            if ($parentNode) {
                $parentPath = $parentNode['path'];
                $startLevel = $parentNode['level'];
            }
        }
        $select = $_conn->select()->from(
            ['main_table' => $this->getMainStoreTable($storeId)],
            [
                'entity_id',
                new \Zend_Db_Expr('main_table.' . $_conn->quoteIdentifier('name')),
                new \Zend_Db_Expr('main_table.' . $_conn->quoteIdentifier('path')),
                'is_active',
                'is_anchor'
            ]
        )->joinLeft(
            ['url_rewrite' => $this->getTable('url_rewrite')],
            'url_rewrite.entity_id = main_table.entity_id AND url_rewrite.is_autogenerated = 1'
            . $_conn->quoteInto(' AND url_rewrite.store_id = ?', $storeId)
            . $_conn->quoteInto(' AND url_rewrite.entity_type = ?', CategoryUrlRewriteGenerator::ENTITY_TYPE),
            ['request_path' => 'url_rewrite.request_path']
        )->where('main_table.is_active = 1');

        if (false == $skipMenuFilter) {
            $select->where('main_table.include_in_menu = ?', '1');
        }

        $select->order('main_table.position');

        if ($parentPath) {
            $select->where($_conn->quoteInto("main_table.path like ?", "{$parentPath}/%"));
        }
        if ($recursionLevel != 0) {
            $levelField = $_conn->quoteIdentifier('level');
            $select->where($levelField . ' <= ?', $startLevel + $recursionLevel);
        }

        $inactiveCategories = $this->getInactiveCategoryIds();

        if (!empty($inactiveCategories)) {
            $select->where('main_table.entity_id NOT IN (?)', $inactiveCategories);
        }

        // Allow extensions to modify select (e.g. add custom category attributes to select)
        $this->_eventManager->dispatch('catalog_category_flat_loadnodes_before', ['select' => $select]);

        $arrNodes = $_conn->fetchAll($select);
        $nodes = [];
        foreach ($arrNodes as $node) {
            $node['id'] = $node['entity_id'];
            $nodes[$node['id']] = $this->_categoryFactory->create()->setData($node);
        }

        return $nodes;
    }

addChildNodes()

addChildNodes	(		$children,
			$path,
			$parent
	)

Creating sorted array of nodes

Parameters

array	$children
string	$path
\Magento\Framework\DataObject	$parent

Returns

void

Definition at line 321 of file Flat.php.

    {
        if (isset($children[$path])) {
            foreach ($children[$path] as $child) {
                $childrenNodes = $parent->getChildrenNodes();
                if ($childrenNodes && isset($childrenNodes[$child->getId()])) {
                    $childrenNodes[$child['entity_id']]->setChildrenNodes([$child->getId() => $child]);
                } else {
                    if ($childrenNodes) {
                        $childrenNodes[$child->getId()] = $child;
                    } else {
                        $childrenNodes = [$child->getId() => $child];
                    }
                    $parent->setChildrenNodes($childrenNodes);
                }

                if ($path) {
                    $childrenPath = explode('/', $path);
                } else {
                    $childrenPath = [];
                }
                $childrenPath[] = $child->getId();
                $childrenPath = implode('/', $childrenPath);
                $this->addChildNodes($children, $childrenPath, $child);
            }
        }
    }

addInactiveCategoryIds()

addInactiveCategoryIds

(

$ids

)

Add inactive categories ids

Parameters

array

$ids

Returns

$this

Definition at line 195 of file Flat.php.

    {
        if (!is_array($this->_inactiveCategoryIds)) {
            $this->_initInactiveCategoryIds();
        }
        $this->_inactiveCategoryIds = array_merge($ids, $this->_inactiveCategoryIds);
        return $this;
    }

checkId()

checkId

(

$id

)

Check if category id exist

Parameters

int

$id

Returns

bool

Definition at line 655 of file Flat.php.

    {
        $select = $this->getConnection()->select()->from(
            $this->getMainStoreTable($this->getStoreId()),
            'entity_id'
        )->where(
            'entity_id=?',
            $id
        );
        return $this->getConnection()->fetchOne($select);
    }

getAllChildren()

getAllChildren

(

$category

)

Return all children ids of category (with category id)

Parameters

\Magento\Catalog\Model\Category

$category

Returns

array

Definition at line 640 of file Flat.php.

    {
        $categoriesIds = $this->getChildren($category);
        $myId = [$category->getId()];
        $categoriesIds = array_merge($myId, $categoriesIds);

        return $categoriesIds;
    }

getAnchorsAbove()

getAnchorsAbove	(	array	$filterIds,
			$storeId = 0
	)

Retrieve anchors above

Parameters

array	$filterIds
int	$storeId

Returns

array

Definition at line 674 of file Flat.php.

    {
        $select = $this->getConnection()->select()->from(
            ['e' => $this->getMainStoreTable($storeId)],
            'entity_id'
        )->where(
            'is_anchor = ?',
            1
        )->where(
            'entity_id IN (?)',
            $filterIds
        );

        return $this->getConnection()->fetchCol($select);
    }

getAttribute()

getAttribute

(

$attribute

)

Retrieve attribute instance

Special for non static flat table.

Parameters

mixed

$attribute

Returns

\Magento\Eav\Model\Entity\Attribute\AbstractAttribute

Definition at line 461 of file Flat.php.

    {
        return $this->_catalogConfig->getAttribute(\Magento\Catalog\Model\Category::ENTITY, $attribute);
    }

getCategories()

getCategories	(		$parent,
			$recursionLevel = 0,
			$sorted = false,
			$asCollection = false,
			$toLoad = true
	)

Return array or collection of categories

Parameters

integer	$parent
integer	$recursionLevel
boolean | string	$sorted
boolean	$asCollection
boolean	$toLoad

Returns

array|\Magento\Framework\Data\Collection

Definition at line 401 of file Flat.php.

    {
        if ($asCollection) {
            $select = $this->getConnection()->select()->from(
                ['mt' => $this->getMainStoreTable($this->getStoreId())],
                ['path']
            )->where(
                'mt.entity_id = ?',
                $parent
            );
            $parentPath = $this->getConnection()->fetchOne($select);

            $collection = $this->categoryFlatCollectionFactory
                ->create()
                ->addNameToResult()
                ->addUrlRewriteToResult()
                ->addParentPathFilter($parentPath)
                ->addStoreFilter()
                ->addIsActiveFilter()
                ->addAttributeToFilter('include_in_menu', 1)
                ->addSortedField($sorted);
            if ($toLoad) {
                return $collection->load();
            }
            return $collection;
        }
        return $this->getNodes($parent, $recursionLevel, $this->_storeManager->getStore()->getId());
    }

getChildren()

getChildren	(		$category,
			$recursive = true,
			$isActive = true,
			$sortByPosition = false
	)

Return children ids of category

Parameters

\Magento\Catalog\Model\Category	$category
bool	$recursive
bool	$isActive
bool	$sortByPosition

Returns

array

Definition at line 608 of file Flat.php.

    {
        $select = $this->getConnection()->select()->from(
            $this->getMainStoreTable($category->getStoreId()),
            'entity_id'
        )->where(
            'path LIKE ?',
            "{$category->getPath()}/%"
        );
        if (!$recursive) {
            $select->where('level <= ?', $category->getLevel() + 1);
        }
        if ($isActive) {
            $select->where('is_active = ?', '1');
        }
        if ($sortByPosition) {
            $select->order('position ASC');
        }
        $_categories = $this->getConnection()->fetchAll($select);
        $categoriesIds = [];
        foreach ($_categories as $_category) {
            $categoriesIds[] = $_category['entity_id'];
        }
        return $categoriesIds;
    }

getChildrenAmount()

getChildrenAmount	(		$category,
			$isActiveFlag = true
	)

Get count of active/not active children categories

Parameters

\Magento\Catalog\Model\Category	$category
bool	$isActiveFlag

Returns

integer

Definition at line 473 of file Flat.php.

    {
        $_table = $this->getMainStoreTable($category->getStoreId());
        $select = $this->getConnection()->select()->from(
            $_table,
            "COUNT({$_table}.entity_id)"
        )->where(
            "{$_table}.path LIKE ?",
            $category->getPath() . '/%'
        )->where(
            "{$_table}.is_active = ?",
            (int)$isActiveFlag
        );
        return (int)$this->getConnection()->fetchOne($select);
    }

getChildrenCategories()

getChildrenCategories

(

$category

)

Return children categories of category

Parameters

\Magento\Catalog\Model\Category

$category

Returns

\Magento\Catalog\Model\Category[]

Definition at line 581 of file Flat.php.

    {
        $categories = $this->_loadNodes($category, 1, $category->getStoreId(), true);
        return $categories;
    }

getInactiveCategoryIds()

getInactiveCategoryIds

(

)

Retrieve inactive categories ids

Returns

array

Definition at line 221 of file Flat.php.

    {
        if (!is_array($this->_inactiveCategoryIds)) {
            $this->_initInactiveCategoryIds();
        }

        return $this->_inactiveCategoryIds;
    }

getMainStoreTable()

getMainStoreTable

(

$storeId = \Magento\Store\Model\Store::DEFAULT_STORE_ID

)

Return name of table for given $storeId.

Parameters

integer

$storeId

Returns

string

Definition at line 173 of file Flat.php.

    {
        if (is_string($storeId)) {
            $storeId = intval($storeId);
        }

        if ($storeId) {
            $suffix = sprintf('store_%d', $storeId);
            $table = $this->getTable('catalog_category_flat_' . $suffix);
        } else {
            $table = parent::getMainTable();
        }

        return $table;
    }

getMainTable()

getMainTable

(

)

Get main table name

Returns

string

Definition at line 162 of file Flat.php.

    {
        return $this->getMainStoreTable($this->getStoreId());
    }

getNodeById()

getNodeById	(		$nodeId,
			$nodes = null
	)

Return node with id $nodeId

Parameters

integer	$nodeId
array	$nodes

Returns

\Magento\Framework\DataObject

Definition at line 437 of file Flat.php.

    {
        if ($nodes === null) {
            $nodes = $this->getNodes($nodeId);
        }
        if (isset($nodes[$nodeId])) {
            return $nodes[$nodeId];
        }
        foreach ($nodes as $node) {
            if ($node->getChildrenNodes()) {
                return $this->getNodeById($nodeId, $node->getChildrenNodes());
            }
        }
        return [];
    }

getNodes()

getNodes	(		$parentId,
			$recursionLevel = 0,
			$storeId = 0
	)

Return sorted array of nodes

Parameters

integer | null	$parentId
integer	$recursionLevel
integer	$storeId

Returns

array

Definition at line 357 of file Flat.php.

    {
        if (!$this->_loaded) {
            $selectParent = $this->getConnection()->select()->from(
                $this->getMainStoreTable($storeId)
            )->where(
                'entity_id = ?',
                $parentId
            );
            if ($parentNode = $this->getConnection()->fetchRow($selectParent)) {
                $parentNode['id'] = $parentNode['entity_id'];
                $parentNode = $this->_categoryFactory->create()->setData($parentNode);
                $this->_nodes[$parentNode->getId()] = $parentNode;
                $nodes = $this->_loadNodes($parentNode, $recursionLevel, $storeId);
                $childrenItems = [];
                foreach ($nodes as $node) {
                    $pathToParent = explode('/', $node->getPath());
                    array_pop($pathToParent);
                    $pathToParent = implode('/', $pathToParent);
                    $childrenItems[$pathToParent][] = $node;
                }
                $this->addChildNodes($childrenItems, $parentNode->getPath(), $parentNode);
                $childrenNodes = $this->_nodes[$parentNode->getId()];
                if ($childrenNodes->getChildrenNodes()) {
                    $this->_nodes = $childrenNodes->getChildrenNodes();
                } else {
                    $this->_nodes = [];
                }
                $this->_loaded = true;
            }
        }
        return $this->_nodes;
    }

getParentCategories()

getParentCategories	(		$category,
			$isActive = true
	)

Return parent categories of category

Parameters

\Magento\Catalog\Model\Category	$category
bool	$isActive

Returns

\Magento\Catalog\Model\Category[]

Definition at line 516 of file Flat.php.

    {
        $categories = [];
        $connection = $this->getConnection();
        $select = $connection->select()->from(
            ['main_table' => $this->getMainStoreTable($category->getStoreId())],
            ['main_table.entity_id', 'main_table.name']
        )->joinLeft(
            ['url_rewrite' => $this->getTable('url_rewrite')],
            'url_rewrite.entity_id = main_table.entity_id AND url_rewrite.is_autogenerated = 1'
            . $connection->quoteInto(' AND url_rewrite.store_id = ?', $category->getStoreId())
            . $connection->quoteInto(' AND url_rewrite.entity_type = ?', CategoryUrlRewriteGenerator::ENTITY_TYPE),
            ['request_path' => 'url_rewrite.request_path']
        )->where(
            'main_table.entity_id IN (?)',
            array_reverse(explode(',', $category->getPathInStore()))
        );
        if ($isActive) {
            $select->where('main_table.is_active = ?', '1');
        }
        $select->order('main_table.path ASC');
        $result = $this->getConnection()->fetchAll($select);
        foreach ($result as $row) {
            $row['id'] = $row['entity_id'];
            $categories[$row['entity_id']] = $this->_categoryFactory->create()->setData($row);
        }
        return $categories;
    }

getParentDesignCategory()

getParentDesignCategory

(

$category

)

Return parent category of current category with own custom design settings

Parameters

\Magento\Catalog\Model\Category

$category

Returns

\Magento\Catalog\Model\Category

Definition at line 551 of file Flat.php.

    {
        $pathIds = array_reverse($category->getPathIds());
        $collection = clone $category->getCollection();
        $collection->setMainTable(
            $this->getMainStoreTable($category->getStoreId())
        )->addFieldToSelect(
            '*'
        )->addFieldToFilter(
            'entity_id',
            ['in' => $pathIds]
        )->addFieldToFilter(
            'custom_use_parent_settings',
            [['eq' => 0], ['null' => 0]]
        )->addFieldToFilter(
            'level',
            ['neq' => 0]
        )->setOrder(
            'level',
            'DESC'
        )->load();
        return $collection->getFirstItem();
    }

getProductCount()

getProductCount

(

$category

)

Get products count in category

Parameters

\Magento\Catalog\Model\Category

$category

Returns

integer

Definition at line 495 of file Flat.php.

    {
        $select = $this->getConnection()->select()->from(
            $this->getTable('catalog_category_product'),
            "COUNT({$this->getTable('catalog_category_product')}.product_id)"
        )->where(
            "{$this->getTable('catalog_category_product')}.category_id = ?",
            $category->getId()
        )->group(
            "{$this->getTable('catalog_category_product')}.category_id"
        );
        return (int)$this->getConnection()->fetchOne($select);
    }

getProductsPosition()

getProductsPosition

(

$category

)

Get positions of associated to category products

Parameters

\Magento\Catalog\Model\Category

$category

Returns

array

Definition at line 696 of file Flat.php.

    {
        $select = $this->getConnection()->select()->from(
            $this->getTable('catalog_category_product'),
            ['product_id', 'position']
        )->where(
            'category_id = :category_id'
        );
        $bind = ['category_id' => (int)$category->getId()];

        return $this->getConnection()->fetchPairs($select, $bind);
    }

getStoreId()

getStoreId

(

)

Return store id

Returns

integer

Definition at line 149 of file Flat.php.

    {
        if ($this->_storeId === null) {
            return (int)$this->_storeManager->getStore()->getId();
        }
        return $this->_storeId;
    }

isInRootCategoryList()

isInRootCategoryList

(

$category

)

Check is category in list of store categories

Parameters

\Magento\Catalog\Model\Category

$category

Returns

boolean

Definition at line 593 of file Flat.php.

    {
        $pathIds = $category->getParentIds();
        return in_array($this->_storeManager->getStore()->getRootCategoryId(), $pathIds);
    }

setStoreId()

setStoreId

(

$storeId

)

Set store id

Parameters

integer

$storeId

Returns

$this

Definition at line 138 of file Flat.php.

    {
        $this->_storeId = (int)$storeId;
        return $this;
    }

Field Documentation

$_catalogConfig

$_catalogConfig

protected

Definition at line 59 of file Flat.php.

$_categoryCollectionFactory

$_categoryCollectionFactory

protected

Definition at line 74 of file Flat.php.

$_categoryFactory

$_categoryFactory

protected

Definition at line 81 of file Flat.php.

$_eventManager

$_eventManager

protected

Definition at line 52 of file Flat.php.

$_inactiveCategoryIds

$_inactiveCategoryIds

protected

Definition at line 45 of file Flat.php.

$_loaded

$_loaded = false

protected

Definition at line 31 of file Flat.php.

$_nodes

$_nodes = []

protected

Definition at line 38 of file Flat.php.

$_storeId

$_storeId

protected

Definition at line 24 of file Flat.php.

$_storeManager

$_storeManager

protected

Definition at line 66 of file Flat.php.

---

The documentation for this class was generated from the following file:

• vendor/magento/module-catalog/Model/ResourceModel/Category/Flat.php