@extends('layout.template')

@section('title', 'GestStudent')

@section('title2')
    VISUALISER LES MOUVEMENTS
@endsection

@section('subtitle')
    Mouvement
@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="margin-top:15px;width:100%">
                        <table class="table table-striped" id="file_export" role="grid"
                            aria-describedby="examtable_info" data-order="[[ 1, &quot;asc&quot; ]]" cellspacing="0"
                            style="width: 200%; margin-top:15px">
                            <thead>
                                <tr role="row">
                                    <th style="width:; text-align:center">
                                        Matricule
                                    </th>
                                    <th style="width:; text-align:center">
                                        Nom & Prénom
                                    </th>
                                    <th style="width:; text-align:center">
                                        Niv/Filière
                                    </th>
                                    <th style="width:; text-align:center">
                                        Période
                                    </th>
                                    <th style="width: ; text-align:center">
                                        Date transaction
                                    </th>
                                    <th style="width:; text-align:center">
                                        Réf transaction
                                    </th>
                                    <th style="width:; text-align:center">
                                        Réf inter
                                    </th>
                                    <th style="width:; text-align:center">
                                        Montant
                                    </th>
                                    <th style="width:; text-align:center">
                                        Reçu Bank
                                    </th>
                                    <th style="width: 5%; text-align:center">
                                        Type opération
                                    </th>
                                    <th style="width:; text-align:center">
                                        Statut opération
                                    </th>
                                    <th style="width:; text-align:center">
                                        Statut MECeF
                                    </th>
                                    <th style="width:; text-align:center">
                                        Date validation
                                    </th>
                                    <th style="width:; text-align:center">
                                        Téléphone
                                    </th>
                                    <th style="width: ; text-align:center" class="js-not-exportable">
                                        Actions
                                    </th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th style="text-align:center">Matricule</th>
                                    <th style="text-align:center">Nom & Prénom</th>
                                    <th style="text-align:center">Niv/Filière</th>
                                    <th style="text-align:center">Période</th>
                                    <th style="text-align:center">Date transation</th>
                                    <th style="text-align:center">Réf transaction</th>
                                    <th style="text-align:center">Réf inter</th>
                                    <th style="text-align:center">Montant</th>
                                    <th style="text-align:center">Reçu Bank</th>
                                    <th style="text-align:center">Type opération</th>
                                    <th style="text-align:center">Statut opération</th>
                                    <th style="text-align:center">Statut MECeF</th>
                                    <th style="text-align:center">Date validation</th>
                                    <th style="text-align:center">Téléphone</th>
                                    <th style="text-align:center">Action</th>
                                </tr>
                            </tfoot>

                                                        
                            <tbody>

                                @foreach ($factures as $facture)
                                    @php
                                        $dis = '';
                                        $phone = $facture->adresse;
                                        $nom = $facture->nom;
                                        $prenom = $facture->prenom;
                                        if ($facture->typeOperation != 'DIRECT') {
                                            $tel = $facture->msisdn;
                                        }
                                        if ($facture->statutOperation == 0) {
                                            //Si l'opération a réussie....
    if ($facture->typefacture == 'FV') {
                                                $cumul += $facture->montant;
                                            } else {
                                                $cumul -= $facture->montant;
                                            }
                                        }
                                    @endphp

                                    <tr role="row" class="odd">

                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank" id="mat">{{ $facture->matricule }}</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $nom }} {{ $prenom }}</a>
                                        </td>
                                        <td align="center">
                                            @foreach ($formations as $formation)
                                                @if ($facture->niveau == $formation->id)
                                                    <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                        target="_blank">{{ $formation->niveauFormation }}{{ $facture->annee }}/
                                                @endif
                                            @endforeach
                                            @foreach ($filieres as $filiere)
                                                @if ($facture->idFiliere == $filiere->idFiliere)
                                                    {{ $filiere->sigleFilieres }}</a>
                                                @endif
                                            @endforeach
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ intval($facture->annee_acad) - 1 }}-{{ $facture->annee_acad }}</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->dateTransaction }}</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->refFacture }}</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->refInternationale }}</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->montant }}[{{ $facture->typefacture }}]</a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank"><img
                                                    src="{{ config('app.aws_url') . $facture->recubank }}"
                                                    alt="Reçu bank" height="60" width="60"></a>
                                        </td>
                                        <td align="center">
                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->typeOperation }}</a>
                                        </td>
                                        <td align="center">

                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">
                                                @if ($facture->statutOperation == 0)
                                                    Succès
                                                @else
                                                    @if ($facture->statutOperation == 1)
                                                        @php
                                                            $dis = 'dis';
                                                            $lien = '<a href="https://e-services.geststudent.net/statutoperation.php?uid=' . $facture->uidmomo . '" target = "_blank" title="Vérifier le statut de la transaction!"><button type="button"  class="btn btn-info btn-outline btn-circle btn-lg m-r-5 modifier" data-toggle="modal" data-target="#update-domiane"><i class="glyphicon glyphicon-cog"></i></button>';
                                                        @endphp
                                                        En attente
                                                    @else
                                                        @php
                                                            $dis = 'dis';
                                                        @endphp
                                                        Echec
                                                    @endif
                                                @endif
                                            </a>
                                        </td>
                                        <td align="center">

                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->statutMecef }} </a>
                                            @if ($facture->statutOperation == 1)
                                                {{ $lien }}
                                            @endif

                                        </td>
                                        <td align="center">

                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $facture->dateValidation }}</a>
                                        </td>
                                        <td align="center">

                                            <a href="{{ route('show.recu', ['name' => $nom . '&nbsp;&nbsp;' . $prenom, 'file' => $facture->recubank]) }}"
                                                target="_blank">{{ $phone }}</a>

                                        </td>
                                        <td align="center" style="color:red">
                                            <div style="display:none">
                                                <template id="info{{ $counter }}">
                                                    <swal-title>
                                                        Confirmer la génération de la facture d'avoir
                                                    </swal-title>
                                                    <swal-html>
                                                        <form class="form-material"
                                                            style="display: block; overflow-x: hidden;" method="post"
                                                            action="{{ route('down.mvt.avoir') }}">
                                                            @csrf()
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="matricule">
                                                                    Matricule:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $facture->matricule }}" readonly
                                                                        id="matricule" name="matricule"
                                                                        style="font-size:15px !important">
                                                                </div>
                                                            </div>

                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="nom">Nom:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $nom }}" readonly
                                                                        id="nom" name="nom"
                                                                        style="font-size:15px !important">

                                                                </div>
                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="prenom">Prénom:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $prenom }}" readonly
                                                                        id="prenom" name="prenom"
                                                                        style="font-size:15px !important">
                                                                </div>

                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="refFacture">refFacture:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text" id="refFacture"
                                                                        name="refFacture" class="form-control fs-5"
                                                                        placeholder="" value="{{ $facture->refFacture }}"
                                                                        style="font-size:15px !important" readonly>
                                                                </div>

                                                            </div>

                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="refInter">refInter:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control fs-5" placeholder=""
                                                                        id="refInter" name="refInter"
                                                                        value="{{ $facture->refInternationale }}"
                                                                        style="font-size:15px !important" readonly>
                                                                </div>

                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">

                                                                <label class="col-sm-5 mt-2 fs-5" for="refAvoir"
                                                                    class=" col-form-label fw-bold">refAvoir:</label>

                                                                <div class="col-sm-5 mt-2 fs-5  input-modal">
                                                                    <div class="input-group">
                                                                        <input type="text" class="form-control fs-5"
                                                                            id="refAvoir" name="refAvoir"
                                                                            style="font-size:15px !important" readonly>
                                                                        <button class="btn btn-danger" type="button"
                                                                            onclick="gen()"
                                                                            style="width:100%;max-width:79px;height:47px;margin-top:-9px">Générer</button>
                                                                    </div>
                                                                </div>

                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5"
                                                                    for="montant"class=" col-form-label fw-bold">Montant:</label>
                                                                <input id="montant" type="number" step="any"
                                                                    min="0" name="montant"
                                                                    value="{{ $facture->montant }}"
                                                                    class="form-control2 required"
                                                                    style="width:100% !important;border-left:none;border-right:none;margin-right:45px; font-size:15px !important">
                                                            </div>
                                                            <button type="submit"
                                                                class="swal2-confirm swal2-styled swal2-default-outline"
                                                                aria-label=""
                                                                style="display: inline-block; background-color: red;">Imprimer
                                                                PDF</button>
                                                            <button type="button" class="swal2-cancel swal2-styled"
                                                                aria-label="" style="display: inline-block;"
                                                                onclick="Swal.close();">Close</button>
                                                        </form>
                                                    </swal-html>
                                                    <swal-param name="showConfirmButton" value="false" />
                                                    <swal-param name="allowEscapeKey" value="true" />
                                                    <swal-param name="customClass" value='{ "popup": "my-popup" }' />
                                                </template>


                                                <template id="temp{{ $count }}">
                                                    <swal-title>
                                                        Confirmer l'impression
                                                    </swal-title>
                                                    <swal-html>
                                                        <form class="form-material"
                                                            style="display: block; overflow-x: hidden;" method="post"
                                                            action="{{ route('down.mvt.impress') }}">
                                                            @csrf()
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="matricule">
                                                                    Matricule:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $facture->matricule }}"
                                                                        style="font-size:15px !important" readonly
                                                                        id="matricule" name="matricule">
                                                                </div>
                                                            </div>

                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="nom">Nom:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $nom }}" readonly
                                                                        id="nom" name="nom"
                                                                        style="font-size:15px !important">
                                                                </div>
                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="prenom">Prénom:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control form-control-line fs-5"
                                                                        value="{{ $prenom }}" readonly
                                                                        id="prenom" name="prenom"
                                                                        style="font-size:15px !important">
                                                                </div>
                                                            </div>
                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="refFacture">refFacture:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="email" id="refFacture"
                                                                        name="refFacture" class="form-control fs-5"
                                                                        value="{{ $facture->refFacture }}" readonly
                                                                        style="font-size:15px !important">
                                                                </div>

                                                            </div>

                                                            <div class="row" style="margin-right:-60px;text-align:end">
                                                                <label class="col-sm-5 mt-2 fs-5" style=""
                                                                    for="refInter">refInter:</label>
                                                                <div class="col-sm-5">
                                                                    <input required type="text"
                                                                        class="form-control fs-5" placeholder="number"
                                                                        id="refInter" name="refInter"
                                                                        value="{{ $facture->refInternationale }}"
                                                                        style="font-size:15px !important">
                                                                </div>
                                                            </div>
                                                            <button type="submit"
                                                                class="swal2-confirm swal2-styled swal2-default-outline"
                                                                aria-label=""
                                                                style="display: inline-block; background-color: red;">Imprimer
                                                                PDF
                                                            </button>
                                                            <button type="button" class="swal2-cancel swal2-styled"
                                                                aria-label="" style="display: inline-block;"
                                                                onclick="Swal.close();">Close</button>
                                                        </form>
                                                    </swal-html>
                                                    <swal-param name="showConfirmButton" value="false" />
                                                    <swal-param name="allowEscapeKey" value="true" />
                                                    <swal-param name="customClass" value='{ "popup": "my-popup" }' />
                                                </template>
                                            </div>
                                            <div class="edit"><button data-swal-template="#info{{ $counter }}"
                                                    onclick="other()" type="button"
                                                    class="btn btn-outline-danger btn-circle btn-lg me-2"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom"
                                                    title="Générer une Facture d'Avoir"
                                                    @if ($facture->typefacture == 'FA' || $dis == 'dis') disabled @endif><i
                                                        class="far fa-edit"
                                                        color="{{ Session::get('couleurText1') }}"></i></button></div>
                                            <div class="edit2"><button data-swal-template="#temp{{ $count }}"
                                                    onclick="impress()" type="button"
                                                    class="btn btn-outline-danger btn-circle btn-lg m-r-5"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom"
                                                    title="Imprimer une Facture"><i class="icon-printer"></i></button>
                                            </div>
                                        </td>
                                    </tr>

                                                                                                        @endforeach
                                <tr>
                                    <td align=center></td>
                                    <td align=center></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td align=center>TOTAL TRANSACTION</td>
                                    <td></td>
                                    <td></td>
                                    <td align=center>
                                        <font color=red><b>{{ $cumul }}</b></font>
                                    </td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                </tr>
                            </tbody>
                            <tfoot>
                                <tr>
                                    <td align=center></td>
                                    <td align=center></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td align=center>TOTAL TRANSACTION</td>
                                    <td></td>
                                    <td></td>
                                    <td align=center>
                                        <font color=red><b>{{ $cumul }}</b></font>
                                    </td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                    <td align=center>
                                        <font color=red><b></b></font< /td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

        </div>
    </div>

@endsection

@section('script')

    <script>
        var other = function() {
            Swal.bindClickHandler();
        }

        $(() => {
            console.log(document.getElementById('avoir'))
        })
        $('#avoir').click(() => {
            console.log('gdgdgdg');
        })
        var gen = function() {

            const computerchoices = '123456789';
            let n = computerchoices.length;
            let conv = document.querySelector('#refAvoir');
            let pass = '';

            for (var i = 0; i < 9; i++) {
                let computerchoice = computerchoices[Math.floor(Math.random() * n)];
                pass += computerchoice;
            }

            conv.value = `${pass}`;
        };


        var impress = function() {

            Swal.bindClickHandler();

        };
    </script>
@endsection