@extends('admin.layout.pdf')

@section('content')
    <style>
        /* ══════════════════════════════════════════════
           MODERN PDF REPORT DESIGN — VITALIS PREMIUM
           V4 : DEPENSES PAR TRANCHES D'AGES
           ══════════════════════════════════════════════ */
        
        @page {
            margin: 1cm;
        }

        body {
            font-family: 'Helvetica', 'Arial', sans-serif;
            color: #2c3e50;
            line-height: 1.4;
            font-size: 11px;
        }

        /* Header Brand Section */
        .report-brand-header {
            border-bottom: 2px solid #8fce8f;
            padding-bottom: 15px;
            margin-bottom: 25px;
            overflow: hidden;
        }
        .report-title-box {
            background: #8fce8f;
            color: #000;
            padding: 12px 20px;
            border-radius: 4px;
            display: inline-block;
            float: right;
            margin-top: 5px;
        }
        .report-title-text {
            font-size: 16px;
            font-weight: 800;
            margin: 0;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }
        .vitalis-logo-text {
            font-size: 24px;
            font-weight: 900;
            color: #2e7d32;
            margin: 0;
        }
        .logo-subtitle {
            font-size: 10px;
            color: #7f8c8d;
            text-transform: uppercase;
            letter-spacing: 1px;
        }

        /* Period Banner */
        .period-banner {
            background: #f8f9fa;
            border-left: 4px solid #8fce8f;
            padding: 10px 15px;
            margin-bottom: 30px;
            text-align: center;
        }
        .period-text {
            margin: 0;
            font-weight: 700;
            color: #34495e;
            font-size: 13px;
        }

        /* Information Grid */
        .info-grid {
            width: 100%;
            margin-bottom: 35px;
            border-collapse: separate;
            border-spacing: 0 5px;
        }
        .info-label {
            width: 150px;
            color: #7f8c8d;
            font-weight: 700;
            text-transform: uppercase;
            font-size: 9px;
            padding: 5px 10px;
            background: #fdfdfd;
            border-bottom: 1px solid #eee;
        }
        .info-value {
            color: #2c3e50;
            font-weight: 700;
            font-size: 11px;
            padding: 5px 10px;
            border-bottom: 1px solid #eee;
        }

        /* Main Data Table */
        .data-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 10px;
        }
        .data-table thead th {
            background-color: #f1f3f5;
            color: #2e7d32;
            font-weight: 800;
            text-transform: uppercase;
            font-size: 9px;
            padding: 8px 10px;
            border: 1px solid #ecf0f1;
            border-bottom: 2px solid #8fce8f;
            text-align: center;
            letter-spacing: 0.5px;
        }
        .data-table tbody td {
            padding: 10px;
            border-bottom: 1px solid #ecf0f1;
            vertical-align: middle;
            text-align: center;
        }
        .tranche-label {
            text-align: left !important;
            font-weight: 700;
            color: #34495e;
            background: #fdfdfd;
        }
        .data-table tbody tr:nth-child(even) {
            background-color: #fafbfb;
        }

        /* Numerical Columns */
        .col-numeric {
            text-align: right !important;
            font-family: 'Courier New', Courier, monospace;
            font-weight: 700;
        }
        .currency {
            color: #95a5a6;
            font-size: 8px;
            font-weight: normal;
            margin-left: 2px;
        }

        /* Badges & Status */
        .pct-badge {
            background: rgba(143, 206, 143, 0.2);
            color: #2e7d32;
            padding: 3px 6px;
            border-radius: 4px;
            font-weight: 800;
            font-size: 9px;
        }

        /* Total Section */
        .total-row {
            background-color: #f1f8f1 !important;
            border-top: 2px solid #8fce8f;
        }
        .total-label {
            text-align: left !important;
            padding-left: 10px;
            font-weight: 800;
            text-transform: uppercase;
            color: #2e7d32;
            font-size: 11px;
        }
        .total-value {
            color: #1b5e20;
            font-size: 11px !important;
            font-weight: 800;
        }

        /* Footer Decoration */
        .footer-note {
            margin-top: 40px;
            text-align: center;
            font-size: 8px;
            color: #bdc3c7;
            border-top: 1px solid #eee;
            padding-top: 10px;
            font-style: italic;
        }
    </style>

    <!-- Header Section -->
    <div class="report-brand-header">
        <div class="report-title-box">
            <h2 class="report-title-text">Dépenses par Tranches d'Âges</h2>
            @if ($date_validation != null && $date_validation < $dateFin)
                <span style="font-size: 12px; font-weight: 400; color: #7f8c8d;">Provisoire</span>
            @endif
        </div>
        <h1 class="vitalis-logo-text">VITALIS</h1>
        <span class="logo-subtitle">Gestion & Assurance Santé — Analyse Démographique</span>
    </div>

    <!-- Date Period Section -->
    <div class="period-banner">
        <p class="period-text">
            Période d'Analyse : du {{ \Carbon\Carbon::parse($dateDebut)->format('d/m/Y') }} au {{ \Carbon\Carbon::parse($dateFin)->format('d/m/Y') }}
        </p>
    </div>

    <!-- Context Information -->
    <table class="info-grid">
        @php
            $headerItems = [];
            if (!empty($infos) && count($infos) > 0) {
                $info = $infos[0];
                if (!empty($info->garant)) $headerItems[] = ['label' => 'Garant', 'value' => $info->garant];
                if (!empty($info->libellePolice)) $headerItems[] = ['label' => 'Police', 'value' => $info->libellePolice];
                if (!empty($info->souscripteur)) $headerItems[] = ['label' => 'Souscripteur', 'value' => $info->souscripteur];
                if (!empty($info->courtier)) $headerItems[] = ['label' => 'Intermédiaire / Courtier', 'value' => $info->courtier];
                if (!empty($info->libelleCollege)) $headerItems[] = ['label' => 'Collège', 'value' => $info->libelleCollege];
            } else {
                if (isset($Entetegarant) && $Entetegarant) $headerItems[] = ['label' => 'Garant', 'value' => $Entetegarant->libelle];
                if (isset($Entetepolice) && $Entetepolice) $headerItems[] = ['label' => 'Police', 'value' => $Entetepolice->libellePolice];
                if (isset($Entetesouscripteur) && $Entetesouscripteur) $headerItems[] = ['label' => 'Souscripteur', 'value' => $Entetesouscripteur->nom.' '.$Entetesouscripteur->prenoms];
                if (isset($EnteteApportteur) && $EnteteApportteur) $headerItems[] = ['label' => 'Intermédiaire / Courtier', 'value' => $EnteteApportteur->libelle];
                elseif (isset($Entetecourtier) && $Entetecourtier) $headerItems[] = ['label' => 'Intermédiaire / Courtier', 'value' => $Entetecourtier->libelle];
                if (isset($Entetecollege) && $Entetecollege) $headerItems[] = ['label' => 'Collège', 'value' => $Entetecollege->libelleCollege];
            }
        @endphp

        @foreach (array_chunk($headerItems, 2) as $chunk)
            <tr>
                @foreach ($chunk as $item)
                    <td class="info-label">{{ $item['label'] }}</td>
                    <td class="info-value">{{ $item['value'] }}</td>
                @endforeach
                @if (count($chunk) == 1)
                    <td class="info-label"></td>
                    <td class="info-value"></td>
                @endif
            </tr>
        @endforeach
    </table>

    <!-- Main Data Table -->
    <table class="data-table">
        <thead>
            <tr>
                <th rowspan="2" style="width: 25%; text-align: left;">Tranche d'âge</th>
                <th colspan="2" style="background: rgba(46, 125, 50, 0.05);">Effectif sur la période</th>
                <th colspan="2" style="background: rgba(46, 125, 50, 0.1);">Dépenses sur la période</th>
                <th rowspan="2" style="width: 15%;">Coût Moyen</th>
            </tr>
            <tr>
                <th style="width: 12%;">Nombre</th>
                <th style="width: 12%;">Taux</th>
                <th style="width: 18%;">Montant</th>
                <th style="width: 12%;">Taux</th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_Nombre = 0;
                $total_Taux_Eff = 0;
                $total_Depense_Tranche = 0;
                $total_Taux_Depense = 0;
                $total_coutMoyenTrancheTraite = 0;
                $count = 0;
            @endphp
            @if(isset($tranchesfts) && count($tranchesfts) > 0)
                @foreach ($tranchesfts as $tranchesft)
                    @php
                        $total_Nombre += (int)$tranchesft->Nombre;
                        $total_Taux_Eff += (float)$tranchesft->Taux_Eff;
                        $total_Depense_Tranche += (float)$tranchesft->Depense_Tranche;
                        $total_Taux_Depense += (float)$tranchesft->Taux_Depense;
                        $total_coutMoyenTrancheTraite += (float)$tranchesft->CoutMoyen;
                        $count++;
                    @endphp
                    <tr>
                        <td class="tranche-label">{{ $tranchesft->libelleTrancheAge }}</td>
                        <td><span style="font-weight: 800;">{{ $tranchesft->Nombre }}</span></td>
                        <td><span class="pct-badge">{{ number_format($tranchesft->Taux_Eff, 2, '.', ' ') }}%</span></td>
                        <td class="col-numeric">{{ number_format($tranchesft->Depense_Tranche, 0, '', ' ') }} <span class="currency">XOF</span></td>
                        <td><span class="pct-badge" style="background: #e8f5e9;">{{ number_format($tranchesft->Taux_Depense, 2, '.', ' ') }}%</span></td>
                        <td class="col-numeric" style="color: #2e7d32; background: #fdfdfd;">{{ number_format($tranchesft->CoutMoyen, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    </tr>
                @endforeach

                <tr class="total-row">
                    <td class="total-label">Totaux Consolidés</td>
                    <td class="total-value">{{ $total_Nombre }}</td>
                    <td class="total-value"><span class="pct-badge" style="background: #2e7d32; color: #fff;">{{ number_format($total_Taux_Eff, 0) }}%</span></td>
                    <td class="col-numeric total-value">{{ number_format($total_Depense_Tranche, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    <td class="total-value"><span class="pct-badge" style="background: #2e7d32; color: #fff;">{{ number_format($total_Taux_Depense, 0) }}%</span></td>
                    <td class="col-numeric total-value">{{ number_format($total_Depense_Tranche / max(1, $total_Nombre), 0, '', ' ') }} <span class="currency">XOF</span></td>
                </tr>
            @else
                <tr>
                    <td colspan="6" style="padding: 40px; color: #95a5a6; font-style: italic;">Aucune donnée disponible pour cette période...</td>
                </tr>
            @endif
        </tbody>
    </table>

    <div class="footer-note">
        Rapport démographique consolidé — Propriété exclusive de Vitalis. Généré le {{ date('d/m/Y à H:i') }}.
    </div>
@endsection