@php
    $user_id = $item->usr_id;
    $image = $item->usr_img;
    $name = $item->usr_name;
    $firstname = $item->usr_prenom;
    $lastname = $item->usr_nom;
    $birth = $item->usr_birth;
    $birth_address = $item->usr_birth_adresse;
    $sexe = $item->usr_sexe;
    $phone = $item->usr_phone;
    $phone_urgence = $item->usr_phone_urgence;
    $region = isset($item->region) ? $item->region->reg_name : "";
    $departement = isset($item->departement) ? $item->departement->dp_name : "";
    $arrondissement = isset($item->arrondissement) ? $item->arrondissement->arr_name : "";
    $address = $item->usr_adresse;
    $doc = $item->usr_doc_name;
    $doc_id = $item->usr_doc_id;
    $date_deliv = $item->date_deliv;
    $date_exp = $item->date_exp;
    $lieu_deliv = $item->lieu_deliv;
    $admin = isset($item->admin) ? $item->admin->ad_name : "";
    $status = $item->usr_status;
    $cni_recto = $item->usr_lien_recto;
    $cni_verso = $item->usr_lien_verso;
    $signature = $item->usr_lien_signature;
    $profession = $item->usr_profession;
    $nationality = mb_strtoupper($item->usr_nationality);
    $status_mat = $item->usr_matrimoniale;
    $date_reg = $item->date_reg;
    $code = $item->usr_qrcode;
    $short_number = $item->usr_nb_court;
    // $intitule_name = isset($item->intitule) ? $item->intitule->int_name : "";
    $name_parent = $item->name_parent;
    $gender_parent = $item->civility_parent;
    $address_parent = $item->usr_adresse;
    $img_parent = $item->img_parent;

    $date_reg_format = \Carbon\Carbon::parse($date_reg)->translatedFormat('d/m/Y');

    $birth_format = DateTime::createFromFormat('d/m/Y', $birth);
    $date_deliv_format = DateTime::createFromFormat('d/m/Y', $date_deliv);
    $date_exp_format = DateTime::createFromFormat('d/m/Y', $date_exp);

    if ($birth_format !== false) {
        $birth_format = $birth_format->format('Y-m-d');
    } else {
        $birth_format = now();
    }
    //dd($birth_format);

    $all_pensions = 0;
    $all_reductions = 0;
    $cur = "XAF";
    $isFirst = true;
    $getClassName = getClassNameSchool($user_id);
    $subscription = $item->subscription ?? null;
    $pension = !is_null($subscription) ? getDataPension($subscription->inscrip_id) : null;
@endphp
@extends('master.master_back')
@section('title')
    Details des informations de {{ $name }}
@endsection

@section('title-two')
    Details des informations de {{ $name }}
