@extends('layouts.dashboard')



@section('title-content')
    <title>
        {{ config('app.name') }} | Course Work</title>
@endsection
@section('content')
    <div class="row">
        <div class="col-md-12">
            <!-- Custom Tabs -->
            <div class="nav-tabs-customx">
                <ul class="nav nav-tabs tabs-bordered" id="tabMenu">
                    {{-- @dd($student->studentyear->year) --}}

                    @for ($y = 1; $y <= count($student_years); $y++)
                        <li class=" nav-item">
                            <a class="nav-link {{ $y == 1 ? 'active' : '' }}" href="#year-{{ $y }}"
                                data-toggle="tab" aria-expanded="false">
                                {!! $srs->year_level($y) !!}
                            </a>
                        </li>
                    @endfor
                </ul>

                <div class="tab-content">

                    @for ($y = 1; $y <= count($student_years); $y++)
                        <div class="tab-pane {{ $y == 1 ? 'active' : '' }}" id="year-{{ $y }}">

                            <div class="boxpane">
                                <div class="boxpane-header">
                                    <h2 class="blue"><i class="fa-fw fa fa-book nb"></i>
                                        The following is the list of course(s) that registered for <b
                                            class="black">[{{ $student->reg_no }}]</b> in this
                                        academic year
                                    </h2>
                                </div>
                                <div class="boxpane-content">
                                    <div class="row">
                                        <div class="col-md-12">

                                            <div class="table-responsive">
                                                <table class="text-center mt-1 table-hover table-bordered table-striped"
                                                    width="100%">
                                                    <thead class="bg-light black">
                                                        <tr>
                                                            <th colspan="10">Semister 1 </th>
                                                        </tr>
                                                        <tr>
                                                            <th class="text-left">Code</th>
                                                            <th class="text-left">Course Name</th>
                                                            <th>Credit</th>
                                                            <th class="text-left">CA(s) Scores</th>
                                                            <th> CA</th>
                                                            <th>TOTAL</th>
                                                            <th>Grade</th>
                                                            <th>GPA</th>
                                                            <th>Remark</th>
                                                            <th>Action</th>

                                                        </tr>
                                                    </thead>
                                                    <tbody>


                                                        @php
                                                            
                                                            $courses = $srs->getCourses($student->reg_no, 1, $y);
                                                            $student_data = $student_years->where('year_of_study', $y)->first();
                                                            if (empty($student_data)) {
                                                                continue;
                                                            }
                                                            $check_stat = [];
                                                            
                                                            $total_credit = 0;
                                                            $total_gpa = 0;
                                                            $total_course = 0;
                                                            $ma_gpa = collect();
                                                            
                                                        @endphp

                                                        @foreach ($courses as $item)
                                                            @php
                                                                $setup = $srs->getCoursesSetup($item->course_id, $item->batch_id);
                                                                $view_info = $srs->getCoursesView($item->course_id, $student->reg_no);
                                                                $total_cs_setup = $srs->getCoursesSetupTotal($item->course_id, $item->batch_id);
                                                                
                                                                $ma_gpa->add($view_info);
                                                                $ma_gpa2 = collect();
                                                                $ma_gpa2->add($view_info);
                                                                
                                                                $gpy = 0;
                                                                $gpy = $srs->getGPA($ma_gpa2, $student_gpa);
                                                                
                                                                try {
                                                                    $view_info2 = $srs->getCoursesRes($view_info->course_works_id);
                                                                } catch (\Exception $e) {
                                                                    continue;
                                                                }
                                                                
                                                                $total_credit = $total_credit + $item->unit;
                                                                
                                                            @endphp
                                                            <tr>
                                                                <td class="text-left">{{ $item->course_code }}</td>
                                                                <td class="text-left">{{ $item->course_name }}</td>
                                                                <td class="text-left">{{ $item->unit }}</td>


                                                                @if (empty($check_stat))




                                                                    <td class="text-left">
                                                                        @foreach ($setup as $key)
                                                                            @php
                                                                                $names = $key->item_acronim;
                                                                                if (!empty($view_info2)) {
                                                                                    $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                                                                }
                                                                            @endphp
                                                                            &nbsp;&nbsp;&nbsp; {{ $names }} -
                                                                            @if ($matokeo)
                                                                                {{ $matokeo->score }}
                                                                            @endif <br>
                                                                        @endforeach
                                                                    </td>
                                                                    <td>
                                                                        @if (!empty($total_cs_setup))
                                                                            @php
                                                                                if (!empty($view_info2)) {
                                                                                    $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                                                                }
                                                                            @endphp
                                                                            @if ($tot_ca)
                                                                                {{ $tot_ca->score }}
                                                                            @endif
                                                                        @endif
                                                                    </td>
                                                                    <td>
                                                                        @if ($view_info != 'No View')
                                                                            {{ $view_info->final_rm }}
                                                                        @endif
                                                                    </td>
                                                                    <td>
                                                                        @if ($view_info != 'No View')
                                                                            {{ $view_info->final_grade }}
                                                                        @endif
                                                                    </td>
                                                                    <td>
                                                                        @foreach ($gpy as $key)
                                                                            <b>
                                                                                @if ($key['gpa'] > 0)
                                                                                    {{ bcdiv($key['gpa'], 1, 4) }}
                                                                                @endif
                                                                            </b>
                                                                        @break
                                                                    @endforeach

                                                                </td>



                                                                <td>
                                                                    @if ($view_info != 'No View')
                                                                        {{ $view_info->final_remark }}
                                                                        @php
                                                                            
                                                                            $total_course++;
                                                                        @endphp
                                                                    @endif
                                                                </td>
                                                            @else
                                                                @if ($check_stat->ca1 == 1)
                                                                    <td colspan="2"> CA Closed </td>
                                                                @else
                                                                    <td class="text-left">
                                                                        @foreach ($setup as $key)
                                                                            @php
                                                                                $names = $key->item_acronim;
                                                                                if (!empty($view_info2)) {
                                                                                    $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                                                                }
                                                                            @endphp
                                                                            &nbsp;&nbsp;&nbsp; {{ $names }} -
                                                                            @if ($matokeo)
                                                                                {{ $matokeo->score }}
                                                                            @endif <br>
                                                                        @endforeach
                                                                    </td>
                                                                    <td>
                                                                        @if (!empty($total_cs_setup))
                                                                            @php
                                                                                if (!empty($view_info2)) {
                                                                                    $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                                                                }
                                                                            @endphp
                                                                            @if ($tot_ca)
                                                                                {{ $tot_ca->score }}
                                                                            @endif
                                                                        @endif
                                                                    </td>
                                                                @endif
                                                                @if ($check_stat->se1 == 1)
                                                                    <td colspan="2"> SE Closed </td>
                                                                @else
                                                                    <td>
                                                                        @if ($view_info != 'No View')
                                                                            {{ $view_info->final_grade }}
                                                                        @endif
                                                                    </td>
                                                                    <td>
                                                                        @if ($view_info != 'No View')
                                                                            {{ $view_info->final_remark }}
                                                                            @php
                                                                                
                                                                                $total_course++;
                                                                            @endphp
                                                                        @endif
                                                                    </td>
                                                                @endif

                                                            @endif
                                                            <td>
                                                                @hasanyrole('SuperAdmin|Admin|DRARC|DAEO')
                                                                    <li class="list-group-item">
                                                                        {{ link_to(route('result_daeo_issue.edit', ['user_id' => $srs->encode($item->user_id), 'course_id' => $srs->encode($item->course_id)]), 'Appeal') }}
                                                                    </li>
                                                                @endhasanyrole

                                                            </td>

                                                        </tr>
                                                    @endforeach

                                                </tbody>
                                                <tfoot class="text-left">
                                                    <tr>

                                                        <th colspan="10" class="bg-light text-center">
                                                            Grade
                                                            Summary
                                                        </th>


                                                    </tr>
                                                    <tr>

                                                        <td rowspan="3" colspan="8"></td>
                                                        <td>Total Credit</td>
                                                        <td><b>{{ $total_credit }}</b>
                                                        </td>

                                                    </tr>


                                                    <tr>
                                                        <td>GPA</td>
                                                        @php
                                                            $gp = $srs->getGPA($ma_gpa, $student_gpa);
                                                            
                                                        @endphp
                                                        @foreach ($gp as $key)
                                                            <td><b>
                                                                    @if ($key['gpa'] > 0)
                                                                        {{ bcdiv($key['gpa'], 1, 4) }}
                                                                    @endif
                                                                </b></td>
                                                    </tr>
                                                    <tr>
                                                        <td>Remarks</td>

                                                        <td><b>If you have RM status, Come and sit for supplementary
                                                                examinations.</b></td>
                                                    @break

            @endforeach
            </tr>

            </tfoot>
            </table>
            <br><br><br>
            <table class="text-center mt-1 table-hover table-bordered table-striped" width="100%">
                <thead class="bg-light black">
                    <tr>
                        <th colspan="10">Semister 2 </th>

                    </tr>
                    <tr>
                        <th class="text-left">Code</th>
                        <th class="text-left">Course Name</th>
                        <th class="text-left">Credit</th>
                        <th class="text-left">CA(s) Scores</th>
                        <th>CA</th>
                        <th>TOTAL</th>
                        <th>Grade</th>
                        <th>GPA</th>
                        <th>Remark</th>
                        <th>Action</th>

                    </tr>
                </thead>
                <tbody>
                    @php
                        $courses = $srs->getCourses($student->reg_no, 2, $y);
                        $total_credit = 0;
                        $total_gpa = 0;
                        $total_course = 0;
                        $ma_gpa = collect();
                        
                    @endphp
                    @foreach ($courses as $item)
                        @php
                            $setup = $srs->getCoursesSetup($item->course_id, $item->batch_id);
                            $view_info = $srs->getCoursesView($item->course_id, $student->reg_no);
                            $total_cs_setup = $srs->getCoursesSetupTotal($item->course_id, $item->batch_id);
                            try {
                                $view_info2 = $srs->getCoursesRes($view_info->course_works_id);
                            } catch (\Exception $e) {
                                continue;
                            }
                            $ma_gpa->add($view_info);
                            $ma_gpa2 = collect();
                            $ma_gpa2->add($view_info);
                            
                            $gpy = 0;
                            $gpy = $srs->getGPA($ma_gpa2, $student_gpa);
                            
                            $total_credit = $total_credit + $item->unit;
                            
                        @endphp
                        <tr>
                            <td class="text-left">{{ $item->course_code }}</td>
                            <td class="text-left">{{ $item->course_name }}</td>
                            <td class="text-left">{{ $item->unit }}</td>
                            @if (empty($check_stat))

                                <td class="text-left">
                                    @foreach ($setup as $key)
                                        @php
                                            $names = $key->item_acronim;
                                            if (!empty($view_info2)) {
                                                $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                            }
                                        @endphp
                                        &nbsp;&nbsp;&nbsp; {{ $names }} -@if ($matokeo)
                                            {{ $matokeo->score }}
                                        @endif <br>
                                    @endforeach
                                </td>
                                <td>
                                    @if (!empty($total_cs_setup))
                                        @php
                                            if (!empty($view_info2)) {
                                                $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                            }
                                        @endphp
                                        @if ($tot_ca)
                                            {{ $tot_ca->score }}
                                        @endif
                                    @endif
                                </td>

                                <td>
                                    @if ($view_info != 'No View')
                                        {{ $view_info->final_rm }}
                                    @endif
                                </td>
                                <td>
                                    @if ($view_info != 'No View')
                                        {{ $view_info->final_grade }}
                                    @endif
                                </td>
                                <td>
                                    @foreach ($gpy as $key)
                                        <b>{{ $key['gpa'] }}</b>
                                    @break
                                @endforeach

                            </td>
                            <td>
                                @if ($view_info != 'No View')
                                    {{ $view_info->final_remark }}
                                    @php
                                        $total_gpa = 1;
                                        $total_course++;
                                    @endphp
                                @endif
                            </td>
                        @else
                            @if ($check_stat->ca2 == 1)
                                <td colspan="2"> CA Closed </td>
                            @else
                                <td class="text-left">
                                    @foreach ($setup as $key)
                                        @php
                                            $names = $key->item_acronim;
                                            if (!empty($view_info2)) {
                                                $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                            }
                                        @endphp
                                        &nbsp;&nbsp;&nbsp; {{ $names }} -@if ($matokeo)
                                            {{ $matokeo->score }}
                                        @endif <br>
                                    @endforeach
                                </td>
                                <td>
                                    @if (!empty($total_cs_setup))
                                        @php
                                            if (!empty($view_info2)) {
                                                $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                            }
                                        @endphp
                                        @if ($tot_ca)
                                            {{ $tot_ca->score }}
                                        @endif
                                    @endif
                                </td>
                            @endif
                            @if ($check_stat->se2 == 1)
                                <td colspan="2"> SE Closed </td>
                            @else
                                <td>
                                    @if ($view_info != 'No View')
                                        {{ $view_info->final_grade }}
                                    @endif
                                </td>

                                <td>
                                    @if ($view_info != 'No View')
                                        {{ $view_info->final_remark }}
                                        @php
                                            $total_gpa = 1;
                                            $total_course++;
                                        @endphp
                                    @endif
                                </td>
                            @endif

                        @endif
                        <td>
                            @hasanyrole('SuperAdmin|Admin|DRARC|DAEO')
                                <li class="list-group-item">
                                    {{ link_to(route('result_daeo_issue.edit', ['user_id' => $srs->encode($item->user_id), 'course_id' => $srs->encode($item->course_id)]), 'Appeal') }}
                                </li>
                            @endhasanyrole

                        </td>

                    </tr>
                @endforeach
            </tbody>
            <tfoot class="text-left">
                <tr>

                    <th colspan="10" class="bg-light text-center">
                        Grade
                        Summary
                    </th>


                </tr>
                <tr>

                    <td rowspan="3" colspan="8"></td>
                    <td>Total Credit</td>
                    <td><b>{{ $total_credit }}</b>
                    </td>

                </tr>

                <tr>
                    <td>GPA</td>
                    @php
                        $gp = $srs->getGPA($ma_gpa, $student_gpa);
                        
                    @endphp
                    @foreach ($gp as $key)
                        <td><b>
                                @if ($key['gpa'] > 0)
                                    {{ bcdiv($key['gpa'], 1, 4) }}
                                @endif
                            </b></td>
                </tr>
                <tr>
                    <td>Remarks</td>

                    <td><b>{{ $key['award'] }}</b></td>
                @break

                @endforeach
            </tr>

        </tfoot>
    </table>

    @php
        $courses = $srs->getCourses($student->reg_no, 3, $y);
    @endphp
    @if (count($courses) > 0)
        <br><br><br>

        <table class="text-center mt-1 table-hover table-bordered table-striped" width="100%">
            <thead class="bg-light black">
                <tr>
                    <th colspan="10">Semister 3 </th>

                </tr>
                <tr>
                    <th class="text-left">Code</th>
                    <th class="text-left">Course Name</th>
                    <th class="text-left">Credit</th>
                    <th class="text-left">CA(s) Scores</th>
                    <th>CA</th>
                    <th>TOTAL</th>
                    <th>Grade</th>
                    <th>GPA</th>
                    <th>Remark</th>
                    <th>Action</th>

                </tr>
            </thead>
            <tbody>
                @php
                    $courses = $srs->getCourses($student->reg_no, 3, $y);
                    $total_credit = 0;
                    $total_gpa = 0;
                    $total_course = 0;
                    $ma_gpa = collect();
                    
                @endphp
                @foreach ($courses as $item)
                    @php
                        $setup = $srs->getCoursesSetup($item->course_id, $item->batch_id);
                        $view_info = $srs->getCoursesView($item->course_id, $student->reg_no);
                        $total_cs_setup = $srs->getCoursesSetupTotal($item->course_id, $item->batch_id);
                        try {
                            $view_info2 = $srs->getCoursesRes($view_info->course_works_id);
                        } catch (\Exception $e) {
                            continue;
                        }
                        $ma_gpa->add($view_info);
                        $ma_gpa2 = collect();
                        $ma_gpa2->add($view_info);
                        
                        $gpy = 0;
                        $gpy = $srs->getGPA($ma_gpa2, $student_gpa);
                        
                        $total_credit = $total_credit + $item->unit;
                        
                    @endphp
                    <tr>
                        <td class="text-left">{{ $item->course_code }}</td>
                        <td class="text-left">{{ $item->course_name }}</td>
                        <td class="text-left">{{ $item->unit }}</td>
                        @if (empty($check_stat))

                            <td class="text-left">
                                @foreach ($setup as $key)
                                    @php
                                        $names = $key->item_acronim;
                                        if (!empty($view_info2)) {
                                            $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                        }
                                    @endphp
                                    &nbsp;&nbsp;&nbsp; {{ $names }} -@if ($matokeo)
                                        {{ $matokeo->score }}
                                    @endif <br>
                                @endforeach
                            </td>
                            <td>
                                @if (!empty($total_cs_setup))
                                    @php
                                        if (!empty($view_info2)) {
                                            $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                        }
                                    @endphp
                                    @if ($tot_ca)
                                        {{ $tot_ca->score }}
                                    @endif
                                @endif
                            </td>

                            <td>
                                @if ($view_info != 'No View')
                                    {{ $view_info->final_rm }}
                                @endif
                            </td>
                            <td>
                                @if ($view_info != 'No View')
                                    {{ $view_info->final_grade }}
                                @endif
                            </td>
                            <td>
                                @foreach ($gpy as $key)
                                    <b>{{ $key['gpa'] }}</b>
                                @break
                            @endforeach

                        </td>
                        <td>
                            @if ($view_info != 'No View')
                                {{ $view_info->final_remark }}
                                @php
                                    $total_gpa = 1;
                                    $total_course++;
                                @endphp
                            @endif
                        </td>
                    @else
                        @if ($check_stat->ca2 == 1)
                            <td colspan="2"> CA Closed </td>
                        @else
                            <td class="text-left">
                                @foreach ($setup as $key)
                                    @php
                                        $names = $key->item_acronim;
                                        if (!empty($view_info2)) {
                                            $matokeo = $view_info2->where('course_setup_id', $key->id)->first();
                                        }
                                    @endphp
                                    &nbsp;&nbsp;&nbsp; {{ $names }} -@if ($matokeo)
                                        {{ $matokeo->score }}
                                    @endif <br>
                                @endforeach
                            </td>
                            <td>
                                @if (!empty($total_cs_setup))
                                    @php
                                        if (!empty($view_info2)) {
                                            $tot_ca = $view_info2->where('course_setup_id', $total_cs_setup->id)->first();
                                        }
                                    @endphp
                                    @if ($tot_ca)
                                        {{ $tot_ca->score }}
                                    @endif
                                @endif
                            </td>
                        @endif
                        @if ($check_stat->se2 == 1)
                            <td colspan="2"> SE Closed </td>
                        @else
                            <td>
                                @if ($view_info != 'No View')
                                    {{ $view_info->final_grade }}
                                @endif
                            </td>

                            <td>
                                @if ($view_info != 'No View')
                                    {{ $view_info->final_remark }}
                                    @php
                                        $total_gpa = 1;
                                        $total_course++;
                                    @endphp
                                @endif
                            </td>
                        @endif

                    @endif
                    <td>
                        @hasanyrole('SuperAdmin|Admin|DRARC|DAEO')
                            <li class="list-group-item">
                                {{ link_to(route('result_daeo_issue.edit', ['user_id' => $srs->encode($item->user_id), 'course_id' => $srs->encode($item->course_id)]), 'Appeal') }}
                            </li>
                        @endhasanyrole

                    </td>

                </tr>
            @endforeach
        </tbody>
        <tfoot class="text-left">
            <tr>

                <th colspan="10" class="bg-light text-center">
                    Grade
                    Summary
                </th>


            </tr>
            <tr>

                <td rowspan="3" colspan="8"></td>
                <td>Total Credit</td>
                <td><b>{{ $total_credit }}</b>
                </td>

            </tr>

            <tr>
                <td>GPA</td>
                @php
                    $gp = $srs->getGPA($ma_gpa, $student_gpa);
                    
                @endphp
                @foreach ($gp as $key)
                    <td><b>
                            @if ($key['gpa'] > 0)
                                {{ bcdiv($key['gpa'], 1, 4) }}
                            @endif

                        </b></td>
            </tr>
            <tr>
                <td>Remarks</td>

                <td><b>{{ $key['award'] }}</b></td>
            @break

