orderColumn('name', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('position', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('phone', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('email', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('created_at', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('application_status', function ($query, $order) { // $query->orderBy('id', $order); // }) ->addColumn('created_at', function ($query) { return date('l M d, Y', strtotime($query->created_at)); }) ->addColumn('applicant_name', function ($query) { if ($query->applicant_name ==null) { $getapp_name = DB::table('userdetails')->where('id',$query->user_id)->first(); return $getapp_name->name??''; }else { return $query->applicant_name; } }) ->addColumn('email', function ($query) { if ($query->applicant_name ==null) { $getapp_name = DB::table('userdetails')->where('id',$query->user_id)->first(); return $getapp_name->email??''; } else { return $query->email; } }) ->addColumn('business_phone', function ($query) { if ($query->applicant_name ==null) { $getapp_name = DB::table('userdetails')->where('id',$query->user_id)->first(); return $getapp_name->phone??''; }else { return $query->business_phone; } return date('l M d, Y', strtotime($query->created_at)); }) ->editColumn('is_disqualified', function ($query) { if ($query->is_disqualified === null) { return 'Started'; }elseif ($query->is_disqualified === 0) { return 'Pending Evaluation'; }elseif ($query->is_disqualified === 1||$query->is_disqualified === 3) { return 'Rejected'; } elseif ($query->is_disqualified === 2) { return 'Under Review'; }elseif ($query->is_disqualified === 4) { return 'Qualified Application'; } }) // ->editColumn('is_stage_complete', function ($query) { // if ($query->is_stage_complete ==0) { // return 'Pending'; // }elseif ($query->is_disqualified ==0) { // return 'Rejected'; // }elseif ($query->is_disqualified ==1) { // return 'Rejected'; // } // }) // ->editColumn('application_status', function ($query) { // // if ($query->application_status !==null) { // if ($query->application_status=='Started') { // return 'Started'; // }else if ($query->application_status=='Completed'){ // return 'Completed'; // }else if ($query->application_status=='Under Review'){ // return 'Under Review'; // }else if ($query->application_status=='Completed Review'){ // return 'Completed Review'; // }else if ($query->application_status=='Not Started'){ // return 'Not Started'; // }else if ($query->application_status=='Rejected'){ // return 'Rejected'; // } // else if ($query->application_status=='Approved Application'){ // return 'Approved Application'; // } // // }else{ // return null; // } // }) ->addColumn('action', function ($query) { if (Session::get('adminrole') == 1) { if ($query->is_disqualified ===null|| $query->is_disqualified ===1) { return ' '; }elseif ($query->is_disqualified ===2|| $query->is_disqualified ===0) { $a=''; $checkeva = DB::table('evaluation_sheet')->where('user_id',$query->user_id)->first(); if ($checkeva ==null || $checkeva !==null && $checkeva->total==null) { return ' '; }else { return ' '; } }elseif ($query->is_disqualified ===3) { return ' '; }elseif ($query->is_disqualified ===4) { return ' '; } }elseif (Session::get('adminrole') == 2) { $getonlyzero = DB::table('users')->where('is_disqualified',0)->orWhere('project_stat','Moved to Credit Analyst')->first(); if ($getonlyzero !== null) { if ($query->is_disqualified ===null|| $query->is_disqualified ===1) { return ' '; }elseif ($query->is_disqualified ===2 || $query->is_disqualified ===0) { $a=''; $checkeva = DB::table('evaluation_sheet')->where('user_id',$query->user_id)->first(); if ($checkeva ==null) { return ' '; }else { return ' '; } }elseif ($query->is_disqualified ===3) { return ' '; }elseif ($query->is_disqualified ===4) { return ' '; } } }elseif (Session::get('adminrole') == 3) { if ($query->is_disqualified ===null|| $query->is_disqualified ===1) { return ' '; }elseif ($query->is_disqualified ===2|| $query->is_disqualified ===0) { $a=''; $checkeva = DB::table('assessment')->where('user_id',$query->user_id)->first(); if ($checkeva ==null) { return ' '; }else { return ' '; } }elseif ($query->is_disqualified ===3) { return ' '; }elseif ($query->is_disqualified ===4) { return ' '; } } }) ->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"); return $this->applyScopes($query); } // public function query() // { // if (Session::get('adminrole') == 1) { // $query = DB::select("select * from users"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 2) { // $query = DB::select("select * from users where is_disqualified = 0 or is_disqualified =2"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 3) { // $query = DB::select("select * from users where is_qualified"); // 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(5) ->buttons( Button::make('export'), Button::make('print') // Button::make('reset'), ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 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'); } }