condition ) { $condition = $this->condition; }else { $filter = MongodbSearchFilter::filterCondition([ 'opt_type' => 'opt_type', 'user_name' => 'user_name', 'success_times' => 'success_times', 'created_at' => 'created_at', 'period_num' => 'period_num', 'ip' => 'ip', 'device' => 'device', 'user_agent' => 'user_agent', 'request_route' => 'request_route', ]); $condition = $filter['condition']; } $data = LogUserLogin::lists($condition, [ 'pageSize' => $this->pageSize ]); unset($filter); $this->listData = $data; } /** * 要展示和导出的所有字段 * @return array */ public function getColumn(){ if(!$this->columns){ $this->columns = [ 'opt_type' => [ 'header' => 'Operation type',//操作类型 'headerOther' => [ 'width' => '120', ], 'value' => function($row) { return (isset($row['opt_type']) && $row['opt_type'] == 1 )? 'login succeeded' : 'login failed';//'登录成功' : '登录失败'; }, 'valueOther' => function($row) { return [ 'tag'=>['type'=>(isset($row['opt_type']) && $row['opt_type'] == 1 )? 'success' : 'danger', 'size' => 'small'] ]; }, ], 'opt_obj' => [ 'header' => 'Operation object',//操作对象 'headerOther' => [ 'width' => '120', ], 'value' => function($row) { return 'member';//会员 }, ], 'user_name' => [ 'header' => 'Object number',//对象编号 'headerOther' => [ 'width' => '110', ], ], 'return_result' => [ 'header' => 'Return content',//返回内容 'headerOther' => [ 'width' => '250', ], ], 'success_times' => [ 'header' => 'Login success times',//登录成功次数 'headerOther' => [ 'width' => '110', ], ], 'fail_times' => [ 'header' => 'Number of login failures',//登录失败次数 'headerOther' => [ 'width' => '110', ], ], 'created_at' => [ 'header' => 'Operation time',//操作时间 'value' => function($row) { return (new DateTime([ 'value' => $row['created_at'], ]))->result(); }, 'headerOther' => ['width' => '180'], ], 'period_num' => 'Number of periods',//期数 'ip' => [ 'header' => 'IP address',//IP地址 'headerOther' => [ 'width' => '150', ], ], 'device' => [ 'header' => 'client',//客户端 'headerOther' => [ 'width' => '150', ], ], 'user_agent' => [ 'header' => 'operating system',//操作系统 'headerOther' => [ 'width' => '950', ], ], 'request_route' => [ 'header' => 'Request path',//请求路径 'headerOther' => [ 'width' => '250', ], ], ]; } return $this->columns; } /** * 前台用于筛选的类型集合 * @return mixed */ public function getFilterTypes() { if(!$this->filterTypes){ $this->filterTypes = [ // 'opt_type' => ['isUserTable'=>false, 'name'=>'操作类型', 'other'=> 'select', 'selectData'=> [['id'=> 1, 'name'=> '登录成功'], ['id'=> 0, 'name'=> '登录失败']]], 'opt_type' => ['isUserTable'=>false, 'name'=>'Operation type', 'other'=> 'select', 'selectData'=> [['id'=> 1, 'name'=> 'login succeeded'], ['id'=> 0, 'name'=> 'login failed']]], 'user_name' => ['isUserTable'=>false, 'name'=>'Object number'],//对象编号 'success_times' => ['isUserTable'=>false, 'name'=>'Login success times'],//登录成功次数 'fail_times' => ['isUserTable'=>false, 'name'=>'Number of login failures'],//登录失败次数 'created_at' => ['isUserTable'=>false, 'name'=>'Operation time', 'other'=> 'date'],//操作时间 'period_num' => ['isUserTable'=>false, 'name'=>'Number of periods'],//期数 'ip' => ['isUserTable'=>false, 'name'=>'IP address'],//IP地址 'device' => ['isUserTable'=>false, 'name'=>'client'],//客户端 'user_agent' => ['isUserTable'=>false, 'name'=>'operating system'],//操作系统 'request_route' => ['isUserTable'=>false, 'name'=>'Request path'],//请求路径 ]; } return $this->filterTypes; } }