@endforeach
</tr>

</tfoot>
</table>

@endif


</div>
</div>
</div>
</div>
</div>
</div>
@endfor
</div>
</div>
</div>
</div>
</div>
</div>
@endsection
@section('css')
<link rel="stylesheet" href="{{ asset('assets/css/select') }}/select2.min.css" />
<link rel="stylesheet" href="{{ asset('assets/css/bootstrap') }}/fileinput.min.css" />
@endsection
@section('scripts')
<script src="{{ asset('assets/js/select') }}/select2.min.js"></script>
<script src="{{ asset('assets/js/bootstrap') }}/fileinput.min.js"></script>
<script>
    $('#gender').select2({
        minimumResultsForSearch: -1,
    });
    $('#entry_qualification').select2({
        minimumResultsForSearch: -1,
    });
    $('#is_disabled').select2({
        minimumResultsForSearch: -1,
    });
    $('#sponsorship').select2({
        minimumResultsForSearch: -1,
    });
    $('#citizenship').select2({});
    $(document).on('ready', function() {
        $("#avatar").fileinput({
            showUpload: false,
            dropZoneEnabled: false,
            mainClass: "input-group-lg"
        });
    });

    $(document).ready(function() {
        $('#tabMenu a[href="#{{ old('tab') }}"]').tab('show')
    });
</script>
@endsection