public function getCount(array $p_params = null, array $p_cols = null)
{
$qb = $this->createQueryBuilder('e')->select('COUNT(e)');
if (is_array($p_params) && !empty($p_params['sSearch'])) {
if (array_key_exists('user', $p_cols)) {
$qb->leftJoin('e.user', 'u');
}
$qb->where($this->buildWhere($p_cols, $p_params['sSearch']));
}
return $qb->getQuery()->getSingleScalarResult();
}