@extends('admin/layouts/contentLayoutMaster')

@section('title', 'Advisor Report')

@section('content')
@section('page-style')
<link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css') }}">
<link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css') }}">
<style>
.table-responsive1{
display: block;width: 100%;overflow-x: auto;    
}    
</style>
@endsection
<!-- Basic Tables start -->
<div class="row" id="basic-table">
  <div class="col-12">
      <div class="card">
          <div class="card-header">
              <h4 class="card-title">Advisor Report</h4>
          </div>
          <div class="card-content">
              <div class="card-body">
                   @if (count($errors) > 0)
                          @if($errors->any())
                            <div class="alert alert-success alert-dismissible" role="alert">
                              <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                              {{$errors->first()}}
                            </div>
                          @endif
                      @endif
                  <!-- Table with outer spacing -->
                  <form method="get">
  <div class="row">
   <div class="col-md-3">
  <div class="form-group">
    <label for="from">From Date</label>
    <input type="text" class="form-control datepicker" id="from" name="from" placeholder="From Date" value="" readonly>
  </div>
  </div>
  <div class="col-md-3">
  <div class="form-group">
    <label for="to">To Date</label>
    <input type="text" class="form-control datepicker" id="to" name="to" placeholder="To Date" value="" readonly>
  </div>
  </div>
  <div class="col-md-3">
  <button type="submit" class="btn btn-primary" style="margin-top: 15px;">Search</button>
  </div>
</div>
</form>
                  <div class="table-responsive1">
                      <table class="table" id="example">
                          <thead>
                              <tr>
                                  <th>S.NO</th>
                                  <th>Date</th>
                                  <th>Name</th>
                                  <th>Email ID</th>
                                  <th>Mobile No</th>
                                  <th>Preferred Subject</th>
                                  <th>Wallet Balance</th>
                                  <th>Status</th>
                              </tr>
                          </thead>
                          <tbody>
                                        @if(count($wallet)>0)
                    @foreach ($wallet as $key=>$wallet1)
                              <tr>
                                  <th scope="row">{{ $s }}</th>
                                  <td>01-01-1970</td>
                                  <td>{{ $wallet1->name }}</td>
                                  <td>{{ $wallet1->email_id }}</td>
                                  <td><strong>{{ $wallet1->mobile_no }}</strong></td>
                                  <td style="max-width: 100px;overflow: hidden;text-overflow: ellipsis;white-space: nowrap;" data-toggle="tooltip" data-placement="top" title="">{{ $wallet1->subject }}</td>
                                  <td><strong>{{ $wallet1->wallet }}</strong></td>
                                  <td><strong>
                                                                    <span class="text-danger">Inactive</span>
                                                                    </strong></td>
                              </tr>
                                                             @endforeach
                    @else
                       <tr>
                            <td colspan="5">No record found!</td>
                       </tr>
                    @endif
                          </tbody>
                      </table>
                  </div>
              </div>
        
          </div>
      </div>
  </div>
</div>
<!-- Basic Tables end -->
<!-- Responsive tables end -->
@endsection
@section('page-script')
        <!-- Page js files -->
<script src="{{ asset('js/scripts/jquery-ui.js') }}"></script>
<script>
  $( function() {
    $( ".datepicker" ).datepicker({
      changeMonth: true,
      changeYear: true,
      dateFormat: 'yy-mm-dd',
      yearRange: "-150:+0",
      showButtonPanel: true,
    closeText: 'Clear',
         onClose: function (dateText, inst) {
        if ($(window.event.srcElement).hasClass('ui-datepicker-close'))
        {
            document.getElementById(this.id).value = '';
        }
    }
    });
  });
</script>
<script src="{{ asset('js/scripts/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('js/scripts/datatables/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('js/scripts/datatables/jszip.min.js') }}"></script>
<script src="{{ asset('js/scripts/datatables/pdfmake.min.js') }}"></script>
<script src="{{ asset('js/scripts/datatables/vfs_fonts.js') }}"></script>
<script src="{{ asset('js/scripts/datatables/buttons.html5.min.js') }}"></script>
<script>
$(document).ready(function() {
    $('#example').DataTable({
        dom: 'Bfrtip',
        "bSort":false,
        "searching": false,
        buttons: [{
  extend: 'collection',
  className: 'exportButton',
  text: 'Data Export',
buttons: [{ extend:'csv',
              exportOptions: {
                modifier: {
                  page: 'all',
                  search: 'none'   
                }
             },
             //the remaining buttons here 
    }]
}]
});
});    
</script>
@endsection