@extends('admin.layout.master')
<link rel="stylesheet" type="text/css" href="{{asset('plugins/files/assets/css/select-responsive-fraza.css')}}" >
<style type="text/css">
    table {
        width: 100%;
        color: black;
        border-collapse: collapse;
    }
    th, td{
        border: 1px solid black;
        padding: 15px;
        vertical-align: top;
    }
    h2  { margin: 0; padding: 0px; }
    p { margin: 5px; }
    .no-border td {
        border: none;
        padding: 4px 2px;

    }
    .noBorder{
        border: 0px solid black;
    }
    .border th {
        border: 1px solid #000;
        color: black;
        background: #33db9e;
        padding: 5px 5px;
        font-weight: bold;
        font-size: 12px;
        text-align: center; }
    .border td {
        border: 1px solid #000;
        font-size: 12px;
        padding: 4px 2px;
        text-align: center;

    }
    .scrollit {
        overflow-y:scroll;
        height:100px;
    }
    .space { padding-top: 250px; }
        .45p { width: 45%; }.20p { width: 20%; }
        .10p { width: 10%; } .15p { width: 15%; }
        .5p { width:  5%; } .12p { width: 15%; }
        .25p { width: 25%; } .50p { width: 50%; }
        .60p { width: 60%; } .75p { width: 75%; }
        .100p { width: 100%;}.20p { width: 20%; }
        .90p { width: 90%;}
    .header
    {
        width:100%;
        font-size: 9px;
    }
