Action '; })->rawColumns(['response', 'action']) ;} // /** * Get query source of dataTable. * * @param \App\App\UsersDataTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $current_year = Carbon::now()->year; $query = DB::select("SELECT * FROM coi_users WHERE momoconflict = 1 AND deleted_at IS NULL AND (status like 'Completed' or status like 'Updated' or status like 'UpdatedFromLastYear') "); 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('usersdatatable-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( Button::make('export'), Button::make('print'), // Button::make('reset'), Button::make('reload') ) ; } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('name')->title('Name'), Column::make('email')->title('Email'), Column::make('phone'), Column::make('dept'), Column::make('division'), Column::make('is_director')->title('Is He/She a Director'), Column::make('created_at')->title('Date Started'), Column::make('response')->title('Assessment Sent'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Users_' . date('YmdHis'); } }