@extends('layouts.app')

@section('title', 'Prévisions')

@section('content')
<div class="pagetitle">
  <h3>Tableau des prévisions</h3>
  <nav>
    <ol class="breadcrumb">
      <li class="breadcrumb-item"><a href="">Accueil</a></li>
      <li class="breadcrumb-item active">Prévisions</li>
    </ol>
  </nav>
</div><!-- End Page Title -->

<section class="section">
  <div class="row">
    <div class="col-lg-12">

      <div class="card">
        <div class="card-body">
         
        	 <br/><button onclick="exportTableToExcel('previsions-table', 'prévisions.xlsx', {includeColumns: [0,1,2,3,4]})" 
        class="btn btn-success">
    Exporter en Excel
</button>
				 <table id="previsions-table" class="table datatable table-custom">
					<thead class="table-dark">
						<tr>
							<th>Activité</th>
							<th>Extrant</th>
							<th>Date prévisionnelle</th>
							<th>Taux prévisionnel (%)</th>
							<th>État d'évaluation</th>
						</tr>
					</thead>
					<tbody>
						@foreach($previsions->groupBy('activite_id') as $activiteId => $activitePrevisions)
							@php
								$activite = $activitePrevisions->first()->activite;
								$extrantsGrouped = $activitePrevisions->groupBy('extrant_id');
							@endphp
							@foreach($extrantsGrouped as $extrantId => $extrantPrevisions)
								@php
									$extrant = $extrantPrevisions->first()->extrant;
								@endphp
								@foreach($extrantPrevisions as $index => $p)
									@php
										$today = now();
										$dateEval = \Carbon\Carbon::parse($p->dateevaluation);
										$etat = '';
										$style = '';
										$details = '';

										// Calculer la fin du trimestre courant
										$currentMonth = $today->month;
										$currentYear = $today->year;

										if ($currentMonth <= 3) {
											$endOfQuarter = \Carbon\Carbon::create($currentYear, 3, 31)->endOfDay();
										} elseif ($currentMonth <= 6) {
											$endOfQuarter = \Carbon\Carbon::create($currentYear, 6, 30)->endOfDay();
										} elseif ($currentMonth <= 9) {
											$endOfQuarter = \Carbon\Carbon::create($currentYear, 9, 30)->endOfDay();
										} else {
											$endOfQuarter = \Carbon\Carbon::create($currentYear, 12, 31)->endOfDay();
										}

										if ($dateEval->greaterThan($today) && $dateEval->lessThanOrEqualTo($endOfQuarter)) {
											// Prévisions dans le reste du trimestre courant
											$etat = 'À venir';
											$style = 'bg-blue';
										} elseif ($dateEval->greaterThan($endOfQuarter)) {
											// Prévisions au-delà du trimestre courant : aucun état
											$etat = '';
											$style = '';
										} else {
											// Prévisions passées
											if ($p->evaluations->isEmpty()) {
												$jours = $dateEval->diffInDays($today, false);
												$jours = (int) $jours;
												$etat = 'En retard';
												$details = "($jours jrs)";
												$style = 'bg-red';
											} else {
												$evaluation = $p->evaluations->first();
												if (!$evaluation->valide) {
													$etat = 'Évalué non validé';
													$style = 'bg-orange';
												} else {
													$etat = 'Évalué et validé';
													$style = 'bg-green';
												}
											}
										}
									@endphp
									<tr>
										{{-- Activité : seulement sur la première ligne du groupe --}}
										@if($loop->first && $loop->parent->first)
											<td rowspan="{{ $extrantsGrouped->sum(fn($grp) => $grp->count()) }}">
												{{ $activite->nom }}
												<a href="{{ route('activites.planning', $activite->id) }}" class="btn btn-info btn-sm">
													<i class="bi bi-eye"></i>
												</a>
											</td>
										@endif

										{{-- Extrant : seulement sur la première ligne de son groupe --}}
										@if($loop->first)
											<td rowspan="{{ $extrantPrevisions->count() }}">
												{{ $extrant->nom }}
											</td>
										@endif

										{{-- Prévision --}}
										<td>{{ $p->dateevaluation }}</td>
										<td>{{ $p->niveaucible }}</td>
										<td>
											<span class="badge {{ $style }}">
												{{ $etat }} {{ $details }}
											</span>
										</td>
									</tr>
								@endforeach
							@endforeach
						@endforeach
					</tbody>
				</table>

          <!-- End Table -->
        </div>
      </div>

    </div>
  </div>
</section>
@endsection