Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = $this->_em->createQueryBuilder()
- ->select('m.id', 'm.mensagem', 'mo.dataAtualizacao')
- ->from('Domain\Entity\MonitoramentoOnibus', 'mo')
- ->innerJoin('\Domain\Entity\OnibusViagem', 'ov', 'WITH', 'ov.id = mo.viagemId')
- ->innerJoin('\Domain\Entity\Mensagem', 'm', 'WITH', 'm.onibusViagem = ov.id')
- ->where("m.onibusViagem = $idViagem")
- ->andWhere("mo.dataAtualizacao > DATE_SUB(m.dataCadastro, 1, 'MINUTE')")
- ->setMaxResults(1);
- $result = $sql->getQuery()->getSQL();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement