| public getArticlesQueryByTopicIdAndLanguage ( integer $topicId, string $languageCode, boolean $defaultFallback = false ) : Doctrine\ORM\Query | ||
| $topicId | integer | Topic id |
| $languageCode | string | Language code |
| $defaultFallback | boolean | Sets the language of the topic to the default one |
| Результат | Doctrine\ORM\Query | |
public function getArticlesQueryByTopicIdAndLanguage($topicId, $languageCode, $defaultFallback = false)
{
$query = $this->getQueryBuilder()->select('node', 't')->from('Newscoop\\NewscoopBundle\\Entity\\Topic', 'node')->leftJoin('node.translations', 't')->where("t.field = 'title'")->andWhere('node.id = :id')->setParameter('id', $topicId);
if ($defaultFallback) {
return $this->setTranslatableHint($query->getQuery(), $languageCode);
}
$query->andWhere('t.locale = :locale')->setParameter('locale', $languageCode);
return $query->getQuery();
}