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();
}