File code/core/Mage/Adminhtml/Block/Report/Customer/Orders/Grid.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 customers by orders report grid block
29:  *
30:  * @category   Mage
31:  * @package    Mage_Adminhtml
32:  * @author      Magento Core Team <core@magentocommerce.com>
33:  */
34: class Mage_Adminhtml_Block_Report_Customer_Orders_Grid extends Mage_Adminhtml_Block_Report_Grid
35: {
36: 
37:     public function __construct()
38:     {
39:         parent::__construct();
40:         $this->setId('gridOrdersCustomer');
41:     }
42: 
43:     protected function _prepareCollection()
44:     {
45:         parent::_prepareCollection();
46:         $this->getCollection()->initReport('reports/customer_orders_collection');
47:     }
48: 
49:     protected function _prepareColumns()
50:     {
51:         $this->addColumn('name', array(
52:             'header'    => $this->__('Customer Name'),
53:             'sortable'  => false,
54:             'index'     => 'name'
55:         ));
56: 
57:         $this->addColumn('orders_count', array(
58:             'header'    => $this->__('Number of Orders'),
59:             'width'     => '100px',
60:             'sortable'  => false,
61:             'index'     => 'orders_count',
62:             'total'     => 'sum',
63:             'type'      => 'number'
64:         ));
65: 
66:         $baseCurrencyCode = $this->getCurrentCurrencyCode();
67: 
68:         $this->addColumn('orders_avg_amount', array(
69:             'header'    => $this->__('Average Order Amount'),
70:             'width'     => '200px',
71:             'align'     => 'right',
72:             'sortable'  => false,
73:             'type'      => 'currency',
74:             'currency_code'  => $baseCurrencyCode,
75:             'index'     => 'orders_avg_amount',
76:             'total'     => 'orders_sum_amount/orders_count',
77:             'renderer'  =>'adminhtml/report_grid_column_renderer_currency'
78:         ));
79: 
80:         $this->addColumn('orders_sum_amount', array(
81:             'header'    => $this->__('Total Order Amount'),
82:             'width'     => '200px',
83:             'align'     => 'right',
84:             'sortable'  => false,
85:             'type'      => 'currency',
86:             'currency_code'  => $baseCurrencyCode,
87:             'index'     => 'orders_sum_amount',
88:             'total'     => 'sum',
89:             'renderer'  => 'adminhtml/report_grid_column_renderer_currency',
90:         ));
91: 
92:         $this->addExportType('*/*/exportOrdersCsv', Mage::helper('reports')->__('CSV'));
93:         $this->addExportType('*/*/exportOrdersExcel', Mage::helper('reports')->__('Excel XML'));
94: 
95:         return parent::_prepareColumns();
96:     }
97: 
98: }
99: