Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($getQuery) && !empty($getQuery)) {
- $getGroups = $this->getEntityManager()
- ->createQueryBuilder()
- ->select('ll')
- ->from('GroupsBundle:Groups', 'g')
- ->from('GroupsBundle:Groups', 'll')
- ->leftJoin('g.language', 'l')
- ->leftJoin('g.query', 'q')
- ->andWhere('q.slug = :query_slug')
- ->setParameter('query_slug', $getQuery)
- ->andWhere('g.publish_moderator = :publish_moderator')
- ->andWhere('l.id=ll.id')
- ->setParameter('publish_moderator', true)
- ->getQuery();
- //->useResultCache(true, 60, 'all_groups_by_query') //60 s.
- //->getResult();
- if(isset($getGroups) && !empty($getGroups)) {
- return $getGroups;
- } else {
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement