@extends('layouts.master')

@section('title')
    Besoins Budgetaires
@endsection

@section('content')
<style>
    table th,
    table td{
        text-align: center;
        vertical-align: middle;
        white-space: nowrap;
    }
    
</style>


<style>
    .table-budget th,
    .table-budget td{
        padding:8px;
        text-align:center;
    }

    .table-budget input{
        min-width:130px;
    }

    .col-montant{
        min-width:190px;
    }

    .col-mois{
        min-width:100px;
    }
</style>


<div class="container-fluid">

   <div class="card shadow-sm mb-4 border-0">
    <div class="card-body d-flex justify-content-between align-items-center flex-wrap">

        <div class="text-center flex-grow-1">
            <h4 class="fw-bold text-uppercase mb-1" style="letter-spacing:1px;">
                BESOINS BUDGETAIRES
            </h4>
        </div>
    </div>
    </div>
        


    <!-- ===================== TABLEAU GLOBAL BESOINS BUDGETAIRES ===================== -->
    <div class="card shadow mb-4">
        <div class="card-header py-3 bg-primary text-white">
            <h6 class="m-0 font-weight-bold">Synthèse Budget - Ressources & Emplois</h6>
        </div>

        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered table-striped" style="font-size:0.85em;">
                    <thead class="thead-dark">
                        <tr>
                            <th>Exercice</th>
                            <th>Direction</th>
                            <th>Centre de responsabilité</th>
                            <th>Entité</th>
                            <th>Type Contrat</th>
                            <th>Code Contrat</th>
                            <th>Nom Contrat</th>
                            <th>Immatriculation</th>
                            <th>Responsable</th>
                            <th>Objet</th>
                            <th>Total Ressources</th>
                            <th>Total Emplois</th>
                            <th>Ecart</th>
                            <th>Détails Ressources</th>
                            <th>Détails Emplois</th>
                            <th>Action</th>
                            <th>Motif Si Retour</th>
                        </tr>
                    </thead>

                    <tbody>
                        @foreach($besoinbudgetaires as $besoinbudgetaire)

                            @php
                                $totalRessources = $besoinbudgetaire->budgetressources->sum('montant_inscrit');
                                $totalDepenses = $besoinbudgetaire->budgetdepenses->sum('montant');
                                $ecart = $totalRessources - $totalDepenses;
                            @endphp

                            <tr>
                                <td>{{ $besoinbudgetaire->exercice }}</td>
                                <td>{{ $besoinbudgetaire->direction->code ?? '-' }} - {{ $besoinbudgetaire->direction->libelle ?? '-' }}</td>
                                <td>{{ $besoinbudgetaire->centrerespo->code ?? '-' }} - {{ $besoinbudgetaire->centrerespo->libelle_long ?? '-' }}</td>
                                <td>{{ $besoinbudgetaire->entite->libelle ?? '-' }}</td>
                               <td> @if($besoinbudgetaire->type_contrat === 'signe')
                                    <span class="badge badge-warning">Signé</span>
                                    @elseif($besoinbudgetaire->type_contrat === 'permanent')
                                        <span class="badge badge-success">Permanent</span>
                                    @elseif($besoinbudgetaire->type_contrat === 'accessoire')
                                        <span class="badge badge-info">Accessoire</span>
                                    @endif
                                </td>
                                 <td>{{ $besoinbudgetaire->code_budget ?? '-' }}</td>
                                <td>{{ $besoinbudgetaire->nom_budget ?? '-' }}</td>
                                <td>{{ $besoinbudgetaire->immatriculation ?? '---' }}</td>
                                <td>{{ $besoinbudgetaire->responsable }}</td>
                                <td>{{ $besoinbudgetaire->objet }}</td>

                                <td class="text-right font-weight-bold text-success">
                                    {{ number_format($totalRessources, 2, ',', ' ') }} FCFA
                                </td>


                                <td class="text-right font-weight-bold text-danger">
                                    {{ number_format($totalDepenses, 2, ',', ' ') }} FCFA
                                </td>

                                 <td class="text-right font-weight-bold {{ $ecart >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($ecart, 2, ',', ' ') }} FCFA
                                </td>

                                <!-- DETAILS RESSOURCES -->
                                <td class="text-center align-middle">
                                    <button class="btn btn-sm btn-success btnVoirDetail" 
                                            data-id="{{ $besoinbudgetaire->id }}" 
                                            data-type="ressources">
                                        Voir
                                    </button>
                                </td>

                                <!-- DETAILS DEPENSES -->
                                <td class="text-center align-middle">
                                   <button class="btn btn-sm btn-danger btnVoirDetail" 
                                            data-id="{{ $besoinbudgetaire->id }}" 
                                            data-type="depenses">
                                        Voir    
                                    </button>
                                </td>

                                <!-- ACTION -->
                             <td>
                              @php
                                  $user = auth()->user();

                                  // 🔥 MON STEP (pas le step courant du besoin)
                                  $myStep = $besoinbudgetaire->workflow->workflow_steps
                                      ->where('role', $user->role)
                                      ->first();

                                  $currentStep = $besoinbudgetaire->workflow_step;

                                  $isMyStep = $currentStep && $currentStep->role === $user->role;

                                  // 🔥 MON HISTORIQUE
                                  $myHistory = $besoinbudgetaire->workflowHistories
                                      ->where('workflow_step_id', $myStep->id ?? null)
                                      ->sortByDesc('id')
                                      ->first();

                                  // 🔥 HISTORIQUE ÉTAPE SUIVANTE
                                  $nextHistory = $besoinbudgetaire->workflowHistories
                                      ->where('workflow_step_id', $myStep->next_step_id ?? null)
                                      ->sortByDesc('id')
                                      ->first();

                                  // =========================
                                  // 🔥 DÉTERMINATION DU STATUS
                                  // =========================

                                  if ($besoinbudgetaire->status === 'brouillon') {
                                      $currentStatus = 'brouillon';
                                  }

                                  // 🔥 SI J’AI DÉJÀ TRANSMIS
                                  elseif ($nextHistory && $nextHistory->status === 'transmis') {
                                      $currentStatus = 'transmis';
                                  }

                                  // 🔥 SI RETOUR DE L’ÉTAPE SUIVANTE
                                  elseif ($nextHistory && $nextHistory->status === 'retourne') {
                                      $currentStatus = 'retourne';
                                  }

                                  else {
                                      $currentStatus = $myHistory->status ?? 'en_attente';
                                  }
                              @endphp


                              @if($isMyStep)

                                  {{-- 🔵 REÇU → À TRAITER --}}
                                  @if($currentStatus === 'transmis')

                                      <div class="d-flex justify-content-center">

                                          <form action="{{ route('user.besoinbudgetaire.valider', $besoinbudgetaire->id) }}"
                                                method="POST" class="mr-1">
                                              @csrf
                                              <button type="submit" class="btn btn-success btn-sm">
                                                  Valider
                                              </button>
                                          </form>

                                          <button class="btn btn-warning btn-sm"
                                                  data-toggle="modal"
                                                  data-target="#modalRetourCorrection"
                                                  data-id="{{ $besoinbudgetaire->id }}">
                                              Retourner
                                          </button>

                                      </div>

                                  {{-- 🟢 VALIDÉ --}}
                                  @elseif($currentStatus === 'valide')

                                      <span class="badge badge-success">Budget validé</span>

                                      <div class="d-flex justify-content-center mt-1">
                                          <form action="{{ route('user.besoinbudgetaire.transmettre', $besoinbudgetaire->id) }}"
                                                method="POST">
                                              @csrf
                                              <button class="btn btn-primary btn-sm">
                                                  <i class="fas fa-paper-plane"></i>
                                              </button>
                                          </form>
                                      </div>

                                  {{-- 🔵 TRANSMIS → PLUS D’ACTION --}}
                                  @elseif($currentStatus === 'transmis')

                                      <span class="badge badge-primary">Budget transmis</span>

                                  {{-- 🔴 RETOURNÉ --}}
                                  @elseif($currentStatus === 'retourne')

                                      <span class="badge badge-danger">Budget retourné</span>

                                      <div class="d-flex justify-content-center mt-1">

                                          <a href="{{ route('user.besoinbudgetaire.edit2', $besoinbudgetaire->id) }}?from={{ url()->current() }}"
                                            class="btn btn-sm btn-info mr-1">
                                              <i class="fas fa-edit"></i>
                                          </a>

                                          <form action="{{ route('user.besoinbudgetaire.transmettre', $besoinbudgetaire->id) }}"
                                                method="POST">
                                              @csrf
                                              <button class="btn btn-sm btn-primary">
                                                  <i class="fas fa-paper-plane"></i>
                                              </button>
                                          </form>

                                      </div>

                                  @endif

                                  {{-- 👁️ AUTRES ÉTAPES --}}
                              @else

                                  @if($currentStatus === 'valide')
                                      <span class="badge badge-success">Budget validé</span>

                                  @elseif($currentStatus === 'transmis')
                                      <span class="badge badge-primary">Budget transmis</span>

                                  @elseif($currentStatus === 'retourne')
                                      <span class="badge badge-danger">Budget retourné</span>

                                  @else
                                      <span class="badge badge-secondary">En attente</span>
                                  @endif

                              @endif

                              </td>

                                                              <!-- MOTIF -->
                              <td class="text-center align-middle">
                              @php
                                  $retour = $besoinbudgetaire->workflowHistories
                                      ->where('status', 'retourne')
                                      ->whereNotNull('motif')
                                      ->sortByDesc('id')
                                      ->first();
                              @endphp

                              {{ $retour->motif ?? '---' }}
                              </td>
                            </tr>

                                <!-- LIGNE DETAILS RESSOURCES -->
                                <tr id="ressource-{{ $besoinbudgetaire->id }}" class="detail-row d-none">
                                  <td colspan="14">

                                    <div class="card mb-3 border-success">
                                          <div class="card-header bg-success text-white py-2">
                                              <strong> Budget Ressources</strong>
                                          </div>
                                      </div>
                                      <div style="overflow-x:auto; width:100%;">
                                          <table class="table table-sm table-bordered" style="min-width:1500px; white-space:nowrap;">
                                            <thead class="bg-light">
                                                <tr>
                                                  <th>Poste de gestion</th>
                                                    <th>Compte syscohada</th>
                                                    <th>Libellé</th>
                                                    <th>Montant total</th>
                                                    <th>Montant inscrit</th>
                                                    <th>Janvier</th><th>Février</th><th>Mars</th><th>Avril</th>
                                                    <th>Mai</th><th>Juin</th><th>Juillet</th><th>Août</th>
                                                    <th>Septembre</th><th>Octobre</th><th>Novembre</th><th>Décembre</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($besoinbudgetaire->budgetressources as $budgetressource)
                                                    <tr>
                                                       <td>{{ $budgetressource->postegestion->code ?? '-' }} - {{ $budgetressource->postegestion->libelle ?? '-' }}</td>
                                                        <td>{{ $budgetressource->comptesyscohada->code ?? '-' }} - {{ $budgetressource->comptesyscohada->libelle ?? '-' }}</td>
                                                        <td>{{ $budgetressource->libelle ?? '-' }}</td>
                                                        <td class="text-right">
                                                            {{ number_format($budgetressource->montant_total,0,',',' ') }} FCFA
                                                        </td>
                                                        <td class="text-right">
                                                            {{ number_format($budgetressource->montant_inscrit,0,',',' ') }} FCFA
                                                        </td>
                                                        <td class="text-right">{{ number_format($budgetressource->janvier,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->fevrier,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->mars,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->avril,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->mai,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->juin,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->juillet,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->aout,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->septembre,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->octobre,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->novembre,0,',',' ') }} FCFA</td>
                                                        <td class="text-right">{{ number_format($budgetressource->decembre,0,',',' ') }} FCFA</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                      </div>
                                    </td>
                                </tr>

                                <!-- LIGNE DETAILS DEPENSES -->
                                <tr id="depense-{{ $besoinbudgetaire->id }}" class="detail-row d-none">
                                    <td colspan="14">

                                        @php
                                            // Regrouper les dépenses par activité
                                            $depensesParActivite = $besoinbudgetaire->budgetdepenses->groupBy('activite');
                                        @endphp

                                        @foreach($depensesParActivite as $activite => $depenses)
                                            {{-- ================= BLOC ACTIVITE ================= --}}
                                            <div class="card mb-3 border-danger">
                                                <div class="card-header bg-danger text-white py-2">
                                                    <strong>Informations complémentaires - Activité : {{ $activite ?? '-' }}</strong>
                                                </div>
                                                <div class="card-body py-2">
                                                    @php
                                                        $firstDepense = $depenses->first();
                                                    @endphp
                                                    <div class="row" style="font-size:0.85em;">
                                                        <div class="col-md-4">
                                                            <strong>Direction :</strong>
                                                            {{ $firstDepense->direction->code ?? '-' }} - {{ $firstDepense->direction->libelle ?? '-' }}
                                                        </div>
                                                        <div class="col-md-4">
                                                            <strong>Centre de responsabilité :</strong>
                                                            {{ $firstDepense->centrerespo->code ?? '-' }} - {{ $firstDepense->centrerespo->libelle_long ?? '-' }}
                                                        </div>
                                                        <div class="col-md-4">
                                                            <strong>Domaine d’activités :</strong>
                                                            {{ $firstDepense->domaineact->code ?? '-' }} - {{ $firstDepense->domaineact->libelle ?? '-' }}
                                                        </div>
                                                        <div class="col-md-4 mt-2">
                                                            <strong>Axe PSD :</strong>
                                                            {{ $firstDepense->axe->code ?? '-' }} - {{ $firstDepense->axe->libelle ?? '-' }}
                                                        </div>
                                                        <div class="col-md-4 mt-2">
                                                            <strong>Domaine PSD :</strong>
                                                            {{ $firstDepense->domainepsd->code ?? '-' }} - {{ $firstDepense->domainepsd->libelle ?? '-' }}
                                                        </div>
                                                        <div class="col-md-4 mt-2">
                                                            <strong>Programme PSD :</strong>
                                                            {{ $firstDepense->programme->code ?? '-' }} - {{ $firstDepense->programme->libelle ?? '-' }}
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>

                                            {{-- ================= TABLEAU LIGNES DEPENSES ================= --}}
                                            <div style="overflow-x:auto; width:100%;">
                                                <table class="table table-sm table-bordered" style="min-width:1000px; white-space:nowrap;">
                                                    <thead class="bg-light">
                                                        <tr>
                                                           <th>Poste de gestion</th>
                                                            <th>Compte syscohada</th>
                                                            <th>Nature dépense</th>
                                                            <th>Nbre</th>
                                                            <th>Quantite</th>
                                                            <th>C.U</th>
                                                            <th>Montant</th>
                                                            <th>Janvier</th><th>Février</th><th>Mars</th><th>Avril</th>
                                                            <th>Mai</th><th>Juin</th><th>Juillet</th><th>Août</th>
                                                            <th>Septembre</th><th>Octobre</th><th>Novembre</th><th>Décembre</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach($depenses as $budgetdepense)
                                                            <tr>
                                                              <td>{{ $budgetdepense->postegestion->code ?? '-' }} - {{ $budgetdepense->postegestion->libelle ?? '-' }}</td>
                                                                <td>{{ $budgetdepense->comptesyscohada->code ?? '-' }} - {{ $budgetdepense->comptesyscohada->libelle ?? '-' }}</td>
                                                                <td>{{ $budgetdepense->nature ?? '-' }}</td>
                                                                <td>{{ number_format($budgetdepense->qte, 2, ',', ' ') }}</td>
                                                                <td>{{ number_format($budgetdepense->c_u, 2, ',', ' ') }}</td>
                                                                <td>{{ number_format($budgetdepense->c_u,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->montant,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->janvier,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->fevrier,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->mars,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->avril,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->mai,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->juin,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->juillet,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->aout,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->septembre,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->octobre,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->novembre,2,',',' ') }} FCFA</td>
                                                                <td class="text-right">{{ number_format($budgetdepense->decembre,2,',',' ') }} FCFA</td>
                                                            </tr>
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                            </div>

                                        @endforeach

                                    </td>
                                </tr>

                        @endforeach
                    </tbody>
                </table>
            </div>

        <div class="d-flex justify-content-between align-items-center mt-3">

            <div class="small text-muted">
                Affichage de {{ $besoinbudgetaires->firstItem() }}
                à {{ $besoinbudgetaires->lastItem() }}
                sur {{ $besoinbudgetaires->total() }} résultats
            </div>

            <div>
               {{ $besoinbudgetaires->appends(request()->query())->links() }}
            </div>

        </div>
    </div>

     <!-- MODAL RETOUR POUR CORRECTION -->
        <div class="modal fade" id="modalRetourCorrection" tabindex="-1">
            <div class="modal-dialog">
                <div class="modal-content">

                    <form method="POST" id="formRetour" action="">
                        @csrf

                        <input type="hidden" name="besoinbudgetaire_id" id="besoin_id_retour">

                        <div class="modal-header bg-warning">
                            <h5 class="modal-title">Retourner pour correction</h5>
                        </div>

                        <div class="modal-body">
                            <label class="form-label">
                                Motif du retour <span class="text-danger">*</span>
                            </label>
                            <textarea
                                name="motif"
                                class="form-control"
                                rows="4"
                                required
                            ></textarea>
                        </div>

                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">
                                Annuler
                            </button>
                            <button type="submit" class="btn btn-warning">
                                Retourner
                            </button>
                        </div>

                    </form>

                </div>
            </div>
        </div>

        <!-- MODALE GÉNÉRIQUE POUR LES DÉTAILS -->
    <div class="modal fade" id="detailsModal" tabindex="-1" aria-labelledby="detailsModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-xl modal-dialog-scrollable">
        <div class="modal-content">
        <div class="modal-header">
            <h5 class="modal-title" id="detailsModalLabel">Détails Budget</h5>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Fermer"></button>
        </div>
        <div class="modal-body" id="detailsModalBody">
            <!-- Le contenu sera injecté via JS -->
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-primary" data-bs-dismiss="modal">Fermer</button>
        </div>
        </div>
    </div>
    </div>

