Code Duplication - gregorybesson/PlaygroundGame - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 34-37 lines in 3 locations

src/PlaygroundGame/Service/PostVote.php 1 location


        return $header;
    }

    public function getEntriesQuery($game)
    {
        $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');

        $qb = $em->createQueryBuilder();
        $qb->select('
            p.id,
            u.username,
            u.title,
            u.firstname,
            u.lastname,
            u.email,
            u.optin,
            u.optinPartner,
            u.address,
            u.address2,
            u.postalCode,
            u.city,
            u.telephone,
            u.mobile,
            u.created_at,
            u.dob,
            e.winner,
            e.socialShares,
            e.playerData,
            e.updated_at,
            p.status,
            p
            ')
            ->from('PlaygroundGame\Entity\PostVotePost', 'p')
            ->innerJoin('p.entry', 'e')
            ->leftJoin('p.user', 'u')
            ->where($qb->expr()->eq('e.game', ':game'));
        
        $qb->setParameter('game', $game);

        return $qb->getQuery();
    }

    /**

src/PlaygroundGame/Service/Quiz.php 1 location


        return $header;
    }

    public function getEntriesQuery($game)
    {
        $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');

        $qb = $em->createQueryBuilder();
        $qb->select('
            r.id,
            u.username,
            u.title,
            u.firstname,
            u.lastname,
            u.email,
            u.optin,
            u.optinPartner,
            u.address,
            u.address2,
            u.postalCode,
            u.city,
            u.telephone,
            u.mobile,
            u.created_at,
            u.dob,
            e.winner,
            e.socialShares,
            e.playerData,
            e.updated_at,
            r.totalCorrectAnswers
            ')
            ->from('PlaygroundGame\Entity\QuizReply', 'r')
            ->innerJoin('r.entry', 'e')
            ->leftJoin('e.user', 'u')
            ->where($qb->expr()->eq('e.game', ':game'));
        
        $qb->setParameter('game', $game);

        return $qb->getQuery();
    }

    public function getGameEntity()

src/PlaygroundGame/Service/Game.php 1 location


        return $games;
    }

    public function getEntriesQuery($game)
    {
        $em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');

        $qb = $em->createQueryBuilder();
        $qb->select('
            e.id,
            u.username,
            u.title,
            u.firstname,
            u.lastname,
            u.email,
            u.optin,
            u.optinPartner,
            u.address,
            u.address2,
            u.postalCode,
            u.city,
            u.telephone,
            u.mobile,
            u.created_at,
            u.dob,
            e.winner,
            e.socialShares,
            e.playerData,
            e.updated_at
            ')
            ->from('PlaygroundGame\Entity\Entry', 'e')
            ->leftJoin('e.user', 'u')
            ->where($qb->expr()->eq('e.game', ':game'));
        
        $qb->setParameter('game', $game);

        return $qb->getQuery();
    }

    public function getEntriesHeader($game)

		@@ 424-460 (lines=37) @@
421		return $header;
422		}
423
424		public function getEntriesQuery($game)
425		{
426		$em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');
427
428		$qb = $em->createQueryBuilder();
429		$qb->select('
430		p.id,
431		u.username,
432		u.title,
433		u.firstname,
434		u.lastname,
435		u.email,
436		u.optin,
437		u.optinPartner,
438		u.address,
439		u.address2,
440		u.postalCode,
441		u.city,
442		u.telephone,
443		u.mobile,
444		u.created_at,
445		u.dob,
446		e.winner,
447		e.socialShares,
448		e.playerData,
449		e.updated_at,
450		p.status,
451		p
452		')
453		->from('PlaygroundGame\Entity\PostVotePost', 'p')
454		->innerJoin('p.entry', 'e')
455		->leftJoin('p.user', 'u')
456		->where($qb->expr()->eq('e.game', ':game'));
457
458		$qb->setParameter('game', $game);
459
460		return $qb->getQuery();
461		}
462
463		/**

		@@ 488-523 (lines=36) @@
485		return $header;
486		}
487
488		public function getEntriesQuery($game)
489		{
490		$em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');
491
492		$qb = $em->createQueryBuilder();
493		$qb->select('
494		r.id,
495		u.username,
496		u.title,
497		u.firstname,
498		u.lastname,
499		u.email,
500		u.optin,
501		u.optinPartner,
502		u.address,
503		u.address2,
504		u.postalCode,
505		u.city,
506		u.telephone,
507		u.mobile,
508		u.created_at,
509		u.dob,
510		e.winner,
511		e.socialShares,
512		e.playerData,
513		e.updated_at,
514		r.totalCorrectAnswers
515		')
516		->from('PlaygroundGame\Entity\QuizReply', 'r')
517		->innerJoin('r.entry', 'e')
518		->leftJoin('e.user', 'u')
519		->where($qb->expr()->eq('e.game', ':game'));
520
521		$qb->setParameter('game', $game);
522
523		return $qb->getQuery();
524		}
525
526		public function getGameEntity()

		@@ 423-456 (lines=34) @@
420		return $games;
421		}
422
423		public function getEntriesQuery($game)
424		{
425		$em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');
426
427		$qb = $em->createQueryBuilder();
428		$qb->select('
429		e.id,
430		u.username,
431		u.title,
432		u.firstname,
433		u.lastname,
434		u.email,
435		u.optin,
436		u.optinPartner,
437		u.address,
438		u.address2,
439		u.postalCode,
440		u.city,
441		u.telephone,
442		u.mobile,
443		u.created_at,
444		u.dob,
445		e.winner,
446		e.socialShares,
447		e.playerData,
448		e.updated_at
449		')
450		->from('PlaygroundGame\Entity\Entry', 'e')
451		->leftJoin('e.user', 'u')
452		->where($qb->expr()->eq('e.game', ':game'));
453
454		$qb->setParameter('game', $game);
455
456		return $qb->getQuery();
457		}
458
459		public function getEntriesHeader($game)

gregorybesson / PlaygroundGame

Code Duplication Length = 34-37 lines in 3 locations

src/PlaygroundGame/Service/PostVote.php 1 location

src/PlaygroundGame/Service/Quiz.php 1 location

src/PlaygroundGame/Service/Game.php 1 location