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 dsq_save($id, Request $request)
 {
     $competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
     $act_competitor = $request->act_comp;
     $result = Result::where('competitiongroup_id', '=', $id)->where('competitor_id', '=', $act_competitor)->first();
     $result->dsq_status = 1;
     $result->fencing_win = null;
     $result->fencing_lose = null;
     $result->fencing_points = 0;
     $result->penalty_points_fencing = null;
     $result->fencing_order = 0;
     $result->swimming_time = "";
     $result->swimming_points = 0;
     $result->penalty_points_swimming = null;
     $result->swimming_order = 0;
     $result->riding_point = "";
     $result->riding_time = "";
     $result->riding_points = 0;
     $result->horse_id = null;
     $result->riding_order = 0;
     $result->ce_time = "";
     $result->ce_points = 0;
     $result->penalty_points_ce = null;
     $result->ce_order = 0;
     $result->total_points = 0;
     $result->total_penalty_points = null;
     $result->save();
     if ($competitiongroup->fencing_bouts != 0) {
         $competitiongroup->fencing_bouts = $competitiongroup->fencing_bouts - $competitiongroup->bouts_per_match;
         $competitiongroup->save();
     }
     $fencing_results1 = Fencing_result::where('competitiongroup_id', '=', $id)->where('competitor1_id', '=', $act_competitor)->get();
     $fencing_results2 = Fencing_result::where('competitiongroup_id', '=', $id)->where('competitor2_id', '=', $act_competitor)->get();
     foreach ($fencing_results1 as $fence) {
         $fence->delete();
     }
     foreach ($fencing_results2 as $fence) {
         $fence->delete();
     }
     //Sorrendek
     $this->riding_order($id);
     $this->swimming_order($id);
     $this->ce_order($id);
     $this->total_fencing_points($id);
     $this->total_points($id);
     $this->team_points_order($id);
     return redirect('admin/competitiongroups/' . $id . '/dsq')->with('status', 'Versenyző kizárva.');
 }
 public function entry_close(EntryCloseFormRequest $request, $id)
 {
     //Nevezés lezárása
     $competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
     $competitiongroup->bouts_per_match = $request->get('bouts_per_match');
     $competitiongroup->fencing_bouts = $request->get('fencing_bouts');
     $competitiongroup->entry_closed = 1;
     $competitiongroup->riding_time_limit = $request->get('riding_time_limit');
     $competitiongroup->save();
     //Benevezett versenyzők vívó mérkőzéseinek összeállítása
     if ($request->fencing_bouts != 0) {
         $competitor_list = Result::select('competitor_id')->where('competitiongroup_id', '=', $id)->orderBy('competitor_id')->get()->toArray();
         $competitor_in = [];
         foreach ($competitor_list as $comp) {
             $competitor_in[] = $comp['competitor_id'];
         }
         while (count($competitor_in) >= 2) {
             foreach ($competitor_in as $comp) {
                 if ($competitor_in[0] != $comp) {
                     $fencing_result = new Fencing_result();
                     $fencing_result->competitiongroup_id = $id;
                     $fencing_result->competitor1_id = $competitor_in[0];
                     $fencing_result->competitor2_id = $comp;
                     $fencing_result->save();
                 }
             }
             unset($competitor_in[0]);
             $competitor_in = array_values($competitor_in);
         }
     }
     return redirect('admin/competitiongroups/')->with('status', 'Nevezés lezárva');
 }