Algolia_Algoliasearch_Helper_Entity_Helper::getCategories PHP Метод

    public function getCategories()
    {
        if (is_null(self::$_activeCategories)) {
            self::$_activeCategories = array();
            /** @var Mage_Catalog_Model_Resource_Category $resource */
            $resource = Mage::getResourceModel('catalog/category');
            if ($attribute = $resource->getAttribute('is_active')) {
                /** @var Mage_Core_Model_Resource $coreResource */
                $coreResource = Mage::getSingleton('core/resource');
                $connection = $coreResource->getConnection('core_read');
                $select = $connection->select()->from(array('backend' => $attribute->getBackendTable()), array('key' => new Zend_Db_Expr("CONCAT(backend.store_id, '-', backend.entity_id)"), 'category.path', 'backend.value'))->join(array('category' => $resource->getTable('catalog/category')), 'backend.entity_id = category.entity_id', array())->where('backend.entity_type_id = ?', $attribute->getEntityTypeId())->where('backend.attribute_id = ?', $attribute->getAttributeId())->order('backend.store_id')->order('backend.entity_id');
                self::$_activeCategories = $connection->fetchAssoc($select);
            }
        }
        return self::$_activeCategories;
    }