@extends('layouts.default') 
@section('content')
    <style>
        text.amcharts-pie-label {
            font-size: 8px!important;
        }
        .p-1{padding: 2px!important;}
        .m-1{margin: 2px!important;}
        .flex-container {
          display: flex;
          justify-content: space-between;
        }
        .flex-container > div {
          text-align: center;
        }
        .b-icon{
            position: absolute;
            font-size: 27px;    
            top: 10px;
            right: 20px;
        }
        .relative{ position: relative; }
        .absolute{ position: absolute; }
        .selected-inventaire{
            border: 3px solid dodgerblue;
            border-radius: 20px!important;
        }
        .z-depth-0>span{font-size: 14px;}
        .inputPosition{
            width: 110px!important;
            font-size: 15px!important;
            border: 1px solid #ada7a7!important;
            padding-left: 5px!important;
            height: 14px!important;
        }
        .bg-green{
            background: green!important;
        }
        .bg-green>td.text-center{
            color:#fff!important;
        }
    </style>
    <!--
    <div style="position: fixed;z-index:999999;bottom: 0px;right: 0px;left: 0px;height:35px;text-align: center;font-size: 20px;color: #fff;background: red;"></div>-->
    <!-- <a href="{{-- route('inv_somocer.updateStock') --}}" class="btn btn-success" 
    style="position: absolute;right: 332px;top: 7px;" >
        Update Stock
    </a> -->
    <a href="{{ route('stock.index') }}" class="btn btn-danger" style="position: absolute;right: 502px;;top: 7px;">
        Vider Stock
    </a>
    <a href="{{ route('hors_inventaire.horsCorrespandence') }}" class="btn btn-primary" style="position: absolute;right: 331px;top: 7px;">
        hors Correspondance
    </a>
    <a href="{{ route('hors_inventaire.index_somocer') }}" class="btn btn-primary" style="position: absolute;right: 200px;top: 7px;">
        Hors Inventaire
    </a>
    <a href="{{ route('positionSomocer.indexSomocer') }}" class="btn btn-primary" 
    style="position: absolute;right: 111px;top: 7px;">Position</a>
    <div class="row">
        <div class="col-md-3 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #8ad2e8;">
                <h3 class="pull-left">{{$nbr_produits}}</h3>
                <h3 class="pull-right">{{$nbr_cab}}</h3>
                <div class="clearfix"></div>
                <div class="pull-left"> Produits</div>
                <div class="pull-right"> Code a barre</div>
            </div>
        </div>
        <div class="col-md-3 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #8aefc5;">
                <h3 class="pull-left">{{$inventorie}}</h3>
                <h3 class="pull-right">{{$inventorie_code}}</h3>
                <div class="clearfix"></div>
                <div class="pull-left" title="Code a barre Scanné"> Code Scanné</div>
                <div class="pull-right">Article Inventorié</div>
            </div>
        </div>
        <!--<div class="col-md-2 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #8aefc5;">
                <h3>{{$inventorie}}</h3>
                <i class="fa fa-barcode b-icon"></i>
                <div class="pull-right">Nbr de Code a barre Scanné</div>
            </div>
        </div>-->
        <div class="col-md-3 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #cdf5a9;">
                <h3>{{ $ecart }}</h3>
                <i class="fa fa-barcode b-icon"></i>
                <div class="pull-right">Nbr de produit avec ecart</div>
            </div>
        </div>

        <div class="col-md-3 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #8ad2e8;">
                <h3>{{$agent}}</h3>
                <i class="fa fa-users b-icon"></i>
                <div class="pull-right">Nbr d'Agent</div>
            </div>
        </div>
        <!--
        <div class="col-md-2 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #03c173;color: #fff;">
                <h3>{{$prix_achat}}</h3>
                <i class="fa fa-usd b-icon"></i>
                <div class="pull-left">0%</div>
                <div class="pull-right">Ecart Valorisé Achat</div>
            </div>
        </div>
        <div class="col-md-2 p-1">
            <div class="panel panel-body p-1 m-1 relative" style="background: #f34137;color: #fff;">
                <h3>{{$prix_vente}}</h3>
                <i class="fa fa-usd b-icon"></i>
                <div class="pull-left">0%</div>
                <div class="pull-right">Ecart Valorisé Vente</div>
            </div>
        </div>
        -->
    </div>
    <div class="row">
        <!-- {{-- 
        <div class="col-md-4">
            <div class="panel panel-body">
                @if(session('success'))
                <div class="alert alert-success">{{session('success')}}</div>
                @endif
                 @if(session('warning'))
                <div class="alert alert-warning">{{session('warning')}}</div>
                @endif
                <form action="{{ route('dashboard.importInventaire')}}"  
                    enctype="multipart/form-data" method="POST" 
                    class="form-inline text-center" style="margin-top: -15px;">
                    {{ csrf_field() }}
                  <input type="text" class="form-control" name="inventaire_code" placeholder="Saisir code Inventaire...">
                  <input type="file" class="form-control" id="file" name="file" placeholder="Excel"
                            title="Télécharger fichier excel" style="width: 150px;">
                  <button type="submit" class="btn btn-info" style="margin-top: 1px;"
                            title="Enregistrer"><i class="fa fa-save"></i></button>
                </form>
                <div class="relative">
                    <a href="{{asset('uploads/ModelInventaire.xlsx')}}" class="absolute"
                        style="z-index: 1;top: 11px;left: 10px;color: blue;text-decoration: underline;">
                        Telecharger le Model
                    </a>
                    <table class="table" id="list-invs">
                        <thead>
                            <tr>
                                <th class="text-center">Code</th>
                                <th class="text-center">Article(s)</th>
                                <th class="text-center">Date</th>
                                <th class="text-center">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                        @if(count($liste_inventaire) > 0)
                            @foreach($liste_inventaire as $k => $inventaire)
                            <tr style="@if($inventaire->cloture==1) background: aquamarine; @else background: antiquewhite; @endif" 
                                class="@if($k==0) selected-inventaire @endif" 
                                id="inv-{{$inventaire->id}}">

                                <td class="text-center">
                                    <a onclick="selectInventaire('{{$inventaire->id}}', '{{$inventaire->code}}', '{{$inventaire->created_at}}');" style="color: blue;">
                                        {{ $inventaire->code }}
                                    </a>
                                </td>
                                <td class="text-center">
                                        {{ $inventaire->sum }}
                                </td>
                                <td class="text-center">
                                    @if(!is_null($inventaire->created_at))
                                        {{date('d/m/Y', strtotime($inventaire->created_at))}}
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if($inventaire->cloture == 0)
                                       <button class="btn btn-info btn-xs" style="margin:0px!important"
                                        onclick="clotureInventaire('{{ $inventaire->code }}');">
                                            <i class="fa fa-check-square" aria-hidden="true"></i>
                                       </button>
                                    @endif
                                       <button class="btn btn-danger btn-xs" style="margin:0px!important"
                                        onclick="deleteInventaire('{{ $inventaire->code }}');">
                                            <i class="fa fa-trash" aria-hidden="true"></i>
                                       </button>
                                </td>
                            </tr>
                            @endforeach
                        @endif
                        </tbody>
                    </table>
                </div>
                _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_--_-_-_-__ hors inv bro -_-_-_-_-_-__-_-_-_-_-_-_-_-_-_ 
            </div>
        </div>
        --}}
        -->
        <div class="col-md-10 col-md-offset-1">
            <div class="panel panel_body">
                <div class="relative" style="min-height: 400px;">
                    @if(isset($liste_inventaire[0]))
                    <!--
                    <a class="btn btn-warning" 
                        href="{{-- route('inv_somocer.exportInventaireWithEcart', ['code' => $lastInventaire, 'avec_ecart' => 1]) --}}"
                        style="position: absolute;left:42px;"
                            title="Exporter table Excel avec Ecart">
                        <i class="fa fa-file-excel-o"></i>
                    </a>  

                    <a class="btn btn-success" 
                        href="{{--  route('inv_somocer.exportInventaireWithEcart', ['code' => $lastInventaire, 'avec_ecart' => 0]) --}}"
                        style="position: absolute;left:82px;"
                            title="Exporter table Excel sans Ecart">
                        <i class="fa fa-file-excel-o"></i>
                    </a>                   
                    -->
                    @endif
                    
                    <img src="{{asset('images/loading.gif')}}" id="loading" style="position: absolute;
                                                                                top: 74px;
                                                                                left: 38%;
                                                                                width: 200px;
                                                                                display: none;">
                    
                    <input type="hidden" id="inventaire_code" value="@if(isset($liste_inventaire[0])) {{$liste_inventaire[0]->code}} @endif">
                    <input type="hidden" id="inventaire_date" value="@if(isset($liste_inventaire[0])) {{$liste_inventaire[0]->created_at}} @endif">
                    
                    <form action="" method="GET" class="form-inline text-center">
                            <input type="text" name="code" placeholder="Nlot..." 
                                    style="width: 200px!important;" @if($code) value="{{$code}}" @endif>

                            <input type="text" name="code_a_barre" placeholder="ITMREF" 
                                    style="width: 200px!important;" @if($code) value="{{$code_a_barre}}" @endif>
                            
                            <!--
                            <input type="text" name="designation" placeholder="Designation..." 
                                    style="width: 200px!important;" @if($designation) value="{{$designation}}" @endif>
                            -->

                            <input type="text" name="position" placeholder="Position..." 
                                    style="width: 150px!important;" @if($position) value="{{$position}}" @endif>

                            <input type="text" name="position_somocer" placeholder="position Théorique..." 
                                    style="width: 150px!important;" @if($position_somocer) value="{{$position_somocer}}" @endif>

                            <input type="text" name="date_inventaire_debut" placeholder="Date Inventaire Début..." 
                                    class="datepicker-dashb" data-language="fr" data-date-format="yyyy-mm-dd" autocomplete="off"
                                    style="width: 100px!important;" @if($date_inventaire_debut) value="{{$date_inventaire_debut}}" @endif>

                            <input type="text" name="date_inventaire_fin" placeholder="Date Inventaire Fin..." 
                                    class="datepicker-dashb" data-language="fr" data-date-format="yyyy-mm-dd"autocomplete="off"
                                    style="width: 100px!important;" @if($date_inventaire_fin) value="{{$date_inventaire_fin}}" @endif>


                            <div class="clearfix"></div>
                            <input type="checkbox" name="stock_inventaire" 
                                    @if($stock_inventaire_v == "on") checked @endif>
                            <label >StockInventaire</label>

                            <input type="checkbox" name="stock_non_traite" 
                                    @if($stock_non_traite == "on") checked @endif>
                            <label  title="stock = 0">Non traité</label>

                            <input type="checkbox" name="stock_ecart" 
                                    @if($stock_ecart == "on") checked @endif>
                            <label  title="stock_ecart <> 0">Ecart</label>
                            
                            <input type="checkbox" name="ecart_zero" 
                                    @if($ecart_zero == "on") checked @endif>
                            <label  title="ecart = 0">Sans Ecart</label>

                            <input type="checkbox" name="ecart_positive" 
                                    @if($ecart_positive == "on") checked @endif>
                            <label  title="Ecart > 0">Ecart positive</label>

                            <input type="checkbox" name="ecart_negative" 
                                    @if($ecart_negative == "on") checked @endif>
                            <label  title="Ecart < 0">Ecart Négative</label>

                            <input type="checkbox" name="diff_position" 
                                    @if($diff_position == "on") checked @endif>
                            <label  title="P.Théorique <> P.Physique">Diff Position</label>

                            <input type="checkbox" name="meme_position" 
                                    @if($meme_position == "on") checked @endif>
                            <label  title="P.Théorique = P.Physique">Meme Position</label>

                            <button class="btn btn-primary btn-sm" type="submit"><i class="fa fa-search"></i></button>
                            <a href="{{ route('dashboard')}}" class="btn btn-warning btn-sm"><i class="fa fa-times"></i></a>
                            <a class="btn btn-success btn-sm" type = "button"
                                href="{{ route('inv_somocer.exportInventaireSomocer', [
                                                'code' => $lastInventaire, 
                                                'nlot' => $code,
                                                'itmref' => $code_a_barre,
                                                'position' => $position,
                                                'position_somocer' => $position_somocer,
                                                'stock_inventaire_v' => $stock_inventaire_v,
                                                'stock_non_traite' => $stock_non_traite,
                                                'stock_ecart' => $stock_ecart,
                                                'ecart_zero' => $ecart_zero,
                                                'ecart_positive' => $ecart_positive,
                                                'ecart_negative' => $ecart_negative,
                                                'diff_position' => $diff_position,
                                                'meme_position' => $meme_position,
                                                'date_inventaire_debut' => $date_inventaire_debut,
                                                'date_inventaire_fin' => $date_inventaire_fin
                                      ])}}"
                            title="Exporter table Excel">
                        <i class="fa fa-file-excel-o"></i>
                    </a>
                    </form>
                    <!-- id="datatable-inv" -->

                    <!-- <h4 class="pull-right">
                        {{-- $inventaires->total() --}} 
                    </h4> -->
                    <h5 class="pull-left" style="color: blue;margin-bottom: 0px;margin-top: 27px;">Total : {{ $inventaires->total() }} Produits </h5>

                    @if($inventaires->perPage() < $inventaires->total())
                    <div class="pull-right" style="height: 45px;">{{ $inventaires->appends($_GET)->links() }}</div>
                    @endif
                    <div class="clearfix"></div>
                    <table class="table" id="datatable-inv">
                        <thead>
                          <tr>
                            <th class="text-center">Nlot</th>
                            <th class="text-center">ITMREF</th>
                            <th class="text-center">STA</th>
                            <th class="text-center" title="stock_théorique">QTE théorique</th>
                            <th class="text-center">QTE carton</th>
                            <th class="text-center">Stock Inventaire</th>
                            <th class="text-center">Ecart</th>
                            <th class="text-center" title="Position Théorique">P.Théorique</th>
                            <th class="text-center"title="Position Physique">P.Physique</th>
                            <th class="text-center" title="commentaire">Com</th>
                            <th class="text-center" title="etiquette">Etiq</th>

                            <th class="text-center" >Heure</th>
                            <th class="text-center">Date</th>

                            <th class="text-center">Agent</th>
                          </tr>
                        </thead>
                        <tbody id="panel_details">
                        @if(count($inventaires)>0)
                          @foreach($inventaires as $inventaire)
                                                      <tr>
                                <td class="text-center">
                                    <div data-toggle="modal" data-target="#panel_position_modal" class="c-blue" 
                                        onclick="getPositionsStockMultiple('{{$inventaire->inventaire_code}}','{{$inventaire->code}}');"> 
                                        {{$inventaire->code}}
                                    </div>
                                    </td>
                                <td class="text-center" style="@if($ecart<0) background: #fd8787;
                                @elseif ($ecart> 0) background: #32CD32 @endif">
                                    {{$inventaire->code_a_barre}}
                                </td>
                                <td class="text-center">{{$inventaire->STA}}</td>
                                <td class="text-center">{{$inventaire->stock_theorique}}</td>
                                <td class="text-center">{{$inventaire->qte_carton}}</td>
                                <td class="text-center">
                                    <div data-toggle="modal" data-target="#panel_position_modal" class="c-blue" 
                                        onclick="getPositionsStockMultiple('{{$inventaire->inventaire_code}}','{{$inventaire->code}}');"> 
                                        {{$inventaire->stock_inventaire}}
                                    </div>
                                    </td>
                                <td class="text-center" style="@if($ecart<0) background: #fd8787;
                                @elseif ($ecart> 0) background: #32CD32 @endif">
                                     {{$ecart}}
                                </td>
                                <td class="text-center" title="Hors Inventaire"
                                    @if($inventaire->ajout==1) style="background:yellow!important" @endif>
                                    {{$inventaire->position1}}
                                </td>
                                <td class="text-center">{{$inventaire->position2}}</td>
                                <td class="text-center">{{$inventaire->commentaire}}</td>
                                <td class="text-center">{{$inventaire->etiquette}}</td>
                                <td class="text-center">{{ $inventaire->heure_stock }}</td>
                                <td class="text-center">{{$inventaire->date_inventaire}}</td>
                                <td class="text-center">{{$inventaire->user}}</td>
                            </tr>
                          @endforeach
                        @endif
                        </tbody>
                    </table>
                     @if(count($inventaires) > 0)
                    <div class="pull-right">{{ $inventaires->appends($_GET)->links() }}</div>
                    @endif
                </div>
            </div>
        </div>

        
    </div>


<!-- Modal -->
<div class="modal fade" id="panel_position_modal" tabindex="-1" role="dialog" aria-labelledby="panel_position_modalTitle" aria-hidden="true">
  <div class="modal-dialog modal-dialog-centered" role="document">
    <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>
        <h5 class="modal-title" id="exampleModalLongTitle">Position et stock</h5>
      </div>
      <div class="modal-body">
        <div id="panel_stock_postions"></div>
      </div>
    </div>
  </div>
</div>


<!-- Modal -->
<div class="modal fade" id="modal_hors_inv" role="dialog" aria-labelledby="modal_hors_invTitle" aria-hidden="true">
  <div class="modal-dialog modal-dialog-centered" role="document">
    <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>
        <h5 class="modal-title" id="exampleModalLongTitle">Affecter Code a barre</h5>
      </div>
      <div class="modal-body">
        <div id="panel_hors_inv"></div>
      </div>
    </div>
  </div>
</div>


<div class="modal fade" id="exportBytime" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Export Inventaire [Interval]</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <form action="{{ route('dashboard.InventaireExportTime', ['code' => $lastInventaire])}}"
                method="GET">
            <div class="form-group">
                <label for="date">Datetime Début</label>
                <input type="datetime-local" class="form-control" name="datetime_debut" required>
            </div>
            <div class="form-group">
                <label for="date">Datetime Fin</label>
                <input type="datetime-local" class="form-control" name="datetime_fin" required>
            </div>
            <button type="submit" class="btn btn-primary"><i class="fa fa-file-excel-o"></i></button>

        </form>
      </div>
    </div>
  </div>
