Mage_Log_Model_Mysql4_Visitor_Online Class Reference

Inheritance diagram for Mage_Log_Model_Mysql4_Visitor_Online:

List of all members.

Public Member Functions
	prepare (Mage_Log_Model_Visitor_Online $object)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 35 of file Online.php.

---

Member Function Documentation

_construct

(

)

[protected]

Initialize connection and define resource

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 41 of file Online.php.

    {
        $this->_init('log/visitor_online', 'visitor_id');
    }

prepare

(

Mage_Log_Model_Visitor_Online $

object

)

Prepare online visitors for collection

Parameters:

Mage_Log_Model_Visitor_Online

$object

Returns:

Mage_Log_Model_Mysql4_Visitor_Online

Definition at line 52 of file Online.php.

    {
        if (($object->getUpdateFrequency() + $object->getPrepareAt()) > time()) {
            return $this;
        }

        $this->_getWriteAdapter()->beginTransaction();
        $this->_getWriteAdapter()->truncate($this->getMainTable());

        $visitors = array();
        $lastUrls = array();

        // retrieve online visitors general data
        $whereCond = sprintf('last_visit_at >= (? - INTERVAL %d MINUTE)',
            $object->getOnlineInterval());
        $select = $this->_getReadAdapter()->select()
            ->from(
                $this->getTable('log/visitor'),
                array('visitor_id', 'first_visit_at', 'last_visit_at', 'last_url_id'))
            ->where($whereCond, now());

        $query = $this->_getReadAdapter()->query($select);
        while ($row = $query->fetch()) {
            $visitors[$row['visitor_id']] = $row;
            $lastUrls[$row['last_url_id']] = $row['visitor_id'];
            $visitors[$row['visitor_id']]['visitor_type'] = Mage_Log_Model_Visitor::VISITOR_TYPE_VISITOR;
            $visitors[$row['visitor_id']]['customer_id']  = null;
        }

        if (!$visitors) {
            $this->commit();
            return $this;
        }

        // retrieve visitor remote addr
        $select = $this->_getReadAdapter()->select()
            ->from(
                $this->getTable('log/visitor_info'),
                array('visitor_id', 'remote_addr'))
            ->where('visitor_id IN(?)', array_keys($visitors));
        $query = $this->_getReadAdapter()->query($select);
        while ($row = $query->fetch()) {
            $visitors[$row['visitor_id']]['remote_addr'] = $row['remote_addr'];
        }

        // retrieve visitor last URLs
        $select = $this->_getReadAdapter()->select()
            ->from(
                $this->getTable('log/url_info_table'),
                array('url_id', 'url'))
            ->where('url_id IN(?)', array_keys($lastUrls));
        $query = $this->_getReadAdapter()->query($select);
        while ($row = $query->fetch()) {
            $visitorId = $lastUrls[$row['url_id']];
            $visitors[$visitorId]['last_url'] = $row['url'];
        }

        // retrieve customers
        $select = $this->_getReadAdapter()->select()
            ->from(
                $this->getTable('log/customer'),
                array('visitor_id', 'customer_id'))
            ->where('visitor_id IN(?)', array_keys($visitors));
        $query = $this->_getReadAdapter()->query($select);
        while ($row = $query->fetch()) {
            $visitors[$row['visitor_id']]['visitor_type'] = Mage_Log_Model_Visitor::VISITOR_TYPE_CUSTOMER;
            $visitors[$row['visitor_id']]['customer_id']  = $row['customer_id'];
        }

        foreach ($visitors as $visitorData) {
            unset($visitorData['last_url_id']);
            $this->_getWriteAdapter()->insert($this->getMainTable(), $visitorData);
        }

        $this->_getWriteAdapter()->commit();

        $object->setPrepareAt();

        return $this;
    }

---

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

• app/code/core/Mage/Log/Model/Mysql4/Visitor/Online.php