@extends('admin.layout.pdf')


@section('content')
    <table style="margin-top: 30px;">
        <tr >
            <td  class="100p" style=" border: 1px solid #000; color: black; background: #8ecd8e; padding: 5px 15px; font-weight: bold; font-size: 25x; text-align: center;">
                RECAPITULATIF DES DEPENSES PAR TRANCHES D'AGES
            </td>
        </tr>
    </table>
    <p style=" margin-top: 15px; padding: 5px; font-weight: bold; font-size: 16px; text-align: center;">
        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  style=" margin-top: 15px;  font-weight: bold; font-size: 14px; text-align: left;">
            <i>
                <u>GARANT</u> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: {{ $info->garant }} <br><br>
                <u>POLICE</u>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: {{ $info->libellePolice }}  <br><br>
                <u>SOUSCRIPTEUR</u>&nbsp;&nbsp; :  {{ $info->souscripteur }} <br><br>
                <U>COURTIER</U>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:  {{ $info->courtier }}  <br><br>
            </i>
        </p>
        @endforeach
    @else
    <p  style=" margin-top: 15px;  font-weight: bold; font-size: 14px; text-align: left;">
        <i>
            @if ($Entetegarant != null)
            <u>GARANT</u> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: {{ $Entetegarant->libelle}} <br><br>
            @endif
            @if ($Entetepolice != null)
            <u>POLICE</u>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: {{ $Entetepolice->libellePolice}} <br><br>
            @endif
            @if ($Entetesouscripteur != null)
            <u>SOUSCRIPTEUR</u>&nbsp;&nbsp; :  {{ $Entetesouscripteur->nom,' ', $Entetesouscripteur->prenoms}} <br><br>
            @endif
            @if ($Entetepolice != null)
            <U>COURTIER</U>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:  {{ $Entetepolice->libelle}} <br><br>
            @endif
            @if ($EnteteApportteur != null)
            <U>COURTIER</U>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:  {{ $EnteteApportteur->libelle}} <br><br>
            @endif
        </i>
    </p>
    @endif



    {{-- {{ dd($tranchesfts)}} --}}
    <table style="margin-top: 30px;" class="border">
        <thead>
            <tr>
                <th rowspan="2">Tranche d'âge</th>
                <th colspan="2">Effectif sur la période</th>
                <th colspan="2">Dépenses sur la période</th>
                <th rowspan="2">Côut moyen</th>
            </tr>
            <tr>
                <th>Nombre</th>
                <th>Taux</th>
                <th>Montant</th>
                <th>Taux</th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_Nombre 	= 0;
                $total_Taux_Eff				= 0;
                $total_Depense_Tranche 	= 0;
                $total_Taux_Depense = 0;
                $total_coutMoyenTrancheTraite   = 0;
            @endphp
            @foreach ($tranchesfts as $tranchesft)
            @php
                (int)$total_Nombre 				= (int)$total_Nombre + (int)$tranchesft->Nombre;
                (int)$total_Taux_Eff				= (int)$total_Taux_Eff + (int)$tranchesft->Taux_Eff;
                (int)$total_Depense_Tranche 				= (int)$total_Depense_Tranche + (int)$tranchesft->Depense_Tranche;
                (int)$total_Taux_Depense = (int)$total_Taux_Depense +  (int)$tranchesft->Taux_Depense;
                (int)$total_coutMoyenTrancheTraite   = (int)$total_coutMoyenTrancheTraite + (int)$tranchesft->CoutMoyen;
            @endphp

            <tr>
                <td>{{ $tranchesft->libelleTrancheAge }}</td>
                <td style="text-align:  center;">{{ $tranchesft->Nombre }}</td>
                <td style="text-align:  center;"> {{ $tranchesft->Taux_Eff }}</td>
                <td class="textfraza"  style="text-align:  center;">{{ number_format($tranchesft->Depense_Tranche, 0, '', ' ') }} </td>
                <td class="textfraza"  style="text-align:  center;">{{ number_format($tranchesft->Taux_Depense, 0, '', ' ') }} </td>
                <td class="textfraza"  style="text-align:  center;">{{ number_format($tranchesft->CoutMoyen, 0, '', ' ') }}</td>
            </tr>
            @endforeach

             <tr style="color: black; background: #8fce8f; font-weight: bold">
                <td>Total</td>
                <td  style="text-align: center;">{{ $total_Nombre }}</td>
                <td  style="text-align: center;">{{ $total_Taux_Eff }}</td>
                <td class="textfraza" style="text-align:  center;">{{ number_format($total_Depense_Tranche, 0, '', ' ') }}</td>
                <td class="textfraza" style="text-align:  center;" >{{ number_format($total_Taux_Depense, 0, '', ' ')  }} </td>
                <td class="textfraza" style="text-align:  center;">{{ number_format($total_coutMoyenTrancheTraite, 0, '', ' ') }}</td>
            </tr>
        </tbody>
    </table>
    <br>
@endsection