00001 <?php 00002 /** 00003 * Magento 00004 * 00005 * NOTICE OF LICENSE 00006 * 00007 * This source file is subject to the Open Software License (OSL 3.0) 00008 * that is bundled with this package in the file LICENSE.txt. 00009 * It is also available through the world-wide-web at this URL: 00010 * http://opensource.org/licenses/osl-3.0.php 00011 * If you did not receive a copy of the license and are unable to 00012 * obtain it through the world-wide-web, please send an email 00013 * to license@magentocommerce.com so we can send you a copy immediately. 00014 * 00015 * DISCLAIMER 00016 * 00017 * Do not edit or add to this file if you wish to upgrade Magento to newer 00018 * versions in the future. If you wish to customize Magento for your 00019 * needs please refer to http://www.magentocommerce.com for more information. 00020 * 00021 * @category Mage 00022 * @package Mage_Reports 00023 * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com) 00024 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 00025 */ 00026 00027 /** 00028 * Report event collection 00029 * 00030 * @category Mage 00031 * @package Mage_Reports 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 00035 class Mage_Reports_Model_Mysql4_Event_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract 00036 { 00037 /** 00038 * Store Ids 00039 * 00040 * @var array 00041 */ 00042 protected $_storeIds; 00043 00044 protected function _construct() 00045 { 00046 $this->_init('reports/event'); 00047 } 00048 00049 /** 00050 * Add store ids filter 00051 * 00052 * @param array $storeIds 00053 * @return Mage_Reports_Model_Mysql4_Event_Collection 00054 */ 00055 public function addStoreFilter(array $storeIds) 00056 { 00057 $this->_storeIds = $storeIds; 00058 return $this; 00059 } 00060 00061 /** 00062 * Add recently filter 00063 * 00064 * @param int $typeId 00065 * @param int $subjectId 00066 * @param int $subtype 00067 * @param int|array $ignore 00068 * @param int $limit 00069 * @return Mage_Reports_Model_Mysql4_Event_Collection 00070 */ 00071 public function addRecentlyFiler($typeId, $subjectId, $subtype = 0, $ignore = null, $limit = 15) 00072 { 00073 $stores = $this->getResource()->getCurrentStoreIds($this->_storeIds); 00074 $this->_select 00075 ->where('event_type_id=?', $typeId) 00076 ->where('subject_id=?', $subjectId) 00077 ->where('subtype=?', $subtype) 00078 ->where('store_id IN(?)', $stores); 00079 if ($ignore) { 00080 if (is_array($ignore)) { 00081 $this->_select->where('object_id NOT IN(?)', $ignore); 00082 } 00083 else { 00084 $this->_select->where('object_id<>?', $ignore); 00085 } 00086 } 00087 $this->_select->group('object_id') 00088 ->limit($limit); 00089 return $this; 00090 } 00091 }