/**
* This function is used to get the user order listpage
*
* .
*
* @return string
*/
function showOrder()
{
include 'classes/Display/DUserAccount.php';
$pagesize = 10;
if (isset($_GET['page'])) {
$start = trim($_GET['page'] - 1) * $pagesize;
$end = $pagesize;
} else {
$start = 0;
$end = $pagesize;
}
$total = 0;
$id = $_SESSION['user_id'];
$sqlselect = "SELECT a.customers_id,a.orders_id,date_format(a.date_purchased,'%e/%c/%Y') as pdate,b.orders_status_name,c.user_display_name,a.order_total as total,a.shipment_track_id,e.shipment_name,a.currency_id,f.id,f.currency_tocken FROM `orders_table` a inner join orders_status_table b on a.orders_status=b.orders_status_id inner join users_table c on a.customers_id=c.user_id inner join order_products_table d on a.orders_id=d.order_id left join shipments_master_table e on a.shipment_id_selected=e.shipment_id left join currency_master_table f on f.id=a.currency_id where a.customers_id=" . $id . " group by a.orders_id order by a.date_purchased desc";
$query = new Bin_Query();
if ($query->executeQuery($sqlselect)) {
$total = ceil($query->totrows / $pagesize);
include 'classes/Lib/Paging.php';
$tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination');
$this->data['paging'] = $tmp->output;
$this->data['prev'] = $tmp->prev;
$this->data['next'] = $tmp->next;
}
$sqlselect = "SELECT a.customers_id,a.orders_status,a.orders_id,date_format(a.date_purchased,'%e/%c/%Y') as pdate,b.orders_status_name,c.user_display_name,a.order_total as total,a.currency_id,f.id,f.currency_tocken,a.shipment_track_id,e.shipment_id,e.shipment_name FROM `orders_table` a inner join orders_status_table b on a.orders_status=b.orders_status_id inner join users_table c on a.customers_id=c.user_id inner join order_products_table d on a.orders_id=d.order_id left join shipments_master_table e on a.shipment_id_selected=e.shipment_id left join currency_master_table f on f.id=a.currency_id where a.customers_id=" . $id . " group by a.orders_id order by a.date_purchased desc LIMIT {$start},{$end}";
$obj = new Bin_Query();
$obj->executeQuery($sqlselect);
return Display_DUserAccount::showMyOrder($obj->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start);
}
