@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
           @if(count($pension)>0)
  <!-- Modal js-->
  <div class="content mt-3">
            <div class="animated fadeIn">
                <div class="row">

                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <strong class="card-title">Retraite</strong>
                                <form action="{{ url('filtre')}}" method="POST" method="POST" enctype="multipart/form-data">
        @csrf
                                             <div class="row">
                                                 <label>Du:</label>
                                                 <div class="col-sm-3">
                                                 <input type="date" name="from" class="form-control"  placeholder="dd-mm-yyyy"  id="validationCustom20">
                                                 </div>
                                                 <label>Au:</label>
                                                 <div class="col-sm-3">
                                                    <input type="date" name="to" class="form-control"
                                                     id="validationCustom01"  placeholder="dd-mm-yyyy"  required>

                                                 </div>
                                                 <div class="col-lg-3">
                                                 <button type="submit" class="btn btn-primary" class="filter pull-right"><span class="fa fa-print"></span> Rechercher</button>
                                                 </div>

                                             </div>
       </form>
                            </div>
           
                            <div class="card-body">
                            <table table class="datatable table table-hover table-bordered yajra-datatable">
                                 <thead>
                                     <tr>
                                         <th>FNR</th>
                                         <th>Matricule</th>
                                         <th>Nom et Prenom</th>

                                         <th>Date_naissance</th>
                                         <th>Tel</th>
                                         <th>PNM</th>
                                      
                                         <th>Allocation</th>
                                         <th>Pensiongenerale</th>
                                       <th>Assignation</th>
                                         <th>Banque</th>
                                         <th>Numero_Compte</th>
                                     </tr>
                                 </thead>
                                 <tfoot>
      <tr>
     
        
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
         <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
       
      <th>
          <input type="text" class="form-control input-sm filter-column">
         </th>
       
        
     
        
        
      </tr>
    </tfoot>
          <tbody>
            @foreach($pension as $calculpensionnps)
               <tr>
                <td>{{$calculpensionnps->fnr}}</td>
                <td>{{$calculpensionnps->matricule}}</td>
                <td>{{$calculpensionnps->nom}}</td>
           
                <td>{{\Carbon\Carbon::parse($calculpensionnps->datenaissance)->format('d/m/Y')}}</td>
                <td>{{$calculpensionnps->telephone}}</td>
                <td>{{$calculpensionnps->pnt}}</td>
          
                <td>{{$calculpensionnps->allocation}}</td>
                <td>{{$calculpensionnps->pensiongenerale}}</td>
                 <td>{{$calculpensionnps->assignation}}</td>
                <td>{{$calculpensionnps->domiciliationnp}}</td>
                <td>{{$calculpensionnps->numerocomptenp}}</td>
                 </tr>
                  @endforeach
                                   </tbody>
                             </table>
</div>
</div>
                        </div>
                    </div>


                </div>
            </div>
@endif

<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="//cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
    <script src="//cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
    <!-- Responsive extension -->
    <script src="https://cdn.datatables.net/responsive/2.1.0/js/responsive.bootstrap.min.js"></script>
    <!-- Buttons extension -->
    <script src="//cdn.datatables.net/buttons/1.2.1/js/dataTables.buttons.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.2.1/js/buttons.bootstrap.min.js"></script>
    <script src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
    <script src="//cdn.datatables.net/buttons/1.2.1/js/buttons.html5.min.js"></script>

    <script>
    var dataTable = $('.datatable').DataTable({
  buttons: [
    {
      extend: 'excel',
      text: 'Export en Excel',
      className: 'btn-sm btn-flat',
    },
  ],
  dom: "<'row'<'col-md-3'l><'col-md-6 text-center'B><'col-md-3'f>>" +
         "<'row'<'col-md-12'tr>>" +
         "<'row'<'col-md-5'i><'col-md-7'p>>",
  drawCallback: function(settings) {
    if (!$('.datatable').parent().hasClass('table-responsive')) {
      $('.datatable').wrap("<div class='table-responsive'></div>");
    }
  }
});

dataTable.columns().every(function() {
  var column = this;

  $('.filter-column', this.footer()).on('keyup change', function() {
    if (column.search() !== this.value) {
      column
        .search(this.value)
        .draw();
      this.focus();
    }
  });

});

    </script>
    <style>/* Styles go here */

/* Column Filter row at top of table  */
.datatable tfoot {
  display: table-header-group;
}

.datatable tfoot .filter-column {

  width: 100% !important;
}</style>

           @endsection
</body>