public function findUserByCpfMail(\Core_Dto_Entity $dtoPerson, \Core_Dto_Entity $dtoMail)
{
$queryBuilder = $this->_em->createQueryBuilder()->select('pf.nuCpf', 'e.txEmail', 'u.stAtivo', 'p.noPessoa', 'p.sqPessoa', 'u.sqUsuario', 'u.txSenha')->from('app:Usuario', 'u')->innerJoin('u.sqPessoa', 'p')->innerJoin('p.sqPessoaFisica', 'pf')->innerJoin('pf.sqEmail', 'e')->innerJoin('e.sqTipoEmail', 'te')->where('pf.nuCpf = :nuCpf')->setParameter('nuCpf', $dtoPerson->getNuCpf())->andWhere('e.txEmail = :txEmail')->setParameter('txEmail', $dtoMail->getTxEmail())->andWhere('te.sqTipoEmail = :sqTipoEmail')->setParameter('sqTipoEmail', \Core_Configuration::getCorpTipoEmailInstitucional());
return $queryBuilder->getQuery()->getOneOrNullResult();
}
