// From apps/web/app/(app)/subscriptions/page.tsx
export default function SubscriptionsPage() {
  const { modal_subscription_set_open } = useStore();
  const { isEnabled } = useFeatureFlag("useSubscriptions");

  if (!isEnabled) {
    return (
      <div className="flex h-full flex-col items-center justify-center">
        <h1>Feature Not Available</h1>
        <p>Subscriptions tracking feature is currently disabled.</p>
      </div>
    )
  }

  return (
    <div className="mx-auto flex max-w-7xl flex-col gap-6 p-4">
      <div className="flex justify-between items-center">
        <div>
          <h1>Subscriptions</h1>
          <p>Manage your recurring payments and track upcoming bills.</p>
        </div>
        <Button onClick={() => modal_subscription_set_open(true)}>
          <Plus className="mr-2 h-4 w-4" />
          Create Subscription
        </Button>
      </div>
      <SubscriptionCalendar />
    </div>
  );
}

// Example: Bi-weekly subscription (every 14 days)
{
  title: "Meal Delivery Service",
  amount: 89.99,
  interval_in_days: 14,
  category_id: "uuid-here"
}

// Subscription status types
type SubscriptionStatus = 'active' | 'paused' | 'canceled';

create type subscription_status as enum('active', 'paused', 'canceled');

create type subscription_period as enum(
  'monthly',
  'yearly',
  'quarterly',
  'semi-annually',
  'weekly',
  'daily'
);

create table subscriptions (
  id uuid primary key default gen_random_uuid(),
  amount numeric(10, 2),
  title varchar(255) not null,
  description varchar(1000),
  logo_url varchar(255),
  period subscription_period,
  interval_in_days integer,
  category_id uuid references categories (id) on delete set null,
  user_id text references users (id) on delete cascade,
  organization_id text references organizations (id) on delete cascade
);

// Create transaction from subscription
const createTransactionFromSubscription = async (subscription) => {
  await db.from('transactions').insert({
    name: subscription.title,
    amount: -subscription.amount, // Negative for expense
    category_id: subscription.category_id,
    status: 'paid',
    source: 'subscription',
    metadata: {
      subscription_id: subscription.id
    },
    transaction_date: new Date()
  });
};

const { isEnabled } = useFeatureFlag("useSubscriptions");