AppBundle\Entity\AlumnoRepository

Complexity

Total Complexity

13

Size/Duplication

Total Lines	160
Duplicated Lines	8.13 %

Coupling/Cohesion

Components	1
Dependencies	7

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	findConPartesAunNoNotificados()	0	11	1
A	findAllConPartesAunNoNotificadosPorUsuario()	0	6	1
A	findConPartesAunNoNotificadosPorUsuario()	13	13	1
A	findAllConPartesAunNoNotificados()	0	6	1
A	findConSancionesAunNoNotificadas()	0	15	1
A	findAllConSancionesAunNoNotificadas()	0	6	1
A	findAllConSancionesAunNoNotificadasPorTutoria()	0	9	1
B	getResumenConvivencia()	0	27	2
B	getSancionadosPorFecha()	0	33	3
A	findAllConPartesPendientesSancion()	0	22	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;

/**
 * AlumnoRepository
 *
 * Clase repositorio para añadir métodos adicionales
 */
class AlumnoRepository extends EntityRepository
{
    public function findConPartesAunNoNotificados()
    {
        return $this->getEntityManager()
            ->getRepository('AppBundle:Alumno')
            ->createQueryBuilder('a')
            ->innerJoin('AppBundle:Parte', 'p', 'WITH', 'p.alumno = a')
            ->where('p.fechaAviso IS NULL')
            ->orderBy('a.apellido1', 'ASC')
            ->addOrderBy('a.apellido2', 'ASC')
            ->addOrderBy('a.nombre', 'ASC');
    }

    public function findConPartesAunNoNotificadosPorUsuario(Usuario $usuario)
    {
        $orX = $this->getEntityManager()->createQueryBuilder()
            ->expr()->orX()
            ->add('p.usuario = :usuario')
            ->add('a.grupo = :grupo');

        return $this->findConPartesAunNoNotificados()
            ->innerJoin('AppBundle:Grupo', 'g', 'WITH', 'a.grupo = g')
            ->andWhere($orX)
            ->setParameter('grupo', $usuario->getTutoria())
            ->setParameter('usuario', $usuario);
    }

    public function findAllConPartesAunNoNotificados()
    {
        return $this->findConPartesAunNoNotificados()
            ->getQuery()
            ->getResult();
    }

    public function findAllConPartesAunNoNotificadosPorUsuario(Usuario $usuario)
    {
        return $this->findConPartesAunNoNotificadosPorUsuario($usuario)
            ->getQuery()
            ->getResult();
    }

    public function findAllConPartesPendientesSancion()
    {
        return $this->getEntityManager()
            ->getRepository('AppBundle:Parte')
            ->createQueryBuilder('p')
            ->select('a')
            ->addSelect('COUNT(p.id)')
            ->addSelect('MIN(p.fechaSuceso)')
            ->addSelect('MAX(p.fechaSuceso)')
            ->addSelect('SUM(p.prioritario)')
            ->innerJoin('AppBundle:Alumno', 'a')
            ->where('p.fechaAviso IS NOT NULL')
            ->andWhere('p.sancion IS NULL')
            ->andWhere('p.alumno = a')
            ->andWhere('p.prescrito = false')
            ->groupBy('a.id')
            ->orderBy('a.apellido1', 'ASC')
            ->addOrderBy('a.apellido2', 'ASC')
            ->addOrderBy('a.nombre', 'ASC')
            ->getQuery()
            ->getResult();
    }

    public function findConSancionesAunNoNotificadas()
    {
        return $this->getEntityManager()
            ->getRepository('AppBundle:Alumno')
            ->createQueryBuilder('a')
            ->leftJoin('a.partes', 'p')
            ->leftJoin('p.sancion', 's')
            ->where('s.fechaComunicado IS NULL')
            ->andWhere('s.motivosNoAplicacion IS NULL')
            ->andWhere('p.alumno = a')
            ->andWhere('p.sancion = s')
            ->orderBy('a.apellido1', 'ASC')
            ->addOrderBy('a.apellido2', 'ASC')
            ->addOrderBy('a.nombre', 'ASC');
    }

    public function findAllConSancionesAunNoNotificadas()
    {
        return $this->findConSancionesAunNoNotificadas()
            ->getQuery()
            ->getResult();
    }

    public function findAllConSancionesAunNoNotificadasPorTutoria($usuario)
    {
        return $this->findConSancionesAunNoNotificadas()
            ->join('a.grupo', 'g')
            ->andWhere('a.grupo = :grupo')
            ->setParameter('grupo', $usuario->getTutoria())
            ->getQuery()
            ->getResult();
    }

    public function getResumenConvivencia($tutor, $fechas)
    {
        $data = $this->getEntityManager()
            ->getRepository('AppBundle:Alumno')
            ->createQueryBuilder('a')
            ->select('a');

        $data = RepositoryUtils::resumenConvivencia($data, $fechas)
            ->leftJoin('AppBundle:Parte', 'p', 'WITH', 'p.alumno = a')
            ->leftJoin('AppBundle:Sancion', 's', 'WITH', 'p.sancion = s');

        if ($tutor) {
            $data = $data
                ->andWhere('a.grupo = :grupo')
                ->setParameter('grupo', $tutor->getTutoria());
        }

        $data = $data
            ->addOrderBy('a.apellido1')
            ->addOrderBy('a.apellido2')
            ->addOrderBy('a.nombre')
            ->groupBy('a.id')
            ->getQuery()
            ->getResult();

        return $data;
    }

    public function getSancionadosPorFecha($fechas)
    {
        $data = $this->getEntityManager()
            ->getRepository('AppBundle:Sancion')
            ->createQueryBuilder('s')
            ->select('s, p, a, g')
            ->addSelect('COUNT(p)')
            ->leftJoin('s.partes', 'p')
            ->leftJoin('p.alumno', 'a')
            ->leftJoin('a.grupo', 'g');

        if ($fechas['desde']) {
            $data = $data
                ->andWhere('s.fechaSancion >= :desde')
                ->setParameter('desde', $fechas['desde']);
        }

        if ($fechas['hasta']) {
            $data = $data
                ->andWhere('s.fechaSancion <= :hasta')
                ->setParameter('hasta', $fechas['hasta']);
        }

        $data = $data
            ->addOrderBy('a.apellido1')
            ->addOrderBy('a.apellido2')
            ->addOrderBy('a.nombre')
            ->groupBy('s.id')
            ->getQuery()
            ->getResult();

        return $data;
    }
}