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

'. // ''. ''. ''. // ''. '

'; }); } /** * Get query source of dataTable. * * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $user = auth()->user(); return $user->mailing_list()->newQuery(); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() // ->setTableId('mailinglist-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('subject'), Column::make('language'), Column::make('from_name'), Column::make('from_email'), Column::make('status'), Column::make('list_id')->title('ID'), Column::make('created_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(140) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'PersonalisedMailAudience_' . date('YmdHis'); } }