eloquent() ->addColumn('is_director', function($query) { if ($query->is_director ==1) { return 'Yes'; }else { return 'No'; } }) // ->orderColumn('name', function ($query, $order) { // $query->orderBy('id', $order); // }) ->addColumn('action', function($query){ $adminid = Session::get('adminid'); $ban = ''; if ($query->can_login ==1) { $ban = ''; }else { $ban = ''; } if ($adminid == 3) { return '

'; }else { return '

'.$ban.'

'; } }) ;} // /** * 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 YEAR(created_at) = $current_year"); // $query = CoiUsers::all()->groupBy('email')->latest(); // return $query; 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('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('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'); } }