public static function countRows($status = NULL, $filter = null) { $result = DB::select(array(DB::expr('COUNT(' . static::$table . '.id)'), 'count'))->from(static::$table)->where('role_id', '=', 1); $result = parent::setFilter($result); if ($status !== NULL) { $result->where(static::$table . '.status', '=', $status); } return $result->count_all(); }