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'));
}
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('marketplace/sales/order/history.phtml');
$sellerId = Mage::getSingleton('customer/session')->getId();
$orderItems = Mage::getResourceModel('sales/order_item_collection')->addFieldToSelect('order_id')->addFieldToFilter('seller_id', $sellerId)->distinct(true);
$arr_order_for_filter = array();
foreach ($orderItems->getData() as $orderItem) {
$arr_order_for_filter[] = $orderItem['order_id'];
}
$orders = Mage::getResourceModel('sales/order_collection')->addFieldToSelect('*')->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))->setOrder('created_at', 'desc');
$dateTo = Mage::app()->getRequest()->getParam('date_to') != '' ? date('Y-m-d H:i:s', strtotime(Mage::app()->getRequest()->getParam('date_to') . "+1 day") - 1) : '';
$dateFrom = Mage::app()->getRequest()->getParam('date_from') !== "" ? date('Y-m-d H:i:s', strtotime(Mage::app()->getRequest()->getParam('date_from'))) : '';
$orderStatus = Mage::app()->getRequest()->getParam('orderstatus');
if ($dateFrom != '') {
$orders->addFieldToFilter('created_at', array('from' => "{$dateFrom}"));
Mage::getSingleton('core/session')->setDateFrom(Mage::app()->getRequest()->getParam('date_from'));
} else {
Mage::getSingleton('core/session')->setDateFrom('');
}
if ($dateTo != '') {
Mage::getSingleton('core/session')->setDateTo(Mage::app()->getRequest()->getParam('date_to'));
$orders->addFieldToFilter('created_at', array('to' => "{$dateTo}"));
} else {
Mage::getSingleton('core/session')->setDateTo('');
}
if ($orderStatus != '') {
Mage::getSingleton('core/session')->setSalesOrderSatus(Mage::app()->getRequest()->getParam('orderstatus'));
$orders->addFieldToFilter('status', "{$orderStatus}");
} else {
Mage::getSingleton('core/session')->setSalesOrderSatus('');
}
$orders->addFieldToFilter('entity_id', array('in' => $arr_order_for_filter));
$this->setOrders($orders);
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');
}
public function __construct()
{
$data = $status = $selectFilter = $from = $to = '';
$data = $this->getRequest()->getPost();
if (isset($data['status'])) {
$status = $data['status'];
}
if (isset($data['select_filter'])) {
$selectFilter = $data['select_filter'];
}
if (!empty($selectFilter)) {
switch ($selectFilter) {
case "today":
/**
* today interval
*/
$startDay = strtotime("-1 today midnight");
$endDay = strtotime("-1 tomorrow midnight");
$from = date("Y-m-d", $startDay);
$to = date("Y-m-d", $endDay);
$fromDisplay = date("Y-m-d", $startDay);
$toDisplay = date("Y-m-d", $startDay);
break;
case "yesterday":
/**
* yesterday interval
*/
$startDay = strtotime("-1 yesterday midnight");
$endDay = strtotime("-1 today midnight");
$from = date("Y-m-d", $startDay);
$to = date("Y-m-d", $endDay);
$fromDisplay = date("Y-m-d", $startDay);
$toDisplay = date("Y-m-d", $startDay);
break;
case "lastweek":
/**
* last week interval
*/
$to = date('d-m-Y');
$toDay = date('l', strtotime($to));
/**
* if today is monday, take last monday
*/
if ($toDay == 'Monday') {
$startDay = strtotime("-1 monday midnight");
$endDay = strtotime("yesterday");
} else {
$startDay = strtotime("-2 monday midnight");
$endDay = strtotime("-1 sunday midnight");
}
$from = date("Y-m-d", $startDay);
$to = date("Y-m-d", $endDay);
$to = date('Y-m-d', strtotime($to . ' + 1 day'));
$fromDisplay = $from;
$toDisplay = date("Y-m-d", $endDay);
break;
case "lastmonth":
/**
* last month interval
*/
$from = date('Y-m-01', strtotime('last month'));
$to = date('Y-m-t', strtotime('last month'));
$to = date('Y-m-d', strtotime($to . ' + 1 day'));
$fromDisplay = $from;
$toDisplay = date('Y-m-t', strtotime('last month'));
break;
case "custom":
/**
* last custom interval
*/
$from = date('Y-m-d', strtotime($data['date_from']));
$to = date('Y-m-d', strtotime($data['date_to'] . ' + 1 day'));
$fromDisplay = $from;
$toDisplay = date('Y-m-d', strtotime($data['date_to']));
break;
}
}
$dbFrom = Mage::getModel('core/date')->gmtDate(null, strtotime($from));
$dbTo = Mage::getModel('core/date')->gmtDate(null, strtotime($to));
parent::__construct();
$this->setTemplate('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()));
if ($status != '') {
$orders->addFieldToFilter('status', array('in' => array($status)));
}
if ($selectFilter != '') {
$orders->addFieldToFilter('created_at', array('from' => $dbFrom, 'to' => $dbTo));
}
$orders->setOrder('created_at', 'desc');
$this->setOrders($orders);
Mage::app()->getFrontController()->getAction()->getLayout()->getBlock('root')->setHeaderTitle(Mage::helper('sales')->__('My Orders'));
}
