*/ class Mage_Adminhtml_Block_Dashboard_Searches_Last extends Mage_Adminhtml_Block_Dashboard_Grid { protected $_collection; public function __construct() { parent::__construct(); $this->setId('lastSearchGrid'); } protected function _prepareCollection() { if (!Mage::helper('core')->isModuleEnabled('Mage_CatalogSearch')) { return parent::_prepareCollection(); } $this->_collection = Mage::getModel('catalogsearch/query') ->getResourceCollection(); $this->_collection->setRecentQueryFilter(); if ($this->getRequest()->getParam('store')) { $this->_collection->addFieldToFilter('store_id', $this->getRequest()->getParam('store')); } else if ($this->getRequest()->getParam('website')){ $storeIds = Mage::app()->getWebsite($this->getRequest()->getParam('website'))->getStoreIds(); $this->_collection->addFieldToFilter('store_id', array('in' => $storeIds)); } else if ($this->getRequest()->getParam('group')){ $storeIds = Mage::app()->getGroup($this->getRequest()->getParam('group'))->getStoreIds(); $this->_collection->addFieldToFilter('store_id', array('in' => $storeIds)); } $this->setCollection($this->_collection); return parent::_prepareCollection(); } protected function _prepareColumns() { $this->addColumn('search_query', array( 'header' => $this->__('Search Term'), 'sortable' => false, 'index' => 'query_text', 'renderer' => 'adminhtml/dashboard_searches_renderer_searchquery', )); $this->addColumn('num_results', array( 'header' => $this->__('Results'), 'sortable' => false, 'index' => 'num_results', 'type' => 'number' )); $this->addColumn('popularity', array( 'header' => $this->__('Number of Uses'), 'sortable' => false, 'index' => 'popularity', 'type' => 'number' )); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); } public function getRowUrl($row) { return $this->getUrl('*/catalog_search/edit', array('id'=>$row->getId())); } }