public function confirmAction() { $tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation(); $where = ''; $limit = $this->_request->getParam('limit') ? $this->_request->getParam('limit') : 10; $this->view->limit = $limit; $itemsPerPage = $limit; $this->view->itemsPerPage = $itemsPerPage; $offset = $this->_request->getParam('offset') ? $this->_request->getParam('offset') : 0; $this->view->offset = $offset; $sStatus = $this->_request->getPost('sStatus') ? $this->_request->getPost('sStatus') : $this->_request->getParam('sStatus'); $this->view->sStatus = $sStatus; $sUsername = $this->_request->getPost('sUsername') ? $this->_request->getPost('sUsername') : $this->_request->getParam('sUsername'); $this->view->sUsername = $sUsername; $fdate = $this->_request->getPost('fdate') ? $this->_request->getPost('fdate') : $this->_request->getParam('fdate'); $this->view->fdate = $fdate; $ldate = $this->_request->getPost('ldate') ? $this->_request->getPost('ldate') : $this->_request->getParam('ldate'); $this->view->ldate = $ldate; if (!empty($sStatus)) { $where .= " AND KOS.ordersStatus LIKE '%{$sStatus}%'"; } if (!empty($sStatus)) { $where .= " AND KU.username LIKE '%{$sUsername}%'"; } if (!empty($fdate)) { $where .= " AND datePurchased > '{$fdate}'"; } if (!empty($ldate)) { $where .= " AND datePurchased < '{$ldate}' "; } $rowset = $tblConfirm->unconfirmList($where, $limit, $offset); $count = $tblConfirm->unconfirmListCount($where); echo '<pre>'; //print_r(($rowset)); echo '</pre>'; $this->view->rowset = $rowset; $this->view->totalItems = $count; }