public function competition_select($id, $subid) { $competition = Competition::whereId($id)->first(); $competitiongroups = Competitiongroup::where('competition_id', '=', $competition->id)->orderBy('date', 'desc')->get(); if (!$competitiongroups->isEmpty()) { $competitiongroup = Competitiongroup::whereId($subid)->firstOrFail(); $results = Result::where('competitiongroup_id', '=', $competitiongroup->id)->where('dsq_status', 0)->orderBy('total_points', 'desc')->get(); $results_dsq = Result::where('competitiongroup_id', '=', $competitiongroup->id)->where('dsq_status', 1)->get(); $teams = Results_team::where('competitiongroup_id', '=', $competitiongroup->id)->orderBy('total_points', 'desc')->get(); } return view('home', compact('competition', 'competitiongroups', 'competitiongroup', 'results', 'results_dsq', 'teams')); }
public function index() { $competitiongroups = Competitiongroup::orderBy('date', 'desc')->paginate(6); $competitiongroup_in_entry = Competitiongroup::where('entry_closed', '=', 0)->get(); $in_entry = []; foreach ($competitiongroup_in_entry as $comp) { $already_in = Result::where('competitiongroup_id', '=', $comp->id)->first(); if ($already_in) { $in_entry[] = $already_in->competitiongroup_id; } } return view('backend.competitiongroups.index', compact('competitiongroups', 'in_entry')); }