public function getApplicationsRanked(LoggedInRequest $request) { $applications = Application::orderByRaw('(appRating*0.2)+(interviewRating*0.8) 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')); }