Function isOrganizationBillingBlocked

apps/sim/lib/billing/core/access.ts:90–112

(organizationId: string)

}

export async function isOrganizationBillingBlocked(organizationId: string): Promise<boolean> {
  const [owner] = await db
    .select({ userId: member.userId })
    .from(member)
    .where(and(eq(member.organizationId, organizationId), eq(member.role, 'owner')))
    .limit(1)

  if (!owner) {
    logger.error(
      'Organization has no owner when checking billing-blocked state — data integrity issue',
      { organizationId }
    )
    return false
  }

  const [ownerStats] = await db
    .select({ blocked: userStats.billingBlocked })
    .from(userStats)
    .where(eq(userStats.userId, owner.userId))
    .limit(1)

  return !!ownerStats?.blocked
}