@extends('dashboard.base')

@section('content')


<div class="container-fluid">
  <div class="fade-in">
    <div class="row">
      <div class="col-sm-12">
        <div class="card">
          <div class="card-header"><h4>Reports Manager</h4></div>
            <div class="card-body">
                @yield('nav')
                @if($errors->any())
                    <br>
                    {!! implode('', $errors->all('<div class="alert alert-danger" role="alert">:message</div>')) !!}
                @endif
                @if(session()->has('message'))
                    <br>
                    <div class="alert alert-success" role="alert">{{ session("message") }}</div>
                @endif
                <div class="clearfix"></div>
                <div class="filter-box mt-1 mb-2">
                  <form class="data-tab" method="get" id="filterForm">
                    <div class="row">
                      <div class="col-md-6">
                        <label>Date Range</label>
                        <input type="text" class="date-range-picker-filter form-control" id="date-range-picker-filter" name="date_range" placeholder="Starting" autocomplete="off" value="{{ request()->date_range??''}}" required>
                      </div>
                      
                      <div class="col-md-6">
                        <button type="button" id="filterSubmitBtn" class="btn btn-primary mr-2 btnMarginTop">Filter</button>
                        <a href="javascript:void(0);" id="export_btn" class="btn btn-success btnMarginTop">Export</a>
                      </div>
                    </div>
                  </form>
                </div>

                <div class="row">
                  <div class="col-md-3">
                    <span id="totalSale">Total Sale : 0</span>
                  </div> 
                  <div class="col-md-2">
                    <span id="totalInvoices">Total Invoices : 0</span>
                  </div> 
                  <div class="col-md-2">
                    <span id="totalItems">Total Items : 0</span>
                  </div> 
                  <div class="col-md-2"> 
                    <span id="totalOrders">Total Orders : 0</span>
                  </div>
                  <div class="col-md-3">
                    <span id="totalCustomers">Total Customers : 0</span>
                  </div>
                </div>

                <div id="dataTableBox" class="d-none">
                  <table class="table table-striped table-bordered dt-responsive nowrap report-datatable" style="width: 100%">
                      <thead>
                          <tr>
                              <th>Customer Name</th>
                              <th>Number of Orders</th>
                              <th>Number of Quantity</th>
                              <th>Total Amount</th>
                          </tr>
                      </thead>
                      <tbody>
                      </tbody>
                  </table>
                </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

@endsection

@section('javascript')
@push('scripts')
<script src="{{ asset('vendor/datatables/buttons.server-side.js') }}"></script>
<script src="{{ asset('js/daterange-picker/moment.min.js') }}"></script>
<script src="{{ asset('js/daterange-picker/daterangepicker.js') }}"></script>
{{-- {{$dataTable->scripts()}} --}}
<script>
  $(document).ready(function(){
    $('.date-range-picker-filter').daterangepicker({
        locale : {
            format : 'DD-M-YYYY'
        }
    });

    function fetch_data(date_range){
      $('#dataTableBox').removeClass('d-none');
        var table = $('.report-datatable').DataTable({
          searching: false,
          lengthMenu: false,
          bLengthChange: false,
          bPaginate: false,
          processing: true,
          serverSide: true,
          "language": {processing: "<div class='active'><i class='fa fa-refresh fa-spin'></i></div>"},
          "ajax":{
              "url": "{{ route('reports.topSpendersReportDataTable') }}",
              "dataType": "json",
              "type": "get",
              "data":{ 
                      _token: "{{csrf_token()}}", 
                      date_range:date_range, 
              },
              "dataSrc": function(json){
                console.log(json);
                  // Get the extra variable value
                  $('#totalSale').html("Total Sale : $"+json.total_sale);
                  $('#totalInvoices').html("Total Invoices : "+json.total_invoices);
                  $('#totalItems').html("Total Items : "+json.total_items);
                  $('#totalOrders').html("Total Orders : "+json.total_orders);
                  $('#totalCustomers').html("Total Customers : "+json.total_customers);

                  // Reset the data into datatable formate
                 json.draw = json.draw;
                 json.recordsTotal = json.recordsTotal;
                 // json.recordsFiltered = json.recordsFiltered;
                 return json.data;
              },
          },
          columns: [
              {data: 'ig_handle', name: 'ig_handle',"orderable":false},
              {data: 'number_of_orders', name: 'number_of_orders',"orderable":false},
              {data: 'number_of_quantity', name: 'number_of_quantity',"orderable":false},
              {data: 'total_amount_of_sale', name: 'total_amount_of_sale',"orderable":false}
          ]
      });
    }

    $('#filterSubmitBtn').on('click',function(){
        $('.report-datatable').DataTable().destroy();
        var date_range = $('#date-range-picker-filter').val();
        if(date_range != '')
        {
          if(date_range==''){
            date_range_export = '0'; 
          }else{
            date_range_export = date_range; 
          }
          var allHref = "{{route('reports.exportTopSpendersReport')}}/"+date_range;

          $("#export_btn").attr("href", allHref);
        }
        fetch_data(date_range);
    });

    
    
  });
</script>
@endpush
@endsection