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