import { Head, router } from '@inertiajs/react';
import { BarChart3, Boxes, ChevronDown, DollarSign, Grid3x3, Layers, Package, PieChart as PieIcon, Search, Table2, Users, X } from 'lucide-react';
import { Bar, CartesianGrid, Cell, ComposedChart, LabelList, Pie, PieChart, ReferenceLine, ResponsiveContainer, Tooltip, XAxis, YAxis } from 'recharts';
import { useEffect, useRef, useState } from 'react';
import AppLayout from '@/layouts/AppLayout';
import { DateRange, ErrorBox, FilterSelect, INK, KpiCard, Panel, UpdatedBadge, tooltipStyle } from '@/components/dashboard';
import { fecha, int, mesCorto, money, moneyShort, pct, toNum } from '@/lib/format';

type Filters = { desde: string; hasta: string; zona: string; provincia: string; productos: string };
type Num = number | string;
type Opcion = { label: string; value: string };

type Data = {
    summary?: { totalVenta?: Num; totalUnidades?: Num; promedioMensual?: Num; productosActivos?: Num; mesesRango?: Num; updatedAt?: string };
    filters?: { zones?: Opcion[]; provinces?: Opcion[] };
    familyParticipation?: { name: string; venta: Num; unidades: Num; percentage: Num }[];
    zoneDistribution?: { name: string; venta: Num; unidades: Num; percentage: Num }[];
    topClients?: { name: string; venta: Num; unidades: Num; percentage: Num }[];
    cityMatrix?: { city: string; province: string; zone1Sales: Num; zone2Sales: Num; venta: Num; unidades: Num; percentage: Num }[];
};
type Evolucion = { month: string; venta: Num; unidades: Num; promedio: Num }[];
type Detalle = {
    rows: { productoId: string; producto: string; familia: string; city: string; province: string; zone: string; venta: Num; unidades: Num; percentage: Num }[];
    page: number;
    totalRows: number;
    totalPages: number;
};
type Hallazgo = { producto_id: string; producto: string; familia_producto: string; venta_total: Num; cantidad_total: Num; clientes: Num };

type Props = { filters: Filters; data: Data | null; evolucion: Evolucion; detalle?: Detalle };

const ZONA_COLOR: Record<string, string> = { 'ZONA 1': 'var(--zona-1)', 'ZONA 2': 'var(--zona-2)' };   // colores oficiales


