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

		@@ 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		/**

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

		@@ 508-543 (lines=36) @@
505		return $header;
506		}
507
508		public function getEntriesQuery($game)
509		{
510		$em = $this->getServiceManager()->get('doctrine.entitymanager.orm_default');
511
512		$qb = $em->createQueryBuilder();
513		$qb->select('
514		r.id,
515		u.username,
516		u.title,
517		u.firstname,
518		u.lastname,
519		u.email,
520		u.optin,
521		u.optinPartner,
522		u.address,
523		u.address2,
524		u.postalCode,
525		u.city,
526		u.telephone,
527		u.mobile,
528		u.created_at,
529		u.dob,
530		e.winner,
531		e.socialShares,
532		e.playerData,
533		e.updated_at,
534		r.totalCorrectAnswers
535		')
536		->from('PlaygroundGame\Entity\QuizReply', 'r')
537		->innerJoin('r.entry', 'e')
538		->leftJoin('e.user', 'u')
539		->where($qb->expr()->eq('e.game', ':game'));
540
541		$qb->setParameter('game', $game);
542
543		return $qb->getQuery();
544		}
545
546		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