import Link from "next/link";
import { prisma } from "@/lib/db";
export const dynamic = "force-dynamic";
export default async function WorkManager() {
  const projects = await prisma.project.findMany({ orderBy: { createdAt: "desc" } });
  return (
    <div>
      <div className="flex justify-between items-end">
        <div>
          <h1 className="text-xl font-bold text-white">Work Manager</h1>
          <p className="text-sm text-white/50">Projects — Published / Draft / Featured / Archived • Real DB</p>
        </div>
        <Link href="/admin/content/work/new" className="px-4 py-2 rounded-full bg-white text-black font-semibold text-sm">+ New Project</Link>
      </div>
      <div className="mt-4 flex gap-2 text-xs">
        {["All","Published","Draft","Featured","Archived"].map(f=> <span key={f} className="px-3 py-1 rounded-full border border-white/10 bg-white/5 text-white/60">{f}</span>)}
      </div>
      {projects.length===0 ? (
        <div className="mt-8 rounded-2xl border border-white/10 bg-white/[0.03] p-12 text-center">
          <h2 className="text-xl font-bold text-white">NO PROJECTS YET</h2>
          <p className="text-sm text-white/50">Create your first project from the Admin Panel.</p>
          <Link href="/admin/content/work/new" className="mt-4 inline-flex px-5 py-2 rounded-full bg-white text-black font-semibold text-sm">+ New Project</Link>
        </div>
      ) : (
        <div className="mt-4 rounded-2xl border border-white/10 overflow-hidden bg-white/[0.03]">
          <div className="grid grid-cols-[1.5fr_0.6fr_0.5fr_0.4fr] gap-2 px-4 py-3 text-[11px] tracking-widest text-white/30 uppercase bg-white/[0.04]"><span>Project</span><span>Status</span><span>Featured</span><span>Action</span></div>
          {projects.map(p=>(
            <div key={p.slug} className="grid grid-cols-[1.5fr_0.6fr_0.5fr_0.4fr] gap-2 px-4 py-3 text-sm border-t border-white/5 items-center">
              <span className="text-white font-medium">{p.title}</span>
              <span className={`text-xs px-2 py-1 rounded-full border w-fit ${p.deletedAt ? "bg-white/5 border-white/10 text-white/40" : p.status==="PUBLISHED" ? "bg-emerald-500/15 border-emerald-500/20 text-emerald-300" : p.status==="DRAFT" ? "bg-amber-500/15 border-amber-500/20 text-amber-300" : "bg-white/5 border-white/10 text-white/40"}`}>{p.deletedAt ? "Archived" : p.status}</span>
              <span className="text-xs text-white/60">{p.featured ? "✓" : "—"}</span>
              <Link href={`/admin/content/work/${p.slug}`} className="text-xs px-3 py-1 rounded-full bg-white text-black font-semibold w-fit">Edit</Link>
            </div>
          ))}
        </div>
      )}
      <p className="text-xs text-white/20 mt-3">Create • Read • Update • Delete • Draft/Publish/Archive • Preview • Soft delete + Restore • Revision history</p>
    </div>
  );
}