addColumn('action', function ($query) { return ' '; }) ->addColumn('created_at', function($query){ return $query->created_at->format('Y:m:d H:i:s') ?? 'N/A'; }) ->addColumn('schedule', function($query){ return (new DateTime($query->schedule))->format('Y:m:d'); }) ->setRowId('id') ->rawColumns(['action']); } /** * Get the query source of dataTable. */ public function query(Forecast $model): QueryBuilder { return $model->newQuery()->where('schedule', '>=', now()->toDateString()); } /** * Optional method if you want to use the html builder. */ public function html(): HtmlBuilder { return $this->builder() ->setTableId('incomingforecast-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('lBfrtip') ->orderBy(1) // ->selectStyleSingle() ->buttons([ Button::make('excel'), Button::make('csv'), Button::make('pdf'), Button::make('print'), Button::make('reset'), Button::make('reload') ]); } /** * Get the dataTable columns definition. */ public function getColumns(): array { return [ Column::make('id')->visible(false), Column::make('banker'), Column::make('two_sure'), Column::make('three_direct'), Column::make('permutations'), Column::make('schedule'), Column::make('created_at'), // Column::make('updated_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get the filename for export. */ protected function filename(): string { return 'IncomingForecast_' . date('YmdHis'); } }