1: <?php
2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25:
26:
27: 28: 29: 30: 31: 32: 33:
34: class Mage_Adminhtml_Block_Report_Tag_Customer_Detail_Grid extends Mage_Adminhtml_Block_Widget_Grid
35: {
36:
37: public function __construct()
38: {
39: parent::__construct();
40: $this->setId('customers_grid');
41: }
42:
43: protected function _prepareCollection()
44: {
45: $collection = Mage::getModel('tag/tag')
46: ->getEntityCollection()
47: ->joinAttribute('original_name', 'catalog_product/name', 'entity_id')
48: ->addCustomerFilter($this->getRequest()->getParam('id'))
49: ->addStatusFilter(Mage_Tag_Model_Tag::STATUS_APPROVED)
50: ->setDescOrder('DESC')
51: ->addStoresVisibility()
52: ->setActiveFilter()
53: ->addGroupByTag()
54: ->setRelationId();
55:
56: $this->setCollection($collection);
57:
58: return parent::_prepareCollection();
59: }
60:
61: protected function _prepareColumns()
62: {
63: $this->addColumn('name', array(
64: 'header' =>Mage::helper('reports')->__('Product Name'),
65: 'sortable' => false,
66: 'index' =>'original_name'
67: ));
68:
69: $this->addColumn('tag_name', array(
70: 'header' =>Mage::helper('reports')->__('Tag Name'),
71: 'sortable' => false,
72: 'index' =>'tag_name'
73: ));
74:
75: if (!Mage::app()->isSingleStoreMode()) {
76: $this->addColumn('visible', array(
77: 'header' => Mage::helper('reports')->__('Visible In'),
78: 'sortable' => false,
79: 'index' => 'stores',
80: 'type' => 'store',
81: 'store_view'=> true
82: ));
83:
84: $this->addColumn('added_in', array(
85: 'header' =>Mage::helper('reports')->__('Submitted In'),
86: 'sortable' => false,
87: 'index' =>'store_id',
88: 'type' =>'store',
89: 'store_view'=>true
90: ));
91: }
92:
93: $this->addColumn('created_at', array(
94: 'header' =>Mage::helper('reports')->__('Submitted On'),
95: 'sortable' => false,
96: 'width' => '140px',
97: 'type' => 'datetime',
98: 'index' => 'created_at'
99: ));
100:
101: $this->setFilterVisibility(false);
102:
103: $this->addExportType('*/*/exportCustomerDetailCsv', Mage::helper('reports')->__('CSV'));
104: $this->addExportType('*/*/exportCustomerDetailExcel', Mage::helper('reports')->__('Excel XML'));
105:
106: return parent::_prepareColumns();
107: }
108: }
109: