Skip to content

A free and open source instant messaging and VoIP chat app built for friends, groups, and communities.

TypeScript fluxerfluxerapp
27.8 KB
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-or-later

import type {GuildID, UserID} from '@app/api/BrandedTypes';
import {Config} from '@app/api/Config';
import type {UserConnectionRow} from '@app/api/database/types/ConnectionTypes';
import type {
	OperatorPassCertificateRow,
	OperatorPassLabsMemberRow,
	OperatorPassOfferRow,
	OperatorPassPurchaseRow,
	OperatorPassRow,
	OperatorPassUnitEventRow,
	OperatorPassUnitRow,
	OperatorPassVisionaryActivationRow,
	OperatorPassWaitlistRow,
	OperatorPassWallEntryRow,
	OperatorPassWallEventRow,
} from '@app/api/database/types/OperatorPassTypes';
import type {StorePurchaseRow} from '@app/api/database/types/StoreBillingTypes';
import type {Application} from '@app/api/models/Application';
import type {AuthSession} from '@app/api/models/AuthSession';
import type {Channel} from '@app/api/models/Channel';
import type {FavoriteMeme} from '@app/api/models/FavoriteMeme';
import type {GiftCode} from '@app/api/models/GiftCode';
import type {Guild} from '@app/api/models/Guild';
import type {GuildMember} from '@app/api/models/GuildMember';
import type {MfaBackupCode} from '@app/api/models/MfaBackupCode';
import type {Payment} from '@app/api/models/Payment';
import type {PushSubscription} from '@app/api/models/PushSubscription';
import type {Relationship} from '@app/api/models/Relationship';
import type {SavedMessage} from '@app/api/models/SavedMessage';
import type {ThreadMember} from '@app/api/models/ThreadMember';
import type {User} from '@app/api/models/User';
import type {UserGuildSettings} from '@app/api/models/UserGuildSettings';
import type {UserSettings} from '@app/api/models/UserSettings';
import type {WebAuthnCredential} from '@app/api/models/WebAuthnCredential';
import {mapStorePurchaseToResponse} from '@app/api/store_billing/StoreBillingMappers';
import {resolveSessionClientInfo} from '@app/api/utils/SessionClientIdentity';
import {getAnimatedAssetExtension} from '@app/api/worker/utils/AssetArchiveHelpers';
import {PremiumFlags} from '@fluxer/constants/src/UserConstants';
import {
	decodeSyncedPreferencesLenient,
	syncedPreferencesToJson,
} from '@fluxer/schema/src/domains/user/SyncedPreferencesCodec';
import {snowflakeToDate} from '@fluxer/snowflake/src/Snowflake';

interface GuildMembershipEntry {
	member: GuildMember | null;
	guild: Guild | null;
	guildId: GuildID;
}

interface ArchivedUserSettings {
	locale: UserSettings['locale'];
	theme: string;
	status: string;
	custom_status: {
		text: string | null;
		emoji_id: string | null;
		emoji_name: string | null;
		emoji_animated: boolean;
		expires_at: string | null;
	} | null;
	developer_mode: boolean;
	message_display_compact: boolean;
	animate_emoji: boolean;
	animate_stickers: UserSettings['animateStickers'];
	gif_auto_play: boolean;
	render_embeds: boolean;
	render_reactions: boolean;
	render_spoilers: UserSettings['renderSpoilers'];
	inline_attachment_media: boolean;
	inline_embed_media: boolean;
	explicit_content_filter: number;
	friend_source_flags: number;
	allow_mature_content_on_ios: boolean;
	default_guilds_restricted: boolean;
	bot_default_guilds_restricted: boolean;
	restricted_guilds: Array<string>;
	bot_restricted_guilds: Array<string>;
	guild_positions: Array<string>;
	guild_folders: Array<{
		id: number;
		name: string | null;
		color: number | null;
		flags: number;
		icon: UserSettings['guildFolders'][number]['icon'];
		guild_ids: Array<string>;
	}>;
	afk_timeout: number;
	time_format: UserSettings['timeFormat'];
	suppress_unprivileged_self_mentions: boolean;
	suppress_unprivileged_self_mentions_bypass_user_ids: Array<string>;
	staff_dm_access_user_ids: Array<string>;
	synced_preferences: unknown;
	profile_privacy: UserSettings['profilePrivacy'];
	privacy_setup_version: number;
	privacy_setup_completed_at: string | null;
}

