@extends('layouts.app')
@section('content')
@if ($message= Session::get('success'))
<div class="col-sm-12">
               <div class="alert  alert-success alert-dismissible fade show" role="alert">
                   <span class="badge badge-pill badge-success">Success</span> {{ $message }}
                   <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                       <span aria-hidden="true">&times;</span>
                   </button>
               </div>
           </div>
@endif
<div class="content mt-3"> 
           <div class="animated">

               <div class="card">
                   <div class="card-header">
                       <i class="mr-2 fa fa-align-justify"></i>
                       <strong class="card-title" v-if="headerText">Menus d'insertion et affichage des données</strong>
                   </div>
                   <div class="card-body">
                
                   <button type="button" class="btn btn-secondary mb-1" data-toggle="modal" data-target="#servicenp">
                           Services
                       </button>
                   <button type="button" class="btn btn-secondary mb-1" data-toggle="modal" data-target="#enfantnp1">
                           Enfants
                       </button>
                       <button type="button" class="btn btn-secondary mb-1" data-toggle="modal" data-target="#calculpensionnp">
                           Calcul Pension
                       </button>
                       <button type="button" class="btn btn-secondary mb-1" data-toggle="modal" data-target="#numerofnr">
                           FNR
                       </button>

               </div>
           </div>



  <div class="modal fade" id="servicenp" tabindex="-1" role="dialog" aria-labelledby="servicenpLabel" aria-hidden="true">
                   <div class="modal-dialog modal-lg" role="document">
                       <div class="modal-content">
                           <div class="modal-header">
                               <h5 class="modal-title" id="servicenpLabel">Services et anuités</h5>
                               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                   <span aria-hidden="true">&times;</span>
                               </button>
                           </div>
                <div class="modal-body">
                <form action="{{ url('addservicenp')}}" method="POST" enctype="multipart/form-data">
             @csrf

                   <div class=" col-sm-12">
                   <label class=" form-control-label">Choisissez le retraité</label>
                   <select name="retraitenp_id" class="form-control">
                   <option value="" selected>Veuillez choisir...</option>
                                         @foreach($retraitenp as $serv)
                                         <option value="{{ $serv->id }}">{{
                                             $serv->nom }}
                                             <br>
                                             {{
                                             $serv->matricule }}
                                             <br>
                                        </option>
                                             @endforeach
                                             </select>

                                   </div>
                         <div class="col-sm-4">

                                           <label class=" form-control-label">Titulaires Ans</label>
                                               <input type="text" name="ansT"  class="form-control @error('ansT') is-invalid @enderror" id="ansT" placeholder="Votre ansT"  value="{{ old('ansT')}}" required>
                                           </div>
                           <div class="col-sm-4">

                                           <label class=" form-control-label">Titulaires Mois</label>
                                               <input  type="text" name="moisT"  class="form-control @error('moisT') is-invalid @enderror" id="moisT" placeholder="Votre moisT"  value="{{ old('moisT')}}" required>
                                           </div>

                                   <div class="col-sm-4">

                                                   <label class=" form-control-label">Titulaires Jours</label>

                                                       <input  type="text" name="joursT"  class="form-control @error('joursT') is-invalid @enderror" id="joursT" placeholder="Votre joursT"  value="{{ old('joursT')}}"  required>
                                                   </div>


                         <div class="col-sm-4">

                                           <label class=" form-control-label">Validité Ans</label>
                                               <input type="text" name="ansV"  class="form-control @error('ansV') is-invalid @enderror" id="ansV" placeholder="Votre ansV"  value="{{ old('ansV')}}" required>
                                           </div>

                           <div class="col-sm-4">

                                           <label class=" form-control-label">Validité Mois</label>
                                               <input type="text" name="moisV"  class="form-control @error('moisV') is-invalid @enderror" id="moisV" placeholder="Votre moisV"  value="{{ old('moisV')}}" required>
                                           </div>
                                   <div class="col-sm-4">

                                                   <label class=" form-control-label">Validité Jours</label>
                                                       <input type="text" name="joursV"  class="form-control @error('joursV') is-invalid @enderror" id="joursV" placeholder="Votre joursV"  value="{{ old('joursV')}}"  required>
                                                   </div>

                         <div class="col-sm-4">

                                           <label class=" form-control-label">Militaire Ans</label>
                                               <input type="text" name="ansM"  class="form-control @error('ansM') is-invalid @enderror" id="ansM" placeholder="Votre ansM"  value="{{ old('ansM')}}" required>
                                           </div>

                           <div class="col-sm-4">

                                           <label class=" form-control-label">Militaire Mois</label>
                                               <input type="text" name="moisM"  class="form-control @error('moisM') is-invalid @enderror" id="moisM" placeholder="Votre moisM"  value="{{ old('moisM')}}" required>
                                           </div>

                                   <div class="col-sm-4">

                                                   <label class=" form-control-label">Militaire Jours</label>


                                                       <input type="text" name="joursM"  class="form-control @error('joursM') is-invalid @enderror" id="joursM" placeholder="Votre joursM"  value="{{ old('joursM')}}"  required>
                                                   </div>


                         <div class="col-sm-4">

                                           <label class=" form-control-label">Bonifications Ans</label>

                                               <input type="text" name="ansB"  class="form-control @error('ansB') is-invalid @enderror" id="ansB" placeholder="Votre ansB"  value="{{ old('ansB')}}" required>
                                           </div>

                           <div class="col-sm-4">

                                           <label class=" form-control-label">Bonifications Mois</label>

                                               <input type="text" name="moisB"  class="form-control @error('moisB') is-invalid @enderror" id="moisB" placeholder="Votre moisB"  value="{{ old('moisB')}}" required>
                                           </div>

                                   <div class="col-sm-4">

                                                   <label class=" form-control-label">Bonifications Jours</label>
                                                       <input type="text" name="joursB"  class="form-control @error('joursB') is-invalid @enderror" id="joursB" placeholder="Votre joursB"  value="{{ old('joursB')}}" required>
                                                   </div>

   <br>
   <br>

   <div class="col-md-12">
                           <div class="modal-footer">

                               <button type="button" class="btn btn-warning" data-dismiss="modal">Annuler</button>
                               <button type="submit" class="btn btn-primary btn-block">Valider</button>
                           </div>
                           </div>
                         </form>
                       </div>
                   </div>
               </div>
               </div>
                   </div>
               </div>

               <div class="modal fade" id="enfantnp1" tabindex="-1" role="dialog" aria-labelledby="enfantnpLabel" aria-hidden="true">
                   <div class="modal-dialog modal-lg" role="document">
                       <div class="modal-content">
                           <div class="modal-header">
                               <h5 class="modal-title" id="enfantnpLabel">Enfants Mineur ou Infirme</h5>
                               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                   <span aria-hidden="true">&times;</span>
                               </button>
                           </div>
                           <div class="modal-body">
                           <form action="{{ url('addenfantnp')}}" method="POST" enctype="multipart/form-data">
                           {{csrf_field()}}
                           <div class="form-group">
                            
                                     <label for="name" class="col-sm-12">Nom du parent</label>
                                     <div class="col-sm-12">
                                     <select name="retraitenp_id" class="form-control" required>
                                     <option value="" selected>Veuillez choisir...</option>
                                         @foreach($retraitenp as $serv)
                                         <option value="{{ $serv->id }}">
                                        
                                             {{ $serv->matricule }}
                                             <br>{{$serv->nom }}
                                        </option>
                                             @endforeach
                                             </select>
                                    
                                     </div>
                                 </div>                 
            <div class="input-group control-group increment" >
            <div class="row">
            <div class="form-group">
            <div class="col-sm-12">
            <input type="text" class="form-control"  name="nomenfantnp[]" placeholder="Enter le nom" required>
        
                                     </div>
                                 </div>
                                 <div class="form-group">
            <div class="col-sm-12">
            <input type="date" class="form-control"  name="datenaissanceenfantnp[]"  required>
           
                                     </div>
                                 </div>
            <div class="form-group">
            <div class="col-sm-12">
            <select name='infirmenp[]'  class="form-control">
                                            <option  value=''>Situation</option>
                                            <option  value='infirme'>Infirme</option>
                                            <option  value='MCS'>Manque de certificat de scolarité</option>
                                            </select>
            <span id="nomenfantnpError" class="alert-message"></span>
                                     </div>
                                 </div>
                </div>   
          <div class="input-group-btn"> 
            <button class="btn btn-success" type="button"><i class="glyphicon glyphicon-plus"></i>Add</button>
          </div>
        </div>
        <div class="clone hide">
          <div class="control-group input-group" style="margin-top:10px">
          <div class="row">
            <div class="form-group">
            <div class="col-sm-12">
            <input type="text"   name="nomenfantnp[]" placeholder="Enter le nom" required>
            <span id="nomenfantnpError" class="alert-message"></span>
                                     </div>
                                 </div>
                                 <div class="form-group">
            <div class="col-sm-12">
            <input type="date"   name="datenaissanceenfantnp[]"  required>
            <span id="datenaissanceenfantnpError" class="alert-message"></span>
                                     </div>
                                 </div>
            <div class="form-group">
            <div class="col-sm-12">
            <select name='infirmenp[]'  >
                                            <option  value=''>Situation</option>
                                            <option  value='infirme'>Infirme</option>
                                            <option  value='MCS'>Manque de certificat de scolarité</option>
                                            </select>
            <span id="nomenfantnpError" class="alert-message"></span>
                                     </div>
                                 </div>
                </div>   
            <div class="input-group-btn"> 
              <button class="btn btn-danger" type="button"><i class="glyphicon glyphicon-remove"></i> Sup</button>
            </div>
          </div>
        </div>
        <div class="modal-footer">
        <button type="submit" class="btn btn-primary" style="margin-top:10px">Valider</button>
        </form>
        </div>
                           
                           </div>
                       </div>
                   </div>
               </div>
               <script type="text/javascript">

