addColumn('action', function($query){ return ' '; }); } /** * Get query source of dataTable. * * @param \App\User $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(category $model) { return $model->newQuery()->select('cat_id', 'cat_name', 'cat_desc', 'created_at'); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->minifiedAjax() ->addAction(['width' => '80px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'cat_id', 'name', 'created_at', 'updated_at' ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Category_' . date('YmdHis'); } }