@extends('layouts.examiner')
@section('title', 'View Results')

@section('content')
<div class="d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800">View Results</h1>
    <a href="{{ route('examiner.results.export') }}" class="btn btn-sm btn-outline-secondary">
        <i class="fas fa-database mr-1"></i> Export Backup Table
    </a>
</div>

@if(session('success'))
<div class="alert alert-success alert-dismissible fade show">
    {{ session('success') }}
    <button type="button" class="close" data-dismiss="alert"><span>&times;</span></button>
</div>
@endif

<div class="card shadow mb-4">
    <div class="card-body">

        {{-- Filter form --}}
        <form action="{{ route('examiner.results.index') }}" method="GET" id="filterForm">
            <div class="form-row align-items-end">
                <div class="form-group col-md-2">
                    <label class="small font-weight-bold">SESSION <span class="text-danger">*</span></label>
                    <select name="a_session" class="form-control" required>
                        <option value="">- Select -</option>
                        @foreach($sessions as $s)
                        <option value="{{ $s->id }}" {{ $sessionId == $s->id ? 'selected' : '' }}>{{ $s->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group col-md-3">
                    <label class="small font-weight-bold">FACULTY</label>
                    <select name="faculty" class="form-control">
                        <option value="">- All -</option>
                        @foreach($faculties as $f)
                        <option value="{{ $f->id }}" {{ $facId == $f->id ? 'selected' : '' }}>{{ $f->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group col-md-2">
                    <label class="small font-weight-bold">DEGREE</label>
                    <select name="degree" class="form-control">
                        <option value="0">All</option>
                        @foreach($degrees as $deg)
                        <option value="{{ $deg->id }}" {{ $degreeId == $deg->id ? 'selected' : '' }}>{{ $deg->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group col-md-2">
                    <label class="small font-weight-bold">EXAM DATE</label>
                    <input name="date" type="date" class="form-control" value="{{ $date }}">
                </div>
                <div class="form-group col-md-1">
                    <label class="small font-weight-bold">PER PAGE</label>
                    <select name="per_page" class="form-control">
                        @foreach([25, 50, 100, 200] as $n)
                        <option value="{{ $n }}" {{ $perPage == $n ? 'selected' : '' }}>{{ $n }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group col-md-2">
                    <label class="small font-weight-bold d-block">&nbsp;</label>
                    <button class="btn btn-success btn-block" type="submit" name="submit" value="1">
                        <i class="fas fa-search mr-1"></i> View Results
                    </button>
                </div>
            </div>

            {{-- Search row --}}
            @if($searched)
            <div class="form-row mt-1">
                <div class="col-md-4">
                    <div class="input-group input-group-sm">
                        <div class="input-group-prepend">
                            <span class="input-group-text"><i class="fas fa-search"></i></span>
                        </div>
                        <input type="text" name="search" class="form-control"
                               placeholder="Search by reg no or name..." value="{{ $search }}">
                        <div class="input-group-append">
                            <button type="submit" name="submit" value="1" class="btn btn-outline-primary">Search</button>
                            @if($search)
                            <a href="{{ route('examiner.results.index', array_merge(request()->except(['search','page']), ['submit'=>1])) }}"
                               class="btn btn-outline-secondary">Clear</a>
                            @endif
                        </div>
                    </div>
                </div>
                @if($rows !== null)
                <div class="col-md-8 text-right small text-muted pt-1">
                    Showing {{ $rows->firstItem() }}–{{ $rows->lastItem() }} of <strong>{{ $rows->total() }}</strong> result(s)
                    @if($search) matching <em>"{{ $search }}"</em>@endif
                </div>
                @endif
            </div>
            @endif
        </form>

        <div class="table-responsive mt-3">
            <table class="table table-bordered table-sm table-hover">
                <thead class="thead-dark">
                    <tr>
                        <th>S/N</th>
                        <th>REG NO.</th>
                        <th>NAME</th>
                        <th>GENDER</th>
                        <th>STATE</th>
                        <th>FACULTY</th>
                        <th>DEPARTMENT</th>
                        @if($jamb)
                        <th>JAMB</th>
                        <th>PUTME</th>
                        <th>AGGREGATE</th>
                        @else
                        <th>SCORE</th>
                        @endif
                        <th>DATE</th>
                    </tr>
                </thead>
                <tbody>
                @if($rows === null)
                    <tr>
                        <td colspan="{{ $jamb ? 11 : 10 }}" class="text-center text-muted py-4">
                            <i class="fas fa-filter mr-1"></i> Select a session above and click <strong>View Results</strong>.
                        </td>
                    </tr>
                @elseif($rows->isEmpty())
                    <tr>
                        <td colspan="{{ $jamb ? 11 : 10 }}" class="text-center text-muted py-4">
                            No completed results found for the selected filters.
                        </td>
                    </tr>
                @else
                    @foreach($rows as $row)
                    <tr>
                        <td>{{ $rows->firstItem() + $loop->index }}</td>
                        <td>
                            <a href="{{ route('examiner.result-display', ['reg_no' => $row->reg_no, 'session_id' => $sessionId]) }}">
                                {{ $row->reg_no }}
                            </a>
                        </td>
                        <td>{{ $row->name }}</td>
                        <td>{{ $row->gender }}</td>
                        <td>{{ $row->state_of_origin }}</td>
                        <td>{{ $row->fac_name }}</td>
                        <td>{{ $row->dept_name }}</td>
                        @if($jamb)
                        <td>{{ $row->jamb }}</td>
                        <td>{{ $row->putme }}</td>
                        <td>{{ $row->aggregate }}</td>
                        @else
                        <td>{{ $row->putme }}</td>
                        @endif
                        <td>{{ $date ?? ($row->stopped_at ? \Carbon\Carbon::parse($row->stopped_at)->format('Y-m-d') : '') }}</td>
                    </tr>
                    @endforeach
                @endif
                </tbody>
            </table>
        </div>

        {{-- Pagination --}}
        @if($rows !== null && $rows->hasPages())
        <div class="d-flex justify-content-center mt-2">
            {{ $rows->links() }}
        </div>
        @endif

        {{-- Download Excel --}}
        @if($rows !== null && $rows->isNotEmpty())
        <form action="{{ route('examiner.results.export-excel') }}" method="POST" target="_blank" class="mt-3 pt-3 border-top">
            @csrf
            <input type="hidden" name="session_id" value="{{ $sessionId }}">
            <input type="hidden" name="faculty"    value="{{ $facId }}">
            <input type="hidden" name="degree"     value="{{ $degreeId }}">
            <input type="hidden" name="date"       value="{{ $date }}">
            <input type="hidden" name="search"     value="{{ $search }}">
            <button class="btn btn-success btn-sm" type="submit">
                <i class="fas fa-file-excel mr-1"></i> Download ALL {{ $rows->total() }} Results as Excel
            </button>
            <div class="form-check form-check-inline ml-2">
                <input class="form-check-input" type="checkbox" name="jamb" value="1" id="with_jamb">
                <label class="form-check-label small" for="with_jamb">Include JAMB Score</label>
            </div>
        </form>
        @endif

    </div>
</div>

<div class="card shadow mb-4">
    <div class="card-header py-3">
        <h6 class="m-0 font-weight-bold text-warning">
            <i class="fas fa-sync mr-1"></i> Generate / Recompute Results
        </h6>
    </div>
    <div class="card-body">
        <p class="small text-muted mb-2">
            Recomputes scores from <code>pume_answers</code> and saves to the backup <code>results</code> table.
        </p>
        <form method="POST" action="{{ route('examiner.results.generate') }}" class="form-inline"
              onsubmit="return confirm('Generate/overwrite results for selected session?')">
            @csrf
            <select name="session_id" class="form-control form-control-sm mr-2" required>
                <option value="">Select Session</option>
                @foreach($sessions as $s)
                <option value="{{ $s->id }}">{{ $s->name }}</option>
                @endforeach
            </select>
            <button type="submit" class="btn btn-warning btn-sm">
                <i class="fas fa-sync mr-1"></i> Generate
            </button>
        </form>
    </div>
</div>
@endsection