addColumn('action', function($query){ return '

'; }); } /** * Get query source of dataTable. * * @param \CoeForm $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(CoeForm $model) { $current_year = Carbon::now()->year; $countcompletedcoe = DB::select("SELECT * FROM coi_users WHERE YEAR(created_at) = $current_year AND deleted_at IS NULL and dept IS NOT NULL and id IN (Select coi_user_id from coe_forms)"); return collect($countcompletedcoe); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('coesubmissionsdatatable-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('email'), Column::make('phone'), Column::make('dept'), Column::make('division'), Column::make('level'), Column::make('is_director')->title('Is He/She a Director'), Column::make('employment_status'), // Column::make('declared_at'), // Column::make('declared_date'), Column::make('COE Agreement') ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'COESubmissions_' . date('YmdHis'); } }