nextcloud / server

	 * @param IUser $user the SubAdmin

	 * @return IGroup[]

	 */

	public function getSubAdminsGroups(IUser $user) {

		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('gid')

			->from('group_admin')

			->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))

			->execute();

		$groups = [];

		while($row = $result->fetch()) {

			$group = $this->groupManager->get($row['gid']);

			if(!is_null($group)) {

				$groups[$group->getGID()] = $group;

			}

		}

		$result->closeCursor();

		return $groups;

	}

	/**

	 * get an array of groupid and displayName for a user

	 * @param IGroup $group the group

	 * @return IUser[]

	 */

	public function getGroupsSubAdmins(IGroup $group) {

		$qb = $this->dbConn->getQueryBuilder();

		$result = $qb->select('uid')

			->from('group_admin')

			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))

			->execute();

		$users = [];

		while($row = $result->fetch()) {

			$user = $this->userManager->get($row['uid']);

			if(!is_null($user)) {

				$users[] = $user;

			}

		}

		$result->closeCursor();

		return $users;

	}

	/**

	 * get all SubAdmins