Function updateOrganizationUsageLimit

apps/sim/lib/billing/core/organization.ts:279–359

(
  organizationId: string,
  newLimit: number
)

 * Update organization usage limit (cap)
 */
export async function updateOrganizationUsageLimit(
  organizationId: string,
  newLimit: number
): Promise<{ success: boolean; error?: string }> {
  try {
    // Validate the organization exists
    const orgRecord = await db
      .select()
      .from(organization)
      .where(eq(organization.id, organizationId))
      .limit(1)

    if (orgRecord.length === 0) {
      return { success: false, error: 'Organization not found' }
    }

    // Get subscription to validate minimum
    const subscription = await getOrganizationSubscription(organizationId)
    if (!subscription) {
      return { success: false, error: 'No active subscription found' }
    }

    if (
      !hasUsableSubscriptionStatus(subscription.status) ||
      (await isOrganizationBillingBlocked(organizationId))
    ) {
      return { success: false, error: 'An active subscription is required to edit usage limits' }
    }

    if (isEnterprise(subscription.plan)) {
      return {
        success: false,
        error: 'Enterprise plans have fixed usage limits that cannot be changed',
      }
    }

    if (!isPaid(subscription.plan)) {
      return {
        success: false,
        error: 'Organization is not on a paid plan',
      }
    }

    const { basePrice } = getPlanPricing(subscription.plan)
    const seatCount = subscription.seats || 1
    const minimumLimit = seatCount * basePrice

    if (newLimit < minimumLimit) {
      return {
        success: false,
        error: `Usage limit cannot be less than minimum billing amount of $${roundCurrency(minimumLimit).toFixed(2)}`,
      }
    }

    await db
      .update(organization)
      .set({
        orgUsageLimit: roundCurrency(newLimit).toFixed(2),