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();
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 '';
}
})
->addColumn('action', function ($query) {
$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 {
if (empty($query->credit_stat) && $query->is_disqualified === 2 && $query->application_status == 'Under Assessment') {
return '