nextcloud / server

	 * @param string $identifier

	 * @return mixed

	 */

	public function retrieve($userId, $identifier) {

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

		$qb->select('credentials')

			->from(self::DB_TABLE)

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

			->andWhere($qb->expr()->eq('identifier', $qb->createNamedParameter($identifier)))

		;

		$result = $qb->execute()->fetch();

		if (!$result) {

			return null;

		}

		$value = $result['credentials'];

		return json_decode($this->crypto->decrypt($value), true);

	}

	/**

	 * Delete a set of credentials

	 *

	 * Checks whether the user is member of a group or not.

	 */

	public function inGroup( $uid, $gid ) {

		$this->fixDI();

		// check

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

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

			->from('group_user')

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

			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($uid)))

			->execute();

		$result = $cursor->fetch();

		$cursor->closeCursor();

		return $result ? true : false;

	}

	/**

	 * Add a user to a group

	 * @param bool $excludeBirthday

	 * @return int

	 */

	public function getCalendarsForUserCount($principalUri, $excludeBirthday = true) {

		$principalUri = $this->convertPrincipal($principalUri, true);

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

		$query->select($query->createFunction('COUNT(*)'))

			->from('calendars')

			->where($query->expr()->eq('principaluri', $query->createNamedParameter($principalUri)));

		if ($excludeBirthday) {

			$query->andWhere($query->expr()->neq('uri', $query->createNamedParameter(BirthdayService::BIRTHDAY_CALENDAR_URI)));

		}

		return (int)$query->execute()->fetchColumn();

	}

	/**

	 * Returns a list of calendars for a principal.

	 * @param \OCA\DAV\CalDAV\Calendar $calendar

	 * @return mixed

	 */

	public function getPublishStatus($calendar) {

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

		$result = $query->select('publicuri')

			->from('dav_shares')

			->where($query->expr()->eq('resourceid', $query->createNamedParameter($calendar->getResourceId())))

			->andWhere($query->expr()->eq('access', $query->createNamedParameter(self::ACCESS_PUBLIC)))

			->execute();

		$row = $result->fetch();

		$result->closeCursor();

		return $row ? reset($row) : false;

	}

	/**

	 * @param int $resourceId

		$qb->execute();

	}

	public function hasExpiredTokens(string $uid): bool {

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

		$qb->select('*')

			->from('authtoken')

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

			->andWhere($qb->expr()->eq('password_invalid', $qb->createNamedParameter(true), IQueryBuilder::PARAM_BOOL))

			->setMaxResults(1);

		$cursor = $qb->execute();

		$data = $cursor->fetchAll();

		$cursor->closeCursor();

		return count($data) === 1;

	}

}