AppBundle\Entity\AgreementRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	30
Duplicated Lines	60 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	countHours()	0	7	1
A	getRealFromDate()	9	9	2
A	getRealToDate()	9	9	2

<?php

namespace AppBundle\Entity;

use Doctrine\ORM\EntityRepository;

class AgreementRepository extends EntityRepository
{
    public function countHours(Agreement $agreement)
    {
        return $this->getEntityManager()
            ->createQuery('SELECT SUM(w.hours) FROM AppBundle:Workday w INNER JOIN w.agreement a WHERE w.agreement = :agreement')
            ->setParameter('agreement', $agreement)
            ->getSingleScalarResult();
    }

    public function getRealFromDate(Agreement $agreement)

This method seems to be duplicated in your project.

    {
        $date = $this->getEntityManager()
            ->createQuery('SELECT MIN(w.date) FROM AppBundle:Workday w INNER JOIN w.agreement a WHERE w.agreement = :agreement')
            ->setParameter('agreement', $agreement)
            ->getSingleScalarResult();

        return null === $date ?: new \DateTime($date);
    }

    public function getRealToDate(Agreement $agreement)

This method seems to be duplicated in your project.

    {
        $date = $this->getEntityManager()
            ->createQuery('SELECT MAX(w.date) FROM AppBundle:Workday w INNER JOIN w.agreement a WHERE w.agreement = :agreement')
            ->setParameter('agreement', $agreement)
            ->getSingleScalarResult();

        return null === $date ?: new \DateTime($date);
    }
}