Newscoop\Entity\Repository\Snippet\SnippetTemplateRepository::getCurrentlyUsed PHP Méthode

    public function getCurrentlyUsed()
    {
        $em = $this->getEntityManager();
        $snippetTemplateIDsQuery = $em->getRepository('Newscoop\\Entity\\Snippet')->createQueryBuilder('snippet')->select('template.id')->join('snippet.template', 'template')->distinct()->getQuery()->getResult();
        $ids = array_map('current', $snippetTemplateIDsQuery);
        $queryBuilder = $this->createQueryBuilder('template');
        $queryBuilder->add('where', $queryBuilder->expr()->in('template.id', $ids));
        return $queryBuilder->getQuery();
    }