public function viewAction() { $this->view->messages = $this->_flashMessenger->getMessages(); $this->_helper->layout->disableLayout(); $creditHistoryObj = new User_Model_DbTable_Chistory(); $order_id = $this->_request->getParam('orderid', 0); $sql = "select cr.*,tch.* from pclive_credit_history as cr,pclive_transaction_history as tch where cr.order_id=tch.orderId and cr.order_id='" . $order_id . "' order by credit_id desc"; $MemberList = $creditHistoryObj->getAdapter()->fetchAll($sql); $page = $this->_getParam('page', 1); $paginator = Zend_Paginator::factory($MemberList); $paginator->setItemCountPerPage(PUBLISHER_PAGING_SIZE); $this->view->page = $page; $this->view->MemberList = $paginator; $this->view->oderId = $order_id; }
public function viewgrouppublicationAction() { $creditHistoryObj = new User_Model_DbTable_Chistory(); $this->view->messages = $this->_flashMessenger->getMessages(); $order_id = $this->_request->getParam('orderid', 0); $sql = "select cr.*,tch.* from pclive_credit_history as cr,pclive_transaction_history as tch where cr.order_id=tch.orderId and cr.order_id='" . $order_id . "' and group_id!='' order by credit_id desc"; $MemberList = $creditHistoryObj->getAdapter()->fetchAll($sql); //$MemberList = $transactionHistoryObj->getOrderHistory($this->sessCompanyInfo->id); $page = $this->_getParam('page', 1); $paginator = Zend_Paginator::factory($MemberList); $paginator->setItemCountPerPage(PUBLISHER_PAGING_SIZE); //$paginator->setItemCountPerPage(2); $paginator->setCurrentPageNumber($page); $this->view->totalCount = count($MemberList); $this->view->pageSize = PUBLISHER_PAGING_SIZE; $this->view->page = $page; $this->view->creditdata = $paginator; $this->view->modelGroup = $this->modelGroup; $this->view->oderId = $order_id; }