public function testTranslatableWhereOnTranslatableCollectionWithArrayAndDifferentDefaultLocale() { $this->_translatableListener->setLocale($this->_languagePl); $this->_translatableListener->setDefaultLocale($this->_languageEn); $comment1 = new Comment(); $comment1->setId(1); $comment2 = new Comment(); $comment2->setId(2); $whereComments = array($comment1, $comment2); $qb = new QueryBuilder($this->_em); $qb->select('a'); $qb->from(self::ARTICLE, 'a'); $qb->addTranslatableWhere('a', 'comments', $whereComments); $this->assertEquals($this->normalizeDql(sprintf(' SELECT a FROM %s a LEFT JOIN a.translations atranslationspl WITH atranslationspl.locale = :atranslationsplloc LEFT JOIN a.translations atranslationsen WITH atranslationsen.locale = :atranslationsenloc LEFT JOIN atranslationspl.comments atranslationsplcommentsjoin LEFT JOIN atranslationsen.comments atranslationsencommentsjoin WHERE CASE WHEN atranslationspl.id IS NOT NULL AND atranslationsplcommentsjoin IN(:acommentsval) THEN TRUE WHEN atranslationsencommentsjoin IN(:acommentsval) THEN TRUE ELSE FALSE END = TRUE', self::ARTICLE)), $qb->getDQL()); $this->assertEquals($this->_languagePl, $qb->getParameter('atranslationsplloc')->getValue()); $this->assertEquals($this->_languageEn, $qb->getParameter('atranslationsenloc')->getValue()); $this->assertEquals($whereComments, $qb->getParameter('acommentsval')->getValue()); $qb->getQuery()->execute(); }
/** * @param $alias * @param array $criteria * @param array $orderBy * @param $limit * @param $offset * @param mixed $locale * @return QueryBuilder * @throws ConditionException */ private function createFindTranslatableQueryBuilder($alias, array $criteria, array $orderBy = null, $limit = null, $offset = null, $locale = null) { $qb = new QueryBuilder($this->_em); $qb->from($this->_entityName, $alias); $qb->select($alias); foreach ($criteria as $criteriaField => $criteriaValue) { $qb->addTranslatableWhere($alias, $criteriaField, $criteriaValue, $locale); } if (isset($orderBy)) { foreach ($orderBy as $orderField => $orderDirection) { $qb->addTranslatableOrderBy($alias, $orderField, $orderDirection, $locale); } } if (isset($limit)) { $qb->setMaxResults($limit); } if (isset($offset)) { $qb->setFirstResult($offset); return $qb; } return $qb; }