File code/core/Mage/Adminhtml/Block/Dashboard/Tab/Customers/Most.php

Packages

currencysymbol
MAbout
Mage
- Admin
- Adminhtml
- AdminNotification
- Api
- Api2
- Authorizenet
- Backup
- Bundle
- Captcha
- Catalog
- CatalogIndex
- CatalogInventory
- CatalogRule
- CatalogSearch
- Centinel
- Checkout
- Cms
- Compiler
- Connect
- Contacts
- Core
- Cron
- CurrencySymbol
- Customer
- Dataflow
- Directory
- DirtectPost
- Downloadable
- Eav
- GiftMessage
- GoogleAnalytics
- GoogleBase
- GoogleCheckout
- ImportExport
- Index
- Install
- Log
- Media
- Newsletter
- Oauth
- Page
- PageCache
- Paygate
- Payment
- Paypal
- PaypalUk
- Persistent
- Poll
- ProductAlert
- Rating
- Reports
- Review
- Rss
- Rule
- Sales
- SalesRule
- Sedfriend
- Sendfriend
- Shipping
- Sitemap
- Tag
- Tax
- Usa
- Weee
- Widget
- Wishlist
- XmlConnect
None
Phoenix
- Moneybookers
PHP
Zend
- Date
- Mime
- XmlRpc

Classes

Interfaces

Exceptions

Mage_Adminhtml_Exception

  1: <?php
  2: /**
  3:  * Magento
  4:  *
  5:  * NOTICE OF LICENSE
  6:  *
  7:  * This source file is subject to the Open Software License (OSL 3.0)
  8:  * that is bundled with this package in the file LICENSE.txt.
  9:  * It is also available through the world-wide-web at this URL:
 10:  * http://opensource.org/licenses/osl-3.0.php
 11:  * If you did not receive a copy of the license and are unable to
 12:  * obtain it through the world-wide-web, please send an email
 13:  * to license@magentocommerce.com so we can send you a copy immediately.
 14:  *
 15:  * DISCLAIMER
 16:  *
 17:  * Do not edit or add to this file if you wish to upgrade Magento to newer
 18:  * versions in the future. If you wish to customize Magento for your
 19:  * needs please refer to http://www.magentocommerce.com for more information.
 20:  *
 21:  * @category    Mage
 22:  * @package     Mage_Adminhtml
 23:  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
 24:  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 25:  */
 26: 
 27: /**
 28:  * Adminhtml dashboard most active buyers
 29:  *
 30:  * @category   Mage
 31:  * @package    Mage_Adminhtml
 32:  * @author      Magento Core Team <core@magentocommerce.com>
 33:  */
 34: 
 35: class Mage_Adminhtml_Block_Dashboard_Tab_Customers_Most extends Mage_Adminhtml_Block_Dashboard_Grid
 36: {
 37: 
 38:     public function __construct()
 39:     {
 40:         parent::__construct();
 41:         $this->setId('customersMostGrid');
 42:     }
 43: 
 44:     protected function _prepareCollection()
 45:     {
 46:         $collection = Mage::getResourceModel('reports/order_collection');
 47:         /* @var $collection Mage_Reports_Model_Mysql4_Order_Collection */
 48:         $collection
 49:             ->groupByCustomer()
 50:             ->addOrdersCount()
 51:             ->joinCustomerName();
 52: 
 53:         $storeFilter = 0;
 54:         if ($this->getParam('store')) {
 55:             $collection->addAttributeToFilter('store_id', $this->getParam('store'));
 56:             $storeFilter = 1;
 57:         } else if ($this->getParam('website')){
 58:             $storeIds = Mage::app()->getWebsite($this->getParam('website'))->getStoreIds();
 59:             $collection->addAttributeToFilter('store_id', array('in' => $storeIds));
 60:         } else if ($this->getParam('group')){
 61:             $storeIds = Mage::app()->getGroup($this->getParam('group'))->getStoreIds();
 62:             $collection->addAttributeToFilter('store_id', array('in' => $storeIds));
 63:         }
 64: 
 65:         $collection->addSumAvgTotals($storeFilter)
 66:             ->orderByTotalAmount();
 67: 
 68:         $this->setCollection($collection);
 69: 
 70:         return parent::_prepareCollection();
 71:     }
 72: 
 73:     protected function _prepareColumns()
 74:     {
 75:         $this->addColumn('name', array(
 76:             'header'    => $this->__('Customer Name'),
 77:             'sortable'  => false,
 78:             'index'     => 'name'
 79:         ));
 80: 
 81:         $this->addColumn('orders_count', array(
 82:             'header'    => $this->__('Number of Orders'),
 83:             'sortable'  => false,
 84:             'index'     => 'orders_count',
 85:             'type'      => 'number'
 86:         ));
 87: 
 88:         $baseCurrencyCode = (string) Mage::app()->getStore((int)$this->getParam('store'))->getBaseCurrencyCode();
 89: 
 90:         $this->addColumn('orders_avg_amount', array(
 91:             'header'    => $this->__('Average Order Amount'),
 92:             'align'     => 'right',
 93:             'sortable'  => false,
 94:             'type'      => 'currency',
 95:             'currency_code'  => $baseCurrencyCode,
 96:             'index'     => 'orders_avg_amount'
 97:         ));
 98: 
 99:         $this->addColumn('orders_sum_amount', array(
100:             'header'    => $this->__('Total Order Amount'),
101:             'align'     => 'right',
102:             'sortable'  => false,
103:             'type'      => 'currency',
104:             'currency_code'  => $baseCurrencyCode,
105:             'index'     => 'orders_sum_amount'
106:         ));
107: 
108:         $this->setFilterVisibility(false);
109:         $this->setPagerVisibility(false);
110: 
111:         return parent::_prepareColumns();
112:     }
113: 
114:     public function getRowUrl($row)
115:     {
116:         return $this->getUrl('*/customer/edit', array('id'=>$row->getCustomerId()));
117:     }
118: }
119: