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();
}
