public function getSelectCountSql()
{
/* @var $countSelect Varien_Db_Select */
$countSelect = parent::getSelectCountSql();
$countSelect->resetJoinLeft();
$countSelect->reset(Zend_Db_Select::GROUP);
// add this to reset the GROUP
return $countSelect;
}
/**
* Returns order collection with some filters
* @return Mage_Sales_Order_Collection
*/
public function getCustomerOrders()
{
if (!is_null($this->_customerOrders)) {
return $this->_customerOrders;
}
if ($this->getGuestMode()) {
$this->_customerOrders = array($this->_getSession()->getData('awrma_guest_order'));
} else {
$this->_customerOrders = Mage::getResourceModel('sales/order_collection')->addFieldToFilter('customer_id', $this->_getSession()->getCustomer()->getId())->addFieldToFilter('state', array('in' => array('complete')))->setOrder('created_at', 'desc');
$this->_customerOrders->getSelect()->where('updated_at > DATE_SUB(NOW(), INTERVAL ? DAY)', Mage::helper('awrma/config')->getDaysAfter());
$this->_customerOrders->load();
}
return $this->_customerOrders;
}
/**
* Render related orders grid information
*/
public function prepareRelatedOrdersFrontendGrid()
{
$this->_prepareRelatedOrders(array('increment_id', 'created_at', 'customer_firstname', 'customer_middlename', 'customer_lastname', 'base_grand_total', 'status'));
$this->_relatedOrders->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()));
$pager = $this->getLayout()->createBlock('page/html_pager')->setCollection($this->_relatedOrders)->setIsOutputRequired(false);
$this->setChild('pager', $pager);
$this->setGridColumns(array(new Varien_Object(array('index' => 'increment_id', 'title' => $this->__('Order #'), 'is_nobr' => true, 'width' => 1)), new Varien_Object(array('index' => 'created_at', 'title' => $this->__('Date'), 'is_nobr' => true, 'width' => 1)), new Varien_Object(array('index' => 'customer_name', 'title' => $this->__('Customer Name'))), new Varien_Object(array('index' => 'base_grand_total', 'title' => $this->__('Order Total'), 'is_nobr' => true, 'width' => 1, 'is_amount' => true)), new Varien_Object(array('index' => 'status', 'title' => $this->__('Order Status'), 'is_nobr' => true, 'width' => 1))));
$orders = array();
foreach ($this->_relatedOrders as $order) {
$orders[] = new Varien_Object(array('increment_id' => $order->getIncrementId(), 'created_at' => $this->formatDate($order->getCreatedAt()), 'customer_name' => $order->getCustomerName(), 'base_grand_total' => Mage::helper('core')->formatCurrency($order->getBaseGrandTotal(), false), 'status' => $order->getStatusLabel(), 'increment_id_link_url' => $this->getUrl('sales/order/view/', array('order_id' => $order->getId()))));
}
if ($orders) {
$this->setGridElements($orders);
}
}
/**
* Before load action
*
* @return Varien_Data_Collection_Db
*/
protected function _beforeLoad()
{
parent::_beforeLoad();
if ($this->_helper()->checkCatalogPermissionsActive()) {
$wherePart = $this->getSelect()->getPart(Zend_Db_Select::SQL_WHERE);
$this->getSelect()->reset(Zend_Db_Select::WHERE);
$weHaveStoreId = false;
foreach ($wherePart as $where) {
if (strpos($where, "store_id") !== false) {
if (!$weHaveStoreId) {
if ($this->_helper()->getNeedMainTableAlias()) {
$this->getSelect()->where(str_replace("AND ", "", str_replace("(store_id", "(main_table.store_id", $where)));
} else {
$this->getSelect()->where(str_replace("AND ", "", str_replace("(store_id", "(e.store_id", $where)));
}
$weHaveStoreId = true;
}
} else {
$this->getSelect()->where(str_replace("AND ", "", $where));
}
}
}
return $this;
}
protected function _construct()
{
parent::_construct();
$this->setMainTable('sales/order_grid');
}
public function getSelectCountSql()
{
$countSelect = parent::getSelectCountSql();
$countSelect->reset(Zend_Db_Select::GROUP);
return $countSelect;
}
