<?php

namespace UBV\SurUbvBundle\Entity;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\Expr\Join;
use Doctrine\ORM\Query;

/**
 * PeriodoAcademicoRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class PeriodoAcademicoRepository extends EntityRepository
{
  public function findObjetoPeriodoAcademicoByEstatus() {
    $em = $this->getEntityManager();
    
    $result = $em->createQueryBuilder();
    
    $dql = $result->select('periodo.descripcion')
            
            ->from('UBVSurUbvBundle:PeriodoAcademico', 'periodo')
            ->join('periodo.periodoEstatus','estatusPeriodo','estatusPeriodo.id = periodo.estatus_periodo_id')
            ->where('periodo.estatus = :estatus')
            ->Andwhere('estatusPeriodo.id = :estatusPeriodo')
            ->setParameter('estatus',true)
            ->setParameter('estatusPeriodo',4)
            ->getQuery()
            ->getOneOrNullResult();
  
    //die(var_dump($dql));
    return $dql;
  }
  
}