$(document).ready(function() {

  $(".btn-success").click(function(){ 
      var html = $(".clone").html();
      $(".increment").after(html);
  });

  $("body").on("click",".btn-danger",function(){ 
      $(this).parents(".control-group").remove();
  });

});

</script>

<!-------------------------------------------------------------------->

               <div class="modal fade" id="calculpensionnp" tabindex="-1" role="dialog" aria-labelledby="calculpensionnpLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg" role="document">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="calculpensionnpLabel">Calcul pension Revision</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                            <form action="{{ url('addcalculpensionnprev')}}" method="POST" enctype="multipart/form-data">
             @csrf
     <div  class="col-sm-12">
     <label for="name" class="col-sm-12">Nom du Rétraité</label>
                                     <select name="retraitenp_id" class="form-control">
                                     <option value="" selected>Veuillez choisir...</option>
                                         @foreach($retraitenp as $serv)
                                         <option value="{{ $serv->id }}">{{
                                             $serv->nom }}
                                             <br>
                                             {{
                                             $serv->matricule }}
                                        </option>
                                             @endforeach
                                             </select>
      </div>
      <div  class="col-sm-4">
    <label>Selectionnez le grade:</label>
            <select name='categorie'  class="form-control"   required>
            <option  value=''>Selectionnez</option>
              <option  value='Cadre A1'>Catégorie A1</option>
              <option  value='Cadre A2'>Catégorie A2</option>
              <option  value='Cadre A3'>Catégorie A3</option>
              <option  value='Cadre B1'>Catégorie B1</option>
              <option  value='Cadre B2'>Catégorie B2</option>
              <option  value='Cadre C1'>Catégorie C1</option>
              <option  value='Cadre C2'>Catégorie C2</option>
              <option  value='Cadre D1'>Catégorie D1</option>
              <option  value='Cadre D2'>Catégorie D2</option>
              <option  value='Autre'>Autre</option>
               </select>
     </div>
          
       <div class="col-sm-4">
         <label>Nombre d'anuité:</label>
       <input type="text"  name="nombreannee"  class="form-control @error('nombreannee') is-invalid @enderror" id="nombreannee" placeholder="Nombre d'anuité"  value="{{ old('nombreannee')}}" >
     </div>
     <script>
