documenso/packages/lib/server-only/subscription/get-active-subscriptions-by-user-id.ts

import { prisma } from '@documenso/prisma';
import { SubscriptionStatus } from '@prisma/client';

export type GetActiveSubscriptionsByUserIdOptions = {
  userId: number;
};

export const getActiveSubscriptionsByUserId = async ({ userId }: GetActiveSubscriptionsByUserIdOptions) => {
  return await prisma.subscription.findMany({
    where: {
      userId,
      status: {
        not: SubscriptionStatus.INACTIVE,
      },
    },
  });
};