@php
        $pages = $epargne->pages;
        $nb_page_epargne = $epargne->nb_page;
        $total_solde_before = 0;
        $total_solde_after = 0;
        $total_solde_debit = 0;
        $total_solde_credit = 0;
        $i = 0;
        $p = 0;
    @endphp

    @foreach ($pages as $operations)

        @include('guichet.pdf.entete-journal')
        <div class="title">
            OPERATIONS SUR EPARGNE
        </div>

        @php
            $sous_total_before = 0;
            $sous_total_after = 0;
            $sous_total_debit = 0;
            $sous_total_credit = 0;
            $p++;
        @endphp

        <table class="table table-list">

            <tr>
                <th>N°</th>
                <th>COMPTE</th>
                <th>NOM ET PRENOM</th>
                <th>N° PIECE</th>
                <th style="text-align: right">SOLDE AV</th>
                <th style="text-align: right">RETRAIT</th>
                <th style="text-align: right">DEPOT</th>
                <th style="text-align: right">SOLDE AP</th>
            </tr>

            @foreach ($operations as $operation)

                    @php

                        $solde_before = $operation->solde + $operation->debit - $operation->credit;

                        $total_solde_before += $solde_before;
                        $total_solde_after += $operation->solde;
                        $total_solde_debit += $operation->debit;
                        $total_solde_credit += $operation->credit;

                        $sous_total_before += $solde_before;
                        $sous_total_after += $operation->solde;
                        $sous_total_debit += $operation->debit;
                        $sous_total_credit += $operation->credit;

                        $i++;

                    @endphp



                <tr>
                    <td>{{ $i }}</td>
                    <td style="text-align: left">{{ $operation->compte_id }}</td>
                    <td style="text-align: left">{{ substr($operation->nom_tiers.' '.$operation->prenom_tiers, 0,30) }}</td>
                    <td style="text-align: left">{{ $operation->num_piece }}</td>
                    <td style="text-align: right">{{ number_format($solde_before, 2, ',',' ') }}</td>
                    <td style="text-align: right">{{ number_format($operation->debit, 2, ',',' ') }}</td>
                    <td style="text-align: right">{{ number_format($operation->credit, 2, ',',' ') }}</td>
                    <td style="text-align: right; border-right: 1px solid #999">{{ number_format($operation->solde, 2, ',',' ') }}</td>
                </tr>

            @endforeach

                <tr>
                    <td colspan="4" class="total  total-l">SOUS-TOTAL {{$p}}</td>
                    <td class="total">
                        {{ App\Lib\Format::number($sous_total_before, 2, ',',' ') }}
                    </td>
                    <td class="total">
                        {{ App\Lib\Format::number($sous_total_debit, 2, ',',' ') }}
                    </td>
                    <td class="total">
                        {{ App\Lib\Format::number($sous_total_credit, 2, ',',' ') }}
                    </td>
                    <td class="total total-r">
                        {{ App\Lib\Format::number($sous_total_after, 2, ',',' ') }}
                    </td>
                </tr>

                @if($nb_page_epargne == $p)
                    <tr>
                        <td colspan="4" class="total total-l">TOTAL</td>
                        <td class="total">
                            {{ App\Lib\Format::number($total_solde_before, 2, ',',' ') }}
                        </td>
                        <td class="total">
                            {{ App\Lib\Format::number($total_solde_debit, 2, ',',' ') }}
                        </td>
                        <td class="total">
                            {{ App\Lib\Format::number($total_solde_credit, 2, ',',' ') }}
                        </td>
                        <td class="total total-r">
                            {{ App\Lib\Format::number($total_solde_after, 2, ',',' ') }}
                        </td>
                    </tr>
                @endif

        </table>

        @include('guichet.pdf.footer')

        <div class="paginate">
            {{$p + $page_decompte}} / {{$nb_page_total}}
        </div>

        @if($nb_page_epargne > $p)
            <div class="page-break"></div>
        @endif

    @endforeach

   <div class="page-break"></div>

   @include('guichet.pdf.entete-journal')

   <div class="title">
       RECAPITULATION PAR PRODUIT DES OPERATIONS SUR EPARGNE
   </div>

    <table class="table table-list">

        <tr>
            <th>Code produit</th>
            <th>Sigle</th>
            <th>Libellé</th>
            <th style="text-align: right">Retrait</th>
            <th style="text-align: right">Dépôt</th>
            <th style="text-align: right">Variation</th>
        </tr>

        @php
            $recap_debit = 0;
            $recap_credit = 0;
        @endphp

        @foreach ($epargne->sum_produit as $sum)

            @php
                $recap_debit += $sum->debit;
                $recap_credit += $sum->credit;
            @endphp

            <tr>
                <td>{{$sum->produit_id}}</td>
                <td>{{$sum->sigle}}</td>
                <td>{{$sum->libelle}}</td>
                <td style="text-align: right">{{ App\Lib\Format::number($sum->debit, 2, ',',' ') }}</td>
                <td style="text-align: right">{{ App\Lib\Format::number($sum->credit, 2, ',',' ') }}</td>
                <td style="text-align: right; border-right: 1px solid #999">
                    @if($sum->credit > $sum->debit)
                        {{ App\Lib\Format::number($sum->credit - $sum->debit, 2, ',',' ') }}
                    @else
                        ({{ App\Lib\Format::number(abs($sum->credit - $sum->debit), 2, ',',' ') }})
                    @endif
                </td>
            </tr>
        @endforeach
            <tr>
                <td colspan="3" class="total">TOTAL</td>
                <td class="total">{{ App\Lib\Format::number($recap_debit, 2, ',',' ') }}</td>
                <td class="total">{{ App\Lib\Format::number($recap_credit, 2, ',',' ') }}</td>
                <td class="total total-r">
                    @if($recap_credit > $recap_debit)
                        {{ App\Lib\Format::number($recap_credit - $recap_debit, 2, ',',' ') }}
                    @else
                        ({{ App\Lib\Format::number(abs($recap_credit - $recap_debit), 2, ',',' ') }})
                    @endif
                </td>
            </tr>
    </table>

    @if(!empty($partsocial))
        @if($partsocial->nb_ligne <= 5)

            <div style="margin-top: 20px"></div>

            @include('guichet.pdf.journal-partsocial')

        @endif
    @endif

    <div class="paginate">
        {{$nb_page_epargne + $page_decompte + 1}} / {{$nb_page_total}}
    </div>

    @include('guichet.pdf.footer')