@php
        if (isset($_POST['current_class'])) {
            $current_class = $_POST['current_class'];
        } 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 < 1) {
            $cal_marks = [
                'English' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'eng_' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'Punjabi' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'punjabi_' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'Hindi' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'hindi_' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'Maths' => ['Marks Obtained (100)', 'Marks Obtained (100)'],
                'maths_' => ['Marks Obtained (100)', 'Marks Obtained (100)'],
                'UOI' => ['Marks Obtained (100)', 'Marks Obtained (100)'],
                'uoi_' => ['Marks Obtained (100)', 'Marks Obtained (100)'],
                'EVS (Oral)' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'evs_' => ['Internal Assessment(20)', 'Marks Obtained (100)'],
                'Computer(Oral)' => ['Marks Obtained (100)'],
                'computer_' => ['Marks Obtained (100)'],
                'Divinity' => ['Marks Obtained (100)'],
                'divinity_' => ['Marks Obtained (100)'],
                'RS' => ['Marks Obtained (100)'],
                'rs_' => ['Marks Obtained (100)'],
                'ICT' => ['Marks Obtained (100)'],
                'ict_' => ['Marks Obtained (100)'],
            ];
        } elseif ($current_class <= 2) {
            $cal_marks = [
                'English' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'eng_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Punjabi' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'punjabi_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Hindi' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'hindi_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Maths' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'maths_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'EVS (Oral)' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'evs_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Computer(Oral)' => ['Marks Obtained (150)','Marks Obtained (100)'],
                'computer_' => ['Marks Obtained (150)','Marks Obtained (100)'],
                'Divinity' => ['Marks Obtained (150)','Marks Obtained (100)'],
                'divinity_' => ['Marks Obtained (150)','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 = [
                'English' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'eng_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Punjabi' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'punjabi_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Hindi' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'hindi_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Maths' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'maths_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Science' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'science_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Social Science' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'social_science_' => ['Marks Obtained (150)', 'Marks Obtained (100)'],
                'Computer' => ['Marks Obtained (150)', 'Marks Obtained(100)'],
                'computer_' => ['Marks Obtained (150)', 'Marks Obtained(100)'],
                'Divinity' => ['Marks Obtained (150)','Marks Obtained (100)'],
                'divinity_' => ['Marks Obtained (150)','Marks Obtained (100)'],
            ];
        } elseif ($current_class <= 8) {
            $cal_marks = [
                'English' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'eng_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'Punjabi' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'punjabi_' => ['Internal Assessment (20)', 'Marks Obtained (100)'],
                'Hindi' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'hindi_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'Maths' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'maths_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'Science' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'science_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'SST' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'social_science_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
                'computer_' => ['Internal Assessment (M.M.20)','Theory and Practical (80)', 'Marks Obtained (100)'],
                'Computer' => ['Marks Obtained (100)', 'Marks Obtained (100)','Theory and Practical (80)'],
                'Divinity' => ['Marks Obtained (100)'],
                'divinity_' => ['Marks Obtained (100)'],
                'co_scholastic_' => [],
                'CoScholastic' => [],
            ];
        } elseif($current_class <= 10 && $result_type == 'PT2') {

            $cal_marks = [
                'English' => [],
                'eng_' => [],
                'Punjabi' => [],
                'punjabi_' => [],
                'Hindi' => [],
                'hindi_' => [],
                'Mathematics' => [],
                'mathematics_' => [],
                'Science' => [],
                'science_' => [],
                'Social Science' => [],
                'social_science_' => [],
                'Computer' => [],
                'computer_' => [],
                'Divinity' => [],
                'divinity_' => [],
                'co_scholastic_' => [],
                'CoScholastic' => [],
            ];
        } elseif ($current_class <= 10 && $result_type == 'Final') {

        $cal_marks = [
            'English' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'eng_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Punjabi' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'punjabi_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Hindi' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'hindi_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Mathematics' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'mathematics_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'maths_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Science' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'science_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Social Science' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'social_science_' => ['Internal Assessment (M.M.20)', 'Marks Obtained (100)'],
            'Computer' => ['Marks Obtained (100)'],
            'computer_' => ['Marks Obtained (100)'],
            'AI-IT' => ['Total Marks (100)'],
            'ai_' => ['Total Marks (100)'],
            'Divinity' => [],
            'divinity_' => [],
            'co_scholastic_' => [],
            'CoScholastic' => [],
        ];
    }
    $show_periodic = 0;
    // if($current_class >= 6 && $current_class <= 8){
    //     $show_periodic = 1;
    // }
    $totalArray =[];
@endphp
@if (count($sqlExist) > 0)
    @php
        // print_r($sqlExist);
    @endphp

<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>
            @foreach ($final_subject as $key => $value22)
                @php  $sub_title_cnt = isset($cal_marks[$value22]) ? count($cal_marks[$value22]) : 0;  @endphp
                <td colspan={{ $array_count_field_name[$value22] + $sub_title_cnt + $show_periodic }}><b>{{ $value22 }}</b>
                </td>
            @endforeach
        </tr>
        <tr>
            @php
                $p = 0;
                $q = 'eng_';
            @endphp
            @foreach ($sqlSubTitle as $key => $value)
                @php
                    $field_arr = explode('pmt_', $value->table_field_name);
                    $table_field_name = $field_arr[0];
                @endphp
                @if ($p == 0)
                    <!-- First Time 'Perodic Test' Print -->
                    @php $p = $value->subject_id; @endphp
                    @if($show_periodic==1)
                    <td><b>Perodic Test</b></td>
                    @endif
                @endif
                @if ($q != $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 = $table_field_name; @endphp
                    @if($show_periodic==1)
                    <td><b>Perodic Test</b></td>
                    @endif
                    <td><b>{{ $value->sub_title. '  ('.$value->max_marks.')' }}</b></td>
                @else
                    <td><b>{{ $value->sub_title. '  ('.$value->max_marks.')' }}</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
            <td><b>Sum</b></td>
            <td><b>Avg</b></td>
        </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)
                    @if ($j <= $vals[$value])
                        @php
                           

                            $fieldName = $value . 'marks' . $j;
                            $fieldName2 = $value . 'perodic_test';
                            $s_adm_no_hid = $results['s_adm_no_hid'];
                        @endphp
                        @if ($j == 1)
                        @if($show_periodic==1)
                            @if ($value == 'eng_' && ($results['current_class'] < 9 && $results['current_class'] > 5))
                                <td>{{ isset($results['eng_perodic_test']) ? round($results['eng_perodic_test'], 2) : '' }}
                                </td>
                            @else
                                <td>{{ isset($sqlExist[$s_adm_no_hid][$fieldName2]) ? round($sqlExist[$s_adm_no_hid][$fieldName2], 2) : '' }}
                                </td>
                            @endif
                        @endif
                        @endif
                        <td>{{ isset($results[$fieldName]) ? $results[$fieldName] : '' }} <b
                                style="color: red;">{{ isset($results[$fieldName . '_old']) && $results[$fieldName . '_old'] != $results[$fieldName] ? $results[$fieldName . '_old'] : '' }}</b>
                        </td>

                        @if ($j < $vals[$value])
                            @php $j++; @endphp
                        @else
                            @php $p = 1; @endphp

                            @foreach ($cal_marks[$value] as $key33 => $value33)
                                @php
                                    $fieldName3 = $value . 'cal' . $p;
                                    $p++;
                                @endphp
                                <td><b>{{ isset($results[$fieldName3]) ? $results[$fieldName3] : '' }}</b></td>
                                @php $totalArray[$value.'cal'] = isset($results[$fieldName3]) ? $results[$fieldName3] : "0"; @endphp
                            @endforeach
                            @php $j=1; @endphp
                        @endif
                    @else
                        @php $j=1; @endphp
                    @endif
                @endforeach
                <td><b>{{ round(array_sum($totalArray)) }}</b></td>
                <td><b>{{ count($totalArray) ? round(array_sum($totalArray) / count($totalArray)) : 0 }}</b></td>
            </tr>

            @php
                $j++;
                $i++;
            @endphp
        @endforeach
    </tbody>
</table>

@endif