@endsection
@section('content')
<div class="container-xxl flex-grow-1 container-p-y">
    <div class="row page-titles mx-0">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ route('get.backend.dashboard') }}">Dashboard</a></li>
            <li class="breadcrumb-item"><a href="{{ route('get.backend.list.student') }}">Liste des Elèves</a></li>
            <li class="breadcrumb-item active"><a href="javascript:void(0)">Details des informations de {{ $name }} </a></li>
        </ol>
    </div>
    <!-- row -->
    <div class="row">
        <div class="col-12">
            <div class="card mb-4">
                <div class="user-profile-header d-flex flex-column flex-sm-row text-sm-start text-center mb-4">
                    <div class="flex-shrink-0 mt-n2 mx-sm-0 mx-auto">
                        @if ($image == "")
                            <img src="{{ asset('user.png') }}" class="d-block h-auto ms-0 ms-sm-4 rounded user-profile-img" alt="{{ $name }}" style="width: 150px !important;height: 160px !important;margin-top:1.5rem;">
                        @else
                            <img src="{{ asset($image) }}" class="d-block h-auto ms-0 ms-sm-4 rounded user-profile-img" alt="{{ $name }}" style="width: 150px !important;height: 160px !important;margin-top:1.5rem;">
                        @endif
                    </div>
                    <div class="flex-grow-1 mt-3 mt-sm-5">
                        <div class="d-flex align-items-md-end align-items-sm-start align-items-center justify-content-md-between justify-content-start mx-4 flex-md-row flex-column gap-4">
                            <div class="user-profile-info">
                                <h4>{{ $name }}</h4>
                                <ul class="list-inline mb-0 d-flex align-items-center flex-wrap justify-content-sm-start justify-content-center gap-2">
                                    <li class="list-inline-item fw-medium">
                                        {{ $sexe }}
                                    </li>
                                    <li class="list-inline-item fw-medium">
                                        {{ $birth }}
                                    </li>
                                    <li class="list-inline-item fw-medium">
                                        {{ $address }}
                                    </li>
                                </ul>
                            </div>
                            <a href="javascript:void(0)" class="btn btn-primary text-nowrap">
                                <i class='bx bx-user-check me-1'></i>
                                {{ $getClassName }}
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-xl-12">
            <div class="card h-auto">
                <div class="card-body">
                    <div class="profile-tab">
                        <div class="custom-tab-1">
                            <ul class="nav nav-tabs">

                                <li class="nav-item"><a href="#infos" data-bs-toggle="tab" class="nav-link active show">Informations</a>
                                </li>
                                <li class="nav-item"><a href="#edit-infos" data-bs-toggle="tab" class="nav-link">Modifier les Informations</a>
                                </li>
                                <li class="nav-item"><a href="#subscribes" data-bs-toggle="tab" class="nav-link">Inscriptions</a>
                                </li>
                                <li class="nav-item"><a href="#Reductions" data-bs-toggle="tab" class="nav-link">Reductions</a>
                                </li>
                            </ul>
                            <div class="tab-content">
                                <div id="infos" class="tab-pane fade active show">
                                    <div class="profile-personal-info pt-4">
                                        <h3 class="text-primary mb-4">Details des Informations</h3>
                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Sexe <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $sexe }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Nom Complet <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $name }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">No <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $short_number }}</span>
                                                    </div>
                                                </div>

                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Date de Naiss... <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $birth }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Lieu de Naiss... <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7">
                                                        <span>
                                                            {{ $birth_address }}
                                                        </span>
                                                    </div>
                                                </div>
                                               
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Adresse <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $address }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Document <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $doc }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">N° Document<span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $doc_id }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Statut <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7">
                                                        @if ($status == 1)
                                                        <span class="badge bg-label-success">
                                                            Active
                                                        </span>
                                                        @elseif($status == 0)
                                                        <span class="badge bg-label--danger">
                                                            Inactive
                                                        </span>
                                                        @elseif($status == 2)
                                                        <span class="badge bg-label-danger">
                                                            Rejete
                                                        </span>
                                                        @endif
                                                    </div>
                                                </div>

                                            </div>
                                            <div class="col-md-6">
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Nom du Parent <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $name_parent }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">N° Téléphone <span class="pull-end">:</span>
                                                        </h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $phone }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">N° Téléphone d'urgence <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $phone_urgence }}</span>
                                                    </div>
                                                </div>
                                                <div class="row mb-2">
                                                    <div class="col-sm-3 col-5">
                                                        <h5 class="f-w-500">Profession <span class="pull-end">:</span></h5>
                                                    </div>
                                                    <div class="col-sm-9 col-7"><span>{{ $profession }}</span>
                                                    </div>
                                                </div>
                                               
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div id="edit-infos" class="tab-pane fade">
                                    <div class="pt-4">
                                        <div class="settings-form">
                                            <h3 class="text-primary mb-4">Modification des Informations</h3>
                                            <form id="edit_client" method="post" action="{{ route('post.backend.edit.student', $item->usr_id) }}" onsubmit="SendDataAnimation(event,'edit_client')">
                                                <div class="row">
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Sexe</label>
                                                        <select class="form-control text-uppercase default-select wide" id="inputState" name="sexe">
                                                            <option value="MASCULIN" {{ $sexe == "MASCULIN" ? "selected" : "" }}>MASCULIN</option>
                                                            <option value="FEMININ" {{ $sexe == "FEMININ" ? "selected" : "" }}>FEMININ</option>
                                                        </select>
                                                    </div>
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Nom</label>
                                                        <input type="text" placeholder="Nom" name="lastname" value="{{ $lastname }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Prenom</label>
                                                        <input type="text" name="firstname" value="{{ $firstname }}" placeholder="Prenom" class="form-control text-uppercase">
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Date de naissance</label>
                                                        <input type="date" name="birth" value="{{ $birth_format }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Lieu de Naissance</label>
                                                        <input type="text" placeholder="Lieu de Naissance" name="place_birth" value="{{ $birth_address }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-4">
                                                        <label class="form-label">Adresse</label>
                                                        <input type="text" name="address" value="{{ $address }}" placeholder="Ngousso" class="form-control text-uppercase">
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">Document</label>
                                                        <select class="form-control text-uppercase default-select wide" id="doc" name="document">
                                                            <option {{ $doc == "ACTE DE NAISSANCE" ? "selected" : "" }}>ACTE DE NAISSANCE</option>
                                                            <option {{ $doc == "CARTE D'IDENTITE" ? "selected" : "" }}>CARTE D'IDENTITE</option>
                                                            <option {{ $doc == "RECEPISSE" ? "selected" : "" }}>RECEPISSE</option>
                                                            <option {{ $doc == "PASSEPORT" ? "selected" : "" }}>PASSEPORT</option>
                                                        </select>
                                                    </div>
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">N° Document</label>
                                                        <input type="text" name="document_id" id="document_id" value="{{ $doc_id }}" class="form-control text-uppercase">
                                                    </div>
                                                   
                                                </div>
                                                <div class="row">
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">Nom du parent</label>
                                                        <input type="text" name="name_parent" value="{{ $name_parent }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">N° Téléphone</label>
                                                        <input type="text" name="phone" id="phone" value="{{ $phone }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">N° Téléphone d'Urgence</label>
                                                        <input type="text" name="phone_urgence" id="phone_urgence" value="{{ $phone_urgence }}" class="form-control text-uppercase">
                                                    </div>
                                                    <div class="mb-3 col-md-6">
                                                        <label class="form-label">Profession</label>
                                                        <input type="text" name="profession" id="profession" value="{{ $profession }}" class="form-control text-uppercase">
                                                    </div>
                                                    {{-- <div class="mb-3 col-md-4">
                                                        <label class="form-label">Nationalité</label>
                                                        <select name="country" id="countrySelect" class="form-control text-uppercase wide mh-auto select2" data-country="{{ $nationality }}">
                                                        </select>
                                                    </div> --}}
                                                </div>
                                                <div class="mb-3">
                                                    <div class="form-check custom-checkbox">
                                                        <input type="checkbox" class="form-check-input" name="accept" id="gridCheck" autocomplete="off">
                                                        <label class="form-check-label form-label" for="gridCheck"> Accepter Vous de modifier les informations ci-dessus</label>
                                                    </div>
                                                </div>
                                                <button class="btn btn-primary btn-sm" type="submit">
                                                    Valider
                                                </button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                                <div id="subscribes" class="tab-pane fade">
                                    <div class="my-post-content pt-4">
                                        <h3 class="text-primary mb-4">Inscriptions</h3>
                                        <div class="row">
                                            @if (isset($item->subscriptions))
                                            @if (count($item->subscriptions) > 0)
                                                @foreach ($item->subscriptions as $value)
                                                @php
                                                    $subscription_id = $value->inscrip_id;
                                                    $class = isset($value->classSchool) ? $value->classSchool->class_name : "";
                                                    $class_pension = isset($value->classSchool) ? $value->classSchool->class_pension : "";
                                                    $pensions = isset($value->pensions) ? $value->pensions : [];
                                                    $sum_pensions = isset($value->pensions) ? $value->pensions->sum('pen_montant') : 0;
                                                    $all_pensions += $sum_pensions;
                                                    $tranche = $value->tranche_status;
                                                    $date = $value->inscrip_date;
                                                    $year = $value->inscrip_annee;
                                                    $status = 0;
                                                    $date_format = \Carbon\Carbon::parse($date)->translatedFormat('d/m/Y');
                                                    if(!is_null($sum_pensions)){
                                                        if($class_pension == $sum_pensions){
                                                            $status = 1;
                                                        }else{
                                                            $status = 0;
                                                        }
                                                    }
                                                @endphp
                                                <div class="col-md-3 mb-3">
                                                    <div class="card border-rounded p-2" style="background: #eceef1 !important">
                                                        @if($isFirst)
                                                        <h6 class="my-1">
                                                            Classe Actuelle: {{ $class }}
                                                            <i class='bx bx-user-check me-1 text-success'></i>
                                                        </h6>
                                                        @php
                                                            $isFirst = false;
                                                        @endphp
                                                        @else
                                                        <h6 class="my-1">Classe : {{ $class }}</h6>
                                                        @endif
                                                        <h6 class="my-1">Session : {{ $year }}</h6>
                                                        <h6 class="my-1">Montant pension : {{ convert_amount_v2($class_pension) }} {{ $cur }}</h6>
                                                        <h6 class="my-1">Pension Soldé ? :
                                                            @if ($status == 1)
                                                                <span class="badge bg-label-success">
                                                                    OUI
                                                                </span>
                                                                @else
                                                                <span class="badge bg-label-danger">
                                                                    NON
                                                                </span>
                                                            @endif
                                                        </h6>
                                                        <h6 class="mt-2">Pension Total: {{ convert_amount_v2($sum_pensions) }} {{ $cur }}</h6>
                                                        <a data-bs-toggle="modal" data-bs-target="#modal_details_subscribe{{ $subscription_id }}" href="javascript:void(0);"
                                                            class="badge bg-label-primary w-auto my-3 p-3">
                                                            {{ "Détails pensions" }}
                                                        </a>
                                                    </div>
                                                </div>
                                                <div class="modal fade" id="modal_details_subscribe{{ $subscription_id }}">
                                                    <div class="modal-dialog modal-dialog-centered" role="document">
                                                        <div class="modal-content">
                                                            <div class="modal-header">
                                                                <h5 class="modal-title">{{ $class }}</h5>
                                                                <button type="button" class="btn-close" data-bs-dismiss="modal">
                                                                </button>
                                                            </div>
                                                            <div class="modal-body">
                                                                <ul class="list-group mb-3">
                                                                    <h5>Details</h5>
                                                                    @php
                                                                        $sum = 0;
                                                                        $residual = 0;
                                                                    @endphp
                                                                    @if(isset($pension))
                                                                        @if (!is_null($pension))
                                                                        @foreach ($pension as $pen)
                                                                        @php
                                                                            $no = "";
                                                                            $tranche = $pen->mvt_tranche;
                                                                            $message = fetchResponseByValue($tranche);
                                                                            $pensionAmount = getPensionClassSchool($pen->inscrip_id);
                                                                            $amount = $pen->pen_montant;
                                                                            $sum += $amount;
                                                                            $residual = $pensionAmount - $sum;
                                                                            $rdv = $pen->pen_rdv;
                                                                            $date = $pen->pen_date;
                                                                            $admin = $pen->admin->ad_name ?? null;
                                                                            $date_format = \Carbon\Carbon::parse($date)->translatedFormat('d/m/Y');
                                                                            $date_rdv = \Carbon\Carbon::parse($rdv)->translatedFormat('d/m/Y');
                                                                        @endphp
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Tranche</h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ $message }} </span>
                                                                        </li>
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Pension</h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ convert_amount_v2($amount) }}</span>
                                                                        </li>
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Prochaine Rendez Vous</h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ $date_rdv }}</span>
                                                                        </li>
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Enregistré par: </h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ $admin }} le {{ $date_format }}</span>
                                                                        </li>
                                                                        @endforeach
                                                                        @endif
                                                                    @else
                                                                    <ul class="list-group mb-3">
                                                                        @if(is_null($subscription))
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <h6 class="my-0 text-center">Elève Non Inscris </h6>
                                                                        </li>
                                                                        @else
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <h6 class="my-0 text-center">Aucun versement pour la pension </h6>
                                                                        </li>
                                                                        @endif
                                                                    </ul>                                                      
                                                                    @endif 
                                                                    @if(!is_null($subscription))
                                                                    <ul class="list-group mb-3 mt-3">
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Total</h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ convert_amount_v2($sum) }}</span>
                                                                        </li>
                                                                        <li class="list-group-item d-flex justify-content-between lh-condensed">
                                                                            <div>
                                                                                <h6 class="my-0">Reste</h6>
                                                                            </div>
                                                                            <span class="text-dark">{{ convert_amount_v2($residual) }}</span>
                                                                        </li>
                                                                    </ul>
                                                                    @endif                                                                                        
                                                                </ul>
                                                            </div>
                                                            <div class="modal-footer">
                                                                <button type="button" class="btn btn-danger light btn-sm" data-bs-dismiss="modal">Close</button>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                                @endforeach
                                            @endif
                                            @else
                                                <h5 class="my-0 text-white text-center">Aucune Inscription</h5>
                                            @endif
                                            <h3 class="my-1 text-success text-center">Pension Total de toutes les inscriptions: {{ convert_amount_v2($all_pensions) }} {{ $cur }}</h3>
                                        </div>
                                    </div>
                                </div>
                                <div id="Reductions" class="tab-pane fade">
                                    <div class="my-post-content pt-4">
                                        <h3 class="text-primary mb-4">Reductions</h3>
                                        <div class="row">
                                            @if (isset($item->reductions))
                                            @if (count($item->reductions) > 0)
                                                @foreach ($item->reductions as $value)
                                                @php
                                                    $amount = $value->red_montant;
                                                    $date = $value->red_date;
                                                    $year = $value->red_annee;
                                                    $all_reductions += $amount;
                                                    $date_format = \Carbon\Carbon::parse($date)->translatedFormat('d/m/Y');
                                                @endphp
                                                <div class="col-md-3 bg">
                                                    <div class="card border-rounded p-2" style="background: #eceef1 !important">
                                                        <h6 class="my-1">Session : {{ $year }}</h6>
                                                        <h6 class="my-1">Date : {{ $date_format }}</h6>
                                                        <h6 class="my-1">Montant : {{ convert_amount_v2($amount) }}</h6>
                                                    </div>
                                                </div>
                                                @endforeach
                                            @else
                                                <h5 class="my-0 text-white text-center">Aucune Reduction</h5>
                                            @endif
                                            @endif
                                            <h3 class="my-1 text-success text-center">Total des reductions: {{ convert_amount_v2($all_reductions) }} {{ $cur }}</h3>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- Modal -->

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script-down')
<link href="{{ asset('backend/vendor/sweetalert2/dist/sweetalert2.min.css') }}?t={{time()}}" rel="stylesheet">
<script src="{{ asset('backend/vendor/sweetalert2/dist/sweetalert2.min.js') }}"></script>
<script>
    $(document).ready(function () {
        
       
    });
</script>
@endsection