public function getArticleAuthor($articleNumber, $languageCode, $authorId, $typeId = null) { $languageId = $this->_em->getRepository('Newscoop\\Entity\\Language')->findOneByCode($languageCode); $qb = $this->createQueryBuilder('au')->where('au.articleNumber = :articleNumber')->andWhere('au.languageId = :languageId')->andWhere('au.author = :author')->setParameters(array('articleNumber' => $articleNumber, 'languageId' => $languageId, 'author' => $authorId)); if ($typeId) { $qb->andWhere('au.type = :type')->setParameter('type', $typeId); } return $qb->getQuery(); }