@extends('admin.layout.pdf')

@section('content')
    <style>
        /* ══════════════════════════════════════════════
           MODERN PDF REPORT DESIGN — VITALIS PREMIUM
           V3 : DEPENSES PAR FAMILLE D'ASSURES
           ══════════════════════════════════════════════ */
        
        @page {
            margin: 0.8cm;
        }

        body {
            font-family: 'Helvetica', 'Arial', sans-serif;
            color: #2c3e50;
            line-height: 1.4;
            font-size: 9.5px; /* Smaller to fit 8 columns gracefully */
        }

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

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

        /* Information Grid */
        .info-grid {
            width: 100%;
            margin-bottom: 25px;
            border-collapse: separate;
            border-spacing: 0 4px;
        }
        .info-label {
            width: 140px;
            color: #7f8c8d;
            font-weight: 700;
            text-transform: uppercase;
            font-size: 8px;
            padding: 4px 10px;
            background: #fdfdfd;
            border-bottom: 1px solid #eee;
        }
        .info-value {
            color: #2c3e50;
            font-weight: 700;
            font-size: 10px;
            padding: 4px 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: 8px;
            padding: 10px 6px;
            border-bottom: 2px solid #8fce8f;
            text-align: center;
            letter-spacing: 0.3px;
        }
        .data-table tbody td {
            padding: 8px 6px;
            border-bottom: 1px solid #ecf0f1;
            vertical-align: middle;
            text-align: center;
        }
        .family-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;
            white-space: nowrap;
        }
        .currency {
            color: #95a5a6;
            font-size: 7.5px;
            font-weight: normal;
            margin-left: 2px;
        }

        /* Badges & Populations */
        .pop-badge {
            background: rgba(143, 206, 143, 0.15);
            color: #2e7d32;
            padding: 2px 6px;
            border-radius: 4px;
            font-weight: 800;
            font-size: 9.5px;
        }

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

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

    <!-- Header Section -->
    <div class="report-brand-header">
        <div class="report-title-box">
            <h2 class="report-title-text">Dépenses par Famille d'Assurés</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 par Foyer</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($Entetecourtier) && $Entetecourtier) $headerItems[] = ['label' => 'Intermédiaire / Courtier', 'value' => $Entetecourtier->libelle];
                elseif (isset($EnteteApportteur) && $EnteteApportteur) $headerItems[] = ['label' => 'Intermédiaire / Courtier', 'value' => $EnteteApportteur->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 style="width: 10%;">Matricule</th>
                <th style="width: 18%; text-align: left;">Assuré Principal (Famille)</th>
                <th style="width: 9%;">Pop. Active</th>
                <th style="width: 9%;">Pop. Traitée</th>
                <th style="width: 13%; text-align: right;">Montant Réclamé</th>
                <th style="width: 13%; text-align: right;">Montant Remboursé</th>
                <th style="width: 13%; text-align: right;">Non Remboursé</th>
                <th style="width: 15%; text-align: right;">Coût Moyen / Foyer</th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_popActive = 0;
                $total_popTraite = 0;
                $total_montantReclame = 0;
                $total_montantNonRembourse = 0;
                $total_montantRembourse = 0;
                $total_coutMoyen = 0;
            @endphp
            @if(isset($depenses) && count($depenses) > 0)
                @foreach ($depenses as $dep)
                    @php
                        $total_popActive += (int)$dep->popActive;
                        $total_popTraite += (int)$dep->popTraite;
                        $total_montantReclame += (float)$dep->montantReclame;
                        $total_montantNonRembourse += (float)$dep->NonRembourse;
                        $total_montantRembourse += (float)$dep->montantRembourse;
                        $total_coutMoyen += (float)$dep->Coutmoyen;
                    @endphp
                    <tr>
                        <td style="font-weight: bold; color: #7f8c8d;">{{ $dep->numeroAdherent }}</td>
                        <td class="family-label">{{ $dep->adherent }}</td>
                        <td><span class="pop-badge">{{ $dep->popActive }}</span></td>
                        <td><span class="pop-badge" style="background: rgba(46, 125, 50, 0.05);">{{ $dep->popTraite }}</span></td>
                        <td class="col-numeric">{{ number_format($dep->montantReclame, 0, '', ' ') }} <span class="currency">XOF</span></td>
                        <td class="col-numeric" style="color: #2e7d32;">{{ number_format($dep->montantRembourse, 0, '', ' ') }} <span class="currency">XOF</span></td>
                        <td class="col-numeric" style="color: #c0392b;">{{ number_format($dep->NonRembourse, 0, '', ' ') }} <span class="currency">XOF</span></td>
                        <td class="col-numeric" style="background: #fdfdfd;">{{ number_format($dep->Coutmoyen, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    </tr>
                @endforeach

                <tr class="total-row">
                    <td colspan="2" class="total-label">Totaux Consolidés</td>
                    <td class="total-value">{{ $total_popActive }}</td>
                    <td class="total-value">{{ $total_popTraite }}</td>
                    <td class="col-numeric total-value">{{ number_format($total_montantReclame, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    <td class="col-numeric total-value" style="color: #1b5e20;">{{ number_format($total_montantRembourse, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    <td class="col-numeric total-value" style="color: #641e16;">{{ number_format($total_montantNonRembourse, 0, '', ' ') }} <span class="currency">XOF</span></td>
                    <td class="col-numeric total-value">{{ number_format($total_montantRembourse / max(1, $total_popTraite), 0, '', ' ') }} <span class="currency">XOF</span></td>
                </tr>
            @else
                <tr>
                    <td colspan="8" class="no-data">Aucune donnée de consommation familiale trouvée...</td>
                </tr>
            @endif
        </tbody>
    </table>

    <div class="footer-note">
        Analyse de morbidité et de consommation par foyer — Propriété de Vitalis. Généré le {{ date('d/m/Y à H:i') }}.
    </div>
@endsection