@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">
                            <div class="card-header">
                                <strong class="card-title">Total de la dépense :   {{number_format($somme, 0, ',', ' ')}}</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>Date paiement</th>
                                                <th>ECHECHEANCE </th>
                                                <th>Montant Net</th>
                                                <th>Caisse</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>
       
      </tr>
    </tfoot>
          <tbody>
            @foreach($programmation as $programmations)
               <tr>
            
                                            <td>{{$programmations->fnr}}</td>
                                            <td>{{$programmations->nom}}</td>
                                            <td>{{\Carbon\Carbon::parse($programmations->date_paiement)->format('d/m/Y')}}</td>
                                            <td>{{$programmations->mois}}/{{$programmations->annee}}</td>
                                            <td>{{$programmations->pensiongenerale}}</td>
                                            <td>{{$programmations->agent_pay}}</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>