function transactionAction() { $this->_checkAuth(); $where = $this->_user->kopel; $modelOrder = new Kutu_Core_Orm_Table_Order(); $rowsetTotal = $modelOrder->countOrders("'" . $where . "' AND (orderStatus = 3 OR orderStatus = 5)"); $rowset = $modelOrder->getOrderSummary("'" . $where . "' AND (orderStatus = 3 OR orderStatus = 5)"); $this->view->numCount = $rowsetTotal; $this->view->listOrder = $rowset; }
public function transactionAction() { $this->_checkAuth(); $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; $Query = $r->getPost('Query') ? $r->getPost('Query') : $r->getParam('Query'); $this->view->Query = $Query; $query = ''; if (!empty($Query)) { $query = " AND KOD.documentName LIKE '%{$Query}%' "; } $tblOrder = new Kutu_Core_Orm_Table_Order(); $rowsetTotal = $tblOrder->countOrders($query, "'" . $this->_userInfo->userId . "' AND (orderStatus = 3 OR orderStatus = 5)"); $where = "'" . $this->_userInfo->userId . "' AND (orderStatus = 3 OR orderStatus = 5)"; $rowset = $tblOrder->getOrderSummary($query, $where, $limit, $offset); $this->view->numCount = $rowsetTotal; $this->view->listOrder = $rowset; //print_r($this->_request->getParams()); }