BCRM\BackendBundle\Entity\Event\DoctrineTicketRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	142
Duplicated Lines	32.39 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getTicketsForEmail()	8	8	1
A	getTicketByIdAndCode()	0	8	1
A	getToNotify()	9	9	1
A	getTicketsForEvent()	0	7	1
A	getTicketCountForEvent()	9	9	1
A	getCheckinCountForEvent()	10	10	1
A	getUnprintedTickets()	10	10	1
A	searchTickets()	0	14	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 PhpOption\None;
use PhpOption\Option;
use PhpOption\Some;
use Symfony\Component\Config\Definition\Exception\Exception;

class DoctrineTicketRepository extends EntityRepository implements TicketRepository
{
    /**
     * @param Event $event
     *
     * @return Ticket[]
     */
    public function getToNotify(Event $event)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('t')
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.notified = 0')
            ->andWhere('t.payment IS NOT NULL')
            ->getQuery()
            ->getResult();
    }

    /**
     * @param Event  $event
     * @param string $email
     *
     * @return Ticket[]
     */
    public function getTicketsForEmail(Event $event, $email)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('t')
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.email = :email')->setParameter('email', $email)
            ->getQuery()
            ->getResult();
    }

    /**
     * @param integer $id
     * @param string  $code
     *
     * @return Option
     */
    public function getTicketByIdAndCode($id, $code)
    {
        return Option::fromValue($this->createQueryBuilder('t')
            ->andWhere('t.id = :id')->setParameter('id', $id)
            ->andWhere('t.code = :code')->setParameter('code', $code)
            ->getQuery()
            ->getOneOrNullResult());
    }

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

    /**
     * Returns the number of tickets for the given day.
     *
     * @param Event $event
     * @param       $day
     *
     * @return mixed
     */
    public function getTicketCountForEvent(Event $event, $day)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('t')
            ->select('COUNT(t.id)')
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.day = :day')->setParameter('day', $day)
            ->getQuery()
            ->getSingleScalarResult();
    }

    /**
     * Returns the number of checkins for the given day.
     *
     * @param Event $event
     * @param       $day
     *
     * @return mixed
     */
    public function getCheckinCountForEvent(Event $event, $day)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('t')
            ->select('COUNT(t.id)')
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.day = :day')->setParameter('day', $day)
            ->andWhere('t.checkedIn IS NOT NULL')
            ->getQuery()
            ->getSingleScalarResult();
    }

    /**
     * Returns the list of unprinted tickets for the given day.
     *
     * @param Event $event
     * @param       $day
     *
     * @return Ticket[]
     */
    public function getUnprintedTickets(Event $event, $day)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('t')
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.day = :day')->setParameter('day', $day)
            ->andWhere('t.checkedIn IS NOT NULL')
            ->andWhere('t.printed = 0')
            ->getQuery()
            ->getResult();
    }

    /**
     * Search tickets matching the given term
     *
     * @param Event $event
     * @param       $day
     * @param       $term
     *
     * @return mixed
     */
    public function searchTickets(Event $event, $day, $term)
    {
        $qb = $this->createQueryBuilder('t');
        return $qb
            ->andWhere('t.event = :event')->setParameter('event', $event)
            ->andWhere('t.day = :day')->setParameter('day', $day)
            ->andWhere($qb->expr()->orX(
                $qb->expr()->like('t.name', ':term'),
                $qb->expr()->like('t.code', ':term'),
                $qb->expr()->like('t.email', ':term')
            ))->setParameter('term', '%' . $term . '%')
            ->getQuery()
            ->getResult();
    }


}