public function store()
 {
     $seven_days = 60 * 60 * 24 * 7;
     $two_hours = 60 * 60 * 2;
     $season = $_REQUEST['season'];
     $venue_id = $_REQUEST['venue_id'];
     $activity = $_REQUEST['activity'];
     $lastSeasonsLeague = League::where('season', $season - 1)->where('venue_id', $venue_id)->where('activity', $activity)->first();
     $lastSeasonsLastGame = Event::where('league_id', $lastSeasonsLeague->id)->where('week_num', 'Wild Card')->where('game_num', 1)->first();
     $start_dt = $_REQUEST['start_dt'];
     $start_dt = $start_dt ? strtotime($start_dt) : strtotime($lastSeasonsLastGame->date) + $seven_days;
     $start_wk = $_REQUEST['start_wk'];
     $start_wk -= 1;
     $week_cnt = $_REQUEST['week_cnt'];
     $game_cnt = $_REQUEST['game_cnt'];
     $games_tm = $_REQUEST['games_tm'];
     $games_tm = $games_tm ? strtotime($games_tm) : strtotime($lastSeasonsLastGame->time);
     $events = [];
     for ($i = $start_wk; $i <= $week_cnt; $i++) {
         $week_num = $i == $week_cnt ? 'Wild Card' : $i + 1;
         for ($j = 0; $j < $game_cnt; $j++) {
             $datetime = date('Y-m-d', $start_dt + $seven_days * $i) . ' ' . date('H:i:s', $games_tm + $two_hours * $j);
             $game_num = $j + 1;
             $league = League::where('season', $season)->where('venue_id', $venue_id)->where('activity', $activity)->first();
             if (!$league) {
                 $league = new League();
                 $league->season = $season;
                 $league->venue_id = $venue_id;
                 $league->activity = $activity;
                 $league->save();
             }
             $event = new Event();
             $event->league_id = $league->id;
             $event->season = $league->season;
             $event->venue_id = $league->venue_id;
             $event->datetime = $datetime;
             $event->week_num = $week_num;
             $event->game_num = $game_num;
             $event->activity = $league->activity;
             $events[] = $event;
         }
     }
     try {
         DB::transaction(function () use($events) {
             foreach ($events as $event) {
                 $event->save();
             }
         });
         $_SESSION['ALERT'] = alert('Season Added!', "Season {$season} for " . Venue::find($venue_id)->name . " was created successfully.", 'success');
     } catch (Excepton $e) {
         print_r($e);
         exit;
         $_SESSION['ALERT'] = alert('Season Not Added!', "Season {$season} for " . Venue::find($venue_id)->name . " could not be created.", 'error');
     }
     return redirect('/seasons');
 }
 public function index()
 {
     $season = $_REQUEST['season'] ?: $this->season;
     $activity = $_REQUEST['activity'] ?: 'Poker';
     $venue_id = $_REQUEST['venue_id'] ?: League::where('season', $season)->where('activity', $activity)->value('venue_id');
     $league = League::where('season', $season)->where('activity', $activity)->where('venue_id', $venue_id)->first();
     if (!$league->id) {
         $_SESSION['ALERT'] = alert("No League Found!", "There were no leagues found matching the specified parameters.", "warning");
         return sizeof($_REQUEST) ? redirect("/rankings") : redirect("/");
     }
     $rankings_query = ' select s.player_id as id, concat(p.lastname, ", ", p.forename) as name, concat(p.forename, " ", p.lastname) as fullname, count(*) as games, sum(s.points) as total ';
     $rankings_query .= ' from t_scores s ';
     $rankings_query .= ' join t_events e on e.id = s.event_id ';
     $rankings_query .= ' join t_players p on p.id = s.player_id ';
     $rankings_query .= ' where e.league_id=? ';
     $rankings_query .= ' group by s.player_id ';
     $rankings = DB::select($rankings_query, [$league->id]);
     $points_query = ' select points ';
     $points_query .= ' from t_scores ';
     $points_query .= ' where player_id=? ';
     $points_query .= ' and event_id in ( ';
     $points_query .= ' select id ';
     $points_query .= ' from t_events ';
     $points_query .= ' where league_id=? ';
     $points_query .= ' ) ';
     $points_query .= ' order by points desc ';
     $points_query .= ' limit ' . $league->ranked_at;
     array_walk($rankings, function (&$ranking) use($points_query, $league) {
         $ranking->points = DB::select($points_query, [$ranking->id, $league->id]);
         $ranking->points = array_map(function ($p) {
             return $p->points;
         }, $ranking->points);
         $ranking->value = $ranking->games >= $league->ranked_at ? $league->ranking == 'AVG' ? floor(array_sum($ranking->points) / $league->ranked_at) : array_sum($ranking->points) : -1;
     });
     $ranked = array_filter($rankings, function ($ranking) {
         return $ranking->value !== -1;
     });
     usort($ranked, function ($a, $b) {
         return $b->value - $a->value;
     });
     $unranked = array_filter($rankings, function ($ranking) {
         return $ranking->value === -1;
     });
     usort($unranked, function ($a, $b) {
         return $b->total - $a->total;
     });
     $seasonPointsLeaders = array_filter($rankings, function ($ranking) {
         return $ranking->total > 0;
     });
     usort($seasonPointsLeaders, function ($a, $b) {
         return $b->total - $a->total;
     });
     $seasonPointsLeaders = array_slice($seasonPointsLeaders, 0, 1);
     $wildCardWinners = User::whereHas('scores', function ($query) use($league) {
         $query->where('finished', '1')->whereHas('event', function ($query) use($league) {
             $query->where('league_id', $league->id)->where('week_num', 'Wild Card');
         });
     })->get();
     return view('pages.rankings', compact('league', 'ranked', 'unranked', 'seasonPointsLeaders', 'wildCardWinners'));
 }
 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $leagues = League::all();
     $stadiums = Stadium::all();
     $teams = Team::all();
     return view('admin.fixtures.create', compact('leagues', $leagues, 'teams', $teams, 'stadiums', $stadiums));
 }
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $year = date('Y');
     $month = date('n');
     $day = date('j');
     $question = Question::where('year', $year)->where('month', $month)->where('day', $day)->first();
     if (count($question)) {
         $leagues = League::where('year', $question->leagueYear())->where('month', $question->leagueMonth())->get();
         foreach ($leagues as $key => $league) {
             $players = json_decode($league->users);
             foreach ($players as $key => $player) {
                 $user = User::find($player);
                 if ($user->deadline_reminder && $user->active) {
                     $answers = Answer::where('question_id', $question->id)->where('user_id', $user->id)->first();
                     if (!count($answers)) {
                         Mail::send('emails.deadlinereminder', [], function ($message) use($user) {
                             $message->from('*****@*****.**', 'Liga Quiz Portugal');
                             $message->to($user->email, $user->fullName())->subject('Quiz ainda não respondido');
                         });
                     }
                 }
             }
         }
     }
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('leagues')->delete();
     League::create(['league_id' => '1', 'name' => 'Winter 2015 Monday A/B League', 'start_date' => '2015-10-01', 'end_date' => '2016-02-18', 'url' => '???', 'format_id' => 1, 'location_id' => 1]);
     League::create(['league_id' => '2', 'name' => 'Winter 2015 Wednesday C/D League', 'start_date' => '2015-10-01', 'end_date' => '2016-02-18', 'url' => '???', 'format_id' => 1, 'location_id' => 1]);
     League::create(['league_id' => '3', 'name' => 'Spring 2016 Monday A/B League', 'start_date' => '2016-01-15', 'end_date' => '2016-03-20', 'url' => '???', 'format_id' => 1, 'location_id' => 1]);
     League::create(['league_id' => '4', 'name' => 'Spring 2016 Wednesday C/D League', 'start_date' => '2016-01-15', 'end_date' => '2016-03-20', 'url' => '???', 'format_id' => 1, 'location_id' => 1]);
 }
 public function index()
 {
     $season = $_REQUEST['season'] ?: $this->season;
     $activity = $_REQUEST['activity'] ?: 'Poker';
     $venue_id = $_REQUEST['venue_id'] ?: League::where('season', $season)->where('activity', $activity)->value('venue_id');
     $league = League::where('season', $season)->where('activity', $activity)->where('venue_id', $venue_id)->first();
     return view('pages.billing', compact('league'));
 }
 /**
  * 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
     }
 }
 /**
  * Fills leagues table
  *
  */
 public function run()
 {
     $faker = Faker::create();
     foreach (range(1, 10) as $index) {
         $l = League::create(['name' => $faker->name(), 'abbreviation' => $faker->realText(10), 'description' => $faker->realText(150)]);
         $l->game()->associate(Game::first())->save();
         //associate league with first game
     }
 }
 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     Validator::extend('quiz_already_created', function ($attribute, $value, $parameters, $validator) {
         $date = explode('/', $value);
         $questions = Question::where('year', $date[2])->where('month', $date[1])->where('day', $date[0])->get()->count();
         if ($questions) {
             return false;
         } else {
             return true;
         }
     });
     Validator::extend('league_already_created', function ($attribute, $value, $parameters, $validator) {
         $date = explode('/', $value);
         $league = League::where('year', $date[1])->where('month', $date[0])->where('leaguename_id', $validator->getData()['league'])->get()->count();
         if ($league) {
             return false;
         } else {
             return true;
         }
     });
     Validator::extend('specialquiz_already_created', function ($attribute, $value, $parameters, $validator) {
         $date = explode('/', $value);
         $quiz = Specialquiz::where('year', $date[2])->where('month', $date[1])->where('day', $date[0])->get()->count();
         if ($quiz) {
             return false;
         } else {
             return true;
         }
     });
     $year = date('Y');
     $month = date('n');
     $day = date('j');
     $specialquiz = Specialquiz::where('year', $year)->where('month', $month)->where('day', $day)->first();
     $globalSpecialQuiz = null;
     if (count($specialquiz)) {
         $globalSpecialQuiz = $specialquiz;
     }
     view()->share('global_specialquiz', $globalSpecialQuiz);
     $quiz = Question::where('year', $year)->where('month', $month)->where('day', $day)->first();
     if (count($quiz)) {
         view()->share('global_leaguequiz', true);
     } else {
         view()->share('global_leaguequiz', false);
     }
 }
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $year = date('Y');
     $month = date('n');
     $day = date('j');
     $question = Question::where('year', $year)->where('month', $month)->where('day', $day)->first();
     if (count($question)) {
         $leagues = League::where('year', $question->leagueYear())->where('month', $question->leagueMonth())->get();
         foreach ($leagues as $key => $league) {
             $players = json_decode($league->users);
             foreach ($players as $key => $player) {
                 $user = User::find($player);
                 if ($user->daily_reminder && $user->active) {
                     Mail::send('emails.dailyreminder', [], function ($message) use($user) {
                         $message->from('*****@*****.**', 'Liga Quiz Portugal');
                         $message->to($user->email, $user->fullName())->subject('Novo quiz já disponível');
                     });
                 }
             }
         }
     }
     $specialquiz = Specialquiz::where('year', $year)->where('month', $month)->where('day', $day)->first();
     if (count($specialquiz)) {
         $users = User::all();
         if ($specialquiz->user_id) {
             $author = User::find($specialquiz->user_id)->fullName();
         } else {
             $author = 'Quiz Portugal';
         }
         foreach ($users as $key => $user) {
             if (strtotime("+1 day", strtotime($user->subscription)) > time() || $user->isAdmin()) {
                 if ($user->daily_reminder && $user->active) {
                     $data = array('specialquiz' => $specialquiz, 'author' => $author);
                     Mail::send('emails.specialquiz', $data, function ($message) use($user) {
                         $message->from('*****@*****.**', 'Liga Quiz Portugal');
                         $message->to($user->email, $user->fullName())->subject('Quiz especial disponível');
                     });
                 }
             }
         }
     }
 }
 public function index()
 {
     $season = $_REQUEST['season'] ?: $this->season;
     $activity = $_REQUEST['activity'] ?: 'Poker';
     $venue_id = $_REQUEST['venue_id'] ?: League::where('season', $season)->where('activity', $activity)->value('venue_id');
     $league = League::where('season', $season)->where('activity', $activity)->where('venue_id', $venue_id)->first();
     if (!$league->id) {
         $_SESSION['ALERT'] = alert("No Event Found!", "There were no events found matching the specified parameters.", "warning");
         return sizeof($_REQUEST) ? redirect("/events") : redirect("/");
     }
     $week_num = $_REQUEST['week_num'] ?: $league->events()->where('datetime', '<=', date('Y-m-d'))->max('week_num') ?: 1;
     //DB::select('select max(week_num) as week_num from t_events where league_id=? and datetime<=?', [$league->id, date('Y-m-d')])[0]->week_num ?: 1;
     $game_num = $_REQUEST['game_num'] ?: 1;
     $event_id = $league->events()->where('week_num', $week_num)->where('game_num', $game_num)->first()->id;
     if (!$event_id) {
         $_SESSION['ALERT'] = alert("No Event Found!", "There were no events found matching the specified parameters.", "warning");
         return redirect("/events");
     }
     return redirect("/events/{$event_id}");
 }
 public function index()
 {
     $season = League::whereHas('events', function ($query) {
         $query->where('datetime', '<=', date('Y-m-d'));
     })->max('season');
     $venues = \App\Venue::where(function ($query) {
         $query->whereRaw('private is not true');
         $query->orWhereRaw('id in (select venue_id from t_venue_players where player_id = ' . (Auth::user()->id ?: 0) . ')');
     });
     $venuesLive = with(clone $venues)->whereHas('leagues', function ($query) use($season) {
         $query->where('season', '>=', $season);
     })->get();
     $venuesPast = with(clone $venues)->whereDoesntHave('leagues', function ($query) use($season) {
         $query->where('season', '>=', $season);
     })->get();
     $venuesLive->each(function ($venue) {
         $venue->current = 1;
     });
     $venuesPast->each(function ($venue) {
         $venue->current = null;
     });
     $venues = array_merge($venuesLive->all(), $venuesPast->all());
     return view('venues.index', compact('venues'));
 }
 public function insertLeague(Request $request)
 {
     $this->validate($request, ['date' => ['required', 'league_already_created'], 'league' => ['required'], 'users' => ['required']]);
     $input = $request->all();
     $date = explode('/', $input['date']);
     $month = $date[0];
     $year = $date[1];
     $league = new League();
     $league->leaguename_id = $input['league'];
     $league->year = $year;
     $league->month = $month;
     $league->users = json_encode($input['users']);
     $league->save();
     $players = $input['users'];
     $rounds = 9;
     $schedule = [];
     for ($leg = 0; $leg < 2; $leg++) {
         for ($round = 1; $round <= $rounds; $round++) {
             $realRound = $round + $leg * 10;
             $schedule[$realRound] = [];
             for ($game = 1; $game <= count($players) / 2; $game++) {
                 $pos1 = $game - 1;
                 $pos2 = count($players) - ($game - 1) - 1;
                 $schedule[$realRound][$game]['home'] = $players[$pos1];
                 $schedule[$realRound][$game]['away'] = $players[$pos2];
                 Game::create(['league_id' => $league->id, 'round' => $realRound, 'user_1_id' => $players[$pos1], 'user_2_id' => $players[$pos2]]);
             }
             // ROTATE ARRAY
             $playersTemp = $players;
             $top = array_shift($playersTemp);
             $last = array_pop($playersTemp);
             $players = [$last];
             foreach ($playersTemp as $value) {
                 $players[] = $value;
             }
             array_unshift($players, $top);
         }
     }
     return redirect()->route('admin.leagues');
 }
