@extends('admin.layout.pdf')

@section('content')
    <style>
        /* Styles globaux pour le PDF */
        body {
            font-family: 'Arial', sans-serif;
            color: #333;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 20px;
        }
        th, td {
            padding: 8px;
            text-align: left;
            border: 1px solid #ddd;
        }
        th {
            background-color: #8ecd8e;
            color: black;
            font-weight: bold;
            text-align: center;
        }
        td.textfraza {
            text-align: right;
            padding-right: 10px;
        }
        tr:nth-child(even) {
            background-color: #f9f9f9;
        }
        tr:hover {
            background-color: #f1f1f1;
        }
        .header-title {
            background-color: #8ecd8e;
            color: black;
            font-size: 24px;
            font-weight: bold;
            padding: 10px 15px;
            border: 1px solid #000;
            text-align: center;
            box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
        }
        .period-label {
            margin-top: 15px;
            padding: 5px;
            font-weight: bold;
            font-size: 16px;
            text-align: center;
            color: #444;
            border-bottom: 1px dashed #8ecd8e;
        }
        .info-section {
            margin-top: 15px;
            font-size: 14px;
            text-align: left;
            color: #555;
            line-height: 1.5;
        }
        .info-section u {
            color: #000;
            font-weight: bold;
        }
        .info-section i {
            font-style: italic;
        }
        .total-row {
            background-color: #8fce8f;
            color: black;
            font-weight: bold;
            text-align: right;
        }
        .no-data {
            text-align: center;
            color: #888;
            font-style: italic;
        }
    </style>

    <table style="margin-top: 30px;">
        <tr>
            <td class="header-title">
                ETAT DES DEPENSES PAR FAMILLE D'ACTES ET PAR PRESTATAIRES
            </td>
        </tr>
    </table>
    <p class="period-label">
        PERIODE COMPTABLE CONSIDEREE: {{ \Carbon\Carbon::parse($dateDebut)->format('d/m/Y') }} AU {{ \Carbon\Carbon::parse($dateFin)->format('d/m/Y') }}
    </p>

    @if (!empty($infos))
        @foreach ($infos as $info)
            <p class="info-section">
                <i>
                    <u>GARANT</u> : {{ $info->garant }}<br><br>
                    <u>POLICE</u> : {{ $info->libellePolice }}<br><br>
                    <u>SOUSCRIPTEUR</u> : {{ $info->souscripteur }}<br><br>
                    <u>COURTIER</u> : {{ $info->courtier }}<br><br>
                    <u>MONTANT SUPERIEUR OU EGAL A :</u> : {{ number_format($idDepense, 0, '', ' ') }} FCFA<br><br>
                </i>
            </p>
        @endforeach
    @else
        <p class="info-section">
            <i>
                @if ($Entetegarant != null)
                    <u>GARANT</u> : {{ $Entetegarant->libelle }}<br><br>
                @endif
                @if ($Entetepolice != null)
                    <u>POLICE</u> : {{ $Entetepolice->libellePolice }}<br><br>
                @endif
                @if ($Entetesouscripteur != null)
                    <u>SOUSCRIPTEUR</u> : {{ $Entetesouscripteur->nom }} {{ $Entetesouscripteur->prenoms }}<br><br>
                @endif
                @if ($Entetecourtier != null) <!-- Correction ici -->
                    <u>COURTIER</u> : {{ $Entetecourtier->libelle }}<br><br>
                @endif
                <u>MONTANT SUPERIEUR OU EGAL A :</u> : {{ number_format($idDepense, 0, '', ' ') }} FCFA<br><br>
            </i>
        </p>
    @endif

    <table class="border">
    <thead>
        <tr>
            <th>Prestataire</th>
            <th>Consultation</th>
            <th>Imagerie</th>
            <th>Biologie</th>
            <th>Dentisterie</th>
            <th>Optique</th>
            <th>Hospitalisation</th>
            <th>Pharmacie</th>
            <th>Maternité</th>
            <th>Autres Examens</th>
            <th>Auxiliaires Médicaux</th>
            <th>Assistance</th>
            <th>Transport Médicalisé</th>
            <th>Bilan de Santé</th>
            <th>Totaux</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 = 50; // Ajuster selon la taille de la page
        @endphp
        @foreach ($p_factures as $p_facture)
            @php
                $total_CONSULTATION += $p_facture->CONSULTATION;
                $total_IMAGERIE += $p_facture->IMAGERIE;
                $total_BIOLOGIE += $p_facture->BIOLOGIE;
                $total_DENTISTERIE += $p_facture->DENTISTERIE;
                $total_OPTIQUE += $p_facture->OPTIQUE; // Corrigé : ajout séparé pour OPTIQUE
                $total_HOSPITALISATION += $p_facture->HOSPITALISATION;
                $total_PHARMACIE += $p_facture->PHARMACIE;
                $total_MATERNITE += $p_facture->MATERNITE;
                $total_AUTRES_EXAMENS += $p_facture->AUTRES_EXAMENS;
                $total_AUXILIAIRES_MEDICAUX += $p_facture->AUXILIAIRES_MEDICAUX;
                $total_ASSISTANCE += $p_facture->ASSISTANCE;
                $total_TRANSPORT_MEDICALISE += $p_facture->TRANSPORT_MEDICALISE;
                $total_BILAN_DE_SANTE += $p_facture->BILAN_DE_SANTE;
                $total_TOTAUX += $p_facture->TOTAUX;
                $rowCount++;
            @endphp
            @if ($rowCount % $rowsPerPage == 0 && $rowCount > 0)
                </tbody>
                </table>
                <div class="break-page"></div>
                <table class="border">
                    <thead>
                        <tr>
                            <th>Prestataire</th>
                            <th>Consultation</th>
                            <th>Imagerie</th>
                            <th>Biologie</th>
                            <th>Dentisterie</th>
                            <th>Optique</th>
                            <th>Hospitalisation</th>
                            <th>Pharmacie</th>
                            <th>Maternité</th>
                            <th>Autres Examens</th>
                            <th>Auxiliaires Médicaux</th>
                            <th>Assistance</th>
                            <th>Transport Médicalisé</th>
                            <th>Bilan de Santé</th>
                            <th>Totaux</th>
                        </tr>
                    </thead>
                    <tbody>
            @endif
            <tr>
                <td style="text-align: left;">{{ $p_facture->Prestataire }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->CONSULTATION, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->IMAGERIE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->BIOLOGIE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->DENTISTERIE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->OPTIQUE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->HOSPITALISATION, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->PHARMACIE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->MATERNITE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->AUTRES_EXAMENS, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->AUXILIAIRES_MEDICAUX, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->ASSISTANCE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->TRANSPORT_MEDICALISE, 0, '', ' ') }}</td>
                <td style="text-align: right;">{{ number_format($p_facture->BILAN_DE_SANTE, 0, '', ' ') }}</td>
                <td style="text-align: right; font-weight: bold;">{{ number_format($p_facture->TOTAUX, 0, '', ' ') }}</td>
            </tr>
        @endforeach
        <tr class="total-row">
            <td style="text-align: left;">TOTAL GÉNÉRAL</td>
            <td style="text-align: right;">{{ number_format($total_CONSULTATION, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_IMAGERIE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_BIOLOGIE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_DENTISTERIE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_OPTIQUE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_HOSPITALISATION, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_PHARMACIE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_MATERNITE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_AUTRES_EXAMENS, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_AUXILIAIRES_MEDICAUX, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_ASSISTANCE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_TRANSPORT_MEDICALISE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_BILAN_DE_SANTE, 0, '', ' ') }}</td>
            <td style="text-align: right;">{{ number_format($total_TOTAUX, 0, '', ' ') }}</td>
        </tr>
    </tbody>
</table>
@endsection