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