Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.95 KB | None | 0 0
  1.         if(isset($getQuery) && !empty($getQuery)) {
  2.             $getGroups = $this->getEntityManager()
  3.                 ->createQueryBuilder()
  4.                 ->select('ll')
  5.                 ->from('GroupsBundle:Groups', 'g')
  6.                 ->from('GroupsBundle:Groups', 'll')
  7.                 ->leftJoin('g.language', 'l')
  8.                 ->leftJoin('g.query', 'q')
  9.                 ->andWhere('q.slug = :query_slug')
  10.                 ->setParameter('query_slug', $getQuery)
  11.                 ->andWhere('g.publish_moderator = :publish_moderator')
  12.                 ->andWhere('l.id=ll.id')
  13.                 ->setParameter('publish_moderator', true)
  14.                 ->getQuery();
  15.                 //->useResultCache(true, 60, 'all_groups_by_query') //60 s.
  16.                 //->getResult();
  17.             if(isset($getGroups) && !empty($getGroups)) {
  18.                 return $getGroups;
  19.             } else {
  20.                 return false;
  21.             }
  22.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement