@extends('admin.layout.pdf')

@section('content')
    <style>
        /* ══════════════════════════════════════════════
           MODERN PDF REPORT DESIGN — VITALIS PREMIUM
           V6 : DEPENSES PAR FAMILLE D'ACTES & PRESTATAIRES
           ══════════════════════════════════════════════ */
        
        @page {
            margin: 0.5cm;
        }

        body {
            font-family: 'Helvetica', 'Arial', sans-serif;
            color: #2c3e50;
            line-height: 1.2;
            font-size: 7px; /* Minimal size for 15 dense columns */
        }

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

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

        /* Information Grid */
        .info-grid {
            width: 100%;
            margin-bottom: 15px;
            border-collapse: separate;
            border-spacing: 0 3px;
        }
        .info-label {
            width: 120px;
            color: #7f8c8d;
            font-weight: 700;
            text-transform: uppercase;
            font-size: 7px;
            padding: 3px 8px;
            background: #fdfdfd;
            border-bottom: 1px solid #eee;
        }
        .info-value {
            color: #2c3e50;
            font-weight: 700;
            font-size: 8.5px;
            padding: 3px 8px;
            border-bottom: 1px solid #eee;
        }
        .highlight-value {
            color: #c0392b;
            font-weight: 800;
        }

        /* Main Data Table */
        .data-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 5px;
        }
        .data-table thead th {
            background-color: #f1f3f5;
            color: #2e7d32;
            font-weight: 800;
            text-transform: uppercase;
            font-size: 6px; /* High density header */
            padding: 5px 2px;
            border: 1px solid #ecf0f1;
            border-bottom: 2px solid #8fce8f;
            text-align: center;
            letter-spacing: 0px;
        }
        .data-table tbody td {
            padding: 4px 2px;
            border-bottom: 1px solid #ecf0f1;
            border-right: 1px solid #f9f9f9;
            vertical-align: middle;
            text-align: right;
        }
        .col-identity {
            text-align: left !important;
            font-weight: 700;
            color: #34495e;
            background: #fdfdfd;
        }
        .data-table tbody tr:nth-child(even) {
            background-color: #fbfcfc;
        }

        /* Numerical Style */
        .num-val {
            font-family: 'Courier New', Courier, monospace;
            font-weight: 600;
            color: #2c3e50;
        }
        .zero-val {
            color: #d5dbdb;
            font-weight: 300;
        }

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

        .break-page {
            page-break-before: always;
        }

        .footer-note {
            margin-top: 25px;
            text-align: center;
            font-size: 7px;
            color: #bdc3c7;
            border-top: 1px solid #eee;
            padding-top: 5px;
            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'Actes & Prestataires</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">Analyse Croisée — Performance du Réseau</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];
            }
            // Always show Seuil if defined
            if (isset($idDepense)) $headerItems[] = ['label' => 'Seuil de Filtrage', 'value' => number_format($idDepense, 0, '', ' ').' FCFA'];
        @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['label'] == 'Seuil de Filtrage' ? 'highlight-value' : '' }}">{{ $item['value'] }}</td>
                @endforeach
                @if (count($chunk) == 1)
                    <td class="info-label"></td>
                    <td class="info-value"></td>
                @endif
            </tr>
        @endforeach
    </table>

    <!-- Data Table -->
    <table class="data-table">
    <thead>
        <tr>
            <th style="width: 12%; text-align: left;">Prestataire</th>
            <th style="width: 6%;">Consul.</th>
            <th style="width: 6%;">Imag.</th>
            <th style="width: 6%;">Biol.</th>
            <th style="width: 6%;">Dent.</th>
            <th style="width: 6%;">Opt.</th>
            <th style="width: 6%;">Hospit.</th>
            <th style="width: 6%;">Pharm.</th>
            <th style="width: 6%;">Matern.</th>
            <th style="width: 6%;">Autres</th>
            <th style="width: 6%;">Auxil.</th>
            <th style="width: 6%;">Assist.</th>
            <th style="width: 6%;">Transp.</th>
            <th style="width: 6%;">Bilan</th>
            <th style="width: 8%; background: #e8f5e9;">TOTAL</th>
        </tr>
    </thead>
    <tbody>
        @php
            $total_CONSULTATION = 0; $total_IMAGERIE = 0; $total_BIOLOGIE = 0; $total_DENTISTERIE = 0;
            $total_OPTIQUE = 0; $total_HOSPITALISATION = 0; $total_PHARMACIE = 0; $total_MATERNITE = 0;
            $total_AUTRES_EXAMENS = 0; $total_AUXILIAIRES_MEDICAUX = 0; $total_ASSISTANCE = 0;
            $total_TRANSPORT_MEDICALISE = 0; $total_BILAN_DE_SANTE = 0; $total_TOTAUX = 0;
            $rowCount = 0;
            $rowsPerPage = 45;
        @endphp
        @foreach ($p_factures as $p_facture)
            @php
                $total_CONSULTATION += (float)$p_facture->CONSULTATION;
                $total_IMAGERIE += (float)$p_facture->IMAGERIE;
                $total_BIOLOGIE += (float)$p_facture->BIOLOGIE;
                $total_DENTISTERIE += (float)$p_facture->DENTISTERIE;
                $total_OPTIQUE += (float)$p_facture->OPTIQUE;
                $total_HOSPITALISATION += (float)$p_facture->HOSPITALISATION;
                $total_PHARMACIE += (float)$p_facture->PHARMACIE;
                $total_MATERNITE += (float)$p_facture->MATERNITE;
                $total_AUTRES_EXAMENS += (float)$p_facture->AUTRES_EXAMENS;
                $total_AUXILIAIRES_MEDICAUX += (float)$p_facture->AUXILIAIRES_MEDICAUX;
                $total_ASSISTANCE += (float)$p_facture->ASSISTANCE;
                $total_TRANSPORT_MEDICALISE += (float)$p_facture->TRANSPORT_MEDICALISE;
                $total_BILAN_DE_SANTE += (float)$p_facture->BILAN_DE_SANTE;
                $total_TOTAUX += (float)$p_facture->TOTAUX;
                $rowCount++;
            @endphp
            @if ($rowCount % $rowsPerPage == 0 && $rowCount > 0 && $rowCount < count($p_factures))
                </tbody>
                </table>
                <div class="break-page"></div>
                <table class="data-table">
                    <thead>
                        <tr>
                            <th style="width: 12%; text-align: left;">Prestataire</th>
                            <th>Consul.</th><th>Imag.</th><th>Biol.</th><th>Dent.</th><th>Opt.</th>
                            <th>Hospit.</th><th>Pharm.</th><th>Matern.</th><th>Autres</th><th>Auxil.</th>
                            <th>Assist.</th><th>Transp.</th><th>Bilan</th>
                            <th style="width: 8%; background: #e8f5e9;">TOTAL</th>
                        </tr>
                    </thead>
                    <tbody>
            @endif
            <tr>
                <td class="col-identity">{{ $p_facture->Prestataire }}</td>
                <td class="num-val {{ $p_facture->CONSULTATION == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->CONSULTATION, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->IMAGERIE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->IMAGERIE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->BIOLOGIE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->BIOLOGIE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->DENTISTERIE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->DENTISTERIE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->OPTIQUE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->OPTIQUE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->HOSPITALISATION == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->HOSPITALISATION, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->PHARMACIE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->PHARMACIE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->MATERNITE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->MATERNITE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->AUTRES_EXAMENS == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->AUTRES_EXAMENS, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->AUXILIAIRES_MEDICAUX == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->AUXILIAIRES_MEDICAUX, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->ASSISTANCE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->ASSISTANCE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->TRANSPORT_MEDICALISE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->TRANSPORT_MEDICALISE, 0, '', ' ') }}</td>
                <td class="num-val {{ $p_facture->BILAN_DE_SANTE == 0 ? 'zero-val' : '' }}">{{ number_format($p_facture->BILAN_DE_SANTE, 0, '', ' ') }}</td>
                <td class="num-val" style="font-weight: 800; background: rgba(232, 245, 233, 0.3);">{{ number_format($p_facture->TOTAUX, 0, '', ' ') }}</td>
            </tr>
        @endforeach
        <tr class="total-row">
            <td class="total-label">GÉNÉRAL CONSOLIDÉ</td>
            <td class="num-val total-value">{{ number_format($total_CONSULTATION, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_IMAGERIE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_BIOLOGIE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_DENTISTERIE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_OPTIQUE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_HOSPITALISATION, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_PHARMACIE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_MATERNITE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_AUTRES_EXAMENS, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_AUXILIAIRES_MEDICAUX, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_ASSISTANCE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_TRANSPORT_MEDICALISE, 0, '', ' ') }}</td>
            <td class="num-val total-value">{{ number_format($total_BILAN_DE_SANTE, 0, '', ' ') }}</td>
            <td class="num-val total-value" style="background: #2e7d32; color: #fff;">{{ number_format($total_TOTAUX, 0, '', ' ') }}</td>
        </tr>
    </tbody>
</table>

    <div class="footer-note">
        Matrice analytique multi-critères — Document confidentiel Vitalis. Généré le {{ date('d/m/Y à H:i') }}.
    </div>
@endsection