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);
}
