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

export const dynamic = "force-dynamic";

const TIER_STYLE: Record<string, { gradient: string; border: string; badge: string }> = {
  free: { gradient: "from-neutral-800 to-neutral-900", border: "border-neutral-700", badge: "bg-neutral-700" },
  starter: { gradient: "from-blue-900 to-blue-950", border: "border-blue-700", badge: "bg-blue-600" },
  plus: { gradient: "from-purple-900 to-purple-950", border: "border-purple-700", badge: "bg-purple-600" },
  premium: { gradient: "from-amber-700 via-red-800 to-red-950", border: "border-amber-500", badge: "bg-gradient-to-r from-amber-500 to-red-600" },
};

export default async function PlansPage() {
  const plansList = await db.select().from(plans).where(eq(plans.active, true)).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-4">Upgrade anytime — higher tiers include everything below. Secure payments via Stripe. Cancel anytime.</p>
      <div className="inline-flex items-center gap-2 bg-green-950/40 border border-green-800/50 text-green-400 rounded-full px-4 py-1.5 text-xs font-semibold mb-8">
        🛡️ 14-Day Money-Back Guarantee — not satisfied? Full refund, no questions asked.
      </div>
      <div className="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4 text-left">
        {[...plansList].sort((a, b) => a.price - b.price).map((p) => {
          const features = JSON.parse(p.features) as string[];
          const style = TIER_STYLE[p.tier] || TIER_STYLE.free;
          const isPremium = p.tier === "premium";
          return (
            <div
              key={p.id}
              className={`relative rounded-xl p-5 flex flex-col bg-gradient-to-br ${style.gradient} border-2 ${
                isPremium ? "border-amber-400" : style.border
              } ${
                isPremium ? "shadow-lg shadow-red-900/30 scale-[1.02] hover:scale-105 ring-2 ring-amber-400/40 ring-offset-2 ring-offset-black" : "hover:scale-105"
              } cursor-pointer transform transition-transform duration-150 active:scale-95`}
            >
              {isPremium && (
                <span className="absolute -top-3 left-1/2 -translate-x-1/2 bg-gradient-to-r from-amber-400 to-red-500 text-black text-[10px] font-bold px-3 py-1 rounded-full whitespace-nowrap flex items-center gap-1">
                  ✓ RECOMMENDED
                </span>
              )}
              <span className={`inline-block ${style.badge} text-white text-xs font-semibold px-2.5 py-1 rounded-full w-fit mb-2`}>
                {p.name}
              </span>
              <p className="text-3xl font-bold mb-4">
                ${p.price.toFixed(2)}<span className="text-sm text-neutral-400 font-normal">/{p.interval}</span>
              </p>
              <ul className="text-sm text-neutral-300 space-y-2 mb-6 flex-1">
                {features.map((f, i) => <li key={i} className="flex gap-2"><span className="text-green-400 shrink-0">✓</span><span>{f}</span></li>)}
              </ul>
              {p.price === 0 ? (
                <a href="/register" className="bg-white/10 hover:bg-white/20 border border-white/20 rounded-lg text-center py-2.5 text-sm font-semibold whitespace-nowrap">
                  Get Started Free
                </a>
              ) : (
                <a
                  href={`/subscription/checkout?amount=${p.price}&description=${encodeURIComponent(`${p.name} Membership`)}&tier=${p.tier}&interval=${p.interval}`}
                  className={`py-2.5 text-center rounded-lg text-sm font-semibold whitespace-nowrap block ${
                    isPremium ? "bg-gradient-to-r from-amber-500 to-red-600 hover:from-amber-400 hover:to-red-500" : "btn-primary"
                  }`}
                >
                  Subscribe
                </a>
              )}
            </div>
          );
        })}
      </div>
    </div>
  );
}
