public function sechWeibo()
{
$keyword = $this->_getKeyword();
if ($keyword) {
//检索含有关键字的微博
$where = array('content' => array('LIKE', '%' . $keyword . '%'));
$db = D('Weibo');
//分页
$count = M('weibo')->where($where)->count('id');
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$limit = $Page->firstRow . ',' . $Page->listRows;
$Page->setConfig('theme', "共 %TOTAL_ROW% 条记录 %FIRST% %UP_PAGE% %NOW_PAGE% / %TOTAL_PAGE% %DOWN_PAGE% %END% ");
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$weibo = $db->getAll($where, $limit);
//判断是否有内容
$this->weibo = $weibo ? $weibo : false;
//页码
$this->count = $count;
$this->page = $Page->show();
// 分页显示输出
}
$this->keyword = $keyword;
// p($result);die;
$this->display();
}
public function index()
{
$user = $this->getModel();
$count = $user->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数和每页显示的记录数(10)
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$data = $user->relation(TRUE)->limit($Page->firstRow . ',' . $Page->listRows)->select();
//设置显示方式
$Page->setConfig('prev', "上一页");
//上一页
$Page->setConfig('next', '下一页');
//下一页
$Page->setConfig('first', '首页');
//第一页
$Page->setConfig('last', "末页");
//最后一页
$Page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// 分页显示输出
$this->assign('data', $data);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display("user/list");
// 输出模板
}
public function showlist()
{
$model = new \Model\TypeModel();
//获取总记录数
$count = $model->count();
//获取页面大小
$pagesize = C('pagesize');
//实例化分页类
$page = new \Think\Page($count, $pagesize);
//设置分页样式
$page->lastSuffix = false;
//不显示末页
$page->rollPage = 3;
//一次显示三页
$page->setConfig('prev', '【上一页】');
$page->setConfig('next', '【下一页】');
$page->setConfig('first', '【首页】');
$page->setConfig('last', '【末页】');
$page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
//调用分页显示方法
$pageinfo = $page->show();
//获取页面数据
$list = $model->order('type_id desc')->limit($page->firstRow . ',' . $page->listRows)->select();
//获取当前页方便跳转
$nowpage = $page->nowPage;
//视图显示
$this->assign('list', $list);
$this->assign('pageinfo', $pageinfo);
$this->assign('nowpage', $nowpage);
$this->display();
}
public function suggest1()
{
$id = $_SESSION['home']['id'];
if (IS_POST) {
//建议表内容
$suggest = $_POST['suggest'];
$cont_info = $_POST['cont_info'];
$user_id = $id;
$cre_time = time();
//把建议内容插入到ju_suggest表中
$model = M();
$model->execute("insert into ju_suggest(`suggest`,`cont_info`,`user_id`,`cre_time`) values('{$suggest}','{$cont_info}','{$user_id}','{$cre_time}')");
}
//意见反馈的遍历
$suggest = D('suggest');
$map['user_id'] = $id;
$map['state'] = 1;
$total = $suggest->where($map)->count();
$page = new \Think\Page($total, 5);
$list = $suggest->where($map)->order('cre_time desc')->limit($page->firstRow . ',' . $page->listRows)->field('suggest,cre_time,reply')->select();
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$page->setConfig('first', '首页');
$page->setConfig('last', '尾页');
$pageButton = $page->show();
//dump($list);
$this->assign('list', $list);
$this->assign('pageButton', $pageButton);
$this->display();
}
public function search($pageSize = 20)
{
/**************************************** 搜索 ****************************************/
$where = array();
if ($level_name = I('get.level_name')) {
$where['level_name'] = array('like', "%{$level_name}%");
}
if ($bottom_num = I('get.bottom_num')) {
$where['bottom_num'] = array('eq', $bottom_num);
}
if ($top_num = I('get.top_num')) {
$where['top_num'] = array('eq', $top_num);
}
if ($rate = I('get.rate')) {
$where['rate'] = array('eq', $rate);
}
/************************************* 翻页 ****************************************/
$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()
{
$ip = $_SERVER["REMOTE_ADDR"];
$now = date("Y-m-d H:i:s", time());
$less_minute_time = date("Y-m-d H:i:s", time() - 60);
$visitor = M('Visitors');
$res = $visitor->where('ip_address="' . $ip . '" AND visit_start_at >="' . $less_minute_time . '"')->find();
if (!$res) {
$sum = M('sums');
$total = $sum->where('id=1')->getField('visitor_sum');
$visitor->add(array('ip_address' => $ip, 'visit_start_at' => $now, 'created_at' => $now));
$data['visitor_sum'] = $total + 1;
$sum->where('id=1')->save($data);
}
$article = new Article();
$count = $article->order('updated_at desc')->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 3);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$Page->setConfig('header', '页');
$Page->setConfig('prev', '');
$Page->setConfig('next', '');
$Page->setConfig('first', '>>');
$Page->setConfig('end', '<<');
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $article->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('articles', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display('index');
// 输出模板
}
/**
* @name index
* @access root
* @const 指明常量
* @module Home
* @param
* @return 渲染对应视图
* @throws
* @todo
* @var $all_log所有日志分页，$wait_user待审核用户
* @version 1.0
*/
public function index()
{
$this->init();
$all_user = $this->user->join('exam_role_user ON exam_user.id = exam_role_user.user_id')->join('exam_role ON exam_role_user.role_id = exam_role.id')->field('exam_user.id,exam_user.email,exam_user.createtime,exam_user.username,exam_role.name')->where("exam_user.status = 1 AND exam_user.username != 'root'")->select();
$this->assign('all_user', $all_user);
$all_wait_user = $this->user->where("status=0")->select();
$this->assign('wait_user', $all_wait_user);
$this->assign('goal', $goal);
// 赋值数据集
$count = $this->log->count();
// 查询满足要求的总记录数$Page
$log = new \Think\Page($count, 10);
// 实例化分页类 传入总记录数和每页显示的记录数
$log->lastSuffix = false;
$log->setConfig('prev', '上一页');
$log->setConfig('next', '下一页');
$log->setConfig('last', '末页');
$log->setConfig('first', '首页');
$log->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
$all_log = $this->log->limit($log->firstRow . ',' . $log->listRows)->select();
$this->assign('log', $all_log);
$log_show = $log->show();
// 分页显示输出
$this->assign('log_cut', $log_show);
// 赋值分页输出
$this->display('');
}
public function showlist()
{
//取出商品栏目
$cat_model = new \Model\CategoryModel();
$cat_list = $cat_model->getTree();
$this->assign('cat_list', $cat_list);
//取出商品并分页显示
$goods_model = new \Model\GoodsModel();
$pagesize = C('pagesize');
$count = $goods_model->count();
$page = new \Think\Page($count, $pagesize);
//设置分页样式
$page->lastSuffix = false;
//不显示末页
$page->rollPage = 3;
//一次显示三页
$page->setConfig('prev', '【上一页】');
$page->setConfig('next', '【下一页】');
$page->setConfig('first', '【首页】');
$page->setConfig('last', '【末页】');
$page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$pageinfo = $page->show();
//获取当前页方便跳转
$nowpage = $page->nowPage;
$goods_list = $goods_model->order('goods_id desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('goods_list', $goods_list);
$this->assign('pageinfo', $pageinfo);
$this->assign('nowpage', $nowpage);
$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 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('非法操作！');
}
}
/**
* 获取单一用户评论,并且关联商品信息
* @param string $email 邮箱
* @return array
*/
public function getUserComment($uid, $p)
{
$p *= 20;
$comment = array();
$model = M();
$sql = "select cid from comment where uid={$uid} && status=1 order by addtime asc limit {$p},20";
$sqlCount = "select count(*) from comment where uid={$uid} && status=1 order by addtime asc";
$commentId = $model->query($sql);
$countComment = $model->query($sqlCount);
$count = $countComment[0]['count(*)'];
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 20);
// 实例化分页类 传入总记录数和每页显示的记录数
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$show = $Page->show();
// 分页显示输出
if (!empty($commentId)) {
foreach ($commentId as $k => $v) {
$sql = "select goods.gid, goods.title, goods.price, goods.oldprice, goods.gimage, goods.gurl,\n\t\t\t\t\t\tcomment.cid, comment.content, comment.addtime from comment left join goods on comment.gid\n\t\t\t\t\t\t= goods.gid where cid={$v['cid']} order by comment.addtime desc";
$comArr = $model->query($sql);
$comment[] = $comArr[0];
}
}
return array($comment, $show);
}
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()
{
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 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()
{
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()
{
$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');
}
}
/**
* 系统参数列表
* @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();
}
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 projects()
{
// type=2;
$News = M('news');
// 实例化User对象
$count = $News->where('type=2')->count();
// 查询满足要求的总记录数
$page = new \Think\Page($count, 8);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$res = $News->where('type=2')->order('datetime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
for ($i = 0; $i < sizeof($res); $i++) {
$res[$i]['url'] = U('News/newsinfo', array('id' => $res[$i]['id']));
}
$page->setConfig('header', '共%TOTAL_ROW%条新闻');
$page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% 共%TOTAL_PAGE%页');
$show = $page->show();
// 分页显示输出
$this->assign('news', $res);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->display();
// 输出模板
}
public function search($pageSize = 20)
{
/**************************************** 搜索 ****************************************/
$where = array();
if ($attr_name = I('get.attr_name')) {
$where['attr_name'] = array('like', "%{$attr_name}%");
}
if ($attr_type = I('get.attr_type')) {
$where['attr_type'] = array('eq', $attr_type);
}
if ($attr_option_values = I('get.attr_option_values')) {
$where['attr_option_values'] = array('like', "%{$attr_option_values}%");
}
if ($type_id = I('get.type_id')) {
$where['type_id'] = array('eq', $type_id);
}
/************************************* 翻页 ****************************************/
$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()
{
$smsModel = D('sms');
$count = $smsModel->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 = $smsModel->getList($Page);
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 index()
{
$id = (int) I('get.id');
$cate = M('cate')->order('sort')->select();
$cids = \Admin\Common\Category::getChildsId($cate, $id);
$cids[] = $id;
$where = array('cid' => array('IN', $cids), 'del' => 0);
// 获取总文章数
$count = M('blog')->where($where)->count();
// 实例化分页类
$page = new \Think\Page($count, 5);
// 设置分页链接样式
$page->setConfig('prev', '<');
$page->setConfig('next', '>');
$limit = $page->firstRow . ',' . $page->listRows;
$cate = D('BlogView')->getAll($where, $limit);
// 显示分页
$page = $page->show();
// 解析并重新整理分页URL
$page = trimPageUrl($page);
// 转换每一篇文章video字段的HTML实体用于输出
foreach ($cate as $key => $value) {
$cate[$key]['video'] = htmlspecialchars_decode($cate[$key]['video']);
$cate[$key]['image'] = __APP__ . '/' . trim($cate[$key]['image'], '@');
}
$this->assign('cate', $cate);
$this->assign('page', $page);
$this->display();
}
public function lineAction()
{
header("Content-Type:text/html; charset=UTF-8");
$res = $this->achievementAction(10000);
$rebate = D('Rebate');
$key = 1;
$res = $rebate->init($key);
$Page = new \Think\Page(count($res), 10);
// 实例化分页类 传入总记录数和每页显示的
$Page->setConfig('theme', '%FIRST% %UP_PAGE% %HEADER% %DOWN_PAGE% %END%');
$Page->setConfig('header', '<span class="rows">共 %TOTAL_ROW% 个返点</span>%LINK_PAGE%<span class="currentrows">当前第 %NOW_PAGE% 页</span>');
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
foreach ($res as $key => $value) {
$res[$key]['actionUrl']['edit'] = U('Rebate/Edit/line?id=' . $value['id']);
$res[$key]['actionUrl']['delete'] = U('Rebate/Delete/line?id=' . $value['id']);
}
$this->assign('rebate', $res);
$this->assign('urlAdd', U('Rebate/Add/line'));
$TPL = T('Rebate@Index/index');
$this->assign('YZRight', $this->fetch($TPl));
$this->display(YZ_TEMPLATE);
}
/**
* 视图：用户列表
*/
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 index()
{
$keyword = I('words');
//获取分类的英文名称
$key = I('get.order');
$sort = I('get.sort');
if (isset($key)) {
if ($key == "1") {
$listsort = "view" . " " . $sort;
}
if ($key == "2") {
$listsort = "id" . " " . $sort;
}
if ($key == "3") {
$listsort = "price" . " " . $sort;
}
if ($key == "4") {
$listsort = "sale" . " " . $sort;
}
}
if (empty($key)) {
$key = "1";
$see = "asc";
$order = "view";
$sort = "asc";
$listsort = $order . " " . $sort;
}
if ($sort == "asc") {
$see = "desc";
}
if ($sort == "desc") {
$see = "asc";
}
$this->assign('see', $see);
$this->assign('order', $key);
$this->assign('value', $sort);
$map['title|name|description'] = array('like', '%' . $keyword . '%');
$count = M('Document')->where($map)->count();
$Page = new \Think\Page($count, 12);
$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();
$field = "id,title,price,tuan_price,qg_price,ms_price,brand,fengmian";
$list = M('Document')->where($map)->field($field)->order($listsort)->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show);
$this->assign('searchlist', $list);
$this->assign('keyword', $keyword);
/* 热词调用*/
$hotsearch = C('HOT_SEARCH');
$this->assign('hotsearch', $hotsearch);
$this->meta_title = $keyword . '的搜索结果';
$this->display();
}
function PAGE($count, $pageNum = 12)
{
$Page = new \Think\Page($count, $pageNum);
// 实例化分页类 传入总记录数和每页显示的记录数
$Page->setConfig('prev', '上一页');
$Page->setConfig('next', '下一页');
$Page->setConfig('theme', "%UP_PAGE%%LINK_PAGE%%DOWN_PAGE%");
return $Page;
}
function getPage($table, $eachNum, $where)
{
$count = $table->where($where)->count();
$page = new \Think\Page($count, $eachNum);
$page->setConfig('prev', 'prev');
$page->setConfig('next', 'next');
$page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
return $page;
}
/**
*视图： 评论列表
**/
public function index()
{
$map = array();
$content = $article_id = $created_at_start = $created_at_end = '';
$content = $_GET['content'];
if ($content != null) {
$map['content'] = array('like', "%{$content}%");
}
$article_id = $_GET['article_id'];
if ($article_id != null) {
$map['article_id'] = array('eq', $article_id);
}
$created_at_start = $_GET['created_at_start'];
if ($created_at_start != null) {
$map['created_at'] = array('egt', $created_at_start);
}
$created_at_end = $_GET['created_at_end'];
if ($created_at_end != null) {
$map['created_at'] = array('elt', $created_at_end);
}
if ($created_at_start != null && $created_at_end != null) {
$map['created_at'] = array('between', array($created_at_start, $created_at_end));
}
$this->assign('content', $content);
$this->assign('article_id', $article_id);
$this->assign('created_at_start', $created_at_start);
$this->assign('created_at_end', $created_at_end);
//所有文章
$mod = M('articles');
$articles = $mod->order('updated_at desc')->select();
$articleArr = array();
foreach ($articles as $article) {
$articleArr[$article['article_id']] = $article['title'];
}
$comments = new Comment();
$count = $comments->where($map)->order('updated_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 = $comments->where($map)->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('comments', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->assign('articleArr', $articleArr);
$this->display('index');
// 输出模板
}
public function index()
{
$map = array();
$title = $author = $case_type = $updated_at_start = $updated_at_end = '';
$title = $_GET['title'];
if ($title != null) {
$map['title'] = array('like', "%{$title}%");
}
$author = $_GET['author'];
if ($author != null) {
$map['author'] = array('like', "%{$author}%");
}
$case_type = $_GET['case_type'];
if ($case_type != null) {
$map['case_type'] = array('eq', $case_type);
}
$updated_at_start = $_GET['updated_at_start'];
if ($updated_at_start != null) {
$map['updated_at'] = array('egt', $updated_at_start);
}
$updated_at_end = $_GET['updated_at_end'];
if ($updated_at_end != null) {
$map['updated_at'] = array('elt', $updated_at_end);
}
if ($updated_at_start != null && $updated_at_end != null) {
$map['updated_at'] = array('between', array($updated_at_start, $updated_at_end));
}
$this->assign('title', $title);
$this->assign('author', $author);
$this->assign('case_type', $case_type);
$this->assign('updated_at_start', $updated_at_start);
$this->assign('updated_at_end', $updated_at_end);
$case = M('Cases');
$count = $case->where($map)->order('updated_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 = $case->where($map)->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('cases', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
$this->assign('case_types', getCaseType());
$this->display('index');
// 输出模板
}
/**
* 获取显示页
*/
public function show($count)
{
// 查询满足要求的总记录数
$page = new \Think\Page($count, 8);
// 每页八条记录
$page->setConfig('header', '个会员');
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$show = $page->show();
return $show;
}
