BCRM\BackendBundle\Entity\Event\DoctrineUnregistrationRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	63
Duplicated Lines	12.7 %

Coupling/Cohesion

Components	2
Dependencies	9

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getNewUnregistrations()	0	8	1
A	getUnregistrationByIdAndKey()	8	8	2
A	getUnprocessedUnregistrations()	0	13	1
A	getUnregistrationsForEvent()	0	7	1

<?php

/**
 * @author    Markus Tacker <m@coderbyheart.com>
 * @copyright 2013-2016 Verein zur Förderung der Netzkultur im Rhein-Main-Gebiet e.V. | http://netzkultur-rheinmain.de/
 */

namespace BCRM\BackendBundle\Entity\Event;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\ResultSetMapping;
use Doctrine\ORM\Query\ResultSetMappingBuilder;
use PhpOption\None;
use PhpOption\Some;

class DoctrineUnregistrationRepository extends EntityRepository implements UnregistrationRepository
{
    /**
     * @return Unregistration[]
     */
    public function getNewUnregistrations()
    {
        $qb = $this->createQueryBuilder('u');
        $qb->andWhere('u.confirmed=0');
        $qb->andWhere('u.confirmationKey IS NULL');
        $qb->groupBy('u.email');
        return $qb->getQuery()->getResult();
    }

    /**
     * @param Event $event
     *
     * @return Unregistration[]
     */
    public function getUnprocessedUnregistrations(Event $event)
    {
        $rsm = new ResultSetMappingBuilder($this->_em);
        $rsm->addRootEntityFromClassMetadata('BCRM\BackendBundle\Entity\Event\Unregistration', 'u');
        $eventId         = $event->getId();
        $unregistrations = "SELECT MAX(id) FROM unregistration WHERE confirmed = 1 AND event_id = $eventId AND processed = 0 GROUP BY event_id, email ORDER BY created ASC, id ASC";
        $sql             = "SELECT * FROM unregistration WHERE id IN ($unregistrations)";
        $query           = $this->_em->createNativeQuery(
            $sql,
            $rsm
        );
        return $query->getResult();
    }

    /**
     * @param string $id
     * @param string $key
     *
     * @return \PhpOption\Option
     */
    public function getUnregistrationByIdAndKey($id, $key)

This method seems to be duplicated in your project.

    {
        $qb = $this->createQueryBuilder('u');
        $qb->andWhere('u.id = :id')->setParameter('id', $id);
        $qb->andWhere('u.confirmationKey = :key')->setParameter('key', $key);
        $result = $qb->getQuery()->getOneOrNullResult();
        return $result === null ? None::create() : new Some($result);
    }

    /**
     * @param Event $event
     *
     * @return Unregistration[]
     */
    public function getUnregistrationsForEvent(Event $event)
    {
        return $this->createQueryBuilder('r')
            ->andWhere('r.event = :event')->setParameter('event', $event)
            ->getQuery()
            ->getResult();
    }


}