AppBundle\Entity\CursoRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	getResumenPorFecha()	0	21	1

<?php
/*
  GESTCONV - Aplicación web para la gestión de la convivencia en centros educativos

  Copyright (C) 2015: Luis Ramón López López

  This program is free software: you can redistribute it and/or modify
  it under the terms of the GNU Affero General Public License as published by
  the Free Software Foundation, either version 3 of the License, or
  (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU Affero General Public License for more details.

  You should have received a copy of the GNU Affero General Public License
  along with this program.  If not, see [http://www.gnu.org/licenses/].
*/

namespace AppBundle\Entity;

use AppBundle\Utils\RepositoryUtils;
use Doctrine\ORM\EntityRepository;

/**
 * CursoRepository
 *
 * Clase repositorio para añadir métodos adicionales
 */
class CursoRepository extends EntityRepository
{
    public function getResumenPorFecha($fechas)
    {
        $data = $this->getEntityManager()
            ->getRepository('AppBundle:Curso')
            ->createQueryBuilder('c')
            ->select('c');

        $data = RepositoryUtils::resumenConvivencia($data, $fechas)
            ->leftJoin('AppBundle:Grupo', 'g', 'WITH', 'g.curso = c')
            ->innerJoin('AppBundle:Alumno', 'a', 'WITH', 'a.grupo = g')
            ->leftJoin('AppBundle:Parte', 'p', 'WITH', 'p.alumno = a')
            ->leftJoin('AppBundle:Sancion', 's', 'WITH', 'p.sancion = s');

        $data = $data
            ->addOrderBy('c.descripcion')
            ->groupBy('c.id')
            ->getQuery()
            ->getResult();

        return $data;
    }
}