/** Buscador de productos con selección múltiple (los IDs se envían unidos con "|"). */
function BuscadorProductos({ filters, onApply }: { filters: Filters; onApply: (ids: string) => void }) {
    const [open, setOpen] = useState(false);
    const [q, setQ] = useState('');
    const [res, setRes] = useState<Hallazgo[]>([]);
    const [cargando, setCargando] = useState(false);
    const [sel, setSel] = useState<string[]>(filters.productos ? filters.productos.split('|').filter(Boolean) : []);
    const ref = useRef<HTMLDivElement>(null);

    useEffect(() => {
        if (q.trim().length < 3) return setRes([]);
        const ctrl = new AbortController();
        const t = setTimeout(async () => {
            setCargando(true);
            try {
                const params = new URLSearchParams({ q: q.trim(), desde: filters.desde, hasta: filters.hasta, zona: filters.zona, provincia: filters.provincia });
                const r = await fetch(`/productos/buscar?${params}`, { signal: ctrl.signal, headers: { Accept: 'application/json' } });
                if (r.ok) setRes(await r.json());
            } catch {
                /* búsqueda cancelada */
            } finally {
                setCargando(false);
            }
        }, 300);
        return () => {
            clearTimeout(t);
            ctrl.abort();
        };
    }, [q, filters.desde, filters.hasta, filters.zona, filters.provincia]);

    useEffect(() => {
        const cerrar = (e: MouseEvent) => ref.current && !ref.current.contains(e.target as Node) && setOpen(false);
        document.addEventListener('mousedown', cerrar);
        return () => document.removeEventListener('mousedown', cerrar);
    }, []);

    const toggle = (id: string) => setSel((s) => (s.includes(id) ? s.filter((x) => x !== id) : [...s, id]));

    return (
        <div ref={ref} className="relative min-w-72 flex-1">
            <button type="button" onClick={() => setOpen(!open)} className="flex h-full w-full flex-col rounded-xl border border-slate-200 bg-white px-3 py-1.5 text-left">
                <span className="text-[10px] font-semibold tracking-wider text-slate-400 uppercase">Producto o familia</span>
                <span className="flex items-center justify-between text-xs font-semibold text-brand">
                    {sel.length ? `${sel.length} producto(s) seleccionado(s)` : 'Buscar por SKU, producto o familia'}
                    <ChevronDown className="size-3.5" />
                </span>
            </button>
            {open && (
                <div className="absolute top-full right-0 left-0 z-20 mt-1 rounded-xl border border-slate-200 bg-white p-3 shadow-xl">
                    <div className="relative mb-2">
                        <Search className="absolute top-1/2 left-2.5 size-4 -translate-y-1/2 text-slate-400" />
                        <input autoFocus value={q} onChange={(e) => setQ(e.target.value)} placeholder="Escribe al menos 3 letras…" className="w-full rounded-lg border border-slate-200 py-2 pr-2 pl-8 text-sm outline-none focus:border-brand" />
                    </div>
                    <ul className="max-h-64 overflow-y-auto">
                        {cargando && <li className="p-2 text-xs text-slate-400">Buscando…</li>}
                        {!cargando && q.trim().length >= 3 && res.length === 0 && <li className="p-2 text-xs text-slate-400">Sin resultados.</li>}
                        {res.map((r) => (
                            <li key={r.producto_id}>
                                <label className="flex cursor-pointer items-start gap-2 rounded-lg p-2 text-xs hover:bg-slate-50">
                                    <input type="checkbox" checked={sel.includes(r.producto_id)} onChange={() => toggle(r.producto_id)} className="mt-0.5" />
                                    <span className="min-w-0 flex-1">
                                        <span className="block truncate font-semibold">{r.producto}</span>
                                        <span className="text-[10px] text-slate-400">
                                            {r.producto_id} · {r.familia_producto} · {moneyShort(r.venta_total)}
                                        </span>
                                    </span>
                                </label>
                            </li>
                        ))}
                    </ul>
                    <div className="mt-2 flex justify-between border-t border-slate-100 pt-2">
                        <button type="button" onClick={() => setSel([])} className="text-xs text-slate-500 hover:text-red-500">
                            Limpiar ({sel.length})
                        </button>
                        <button
                            type="button"
                            onClick={() => {
                                onApply(sel.join('|'));
                                setOpen(false);
                            }}
                            className="rounded-lg bg-brand px-3 py-1.5 text-xs font-bold text-white"
                        >
                            Aplicar
                        </button>
                    </div>
                </div>
            )}
        </div>
    );
}

