@extends('app')
@section('content')

        <!-- Content Header (Page header) -->



<section class="content-header">
    @if(Session::get('ADMINISTRATION_EMPLACEMENTS_AJOUTER'))

    <div class="box-tools pull-right">
        <a href="{{ url('emplacement/ajouter') }}" class="btn btn-block btn-primary">
            <span class="glyphicon glyphicon-plus" aria-hidden="false"></span>
            Ajouter
        </a>
    </div>
    <div class="box-tools pull-right" style="margin-right: 1%">
        @if(Session::get('ADMINISTRATION_EMPLACEMENTS_IMPORTER'))
        <a href="#importer" class="btn btn-block btn-success" data-toggle="modal">
            <span class="glyphicon glyphicon-download-alt" aria-hidden="false"></span>
                Importer
        </a>
            @endif
    </div>
    
    @endif
      
    <div class="box-tools pull-right" style="margin-right: 1%">
        @if(Session::get('ADMINISTRATION_EMPLACEMENTS_EXPORTER'))
        <a href="{{ route('exportEmp') }}" class="btn btn-block btn-success" >
            <span class="glyphicon glyphicon-export" aria-hidden="false"></span>
                Export
        </a>
            @endif
    </div>
    
    

    <h1>
        Gestion des emplacements de stockage
    </h1>

</section>

