Newscoop\Entity\Repository\CommentRepository::getCount PHP Method

    public function getCount(array $p_params = null, array $p_cols = array())
    {
        $qb = $this->createQueryBuilder('e');
        $qb->from('Newscoop\\Entity\\Comment\\Commenter', 'c')->from('Newscoop\\Entity\\Article', 'a');
        $andx = $qb->expr()->andx();
        $andx->add($qb->expr()->eq('e.language', new Expr\Literal('a.language')));
        $andx->add($qb->expr()->eq('e.thread', new Expr\Literal('a.number')));
        $andx->add($qb->expr()->eq('e.commenter', new Expr\Literal('c.id')));
        if (is_array($p_params) && !empty($p_params['sSearch'])) {
            $this->buildWhere($p_cols, $p_params['sSearch'], $qb, $andx);
        }
        if (is_array($p_params) && !empty($p_params['sFilter'])) {
            $this->buildFilter($p_cols, $p_params['sFilter'], $qb, $andx);
        }
        $qb->where($andx);
        $qb->select('COUNT(e)');
        return $qb->getQuery()->getSingleScalarResult();
    }