@extends('layouts.examiner')
@section('title', isset($found) ? 'Upload Results' : 'Upload Candidates')

@section('content')

@if(isset($found))
{{-- ── POST results view ─────────────────────────────────────── --}}
<div class="d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800">Uploaded Candidates List</h1>
</div>

<div class="card shadow mb-4">
    <div class="card-header py-3">
        <h6 class="m-0 font-weight-bold text-primary">Uploaded Candidates</h6>
    </div>
    <div class="card-body">

        {{-- Raw spreadsheet preview --}}
        <div class="table-responsive mb-3">
            <table class="table table-bordered table-condensed table-sm" id="myTable">
                <thead class="thead-light">
                    <tr>
                        @foreach($headerRow as $col)
                            <th>{{ $col }}</th>
                        @endforeach
                    </tr>
                </thead>
                <tbody>
                    @foreach($dataRows as $row)
                        <tr>
                            @foreach($row as $cell)
                                <td>{{ $cell }}</td>
                            @endforeach
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>

        {{-- Summary --}}
        <h4>{{ $found }} CANDIDATE(S) RECORDS SUCCESSFULLY UPLOADED IN {{ $elapsed }}s</h4>

        @if($noDeptUniq->count())
            <h5 class="text-danger mt-3">The following department names were not found!</h5>
            <p class="text-danger">{{ $noDeptUniq->implode(', ') }}</p>
        @endif

        @if($noProgUniq->count())
            <h5 class="text-warning mt-3">The following programme names were not found!</h5>
            <p class="text-warning">{{ $noProgUniq->implode(', ') }}</p>
        @endif

        <a href="{{ route('examiner.candidates.upload') }}" class="btn btn-primary mt-3">
            <i class="fas fa-upload mr-1"></i> Upload Another File
        </a>
        <a href="{{ route('examiner.candidates.index') }}" class="btn btn-secondary mt-3">
            <i class="fas fa-users mr-1"></i> View Candidates
        </a>
    </div>
</div>

@else
{{-- ── GET upload form ───────────────────────────────────────── --}}
<div class="d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800">Upload Candidates List</h1>
</div>

<div class="row">
    <div class="col-lg-8">
        <div class="card shadow mb-4">
            <div class="card-header py-3">
                <h6 class="m-0 font-weight-bold text-primary">Upload Candidates</h6>
            </div>
            <div class="card-body">
                @if(session('error'))
                    <div class="alert alert-danger">{{ session('error') }}</div>
                @endif

                <form method="POST" action="{{ route('examiner.candidates.upload.store') }}"
                      enctype="multipart/form-data">
                    @csrf

                    <div class="form-group">
                        <label for="session_id">Academic Session</label>
                        <select name="session_id" id="session_id"
                                class="form-control @error('session_id') is-invalid @enderror" required>
                            <option value="">-- Select --</option>
                            @foreach($sessions as $s)
                                <option value="{{ $s->id }}" {{ old('session_id') == $s->id ? 'selected' : '' }}>
                                    {{ $s->name }}
                                </option>
                            @endforeach
                        </select>
                        @error('session_id')<div class="invalid-feedback">{{ $message }}</div>@enderror
                    </div>

                    <div class="form-group">
                        <label for="file">Choose File (Excel)</label>
                        <input type="file" name="file" id="file" accept=".xlsx,.xls"
                               class="form-control-file @error('file') is-invalid @enderror" required>
                        @error('file')<div class="invalid-feedback d-block">{{ $message }}</div>@enderror
                    </div>

                    <div class="form-group">
                        <button class="btn btn-outline-primary" type="submit">Upload</button>
                    </div>
                </form>

                <a href="#" data-toggle="modal" data-target="#formatModal">View Format?</a>
            </div>
        </div>
    </div>
</div>

{{-- Format modal --}}
<div class="modal fade" id="formatModal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-xl" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Excel File Format</h5>
                <button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
            </div>
            <div class="modal-body">
                <p class="text-muted small mb-2">
                    Row 1 is treated as a header and skipped.
                    Existing candidates (matched by Reg No) will be updated.
                    Rows where the Department name does not match an existing department are skipped.
                </p>
                <table class="table table-bordered">
                    <thead class="thead-light">
                        <tr>
                            <th>Column</th>
                            <th>S/N</th>
                            <th>REG NO.</th>
                            <th>NAME</th>
                            <th>STATE</th>
                            <th>GENDER</th>
                            <th>PHONE</th>
                            <th>JAMB SCORE</th>
                            <th>DEPARTMENT</th>
                            <th>PROGRAMME</th>
                            <th>DEGREE IN VIEW</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td class="text-muted">Excel col</td>
                            <td>A</td><td>B</td><td>C</td><td>D</td><td>E</td>
                            <td>F</td><td>G</td><td>H</td><td>I</td><td>J</td>
                        </tr>
                    </tbody>
                </table>
                <ul class="small text-muted pl-3 mb-0">
                    <li><strong>NAME</strong> — full name in one cell (e.g. <em>ADEYEMI JOHN PAUL</em>); split as Surname Firstname Othernames.</li>
                    <li><strong>DEPARTMENT</strong> — must exactly match an existing department name (case-insensitive). Rows with no match are skipped and reported.</li>
                    <li><strong>PROGRAMME</strong> — must match an existing programme name. Mismatch is reported but the candidate is still saved.</li>
                    <li><strong>DEGREE IN VIEW</strong> — informational only, not stored separately.</li>
                </ul>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>
@endif

@endsection