@extends('layout.template')

@section('title')
    GestStudent@Etat Payement en date du : {{ $dateTransaction }}
@endsection

@section('title2')
    VISUALISER L'ETAT DE PAYEMENT
@endsection

@section('subtitle')
    Scolarité
@endsection

@section('main')
    <div class="page-content container-fluid">

        <div class="white-box">
            <div>
                <h3 class="box-title m-b-0" style="color:#313131; font-weight:bold">Data Export</h3>
                <p class="text-muted m-b-30" style="font-size:14px; color:#8E9EA7">Export data to Copy, CSV, Excel, PDF
                    &amp; Print</p>
            </div>
            <div class="table-responsive">
                <div id="examtable_wrapper" class="dataTables_wrapper">
                    <div style="width:100%">
                        <table class="table table-striped" id="file_export" role="grid"
                            aria-describedby="examtable_info" data-order="[[ 2, &quot;asc&quot; ]]" cellspacing="0"
                            width="100%" role="grid" aria-describedby="examtable_info" style="width: 200%; ">
                            <thead>
                                <tr role="row">
                                    <th style="width: 63px;text-align:center">
                                        N°
                                    </th>
                                    <th style="width: 63px;text-align:center">
                                        Matricule
                                    </th>
                                    <th style="width: 106px;text-align:center" id="paye">
                                        Nom & Prénom
                                    </th>
                                    <th style="width: 86px;text-align:center">
                                        Statut
                                    </th>
                                    <th style="width: 88px;text-align:center">
                                        Niveau
                                    </th>
                                    <th style="width: 88px;text-align:center">
                                        Filière
                                    </th>
                                    <th style="width: 88px;text-align:center">
                                        Période
                                    </th>
                                    <th style="width: 141px;text-align:center">
                                        Solde antérieur
                                    </th>
                                    <th style="width: 72px;text-align:center">
                                        Montant payé
                                    </th>
                                    <th style="width: 61px;text-align:center" id="paye">
                                        Reste à payer
                                    </th>
                                    <th style="text-align: center" id="scol">
                                        Scolarité Totale
                                    </th>
                                    <th style="width: 61px;text-align:center">
                                        Taux de recouvrement(%)
                                    </th>
                                </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                    <th style="text-align:center">
                                        N°
                                    </th>
                                    <th style="text-align:center">
                                        Matricule
                                    </th>
                                    <th style="text-align:center" id="paye">
                                        Nom & Prénom
                                    </th>
                                    <th style="text-align:center">
                                        Statut
                                    </th>
                                    <th style="text-align:center">
                                        Niveau
                                    </th>
                                    <th style="text-align:center">
                                        Filière
                                    </th>
                                    <th style="text-align:center">
                                        Période
                                    </th>
                                    <th style="text-align:center">
                                        Solde antérieur
                                    </th>
                                    <th style="text-align:center">
                                        Montant payé
                                    </th>
                                    <th style="text-align:center" id="paye">
                                        Reste à payer
                                    </th>
                                    <th style="text-align: center" id="scol">
                                        Scolarité Totale
                                    </th>
                                    <th style="text-align:center">
                                        Taux de recouvrement(%)
                                    </th>
                                </tr>
                            </tfoot>
                            <tbody>

                                @php
                                    function myround($value, $places = 0)
                                    {
                                        if ($places < 0) {
                                            $places = 0;
                                        }
                                    
                                        $mult = pow(10, $places);
                                    
                                        $number1 = $value * $mult;
                                        $number2 = intval($number1);
                                        $number3 = $number1 - $number2;
                                    
                                        if ($number3 >= 0.5) {
                                            return ceil($value * $mult) / $mult;
                                        } else {
                                            return floor($value * $mult) / $mult;
                                        }
                                    }
                                    $i = 0;
                                    $totali = 0;
                                    $totalReste = 0;
                                    $totalSco = 0;
                                @endphp
                                @foreach ($inscrits as $inscrit)
                                    @php
                                        $i += 1;
                                        $montDu = 0;
                                        $payer = 0;
                                    @endphp
                                    <tr role="row" class="odd">
                                        <td style="text-align: center">{{ $i }}</td>
                                        <td style="text-align: center">{{ $inscrit->matricule }}</td>
                                        <td style="text-align: ">
                                            {{ $inscrit->nom }} {{ $inscrit->prenom }}
                                        </td>
                                        <td style="text-align: center">
                                            @foreach ($statuts as $statut)
                                                @if ($statut->idStatut == $inscrit->statut)
                                                    {{ $statut->statut }}
                                                @endif
                                            @endforeach
                                        </td>
                                        <td style="text-align: center">
                                            @foreach ($formations as $formation)
                                                @if ($inscrit->niveauFormation == $formation->id)
                                                    {{ $formation->niveauFormation }}{{ $inscrit->annee }}
                                                @endif
                                            @endforeach
                                        </td>
                                        <td style="text-align: center">
                                            @foreach ($filieres as $filiere)
                                                @if ($inscrit->idFiliere == $filiere->idFiliere)
                                                    {{ $filiere->sigleFilieres }}
                                                @endif
                                            @endforeach
                                        </td>
                                        <td style="text-align: center">
                                            @foreach ($academiques as $academique)
                                                @if ($inscrit->annee_acad == $academique->annee_acad)
                                                    {{ $academique->periode }}
                                                @endif
                                            @endforeach
                                        </td>
                                        @foreach ($inscritOld as $old)
                                            @if ($old->matricule == $inscrit->matricule)
                                                @foreach ($montants as $montant)
                                                    @if ($montant->idFiliere == $old->idFiliere && $montant->idStatut == $old->statut && $montant->annee == $old->annee)
                                                        @php
                                                            $scol = $montant->scolarite + $montant->fraisInscription;
                                                            $montDu += $scol - $old->montant;
                                                        @endphp
                                                    @endif
                                                @endforeach
                                            @endif
                                        @endforeach
                                        <td style="text-align: center">{{ $montDu }}</td>
                                        <td style="text-align: center" class="montant">
                                            @php
                                                $payer = $inscrit->montant;
                                            @endphp
                                            {{ $payer }}
                                        </td>
                                        <td style="text-align: center" class="reste">
                                            @foreach ($montants as $montant)
                                                @if (
                                                    $montant->idFiliere == $inscrit->idFiliere &&
                                                        $montant->idStatut == $inscrit->statut &&
                                                        $montant->annee == $inscrit->annee &&
                                                        $montant->periode == $inscrit->annee_acad)
                                                    @php
                                                        $total = $montant->fraisInscription + $montant->scolarite;
                                                    @endphp
                                                @endif
                                            @endforeach
                                            @php
                                                $total += $montDu;
                                                $reste = $total - $payer;
                                            @endphp
                                            {{ $reste }}
                                        </td>
                                        <td style="text-align: center" class="total">{{ $total }}</td>
                                        @php
                                            
                                            $totali += $payer;
                                            $totalReste += $reste;
                                            $totalSco += $total;
                                            if ($total == 0) {
                                                $total = 1;
                                            }
                                        @endphp
                                        <td style="text-align: center" class="taux">
                                            {{ myround(($payer * 100) / $total, 3) }}%</td>
                                    </tr>
                                @endforeach

                                <tr>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center">TOTAL</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totali }}</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totalReste }}</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totalSco }}</td>
                                    @php
                                        if ($totalSco == 0) {
                                            $totalSco = 1;
                                        }
                                        $tauxRecouvrement = myround(($totali / $totalSco) * 100, 3);
                                    @endphp
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $tauxRecouvrement }}%
                                    </td>
                                </tr>
                            </tbody>

                            <tfoot>
                                <tr>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center"></td>
                                    <td style="text-align: center">TOTAL</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totali }}</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totalReste }}</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $totalSco }}</td>
                                    <td style="color: red; font-weight:bold; text-align: center">{{ $tauxRecouvrement }}%
                                    </td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    </div>
    <script type="text/javascript">
        let somme = 0,
            reste = 0,
            total = 0,
            taux = 0;
        for (let i = 0; i < {{ count($inscrits) }}; i++) {
            somme += parseInt(document.getElementsByClassName('montant')[i].textContent)
            reste += parseInt(document.getElementsByClassName('reste')[i].textContent)
            total += parseInt(document.getElementsByClassName('total')[i].textContent)
        }
        // for (let i = 0; i < 2; i++) {
        //     document.getElementsByClassName('pay')[i].innerHTML= somme;
        //     document.getElementsByClassName('rest')[i].innerHTML= reste;
        //     document.getElementsByClassName('tota')[i].innerHTML= total;
        // }
    </script>
@endsection