コード例 #1
0
ファイル: TippsController.php プロジェクト: sewede/footipp
 public function calcPoints()
 {
     //Get Tipps
     $tipps = Tipp::join('matches', 'tipps.match_id', '=', 'matches.id')->select('matches.id', 'matches.home_goals as erg1', 'matches.away_goals as erg2', 'tipps.*')->orderBy('date')->get();
     //check points
     $count = count($tipps);
     for ($i = 0; $i < $count; $i++) {
         $points = 0;
         if ($tipps[$i]->home_goals === $tipps[$i]->erg1) {
             $points += 1;
         }
         if ($tipps[$i]->away_goals === $tipps[$i]->erg2) {
             $points += 1;
         }
         if ($tipps[$i]->home_goals - $tipps[$i]->away_goals === $tipps[$i]->erg1 - $tipps[$i]->erg2) {
             $points += 6;
         }
         if ($tipps[$i]->home_goals - $tipps[$i]->away_goals > 0 && $tipps[$i]->erg1 - $tipps[$i]->erg2 > 0) {
             $points += 4;
         }
         if ($tipps[$i]->home_goals - $tipps[$i]->away_goals < 0 && $tipps[$i]->erg1 - $tipps[$i]->erg2 < 0) {
             $points += 4;
         }
         if ($tipps[$i]->home_goals - $tipps[$i]->away_goals === 0 && $tipps[$i]->erg1 - $tipps[$i]->erg2 === 0) {
             $points += 4;
         }
         if ($tipps[$i]->home_goals === $tipps[$i]->erg1 && $tipps[$i]->away_goals === $tipps[$i]->erg2) {
             $points += 3;
         }
         if ($tipps[$i]->erg1 != null) {
             Tipp::where('id', $tipps[$i]->id)->update(['points' => $points]);
         }
     }
     return redirect('tipps');
 }
コード例 #2
0
ファイル: ShowMatches.php プロジェクト: sewede/footipp
 public function getLatest()
 {
     Carbon::setlocale('de');
     setlocale(LC_TIME, 'de_DE.utf8');
     $userID = Auth::id();
     $userIDExistsInTipps = Tipp::where('user_id', $userID)->first();
     if ($userIDExistsInTipps) {
         $matches = Matches::where('league_id', 1)->where('date', '>', Carbon::now())->where('tipps.user_id', $userID)->join('clubs as homeclub', 'matches.home_id', '=', 'homeclub.id')->join('clubs as awayclub', 'matches.away_id', '=', 'awayclub.id')->join('tipps', 'tipps.match_id', '=', 'matches.id')->select('matches.*', 'homeclub.club as home', 'awayclub.club as away', 'tipps.home_goals as tipp_home', 'tipps.away_goals as tipp_away')->orderBy('date')->get();
         return $matches;
     } else {
         $matches = Matches::where('league_id', 1)->where('date', '>', Carbon::now())->join('clubs as homeclub', 'matches.home_id', '=', 'homeclub.id')->join('clubs as awayclub', 'matches.away_id', '=', 'awayclub.id')->select('matches.*', 'homeclub.club as home', 'awayclub.club as away')->orderBy('date')->get();
         return $matches;
     }
 }