import { auth } from "@/lib/auth";
import { redirect } from "next/navigation";
import { db } from "@/lib/db";
import { payments, tips } from "@/lib/db/schema";
import { eq, desc } from "drizzle-orm";
import Link from "next/link";

export const dynamic = "force-dynamic";

const TYPE_LABEL: Record<string, string> = {
  subscription: "Membership Subscription",
  purchase: "Purchase (Shop / PPV Video)",
  tip: "Support / Tip",
};

const STATUS_STYLE: Record<string, string> = {
  paid: "bg-green-900/50 text-green-400",
  active: "bg-green-900/50 text-green-400",
  pending: "bg-neutral-800 text-neutral-400",
  refunded: "bg-amber-900/50 text-amber-400",
  canceled: "bg-neutral-800 text-neutral-500",
  failed: "bg-red-900/50 text-red-400",
};

export default async function PaymentHistoryPage() {
  const session = await auth();
  if (!session?.user) redirect("/login");

  const userId = (session.user as any).id;

  const paymentRows = await db.select().from(payments).where(eq(payments.userId, userId));
  const tipRows = await db.select().from(tips).where(eq(tips.userId, userId));

  // Unify both tables into one combined, sorted list.
  const combined = [
    ...paymentRows.map((p) => ({
      id: p.id,
      date: p.createdAt,
      description: p.description,
      typeLabel: TYPE_LABEL[p.type] || p.type,
      isRecurring: p.type === "subscription",
      amount: p.amount,
      status: p.status,
      stripeAccount: p.stripeAccount,
    })),
    ...tipRows.map((t) => ({
      id: t.id,
      date: t.createdAt,
      description: "Support the Creators" + (t.message ? ` — "${t.message}"` : ""),
      typeLabel: t.isRecurring ? "Recurring Support" : "One-Time Tip",
      isRecurring: t.isRecurring,
      amount: t.amount,
      status: t.status,
      stripeAccount: t.stripeAccount,
    })),
  ].sort((a, b) => new Date(b.date || 0).getTime() - new Date(a.date || 0).getTime());

  const totalSpent = combined.filter((r) => r.status === "paid" || r.status === "active").reduce((s, r) => s + r.amount, 0);

  return (
    <div className="max-w-5xl mx-auto">
      <div className="flex justify-between items-center mb-4">
        <h1 className="text-2xl font-bold">Payment History</h1>
        <Link href="/my-library" className="text-red-500 text-sm">← Back to My Library</Link>
      </div>

      <div className="card p-4 mb-4">
        <p className="text-neutral-500 text-xs mb-1">Total confirmed spending</p>
        <p className="text-2xl font-bold">${totalSpent.toFixed(2)}</p>
      </div>

      <div className="card p-5">
        {combined.length === 0 ? (
          <p className="text-neutral-500 text-center py-8">No payments yet.</p>
        ) : (
          <table className="w-full text-sm">
            <thead>
              <tr className="text-left text-neutral-500 border-b border-neutral-800">
                <th className="pb-2">Date</th>
                <th className="pb-2">Type</th>
                <th className="pb-2">Description</th>
                <th className="pb-2">Amount</th>
                <th className="pb-2">Status</th>
                <th className="pb-2"></th>
              </tr>
            </thead>
            <tbody>
              {combined.map((r) => (
                <tr key={r.id} className="border-b border-neutral-900">
                  <td className="py-3">{r.date ? new Date(r.date).toLocaleDateString() : "—"}</td>
                  <td className="py-3">
                    {r.typeLabel}
                    {r.isRecurring && <span className="ml-1 text-xs text-amber-400">(recurring)</span>}
                  </td>
                  <td className="py-3 max-w-xs truncate">{r.description}</td>
                  <td className="py-3 font-semibold">${r.amount.toFixed(2)}</td>
                  <td className="py-3">
                    <span className={`text-xs px-2 py-0.5 rounded-full capitalize ${STATUS_STYLE[r.status] || "bg-neutral-800 text-neutral-400"}`}>
                      {r.status}
                    </span>
                  </td>
                  <td className="py-3 text-right">
                    {(r.status === "paid" || r.status === "active" || r.status === "failed") && (
                      <a
                        href={`/api/invoice/${r.id}/pdf`}
                        className="text-red-500 text-xs font-semibold hover:text-red-400 whitespace-nowrap"
                      >
                        Download PDF
                      </a>
                    )}
                  </td>
                </tr>
              ))}
            </tbody>
          </table>
        )}
      </div>
    </div>
  );
}
