import { db, schema } from "@/lib/db";
import { desc, eq } from "drizzle-orm";
import DossierTable from "@/components/dashboard/DossierTable";

export const metadata = { title: "Dossiers terminés" };

export default async function TerminesPage() {
  const rows = await db
    .select({
      id: schema.dossier.id,
      reference: schema.dossier.reference,
      title: schema.dossier.title,
      serviceSlug: schema.dossier.serviceSlug,
      status: schema.dossier.status,
      createdAt: schema.dossier.createdAt,
      updatedAt: schema.dossier.updatedAt,
      clientName: schema.user.name,
      clientEmail: schema.user.email,
    })
    .from(schema.dossier)
    .leftJoin(schema.user, eq(schema.dossier.clientId, schema.user.id))
    .where(eq(schema.dossier.status, "termine"))
    .orderBy(desc(schema.dossier.completedAt));

  return (
    <div className="space-y-10 max-w-7xl">
      <header>
        <span className="eyebrow">Dossiers</span>
        <h1 className="display-lg !text-4xl text-primary mt-2">Terminés</h1>
        <p className="body-md text-on-surface-variant mt-2">
          Dossiers finalisés. Archivage et consultation.
        </p>
      </header>

      <DossierTable
        rows={rows}
        emptyLabel="Aucun dossier terminé."
        hrefPrefix="/socialexadmin/dossiers"
      />
    </div>
  );
}