import { NextResponse } from "next/server";
import { prisma } from "@/lib/prisma";
import { requireRole } from "@/lib/auth";

type Params = { params: Promise<{ id: string }> };

/** Rename one of this institution's own academic items. */
export async function PUT(req: Request, { params }: Params) {
  const session = await requireRole("INSTITUTION_ADMIN");
  if (!session || !session.institutionId) {
    return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
  }
  const { id } = await params;
  try {
    const body = await req.json();
    const name = String(body.name ?? "").trim();
    const nameBn = String(body.nameBn ?? "").trim() || name;
    if (!name) return NextResponse.json({ error: "Name required" }, { status: 400 });

    const item = await prisma.academicItem.findUnique({ where: { id: Number(id) } });
    if (!item || item.institutionId !== session.institutionId) {
      return NextResponse.json({ error: "Not found" }, { status: 404 });
    }

    const clash = await prisma.academicItem.findFirst({
      where: {
        id: { not: item.id },
        category: item.category,
        name,
        OR: [{ institutionId: null }, { institutionId: session.institutionId }],
      },
    });
    if (clash) return NextResponse.json({ error: "Item exists" }, { status: 409 });

    await prisma.academicItem.update({
      where: { id: item.id },
      data: { name, nameBn },
    });
    return NextResponse.json({ success: true });
  } catch {
    return NextResponse.json({ error: "Could not update" }, { status: 500 });
  }
}

/** Delete one of this institution's own academic items (guarded by usage). */
export async function DELETE(_req: Request, { params }: Params) {
  const session = await requireRole("INSTITUTION_ADMIN");
  if (!session || !session.institutionId) {
    return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
  }
  const { id } = await params;

  const item = await prisma.academicItem.findUnique({ where: { id: Number(id) } });
  if (!item || item.institutionId !== session.institutionId) {
    return NextResponse.json({ error: "Not found" }, { status: 404 });
  }

  const [studentCount, admissionCount, feeCount, scheduleCount, broadcastCount] = await Promise.all([
    prisma.student.count({ where: { OR: [{ classItemId: item.id }, { sectionItemId: item.id }] } }),
    prisma.admission.count({ where: { classItemId: item.id } }),
    prisma.feeSchedule.count({ where: { classItemId: item.id } }),
    prisma.classSchedule.count({
      where: {
        OR: [
          { sessionItemId: item.id },
          { departmentItemId: item.id },
          { classItemId: item.id },
          { sectionItemId: item.id },
          { groupItemId: item.id },
          { subjectItemId: item.id },
          { roomItemId: item.id },
        ],
      },
    }),
    prisma.broadcast.count({ where: { classItemId: item.id } }),
  ]);
  if (studentCount + admissionCount + feeCount + scheduleCount + broadcastCount > 0) {
    return NextResponse.json({ error: "IN_USE" }, { status: 409 });
  }

  await prisma.$transaction([
    prisma.academicSelection.deleteMany({ where: { academicItemId: item.id } }),
    prisma.academicItem.delete({ where: { id: item.id } }),
  ]);
  return NextResponse.json({ success: true });
}