PHP Core_Dto_Search::getSqUsuario Examples

Example #1

File: VwEndereco.php Project: sgdoc/sgdoce-codigo

 /**
  * Obtém endereço de um usuário
  * @param \Core_Dto_Search $dto
  * @return array
  */
 public function buscarEnderecoPorIdUsuario(\Core_Dto_Search $dto)
 {
     $query = $this->_em->createQueryBuilder();
     $query->select('e')->from($this->_enName, 'e')->where('e.sqPessoa = :idUsuario')->setParameter('idUsuario', $dto->getSqUsuario());
     $result = $query->getQuery()->getResult();
     if (!$result) {
         $result[] = new \Sgdoce\Model\Entity\VwEndereco();
     }
     return $result[0];
 }