gregorybesson /
PlaygroundGame
| @@ 574-607 (lines=34) @@ | ||
| 571 | return $games; |
|
| 572 | } |
|
| 573 | ||
| 574 | public function getEntriesQuery($game) |
|
| 575 | { |
|
| 576 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 577 | ||
| 578 | $qb = $em->createQueryBuilder(); |
|
| 579 | $qb->select(' |
|
| 580 | e.id, |
|
| 581 | u.username, |
|
| 582 | u.title, |
|
| 583 | u.firstname, |
|
| 584 | u.lastname, |
|
| 585 | u.email, |
|
| 586 | u.optin, |
|
| 587 | u.optinPartner, |
|
| 588 | u.address, |
|
| 589 | u.address2, |
|
| 590 | u.postalCode, |
|
| 591 | u.city, |
|
| 592 | u.telephone, |
|
| 593 | u.mobile, |
|
| 594 | u.created_at, |
|
| 595 | u.dob, |
|
| 596 | e.winner, |
|
| 597 | e.socialShares, |
|
| 598 | e.playerData, |
|
| 599 | e.updated_at |
|
| 600 | ') |
|
| 601 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
| 602 | ->leftJoin('e.user', 'u') |
|
| 603 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 604 | ||
| 605 | $qb->setParameter('game', $game); |
|
| 606 | ||
| 607 | return $qb->getQuery(); |
|
| 608 | } |
|
| 609 | ||
| 610 | public function getEntriesHeader($game) |
|
| @@ 416-452 (lines=37) @@ | ||
| 413 | return $header; |
|
| 414 | } |
|
| 415 | ||
| 416 | public function getEntriesQuery($game) |
|
| 417 | { |
|
| 418 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 419 | ||
| 420 | $qb = $em->createQueryBuilder(); |
|
| 421 | $qb->select(' |
|
| 422 | p.id, |
|
| 423 | u.username, |
|
| 424 | u.title, |
|
| 425 | u.firstname, |
|
| 426 | u.lastname, |
|
| 427 | u.email, |
|
| 428 | u.optin, |
|
| 429 | u.optinPartner, |
|
| 430 | u.address, |
|
| 431 | u.address2, |
|
| 432 | u.postalCode, |
|
| 433 | u.city, |
|
| 434 | u.telephone, |
|
| 435 | u.mobile, |
|
| 436 | u.created_at, |
|
| 437 | u.dob, |
|
| 438 | e.winner, |
|
| 439 | e.socialShares, |
|
| 440 | e.playerData, |
|
| 441 | e.updated_at, |
|
| 442 | p.status, |
|
| 443 | p |
|
| 444 | ') |
|
| 445 | ->from('PlaygroundGame\Entity\PostVotePost', 'p') |
|
| 446 | ->innerJoin('p.entry', 'e') |
|
| 447 | ->leftJoin('p.user', 'u') |
|
| 448 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 449 | ||
| 450 | $qb->setParameter('game', $game); |
|
| 451 | ||
| 452 | return $qb->getQuery(); |
|
| 453 | } |
|
| 454 | ||
| 455 | /** |
|
| @@ 484-519 (lines=36) @@ | ||
| 481 | return $header; |
|
| 482 | } |
|
| 483 | ||
| 484 | public function getEntriesQuery($game) |
|
| 485 | { |
|
| 486 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 487 | ||
| 488 | $qb = $em->createQueryBuilder(); |
|
| 489 | $qb->select(' |
|
| 490 | r.id, |
|
| 491 | u.username, |
|
| 492 | u.title, |
|
| 493 | u.firstname, |
|
| 494 | u.lastname, |
|
| 495 | u.email, |
|
| 496 | u.optin, |
|
| 497 | u.optinPartner, |
|
| 498 | u.address, |
|
| 499 | u.address2, |
|
| 500 | u.postalCode, |
|
| 501 | u.city, |
|
| 502 | u.telephone, |
|
| 503 | u.mobile, |
|
| 504 | u.created_at, |
|
| 505 | u.dob, |
|
| 506 | e.winner, |
|
| 507 | e.socialShares, |
|
| 508 | e.playerData, |
|
| 509 | e.updated_at, |
|
| 510 | r.totalCorrectAnswers |
|
| 511 | ') |
|
| 512 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
| 513 | ->innerJoin('r.entry', 'e') |
|
| 514 | ->leftJoin('e.user', 'u') |
|
| 515 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 516 | ||
| 517 | $qb->setParameter('game', $game); |
|
| 518 | ||
| 519 | return $qb->getQuery(); |
|
| 520 | } |
|
| 521 | ||
| 522 | public function getGameEntity() |
|
