@extends('admin.layout.pdf')

@section('content')
    <style>
        /* ══════════════════════════════════════════════
           MODERN PDF REPORT DESIGN — VITALIS PREMIUM
           V4 : EVOLUTION MENSUELLE (12 MOIS)
           ══════════════════════════════════════════════ */
        
        @page {
            margin: 0.5cm; /* Reduced margin for ultra-wide report */
        }

        body {
            font-family: 'Helvetica', 'Arial', sans-serif;
            color: #2c3e50;
            line-height: 1.2;
            font-size: 7.5px; /* Ultra-small for 15 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: 7px;
            padding: 6px 3px;
            border: 1px solid #ecf0f1;
            border-bottom: 2px solid #8fce8f;
            text-align: center;
            letter-spacing: 0.2px;
        }
        .data-table tbody td {
            padding: 5px 3px;
            border-bottom: 1px solid #ecf0f1;
            border-right: 1px solid #f9f9f9;
            vertical-align: middle;
            text-align: right; /* Default to right for months */
        }
        .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: #bdc3c7;
            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: 8px;
        }
        .total-value {
            color: #1b5e20;
            font-weight: 800;
            background: #e8f5e9;
        }

        .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">Evolution Mensuelle des Dépenses</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">Rapport Analytique — Vue Annuelle</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>

    <!-- Main Data Table -->
    <table class="data-table">
        <thead>
            <tr>
                <th style="width: 6%;">Matricule</th>
                <th style="width: 14%; text-align: left;">Nom et Prénom(s)</th>
                <th style="width: 6%;">Jan.</th>
                <th style="width: 6%;">Fév.</th>
                <th style="width: 6%;">Mar.</th>
                <th style="width: 6%;">Avr.</th>
                <th style="width: 6%;">Mai</th>
                <th style="width: 6%;">Juin</th>
                <th style="width: 6%;">Juil.</th>
                <th style="width: 6%;">Août</th>
                <th style="width: 6%;">Sept.</th>
                <th style="width: 6%;">Oct.</th>
                <th style="width: 6%;">Nov.</th>
                <th style="width: 6%;">Déc.</th>
                <th style="width: 8%; background: #e8f5e9;">TOTAL</th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_JANVIER = 0; $total_FEVRIER = 0; $total_MARS = 0; $total_AVRIL = 0;
                $total_MAI = 0; $total_JUIN = 0; $total_JUILLET = 0; $total_AOUT = 0;
                $total_SEPTEMBRE = 0; $total_OCTOBRE = 0; $total_NOVEMBRE = 0; $total_DECEMBRE = 0;
                $total_TOTAUX = 0;
                $rowCount = 0;
                $rowsPerPage = 45;
            @endphp
            @foreach ($p_factures as $facture)
                @php
                    $total_JANVIER += (float)$facture->JANVIER;
                    $total_FEVRIER += (float)$facture->FEVRIER;
                    $total_MARS += (float)$facture->MARS;
                    $total_AVRIL += (float)$facture->AVRIL;
                    $total_MAI += (float)$facture->MAI;
                    $total_JUIN += (float)$facture->JUIN;
                    $total_JUILLET += (float)$facture->JUILLET;
                    $total_AOUT += (float)$facture->AOUT;
                    $total_SEPTEMBRE += (float)$facture->SEPTEMBRE;
                    $total_OCTOBRE += (float)$facture->OCTOBRE;
                    $total_NOVEMBRE += (float)$facture->NOVEMBRE;
                    $total_DECEMBRE += (float)$facture->DECEMBRE;
                    $total_TOTAUX += (float)$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: 6%;">Matricule</th>
                                <th style="width: 14%; text-align: left;">Nom et Prénom(s)</th>
                                <th>Jan.</th><th>Fév.</th><th>Mar.</th><th>Avr.</th><th>Mai</th><th>Juin</th>
                                <th>Juil.</th><th>Août</th><th>Sept.</th><th>Oct.</th><th>Nov.</th><th>Déc.</th>
                                <th style="width: 8%; background: #e8f5e9;">TOTAL</th>
                            </tr>
                        </thead>
                        <tbody>
                @endif

                <tr>
                    <td class="col-identity" style="text-align: center !important;">{{ $facture->numeroAdherent }}</td>
                    <td class="col-identity">{{ $facture->adherent }}</td>
                    <td class="num-val {{ $facture->JANVIER == 0 ? 'zero-val' : '' }}">{{ number_format($facture->JANVIER, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->FEVRIER == 0 ? 'zero-val' : '' }}">{{ number_format($facture->FEVRIER, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->MARS == 0 ? 'zero-val' : '' }}">{{ number_format($facture->MARS, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->AVRIL == 0 ? 'zero-val' : '' }}">{{ number_format($facture->AVRIL, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->MAI == 0 ? 'zero-val' : '' }}">{{ number_format($facture->MAI, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->JUIN == 0 ? 'zero-val' : '' }}">{{ number_format($facture->JUIN, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->JUILLET == 0 ? 'zero-val' : '' }}">{{ number_format($facture->JUILLET, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->AOUT == 0 ? 'zero-val' : '' }}">{{ number_format($facture->AOUT, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->SEPTEMBRE == 0 ? 'zero-val' : '' }}">{{ number_format($facture->SEPTEMBRE, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->OCTOBRE == 0 ? 'zero-val' : '' }}">{{ number_format($facture->OCTOBRE, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->NOVEMBRE == 0 ? 'zero-val' : '' }}">{{ number_format($facture->NOVEMBRE, 0, '', ' ') }}</td>
                    <td class="num-val {{ $facture->DECEMBRE == 0 ? 'zero-val' : '' }}">{{ number_format($facture->DECEMBRE, 0, '', ' ') }}</td>
                    <td class="num-val" style="font-weight: 800; background: rgba(232, 245, 233, 0.3);">{{ number_format($facture->TOTAUX, 0, '', ' ') }}</td>
                </tr>
            @endforeach

            <tr class="total-row">
                <td colspan="2" class="total-label">TOTAL GÉNÉRAL CONSOLIDÉ</td>
                <td class="num-val total-value">{{ number_format($total_JANVIER, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_FEVRIER, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_MARS, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_AVRIL, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_MAI, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_JUIN, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_JUILLET, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_AOUT, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_SEPTEMBRE, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_OCTOBRE, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_NOVEMBRE, 0, '', ' ') }}</td>
                <td class="num-val total-value">{{ number_format($total_DECEMBRE, 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">
        Évolution annuelle consolidée — Propriété exclusive de Vitalis. Généré le {{ date('d/m/Y à H:i') }}.
    </div>
@endsection