@php
if(isset($_POST['current_class'])){ 
    $current_class = $_POST['current_class'];
    $board = $_POST['board'];
}else{
    $current_class = 1;
}    
            #"English" => array("Average (PT & HW) (10)","Internal Assessment(35)","Marks Obtained (100)"),
            #"eng_" => array("Average (PT & HW) (10)","Internal Assessment(35)","Marks Obtained (100)"),
if(($current_class <= 5) && ($board == 'IB')){
    $cal_marks = array(
            "English" => array("Total"),
            "eng_" => array("Total"),
            "Maths" => array("Total"),
            "maths_" => array("Total"),
            "Science" => array("Total"),
            "uoi1_" => array("Total"),
            "SST / EVS" => array("Total"),
            "uoi2_" => array("Total"),
            "Punjabi" => array("Total"),
            "punjabi_" => array("Total"),
            "Spiritual Development Program" => array("Total"),
            "divinity_" => array("Total"),
            "Hindi" => array("Total"),
            "hindi_" => array("Total"),
            "ICT" => array("Total"),
            "ict_" => array("Total"),
            "P.E." => array(),
            "pe_" => array(),
            "Music" => array(),
            "music_" => array(),
            "CACA" => array(),
            "caca_" => array(),
            "Visual Art" => array(),
            "visual_art_" => array(),
            "GK" => array(),
            "gk_" => array(),
            "UOI" => array("Total"),
            "uoi_" => array("Total"),
            // "UOI" => array("Total"),
            // "U1-UOI" => array("Total"),
            // "U2-UOI" => array("Total"),
            // "u1-uoi" => array("Total"),
            // "u2-uoi" => array("Total"),
            // "uoi_" => array("Total"),
            // "EVS" => array("Total"),
            // "evs_" => array("Total"),
            // "Computer(Oral)" => array("Total"),
            // "computer_" => array("Total"),
            // "Divinity" => array("Total"),
            // "RS" => array("Total"),
            // "rs_" => array("Total"),
    );

}elseif($current_class <= 2){
    $cal_marks = array(
            "English" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "eng_" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "Punjabi" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "punjabi_" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "Hindi" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "hindi_" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "Maths" => array("Marks Obtained (100)","Marks Obtained (100)"),
            "maths_" => array("Marks Obtained (100)","Marks Obtained (100)"),
            "EVS (Oral)" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "evs_" => array("Internal Assessment(20)","Marks Obtained (100)"),
            "Computer(Oral)" => array("Marks Obtained (100)"),
            "computer_" => array("Marks Obtained (100)"));
}elseif($current_class <= 5){
            #"English" => array("PT+HW +SR (20)","Avg(PT+HW+SR) - 10","Internal Assessment (30)","Marks Obtained (100)"),
            #"eng_" => array("PT+HW +SR (20)","Avg(PT+HW+SR) - 10","Internal Assessment (30)","Marks Obtained (100)"),
    $cal_marks = array( 
            "English" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "eng_" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "Punjabi" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "punjabi_" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "Hindi" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "hindi_" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "Maths" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "maths_" => array("Internal Assessment (20)","Marks Obtained (100)"),
            "Science" => array("Internal Assessment (20)","YE+Project (80)","Marks Obtained (100)"),
            "science_" => array("Internal Assessment (20)","YE+Project (80)","Marks Obtained (100)"),
            "Social Science" => array("Internal Assessment (20)","YE+Project (80)","Marks Obtained (100)"),
            "social_science_" => array("Internal Assessment (20)","YE+Project (80)","Marks Obtained (100)"),
            "Computer" => array("Internal Assessment (20)","Marks Obtained(100)"),
            "computer_" => array("Internal Assessment (20)","Marks Obtained(100)"));
}elseif($current_class <= 8){         
    $cal_marks = array( 
        "English" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "eng_" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "Punjabi" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "punjabi_" => array("Internal Assessment (20)","Marks Obtained (100)"),
        "Hindi" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "hindi_" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "Maths" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "maths_" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "Science" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "science_" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "SST" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "social_science_" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "Computer" => array("Internal Assessment (M.M.20)","Marks Obtained (100)"),
        "computer_" => array("Marks Obtained (100)","Marks Obtained (100)"),
        "Divinity" => array("Marks Obtained (100)"),
        "divinity_" => array("Marks Obtained (100)"));
}else{
    $cal_marks = array( 
        "English" => array("Marks Obtained (100)"),
        "eng_" => array("Marks Obtained (100)"),
        "Punjabi" => array("Marks Obtained (100)"),
        "punjabi_" => array("Marks Obtained (100)"),
        "Hindi" => array("Marks Obtained (100)"),
        "hindi_" => array("Marks Obtained (100)"),
        "Mathematics" => array("Marks Obtained (100)"),
        "maths_" => array("Marks Obtained (100)"),
        "Science" => array("Marks Obtained (100)"),
        "science_" => array("Marks Obtained (100)"),
        "Social Science" => array("Marks Obtained (100)"),
        "social_science_" => array("Marks Obtained (100)"),
        "Computer" => array("Marks Obtained (100)"),
        "computer_" => array("Marks Obtained (100)"),
        "Divinity" => array("Marks Obtained (100)"),
        "divinity_" => array("Marks Obtained (100)"));    
}              
@endphp 
<!--
<div class="col-lg-12">
    <div class="p-3 mb-2 bg-primary text-white" style="cellpadding:15px; cellspacing:15px;">
            <div class="panel-heading">
                <div class="panel-title">{{$title}}</div>
                <div class="pull-right">       
                </div>
            </div>
            <div class="table-responsive">
                <div class="row">
                    <div class="col-lg-12">
                            {{ Form::open(array('url' => 'teacher/viewAcademicResult', 'method' => 'post')) }}
                            {{ csrf_field() }}
                            <div class="form-group">
                            <div class="row">
                                <div class="col-lg-2">
                                    <b>Select School</b>
                                    @php $school = ''; if(!empty($_POST['school'])) $school = $_POST['school']; @endphp 
                                    {{ Form::select('school', $schools_list_arr, $school, ['placeholder' => '- Select School -', 'class' => 'form-control', 'id' => 'school', 'required' => '']) }}
                                </div>
                                                                  
                                <div class="col-lg-2">
                                    <b>Select Class</b>
                                    @php $current_class = -13; 
                                     if(isset($_POST['current_class'])) 
                                        $current_class = $_POST['current_class'];  
                                     @endphp
                                    {{ Form::select('current_class', $arrClasses, $current_class, ['placeholder' => '- Select Class -', 'class' => 'form-control', 'id' => 'current_class', 'required' => '']) }}
                                </div> 

                                <div class="col-lg-1">
                                    <b>Section</b>
                                    @php $section = ''; if(!empty($_POST['section'])) $section = $_POST['section']; @endphp 
                                    {{ Form::select('section', $sections, $section, ['placeholder' => 'Select', 'class' => 'form-control', 'id' => 'section', 'required' => '']) }}
                                </div>

                                <div class="col-lg-2">
                                    <b>Session</b>
                                     @php $session = ''; if(!empty($_POST['session'])){ $session = $_POST['session']; }else{ $session = $active_session; } @endphp 
                                     {{ Form::select('session', $session_list, $session, ['placeholder' => 'Session', 'class' => 'form-control', 'id' => 'session', 'required' => '']) }}
                                </div>

                                <div class="col-lg-1">
                                    <b>Board</b>
                                    @php $Board = ''; if(!empty($_POST['Board'])) { $Board = $_POST['Board']; }else{ $Board = 'CBSE'; } @endphp 
                                   {{ Form::select('board', ["CBSE"=>"CBSE","IB"=>"IB","CAIE"=>"CAIE"], $Board, ['placeholder' => '- Select Board-', 'class' => 'form-control', 'id' => 'Board', 'required' => '']) }}
                                </div>                                                                
                                <div class="col-lg-2">
                                    <b>Result Type</b>
                                    @php $resultType = ''; if(!empty($_POST['resultType'])) { $resultType = $_POST['resultType']; }else{ $resultType = ''; } @endphp 
                                    {{ Form::select('resultType', ["Pre Mid Term"=>"Pre Mid Term","Half Yearly"=>"Half Yearly","Post Mid Term"=>"Post Mid Term","Final"=>"Final","Co-Scholastic Term 1" => "Co-Scholastic Term 1","Co-Scholastic Term 2" => "Co-Scholastic Term 2","Discipline Term 1" => "Discipline Term 1","Discipline Term 2" => "Discipline Term 2"], $resultType, ['placeholder' => '- Select Board-', 'class' => 'form-control', 'id' => 'Board', 'required' => '']) }}
                                </div>

                                <div class="col-lg-2">  
                                        <div class="form-group" id="submit_btn">
                                            <div class="col-sm-8">
                                               <b>&nbsp;</b>
                                               <button type="submit" class="btn btn-info form-control">Submit</button>
                                            </div>
                                        </div>                                    
                                </div>
                            </div>
                            </div>
                            {{ Form::close() }}
                    </div>
                </div>
            </div>
    </div>
