@extends('layouts.exat')
@section('title', 'Remboursements')
@section('subtitle', 'Suivi des avances décaissées')

@section('content')
<div class="sm:sticky sm:top-16 sm:z-20 -mx-4 border-b border-slate-200 bg-slate-50/95 px-4 pb-3 pt-4 backdrop-blur sm:-mx-6 sm:px-6">
    <div class="mb-4 grid grid-cols-2 gap-3 sm:grid-cols-3 lg:grid-cols-5">
        <div class="rounded-xl bg-white p-4 ring-1 ring-slate-200">
            <div class="text-xs text-slate-500">Total à rembourser</div>
            <div class="text-2xl font-medium text-slate-800">{{ number_format($stats['total_a_rembourser'], 0, ',', ' ') }}<span class="ml-1 text-sm text-slate-400">FCFA</span></div>
        </div>
        <div class="rounded-xl bg-white p-4 ring-1 ring-slate-200">
            <div class="text-xs text-slate-500">Encours</div>
            <div class="text-2xl font-medium text-indigo-600">{{ number_format($stats['encours'], 0, ',', ' ') }}<span class="ml-1 text-sm text-slate-400">FCFA</span></div>
        </div>
        <div class="rounded-xl bg-white p-4 ring-1 ring-slate-200">
            <div class="text-xs text-slate-500">Total remboursé</div>
            <div class="text-2xl font-medium text-emerald-600">{{ number_format($stats['rembourse'], 0, ',', ' ') }}<span class="ml-1 text-sm text-slate-400">FCFA</span></div>
        </div>
        <div class="rounded-xl bg-white p-4 ring-1 ring-slate-200">
            <div class="text-xs text-slate-500">En retard</div>
            <div class="text-2xl font-medium text-rose-600">{{ $stats['en_retard'] }}</div>
        </div>
        <div class="rounded-xl bg-white p-4 ring-1 ring-slate-200">
            <div class="text-xs text-slate-500">Soldées</div>
            <div class="text-2xl font-medium text-green-600">{{ $stats['soldees'] }}</div>
        </div>
    </div>

    @if(auth()->user()->hasRole(['SUPERADMIN','ADMIN']))
        <form method="POST" action="{{ route('remboursements.synchroniser') }}" class="mb-3 flex justify-end">
            @csrf
            <button class="inline-flex h-9 items-center gap-1.5 rounded-lg border border-emerald-200 bg-emerald-50 px-3 text-sm font-medium text-emerald-700 hover:bg-emerald-100" title="Récupérer les remboursements depuis la base externe">
                <svg class="h-4 w-4" fill="none" viewBox="0 0 24 24" stroke-width="1.8" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" d="M16.023 9.348h4.992V4.356M2.985 19.644v-4.992h4.992m-4.993 0 3.181 3.183a8.25 8.25 0 0 0 13.803-3.7M4.031 9.865a8.25 8.25 0 0 1 13.803-3.7l3.181 3.182m0-4.99v4.99"/></svg>
                Synchroniser maintenant
            </button>
        </form>
    @endif
    <form method="GET" class="flex flex-wrap items-end gap-2 rounded-xl bg-white p-3 ring-1 ring-slate-200">
        <div>
            <label class="mb-1 block text-[11px] text-slate-400">Statut</label>
            <select name="statut" class="h-9 rounded-lg border-slate-200 text-sm">
                <option value="">Tous</option>
                @foreach(['DECAISSEE'=>'Décaissée','EN_REMBOURSEMENT'=>'En remboursement','EN_DEFAUT'=>'En défaut','SOLDEE'=>'Soldée'] as $v => $lib)
                    <option value="{{ $v }}" @selected(request('statut')===$v)>{{ $lib }}</option>
                @endforeach
            </select>
        </div>
        @include('partials._filtre-date')
        <div class="min-w-[220px] flex-1">
            <label class="mb-1 block text-[11px] text-slate-400">Recherche</label>
            <input type="text" name="q" value="{{ request('q') }}" placeholder="Référence, planteur ou code" class="h-9 w-full rounded-lg border-slate-200 text-sm">
        </div>
        <button class="inline-flex h-9 items-center gap-2 rounded-lg border border-slate-200 px-3 text-sm text-slate-700 hover:bg-slate-50">Filtrer</button>
        @if(request()->hasAny(['periode', 'date', 'date_debut', 'date_fin', 'semaine', 'mois', 'annee']))
            <a href="{{ route('remboursements.index') }}" class="inline-flex h-9 items-center px-2 text-sm text-slate-500 hover:text-slate-700">Réinitialiser</a>
        @endif
                    <div class="ml-auto flex items-end gap-2">
                    <a href="{{ route('export.remboursements', array_merge(['format' => 'xlsx'], request()->query())) }}" title="Exporter en Excel"
                       class="inline-flex h-9 items-center gap-1.5 rounded-lg border border-emerald-200 bg-emerald-50 px-3 text-sm font-medium text-emerald-700 hover:bg-emerald-100">
                        <svg class="h-4 w-4" fill="none" viewBox="0 0 24 24" stroke-width="1.7" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" d="M9 12.75 11.25 15 15 9.75M21 12a9 9 0 1 1-18 0 9 9 0 0 1 18 0Z"/></svg>Excel
                    </a>
                    <a href="{{ route('export.remboursements', array_merge(['format' => 'pdf'], request()->query())) }}" title="Exporter en PDF"
                       class="inline-flex h-9 items-center gap-1.5 rounded-lg border border-red-200 bg-red-50 px-3 text-sm font-medium text-red-700 hover:bg-red-100">
                        <svg class="h-4 w-4" fill="none" viewBox="0 0 24 24" stroke-width="1.7" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" d="M19.5 14.25v-2.625a3.375 3.375 0 0 0-3.375-3.375h-1.5A1.125 1.125 0 0 1 13.5 7.125v-1.5a3.375 3.375 0 0 0-3.375-3.375H8.25m2.25 0H5.625c-.621 0-1.125.504-1.125 1.125v17.25c0 .621.504 1.125 1.125 1.125h12.75c.621 0 1.125-.504 1.125-1.125V11.25a9 9 0 0 0-9-9Z"/></svg>PDF
                    </a>
                </div>
            </form>

    </div>

    <div class="mt-3 overflow-hidden rounded-xl bg-white ring-1 ring-slate-200">
        <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead>
                    <tr class="bg-slate-50 text-left text-xs text-slate-500">
                        @include('partials.th-tri', ['col' => 'reference', 'label' => 'Réf. Int / Ext'])
                        @include('partials.th-tri', ['col' => 'planteur', 'label' => 'Planteur'])
                        @include('partials.th-tri', ['col' => 'montant', 'label' => 'Montant', 'align' => 'right'])
                        @include('partials.th-tri', ['col' => 'mois', 'label' => 'Mois', 'align' => 'center'])
                        @include('partials.th-tri', ['col' => 'rembourse', 'label' => 'Remboursé', 'align' => 'right'])
                        @include('partials.th-tri', ['col' => 'solde', 'label' => 'Solde', 'align' => 'right'])
                        @include('partials.th-tri', ['col' => 'decaissement', 'label' => 'Décaissement'])
                        @include('partials.th-tri', ['col' => 'dernier', 'label' => 'Dernier remb.'])
                        @include('partials.th-tri', ['col' => 'avancement', 'label' => 'Avancement'])
                        @include('partials.th-tri', ['col' => 'statut', 'label' => 'Statut'])
                        <th class="px-4 py-3"></th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($demandes as $d)
                        @php
                            $montant = (float) $d->montant;
                            $rembourse = (float) ($sommes[$d->id] ?? 0);
                            $solde = max(0, $montant - $rembourse);
                            $pct = $montant > 0 ? min(100, round($rembourse / $montant * 100)) : 0;
                        @endphp
                        <tr class="border-t border-slate-100 hover:bg-slate-50/60">
                            <td class="whitespace-nowrap px-4 py-3"><div class="font-medium tabular-nums text-slate-800">{{ $d->reference }}</div>@if($d->numero_pret)<div class="text-[11px] text-slate-400">{{ $d->numero_pret }}</div>@endif</td>
                            <td class="px-4 py-3"><div class="text-slate-800">{{ $d->planteur->nom ?? '—' }}</div><div class="text-[11px] text-slate-400">{{ $d->planteur->code ?? '' }}</div></td>
                            <td class="whitespace-nowrap px-4 py-3 text-right tabular-nums text-slate-700">{{ number_format($montant, 0, ',', ' ') }}</td>
                            <td class="px-4 py-3 text-center tabular-nums text-slate-600">{{ $d->duree_mois ?? '—' }}</td>
                            <td class="whitespace-nowrap px-4 py-3 text-right tabular-nums text-emerald-700">{{ number_format($rembourse, 0, ',', ' ') }}</td>
                            <td class="whitespace-nowrap px-4 py-3 text-right tabular-nums font-medium text-slate-800">{{ number_format($solde, 0, ',', ' ') }}</td>
                            <td class="whitespace-nowrap px-4 py-3 text-slate-500">{{ $d->date_octroi ? \Illuminate\Support\Carbon::parse($d->date_octroi)->format('d/m/Y') : '—' }}</td>
                            <td class="whitespace-nowrap px-4 py-3 text-slate-500">{{ ($derniersRemb[$d->id] ?? null) ? \Illuminate\Support\Carbon::parse($derniersRemb[$d->id])->format('d/m/Y') : '—' }}</td>
                            <td class="px-4 py-3">
                                <div class="flex items-center gap-2">
                                    <div class="h-1.5 w-24 overflow-hidden rounded-full bg-slate-100"><div class="h-full rounded-full bg-emerald-500" style="width: {{ $pct }}%"></div></div>
                                    <span class="text-[11px] text-slate-400">{{ $pct }}%</span>
                                </div>
                            </td>
                            <td class="px-4 py-3"><x-statut-badge :statut="$d->statut" /></td>
                            <td class="whitespace-nowrap px-4 py-3 text-right">
                                <a href="{{ route('remboursements.show', $d) }}" class="text-xs font-medium text-emerald-600 hover:text-emerald-700">Détail</a>
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="11" class="px-4 py-12 text-center text-sm text-slate-400">Aucune avance décaissée. Décaissez une demande validée depuis sa fiche.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        @if($demandes->total() > 0)
        <div class="border-t border-slate-100 px-4 py-3">
            @include('partials.pagination', ['paginator' => $demandes])
        </div>
    @endif
    </div>
@endsection