printColumns = ['Name', 'Code', 'Service Type']; $this->exportColumns = $this->printColumns; $this->excludeFromExport = ['Name']; } public function ajax() { return datatables() ->eloquent($this->query()) ->addColumn('Service Type', function ($row) { return $row->ussd_service_type->name; }) ->addColumn('Name', function ($row) { return $row->name; }) ->addColumn('Code', function ($row) { return $row->code; }) ->addColumn('action', function ($row) { $default = route('service.response.report', ['id' => $row->id]); $sales_route = route('service.sales.report', $row->id); $type = $row->ussd_service_type->name ?? null; $responses = ''; return '

' . '' . '' . '' . (in_array($type, ['Collection', 'Sales']) ? $responses : null) . '' . '' . '

'; })->make(true); } /** * Get the query object to be processed by dataTables. * */ public function query() { $query = UssdService::query()->where('sms_username', auth()->user()->username); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->addAction(['width' => '210px']) ->dom('Bfrtip') ->buttons( Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'Name', 'Code', 'Service Type' => ['title' => 'Service Type'] ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'ussd_ussdservicedatatables_' . time(); } }