Function getActiveOrder

src/stores/userStore.ts:117–150

(email: string | undefined)

// TODO: Think about how to keep multiple subscriptions mutually exclusive
async function getActiveOrder(email: string | undefined): Promise<{
  order: Order | null;
  error: string | null;
}> {
  if (!email) {
    return { order: null, error: null };
  }

  // API: https://supabase.com/docs/reference/javascript/select
  const { data: items, error } = await supabase
    .from("orders")
    .select()
    .eq("email", email)
    .neq("plan", "free")
    .order("created_at", { ascending: false });
  if (error) {
    return { order: null, error: error.toString() };
  }

  try {
    const orders = items.map((item) => OrderSchema.parse(item));

    for (const order of orders) {
      if (order.status === "active") {
        return { order, error: null };
      }
    }

    const order = last(sortBy(orders, "ends_at")) ?? null;
    return { order, error: null };
  } catch (error) {
    return { order: null, error: (error as Error).toString() };
  }
}