@extends('layout.base', ['title' => 'Assurance - Journal Cotisation'])

@section('content')
              <div id="page-wrapper" >
            <div id="page-inner">
                  <form method="POST" action="{{ route('PdfCreateCotisation')}}">
                        {{ csrf_field() }}
                        <div class="row">
                            <div class="col-md-3">
                              <div class="form-group">
                                <label>Groupe</label>
                                  <select name="Groupe" class="form-control">
                                    <option></option>
                                  @foreach($Partenaires as $G)
                                    <option value="{{ $G->id}}"> {{ $G->Origine}}</option>
                                  @endforeach    
                                  </select>
                              </div>
                            </div>

                            <div class="col-md-2">
                              <div class="form-group">
                                    <label>Individu</label>
                                    <input type="text" name="prodReas" id="prodReas"  class="form-control" style="" oninput="research(this)">
                                   <select class="form-control" name="Individu" id="Produit">
                                        <option value="">-- Selectionner l'Affilier --</option>
                                    </select>
                                    {!! $errors->first('Affilier', '<span class="error">:message</span>') !!}
                                </div>
                            </div>

                            <div class="col-md-2">
                              <div class="form-group">
                                 <label>Du :</label>
                                 <input type="date" class="form-control" name="Debut"/>
                                </div>
                            </div>

                            <div class="col-md-3">
                              <div class="form-group">
                                <label>Au :</label>
                                <input type="date" class="form-control" name="Fin"/>
                              </div>
                            </div>
                            <div class="col-md-2">
                                <div class="form-group">
                                <label style="visibility: hidden;">Rech</label>
                                <button type="submit" class="btn btn-primary">Rechercher</button>
                                </div> 
                            </div>
                        </div>
                     </form>    
               <hr />
                 <!-- /. ROW  -->
                
               
            <div class="row">
                <div class="col-md-12">
                    <!-- Advanced Tables -->
                    <div class="panel panel-default">
                        <div class="panel-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                                    <thead>
                                        <tr>
                                            <th>CODE</th>
                                            <th>ADHERANT</th>
                                            <th>JANVIER</th>
                                            <th>FEVRIER</th>
                                            <th>MARS</th>
                                            <th>AVRIL</th>
                                            <th>MAI</th>
                                            <th>JUIN</th>
                                            <th>JUILLET</th>
                                            <th>AOUT</th>
                                            <th>SEPTEMBRE</th>
                                            <th>OCTOBRE</th>
                                            <th>NOVEMBRE</th>
                                            <th>DECEMBRE</th>
                                            <th>TOTAL</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                       {!! $tableListe !!}
                                    </tbody>
                                    <tfoot>
                                      @foreach($Somme as $S)
                                        <tr>
                                            <th>{{ $S->AF}}</th>
                                            <th>{{ $S->AF}}</th>
                                            <th>{{ $S->J}}</th>
                                            <th>{{ $S->F}}</th>
                                            <th>{{ $S->M}}</th>
                                            <th>{{ $S->A}}</th>
                                            <th>{{ $S->Ma}}</th>
                                            <th>{{ $S->Ju}}</th>
                                          <th>{{ $S->Jui}}</th>
                                            <th>{{ $S->Ao}}</th>
                                            <th>{{ $S->S}}</th>
                                            <th>{{ $S->O}}</th>
                                            <th>{{ $S->N}}</th>
                                            <th>{{ $S->D}}</th>
                                            <th>{{ $S->ST}}</th>
                                        </tr>
                                        @endforeach
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                    <!--End Advanced Tables -->
                </div>
            </div>
        </div>
               
    </div>
             <!-- /. PAGE INNER  -->
@endsection 

<script type="text/javascript">
    function research(va){
     var affilie= $(va).val();
     // var id_categorie= $("#Categorie").val();
      $.get('{{ route('researchAffilierCotisation') }}',
          {affilie:affilie},
          function(data){
            $("#prodReas").css('display','block');
            $('#Produit').html(data);
          });
   }
</script>