/**
  * @param User $user
  * @return ReportCard
  */
 public function getForUser(User $user)
 {
     $uid = (string) $user->getId();
     if ($this->cache->contains($uid)) {
         return $this->cache->fetch($uid);
     }
     /** @var EGPlayerStatsRepository $statsRepo */
     $statsRepo = $this->em->getRepository('GotChosenSiteBundle:EGPlayerStats');
     /** @var EGGameResultRepository $resultsRepo */
     $resultsRepo = $this->em->getRepository('GotChosenSiteBundle:EGGameResult');
     /** @var Scholarship $egScholarship */
     $egScholarship = $this->em->getRepository('GotChosenSiteBundle:Scholarship')->getCurrentEvoGames();
     $playerStats = $statsRepo->getOrCreate($user, $egScholarship, date('Y-m'));
     $card = new ReportCard();
     $card->rank = $playerStats->getRank();
     $card->maxRank = $statsRepo->getTotalPlayers(date('Y-m'));
     $card->qualifierPlays = $statsRepo->getTotalPlaySessions($user, $egScholarship, EGPlaySession::PHASE_QUALIFIER);
     $card->contestPlays = $statsRepo->getTotalPlaySessions($user, $egScholarship, EGPlaySession::PHASE_CONTEST);
     $card->wins = $resultsRepo->getTotalWins($user, date('Y-m'));
     $card->feedbacksRated = min(20, $playerStats->getFeedbacksRated());
     $card->pointsWinning = $playerStats->getGameplayPoints();
     $card->pointsBonus = $playerStats->getBonusPoints();
     $card->pointsFeedback = $playerStats->getFeedbackPoints();
     $card->pointsTotal = $playerStats->getTotalPoints();
     $this->cache->save($uid, $card);
     return $card;
 }
 public function recalcFeedbackPoints(User $user, Scholarship $scholarship, $month)
 {
     $em = $this->getEntityManager();
     $conn = $em->getConnection();
     /** @var EGPlayerStatsRepository $statsRepo */
     $statsRepo = $em->getRepository('GotChosenSiteBundle:EGPlayerStats');
     // grab all the rated games with their highest ratings
     $stmt = $conn->prepare('SELECT f.game_id, MAX(f.developerRating) max_rating
          FROM EGFeedback f
          WHERE f.user_id = :user
              AND f.createdDate >= :start
              AND f.createdDate < :end
              AND f.ratedDate IS NOT NULL
          GROUP BY f.game_id
          ORDER BY max_rating DESC');
     $stmt->bindValue('user', $user->getId(), \PDO::PARAM_INT);
     $stmt->bindValue('start', $month . '-01 00:00:00', \PDO::PARAM_STR);
     $stmt->bindValue('end', Dates::nextMonth($month) . '-01 00:00:00', \PDO::PARAM_STR);
     $stmt->execute();
     $totalFeedback = 0;
     $count = 0;
     while ($row = $stmt->fetch()) {
         $totalFeedback += $row['max_rating'];
         $count++;
         // stop at 100 feedback or 20 games
         if ($totalFeedback >= 100 || $count >= 20) {
             break;
         }
     }
     $totalFeedback = min($totalFeedback, 100);
     $pstats = $statsRepo->getOrCreate($user, $scholarship, $month);
     $pstats->setFeedbackPoints($totalFeedback);
     $pstats->updateTotalPoints();
     $em->flush();
 }
 /**
  * @param User $user
  * @param $month
  * @return integer
  */
 public function getTotalWins(User $user, $month)
 {
     $this->assertMonth($month);
     $q = $this->getEntityManager()->createQuery('SELECT SUM(gr.wins) FROM GotChosenSiteBundle:EGGameResult gr
          WHERE gr.statsMonth = :month AND gr.user = :user');
     $q->setParameter('month', $month);
     $q->setParameter('user', $user->getId());
     return $q->getSingleScalarResult() ?: 0;
     // This function was returning NULL instead of 0
 }
 /**
  * Retrieves play sessions for the given user, optionally filtered by month.
  *
  * @param User $player
  * @param null|string $month In the form of YYYY-MM
  * @return array
  */
 public function findPlaySessions(User $player, $month = null)
 {
     $q = $this->getEntityManager()->createQueryBuilder();
     $q->select('ps', 'g')->from('GotChosenSiteBundle:EGPlaySession', 'ps')->join('ps.game', 'g')->where('ps.player = :user')->setParameter('user', $player->getId())->andWhere('ps.isCompleted = 1');
     if ($month && preg_match('/^\\d{4}-\\d{2}$/', $month)) {
         $q->andWhere('ps.endDate >= :start')->setParameter('start', $month . '-01 00:00:00')->andWhere('ps.endDate < :end')->setParameter('end', Dates::nextMonth($month) . '-01 00:00:00');
     }
     $q->orderBy('ps.endDate');
     return $q->getQuery()->getResult();
 }
 /**
  * @param User $sponsor
  * @param Scholarship $sship40k
  * @return EntrySponsor[]
  */
 public function getSponsoring(User $sponsor, Scholarship $sship40k)
 {
     $em = $this->getEntityManager();
     $q = $em->createQuery('SELECT es, e, u FROM GotChosenSiteBundle:EntrySponsor es
          JOIN es.user sponsor
          JOIN es.entry e
          JOIN e.user u
          JOIN e.scholarship s
          WHERE s.id = ?1 AND sponsor.id = ?2');
     $q->setParameter(1, $sship40k->getId());
     $q->setParameter(2, $sponsor->getId());
     return $q->getResult();
 }
예제 #6
0
 /**
  * Determines if this property can be seen by the given $viewer.
  * If $viewer is the property's owner, or an administrator, returns true. Otherwise it will compare
  * this property's visible networks with the networks of the viewer, and if at least one matches,
  * this method will return true.
  *
  * @param User $viewer
  * @param array $viewerNetworkIds
  * @return bool
  */
 public function isVisibleBy(User $viewer = null, $viewerNetworkIds = null)
 {
     $visibility = $this->getVisibility();
     // if public, true right away. if not public and the viewer is a guest, false right away.
     if ($visibility == self::VISIBLE_PUBLIC) {
         return true;
     } else {
         if (!$viewer) {
             return false;
         }
     }
     // if we are viewing our own profile, true.
     if ($viewer && $viewer->getId() == $this->getUser()->getId()) {
         return true;
     }
     // if we are an admin, true.
     // however we name these... ROLE_ADMIN is part of symfony, Administrators may be a new thing.
     $viewerRoles = $viewer ? $viewer->getRoles() : [];
     if (in_array('ROLE_SUPER_ADMIN', $viewerRoles) || in_array('Administrator', $viewerRoles)) {
         return true;
     }
     // handle private (false except for owner/admin, handled above), and all registered users.
     if ($visibility == self::VISIBLE_PRIVATE) {
         return false;
     } else {
         if ($visibility == self::VISIBLE_MEMBERS) {
             return $viewer ? true : false;
         }
     }
     // handle custom network-based visibility.
     // if a list of the viewer's network ids is passed, use that to save on processing time.
     if ($viewerNetworkIds === null) {
         $viewerNetworkIds = [];
         foreach ($viewer->getNetworks() as $vnet) {
             $viewerNetworkIds[] = $vnet->getNetwork()->getId();
         }
     }
     return $this->hasIntersectingNetworks($viewerNetworkIds);
 }
예제 #7
0
 public function userHasGame(User $user)
 {
     $gameRepo = $this->em->getRepository('GotChosenSiteBundle:EGGame');
     $game = $gameRepo->findOneBy(['user' => $user->getId()]);
     return !is_null($game);
 }
예제 #8
0
 public static function makePreview(User $toUser, $template, $subject, array $params)
 {
     $mq = new MassMailQueue();
     $mq->setType(self::TYPE_PREVIEW);
     $mq->setFilterSpec(['userId' => $toUser->getId()]);
     $mq->setTemplate($template);
     $mq->setSubject($subject);
     $mq->setParameters($params);
     return $mq;
 }
예제 #9
0
 public function getProperties(User $user, $includeGroups = false)
 {
     $gSelect = "";
     $gJoin = "";
     if ($includeGroups) {
         $gSelect = "g, ";
         $gJoin = "JOIN p.groups g";
     }
     $q = $this->getEntityManager()->createQuery("SELECT up, p, {$gSelect} vn FROM GotChosenSiteBundle:UserProfile up\n             JOIN up.property p\n             {$gJoin}\n             LEFT JOIN up.visibleNetworks vn\n             WHERE up.user = ?1");
     $q->setParameter(1, $user->getId());
     return $q->getResult();
 }