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 newsletter subscribers grid block
 29:  *
 30:  * @category   Mage
 31:  * @package    Mage_Adminhtml
 32:  * @author      Magento Core Team <core@magentocommerce.com>
 33:  */
 34: class Mage_Adminhtml_Block_Newsletter_Subscriber_Grid extends Mage_Adminhtml_Block_Widget_Grid
 35: {
 36:     /**
 37:      * Constructor
 38:      *
 39:      * Set main configuration of grid
 40:      */
 41:     public function __construct()
 42:     {
 43:         parent::__construct();
 44:         $this->setId('subscriberGrid');
 45:         $this->setUseAjax(true);
 46:         $this->setDefaultSort('subscriber_id', 'desc');
 47:     }
 48: 
 49:     /**
 50:      * Prepare collection for grid
 51:      *
 52:      * @return Mage_Adminhtml_Block_Widget_Grid
 53:      */
 54:     protected function _prepareCollection()
 55:     {
 56:         $collection = Mage::getResourceSingleton('newsletter/subscriber_collection');
 57:         /* @var $collection Mage_Newsletter_Model_Mysql4_Subscriber_Collection */
 58:         $collection
 59:             ->showCustomerInfo(true)
 60:             ->addSubscriberTypeField()
 61:             ->showStoreInfo();
 62: 
 63:         if($this->getRequest()->getParam('queue', false)) {
 64:             $collection->useQueue(Mage::getModel('newsletter/queue')
 65:                 ->load($this->getRequest()->getParam('queue')));
 66:         }
 67: 
 68:         $this->setCollection($collection);
 69: 
 70:         return parent::_prepareCollection();
 71:     }
 72: 
 73:     protected function _prepareColumns()
 74:     {
 75: 
 76:         $this->addColumn('subscriber_id', array(
 77:             'header'    => Mage::helper('newsletter')->__('ID'),
 78:             'index'     => 'subscriber_id'
 79:         ));
 80: 
 81:         $this->addColumn('email', array(
 82:             'header'    => Mage::helper('newsletter')->__('Email'),
 83:             'index'     => 'subscriber_email'
 84:         ));
 85: 
 86:         $this->addColumn('type', array(
 87:             'header'    => Mage::helper('newsletter')->__('Type'),
 88:             'index'     => 'type',
 89:             'type'      => 'options',
 90:             'options'   => array(
 91:                 1  => Mage::helper('newsletter')->__('Guest'),
 92:                 2  => Mage::helper('newsletter')->__('Customer')
 93:             )
 94:         ));
 95: 
 96:         $this->addColumn('firstname', array(
 97:             'header'    => Mage::helper('newsletter')->__('Customer First Name'),
 98:             'index'     => 'customer_firstname',
 99:             'default'   =>    '----'
100:         ));
101: 
102:         $this->addColumn('lastname', array(
103:             'header'    => Mage::helper('newsletter')->__('Customer Last Name'),
104:             'index'     => 'customer_lastname',
105:             'default'   =>    '----'
106:         ));
107: 
108:         $this->addColumn('status', array(
109:             'header'    => Mage::helper('newsletter')->__('Status'),
110:             'index'     => 'subscriber_status',
111:             'type'      => 'options',
112:             'options'   => array(
113:                 Mage_Newsletter_Model_Subscriber::STATUS_NOT_ACTIVE   => Mage::helper('newsletter')->__('Not Activated'),
114:                 Mage_Newsletter_Model_Subscriber::STATUS_SUBSCRIBED   => Mage::helper('newsletter')->__('Subscribed'),
115:                 Mage_Newsletter_Model_Subscriber::STATUS_UNSUBSCRIBED => Mage::helper('newsletter')->__('Unsubscribed'),
116:                 Mage_Newsletter_Model_Subscriber::STATUS_UNCONFIRMED => Mage::helper('newsletter')->__('Unconfirmed'),
117:             )
118:         ));
119: 
120:         $this->addColumn('website', array(
121:             'header'    => Mage::helper('newsletter')->__('Website'),
122:             'index'     => 'website_id',
123:             'type'      => 'options',
124:             'options'   => $this->_getWebsiteOptions()
125:         ));
126: 
127:         $this->addColumn('group', array(
128:             'header'    => Mage::helper('newsletter')->__('Store'),
129:             'index'     => 'group_id',
130:             'type'      => 'options',
131:             'options'   => $this->_getStoreGroupOptions()
132:         ));
133: 
134:         $this->addColumn('store', array(
135:             'header'    => Mage::helper('newsletter')->__('Store View'),
136:             'index'     => 'store_id',
137:             'type'      => 'options',
138:             'options'   => $this->_getStoreOptions()
139:         ));
140: 
141:         $this->addExportType('*/*/exportCsv', Mage::helper('customer')->__('CSV'));
142:         $this->addExportType('*/*/exportXml', Mage::helper('customer')->__('Excel XML'));
143:         return parent::_prepareColumns();
144:     }
145: 
146:     /**
147:      * Convert OptionsValue array to Options array
148:      *
149:      * @param array $optionsArray
150:      * @return array
151:      */
152:     protected function _getOptions($optionsArray)
153:     {
154:         $options = array();
155:         foreach ($optionsArray as $option) {
156:             $options[$option['value']] = $option['label'];
157:         }
158:         return $options;
159:     }
160: 
161:     /**
162:      * Retrieve Website Options array
163:      *
164:      * @return array
165:      */
166:     protected function _getWebsiteOptions()
167:     {
168:         return Mage::getModel('adminhtml/system_store')->getWebsiteOptionHash();
169:     }
170: 
171:     /**
172:      * Retrieve Store Group Options array
173:      *
174:      * @return array
175:      */
176:     protected function _getStoreGroupOptions()
177:     {
178:         return Mage::getModel('adminhtml/system_store')->getStoreGroupOptionHash();
179:     }
180: 
181:     /**
182:      * Retrieve Store Options array
183:      *
184:      * @return array
185:      */
186:     protected function _getStoreOptions()
187:     {
188:         return Mage::getModel('adminhtml/system_store')->getStoreOptionHash();
189:     }
190: 
191:     protected function _prepareMassaction()
192:     {
193:         $this->setMassactionIdField('subscriber_id');
194:         $this->getMassactionBlock()->setFormFieldName('subscriber');
195: 
196:         $this->getMassactionBlock()->addItem('unsubscribe', array(
197:              'label'        => Mage::helper('newsletter')->__('Unsubscribe'),
198:              'url'          => $this->getUrl('*/*/massUnsubscribe')
199:         ));
200: 
201:         $this->getMassactionBlock()->addItem('delete', array(
202:              'label'        => Mage::helper('newsletter')->__('Delete'),
203:              'url'          => $this->getUrl('*/*/massDelete')
204:         ));
205: 
206:         return $this;
207:     }
208: }
209: