Mage_Sitemap_Model_Mysql4_Catalog_Category Class Reference

Inheritance diagram for Mage_Sitemap_Model_Mysql4_Catalog_Category:

List of all members.

Public Member Functions
	getCollection ($storeId)
Protected Member Functions
	_construct ()
	_prepareCategory (array $categoryRow)
	_addFilter ($storeId, $attributeCode, $value, $type= '=')
Protected Attributes
	$_select
	$_attributesCache = array()

---

Detailed Description

Definition at line 35 of file Category.php.

---

Member Function Documentation

_addFilter	(	$	storeId,
		$	attributeCode,
		$	value,
		$	type = '='
	)			[protected]

Add attribute to filter

Parameters:

	int	$storeId
	string	$attributeCode
	mixed	$value
	string	$type

Returns:

Zend_Db_Select

Definition at line 135 of file Category.php.

    {
        if (!isset($this->_attributesCache[$attributeCode])) {
            $attribute = Mage::getSingleton('catalog/category')->getResource()->getAttribute($attributeCode);

            $this->_attributesCache[$attributeCode] = array(
                'entity_type_id'    => $attribute->getEntityTypeId(),
                'attribute_id'      => $attribute->getId(),
                'table'             => $attribute->getBackend()->getTable(),
                'is_global'         => $attribute->getIsGlobal(),
                'backend_type'      => $attribute->getBackendType()
            );
        }

        $attribute = $this->_attributesCache[$attributeCode];

        if (!$this->_select instanceof Zend_Db_Select) {
            return false;
        }

        switch ($type) {
            case '=':
                $conditionRule = '=?';
                break;
            case 'in':
                $conditionRule = ' IN(?)';
                break;
            default:
                return false;
                break;
        }

        if ($attribute['backend_type'] == 'static') {
            $this->_select->where('e.' . $attributeCode . $conditionRule, $value);
        }
        else {
            if ($attribute['is_global']) {

            }
            else {
                $this->_select->join(
                    array('t1_'.$attributeCode => $attribute['table']),
                    'e.entity_id=t1_'.$attributeCode.'.entity_id AND t1_'.$attributeCode.'.store_id=0',
                    array()
                )
                ->joinLeft(
                    array('t2_'.$attributeCode => $attribute['table']),
                    $this->_getWriteAdapter()->quoteInto('t1_'.$attributeCode.'.entity_id = t2_'.$attributeCode.'.entity_id AND t1_'.$attributeCode.'.attribute_id = t2_'.$attributeCode.'.attribute_id AND t2_'.$attributeCode.'.store_id=?', $storeId),
                    array()
                )
                ->where('t1_'.$attributeCode.'.attribute_id=?', $attribute['attribute_id'])
                ->where('IFNULL(t2_'.$attributeCode.'.value, t1_'.$attributeCode.'.value)'.$conditionRule, $value);
            }
        }

        return $this->_select;
    }

_construct

(

)

[protected]

Init resource model (catalog/category)

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 54 of file Category.php.

    {
        $this->_init('catalog/category', 'entity_id');
    }

_prepareCategory

(

array $

categoryRow

)

[protected]

Prepare category

Parameters:

array

$categoryRow

Returns:

Varien_Object

Definition at line 116 of file Category.php.

    {
        $category = new Varien_Object();
        $category->setId($categoryRow[$this->getIdFieldName()]);
        $categoryUrl = !empty($categoryRow['url']) ? $categoryRow['url'] : 'catalog/category/view/id/' . $category->getId();
        $category->setUrl($categoryUrl);
        return $category;
    }

getCollection

(

$

storeId

)

Get category collection array

Returns:

array

Definition at line 64 of file Category.php.

    {
        $categories = array();

        $store = Mage::app()->getStore($storeId);
        /* @var $store Mage_Core_Model_Store */

        if (!$store) {
            return false;
        }

        $this->_select = $this->_getWriteAdapter()->select()
            ->from($this->getMainTable())
            ->where($this->getIdFieldName() . '=?', $store->getRootCategoryId());
        $categoryRow = $this->_getWriteAdapter()->fetchRow($this->_select);

        if (!$categoryRow) {
            return false;
        }

        $urConditions = array(
            'e.entity_id=ur.category_id',
            $this->_getWriteAdapter()->quoteInto('ur.store_id=?', $store->getId()),
            'ur.product_id IS NULL',
            $this->_getWriteAdapter()->quoteInto('ur.is_system=?', 1),
        );
        $this->_select = $this->_getWriteAdapter()->select()
            ->from(array('e' => $this->getMainTable()), array($this->getIdFieldName()))
            ->joinLeft(
                array('ur' => $this->getTable('core/url_rewrite')),
                join(' AND ', $urConditions),
                array('url'=>'request_path')
            )
            ->where('e.path LIKE ?', $categoryRow['path'] . '/%');

        $this->_addFilter($storeId, 'is_active', 1);

        $query = $this->_getWriteAdapter()->query($this->_select);
        while ($row = $query->fetch()) {
            $category = $this->_prepareCategory($row);
            $categories[$category->getId()] = $category;
        }

        return $categories;
    }

---

Member Data Documentation

$_attributesCache = array() [protected]

Definition at line 49 of file Category.php.

$_select [protected]

Definition at line 42 of file Category.php.

---

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

• app/code/core/Mage/Sitemap/Model/Mysql4/Catalog/Category.php