public function menu_index() { $AuthRule = D("AuthRule"); if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $menuList = $AuthRule->order("concat(path,id)")->page($_GET['p'] . ",{$pageNumer}")->select(); //菜单成绩关系 // 进行分页数据查询 注意page方法的参数的前面部分是当前的页数使用 $_GET[p]获取 $this->assign('list', $menuList); // 赋值数据集 $count = $AuthRule->where()->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "菜单列表"); $this->assign("menuList", $menuList); $this->assign("title", "开心蛙后台管理-菜单查看"); $this->display(); }
public function index() { if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $dataList = $this->table->page($_GET['p'] . ",{$pageNumer}")->select(); $typeList = $this->goods_type->select(); $map['status'] = array("eq", 2); $faceList = $this->goods_face->where($map)->select(); //查出商品主图 $tlist = array(); $flist = array(); foreach ($typeList as $list) { $tlist[$list['id']] = $list; } foreach ($faceList as $list) { $flist[$list['gid']] = $list; } $count = $this->table->where()->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "商品列表"); $this->assign("dataList", $dataList); $this->assign("typeList", $tlist); $this->assign("faceList", $flist); $this->assign("title", "开心蛙后台管理-商品列表"); $this->display(); }
public function index() { if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $dataList = $this->table->page($_GET['p'] . ",{$pageNumer}")->select(); $count = $this->table->where()->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "商品分类"); $this->assign("dataList", $dataList); $this->assign("title", "开心蛙后台管理-商品分类"); $this->display(); }
public function index() { $model = M(); $GroupAccess = D('GroupAccess'); if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $news = $model->table("__GROUP_ACCESS__ AS ga,__MEMBER__ AS m,__GROUP__ AS g")->where("ga.uid=m.id AND ga.group_id=g.id")->field("ga.id,ga.uid,m.admin_name,m.status,g.title")->page($_GET['p'] . ",{$pageNumer}")->select(); $count = $GroupAccess->where()->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("news", $news); $this->display(); }
public function index() { if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $dataList = M()->table("kxw_orders as o,kxw_users as u")->where("o.uid = u.id")->field("o.*,u.telephone")->page($_GET['p'] . ",{$pageNumer}")->select(); $count = M()->table("kxw_orders as o,kxw_users as u")->where("o.uid = u.id")->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "订单列表"); $this->assign("dataList", $dataList); $this->assign("typeList", $tlist); $this->assign("title", "开心蛙后台管理-订单列表"); $this->display(); }
public function index() { if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 // $dataList = $this->table->page($_GET['p'].",{$pageNumer}")->select(); $dataList = M()->table("kxw_users as u,kxw_user_info as us,kxw_beancount as b")->where("u.id = us.uid AND u.id = b.uid")->field("u.id,u.telephone,u.email,u.user_type,u.client_type,u.create_time,u.login_time,us.user_name,b.amount")->page($_GET['p'] . ",{$pageNumer}")->select(); $count = M()->table("kxw_users as u,kxw_user_info as us,kxw_beancount as b")->where("u.id = us.uid AND u.id = b.uid")->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "会员列表"); $this->assign("dataList", $dataList); $this->assign("title", "开心蛙后台管理-会员列表"); $this->display(); }
public function index() { if (!$_GET['p']) { $_GET['p'] = 1; } $pageNumer = C("PAGE_NUMBER"); //分页配置大小 $dataList = $this->room->join("LEFT JOIN kxw_room_type ON kxw_room.roomtypeid = kxw_room_type.id")->field("kxw_room.*,kxw_room_type.type_name as roomtypename")->order("kxw_room.listorder DESC,kxw_room.id DESC")->page($_GET['p'] . ",{$pageNumer}")->select(); $this->assign('list', $dataList); // 赋值数据集 $count = $this->room->join("LEFT JOIN kxw_room_type ON kxw_room.roomtypeid = kxw_room_type.id")->count(); // 查询满足要求的总记录数 $Page = pageConfig($count, $pageNumer); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 $this->assign("total", $count); $this->assign("header", "视频列表"); $this->assign("dataList", $dataList); $this->assign("title", "开心蛙后台管理-视频列表查看"); $this->display(); }