<?php // +---------------------------------------------------------------------- // | bronet [ 以客户为中心 以奋斗者为本 ] // +---------------------------------------------------------------------- // | Copyright (c) 2013-2017 http://www.bronet.cn All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- // | Author:kane < chengjin005@163.com> // +---------------------------------------------------------------------- namespace app\portal\controller; use cmf\controller\AdminBaseController; use function Qiniu\thumbnail; use think\Db; class AdminPrizeOrderController extends AdminBaseController { public function index() { //接收搜索参数 $param = $this->request->param(); //添加搜索条件 $where=[]; $keyword = empty($param['keyword']) ? '' : $param['keyword']; if (!empty($keyword)) { $where['u.nickname|u.mobile'] = ['like', "%$keyword%"]; } $data = Db::name('prize_order') ->alias('po') ->join('prize p','po.prize_id=p.id') ->join('users u','po.users_id=u.id') ->where($where) ->field('po.*,p.name,p.score as pscore,po.status as postatus,u.nickname,u.mobile') ->order('po.create_time','desc') ->paginate('15'); $data->appends($param); $this->assign('page',$data->render()); $this->assign('keyword', isset($param['keyword']) ? $param['keyword'] : ''); $this->assign('list', $data); return $this->fetch(); } public function check(){ $id=$this->request->param('id'); Db::name('prize_order')->where('id',$id)->update(['status'=>1,'check_time'=>time()]); $this->success('核销成功'); } public function delete() { $id = $this->request->param('id'); Db::name('prize_order')->where('id', $id)->delete(); $this->success('删除成功'); } }