eloquent($query) ->addColumn('checkbox', function ($row) { return ''; }) ->addColumn('from_date', function ($row) { return Carbon::parse($row->from_date)->toDateString(); }) ->addColumn('to_date', function ($row) { return Carbon::parse($row->to_date)->toDateString(); }) ->addColumn('action', function ($row) { $returnValue = '

'; if($row->status != 'pending' && $row->status != 'NONE') { $returnValue .= 'Download' ; } $returnValue .= 'Delete' . '

'; return $returnValue; })->rawColumns(['checkbox','action']); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|Builder|Collection */ public function query() { $query = Auth::user()->reports()->where('pulled_by',null)->orderBy('created_at', 'desc'); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { $params['order'] = [[1, 'desc']]; $params['lengthMenu'] = [[10, 30, 75, -1], [10, 30, 75, "All"]]; return $this->builder() ->addCheckbox(['title'=>'']) ->columns($this->getColumns()) ->ajax('') ->addAction(['width' => '150px']) ->dom('Bfrtip') ->buttons( Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'created_at', 'name' =>['title'=>'Report Name'], 'from_date' =>['title'=>'Report From'], 'to_date' =>['title'=>'Report To'], 'status' ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'reporting_' . time(); } }