Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Compare_Item Class Reference

Inheritance diagram for Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Compare_Item:

List of all members.

Public Member Functions
	loadByProduct (Mage_Catalog_Model_Product_Compare_Item $object, $product)
	getCount ($customerId, $visitorId)
	clean (Mage_Catalog_Model_Product_Compare_Item $object)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 35 of file Item.php.

---

Member Function Documentation

_construct

(

)

[protected]

Initialize connection

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 41 of file Item.php.

    {
        $this->_init('catalog/compare_item', 'catalog_compare_item_id');
    }

clean

(

Mage_Catalog_Model_Product_Compare_Item $

object

)

Clean compare table

Parameters:

Mage_Catalog_Model_Product_Compare_Item

$object

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Compare_Item

Definition at line 105 of file Item.php.

    {
        while (true) {
            $select = $this->_getReadAdapter()->select()
                ->from(array('compare_table' => $this->getMainTable()), array('catalog_compare_item_id'))
                ->joinLeft(
                    array('visitor_table' => $this->getTable('log/visitor')),
                    '`visitor_table`.`visitor_id`=`compare_table`.`visitor_id`',
                    array())
                ->where('compare_table.visitor_id>?',0)
                ->where('`visitor_table`.`visitor_id` IS NULL')
                ->limit(1000);
            $itemIds = $this->_getReadAdapter()->fetchCol($select);

            if (!$itemIds) {
                break;
            }

            $this->_getWriteAdapter()->delete(
                $this->getMainTable(),
                $this->_getWriteAdapter()->quoteInto('catalog_compare_item_id IN(?)', $itemIds)
            );
        }

        return $this;
    }

getCount	(	$	customerId,
		$	visitorId
	)

Resource retrieve count compare items

Parameters:

	int	$customerId
	int	$visitorId

Returns:

int

Definition at line 89 of file Item.php.

    {
        $select = $this->_getReadAdapter()->select()->from($this->getMainTable(), 'COUNT(*)')
            ->where('visitor_id=?',  $visitorId);
        if ($customerId) {
            $select->where('customer_id=?', $customerId);
        }
        return $this->_getReadAdapter()->fetchOne($select);
    }

loadByProduct	(	Mage_Catalog_Model_Product_Compare_Item $	object,
		$	product
	)

Load object by product

Parameters:

	Mage_Core_Model_Abstract	$object
	mixed	$product

Returns:

bool

Definition at line 53 of file Item.php.

    {
        $read = $this->_getReadAdapter();
        if ($product instanceof Mage_Catalog_Model_Product) {
            $productId = $product->getId();
        }
        else {
            $productId = (int) $product;
        }

        $select = $read->select()->from($this->getMainTable())
            ->where('product_id=?',  $productId)
            ->where('visitor_id=?',  $object->getVisitorId());
        if ($object->getCustomerId()) {
            $select->where('customer_id=?', $object->getCustomerId());
        }

        $data = $read->fetchRow($select);

        if (!$data) {
            return false;
        }

        $object->setData($data);

        $this->_afterLoad($object);
        return true;
    }

---

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

• app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Compare/Item.php