Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. $sql = $this->_em->createQueryBuilder()
  2. ->select('m.id', 'm.mensagem', 'mo.dataAtualizacao')
  3. ->from('Domain\Entity\MonitoramentoOnibus', 'mo')
  4. ->innerJoin('\Domain\Entity\OnibusViagem', 'ov', 'WITH', 'ov.id = mo.viagemId')
  5. ->innerJoin('\Domain\Entity\Mensagem', 'm', 'WITH', 'm.onibusViagem = ov.id')
  6. ->where("m.onibusViagem = $idViagem")
  7. ->andWhere("mo.dataAtualizacao > DATE_SUB(m.dataCadastro, 1, 'MINUTE')")
  8. ->setMaxResults(1);
  9.  
  10. $result = $sql->getQuery()->getSQL();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement