import Link from 'next/link';
import { requireAdmin } from '@/lib/admin/auth';
import { dataQuality, matchCandidatesForRecord } from '@/lib/admin/queries';
import { manualMatchAction, saleStatusAction } from '@/lib/admin/actions';
import { AdminShell, ActionButton, Kpi, StatusPill, fmtTs, n } from '@/components/admin/shell';
import { Table, th, td, tdNum } from '@/components/ui/primitives';

export default async function DataQualityPage({ searchParams }: { searchParams: Promise<{ match?: string }> }) {
  await requireAdmin();
  const sp = await searchParams;
  const dq = await dataQuality();
  const q = (dq.quality ?? {}) as Record<string, unknown>;
  const matching = sp.match ? await matchCandidatesForRecord(sp.match) : null;
  return (
    <AdminShell current="/admin/data-quality" title="Data quality" subtitle="Flagged/excluded sales with audit reasons, unmatched records with manual matching, cross-listing duplicates. Nothing is deleted; every change is written to the audit log.">
      <div className="grid grid-cols-2 gap-3 md:grid-cols-4">
        <Kpi label="Sales data quality (avg)" value={n(q.sales_avg, 1)} sub={`p10 ${n(q.sales_p10, 1)}`} />
        <Kpi label="Assets data quality (avg)" value={n(q.assets_avg, 1)} />
        <Kpi label="Low-confidence sales" value={n(q.low_confidence_sales)} sub="confidence < 0.6" />
        <Kpi label="Flagged / excluded" value={dq.flagged.length} sub="latest 100 shown" />
      </div>

      {matching?.record ? (
        <section className="card mt-6 border-index/40">
          <header className="flex items-center justify-between border-b border-border px-4 py-2.5"><h2 className="text-sm font-semibold">Manual match</h2><Link href="/admin/data-quality" className="text-xs text-muted hover:text-fg">close</Link></header>
          <div className="p-4 text-sm">
            <p className="font-medium">{String((matching.record.payload as { rawTitle?: string }).rawTitle ?? matching.record.id)}</p>
            <ul className="mt-3 divide-y divide-border text-xs">
              {matching.candidates.length === 0 ? <li className="py-2 text-subtle">No similar asset titles. Reject or leave for the resolver.</li> : null}
              {matching.candidates.map((c) => (
                <li key={String(c.id)} className="flex items-center justify-between gap-3 py-1.5">
                  <span className="truncate"><Link href={`/asset/${String(c.slug)}`} className="hover:underline">{String(c.title)}</Link> <span className="text-subtle">{String(c.category_slug)} · {Math.round(Number(c.score) * 100)}%</span></span>
                  <form action={manualMatchAction}><input type="hidden" name="recordId" value={String(matching.record!.id)} /><input type="hidden" name="assetId" value={String(c.id)} /><ActionButton label="match" tone="primary" /></form>
                </li>
              ))}
            </ul>
            <form action={manualMatchAction} className="mt-3 flex items-center gap-2 text-xs"><input type="hidden" name="recordId" value={String(matching.record.id)} /><input name="assetId" placeholder="or paste an asset id (rare_…)" className="flex-1 rounded-md border border-border bg-sunken px-2 py-1" /><ActionButton label="match id" /></form>
            <form action={manualMatchAction} className="mt-2"><input type="hidden" name="recordId" value={String(matching.record.id)} /><input type="hidden" name="assetId" value="" /><ActionButton label="reject record" tone="danger" /></form>
          </div>
        </section>
      ) : null}

      <section className="card mt-6">
        <header className="border-b border-border px-4 py-2.5"><h2 className="text-sm font-semibold">Flagged & excluded sales</h2></header>
        <Table>
          <thead><tr><th className={th}>Asset</th><th className={th}>Status</th><th className={th}>Flags</th><th className={`${th} text-right`}>Price</th><th className={th}>Date</th><th className={th}>Source</th><th className={th}>Last reason</th><th className={th}>Actions</th></tr></thead>
          <tbody>
            {dq.flagged.length === 0 ? <tr><td className={td} colSpan={8}><span className="text-subtle">No flagged or excluded sales.</span></td></tr> : null}
            {dq.flagged.map((s) => (
              <tr key={String(s.id)}>
                <td className={`${td} max-w-[260px] truncate`}><Link href={`/asset/${String(s.asset_slug)}`} className="hover:underline">{String(s.title)}</Link><div className="truncate text-[10px] text-subtle">{String(s.raw_title)}</div></td>
                <td className={td}><StatusPill status={String(s.status)} /></td>
                <td className={`${td} font-mono text-[10px]`}>{(s.flags as string[]).join(', ')}</td>
                <td className={tdNum}>{n(s.price, 2)} {String(s.currency)}<div className="text-[10px] text-subtle">${n(s.price_usd)}</div></td>
                <td className={td}>{fmtTs(s.sale_date).slice(0, 10)}</td>
                <td className={td}><a href={String(s.source_url)} target="_blank" rel="noreferrer noopener" className="hover:underline">{String(s.source_id)}</a></td>
                <td className={`${td} max-w-[220px] truncate`} title={String(s.last_reason ?? '')}>{String(s.last_reason ?? '')}</td>
                <td className={td}>
                  <div className="flex gap-1">
                    {(['valid', 'flagged', 'excluded'] as const).filter((x) => x !== s.status).map((x) => (
                      <form key={x} action={saleStatusAction} className="flex items-center gap-1"><input type="hidden" name="id" value={String(s.id)} /><input type="hidden" name="status" value={x} /><input type="hidden" name="reason" value={`admin review → ${x}`} /><ActionButton label={x === 'valid' ? 'restore' : x} tone={x === 'excluded' ? 'danger' : 'neutral'} /></form>
                    ))}
                  </div>
                </td>
              </tr>
            ))}
          </tbody>
        </Table>
      </section>

      <section className="card mt-6">
        <header className="border-b border-border px-4 py-2.5"><h2 className="text-sm font-semibold">Unmatched / rejected normalized records</h2></header>
        <Table>
          <thead><tr><th className={th}>Title</th><th className={th}>Connector</th><th className={th}>Kind</th><th className={th}>Category</th><th className={`${th} text-right`}>Price</th><th className={th}>Reason</th><th className={th}>Created</th><th className={th}></th></tr></thead>
          <tbody>
            {dq.unmatched.length === 0 ? <tr><td className={td} colSpan={8}><span className="text-subtle">Nothing waiting for a manual decision.</span></td></tr> : null}
            {dq.unmatched.map((r) => (
              <tr key={String(r.id)}>
                <td className={`${td} max-w-[300px] truncate`}><a href={String(r.source_url ?? '#')} target="_blank" rel="noreferrer noopener" className="hover:underline">{String(r.raw_title ?? r.id)}</a></td>
                <td className={td}>{String(r.connector_id)}</td>
                <td className={td}>{String(r.kind)}</td>
                <td className={td}>{String(r.category_slug ?? '—')}</td>
                <td className={tdNum}>{r.price ? `${n(r.price, 2)} ${String(r.currency ?? '')}` : '—'}</td>
                <td className={`${td} max-w-[200px] truncate`} title={String(r.reject_reason ?? '')}>{String(r.reject_reason ?? '')}</td>
                <td className={td}>{fmtTs(r.created_at)}</td>
                <td className={td}><Link href={`/admin/data-quality?match=${String(r.id)}`} className="rounded-md border border-border px-2 py-0.5 text-[11px] font-medium hover:bg-inset">match</Link></td>
              </tr>
            ))}
          </tbody>
        </Table>
      </section>

      <section className="card mt-6">
        <header className="border-b border-border px-4 py-2.5"><h2 className="text-sm font-semibold">Cross-listing groups</h2></header>
        <Table>
          <thead><tr><th className={th}>Group</th><th className={`${th} text-right`}>Listings</th><th className={th}>Sources</th><th className={th}>Sample</th></tr></thead>
          <tbody>
            {dq.duplicates.length === 0 ? <tr><td className={td} colSpan={4}><span className="text-subtle">No cross-listing groups detected yet.</span></td></tr> : null}
            {dq.duplicates.map((d) => <tr key={String(d.cross_listing_group_id)}><td className={`${td} font-mono text-[11px]`}>{String(d.cross_listing_group_id)}</td><td className={tdNum}>{n(d.n)}</td><td className={td}>{(d.sources as string[]).join(', ')}</td><td className={`${td} max-w-[320px] truncate`}>{String(d.sample_title)}</td></tr>)}
          </tbody>
        </Table>
      </section>
    </AdminShell>
  );
}