/**
* @return obj
*/
public function show()
{
if (!isset(self::$_instance)) {
$show = __CLASS__;
self::$_instance = new $show();
}
return self::$_instance;
}
public function confirmAction()
{
$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->view->sStatus = $sStatus;
$sUsername = $this->_request->getPost('sUsername') ? $this->_request->getPost('sUsername') : '';
$this->view->sUsername = $sUsername;
$fdate = $this->_request->getPost('fdate') ? $this->_request->getPost('fdate') : '';
$this->view->fdate = $fdate;
$ldate = $this->_request->getPost('ldate') ? $this->_request->getPost('ldate') : '';
$this->view->ldate = $ldate;
$where = '';
if (!empty($sStatus)) {
$where .= " AND KO.orderStatus LIKE '%{$sStatus}%'";
}
if (!empty($sStatus)) {
$where .= " AND KU.username LIKE '%{$sUsername}%'";
}
if (!empty($fdate)) {
$where .= " AND KO.datePurchased > '{$fdate}'";
}
if (!empty($ldate)) {
$where .= " AND KO.datePurchased < '{$ldate}' ";
}
$rowset = App_Model_Show_PaymentConfirmation::show()->unconfirmList($where, $limit, $offset);
$count = App_Model_Show_PaymentConfirmation::show()->unconfirmListCount($where);
$this->view->rowset = $rowset;
$this->view->totalItems = $count;
}
