public function index() { import('ORG.Util.Page'); $m = M("Good"); $count = $m->count(); // 查询满足要求的总记录数 $Page = new Page($count, 12); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('theme', '<li><a>%totalRow% %header%</a></li> <li>%upPage%</li> <li>%downPage%</li> <li>%first%</li> <li>%prePage%</li> <li>%linkPage%</li> <li>%nextPage%</li> <li>%end%</li> '); //(对thinkphp自带分页的格式进行自定义) $show = $Page->show(); // 分页显示输出 $result = $m->limit($Page->firstRow . ',' . $Page->listRows)->select(); for ($i = 0; $i < count($result); $i++) { $menu_id = $result[$i]["menu_id"]; $result[$i]["menu"] = R("Api/Api/getmenuvalue", array($menu_id)); } $menu = R("Api/Api/getarraymenu"); $this->assign("menu", $menu); $this->assign("addmenu", $menu); $this->assign("page", $show); // 赋值分页输出 $this->assign("result", $result); $this->display(); }
function index() { // print_r($_SESSION); // exit(); $donate_model = M('donate'); import('ORG.Util.Page'); $pagesize = 17; $count = $donate_model->where('userid=' . $_SESSION['userid'])->count(); // 查询满足要求的总记录数 $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条赠送金额信息'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $donate_model->where('userid=' . $_SESSION['userid'])->order('id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list = $this->formatfield($list); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); }
public function index() { parent::userauth2(12); $co = M('competence'); $keyword = I('get.keyword', '', 'htmlspecialchars'); import('ORG.Util.Page'); // 导入分页类 $where['Sid&Cname'] = array('0', array('LIKE', "%{$keyword}%"), '_multi' => true); //多条件查询 $count = $co->where($where)->count(); //总记录数 $Page = new Page($count, 4); //实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '<img src="__IMAGE__/prev.gif" border="0" title="上一页" />'); $Page->setConfig('next', '<img src="__IMAGE__/next.gif" border="0" title="下一页" />'); $Page->setConfig('first', '<img src="__IMAGE__/first.gif" border="0" title="第一页" />'); $Page->setConfig('last', '<img src="__IMAGE__/last.gif" border="0" title="最后一页" />'); $show = $Page->show(); //分页显示输出 $volist = $co->where($where)->order('Dtime')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $sidlist = $co->where('Sid<>0')->order('Dtime')->select(); $this->assign('volist', $volist); $this->assign('sidlist', $sidlist); $this->assign('page', $show); $this->assign('keyword', $keyword); $this->co = $count; $this->display(); }
public function ip() { parent::userauth2(21); $keyword = I('get.keyword', '', 'htmlspecialchars'); $ip = D('Ip'); import('ORG.Util.Page'); // 导入分页类 if ($keyword != '') { $where['Ip'] = $keyword; } else { $where['Ip'] = ''; } $count = $ip->where($where)->count(); //总记录数 $Page = new Page($count, 15); //实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '<img src="__IMAGE__/prev.gif" border="0" title="上一页" />'); $Page->setConfig('next', '<img src="__IMAGE__/next.gif" border="0" title="下一页" />'); $Page->setConfig('first', '<img src="__IMAGE__/first.gif" border="0" title="第一页" />'); $Page->setConfig('last', '<img src="__IMAGE__/last.gif" border="0" title="最后一页" />'); $show = $Page->show(); //分页显示输出 $volist = $ip->relation(true)->where($where)->order('Dtime desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('volist', $volist); $this->assign('page', $show); //输出分页 $this->assign('keyword', $keyword); $this->co = $count; $this->display(); }
public function admin_user_list() { $admin = $this->is_admin_authed(); if (empty($admin)) { redirect(__APP__ . '/admin/login.html'); } $user = D('User'); $user_all = $user->get_user_list(); $user_count = count($user_all); import('ORG.Util.Page'); // 导入分页类 $page = new Page($user_count, '', '', 'admin/user_list'); $page->setConfig('first', '首页'); $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $page->setConfig('last', '末页'); $page->setConfig('theme', '%first% %prePage% %linkPage% %nextPage% %end%'); $show = $page->show(); // 分页显示输出 $offset = I('page') ? (I('page') - 1) * $page->listRows : 0; $user_list = $user->get_user_list($offset, $page->listRows); $this->assign('page', $show); // 赋值分页输出 $this->assign('user_list', $user_list); // 赋值数据集 $this->assign('admin', $admin); $this->display(); }
/** * 最新资讯 */ public function index() { // 渲染TDK $this->tdk(4); // 导航高亮 $this->assign('highline', 4); // 渲染导航条 $this->navigation(); // 渲染右边悬浮框 $this->right(); // 资讯分类 $category = M('NewsCategory')->order("add_time ASC")->select(); if ($category) { $id = isset($_GET['category']) ? intval($_GET['category']) : $category[0]['id']; if (!M('NewsCategory')->where(array('id' => $id))->count()) { $this->redirect('/news/index?category=' . $category[0]['id']); } Load('extend'); import('ORG.Util.Page'); $news = M('News'); $count = $news->where(array('category_id' => $id))->count(); $page = new Page($count, 10); $page->setConfig('theme', "共 %totalRow% %header% %nowPage%/%totalPage%页 %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%"); $page->setConfig('header', '篇资讯'); $show = $page->show(); $newsLists = $news->where(array('category_id' => $id))->order("add_time DESC")->limit($page->firstRow, $page->listRows)->select(); $this->assign('newsLists', $newsLists); $this->assign('count', ceil($count / 10)); $this->assign('page', $show); $this->assign('category', $category); } $this->assign('id', $id); $this->display(); }
public function index() { //自定义 $Form = M('Form'); import("@.ORG.Page"); //导入分页类 $count = $Form->count(); //计算总数 $p = new Page($count, 5); $list = $Form->limit($p->firstRow . ',' . $p->listRows)->order('id desc')->select(); //$p->firstRow 当前页开始记录的下标,$p->listRows 每页显示记录数 //一般定义分页样式 通过分页对象的setConfig定义其config属性; /* 默认值为$config = array('header'=>'条记录','prev'=>'上一页','next'=>'下一页','first'=>'第一页','last'=>'最后一页', 'theme'=>' %totalRow% %header% %nowPage%/%totalPage% 页 %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%'); 修改显示的元素的话设置theme就行了,可对其元素加class */ $p->setConfig('header', '条数据'); $p->setConfig('prev', "<"); $p->setConfig('next', '>'); $p->setConfig('first', '<<'); $p->setConfig('last', '>>'); $page = $p->show(); //分页的导航条的输出变量 $this->assign("page", $page); $this->assign("list", $list); //数据循环变量 $this->display(); }
public function index() { parent::userauth2(60); $sid = I('get.sid', ''); $menu = D('Dmenu'); import('ORG.Util.Page'); // 导入分页类 if ($sid != '') { $where['Sid'] = $sid; } else { $where['Sid'] = 0; } $count = $menu->where($where)->count(); //总记录数 $Page = new Page($count, 15); //实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '<img src="__IMAGE__/prev.gif" border="0" title="上一页" />'); $Page->setConfig('next', '<img src="__IMAGE__/next.gif" border="0" title="下一页" />'); $Page->setConfig('first', '<img src="__IMAGE__/first.gif" border="0" title="第一页" />'); $Page->setConfig('last', '<img src="__IMAGE__/last.gif" border="0" title="最后一页" />'); $show = $Page->show(); //分页显示输出 $volist = $menu->relation(true)->where($where)->order('Sortid asc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list = $menu->where('Sid = 0')->order('Sortid asc')->select(); $this->assign('volist', $volist); $this->assign('list', $list); $this->assign('sid', $sid); $this->assign('page', $show); //输出分页 $this->co = $count; $this->display('System/dmenu'); }
protected function pageInit($count, $header = '条记录', $row = PDM_LIMIT, $url = '') { import("@.Rover.Page"); $page = new Page($count, $row); if ($url != '') { $page->url = $url; } $page->setConfig('header', $header); $page->setConfig('first', '首页'); $page->setConfig('last', '尾页'); $page->setConfig('theme', '<li class="previous">%upPage%</li><li class="next"> %downPage%</li>'); $this->assign('page', $page->show()); //开始记录分页序号 S if ($page->nowPage == 1) { $current_page = 0; $row = 0; } else { $row = $page->listRows; $current_page = $page->nowPage; } $this->assign('page_now', $current_page); $this->assign('page_row', $row); //开始记录分页序号 E return $page; }
function index() { // print_r($_SESSION); // exit(); if (isset($_GET['id'])) { $id = $_GET['id']; $_SESSION['userid'] = $id; } else { $id = $_session['userid']; } // 1代表 已过期 2代表 本月过期 3代表 3个月未使用 $user_model = M('users'); if ($id == 1) { // code... $where = "expirydate<=" . time(); } else { if ($id == 2) { // 本月过期 $time = strtotime(date('Y-m-01 00:00:00'), time()); $where = "expirydate>=" . $time . "and expirydate<=" . time(); } else { if ($id == 3) { $time = time() - 90 * 24 * 60 * 60; $where = "lastusetime<=" . $time; } else { $where = "banlance<='0' and limitflag = 0"; } } } import('ORG.Util.Page'); if ($_SESSION['power'] == 1) { $header = "条用户信息"; $count = $user_model->where($where)->count(); // 查询满足要求的总记录数 $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', $header); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 $userdata = $user_model->where($where)->order('registedate')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('page', $show); // 赋值分页输出 } else { $sql = "select * from cb_users where phonenum in (select bindtel from cb_cards where ownid=" . $_SESSION['accountid'] . " or subownid=" . $_SESSION['accountid'] . ") and " . $where; $userdata = $user_model->query($sql); } $userdata = $this->formatarrfield($userdata); $this->assign("userdata", $userdata); $this->assign('timer', $this->getTime()); $this->display(); }
public function paging($obj, $where = '', $pagesize = '12') { import("ORG.Util.Page"); $count = $obj->where($where)->count(); $pageobj = new Page($count, $pagesize); $pageobj->setConfig('header', '条'); $pageobj->setConfig('prev', "<"); $pageobj->setConfig('next', '>'); $pageobj->setConfig('first', '<<'); $pageobj->setConfig('last', '>>'); return $pageobj; }
/** * 前台分页统一 */ protected function _pager($count, $pagesize) { $pager = new Page($count, $pagesize); $pager->rollPage = 5; $pager->setConfig('header', '条记录'); $pager->setConfig('prev', '上一页'); $pager->setConfig('next', '下一页'); $pager->setConfig('first', '第一页'); $pager->setConfig('last', '最后一页'); $pager->setConfig('theme', '%upPage% %first% %linkPage% %end% %downPage%'); return $pager; }
function index() { import('ORG.Util.Page'); $pagesize = 17; $donate_model = M('donate'); if ($_SESSION['power'] == 1) { $count = $donate_model->where($data)->count(); // 查询满足要求的总记录数 $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条赠送金额信息'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 //进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $donate_model->order('id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list = $this->getusername($list); $list = $this->formatfield($list); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); // 输出模板 } else { //$_SESSION['accountid']=19; $sql = "select count(id) from cb_donate where userid in (select id from cb_users where phonenum in(select bindtel from cb_cards where subownid =" . $_SESSION['accountid'] . " or ownid=" . $_SESSION['accountid'] . "))"; $arr = $donate_model->query($sql); $count = $arr[0]['count']; $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', $header); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $sql = "select * from cb_donate where userid in (select id from cb_users where phonenum in(select bindtel from cb_cards where subownid =" . $_SESSION['accountid'] . " or ownid=" . $_SESSION['accountid'] . "))"; $sql = $sql . " limit " . $Page->listRows . " offset " . $Page->firstRow; $list = $donate_model->query($sql); $list = $this->getusername($list); $list = $this->formatfield($list); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); } }
function index() { $account = M('account'); $nav = $this->infinite($account->field('id,loginname,ownid')->order('id ASC')->select(), $_SESSION['accountid']); $this->assign('nav', $nav); if ($_SESSION['power'] == 1) { $log_model = M('log'); import('ORG.Util.Page'); $header = "条操作日志"; $pagesize = 16; $count = $log_model->count(); // 查询满足要求的总记录数 //print_r($count); $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', $header); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $logdata = $log_model->order('opertime desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); //print_r($logdata); } else { $log_model = M('log'); import('ORG.Util.Page'); $header = "条操作日志"; $pagesize = 16; $count = $log_model->where('accountid=' . $_SESSION['accountid'])->count(); // 查询满足要求的总记录数 //print_r($count); $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', $header); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $logdata = $log_model->order('opertime desc')->where('accountid=' . $_SESSION['accountid'])->limit($Page->firstRow . ',' . $Page->listRows)->select(); } $logdata = $this->formatfield($logdata); $this->assign('logdata', $logdata); //赋值数据集 $this->assign('page', $show); //赋值分页输出 $this->display(); }
public function index() { import('ORG.Util.Page'); $m = M("Good"); $count = $m->count(); // 查询满足要求的总记录数 $Page = new Page($count, 12); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('theme', '<li><a>%totalRow% %header%</a></li> <li>%upPage%</li> <li>%downPage%</li> <li>%first%</li> <li>%prePage%</li> <li>%linkPage%</li> <li>%nextPage%</li> <li>%end%</li> '); //(对thinkphp自带分页的格式进行自定义) $show = $Page->show(); // 分页显示输出 $result = $m->limit($Page->firstRow . ',' . $Page->listRows)->select(); for ($i = 0; $i < count($result); $i++) { $menu_id = $result[$i]["menu_id"]; $result[$i]["menu"] = R("Api/Api/getmenuvalue", array($menu_id)); } $menu = R("Api/Api/getarraymenu"); $this->assign("menu", $menu); $this->assign("addmenu", $menu); $this->assign("page", $show); // 赋值分页输出 $this->assign("result", $result); $zhekou = 0; if (file_exists('./Public/Conf/zhekou.php')) { require './Public/Conf/zhekou.php'; } $this->assign("zhekou", $zhekou); $yongjin = array(); $yongjin['yongjin_1'] = 28; $yongjin['yongjin_2'] = 13; $yongjin['yongjin_3'] = 9; if (file_exists('./Public/Conf/yongjin.php')) { require './Public/Conf/yongjin.php'; $yongjin = json_decode($yongjin, true); } $this->assign("yongjin", $yongjin); $tixianinfo = array(); $tixianinfo['shouhuo'] = 7; $tixianinfo['tixian'] = 7; $tixianinfo['jine'] = 50; $tixianinfo['dingdan'] = 20000; if (file_exists('./Public/Conf/tixianinfo.php')) { require './Public/Conf/tixianinfo.php'; $tixianinfo = json_decode($tixianinfo, true); } $this->assign("tixianinfo", $tixianinfo); $this->display(); }
/** * 节点列表 * @author Terry <*****@*****.**> * @date 2013-04-01 */ public function pageList() { $name = $this->getActionName(); $ary_get['pageall'] = $this->_get('pageall', 'htmlspecialchars', 10); $count = D($name)->where()->count(); $obj_page = new Page($count, $ary_get['pageall']); $obj_page->setConfig("header", "条"); $obj_page->setConfig('theme', '<li style="heigth:23px;line-height:23px;padding-top:8px;">共%totalRow%%header% %nowPage%/%totalPage%页 %first% %upPage% %prePage% %linkPage% %nextPage% %downPage% %end%</li>'); $page = $obj_page->newshow(); $ary_data = D($name)->where()->limit($obj_page->firstRow, $obj_page->listRows)->select(); $this->assign("filter", $ary_get); $this->assign("data", $ary_data); $this->assign("page", $page); $this->display(); }
/** * 菜单列表 * @author Terry <*****@*****.**> * @date 2013-01-22 */ public function pageList() { $rolenav = D("RoleNav"); $ary_get['pageall'] = $this->_get('pageall', 'htmlspecialchars', 10); $count = $rolenav->where()->count(); $obj_page = new Page($count, $ary_get['pageall']); $obj_page->setConfig("header", "条"); $obj_page->setConfig('theme', '<li class="pageSelect">共%totalRow%%header% %nowPage%/%totalPage%页 %first% %upPage% %prePage% %linkPage% %nextPage% %downPage% %end%</li>'); $page = $obj_page->newshow(); $ary_data = $rolenav->where()->limit($obj_page->firstRow, $obj_page->listRows)->select(); $this->assign("data", $ary_data); $this->assign("filter", $ary_get); $this->assign("page", $page); $this->display(); }
function notice_management($flag = null) { $a = M('notice'); import('ORG.Util.Date'); // 导入日期类 import('ORG.Util.Page'); // 导入分页类 $count = $a->where($where)->count(); //获取数据的总数 $page = new Page($count, 15); // $page->setConfig('header', '条信息'); $show = $page->show(); //返回分页信息 $arr = $a->where($where)->order('istop desc,createtime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); for ($i = 0; $i < sizeof($arr); $i++) { $arr[$i]['createtime'] = $arr[$i]['createtime']; $Date = new Date($arr[$i]['createtime']); $time = $Date->dateDiff(time(), 'd'); // 比较日期差 $arr[$i]['lefttop'] = round($arr[$i]['topday'] - $time); } $this->assign('show', $show); $this->assign("notice", $arr); if (!$flag) { $this->display(); } }
/** * 查看用户详情页面 */ public function view() { $user = M('User'); $oneUser = $user->where('id=' . $_GET['user_id'])->find(); // 处理字段 $oneUser['regtime'] = date('Y/m/d H:i:s', $oneUser['regtime']); $oneUser['logintime'] = date('Y/m/d H:i:s', $oneUser['logintime']); $this->assign('oneUser', $oneUser); // 获取用户购买过的商品记录,分页 $orderInfoView = D('OrderInfoView'); $buyGoods = $orderInfoView->where('user_id=' . $_GET['user_id'])->page($_GET['p'] . ',5')->select(); foreach ($buyGoods as $k => $v) { $buyGoods[$k]['add_time'] = date('Y/m/d H:i:s', $buyGoods[$k]['add_time']); } $this->assign('buyGoods', $buyGoods); import("ORG.Util.Page"); // 导入分页类 $count = $orderInfoView->where('user_id=' . $_GET['user_id'])->count(); // 查询满足要求的总记录数 $page = new Page($count, 5); // 实例化分页类 传入总记录数和每页显示的记录数 $page->setConfig('header', '种商品'); // 配置分页显示输出样式 $show = $page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->display('userdesc'); }
public function admin() { // $category = D ( 'Category' ); // $data = $category->select(); // load('@.tree'); // $data = getTree( $data ); // $this->assign ( 'data', $data ); // $this->display( 'admin' ); import ('ORG.Util.Page'); $cate = D('Category'); $count = $cate->count(); $page = new Page ($count, 11); $page->setConfig('header', '个分类'); $show = $page->show(); $this->assign('show', $show); $data = $cate->select(); // 加载函数文件 load ( '@.tree' ); // 生成树状结构 $data = getTree ( $data ); // 截取之后的数组 $list = array_slice ( $data, $page->firstRow, $page->listRows ); // 分配数组数据 $this->assign ( 'data', $list ); // 显示模板 $this->display ( 'admin' ); }
function menu_management($flag = null) { $f = M('function'); $a = M('authority'); $where['father_id'] = 0; $count = 0; //获取数据的总数 $first = $f->where($where)->select(); for ($i = 0; $i < sizeof($first); $i++) { $count++; $where['father_id'] = $first[$i]['f_id']; $first[$i]['second'] = $f->where($where)->select(); for ($j = 0; $j < sizeof($first[$i]['second']); $j++) { $count++; $where1['aid'] = $first[$i]['second'][$j]['default']; $first[$i]['second'][$j]['aname'] = $a->where($where1)->getfield('aname'); } } import('ORG.Util.Page'); // 导入分页类 $page = new Page($count, 15); // $page->setConfig('header', '条信息'); $show = $page->show(); //返回分页信息 $this->assign('menu', $first); $this->assign('show', $show); if (!$flag) { $this->display(); } }
/** * 显示订单列表页面 */ public function index() { // 用做编号的计数 $this->assign('orderIndex', ($_GET['p'] - 1) * 5 + 1); // 分页 $orderInfo = M('Order_info'); $orderList = $orderInfo->page($_GET['p'] . ',10')->select(); // 处理订单字段 foreach ($orderList as $k => $v) { $orderList[$k]['add_time'] = date('Y/m/d H:i:s', $v['add_time']); if ($v['payment_method'] == 1) { $orderList[$k]['payment_method'] = '货到付款'; } else { $orderList[$k]['payment_method'] = '网上支付'; } } $this->assign('orderList', $orderList); // 赋值数据集 import("ORG.Util.Page"); // 导入分页类 $count = $orderInfo->count(); // 查询满足要求的总记录数 $page = new Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数 $page->setConfig('header', '个订单'); // 配置分页显示输出样式 $show = $page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->display('orderlist'); }
public function mobile_content_list($where = array(), $order = "id desc", $limit = 10, $page_params = array()) { $page_num = isset($_GET['p']) ? $_GET['p'] : 1; $news = $this->where(array_merge(array('siteid' => get_siteid()), $where))->order($order)->page($page_num . ', ' . $limit)->select(); $news_temp = array(); foreach ($news as $key => $value) { $value['url'] = U('Content/show', "catid=" . $value['catid'] . "&id=" . $value['id']); $news_temp[$value['id']] = $value; } unset($news); // 分页 import("ORG.Util.Page"); // 导入分页类 $count = $this->where(array_merge(array('siteid' => get_siteid()), $where))->count(); // 查询满足要求的总记录数 $Page = new Page($count, $limit); // 实例化分页类 传入总记录数和每页显示的记录数 if ($page_params) { foreach ($page_params as $key => $param) { $Page->setConfig($key, $param); } } $show = $Page->show(); // 分页显示输出 $next_page_num = ceil($count / $limit) - $page_num; return array('status' => 'success', 'message' => $news_temp, 'next_page_num' => $next_page_num, 'finished' => $finished, 'pages' => $show); }
public function index() { $catsid = I('catsid', '', 'intval'); $cats = M('Category')->find($catsid); $this->assign('catName', $cats['name']); //数据分页 import('ORG.Util.Page'); // 导入分页类 $count = M('article')->where("tid={$catsid} and islock=0")->count(); //获取数据的总数 $page = new Page($count, 5); $page->setConfig('theme', '<ul class="pagination"><li>%upPage%</li><li>%downPage%</li><li>%prePage%</li><li>%linkPage%</li><li>%nextPage%</li><li>%end%</li></ul>'); $show = $page->show(); //返回分页信息 $articles = M('article')->where("tid={$catsid} and islock=0")->order('article_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign('show', $show); $this->assign('count', $count); $this->assign('list', $articles); //侧栏的数据分配 $sidebar1 = M('Article')->where("tid={$catsid} and ispush=1 and islock=0")->order('approval desc')->limit('5')->select(); $sidebar2 = M('Article')->where("tid={$catsid} and ispush=1 and islock=0")->order('opposition desc')->limit('5')->select(); $sidebar3 = M('Article')->where("tid={$catsid} and ispush=1 and islock=0")->order('rand()')->limit('5')->select(); //赞多到少 $this->assign('sidebar1', $sidebar1); //赞少到多 $this->assign('sidebar2', $sidebar2); //随机5篇 $this->assign('sidebar3', $sidebar3); $this->display('list_article'); }
public function showArticles() { $keywords = M('Keyword'); $where['flag'] = 1; $wordlist = $keywords->where($where)->field('name,value')->order("value desc")->select(); $this->assign("wordlist", json_encode($wordlist)); $monthlist = $this->countArtsByMonth(); $this->assign("monthlist", $monthlist); $articlestype = M('articlestype'); $typelist = $articlestype->order("typenum desc")->select(); $temp = M("Articles"); $totalnum = $temp->count(); //dump($typelist); $this->assign("totalnum", $totalnum); $this->assign("typelist", $typelist); $ranklist = $temp->field("id,title,viewnum")->order("viewnum desc")->limit(5)->select(); //dump($ranklist); $this->assign("ranklist", $ranklist); $newlist = $temp->field("id,title")->where("flag=1")->order("createtime desc")->limit(5)->select(); $this->assign("newlist", $newlist); //dump($newlist); if (isset($_GET['type'])) { $articles = M("Articles"); import('ORG.Util.Page'); // 导入分页类 $type = $_GET['type']; $where_type['typeid'] = $type; $count = $articles->where($where_type)->count(); //获取数据的总数 $page = new Page($count, 15); // $page->setConfig('header', '条数据'); $show = $page->show(); //返回分页信息 $article_list = $articles->where($where_type)->order('createtime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign('type', $type); $this->assign('art_list', $article_list); $this->assign('show', $show); } else { $articles = M("Articles"); import('ORG.Util.Page'); // 导入分页类 $count = $articles->count(); //获取数据的总数 $page = new Page($count, 15); // $page->setConfig('header', '条数据'); $show = $page->show(); //返回分页信息 $article_list = $articles->order('createtime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); //dump($article_list); $this->assign('type', "0"); $this->assign('art_list', $article_list); $this->assign('show', $show); } $this->display(); }
function index() { /* //cardnum下拉 $cards=M('cards'); $allcards=$cards->order('cardnum ASC')->getField('cardnum',true); $this->assign('allcards',$allcards); */ $filllog_model = M('fill_log'); import('ORG.Util.Page'); $header = "条操作充值日志"; $pagesize = 14; $log_model = M('fill_log'); $where = ''; if ($this->isPost() || isset($_REQUEST['starttime'])) { $starttime = strtotime(trim($_REQUEST['starttime'])); $endtime = strtotime(trim($_REQUEST['endtime'])); $where = "filldate>=" . $starttime . " and filldate<=" . $endtime; if (isset($_REQUEST['cardno']) && !empty($_REQUEST['cardno'])) { $where .= " AND cardno like '%{$_REQUEST['cardno']}%'"; } if (isset($_REQUEST['phonenum']) && !empty($_REQUEST['phonenum'])) { $where .= " AND phonenum like '%{$_REQUEST['phonenum']}%'"; } } $count = $filllog_model->where($where)->count(); // 查询满足要求的总记录数 $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', $header); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '共查询出%totalRow%%header% 第%nowPage%页|共%totalPage% 页 %upPage% %first% %prePage% %linkPage% %nextPage% %end% %downPage%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $logdata = $filllog_model->order('filldate desc')->where($where)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $logdata = $this->formatfield($logdata); $this->assign('logdata', $logdata); //赋值数据集 $this->assign('page', $show); //赋值分页输出 $this->display(); }
/** * 显示栏目页面 */ public function category() { // 获取用户session if (session('?user')) { $this->assign('user', session('user')); } // 获取购物车头信息session if (session('?cartInfo')) { $cartInfo = session('cartInfo'); } else { $cartInfo['totalPrice'] = 0.0; $cartInfo['totalNumber'] = 0; } $this->assign('cartInfo', $cartInfo); // 获取该栏目的子孙树,包含本栏目 $cate_id = $_GET['cate_id']; $cate = M('Category'); $cateTree = $cate->select(); $childCateTree = getChildTree($cateTree, $cate_id); $oneCate = $cate->where('id=' . $cate_id)->find(); $oneCate['level'] = 0; array_unshift($childCateTree, $oneCate); $this->assign('cateTree', $childCateTree); // 获取本栏目名称,用于导航条输出 $this->assign('oneCate', $oneCate); // 获取所有栏目 $cateList = getChildTree($cateTree, 0); foreach ($cateList as $key => $value) { $cateList[$key]['cate_name'] = str_repeat(' ', $value['level'] * 2) . $value['cate_name']; } $this->assign('cateList', $cateList); // 获取对应栏目下的所有商品并分页 $goods = M('Goods'); // 将栏目子孙树的cate_id拼接成以逗号分隔的字符串 $cateStr = ''; foreach ($childCateTree as $v) { $cateStr .= $v['id'] . ','; } $cateStr = substr($cateStr, 0, strlen($cateStr) - 1); $list = $goods->where("cate_id in ({$cateStr}) AND is_delete=0")->page($_GET['p'] . ',6')->select(); $this->assign('goodsList', $list); // 赋值数据集 import("ORG.Util.Page"); // 导入分页类 $count = $goods->where("cate_id in ({$cateStr}) AND is_delete=0")->count(); // 查询满足要求的总记录数 $page = new Page($count, 6); // 实例化分页类 传入总记录数和每页显示的记录数 $page->setConfig('header', '件商品'); // 配置分页显示输出样式 $show = $page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->display(); }
/** * 显示用户订单列表 */ public function orderlist() { // 获取用户session if (session('?user')) { $this->assign('user', session('user')); } // 获取购物车头信息session if (session('?cartInfo')) { $cartInfo = session('cartInfo'); } else { $cartInfo['totalPrice'] = 0.0; $cartInfo['totalNumber'] = 0; } $this->assign('cartInfo', $cartInfo); // 获取所有栏目 $cate = M('Category'); $cateTree = $cate->select(); $cateList = getChildTree($cateTree, 0); // 获取导航地址链 $cateParentTree = createLinkAddress($cateList, $goodsInfo['cate_id']); $this->assign('cateParentTree', $cateParentTree); foreach ($cateList as $key => $value) { $cateList[$key]['cate_name'] = str_repeat(' ', $value['level'] * 2) . $value['cate_name']; } $this->assign('cateList', $cateList); // 订单编号 $this->assign('orderIndex', ($_GET['p'] - 1) * 5 + 1); // 分页 $orderInfo = M('Order_info'); $user = session('user'); $orderList = $orderInfo->where('user_id=' . $user['id'])->page($_GET['p'] . ',5')->select(); // 处理订单字段 foreach ($orderList as $k => $v) { $orderList[$k]['add_time'] = date('Y/m/d H:i:s', $v['add_time']); if ($v['payment_method'] == 1) { $orderList[$k]['payment_method'] = '货到付款'; } else { $orderList[$k]['payment_method'] = '网上支付'; } } $this->assign('orderList', $orderList); // 赋值数据集 import("ORG.Util.Page"); // 导入分页类 $count = $orderInfo->where('user_id=' . $user['id'])->count(); // 查询满足要求的总记录数 $page = new Page($count, 5); // 实例化分页类 传入总记录数和每页显示的记录数 $page->setConfig('header', '个订单'); // 配置分页显示输出样式 $show = $page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->display('orderlist'); }
public function index() { import('ORG.Util.Page'); $m = M("User"); $count = $m->count(); // 查询满足要求的总记录数 $Page = new Page($count, 12); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('theme', '<li><a>%totalRow% %header%</a></li> <li>%upPage%</li> <li>%downPage%</li> <li>%first%</li> <li>%prePage%</li> <li>%linkPage%</li> <li>%nextPage%</li> <li>%end%</li> '); //(对thinkphp自带分页的格式进行自定义) $show = $Page->show(); // 分页显示输出 $result = $m->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign("result", $result); $this->assign("page", $show); // 赋值分页输出 $this->display(); }
/** * 管理员列表 * @author Terry <*****@*****.**> * @date 2013-01-22 */ public function pageList() { $ary_get = $this->_get(); $ary_get['pageall'] = $this->_get('pageall', 'htmlspecialchars', 10); $admin_access = D('Config')->getCfgByModule('ADMIN_ACCESS'); $admin = M("admin"); $count = $admin->join(C("DB_PREFIX") . "role ON " . C("DB_PREFIX") . "admin.role_id=" . C("DB_PREFIX") . "role.id")->where()->count(); $obj_page = new Page($count, $ary_get['pageall']); $obj_page->setConfig("header", "条"); $obj_page->setConfig('theme', '<li class="pageSelect">共%totalRow%%header% %nowPage%/%totalPage%页 %first% %upPage% %prePage% %linkPage% %nextPage% %downPage% %end%</li>'); $page = $obj_page->newshow(); $ary_data = $admin->join(C("DB_PREFIX") . "role ON " . C("DB_PREFIX") . "admin.role_id=" . C("DB_PREFIX") . "role.id")->where()->limit($obj_page->firstRow, $obj_page->listRows)->select(); $this->assign("data", $ary_data); $this->assign("admin", $admin_access); $this->assign("filter", $ary_get); // echo "<pre>";print_r($admin_access);exit; $this->assign("page", $page); $this->display(); }