Code Duplication    Length = 15-39 lines in 3 locations

src/Service/Game.php 1 location

@@ 638-674 (lines=37) @@
635
        return $grid;
636
    }
637
638
    public function getEntriesQuery($game)
639
    {
640
        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');
641
642
        $qb = $em->createQueryBuilder();
643
        $qb->select('
644
            e.id,
645
            u.username,
646
            u.title,
647
            u.firstname,
648
            u.lastname,
649
            u.email,
650
            u.optin,
651
            u.optinPartner,
652
            u.address,
653
            u.address2,
654
            u.postalCode,
655
            u.city,
656
            u.country,
657
            u.telephone,
658
            u.mobile,
659
            u.created_at,
660
            u.dob,
661
            e.winner,
662
            e.socialShares,
663
            e.playerData,
664
            e.geoloc,
665
            e.updated_at
666
            ')
667
            ->from('PlaygroundGame\Entity\Entry', 'e')
668
            ->leftJoin('e.user', 'u')
669
            ->where($qb->expr()->eq('e.game', ':game'));
670
671
        $qb->setParameter('game', $game);
672
673
        return $qb;
674
    }
675
676
    /**
677
     * DEPRECATED

src/Service/Quiz.php 2 locations

@@ 176-190 (lines=15) @@
173
        return $question;
174
    }
175
176
    public function findRepliesByGame($game)
177
    {
178
        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');
179
        $qb = $em->createQueryBuilder();
180
        $qb->select('r')
181
           ->from('PlaygroundGame\Entity\QuizReply', 'r')
182
           ->innerJoin('r.entry', 'e')
183
           ->where('e.game = :game')
184
           ->setParameter('game', $game);
185
        $query = $qb->getQuery();
186
187
        $replies = $query->getResult();
188
189
        return $replies;
190
    }
191
192
    public function updatePrediction($question)
193
    {
@@ 693-731 (lines=39) @@
690
    }
691
692
693
    public function getEntriesQuery($game)
694
    {
695
        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');
696
697
        $qb = $em->createQueryBuilder();
698
        $qb->select(
699
            '
700
            r.id,
701
            u.username,
702
            u.title,
703
            u.firstname,
704
            u.lastname,
705
            u.email,
706
            u.optin,
707
            u.optinPartner,
708
            u.address,
709
            u.address2,
710
            u.postalCode,
711
            u.city,
712
            u.telephone,
713
            u.mobile,
714
            u.created_at,
715
            u.dob,
716
            e.winner,
717
            e.socialShares,
718
            e.playerData,
719
            e.updated_at,
720
            r.totalCorrectAnswers
721
            '
722
        )
723
            ->from('PlaygroundGame\Entity\QuizReply', 'r')
724
            ->innerJoin('r.entry', 'e')
725
            ->leftJoin('e.user', 'u')
726
            ->where($qb->expr()->eq('e.game', ':game'));
727
728
        $qb->setParameter('game', $game);
729
730
        return $qb;
731
    }
732
733
    public function getGameEntity()
734
    {