import { NextResponse } from "next/server";
import { db } from "@/lib/db";

export async function GET(req: Request) {
  const { searchParams } = new URL(req.url);
  const cp = searchParams.get("cp");

  try {
    if (cp) {
      // Traemos la colonia y su sección (agrupando para evitar ruido si hay duplicados)
      const [rows]: any = await db.query(
        "SELECT section_number, colonia FROM sections WHERE cp = ? GROUP BY colonia, section_number ORDER BY colonia ASC",
        [cp]
      );
      return NextResponse.json(rows);
    }
    return NextResponse.json([]);
  } catch (error) {
    return NextResponse.json({ error: "Error al cargar datos de zona" }, { status: 500 });
  }
}