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 * Wishlist Report 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_Wishlist_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract 00036 { 00037 protected $wishlistTable; 00038 00039 public function setWishlistTable($value) 00040 { 00041 $this->_wishlistTable = $value; 00042 return $this; 00043 } 00044 00045 public function getWishlistTable() 00046 { 00047 return $this->_wishlistTable; 00048 } 00049 00050 protected function _construct() 00051 { 00052 $this->_init('wishlist/wishlist'); 00053 00054 $this->setWishlistTable(Mage::getSingleton('core/resource')->getTableName('wishlist/wishlist')); 00055 } 00056 00057 public function getWishlistCustomerCount() 00058 { 00059 $collection = Mage::getResourceModel('customer/customer_collection'); 00060 $collection->load(); 00061 00062 $customers = $collection->count(); 00063 00064 $collection = Mage::getResourceModel('customer/customer_collection'); 00065 $collection->getSelect()->from(array('wt' => $this->getWishlistTable())) 00066 ->where('wt.customer_id=e.entity_id') 00067 ->group('wt.wishlist_id'); 00068 $collection->load(); 00069 $count = $collection->count(); 00070 return array(($count*100)/$customers, $count); 00071 } 00072 00073 public function getSharedCount() 00074 { 00075 $collection = Mage::getResourceModel('customer/customer_collection'); 00076 $collection->getSelect()->from(array('wt' => $this->getWishlistTable())) 00077 ->where('wt.customer_id=e.entity_id') 00078 ->where('wt.shared=1') 00079 ->group('wt.wishlist_id'); 00080 $collection->load(); 00081 return $collection->count(); 00082 } 00083 00084 }