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 '
//
//
//
//
//
// ';
// }else {
// return '
//
//
//
//
//
// ';
// }
//
//
// }else {
//
// if ($query->is_disqualified==4) {
// return '
//
//
//