@extends('../layout/' . $layout)

@section('subhead')
    <title>Atarud MIS - Manage Exam Marks</title>
@endsection

@section('subcontent')
    <div class="flex items-center mt-8">
        <h2 class="intro-y text-lg font-medium mr-auto">Manage Exam Marks</h2>
        {{-- <a href="javascript:;" data-tw-toggle="modal" data-tw-target="#new-exam" class="btn btn-primary w-24 ml-auto">
            <i data-lucide="plus-circle" class="w-4 h-4 mr-1"></i> Add
        </a> --}}
    </div>

    <div class="grid grid-cols-12 gap-6 mt-6">

        <!-- BEGIN: Data List -->
        <div class="intro-y col-span-12 overflow-auto lg:overflow-visible">


            <div class="overflow-x-auto"   style="border-radius:5px; border:1px solid #e5e7eb;">
                <form action="{{ route('mark.resultsheet') }}" method="post">
                    @csrf
                    <div id="details">
                         <table class='table ' >
                            <thead class='table-light'>
                                @php
                                    $total_marks = App\Models\Exam::where('id', $exam->id)->first()->total_marks;
                                    $count = 0;
                                @endphp
                            <tr>
                             <td>#</td>
                             <td>Student ID</td>
                             <td>Student Name</td>
                             <td>Student Father Name</td>
                             <td>Writing</td>
                             <td>Speaking</td>
                             <td>listinig</td>
                             <td>Reading</td>
                             <td>Home Work</td>
                             <td>FL</td>
                             <td>Mark Obtained (out of $total_marks)</td>
                             </tr>
                             </thead>
                             <tbody>
                            @php
                                // $students = App\Models\StudentCourses::where('course_id', $exam->course_id)
                                //                     ->get();

                                // $students = App\Models\StudentExamGroup::where('course_id', $exam->course_id)
                                //                             ->where('exam_id',$exam->id)
                                //                             ->where('status', 'Completed')
                                //                             ->get();
                                                            // return $request;
                            @endphp

                                @foreach($students as $row)
                                @php
                                    $student = App\Models\Student::where('id', $row->student_id)
                                                            // ->where('status', 'active')
                                                            ->first();
                                    $att = App\Models\Attendance::where('student_id', $row->student_id)
                                                                ->where('course_id', $course->id)
                                                                ->where('status', 1)
                                                                ->count();
                                    if($student == null) continue;

                                    $row2 = App\Models\Mark::where('exam_id', $exam->id)->
                                                    where('student_id', $row->student_id)->
                                                    first();
                                    $writing = App\Models\ExamQuestionSetting::where('exam_type_id', 1)->where('exam_setting_id', $exam->exam_setting_id)->first();
                                    $listening = App\Models\ExamQuestionSetting::where('exam_type_id', 2)->where('exam_setting_id', $exam->exam_setting_id)->first();
                                    $speaking = App\Models\ExamQuestionSetting::where('exam_type_id', 3)->where('exam_setting_id', $exam->exam_setting_id)->first();
                                    $reading = App\Models\ExamQuestionSetting::where('exam_type_id', 4)->where('exam_setting_id', $exam->exam_setting_id)->first();

                                    $writing = $writing != null ? $writing->total : 1;
                                    $listening = $listening != null ? $listening->total : 1;
                                    $speaking = $speaking != null ? $speaking->total : 1;
                                    $reading = $reading != null ? $reading->total : 1;

                                    $wr = $rd = $li = $sp = $hm = $total = $totalWr = $trd = $tli = $tsp = $thm = 0;
                                    $twr = $trd = $tli = $tsp = $thm = 0;

                                    if($row2 != null){
                                        $wr = $row2->wr;
                                        $rd = $row2->rd;
                                        $li = $row2->li;
                                        $sp = $row2->sp;
                                        $hm = $row2->hm;
                                        $total = $row2->mark_obtained;
                                    }else{
                                        $totalWr = 0;
                                        $qs = App\Models\StudentExamScore::where('student_id',$row->student_id)->where('exam_id', $exam->id)->get();
                                        // dd($qs);
                                        foreach($qs as $q){
                                            $qb = App\Models\QuestionBank::where('id', $q->question_id)->first();
                                            if($qb->exam_type_id == 1 ){ if($q->answerStatus == "Correct"){ ++$wr;} ++$twr;}
                                            if($qb->exam_type_id == 2 ){ if($q->answerStatus == "Correct"){ ++$li;} ++$tli;}
                                            if($qb->exam_type_id == 3 ){ if($q->answerStatus == "Correct"){ ++$sp;} ++$tsp;}
                                            if($qb->exam_type_id == 4 ){ if($q->answerStatus == "Correct"){ ++$rd;} ++$trd;}
                                        }
                                        $wr = ($writing * $wr)/ ($twr ==  0 ? 1 : $twr);
                                        $li = ($listening * $li)/ ($tli ==  0 ? 1 : $tli);
                                        $sp = ($speaking * $sp)/ ($tsp ==  0 ? 1 : $tsp);
                                        $rd = ($reading * $rd)/ ($trd ==  0 ? 1 : $trd);

                                        $total = $wr + $li + $sp + $rd;
                                        $row2 = App\Models\Mark::create([
                                            'student_id' => $row->student_id,
                                            'program_id' => $exam->program_id,
                                            'semester_id' => $exam->semester_id,
                                            'section_id' => $exam->section_id,
                                            'course_id' => $exam->course_id,
                                            'exam_id' => $exam->id,
                                            'mark_obtained' => $total,
                                            'wr' => $wr,
                                            'hm' => $hm,
                                            'rd' => $rd,
                                            'li' => $li,
                                            'sp' => $sp,
                                        ]);
                                        $wr = $row2->wr;
                                        $rd = $row2->rd;
                                        $li = $row2->li;
                                        $sp = $row2->sp;
                                        $hm = $row2->hm;
                                        $total = $row2->mark_obtained;
                                    }
                                @endphp

                                {{-- @foreach($marks as $row2) --}}

                                    <tr>
                                     <td>{{++$count}}</td>
                                     <td>{{$student->id}}</td>
                                     <td>{{$student->name}}</td>
                                     <td>{{$student->father_name}}</td>
                                     <td>
                                        <input type='number' value='{{ $wr }}' name='wr{{ $count }}' data-id='{{ $row->id }}' min='0'  onchange='return totalMarks(this)' id='wr{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $sp }}' name='sp{{ $count }}' data-id='{{ $row->id}}' min='0'  onchange='return totalMarks(this)' id='sp{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $li }}' name='li{{ $count }}' data-id='{{ $row->id }}' min='0'  onchange='return totalMarks(this)' id='li{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $rd }}' name='rd{{ $count }}' data-id='{{ $row->id }}' min='0' onchange='return totalMarks(this)' id='rd{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $hm }}' name='hm{{ $count }}' data-id='{{ $row->id }}' min='0' onchange='return totalMarks(this)' id='hm{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $att}}' name='fl{{ $count }}' data-id='{{ $row->id }}' min='0' onchange='return totalMarks(this)' id='fl{{ $row->id }}' class='form-control'/>
                                     </td>
                                     <td>
                                     <input type='number' value='{{ $total }}'  name='mark_obtained{{ $count }}' min='0'  id='mark_obtained{{ $row->id }}' class='form-control'/>
                                     <input type='hidden' name='mark_id{{ $count }}' value='{{ $row2->id }}' />
                                     </td>
                                     </tr>

                                @endforeach

                              </tbody>
                              </table>
                              <input type='hidden' name='exam_id' value='{{$exam->id}}' />
                              <input type='hidden' name='course_id' value='{{ $course->id }}' />
                              <input type='hidden' name='count' value='{{ $count }}' />

                              <button type='submit' class='btn btn-primary update_operation' style='margin-top:10px; margin-bottom: 10px; float:right;'>Save</button>
                    </div>
                </form>
            </div>

            <div class="overflow-x-auto" id="resultsheet"  style="border-radius:5px; border:1px solid #e5e7eb;">

            </div>
            <!-- END: Data List -->
        </div>

    @endsection
    @section('script')
        <script src="{{ asset('dist/js/jquery.js') }}"></script>

        <script>


         function totalMarks(element){
                var id = element.dataset.id;
                var hm = document.getElementById('hm'+id);
                var wr = document.getElementById('wr'+id);
                var sp = document.getElementById('sp'+id);
                var fl = document.getElementById('fl'+id);
                var li = document.getElementById('li'+id);
                var rd = document.getElementById('rd'+id);
                var mark_obtained = document.getElementById('mark_obtained'+id);
                mark_obtained.value = Number(hm.value) +  Number(wr.value) +  Number(fl.value) + Number(li.value) + Number(rd.value) + Number(sp.value);
        }

    </script>
    @endsection