import { artifacts, researchRuns, reviewFindings } from "@autoscholar/db";
import { and, desc, eq, inArray } from "drizzle-orm";
import Link from "next/link";
import { StatusBadge } from "@/components/StatusBadge";
import { fmtDateTime } from "@/lib/format";
import { db } from "@/lib/server/db";

export const dynamic = "force-dynamic";

export default async function ManuscriptsPage({ searchParams }: { searchParams: Promise<{ run?: string }> }) {
  const { run: selected } = await searchParams;
  const d = db();
  const rows = await d
    .selectDistinctOn([researchRuns.id], { run: researchRuns, pdf: artifacts })
    .from(artifacts)
    .innerJoin(researchRuns, eq(artifacts.runId, researchRuns.id))
    .where(eq(artifacts.path, "manuscript/main.pdf"))
    .orderBy(researchRuns.id, desc(artifacts.version));
  rows.sort((a, b) => b.run.updatedAt.getTime() - a.run.updatedAt.getTime());
  const cur = rows.find((r) => r.run.id === selected) ?? rows[0];
  let meta: Record<string, unknown> | null = null;
  let review: Record<string, unknown> | null = null;
  let findings: (typeof reviewFindings.$inferSelect)[] = [];
  let versions: (typeof artifacts.$inferSelect)[] = [];
  if (cur) {
    const { storage } = await import("@/lib/server/db");
    const latest = await d
      .select()
      .from(artifacts)
      .where(
        and(
          eq(artifacts.runId, cur.run.id),
          inArray(artifacts.path, [
            "manuscript/metadata.json",
            "review/review-1.json",
            "manuscript/main.pdf",
          ]),
        ),
      )
      .orderBy(desc(artifacts.version));
    const m = latest.find((a) => a.path === "manuscript/metadata.json");
    const r = latest.find((a) => a.path === "review/review-1.json");
    versions = latest.filter((a) => a.path === "manuscript/main.pdf");
    try {
      if (m) meta = JSON.parse((await storage().get(m.storageKey)).toString("utf8"));
    } catch {
      meta = null;
    }
    try {
      if (r) review = JSON.parse((await storage().get(r.storageKey)).toString("utf8"));
    } catch {
      review = null;
    }
    findings = await d.select().from(reviewFindings).where(eq(reviewFindings.runId, cur.run.id));
  }
  return (
    <div className="space-y-6">
      <header>
        <p className="eyebrow">Output</p>
        <h1 className="title-2 mt-1">Manuscripts</h1>
        <p className="muted mt-1 text-sm">
          Draft and final PDFs with metadata and review findings, from private run artifacts.
        </p>
      </header>
      {rows.length === 0 ? (
        <div className="surface p-8 text-center muted">No run has produced a manuscript yet.</div>
      ) : (
        <div className="grid gap-6 lg:grid-cols-12">
          <ul className="space-y-1 text-sm lg:col-span-3">
            {rows.map((r) => (
              <li key={r.run.id}>
                <Link
                  href={`/admin/manuscripts?run=${r.run.id}`}
                  className={`block rounded-md px-2 py-1.5 no-underline hover:bg-[var(--bg-muted)] ${cur?.run.id === r.run.id ? "bg-[var(--bg-muted)]" : ""}`}
                >
                  {r.run.title}
                  <span className="block text-xs">
                    <StatusBadge status={r.run.status} />{" "}
                    <span className="subtle">{fmtDateTime(r.run.updatedAt)}</span>
                  </span>
                </Link>
              </li>
            ))}
          </ul>
          {cur && (
            <div className="space-y-4 lg:col-span-9">
              <div className="flex flex-wrap items-center justify-between gap-2">
                <h2 className="title-3">{(meta?.title as string) ?? cur.run.title}</h2>
                <div className="flex gap-2">
                  <Link href={`/admin/runs/${cur.run.id}`} className="btn btn-sm">
                    Run
                  </Link>
                  <Link href={`/admin/quality/${cur.run.id}`} className="btn btn-sm">
                    Quality
                  </Link>
                  <a
                    className="btn btn-sm"
                    href={`/api/admin/runs/${cur.run.id}/artifacts/manuscript/main.tex`}
                  >
                    main.tex
                  </a>
                </div>
              </div>
              <object
                data={`/api/admin/runs/${cur.run.id}/artifacts/manuscript/main.pdf`}
                type="application/pdf"
                className="surface h-[60vh] w-full"
                aria-label="Manuscript PDF preview"
              >
                <a href={`/api/admin/runs/${cur.run.id}/artifacts/manuscript/main.pdf?download=1`}>
                  Download PDF
                </a>
              </object>
              {versions.length > 1 && (
                <p className="subtle text-xs">
                  PDF versions:{" "}
                  {versions.map((v) => (
                    <a
                      key={v.id}
                      className="mr-2"
                      href={`/api/admin/runs/${cur.run.id}/artifacts/manuscript/main.pdf?version=${v.version}`}
                    >
                      v{v.version}
                    </a>
                  ))}
                </p>
              )}
              {meta && (
                <section className="surface p-4 text-sm">
                  <h3 className="serif font-semibold">Metadata</h3>
                  <p className="mt-1">
                    <strong>Abstract.</strong> {String(meta.abstract ?? "")}
                  </p>
                  <p className="muted mt-1 text-xs">
                    Keywords: {(meta.keywords as string[] | undefined)?.join(", ")} · synthetic:{" "}
                    {String(meta.synthetic ?? false)}
                  </p>
                </section>
              )}
              {review && (
                <section className="surface p-4 text-sm">
                  <h3 className="serif font-semibold">
                    Independent review — round {String(review.round)} · {String(review.recommendation)}
                  </h3>
                  <p className="muted mt-1">{String(review.summary ?? "")}</p>
                  <ul className="mt-2 grid grid-cols-2 gap-1 text-xs sm:grid-cols-3">
                    {((review.rubric as Array<{ dimension: string; score: number }>) ?? []).map((r) => (
                      <li key={r.dimension}>
                        <span className="font-mono">{r.dimension}</span>: {r.score}/5
                      </li>
                    ))}
                  </ul>
                  <p className="subtle mt-2 text-xs">{String(review.limitationsOfThisReview ?? "")}</p>
                </section>
              )}
              {findings.length > 0 && (
                <section className="surface p-4 text-sm">
                  <h3 className="serif font-semibold">Review findings ({findings.length})</h3>
                  <ul className="mt-2 space-y-2">
                    {findings.map((f) => (
                      <li key={f.id}>
                        <StatusBadge status={f.severity} /> <strong>{f.title}</strong>{" "}
                        <span className="subtle text-xs">
                          ({f.category}, {f.resolution})
                        </span>
                        <p className="muted text-xs">{f.detail}</p>
                        {f.resolutionNote && <p className="text-xs">↳ {f.resolutionNote}</p>}
                      </li>
                    ))}
                  </ul>
                </section>
              )}
            </div>
          )}
        </div>
      )}
    </div>
  );
}