Function resolveMembershipTier

server/src/db/organization-db.ts:259–265

(org: MembershipTierRow | null | undefined)

 * Only falls back for tier-preserving statuses (active, past_due, trialing).
 */
export function resolveMembershipTier(org: MembershipTierRow | null | undefined): MembershipTier | null {
  if (!org) return null;
  if (org.membership_tier) return org.membership_tier as MembershipTier;
  if (!(TIER_PRESERVING_STATUSES as readonly string[]).includes(org.subscription_status ?? '')) return null;
  return tierFromLookupKey(org.subscription_price_lookup_key)
    ?? inferMembershipTier(org.subscription_amount, org.subscription_interval, org.is_personal);
}

/**
 * Read + resolve the current membership tier for `orgId` using a