editColumn('background', function($query){ return $query->background ?? 'N/A'; }) ->editColumn('customer_base', function($query){ return $query->customer_base ?? 'N/A'; }) ->editColumn('investment_plan', function($query){ return $query->investment_plan ?? 'N/A'; }) ->addColumn('action', function ($query) { return '
View Fill in Download '; }); } /** * Get query source of dataTable. * * @param \App\App\DashboardTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { // $query = DB::select("select * from users where is_disqualified = 2 and project_stat='Moved to Credit Analyst' or credit_stat='Assessment Complete' or credit_stat='Credit Reject'"); $id = auth()->guard('adminguard')->user()->id; $query = DB::select("select * from users where creditanalyst_id ='$id'"); 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('dashboardtable-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(0) ->buttons( Button::make('export'), Button::make('print') // Button::make('reset'), ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('updated_at')->visible(false)->exportable(false), Column::make('applicant_name'), Column::make('background'), Column::make('customer_base'), Column::make('investment_plan'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'ApplicantOverview_' . date('YmdHis'); } }