import { NextResponse } from 'next/server';
import { prisma } from '@/lib/prisma';

export async function GET() {
  try {
    const items = await prisma.cityFilter.findMany({ orderBy: [{ country: 'asc' }, { state: 'asc' }, { city: 'asc' }] });
    return NextResponse.json(items);
  } catch {
    return NextResponse.json({ error: 'Error fetching cities' }, { status: 500 });
  }
}

export async function POST(request: Request) {
  try {
    const body = await request.json();
    const { city, state, country, isActive } = body;
    if (!city || !country) return NextResponse.json({ error: 'Ciudad y País son requeridos' }, { status: 400 });
    const item = await prisma.cityFilter.create({
      data: {
        city: city.trim(),
        state: state?.trim() || null,
        country: country.toUpperCase().trim(),
        isActive: isActive !== false,
      }
    });
    return NextResponse.json(item);
  } catch (error: unknown) {
    const prismaError = error as { code?: string };
    if (prismaError.code === 'P2002') return NextResponse.json({ error: 'Ya existe esa combinación ciudad/estado/país' }, { status: 409 });
    return NextResponse.json({ error: 'Error creating city' }, { status: 500 });
  }
}