import { auth } from "@/lib/auth";
import { redirect } from "next/navigation";
import Link from "next/link";
import { confirmCheckoutSession } from "@/lib/confirmPayment";
import { db } from "@/lib/db";
import { payments, products, ebookClaims } from "@/lib/db/schema";
import { eq, and } from "drizzle-orm";
import { getSetting } from "@/lib/settings";
import UpgradeSuccessCelebration from "@/components/UpgradeSuccessCelebration";

export const dynamic = "force-dynamic";

export default async function MyLibraryPage({
  searchParams,
}: {
  searchParams: Promise<{ session_id?: string; acct?: string }>;
}) {
  const session = await auth();
  if (!session?.user) redirect("/login");

  const { session_id, acct } = await searchParams;
  let justConfirmed = false;
  if (session_id) {
    const result = await confirmCheckoutSession(session_id, acct);
    justConfirmed = !!result;
  }

  const upgradeSuccessGif = await getSetting("upgradeSuccessGif", "");
  const upgradeSuccessGifLength = await getSetting("upgradeSuccessGifLength", "");
  const upgradeSuccessSound = await getSetting("upgradeSuccessSound", "");
  const upgradeSuccessDurationSeconds = parseFloat(await getSetting("upgradeSuccessDurationSeconds", "3")) || 3;

  const userId = (session.user as any).id;
  const tier = (session.user as any).tier || "free";

  // Real purchased products (paid shop purchases with a linked product).
  const purchasedRows = await db
    .select({ payment: payments, product: products })
    .from(payments)
    .innerJoin(products, eq(payments.productId, products.id))
    .where(and(eq(payments.userId, userId), eq(payments.status, "paid")));

  // Real claimed free ebooks (from the membership welcome gift).
  const claimedRows = await db
    .select({ claim: ebookClaims, product: products })
    .from(ebookClaims)
    .innerJoin(products, eq(ebookClaims.productId, products.id))
    .where(and(eq(ebookClaims.userId, userId), eq(ebookClaims.claimed, true)));

  // Merge, avoiding duplicate entries for the same product.
  const seenProductIds = new Set<string>();
  const libraryItems: { slug: string; title: string; imageUrl: string | null; fileUrl: string | null; source: "purchased" | "free gift"; date: Date | null }[] = [];

  for (const r of purchasedRows) {
    if (seenProductIds.has(r.product.id)) continue;
    seenProductIds.add(r.product.id);
    libraryItems.push({ slug: r.product.slug, title: r.product.title, imageUrl: r.product.imageUrl, fileUrl: r.product.fileUrl, source: "purchased", date: r.payment.createdAt });
  }
  for (const r of claimedRows) {
    if (seenProductIds.has(r.product.id)) continue;
    seenProductIds.add(r.product.id);
    libraryItems.push({ slug: r.product.slug, title: r.product.title, imageUrl: r.product.imageUrl, fileUrl: r.product.fileUrl, source: "free gift", date: r.claim.claimedAt });
  }

  return (
    <div className="max-w-4xl mx-auto">
      {justConfirmed && (
        <>
          <UpgradeSuccessCelebration
            gif={upgradeSuccessGif}
            gifLength={upgradeSuccessGifLength}
            sound={upgradeSuccessSound}
            durationSeconds={upgradeSuccessDurationSeconds}
          />
          <div className="card p-4 mb-6 border-green-800 bg-green-950/30">
            <p className="text-green-400 font-semibold">✓ Payment confirmed! A receipt has been sent to your email.</p>
          </div>
        </>
      )}

      <div className="flex justify-between items-center mb-4">
        <h1 className="text-2xl font-bold">My Library</h1>
        <Link href="/my-library/payment-history" className="text-red-500 text-sm">Payment History →</Link>
      </div>

      {libraryItems.length === 0 ? (
        <div className="card p-10 text-center mb-6">
          <p className="font-semibold text-lg mb-1">No purchases yet</p>
          <p className="text-neutral-500 text-sm mb-4">Start building your library by purchasing premium content</p>
          <Link href="/shop" className="btn-primary inline-block px-5 py-2.5">Browse Shop</Link>
        </div>
      ) : (
        <div className="grid sm:grid-cols-2 gap-4 mb-6">
          {libraryItems.map((item, i) => {
            const colors = [
              "from-red-950/50 to-transparent border-red-900/40",
              "from-amber-950/50 to-transparent border-amber-900/40",
              "from-purple-950/50 to-transparent border-purple-900/40",
              "from-blue-950/50 to-transparent border-blue-900/40",
            ];
            const color = colors[i % colors.length];
            return (
              <div key={i} className={`card overflow-hidden bg-gradient-to-br ${color}`}>
                <Link href={`/shop/${item.slug}`} className="block hover:opacity-90 transition-opacity">
                  {item.imageUrl && (
                    <img src={item.imageUrl} className="w-full h-36 object-cover" />
                  )}
                </Link>
                <div className="p-4">
                  <div className="flex items-center gap-2 mb-2">
                    <span className={`text-[10px] font-bold px-2 py-0.5 rounded-full ${item.source === "free gift" ? "bg-amber-500 text-black" : "bg-red-600 text-white"}`}>
                      {item.source === "free gift" ? "🎁 FREE GIFT" : "PURCHASED"}
                    </span>
                  </div>
                  <Link href={`/shop/${item.slug}`} className="hover:text-red-400 transition-colors">
                    <h3 className="font-bold mb-1">{item.title}</h3>
                  </Link>
                  <p className="text-xs text-neutral-500 mb-3">
                    {item.date ? new Date(item.date).toLocaleDateString() : ""}
                  </p>
                  <div className="flex items-center gap-3">
                    <Link href={`/shop/${item.slug}`} className="btn-secondary inline-block px-4 py-2 text-sm">
                      View
                    </Link>
                    {item.fileUrl && (
                      <a href={item.fileUrl} target="_blank" rel="noopener noreferrer" className="btn-primary inline-block px-4 py-2 text-sm">
                        ⬇ Download
                      </a>
                    )}
                  </div>
                </div>
              </div>
            );
          })}
        </div>
      )}

      <div className="card p-5 flex items-center justify-between">
        <div>
          <h3 className="font-semibold capitalize">{tier} Membership</h3>
          <p className="text-neutral-500 text-sm">Your current access tier</p>
        </div>
        <span className="text-green-500 text-sm border border-green-700 rounded-full px-3 py-1">✓ Active</span>
      </div>
    </div>
  );
}
