<?php

namespace UBV\SurUbvBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * GrupoRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class GrupoRepository extends EntityRepository
{
  public function findObjetoGrupoByDescripcion($descripcionGrupo) {
    $em = $this->getEntityManager();
    
    $result = $em->createQueryBuilder();
    
    $dql = $result->select('grupo')
            ->from('UBVSurUbvBundle:Grupo', 'grupo')
            ->where('grupo.name = :descripcionGrupo')
            ->setParameter('descripcionGrupo', $descripcionGrupo)
            ->getQuery()
            ->getOneOrNullResult();
  
    //die(var_dump($dql));
    return $dql;
  }
}