import { db } from "@/lib/db";
import { plans } from "@/lib/db/schema";
import { asc } from "drizzle-orm";
import CheckoutButton from "@/components/CheckoutButton";

export default async function PlansPage() {
  const plansList = await db.select().from(plans).orderBy(asc(plans.sortOrder));

  return (
    <div className="max-w-6xl mx-auto text-center">
      <h1 className="text-3xl font-bold mb-2">Membership Plans</h1>
      <p className="text-neutral-400 mb-1">Unlock exclusive devotional content with our tiered membership plans.</p>
      <p className="text-neutral-500 text-sm mb-8">Upgrade anytime — higher tiers include everything below. Secure payments via Stripe. Cancel anytime.</p>
      <div className="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4 text-left">
        {plansList.map((p) => {
          const features = JSON.parse(p.features) as string[];
          return (
            <div key={p.id} className="card p-5 flex flex-col">
              <h3 className="font-semibold mb-1">{p.name}</h3>
              <p className="text-3xl font-bold mb-4">${p.price.toFixed(2)}<span className="text-sm text-neutral-500 font-normal">/{p.interval}</span></p>
              <ul className="text-sm text-neutral-400 space-y-2 mb-6 flex-1">
                {features.map((f, i) => <li key={i}>✓ {f}</li>)}
              </ul>
              {p.price === 0 ? (
                <a href="/register" className="btn-secondary text-center py-2.5">Get Started Free</a>
              ) : (
                <CheckoutButton
                  type="subscription"
                  label="Login to Subscribe"
                  amount={p.price}
                  description={`${p.name} Membership`}
                  metadata={{ tier: p.tier }}
                  className="btn-primary py-2.5 text-center"
                />
              )}
            </div>
          );
        })}
      </div>
    </div>
  );
}
