import { Head, router, usePage } from '@inertiajs/react';
import { useState, type FormEvent } from 'react';
import AdminLayout from '../../Components/AdminLayout';
import { DateTime, EmptyState, StatusBadge } from '../../Components/Display';
import type { SharedProps, SyncStatus } from '../../types';

interface SyncTableRow {
    id: number;
    name: string;
    sourceTable: string;
    targetTable: string;
    syncMode: string;
    isActive: boolean;
    lastRowsCount: number | null;
    lastSuccessAt: string | null;
    latestStatus: SyncStatus | null;
    connection: string;
    syncUrl: string;
}

export default function TablesIndex({ tables, filters }: { tables: SyncTableRow[]; filters: { search: string; status: string } }) {
    const { auth, workerEnabled, navigation } = usePage<SharedProps>().props;
    const [search, setSearch] = useState(filters.search);

    function applyFilters(event: FormEvent<HTMLFormElement>) {
        event.preventDefault();
        const status = new FormData(event.currentTarget).get('status')?.toString() ?? 'all';
        router.get(navigation.tables, { search, status }, { preserveState: true, replace: true });
    }

    function startAll() {
        if (auth.canStartSync && window.confirm('¿Iniciar la recarga completa de todas las tablas habilitadas?')) {
            router.post(navigation.startAll);
        }
    }

    return <AdminLayout title="Tablas de sincronización" description="Vistas de PostgreSQL y tablas de destino en ClickHouse." active="tables" actions={
        <button disabled={!auth.canStartSync} onClick={startAll} className="rounded-xl bg-slate-950 px-4 py-2.5 text-sm font-semibold text-white hover:bg-slate-800 disabled:cursor-not-allowed disabled:bg-slate-200 disabled:text-slate-500">Sincronizar todas</button>
    }>
        <Head title="Tablas" />
        {!workerEnabled && <div className="mb-5 rounded-2xl border border-amber-200 bg-amber-50 px-5 py-4 text-sm text-amber-900">La integración con el worker privado está pendiente. Las acciones de sincronización están deshabilitadas.</div>}
        {workerEnabled && !auth.isAdmin && <div className="mb-5 rounded-2xl border border-slate-200 bg-white px-5 py-4 text-sm text-slate-600">Solo un administrador puede iniciar sincronizaciones.</div>}
        <div className="mb-5 rounded-2xl border border-slate-200 bg-white p-4 shadow-sm">
            <form onSubmit={applyFilters} className="flex flex-col gap-3 sm:flex-row">
                <label className="flex-1"><span className="sr-only">Buscar tablas</span><input value={search} onChange={(event) => setSearch(event.target.value)} placeholder="Buscar por nombre, origen o destino…" className="w-full rounded-xl border border-slate-300 px-4 py-2.5 text-sm outline-none focus:border-cyan-600 focus:ring-2 focus:ring-cyan-100" /></label>
                <label><span className="sr-only">Filtrar por estado</span><select name="status" defaultValue={filters.status} className="w-full rounded-xl border border-slate-300 bg-white px-4 py-2.5 text-sm outline-none sm:w-44"><option value="all">Todos los estados</option><option value="active">Habilitadas</option><option value="inactive">Inactivas</option></select></label>
                <button className="rounded-xl bg-slate-950 px-5 py-2.5 text-sm font-semibold text-white hover:bg-slate-800">Aplicar filtros</button>
            </form>
        </div>
        {tables.length === 0 ? <EmptyState title="No hay tablas para mostrar" description="Prueba otra búsqueda o revisa la configuración de las tablas." /> :
            <div className="overflow-hidden rounded-2xl border border-slate-200 bg-white shadow-sm">
                <div className="overflow-x-auto"><table className="w-full min-w-[1040px] text-left text-sm"><thead className="bg-slate-50 text-xs font-semibold uppercase tracking-wider text-slate-500"><tr><th className="px-5 py-4">Tabla</th><th className="px-5 py-4">Origen PostgreSQL</th><th className="px-5 py-4">Destino ClickHouse</th><th className="px-5 py-4">Modalidad</th><th className="px-5 py-4">Estado</th><th className="px-5 py-4">Última sincronización</th><th className="px-5 py-4 text-right">Filas</th><th className="px-5 py-4" /></tr></thead>
                    <tbody className="divide-y divide-slate-100">{tables.map((table) => <tr key={table.id} className="hover:bg-slate-50/80">
                        <td className="px-5 py-4"><div className="font-semibold text-slate-900">{table.name}</div><div className="mt-1 text-xs text-slate-400">{table.connection}</div></td>
                        <td className="px-5 py-4 font-mono text-xs text-slate-600">{table.sourceTable}</td>
                        <td className="px-5 py-4 font-mono text-xs text-slate-600">{table.targetTable}</td>
                        <td className="px-5 py-4"><span className="rounded-lg bg-slate-100 px-2 py-1 text-xs font-medium text-slate-700">{table.syncMode === 'full' ? 'Completa' : table.syncMode}</span></td>
                        <td className="px-5 py-4"><span className={`text-xs font-semibold ${table.isActive ? 'text-emerald-700' : 'text-slate-400'}`}>{table.isActive ? '● Habilitada' : '○ Inactiva'}</span></td>
                        <td className="px-5 py-4"><div><DateTime value={table.lastSuccessAt} /></div><div className="mt-1"><StatusBadge status={table.latestStatus} /></div>{!table.lastSuccessAt && <div className="mt-1 text-xs text-amber-700">Nunca sincronizada desde Laravel</div>}</td>
                        <td className="px-5 py-4 text-right font-semibold tabular-nums">{table.lastRowsCount?.toLocaleString('es-DO') ?? '—'}</td>
                        <td className="px-5 py-4"><button disabled={!auth.canStartSync || !table.isActive} onClick={() => router.post(table.syncUrl)} className="whitespace-nowrap rounded-lg border border-cyan-300 px-3 py-2 text-xs font-semibold text-cyan-800 hover:bg-cyan-50 disabled:cursor-not-allowed disabled:border-slate-200 disabled:text-slate-400">Sincronizar</button></td>
                    </tr>)}</tbody>
                </table></div>
                <div className="border-t border-slate-100 px-5 py-4 text-xs text-slate-500">{tables.length} tabla{tables.length === 1 ? '' : 's'} mostrada{tables.length === 1 ? '' : 's'}</div>
            </div>}
    </AdminLayout>;
}
