Mage_Reports_Model_Mysql4_Event Class Reference

Inheritance diagram for Mage_Reports_Model_Mysql4_Event:

List of all members.

Public Member Functions
	updateCustomerType (Mage_Reports_Model_Event $model, $visitorId, $customerId, $types=array())
	applyLogToCollection (Varien_Data_Collection_Db $collection, $eventTypeId, $eventSubjectId, $subtype, $skipIds=array())
	getCurrentStoreIds (array $predefinedStoreIds=null)
	clean (Mage_Reports_Model_Event $object)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 34 of file Event.php.

---

Member Function Documentation

_construct

(

)

[protected]

Initialize connection

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 40 of file Event.php.

    {
        $this->_init('reports/event', 'event_id');
    }

applyLogToCollection	(	Varien_Data_Collection_Db $	collection,
		$	eventTypeId,
		$	eventSubjectId,
		$	subtype,
		$	skipIds = array()
	)

Add events log to a collection The collection id field is used without corellation, so it must be unique. DESC ordering by event will be added to the collection

Parameters:

	Varien_Data_Collection_Db	$collection
	int	$eventTypeId
	int	$eventSubjectId
	int	$subtype
	array	$skipIds

Definition at line 80 of file Event.php.

    {
        $idFieldName = $collection->getResource()->getIdFieldName();

        $derivedSelect = $this->getReadConnection()->select()
            ->from($this->getTable('reports/event'), array('event_id' => new Zend_Db_Expr('MAX(event_id)'), 'object_id'))
            ->where('event_type_id=?', (int)$eventTypeId)
            ->where('subject_id=?',    (int)$eventSubjectId)
            ->where('subtype=?',       (int)$subtype)
            ->where('store_id IN(?)', $this->getCurrentStoreIds())
            ->group('object_id')
        ;
        if ($skipIds) {
            if (!is_array($skipIds)) {
                $skipIds = array((int)$skipIds);
            }
            $derivedSelect->where('object_id NOT IN(?)', $skipIds);
        }

        $collection->getSelect()
            ->joinInner(array('evt' => new Zend_Db_Expr("({$derivedSelect})")), "`{$idFieldName}`=evt.object_id", array())
            ->order('evt.event_id DESC');
    }

clean

(

Mage_Reports_Model_Event $

object

)

Clean report event table

Parameters:

Mage_Reports_Model_Event

$object

Returns:

Mage_Reports_Model_Mysql4_Event

Definition at line 154 of file Event.php.

    {
        while (true) {
            $select = $this->_getReadAdapter()->select()
                ->from(array('event_table' => $this->getMainTable()), array('event_id'))
                ->joinLeft(
                    array('visitor_table' => $this->getTable('log/visitor')),
                    'event_table.subject_id = visitor_table.visitor_id',
                    array())
                ->where('visitor_table.visitor_id IS NULL')
                ->where('event_table.subtype=?', 1)
                ->limit(1000);
            $eventIds = $this->_getReadAdapter()->fetchCol($select);

            if (!$eventIds) {
                break;
            }

            $this->_getWriteAdapter()->delete(
                $this->getMainTable(),
                $this->_getWriteAdapter()->quoteInto('event_id IN(?)', $eventIds)
            );
        }
        return $this;
    }

getCurrentStoreIds

(

array $

predefinedStoreIds = null

)

Obtain all current store ids, depending on configuration

Parameters:

array

$predefinedStoreIds

Returns:

array

Definition at line 110 of file Event.php.

    {
        $stores = array();
        // get all or specified stores
        if (Mage::app()->getStore()->getId() == 0) {
            if (null !== $predefinedStoreIds) {
                $stores = $predefinedStoreIds;
            }
            else {
                foreach (Mage::app()->getStores() as $store) {
                    $stores[] = $store->getId();
                }
            }
        }
        // get all stores, required by configuration in current store scope
        else {
            switch (Mage::getStoreConfig('catalog/recently_products/scope')) {
                case 'website':
                    $resourceStore = Mage::app()->getStore()->getWebsite()->getStores();
                    break;
                case 'group':
                    $resourceStore = Mage::app()->getStore()->getGroup()->getStores();
                    break;
                default:
                    $resourceStore = array(Mage::app()->getStore());
                    break;
            }

            foreach ($resourceStore as $store) {
                $stores[] = $store->getId();
            }
        }
        foreach ($stores as $key => $store) {
            $stores[$key] = (int)$store;
        }
        return $stores;
    }

updateCustomerType	(	Mage_Reports_Model_Event $	model,
		$	visitorId,
		$	customerId,
		$	types = array()
	)

Update customer type after customer login

Parameters:

	Mage_Reports_Model_Event	$model
	int	$visitorId
	int	$customerId
	array	$types

Returns:

Mage_Reports_Model_Mysql4_Event

Definition at line 54 of file Event.php.

    {
        if ($types) {
            $this->_getWriteAdapter()->update($this->getMainTable(),
                array('subject_id' => $customerId, 'subtype' => 0),
                array(
                    $this->_getWriteAdapter()->quoteInto('subject_id=?', $visitorId),
                    $this->_getWriteAdapter()->quoteInto('subtype=?', 1),
                    $this->_getWriteAdapter()->quoteInto('event_type_id IN(?)', $types)
                )
            );
        }
        return $this;
    }

---

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

• app/code/core/Mage/Reports/Model/Mysql4/Event.php