<?php /** * Created by PhpStorm. * User: ruidiudiu * Date: 2018/11/20 * Time: 14:26 */ namespace app\portal\controller; use app\portal\model\UsersModel; use cmf\controller\AdminBaseController; use think\Db; /** * Class AdminUsersController * @package app\portal\controller * @adminMenuRoot( * 'name' =>'用户管理', * 'action' =>'index', * 'parent' =>'', * 'display'=> true, * 'order' => 30, * 'icon' =>'th', * 'remark' =>'用户管理' * ) */ class AdminUsersController extends AdminBaseController{ public function index(){ $param=$this->request->param(); $where=[]; if (!empty($param['keyword'])){ $where['phone']=['like','%'.$param['keyword'].'%']; } $users=new UsersModel(); $data=$users->where($where)->order('create_time','desc')->paginate(10)->each(function ($item) { if ($item['is_use']==1){ $item['eq']=Db::name('order') ->alias('o') ->join('equipment e','o.eq_name=e.name') ->where(['o.users_id'=>$item['id'],'o.state'=>1])->find()['serial_number']; } return $item; }); $data->appends($param); $this->assign('keyword', isset($param['keyword']) ? $param['keyword'] : ''); $this->assign('data',$data); return $this->fetch(); } }