@extends('admin/layouts/contentLayoutMaster')

@section('title', 'Student 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">Student 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="institution_id">Institution Type</label>
     <select class="form-control" name="institution_id" id="institution_id" onchange="getclass()">
    <option value="">Choose Type</option>      
    @if(count($institution)>0)
    @foreach ($institution as $key=>$institution1)    
    <option value="{{$institution1->id}}" selected>{{$institution1->institution_name}}</option>  
    @endforeach
    @endif      
   </select>
  </div>
  </div>
   <div class="col-md-3">
  <div class="form-group">
    <label for="class_id">Class</label>
     <select class="form-control" name="class_id" id="class_id">
    <option value="">Choose Class Name</option>      
    @if(count($class)>0)
    @foreach ($class as $key=>$class1)    
    <option value="{{$class1->id}}" selected>{{$class1->class_name}}</option>  
    @endforeach
    @endif      
   </select>
  </div>
  </div>
  <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-12" style="text-align:center;">
  <button type="submit" class="btn btn-primary" style="margin-top: 15px;">Search</button>
  <a href="/admin/studentreport" class="btn btn-danger" style="margin-top: 15px;">Clear</a>
  </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>Institution Type</th>
                                  <th>Institution Name</th>
                                  <th>Class</th>
                                  <th>Credit 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>{{ $wallet1->mobile_no }}</td>
                                  <td>{{ $wallet1->institution_type }}</td>
                                  <td>{{ $wallet1->school_name }}</td>
                                  <td>{{ $wallet1->class }}</td>
                                  <td><strong>{{ $wallet1->wallet }}</strong></td>
                                  <td><strong>
                                                                    <span class="text-danger">Inactive</span>
                                                                    </strong></td>
                              </tr>
                                                             @endforeach
                    @else
                       <tr>
                            <td colspan="7">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 
    }]
}]
});
});  
function getclass() {
	var institution_id = $('#institution_id').val();
	var getclass =	'{{ URL::to("admin/getclass")}}';
	if(institution_id != ''){
		$.ajax({
			url: getclass,
			type: "POST",			
			data:{institution_id:institution_id},
			success: function (data) {
               if(data.length != ''){
					var i;
					var showData = [];
					for (i = 0; i < data.length; ++i) {
						showData[i] = "<option value='"+data[i].id+"'>"+data[i].class_name+"</option>";
					}
					$("#class_id").html(showData);
				}else{
					$("#class_id").html("<option value=''>Choose Class Name</option>");
				}			
			},
		});
	}
}    
</script>
@endsection