<?php

namespace UBV\SurUbvBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * PersonaCorreoRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class PersonaCorreoRepository extends EntityRepository
{
  public function findCorreoPersonalByPersonaId($usuarioId) {
    $em = $this->getEntityManager();
    
    $result = $em->createQueryBuilder();
    
    $dql = $result->select('correo.descripcion as Correo')
            ->from('UBVSurUbvBundle:PersonaCorreo', 'correo')
            ->join('correo.correoTipo','correoTipo', 'correo.correo_tipo_id = correoTipo.id')
            ->where('correo.persona_id = :usuarioId')
            ->Andwhere('tipoCorreo.descripcion = :descripcionCorreoTipo')
            ->setParameter('usuarioId', $usuarioId)
            ->setParameter('descripcionCorreoTipo', 'Personal')
            ->getQuery()
            ->getResult(Query::HYDRATE_ARRAY);
    
    
    die(dump($dql));
    return $arregloCuentas;
  }
}