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 team_points_order($id) { $teams = Results_team::where('competitiongroup_id', '=', $id)->get(); foreach ($teams as $team) { $comps = [$team->competitor1_id, $team->competitor2_id, $team->competitor3_id]; $competitors = Result::where('competitiongroup_id', '=', $id)->whereIn('competitor_id', $comps)->get(); $swimming_points = 0; $riding_points = 0; $ce_points = 0; $fencing_points = 0; $total_points = 0; foreach ($competitors as $comp) { $swimming_points += $comp->swimming_points; $riding_points += $comp->riding_points; $ce_points += $comp->ce_points; $fencing_points += $comp->fencing_points; $total_points += $comp->total_points; } $team->swimming_points = $swimming_points; $team->riding_points = $riding_points; $team->ce_points = $ce_points; $team->fencing_points = $fencing_points; $team->total_points = $total_points; $team->save(); } //Vívás sorrend $fencing_order = Results_team::where('competitiongroup_id', '=', $id)->orderBy('fencing_points', 'desc')->get(); $i = 0; foreach ($fencing_order as $fence) { $i++; $fence->fencing_order = $i; $fence->save(); } //Úszás sorrend $swimming_order = Results_team::where('competitiongroup_id', '=', $id)->orderBy('swimming_points', 'desc')->get(); $i = 0; foreach ($swimming_order as $swim) { $i++; $swim->swimming_order = $i; $swim->save(); } //Lovas sorrend $riding_order = Results_team::where('competitiongroup_id', '=', $id)->orderBy('riding_points', 'desc')->get(); $i = 0; foreach ($riding_order as $ride) { $i++; $ride->riding_order = $i; $ride->save(); } //Kombinált sorrend $ce_order = Results_team::where('competitiongroup_id', '=', $id)->orderBy('ce_points', 'desc')->get(); $i = 0; foreach ($ce_order as $ce) { $i++; $ce->ce_order = $i; $ce->save(); } }
public function destroy_team_entry($id) { $team = Results_team::findOrFail($id); $del_id = $team->competitiongroup_id; $team->delete(); return redirect('admin/competitiongroups/' . $del_id . '/entry/teams_entry')->with('status', 'Nevezés törölve'); }