1#@!#!123s

: / home / bmsnrajganj / public_html / erp / application / views / admin / examresult /
Filename : index_old.php
back
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js"></script>


<div class="content-wrapper" style="min-height: 946px;">
    <section class="content-header">
        <h1>
            <i class="fa fa-map-o"></i> <?php echo $this->lang->line('examinations'); ?> <small><?php echo $this->lang->line('student_fee1'); ?></small>  
        </h1>
    </section>
    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title"><i class="fa fa-search"></i> <?php echo $this->lang->line('select_criteria'); ?></h3>
                    </div>
                    <div class="box-body">
                        <form role="form" action="<?php echo site_url('admin/examresult') ?>" method="post" >
                            <?php echo $this->customlib->getCSRF(); ?>
                            <div class="row">
                                <div class="col-sm-6 col-lg-3 col-md-3 col20">
                                    <div class="form-group">
                                        <label><?php echo $this->lang->line('exam') . " " . $this->lang->line('group'); ?></label><small class="req"> *</small>
                                        <select autofocus="" id="exam_group_id" name="exam_group_id" class="form-control select2" >
                                            <option value=""><?php echo $this->lang->line('select'); ?></option>
                                            <?php
                                            foreach ($examgrouplist as $ex_group_key => $ex_group_value) {
                                                ?>
                                                <option value="<?php echo $ex_group_value->id ?>" <?php
                                                if (set_value('exam_group_id') == $ex_group_value->id) {
                                                    echo "selected=selected";
                                                }
                                                ?>><?php echo $ex_group_value->name; ?></option>
                                                        <?php
                                                    }
                                                    ?>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('exam_group_id'); ?></span>
                                    </div>
                                </div>
                                <!--./col-md-3-->    
                                <div class="col-sm-6 col-lg-3 col-md-3 col20">
                                    <div class="form-group">
                                        <label><?php echo $this->lang->line('exam') ?></label><small class="req"> *</small>
                                        <select  id="exam_id" name="exam_id[]" class="form-control select2" multiple>
                                            <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('exam_id'); ?></span>
                                    </div>
                                </div>
                                <!--./col-md-3-->
                                <div class="col-sm-6 col-lg-3 col-md-3 col20">
                                    <div class="form-group">
                                        <label><?php echo $this->lang->line('session'); ?></label><small class="req"> *</small>
                                        <select  id="session_id" name="session_id" class="form-control" >
                                            <option value=""><?php echo $this->lang->line('select'); ?></option>
                                            <?php
                                            foreach ($sessionlist as $session) {
                                                ?>
                                                <option value="<?php echo $session['id'] ?>" <?php
                                                if (set_value('session_id') == $session['id']) {
                                                    echo "selected=selected";
                                                }
                                                ?>><?php echo $session['session'] ?></option>
                                                        <?php
                                                    }
                                                    ?>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('session_id'); ?></span>
                                    </div>
                                </div>
                                <!--./col-md-3-->
                                <div class="col-sm-6 col-lg-3 col-md-12 col20">
                                    <div class="form-group">
                                        <label><?php echo $this->lang->line('class'); ?></label><small class="req"> *</small>
                                        <select id="class_id" name="class_id" class="form-control" >
                                            <option value=""><?php echo $this->lang->line('select'); ?></option>
                                            <?php
                                            foreach ($classlist as $class) {
                                                ?>
                                                <option value="<?php echo $class['id'] ?>" <?php
                                                if (set_value('class_id') == $class['id']) {
                                                    echo "selected=selected";
                                                }
                                                ?>><?php echo $class['class'] ?></option>
                                                        <?php
                                                    }
                                                    ?>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('class_id'); ?></span>
                                    </div>
                                </div>
                                <div class="col-sm-6 col-lg-3 col-md-12 col20">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1"><?php echo $this->lang->line('section'); ?></label><small class="req"> *</small>
                                        <select  id="section_id" name="section_id" class="form-control" >
                                            <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('section_id'); ?></span>
                                    </div>
                                </div>
                                <div class="col-sm-12">
                                    <div class="form-group">
                                        <button type="submit" name="search" value="search_filter" class="btn btn-primary pull-right btn-sm checkbox-toggle"><i class="fa fa-search"></i> <?php echo $this->lang->line('search'); ?></button>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                    <?php
                    if (isset($studentList)) {
                        //print_r($studentList);
                        //$studentList[0][0]->subject_results;
                        //echo count($studentList).'=>'.count($exam_id)."<br><br>";
                        if(count($exam_id)==4){//count($exam_id)!=1 && count($exam_id)!=2
                        for($m=0;$m<count($studentList);$m++){///(count($studentList)) ///count($exam_id)//4
                                                    for($i=1;$i<count($studentList);$i++){//4
                                                        for($j=0;$j<count($studentList[0][$m]->subject_results);$j++){
                                                            //if()
                                                            //echo $studentList[0][$m]->subject_results[$j]->min_marks.'==>'.$studentList[$i][$m]->subject_results[$j]->min_marks."<br><br>";
                                                            if($studentList[0][$m]->subject_results[$j]->name==$studentList[$i][$m]->subject_results[$j]->name){
                                                                 $studentList[0][$m]->subject_results[$j]->id=$studentList[0][$m]->subject_results[$j]->id.','.$studentList[$i][$m]->subject_results[$j]->id;
                                                                $studentList[0][$m]->subject_results[$j]->max_marks=$studentList[0][$m]->subject_results[$j]->max_marks+$studentList[$i][$m]->subject_results[$j]->max_marks;
                                                                
                                                                 $studentList[0][$m]->subject_results[$j]->min_marks=$studentList[0][$m]->subject_results[$j]->min_marks+$studentList[$i][$m]->subject_results[$j]->min_marks;
                                                                  $studentList[0][$m]->subject_results[$j]->get_marks=$studentList[0][$m]->subject_results[$j]->get_marks+$studentList[$i][$m]->subject_results[$j]->get_marks;
                                                                  // $studentList[0][0]->subject_results[$j]->attendence=$studentList[0][0]->subject_results[$j]->attendence.','.$studentList[$i][0]->subject_results[$j]->attendence;
                                                                    $studentList[0][$m]->subject_results[$j]->credit_hours=$studentList[0][$m]->subject_results[$j]->credit_hours+$studentList[$i][$m]->subject_results[$j]->credit_hours;
                                                                    // $studentList[0][0]->subject_results[$j]->max_marks=$studentList[0][0]->subject_results[$j]->max_marks+$studentList[$i][0]->subject_results[$j]->max_marks;
                                                           
                                                           
                                                           
                                                           
                                                           
                                                           
                                                            }
                                                            //  print_r($studentList[0][0]->subject_results[$j]->name);
                                                            // print_r($studentList[$i][0]->subject_results[$j]->name);
                                                            // print_r($studentList[$m][0]->subject_results[$j]);
                                                            // //print_r($studentList[$i][0]->subject_results[$j]);
                                                            
                                                            // echo "<br><br>";
                                                        }
                                                    }
                                                    // print_r($studentList[$m][0]);
                                                            
                                                            
                                                    //         echo "<br><br>";
                    }
                        }
                        if(count($exam_id)==2){
                            for($m=0;$m<1;$m++){///count($exam_id)//0
                                                    for($i=1;$i<count($exam_id);$i++){//1
                                                    for($l=0;$l<count($studentList[$m]);$l++){//4
                                                        for($j=0;$j<count($studentList[$m][$l]->subject_results);$j++){
                                                            //if()
                                                            //echo $studentList[$m][$j]->admission_no.'=>'.$studentList[$m][$l]->subject_results[$j]->max_marks.'=='.$studentList[$i][$l]->subject_results[$j]->max_marks."<br><br>";
                                                            if($studentList[$m][$l]->subject_results[$j]->name==$studentList[$i][$l]->subject_results[$j]->name){
                                                                 $studentList[$m][$l]->subject_results[$j]->id=$studentList[$m][$l]->subject_results[$j]->id.','.$studentList[$i][$l]->subject_results[$j]->id;
                                                                $studentList[$m][$l]->subject_results[$j]->max_marks=$studentList[$m][$l]->subject_results[$j]->max_marks+$studentList[$i][$l]->subject_results[$j]->max_marks;
                                                                
                                                                 $studentList[$m][$l]->subject_results[$j]->min_marks=$studentList[$m][$l]->subject_results[$j]->min_marks+$studentList[$i][$l]->subject_results[$j]->min_marks;
                                                                  $studentList[$m][$l]->subject_results[$j]->get_marks=$studentList[$m][$l]->subject_results[$j]->get_marks+$studentList[$i][$l]->subject_results[$j]->get_marks;
                                                                  // $studentList[0][0]->subject_results[$j]->attendence=$studentList[0][0]->subject_results[$j]->attendence.','.$studentList[$i][0]->subject_results[$j]->attendence;
                                                                    $studentList[$m][$l]->subject_results[$j]->credit_hours=$studentList[$m][$l]->subject_results[$j]->credit_hours+$studentList[$i][$l]->subject_results[$j]->credit_hours;
                                                                    // $studentList[0][0]->subject_results[$j]->max_marks=$studentList[0][0]->subject_results[$j]->max_marks+$studentList[$i][0]->subject_results[$j]->max_marks;
                                                           
                                                           
                                                           
                                                           
                                                           
                                                           
                                                            }
                                                            //  print_r($studentList[0][0]->subject_results[$j]->name);
                                                            // print_r($studentList[$i][0]->subject_results[$j]->name);
                                                            //print_r($studentList[0][0]->subject_results[$j]);
                                                            //print_r($studentList[$i][0]->subject_results[$j]);
                                                            
                                                            //echo "<br><br>";
                                                        }
                                                    }
                                                    }
                    }
                        }
                        // print_r($studentList[0][0]);//[0][0]->subject_results
                        // echo "<br><br>";
                        // print_r($studentList[0][1]);
                        // echo "<br><br>";
                        // print_r($studentList[0][2]);
                        // echo "<br><br>";
                        // print_r($studentList[0][3]);
                        // //print_r($studentList[0][1]->subject_results);
                         //echo count($exam_id)."<br><br>";
                        
                                                    // Create an associative array to store unique students based on student_id
$uniqueStudents = array();
if(count($exam_id)==1){
    for($m=0;$m<(count($studentList));$m++){///count($exam_id)

    
       // echo count($exam_id).'=>'.$m."<br>";
        for($r=0;$r<(count($studentList[$m]));$r++){
        $uniqueStudents[] = $studentList[$m][$r];
        }
    
}
}
if(count($exam_id)==2){
    
    for($m=0;$m<(count($studentList)-1);$m++){///count($exam_id)
    for($c=0;$c<count($studentList[$m]);$c++){
                // echo $m.'=>'.$c."<br><br>";
        $uniqueStudents[] = $studentList[$m][$c];
             }
}
    
}
if(count($exam_id)==4){
    for($m=0;$m<(count($studentList));$m++){///count($exam_id)
    // echo count($exam_id).'=>'.$m."<br>";
             $uniqueStudents[] = $studentList[0][$m];
}
}
// Iterate through the original array and store each student based on student_id
//  for($m=0;$m<(count($studentList))+((count($exam_id)==2)?-1:0);$m++){///count($exam_id)

//     if(count($exam_id)==1){
//       // echo count($exam_id).'=>'.$m."<br>";
//         for($r=0;$r<(count($studentList[$m]));$r++){
//         $uniqueStudents[] = $studentList[$m][$r];
//         }
//     }else{
//          //echo count($exam_id).'=>'.$m."<br>";
//          if(count($exam_id)==2){
//              for($c=0;$c<count($studentList[$m]);$c++){
//                 // echo $m.'=>'.$c."<br><br>";
//         $uniqueStudents[] = $studentList[$m][$c];
//              }
//          }else{
//             // echo count($exam_id).'=>'.$m."<br>";
//              $uniqueStudents[] = $studentList[$m][$m];
//          }
//     }
// }
// Convert the associative array back to indexed array
$uniqueStudentList = array_values($uniqueStudents);
//print_r($studentList[0][0]);
// Now $uniqueStudentList contains only unique students based on student_id

unset($studentList);
$studentList=$uniqueStudentList;
unset($uniqueStudentList);
// print_r($studentList);

//subject

// Assuming $subjectList is your array
$resultArray = [];

foreach ($subjectList as $subjectArray) {
    foreach ($subjectArray as $subject) {
        $subjectName = $subject->subject_name;

        if (!isset($resultArray[$subjectName])) {
            // If subject name doesn't exist in the result array, add it
            $resultArray[$subjectName] = clone $subject;
        } else {
            // If subject name already exists, aggregate max marks
            $resultArray[$subjectName]->max_marks += $subject->max_marks;
             $resultArray[$subjectName]->min_marks += $subject->min_marks;
              $resultArray[$subjectName]->get_marks += $subject->get_marks;
               $resultArray[$subjectName]->credit_hours += $subject->credit_hours;
                $resultArray[$subjectName]->id = $resultArray[$subjectName]->id.",".$subject->id;
                // $resultArray[$subjectName]->max_marks += $subject->max_marks;
                //  $resultArray[$subjectName]->max_marks += $subject->max_marks;
        }
    }
}

// Convert the associative array back to indexed array
$resultArray = array_values($resultArray);

// Now $resultArray should contain aggregated max marks for each subject

//print_r($resultArray);
// echo "<br><br>";
           
unset($subjectList);
$subjectList=$resultArray;
unset($resultArray);
//print_r($subjectList);
                        ?>
                        <form method="post" action="<?php echo base_url('admin/examresult/printmarksheet') ?>" id="printMarksheet">
                            <input type="hidden" name="marksheet_template" value="<?php echo $marksheet_template; ?>">
                            <div class="" >
                                <div class="box-header ptbnull"></div>
                                <div class="box-header ptbnull">
                                    <h3 class="box-title titlefix"><i class="fa fa-users"></i> <?php echo $this->lang->line('exam') . " " . $this->lang->line('result'); ?></h3>
                                </div>
                                <div class="box-body">
                                    <input type="hidden" name="post_exam_id" value="<?php  $exam_id_str = implode(',', $exam_id); echo $exam_id_str;//$exam_id; ?>">
                                    <input type="hidden" name="post_exam_group_id" value="<?php echo $exam_group_id; ?>">
                                    <div class="tab-pane active table-responsive no-padding" id="tab_1">
                                        <div class="download_label"> <?php echo $this->lang->line('exam') . " " . $this->lang->line('result'); ?></div>
                                       
                                       <table class="table table-striped table-bordered table-hover example" cellspacing="0" width="100%">
    <thead>
        <tr>
            <th><?php echo $this->lang->line('admission_no'); ?></th>
            <th><?php echo $this->lang->line('roll_no'); ?></th>
            <th><?php echo $this->lang->line('student_name'); ?></th>
            <?php
            
            //print_r($subjectList);
            if (!empty($subjectList)) {
                foreach ($subjectList as $subject_key => $subject_value) {
                    // echo "<br><br>";
                    // print_r($subject_value);
                    ?>
                    <th>
                        <?php
                        echo $subject_value->subject_name;//name;
                        echo "<br/>";
                        echo "(" . $subject_value->min_marks . "/" . $subject_value->max_marks . " - " . $subject_value->subject_code . ")"; //code
                        if ($exam_details->exam_group_type == "gpa") {
                            ?>
                            <br/>
                            (<?php echo $this->lang->line('grade') . " " . $this->lang->line('point'); ?>) * (<?php echo $this->lang->line('credit') . " " . $this->lang->line('hours') ?>)
                            <?php
                        }
                        ?>
                    </th>
                    <?php
                }

                if ($exam_details->exam_group_type == "school_grade_system" || $exam_details->exam_group_type == "basic_system" || $exam_details->exam_group_type == "coll_grade_system") {
                    ?>
                    <th><?php echo $this->lang->line('grand') . " " . $this->lang->line('total'); ?></th>
                    <th><?php echo $this->lang->line('percent') ?> (%)</th>
                    <?php
                    if ($exam_details->exam_group_type != "gpa") {
                        ?>
                        <th><?php echo $this->lang->line('result') ?></th>
                        <?php
                    }
                    ?>
                    <?php
                } elseif ($exam_details->exam_group_type == "gpa") {
                    ?>
                    <th><?php echo $this->lang->line('result') ?></th>
                    <?php
                }
            }
            ?>
        </tr>
    </thead>
    <tbody>
        <?php
                  echo "1st chcek<pre>";  
            print_r($studentList);
            echo "</pre>";
        if (empty($studentList)) {
            ?>
            <?php
        } else {
            echo "2nd chcek<pre>";
            
            print_r(isset($studentList));
            echo "</pre>";
            foreach ($studentList as $student_key => $student_value) {
                // echo "<br><br>";
                // print_r($student_value);
                $result_status = 1;
                $no_subject_result = 0;
                ?>
                <tr>
                    <td><?php echo $student_value->admission_no; ?></td>
                    <td><?php echo ($student_value->exam_roll_no != 0) ? $student_value->exam_roll_no : "-"; ?> </td>
                    <td>
                        <!--text-decoration: none;-->
                        <a style="color: #337ab7;
    text-decoration: none;" href="<?php echo base_url(); ?>student/view/<?php echo $student_value->student_id; ?>"><?php echo $this->customlib->getFullName($student_value->firstname, $student_value->middlename, $student_value->lastname, $sch_setting->middlename, $sch_setting->lastname); ?>
                    </a>
                    </td>
                    <?php
                    if (!empty($subjectList)) {
                        $total_marks = 0;
                        $get_marks = 0;
                        $get_percentage = 0;
                        $total_credit_hour = 0;
                        $total_quality_point = 0;
                       
                        foreach ($subjectList as $subject_key => $subject_value) {
                            $subject_status = 1;
                            $total_marks = $total_marks + $subject_value->max_marks;
                            ?>
                            <td>
                                <?php
                                
                                $result = getSubjectMarks($student_value->subject_results, $subject_value->id);//$student_value->subject_results[$subject_key]
                                if ($result) {
                                    $no_subject_result = 1;
                                    if ($exam_details->exam_group_type == "gpa") {
                                        $get_marks = $get_marks + $result->get_marks;
                                        $subject_credit_hour = $subject_value->credit_hours;
                                        $total_credit_hour = $total_credit_hour + $subject_value->credit_hours;
                                        $percentage_grade = ($result->get_marks * 100) / $result->max_marks;
                                        $point = findGradePoints($exam_grades, $percentage_grade);
                                        $total_quality_point = $total_quality_point + ($point * $subject_credit_hour);
                                        echo $point . " X " . $subject_credit_hour . " = " . number_format($point * $subject_credit_hour, 2, '.', '');
                                        if ($result->attendence == "absent") {
                                            ?>  
                                            <p class="text">
                                                <?php echo $this->lang->line($result->attendence); ?>
                                            </p>
                                            <?php
                                        }
                                        ?>
                                        <p class="text"><?php echo $result->note; ?></p>
                                        <?php
                                    } else {
                                        $get_marks = $get_marks + $result->get_marks;
                                        if ($result->get_marks < $subject_value->min_marks) {
                                            $result_status = 0;
                                            $subject_status = 0;
                                        }
                                        echo $result->get_marks;
                                        if ($exam_details->exam_group_type == "school_grade_system" || $exam_details->exam_group_type == "coll_grade_system") {
                                            $percentage_grade = ($result->get_marks * 100) / $subject_value->max_marks;
                                            echo " (" . get_ExamGrade($exam_grades, $percentage_grade) . ")";
                                        }
                                        if ($exam_details->exam_group_type == "basic_system") {
                                            echo ($subject_status == 0) ? " (F)" : "";
                                        }
                                        if ($result->attendence == "absent") {
                                            ?>  
                                            <p class="text">
                                                <?php echo $this->lang->line($result->attendence); ?>
                                            </p>
                                            <?php
                                        }
                                        ?>
                                        <p class="text"><?php echo $result->note; ?></p>
                                        <?php
                                    }
                                } else {
                                //     print_r($student_value->subject_results);
                                // echo $subject_value->id."<br><br>";
                                // echo $subject_key."<br>";
                                    // Handle the case when result is not available for the subject
                                }
                                ?>
                            </td>
                            <?php
                           
                        }
                        if ($exam_details->exam_group_type == "school_grade_system" || $exam_details->exam_group_type == "basic_system" || $exam_details->exam_group_type == "coll_grade_system") {
                            ?>
                            <td><?php echo number_format($get_marks, 2, '.', '') . "/" . number_format($total_marks, 2, '.', ''); ?></td>
                            <td>
                                <?php
                                $total_percentage = ($get_marks * 100) / $total_marks;
                                echo number_format($total_percentage, 2, '.', '');
                                ?>
                            </td>
                            <?php
                        }
                        ?>
                        <?php
                    }
                    ?>
                    <?php
                    if ($exam_details->exam_group_type == "gpa") {
                        ?>
                        <td>
                            <?php
                            if ($total_credit_hour > 0) {
                                $percentage_grade = ($get_marks * 100) / $total_marks;
                                $exam_qulity_point = number_format($total_quality_point / $total_credit_hour, 2, '.', '');
                                echo $total_quality_point . "/" . $total_credit_hour . "=" . $exam_qulity_point . " [" . get_ExamGrade($exam_grades, $percentage_grade) . "]";
                            } else {
                                echo "--";
                            }
                            ?>
                        </td>
                        <?php
                    } elseif ($exam_details->exam_group_type == "school_grade_system" || $exam_details->exam_group_type == "basic_system" || $exam_details->exam_group_type == "coll_grade_system") {
                        echo "<td>";
                        if ($no_subject_result) {
                            if ($result_status) {
                                ?>
                                <label class="label label-success" ><?php echo $this->lang->line('pass'); ?></label>
                                <?php
                            } else {
                                ?>
                                <label class="label label-danger"><?php echo $this->lang->line('fail'); ?></label>
                                <?php
                            }
                        }
                        echo "</td>";
                    }
                    ?>
                </tr>
                <?php
            }
        }
        ?>
    </tbody>
</table>

                                       
                                        </div>
                                </div>
                            </div>
                        </form>
                    </div>
                    <?php
                }
                ?>
            </div>
        </div>
    </section>
