public function competitor_statistics(Request $request) { $competitors = Competitor::all(); //Nevezett versenyzők $competitor_in = []; foreach ($competitors as $comp) { $competitor_in[$comp->id] = $comp->full_name_birthday; } natsort($competitor_in); reset($competitor_in); $act_competitor = key($competitor_in); //Kiválasztott versenyző if ($request->competitor) { $act_competitor = $request->competitor; } $all_result = Result::where('competitor_id', '=', $act_competitor)->orderBy('total_points', 'desc')->get(); //Úszás és kombinált távok mentése $swim_200 = ['Ifi B', 'Ifi A', 'Junior', 'Felnőtt', 'Senior']; $swim_100 = ['Ifi C', 'Ifi D']; $swim_50 = ['Ifi E', 'Ifi F']; $ce_3200 = ['Ifi A', 'Junior', 'Felnőtt', 'Senior']; $ce_2400 = ['Ifi B']; $ce_1600 = ['Ifi C']; $ce_800 = ['Ifi D']; $ce_400 = ['Ifi E', 'Ifi F']; //Lovaglás legjobb $best_riding = Result::where('competitor_id', '=', $act_competitor)->where('riding_points', '!=', 0)->orderBy('riding_points', 'desc')->first(); //Vívás legjobb $best_fencing = Result::where('competitor_id', '=', $act_competitor)->where('fencing_points', '!=', 0)->orderBy('fencing_points', 'desc')->first(); //Totál legjobb $best_total = Result::where('competitor_id', '=', $act_competitor)->where('total_points', '!=', 0)->orderBy('total_points', 'desc')->first(); //Úszás legjobbak $best_swimming_200 = Result::whereIn('age_group', $swim_200)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first(); $best_swimming_100 = Result::whereIn('age_group', $swim_100)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first(); $best_swimming_50 = Result::whereIn('age_group', $swim_50)->where('competitor_id', '=', $act_competitor)->where('swimming_time', '!=', '')->orderBy('swimming_time', 'asc')->first(); //Kombinált legjobbak $best_ce_3200 = Result::whereIn('age_group', $ce_3200)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first(); $best_ce_2400 = Result::whereIn('age_group', $ce_2400)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first(); $best_ce_1600 = Result::whereIn('age_group', $ce_1600)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first(); $best_ce_800 = Result::whereIn('age_group', $ce_800)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first(); $best_ce_400 = Result::whereIn('age_group', $ce_400)->where('competitor_id', '=', $act_competitor)->where('ce_time', '!=', '')->orderBy('ce_time', 'asc')->first(); return view('competitor_statistics', compact('all_result', 'competitors', 'competitor_in', 'act_competitor', 'best_riding', 'best_fencing', 'best_total', 'best_swimming_200', 'best_swimming_100', 'best_swimming_50', 'best_ce_3200', 'best_ce_2400', 'best_ce_1600', 'best_ce_800', 'best_ce_400')); }