@extends('layouts.admin')

@section('css')
@parent
    <!-- JQuery DataTable Css -->
    {!! Html::style('adminbsb_plugins/jquery-datatable/skin/bootstrap/css/dataTables.bootstrap.min.css') !!}
@stop

@section('content')

<div class="block-header">
	<h2><i class="material-icons">send</i> Formulaires</h2>
</div>

<div class="row clearfix">
    <div class="col-xs-12">
      <div class="card">                
        <div class="header"> 
          {!! Html::link(action('FormulaireController@export_saisies', array('id' => $formulaire->id)), "Exporter les saisies en csv", array("class" => "btn btn-sm bg-teal waves-effect m-l-15 pull-right")) !!}                                  
          <h2>
            <p>Saisies</p>
            <small>Liste des saisies du formulaire <strong>{{ $formulaire->nom }}</strong></small>            
          </h2>
        </div>
        <div class="body table-responsive">
          <table class="table table-bordered table-striped table-hover dataTable js-exportable">
            <thead>
                <tr>
                    <th>Enregistrement</th>
                    @foreach($formulaire->champs as $champs)
                    <th>{{ $champs->nom }}</th>
                    @endforeach
                    @if($formulaire->rgpd)
                    <th>Supp.</th>
                    @endif
                </tr>
            </thead>
            <tbody>
              @foreach($instances as $instance)
                <tr>
                    <td>{{ $instance->instance }}</td>
                    @foreach($formulaire->champs as $champs)
                        <td>{{ getChampsValue($champs->id, $instance->instance) }}</td>
                    @endforeach
                    @if($formulaire->rgpd)
                        <td><a href="{{ action('FormulaireController@delete_saisie', array('id' => $instance->instance)) }}" title="Supprimer le champ" onclick="return confirm('Etes-vous sûr de vouloir supprimer cet élément ?');" class="col-red"><i class="material-icons">delete_forever</i></a></td>
                    @endif
                </tr>
              @endforeach
            </tbody>
          </table>
        </div>
      </div>
    </div>
</div>
@stop

@section('js')

<!-- Jquery DataTable Plugin Js -->
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/dataTables.buttons.min.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/buttons.flash.min.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/jszip.min.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/pdfmake.min.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/vfs_fonts.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/buttons.html5.min.js") !!}
{!! Html::script("adminbsb_plugins/jquery-datatable/extensions/export/buttons.print.min.js") !!}

<script type="text/javascript">
        
        //Exportable table    
        $('.js-exportable').DataTable({
            "order": [ 0, 'desc' ],
            "oLanguage": {
                  "sProcessing":     "Traitement en cours...",
                  "sSearch":         "Rechercher&nbsp;:",
                  "sLengthMenu":     "Afficher _MENU_ &eacute;l&eacute;ments",
                  "sInfo":           "Affichage de l'&eacute;l&eacute;ment _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
                  "sInfoEmpty":      "Affichage de l'&eacute;l&eacute;ment 0 &agrave; 0 sur 0 &eacute;l&eacute;ment",
                  "sInfoFiltered":   "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
                  "sInfoPostFix":    "",
                  "sLoadingRecords": "Chargement en cours...",
                  "sZeroRecords":    "Aucun &eacute;l&eacute;ment &agrave; afficher",
                  "sEmptyTable":     "Aucune donn&eacute;e disponible dans le tableau",
                  "oPaginate": {
                      "sFirst":      "Premier",
                      "sPrevious":   "Pr&eacute;c&eacute;dent",
                      "sNext":       "Suivant",
                      "sLast":       "Dernier"
                  },
                  "oAria": {
                      "sSortAscending":  ": activer pour trier la colonne par ordre croissant",
                      "sSortDescending": ": activer pour trier la colonne par ordre d&eacute;croissant"
                  }
              },
            // pour boutons exports  
            dom: 'Bfrtip',
            buttons: [
                'copy', 'excel', 'pdf', 'print'
            ]
        }); 
        
</script>
@stop