/** * @return int */ public function maxWonStreak() { $userIds = Game::where(['finished' => true])->innerJoin('winner_game_user')->order('games.id')->select(['user_id'])->fetchAll(); $maxWonStreak = 0; $tmpStreak = 0; foreach ($userIds as $userId) { if ($userId[0] == $this->id) { $tmpStreak++; } else { $maxWonStreak = $tmpStreak > $maxWonStreak ? $tmpStreak : $maxWonStreak; $tmpStreak = 0; } } return $maxWonStreak; }
public function index() { $this->view->games = Game::where(['finished' => true])->order('started_at desc, id desc')->fetchAll(); $this->view->render(); }