import { db } from "@/lib/db";
import { requireConfAccess } from "@/lib/rbac";
import { Card, EmptyState, PageHeader, StatCard, btn } from "@/components/ui";
import { fmtDateTime } from "@/lib/utils";

export const metadata = { title: "Feedback" };

const avg = (xs: number[]) => (xs.length ? xs.reduce((a, b) => a + b, 0) / xs.length : 0);
const starsFor = (n: number) => "★".repeat(Math.round(n)) + "☆".repeat(5 - Math.round(n));

export default async function FeedbackReportPage({ params }: { params: Promise<{ id: string }> }) {
  const { id } = await params;
  await requireConfAccess(id, "content.manage");

  const [all, sessions] = await Promise.all([
    db.feedback.findMany({
      where: { conferenceId: id },
      orderBy: { createdAt: "desc" },
      include: { registration: true, session: true },
    }),
    db.session.findMany({ where: { conferenceId: id }, select: { id: true, title: true } }),
  ]);
  const overall = all.filter((f) => !f.sessionId);
  const overallAvg = avg(overall.map((f) => f.rating));
  const distribution = [5, 4, 3, 2, 1].map((n) => ({ n, count: overall.filter((f) => f.rating === n).length }));
  const maxDist = Math.max(1, ...distribution.map((d) => d.count));
  const sessionRows = sessions
    .map((s) => {
      const ratings = all.filter((f) => f.sessionId === s.id).map((f) => f.rating);
      return { title: s.title, count: ratings.length, avg: avg(ratings) };
    })
    .filter((r) => r.count > 0)
    .sort((a, b) => b.avg - a.avg);
  const comments = overall.filter((f) => f.comments);

  return (
    <main>
      <PageHeader
        title="Feedback"
        sub={`${overall.length} overall responses · ${all.length - overall.length} session ratings`}
        action={<a href={`/api/v1/conferences/${id}/reports/feedback`} className={btn.secondary}>⬇ Export CSV</a>}
      />

      {all.length === 0 ? (
        <EmptyState title="No feedback yet" body="Attendees rate the conference and sessions at /c/<slug>/feedback — the link also appears on their My Conferences card." />
      ) : (
        <>
          <div className="grid gap-3 sm:grid-cols-3">
            <StatCard label="Overall rating" value={<span>{overallAvg.toFixed(1)} <span className="text-base text-amber-500">{starsFor(overallAvg)}</span></span>} sub={`${overall.length} responses`} />
            <StatCard label="Sessions rated" value={sessionRows.length} sub={`best: ${sessionRows[0]?.title.slice(0, 32) ?? "—"}`} />
            <StatCard label="Comments" value={comments.length} />
          </div>

          <div className="mt-4 grid gap-4 lg:grid-cols-2">
            <Card className="p-5">
              <h2 className="text-sm font-semibold text-zinc-300">Rating distribution</h2>
              <div className="mt-4 space-y-2">
                {distribution.map((d) => (
                  <div key={d.n} className="flex items-center gap-3 text-sm">
                    <span className="w-8 text-amber-500">{d.n}★</span>
                    <div className="h-3 flex-1 overflow-hidden rounded-full bg-zinc-800/70">
                      <div className="h-full rounded-full bg-gradient-to-r from-amber-400 to-orange-400" style={{ width: `${(d.count / maxDist) * 100}%` }} />
                    </div>
                    <span className="w-8 text-right tabular-nums text-zinc-500">{d.count}</span>
                  </div>
                ))}
              </div>
              <h3 className="mt-6 text-sm font-semibold text-zinc-300">Session ratings</h3>
              <div className="mt-2 space-y-1.5 text-sm">
                {sessionRows.length === 0 && <p className="text-zinc-500">No session ratings yet.</p>}
                {sessionRows.map((r) => (
                  <div key={r.title} className="flex items-center justify-between gap-3">
                    <span className="min-w-0 truncate text-zinc-300">{r.title}</span>
                    <span className="shrink-0 tabular-nums text-zinc-400">
                      <span className="text-amber-500">{r.avg.toFixed(1)}★</span> <span className="text-xs text-zinc-600">({r.count})</span>
                    </span>
                  </div>
                ))}
              </div>
            </Card>

            <Card className="p-5">
              <h2 className="text-sm font-semibold text-zinc-300">Comments</h2>
              <div className="mt-3 max-h-[28rem] space-y-3 overflow-y-auto">
                {comments.length === 0 && <p className="text-sm text-zinc-500">No written comments yet.</p>}
                {comments.map((f) => (
                  <div key={f.id} className="rounded-xl border border-zinc-800/60 bg-white/40 p-3">
                    <div className="flex items-center justify-between text-xs text-zinc-500">
                      <span className="text-amber-500">{starsFor(f.rating)}</span>
                      <span>{f.registration?.name ?? "Anonymous"} · {fmtDateTime(f.createdAt)}</span>
                    </div>
                    <p className="mt-1.5 text-sm text-zinc-300">{f.comments}</p>
                  </div>
                ))}
              </div>
            </Card>
          </div>
        </>
      )}
    </main>
  );
}
