Mage_Sitemap_Model_Mysql4_Catalog_Product Class Reference

Inheritance diagram for Mage_Sitemap_Model_Mysql4_Catalog_Product:

List of all members.

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

---

Detailed Description

Definition at line 35 of file Product.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 69 of file Product.php.

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

            $this->_attributesCache[$attributeCode] = array(
                'entity_type_id'    => $attribute->getEntityTypeId(),
                'attribute_id'      => $attribute->getId(),
                'table'             => $attribute->getBackend()->getTable(),
                'is_global'         => $attribute->getIsGlobal() == Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
                '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 Product.php.

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

_prepareProduct

(

array $

productRow

)

[protected]

Prepare product

Parameters:

array

$productRow

Returns:

Varien_Object

Definition at line 183 of file Product.php.

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

getCollection

(

$

storeId

)

Get category collection array

Returns:

array

Definition at line 133 of file Product.php.

    {
        $products = array();

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

        if (!$store) {
            return false;
        }

        $urCondions = array(
            'e.entity_id=ur.product_id',
            'ur.category_id IS NULL',
            $this->_getWriteAdapter()->quoteInto('ur.store_id=?', $store->getId()),
            $this->_getWriteAdapter()->quoteInto('ur.is_system=?', 1),
        );
        $this->_select = $this->_getWriteAdapter()->select()
            ->from(array('e' => $this->getMainTable()), array($this->getIdFieldName()))
            ->join(
                array('w' => $this->getTable('catalog/product_website')),
                'e.entity_id=w.product_id',
                array()
            )
            ->where('w.website_id=?', $store->getWebsiteId())
            ->joinLeft(
                array('ur' => $this->getTable('core/url_rewrite')),
                join(' AND ', $urCondions),
                array('url' => 'request_path')
            )
            ;

        $this->_addFilter($storeId, 'visibility', Mage::getSingleton('catalog/product_visibility')->getVisibleInSearchIds(), 'in');
        $this->_addFilter($storeId, 'status', Mage::getSingleton('catalog/product_status')->getVisibleStatusIds(), 'in');

        $query = $this->_getWriteAdapter()->query($this->_select);
        while ($row = $query->fetch()) {
            $product = $this->_prepareProduct($row);
            $products[$product->getId()] = $product;
        }

        return $products;
    }

---

Member Data Documentation

$_attributesCache = array() [protected]

Definition at line 49 of file Product.php.

$_select [protected]

Definition at line 42 of file Product.php.

---

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

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