@extends('layouts.master')
@section('page_title', 'Tabulation Sheet')
@section('content')
    <div class="card">
        <div class="card-header header-elements-inline">
            <h5 class="card-title"><i class="icon-books mr-2"></i> Tabulation Sheet</h5>
            {!! Qs::getPanelOptions() !!}
        </div>

        <div class="card-body">
        <form method="post" action="{{ route('marks.tabulation_select') }}">
                    @csrf
                    <div class="row">

                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label for="exam_id" class="col-form-label font-weight-bold">Exam:</label>
                                            <select required id="exam_id" name="exam_id" class="form-control select" data-placeholder="Select Exam">
                                                <option value=""></option>
                                                @forelse($exams as $exm)
                                                    <option {{ ($selected && $exam_id == $exm->id) ? 'selected' : '' }} value="{{ $exm->id }}">{{ $exm->name }}</option>
                                                @empty
                                                    <option value="" disabled>No exams found</option>
                                                @endforelse
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="my_class_id" class="col-form-label font-weight-bold">Class:</label>
                                            <select onchange="getClassSections(this.value)" required id="my_class_id" name="my_class_id" class="form-control select" data-placeholder="Select Class">
                                                <option value=""></option>
                                                @foreach($my_classes as $c)
                                                    <option {{ ($selected && $my_class_id == $c->id) ? 'selected' : '' }} value="{{ $c->id }}">{{ $c->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="section_id" class="col-form-label font-weight-bold">Section:</label>
                                <select id="section_id" name="section_id" data-placeholder="Select Class First" class="form-control select">
                                    <option value=""></option>
                                    <option value="">All Sections</option>
                                    @if($selected)
                                    
                                        @foreach($sections->where('my_class_id', $my_class_id) as $s)
                                            <option {{ $section_id == $s->id ? 'selected' : '' }} value="{{ $s->id }}">{{ $s->name }}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>


                        <div class="col-md-2 mt-4">
                            <div class="text-right mt-1">
                                <button type="submit" class="btn btn-primary">View Sheet <i class="icon-paperplane ml-2"></i></button>
                            </div>
                        </div>

                    </div>

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

    {{--if Selction Has Been Made --}}

    @if($selected)
        <div class="card">
            <div class="card-header">
                <h6 class="card-title font-weight-bold">Tabulation Sheet for {{ $my_class->name }} {{ $section->name ?? '' }} {{ $ex->name }} </h6>
            </div>
            <div class="card-body">
                <table class="table table-responsive table-striped">
                    <thead>
                    <tr>
                        <th>#</th>
                        <th>NAMES_OF_STUDENTS_IN_CLASS</th>
                       @foreach($subjects as $sub)
                       <th title="{{ $sub->name }}" rowspan="2">{{ strtoupper($sub->slug ?: $sub->name) }}</th>
                       @endforeach
                        {{--@if($ex->term == 3)
                        <th>1ST TERM TOTAL</th>
                        <th>2ND TERM TOTAL</th>
                        <th>3RD TERM TOTAL</th>
                        <th style="color: darkred">CUM Total</th>
                        <th style="color: darkblue">CUM Average</th>
                        @endif--}}
                        <th style="color: darkred">Total</th>
                        <th style="color: darkblue">Average</th>
                        <th style="color: darkgreen">Position</th>
                    </tr>
                    </thead>
                    <tbody>
                    @php
    // Sort students descending by total marks
    $students = $students->map(function ($s) use ($marks, $tex, $subjects, $exam_id) {
        $s->computed_total = $marks
            ->where('student_id', $s->user_id)
            ->where('exam_id', $exam_id)
            ->sum($tex);
        return $s;
    })->sortByDesc('computed_total')->values();

    $prev_total = null;
    $rank = 0;
    $position = 0;
@endphp

@foreach($students as $index => $s)
    @php
        // Compare current student's total with previous
        if ($s->computed_total !== $prev_total) {
            $rank = ++$position;
            $prev_total = $s->computed_total;
        }

        $subject_count = $subjects->count();
        $student_average = $subject_count > 0 ? round($s->computed_total / $subject_count, 2) : '-';
    @endphp

    <tr>
        <td>{{ $rank }}</td>
        <td class="text-left">{{ $s->user->name }}</td>

        @foreach($subjects as $sub)
            <td>
                {{ $marks->where('student_id', $s->user_id)
                        ->where('subject_id', $sub->id)
                        ->first()->$tex ?? '-' }}
            </td>
        @endforeach

        <td class="text-danger font-weight-bold">{{ $s->computed_total ?: '-' }}</td>
        <td class="text-primary font-weight-bold">{{ $student_average ?: '-' }}</td>
        <td class="text-success font-weight-bold">{!! Mk::getSuffix($rank) !!}</td>
    </tr>
@endforeach


                    </tbody>
                </table>
                {{--Print/Export Buttons--}}
                <div class="text-center mt-4">
                    <a target="_blank" href="{{  route('marks.print_tabulation', [$exam_id, $my_class_id, $section_id ?? 0]) }}" class="btn btn-danger btn-lg mr-2"><i class="icon-printer mr-2"></i> Print Tabulation Sheet</a>
                    <a href="{{  route('marks.export_tabulation', [$exam_id, $my_class_id, $section_id ?? 0]) }}" class="btn btn-success btn-lg"><i class="icon-file-excel mr-2"></i> Export to Excel</a>
                </div>
            </div>
        </div>
    @endif
@endsection