public function getOneByArticleAndCommentId($articleNumber, $languageId, $commentId, $fetchReplies = true)
{
$qb = $this->createQueryBuilder('ec');
$qb->select('ec', 'u')->join('ec.user', 'u')->where('ec.articleNumber = :articleNumber')->andWhere('ec.languageId = :languageId')->andWhere('ec.id = :commentId')->andWhere('ec.is_active = :is_active')->setParameters(array('articleNumber' => $articleNumber, 'languageId' => $languageId, 'commentId' => $commentId, 'is_active' => true));
if (!$fetchReplies) {
$qb->andWhere($qb->expr()->isNull('ec.parentId'));
}
return $qb->getQuery();
}