model()->leftJoin('users_info','users_report.user_id','=','users_info.user_id')->select(['users_report.*','users_info.nickname','users_info.avatar','users_info.area'])->orderByDesc('id'); $grid->column('id')->sortable(); $grid->combine('user', ['avatar', 'nickname'],'用户'); $grid->column('user_id','用户'); $grid->column('type')->using([1=>'用户',2=>'动态'])->label(['gray','blue','green']); $grid->column('report_id'); $grid->column('content'); $grid->column('info'); $grid->column('img_url','图片内容')->display(function ($v){ if(isset($v)&&!empty($v)){ $v = json_decode($v,true); $str = ''; if(count($v)>0){ foreach ($v as $item){ $str.=''; } } return $str; }else{ return ""; } }); $grid->column('status'); $grid->column('created_at'); // $grid->column('updated_at')->sortable(); $grid->filter(function (Grid\Filter $filter) { $filter->equal('id'); }); return $grid; } /** * Make a show builder. * * @param mixed $id * * @return Show */ protected function detail($id) { return Show::make($id, new UserReportModel(), function (Show $show) { $show->field('id'); $show->field('user_id'); $show->field('report_id'); $show->field('type'); $show->field('content'); $show->field('info'); $show->field('img_url'); $show->field('status'); $show->field('created_at'); $show->field('updated_at'); }); } /** * Make a form builder. * * @return Form */ protected function form() { return Form::make(new UserReportModel(), function (Form $form) { $form->display('id'); $form->text('user_id'); $form->text('report_id'); $form->text('type'); $form->text('content'); $form->text('info'); $form->text('img_url'); $form->text('status'); $form->display('created_at'); $form->display('updated_at'); }); } }