Beispiel #14
0
 public function getAllLeague()
 {
     $allLeagues = League::getAllLeague();
     return \Response::json($allLeagues, 200);
 }
<?php

namespace App\ViewComposers;

use View;
use App\League;
View::composer('partials.select-league', function ($view) {
    $activities = League::groupBy('activity')->get(['activity'])->pluck('activity');
    $view->with('activities', $activities);
});
Beispiel #16
0
 public function bowlers()
 {
     $baseURL = '../public/';
     $allBowlers = User::getAllBolwerDetails();
     if (empty($allBowlers)) {
         $allBowlers = 0;
     }
     foreach ($allBowlers as $bowler) {
         $Bowlers[$bowler->id][] = ['data' => $bowler];
     }
     $userDetails = Auth::user();
     $jackpotCount = Lottery::getJackpotCountOfUser($userDetails->id);
     $totalTickets = Lottery::getTotalLotteryCount($userDetails->id);
     $totalJackpot = Lottery::getTotaljackpotAmountofUser($userDetails->id);
     $totalLeagues = League::getLeagueByBowler($userDetails->id);
     return \View::make('bowlers')->with('Bowlers', $Bowlers)->with('userDetails', $userDetails)->with('jackpotCount', $jackpotCount)->with('totalTickets', $totalTickets)->with('totalJackpot', $totalJackpot)->with('totalLeagues', $totalLeagues)->with('baseURL', $baseURL);
 }
