public function admin_list()
{
$admin = M('admin');
$val = I('val');
$auth = new Auth();
$this->assign('testval', $val);
if ($val) {
$map['admin_username'] = array('like', "%" . $val . "%");
}
$count = $admin->where($map)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, C('DB_PAGENUM'));
// 实例化分页类 传入总记录数和每页显示的记录数
foreach ($map as $key => $val) {
$Page->parameter[$key] = urlencode($val);
}
$show = $Page->show();
// 分页显示输出
$admin_list = $admin->where($map)->order('admin_id')->limit($Page->firstRow . ',' . $Page->listRows)->select();
foreach ($admin_list as $k => $v) {
$group = $auth->getGroups($v['admin_id']);
$admin_list[$k]['group'] = $group[0]['title'];
}
$this->assign('admin_list', $admin_list);
$this->assign('page', $show);
$this->display();
}
/**
* 友情链接列表
* @date: 2016-2-4 上午07:21:35
* @author: zhouqg
* @param: variable
* @return:
*/
public function index()
{
// 搜索功能
$keyword = I('post.keyword');
if (!empty($keyword)) {
$where['link_name'] = array('like', "%{$keyword}%");
$this->assign('keyword', $keyword);
}
$m = D('Link');
$order = 'link_sort,link_addtime desc';
$result = $m->where($where)->select();
//分页
$count = count($result);
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 15);
// 实例化分页类 传入总记录数和每页显示的记录数(20)
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
$this->assign('count', $count);
// 赋值分页输出
$result = $m->where($where)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('vlist', $result);
//赋值
$this->display();
}
public function showlist()
{
header("Content-Type:text/html; charset=utf-8");
$Goods = M('Goods');
// 实例化User对象
$count = $Goods->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数和每页显示的记录数(5)
$Page->setConfig('header', '共%TOTAL_ROW%条');
$Page->setConfig('first', '首页');
$Page->setConfig('last', '共%TOTAL_PAGE%页');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('link', 'indexpagenumb');
//pagenumb 会替换成页码
$Page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $Goods->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('info', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display();
// 输出模板
}
public function search($pageSize = 20)
{
/**************************************** 搜索 ****************************************/
$where = array();
if ($brand_name = I('get.brand_name')) {
$where['brand_name'] = array('like', "%{$brand_name}%");
}
if ($site_url = I('get.site_url')) {
$where['site_url'] = array('like', "%{$site_url}%");
}
if ($goods_desc = I('get.goods_desc')) {
$where['goods_desc'] = array('eq', $goods_desc);
}
if ($sort = I('get.sort')) {
$where['sort'] = array('eq', $sort);
}
if ($is_show = I('get.is_show')) {
$where['is_show'] = array('eq', $is_show);
}
/************************************* 翻页 ****************************************/
$count = $this->alias('a')->where($where)->count();
$page = new \Think\Page($count, $pageSize);
// 配置翻页的样式
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$data['page'] = $page->show();
/************************************** 取数据 ******************************************/
$data['data'] = $this->alias('a')->where($where)->group('a.id')->limit($page->firstRow . ',' . $page->listRows)->select();
return $data;
}
public function index()
{
//实例化user模型
$user = D('Common/User');
//接收参数
$mobile = I('mobile');
$username = I('username');
$page = I('p') ?: 1;
$where = array();
if (!empty($mobile)) {
$where['tel'] = array('like', $mobile);
}
if (!empty($username)) {
$where['name'] = array('like', $username);
}
//数据查询
$limit = 10;
$offset = ($page - 1) * $limit;
$user_list = $user->user_lists('', $limit, $offset, $where);
$all_count = $user->user_count();
//构造分页
$page = new \Think\Page($all_count, $limit);
$page_str = $page->show();
$this->assign('user_list', $user_list);
$this->assign('page', $page_str);
$this->display();
}
/**
*
*/
public function queryView($map = null, $page = array('curpage' => 0, 'size' => 10), $order = false, $params = false, $fields = false)
{
$query = $this->model;
if (!is_null($map)) {
$query = $query->where($map);
}
if (!($order === false)) {
$query = $query->order($order);
}
if (!($fields === false)) {
$query = $query->field($fields);
}
$list = $query->page($page['curpage'] . ',' . $page['size'])->alias('a')->join('common_member b on a.uid=b.uid')->join('itboye_mgroup c on a.groupid=c.id')->field('a.id id,b.nickname nickname,c.name,c.discount_ratio,c.commission_ratio,a.createtime')->select();
if ($list === false) {
$error = $this->model->getDbError();
return $this->apiReturnErr($error);
}
$count = $this->model->where($map)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, $page['size']);
//分页跳转的时候保证查询条件
if ($params !== false) {
foreach ($params as $key => $val) {
$Page->parameter[$key] = urlencode($val);
}
}
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $Page->show();
return $this->apiReturnSuc(array("show" => $show, "list" => $list));
}
public function index(){
$id = I('get.id');
//$list=M('article')->where(array('cid'=>$id))->limit()->select();
$Blog=M('article');
$count = $Blog->count();
$Page =new \Think\Page($count,C('LISTPAGESIZE'));
$list=$Blog->where(array('cid'=>$id))->limit($Page->firstRow.','.$Page->listRows)->select();
$show = $Page->show();
$this->assign('page',$show);
$field= array('cname');
$cate=M('category')->field($field)->find($id);
$this->cate=$cate;
$this->list=$list;
//S('List',$list,10);
$this->display('/list');
}
/**
* history()
* 打印店历史文件列表
* @param $pri_id
*/
public function history()
{
$pid = pri_id(U('Index/index'));
if ($pid) {
$condition['pri_id'] = $pid;
$status = 5;
$condition['status'] = $status;
$this->assign('history', true);
$this->title = '已打印文件历史记录';
$File = D('FileView');
$count = $File->where($condition)->count();
$Page = new \Think\Page($count, 10);
$show = $Page->show();
$ppt_layout = C('PPT_LAYOUT');
$result = $File->where($condition)->order('file.id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
//cache($cache_key, 10)->select();
foreach ($result as &$file) {
$file['ppt_layout'] = $ppt_layout[$file['ppt_layout']];
}
unset($file);
$this->data = $result;
$this->assign('page', $show);
$this->display();
} else {
$this->redirect('Printer/Index/index');
}
}
public function index()
{
$name = session('nickname');
if (empty($name)) {
header("Location:/TP/index.php/login");
exit;
} else {
$user = M("user");
$map['nickname'] = array('neq', $name);
$count = $user->where($map)->count();
//echo $count;
$page = new \Think\Page($count, 5);
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$page->setConfig('last', '末页');
$page->setConfig('first', '首页');
$page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% 第 ' . I('p', 1) . ' 页/共 %TOTAL_PAGE% 页 (5位/页)');
$show = $page->show();
$list = $user->where($map)->order('id desc')->limit($page->firstRow . ',' . $page->listRows)->select();
//var_dump($list);
$this->assign('list', $list);
$this->assign('page', $show);
$this->display('./Application/home/view/addfriend.html');
}
}
public function index()
{
//dump($_SESSION);
//实例化对象
$user = M('user');
//获得用户的信息
$username = I('username');
//判断是否提交了搜索
if ($_POST) {
$_GET['p'] = 1;
}
if (isset($_SESSION['help']['fk'])) {
$_GET['p'] = 1;
unset($_SESSION['help']['fk']);
}
$args['username'] = $username;
//模糊查询
$map['username'] = array("LIKE", "%{$username}%");
//获得满足条件的总记录数
$count = $user->where($map)->count();
//实例化分页类,传入总条数、每页显示条数
$Page = new \Think\Page($count, 3, $args);
//查询用户信息
$data = $user->field('id,username,password,auth,status,regtime')->where($map)->limit("{$Page->firstRow},{$Page->listRows}")->order("id asc")->select();
//显示分页
$show = $Page->show();
//分配数据
$this->assign('Page', $show);
$this->assign('users', $data);
$this->display();
}
public function index()
{
//初始化参数
$where = '';
//接收搜索框传值
$username = I('get.username');
//如果不为空则设置查询条件
if (!empty($username)) {
$where['username'] = array('like', '%' . $username . '%');
}
//创建连接数据库对象
$user = M('users');
//统计总记录数
$count = $user->where($where)->count();
//创建分页对象
$pages = new \Think\Page($count, 10);
//获取页码
$page = $pages->show();
//获取limit参数
$limit = $pages->firstRow . ',' . $pages->listRows;
//读数据
$users = $user->limit($limit)->where($where)->order('id ASC')->select();
//分配变量
$this->assign('users', $users);
$this->assign('page', $page);
$this->assign('username', $username);
//解析模版
$this->display();
}
public function index()
{
check_login();
$NODE_URL = U("Comment/index");
$this->assign("NODE_URL", $NODE_URL);
$NODE_URL = U("Comment/node_add");
$this->assign("node_add", $NODE_URL);
$M_shop = M("scomment");
$count = $M_shop->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
$Page->setConfig('header', '共 <span style="font-weight:bold;color:#FF6600;"> %TOTAL_ROW% </span>条记录');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('prev', '上一页');
$Page->setConfig('theme', '%HEADER% <span style="font-weight:bold;color:blue;">%NOW_PAGE%</span>/<span style="font-weight:bold;">%TOTAL_PAGE%</span>页 %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $M_shop->order('comment_id')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display();
}
public function index()
{
/** ！控制器必须 **/
/* 热词调用*/
$hotsearch = R("Index/getHotsearch");
$this->assign('hotsearch', $hotsearch);
/** * 控制器必须！**/
$tuan = M("tuan");
$category = $tuan->order("id")->select();
//团购分类
$this->assign('category', $category);
// 赋值数据集
/* 获取商品*/
$User = M("tuanid");
$count = M('tuanid')->count();
$Page = new \Think\Page($count, 10);
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('first', '第一页');
$Page->setConfig('last', '尾页');
$Page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
$show = $Page->show();
$list = $User->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出 $this->display();
$this->display();
}
public function shop_edit()
{
check_login();
$edit_id = I('get.edit_id', '', 'number_int');
if ($edit_id) {
$NODE_URL = U("Menu/dish_add?add_id=" . $edit_id);
$this->assign("ADD_URL", $NODE_URL);
$shop_thing = M('shop')->where('shop_id=' . $edit_id)->find();
$this->assign("shop_thing", $shop_thing);
$M_shop = M("dish");
$count = $M_shop->where('shop_id=' . $edit_id)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
$Page->setConfig('header', '共 <span style="font-weight:bold;color:#FF6600;"> %TOTAL_ROW% </span>条记录');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('prev', '上一页');
$Page->setConfig('theme', '%HEADER% <span style="font-weight:bold;color:blue;">%NOW_PAGE%</span>/<span style="font-weight:bold;">%TOTAL_PAGE%</span>页 %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $M_shop->where('shop_id=' . $edit_id)->order('dish_id')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display('shop');
} else {
$this->error('非法操作！');
}
}
public function comment()
{
$postId = I("get.postId", 0, 'intval');
if (!$postId) {
$this->error("no id");
}
if (isset($_GET['content'])) {
$where['content'] = array('like', "%{$_GET['content']}%");
$this->assign('user_name', $_GET['content']);
}
$where['post_id'] = $postId;
$info = $this->postModel->find($postId);
$postInfo = $this->commentModel->where($where)->count();
$Page = new \Think\Page($postInfo[0]['total'], 8);
$Page->lastSuffix = false;
$Page->setConfig('header', '共%TOTAL_ROW%条');
$Page->setConfig('first', '首页');
$Page->setConfig('last', '共%TOTAL_PAGE%页');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$list = $this->commentModel->where($where)->relation("user")->limit($Page->firstRow, $Page->listRows)->select();
$this->assign('empty', '<tr class="text-center">没有评价数据</tr>');
$this->assign('list', $list);
// 赋值数据集
$show = $Page->show();
$this->assign('page', $show);
// 赋值分页输出
$this->assign("info", $info);
$this->assign("post", 1);
$this->display();
}
/**
* 信息审核页面
*/
public function index()
{
$searchName = I('search');
if ($searchName !== "") {
//按nickname查询
$where['check_state'] = 0;
$where['pro_name'] = array('like', '%' . $searchName . '%');
$count = M('product_list')->where($where)->count();
$Page = new \Think\Page($count, 10);
// 实例化分页类
$show = $Page->show();
// 分页显示输出
$list = M('product_list')->limit($Page->firstRow . ',' . $Page->listRows)->where($where)->select();
} else {
$count = M('product_list')->where('check_state = 0')->count();
$Page = new \Think\Page($count, 10);
// 实例化分页类
$show = $Page->show();
// 分页显示输出
$list = D('product_list')->where('check_state = 0')->limit($Page->firstRow . ',' . $Page->listRows)->select();
}
$this->assign('list', getList($list));
// 赋值数据集
$this->assign('show', $show);
// 赋值分页输出
$this->display();
}
public function orderList()
{
$Data = M('Company_order');
$opt = I('post.');
$city = session($this->_userCfg['CITY']);
if ($city != '') {
$opt['city'] = $city;
}
$count = $Data->where($opt)->count();
// 查询满足要求的总记录数 $map表示查询条件
$page = new \Think\Page($count, 15);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$order = $Data->where($opt)->order('addTime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
if ($order) {
for ($i = 0; $i < count($order); $i++) {
$order[$i]['payType'] = $this->getPayType($order[$i]['payType']);
$order[$i]['paySign'] = $this->getPaySign($order[$i]['payTime']);
$order[$i]['wlSign'] = $this->getWlSign($order[$i]['sign']);
$order[$i]['userInfo'] = unserialize($order[$i]['address']);
}
}
$this->assign('page', $show);
// 赋值分页输出
$this->assign('order', $order);
$this->assign('params', $opt);
$this->display();
}
public function index()
{
//遍历循环搜索条件
foreach ($_GET as $k => $v) {
if ($v) {
$map[$k] = $v;
}
}
unset($map['p']);
$attrvalue = M("attrvalue");
$count = $attrvalue->where($map)->count();
//查询数据总条数
$data = $attrvalue->where($map)->order("sort ASC")->page($_GET['p'], 10)->select();
//获取属性数据
$Page = new \Think\Page($count, 10, $map);
//给分页类传入搜索条件，维持搜索
$show = $Page->show();
//分页显示输出
/* //获取商品类型
$types = M("type") -> field('id,name,pid') -> select();
$types = getList($types);
foreach($types as $v){
$type[$v['id']] = $v['name'];//定义数组存放类型，键为ID，值为类名
} */
$this->assign('map', $map);
$this->assign('page', $show);
//$this -> assign('types',$types);
//$this -> assign('type',$type);
$this->assign('attrvalues', $data);
$this->display();
}
public function index()
{
$user = session('auth_manager_shop');
//载入分类
$catelist = D('GoodsCate')->get_cate_list(0);
$this->assign('catelist', $catelist);
//当前分类id
$_GET['cate_id'] = $_GET['cate_id'] ? $_GET['cate_id'] : 0;
$this->assign('cate_id', $_GET['cate_id']);
$ids = D('GoodsCate')->get_child_ids($_GET['cate_id']);
//分页
$Goods = M('Goods');
$where['pid'] = array('in', $ids);
$where['sid'] = $user['shopid'];
$count = $Goods->where($where)->count();
$Page = new \Think\Page($count, 30);
$show = $Page->show();
//主数据
$alist = $Goods->where($where)->field(true)->order('id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
foreach ($alist as &$v) {
$v['mainpic'] = json_decode($v['mainpic'], true)[1];
}
$this->assign('alist', $alist);
$this->assign('pages', $show);
$this->display();
}
public function lst()
{
//实例化模型
$brandModel = D('brand');
/*****************设置数字签名*****************/
//1 设置数字签名,加盐拼接id
$md5String = md5(C('SALT'));
/*****************分页功能*****************/
//1 获取记录总数
$count = $brandModel->count();
//2 获取每页显示的数量
$pageNum = C('PAGE_NUMBER');
//3 实例化分页类
$Page = new \Think\Page($count, $pageNum);
//4 获取分页栏
$show = $Page->show();
//5 分页数据的获取
$data = $brandModel->limit($Page->firstRow . ',' . $Page->listRows)->select();
/*****************分配数据，显示模板*****************/
$this->assign('data', $data);
$this->assign('show', $show);
$this->assign('md5String', $md5String);
//分配数字签名
$this->display('brand_list');
}
public function getSon()
{
$id = $_GET['id'];
$son = M('category');
$total = $son->where('form_id=' . $id)->count();
$page = new \Think\Page($total, 5);
$button = $page->show();
$sonlist = $son->where('form_id=' . $id)->limit($page->firstRow . ',' . $page->listRows)->select();
$parent = $son->where('id=' . $sonlist[0]['form_id'])->select();
$this->assign('page', $button);
foreach ($sonlist as &$val) {
if ($val['display'] == 1) {
$val['display'] = '已启用';
} elseif ($val['display'] == 0) {
$val['display'] = '已禁用';
}
if ($val['path'] == '0,') {
$val['gpath'] = $val['path'];
$val['path'] = '根目录';
} else {
$val['gpath'] = $val['path'];
$val['path'] = "/{$parent[0]['name']}/{$val['name']}";
}
}
$this->assign('list', $sonlist);
$this->display('categorylist');
}
public function index()
{
if (!empty($_GET['name'])) {
$map['lesson'] = array('like', "%{$_GET['name']}%");
}
//if(strlen($_GET['sex'] ) > 0) $map['sex'] = $_GET['sex'];
$lesson = D('Lesson');
$total = $lesson->where($map)->count();
$page = new \Think\Page($total, 5);
$lesson_list = $lesson->where($map)->limit($page->firstRow . ',' . $page->listRows)->getAll();
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$page->setConfig('first', '首页');
$page->setConfig('last', '尾页');
$pageButton = $page->show();
$this->assign('list', $lesson_list);
$this->assign('pageButton', $pageButton);
// 计划开始
$Plan = D('Plan');
$pl_list = $Plan->where('pid=0')->select();
$this->assign('pl_list', $pl_list);
// 分享开始
$Share = D('Share');
$sh_list = $Share->select();
$this->assign('sh_list', $sh_list);
$this->display();
}
public function index()
{
//取出用户信息
$User = D('UserRelation');
$searchName = I('search');
if ($searchName !== "") {
$count = $User->field('password', true)->relation(true)->where(array('user_name' => $searchName))->count();
$Page = new \Think\Page($count, 7);
// 实例化分页类
$list = $User->field('password', true)->relation(true)->limit($Page->firstRow . ',' . $Page->listRows)->where(array('user_name' => $searchName))->select();
} else {
$count = $User->field('password', true)->relation(true)->count();
$Page = new \Think\Page($count, 7);
// 实例化分页类
$list = $User->field('password', true)->relation(true)->limit($Page->firstRow . ',' . $Page->listRows)->select();
}
$show = $Page->show();
// 分页显示输出
$this->assign('user', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
//取出与用户有关的部门信息和职位信息
$apart = M('apart_user')->select();
$level = M('level_user')->select();
$this->assign('apart', $apart);
$this->assign('level', $level);
$this->display();
}
public function index()
{
$map = array();
$parameter = array();
if (!empty($_REQUEST['brand'])) {
$map['brandtitle'] = array('like', '%' . $_REQUEST['brand'] . '%');
$parameter['brand'] = $_REQUEST['brand'];
}
if (!empty($_REQUEST['series'])) {
$map['seriestitle'] = array('like', '%' . $_REQUEST['series'] . '%');
$parameter['series'] = $_REQUEST['series'];
}
if (!empty($_REQUEST['keywords'])) {
$map['title'] = array('like', '%' . $_REQUEST['keywords'] . '%');
$parameter['title'] = $_REQUEST['keywords'];
}
$model = D('CarClassView');
$count = $model->where($map)->count();
$page = new \Think\Page($count, 15);
$page->parameter = array_merge($parameter, $page->parameter);
$show = $page->show();
$list = $model->where($map)->order('sort desc')->limit($page->firstRow . ',' . $page->listRows)->select();
cookie('_currentUrl_', __SELF__);
$this->assign(array('list' => $list, 'page' => $show));
$this->display();
}
/**
* 视图：用户列表
*/
public function index()
{
$visitors = M('Visitors');
$count = $visitors->order('created_at desc')->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$Page->setConfig('header', '页');
$Page->setConfig('prev', '');
$Page->setConfig('next', '');
$Page->setConfig('first', '>>');
$Page->setConfig('end', '<<');
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $visitors->order('created_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
//访问总次数
$sum = M('sums');
$total = $sum->where('id=1')->getField('visitor_sum');
$this->assign('visitors', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->assign('sum', $total);
$this->display('index');
// 输出模板
}
public function join()
{
$this->title = '我参与的';
$this->user = M('user')->find($this->user_id);
$page = I('request.p', 1);
$page = $page < 1 ? 1 : $page;
$list = M('hongbao_order')->where(array('user_id' => $this->user_id))->page($page, 10)->order("id DESC")->select();
if ($list) {
foreach ($list as $i => $item) {
$list[$i]['hongbao'] = M('hongbao')->find($item['hongbao_id']);
$list[$i]['user'] = M('user')->find($list[$i]['hongbao']['user_id']);
}
}
$total = M('hongbao_order')->where(array('user_id' => $this->user_id))->count();
$this->list = $list;
$Page = new \Think\Page($total, 10);
// 实例化分页类 传入总记录数和每页显示的记录数(20)
$Page->rollPage = 5;
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('theme', '%UP_PAGE% %DOWN_PAGE% <li ><a>共 %TOTAL_ROW% 条记录</a></li>');
$show = $Page->show();
$this->page = $show;
$this->display();
}
/**
* 广告列表
*
*/
public function index()
{
if (IS_POST) {
$title = I('post.search_text');
if ($title) {
$condition['name'] = array('like', '%' . $title . '%');
}
}
$advertModel = D('Advert');
$count = $advertModel->where($condition)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 15);
// 实例化分页类 传入总记录数和每页显示的记录数
$Page->setConfig('header', '条记录');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('theme', "%UP_PAGE% %FIRST% %LINK_PAGE% %DOWN_PAGE% %END% <span>共%TOTAL_ROW% %HEADER% %NOW_PAGE%/%TOTAL_PAGE% 页</span>");
$show = $Page->show();
// 分页显示输出
$data = $advertModel->getList($Page, $condition);
foreach ($data as $k => $v) {
if ($v['status'] == 20) {
$data[$k][status] = '启用';
} else {
$data[$k][status] = '禁用';
}
}
$this->assign('data', $data);
$this->assign('page', $show);
$this->assign('title', '广告列表');
$this->display();
}
public function adList()
{
$m = M('Company_ad');
if (session($this->_userCfg['ECID']) != '816') {
$opt['ecid'] = session($this->_userCfg['ECID']);
} else {
$admin = session($this->_userCfg['ECID']);
}
if (I('post.ecid') != '' && I('post.ecid') != '-1') {
$opt['ecid'] = I('post.ecid');
}
if (I('post.id') != '' && I('post.id') != "-1") {
$opt['id'] = I('post.id');
}
$count = $m->where($opt)->count();
// 查询满足要求的总记录数 $map表示查询条件
$page = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
$result = $m->where($opt)->order('modifyTime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('admin', $admin);
$this->assign('adInfo', $result);
$this->assign('page', $show);
// 赋值分页输出
$this->display();
}
public function index()
{
$opus = D('Opus');
//实例化问题表
$user = D('User');
//实例化用户表
//dump(I('get.'));
/*姓名判断*/
if (I('get.user')) {
$name = I('get.user');
$map['name'] = array('exp', "like '%{$name}%' ");
$ulist = $user->where($map)->select();
$name = '';
foreach ($ulist as $key => $value) {
$name[$key] = $value['id'];
}
$where = join(" or 'user_id' = ", $name);
$map['user_id'] = $where;
unset($map['name']);
}
/*标题判断*/
if (I('get.title')) {
$title = I('get.title');
$map['ques'] = array('exp', "like '%{$title}%' ");
}
$total = $opus->where($map)->count();
$page = new \Think\Page($total, 8);
$oplist = $opus->where($map)->limit($page->firstRow . ',' . $page->listRows)->getOpus();
$pageButton = $page->show();
//dump($oplist);
$this->assign('list', $oplist);
$this->assign('pageButton', $pageButton);
$this->display();
}
/**
* 系统参数列表
* @author copoet
*/
public function index()
{
if (IS_POST) {
$title = I('post.search_text');
if ($title) {
$condition['id|sys_explain|sys_name'] = array('like', '%' . $title . '%');
}
}
$systemModel = D('system');
$count = $systemModel->where($condition)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 20);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$Page->setConfig('header', '条记录');
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('theme', "%UP_PAGE% %FIRST% %LINK_PAGE% %DOWN_PAGE% %END% <span>共%TOTAL_ROW% %HEADER% %NOW_PAGE%/%TOTAL_PAGE% 页</span>");
$show = $Page->show();
// 分页显示输出
$data = $systemModel->getList($Page, $condition);
$this->assign('data', $data);
$this->assign('page', $show);
// 赋值分页输
$this->assign('title', '系统参数列表');
$this->display();
}
