AppBundle\Entity\AgreementRepository

Complexity

Total Complexity

9

Size/Duplication

Total Lines	62
Duplicated Lines	29.03 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	4
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	countHours()	0	7	1
A	getRealFromDate()	9	9	2
A	getRealToDate()	9	9	2
A	getActivitiesStats()	0	12	1
A	delete()	0	18	3

<?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);
    }

    public function getActivitiesStats(Agreement $agreement)
    {
        $activities = $agreement->getActivities();

        $result = $this->getEntityManager()
            ->createQuery('SELECT a, SUM(t.hours), COUNT(a) FROM AppBundle:Activity a INNER JOIN AppBundle:Tracking t WITH t.activity = a.id INNER JOIN t.workday w WHERE w.agreement = :agreement AND a.id IN (:activities) GROUP BY a.id')
            ->setParameter('agreement', $agreement)
            ->setParameter('activities', $activities)
            ->getResult();

        return $result;
    }

    public function delete(Agreement $agreement)
    {
        // borrar informe si estaba cumplimentado
        if ($agreement->getReport()) {
            $this->getEntityManager()->remove($agreement->getReport());
        }

        // borrar calendario
        foreach ($agreement->getWorkdays() as $workday) {
            $this->getEntityManager()->remove($workday);
        }

        // borrar actividades de plan de formación individualizado
        $agreement->getActivities()->clear();

        // borrar acuerdo
        $this->getEntityManager()->remove($agreement);
    }
}