/** * Require the correct pagenav class based on template * * @param int $total total * @param int $limitStart start * @param int $limit length of records to return * * @return object pageNav */ public function &getPagination($total = 0, $limitStart = 0, $limit = 0) { if (!isset($this->nav)) { if ($this->randomRecords) { $limitStart = $this->getRandomLimitStart(); } $params = $this->getParams(); $this->nav = new FPagination($total, $limitStart, $limit); if ($limit == -1) { $this->nav->viewAll = true; } // $$$ rob set the nav link urls to the table action to avoid messed up url links when doing ranged filters via the querystring $this->nav->url = $this->getTableAction(); $this->nav->showAllOption = $params->get('showall-records', false); $this->nav->setId($this->getId()); $this->nav->showTotal = $params->get('show-total', false); $item = $this->getTable(); $this->nav->startLimit = FabrikWorker::getMenuOrRequestVar('rows_per_page', $item->rows_per_page, $this->isMambot); $this->nav->showDisplayNum = $params->get('show_displaynum', true); } return $this->nav; }
public function actionRecharge() { $data = array(); $attr = array('condition' => 'user_id = :user_id', 'params' => array(':user_id' => $this->user['id'])); $userProBuyList = $this->userProductBuy_model->findAll($attr); $sumBuyVal = 0.0; foreach ($userProBuyList as $userProVal) { $buyPro = $userProVal->getAttributes(); $sumBuyVal += $buyPro['buy_val']; } $data['sumBuyVal'] = $sumBuyVal; $dType = $this->request->getParam('dType'); $rType = $this->request->getParam('rType'); $dTime = FConfig::item('config.time_type.' . $dType); if ($rType == 3) { //分页参数 $page = $this->request->getParam('page') > 0 ? (int) $this->request->getParam('page') : 1; $page_size = $this->request->getParam('size') > 0 ? (int) $this->request->getParam('size') : FConfig::item('config.pageSize'); $where = "1=1"; $where .= " and user_id = {$this->user['id']}"; if (!empty($dType)) { $where .= " and create_time >= :create_time"; $data['dType'] = $dType; } $condition_arr = array('condition' => $where, 'order' => 'create_time DESC', 'limit' => $page_size, 'offset' => ($page - 1) * $page_size); $condition_arr['params'] = array(); if (!empty($dType)) { $condition_arr['params'][':create_time'] = $dTime; } $data['cashList'] = $this->withdrawCash_model->findAll($condition_arr); $data['count'] = $this->withdrawCash_model->count($condition_arr); $pages = new FPagination($data['count']); $pages->setPageSize($page_size); $pages->setCurrent($page); $pages->makePages(); $data['page'] = $pages; } //分页参数 $page = $this->request->getParam('page') > 0 ? (int) $this->request->getParam('page') : 1; $page_size = $this->request->getParam('size') > 0 ? (int) $this->request->getParam('size') : FConfig::item('config.pageSize'); $where = "1=1"; $where .= " and user_id = {$this->user['id']} and trade_status=1"; if (!empty($rType)) { $where .= " and trade_type = :trade_type"; $data['rType'] = $rType; } if (!empty($dType)) { $where .= " and trade_time >= :trade_time"; $data['dType'] = $dType; } $condition_arr = array('condition' => $where, 'order' => 'trade_time DESC', 'limit' => $page_size, 'offset' => ($page - 1) * $page_size); $condition_arr['params'] = array(); if (!empty($dType)) { $condition_arr['params'][':trade_time'] = $dTime; } $tType = FConfig::item("config.r_type." . $rType); if (!empty($rType)) { $condition_arr['params'][':trade_type'] = FConfig::item("config.trade_type." . $tType); } $data['tradeList'] = $this->tradingRecord_model->findAll($condition_arr); $data['count'] = $this->tradingRecord_model->count($condition_arr); $pages = new FPagination($data['count']); $pages->setPageSize($page_size); $pages->setCurrent($page); $pages->makePages(); $data['tradeList'] = $this->tradingRecord_model->findAll($condition_arr); $data['page'] = $pages; $this->render('recharge', $data); }