function getValue(){
    var saisie =document.getElementById("nombreannee").value;
alert("Vous avez saisi : "+ saisie);
  if (annuité  >= 25)
    annuité=0;
    else if (annuité  < 25)
    annuité=4;
    alert(annuité);
  }
</script>
      <div class="col-sm-4">
       <label>Majoration:</label>
       <select class="form-control"  name="majoration"  required>
                <option data-display="Select">Séclectionnez</option>
                    <option value="22">22%</option>
                    <option value="32">32%</option>
                     <option value="42">42%</option>
                                    
                </select>
     </div>
      
 

      <div class="col-sm-4">
       <label>Valuer du point Indiciaire:</label>
       <select class="form-control" name="vpi"  required>
            <option data-display="Select">Selectionnez</option>
            <option value="2500">2500</option>
            <option value="2750">2750</option>
            <option value="3500">3500</option>
         <option value="3800">3800</option>
        <option value="4180">4180</option>
        <option value="5311">5311</option>
    </select>
     </div>
      <div class="col-sm-4">
       <label>Indice:</label>
       <input type="text"  name="indice" class="form-control @error('indice') is-invalid @enderror" id="indice" placeholder="Indice"  value="{{ old('indice')}}"  required>
     </div>

     <div class="col-sm-4">
      <label>Taux d'invalidité:</label>
       <input type="number" name="tauxinv" class="form-control @error('tauxinv') is-invalid @enderror" id="tauxinv" placeholder="Taux invalidité"  value="{{ old('tauxinv')}}">
     </div>
     <div class="col-sm-4">
   <label>Rappel  date debut:</label>
       <input type="date" name="dated" class="form-control @error('dated') is-invalid @enderror" id="dated" placeholder="Date debut"  value="{{ old('dated')}}">
     </div>

     <div class="col-sm-4">
   <label>Date fin:</label>
       <input type="date"  name="datefin" class="form-control @error('datefin') is-invalid @enderror" id="datefin" placeholder="datefin"  value="{{ old('datefin')}}" >
     </div>
        <div class="col-sm-4">
       <label>Nombre de Mois:</label>
       <input type="number"  name="nombremois" class="form-control @error('nombremois') is-invalid @enderror" id="nombremois" placeholder="nombre mois"  value="{{ old('nombremois')}}">
     </div>
      <div class="col-sm-4">
       <label>Rappel P_jours date debut:</label>
     <input type="date" name="datedej" class="form-control @error('datedej') is-invalid @enderror" id="datedej" placeholder="date debut"  value="{{ old('datedej')}}" >
     </div>
      <div class="col-sm-4">
       <label>Date fin:</label>
       <input type="date"  name="datefinj" class="form-control @error('datefinj') is-invalid @enderror" id="datefinj" placeholder="date finj"  value="{{ old('datefinj')}}" >
     </div>
   <div class="col-sm-4">
         <label>Nombre de jours:</label>
          <input type="number"  name="nombrejours" class="form-control @error('nombrejours') is-invalid @enderror" id="nombrejours" placeholder="nombre de jours"  value="{{ old('nombrejours')}}" >
   </div>
   <div class="col-sm-4">
         <label>Rappel traitement indiciaire:</label>
          <input type="number"  name="montanttrait" class="form-control @error('montanttrait') is-invalid @enderror" id="montanttrait" placeholder="montant traitement"  value="{{ old('montanttrait')}}">
   </div>
   <div class="col-sm-4">
         <label>Debut traitement:</label>
          <input type="date"  name="debuttrait" class="form-control @error('debuttrait') is-invalid @enderror" id="debuttrait" placeholder="debut trait"  value="{{ old('debuttrait')}}" >
   </div>
   <div class="col-sm-4">
         <label>Fin traitement:</label>
          <input type="date"  name="fintrait" class="form-control @error('fintrait') is-invalid @enderror" id="fintrait" placeholder="fin trait"  value="{{ old('fintrait')}}">
   </div>
   <div class="col-sm-4">
         <label>Trop perçu date debut:</label>
          <input type="date"  name="datedebut" class="form-control @error('datedebut') is-invalid @enderror" id="datedebut" placeholder="date debut"  value="{{ old('datedebut')}}">
   </div>
   <div class="col-sm-4">
         <label>Date de la fin:</label>
          <input type="date"  name="datefint" class="form-control @error('datefint') is-invalid @enderror" id="datefint" placeholder="date fin trop percu"  value="{{ old('datefint')}}">
   </div>
   <div class="col-sm-4">
         <label>montant Trop percu:</label>
          <input type="number"  name="montanttp" class="form-control @error('montanttp') is-invalid @enderror" id="montanttp" placeholder="montant"  value="{{ old('montanttp')}}">
   </div>
   <div class="col-sm-4">
         <label>Debut Rap:</label>
          <input type="date"  name="datedea" class="form-control @error('datedea') is-invalid @enderror" id="datedea" placeholder="Debut"  value="{{ old('datedea')}}">
   </div>
   <div class="col-sm-4">
         <label>Fin Rap All:</label>
          <input type="date"  name="datefina" class="form-control @error('datefina') is-invalid @enderror" id="datefina" placeholder="Fin"  value="{{ old('datefina')}}">
   </div>

   <div class="col-sm-4">
         <label>Valeur Allocation:</label>
          <input type="number"  name="valleurall" class="form-control @error('valleurall') is-invalid @enderror" id="valleurall" placeholder="Valeur Allocation"  value="{{ old('valleurall')}}">
   </div>
   <div class="col-sm-4">
         <label>Nombre Mois Allocation:</label>
          <input type="number"  name="nombremoisa" class="form-control @error('nombremoisa') is-invalid @enderror" id="nombremoisa" placeholder="Nombre mois Allocation"  value="{{ old('nombremoisa')}}">
   </div>
   <div class="col-sm-4">
         <label>Debut AP:</label>
          <input type="date"  name="debutap" class="form-control @error('debutap') is-invalid @enderror" id="debutap" placeholder="Debut"  value="{{ old('debutap')}}">
   </div>
   <div class="col-sm-4">
         <label>Fin AP:</label>
          <input type="date"  name="fintap" class="form-control @error('fintap') is-invalid @enderror" id="fintap" placeholder="Fin"  value="{{ old('fintap')}}">
   </div>
   <div class="col-sm-4">
         <label>Montant AP:</label>
          <input type="number"  name="montantap" class="form-control @error('montantap') is-invalid @enderror" id="montantap" placeholder="Montant à percu"  value="{{ old('montantap')}}">
   </div>
   <div class="col-sm-4">
         <label>Nombre mois AP:</label>
          <input type="number"  name="nombremoisap" class="form-control @error('nombremoisap') is-invalid @enderror" id="nombremoisap" placeholder="Nombre Mois à percu"  value="{{ old('nombremoisap')}}">
   </div>
 
   <br>
   <br>

   <div class="col-md-12">
                           <div class="modal-footer">

                               <button type="button" class="btn btn-warning" data-dismiss="modal">Anuler</button>
                               <button type="submit" class="btn btn-primary btn-block">Valider</button>
                           </div>
                           </div>
                         </form>
                            </div>

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


                <div class="modal fade" id="Numérotation" tabindex="-1" role="dialog" aria-labelledby="NumérotationLabel" aria-hidden="true">
                   <div class="modal-dialog modal-sm" role="document">
                       <div class="modal-content">
                           <div class="modal-header">
                               <h5 class="modal-title" id="NumérotationLabel">Numérotation</h5>
                               <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                   <span aria-hidden="true">&times;</span>
                               </button>
                           </div>
                           <div class="modal-body">
                             <form action="{{ url('addfiles')}}" method="POST" enctype="multipart/form-data">
                               @csrf
                               <div class="form-group">
                                     <label for="name" class="col-sm-12">Nom du Rétraité</label>
                                     <div class="col-sm-12">
                                     <select name="retraitenp_id" class="form-control">
                                     <option value="" selected>Veuillez choisir...</option>
                                         @foreach($retraitenp as $serv)
                                         <option value="{{ $serv->id }}">{{
                                             $serv->nom }}
                                             <br>
                                             {{
                                             $serv->matricule }}
                                        </option>
                                             @endforeach
                                             </select>
                                         <span id="nomenfantnpError" class="alert-message"></span>
                                     </div>
                                 </div>
                                 <div class="form-group">
                                     <label for="name" class="col-sm-12">Nom</label>
                                     <div class="col-sm-12">
                                         <input type="text" class="form-control" id="name_file" name="name_file" placeholder="Enter le nom">
                                         <span id="name_fileError" class="alert-message"></span>
                                     </div>
                                 </div>
                                 <div class="form-group">
                                     <label for="name" class="col-sm-12">Fichier</label>
                                     <div class="col-sm-12">
                                         <input type="file" class="form-control" id="file" name="file" placeholder="Enter le nom">
                                         <span id="fileError" class="alert-message"></span>
                                     </div>
                                 </div>

                           </div>
                           <div class="modal-footer">
                               <button type="button" class="btn btn-warning" data-dismiss="modal">Anuler</button>
                               <button type="submit" class="btn btn-primary">Valider</button>
                                  </form>
                           </div>
                       </div>
                   </div>
               </div>

               <br />
<b>Fatal error</b>:  Uncaught Error: Class 'DB' not found in /home/carenin/public_html/resources/views/revisions/servicenprev.blade.php:530
Stack trace:
#0 {main}
  thrown in <b>/home/carenin/public_html/resources/views/revisions/servicenprev.blade.php</b> on line <b>530</b><br />