Mage_Reports_Model_Mysql4_Product_Downloads_Collection Class Reference

Inheritance diagram for Mage_Reports_Model_Mysql4_Product_Downloads_Collection:

List of all members.

Public Member Functions
	addSummary ()
	setOrder ($attribute, $dir='desc')
	addFieldToFilter ($field, $condition=null)
Protected Attributes
	$_idFieldName = 'link_id'

---

Detailed Description

Definition at line 35 of file Collection.php.

---

Member Function Documentation

addFieldToFilter	(	$	field,
		$	condition = null
	)

Add filtering

Returns:

Mage_Reports_Model_Mysql4_Product_Downloads_Collection

Reimplemented from Mage_Eav_Model_Entity_Collection_Abstract.

Definition at line 91 of file Collection.php.

    {
        if ($field == 'link_title') {
            $conditionSql = $this->_getConditionSql('l.title', $condition);
            $this->getSelect()->where($conditionSql);
        } else {
            parent::addFieldToFilter($field, $condition);
        }
        return $this;
    }

addSummary

(

)

Add downloads summary grouping by product

Returns:

Mage_Reports_Model_Mysql4_Product_Downloads_Collection

Definition at line 44 of file Collection.php.

    {
        $this->getSelect()
            ->joinInner(
                array('d' => $this->getTable('downloadable/link_purchased_item')),
                'e.entity_id=d.product_id',
                array(
                    'purchases' => 'd.number_of_downloads_bought',
                    'downloads' => 'd.number_of_downloads_used'
                )
            )
            ->joinInner(
                array('l' => $this->getTable('downloadable/link_title')),
                'd.link_id=l.link_id',
                array('l.link_id')
            )
            ->joinLeft(
                array('l_store' => $this->getTable('downloadable/link_title')),
                $this->getConnection()->quoteInto('l.link_id=l_store.link_id AND l_store.store_id=?',$this->getStoreId()),
                array('link_title' => 'IFNULL(l_store.title, l.title)')
            )
            ->where('d.number_of_downloads_bought>0 OR d.number_of_downloads_used>0')
            ->group('d.link_id');

        return $this;
    }

setOrder	(	$	attribute,
		$	dir = 'desc'
	)

Add sorting

Returns:

Mage_Reports_Model_Mysql4_Product_Downloads_Collection

Reimplemented from Mage_Eav_Model_Entity_Collection_Abstract.

Definition at line 76 of file Collection.php.

    {
        if ($attribute == 'purchases' || $attribute == 'downloads' || $attribute == 'link_title') {
            $this->getSelect()->order($attribute . ' ' . $dir);
        } else {
            parent::setOrder($attribute, $dir);
        }
        return $this;
    }

---

Member Data Documentation

$_idFieldName = 'link_id' [protected]

Reimplemented from Varien_Data_Collection_Db.

Definition at line 37 of file Collection.php.

---

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

• app/code/core/Mage/Reports/Model/Mysql4/Product/Downloads/Collection.php