</div>
<?php

function getSubjectMarks($subject_results, $subject_id) {
    if (!empty($subject_results)) {
        //print_r($subject_results);
        foreach ($subject_results as $subject_result_key => $subject_result_value) {
            $numberArray = explode(",", $subject_result_value->id);
            $numberArray_subject_id = explode(",", $subject_id);
            // print_r($numberArray);
            // echo "<br><br>";
            // print_r($numberArray_subject_id);
            // Check if there are any common values
$commonValues = array_intersect($numberArray, $numberArray_subject_id);
if (!empty($commonValues)) {
            //if (in_array($subject_id, $numberArray)) {//subject_id
            
            //if ($subject_id == $subject_result_value->id) {//subject_id
                return $subject_result_value;
            }
        }
    }
    return false;
}

function get_ExamGrade($exam_grades, $percentage) {
    if (!empty($exam_grades)) {
        foreach ($exam_grades as $exam_grade_key => $exam_grade_value) {

            if ($exam_grade_value->mark_from >= $percentage && $exam_grade_value->mark_upto <= $percentage) {
                return $exam_grade_value->name;
            }
        }
    }

    return "-";
}

function findGradePoints($exam_grades, $percentage) {

    if (!empty($exam_grades)) {
        foreach ($exam_grades as $exam_grade_key => $exam_grade_value) {

            if ($exam_grade_value->mark_from >= $percentage && $exam_grade_value->mark_upto <= $percentage) {
                return $exam_grade_value->point;
            }
        }
    }

    return 0;
}
?>
<script type="text/javascript">
     $(document).ready(function () {
        $('.select2').select2();

    });
    $(document).ready(function () {
        $.extend($.fn.dataTable.defaults, {
            searching: true,
            ordering: true,
            paging: false,
            retrieve: true,
            destroy: true,
            info: false
        });
    });

    var date_format = '<?php echo $result = strtr($this->customlib->getSchoolDateFormat(), ['d' => 'dd', 'm' => 'mm', 'Y' => 'yyyy']) ?>';
    var class_id = '<?php echo set_value('class_id') ?>';
    var section_id = '<?php echo set_value('section_id') ?>';
    var session_id = '<?php echo set_value('session_id') ?>';
    var exam_group_id = '<?php echo set_value('exam_group_id') ?>';
    var exam_id = '<?php if(isset($exam_id_str)){
        $exam_id_str = implode(',', $exam_id); echo set_value('$exam_id_str');} ?>';
    getSectionByClass(class_id, section_id);

    // getExamgroupByClassSectionSession(class_id, section_id, session_id);
    getExamByExamgroup(exam_group_id, exam_id);
    $(document).on('change', '#exam_group_id', function (e) {
        $('#exam_id').html("");
        var exam_group_id = $(this).val();
        getExamByExamgroup(exam_group_id, 0);
    });

    $(document).on('change', '#class_id', function (e) {
        $('#section_id').html("");
        var class_id = $(this).val();
        getSectionByClass(class_id, 0);
    });

    function getSectionByClass(class_id, section_id) {

        if (class_id !== "") {
            $('#section_id').html("");
            var base_url = '<?php echo base_url() ?>';
            var div_data = '<option value=""><?php echo $this->lang->line('select'); ?></option>';


            $.ajax({
                type: "GET",
                url: base_url + "sections/getByClass",
                data: {'class_id': class_id},
                dataType: "json",
                beforeSend: function () {
                    $('#section_id').addClass('dropdownloading');
                },
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
                        var sel = "";
                        if (section_id === obj.section_id) {
                            sel = "selected";
                        }
                        div_data += "<option value=" + obj.section_id + " " + sel + ">" + obj.section + "</option>";
                    });
                    $('#section_id').append(div_data);
                },
                complete: function () {
                    $('#section_id').removeClass('dropdownloading');
                }
            });
        }
    }


    function getExamByExamgroup(exam_group_id, exam_id) {

        if (exam_group_id !== "") {
            $('#exam_id').html("");
            var base_url = '<?php echo base_url() ?>';
            var div_data = '<option value=""><?php echo $this->lang->line('select'); ?></option>';


            $.ajax({
                type: "POST",
                url: base_url + "admin/examgroup/getExamByExamgroup",
                data: {'exam_group_id': exam_group_id},
                dataType: "json",
                beforeSend: function () {
                    $('#exam_id').addClass('dropdownloading');
                    $('#exam_id').select2({
            multiple: true, // Enable multiple selection
            placeholder: "Select exams", // Text to be displayed in the placeholder
            closeOnSelect: false, // Do not close dropdown on selection
            allowClear: true, // Allow clearing the selection
            minimumSelectionLength: 1,  // Set minimumSelectionLength to 1 for at least one selection
            maximumSelectionLength: 4
            // Additional configurations if needed
        });
                },
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
                        var sel = "";
                        if (exam_id === obj.id) {
                            sel = "selected";
                        }
                        div_data += "<option value=" + obj.id + " " + sel + ">" + obj.exam + "</option>";
                    });

                    $('#exam_id').append(div_data);
                    $('#exam_id').trigger('change');
                },
                complete: function () {
                    $('#exam_id').removeClass('dropdownloading');
                }
            });
        }
    }
</script>
<script>
    // $(document).ready(function() {
    //     $('#exam_id').select2({
    //         multiple: true, // Enable multiple selection
    //         placeholder: "Select exams", // Text to be displayed in the placeholder
    //         closeOnSelect: false, // Do not close dropdown on selection
    //         allowClear: true, // Allow clearing the selection
    //         maximumSelectionLength: 4
    //         // Additional configurations if needed
    //     });
    // });
</script>