@extends('layouts.app')
@section('title')
    All Verified Candidate With Exam center list
@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('report.fetch-center') }}" method="GET" enctype="multipart/form-data">
                
            <input type=hidden name="config" id="config" value="{{$db}}"/>
            <input type=hidden name="rightTableName" id="rightTableName" value="{{$jointablename}}"/>
            <input type=hidden name="conntype" id="conntype" value="{{$conntype}}"/>
            <input type=hidden name="rightTableColumnName" id="rightTableColumnName" value="{{$jointablecolumn}}"/>
             <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