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