nextcloud / server

	 * @param string $search

	 * @return int|bool

	 */

	public function countDisabledInGroup(string $gid): int {

		$this->fixDI();

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

		$query->select($query->createFunction('COUNT(Distinct uid)'))

			->from('preferences', 'p')

			->innerJoin('p', 'group_user', 'g', 'p.userid = g.uid')

			->where($query->expr()->eq('appid', $query->createNamedParameter('core')))

			->andWhere($query->expr()->eq('configkey', $query->createNamedParameter('enabled')))

			->andWhere($query->expr()->eq('configvalue', $query->createNamedParameter('false'), IQueryBuilder::PARAM_STR))

			->andWhere($query->expr()->eq('gid', $query->createNamedParameter($gid), IQueryBuilder::PARAM_STR));

		$result = $query->execute();

		$count = $result->fetchColumn();

		$result->closeCursor();

		if ($count !== false) {

			$count = (int)$count;

		} else {

			$count = 0;

		}

		return $count;

	}

}

	 * @return int

	 * @since 14.0.0

	 */

	public function countDisabledUsersOfGroups(array $groups): int {

		$queryBuilder = \OC::$server->getDatabaseConnection()->getQueryBuilder();

		$queryBuilder->select($queryBuilder->createFunction('COUNT(Distinct uid)'))

			->from('preferences', 'p')

			->innerJoin('p', 'group_user', 'g', 'p.userid = g.uid')

			->where($queryBuilder->expr()->eq('appid', $queryBuilder->createNamedParameter('core')))

			->andWhere($queryBuilder->expr()->eq('configkey', $queryBuilder->createNamedParameter('enabled')))

			->andWhere($queryBuilder->expr()->eq('configvalue', $queryBuilder->createNamedParameter('false'), IQueryBuilder::PARAM_STR))

			->andWhere($queryBuilder->expr()->in('gid', $queryBuilder->createNamedParameter($groups, IQueryBuilder::PARAM_STR_ARRAY)));

		$result = $queryBuilder->execute();

		$count = $result->fetchColumn();

		$result->closeCursor();

		if ($count !== false) {

			$count = (int)$count;

		} else {

			$count = 0;

		}

		return $count;

	}

	/**

	 * returns how many users have logged in once