gregorybesson /
PlaygroundGame
| @@ 689-725 (lines=37) @@ | ||
| 686 | return $header; |
|
| 687 | } |
|
| 688 | ||
| 689 | public function getEntriesQuery($game) |
|
| 690 | { |
|
| 691 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 692 | ||
| 693 | $qb = $em->createQueryBuilder(); |
|
| 694 | $qb->select(' |
|
| 695 | r.id, |
|
| 696 | u.username, |
|
| 697 | u.title, |
|
| 698 | u.firstname, |
|
| 699 | u.lastname, |
|
| 700 | u.email, |
|
| 701 | u.optin, |
|
| 702 | u.optinPartner, |
|
| 703 | u.address, |
|
| 704 | u.address2, |
|
| 705 | u.postalCode, |
|
| 706 | u.city, |
|
| 707 | u.telephone, |
|
| 708 | u.mobile, |
|
| 709 | u.created_at, |
|
| 710 | u.dob, |
|
| 711 | e.winner, |
|
| 712 | e.socialShares, |
|
| 713 | e.playerData, |
|
| 714 | e.updated_at, |
|
| 715 | r.totalCorrectAnswers |
|
| 716 | ') |
|
| 717 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
| 718 | ->innerJoin('r.entry', 'e') |
|
| 719 | ->leftJoin('e.user', 'u') |
|
| 720 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 721 | ||
| 722 | $qb->setParameter('game', $game); |
|
| 723 | ||
| 724 | return $qb->getQuery(); |
|
| 725 | } |
|
| 726 | ||
| 727 | public function getGameEntity() |
|
| 728 | { |
|
| @@ 546-581 (lines=36) @@ | ||
| 543 | return $games; |
|
| 544 | } |
|
| 545 | ||
| 546 | public function getEntriesQuery($game) |
|
| 547 | { |
|
| 548 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 549 | ||
| 550 | $qb = $em->createQueryBuilder(); |
|
| 551 | $qb->select(' |
|
| 552 | e.id, |
|
| 553 | u.username, |
|
| 554 | u.title, |
|
| 555 | u.firstname, |
|
| 556 | u.lastname, |
|
| 557 | u.email, |
|
| 558 | u.optin, |
|
| 559 | u.optinPartner, |
|
| 560 | u.address, |
|
| 561 | u.address2, |
|
| 562 | u.postalCode, |
|
| 563 | u.city, |
|
| 564 | u.country, |
|
| 565 | u.telephone, |
|
| 566 | u.mobile, |
|
| 567 | u.created_at, |
|
| 568 | u.dob, |
|
| 569 | e.winner, |
|
| 570 | e.socialShares, |
|
| 571 | e.playerData, |
|
| 572 | e.geoloc, |
|
| 573 | e.updated_at |
|
| 574 | ') |
|
| 575 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
| 576 | ->leftJoin('e.user', 'u') |
|
| 577 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 578 | ||
| 579 | $qb->setParameter('game', $game); |
|
| 580 | ||
| 581 | return $qb->getQuery(); |
|
| 582 | } |
|
| 583 | ||
| 584 | public function getEntriesHeader($game) |
|
| @@ 677-714 (lines=38) @@ | ||
| 674 | return $header; |
|
| 675 | } |
|
| 676 | ||
| 677 | public function getEntriesQuery($game) |
|
| 678 | { |
|
| 679 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 680 | ||
| 681 | $qb = $em->createQueryBuilder(); |
|
| 682 | $qb->select(' |
|
| 683 | p.id, |
|
| 684 | u.username, |
|
| 685 | u.title, |
|
| 686 | u.firstname, |
|
| 687 | u.lastname, |
|
| 688 | u.displayName, |
|
| 689 | u.email, |
|
| 690 | u.optin, |
|
| 691 | u.optinPartner, |
|
| 692 | u.address, |
|
| 693 | u.address2, |
|
| 694 | u.postalCode, |
|
| 695 | u.city, |
|
| 696 | u.telephone, |
|
| 697 | u.mobile, |
|
| 698 | u.created_at, |
|
| 699 | u.dob, |
|
| 700 | e.winner, |
|
| 701 | e.socialShares, |
|
| 702 | e.playerData, |
|
| 703 | e.updated_at, |
|
| 704 | p.status, |
|
| 705 | p |
|
| 706 | ') |
|
| 707 | ->from('PlaygroundGame\Entity\PostVotePost', 'p') |
|
| 708 | ->innerJoin('p.entry', 'e') |
|
| 709 | ->leftJoin('p.user', 'u') |
|
| 710 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 711 | ||
| 712 | $qb->setParameter('game', $game); |
|
| 713 | ||
| 714 | return $qb->getQuery(); |
|
| 715 | } |
|
| 716 | ||
| 717 | /** |
|