</style>
@section('content')
    <div id="overlay"  style="display:none;">
        <div class="loader" style="margin-top: 380px;">Loading...</div>
    </div>
    <div class="pcoded-content">
        <!-- [ breadcrumb ] start -->
        <div class="page-header">
            <div class="page-block">
                <div class="row align-items-center">
                    <div class="col-md-12">
                        <div class="page-header-title">
                            <h4 class="m-b-10">Etat</h4>
                        </div>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item">
                                <a href="{{ route('home_path') }}">
                                <i class="feather icon-home"></i>
                            </a>
                            </li>
                            <li class="breadcrumb-item"><a href="{{ route('home_path') }}">Accueil</a>
                            </li>
                            <li class="breadcrumb-item">
                                <a href="#">Dépenses  {{-- de la Police  @if (($adherents))
                                    " {{ $adherents->first()->police->libellePolice }}"
                                @endif --}} </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
        <!-- [ breadcrumb ] end -->
        <div class="pcoded-inner-content">
            <!-- Main-body start -->
            <div class="main-body">
                <div class="page-wrapper">
                    <!-- Page-body start -->
                    <div class="page-body">
                        <div class="row">
                            <div class="col-sm-12">
                                <!-- Scroll - Vertical, Dynamic Height table end -->
                                <!-- Language - Comma Decimal Place table start -->
                                <div class="card">
                                    <div class="card-header">
                                        <h5><label class="badge badge-lg bg-info">{{-- {{ $nbre_beneficiaire }} --}}</label>Dépenses</h5>

                                        <div class="d-flex align-items-center justify-content-between flex-wrap">
                                            <div class="border-right pr-4 mb-3 mb-xl-0">
                                                <p class="text-muted"></p>
                                                <h4 class="mb-0 font-weight-bold"></h4>
                                            </div>
                                            <div class="border-right pr-4 mb-3 mb-xl-0">
                                                <p class="text-muted"></p>
                                                <h4 class="mb-0 font-weight-bold"></h4>
                                            </div>
                                            <div class="border-right pr-4 mb-3 mb-xl-0">
                                                <p class="text-muted"></p>
                                                <h4 class="mb-0 font-weight-bold"></h4>
                                            </div>
                                            <div class="pr-3 mb-3 mb-xl-0">
                                                <p class="text-muted"></p>
                                                <h4 class="mb-0 font-weight-bold"></h4>
                                            </div>
                                            </div>
                                            <div class="mb-3 mb-xl-0">
                                                {{-- <a class="btn btn-inverse btn-round  btn-grd" href="{{ route('admin.etat.pdf') }}" target="_blank"><i class="fas fa-file-pdf"></i>Export Bénéficiaire</a> --}}
                                                {{-- <a class="btn btn-warning btn-round  btn-grd" href="{{ route('admin.souscripteur.index',['idPolice' => $idPolice]) }}"><i class="ti-plus"></i>Retour</a> --}}
                                            </div>
                                        </div><br>
                                        <div class="card">
                                            <div class="col-md-12 ">
                                                    <div class="panel panel-default">
                                                        <div class="panel-body" style="padding:0.5px">
                                                            
                                                            {{ Form::open(['route' => 'admin.etat.validerDepenseFamille', 'method' => 'GET', /* 'target'=>'_blank' ,  'onsubmit'=>'showOverlay()',*/    'id' => 'form_statistique']) }}
                                                                {{-- <input id="taux" name="taux" type="hidden" value="{{$taux}}"> --}}
                                                                <input id="version" name="version" type="hidden" value="{{$version}}">
                                                                <div class="row form-group">
                                                                    <div class="col-md-4 col-md-12">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Adhérent</label>
                                                                            {{ Form::text('adherent', isset($adherent) ? $adherent: old('adherent'), ['class' => ' form-control', 'id' => 'adherent','placeholder'=>"Numéro Adhérent ou Nom Adhérent"]) }}
                                                                            @if (($errors->has('adherent')))
                                                                                <div class="alert alert-danger">
                                                                                    {{ $errors->first('adherent') }}
                                                                                </div>
                                                                            @endif
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                <div class="row form-group">
                                                                    <div class="col-md-4 col-md-6">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Souscripteur</label>
                                                                            {{ Form::select('idSouscripteur', $souscripteurs, old('idSouscripteur'), ['class' => 'js-select2 form-control', 'id' => 'idSouscripteur']) }}
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Police</label>
                                                                            {{ Form::select('idPolice', $polices, old('idPolice'), ['class' => 'js-select2 form-control', 'id' => 'idPolice']) }}
                                                                        </div>
                                                                    </div>
                                                                </div>

                                                                <div class="row form-group">
                                                                    <div class="col-md-4 col-md-6">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Collège</label>
                                                                            {{ Form::select('idCollege', $colleges,  old('idCollege'), ['class' => 'form-control js-select2', 'id' => 'idCollege']) }}
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Dépense supérieure à</label>
                                                                            {{ Form::text('idDepense', isset($idDepense) ? $idDepense: old('idDepense'), ['class' => ' form-control', 'id' => 'idDepense']) }}
                                                                        </div>
                                                                    </div>
                                                                </div>

                                                                <div class="row form-group">
                                                                    <div class="col-md-4 col-md-6">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Période du</label>
                                                                            {{ Form::date('dateDebut', old('dateDebut'), ['class' => 'form-control  datepicker', 'id' => 'dateDebut', 'placeholder' => '< Date de Debut']) }}
                                                                            @if (($errors->has('dateDebut')))
                                                                                <div class="alert alert-danger">
                                                                                    {{ $errors->first('dateDebut') }}
                                                                                </div>
                                                                            @endif
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md">
                                                                        <div class="form-outline">
                                                                            <label class="form-label "  style="font-weight: bold">Au</label>
                                                                            {{ Form::date('dateFin', old('dateFin'), ['class' => 'form-control  datepicker', 'id' => 'dateFin', 'placeholder' => '< Date de Fin']) }}
                                                                            @if (($errors->has('dateFin')))
                                                                                <div class="alert alert-danger">
                                                                                    {{ $errors->first('dateFin') }}
                                                                                </div>
                                                                            @endif
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                               <br>
                                                                <div class="row form-group" style="padding:0.5px">
                                                                    <div class="col-md-4 col-md-12">
                                                                        <div class="form-outline">
                                                                            <button class="btn btn-default btn-block" style="background-color: #33db9e;font-weight: bold;">Valider</button>                                                              
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                 <br>
                                                                <div class="card-block" id="preview">
                                                                    @isset ($depenseFamilles)
                                                                    <div {{-- class="table-responsive" --}}>
                                                                        <table style="margin-left:5px;margin-right: 20px;"  class="border">
                                                                            <thead>
                                                                                <tr style=" font-weight: bold; font-size: 9px; border: 2px solid #000;">
                                                                                    <th class="text-center">Matricule</th>
                                                                                    <th class="text-center">Famille</th>
                                                                                    <th class="text-center">Pop. active</th>
                                                                                    <th class="text-center">Pop traitée</th>
                                                                                    <th class="text-center">Montant Réclamé</th>
                                                                                    <th class="text-center">Montant Remboursé</th>
                                                                                    <th class="text-center">Montant Non Remb.</th>
                                                                                    <th class="text-center">Coût moyen </th>
                                                                                </tr>
                                                                            </thead>
                                                                            <tbody>
                                                                                @php
                                                                                    $total_popActive = 0;
                                                                                    $total_popTraite = 0;
                                                                                    $total_montantReclame = 0;
                                                                                    $total_montantNonRembourse = 0;
                                                                                    $total_montantRembourse = 0;
                                                                                    $total_coutMoyen = 0;
                                                                                    $total_taux = 0;
                                                                                @endphp
                                                                                        @foreach ( $depenseFamilles as $depenseFamille )
                                                                                        @php
                                                                                            (int)$total_popActive = (int)$total_popActive + ((int)$depenseFamille->popActive);
                                                                                            (int)$total_popTraite = (int)$total_popTraite + (int)($depenseFamille->popTraite);
                                                                                            (int)$total_montantReclame = (int)$total_montantReclame+ (int)$depenseFamille->montantReclame; 
                                                                                            (int)$total_montantNonRembourse = (int)$total_montantNonRembourse+ (int)$depenseFamille->NonRembourse; 
                                                                                            (int)$total_montantRembourse = (int)$total_montantRembourse+ (int)$depenseFamille->montantRembourse; 
                                                                                            (int)$total_coutMoyen = (int)$total_coutMoyen + (int)$depenseFamille->Coutmoyen; 
                                                                                        @endphp

                                                                                            <tr style=" font-weight: bold; font-size: 9px;">
                                                                                                <td>{{ ($depenseFamille->numeroAdherent) }}
                                                                                                </td>
                                                                                                <td class="text-left">
                                                                                                        {{$depenseFamille->adherent}}
                                                                                                </td>
                                                                                                <td class="text-center">
                                                                                                        {{$depenseFamille->popActive}}
                                                                                                </td>
                                                                                                <td class="text-center">
                                                                                                    {{ $depenseFamille->popTraite }}
                                                                                                    {{-- {{  substr($prestationQuotidienne->beneficiaire, 0, strpos($prestationQuotidienne->beneficiaire, ' ', 200))  }} --}}
                                                                                                </td>
                                                                                                <td class="text-center">
                                                                                                    <div>
                                                                                                       {{ number_format($depenseFamille->montantReclame, 0, '', ' ') }} 
                                                                                                    </div>
                                                                                                </td>
                                                                                                <td class="text-center">{{ number_format($depenseFamille->montantRembourse, 0, '', ' ') }}</td>
                                                                                                <td class="text-center" >{{ number_format($depenseFamille->NonRembourse, 0, '', ' ') }} </td>
                                                                                                <td class="text-center"  style="margin: 10px;">{{ number_format($depenseFamille->Coutmoyen, 0, '', ' ') }} </td>
                                                                                            </tr>
                                                                                        @endforeach
                                                                                        <tr style="color: black;font-weight: bold; background: #33db9e;">
                                                                                            <td colspan="2">TOTAL GENERAL  : </td>
                                                                                            <td class="text-center">
                                                                                                {{ $total_popActive }}
                                                                                            </td>
                                                                                            <td class="text-center">
                                                                                                {{ $total_popTraite }}
                                                                                            </td>
                                                                                            <td class="text-center">
                                                                                                {{ number_format($total_montantReclame, 0, '', ' ') }}
                                                                                            </td>
                                                                                            <td class="text-center">
                                                                                                <div>
                                                                                                    {{ number_format($total_montantRembourse, 0, '', ' ') }}
                                                                                                </div>
                                                                                            </td>
                                                                                            <td class="text-center">{{ number_format($total_montantNonRembourse, 0, '', ' ') }}</td>
                                                                                            <td class="text-center" >{{ number_format($total_coutMoyen, 0, '', ' ') }}  </td>
                                                                                        </tr>
                                                                                    {{-- </table>
                                                                                </div> --}}
                                                                            </tbody>
                                                                        </table>
                                                                    </div>
                                                                    @endif
                                                                </div>
                                                                <br>
                                                            {{ form::close() }}

                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                    </div>

                                    <!-- Language - Comma Decimal Place table end -->
                                </div>
                            </div>
                        </div>
                        <!-- Page-body end -->
                    </div>
                </div>
            {{--  <!-- Main-body end -->
                <div id="styleSelector">

                </div> --}}
            </div>
        </div>
    </div>

    <script>
        $("#idSouscripteur").on("change", function() {
            debugger;
            var idSouscripteur = $(this).val();

            $.ajax({
                method: "GET",
                data: {
                    idSouscripteur: idSouscripteur
                },
                url: "{{ url('admin/sousPolice') }}",
            }).done(function (polices) {
                debugger;
                var result = '<option value="">Veuillez sélectionner une police</option>';
                for (var i = 0; i < polices.length; i++) {
                    result += '<option value="' + polices[i].id + '">' + polices[i].libellePolice + '</option>';
                }
                $("#idPolice").find("option").remove().end().append(result).val("");
                // $("#service_direction_id").find("option").remove().end().append('<option value="">Veuillez sélectionnez un Service</option>').val("");
            });
        });
        $("#idPolice").on("change", function() {
            //debugger;
            var idPolice = $(this).val();
            var idSouscripteur = $('#idSouscripteur').val();

            $.ajax({
                method: "GET",
                data: {
                    idPolice: idPolice,
                    idSouscripteur: idSouscripteur
                },
                url: "{{ url('admin/policeCollege') }}",
            }).done(function (colleges) {
                //debugger;
                var result = '<option value="">Veuillez sélectionner un collège</option>';
                for (var i = 0; i < colleges.length; i++) {
                    result += '<option value="' + colleges[i].id + '">' + colleges[i].libelleCollege + '</option>';
                }
                $("#idCollege").find("option").remove().end().append(result).val("");
                // $("#service_direction_id").find("option").remove().end().append('<option value="">Veuillez sélectionnez un Service</option>').val("");
            });
        });
        $(document).ready(function() {
            $(".js-select2").select2({
                closeOnSelect: false
            });
            $(".js-select2-multi").select2({
                closeOnSelect: false
            });
        });
    </script>
@endsection