@extends('layouts.app')
@section('title')
    Procurement Data Lists
@endsection
@section('content')
    <div class="row card">


        <div class="mt-3 card-body card-white mb-4">
            <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                <h6 class="m-0 font-weight-normal text-head-color">Procurement Data Lists (
                    {{ $CityIntemationTotalCount ? $CityIntemationTotalCount : 0 }} )</h6>
            </div>
            <br>
            <div id='loader'></div>
            <form action="{{ route('procurement-reports') }}" method="GET" enctype="multipart/form-data">
                <div class="row">
                    <div class=" form-group col-md-3">
                        <label> Search by Application Number </label>
                        <input type="text"  name="ApplicationNumber" value="{{ Request::get('ApplicationNumber') }}"
                            placeholder="Search by Application Number" class="form-control ApplicationNumber">
                    </div>
                    <div class="form-group col-md-3">
                        <label> Exam Date </label>
                        <input type="date" name="ExamDate" value="{{ Request::get('ExamDate') }}"
                            placeholder="Search by ExamDate" class="form-control ExamDate">
                    </div>

                    <div class="form-group col-md-3">
                        <label>Select Shift</label>
                        <select class="form-control shift" name="shift">
                            <option value="">All</option>
                            {{-- @foreach ($examShifts as $examShift)
                                <option value="{{ $examShift->ID }}" @if (Request::get('shift') == $examShift->ID) selected @endif>
                                    {{ $examShift->ShiftName }}</option>
                            @endforeach --}}
                            <option value="1" @if (Request::get('shift') == '1') selected @endif>First</option>
                            <option value="2" @if (Request::get('shift') == '2') selected @endif>Second</option>



                        </select>
                    </div>


                    <div class="form-group col-md-4">
                        <button type="submit" class="btn btn-success"><i style="font-size:20px" class="fa">&#xf002;</i>
                            Search</button>
                    
                        <button type="button" onclick="display_data()" class="btn btn-danger btn-rounded"><i style="font-size:20px" class="fa">&#xf1c3;</i>
                            Download</button>

                        <a class="btn btn-dark" href="{{ route('procurement-reports') }}">Clear</a>
                       

                        <div class="loader-div">
                            <img class="loader-img" src="assets/images/loader.gif" style="height: 120px;width: auto;" />
                        </div> 

                        

                    </div>
             
                   
                </div>
            </form>
            <div class="mt-2 mb-4">
                    <table class="table table-bordered table-responsive">
                        <thead>
                            <tr>
                                <th>S.No</th>
                                <th>Roll No</th>
                                <th>Application No</th>
                                <th>Candidate Name </th>
                                <th>Gender</th>
                                <th>DOB </th>
                                <th>Father's Name </th>
                                <th>Mother's Name</th>
                                <th>Center Code</th>
                                <th>Center Name</th>
                                <th>Center Address</th>
                                <th>City</th>
                                <th>Exam Shift</th>
                                <th>Exam Date and Time</th>

                            </tr>
                        </thead>
                        <tbody>
                            @if (count($CityIntemationTblAlls) > 0)
                                @foreach ($CityIntemationTblAlls as $key => $CityIntemationTblAll)
                                 @php
                                         if($CityIntemationTblAll->ExamShift=='1'){ 
                                           $examShift="First"; $examTime="09:00 Am - 11:00 Am"; }
                                        else { $examShift="Second"; $examTime="03:00 Pm - 05:00 Pm"; }
                                 @endphp
                                    <tr>
                                        <td>{{ $key + 1 }}</td>
                                        <td> {{ $CityIntemationTblAll->Rollnumber ? $CityIntemationTblAll->Rollnumber : null }}
                                        </td>
                                        <td> {{ $CityIntemationTblAll->ApplicationNumber ? $CityIntemationTblAll->ApplicationNumber : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->CandidateName ? $CityIntemationTblAll->CandidateName : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->GenderName ? $CityIntemationTblAll->GenderName : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->DOB ? date("d-m-Y", strtotime($CityIntemationTblAll->DOB)) : null }}</td>
                                        <td>{{ $CityIntemationTblAll->FatherName ? $CityIntemationTblAll->FatherName : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->MotherName ? $CityIntemationTblAll->MotherName : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->TestCentreNumber ? $CityIntemationTblAll->TestCentreNumber : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->TestCentreName ? $CityIntemationTblAll->TestCentreName : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->VenueAddress ? $CityIntemationTblAll->VenueAddress : null }}
                                        </td>
                                        <td>{{ $CityIntemationTblAll->ExamCity ? $CityIntemationTblAll->ExamCity : null }}
                                        </td>
                                        <td>
                                           {{ $examShift ? $examShift :null}}
                                        </td>
                                        <td>
                                            
                                            {{ $CityIntemationTblAll->ExamDate ? date("d-m-Y", strtotime($CityIntemationTblAll->ExamDate))." ".$examTime : null }}
                                        </td>
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td colspan="11">
                                        <center>No Data Found !!</center>
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                    {!! $CityIntemationTblAlls->appends(request()->query())->links('pagination::bootstrap-4') !!}
            </div>



        </div>
    </div>
    @endsection
    <style type="text/css">
		.loader-div {
			display: none;
			position: fixed;
			margin: 0px;
			padding: 0px;
			right: 0px;
			top: 0px;
			width: 100%;
			height: 100%;
			background-color: #fff;
			z-index: 30001;
			opacity: 0.8;
		}
		.loader-img {
			position: absolute;
			top: 0;
			bottom: 0;
			left: 0;
			right: 0;
			margin: auto;
		}
	</style>

    @push('js')
    <script type="text/javascript">
		function display_data() {
			$(".loader-div").show(); // show loader
            var ApplicationNumber = $('.ApplicationNumber').val();
            var ExamDate = $('.ExamDate').val();
            var shift = $('.shift').val();
			$.ajax({
                
                 url:"{{ url('procurement-reports/export') }}",
				 type:"GET",
                 cache: false,
                 xhrFields:{
                   responseType: 'blob'
                 },
                 data:{
                    ApplicationNumber: ApplicationNumber,
                    ExamDate:ExamDate,
                    shift:shift
                 },
				 success: function(result, status, xhr) {
                var disposition = xhr.getResponseHeader('content-disposition');
                var filename = 'MNS-Data-Download.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>
    @endpush