AdminUsersController.php 1.4 KB
<?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();
    }



}