gregorybesson /
PlaygroundGame
| @@ 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 | { |
|