</div>
-->
@if (count($sqlExist) > 0)
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">View School Result</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <table class="table table-bordered" border="1">
        <tbody>
          <tr>
            <td rowspan="2"><b>S No.</b></td>
            <td rowspan="2"><b>Student Name</b></td>
            <td rowspan="2"><b>Admission No.</b></td>
            @php 
                $subject_mapping = [];
                foreach ($sqlSubTitle as $sub) {
                    if (!isset($subject_mapping[$sub->subject])) {
                        $field_arr = explode('pmt_', $sub->table_field_name);
                        $subject_mapping[$sub->subject] = $field_arr[0];
                    }
                }
            @endphp
            @foreach ($final_subject as $key => $value22)
                @php 
                    $field_name = isset($subject_mapping[$value22]) ? $subject_mapping[$value22] : $value22;
                    $sub_title_cnt = isset($cal_marks[$field_name]) ? count($cal_marks[$field_name]) : 0; 
                @endphp
            <td colspan={{$array_count_field_name[$value22]+$sub_title_cnt}}><b>{{$value22}}</b></td>
            @endforeach
          </tr>
          <tr>
            @php $p = 0; $q = 'eng_'; echo "<pre>"; @endphp
            @foreach ($sqlSubTitle as $key => $value)
                @if($p == 0) <!-- First Time 'Perodic Test' Print -->
                    @php $p = $value->subject_id; @endphp
                @endif
                @if($q != $value->table_field_name) <!-- On Sub Title Change Print Cal Fields -->
                    @if(isset($cal_marks[$q]))
                        @foreach ($cal_marks[$q] as $key33 => $value33)
                        <td><b>{{$value33}}</b></td>
                        @endforeach
                    @endif
                    @php $q = $value->table_field_name; @endphp
                    <td><b>{{$value->sub_title}}</b></td>    
                @else
                    <td><b>{{$value->sub_title}}</b></td>
                @endif    
            @endforeach
            @if(isset($cal_marks[$q]))
                @foreach ($cal_marks[$q] as $key33 => $value33) <!-- At Last Print Cal Fields-->
                        <td><b>{{$value33}}</b></td>
                @endforeach
            @endif
           </tr> 


        
        @php $i = 1; @endphp     
        @foreach ($sqlExist as $results)
        <tr>
            <td>{{ $i }}</td>
            <td>{{ isset($results['s_full_name_hid'])?$results['s_full_name_hid']:'' }}</td>
            <td>{{ $results['s_adm_no_hid'] }}</td>
            @php $vals = array_count_values($table_field_name1); @endphp
            @php $j = 1; @endphp
            @foreach ($table_field_name1 as $key => $value)
            @php
                if($j <= $vals[$value])
                {
                    $fieldName=$value.'marks'.$j;
                    $fieldName2=$value.'perodic_test';
                    $s_adm_no_hid = $results['s_adm_no_hid'];

                        @endphp 
                            <td>{{ isset($results[$fieldName]) ? $results[$fieldName] : "" }} <b style="color: red;">{{ (isset($results[$fieldName.'_old']) && ($results[$fieldName.'_old'] != $results[$fieldName])) ? $results[$fieldName.'_old'] : "" }}</b></td>
                    @php        
                    if($j < $vals[$value]){
                        $j++;
                    }else{
                        $p = 1;
                        @endphp
                        @if(isset($cal_marks[$value]))
                            @foreach ($cal_marks[$value] as $key33 => $value33) 
                            @php 
                                $fieldName3=$value.'cal'.$p; 
                                
                                // Calculate total dynamically for all subjects (single or multiple assessments)
                                $calculatedTotal = 0;
                                if (isset($vals[$value]) && $vals[$value] >= 1) {
                                    for ($k = 1; $k <= $vals[$value]; $k++) {
                                        $marksField = $value.'marks'.$k;
                                        if (isset($results[$marksField]) && is_numeric($results[$marksField])) {
                                            $calculatedTotal += $results[$marksField];
                                        }
                                    }
                                }
                                
                                $displayValue = ($calculatedTotal > 0) ? $calculatedTotal : (isset($results[$fieldName3]) ? $results[$fieldName3] : "");
                                $p++; 
                            @endphp
                            <td><b>{{ $displayValue }}</b></td>
                        @endforeach                        @endif                        @php
                      $j=1;
                    }
                }else{
                    $j=1;
                }
            @endphp
            @endforeach
          </tr>
          
          @php $j++; $i++;@endphp
        
        @endforeach
        </tbody>
      </table>
    </div>
            {{ Form::open([ 'method' => 'post', 'url' => 'teacher/addAcademicResult','class' => 'form-horizontal']) }}
            {{ csrf_field() }}
            {{ Form::hidden('school_id', $school_id, ['class' => 'school_id', 'id' => 'school_id', 'required' => '']) }}
            {{ Form::hidden('current_class', $current_class, ['class' => 'class', 'id' => 'current_class', 'required' => '']) }}
            {{ Form::hidden('section', $section, ['class' => 'section', 'id' => 'section', 'required' => '']) }}
            {{ Form::hidden('session', $session, ['class' => 'session', 'id' => 'session', 'required' => '']) }}
            {{ Form::hidden('board', $board, ['class' => 'board', 'id' => 'board', 'required' => '']) }}
            {{ Form::hidden('result_type', $result_type, ['class' => 'result_type', 'id' => 'result_type', 'required' => '']) }}
            <b class="d-flex justify-content-center justify-content-middel">
              @if(($getResultStatus != 1) && ($getResultStatus != 2) && ($getResultStatus != 3) && isset($getResultStatus) && ($assignAsChk == 'Teacher'))
              &nbsp;Yes, I have been filled all the student marks, now its ready for oberver review.&nbsp;
              {{ Form::button('Submit', ['class' => 'btn btn-info result_submit', 'data-submitFrom'=>'Teacher','id'=>'result_submit']) }}
              @elseif(($getResultStatus != 2) && ($getResultStatus != 3) && isset($getResultStatus) && ($assignAsChk == 'Observer'))
              &nbsp;Yes, I have review all the student marks, now its ready for principal review.&nbsp;
              {{ Form::button('Submit', ['class' => 'btn btn-info result_submit', 'data-submitFrom'=>'Observer','id'=>'result_submit']) }}
              @endif
            </b><br>
            {{ Form::close() }}
@endif
      <script type="text/javascript">
      $(document).on('click', '.result_submit', function () {
        var school_id = $('#school_id').val();
        var current_class = $('#current_class').val();
        var section = $('#section').val();
        var session = $('#session').val();
        var board = $('#board').val();
        var result_type = $('#result_type').val();
        var submitFrom = $(this).attr('data-submitFrom');
        var thisScope = this;
        $.ajax({
              url: "{{url('/')}}/teacher/submitResultForObserver", 
              type: "post",
              data: {school_id:school_id, current_class:current_class, section:section, session:session, board:board, result_type:result_type, submitFrom:submitFrom},
              dataType: "json",
              beforeSend  : function(){
                  // Show image container
                  //$(thisScope).parent().parent().find('.loader').show();
                  //$(thisScope).parent().parent().find('.saveTeacher').hide();        
              },        
              success: function(data)
              {
                  alert("Class teacher submit the result for observer review.");
              },
              error: function(data) {
                  alert("Sorry! Some error occurred during add/update.");
              },
              complete   : function(data){
                  // Hide image container
                  document.getElementById("result_submit").style.display = "none";
                  window.location.reload(true);
                  
              }
          });
      });
      </script>