<!-- Main content -->
<section class="content">
    @if(Session::has('msgDeleteOk'))
        <div class="box box-success box-solid">
            <div class="box-header with-border">
                <div class="box-title">
                    <span> <i class="fa fa-check"></i></span>
                    <em>{!! session('msgDeleteOk') !!}</em>
                </div>
                <div class="box-tools pull-right">
                    <button class="btn btn-box-tool" data-widget="remove">
                        <i class="fa fa-times"></i>
                    </button>
                </div>
            </div>
        </div>
        @endif

        @if(Session::has('msgDeleteNotOk'))
            <div class="box box-warning box-solid">
                <div class="box-header with-border">
                    <div class="box-title">
                        <span> <i class="fa fa-check"></i></span>
                        <em>{!! session('msgDeleteNotOk') !!}</em>
                    </div>
                    <div class="box-tools pull-right">
                        <button class="btn btn-box-tool" data-widget="remove">
                            <i class="fa fa-times"></i>
                        </button>
                    </div>
                </div>
            </div>
            @endif
        @if(Session::has('msgAdd'))
            <div class="box box-success box-solid">
                <div class="box-header with-border">
                    <div class="box-title">
                        <span> <i class="fa fa-check"></i></span>
                        <em>{!! session('msgAdd') !!}</em>
                    </div>
                    <div class="box-tools pull-right">
                        <button class="btn btn-box-tool" data-widget="remove">
                            <i class="fa fa-times"></i>
                        </button>
                    </div>
                </div>
            </div>
            @endif

        @if(Session::has('msgAjouterAnnuler'))
    <div class="box box-danger box-solid">
        <div class="box-header with-border">
            <div class="box-title">
                <span> <i class="fa fa-check"></i></span>
                    Échec de l'importation.<br>
                <em>
                    <ul>
                        @foreach (session('msgAjouterAnnuler') as $key => $e)
                        <li>
                            Ligne {{ $key }} : {{ $e }}.
                        </li>
                        @endforeach
                    </ul>
                    
                </em>
            </div>
            <div class="box-tools pull-right">
                <button class="btn btn-box-tool" data-widget="remove">
                    <i class="fa fa-times"></i>
                </button>
            </div>
        </div>
    </div>
    @endif

     @if(Session::has('msgAjouter'))
    <div class="box box-success box-solid">
        <div class="box-header with-border">
            <div class="box-title">
                <span> <i class="fa fa-check"></i></span>
                <em>
                    {!! session('msgAjouter') !!}
                </em>
            </div>
            <div class="box-tools pull-right">
                <button class="btn btn-box-tool" data-widget="remove">
                    <i class="fa fa-times"></i>
                </button>
            </div>
        </div>
    </div>
    @endif

    @if(Session::has('msgAjouterErreur'))
    <div class="box box-danger box-solid">
        <div class="box-header with-border">
            <div class="box-title">
                <span> <i class="fa fa-check"></i></span>
                    Échec de l'importation.<br>
                <em>
                    @if (session('msgAjouterErreur')->count() != 0)
                    <ul>
                        @foreach (session('msgAjouterErreur') as $key =>$e)
                        <li>
                        Ligne {{ $key }} : {{ $e }}.
                        </li>
                        @endforeach
                    </ul>
                    @endif
                </em>
            </div>
            <div class="box-tools pull-right">
                <button class="btn btn-box-tool" data-widget="remove">
                    <i class="fa fa-times"></i>
                </button>
            </div>
        </div>
    </div>
    @endif



                <!-- Default box -->
        <div class="box">



            <table id="example1" class="table table-bordered table-striped dataTable">
                <thead>
                <tr role="row">
                    <th class="text-center sorting_asc">Libellé de l'emplacement</th>
                    <th class="text-center sorting_asc">Code à barres de l'emplacement</th>
                    <th class="text-center sorting_asc">Remarque</th>
                    <th class="text-center sorting_asc">Zone</th>
                    <th class="text-center sorting_asc">Volume max (m³)</th>
                    <th class="text-center sorting_asc">Taux d'occupation</th>
                    <th class="text-center sorting_asc">Etat</th>
                    @if(Session::get('CHARGEMENT')=='1')

                    <th class="text-center sorting_asc">Véhicule</th>
                    @endif
                    @if (Session::get('STOCK_EMPLACEMENT_MOBILE') == "1")
                        <th class="text-center sorting_asc">Détail</th>
                    @endif

                    @if(Session::get('ADMINISTRATION_EMPLACEMENTS_MODIFIER'))

                    <th class="text-center sorting_asc">Modifier</th>
                    @endif
                    @if(Session::get('ADMINISTRATION_EMPLACEMENTS_SUPPRIMER'))

                    <th class="text-center sorting_asc">Supprimer</th>
                        @endif
                </tr>
                </thead>

                <tbody>
                @foreach( $emplacements as $emplacement)
                    <tr role="row" class="odd">
                        <td class="text-center sorting_1">{!!$emplacement->libelle!!}</td>
                        <td class="text-center sorting_1">{!!$emplacement->code_identification!!}</td>
                        <td class="text-center sorting_1">{!!$emplacement->description!!}</td>
                        <td class="text-center sorting_1">{!!$emplacement->zone->libelle!!}</td>
                        <td class="text-center sorting_1">{!!$emplacement->volumeMax!!}</td>


                     <td>   <div class="progress">
                            <div class="progress-bar progress-bar-success" role="progressbar"
                                 aria-valuemin="0" aria-valuemax="100" style="width:{!!$emplacement->tauxOccupation!!}%">
                              <span style="color: #0c0c0c">{!!$emplacement->tauxOccupation!!}%</span>
                            </div>
                        </div>
                        </td>

                        <td class="text-center sorting_1">{!!$emplacement->etat!!}</td>
                        @if(Session::get('CHARGEMENT')=='1')

                        <td class="text-center sorting_1">{!!$emplacement->emplacement_mobile!!}</td>
                        @endif
                        @if (Session::get('STOCK_EMPLACEMENT_MOBILE') == "1")
                        
                        
                        <td class="text-center sorting_1">
                            <a class="glyphicon glyphicon-eye-open" style="cursor: pointer;" onclick="afficheDetail({{ $emplacement->id_emplacement }})"></a>
                        </td>
                        @endif
                        @if(Session::get('ADMINISTRATION_EMPLACEMENTS_MODIFIER'))

                        <td class="text-center sorting_asc">
                            <a href="{{url('emplacement/modifier')}}/{{$emplacement->id_emplacement}}" class="glyphicon glyphicon-edit"></a>
                        </td >
                        @endif
                        @if(Session::get('ADMINISTRATION_EMPLACEMENTS_SUPPRIMER'))

                        <td class="text-center sorting_asc">
                            <a href="#DeleteModal{{$emplacement->id_emplacement}}" class=" open-AddBookDialog glyphicon glyphicon-trash" data-toggle="modal"></a>
                        </td>
                            @endif
                    </tr>
                    <!--

                    <tr role="row" class="odd">
                        <td class="sorting_1">Gecko</td>
                        <td>Firefox 1.0</td>
                        <td>Win 98+ / OSX.2+</td>
                        <td>1.7</td>
                        <td>A</td>
                        <td>A</td>
                        <td>A</td>
                    </tr>
                    -->




                    <div class="example-modal">
                        <div class="modal" id="DeleteModal{{$emplacement->id_emplacement}}">
                            <div class="modal-dialog">
                                <div class="modal-content">
                                    <div class="modal-header">
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span></button>
                                        <h4 class="modal-title" style="font-family:verdana;"> Confirmation </h4>
                                    </div>
                                    <div class="modal-body">
                                        <p>Voulez-vous vraiment supprimer cet emplacement " {{$emplacement->libelle}} " ?</p>
                                    </div>

                                    <div class="modal-footer">
                                        {!! Form::open(['method' => 'POST', 'action' => ['EmplacementController@delete',$emplacement->id_emplacement]]) !!}
                                        <input type="submit" class="btn btn-flat btn-primary pull-right" value="Valider">
                                        <button type="button" class="btn btn-flat btn-danger pull-right " data-dismiss="modal">Annuler</button>
                                        {!! Form::close() !!}
                                    </div>
                                </div>
                                <!-- /.modal-content -->
                            </div>
                            <!-- /.modal-dialog -->
                        </div>
                        <!-- /.modal -->
                    </div>


                @endforeach
                </tbody>

            </table>



        </div><!-- /.box -->
        <div class="modal fade" id="modal-detail_ue">
          <div class="modal-dialog ">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title">Liste des UE </h4>
              </div>
              <div class="modal-body">
            
                <main id="tebleau">
                    <table id="example7" class="table table-bordered table-striped" style="text-align: center">
                        <thead>
                            <tr role="row">
                                <th class="text-center sorting_asc">N° UE</th>
                                <th class="text-center sorting_asc">Nombre de produit</th>  
                                <th class="text-center sorting_asc">Etat UE</th>  
                            </tr>
                        </thead>
                        <tbody>        
                        </tbody>
                    </table>
                </main>
             
              </div>
              <div class="modal-footer">
               
                <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
        <!-- /.modal -->
