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'));
}
