protected function _construct() { parent::_construct(); $this->setTemplate('affiliateplusstatistic/grid.phtml'); $account = Mage::getSingleton('affiliateplus/session')->getAccount(); $collection = Mage::getModel('affiliateplus/action')->getCollection(); if ($this->_getHelper()->getSharingConfig('balance') == 'store') { $collection->addFieldToFilter('store_id', Mage::app()->getStore()->getId()); } $collection->addFieldToFilter('account_id', $account->getId())->addFieldToFilter('type', '1')->setOrder('created_date', 'ASC'); if ($fromDate = $this->getRequest()->getParam('date_from')) { $collection->addFieldToFilter('created_date', array('from' => $this->formatData($fromDate))); } if ($toDate = $this->getRequest()->getParam('date_to')) { $collection->addFieldToFilter('created_date', array('to' => $this->formatData($toDate))); } if ($status_list = $this->getRequest()->getParam('status')) { $status_list = explode('-', $status_list); $collection->addFieldToFilter('status', array('in' => $status_list)); } /*if($this->getRequest()->getParam('period')=='month'){ $collection ->getSelect() ->group('month(created_time)') ->columns(array('total_amount'=>'SUM(total_amount)','commission'=>'SUM(commission)','rowspan'=>'COUNT(transaction_id)')) ; }else if($this->getRequest()->getParam('period')=='year'){ $collection ->getSelect() ->group('year(created_time)') ->columns(array('total_amount'=>'SUM(total_amount)','commission'=>'SUM(commission)','rowspan'=>'COUNT(transaction_id)')) ; } Zend_Debug::dump($collection->toArray());*/ $this->setCollection($collection); }
protected function _construct() { parent::_construct(); $collection = $this->getImpressionCollection(); $this->setCollection($collection); }