@extends('layouts.app')
@section('title')
    All Verified Candidate 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">All Verified Candidate Lists 
                    {{-- {{ $CityIntemationTotalCount ? $CityIntemationTotalCount : 0 }} )</h6> --}}
            </div>
            <br>
            <div id='loader'></div>
            {{-- <form action="{{ route('all-reports') }}" method="GET" enctype="multipart/form-data">
                <div class="row">
                    

                    <div class="form-group col-md-3">
                        <label>Select Exam Type</label>
                        <select class="form-control shift" name="config">
                            <option value=" ">Select Exam Type  </option>
                            @foreach ($MISConfigurationls as $MISConfigurationl)
                                <option value="{{ $MISConfigurationl->ID }}" @if (Request::get('config') == $MISConfigurationl->ID) selected @endif>
                                    {{ $MISConfigurationl->DatabaseName }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="row">

                        <div class="form-group col-md-4">
                            <button type="submit" class="btn btn-success"><i style="font-size:20px" class="fa">&#xf002;</i>
                                Select Exam</button>
                        
    
                        </div>
                 
                       
                    </div>
                </form>        --}}
    @if(isset($columns))            
        <form action="{{ route('all-reports') }}" method="GET" enctype="multipart/form-data">
                
            <input type=hidden name="config" id="config" value="{{$db}}"/>
             <div class="form-group col-md-3">
                        <label>Select Exam Session</label>
                                                          <select class="form-control shift" name="year">
                            <option value=" ">Select Exam Session</option>
                            @foreach ($years as $year)
                                <option value="{{ $year }}">{{ $year }}</option>
                            @endforeach
                        </select>
                     
                    </div>
                </div>
                <div class="row">
                    <label>Select Required Fields in Excel</label>
                    @php 
                      
                        $excludeColumns = [
                            'ID', 'IsAadharNumber','Password', 'IsConfirm', 'ApplicationFinalSubmit', 'ApplicationSubmitDate', 'LastLoginDate', 'ModifyBy', 
                            'ModifyDate', 'CandidateIP', 'IsActive', 'AuthKey', 'VerificationToken', 'Status', 'created_at', 'updated_at', 
                            'PasswordResetToken', 'IsCheckedName', 'IsCheckedDOB', 'IsCheckedFatherName', 'IsCheckedMotherName', 
                            'IsCheckedGender', 'IsCheckedAddress', 'IsCheckedMobile', 'IsCheckedEmail', 
                            'PaymentConfirmedDate', 'ActivityID', 'IsAllocation', 'IsCorrection', 'IsCorrectionSubmit', 
                            'CorrectionSubmitDate', 'CorrectionActivateDate', 'AdminExamConfigID', 'IsSIngleGirlChild', 
                            'SysStartTime', 'SysEndTime', 'IsCorrectionFinalSubmit', 'ischargeback'
                        ];
                    @endphp
                                        @foreach ($columns as $column)
                        @if (!in_array($column, $excludeColumns))
                         
                            <div class="form-group col-md-3">
                                                                <input type="checkbox" id="{{$column}}" name="selectedColumns[]" value="{{$column}}"
                                @if(isset($selectedColumn))  
                                @if(in_array($column,$selectedColumn))
                                 checked 
                                 @endif
                                 
                                 @endif>
                                <label for="{{$column}}">{{$checkname}}</label><br>
                                                            </div>
                        @endif
                    @endforeach
                    @if (!$mandatoryChecked)
                        <div class="alert alert-danger">At least one checkbox is mandatory</div>
                    @endif
                </div>
                <div class="row">
                    <label>Please Select Condition</label>
                    <div class="form-group col-md-3">
                        <label>Select Gender</label>
                        <select class="form-control shift" name="gender" Placeholder="Select Gender">
                           <option value=" ">Select Gender</option>
                           @foreach ($genders as $gender)
                           <option value="{{$gender->ID}}" @if (Request::get('gender') == $gender->ID) selected @endif>{{$gender->Gender}}</option>
                           @endforeach
                    </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label>Select Identity</label>
                        <select class="form-control shift" name="identity" Placeholder="Select identity">
                           <option value=" ">Select identity</option>
                           @foreach ($identity as $identitys)
                           <option value="{{$identitys->ID}}"  @if (Request::get('identity') == $identitys->ID) selected @endif>{{$identitys->IdentityName}}</option>
                           @endforeach
                    </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label>Select Security Question</label>
                        <select class="form-control shift" name="securityques" Placeholder="Select Gender">
                           <option value=" ">Select Security Question</option>
                           @foreach ($securityques as $securityquess)
                           <option value="{{$securityquess->ID}}"  @if (Request::get('securityques') == $securityquess->ID) selected @endif>{{$securityquess->Question}}</option>
                           @endforeach
                    </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label>Select Cast Category</label>
                        <select class="form-control shift" name="castcategory" Placeholder="Select Cast Category">
                           <option value=" ">Select Cast Category</option>
                           @foreach ($castcategory as $castcategorys)
                           <option value="{{$castcategorys->ID}}" @if (Request::get('castcategory') == $castcategorys->ID) selected @endif>{{$castcategorys->CategoryName}}</option>
                           @endforeach
                    </select>
                    </div>
                  
                    <div class="form-group col-md-3">
                        <label>Select Language</label>
                        <select class="form-control shift" name="language" Placeholder="Select Language">
                           <option value=" ">Select Language</option>
                           @foreach ($language as $languages)
                           <option value="{{$languages->ID}}"@if (Request::get('language') == $languages->ID) selected @endif>{{$languages->LanguageName}}</option>
                           @endforeach
                    </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label>Select Disability</label>
                        <select class="form-control shift" name="disablity" Placeholder="Select Gender">
                           <option value=" ">Select Disability</option>
                           @foreach ($disablity as $disablitys)
                           <option value="{{$disablitys->ID}}"@if (Request::get('disablity') == $disablitys->ID) selected @endif>{{$disablitys->Name}}</option>
                           @endforeach
                    </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label>Payment Status</label>
                        <select class="form-control shift" name="payment" Placeholder="Select Payment">
                           <option value=" ">Select Payment</option>
                           
                           <option value="0">Not Done</option>
                           <option value="1">Success</option>
                           
                    </select>
                    </div>
                    
                    <div class="form-group col-md-3">
                        <label>Select State</label>
                        <select class="form-control shift" name="state" Placeholder="Select State">
                           <option value=" ">Select State</option>
                           @foreach ($state as $states)
                           <option value="{{$states->ID}}" @if (Request::get('state') == $states->ID) selected @endif>{{$states->StateName}}</option>
                           @endforeach
                                
                          
                           
                           
                        </select>
                    </div>
                </div>
                <div class="row">

                    <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>
                    
                      

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

                        <div class="loader-div">
                            <img class="loader-img" src="https://webapps.dot.illinois.gov/IROADS/assets/loading.gif" style="height: 120px;width: auto;" />
                        </div> 

                        

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

        </div>
    @endif
    </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({
                xhr: function() {
        var xhr = new window.XMLHttpRequest();
       
       // Download progress
       xhr.addEventListener("progress", function(evt){
           if (evt.lengthComputable) {
               var percentComplete = evt.loaded / evt.total;
               // Do something with download progress
               console.log(percentComplete);
           }
       }, false);
       
       return xhr;
    },
                 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>

    <script>
        document.addEventListener("DOMContentLoaded", function() {
            const checkboxes = document.querySelectorAll('input[type="checkbox"]');
            const form = document.querySelector('form');
    
            form.addEventListener('submit', function(event) {
                let atLeastOneChecked = false;
    
                checkboxes.forEach(function(checkbox) {
                    if (checkbox.checked) {
                        atLeastOneChecked = true;
                    }
                });
    
                if (!atLeastOneChecked) {
                    event.preventDefault(); // Prevent form submission
                    alert('At least one checkbox is mandatory');
                }
            });
        });
    </script>



    <script>
    var dataArray1 = @json($excelfeild);  
    var dataArray2 = @json($excelcondition);  
    document.getElementById('dataArray').value = JSON.stringify(dataArray1);
    document.getElementById('dataArray2').value = JSON.stringify(dataArray2);
    document.getElementById('dataForm').submit();
</script>
@endpush