export default function Productos({ filters, data, evolucion, detalle }: Props) {
    const s = data?.summary ?? {};
    const apply = (patch: Partial<Filters>) => router.get('/productos', { ...filters, ...patch }, { preserveState: true, preserveScroll: true });

    const meses = evolucion.map((e) => ({ label: `${mesCorto(e.month.slice(0, 7))} ${e.month.slice(2, 4)}`, venta: toNum(e.venta), unidades: toNum(e.unidades) }));
    const promedio = toNum(evolucion[0]?.promedio);
    const familias = data?.familyParticipation ?? [];
    const maxFam = Math.max(...familias.map((f) => toNum(f.venta)), 1);
    const zonas = (data?.zoneDistribution ?? []).map((z) => ({ ...z, venta: toNum(z.venta) }));
    const clientes = data?.topClients ?? [];
    const maxCli = Math.max(...clientes.map((c) => toNum(c.venta)), 1);

    const [detalleAbierto, setDetalleAbierto] = useState(false);
    const [buscarDet, setBuscarDet] = useState('');
    const cargarDetalle = (pagina: number, buscar = buscarDet) =>
        router.reload({ only: ['detalle'], data: { det_pagina: pagina, det_buscar: buscar } });

    return (
        <AppLayout>
            <Head title="Análisis de Productos" />

            <header className="mb-5">
                <h1 className="flex items-center gap-2 text-3xl font-extrabold tracking-tight">
                    Análisis de Productos <span className="rounded-full bg-emerald-50 px-2 py-0.5 text-xs font-bold text-emerald-700">Facturación SAP</span>
                </h1>
                <p className="mt-1 text-sm text-slate-500">
                    Familia, producto, provincia, ciudad y zona ·{' '}
                    <b className="text-brand">
                        {fecha(filters.desde)} a {fecha(filters.hasta)}
                    </b>
                    <UpdatedBadge at={s.updatedAt} />
                </p>
            </header>

            <div className="mb-5 flex flex-wrap items-stretch gap-2">
                <DateRange desde={filters.desde} hasta={filters.hasta} onChange={apply} />
                <FilterSelect multiple label="Zona" value={filters.zona} all="TODAS" options={(data?.filters?.zones ?? []).map((o) => o.value).filter((v) => v !== 'TODAS')} onChange={(v) => apply({ zona: v })} />
                <FilterSelect multiple label="Provincia" value={filters.provincia} all="TODAS" options={(data?.filters?.provinces ?? []).map((o) => o.value).filter((v) => v !== 'TODAS')} onChange={(v) => apply({ provincia: v })} />
                <BuscadorProductos filters={filters} onApply={(ids) => apply({ productos: ids })} />
                {filters.productos && (
                    <button type="button" onClick={() => apply({ productos: '' })} className="flex items-center gap-1 rounded-xl border border-slate-200 bg-white px-3 text-xs font-semibold text-slate-500 hover:text-red-500">
                        <X className="size-3.5" /> Quitar productos
                    </button>
                )}
            </div>

            {!data ? (
                <ErrorBox message="No se pudo cargar el análisis de productos." />
            ) : (
                <>
                    <div className="mb-5 grid grid-cols-1 gap-3 sm:grid-cols-2 xl:grid-cols-4">
                        <KpiCard title="Venta total" icon={<DollarSign className="size-4" />} accent="#5b4ce6">
                            <p className="text-lg font-extrabold">{money(s.totalVenta)}</p>
                            <p className="text-xs text-slate-400">Facturación del rango seleccionado</p>
                        </KpiCard>
                        <KpiCard title="Unidades vendidas" icon={<Package className="size-4" />} accent="#10b981">
                            <p className="text-lg font-extrabold">{int(s.totalUnidades)}</p>
                            <p className="text-xs text-slate-400">Unidades facturadas en el rango</p>
                        </KpiCard>
                        <KpiCard title="Promedio mensual" icon={<BarChart3 className="size-4" />} accent="#f59e0b">
                            <p className="text-lg font-extrabold">{money(s.promedioMensual)}</p>
                            <p className="text-xs text-slate-400">Incluye todos los meses del rango ({int(s.mesesRango)}), también meses en cero</p>
                        </KpiCard>
                        <KpiCard title="SKUs activos" icon={<Boxes className="size-4" />} accent="#8b5cf6">
                            <p className="text-lg font-extrabold">{int(s.productosActivos)}</p>
                            <p className="text-xs text-slate-400">Productos con facturación en el rango</p>
                        </KpiCard>
                    </div>

                    <div className="mb-5 grid grid-cols-1 gap-4 xl:grid-cols-[2fr_1.2fr_1fr]">
                        <Panel title="Evolución mensual" icon={<BarChart3 className="size-4" />} accent="#5b4ce6" right={`Año ${filters.desde.slice(0, 4)} · línea: promedio mensual`}>
                            <div className="h-80">
                                <ResponsiveContainer width="100%" height="100%">
                                    <ComposedChart data={meses} margin={{ top: 24, right: 8, left: 0, bottom: 0 }}>
                                        <CartesianGrid vertical={false} stroke={INK.grid} />
                                        <XAxis dataKey="label" tickLine={false} axisLine={{ stroke: INK.axis }} tick={{ fill: INK.muted, fontSize: 11 }} />
                                        <YAxis tickLine={false} axisLine={false} width={76} tick={{ fill: INK.muted, fontSize: 11 }} tickFormatter={(v) => moneyShort(v)} />
                                        <Tooltip
                                            cursor={{ fill: 'rgba(91,76,230,0.06)' }}
                                            formatter={(v, _n, p) => [`${money(v)} · ${int((p.payload as { unidades: number }).unidades)} unid.`, 'Venta']}
                                            contentStyle={tooltipStyle}
                                        />
                                        {promedio > 0 && <ReferenceLine y={promedio} stroke="#f59e0b" strokeDasharray="6 6" strokeWidth={2} label={{ value: `Prom. ${moneyShort(promedio)}`, fill: '#b45309', fontSize: 11, position: 'insideTopLeft' }} />}
                                        <Bar dataKey="venta" fill="#5b4ce6" radius={[4, 4, 0, 0]} maxBarSize={40}>
                                            <LabelList dataKey="venta" position="top" formatter={(v) => moneyShort(v)} style={{ fill: INK.secondary, fontSize: 10, fontWeight: 700 }} />
                                        </Bar>
                                    </ComposedChart>
                                </ResponsiveContainer>
                            </div>
                        </Panel>

                        <Panel title="Participación por familia" icon={<Layers className="size-4" />} accent="#06b6d4" right={`${familias.length} familias`}>
                            <ul className="max-h-80 space-y-2 overflow-y-auto pr-2">
                                {familias.map((f) => (
                                    <li key={f.name} className="text-xs">
                                        <div className="flex justify-between">
                                            <span className="font-bold">{f.name}</span>
                                            <span className="font-bold text-brand">{pct(f.percentage)}</span>
                                        </div>
                                        <div className="my-1 h-1.5 rounded-full bg-slate-100">
                                            <div className="h-1.5 rounded-full bg-brand" style={{ width: `${(toNum(f.venta) / maxFam) * 100}%` }} />
                                        </div>
                                        <div className="flex justify-between text-[10px] text-slate-400 tabular-nums">
                                            <span>{moneyShort(f.venta)}</span>
                                            <span>{int(f.unidades)} u</span>
                                        </div>
                                    </li>
                                ))}
                            </ul>
                        </Panel>

                        <Panel title="Distribución Zona 1 vs Zona 2" icon={<PieIcon className="size-4" />} accent="#8b5cf6">
                            <div className="h-48">
                                <ResponsiveContainer width="100%" height="100%">
                                    <PieChart>
                                        <Pie data={zonas} dataKey="venta" nameKey="name" innerRadius="55%" outerRadius="85%" stroke="#fff" strokeWidth={2}>
                                            {zonas.map((z) => (
                                                <Cell key={z.name} fill={ZONA_COLOR[z.name] ?? '#94a3b8'} />
                                            ))}
                                        </Pie>
                                        <Tooltip formatter={(v, n) => [money(v), String(n)]} contentStyle={tooltipStyle} />
                                    </PieChart>
                                </ResponsiveContainer>
                            </div>
                            <ul className="space-y-2">
                                {zonas.map((z) => (
                                    <li key={z.name} className="rounded-xl border border-slate-100 p-2.5 text-xs">
                                        <div className="flex justify-between font-bold">
                                            <span className="flex items-center gap-2">
                                                <span className="size-2.5 rounded-full" style={{ background: ZONA_COLOR[z.name] ?? '#94a3b8' }} />
                                                {z.name}
                                            </span>
                                            <span>{pct(z.percentage)}</span>
                                        </div>
                                        <p className="mt-0.5 font-bold">{money(z.venta)}</p>
                                        <p className="text-[10px] text-slate-400">{int(z.unidades)} unidades</p>
                                    </li>
                                ))}
                            </ul>
                        </Panel>
                    </div>

                    <div className="mb-5 grid grid-cols-1 gap-4 xl:grid-cols-[1fr_2fr]">
                        <Panel title="Top 10 clientes" icon={<Users className="size-4" />} accent="#10b981" right="Clientes que más compran lo seleccionado">
                            <ul className="space-y-2.5">
                                {clientes.map((c) => (
                                    <li key={c.name} className="text-xs" title={`${int(c.unidades)} unidades · ${pct(c.percentage)}`}>
                                        <div className="flex justify-between gap-2">
                                            <span className="truncate font-bold">{c.name}</span>
                                            <span className="shrink-0 font-bold tabular-nums">{moneyShort(c.venta)}</span>
                                        </div>
                                        <div className="mt-1 h-1.5 rounded-full bg-slate-100">
                                            <div className="h-1.5 rounded-full bg-emerald-500" style={{ width: `${(toNum(c.venta) / maxCli) * 100}%` }} />
                                        </div>
                                    </li>
                                ))}
                            </ul>
                        </Panel>

                        <Panel title="Matriz de ventas por ciudad" icon={<Grid3x3 className="size-4" />} accent="#f97316" right="Venta, unidades y distribución por ciudad">
                            <div className="max-h-96 overflow-y-auto">
                                <table className="w-full text-[11px]">
                                    <thead className="sticky top-0 bg-white text-[10px] tracking-wider text-slate-400 uppercase">
                                        <tr>
                                            <th className="py-1.5 text-left">Ciudad</th>
                                            <th className="text-left">Provincia</th>
                                            <th className="text-right">Zona 1</th>
                                            <th className="text-right">Zona 2</th>
                                            <th className="text-right">Venta total</th>
                                            <th className="text-right">Unidades</th>
                                            <th className="text-right">Part.</th>
                                        </tr>
                                    </thead>
                                    <tbody className="tabular-nums">
                                        {(data.cityMatrix ?? []).map((c) => (
                                            <tr key={`${c.city}-${c.province}`} className="border-t border-slate-100">
                                                <td className="py-1.5 font-semibold">{c.city}</td>
                                                <td className="text-slate-500">{c.province}</td>
                                                <td className="text-right">{moneyShort(c.zone1Sales)}</td>
                                                <td className="text-right">{moneyShort(c.zone2Sales)}</td>
                                                <td className="text-right font-bold">{money(c.venta)}</td>
                                                <td className="text-right">{int(c.unidades)}</td>
                                                <td className="text-right font-semibold text-brand">{pct(c.percentage)}</td>
                                            </tr>
                                        ))}
                                    </tbody>
                                </table>
                            </div>
                        </Panel>
                    </div>

                    {/* Detalle completo (se carga bajo demanda) */}
                    <div className="rounded-2xl border border-slate-200 bg-white p-4">
                        <div className="flex flex-wrap items-center justify-between gap-2">
                            <h3 className="flex items-center gap-2 text-sm font-extrabold tracking-wide uppercase">
                                <Table2 className="size-4 text-brand" /> Detalle completo por SKU, ciudad y zona
                                {detalle && <span className="font-semibold text-slate-400 normal-case">({int(detalle.totalRows)} registros)</span>}
                            </h3>
                            <div className="flex items-center gap-2">
                                {detalleAbierto && (
                                    <form
                                        onSubmit={(e) => {
                                            e.preventDefault();
                                            cargarDetalle(1);
                                        }}
                                        className="relative"
                                    >
                                        <Search className="absolute top-1/2 left-2.5 size-3.5 -translate-y-1/2 text-slate-400" />
                                        <input value={buscarDet} onChange={(e) => setBuscarDet(e.target.value)} placeholder="Filtrar producto, ciudad…" className="rounded-lg border border-slate-200 py-1.5 pr-2 pl-7 text-xs outline-none focus:border-brand" />
                                    </form>
                                )}
                                <button
                                    type="button"
                                    onClick={() => {
                                        if (!detalleAbierto && !detalle) cargarDetalle(1);
                                        setDetalleAbierto(!detalleAbierto);
                                    }}
                                    className="flex items-center gap-1 rounded-lg border border-slate-200 px-3 py-1.5 text-xs font-semibold text-slate-600 hover:bg-slate-50"
                                >
                                    <ChevronDown className={detalleAbierto ? 'size-3.5 rotate-180' : 'size-3.5'} /> {detalleAbierto ? 'Ocultar tabla' : 'Ver tabla completa'}
                                </button>
                            </div>
                        </div>

                        {detalleAbierto && (
                            <div className="mt-3">
                                {!detalle ? (
                                    <p className="p-4 text-sm text-slate-400">Cargando…</p>
                                ) : (
                                    <>
                                        <div className="overflow-x-auto">
                                            <table className="w-full text-[11px]">
                                                <thead className="text-[10px] tracking-wider text-slate-400 uppercase">
                                                    <tr>
                                                        <th className="py-1.5 text-left">SKU</th>
                                                        <th className="text-left">Producto</th>
                                                        <th className="text-left">Familia</th>
                                                        <th className="text-left">Ciudad</th>
                                                        <th className="text-left">Provincia</th>
                                                        <th className="text-left">Zona</th>
                                                        <th className="text-right">Venta</th>
                                                        <th className="text-right">Unidades</th>
                                                        <th className="text-right">Part.</th>
                                                    </tr>
                                                </thead>
                                                <tbody className="tabular-nums">
                                                    {detalle.rows.map((r, i) => (
                                                        <tr key={`${r.productoId}-${r.city}-${r.zone}-${i}`} className="border-t border-slate-100">
                                                            <td className="py-1.5 text-slate-500">{r.productoId}</td>
                                                            <td className="font-semibold">{r.producto}</td>
                                                            <td>{r.familia}</td>
                                                            <td>{r.city}</td>
                                                            <td className="text-slate-500">{r.province}</td>
                                                            <td>{r.zone}</td>
                                                            <td className="text-right font-bold">{money(r.venta)}</td>
                                                            <td className="text-right">{int(r.unidades)}</td>
                                                            <td className="text-right text-brand">{pct(r.percentage, 2)}</td>
                                                        </tr>
                                                    ))}
                                                    {detalle.rows.length === 0 && (
                                                        <tr>
                                                            <td colSpan={9} className="p-4 text-center text-slate-400">
                                                                Sin registros.
                                                            </td>
                                                        </tr>
                                                    )}
                                                </tbody>
                                            </table>
                                        </div>
                                        <div className="mt-3 flex items-center justify-between text-xs">
                                            <button type="button" disabled={detalle.page <= 1} onClick={() => cargarDetalle(detalle.page - 1)} className="rounded-lg border border-slate-200 px-3 py-1 disabled:opacity-40">
                                                Anterior
                                            </button>
                                            <span className="text-slate-500">
                                                Página {detalle.page} de {int(detalle.totalPages)}
                                            </span>
                                            <button type="button" disabled={detalle.page >= detalle.totalPages} onClick={() => cargarDetalle(detalle.page + 1)} className="rounded-lg border border-slate-200 px-3 py-1 disabled:opacity-40">
                                                Siguiente
                                            </button>
                                        </div>
                                    </>
                                )}
                            </div>
                        )}
                    </div>
                </>
            )}
        </AppLayout>
    );
}
