@extends('layouts.admin')
@section('content')
    <main role="main" class="flex-shrink-0">

        <div class="container custom-container">

            <div class="content-body">


                <div class="card mt-50 mb-50">
                    <div class="card-header">
                        <h4 class="mb-2">Report</h4>
                    </div>
                    <div class="card-body">
                        <form action="{{ route('city-coordinator-report')}}" method="get">
                            
                            <div class="custom-form">
                                <div class="row">
                                    <div class="form-group col-md-2">
                                        <label>Exam Date:</label>
                                        <input type="date" class="form-control form-control-sm examDate" name="examDate"
                                            value="{{ Request::get('examDate') }}">
                                    </div>
                                    <div class="form-group col-md-2">
                                        <label>Exam Name:</label>
                                        <select class="form-control form-control-sm examID" name="examID">
                                            <option value="">---Select---</option>
                                            <option value="209" @if(Request::get('examID')=='209') selected @endif>CUET UG OFFLINE</option>
                                            
                                        </select>
                                    </div>

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

                                    </div>
                                    <div class="form-group col-md-6">
                                        <div class="row">
                                            <div class="col-md-4">
                                                <label>&nbsp;</label>
                                                <button type="submit"
                                                    class="btn btn-block btn-success form-control border-0">Search</button>
                                            </div>
                                            <div class="col-md-4">
                                                <label>&nbsp;</label>
                                                <a href="{{ route('city-coordinator-report')}}" class="form-control btn btn-block btn-secondary border-0">
                                                   Reset
                                                </a>
                                            </div>
                                            <div class="col-md-4">
                                                <label>&nbsp;</label>
                                                <button onclick="display_data()"
                                                    class="btn-danger form-control btn btn-block custom-orange">Download</button>
                                            </div>
                                        </div>

                                    </div>
                                </div>
                            </form>

                                <div class="table-responsive">
                                    <table id="exportR" class="table table-striped table-bordered">
                                        <thead class="thead-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Reference No.</th>
                                                <th>Centre Number</th>
                                                <th>City</th>
                                                <th>Exam Details</th>
                                                <th>Total Amount</th>
                                                <th>Bill Date</th>
                                                <th>Status</th>
                                                <th>Remark</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @if (count($CityCoordinators) > 0)
                                            @foreach($CityCoordinators as $key => $CityCoordinator)
                                            <tr>
                                                <td>{{ $key+1 }}</td>
                                                <td>{{ isset($CityCoordinator->{'Reference No_'} ) ? $CityCoordinator->{'Reference No_'} :null }}</td>
                                                <td></td>
                                                <td>{{ isset($CityCoordinator->{'Center City'} ) ? $CityCoordinator->{'Center City'} :null }}</td>
                                                <td>{{ isset($CityCoordinator->{'Exam Name'} ) ? $CityCoordinator->{'Exam Name'} :null }}</td>
                                                <td>{{ isset($CityCoordinator->{'Net Amount Payable'} ) ? $CityCoordinator->{'Net Amount Payable'} :null }}</td>
                                                <td>{{ isset($CityCoordinator->{'$systemCreatedAt'} ) ? $CityCoordinator->{'$systemCreatedAt'} :null }}</td>
                                                <td>Submitted </td>
                                                <td><b>-</b></td>
                                            </tr>
                                            @endforeach
                                            @else
                                            <tr>
                                                <td colspan="9">
                                                    <center>No Data Found !!</center>
                                                </td>
                                            </tr>
                                            @endif

                                        </tbody>
                                    </table>
                                   
                                  
                                    {!! $CityCoordinators->appends(request()->query())->links('pagination::bootstrap-4') !!} 
                                
                                </div>



                            </div>
                        
                    </div>
                </div>

            </div>
        </div>



    </main>
@endsection
<style>
    .row {
        padding-bottom: 5px;
    }
</style>
<script type="text/javascript">
    function display_data() {
        var examDate = $('.examDate').val();
        var examID = $('.examID').val();
        $.ajax({
             url:"{{ url('city-coordinator-report-download') }}",
             type:"GET",
             cache: false,
             xhrFields:{
               responseType: 'blob'
             },
             data:{
                examDate: examDate,
                examID:examID,
                type:'downloadexcel'
             },
             success: function(result, status, xhr) {
                $('#loadmessage').html(result).css("display", "block");
            var disposition = xhr.getResponseHeader('content-disposition');
            var filename = 'ExcelDownload.xlsx';
            // The actual download
            var blob = new Blob([result], {
                type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
            });
            var link = document.createElement('a');
            link.href = window.URL.createObjectURL(blob);
            link.download = filename;
            document.body.appendChild(link);
            link.click();
            document.body.removeChild(link);
           // $(".loader-div").hide();
            },
              error: function (xhr, status) {
                $(".loader-div").hide(); // hide loader	
                console.log('ajax error = ' + xhr.statusText);
              }
         });
    }
</script>