import Link from "next/link";
import { sql, eq } from "drizzle-orm";
import { db } from "@/db/client";
import { listings, reports, users, emailDeliveries, auditEvents } from "@/db/schema";
import { Stat } from "@/components/ui";
import { fmtInt } from "@/lib/format";
import { meta } from "@/lib/db";
export const dynamic = "force-dynamic";
export default async function AdminHome() {
  const d = db();
  const [[l], [r], [u], [m], [a]] = await Promise.all([
    d.select({ pending: sql<number>`sum(case when status='PENDING_REVIEW' then 1 else 0 end)::int`, published: sql<number>`sum(case when status='PUBLISHED' then 1 else 0 end)::int`, total: sql<number>`count(*)::int` }).from(listings),
    d.select({ open: sql<number>`count(*)::int` }).from(reports).where(eq(reports.status, "OPEN")),
    d.select({ n: sql<number>`count(*)::int`, d7: sql<number>`sum(case when created_at > now() - interval '7 days' then 1 else 0 end)::int` }).from(users),
    d.select({ n: sql<number>`count(*)::int`, failed: sql<number>`sum(case when status='FAILED' then 1 else 0 end)::int`, mocked: sql<number>`sum(case when status='MOCKED' then 1 else 0 end)::int` }).from(emailDeliveries).where(sql`created_at > now() - interval '7 days'`),
    d.select({ n: sql<number>`count(*)::int` }).from(auditEvents).where(sql`created_at > now() - interval '24 hours'`),
  ]);
  return (
    <div className="space-y-5">
      <h1 className="text-2xl font-extrabold tracking-tight">Tableau de bord</h1>
      <div className="grid grid-cols-2 md:grid-cols-5 gap-3">
        <Link href="/admin/annonces"><Stat label="Annonces à vérifier" value={fmtInt(l.pending)} tone={l.pending ? "warn" : undefined} sub={`${l.published} publiées · ${l.total} au total`} /></Link>
        <Link href="/admin/signalements"><Stat label="Signalements ouverts" value={fmtInt(r.open)} tone={r.open ? "warn" : undefined} /></Link>
        <Stat label="Comptes" value={fmtInt(u.n)} sub={`${u.d7} cette semaine`} />
        <Stat label="Courriels (7 j)" value={fmtInt(m.n)} sub={`${m.failed} échecs · ${m.mocked} simulés${m.mocked ? " (transport mock)" : ""}`} tone={m.failed ? "warn" : undefined} />
        <Stat label="Événements d'audit (24 h)" value={fmtInt(a.n)} />
      </div>
      <div className="tv-card p-4 text-sm"><p className="font-semibold">Sources et synchronisation</p><p className="text-ink-2">Base canonique construite le {meta("built_at") ?? "—"} · {fmtInt(Number(meta("listings_sale")))} à vendre · {fmtInt(Number(meta("listings_rent")))} à louer · {fmtInt(Number(meta("properties")))} propriétés · {fmtInt(Number(meta("valuations")))} valuations. Journal : <code>data/sync.log</code> sur le nœud.</p>{!process.env.RESEND_API_KEY && <p className="text-warn mt-2">RESEND_API_KEY absente : les courriels sont simulés (data/outbox/mails.jsonl). Configurer une clé et vérifier le domaine d'envoi avant l'ouverture publique des comptes.</p>}</div>
    </div>
  );
}