@extends('index')
@section('content')

    <div class="card mt-3 font-purple" style="overflow:scroll;">
        <table class="table card-table table-title pt-3">
            <tr class="no-background">
                <td width="150px" class="text-left">Kelas</td>
                <td width="10px">:</td>
                <td class="text-left"><strong>{{ $class->name }}</strong> <small>{{ $class->year }}</small></td>
                <td rowspan="5">
                    <!-- <a href="?q=download" target="_blank" class="btn btn-primary float-right d-none d-md-block" style="color:#fff;"><i class="fe fe-download"></i> Download Raport</a> -->
                </td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Semester</td>
                <td width="10px">:</td>
                @php
                    //semester(session('s_semester'))
                    $smtr = '';
                    $pisah = explode(' ', $class->name);
                    if ($pisah[0] == 'X') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 1';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 1';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 2';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 2';
                        }
                        //'<option value="1">Mid Semester 1</option><option value="2">Semester 1</option><option value="3">Mid Semester 2</option><option value="4">Semester 2</option>';
                    } elseif ($pisah[0] == 'XI') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 3';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 3';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 4';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 4';
                        }
                        //'<option value="1">Mid Semester 3</option><option value="2">Semester 3</option><option value="3">Mid Semester 4</option><option value="4">Semester 4</option>';
                    } elseif ($pisah[0] == 'XII') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 5';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 5';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 6';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 6';
                        }

                        //'<option value="1">Mid Semester 5</option><option value="2">Semester 5</option><option value="3">Mid Semester 6</option><option value="4">Semester 6</option>';
                    }
                @endphp
                <td class="text-left">{{ $smtr }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Wali Kelas</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $class->wali->getName() }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Nama Siswa</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $student->name }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">NIS</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $student->code }}</td>
            </tr>
        </table>


        <!-- <a href="?q=download" target="_blank" class="btn btn-primary float-right d-md-none" style="color:#fff;"><i class="fe fe-download"></i> Download Raport</a> -->
    </div>

    <form action="/report/{{ $student->id }}" method="POST" target="_blank" class="card mt-3">
        {{ csrf_field() }}
        <input name="_method" type="hidden" value="PUT">
        <div class="card-body">
            <div class="row">
                <div class="form-group col-md-4">
                    <label for="code">Titik Mangsa</label>
                    <input type="text" class="form-control datepicker" name="date_mangsa"
                        value="@if (session('date_mangsa')) {{ session('date_mangsa') }}@else{{ DATE('Y-m-d') }} @endif">
                </div>
            </div>
            <button type="submit" class="btn btn-primary" style="color:#fff;"><i class="fe fe-download"></i> Download
                Raport</button>
        </div>
    </form>

    <div class="card mt-3">
        <div class="tb-major card-body text-center" style="overflow:scroll;">
            <table class="table card-table" style="width:1350px;">
                <thead>
                    <tr>
                        <th scope="col" colspan="3"></th>
                        <th scope="col" colspan="2" class="font-10">Pengetahuan (KI 3)</th>
                        <th scope="col" colspan="2" class="font-10">Keterampilan (KI 4)</th>
                        <th scope="col" colspan="2" class="font-10">Sikap Spiritual (KI 1) & Sosial (KI 2)</th>
                    </tr>

                    <tr>
                        <th scope="col" class="font-10">No</th>
                        <th scope="col" class="font-10 text-left">Mata Pelajaran Siswa</th>
                        <th scope="col" class="font-10" width="80px">KKM</th>
                        <th scope="col" class="font-10" width="80px">Angka</th>
                        <th scope="col" class="font-10" width="80px">Predikat</th>
                        <th scope="col" class="font-10" width="80px">Angka</th>
                        <th scope="col" class="font-10" width="80px">Predikat</th>
                        <th scope="col" class="font-10" width="80px">Predikat</th>
                        <th scope="col" class="font-10">Antar Mata Pelajaran</th>
                    </tr>
                </thead>
                <tbody>
                    <tr class="no-background">
                        <td class="bg-full-radius"><strong>A</strong></td>
                        <td class="bg-full-radius text-left"><strong>Kelompok Mata Pelajaran Umum</strong></td>
                        <td class="bg-full-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-full-radius"></td>
                        <td class="bg-full-radius" width="180px" rowspan="{{ $count + 11 }}"
                            style="vertical-align:top;text-align:left;">
                            Sudah baik dalam sikap kejujuran, disiplin, toleransi, gotong royong, santun, dan percaya diri,
                            namun masih perlu ditingkatkan dalam sikap tanggung jawab, melalui pembiasaan penugasan mandiri
                            di rumah.
                        </td>
                    </tr>
                    @php
                        $i = 1;
                        $kkm_total = 0;
                        $knowledge_total = 0;
                        $skill_total = 0;
                        //$count = 0;
                    @endphp
                    @foreach ($kategori4 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius">{{ $i }}</td>
                            <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                            <td class="bg-full-radius">{{ $rows->kkm }}</td>
                            <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                            <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                            <td class="bg-left-radius">{{ $nSkillScore }}</td>
                            <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                            <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>
                        </tr>
                        @php
                            $i++;
                            $kkm_total = $kkm_total + $rows->kkm;
                            $knowledge_total = $knowledge_total + $nKnowledgeScore;
                            $skill_total = $skill_total + $nSkillScore;
                            //$count++;
                        @endphp
                    @endforeach

                    <tr class="no-background">
                        <td colspan="8" height="20px"></td>
                    </tr>

                    <tr class="no-background">
                        <td class="bg-full-radius"><strong>B</strong></td>
                        <td class="bg-full-radius text-left"><strong>Kelompok Mata Pelajaran Kejuruan</strong></td>
                        <td class="bg-full-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-full-radius"></td>
                    </tr>

                    @php $i = 1; @endphp
                    @foreach ($kategori5 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        @if ($rows->name != 'Projek Kreatif dan Kewirausahaan')
                            <tr class="no-background">
                                <td class="bg-full-radius">{{ $i }}</td>
                                <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                                <td class="bg-full-radius">{{ $rows->kkm }}</td>
                                <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                                <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                                <td class="bg-left-radius">{{ $nSkillScore }}</td>
                                <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                                <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>
                            </tr>
                            @php
                                $i++;
                                $kkm_total = $kkm_total + $rows->kkm;
                                $knowledge_total = $knowledge_total + $nKnowledgeScore;
                                $skill_total = $skill_total + $nSkillScore;
                                //$count++;
                            @endphp
                        @endif
                    @endforeach

                    {{-- ? SubKatebori4  --}}
                    @if ($class->class == 1)
                        <tr class="no-background">
                            <td class="bg-full-radius">{{ $i }}</td>
                            <td class="bg-full-radius text-left">Projek Ilmu Pengetahuan Alam Dan Sosial</td>
                            <td class="bg-full-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-full-radius"></td>
                        </tr>

                        @php
                            $i++;
                        @endphp
                    @endif

                    @foreach ($subcategori4 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius"></td>
                            <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                            <td class="bg-full-radius">{{ $rows->kkm }}</td>
                            <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                            <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                            <td class="bg-left-radius">{{ $nSkillScore }}</td>
                            <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                            <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                        </tr>
                        @php
                            //$i++;
                            $kkm_total = $kkm_total + $rows->kkm;
                            $knowledge_total = $knowledge_total + $nKnowledgeScore;
                            $skill_total = $skill_total + $nSkillScore;
                            //$count++;
                        @endphp
                    @endforeach

                    {{-- ? subcategori7  --}}
                    @foreach ($subcategori7 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius">{{ $i }}</td>
                            <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                            <td class="bg-full-radius">{{ $rows->kkm }}</td>
                            <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                            <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                            <td class="bg-left-radius">{{ $nSkillScore }}</td>
                            <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                            <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                        </tr>
                        @php
                            $i++;
                            $kkm_total = $kkm_total + $rows->kkm;
                            $knowledge_total = $knowledge_total + $nKnowledgeScore;
                            $skill_total = $skill_total + $nSkillScore;
                            //$count++;
                        @endphp
                    @endforeach

                    {{-- ? subcategori5  --}}
                    <tr class="no-background">
                        <td class="bg-full-radius">{{ $i }}</td>
                        <td class="bg-full-radius text-left">
                            {{ $class->class == 1 ? 'Dasar-Dasar Program Keahlian' : 'Konsentrasi Keahlian' }}
                        </td>
                        <td class="bg-full-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-left-radius"></td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-full-radius"></td>

                    </tr>
                    @php
                        $i++;
                    @endphp

                    @foreach ($subcategori5 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius"></td>
                            <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                            <td class="bg-full-radius">{{ $rows->kkm }}</td>
                            <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                            <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                            <td class="bg-left-radius">{{ $nSkillScore }}</td>
                            <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                            <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                        </tr>
                        @php
                            //$i++;
                            $kkm_total = $kkm_total + $rows->kkm;
                            $knowledge_total = $knowledge_total + $nKnowledgeScore;
                            $skill_total = $skill_total + $nSkillScore;
                            //$count++;
                        @endphp
                    @endforeach

                    {{-- ? subcategori6  --}}
                    @foreach ($subcategori6 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius"></td>
                            <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                            <td class="bg-full-radius">{{ $rows->kkm }}</td>
                            <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                            <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                            <td class="bg-left-radius">{{ $nSkillScore }}</td>
                            <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                            <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                        </tr>
                        @php
                            // $i++;
                            $kkm_total = $kkm_total + $rows->kkm;
                            $knowledge_total = $knowledge_total + $nKnowledgeScore;
                            $skill_total = $skill_total + $nSkillScore;
                            //$count++;
                        @endphp
                    @endforeach

                    @foreach ($kategori5 as $rows)
                        @php
                            $nScore = App\Score::where('user_id', $student->id)
                                ->where('lesson_id', $rows->id)
                                ->where('year_id', session('s_year'))
                                ->where('classroom_id', session('s_classroom'))
                                ->where('semester', session('s_semester'))
                                ->where('active', 1)
                                ->first();
                            if ($nScore) {
                                //$nKkm               = $nScore->kkm;
                                $nKnowledgeScore = $nScore->knowledge_score;
                                $nKnowledgeRanking = $nScore->knowledge_ranking;
                                $nSkillScore = $nScore->skill_score;
                                $nSkillRanking = $nScore->skill_ranking;
                                $nAttitudeRanking = $nScore->attitude_ranking;
                            } else {
                                //$nKkm               = 0;
                                $nKnowledgeScore = 0;
                                $nKnowledgeRanking = '-';
                                $nSkillScore = 0;
                                $nSkillRanking = '-';
                                $nAttitudeRanking = '-';
                            }
                        @endphp
                        @if ($rows->name == 'Projek Kreatif dan Kewirausahaan')
                            <tr class="no-background">
                                <td class="bg-full-radius">{{ $i }}</td>
                                <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                                <td class="bg-full-radius">{{ $rows->kkm }}</td>
                                <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                                <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                                <td class="bg-left-radius">{{ $nSkillScore }}</td>
                                <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                                <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>
                            </tr>
                            @php
                                $i++;
                                $kkm_total = $kkm_total + $rows->kkm;
                                $knowledge_total = $knowledge_total + $nKnowledgeScore;
                                $skill_total = $skill_total + $nSkillScore;
                                //$count++;
                            @endphp
                        @endif
                    @endforeach


                    {{--  @if (count($interestc1))
                        <tr class="no-background">
                            <td colspan="8" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C1</strong></td>
                            <td class="bg-full-radius text-left"><strong>DASAR BIDANG KEAHLIAN</strong></td>
                            <td class="bg-full-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-full-radius"></td>

                        </tr>
                        @php $i = 1; @endphp
                        @foreach ($interestc1 as $rows)
                            @php
                                $nScore = App\Score::where('user_id', $student->id)
                                    ->where('lesson_id', $rows->id)
                                    ->where('year_id', session('s_year'))
                                    ->where('classroom_id', session('s_classroom'))
                                    ->where('semester', session('s_semester'))
                                    ->where('active', 1)
                                    ->first();
                                if ($nScore) {
                                    //$nKkm               = $nScore->kkm;
                                    $nKnowledgeScore = $nScore->knowledge_score;
                                    $nKnowledgeRanking = $nScore->knowledge_ranking;
                                    $nSkillScore = $nScore->skill_score;
                                    $nSkillRanking = $nScore->skill_ranking;
                                    $nAttitudeRanking = $nScore->attitude_ranking;
                                } else {
                                    //$nKkm               = 0;
                                    $nKnowledgeScore = 0;
                                    $nKnowledgeRanking = '-';
                                    $nSkillScore = 0;
                                    $nSkillRanking = '-';
                                    $nAttitudeRanking = '-';
                                }
                            @endphp
                            <tr class="no-background">
                                <td class="bg-full-radius">{{ $i }}</td>
                                <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                                <td class="bg-full-radius">{{ $rows->kkm }}</td>
                                <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                                <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                                <td class="bg-left-radius">{{ $nSkillScore }}</td>
                                <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                                <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                            </tr>
                            @php
                                $i++;
                                $kkm_total = $kkm_total + $rows->kkm;
                                $knowledge_total = $knowledge_total + $nKnowledgeScore;
                                $skill_total = $skill_total + $nSkillScore;
                                //$count++;
                            @endphp
                        @endforeach
                    @endif

                    @if (count($interestc2))
                        <tr class="no-background">
                            <td colspan="8" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C2</strong></td>
                            <td class="bg-full-radius text-left"><strong>DASAR PROGRAM KEAHLIAN</strong></td>
                            <td class="bg-full-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-full-radius"></td>

                        </tr>
                        @php $i = 1; @endphp
                        @foreach ($interestc2 as $rows)
                            @php
                                $nScore = App\Score::where('user_id', $student->id)
                                    ->where('lesson_id', $rows->id)
                                    ->where('year_id', session('s_year'))
                                    ->where('classroom_id', session('s_classroom'))
                                    ->where('semester', session('s_semester'))
                                    ->where('active', 1)
                                    ->first();
                                if ($nScore) {
                                    //$nKkm               = $nScore->kkm;
                                    $nKnowledgeScore = $nScore->knowledge_score;
                                    $nKnowledgeRanking = $nScore->knowledge_ranking;
                                    $nSkillScore = $nScore->skill_score;
                                    $nSkillRanking = $nScore->skill_ranking;
                                    $nAttitudeRanking = $nScore->attitude_ranking;
                                } else {
                                    //$nKkm               = 0;
                                    $nKnowledgeScore = 0;
                                    $nKnowledgeRanking = '-';
                                    $nSkillScore = 0;
                                    $nSkillRanking = '-';
                                    $nAttitudeRanking = '-';
                                }
                            @endphp
                            <tr class="no-background">
                                <td class="bg-full-radius">{{ $i }}</td>
                                <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                                <td class="bg-full-radius">{{ $rows->kkm }}</td>
                                <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                                <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                                <td class="bg-left-radius">{{ $nSkillScore }}</td>
                                <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                                <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                            </tr>
                            @php
                                $i++;
                                $kkm_total = $kkm_total + $rows->kkm;
                                $knowledge_total = $knowledge_total + $nKnowledgeScore;
                                $skill_total = $skill_total + $nSkillScore;
                                //$count++;
                            @endphp
                        @endforeach
                    @endif

                    @if (count($interestc3))
                        <tr class="no-background">
                            <td colspan="8" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C3</strong></td>
                            <td class="bg-full-radius text-left"><strong>DASAR KOMPETENSI KEAHLIAN </strong></td>
                            <td class="bg-full-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-left-radius"></td>
                            <td class="bg-right-radius"></td>
                            <td class="bg-full-radius"></td>

                        </tr>
                        @php $i = 1; @endphp
                        @foreach ($interestc3 as $rows)
                            @php
                                $nScore = App\Score::where('user_id', $student->id)
                                    ->where('lesson_id', $rows->id)
                                    ->where('year_id', session('s_year'))
                                    ->where('classroom_id', session('s_classroom'))
                                    ->where('semester', session('s_semester'))
                                    ->where('active', 1)
                                    ->first();
                                if ($nScore) {
                                    //$nKkm               = $nScore->kkm;
                                    $nKnowledgeScore = $nScore->knowledge_score;
                                    $nKnowledgeRanking = $nScore->knowledge_ranking;
                                    $nSkillScore = $nScore->skill_score;
                                    $nSkillRanking = $nScore->skill_ranking;
                                    $nAttitudeRanking = $nScore->attitude_ranking;
                                } else {
                                    //$nKkm               = 0;
                                    $nKnowledgeScore = 0;
                                    $nKnowledgeRanking = '-';
                                    $nSkillScore = 0;
                                    $nSkillRanking = '-';
                                    $nAttitudeRanking = '-';
                                }
                            @endphp
                            <tr class="no-background">
                                <td class="bg-full-radius">{{ $i }}</td>
                                <td class="bg-full-radius text-left">{{ $rows->name }}</td>
                                <td class="bg-full-radius">{{ $rows->kkm }}</td>
                                <td class="bg-left-radius">{{ $nKnowledgeScore }}</td>
                                <td class="bg-right-radius">{{ $nKnowledgeRanking }}</td>
                                <td class="bg-left-radius">{{ $nSkillScore }}</td>
                                <td class="bg-right-radius">{{ $nSkillRanking }}</td>
                                <td class="bg-full-radius">{{ textRanking($nAttitudeRanking) }}</td>

                            </tr>
                            @php
                                $i++;
                                $kkm_total = $kkm_total + $rows->kkm;
                                $knowledge_total = $knowledge_total + $nKnowledgeScore;
                                $skill_total = $skill_total + $nSkillScore;
                                //$count++;
                            @endphp
                        @endforeach
                    @endif  --}}

                    <tr class="no-background">
                        <td colspan="9" height="20px"></td>
                    </tr>

                    <tr class="no-background">
                        <td class="bg-full-radius" colspan="2"><strong>Jumlah Nilai</strong></td>
                        <td class="bg-full-radius">{{ $kkm_total }}</td>
                        <td class="bg-left-radius">{{ $knowledge_total }}</td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-left-radius">{{ $skill_total }}</td>
                        <td class="bg-right-radius"></td>
                        <td class="bg-full-radius"></td>

                    </tr>

                    <tr class="no-background">
                        @php
                            $avgKkm = $count_real > 0 ? ceil($kkm_total / $count_real) : 0;
                            $avgKnowledge = $count_real > 0 ? ceil($knowledge_total / $count_real) : 0;
                            $avgSkill = $count_real > 0 ? ceil($skill_total / $count_real) : 0;
                        @endphp

                        <td class="bg-full-radius" colspan="2"><strong>Rata-Rata</strong></td>
                        <td class="bg-full-radius">{{ $avgKkm }}</td>
                        <td class="bg-left-radius">{{ $avgKnowledge }}</td>
                        <td class="bg-right-radius">{{ checkRanking($avgKnowledge) }}</td>
                        <td class="bg-left-radius">{{ $avgSkill }}</td>
                        <td class="bg-right-radius">{{ checkRanking($avgSkill) }}</td>
                        <td class="bg-full-radius"></td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <div class="card mt-3">
        <div class="card-body">
            <h2 class="card-title pt-1 float-left">1. Kegiatan Ekstrakurikuler</h2>
        </div>
        <div class="tb-major card-body text-center" style="overflow:scroll;">
            @if ($extraUser)
                <table class="table card-table">
                    <thead>
                        <tr>
                            <th>No</th>
                            <th>Ekstrakurikuler</th>
                            <th>Keterangan</th>
                        </tr>
                    </thead>
                    @php
                        $i = 1;
                    @endphp
                    <tbody>
                        @foreach ($extraUser as $ext)
                            <tr>
                                <td>{{ $i }}.</td>
                                <td>{{ $ext->Extracurricular->name }}</td>
                                <td>{{ $ext->score }}</td>
                            </tr>
                            @php
                                $i++;
                            @endphp
                        @endforeach
                        {{--  <tr>
                            <td>2</td>
                            <td>Ekstrakurikukuler 2</td>
                            <td>{{ $extra->extra_two }}</td>
                        </tr>
                        <tr>
                            <td>3</td>
                            <td>Ekstrakurikukuler 3</td>
                            <td>{{ $extra->extra_three }}</td>
                        </tr>
                        <tr>
                            <td>4</td>
                            <td>Ekstrakurikukuler 4</td>
                            <td>{{ $extra->extra_four }}</td>
                        </tr>
                        <tr>
                            <td>5</td>
                            <td>Ekstrakurikukuler 5</td>
                            <td>{{ $extra->extra_five }}</td>
                        </tr>  --}}
                    </tbody>
                </table>
            @else
                <p>Tidak ada data</a>
            @endif
        </div>
    </div>

    <div class="card mt-3">
        <div class="card-body">
            <h2 class="card-title pt-1 float-left">2. Ketidakhadiran</h2>
        </div>
        <div class="tb-major card-body text-center" style="overflow:scroll;">

            <table class="table card-table">
                <thead>
                    <tr>
                        <th scope="col" width="50px">No</th>
                        <th scope="col">Keterangan</th>
                        <th scope="col" width="150px"></th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>1</td>
                        <td>Sakit</td>
                        <td>{{ $student->getPresenceCount(2) }} Kali</td>
                    </tr>
                    <tr>
                        <td>2</td>
                        <td>Ijin</td>
                        <td>{{ $student->getPresenceCount(3) }} Kali</td>
                    </tr>
                    <tr>
                        <td>3</td>
                        <td>Tanpa Keterangan</td>
                        <td>{{ $student->getPresenceCount(4) }} Kali</td>
                    </tr>
                </tbody>
            </table>

        </div>
    </div>

    <div class="card mt-3">
        <div class="card-body">
            <h2 class="card-title pt-1 float-left">Capaian</h2>
        </div>
        <div class="tb-major card-body text-center" style="overflow:scroll;">
            <table class="table card-table">
                <thead>

                    <tr>
                        <th scope="col" width="50px">No</th>
                        <th scope="col" class="text-left">Mata Pelajaran Siswa</th>
                        <th scope="col">Kopetensi</th>
                        <th scope="col">Predikat</th>
                    </tr>
                </thead>
                <tbody>
                    <tr class="no-background">
                        <td class="bg-full-radius"><strong>A</strong></td>
                        <td class="bg-full-radius text-left" colspan="3"><strong>KELOMPOK MATA PELAJARAN UMUM</strong>
                        </td>
                    </tr>
                    @php
                        $i = 1;
                    @endphp
                    @foreach ($kategori4 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                        @php
                            $i++;
                        @endphp
                    @endforeach

                    <tr class="no-background">
                        <td colspan="4" height="20px"></td>
                    </tr>

                    <tr class="no-background">
                        <td class="bg-full-radius"><strong>B</strong></td>
                        <td class="bg-full-radius text-left" colspan="3"><strong>KELOMPOK MATA PELAJARAN
                                KEJURUAN</strong></td>
                    </tr>
                    @php
                        $i = 1;
                    @endphp
                    @foreach ($kategori5 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                        @php
                            $i++;
                        @endphp
                    @endforeach

                    {{--  ? Subkategori4  --}}
                    @if ($class->class == 1)
                        <tr class="no-background">
                            <td class="bg-full-radius">{{ $i }}</td>
                            <td class="bg-full-radius text-left" colspan="3">
                                Projek Ilmu Pengetahuan Alam Dan Sosial
                            </td>
                        </tr>
                        @php
                            $i++;
                        @endphp
                    @endif

                    @foreach ($subcategori4 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3"></td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                    @endforeach

                    {{--  ? Subkategori5  --}}
                    <tr class="no-background">
                        <td class="bg-full-radius">{{ $i }}</td>
                        <td class="bg-full-radius text-left" colspan="3">
                            {{ $class->class == 1 ? 'Dasar-Dasar Program Keahlian' : 'Konsentrasi Keahlian' }}
                        </td>
                    </tr>
                    @php
                        $i++;
                    @endphp
                    @foreach ($subcategori5 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3"></td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                    @endforeach

                    {{--  ? Subkategori6  --}}
                    @foreach ($subcategori6 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                        @php
                            $i++;
                        @endphp
                    @endforeach

                    @foreach ($subcategori7 as $rows)
                        <tr class="no-background">
                            <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                            <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                            <td class="bg-full-radius">Pengetahuan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                pengetahuan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Keterampilan</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                Keterampilan</td>
                        </tr>
                        <tr class="no-background">
                            <td class="bg-full-radius">Sosial & Spiritual</td>
                            <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan kompetensi
                                sikap sosial & spiritual</td>
                        </tr>
                        @php
                            $i++;
                        @endphp
                    @endforeach

                    {{--  @if (count($interestc1))
                        <tr class="no-background">
                            <td colspan="4" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C1</strong></td>
                            <td class="bg-full-radius text-left" colspan="3"><strong>DASAR BIDANG KEAHLIAN</strong>
                            </td>
                        </tr>
                        @php
                            $i = 1;
                        @endphp
                        @foreach ($interestc1 as $rows)
                            <tr class="no-background">
                                <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                                <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                                <td class="bg-full-radius">Pengetahuan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi pengetahuan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Keterampilan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi Keterampilan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Sosial & Spiritual</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi sikap sosial & spiritual</td>
                            </tr>
                            @php
                                $i++;
                            @endphp
                        @endforeach
                    @endif

                    @if (count($interestc2))
                        <tr class="no-background">
                            <td colspan="4" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C2</strong></td>
                            <td class="bg-full-radius text-left" colspan="3"><strong>DASAR PROGRAM KEAHLIAN</strong>
                            </td>
                        </tr>
                        @php
                            $i = 1;
                        @endphp
                        @foreach ($interestc2 as $rows)
                            <tr class="no-background">
                                <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                                <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                                <td class="bg-full-radius">Pengetahuan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi pengetahuan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Keterampilan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi Keterampilan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Sosial & Spiritual</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi sikap sosial & spiritual</td>
                            </tr>
                            @php
                                $i++;
                            @endphp
                        @endforeach
                    @endif

                    @if (count($interestc3))
                        <tr class="no-background">
                            <td colspan="4" height="20px"></td>
                        </tr>

                        <tr class="no-background">
                            <td class="bg-full-radius"><strong>C3</strong></td>
                            <td class="bg-full-radius text-left" colspan="3"><strong>DASAR KOMPETENSI KEAHLIAN</strong>
                            </td>
                        </tr>
                        @php
                            $i = 1;
                        @endphp
                        @foreach ($interestc3 as $rows)
                            <tr class="no-background">
                                <td class="bg-full-radius" rowspan="3">{{ $i }}</td>
                                <td class="bg-full-radius text-left" rowspan="3">{{ $rows->name }}</td>
                                <td class="bg-full-radius">Pengetahuan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi pengetahuan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Keterampilan</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi Keterampilan</td>
                            </tr>
                            <tr class="no-background">
                                <td class="bg-full-radius">Sosial & Spiritual</td>
                                <td class="bg-full-radius text-left">sudah menunjukkan sikap baik dalam penguasaan
                                    kompetensi sikap sosial & spiritual</td>
                            </tr>
                            @php
                                $i++;
                            @endphp
                        @endforeach
                    @endif  --}}

                </tbody>
            </table>
        </div>
    </div>

@endsection
@push('script')
@endpush