| public getSnippetTemplatesForArticle ( $articleNr, $languageCode, string $show = 'enabled' ) : Doctrine\ORM\Query | ||
| $show | string | Define which Snippets to return, 'enabled' | 'disabled' | 'all' |
| Результат | Doctrine\ORM\Query | Query |
public function getSnippetTemplatesForArticle($articleNr, $languageCode, $show = 'enabled')
{
$em = $this->getEntityManager();
$snippetTemplateIDsQuery = $em->getRepository('Newscoop\\Entity\\Snippet')->getArticleSnippetQueryBuilder($articleNr, $languageCode, $show)->select('template.id');
$snippetTemplateIDsQueryResult = $snippetTemplateIDsQuery->distinct()->getQuery()->getResult();
$ids = array_map('current', $snippetTemplateIDsQueryResult);
$queryBuilder = $this->createQueryBuilder('template');
$queryBuilder->add('where', $queryBuilder->expr()->in('template.id', $ids));
return $queryBuilder->getQuery();
}