</div>
<script>
    
    function getInventaireInfo(){
        var code = $('#inventaire_code').val();
        var date = $('#inventaire_date').val();
        date=moment(date).format('DD-MM-YYYY');
        return `inventaire_-_${code}_-_${date}`;
    };


    function selectInventaire(id, code, date){
        $('#inventaire_code').val(code);
        $('#inventaire_date').val(date);

        $('.selected-inventaire').removeClass('selected-inventaire');
        $('#inv-'+id).addClass('selected-inventaire');

        $('#panel_details').empty();
        $('#panel_details_hors_inv').empty();
        $('#loading').css("display", "block");

        $.ajax({
            url: '{{route("dashboard.getInventaire")}}',
            type: 'GET',
            data: {id: id, code:code},
        })
        .done(function(response) {
            var tr = ``;
            var trhors = ``;
            response.inventaire.forEach( function(element, index) {
                var ecart = element.stock_inventaire - element.stock_theorique;
                var stock_inventaire = (element.stock_inventaire== null) ? '' : element.stock_inventaire;

                var date_theorique  = (element.date_theorique== null)  ? '' : moment(element.date_theorique).format('DD/MM/YYYY');

                var date_inventaire  = (element.date_inventaire== null)  ? '' : moment(element.date_inventaire).format('DD/MM/YYYY');

                var position         = (element.position== null) ? '' : element.position;
                var user        = (element.user== null) ? '' : element.user;

                var style = (ecart < 0) ? 'background:#fd8787' : '';
                tr += `
                    <tr>
                        <td class="text-center">${element.code}</td>
                        <td class="text-center">${element.code_a_barre}</td>
                        <td class="text-center" style="${style}">${element.designation}</td>
                        <td class="text-center">${element.prix_achat}</td>
                        <td class="text-center">${element.prix_vente}</td>
                        <td class="text-center">${date_theorique}</td>
                        <td class="text-center">${element.stock_theorique}</td>
                        <td class="text-center">${stock_inventaire}</td>
                        <td class="text-center">${date_inventaire}</td>
                        <td class="text-center" style="${style}">${ecart}</td>
                        <td class="text-center">${position}</td>
                        <td class="text-center">${user}</td>
                    </tr>
                `;
            });
            response.hors_inventaire.forEach( function(element, index) {
                trhors += `
                    <tr>
                        <td class="text-center">${element.code_a_barre}</td>
                        <td class="text-center">${element.stock_inventaire}</td>
                    </tr>
                `;
            });
            $('#loading').css("display", "none");
            $('#panel_details').append(tr);
            $('#panel_details_hors_inv').append(trhors);
        })
        .fail(function() {
            console.log("error");
        });       
    };

    function exportInventaire(){
        var code = $('#inventaire_code').val();
        var date = $('#inventaire_date').val();
        //console.log(code);
         $.ajax({
            url: '{{route("dashboard.getInventaire")}}',
            type: 'GET',
            data: {code:code},
        })
        .done(function(response) {
           // console.log(response);
            response.inventaire.forEach( function(element, index) {
                response.inventaire[index]['ecart'] = element.stock_inventaire - element.stock_theorique;
                response.inventaire[index].stock_inventaire = (element.stock_inventaire== null) ? '' : element.stock_inventaire;
                response.inventaire[index].date_theorique  = (element.date_theorique== null)  ? '' : moment(element.date_theorique).format('DD/MM/YYYY');
                response.inventaire[index].date_inventaire  = (element.date_inventaire== null)  ? '' : moment(element.date_inventaire).format('DD/MM/YYYY');
                response.inventaire[index].position         = (element.position== null) ? '' : element.position;
                response.inventaire[index].user_code        = (element.user_code== null) ? '' : element.user_code;
            });
            var filename = getInventaireInfo();

            var file = {
                  sheetid: filename,
                  headers: true,
                  caption: {
                      title:filename,
                      style:'font-size: 50px; color:blue!important;'
                  },
                  column: {
                      style:'font-size:20px;background:#d1d1d1;'
                  },
                  columns: [
                    {columnid:'inventaire_code',title: 'Code Inventaire'},
                    {columnid:'code',title: 'Code produit'},
                    {columnid:'code_a_barre',title: 'Code a barre'},
                    {columnid:'designation',title: 'Désignation'},
                    {columnid:'prix_achat',title: 'P.Achat'},
                    {columnid:'prix_vente',title: 'P.Vente'},
                    {columnid:'date_theorique',title: 'Date théorique'},
                    {columnid:'stock_theorique',title: 'Stock théorique'},
                    {columnid:'stock_inventaire',title: 'Stock Inventaire'},
                    {columnid:'ecart',title: 'Ecart'},
                    {columnid:'date_inventaire',title: 'Date Inventaire'},
                    {columnid:'position',title: 'Position'},
                    {columnid:'user_code',title: 'Utilisateur'},
                    {columnid:'cloture',title: 'Cloturé'}   
                  ],
                  row: {
                      style: function(sheet,row,rowidx){
                          return 'text-align:center;background:'+(rowidx%2?'#fff':'#f1f1f1')+';height:100px!important;';
                      }
                  }
            };
            alasql('SELECT * INTO XLS("'+ filename +'.xls",?) FROM ?',[file,response.inventaire]);
        })
        .fail(function() {
            console.log("error");
        });
    };

    function exportInventaireCabStock(){
        var code = $('#inventaire_code').val();
        var date = $('#inventaire_date').val();
        //console.log(code);
         $.ajax({
            url: '{{route("dashboard.exportInventairePharma")}}',
            type: 'GET',
            data: {code:code},
        })
        .done(function(response) {
            console.log(response.inventaire);
            response.inventaire.forEach( function(element, index) {
                response.inventaire[index].stock_inventaire = (element.stock_inventaire== null) ? '' : element.stock_inventaire;
            });
            var filename = getInventaireInfo();

            var file = {
                  sheetid: filename,
                  headers: false,
                  column: {
                      style:'font-size:20px;background:#d1d1d1;',
                      cell: {
                            format : function(value){
                                return value.toString()
                            }
                      }
                  },
                  columns: [
                    {columnid:'code_a_barre',title: 'Code a barre'},
                    {columnid:'stock_inventaire',title: 'Stock Inventaire'}
                  ],
                  row: {
                      style: function(sheet,row,rowidx){
                          return 'text-align:center;background:'+(rowidx%2?'#fff':'#f1f1f1')+';height:100px!important;';
                      }
                  }
            };
            alasql('SELECT CONVERT(STRING,code_a_barre,12) as code_a_barre,stock_inventaire  INTO XLS("'+ filename +'.xls",?) FROM ?',[file,response.inventaire]);
        })
        .fail(function() {
            console.log("error");
        });
    };

    function clotureInventaire(code){
        Swal.fire({
          title: 'Cloturé l\'inventaire numero : '+code,
          text: "",
          type: 'warning',
          showCancelButton: true,
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33',
          confirmButtonText: 'Oui',
          cancelButtonText: 'Non'
        }).then((result) => {
            if (result.value) {
                $.ajax({
                    url: '{{route("dashboard.clotureInventaire")}}',
                    type: 'POST',
                    data: {code: code},
                    headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
                })
                .done(function(response) {
                    if(response.success==true){
                        Swal.fire(
                          'Inventaire '+code+' Cloturé!',
                          '',
                          'success'
                        );
                        window.location.reload();
                    }  
                })
                .fail(function() {
                    console.log("error");
                    Swal.fire(
                      'Oups!',
                      'error.',
                      'warning'
                    );
                });      
            }
        })
    };

    function deleteInventaire(code){
        Swal.fire({
          title: 'Supprimer l\'inventaire : '+code+' ?',
          text: "",
          type: 'warning',
          showCancelButton: true,
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33',
          confirmButtonText: 'Oui',
          cancelButtonText: 'Non'
        }).then((result) => {
            if (result.value) {
                $.ajax({
                    url: '{{route("dashboard.deleteInventaire")}}',
                    type: 'POST',
                    data: {code: code},
                    headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
                })
                .done(function(response) {
                    if(response.success==true){
                        Swal.fire(
                          'Inventaire Supprimé!',
                          'Succé',
                          'success'
                        );
                        window.location.reload();
                    }  
                })
                .fail(function() {
                    console.log("error");
                    Swal.fire(
                      'Oups!',
                      'Erreur.',
                      'warning'
                    );
                });      
            }
        })
    };

    // function getPositionsStock(inventaire, code){
        
    //     $('#panel_stock_postions').empty();

    //     $.ajax({
    //         url: '{{route("inv_somocer.getPositionsStock")}}',
    //         type: 'GET',
    //         data: {
    //                 inventaire_code : inventaire,
    //                 code : code 
    //             },
    //     })
    //     .done(function(response) {
    //         if(response.length> 0){
    //             var block = ``;
    //             var tr = '';
    //             response.forEach( function(element, index) {
    //                 var id = element.code_a_barre.replace(/ /g, '') +'_'+element.position.replace(/ /g, '');
    //                 var id_pos = id+'_pos';
    //                 var id_type = id+'_type';
    //                 var stock_inventaire = (element.stock_inventaire) ? element.stock_inventaire : '';
    //                 var position = (element.position) ? element.position : '';
    //                 var type = (element.type) ? element.type : 'piece';
    //                 tr += `
    //                     <tr>
    //                         <td class="text-center">${element.code_a_barre}</td>
    //                         <td class="text-center">
    //                             <input type="text" class="inputPosition" id="${id}" value="${stock_inventaire}" />
    //                         </td>
    //                         <td class="text-center">
    //                             <input type="text" class="inputPosition"  id="${id_pos}" value="${position}"/>
    //                         </td>
    //                         <td class="text-center">
    //                             <input type="text" class="inputPosition"  id="${id_type}" value="${type}"/>
    //                         </td>
    //                         <td class="text-center">${element.date_inventaire}</td>
    //                         <td class="text-center">
    //                             <button class="btn btn-success btn-xs" style="margin:0px;"
    //                             onclick="updatequantiteposition('${element.code_a_barre}', '${element.position}', '${element.code}')">
    //                                 <i class="fa fa-save"></i>
    //                             </button>
    //                         </td>
    //                     </tr>
    //                 `;
    //             });

    //             block += `<h3 class="text-center">${response[0].code}</h3>`;
             
    //             block += `<table class="table">
    //                 <thead>
    //                     <tr>
    //                         <th class="text-center">ITMREF</th>
    //                         <th class="text-center">Quantite stock</th>
    //                         <th class="text-center">Position</th>
    //                         <th class="text-center">Type</th>
    //                         <th class="text-center">Date</th>
    //                         <th class="text-center">Action</th>
    //                     </tr>
    //                 </thead>
    //                 <tbody>
    //                     ${tr}
    //                 </tbody>
    //             </table>`;
    //             $('#panel_stock_postions').append(block);

    //         }
            
    //     })
    //     .fail(function() {
    //         console.log("error");
    //     }); 
    // };

    function getPositionsStockMultiple(inventaire, code){
        
        $('#panel_stock_postions').empty();

        $.ajax({
            url: '{{route("inv_somocer.getPositionsStockMultiple")}}',
            type: 'GET',
            data: {
                    inventaire_code : inventaire,
                    code : code 
                },
        })
        .done(function(response) {
            if(response.length> 0){
                var block = ``;
                var tr = '';
                response.forEach( function(element, index) {
                    var id= element.id+'_'+element.code_a_barre.replace(/ /g, '') + '_'+element.position.replace(/ /g, '');
                    var id_pos = id+'_pos';
                    var id_etiquette = id+'_etiquette';

                    var stock_inventaire = (element.stock_inventaire) ? element.stock_inventaire : '';
                    var position = (element.position) ? element.position : '';
                    var type = (element.type) ? element.type : 'piece';
                    var etiquette = (element.etiquette) ? element.etiquette : '';
                    tr += `
                        <tr>
                            <td class="text-center">${element.code_a_barre}</td>
                            <td class="text-center">
                                <input type="text" class="inputPosition" id="${id}" value="${stock_inventaire}" />
                            </td>
                            <td class="text-center">
                                <input type="text" class="inputPosition"  id="${id_pos}" value="${position}"/>
                            </td>
                            <td class="text-center">
                                <input type="text" class="inputPosition"  id="${id_etiquette}" value="${etiquette}"/>
                            </td>
                            <td class="text-center">${element.date_inventaire}</td>
                            <td class="text-center">
                                <button class="btn btn-success btn-xs" style="margin:0px;"
                                onclick="updatequantiteposition('${element.code_a_barre}', '${element.position}', '${element.code}', '${element.id}', '${element.date_inventaire}')">
                                    <i class="fa fa-save"></i>
                                </button>
                            </td>
                        </tr>
                    `;
                });

                block += `<h3 class="text-center">${response[0].code}</h3>`;
             
                block += `<table class="table">
                    <thead>
                        <tr>
                            <th class="text-center">ITMREF</th>
                            <th class="text-center">Quantite stock</th>
                            <th class="text-center">Position Physique</th>
                            <th class="text-center">Etiquette</th>
                            <th class="text-center">Date</th>
                            <th class="text-center">Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        ${tr}
                    </tbody>
                </table>`;
                $('#panel_stock_postions').append(block);

            }
            
        })
        .fail(function() {
            console.log("error");
        }); 
    };

    function updatequantiteposition(code_a_barre,position, code, id, date_inventaire){
        var id_database = id;
        var id = id+'_'+code_a_barre.replace(/ /g, '') +'_'+position.replace(/ /g, '');
        var quantite = $(`#${id}`).val();
        var new_pos = $(`#${id}_pos`).val();
        var new_type = $(`#${id}_type`).val();
        var new_etiquette = $(`#${id}_etiquette`).val();

            var data = {
                    id: id_database,
                    code: code,
                    code_a_barre: code_a_barre,
                    quantite: quantite,
                    position: position,
                    new_pos: new_pos,
                    new_type: new_type,
                    new_etiquette : new_etiquette,
                    date_inventaire : date_inventaire
                };
                console.log(data);
            $.ajax({
                url: '{{route("inv_somocer.updatequantiteposition")}}',
                type: 'POST',
                data: data,
                headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
            })
            .done(function(response) {
                if(response.success==true){
                    toastr.success('Saved', "Succès!!");
                    //window.location.reload();
                }
                if(response.success==false){
                    toastr.warning('Attention', response.message);
                }

            })
            .fail(function() {
                console.log("error");
            })
            .always(function() {
                console.log("complete");
            });
           
    };

    /** 
    * hors inventaire
    */
    /*function affectationcodeabarre(code_a_barre, inventaire_code, produit_code){
        $('#panel_hors_inv').empty();
        $('#panel_hors_inv').append(`<h3 class="text-center">${code_a_barre}</h3>`);
        var search = '';
        $.ajax({
            url: '{{route("dashboard.selecthorsInvProd")}}',
            type: 'GET'
        })
        .done(function(response) {
            var options = '<option value="">Choisir...</option>';
            response.forEach( function(element, index) {
                var selected = (element.code == produit_code && produit_code != 'null')? 'selected' : '';
                options += `<option value="${element.code}" ${selected} >${element.designation}</option>`;
                            console.log(element.code, produit_code, selected);

            });
            search = `
            <div class="row">
                <div class="col-md-12">
                    <div class="text-center">
                        <b>Produit : </b>
                        <select type="text" class="form-control" id="prods_select" >
                            ${options}
                        </select>
                    </div>
                    <button class="btn btn-success pull-right" onclick="changeCabHoreInv('${code_a_barre}', '${inventaire_code}');">
                        <i class="fa fa-save"></i>
                    </button>
                </div>
            </div>`;
            $('#panel_hors_inv').append(search);

            $("#prods_select").select2({
                theme: "classic",
                placeholder: 'Produit...',
                allowClear: true,
                sorter: function(results) {
                        var query = $('.select2-search__field').val().toLowerCase();
                        return results.sort(function(a, b) {
                          return a.text.toLowerCase().indexOf(query) -
                            b.text.toLowerCase().indexOf(query);
                        });
                      }
            });
        })
        .fail(function() {
            console.log("error");
        })
        .always(function() {
            console.log("complete");
        });

    };

    function changeCabHoreInv(code_a_barre, inventaire_code){
       var code = $('#prods_select').val();
        if(code){
            $.ajax({
                url: '{{route("dashboard.changeCabHoreInv")}}',
                type: 'POST',
                data: {
                    code: code,
                    code_a_barre: code_a_barre,
                    inventaire_code: inventaire_code
                },
                headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
            })
            .done(function(response) {
                if(response.success == true){
                    console.log(response);
                    toastr.success('Succés', 'Code a barre affecté avec succée!');
                }
            })
            .fail(function() {
                console.log("error");
            })
            .always(function() {
                console.log("complete");
            });
            
        }else{
            toastr.warning('Attention', 'Produit Obligatoire!');

        }
    };


    function deleteCAB(code_a_barre, inventaire_code, position){
        Swal.fire({
          title: 'Supprimer code a barre : '+code_a_barre+' ?',
          text: "",
          type: 'warning',
          showCancelButton: true,
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33',
          confirmButtonText: 'Oui',
          cancelButtonText: 'Non'
        }).then((result) => {
            if (result.value) {
                var id ='tdhor'+code_a_barre+'-'+ inventaire_code + '-'+position
                var data = {
                    code_a_barre : code_a_barre,
                    inventaire_code : inventaire_code,
                    position : position
                };

                $.ajax({
                    url: '{{ route("dashboard.deleteCAB") }}',
                    type: 'POST',
                    data: data,
                    headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
                })
                .done(function(response) {
                    if(response.success==true){
                        toastr.success('Succés', 'Code a barre supprimé avec succée!');
                        $(`#${id}`).hide(1000);
                    }else{
                        toastr.warning('Attention', 'Code a barre non supprimé!');
                    }
                })
                .fail(function() {
                    //console.log("error");
                })
                .always(function() {
                    //console.log("complete");
                });   
            }
        })    
    };*/
    /** 
    * fin hors inventaire
    */
    function cab_new_for_update(code_a_barre, inventaire_code){
        var cab_new = $('#cab_new_for_update').val();
       // console.log(inventaire_code, code_a_barre, cab_new);
        
        $.ajax({
            url: '{{ route("dashboard.cab_new_for_update")}}',
            type: 'POST',
            data: {
                cab_new: cab_new,
                code_a_barre: code_a_barre,
                inventaire_code: inventaire_code
            },
            headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}
        })
        .done(function(response) {
            //console.log("success");
            if(response.success==true){
                toastr.success('Succés', 'Code a barre modifié avec succée!');
                window.location.reload();
            }else{
                toastr.warning('Attention', response.message);
            }
        })
        .fail(function() {
            console.log("error");
        })
        .always(function() {
            console.log("complete");
        });
        
    };
   </script>
@endsection