@include('includes.header')
<!-- Page content-->
<div class="container">
    <div class="mt-5">
        @if(!empty($code) && !empty($message) && $code === 200)
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <strong>Success!</strong> {{ $message }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @elseif(!empty($code) && !empty($message) && $code === 404)
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <strong>Error!</strong> {{ $message }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif
        <h1>Search Data</h1>
        <form role="form" method="GET" class="mb-5" name="searchForm" id="searchForm">
            <div class="d-flex gap-2">
                <div class="col-sm-3">
                    <input type="text" name="employer_name" id="employer_name" placeholder="Employer Name"
                           value="{{ (request()->input('employer_name') ? request()->input('employer_name') : (!empty($searchValues->employer_name) ? $searchValues->employer_name : '')) }}"
                           class="form-control">
                    <span id="searchEmployerError" class="font-size-13 text-danger"></span>
                </div>
                <div class="col-sm-3">
                    <select class="form-select select2" name="states" id="statesValue">
                        <option value="">Select Work State</option>
                        @foreach($states as $state)
                            <option value="{{ $state->id }}"
                                    @if(request()->input('states') == $state->id) selected
                                    @endif @if(!empty($searchValues->state_id) && $searchValues->state_id == $state->id) selected @endif >{{ $state->state_name }}</option>
                        @endforeach
                    </select>
                    <span id="searchStateError" class="font-size-13 text-danger"></span>
                </div>
                <div class="col-sm-2">
                    <button type="submit" id="searchBtn" class="btn btn-primary">
                        <span class="spinner-grow spinner-grow-sm" id="spinnerSearch" style="display: none"
                              aria-hidden="true"></span>
                        &nbsp;Search & Save
                    </button>
                </div>
            </div>
        </form>
        @if(request()->search_data_id != 0)
            @php
                $searchData = App\Models\SearchValues::select('search_values.*', 'states.state_name')
               ->leftJoin('states', 'search_values.state_id', '=', 'states.id')
               ->orderBy('search_values.created_at', 'desc')
               ->get();
            @endphp
            @include('import-duplicate',['searchData' => $searchData])
        @endif

        @if(!empty($data->total()))
            <div class="row">
                <div class="col-sm-9">
                    <p>Found {{ !empty($data->total()) ? $data->total() : 0 }} records as per below, We have saved in
                        our records</p>
                </div>
                <div class="col-sm-3">
                    <a href="{{ route('downloadSearchData', ['id' => request()->get('search_data_id')]) }}"
                       class="btn btn-primary float-end mb-2">
                        Download CSV
                    </a>
                </div>
            </div>
        @endif
        <table class="table table-bordered">
            <thead>
            <tr>
                <th scope="col">#</th>
                <th scope="col">Name</th>
                <th scope="col">Title</th>
                <th scope="col">Employer Name</th>
                <th scope="col">State</th>
            </tr>
            </thead>
            <tbody>
            @if(!empty($data->total()))
                @foreach($data as $key => $row)
                    <tr>
                        <th scope="row">{{ $data->firstItem() + $key }}</th>
                        <td>{{ !empty($row['Name']) ? $row['Name'] : 'N/A' }}</td>
                        <td>{{ !empty($row['Title__c']) ? $row['Title__c'] : 'N/A' }}</td>
                        <td>{{ !empty($row['School_District__c']) ? $row['School_District__c'] : 'N/A' }}</td>
                        <td>{{ !empty($row['State__c']) ? $row['State__c'] : 'N/A' }}</td>
                    </tr>
                @endforeach
            @else
                <tr>
                    <td colspan="8">
                        <center>No Records Found!</center>
                    </td>
                </tr>
            @endif
            </tbody>
        </table>
        <div class="pagination-custom">
            {{$data->links()}}
        </div>
    </div>
</div>
@include('includes.footer')