@extends('layouts.dashboard')

@section('title-content')
    <title>{{ config('app.name') }} Course Details | Carry Over</title>
@endsection
@section('content')
    <div class="row">
        <div class="col-md-12">
            <div class="boxpane">
                <div class="boxpane-header">
                    <h2 class="blue"><i class="fa-fw fa fa-dashboard"></i>
                        Registered Student(s) on the course-<b class="black">{{ $course->course_code }}</b>
                    </h2>
                </div>
            </div>
            <div class="boxpane-content">
                <div class="row">
                    <div class="col-md-12">
                        <p class="introtext">
                            Here is the list of all students registered to this course who have <b>Carry over</b> and
                            their academic results,you can use
                            the form below
                            to filter student(s).Click the following link to get an excel file with registered students
                        </p>
                        <div class="table-responsive">
                            <table id="carryTable" class="tablex table-striped table-bordered table-hover text-justify"
                                style="width: 100%;">
                                <thead>
                                    <tr>
                                        <th rowspan="2">#</th>
                                        <th rowspan="2">Student Name</th>
                                        <th rowspan="2">Sex</th>
                                        <th rowspan="2">Registration No.</th>
                                        @if ($course->scheme_id == 6 || $course->scheme_id == 7)
                                            <th colspan="5">CA Scores</th>
                                        @else
                                            <th colspan="4">CA Scores</th>
                                        @endif
                                        @if ($course->cw == 100)
                                            <th rowspan="2">{{ $CA }}</th>
                                        @else
                                            @if ($course->scheme_id == 6 || $course->scheme_id == 7)
                                                <th rowspan="2">{{ $CA }}</th>
                                            @else
                                                <th rowspan="2">{{ $CA }}</th>
                                            @endif
                                            <th rowspan="2">{{ $UE }}</th>
                                            <th rowspan="2">{{ $Total }}</th>
                                            <th rowspan="2">Grade</th>
                                            <th rowspan="2">CA.Remarks</th>
                                            <th rowspan="2">OV.Remarks</th>
                                            <th rowspan="2">Status</th>
                                        @endif
                                    </tr>
                                    <tr>
                                        <th>{{ $ASSIGN1 }}</th>
                                        <th>{{ $ASSIGN2 }}</th>
                                        <th>{{ $T1 }}</th>
                                        <th>{{ $T2 }}</th>
                                        @if ($course->scheme_id == 6 || $course->scheme_id == 7)
                                            <th>{{ $PORTFOLIO }}</th>
                                        @endif
                                    </tr>
                                </thead>
                                <tbody>

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script src="{{ asset('assets/dashboard/js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('assets/dashboard/js/dataTables.bootstrap4.min.js') }}"></script>

    <script type="text/javascript">
        $(document).ready(function() {
            @if ($course->scheme_id == 6 || $course->scheme_id == 7)
                let carryTable = $('#carryTable').DataTable({
                    processing: true,
                    //serverSide: true,
                    ajax: '{{ route('courses.get-carry-students', $id) }}',
                    columns: [{
                            data: 'DT_RowIndex'
                        },
                        {
                            data: 'full_name',
                            name: 'users.first_name'
                        },
                        {
                            data: 'gender',
                            name: 'users.gender'
                        },
                        {
                            data: 'reg_no',
                            name: 'students.reg_no'
                        },
                        {
                            data: 'a1',
                            name: 'course_works.a1'
                        },
                        {
                            data: 'a2',
                            name: 'course_works.a2'
                        },
                        {
                            data: 't1',
                            name: 'course_works.t1'
                        },
                        {
                            data: 't2',
                            name: 'course_works.t2'
                        },
                        {
                            data: 'portfolio',
                            name: 'course_works.portfolio'
                        },
                        {
                            data: 'total_ca',
                            name: 'course_works.total_ca'
                        },
                        {
                            data: 'score',
                            name: 'results.score'
                        },
                        {
                            data: 'total',
                            name: 'total',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'grade',
                            name: 'grade',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'ca_remark',
                            name: 'ca_remark',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'remark',
                            name: 'remark',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'cs_status',
                            name: 'course_students.cs_status'
                        }
                    ],
                    columnDefs: [{
                        className: 'text-center',
                        targets: [2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
                    }],

                });
            @else
                let carryTable = $('#carryTable').DataTable({
                    processing: true,
                    //serverSide: true,
                    ajax: '{{ route('courses.get-carry-students', $id) }}',
                    columns: [{
                            data: 'DT_RowIndex'
                        },
                        {
                            data: 'full_name',
                            name: 'users.first_name'
                        },
                        {
                            data: 'gender',
                            name: 'users.gender'
                        },
                        {
                            data: 'reg_no',
                            name: 'students.reg_no'
                        },
                        {
                            data: 'a1',
                            name: 'course_works.a1'
                        },
                        {
                            data: 'a2',
                            name: 'course_works.a2'
                        },
                        {
                            data: 't1',
                            name: 'course_works.t1'
                        },
                        {
                            data: 't2',
                            name: 'course_works.t2'
                        },
                        {
                            data: 'total_ca',
                            name: 'course_works.total_ca'
                        },
                        {
                            data: 'score',
                            name: 'results.score'
                        },
                        {
                            data: 'total',
                            name: 'total',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'grade',
                            name: 'grade',
                            orderable: false,
                            searchable: false
                        },

                        {
                            data: 'ca_remark',
                            name: 'ca_remark',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'remark',
                            name: 'remark',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'cs_status',
                            name: 'course_students.cs_status'
                        }
                    ],
                    columnDefs: [{
                        className: 'text-center',
                        targets: [2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
                    }],

                });
            @endif

            // courseTable.draw(false);
        })
    </script>
@endsection