</div>
</div>


<!-- ================= SCRIPT DYNAMIQUE ================= -->
<script>
    $(document).ready(function() {
        // Créer une instance globale de la modale
        let modalEl = document.getElementById('detailsModal');
        let detailsModal = new bootstrap.Modal(modalEl);

        $('.btnVoirDetail').click(function() {
            let id = $(this).data('id');
            let type = $(this).data('type');

            let rowId = (type === 'ressources') ? 'ressource-' + id : 'depense-' + id;
            let rowContent = $('#' + rowId + ' td').html();

            $('#detailsModalBody').html(rowContent);

            let titre = (type === 'ressources') ? 'Détails Budget Ressources' : 'Détails Budget Emplois';
            $('#detailsModalLabel').text(titre);

            // Afficher la modale
            detailsModal.show();
        });

        // Fermer la modale via boutons manuellement (optionnel)
        $(modalEl).on('click', '[data-bs-dismiss="modal"]', function() {
            detailsModal.hide();
        });
    });
</script>

<script>
    document.addEventListener("click", function(e) {
        if(e.target.classList.contains("toggle-detail")) {
            let target = document.querySelector(e.target.dataset.target);
            target.classList.toggle("d-none");
        }
    });
</script>

<script>
   $('#modalRetourCorrection').on('show.bs.modal', function (event) {
    var button = $(event.relatedTarget);
    var besoinId = button.data('id');

    $('#besoin_id_retour').val(besoinId);

    // 🔥 construire l'URL dynamiquement
    let url = "/user/besoinbudgetaire/" + besoinId + "/retourner";
    $('#formRetour').attr('action', url);
    });
</script>
@endsection