gregorybesson /
PlaygroundGame
| @@ 425-458 (lines=34) @@ | ||
| 422 | return $games; |
|
| 423 | } |
|
| 424 | ||
| 425 | public function getEntriesQuery($game) |
|
| 426 | { |
|
| 427 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 428 | ||
| 429 | $qb = $em->createQueryBuilder(); |
|
| 430 | $qb->select(' |
|
| 431 | e.id, |
|
| 432 | u.username, |
|
| 433 | u.title, |
|
| 434 | u.firstname, |
|
| 435 | u.lastname, |
|
| 436 | u.email, |
|
| 437 | u.optin, |
|
| 438 | u.optinPartner, |
|
| 439 | u.address, |
|
| 440 | u.address2, |
|
| 441 | u.postalCode, |
|
| 442 | u.city, |
|
| 443 | u.country, |
|
| 444 | u.telephone, |
|
| 445 | u.mobile, |
|
| 446 | u.created_at, |
|
| 447 | u.dob, |
|
| 448 | e.winner, |
|
| 449 | e.socialShares, |
|
| 450 | e.playerData, |
|
| 451 | e.updated_at |
|
| 452 | ') |
|
| 453 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
| 454 | ->leftJoin('e.user', 'u') |
|
| 455 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 456 | ||
| 457 | $qb->setParameter('game', $game); |
|
| 458 | ||
| 459 | return $qb->getQuery(); |
|
| 460 | } |
|
| 461 | ||
| @@ 503-539 (lines=37) @@ | ||
| 500 | return $header; |
|
| 501 | } |
|
| 502 | ||
| 503 | public function getEntriesQuery($game) |
|
| 504 | { |
|
| 505 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 506 | ||
| 507 | $qb = $em->createQueryBuilder(); |
|
| 508 | $qb->select(' |
|
| 509 | p.id, |
|
| 510 | u.username, |
|
| 511 | u.title, |
|
| 512 | u.firstname, |
|
| 513 | u.lastname, |
|
| 514 | u.email, |
|
| 515 | u.optin, |
|
| 516 | u.optinPartner, |
|
| 517 | u.address, |
|
| 518 | u.address2, |
|
| 519 | u.postalCode, |
|
| 520 | u.city, |
|
| 521 | u.telephone, |
|
| 522 | u.mobile, |
|
| 523 | u.created_at, |
|
| 524 | u.dob, |
|
| 525 | e.winner, |
|
| 526 | e.socialShares, |
|
| 527 | e.playerData, |
|
| 528 | e.updated_at, |
|
| 529 | p.status, |
|
| 530 | p |
|
| 531 | ') |
|
| 532 | ->from('PlaygroundGame\Entity\PostVotePost', 'p') |
|
| 533 | ->innerJoin('p.entry', 'e') |
|
| 534 | ->leftJoin('p.user', 'u') |
|
| 535 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 536 | ||
| 537 | $qb->setParameter('game', $game); |
|
| 538 | ||
| 539 | return $qb->getQuery(); |
|
| 540 | } |
|
| 541 | ||
| 542 | /** |
|
| @@ 547-582 (lines=36) @@ | ||
| 544 | return $header; |
|
| 545 | } |
|
| 546 | ||
| 547 | public function getEntriesQuery($game) |
|
| 548 | { |
|
| 549 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 550 | ||
| 551 | $qb = $em->createQueryBuilder(); |
|
| 552 | $qb->select(' |
|
| 553 | r.id, |
|
| 554 | u.username, |
|
| 555 | u.title, |
|
| 556 | u.firstname, |
|
| 557 | u.lastname, |
|
| 558 | u.email, |
|
| 559 | u.optin, |
|
| 560 | u.optinPartner, |
|
| 561 | u.address, |
|
| 562 | u.address2, |
|
| 563 | u.postalCode, |
|
| 564 | u.city, |
|
| 565 | u.telephone, |
|
| 566 | u.mobile, |
|
| 567 | u.created_at, |
|
| 568 | u.dob, |
|
| 569 | e.winner, |
|
| 570 | e.socialShares, |
|
| 571 | e.playerData, |
|
| 572 | e.updated_at, |
|
| 573 | r.totalCorrectAnswers |
|
| 574 | ') |
|
| 575 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
| 576 | ->innerJoin('r.entry', 'e') |
|
| 577 | ->leftJoin('e.user', 'u') |
|
| 578 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 579 | ||
| 580 | $qb->setParameter('game', $game); |
|
| 581 | ||
| 582 | return $qb->getQuery(); |
|
| 583 | } |
|
| 584 | ||
| 585 | public function getGameEntity() |
|