interface UserDataJsonParams {
	user: User;
	userId: UserID;
	productName: string;
	authSessions: Array<AuthSession>;
	relationships: Array<Relationship>;
	userNotes: Map<UserID, string>;
	userSettings: UserSettings | null;
	guildMemberships: Array<GuildMembershipEntry>;
	guildSettings: Array<UserGuildSettings | null>;
	threadMemberships: Array<ThreadMember>;
	savedMessages: Array<SavedMessage>;
	privateChannels: Array<Channel>;
	favoriteMemes: Array<FavoriteMeme>;
	pushSubscriptions: Array<PushSubscription>;
	webAuthnCredentials: Array<WebAuthnCredential>;
	mfaBackupCodes: Array<MfaBackupCode>;
	recoveryKitCreatedAt: Date | null;
	createdGiftCodes: Array<GiftCode>;
	payments: Array<Payment>;
	storePurchases: Array<StorePurchaseRow>;
	operatorPass: OperatorPassRow | null;
	operatorPassPurchases: Array<OperatorPassPurchaseRow>;
	operatorPassWaitlistEntry: OperatorPassWaitlistRow | null;
	operatorPassWall: OperatorPassWallEntryRow | null;
	operatorPassWallEvents: Array<OperatorPassWallEventRow>;
	operatorPassUnits: Array<{unit: OperatorPassUnitRow; events: Array<OperatorPassUnitEventRow>}>;
	operatorPassOffers: Array<OperatorPassOfferRow>;
	operatorPassCertificates: Array<OperatorPassCertificateRow>;
	operatorPassVisionaryActivation: OperatorPassVisionaryActivationRow | null;
	operatorPassLabs: OperatorPassLabsMemberRow | null;
	oauthClients: Array<Application>;
	connections: Array<UserConnectionRow>;
	pinnedDms: Array<{
		channel_id: bigint;
		sort_order: number;
	}>;
	authorizedIps: Array<{
		ip: string;
	}>;
	activityData: {
		last_active_at: Date | null;
		last_active_ip: string | null;
	};
}

function mapOperatorPassUnit(unit: OperatorPassUnitRow, events: Array<OperatorPassUnitEventRow>, userId: UserID) {
	const bought = unit.buyer_id === userId;
	const handOff = events.findIndex((event) => event.kind === 'transferred');
	const received = events.findIndex((event) => event.kind === 'transferred' && event.recipient_id === userId);
	const passedOn = bought && handOff !== -1;
	let visible = events;
	if (passedOn) {
		visible = events.slice(0, handOff + 1);
	} else if (!bought && received !== -1) {
		visible = events.slice(received);
	} else if (!bought && unit.purchase_id !== null) {
		visible = [];
	}
	return {
		id: bought || unit.purchase_id === null ? unit.pass_id : null,
		purchase_id: bought ? (unit.purchase_id ?? null) : null,
		source: unit.source,
		status: passedOn ? 'passed_on' : unit.status,
		held_by_you: unit.holder_id === userId,
		delivered_at: (passedOn ? unit.first_delivered_at : unit.delivered_at).toISOString(),
		first_delivered_at: (bought ? unit.first_delivered_at : unit.delivered_at).toISOString(),
		ended_at: passedOn ? null : (unit.ended_at?.toISOString() ?? null),
		end_reason: passedOn ? null : (unit.end_reason ?? null),
		withdrawal_country: bought ? (unit.withdrawal_country ?? null) : null,
		withdrawal_days: bought ? (unit.withdrawal_days ?? null) : null,
		events: visible.map((event) => ({
			occurred_at: event.occurred_at.toISOString(),
			kind: event.kind,
			payment_id: bought ? (event.payment_id ?? null) : null,
			sender_id: event.sender_id?.toString() ?? null,
			recipient_id: event.recipient_id?.toString() ?? null,
			offer_id: event.offer_id ?? null,
			country: bought ? (event.country ?? null) : null,
			days: bought ? (event.days ?? null) : null,
			rule_version: bought ? (event.rule_version ?? null) : null,
			reason: event.reason ?? null,
		})),
	};
}

