addColumn('created_at', function ($query) { return date('l M d, Y', strtotime($query->created_at)); }) ->editColumn('is_disqualified', function ($query) { if (empty($query->project_stat) && $query->is_disqualified === 0) { return ''; } $getissue = IssuesResponse::where('user_id',$query->user_id)->where('credit_id',auth()->guard('adminguard')->user()->id)->where('status','Open')->count(); // $getres = IssuesResponse::where('user_id',$query->user_id)->where('credit_id',auth()->guard('adminguard')->user()->id)->where('status','Closed')->whereNotNull('response')->count(); if ($query->credit_stat === "Assessment Complete" && $query->is_disqualified !== 0&& $getissue==0) { if ($query->is_disqualified==4) { return ''; }elseif ($query->is_disqualified==3) { return ''; } } if (empty($query->credit_stat) && $query->is_disqualified === 2&&$query->application_status=='Under Review'){ return ''; } if (empty($query->credit_stat) && $query->is_disqualified === 2&&$query->application_status=='Under Assessment'){ return ''; } if (empty($query->credit_stat) && $query->is_disqualified === 2&&$query->application_status=='Issues Detected'&& $getissue>0){ return ''; } if (empty($query->credit_stat) && $query->is_disqualified === 2&&$query->application_status=='Issues Detected'&& $getissue==0){ return ''; } if ($query->credit_stat === "Credit Reject" && $query->is_disqualified !== 0) { return ''; } if ($query->application_status == 'Moved To Interview Stage') { return ''; } // // if ($query->credit_stat == null && $query->is_disqualified== 2 ) { // return ''; // }elseif($query->credit_stat != null && $query->is_disqualified!= 2 ) { // return ''; // } }) // // ->addColumn('action', function ($query) { // // FYEI Dashboard // // $a=''; // $checkeva = DB::table('assessment')->where('user_id',$query->user_id)->first(); // if ($checkeva ==null) { // // if (empty($query->project_stat) && $query->is_disqualified === 0) { // return ' //
// //
// View Application //
//
// // '; // }else { // return ' //
// //
// View Application // Assess Applicant //
//
// // '; // } // // // }else { // // if ($query->is_disqualified==4) { // return ' //
// //
// View Application // // FYEI Dashboard // Decision Form // '; // }else { // return ' //
// //
// View Application // // FYEI Dashboard // // '; // } // // ' //
//
// // '; // } // }) ->rawColumns(['application_status','action','is_disqualified']); } /** * 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' and application_status='Under Assessment' or application_status='Issues Detected'"); return $this->applyScopes($query); } 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('company_name'), Column::make('company_name'), Column::make('email'), Column::make('business_phone'), Column::make('application_stage'), // Column::make('is_stage_complete'), Column::make('is_disqualified')->title('Application Status'), Column::make('created_at')->title('Date Applied'), // // Column::make('application_status'), // Column::computed('action') // ->exportable(false) // ->printable(false) // ->width(60) // ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'DashboardTable_' . date('YmdHis'); } }