public function index() { $news = D('News'); $where['belong'] = I("get.type"); $count = $news->where($where)->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $news_list = $news->where($where)->order('belong asc,sort desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($news_list as $k => $v) { $news_list[$k]['add_time'] = date('Y-m-d H:i:s', $v['add_time']); switch ($v['belong']) { case 1: $news_list[$k]['belong'] = '新闻资讯'; break; case 2: $news_list[$k]['belong'] = '月嫂新闻'; break; case 3: $news_list[$k]['belong'] = '育儿嫂新闻'; break; case 4: $news_list[$k]['belong'] = '保姆新闻'; break; // case 5: // $news_list[$k]['belong']='月嫂新闻4'; // break; } } $this->assign('news_list', $news_list); $this->assign('page', $show); $this->display('News/list'); }
public function index() { $where = '1'; if ($_GET['k']) { addslashes($_GET['k']); $where = 'phone LIKE "%' . $_GET['k'] . '%" OR buyer_email LIKE "%' . $_GET['k'] . '%" OR buy_name LIKE "%' . $_GET['k'] . '%" '; } $count = M('n_alipay_info')->where($where)->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $alipay_list = M('n_alipay_info')->where($where)->order('trade_status_number desc,order_status asc,add_time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $success_stauts = ['TRADE_FINISHED', 'TRADE_SUCCESS']; foreach ($alipay_list as $k => $v) { $alipay_list[$k]['add_time'] = date('Y-m-d H:i:s', $v['add_time']); $alipay_list[$k]['order_status_name'] = $v['order_status'] == 1 ? '<span style="color: #0000cc">已处理</span>' : '<span style="color: red">未处理</span>'; $alipay_list[$k]['trade_status_name'] = in_array($v['trade_status'], $success_stauts) ? '<span style="color: #0000cc">已付款</span>' : '<span style="color: red">未付款</span>'; } $this->assign('alipay_list', $alipay_list); $trade_status_number = M('n_alipay_info')->where('trade_status_number=1')->count('distinct phone'); $sub_total_fee = M('n_alipay_info')->where('trade_status_number=1')->sum('total_fee_real'); $this->assign('trade_status_number', $trade_status_number); $this->assign('sub_total_fee', $sub_total_fee); $this->assign('page', $show); $this->display('payList'); }
public function index() { $Nurse = D('Nurse'); $count = $Nurse->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $nurse_list = $Nurse->order('is_recommend desc,sort desc,recommend_time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($nurse_list as $k => $v) { $nurse_list[$k]['age'] = date('Y', time()) - date('Y', strtotime($v['age'])); } $this->assign('nurse_list', $nurse_list); $this->assign('page', $show); $this->display('Confinement/list'); }
public function video_list() { if (!$_SESSION[C('VIDEO_AUTH_KEY')]['id']) { echo "<script>alert('请登录!');window.location.href='" . __MODULE__ . "/Index/login.html';</script>"; exit; } $where = '1'; $count = M('video')->where($where)->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $news_list = M('video')->where($where)->order('add_time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($news_list as $k => $v) { $news_list[$k]['add_time'] = date('Y-m-d', $v['add_time']); } $this->assign('news_list', $news_list); $this->assign('page', $show); $this->display('list'); }
public function friendList() { $count = M('friendship_link')->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $friend_list = M('friendship_link')->order('status asc,sort desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $status_name = ['', '显示', '不显示']; $target_name = ['', '是', '否']; foreach ($friend_list as $k => $v) { $friend_list[$k]['status_name'] = $status_name[$v['status']]; $friend_list[$k]['target_name'] = $target_name[$v['target']]; } $this->assign('friend_list', $friend_list); $this->assign('page', $show); $this->display(); }
public function email() { $email = D('Email'); $count = $email->where('state=2')->count(); $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $email_list = $email->where('state=2')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('email_list', $email_list); $this->assign('page', $show); $this->display(); }
public function video() { if ($_SESSION[C('ADMIN_AUTH_KEY')]['video'] != 1) { echo "<script>alert('你没有权限!');window.location.href='" . __MODULE__ . "/Admin/info.html';</script>"; exit; } $count = M('video')->where('status!=10')->count(); $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->showFront(); // 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $message_list = M('video')->where('status!=10')->order('add_time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $level_name = ['', '一星课程', '二星课程', '三星课程', '四星课程', '五星课程']; $type_name = ['', '1', '2', '3', '4', '5', '6']; foreach ($message_list as $k => $v) { $message_list[$k]['add_time'] = date('Y-m-d H:i:s', $v['add_time']); $message_list[$k]['level_name'] = $level_name[$v['level']]; // $message_list[$k]['type_name'] = $type_name[$v['type']]; } $this->assign('message_list', $message_list); $this->assign('page', $show); $this->display(); }