@php
        $sum_before_charge = 0;
        $sum_mvt_debit_charge = 0;
        $sum_mvt_credit_charge = 0;
        $sum_after_charge = 0;

        $sum_before_produit = 0;
        $sum_mvt_debit_produit = 0;
        $sum_mvt_credit_produit = 0;
        $sum_after_produit = 0;

@endphp

@include('compta.pdf.entete')

<div class="title">
    BALANCE GENERALE DE COMPTE AU {{(new DateTime($finPeriode))->format(config('myahs.date_format'))}}
</div>
<div style="width: 100%; text-align:center; font-weight: bold; margin-bottom:2px;">
    PRODUITS
</div>

<table class="table">
    <tr class="head">
        <td class="w-6">COMPTE</td>
        <td>LIBELLE</td>
        <td class="w-36 number">SOLDE DEBUT</td>
        <td class="w-36 number">DEBIT</td>
        <td class="w-36 number">CREDIT</td>
        <td class="w-36 number">SOLDE FIN</td>
    </tr>

    @foreach ($exploitations as $id_compte=>$balance)
        @if(substr($id_compte,0,1) == '7' && $balance->test_ligne > 0)
            @php
                $sum_mvt_debit_produit += $balance->mvt_debit;
                $sum_mvt_credit_produit += $balance->mvt_credit;
                $sum_after_produit += $balance->solde_periode;
            @endphp
            <tr class="items">
                <td>{{$id_compte}}</td>
                <td>{{substr($balance->libelle,0,60)}}</td>
                <td class="number">
                    @php
                        $soldeBefore = key_exists($id_compte, $soldeAnterieurs)?$soldeAnterieurs[$id_compte]:0;
                    @endphp
                    @if($soldeBefore >= 0)
                        {{App\Lib\Format::number($soldeBefore)}}
                    @else
                        <span class="text-red-500 italic">({{App\Lib\Format::number(abs($balance->solde_periode))}})</span>
                    @endif
                </td>
                <td class="number">{{App\Lib\Format::number($balance->mvt_debit)}}</td>
                <td class="number">{{App\Lib\Format::number($balance->mvt_credit)}}</td>
                <td class="number">{{App\Lib\Format::number($balance->solde_periode)}}</td>
            </tr>
        @endif
    @endforeach

    <tr class="foot">
        <td colspan="2">TOTAL PRODUITS</td>
        @php
            $sum_before_produit = $sum_after_produit - $sum_mvt_debit_produit + $sum_mvt_debit_produit;
        @endphp
        <td class="number">{{App\Lib\Format::number($sum_before_produit)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_mvt_debit_produit)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_mvt_credit_produit)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_after_produit)}}</td>
    </tr>

    <tr>
        <td colspan="6"></td>
    </tr>
</table>

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

@include('compta.pdf.entete')

<div class="title">
    BALANCE GENERALE DE COMPTE AU {{(new DateTime($finPeriode))->format(config('myahs.date_format'))}}
</div>
<div style="width: 100%; text-align:center; font-weight: bold; margin-bottom:2px;">
    CHARGES
</div>

<table class="table">
    <tr class="head">
        <td class="w-6">COMPTE</td>
        <td>LIBELLE</td>
        <td class="w-36 number">SOLDE DEBUT</td>
        <td class="w-36 number">DEBIT</td>
        <td class="w-36 number">CREDIT</td>
        <td class="w-36 number">SOLDE FIN</td>
    </tr>

    @foreach ($exploitations as $id_compte=>$balance)
        @if(substr($id_compte,0,1) == '6' && $balance->test_ligne > 0)
        @php
            $sum_mvt_debit_charge += $balance->mvt_debit;
            $sum_mvt_credit_charge += $balance->mvt_credit;
            $sum_after_charge += $balance->solde_periode;
        @endphp
        <tr class="items">
            <td>{{$id_compte}}</td>
            <td>{{substr($balance->libelle,0,60)}}</td>
            <td class="number">
                @php
                    $soldeBefore = key_exists($id_compte, $soldeAnterieurs)?$soldeAnterieurs[$id_compte]:0;
                @endphp
                @if($soldeBefore >= 0)
                    {{App\Lib\Format::number($soldeBefore)}}
                @else
                    <span class="text-red-500 italic">({{App\Lib\Format::number(abs($soldeBefore))}})</span>
                @endif
            </td>
            <td class="number">{{App\Lib\Format::number($balance->mvt_debit)}}</td>
            <td class="number">{{App\Lib\Format::number($balance->mvt_credit)}}</td>
            <td class="number">
                @if($balance->solde_periode >= 0)
                    {{App\Lib\Format::number($balance->solde_periode)}}
                @else
                    <span class="text-red-500 italic">({{App\Lib\Format::number(abs($balance->solde_periode))}})</span>
                @endif
            </td>
        </tr>
        @endif
    @endforeach
    <tr class="foot">
        <td colspan="2">TOTAL CHARGES</td>
        @php
            $sum_before_charge = $sum_after_charge + $sum_mvt_credit_charge - $sum_mvt_debit_charge;
        @endphp
        <td class="number">{{App\Lib\Format::number($sum_before_charge)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_mvt_debit_charge)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_mvt_credit_charge)}}</td>
        <td class="number">{{App\Lib\Format::number($sum_after_charge)}}</td>
    </tr>

    @php
        $resultat_before = $sum_before_produit - $sum_before_charge;
        $resultat_after = $sum_after_produit - $sum_after_charge;
        $variation_debit = $resultat_after > $resultat_before ? $resultat_after - $resultat_before : 0;
        $variation_credit = $resultat_after > $resultat_before ? 0 : $resultat_after - $resultat_before;
    @endphp

    <tr class="foot resultat">
        <td colspan="2">RESULTAT</td>
        <td class="number">{{App\Lib\Format::number($resultat_before)}}</td>
        <td class="number">{{App\Lib\Format::number(abs($variation_debit))}}</td>
        <td class="number">{{App\Lib\Format::number(abs($variation_credit))}}</td>
        <td class="number">{{App\Lib\Format::number($resultat_after)}}</td>
    </tr>

</table>