public function postpaidAction()
{
$tblOrder = new Kutu_Core_Orm_Table_Order();
$where = '';
$r = $this->getRequest();
$limit = $r->getParam('limit') ? $r->getParam('limit') : 10;
$this->view->limit = $limit;
$itemsPerPage = $limit;
$this->view->itemsPerPage = $itemsPerPage;
$offset = $r->getParam('offset') ? $r->getParam('offset') : 0;
$this->view->offset = $offset;
$this->view->Query = $r->getParam('Query') ? $r->getParam('Query') : '';
$sort = $r->getParam('sort') ? $r->getParam('sort') : '';
if ($this->_request->get('Query')) {
$Query = $this->_request->get('Query');
$where .= " (KU.username LIKE '%" . $Query . "%'\n\t\tOR KO.orderStatus LIKE '%" . $Query . "%'\n\t\tOR KU.lastname LIKE '%" . $Query . "%'\n\t\tOR KU.firstname LIKE '%" . $Query . "%'\n\t\tOR KU.company LIKE '%" . $Query . "%') ";
}
if ($sort == 'exist') {
$order = "ORDER BY total DESC";
} elseif ($sort == 'notExist') {
$order = "ORDER BY total ASC";
} else {
$order = "";
}
//echo($where);
$rowset = $tblOrder->getPostpaidSummary($where, $limit, $offset, $order);
$total = $tblOrder->getPostpaidCount($where);
for ($i = 0; $i < count($rowset); $i++) {
$last[] = $rowset[$i]->guid;
}
for ($i = 0; $i < count(@$last); $i++) {
$coba = $tblOrder->getLastTransactionDate($last[$i]);
$lastTransaction[$coba[0]->userId] = $coba[0]->datePurchased;
//$dateP);
}
@($this->view->lastTransaction = $lastTransaction);
$this->view->totalItems = $total;
$this->view->rowset = $rowset;
$this->view->sort = $sort;
}
