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

export async function GET() {
  try {
    const items = await prisma.htsProduct.findMany({ orderBy: [{ name: 'asc' }] });
    return NextResponse.json(items);
  } catch {
    return NextResponse.json({ error: 'Error fetching HTS catalog' }, { status: 500 });
  }
}

const parseSafeFloat = (val: unknown) => {
  if (val === null || val === undefined || val === '') return null;
  const parsed = parseFloat(String(val));
  return isNaN(parsed) ? null : parsed;
};

export async function POST(request: Request) {
  try {
    const body = await request.json();
    const { name, htsCode, nandina, dutyRateEC, dutyRateCO, dutyRateUS, declaredValue, description } = body;
    if (!name || !htsCode || !nandina) {
      return NextResponse.json({ error: 'Nombre, HTS Code y Nandina son requeridos.' }, { status: 400 });
    }
    const item = await prisma.htsProduct.create({
      data: {
        name: String(name).toUpperCase().trim(),
        htsCode: String(htsCode).trim(),
        nandina: String(nandina).trim(),
        dutyRateEC: parseSafeFloat(dutyRateEC),
        dutyRateCO: parseSafeFloat(dutyRateCO),
        dutyRateUS: parseSafeFloat(dutyRateUS),
        declaredValue: parseSafeFloat(declaredValue),
        description: description || null,
      }
    });
    return NextResponse.json(item, { status: 201 });
  } catch (e: unknown) {
    const prismaError = e as { code?: string };
    if (prismaError.code === 'P2002') {
      return NextResponse.json({ error: 'Ya existe este producto.' }, { status: 409 });
    }
    console.error(e);
    return NextResponse.json({ error: 'Error creating HTS entry' }, { status: 500 });
  }
}