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