<?php

namespace App\ViewComposers;

use View;
use Auth;
use App\Venue;
use App\League;
View::composer('partials.select-venue', function ($view) {
    $season = League::whereHas('events', function ($query) {
        $query->where('datetime', '<=', date('Y-m-d'));
    })->max('season');
    $venues = Venue::where(function ($query) {
        $query->whereRaw('private is not true');
        $query->orWhereRaw('id in (select venue_id from t_venue_players where player_id = ' . (Auth::user()->id ?: 0) . ')');
    });
    $venuesLive = with(clone $venues)->whereHas('leagues', function ($query) use($season) {
        $query->where('season', '>=', $season);
    })->get();
    $venuesPast = with(clone $venues)->whereDoesntHave('leagues', function ($query) use($season) {
        $query->where('season', '>=', $season);
    })->get();
    $view->with('venuesLive', $venuesLive)->with('venuesPast', $venuesPast);
});
 public function viewTodayQuiz()
 {
     $user_id = Auth::user()->id;
     $year = date('Y');
     $month = date('n');
     $day = date('j');
     $firstMonday = date("j", strtotime('first monday of ' . $year . '-' . $month));
     $leagueYear = $year;
     if ($firstMonday > $day) {
         $leagueMonth = $month - 1;
         if (!$leagueMonth) {
             $leagueMonth = 12;
             $leagueYear--;
         }
     } else {
         $leagueMonth = $month;
     }
     $dayOffset = 0;
     $round = 0;
     for ($i = 0; $i < 20; $i++) {
         $round++;
         if (date("d-m-Y") == date("d-m-Y", strtotime('first monday of ' . $leagueYear . '-' . $leagueMonth) + 86400 * $dayOffset)) {
             break;
         }
         if (($i + 1) % 5 == 0) {
             $dayOffset = $dayOffset + 3;
         } else {
             $dayOffset++;
         }
     }
     if ($round % 10 == 0) {
         $solo = true;
     } else {
         $solo = false;
     }
     $leagues = League::where('year', $year)->where('month', $leagueMonth)->get();
     $league_id = 0;
     foreach ($leagues as $key => $league) {
         $players = json_decode($league->users);
         if (in_array($user_id, $players)) {
             $league_id = $league->id;
         }
     }
     $opponent = 0;
     $roundGame = Game::where('user_1_id', $user_id)->where('round', $round)->where('league_id', $league_id)->first();
     if (!count($roundGame)) {
         $roundGame = Game::where('user_2_id', $user_id)->where('round', $round)->where('league_id', $league_id)->first();
         if (count($roundGame)) {
             $opponent = $roundGame->user_1_id;
         }
     } else {
         $opponent = $roundGame->user_2_id;
     }
     if ($opponent) {
         $start = (new Carbon('now'))->hour(0)->minute(0)->second(0);
         $end = (new Carbon('now'))->hour(23)->minute(59)->second(59);
         $answers = Answer::where('submitted', 1)->where('user_id', $opponent)->whereNotBetween('updated_at', [$start, $end])->get();
         $genresCollection = Genre::all();
         $subgenresCollection = Subgenre::all();
         $genres = array();
         foreach ($genresCollection as $key => $genre) {
             $genres[$genre->id] = array();
             $genres[$genre->id]['info'] = $genre;
             $genres[$genre->id]['corrects'] = 0;
             $genres[$genre->id]['total'] = 0;
             $genres[$genre->id]['percentage'] = 0;
         }
         $subgenres = array();
         foreach ($subgenresCollection as $key => $subgenre) {
             $subgenres[$subgenre->id] = array();
             $subgenres[$subgenre->id]['info'] = $subgenre;
             $subgenres[$subgenre->id]['corrects'] = 0;
             $subgenres[$subgenre->id]['total'] = 0;
             $subgenres[$subgenre->id]['percentage'] = 0;
         }
         foreach ($answers as $key => $answer) {
             $answerQuestion = $answer->question()[0];
             $answerGenre = $answerQuestion->genre_id;
             $answerSubgenre = $answerQuestion->subgenre_id;
             if ($answer->correct) {
                 $genres[$answerGenre]['corrects']++;
                 $subgenres[$answerSubgenre]['corrects']++;
             }
             $genres[$answerGenre]['total']++;
             $subgenres[$answerSubgenre]['total']++;
         }
         foreach ($genres as $key => $genre) {
             if ($genres[$key]['total']) {
                 $genres[$key]['percentage'] = round($genre['corrects'] / $genre['total'] * 100, 2);
             }
         }
         $percentage = array();
         foreach ($subgenres as $key => $subgenre) {
             if ($subgenres[$key]['total']) {
                 $subgenres[$key]['percentage'] = round($subgenre['corrects'] / $subgenre['total'] * 100, 2);
                 $percentage[$key] = $subgenres[$key]['percentage'];
             } else {
                 $subgenres[$key]['percentage'] = 0;
                 $percentage[$key] = 0;
             }
         }
         if ($percentage) {
             array_multisort($percentage, SORT_DESC, $subgenres);
         }
         $opponent = User::find($opponent);
     } else {
         $genres = [];
         $subgenres = [];
     }
     $questions = Question::where('year', $year)->where('month', $month)->where('day', $day)->get();
     $filetype = [];
     $answers = [];
     foreach ($questions as $key => $question) {
         $filetype[$question->genre_id] = pathinfo($question->filename, PATHINFO_EXTENSION);
         $answers[$question->genre_id] = '';
     }
     $submitted = false;
     foreach ($questions as $key => $question) {
         $answer = Answer::where('question_id', $question['id'])->where('user_id', $user_id)->orderBy('id', 'desc')->first();
         $answers[$question->genre_id] = $answer;
         if ($answer) {
             if ($answer->submitted) {
                 $submitted = true;
             }
         }
     }
     if ($submitted) {
         return view('quiz_answered')->with(['questions' => $questions, 'answers' => $answers, 'filetype' => $filetype, 'year' => $year, 'month' => $month, 'day' => $day, 'solo' => $solo]);
     } else {
         return view('quiz')->with(['questions' => $questions, 'filetype' => $filetype, 'answers' => $answers, 'solo' => $solo, 'genres' => $genres, 'subgenres' => $subgenres, 'opponent' => $opponent]);
     }
 }
 public function GetLeagueByCode($code)
 {
     return League::where('code', $code)->first();
 }
