/** * Gets all user limited with page and limit * * @param int $page * @param into $limit * @return object */ public function getAll($page = 1, $limit = 40) { $users = $this->dc->qb()->select('*')->from($this->dc->p($this->config->get('foolz/foolframe', 'foolauth', 'table_name')), 't')->setMaxResults($limit)->setFirstResult($page * $limit - $limit)->execute()->fetchAll(); $users = User::forge($this->getContext(), $users); $count = $this->dc->qb()->select('COUNT(*) as count')->from($this->dc->p($this->config->get('foolz/foolframe', 'foolauth', 'table_name')), 't')->execute()->fetch(); return ['result' => $users, 'count' => $count['count']]; }