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 teams_entry($id)
{
$competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
//Versenyzők a listába
$result_list = Result::where('competitiongroup_id', '=', $id)->get()->lists('competitor_id', 'competitor_id');
$already_in1 = Results_team::select('competitor1_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor1_id', 'competitor1_id');
$already_in2 = Results_team::select('competitor2_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor2_id', 'competitor2_id');
$already_in3 = Results_team::select('competitor3_id')->where('competitiongroup_id', '=', $id)->get()->lists('competitor3_id', 'competitor3_id');
foreach ($already_in1 as $remove) {
$result_list->forget($remove);
}
foreach ($already_in2 as $remove) {
$result_list->forget($remove);
}
foreach ($already_in3 as $remove) {
$result_list->forget($remove);
}
$competitors = [];
foreach ($result_list as $comp) {
$temp_comp = Competitor::whereId($comp)->first();
$competitors[$comp] = $temp_comp->full_name_birthday;
}
natsort($competitors);
//Benevezett versenyzők
$competitor_list = Result::select('results.*')->where('competitiongroup_id', '=', $id)->join('competitors', 'results.competitor_id', '=', 'competitors.id')->orderBy('full_name', 'asc')->get();
$competitor_in = [];
foreach ($competitor_list as $comp) {
$competitor_in[$comp->id] = $comp->competitor->full_name;
}
natsort($competitor_in);
$comp_count = count($competitor_in);
//Benevezett csapatok
$team_list = Results_team::where('competitiongroup_id', '=', $id)->orderBy('name')->get();
$team_in = [];
foreach ($team_list as $team) {
$team_in[$team->id] = $team->name;
}
natsort($team_in);
$team_count = count($team_in);
return view('backend.competitiongroups.teams_entry', compact('competitiongroup', 'competitors', 'team_in', 'team_list', 'team_count', 'competitor_in', 'competitor_list', 'comp_count'));
}
