@extends('frontend.layouts.app')
@section('title')
    Public Result
@endsection
@push('style')
    <style>
    </style>
@endpush

@section('content')
    @include('frontend.layouts.include.breadcrumb', [
        'items' => [['name' => 'Result', 'url' => '#'], ['name' => 'Public Result', 'url' => null]],
    ])
    <div class="container-fluid py-4 bg-light">
        <div class="row">
            <div class="col-12">
                <div class="">
                    <ul class="nav nav-tabs" role="tablist">
                        @foreach ($board_results as $year => $items)
                            <li class="nav-item">
                                <a class="nav-link {{ $loop->first ? 'active' : '' }}" data-toggle="tab"
                                    href="#year{{ $year }}" role="tab">
                                    {{ $year }}
                                </a>
                            </li>
                        @endforeach
                    </ul>


                    <div class="tab-content">
                        @foreach ($board_results as $year => $items)
                            <div class="tab-pane fade {{ $loop->first ? 'show active' : '' }}" id="year{{ $year }}"
                                role="tabpanel">

                                <div class="table-responsive">
                                    <table class="table table-bordered">
                                        <thead>
                                            <tr>
                                                <th>Group</th>
                                                <th>No. of Examinees</th>
                                                <th>Attend Examinees</th>
                                                <th>A+</th>
                                                <th>A</th>
                                                <th>A-</th>
                                                <th>B,C & D</th>
                                                <th>Fail</th>
                                                <th>Total Pass</th>
                                                <th>Pass Accuracy</th>
                                            </tr>
                                        </thead>

                                        <tbody>

                                            @php
                                                $sum_no_of_examinees = 0;
                                                $sum_attend = 0;
                                                $sum_a_plus = 0;
                                                $sum_a = 0;
                                                $sum_a_minus = 0;
                                                $sum_bcd = 0;
                                                $sum_f = 0;
                                            @endphp

                                            @foreach ($items as $result)
                                                @php
                                                    $totalPass = $result->attend_examinees - $result->f;
                                                    $accuracy =
                                                        $result->attend_examinees > 0
                                                            ? round(($totalPass / $result->attend_examinees) * 100, 2)
                                                            : 0;

                                                    // accumulate totals
                                                    $sum_no_of_examinees += $result->no_of_examinees;
                                                    $sum_attend += $result->attend_examinees;
                                                    $sum_a_plus += $result->a_plus;
                                                    $sum_a += $result->a;
                                                    $sum_a_minus += $result->a_minus;
                                                    $sum_bcd += $result->bcd;
                                                    $sum_f += $result->f;
                                                @endphp

                                                <tr>
                                                    <td><b>{{ $result->group_name }}</b></td>
                                                    <td>{{ $result->no_of_examinees }}</td>
                                                    <td>{{ $result->attend_examinees }}</td>
                                                    <td>{{ $result->a_plus }}</td>
                                                    <td>{{ $result->a }}</td>
                                                    <td>{{ $result->a_minus }}</td>
                                                    <td>{{ $result->bcd }}</td>
                                                    <td>{{ $result->f }}</td>
                                                    <td>{{ $totalPass }}</td>
                                                    <td>{{ $accuracy }}%</td>
                                                </tr>
                                            @endforeach

                                            @php
                                                $totalPassAll = $sum_attend - $sum_f;
                                                $totalAccuracyAll =
                                                    $sum_attend > 0 ? round(($totalPassAll / $sum_attend) * 100, 2) : 0;
                                            @endphp

                                            <tr>
                                                <td><b>Total Student</b></td>
                                                <td>{{ $sum_no_of_examinees }}</td>
                                                <td>{{ $sum_attend }}</td>
                                                <td>{{ $sum_a_plus }}</td>
                                                <td>{{ $sum_a }}</td>
                                                <td>{{ $sum_a_minus }}</td>
                                                <td>{{ $sum_bcd }}</td>
                                                <td>{{ $sum_f }}</td>
                                                <td>{{ $totalPassAll }}</td>
                                                <td>{{ $totalAccuracyAll }}%</td>
                                            </tr>
                                        </tbody>


                                    </table>
                                </div>
                            </div>
                        @endforeach
                    </div>

                </div>
            </div>
        </div>
    </div>
@endsection
@push('script')
@endpush