@extends('layouts.master')

@section('content')

<div class="container-fluid">

    <!-- ================= HEADER ================= -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h4 class="fw-bold">📊 Tableau de Bord Budgétaire</h4>
    </div>

    <!-- ================= STATS ================= -->
    <div class="row mb-4">

        <div class="col-md-6">
            <div class="card shadow border-0 bg-success text-white">
                <div class="card-body">
                    <h6>Total Ressources</h6>
                    <h4>{{ number_format($totalRessources,0,',',' ') }} FCFA</h4>
                </div>
            </div>
        </div>

        <div class="col-md-6">
            <div class="card shadow border-0 bg-danger text-white">
                <div class="card-body">
                    <h6>Total Emplois</h6>
                    <h4>{{ number_format($totalDepenses,0,',',' ') }} FCFA</h4>
                </div>
            </div>
        </div>

    </div>

    <!-- ================= FILTRES ================= -->
    <div class="card shadow-sm border-0 mb-4">
        <div class="card-body">

            <form method="GET">
                <div class="row g-3 align-items-end">

                    <div class="col-md-3">
                        <label class="fw-bold">Exercice</label>
                        <input type="number" name="exercice" class="form-control"
                            value="{{ request('exercice') }}">
                    </div>

                    <div class="col-md-3">
                        <label class="fw-bold">Statut</label>
                        <select name="status" class="form-control">
                            <option value="">Tous</option>
                            <option value="brouillon" {{ request('status')=='brouillon'?'selected':'' }}>Brouillon</option>
                            <option value="transmis" {{ request('status')=='transmis'?'selected':'' }}>Transmis</option>
                            <option value="valide" {{ request('status')=='valide'?'selected':'' }}>Validé</option>
                            <option value="retourne" {{ request('status')=='retourne'?'selected':'' }}>Retourné</option>
                        </select>
                    </div>

                    <div class="col-md-3">
                        <label class="fw-bold">Direction</label>
                        <select name="direction_id" class="form-control">
                            <option value="">Toutes</option>
                            @foreach($directions as $d)
                                <option value="{{ $d->id }}"
                                    {{ request('direction_id') == $d->id ? 'selected' : '' }}>
                                    {{ $d->code }} - {{ $d->libelle }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3">
                        <label class="fw-bold">Entité</label>
                        <select name="entite_id" class="form-control">
                            <option value="">Toutes</option>
                            @foreach($entites as $e)
                                <option value="{{ $e->id }}"
                                    {{ request('entite_id') == $e->id ? 'selected' : '' }}>
                                    {{ $e->code }} - {{ $e->libelle }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-12 d-flex justify-content-center mt-2">
                        <button type="submit" class="btn btn-dark px-5">
                            🔎 Rechercher
                        </button>
                    </div>

                </div>
            </form>

        </div>
    </div>

    <!-- ================= TABLEAU BUDGETAIRE ================= -->
    <div class="card shadow border-0">
        <div class="card-body p-0">

            <div class="table-responsive">
                <table class="table table-hover table-bordered align-middle mb-0 text-center">

                    <thead class="bg-dark text-white">
                        <tr>
                            <th>#</th>
                            <th>Compte</th>
                            <th>Libellé</th>
                            <th>Rubrique</th>
                            <th>Poste</th>
                            <th>Budget</th>
                            <th>Engagement</th>
                            <th>Ecart</th>
                            <th>%</th>
                        </tr>
                    </thead>

                    <tbody>

                    @php
                        $totalBudget = 0;
                        $totalEngagement = 0;
                    @endphp

                    @forelse($besoins as $index => $b)

                        @foreach($b->budgetdepenses as $d)

                        @php
                            $budget = $d->montant ?? 0;
                            $engagement = $d->engagement ?? 0;
                            $ecart = $budget - $engagement;
                            $taux = $budget > 0 ? ($engagement / $budget) * 100 : 0;

                            $totalBudget += $budget;
                            $totalEngagement += $engagement;
                        @endphp

                        <tr>
                            <td>{{ $index + 1 }}</td>

                            <td>{{ optional($d->comptesyscohada)->code ?? '-' }}</td>

                            <td>{{ optional($d->comptesyscohada)->libelle ?? '-' }}</td>

                            <td>{{ optional($d->rubrique5)->libelle ?? '-' }}</td>

                            <td>{{ optional($d->postegestion)->libelle ?? '-' }}</td>

                            <td class="text-success fw-bold">
                                {{ number_format($budget,0,',',' ') }}
                            </td>

                            <td class="text-primary fw-bold">
                                {{ number_format($engagement,0,',',' ') }}
                            </td>

                            <td class="text-danger fw-bold">
                                {{ number_format($ecart,0,',',' ') }}
                            </td>

                            <td>
                                {{ number_format($taux,2) }} %
                            </td>
                        </tr>

                        @endforeach

                    @empty
                        <tr>
                            <td colspan="9" class="text-center text-muted py-4">
                                Aucun besoin budgétaire trouvé
                            </td>
                        </tr>
                    @endforelse

                    </tbody>

                    <!-- TOTAL GLOBAL -->
                    <tfoot class="table-dark">
                        @php
                            $totalEcart = $totalBudget - $totalEngagement;
                            $totalTaux = $totalBudget > 0 ? ($totalEngagement / $totalBudget) * 100 : 0;
                        @endphp

                        <tr>
                            <th colspan="5">TOTAL GENERAL</th>
                            <th>{{ number_format($totalBudget,0,',',' ') }}</th>
                            <th>{{ number_format($totalEngagement,0,',',' ') }}</th>
                            <th>{{ number_format($totalEcart,0,',',' ') }}</th>
                            <th>{{ number_format($totalTaux,2) }} %</th>
                        </tr>
                    </tfoot>

                </table>
            </div>

        </div>
    </div>

</div>

@endsection