Newscoop\Datatable\Source::getCount PHP Method

getCount() public method

Get entity count
public getCount ( array $p_params = null, array $p_cols = null ) : integer
$p_params array
$p_cols array
return integer
    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();
    }