eloquent($query) ->addColumn('action', function ($row) { return '

' . '' . '' . '' . '

'; }); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $query = Email_templates::query()->where('client_id','=', Auth::user()->id)->select('*'); 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('dataTableBuilder') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( Button::make('create')->text('Create template'), Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('template_name'), Column::make('type'), Column::make('created_at'), Column::make('updated_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(200) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'emailtemplatesdatatables_' . time(); } }