@extends('layouts.backend')
@section('extraCss')  
<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css" rel="stylesheet">
@endsection
@php  
     $reqpos = request("warehouse_id");
@endphp
@section('mainContentArea')
<div class="card card-default">
<div class="card-header">
    <h4>Stock Barcode wise Report</h4>
</div>   
<div class="alert alert-default" style="overflow-x:auto;">
    <form action="{{ route('stock-barcode-wise-report') }}" id="stockbarcodereport" method="post">
        @csrf
        <h4>Filter  </h4>
        <div style= "padding:15px;">                                                     
        </div>
        <table class="table filterPosSo">
            <tr>
                <td width="10%">Warehouse</td>
                <td width="15%">Group</td>
                <td width="15%">Store</td>
                <td width="8%">Category</td>
                <td width="15%">Article</td>
                <td width="15%">Brand</td>   
                <td width="15%">Color</td>   
                <td width="15%">Barcode</td>                 
                                   
                <td colspan="2">ACTION</td>
            </tr>
            <tr>

                <td>
                    <select name="warehouse_id[]" id="warehouse" class="input-md"  multiple="multiple" >
                        
                        @foreach($ALL_WAREHOUSES as $warehouse)
                        <option value="{{ $warehouse->id }}" {{ ( !empty(request("warehouse_id")) && in_array($warehouse->id, request("warehouse_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                        @endforeach
                    </select>
                </td>

                <td>
                    <select name="storeType[]" id="storeType" class="input-md" multiple="multiple" >                                                      
                    @foreach($ALL_GROUP as $key => $type)
                    <option value="{{ $type->id }}" {{ ( !empty(request("storeType")) && in_array($type->id , request("storeType")) ? "selected" : "")  }}
                    {{ ( empty(request("storeType")) ? "selected" : "") }}>{{ $type->name }}</option>
                    @endforeach
                    </select>
                </td>

                <td>
                    <select name="warehouse_id[]" id="posStore" class="input-md" multiple="multiple">
                    </select>
                </td>

                 <!-- <td>
                    <select name="warehouse_id[]" id="Pos" class="input-md"  multiple="multiple">                                
                        @foreach($ALL_POS as $warehouse)
                        <option value="{{ $warehouse->id }}" {{ ( !empty(request("warehouse_id")) && in_array($warehouse->id, request("warehouse_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                        @endforeach
                    </select>
                </td> -->                       
                
                <td>
                    <select name="subsection[]" id="subsection" class="input-md" multiple="multiple">                                
                         @foreach($subsections as $subsection)
                        <option value="{{ $subsection->subsection }}" {{ ( !empty(request("subsection")) && in_array($subsection->subsection, request("subsection")) ? "selected" : "") }}>{{ $subsection->subsection  }}</option>
                   
                         @endforeach
                    </select>
                </td> 

                <td>
                 
                    <select name="article[]" id="article" class="input-md" multiple="multiple">            
                        @foreach($ListArticle as $Larticles)
                        <option value="{{ $Larticles->article }}" {{ ( !empty(request('article')) && in_array($Larticles->article, request('article')) ? "selected" : "") }}>{{ $Larticles->article  }}</option>
                        @endforeach
                    </select>
                </td>

                <td>
                    <select name="brand[]" id="brand" class="input-md" multiple="multiple">
                        @foreach($brands as $brand)
                        <option value="{{ $brand->id }}" {{ ( !empty(request("brand")) && in_array($brand->id, request("brand")) ? "selected" : "") }}>{{ $brand->name  }}</option>

                        @endforeach
                    </select>
                </td>

                <td>
                    <input name="color" id="color" class="form-control" value="{{ request('color') }}" >
                </td>

                <td>
                    <input name="barcode" id="barcode" class="form-control" value="{{ request('barcode') }}" >
                </td>                                               
               
                <td><button class="btn btn-block btn-success"><i class="fa fas fa-search" id="submit"></i></button></td>
                <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('stock-barcode-wise-report') }}';"><i class="fa fas fa-refresh"></i></button></td>
                @if(count($pos_id) > 0)
                <td>
                    <!--  @php if(!empty($subsectionfilter) && $subsectionfilter != 0) 
                         {
                           $subsectionfilter = implode(",",$subsectionfilter);
                         }else
                         {
                            $subsectionfilter = 0;
                         } 

                         if(!empty($articlefilter) && $articlefilter != 0) 
                         {
                           $articlefilter = implode(",",$articlefilter);
                         }else
                         {
                            $articlefilter = 0;
                         } 
                          
                         @endphp -->
                    <a class="btn btn-md btn-primary" style="float:right; margin-bottom:10px;" href="{{ route('barcodeWiseExport',[implode(",",$pos_id)] ) }}" id="eexcel">Export Excel</a> 
                </td>
                @endif
            </tr>
        </table>
    </form>
</div>
<div class="card-body" >
    <div class="table-responsive">
        <table class="table table-striped table-bordered " id="articleTables">
        <thead>                   
            <tr>
                <th>#</th>                       
                <th>Section</th>
                <th>Subsection</th>                     
                <th>Article</th>
                <th>Brand</th>                       
                <th>Color</th>                       
                <th>Size</th>  
                <th>Barcode</th>   
                <th>MRP</th> 
                <th>Qty</th>  
                <th>ArticleCode</th> 
            </tr>
        </thead>
        @php if(count($warehouseProducts) > 0) { @endphp
        <tbody>                
        @php $totalcountallsize  = 0 ;   @endphp 
        @foreach($warehouseProducts as $key => $row)          
            <tr>
                @php $article = \App\Article::with('category')->with('maincategory')->select('image')->where('code',$row->article)->first(); @endphp                         
                <td> {{$key + $warehouseProducts->firstItem()}}</td>                       
                <td>{{ !empty($article->maincategory) ? $article->maincategory->name : $row->section }}</td>
                <td>{{ !empty($article->category) ? $article->category->name : $row->subsection }}</td>
                <td> {{ $row->article }}  </td> 
                <td>{{ $brandarray[$row->brand_id] }}</td>
                <td>{{ $row->color }}</td>
                <td>{{ $row->size }}</td>
                <td>{{ $row->barcode }}</td>
                <td>{{ $row->mrp }}</td>
                <td>{{ $row->qty }}</td> 
                <td>{{ $row->articlecode }}</td> 
            </tr>
        @endforeach
        </tbody>                
       @php } @endphp
    </table>
    </div>   
</div>
@php if(count($warehouseProducts) > 0) { @endphp {!! $warehouseProducts->appends(request()->input())->links() !!} @php } @endphp

</div>

@endsection

@section('extraJs')
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" ></script>
<script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js" ></script>
<script type="text/javascript"> 
$("#submit").click(function () {  
    if (($('#warehouse').val() == '') && ($('#posStore').val() == '')) {
    alert("Please Select Warehouse / Store");
    $("#productreport").attr("disabled", "disabled");
    return false;
  }       
});

$('#articleTables').DataTable( {
  "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],         
  dom: 'Bfrtip',
  buttons: [ 
  'colvis',
  {
    extend: 'excelHtml5',
    autoFilter: true,
    sheetName: 'Exported data',
    exportOptions: {
    columns: ':visible'
    },
    footer: true
  }                     
  ],                   
  colReorder: true,  
  paging: false 
  } );

    $('a[data-toggle="tooltip"]').tooltip({
    animated: 'fade',
    placement: 'bottom',
    html: true
});

var type = $('#storeType').val();
callstores(type);

$("#storeType").on('change', function () { 

var type = $('#storeType').val();
callstores(type);

});

function callstores(type)
{
  var _token   = $('meta[name="csrf-token"]').attr('content');   

  $.ajax({
  url:"{{ route('type-store-list') }}",
  method:"get",
  data:{type: type, _token:_token},
  success:function(res)
  { 

  if(res){ console.log(res);
  $("#posStore").empty();

  $.each(res,function(key,value){ //console.log(key,value);
  $("#posStore").append('<option value="'+key+'" >'+value+'</option>');
  });

  console.log( null);
  var values = null;
  $.each(values, function(i,e){ console.log(i,e);
      $("#posStore option[value='" + e + "']").prop("selected", true);
  });

  $('#posStore').multiselect({            
  enableFiltering: true,
  allSelectedText: 'All',
  maxHeight: 200,
  includeSelectAllOption: true,
  enableCaseInsensitiveFiltering: true  
  });        

  $('#posStore').multiselect('rebuild');

  }else{
  $("#posStore").empty();
  }
  }

  })
}

</script>

@endsection