gregorybesson /
PlaygroundGame
| @@ 574-607 (lines=34) @@ | ||
| 571 | return $games; |
|
| 572 | } |
|
| 573 | ||
| 574 | public function getEntriesQuery($game){ |
|
| 575 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 576 | ||
| 577 | $qb = $em->createQueryBuilder(); |
|
| 578 | $qb->select(' |
|
| 579 | e.id, |
|
| 580 | u.username, |
|
| 581 | u.title, |
|
| 582 | u.firstname, |
|
| 583 | u.lastname, |
|
| 584 | u.email, |
|
| 585 | u.optin, |
|
| 586 | u.optinPartner, |
|
| 587 | u.address, |
|
| 588 | u.address2, |
|
| 589 | u.postalCode, |
|
| 590 | u.city, |
|
| 591 | u.telephone, |
|
| 592 | u.mobile, |
|
| 593 | u.created_at, |
|
| 594 | u.dob, |
|
| 595 | e.winner, |
|
| 596 | e.socialShares, |
|
| 597 | e.playerData, |
|
| 598 | e.updated_at |
|
| 599 | ') |
|
| 600 | ->from('PlaygroundGame\Entity\Entry', 'e') |
|
| 601 | ->leftJoin('e.user', 'u') |
|
| 602 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 603 | ||
| 604 | $qb->setParameter('game', $game); |
|
| 605 | ||
| 606 | return $qb->getQuery(); |
|
| 607 | } |
|
| 608 | ||
| 609 | public function getEntriesHeader($game){ |
|
| 610 | if ($game->getPlayerForm()) { |
|
| @@ 414-450 (lines=37) @@ | ||
| 411 | return $header; |
|
| 412 | } |
|
| 413 | ||
| 414 | public function getEntriesQuery($game){ |
|
| 415 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 416 | ||
| 417 | $qb = $em->createQueryBuilder(); |
|
| 418 | $qb->select(' |
|
| 419 | p.id, |
|
| 420 | u.username, |
|
| 421 | u.title, |
|
| 422 | u.firstname, |
|
| 423 | u.lastname, |
|
| 424 | u.email, |
|
| 425 | u.optin, |
|
| 426 | u.optinPartner, |
|
| 427 | u.address, |
|
| 428 | u.address2, |
|
| 429 | u.postalCode, |
|
| 430 | u.city, |
|
| 431 | u.telephone, |
|
| 432 | u.mobile, |
|
| 433 | u.created_at, |
|
| 434 | u.dob, |
|
| 435 | e.winner, |
|
| 436 | e.socialShares, |
|
| 437 | e.playerData, |
|
| 438 | e.updated_at, |
|
| 439 | p.status, |
|
| 440 | p |
|
| 441 | ') |
|
| 442 | ->from('PlaygroundGame\Entity\PostVotePost', 'p') |
|
| 443 | ->innerJoin('p.entry', 'e') |
|
| 444 | ->leftJoin('p.user', 'u') |
|
| 445 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 446 | ||
| 447 | $qb->setParameter('game', $game); |
|
| 448 | ||
| 449 | return $qb->getQuery(); |
|
| 450 | } |
|
| 451 | ||
| 452 | /** |
|
| 453 | * getGameEntries : All entries of a game |
|
| @@ 456-491 (lines=36) @@ | ||
| 453 | return $header; |
|
| 454 | } |
|
| 455 | ||
| 456 | public function getEntriesQuery($game){ |
|
| 457 | $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default'); |
|
| 458 | ||
| 459 | $qb = $em->createQueryBuilder(); |
|
| 460 | $qb->select(' |
|
| 461 | r.id, |
|
| 462 | u.username, |
|
| 463 | u.title, |
|
| 464 | u.firstname, |
|
| 465 | u.lastname, |
|
| 466 | u.email, |
|
| 467 | u.optin, |
|
| 468 | u.optinPartner, |
|
| 469 | u.address, |
|
| 470 | u.address2, |
|
| 471 | u.postalCode, |
|
| 472 | u.city, |
|
| 473 | u.telephone, |
|
| 474 | u.mobile, |
|
| 475 | u.created_at, |
|
| 476 | u.dob, |
|
| 477 | e.winner, |
|
| 478 | e.socialShares, |
|
| 479 | e.playerData, |
|
| 480 | e.updated_at, |
|
| 481 | r.totalCorrectAnswers |
|
| 482 | ') |
|
| 483 | ->from('PlaygroundGame\Entity\QuizReply', 'r') |
|
| 484 | ->innerJoin('r.entry', 'e') |
|
| 485 | ->leftJoin('e.user', 'u') |
|
| 486 | ->where($qb->expr()->eq('e.game', ':game')); |
|
| 487 | ||
| 488 | $qb->setParameter('game', $game); |
|
| 489 | ||
| 490 | return $qb->getQuery(); |
|
| 491 | } |
|
| 492 | ||
| 493 | public function getGameEntity() |
|
| 494 | { |
|
