@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>



               @if(count($programmation)>0)
  <div class="content mt-3">
            <div class="animated fadeIn">
                <div class="row">

                    <div class="col-md-12">
                        <div class="card">
                          
                <form action="{{url('addrapportvirement')}}" method="POST" enctype="multipart/form-data">
                @csrf
                <div class="row">
                        <div class="col-md-3">
                        <input type="date" name="from" class="form-control"  placeholder="dd-mm-yyyy"  id="validationCustom20">
                        </div>
                        <div class="col-md-3">
                        <input type="date" name="to" class="form-control" id="validationCustom01"  placeholder="dd-mm-yyyy"  required>
                        </div>
                       
                                     <div class="col-md-2">

   <input type="text" name="banque" class="form-control" id="validationCustom01"  placeholder="Banque"  required>
   </div> 
                        <div class="col-md-2">
                            <button class="btn btn-outline-primary" type="submit">Valider</button>
                        </div>
                    </div>
                </form>
                            <div class="card-header">
                                <strong class="card-title">Paiement</strong>
                            </div>
                    
                            <div class="card-body">
              <table table class="datatable table table-hover table-bordered yajra-datatable" >
                                 <thead>
                                
                                     <tr>
                                            <th>N° FNR</th>
                                                <th>Nom</th>
                                             <th>Matricule</th>
                                             <th>Echeance</th>
                                                <th>Mode paiement</th>
                                                <th>Montant Net</th>
                                                <th>Intégré par</th>
                                                <th>Banque</th>
                                                <th>Numero</th>
                                         <th></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></th>
      </tr>
    </tfoot>
          <tbody>
            @foreach($programmation as $programmations)
               <tr>
            
                                            <td>{{$programmations->fnr}}</td>
                                            <td>{{$programmations->nom}}</td>
                                            <td>{{$programmations->matricule}}</td>
                                            <td>{{\Carbon\Carbon::parse($programmations->echeance_id)->format('d/m/Y')}}</td>
                                            <td>{{$programmations->mode_paiement}}</td>
                                            <td>{{$programmations->pensiongenerale}}</td>
                                            <td>{{$programmations->utilisateur}}</td>
                                      
                                            <td>{{$programmations->domiciliation}}</td>
                                            <td>{{$programmations->numerocompte}}</td>
                 <td>
                
                
                  
                </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>