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/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)

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()

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

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

		@@ 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()

gregorybesson / PlaygroundGame

Code Duplication Length = 34-37 lines in 3 locations

src/PlaygroundGame/Service/PostVote.php 1 location

src/PlaygroundGame/Service/Game.php 1 location

src/PlaygroundGame/Service/Quiz.php 1 location