export function mapPayment(payment: Payment) {
	return {
		checkout_session_id: payment.checkoutSessionId,
		amount_cents: payment.amountCents,
		currency: payment.currency,
		status: payment.status,
		subscription_id: payment.subscriptionId,
		payment_intent_id: payment.paymentIntentId,
		product_type: payment.productType,
		is_gift: payment.isGift,
		gift_code: payment.giftCode,
		created_at: payment.createdAt.toISOString(),
		completed_at: payment.completedAt?.toISOString() ?? null,
	};
}

export function mapOAuthApplication(app: Application) {
	return {
		application_id: app.applicationId.toString(),
		name: app.name,
		redirect_uris: Array.from(app.oauth2RedirectUris),
	};
}

export function mapSecurityData(params: {
	authorizedIps: Array<{
		ip: string;
	}>;
	activityData: {
		last_active_at: Date | null;
		last_active_ip: string | null;
	};
}) {
	return {
		authorized_ips: params.authorizedIps,
		activity_tracking: {
			last_active_at: params.activityData.last_active_at?.toISOString() ?? null,
			last_active_ip: params.activityData.last_active_ip,
		},
	};
}

export function getOperatorPassCertificateArchivePath(
	certificate: Pick<OperatorPassCertificateRow, 'number' | 'version'>,
): string {
	return `operator_pass/certificates/${certificate.number}-copy-${certificate.version}.pdf`;
}

