@extends('admin.layout.pdf')
			

@section('content')
   
    <table class="border-bottom-warning">
        <tr >
            <td  class="100p" style=" border: 1px solid #000; color: black; background: #8fce8f; padding: 5px 15px; font-weight: bold; font-size: 18px; text-align: center;">
            ETAT DES DEPENSES PAR FAMILLE D'ASSURES
            </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
        </i>
    </p> 
    @endif
    
  
    
    <table style="margin-top: 30px;" class="border">
        <thead>
            <tr>
                <th class="10p">Matricule</th>
                <th class="20p">Famille</th>
                <th class="10p">Pop. active</th>
                <th class="10p">Pop traitée</th>
                <th class="10p">Montant Réclamé</th>
                <th class="10p">Montant Remboursé</th>
                <th class="10p">Montant Non Remb.</th>
                <th class="10p">Coût moyen</th>
                {{-- <th class="10p">Taux</th> --}}
            </tr>
        </thead>
        <tbody>
            @php
                $total_popActive = 0;
                $total_popTraite = 0;
                $total_montantReclame = 0;
                $total_montantNonRembourse = 0;
                $total_montantRembourse = 0;
                $total_coutMoyen = 0;
                $total_taux = 0;
            @endphp
            @foreach ($depenses as $dep) {
               
                @php
                    (int)$total_popActive = (int)$total_popActive + ((int)$dep->popActive);
                    (int)$total_popTraite = (int)$total_popTraite + (int)($dep->popTraite);
                    (int)$total_montantReclame = (int)$total_montantReclame+ (int)$dep->montantReclame; 
                    (int)$total_montantNonRembourse = (int)$total_montantNonRembourse+ (int)$dep->montantNonRembourse; 
                    (int)$total_montantRembourse = (int)$total_montantRembourse+ (int)$dep->montantRembourse; 
                    /* (int)$total_taux = (int)$total_taux+ (int)$dep->Taux;  */
                    (int)$total_coutMoyen = (int)$total_coutMoyen + (int)$dep->Coutmoyen; 
                @endphp
                
                <tr>
                    <td style="text-align:  center;">{{ $dep->numeroAdherent }}</td>
                    <td style="text-align: left;">{{ $dep->adherent }}</td>
                    <td style="text-align:  center;">{{ $dep->popActive }}</td>
                    <td style="text-align:  center;">{{ $dep->popTraite }}</td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($dep->montantReclame, 0, '', ' ') }}</td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($dep->montantRembourse, 0, '', ' ') }}</td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($dep->montantNonRembourse, 0, '', ' ') }} </td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($dep->Coutmoyen, 0, '', ' ') }}</td>
                    {{-- <td>{{ $dep->Taux }}</td> --}}
                </tr>	               
            @endforeach     
                <tr style="color: black; background: #8fce8f;font-weight: bold">
                    <td colspan=2 >TOTAL GENERAL  :</td>
                    <td style="text-align:  center;"> {{ $total_popActive }}</td>
                    <td style="text-align:  center;"> {{ $total_popTraite }}</td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($total_montantReclame, 0, '', ' ') }} </td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($total_montantRembourse, 0, '', ' ') }} </td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($total_montantNonRembourse, 0, '', ' ') }} </td>
                    <td class="textfraza" style="text-align:  center;">{{ number_format($total_coutMoyen, 0, '', ' ') }} </td>
                   {{--  <td> {{ $total_taux }}</td> --}}
                </tr>
           
        </tbody>
    </table>

@endsection