eloquent($query) ->orderColumn('name', function ($query, $order) { $query->orderBy('id', $order); }) ->orderColumn('company_name', function ($query, $order) { $query->orderBy('id', $order); }) ->orderColumn('position', function ($query, $order) { $query->orderBy('id', $order); }) ->orderColumn('phone', function ($query, $order) { $query->orderBy('id', $order); }) ->orderColumn('email', function ($query, $order) { $query->orderBy('id', $order); }) ->orderColumn('created_at', function ($query, $order) { $query->orderBy('id', $order); }) ->editColumn('created_at', function ($query) { return $query->created_at->format('d M, Y');// human readable format }) ->addColumn('action', function($query){ // '.route('admin.application.approvegrant',$query->id).' // '.route('admin.start.review',$query->id).' return ' '; }) ->rawColumns(['action']); } /** * Get query source of dataTable. * * @param \App\App\CompletedApplication $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = UserDetails::where('application_status','Approved Application'); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('completedapplication-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( // Button::make('create'), Button::make('export'), Button::make('print') // Button::make('reset'), // Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('name'), Column::make('company_name'), Column::make('position'), Column::make('phone'), Column::make('email'), Column::make('created_at')->title('Date Applied'), // Column::computed('action') // ->exportable(false) // ->printable(false) // ->width(60) // ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'CompletedApplication_' . date('YmdHis'); } }