addColumn('is_director', function ($query) { if ($query->is_director == 1) { return 'Yes'; } else { return 'No'; } }) // ->addColumn('name', function($query) { // return $query->userdetails->name ?? ''; // }) // ->orderColumn('name', function ($query, $order) { // $query->orderBy('id', $order); // }) ; } // /** * 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 dept IS NOT NULL AND deleted_at IS NULL AND (coi_status IS NULL AND status IS NULL) UNION SELECT * FROM `coi_users` WHERE dept IS NOT NULL AND deleted_at IS NULL AND ((coi_status = 'Agree' AND status = 'Pending') OR (coi_status IS NULL AND status = 'Pending')) "); return collect($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(0) ->buttons( Button::make('export'), Button::make('print'), // Button::make('reset'), Button::make('reload') ) ; } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('id')->visible(false)->exportable(false) ->printable(false), 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'), // 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'); } }