コード例 #1
0
 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();
 }
コード例 #2
0
 private function fillDataForFindTranslatable()
 {
     /** @var \FSi\DoctrineExtensions\Translatable\Entity\Repository\TranslatableRepository $repository */
     $repository = $this->_em->getRepository(self::ARTICLE);
     $article1 = new Article();
     $this->_em->persist($article1);
     $article1->setDate(new \DateTime('2014-01-01 00:00:00'));
     $translationEn = $repository->getTranslation($article1, $this->_languageEn);
     $translationEn->setTitle(self::ENGLISH_TITLE_1);
     $translationEn->setIntroduction(self::ENGLISH_TEASER);
     $translationEn->setContents(self::ENGLISH_CONTENTS_1);
     $this->_em->persist($translationEn);
     $article2 = new Article();
     $this->_em->persist($article2);
     $article2->setDate(new \DateTime('2014-02-02 00:00:00'));
     $translationPl = $repository->getTranslation($article2, $this->_languagePl);
     $translationPl->setTitle(self::POLISH_TITLE_1);
     $translationPl->setIntroduction(self::POLISH_TEASER);
     $translationPl->setContents(self::POLISH_CONTENTS_1);
     $this->_em->persist($translationPl);
     $category1 = new Category();
     $category1->setTitle(self::CATEGORY_1);
     $article1->addCategory($category1);
     $article2->addCategory($category1);
     $this->_em->persist($category1);
     $section = new Section();
     $section->setTitle(self::SECTION_1);
     $article1->setSection($section);
     $article2->setSection($section);
     $this->_em->persist($section);
     $comment = new Comment();
     $comment->setContent('Lorem');
     $comment->setDate(new \DateTime());
     $comment->setArticleTranslation($translationPl);
     $this->_em->persist($comment);
     $comment = new Comment();
     $comment->setContent('Ipsum');
     $comment->setDate(new \DateTime());
     $comment->setArticleTranslation($translationPl);
     $this->_em->persist($comment);
     $this->_em->flush();
     $this->_em->refresh($article1);
     $this->_em->refresh($article2);
 }