</section><!-- /.content -->

<div class="example-modal">
        <div class="modal" id="importer">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span></button>
                            <h3 class="modal-title" style="font-family:verdana;">Importer les emplacements </h3>
                        </div>
                        <div class="modal-body">
                            <p>Importer les emplacements depuis un fichier xls ou xlsx. Télécharger le modèle et ouvrir Excel  pour voir le format avec tous les champs acceptés.
                            </p>

                            {!! Form::open(['method'=>'POST','action' => ['EmplacementController@downloadModele']]) !!}
                            <div class="col-sm-7">
                                <label class="control-label">Télécharger le fichier modèle</label>

                            </div>


                            <input id="btnDwnld" class="btn btn-success col-sm-4" type="submit"  value="Télécharger le modèle "  name="dwnld">
                            <br>
                            <br>
                            {!! Form::close() !!}
                           
                            
                                {!! Form::open(['url'=>'emplacement/upload', 'files' => true,'enctype'=>'multipart/form-data']) !!}
                                        <div class="col-sm-7">
                                            <input type="file" id="file" name="file"  class="form-control" onchange="verifInput(this.id, 'btnSubmit');" accept=".xls,.xlsx,.csv" required>
                                        </div>
                                        <input id="btnSubmit" class="btn btn-success col-sm-4" type="submit" value="Importer le fichier" disabled="disabled" name="submit" onClick="toggle_visibility('tips');">

                                        {!! Form::close() !!}
                            
                            



                            <div class="modal-footer">



                            </div>
                        </div>
                        <!-- /.modal-content -->
                    </div>
                    <!-- /.modal-dialog -->
                </div>
                <!-- /.modal -->
            </div>
        </div>
<div hidden="true">
         <table id="headerTable" border="1px" style="font-size:14px;text-align: center ">
   
        <tr>
            <td>Libellé*</td>
            <td>Code à barres*</td>
            <td>Libellé zone*</td>
            <td>Volume max (m³)*</td>
            <td>Véhicule*</td>
            <td>Remarque</td>
        </tr>
    
    
        @foreach ($emplacements as $element)
            <tr>
                <td>{{ $element->libelle }}</td>
                <td>{{ $element->code_identification }}</td>
                <td>{{ $element->zone->libelle }}</td>
                <td>{{ $element->volumeMax }}</td>
                <td>{{ $element->emplacement_mobile }}</td>
                <td>{{ $element->description }}</td>
            </tr>
        @endforeach
   
</table>
</div>

<script type="text/javascript">
    
    function doit(type, fn, dl) {
        var elt = document.getElementById('headerTable');
        var wb = XLSX.utils.table_to_book(elt, {sheet:"Feuil1"});
        return dl ?
            XLSX.write(wb, {bookType:type, bookSST:true, type: 'base64'}) :
            XLSX.writeFile(wb, fn || ('Les emplacements.' + (type || 'xlsx')));
    }

    
    function afficheDetail(id_emplacement){
        $.ajax({
                    url: "{{url('emplacement/detail_ue')}}/"+id_emplacement,
                    method : "post",   
                    data: {
                    "_token": "{{ csrf_token() }}"
                    } ,        
                    success: function(data){ 
                        var t = $('#example7').DataTable();
                        t.clear().draw();
                        var etat = '';
                        var myModal = $('#modal-detail_ue');
                            var vals = Object.keys(data).map(function(key) {
                                if(data[key].etat_ue == 0){
                                    etat ='FERMER';
                                }
                                if(data[key].etat_ue == 1){
                                    etat ='OUVERT';
                                }
                                if(data[key].etat_ue == 2){
                                    etat ='VIDE';
                                }
                            t.row.add( [
                                       data[key].num_ue,
                                       data[key].nbr_produit,
                                       etat
                                       
                                    ] ).draw( false );
                            }); 
                        
                        myModal.modal({ show: true });                                   
                    },
                    error: function(data){
                        alert('oops erreur de serveur !!');
                      }
                  }); 
      }

      function verifInput(id, idSubmit) {
                if(document.getElementById(id).value != ""){
                    document.getElementById(idSubmit).disabled = false;
                }
            }
</script>


@endsection