Beispiel #20
0
 /**
  * Remove the league from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $league = League::findOrFail($id);
     $league->delete();
     return redirect('/leagues');
 }
 /**
  * Display the form to edit a match
  * @param  [type] $league_id [description]
  * @param  [type] $match_id  [description]
  * @return [type]            [description]
  */
 public function editMatch($league_id, $match_id)
 {
     $league = League::find($league_id);
     $players = \DB::table('league_players')->where('leage_id', '=', $league_id)->orderby('last_name')->orderby('first_name');
     //dropdown list
     $players_list = Player::orderby('last_name')->orderby('first_name')->get();
     $players_list = $players_list->lists('last_first_name', 'player_id');
     //get the match
     $match = Match::find($match_id);
     if (!is_null($match)) {
         //Get the game
         $match_game = MatchGame::find($match_id);
         if (!is_null($match_game)) {
             $game = Game::find($match_game->game_id);
         } else {
             $game = new Game();
         }
     }
     return view('pages/tools.league.match.edit', compact('match', 'game', 'league', 'players_list'));
 }
Beispiel #22
0
 public function getBowlersInLeague($leagueId)
 {
     $isValidToken = User::checkAuth();
     if ($isValidToken != 0) {
         $allBowlers = League::getBowlersinLeague($leagueId);
         if (empty($allBowlers)) {
             return "Invalid League ID or No Bowlers in this League";
         }
         return \Response::json($allBowlers, 200);
     } else {
         return json_encode("Please enter valid Authentication Token");
     }
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     $league = League::find($id);
     $path = $league->logo_path;
     $name = $league->logo_name;
     $file = $path . $name;
     if (\File::isFile($file)) {
         \File::delete($file);
     }
     $league->delete();
     flash()->success('', 'Lyga ištrinta!');
     return redirect()->back();
 }
 /**
  * Update the specified tournament in storage.
  *
  * @param  int  $id id of tournament which should be updated
  * @return Response route where to redirect after update
  */
 public function update($id)
 {
     $validator = Validator::make(Input::all(), Tournament::rules($id));
     if ($validator->fails()) {
         return redirect('/tournaments/edit/' . $id)->withInput()->withErrors($validator);
     }
     $tournament = Tournament::findOrFail($id);
     $tournament->name = htmlspecialchars(Input::get('name'));
     $tournament->type = htmlspecialchars(Input::get('type'));
     $tournament->min_number_of_teams = Input::get('min_number_of_teams');
     $tournament->max_number_of_teams = Input::get('max_number_of_teams');
     $tournament->start_date = Input::get('start_date');
     $tournament->end_date = Input::get('end_date');
     $tournament->description = htmlspecialchars(Input::get('description'));
     $tournament->league()->associate(League::findOrFail(Input::get('league_id')));
     $tournament->save();
     return redirect('/tournaments');
     //
 }
Beispiel #25
0
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     League::destroy($id);
     return redirect()->route('league.index');
 }