import { db } from '@/lib/db';
import { colegio } from '@/db/schema';
import { eq } from 'drizzle-orm';
import { getServerSession } from "next-auth";
import { authOptions } from "@/lib/auth";
import SedesListClient from "./SedesListClient";

export const dynamic = "force-dynamic";

export default async function AdminSedesPage() {
  const session = await getServerSession(authOptions);
  const role = session?.user?.role;
  const colegioId = session?.user?.colegioId;

  // Aislamiento: ADMIN_COLEGIO solo ve su propia sede
  const colegios = role === "ADMIN_COLEGIO" && colegioId
    ? await db.query.colegio.findMany({ where: eq(colegio.id, colegioId) })
    : await db.query.colegio.findMany();

  // Sort by nombre
  const sortedColegios = colegios.sort((a, b) => a.nombre.localeCompare(b.nombre));

  return (
    <SedesListClient colegios={sortedColegios} />
  );
}