@extends('backend.superadmin.layouts.master')
@section('content')
    <!-- Main Container -->
    <main id="main-container">

        <!-- Hero -->
        <div class="bg-body-light">
            <div class="content content-full">
                <div class="d-flex flex-column flex-sm-row justify-content-sm-between align-items-sm-center">
                    <h1 class="flex-sm-fill font-size-h2 font-w400 mt-2 mb-0 mb-sm-2">{{$heading}}</h1>
                </div>
            </div>
        </div>
        <!-- END Hero -->
        <!-- Page Content -->
        <div class="m-2 border">
        @include('layouts.message')

        <!-- Full Table -->
            <div class="block block-rounded">
                <div class="block-content">
                    <label for=""><strong><i class="fa fa-search"></i> Filter Result
                        @if(request('status') || request('stream_id') || request('stream_id') || request('level_id') || request('per_page'))
                            <a href="{{url()->current()}}" class="badge badge-light badge-pill"><i class="fa fa-times-circle"></i> Clear Filter</a>
                        @endif
                    </label>
                    <form action="" method="get">
                        <div class="row">
                            <div class="col-sm-4">
                                <div class="form-group">
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                                    <span class="input-group-text">
                                                        <strong>Level</strong>
                                                    </span>
                                        </div>
                                        <select name="level_id" id="" class="form-control" onchange="javascript:this.form.submit();">
                                            <option value="">--Choose--</option>
                                            @foreach($levels as $level)
                                                <option value="{{$level->id}}" @if(request('level_id')==$level->id) selected @endif>{{$level->name}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-4">
                                <div class="form-group">
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                                    <span class="input-group-text">
                                                        <strong>Stream</strong>
                                                    </span>
                                        </div>
                                        <select name="faculty_id" id="" class="form-control" onchange="javascript:this.form.submit();">
                                            <option value="">--Choose--</option>
                                            @foreach($streams as $stream)
                                                <option value="{{$stream->id}}" @if(request('faculty_id')==$stream->id) selected @endif>{{$stream->name}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-4">
                                <div class="form-group">
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">
                                                <strong>Exam</strong>
                                            </span>
                                        </div>
                                        <select name="exam_id" id="" class="form-control" onchange="javascript:this.form.submit();">
                                            <option value="">--Choose--</option>
                                            @foreach($exams as $exam)
                                                <option value="{{$exam->id}}" @if(request('exam_id')==$exam->id) selected @endif>{{$exam->title}} | {{$exam->semester->name}} | {{$exam->subject->name}} </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-12">
                                <div class="form-group">
                                    <div class="row justify-content-center">
                                        <div class="col-sm-3">
                                            <div class="input-group">
                                                <div class="input-group-prepend">
                                                    <span class="input-group-text">Exam Status</span>
                                                </div>
                                                <select name="status" id="" class="form-control" onchange="javascript:this.form.submit();">
                                                    <option value="completed" @if(request('status')=='completed') selected @endif>Completed</option>
                                                    <option value="pending" @if(request('status')=='pending') selected @endif>Pending</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-sm-3">
                                            <div class="input-group">
                                                <div class="input-group-prepend">
                                                    <span class="input-group-text">Per Page</span>
                                                </div>
                                                <select name="per_page" id="" class="form-control" onchange="javascript:this.form.submit();">
                                                    <option value="20" @if(request('per_page')=='20') selected @endif>20</option>
                                                    <option value="30" @if(request('per_page')=='30') selected @endif>30</option>
                                                    <option value="50" @if(request('per_page')=='50') selected @endif>50</option>
                                                    <option value="100" @if(request('per_page')=='100') selected @endif>100</option>
                                                    <option value="500" @if(request('per_page')=='500') selected @endif>500</option>
                                                    <option value="1000" @if(request('per_page')=='1000') selected @endif>1000</option>
                                                </select>
                                                <div class="input-group-append">
                                                    <span class="input-group-text">Entries</span>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-sm-3">
                                            <a href="{{url()->current().'/export?level_id='.request('level_id').'&faculty_id='.request('faculty_id').'&exam_id='.request('exam_id').'&status='.request('status')}}" class="btn btn-primary"><i class="fa fa-file-export"></i> Export List</a>
                                        </div>
                                        {{--<div class="col-sm-3">--}}
                                            {{--<div class="form-group">--}}
                                                {{--<div class="input-group">--}}
                                                    {{--<div class="input-group-prepend">--}}
                                            {{--<span class="input-group-text">--}}
                                                {{--<strong>Status</strong>--}}
                                            {{--</span>--}}
                                                    {{--</div>--}}
                                                    {{--<select name="status" id="" class="form-control" onchange="javascript:this.form.submit();">--}}
                                                        {{--<option value="completed" @if(request('status')=='completed') selected @endif>Completed</option>--}}
                                                        {{--<option value="pending" @if(request('status')=='pending') selected @endif>Pending</option>--}}
                                                    {{--</select>--}}
                                                {{--</div>--}}
                                            {{--</div>--}}
                                        {{--</div>--}}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <!-- END Full Table -->
            <div class="block block-rounded">
                <div class="block-content">
                    <div class="table-responsive">
                        <table id="export_btn" class="table table-md table-striped table-vcenter" style="display: none;">
                            <thead>
                            <tr>
                                <th class="text-center">SN</th>
                                <th>Student Name</th>
                                <th>Email</th>
                                <th>Mobile</th>
                                <th class="text-center">Marks</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach($students as $key=>$student)
                                @if(request('exam_id'))
                                    @php
                                        $studentExam = $student->allExams()->where('exam_id',request('exam_id'))->first();
                                    @endphp
                                @else
                                    @php
                                        $studentExam = $student->allExams()->orderBy('id','DESC')->first();
                                    @endphp
                                @endif
                                <tr>
                                    <td class="text-center">{{++$key}}</td>
                                    <td>{{$student->first_name}} {{$student->middle_name}} {{$student->last_name}}</td>
                                    <td>@if(isset($student->user->email)) {{$student->user->email}} @endif</td>
                                    <td>{{$student->mobile}}</td>
                                    <td class="text-center">{{$studentExam->score}}</td>
                                </tr>
                            @endforeach
                            </tbody>
                        </table>
                        <table class="table table-md table-striped table-vcenter">
                            <thead>
                            <tr>
                                <th class="text-center">SN</th>
                                <th>Student Name</th>
                                <th>Email</th>
                                <th>Mobile</th>
                                <th>Exam Title</th>
                                <th class="text-center">Marks</th>
                                <th class="text-center">Action</th>
                            </tr>
                            </thead>
                            <tbody>