@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-ageing-report') }}" id="ageingreport" 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="15%"> Article </td>                 
                <td width="15%"> Color </td>   
                <td width="15%"> Start Date </td> 
                <td width="15%"> End Date </td>                                  
                <td colspan="2"> ACTION </td>
            </tr>
            <tr>
                <td>
                    <select name="warehouse_id[]" id="warehousef" 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> 
                    <input name="article" id="article" class="form-control" value="{{ !empty(request('article')) ? request('article') : '' }}" >   
                </td>
                <td>
                    <input name="color" id="color" class="form-control" value="{{ !empty(request('color')) ? request('color') : '' }}" >
                </td>

                <td>
                    <div class="form-group">                       
                        <input type="text" id="startdate" class="form-control datepicker" required readonly name="startdate">
                    </div>
                </td>
                <td>
                    <div class="form-group">                       
                        <input type="text" id="enddate" class="form-control datepicker" required readonly name="enddate">
                    </div>
                </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-ageing-report') }}';"><i class="fa fas fa-refresh"></i></button></td>
               
            </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>Article</th>                                   
                <th>Color</th>                       
                <th>Size</th>  
              
                <th>MRP</th> 
                <th>Qty</th>  
                <th> AGE</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> {{ $row->article }}</td> 
                <td>{{ $row->color }}</td>
                <td>{{ $row->size }}</td>
                <td>{{ $row->mrp }}</td>
                <td>{{ $row->qty }}</td> 
                @php 
                $date1=date_create(date('Y-m-d h:i:s'));
                $date2=date_create($row->created_at);
                $diff=date_diff($date1,$date2);
              
                @endphp
                <td> {{ $diff->format("%R%a days") }}  </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 (($('#warehousef').val() == '') ) 
    {
        alert("Please Select Warehouse");   
        $("#ageingreport").attr("disabled", "disabled");
        return false;
    }  
    
    var startDate = document.getElementById("startdate").value;
    var endDate = document.getElementById("enddate").value;

    if ((Date.parse(startDate) > Date.parse(endDate))) {

        alert("End date should be greater than Start date");
       
        $("#productreport").attr("disabled", "disabled");

        return false;
    }else{
        jQuery("#loader_div").show();
    }
});

$('#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