Guest User

Untitled

a guest
Jan 20th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. $ids = array(1,2,3);
  2. $query = 'select o from Organisation o where o.id in (:ids)';
  3. $this->_entityManager->createQuery($query)
  4. ->setParameter('ids', implode(', ', $ids))
  5.  
  6. $em->createQuery('SELECT users FROM EntitiesUser users WHERE users.id IN (:ids)')
  7. ->setParameters(array('ids' => $ids));
  8.  
  9. $con = $this->getEntityManager();
  10. $query = $con->createQuery("SELECT cl
  11. FROM BackendBundle:classifieds cl
  12. INNER JOIN BackendBundle:locations lo WITH cl.locationId = lo.id
  13. INNER JOIN BackendBundle:municipality mu WITH lo.municipalId = mu.id
  14. WHERE cl.verified = false AND mu.id = ".$munId." AND cl.locationId NOT IN (:ids) ");
  15. $query->setParameters(array('ids' => $locsIds));
  16. $res = $query->getResult();
  17.  
  18. return $res;
  19.  
  20. $em->createQuery(“SELECT users FROM EntitiesUser users WHERE users.id IN (':ids')”)
  21. ->setParameters(array(‘ids’ => $ids));
Add Comment
Please, Sign In to add comment