@@ 638-674 (lines=37) @@ | ||
635 | return $grid; |
|
636 | } |
|
637 | ||
638 | public function getEntriesQuery($game) |
|
639 | { |
|
640 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
641 | ||
642 | $qb = $em->createQueryBuilder(); |
|
643 | $qb->select(' |
|
644 | e.id, |
|
645 | u.username, |
|
646 | u.title, |
|
647 | u.firstname, |
|
648 | u.lastname, |
|
649 | u.email, |
|
650 | u.optin, |
|
651 | u.optinPartner, |
|
652 | u.address, |
|
653 | u.address2, |
|
654 | u.postalCode, |
|
655 | u.city, |
|
656 | u.country, |
|
657 | u.telephone, |
|
658 | u.mobile, |
|
659 | u.created_at, |
|
660 | u.dob, |
|
661 | e.winner, |
|
662 | e.socialShares, |
|
663 | e.playerData, |
|
664 | e.geoloc, |
|
665 | e.updated_at |
|
666 | ') |
|
667 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
668 | ->leftJoin('e.user', 'u') |
|
669 | ->where($qb->expr()->eq('e.game', ':game')); |
|
670 | ||
671 | $qb->setParameter('game', $game); |
|
672 | ||
673 | return $qb; |
|
674 | } |
|
675 | ||
676 | /** |
|
677 | * DEPRECATED |
@@ 176-190 (lines=15) @@ | ||
173 | return $question; |
|
174 | } |
|
175 | ||
176 | public function findRepliesByGame($game) |
|
177 | { |
|
178 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
179 | $qb = $em->createQueryBuilder(); |
|
180 | $qb->select('r') |
|
181 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
182 | ->innerJoin('r.entry', 'e') |
|
183 | ->where('e.game = :game') |
|
184 | ->setParameter('game', $game); |
|
185 | $query = $qb->getQuery(); |
|
186 | ||
187 | $replies = $query->getResult(); |
|
188 | ||
189 | return $replies; |
|
190 | } |
|
191 | ||
192 | public function updatePrediction($question) |
|
193 | { |
|
@@ 693-731 (lines=39) @@ | ||
690 | } |
|
691 | ||
692 | ||
693 | public function getEntriesQuery($game) |
|
694 | { |
|
695 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
696 | ||
697 | $qb = $em->createQueryBuilder(); |
|
698 | $qb->select( |
|
699 | ' |
|
700 | r.id, |
|
701 | u.username, |
|
702 | u.title, |
|
703 | u.firstname, |
|
704 | u.lastname, |
|
705 | u.email, |
|
706 | u.optin, |
|
707 | u.optinPartner, |
|
708 | u.address, |
|
709 | u.address2, |
|
710 | u.postalCode, |
|
711 | u.city, |
|
712 | u.telephone, |
|
713 | u.mobile, |
|
714 | u.created_at, |
|
715 | u.dob, |
|
716 | e.winner, |
|
717 | e.socialShares, |
|
718 | e.playerData, |
|
719 | e.updated_at, |
|
720 | r.totalCorrectAnswers |
|
721 | ' |
|
722 | ) |
|
723 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
724 | ->innerJoin('r.entry', 'e') |
|
725 | ->leftJoin('e.user', 'u') |
|
726 | ->where($qb->expr()->eq('e.game', ':game')); |
|
727 | ||
728 | $qb->setParameter('game', $game); |
|
729 | ||
730 | return $qb; |
|
731 | } |
|
732 | ||
733 | public function getGameEntity() |
|
734 | { |