public function exportAll() { $table = Competitor::all(); $user = User::first(); $makeKeys = $table; $output = ""; $keyArray = []; foreach ($makeKeys->first()->toArray() as $key => $value) { // var_dump( $key ); array_push($keyArray, $key); } // var_dump($table->first()->user->toArray()); foreach ($user->toArray() as $key => $value) { if ($key !== 'id') { array_push($keyArray, $key); } } // var_dump($table . '</br>'); // var_dump($makeKeys); // var_dump( $keyArray ); $output .= implode(",", $keyArray) . "\n"; foreach ($table as $row) { // var_dump($row);echo'</br>'; $output .= implode(",", $row->toArray()); $output .= implode(",", $row->user->toArray()) . "\n"; } // echo $output; $headers = array('Content-Type' => 'text/csv', 'Content-Disposition' => 'attachment; filename="allParticipants.csv"'); return Response::make(rtrim($output, "\n"), 200, $headers); }
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')); }