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