gregorybesson /
PlaygroundGame
| @@ 647-683 (lines=37) @@ | ||
| 644 | return $header; |
|
| 645 | } |
|
| 646 | ||
| 647 | public function getEntriesQuery($game) |
|
| 648 | { |
|
| 649 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 650 | ||
| 651 | $qb = $em->createQueryBuilder(); |
|
| 652 | $qb->select(' |
|
| 653 | r.id, |
|
| 654 | u.username, |
|
| 655 | u.title, |
|
| 656 | u.firstname, |
|
| 657 | u.lastname, |
|
| 658 | u.email, |
|
| 659 | u.optin, |
|
| 660 | u.optinPartner, |
|
| 661 | u.address, |
|
| 662 | u.address2, |
|
| 663 | u.postalCode, |
|
| 664 | u.city, |
|
| 665 | u.telephone, |
|
| 666 | u.mobile, |
|
| 667 | u.created_at, |
|
| 668 | u.dob, |
|
| 669 | e.winner, |
|
| 670 | e.socialShares, |
|
| 671 | e.playerData, |
|
| 672 | e.updated_at, |
|
| 673 | r.totalCorrectAnswers |
|
| 674 | ') |
|
| 675 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
| 676 | ->innerJoin('r.entry', 'e') |
|
| 677 | ->leftJoin('e.user', 'u') |
|
| 678 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 679 | ||
| 680 | $qb->setParameter('game', $game); |
|
| 681 | ||
| 682 | return $qb->getQuery(); |
|
| 683 | } |
|
| 684 | ||
| 685 | public function getGameEntity() |
|
| 686 | { |
|
| @@ 452-487 (lines=36) @@ | ||
| 449 | return $games; |
|
| 450 | } |
|
| 451 | ||
| 452 | public function getEntriesQuery($game) |
|
| 453 | { |
|
| 454 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 455 | ||
| 456 | $qb = $em->createQueryBuilder(); |
|
| 457 | $qb->select(' |
|
| 458 | e.id, |
|
| 459 | u.username, |
|
| 460 | u.title, |
|
| 461 | u.firstname, |
|
| 462 | u.lastname, |
|
| 463 | u.email, |
|
| 464 | u.optin, |
|
| 465 | u.optinPartner, |
|
| 466 | u.address, |
|
| 467 | u.address2, |
|
| 468 | u.postalCode, |
|
| 469 | u.city, |
|
| 470 | u.country, |
|
| 471 | u.telephone, |
|
| 472 | u.mobile, |
|
| 473 | u.created_at, |
|
| 474 | u.dob, |
|
| 475 | e.winner, |
|
| 476 | e.socialShares, |
|
| 477 | e.playerData, |
|
| 478 | e.updated_at |
|
| 479 | ') |
|
| 480 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
| 481 | ->leftJoin('e.user', 'u') |
|
| 482 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 483 | ||
| 484 | $qb->setParameter('game', $game); |
|
| 485 | ||
| 486 | return $qb->getQuery(); |
|
| 487 | } |
|
| 488 | ||
| 489 | public function getEntriesHeader($game) |
|
| 490 | { |
|
| @@ 505-542 (lines=38) @@ | ||
| 502 | return $header; |
|
| 503 | } |
|
| 504 | ||
| 505 | public function getEntriesQuery($game) |
|
| 506 | { |
|
| 507 | $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default'); |
|
| 508 | ||
| 509 | $qb = $em->createQueryBuilder(); |
|
| 510 | $qb->select(' |
|
| 511 | p.id, |
|
| 512 | u.username, |
|
| 513 | u.title, |
|
| 514 | u.firstname, |
|
| 515 | u.lastname, |
|
| 516 | u.email, |
|
| 517 | u.optin, |
|
| 518 | u.optinPartner, |
|
| 519 | u.address, |
|
| 520 | u.address2, |
|
| 521 | u.postalCode, |
|
| 522 | u.city, |
|
| 523 | u.telephone, |
|
| 524 | u.mobile, |
|
| 525 | u.created_at, |
|
| 526 | u.dob, |
|
| 527 | e.winner, |
|
| 528 | e.socialShares, |
|
| 529 | e.playerData, |
|
| 530 | e.updated_at, |
|
| 531 | p.status, |
|
| 532 | p |
|
| 533 | ') |
|
| 534 | ->from('PlaygroundGame\Entity\PostVotePost', 'p') |
|
| 535 | ->innerJoin('p.entry', 'e') |
|
| 536 | ->leftJoin('p.user', 'u') |
|
| 537 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 538 | ||
| 539 | $qb->setParameter('game', $game); |
|
| 540 | ||
| 541 | return $qb->getQuery(); |
|
| 542 | } |
|
| 543 | ||
| 544 | /** |
|
| 545 | * getGameEntries : All entries of a game |
|
