public function __construct()
{
parent::__construct();
$this->setTemplate('sales/order/history.phtml');
$postData = $this->getRequest()->getParams();
if ($postData['myorder_txt'] || $postData['myorder_status']) {
$orders = Mage::getResourceModel('sales/order_collection')->addFieldToFilter('customer_id', Mage::getSingleton('customer/session')->getCustomer()->getId())->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()));
$orders->setOrder('main_table.created_at', 'desc');
if ($searchKeyword = strtolower($postData['myorder_txt'])) {
$orders->getSelect()->joinLeft(array('sub' => $orders->getTable('sales/order_item')), 'sub.order_id=main_table.entity_id', array('sub.sku'));
$orders->getSelect()->joinLeft(array('order_address' => $orders->getTable('sales/order_address')), 'main_table.entity_id=order_address.parent_id', array('order_address.parent_id'));
/* $orders->addFieldToFilter('order_address.address_type', 'shipping'); */
$orders->getSelect()->where("\n main_table.increment_id like '%{$searchKeyword}%' OR \n LOWER(main_table.coupon_code) like '%{$searchKeyword}%' OR\n LOWER(sub.name) like '%{$searchKeyword}%' OR \n LOWER(sub.sku) like '%{$searchKeyword}%' OR \n LOWER(order_address.firstname) like '%{$searchKeyword}%' OR \n LOWER(order_address.lastname) like '%{$searchKeyword}%' OR \n LOWER(order_address.company) like '%{$searchKeyword}%' OR \n LOWER(order_address.street) like '%{$searchKeyword}%' OR \n LOWER(order_address.region) like '%{$searchKeyword}%' OR\n LOWER(order_address.city) like '%{$searchKeyword}%' OR \n LOWER(order_address.postcode) like '%{$searchKeyword}%' OR\n LOWER(order_address.telephone) like '%{$searchKeyword}%' \n ");
$orders->getSelect()->group('sub.order_id');
/* $orders->getSelect()->group('main_table.entity_id'); */
}
if ($postData['myorder_status']) {
$orders->getSelect()->where(" main_table.status='" . trim($postData['myorder_status']) . "'");
}
/* echo $orders->getSelect(); */
} else {
$orders = Mage::getResourceModel('sales/order_collection')->addFieldToSelect('*')->addFieldToFilter('customer_id', Mage::getSingleton('customer/session')->getCustomer()->getId())->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))->setOrder('created_at', 'desc');
}
$this->setOrders($orders);
Mage::app()->getFrontController()->getAction()->getLayout()->getBlock('root')->setHeaderTitle(Mage::helper('sales')->__('My Orders'));
}
protected function _prepareLayout()
{
parent::_prepareLayout();
$pager = $this->getLayout()->createBlock('page/html_pager', 'sales.order.history.pager')->setCollection($this->getOrders());
$this->setChild('pager', $pager);
$this->getOrders()->load();
return $this;
}
public function __construct()
{
parent::__construct();
if (Mage::helper('tweaks')->isOrderViewProductsColumnFrontendEnable()) {
$this->setTemplate('tweaks/sales-order-history.phtml');
$orders = Mage::getResourceModel('sales/order_collection')->addFieldToSelect('*')->addFieldToFilter('customer_id', Mage::getSingleton('customer/session')->getCustomer()->getId())->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))->setOrder('created_at', 'desc');
$orders->getSelect()->columns(array('product_names' => new Zend_Db_Expr('(SELECT GROUP_CONCAT(name SEPARATOR \'\\n\') FROM ' . $orders->getTable('sales/order_item') . ' WHERE parent_item_id IS NULL AND order_id=main_table.entity_id)')));
$this->setOrders($orders);
Mage::app()->getFrontController()->getAction()->getLayout()->getBlock('root')->setHeaderTitle(Mage::helper('sales')->__('My Orders'));
}
}
public function __construct()
{
parent::__construct();
$this->setTemplate('sublogin/sales/order/history.phtml');
$_3a6c2ec34d8458e049eec354fda76a3e8b1384c1 = Mage::getResourceModel('sales/order_collection')->addFieldToSelect('*')->addFieldToFilter('customer_id', Mage::getSingleton('customer/session')->getCustomer()->getId())->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()));
$_17fe0f58f521a1d8d613a93097a5a22f2074c04f = Mage::helper('sublogin')->getCurrentSublogin();
if (Mage::getStoreConfig('sublogin/general/restrict_order_view') && $_17fe0f58f521a1d8d613a93097a5a22f2074c04f) {
$_3a6c2ec34d8458e049eec354fda76a3e8b1384c1->addFieldToFilter('customer_email', Mage::getSingleton('customer/session')->getSubloginEmail());
}
$_3a6c2ec34d8458e049eec354fda76a3e8b1384c1->setOrder('created_at', 'desc');
$this->setOrders($_3a6c2ec34d8458e049eec354fda76a3e8b1384c1);
Mage::app()->getFrontController()->getAction()->getLayout()->getBlock('root')->setHeaderTitle(Mage::helper('sales')->__('My Orders'));
}
public function __construct()
{
parent::__construct();
$this->setTemplate('payperrentals/sales/order/history.phtml');
}
public function __construct()
{
parent::__construct();
$this->setTemplate('marketplace/buyerseller/sales/order/history.phtml');
}
