handleInvoicePaid.tsx

const handleInvoicePaid = async (data: Stripe.Event.Data.Object) => {
  const invoice = data as Stripe.Invoice;

  const stripeSubId = invoice.subscription?.toString();
  if (
    invoice.billing_reason === 'subscription_create' ||
    invoice.billing_reason === 'subscription_update'
  ) {
    // this should already be handled with 'checkout.session.completed' or with 'customer.subscription.updated'
    return;
  }
  const subscription = await db.subscription.findFirst({
    where: {
      stripe_subscription_id: stripeSubId,
    },
  });

  await db.subscription.update({
    where: { id: subscription!.id },
    data: { ends_at: null, stripe_status: 'active' },
  });

  console.log({ message: 'Invoice paid' });
};