/** * @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; }