/** * Insert new Tournament * * @param array $data * @return Tournament */ public function create_tournament(array $data) { $tourney = \DB::table('tournaments')->where('tournament_id', '=', $data['tournament_id'])->first(); if (is_null($tourney)) { return Tournament::create(['tournament_id' => $data['tournament_id'], 'name' => $data['name'], 'img_logo' => $data['img_logo'], 'location' => $data['location'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date']]); } }
public function start($id) { $tournament = Tournament::find($id); $participants = $tournament->participants; if ($tournament->started == false) { // $registrations =$tournament->registrations()->get(); // echo $registrations[0]->user()->get(); // Von der Registrierung zum User $registrations = $tournament->registrations()->get(); for ($i = 0; $i <= $participants / 2; $i = $i + 2) { echo "test" . $i; $player1 = $registrations[$i]->user()->get(); $player2 = $registrations[$i + 1]->user()->get(); $post = new Result(); $post->user1()->associate($player1[0]); $post->user2()->associate($player2[0]); $post->tournament()->associate($tournament); $post->round = 0; $post->save(); } $tournament->started = 1; $tournament->round = 0; // $tournament->round++; $tournament->save(); } else { $tournament_already_started_message = "Tournament already started"; } // echo count($registrations); return view('results.index', array("tournament_already_started_message" => $tournament_already_started_message, "started" => $tournament->started, 'tournament' => $tournament)); }
/** * Fills tournaments table * */ public function run() { $faker = Faker::create(); foreach (range(1, 10) as $index) { $t = Tournament::create(['name' => $faker->name(), 'min_number_of_teams' => $faker->numberBetween(2, 4), 'max_number_of_teams' => $faker->numberBetween(4, 16), 'start_date' => $faker->date('YYYY-MM-DD'), 'end_date' => $faker->date('YYYY-MM-DD'), 'type' => $faker->realText(100)]); $t->league()->associate(League::first())->save(); //associate tournamnet with first league } }
/** * Show the application welcome screen to the user. * * @return Response */ public function scraper() { $success = ''; $groups = Group::lists('name', 'group_id'); $locations = Location::lists('location', 'location_id'); //$tournaments = Tournament::orderBy('start_date', 'desc') // ->lists('name','tournament_id'); $tournaments = Tournament::selectRaw('CONCAT(name, " (", start_date, ")") as name, tournament_id')->orderBy('start_date', 'desc')->lists('name', 'tournament_id'); $players = Player::select('first_name', 'last_name', 'player_id', \DB::raw('CONCAT(first_name, " ", last_name) as full_name'))->orderBy('first_name')->orderBy('last_name')->get()->lists('full_name', 'player_id'); return view('admin.scraper', compact('groups', 'locations', 'tournaments', 'players', 'success')); }
public function add($id) { // Es würede auch Funktionieren wenn ich ein Turnier erstelle und diesem Benutzer hinzufüge.. (bessere Lösung).. $userid = Auth::user()->id; $registration = new Registration(); $registration->tournament()->associate(Tournament::find($id)); $registration->user()->associate(User::find($userid)); $registration->save(); return $this->index($id); // methoden parameter request apramter }
public function fetchStartingTournaments() { $dateTimeNow = date('Y-m-d H:i:s', strtotime('+5 seconds')); $dateTimeSoon = date('Y-m-d H:i:s', strtotime('+600 seconds')); //echo $dateTimeNow . "<br>"; $tournaments = \App\Tournament::where('loaded_to_server', 0)->where('starts_at', '>', $dateTimeNow)->where('starts_at', '<', $dateTimeSoon)->with('collection.problems')->get(); // Set back info for each that we have loaded them // This should probably be done in a background job $tournaments->each(function ($tournament) { $tournament->loaded_to_server = 1; $tournament->save(); }); return response()->json($tournaments); }
public function loadClientApp(\Illuminate\Http\Request $request) { // Get tournament key $key = $request->route('key'); // Make sure tournament key matches to some tournament try { $tournament = \App\Tournament::where('key', $key)->firstOrFail(); } catch (ModelNotFoundException $e) { \Session::flash('errorMsg', 'Tournament not found!'); return \View::make('tournamentnotfound'); } // Validate user inputted data // Framework will catch any throws higher up in call tree $this->validate($request, ['username' => 'required|min:2|max:32|alpha_num']); // All is fine // Launch client app return \View::make('clientApp')->with('username', \Input::get('username'))->with('tournamentkey', $tournament->key); }
/** * Remove the specified tournament from storage. * * @param int $id Id of tournament to delete * @return Response route where to redirect after delete */ public function destroy($id) { $tournament = Tournament::findOrFail($id); $tournament->delete(); return redirect('/tournaments'); }
/** * [future description] * @return [type] [description] */ public function future() { return Tournament::where('start_date', '>', date('Y-m-d'))->orderBy('start_date'); }
/** * Display the specified team. * * @param int $id * @return Response */ public function show($id) { $team = Team::findOrFail($id); $users = User::all(); $tournaments = Tournament::all(); return view('/teams/team-details', ['team' => $team, 'users' => $users, 'tournaments' => $tournaments]); }
private function createNewSecret($times = 0) { if ($times > 5) { return \App::abort(403, 'Could not create tournament secret key - contact administrator'); } $chars = "qwertyuipasdfghjklzxcvbnm12345678900"; $secret = ""; for ($i = 0; $i < 4; $i++) { $r = rand(0, strlen($chars) - 1); $secret .= $chars[$r]; } if (\App\Tournament::where('key', $secret)->first()) { return $this->createNewSecret($times + 1); } return $secret; }
/** * Display a listing of the resource. * * @return Response */ public function match($user_id, $match_id) { $tournaments = Tournament::selectRaw('CONCAT(name, " (", start_date, ")") as name, tournament_id')->where('start_date', '>=', '2016-10-01')->orderBy('start_date', 'desc')->lists('name', 'tournament_id'); $user = User::find($user_id); return view('pages/tools.referee.match', compact('tournaments', 'user', 'match_id')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { echo $id; Tournament::destroy($id); return $this->index(); // methoden parameter request apramter }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('tournaments')->delete(); Tournament::create(['name' => 'Dota Pit League Season 3', 'organizer' => 'Dota Pit', 'start_date' => '2015-01-21', 'end_date' => '2015-07-12', 'location' => 'online', 'format' => 'Groups into Double-elimination Bracket', 'prize_pool' => '$265,378+', 'status' => 'concluded']); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy(Tournament $tournament) { $tournament->delete(); return redirect("tournaments"); }