export function buildUserDataJson(params: UserDataJsonParams) {
	const {
		user,
		userId,
		productName,
		authSessions,
		relationships,
		userNotes,
		userSettings,
		guildMemberships,
		guildSettings,
		threadMemberships,
		savedMessages,
		privateChannels,
		favoriteMemes,
		pushSubscriptions,
		webAuthnCredentials,
		mfaBackupCodes,
		recoveryKitCreatedAt,
		createdGiftCodes,
		payments,
		storePurchases,
		operatorPass,
		operatorPassPurchases,
		operatorPassWaitlistEntry,
		operatorPassWall,
		operatorPassWallEvents,
		operatorPassUnits,
		operatorPassOffers,
		operatorPassCertificates,
		operatorPassVisionaryActivation,
		operatorPassLabs,
		oauthClients,
		connections,
		pinnedDms,
		authorizedIps,
		activityData,
	} = params;
	const responseFields = {
		user: {
			id: user.id.toString(),
			username: user.username,
			discriminator: user.discriminator,
			bot: user.isBot,
			system: user.isSystem,
			email: user.email,
			email_verified: user.emailVerified,
			email_bounced: user.emailBounced,
			avatar_hash: user.avatarHash,
			avatar_url: user.avatarHash
				? `${Config.endpoints.media}/avatars/${userId}/${user.avatarHash}.${getAnimatedAssetExtension(user.avatarHash)}`
				: null,
			banner_hash: user.bannerHash,
			banner_url: user.bannerHash
				? `${Config.endpoints.media}/banners/${userId}/${user.bannerHash}.${getAnimatedAssetExtension(user.bannerHash)}`
				: null,
			bio: user.bio,
			pronouns: user.pronouns,
			accent_color: user.accentColor,
			date_of_birth: user.dateOfBirth,
			locale: user.locale,
			flags: user.flags.toString(),
			premium_type: user.premiumType,
			premium_since: user.premiumSince?.toISOString() ?? null,
			premium_until: user.premiumUntil?.toISOString() ?? null,
			premium_lifetime_sequence: user.premiumLifetimeSequence,
			operator_pass_show_operators: (user.premiumFlags & PremiumFlags.OPERATORS_CHANNEL_HIDDEN) === 0,
			stripe_customer_id: user.stripeCustomerId,
			stripe_subscription_id: user.stripeSubscriptionId,
			terms_agreed_at: user.termsAgreedAt?.toISOString() ?? null,
			privacy_agreed_at: user.privacyAgreedAt?.toISOString() ?? null,
			last_active_at: user.lastActiveAt?.toISOString() ?? null,
			created_at: snowflakeToDate(user.id).toISOString(),
			mfa_enabled: user.authenticatorTypes.size > 0,
			authenticator_types: Array.from(user.authenticatorTypes),
		},
		auth_sessions: authSessions.map((session) => {
			const clientInfo = resolveSessionClientInfo({
				userAgent: session.clientUserAgent,
				reportedOs: session.clientOs ?? null,
				productName,
			});
			return {
				created_at: session.createdAt.toISOString(),
				approx_last_used_at: session.approximateLastUsedAt?.toISOString() ?? null,
				client_ip: session.clientIp,
				client_os: clientInfo.os,
				client_user_agent: session.clientUserAgent,
				client_platform: clientInfo.platform,
				app_platform: session.appPlatform,
				app_version: session.appVersion,
				app_release_channel: session.appReleaseChannel,
				app_build_number: session.appBuildNumber,
				app_beta_number: session.appBetaNumber,
			};
		}),
		relationships: relationships.map((rel) => ({
			target_user_id: rel.targetUserId.toString(),
			type: rel.type,
			nickname: rel.nickname,
			since: rel.since?.toISOString() ?? null,
		})),
		notes: Array.from(userNotes.entries()).map(([targetUserId, note]) => ({
			target_user_id: targetUserId.toString(),
			note,
		})),
	};
	let archivedSettings: ArchivedUserSettings | null = null;
	if (userSettings) {
		const statusFields = {
			locale: userSettings.locale,
			theme: userSettings.theme,
			status: userSettings.status,
		};
		let customStatus: ArchivedUserSettings['custom_status'] = null;
		if (userSettings.customStatus) {
			customStatus = {
				text: userSettings.customStatus.text,
				emoji_id: userSettings.customStatus.emojiId?.toString() ?? null,
				emoji_name: userSettings.customStatus.emojiName,
				emoji_animated: userSettings.customStatus.emojiAnimated,
				expires_at: userSettings.customStatus.expiresAt?.toISOString() ?? null,
			};
		}
		archivedSettings = {
			...statusFields,
			custom_status: customStatus,
			developer_mode: userSettings.developerMode,
			message_display_compact: userSettings.compactMessageDisplay,
			animate_emoji: userSettings.animateEmoji,
			animate_stickers: userSettings.animateStickers,
			gif_auto_play: userSettings.gifAutoPlay,
			render_embeds: userSettings.renderEmbeds,
			render_reactions: userSettings.renderReactions,
			render_spoilers: userSettings.renderSpoilers,
			inline_attachment_media: userSettings.inlineAttachmentMedia,
			inline_embed_media: userSettings.inlineEmbedMedia,
			explicit_content_filter: userSettings.explicitContentFilter,
			friend_source_flags: userSettings.friendSourceFlags,
			allow_mature_content_on_ios: userSettings.allowMatureContentOnIos,
			default_guilds_restricted: userSettings.defaultGuildsRestricted,
			bot_default_guilds_restricted: userSettings.botDefaultGuildsRestricted,
			restricted_guilds: Array.from(userSettings.restrictedGuilds).map((id) => id.toString()),
			bot_restricted_guilds: Array.from(userSettings.botRestrictedGuilds).map((id) => id.toString()),
			guild_positions: userSettings.guildPositions.map((id) => id.toString()),
			guild_folders: userSettings.guildFolders.map((folder) => ({
				id: folder.folderId,
				name: folder.name,
				color: folder.color,
				flags: folder.flags,
				icon: folder.icon,
				guild_ids: folder.guildIds.map(String),
			})),
			afk_timeout: userSettings.afkTimeout,
			time_format: userSettings.timeFormat,
			suppress_unprivileged_self_mentions: userSettings.suppressUnprivilegedSelfMentions,
			suppress_unprivileged_self_mentions_bypass_user_ids: Array.from(
				userSettings.suppressUnprivilegedSelfMentionBypassUserIds,
			).map((id) => id.toString()),
			staff_dm_access_user_ids: Array.from(userSettings.staffDmAccessUserIds).map((id) => id.toString()),
			synced_preferences: syncedPreferencesToJson(decodeSyncedPreferencesLenient(userSettings.syncedPreferences)),
			profile_privacy: userSettings.profilePrivacy,
			privacy_setup_version: userSettings.privacySetupVersion,
			privacy_setup_completed_at: userSettings.privacySetupCompletedAt?.toISOString() ?? null,
		};
	}
	return {
		...responseFields,
		user_settings: archivedSettings,
		guild_memberships: guildMemberships
			.filter((membership): membership is GuildMembershipEntry & {member: GuildMember} => membership.member !== null)
			.map(({member, guild, guildId}) => ({
				guild_id: guildId.toString(),
				guild_name: guild?.name ?? null,
				joined_at: member.joinedAt.toISOString(),
				nick: member.nickname,
				avatar_hash: member.avatarHash,
				avatar_url: member.avatarHash
					? `${Config.endpoints.media}/guilds/${guildId}/users/${userId}/avatars/${member.avatarHash}`
					: null,
				banner_hash: member.bannerHash,
				banner_url: member.bannerHash
					? `${Config.endpoints.media}/guilds/${guildId}/users/${userId}/banners/${member.bannerHash}`
					: null,
				role_ids: Array.from(member.roleIds).map((id) => id.toString()),
			})),
		user_guild_settings: guildSettings
			.filter((settings) => settings !== null)
			.map((settings) => ({
				guild_id: settings.guildId.toString(),
				message_notifications: settings.messageNotifications,
				muted: settings.muted,
				mobile_push: settings.mobilePush,
				suppress_everyone: settings.suppressEveryone,
				suppress_roles: settings.suppressRoles,
				hide_muted_channels: settings.hideMutedChannels,
			})),
		...(threadMemberships.length > 0
			? {
					thread_memberships: threadMemberships.map((member) => ({
						thread_id: member.threadId.toString(),
						guild_id: member.guildId.toString(),
						parent_id: member.parentId.toString(),
						join_timestamp: member.joinTimestamp.toISOString(),
						flags: member.flags,
						muted: member.muted,
					})),
				}
			: {}),
		saved_messages: savedMessages.map((msg) => ({
			channel_id: msg.channelId.toString(),
			message_id: msg.messageId.toString(),
			saved_at: msg.savedAt.toISOString(),
		})),
		private_channels: privateChannels.map((channel) => ({
			channel_id: channel.id.toString(),
			type: channel.type,
			name: channel.name,
			icon_hash: channel.iconHash,
			owner_id: channel.ownerId?.toString() ?? null,
			recipient_ids: Array.from(channel.recipientIds).map((id) => id.toString()),
			last_message_id: channel.lastMessageId?.toString() ?? null,
		})),
		favorite_memes: favoriteMemes.map((meme) => ({
			meme_id: meme.id.toString(),
			name: meme.name,
			alt_text: meme.altText,
			tags: meme.tags,
			filename: meme.filename,
			content_type: meme.contentType,
			size: meme.size.toString(),
			width: meme.width,
			height: meme.height,
			duration: meme.duration,
		})),
		push_subscriptions: pushSubscriptions.map((sub) => ({
			subscription_id: sub.subscriptionId,
			platform: sub.platform,
			app_id: sub.appId,
			provider_environment: sub.providerEnvironment,
			endpoint: sub.endpoint,
			user_agent: sub.userAgent,
		})),
		webauthn_credentials: webAuthnCredentials.map((cred) => ({
			credential_id: cred.credentialId,
			name: cred.name,
			transports: cred.transports ? Array.from(cred.transports) : [],
			created_at: cred.createdAt.toISOString(),
			last_used_at: cred.lastUsedAt?.toISOString() ?? null,
		})),
		mfa_backup_codes: {
			total_count: mfaBackupCodes.length,
			consumed_count: mfaBackupCodes.filter((code) => code.consumed).length,
			remaining_count: mfaBackupCodes.filter((code) => !code.consumed).length,
		},
		...(recoveryKitCreatedAt ? {recovery_kit: {created_at: recoveryKitCreatedAt.toISOString()}} : {}),
		gift_codes_created: createdGiftCodes.map((gift) => ({
			code: gift.code,
			duration_months: gift.durationMonths,
			duration_type: gift.durationType,
			duration_quantity: gift.durationQuantity,
			created_at: gift.createdAt.toISOString(),
			redeemed_by_user_id: gift.redeemedByUserId?.toString() ?? null,
			redeemed_at: gift.redeemedAt?.toISOString() ?? null,
			stripe_payment_intent_id: gift.stripePaymentIntentId,
		})),
		payments: payments.map(mapPayment),
		store_purchases: storePurchases.map(mapStorePurchaseToResponse),
		operator_pass: operatorPass
			? {
					granted_at: operatorPass.granted_at.toISOString(),
					source: operatorPass.source,
					checkout_session_id: operatorPass.checkout_session_id ?? null,
					pass_count: operatorPass.pass_count ?? 1,
					payment_intent_id: operatorPass.payment_intent_id ?? null,
					amount_minor: operatorPass.amount_minor ?? null,
					currency: operatorPass.currency ?? null,
					paused: operatorPass.paused_at != null,
					terms_version: operatorPass.terms_version ?? null,
					terms_accepted_at: operatorPass.terms_accepted_at?.toISOString() ?? null,
					waiver_consent_at: operatorPass.waiver_consent_at?.toISOString() ?? null,
					waiver_consent_version: operatorPass.waiver_consent_version ?? null,
					waiver_consent_ip: operatorPass.waiver_consent_ip ?? null,
					waiver_consent_user_agent: operatorPass.waiver_consent_user_agent ?? null,
				}
			: null,
		operator_pass_wall: operatorPassWall
			? {
					name: operatorPassWall.name ?? null,
					quote: operatorPassWall.quote ?? null,
					opted_out: operatorPassWall.opted_out,
					keep_as_is: operatorPassWall.keep_as_is,
					release_list_opt_in: operatorPassWall.release_list_opt_in ?? false,
					hidden: operatorPassWall.hidden,
					live_name: operatorPassWall.live_name ?? null,
					business: operatorPassWall.live_business ?? false,
					pending_name: operatorPassWall.pending_name ?? null,
					declined_name: operatorPassWall.declined_name ?? null,
					decline_reason: operatorPassWall.decline_reason ?? null,
					decline_note: operatorPassWall.decline_note ?? null,
					listed_at: operatorPassWall.listed_at?.toISOString() ?? null,
					delivered_at: operatorPassWall.delivered_at?.toISOString() ?? null,
					release_published_year: operatorPassWall.release_published_year ?? null,
					release_erased_at: operatorPassWall.release_erased_at?.toISOString() ?? null,
				}
			: null,
		operator_pass_wall_history: operatorPassWallEvents.map((event) => ({
			occurred_at: event.occurred_at.toISOString(),
			kind: event.kind,
			name: event.name ?? null,
			reason: event.reason ?? null,
			cause: event.cause ?? null,
			purchase_id: operatorPassPurchases.some((purchase) => purchase.checkout_session_id === event.purchase_id)
				? (event.purchase_id ?? null)
				: null,
			release_year: event.release_year ?? null,
			release_tag: event.release_tag ?? null,
			pass_count: event.pass_count ?? null,
			first_pass_at: event.first_pass_at?.toISOString() ?? null,
		})),
		operator_pass_purchases: operatorPassPurchases.map((purchase) => ({
			checkout_session_id: purchase.checkout_session_id,
			quantity: purchase.quantity ?? 1,
			status: purchase.status,
			phase: purchase.phase,
			amount_minor: purchase.amount_minor,
			currency: purchase.currency,
			quote_honored: purchase.quote_honored,
			payment_intent_id: purchase.payment_intent_id ?? null,
			invoice_id: purchase.invoice_id ?? null,
			created_at: purchase.created_at.toISOString(),
			completed_at: purchase.completed_at?.toISOString() ?? null,
			refunded_at: purchase.refunded_at?.toISOString() ?? null,
			terms_version: purchase.operator_pass_terms_version ?? null,
			purchased_at: purchase.purchased_at?.toISOString() ?? null,
			delivered_at: (purchase.delivered_at ?? purchase.perks_granted_at)?.toISOString() ?? null,
			withdrawal_ends_at: purchase.withdrawal_ends_at?.toISOString() ?? null,
			withdrawn_at: purchase.withdrawn_at?.toISOString() ?? null,
			withdrawal_name: purchase.withdrawal_name ?? null,
			waiver_consent_at: purchase.waiver_consent_at?.toISOString() ?? null,
			waiver_consent_version: purchase.waiver_consent_version ?? null,
			waiver_consent_text: purchase.waiver_consent_text ?? null,
			waiver_consent_ip: purchase.waiver_consent_ip ?? null,
			waiver_consent_user_agent: purchase.waiver_consent_user_agent ?? null,
			wall_name: purchase.wall_name ?? null,
			wall_opt_out: purchase.wall_opt_out ?? null,
			labs_greeting: purchase.labs_greeting ?? null,
			withdrawal_country: purchase.withdrawal_country ?? null,
			withdrawal_days: purchase.withdrawal_days ?? null,
			withdrawal_rule_version: purchase.withdrawal_rule_version ?? null,
			stripe_terms_consent: purchase.stripe_terms_consent ?? null,
			certificate_names: purchase.certificate_names ?? null,
			age_confirmed_at: purchase.age_confirmed_at?.toISOString() ?? null,
		})),
		operator_passes: operatorPassUnits.map(({unit, events}) => mapOperatorPassUnit(unit, events, userId)),
		operator_pass_offers: operatorPassOffers.map((offer) => ({
			id: offer.offer_id,
			pass_id: offer.sender_id === userId ? offer.pass_id : null,
			status: offer.status,
			sender_id: offer.sender_id.toString(),
			recipient_id: offer.recipient_id.toString(),
			created_at: offer.created_at.toISOString(),
			accepted_at: offer.accepted_at?.toISOString() ?? null,
			arrives_at: offer.completes_at?.toISOString() ?? null,
			ended_at: offer.ended_at?.toISOString() ?? null,
			wall_name: offer.recipient_id === userId ? (offer.wall_name ?? null) : null,
			labs_greeting: offer.recipient_id === userId ? (offer.labs_greeting ?? null) : null,
			terms_version: offer.terms_version ?? null,
		})),
		operator_pass_visionary: operatorPassVisionaryActivation
			? {
					visionary_since: operatorPassVisionaryActivation.visionary_since?.toISOString() ?? null,
					visionary_sequence: operatorPassVisionaryActivation.visionary_sequence ?? null,
					activated_at: operatorPassVisionaryActivation.activated_at?.toISOString() ?? null,
					terms_version: operatorPassVisionaryActivation.terms_version ?? null,
					terms_box_text: operatorPassVisionaryActivation.terms_box_text ?? null,
					age_confirmed_at: operatorPassVisionaryActivation.age_confirmed_at?.toISOString() ?? null,
					consent_ip: operatorPassVisionaryActivation.consent_ip ?? null,
					consent_user_agent: operatorPassVisionaryActivation.consent_user_agent ?? null,
					pass_id: operatorPassVisionaryActivation.pass_id ?? null,
					certificate_number: operatorPassVisionaryActivation.certificate_number ?? null,
					completed_at: operatorPassVisionaryActivation.completed_at?.toISOString() ?? null,
					ended_at: operatorPassVisionaryActivation.ended_at?.toISOString() ?? null,
					end_reason: operatorPassVisionaryActivation.end_reason ?? null,
					notice_emailed_at: operatorPassVisionaryActivation.notice_emailed_at?.toISOString() ?? null,
					notice_skip_reason: operatorPassVisionaryActivation.notice_skip_reason ?? null,
					notice_dm_sent_at: operatorPassVisionaryActivation.notice_dm_sent_at?.toISOString() ?? null,
				}
			: null,
		operator_pass_labs: operatorPassLabs
			? {
					greeting: operatorPassLabs.greeting ?? null,
					added_at: operatorPassLabs.added_at?.toISOString() ?? null,
					left_at: operatorPassLabs.left_at?.toISOString() ?? null,
					left_reason: operatorPassLabs.left_reason ?? null,
					greeted_at: operatorPassLabs.greeted_at?.toISOString() ?? null,
					greeting_message_id: operatorPassLabs.greeting_message_id?.toString() ?? null,
				}
			: null,
		operator_pass_certificates: operatorPassCertificates.map((certificate) => ({
			pass_id: certificate.pass_id,
			purchase_id: certificate.purchase_id ?? null,
			number: certificate.number,
			version: certificate.version,
			holder_name: certificate.holder_name === '' ? null : certificate.holder_name,
			issued_at: certificate.issued_at.toISOString(),
			paid_at: certificate.paid_at.toISOString(),
			phase: certificate.phase,
			terms_version: certificate.terms_version,
			sha256: certificate.sha256,
			source: certificate.source,
			cancelled_at: certificate.cancelled_at?.toISOString() ?? null,
			reissue_reason: certificate.reissue_reason ?? null,
			pdf_path: certificate.pdf.length > 0 ? getOperatorPassCertificateArchivePath(certificate) : null,
		})),
		operator_pass_waitlist: operatorPassWaitlistEntry
			? {
					status: operatorPassWaitlistEntry.status,
					locale: operatorPassWaitlistEntry.locale ?? null,
					country_code: operatorPassWaitlistEntry.country_code ?? null,
					consent_ip: operatorPassWaitlistEntry.consent_ip ?? null,
					price_feedback: operatorPassWaitlistEntry.price_feedback ?? null,
					currency: operatorPassWaitlistEntry.currency ?? null,
					followup_picks: [...(operatorPassWaitlistEntry.followup_picks ?? [])].sort(),
					followup_about: [...(operatorPassWaitlistEntry.followup_about ?? [])].sort(),
					followup_other_text: operatorPassWaitlistEntry.followup_other_text ?? null,
					followup_answered_at: operatorPassWaitlistEntry.followup_answered_at?.toISOString() ?? null,
					created_at: operatorPassWaitlistEntry.created_at.toISOString(),
					updated_at: operatorPassWaitlistEntry.updated_at.toISOString(),
					confirmed_at: operatorPassWaitlistEntry.confirmed_at?.toISOString() ?? null,
					unsubscribed_at: operatorPassWaitlistEntry.unsubscribed_at?.toISOString() ?? null,
					sale_email_sent_at: operatorPassWaitlistEntry.sale_email_sent_at?.toISOString() ?? null,
				}
			: null,
		oauth_applications: oauthClients.map(mapOAuthApplication),
		connections: connections.map((connection) => ({
			id: connection.connection_id,
			type: connection.connection_type,
			identifier: connection.identifier,
			name: connection.name,
			verified: connection.verified,
			visibility_flags: connection.visibility_flags,
			sort_order: connection.sort_order,
			created_at: connection.created_at.toISOString(),
			verified_at: connection.verified_at?.toISOString() ?? null,
			last_verified_at: connection.last_verified_at?.toISOString() ?? null,
		})),
		pinned_dms: pinnedDms.map((pin) => ({
			channel_id: pin.channel_id.toString(),
			sort_order: pin.sort_order,
		})),
		...mapSecurityData({authorizedIps, activityData}),
	};
}