public function getApplications(LoggedInRequest $request)
{
$applications = Application::orderBy('applicationEdited', "desc")->get();
$numInterviewed = count(Application::where('interviewed', true)->get());
$numAccepted = count(Application::where('status', 'Accepted')->get());
$numReviewed = count(Application::where('reviewed', true)->get());
return view('pages.applications', compact('applications', 'numInterviewed', 'numAccepted', 'numReviewed'));
}
public function getNextApplicationID()
{
$user = Auth::user();
foreach (Application::orderBy(DB::raw('RAND()'))->get() as $app) {
//we must find the applications that are completed and have fewer than 3 reviews and that i didn't review
if ($app->completed) {
if ($app->reviews < 3) {
if (!ApplicationRating::where('application_id', $app->id)->where('user_id', $user->id)->first()) {
return $app->id;
}
}
}
}
return null;
}
