@extends('layouts.app', ['activePage' => 'listReport', 'titlePage' => __('Reporting')])


@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col">
                    <div class="shadow p-3 mb-5 bg-white rounded">
                        <div class="card-header">
                            <div class="row align-items-center">
                                <div class="col-sm-8">
                                    <h3 class="mb-0">{{ __('Reporting') }}</h3>
                                </div>
                              
                            </div>
                        </div>
                        
                        <div class="col-12">
                            
        @if (count($errors) > 0)
        @if($errors->any())
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            {{$errors->first()}}
            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                <span aria-hidden="true">&times;</span>
            </button>
          </div>
        @endif
    @endif
                            @if (session('status'))
                                <div class="alert alert-success alert-dismissible fade show" role="alert">
                                    {{ session('status') }}
                                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                        <span aria-hidden="true">&times;</span>
                                    </button>
                                </div>
                            @endif
                        </div>




<form   enctype="multipart/form-data">
<div class="form-row">

            
                          <div class="form-group col-md-4" >
               
                 <select class="form-control select2" name="category_id" id="category_id" onChange="getResult1();">
                                <option value="">Select Category</option>
                                @foreach ($reportCat as $key=>$b)
                                <option 
                            @if(isset($_REQUEST['category_id']) and !empty($_REQUEST['category_id']))
                            @if($_REQUEST['category_id'] == $b->category_id )

                                selected  
                               @endif
                                @endif
                                value="{{$b->category_id}}"> {{$b->category_name}} </option>
                                @endforeach

                            </select>
                          </div>
                          <div class="form-group col-md-4" >
               
                 <select class="form-control select2" name="subcategory_id" id="subcategory_id" >
                                <option value="">Select Subcategory</option>
                            @foreach ($reportSubcat as $key=>$b)
                                <option 
                            @if(isset($_REQUEST['subcategory_id']) and !empty($_REQUEST['subcategory_id']))
                            @if($_REQUEST['subcategory_id'] == $b->subcategory_id )

                                selected  
                               @endif
                                @endif
                                value="{{$b->subcategory_id}}"> {{$b->subcategory_name}} </option>
                                @endforeach

                            </select>
                          </div>

                          <div class="form-group col-md-4">

                          <button type="submit" class="btn btn-success btn-fab btn-fab-mini">
                      <i class="material-icons">search</i>
                          </button>
                         
                      <a href="{{route('report.listReport')}}" class="btn btn-danger btn-fab btn-fab-mini">
                      <i class="material-icons">close</i>
</a>
</div>
</div>
                    </form>



                        <div class="table-responsive">
                            <table class="table align-items-center table-flush datatable">
                                <thead class="thead-light">
                                    <tr>
                                        <th scope="col">{{ __('#') }}</th>
                                        <th scope="col">{{ __('Name') }}</th>
										 <th scope="col">{{ __('Value Name') }}</th>
                                        <th scope="col">{{ __('Quantity') }}</th>
                                        <th scope="col">{{ __('Price') }}</th>

                                    </tr>
                                </thead>

                                <tbody>
                               
                                @foreach ($reportList as $key=>$user)
                                        <tr>
                                            <td>{{ $key+1}} </td>
                                            <td>{{ $user->product_name }}</td>
											      <td>{{ $user->value_name }}</td>
                                            <td>{{ $user->quantity }}</td>
                                            <td>{{ $user->product_price }}</td>
                               
                               </tr>
                               @endforeach
                                </tbody>
                            </table>
                        </div>



                       
                        <div class="card-footer py-4">
                            <nav class="d-flex justify-content-end" aria-label="...">
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection


@push('js')
    <script>
$('.datatable').DataTable(
    {
        "pageLength": 50,
          dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    });

  window.onload = function() {
      
var category_id =   $('#category_id').val();
if(category_id != ''){
    
const urlParams = new URLSearchParams(window.location.search);
const myParam = urlParams.get('subcategory_id');
 console.log(myParam)
    
     $.ajax({
    url: 'getSubcategory',
headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
    type: "POST",
    data: '&id='+category_id,
    success: function (data) {

        console.log(data)
        $('#subcategory_id').find('option').not(':first').remove();

        if(data.length != ''){
        
  for(var i=0; i<data.length; i++){
  var id = data[i].subcategory_id;
  var name =data[i].subcategory_name;

  var option = "<option value='"+id+"'>"+name+"</option>"; 

$("#subcategory_id").append(option); 
  }
 
    $('#subcategory_id').val(myParam).trigger('change'); 
        }
        
else{
            

        }
    },error:  function (data) {
        console.log(data);
    }
});
    
    
}
};

function getResult1(){

var category_id =   $('#category_id').val();

if(category_id != ''){

    $.ajax({
    url: 'getSubcategory',
headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
    type: "POST",
    data: '&id='+category_id,
    success: function (data) {

        console.log(data)
        $('#subcategory_id').find('option').not(':first').remove();

        if(data.length != ''){
        
  for(var i=0; i<data.length; i++){
  var id = data[i].subcategory_id;
  var name =data[i].subcategory_name;

  var option = "<option value='"+id+"'>"+name+"</option>"; 

$("#subcategory_id").append(option); 
  }
        }
else{
            

        }
    },error:  function (data) {
        console.log(data);
    }


});

}

}
    </script>
    @endpush