Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ids = array(1,2,3);
- $query = 'select o from Organisation o where o.id in (:ids)';
- $this->_entityManager->createQuery($query)
- ->setParameter('ids', implode(', ', $ids))
- $em->createQuery('SELECT users FROM EntitiesUser users WHERE users.id IN (:ids)')
- ->setParameters(array('ids' => $ids));
- $con = $this->getEntityManager();
- $query = $con->createQuery("SELECT cl
- FROM BackendBundle:classifieds cl
- INNER JOIN BackendBundle:locations lo WITH cl.locationId = lo.id
- INNER JOIN BackendBundle:municipality mu WITH lo.municipalId = mu.id
- WHERE cl.verified = false AND mu.id = ".$munId." AND cl.locationId NOT IN (:ids) ");
- $query->setParameters(array('ids' => $locsIds));
- $res = $query->getResult();
- return $res;
- $em->createQuery(“SELECT users FROM EntitiesUser users WHERE users.id IN (':ids')”)
- ->setParameters(array(‘ids’ => $ids));
Add Comment
Please, Sign In to add comment