datatables ->eloquent($this->query()) ->addColumn('username', function ($row) { return ''.$row->username.'';}) ->rawColumns(['username']) ->make(true); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { if($this->request()->get('type')) { $type = $this->request()->get('type'); $roleId = strtolower($type) == 'reseller' ? Role::where('name', 'reseller')->firstOrFail()->id : Role::where('name', 'user')->firstOrFail()->id; $query = User::with('credit')->where([ ['role_id', '=', $roleId] ]); } else { $query = User::where('id',0); } return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'username' => ['title' => 'Client Name'], 'organisation' => ['title' => 'Organization'], //'updated_at' => ['title' => 'Total'], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'admin_client_datatables_' . time(); } }