public getAllByArticleNumber ( integer $articleNumber, boolean $fetchReplies = true ) : Doctrine\ORM\Query | ||
$articleNumber | integer | |
$fetchReplies | boolean | |
Résultat | Doctrine\ORM\Query |
public function getAllByArticleNumber($articleNumber, $fetchReplies = true)
{
$qb = $this->createQueryBuilder('ec');
$qb->select('ec', 'u')->join('ec.user', 'u')->where('ec.articleNumber = :articleNumber')->andWhere('ec.is_active = :is_active')->andWhere('ec.resolved = false')->setParameters(array('articleNumber' => $articleNumber, 'is_active' => true));
if (!$fetchReplies) {
$qb->andWhere($qb->expr()->isNull('ec.parentId'));
}
return $qb->getQuery();
}