1#@!#!123s

: / home / schoolcampuserp / srinfinityschool.in / application / controllers / admin /
Filename : Examresult.php
back
<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Examresult extends Admin_Controller {

    public $exam_type = array();

    public function __construct() {
        parent::__construct();
       
        $this->exam_type = $this->config->item('exam_type');
        $this->attendence_exam = $this->config->item('attendence_exam');
        $this->sch_setting_detail = $this->setting_model->getSetting();
        $this->config_attendance = $this->config->item('attendence');
        $this->current_session = $this->setting_model->getCurrentSession();
        $this->load->model('Stuattendence_model');
        // Load the profiler library
        $this->load->library('profiler');
        // $this->config->load("mailsms");
        // $this->load->library('mailsmsconf');
        //$this->load->controller('Stuattendence');
    }

    public function printCard() {
        $this->form_validation->set_error_delimiters('', '');
        $this->form_validation->set_rules('admitcard_template', $this->lang->line('template'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('post_exam_id', $this->lang->line('exam'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('post_exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('exam_group_class_batch_exam_student_id[]', $this->lang->line('students'), 'required|trim|xss_clean');
        $data = array();

        if ($this->form_validation->run() == false) {
            $data = array(
                'admitcard_template' => form_error('admitcard_template'),
                'post_exam_id' => form_error('post_exam_id'),
                'post_exam_group_id' => form_error('post_exam_group_id'),
                'exam_group_class_batch_exam_student_id' => form_error('exam_group_class_batch_exam_student_id'),
            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {
            $post_exam_id = $this->input->post('post_exam_id');
            $post_exam_group_id = $this->input->post('post_exam_group_id');
            $students_array = $this->input->post('exam_group_class_batch_exam_student_id');
            $exam = $this->examgroup_model->getExamByID($post_exam_id);
            $data['exam'] = $exam;
            $exam_grades = $this->grade_model->getByExamType($exam->exam_group_type);
            $data['exam_grades'] = $exam_grades;
            $data['admitcard'] = $this->admitcard_model->get($this->input->post('admitcard_template'));
            $data['exam_subjects'] = $this->batchsubject_model->getExamSubjects($post_exam_id);
            $data['student_details'] = $this->examstudent_model->getStudentsAdmitCardByExamAndStudentID($students_array, $post_exam_id);
            $data['sch_setting']= $this->sch_setting_detail;
            $student_admit_cards = $this->load->view('admin/admitcard/_printadmitcard', $data, true);
            $array = array('status' => '1', 'error' => '', 'page' => $student_admit_cards);
            echo json_encode($array);
        }
    }

    public function admitcard() {
        if (!$this->rbac->hasPrivilege('print_admit_card', 'can_view')) {
            access_denied();
        }

        $this->session->set_userdata('top_menu', 'Examinations');
        $this->session->set_userdata('sub_menu', 'Examinations/examresult/admitcard');
        $examgroup_result = $this->examgroup_model->get();
        $data['examgrouplist'] = $examgroup_result;

        $admitcard_result = $this->admitcard_model->get();
        $data['admitcardlist'] = $admitcard_result;
        $class = $this->class_model->get();
        $data['title'] = 'Add Batch';
        $data['title_list'] = 'Recent Batch';
        $data['examType'] = $this->exam_type;
        $data['classlist'] = $class;
        // $session = $this->session_model->get();
        // $data['sessionlist'] = $session;
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|xss_clean');//|required
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|xss_clean');//|required
        //$this->form_validation->set_rules('session_id', $this->lang->line('student'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_id', $this->lang->line('exam'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('admitcard', $this->lang->line('admit') . " " . $this->lang->line('card') . " " . $this->lang->line('template'), 'trim|required|xss_clean');

        if ($this->form_validation->run() == false) {
            
        } else {
            $exam_group_id = $this->input->post('exam_group_id');
            $exam_id = $this->input->post('exam_id');
            $session_id = $this->current_session;
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');
            $admitcard_template = $this->input->post('admitcard');
            $data['admitcard_template'] = $admitcard_template;

            $data['studentList'] = $this->examgroupstudent_model->searchExamStudents($exam_group_id, $exam_id, $class_id, $section_id, $session_id);

            $data['examList'] = $this->examgroup_model->getExamByExamGroup($exam_group_id, true);
 
            $data['exam_id'] = $exam_id;
            $data['exam_group_id'] = $exam_group_id;
        }
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        $this->load->view('admin/examresult/admitcard', $data);
        $this->load->view('layout/footer', $data);
    }

    function monthAttendance($st_month, $no_of_months, $student_id) {

        $record = array();

        $r = array();
        $month = date('m', strtotime($st_month));
        $year = date('Y', strtotime($st_month));

        foreach ($this->config_attendance as $att_key => $att_value) {

            $s = $this->stuattendence_model->count_attendance_obj($month, $year, $student_id, $att_value);


            $attendance_key = $att_key;


            $r[$attendance_key] = $s;
        }

        $record[$student_id] = $r;

        return $record;
    }

    public function marksheet() {
        if (!$this->rbac->hasPrivilege('print_marksheet', 'can_view')) {
            access_denied();
        }
        $this->session->set_userdata('top_menu', 'Examinations');
        $this->session->set_userdata('sub_menu', 'Examinations/examresult/marksheet');
        $examgroup_result = $this->examgroup_model->get();
        $data['examgrouplist'] = $examgroup_result;

        $marksheet_result = $this->marksheet_model->get();
        $data['marksheetlist'] = $marksheet_result;

        $class = $this->class_model->get();
        $data['title'] = 'Add Batch';
        $data['title_list'] = 'Recent Batch';
        $data['examType'] = $this->exam_type;
        $data['classlist'] = $class;
        $session = $this->session_model->get();
        $data['sessionlist'] = $session;
        $this->form_validation->set_rules('marksheet', $this->lang->line('marksheet'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');
       // $this->form_validation->set_rules('session_id', $this->lang->line('student'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_id', $this->lang->line('exam'), 'trim|required|xss_clean');
    
        if ($this->form_validation->run() == false) {
           
            
        } else {
            
            $exam_group_id = $this->input->post('exam_group_id');
            $exam_id = $this->input->post('exam_id');
            $session_id = $this->current_session;
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');
            
            $marksheet_template = $this->input->post('marksheet');
            $data['marksheet_template'] = $marksheet_template;
            
            $csa_post_exam_id_array=$this->examgroup_model->getExamByExamGroup($exam_group_id, true,1);
//  print_r($csa_post_exam_id_array);
//  exit();
if(!empty($csa_post_exam_id_array)){
$csa_exam_id=0;
 if(count($csa_post_exam_id_array)==2){
     $csa_exam_id=$csa_post_exam_id_array[1]->id;
      $arr=array();
                $arr[0]=$csa_post_exam_id_array[0]->id;
                $arr[1]=$csa_post_exam_id_array[1]->id;
                $data['csa_studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,1);
$data['csa_arr_exam_id']=implode(',', $arr);
 }elseif(count($csa_post_exam_id_array)==3){
     $csa_exam_id=$csa_post_exam_id_array[1]->id;
      $arr=array();
                $arr[0]=$csa_post_exam_id_array[0]->id;
                $arr[1]=$csa_post_exam_id_array[1]->id;
                $arr[2]=$csa_post_exam_id_array[2]->id;
                $data['csa_studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,1);
$data['csa_arr_exam_id']=implode(',', $arr);
 }else{
     $csa_exam_id=$csa_post_exam_id_array[0]->id;
     $data['csa_studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $csa_exam_id, $class_id, $section_id, $session_id,0);
$data['csa_arr_exam_id']=$csa_exam_id; //csa_exam_id
 }
 $data['csa_studentList'] = $this->examgroupstudent_model->searchExamStudents($exam_group_id, $csa_exam_id, $class_id, $section_id, $session_id);
$data['csa_examList'] = $this->examgroup_model->getExamByExamGroup($exam_group_id, true,1);
$data['get_all_csa_exam_group']=$csa_post_exam_id_array;
$data['csa_exam_id'] = $csa_exam_id;
}
  //print_r($data['csa_studentList_final']);                      
//  echo $csa_exam_id; 176
  // exit();
// $csa_post_exam_id = [];
// $students_array_csa=array();
// foreach ($csa_post_exam_id_array as $item) {
//     $csa_post_exam_id[] = $item->id;
//      $studentList_final_csa = $this->examgroupstudent_model->searchExamStudents_final($post_exam_group_id,$item->id,$this->input->post('class_id'),$this->input->post('section_id'),$this->current_session,0);
// //print_r($studentList_final_csa)."<br>";
// //foreach ($studentList_final_csa as $item_new) {
// //echo $studentList_final_csa[0]->exam_group_class_batch_exam_student_id."<br>";
// $students_array_csa[]=$studentList_final_csa[0]->exam_group_class_batch_exam_student_id;
// //}   
// }


            $data['studentList'] = $this->examgroupstudent_model->searchExamStudents($exam_group_id, $exam_id, $class_id, $section_id, $session_id);
            //$data['studentList2'] = $this->examgroupstudent_model->searchExamStudents2($exam_group_id, $exam_id, $class_id, $section_id, $session_id);


            $data['examList'] = $this->examgroup_model->getExamByExamGroup($exam_group_id, true);
            
            $data['exam_group_connection'] = $this->examgroup_model->getExamByExamGroupConnection($exam_group_id);
            // print_r($data['exam_group_connection']);
            // exit();
$exam_group_connection=$data['exam_group_connection'];
            //$data['getExamGroupConnection'] = $this->examgroup_model->getExamGroupConnection($exam_group_id);
            

            $data['exam_id'] = $exam_id;
            $data['exam_group_id'] = $exam_group_id;
            $examLists=$data['examList'];
            $data['examination_module'] = $this->sch_setting_detail->examination_module;
            
            if($this->sch_setting_detail->examination_module == 2){
                if($exam_group_connection[0]->exam_group_exam_connection_id==0 && $exam_group_connection[1]->exam_group_exam_connection_id==0 ){
                    $i=0;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $exam_id, $class_id, $section_id, $session_id,$i);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 ){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $i=2;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=2;   
                    $data['arr_exam_id']=implode(',', $arr);

                }
                
            }
            //yuvi starts
            elseif($this->sch_setting_detail->examination_module == 3){
                if($exam_group_connection[0]->exam_group_exam_connection_id==0 && $exam_group_connection[1]->exam_group_exam_connection_id==0 && $exam_group_connection[2]->exam_group_exam_connection_id==0 ){
                    $i=0;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $exam_id, $class_id, $section_id, $session_id,$i);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 ){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $i=3;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=3;   
                    $data['arr_exam_id']=implode(',', $arr);

                }
                
            }
            
            // yuvi ends
            elseif($this->sch_setting_detail->examination_module == 4){
                if($exam_group_connection[0]->exam_group_exam_connection_id ==0 && $exam_group_connection[1]->exam_group_exam_connection_id==0 && $exam_group_connection[2]->exam_group_exam_connection_id==0 && $exam_group_connection[3]->exam_group_exam_connection_id==0){
                    $i=0;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $exam_id, $class_id, $section_id, $session_id,$i);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id == 0 && $exam_group_connection[3]->exam_group_exam_connection_id ==0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $i=2;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=2;   
                    $data['arr_exam_id']=implode(',', $arr);

                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id != 0 && $exam_group_connection[3]->exam_group_exam_connection_id !=0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $i=4;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=4;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                
            }
            elseif($this->sch_setting_detail->examination_module == 6){
                
                if($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id==0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $i=3;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=3;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id!=0 && $exam_group_connection[4]->exam_group_exam_connection_id!=0 && $exam_group_connection[5]->exam_group_exam_connection_id!=0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $arr[4]=$examLists[4]->id;
                    $arr[5]=$examLists[5]->id;
                    $i=6;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=6;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                
            }
            elseif($this->sch_setting_detail->examination_module == '6a'){
                if($exam_group_connection[0]->exam_group_exam_connection_id==0 && $exam_group_connection[1]->exam_group_exam_connection_id==0 && $exam_group_connection[2]->exam_group_exam_connection_id==0 && $exam_group_connection[3]->exam_group_exam_connection_id==0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0){
                    $i=0;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $exam_id, $class_id, $section_id, $session_id,$i);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id==0 && $exam_group_connection[3]->exam_group_exam_connection_id==0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $i=2;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=2;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id!=0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $i=4;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=4;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id!=0 && $exam_group_connection[4]->exam_group_exam_connection_id!=0 && $exam_group_connection[5]->exam_group_exam_connection_id!=0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $arr[4]=$examLists[4]->id;
                    $arr[5]=$examLists[5]->id;
                    $i=6;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=6;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
            }
            elseif($this->sch_setting_detail->examination_module == 8){
                if($exam_group_connection[0]->exam_group_exam_connection_id==0 && $exam_group_connection[1]->exam_group_exam_connection_id==0 && $exam_group_connection[2]->exam_group_exam_connection_id==0 && $exam_group_connection[3]->exam_group_exam_connection_id==0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0 && $exam_group_connection[6]->exam_group_exam_connection_id==0 && $exam_group_connection[7]->exam_group_exam_connection_id==0){
                    $i=0;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $exam_id, $class_id, $section_id, $session_id,$i);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id!=0 && $exam_group_connection[4]->exam_group_exam_connection_id==0 && $exam_group_connection[5]->exam_group_exam_connection_id==0 && $exam_group_connection[6]->exam_group_exam_connection_id==0 && $exam_group_connection[7]->exam_group_exam_connection_id==0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $i=4;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=4;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
                elseif($exam_group_connection[0]->exam_group_exam_connection_id!=0 && $exam_group_connection[1]->exam_group_exam_connection_id!=0 && $exam_group_connection[2]->exam_group_exam_connection_id!=0 && $exam_group_connection[3]->exam_group_exam_connection_id!=0 && $exam_group_connection[4]->exam_group_exam_connection_id!=0 && $exam_group_connection[5]->exam_group_exam_connection_id!=0 && $exam_group_connection[6]->exam_group_exam_connection_id!=0 && $exam_group_connection[7]->exam_group_exam_connection_id!=0){
                    $arr=array();
                    $arr[0]=$examLists[0]->id;
                    $arr[1]=$examLists[1]->id;
                    $arr[2]=$examLists[2]->id;
                    $arr[3]=$examLists[3]->id;
                    $arr[4]=$examLists[4]->id;
                    $arr[5]=$examLists[5]->id;
                    $arr[6]=$examLists[6]->id;
                    $arr[7]=$examLists[7]->id;
                    $i=8;
                    $data['studentList_final'] = $this->examgroupstudent_model->searchExamStudents_final($exam_group_id, $arr, $class_id, $section_id, $session_id,$i);
                    $data['i']=8;   
                    $data['arr_exam_id']=implode(',', $arr);
                }
            }
      
            
        }
       
       
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        //$this->output->enable_profiler(TRUE);
        $this->load->view('admin/examresult/marksheet', $data);
        $this->load->view('layout/footer', $data);
    }

    public function printmarksheet() {
        // $this->output->enable_profiler(TRUE);
        //   $this->load->helper('debug');  // Load the helper

        //  clear_logs(); 
      
        $this->form_validation->set_error_delimiters('', '');
        $this->form_validation->set_rules('post_exam_id', $this->lang->line('exam'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('post_exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('exam_group_class_batch_exam_student_id[]', $this->lang->line('students'), 'required|trim|xss_clean');
        $data = array();
        
        if ($this->form_validation->run() == false) {
            $data = array(
                'post_exam_id' => form_error('post_exam_id'),
                'post_exam_group_id' => form_error('post_exam_group_id'),
                'exam_group_class_batch_exam_student_id' => form_error('exam_group_class_batch_exam_student_id'),
            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {
        //   echo "1<br>";
        

//exit();
$template=$this->marksheet_model->get($this->input->post('marksheet_template'));
 $data['template'] = $template;
$i = $this->input->post('i');
$term = $this->input->post('term');

$sch_setting = $this->sch_setting_detail;
$examination_module= $sch_setting ->examination_module;

if (!empty($term)) { 
    $data['term'] = $term; 
}
// Retrieve POST data
$post_exam_id = $this->input->post('post_exam_id');
$post_exam_group_id = $this->input->post('post_exam_group_id');
$students_array = $this->input->post('exam_group_class_batch_exam_student_id');

// Retrieve exam and exam grades
$data['exam'] = $this->examgroup_model->getExamByID($post_exam_id);
$data['exam_grades'] = $this->grade_model->getByExamType($data['exam']->exam_group_type);

// Get exam results




$data['marksheet'] = $this->examresult_model->getExamResults($post_exam_id, $post_exam_group_id, $students_array, $i,$examination_module);


if(!empty($this->input->post('csa_post_exam_id')) && !empty($this->input->post('csa_exam_group_class_batch_exam_student_id'))){
//get all Co-scholastic area exam data

$csa_post_exam_id = $this->input->post('csa_post_exam_id');
$csa_students_array = $this->input->post('csa_exam_group_class_batch_exam_student_id');

// Retrieve exam
$data['csa_exam'] = $this->examgroup_model->getExamByID($csa_post_exam_id,1);

// Get exam results
$data['csa_marksheet'] = $this->examresult_model->getExamResults($csa_post_exam_id, $post_exam_group_id, $csa_students_array, 1);



//$csa_exam=$this->examgroup_model->getExamByID($csa_post_exam_id,1);
//$csa_marksheet=$this->examresult_model->getExamResults($csa_post_exam_id, $post_exam_group_id, $csa_students_array, 1);
// $len=count($csa_marksheet['students'][0]['exam_result'][0])/count($csa_exam);
// //echo $len."<br>";
// for($i=0;$i<$len;$i++){
//   echo $csa_marksheet['students'][0]['exam_result'][0][$i]->name.'='.$csa_marksheet['students'][0]['exam_result'][0][$i]->get_marks.'==='.$csa_marksheet['students'][0]['exam_result'][0][$i+$len]->name.'='.$csa_marksheet['students'][0]['exam_result'][0][$i+$len]->get_marks."<br>";
// }
// print_r($data['csa_marksheet']);
//  exit();
}


if (!empty($data['marksheet']['students'])) {
    foreach ($data['marksheet']['students'] as $student_key => $student_value) {
   
        $student_session_id = $student_value['student_session_id'];
        
        $attendance_details = $this->Stuattendence_model->getAttendanceBySessionId($student_session_id);
        
        $data['marksheet']['students'][$student_key]['attendance'] = $attendance_details;
    }
}
// print_r($data['marksheet']);
// exit();

// Get school settings
$data['sch_setting'] = $sch_setting;
$data['i'] = $i;
$data['choose_attendance'] = $this->sch_setting_detail->choose_attendance;
// // Define month array


// // Assign month attendance data to $data
// $data['monthAttendance2'] = $monthAttendance2;
$months = array(
    "January" => 1,
    "February" => 2,
    "March" => 3,
    "April" => 4,
    "May" => 5,
    "June" => 6,
    "July" => 7,
    "August" => 8,
    "September" => 9,
    "October" => 10,
    "November" => 11,
    "December" => 12
);
$month_array=array("January","February","March","April","May","June","July","August","September","October","November","December");

            // $session_id = $this->input->post('session_id');
            $session_id=$data['exam'] -> session_id;
            $class_id = $this->input->post('class_id');
            
            $section_id = $this->input->post('section_id');
            
            $date1 =explode('-', $data['exam'] -> session); 
            

            
            //echo $date1[0];
            //start att
            //echo $date1[0];
            //print_r($date1);
            
            $monthAttendance2 = array();
            
            $studentlist = $this->student_model->searchByClassSection($class_id, $section_id);
            
            $session_current = $this->setting_model->getCurrentSessionName();
            
            $startMonth = $this->setting_model->getStartMonth();
                // $startMonth=5;
            


            
            for($j=0;$j<count($month_array);$j++){
            
            $centenary = substr($session_current, 0, 2); //2017-18 to 2017
            
            $year_first_substring = substr($session_current, 2, 2); //2017-18 to 2017
            
            $year_second_substring = substr($session_current, 5, 2); //2017-18 to 18
            
            $month_number = $months[$month_array[$j]];//date("m", strtotime($month_array[$j]));
            
            $year = $date1[0];//$this->input->post('year');
            
            $data['year_selected'] = $year;
            //echo $year;
            

            
            if (!empty($year)) {

                $year = $date1[0];
            } else {

                if ($month_number >= $startMonth && $month_number <= 12) {
                    $year = $centenary . $year_first_substring;
                } else {
                    $year = $centenary . $year_second_substring;
                }
            }


            $num_of_days = cal_days_in_month(CAL_GREGORIAN, $month_number, $year);
            //echo $num_of_days;
            $attr_result = array();
            $attendence_array = array();
            $student_result = array();
            
            $data['no_of_days'] = $num_of_days;
            
            $date_result = array();
            
            for ($i = 1; $i <= $num_of_days; $i++) {
                $att_date = $year . "-" . $month_number . "-" . sprintf("%02d", $i);
                $attendence_array[] = $att_date;

                // $res = $this->examresult_model->searchAttendenceReport($class_id, $section_id, $att_date);
                // $student_result = $res;
                // $s = array();
                // foreach ($res as $result_k => $result_v) {
                //     $s[$result_v['student_session_id']] = $result_v;
                // }
                // $date_result[$att_date] = $s;
                // log_debug("check",$attendence_array);
            }
            

            
            $res = $this->examresult_model->searchAttendenceReport($class_id, $section_id, $attendence_array);
            $student_result = $res;


            
            foreach ($res as $result_k => $result_v) {


                $date = $year . "-" . $month_array[$j];
                $newdate = date('Y-m-d', strtotime($date));
                //$monthAttendance[] = $this->monthAttendance($newdate, 1, $result_v['student_session_id']);
                $monthAttendance2[$result_v["admission_no"]][$j] = $this->monthAttendance($newdate, 1, $result_v['student_session_id']);
            }

        }

            //end att
$data['monthAttendance2']=$monthAttendance2;
            

 

        //$this->load->view('admin/examresult/_printmarksheet', $data);
        

//$this->load->view('admin/examresult/_printmarksheet', $data);

// echo "<pre>";
// print_r($data);
// echo "</pre>";

// yuvi lets create a new model functions  starts here

// $exam_appried_students=

$start_date = $date1[0].'-'.$startMonth.'-01';
// $end_date = '2025-06-23';
$end_date= $template ->attendence_date_upto;
$regular_attendence=[];

foreach($students_array as $student_key => $student_value){
   
    $regular_total_present_days = 0;
    $regular_total_school_days = 0;

    $student = $this->examstudent_model->getExamStudentByID($student_value);
    //  log_debug('$student',$student);
     
    //  $yuvi = $this->Stuattendence_model->getAttendanceByStartDateAndEndDate(
    //     $start_date,
    //     $end_date,
    //     $student["student_session_id"],
    //     $student["class_id"],
    //     $student["section_id"]
    // );
    
    $student_session_id = $student["student_session_id"]; // Optional
    $class_id = $student["class_id"];             // Optional
    $section_id =  $student["section_id"];  

    $row_attendence = $this->Stuattendence_model->getAttendanceByStartDateAndEndDate($start_date, $end_date, $student_session_id, $class_id, $section_id);

    // log_debug("student_data",[
    //     "student_session_id" => $student["student_session_id"],
    //      "class_id" =>$student["class_id"],
    //       "section_id" =>  $student["section_id"],
    //     ]);
    
    //   log_debug('yuvi', $row_attendence);
    
    foreach($row_attendence as $info_attendence){
        if($info_attendence['attendence_type_id'] != "" && $info_attendence['attendence_type_id'] !=5){
            $regular_total_school_days ++;
        }
        if ($info_attendence['attendence_type_id'] != 4 && $info_attendence['attendence_type_id'] != 5) {
            $regular_total_present_days ++;
         }
    }
    
    $regular_attendence[ $student['admission_no'] ] = [
        'regular_total_present_day' => $regular_total_present_days,
        'regular_total_school_days' => $regular_total_school_days,
        ]; 
    
  

}

//   log_debug('regular_attendence', $regular_attendence);
    $data['regular_attendence'] = $regular_attendence;
// $student_session_id = 7337; // Optional
// $class_id = 17;             // Optional
// $section_id = 1;            // Optional

// $yuvi = $this->Stuattendence_model->getAttendanceByStartDateAndEndDate($start_date, $end_date, $student_session_id, $class_id, $section_id);
// log_debug('yuvi',$yuvi);
//ends here
// log_debug('Final data to display on the print file',$data);
            if ($this->sch_setting_detail->examination_module == 4 || $this->sch_setting_detail->examination_module == 2) {
                $student_exam_page = $this->load->view('admin/examresult/_printmarksheet_4', $data, true);
            } elseif ($this->sch_setting_detail->examination_module == 3) {
                $student_exam_page = $this->load->view('admin/examresult/_printmarksheet_3.php', $data, true);
            } elseif ($this->sch_setting_detail->examination_module == 6) {
                $student_exam_page = $this->load->view('admin/examresult/_printmarksheet_6', $data, true);
            }elseif($this->sch_setting_detail->examination_module == '6a'){
                $student_exam_page = $this->load->view('admin/examresult/_printmarksheet_6a', $data, true);
            }
            elseif ($this->sch_setting_detail->examination_module == 8) {
                $student_exam_page = $this->load->view('admin/examresult/_printmarksheet_8', $data, true);
            }
           // $student_exam_page = $this->load->view('admin/examresult/_printmarksheet', $data, true); 
            
//     // Capture the profiler output
// $profiler_output = $this->output->get_profiler_sections();
// Capture the profiler output
// $profiler_output = $this->output->profiler_string();
// Get profiler output
// $CI = &get_instance(); // Get CodeIgniter instance
// $profiler_output = $CI->profiler->run();
// Get profiler output
// $profiler_output = $this->profiler->run();

            $array = array('status' => '1', 'error' => '', 'page' => $student_exam_page);//'profiler_output' => $profiler_output
            echo json_encode($array);
            
            
            
            //$student_exam_page = $this->load->view('admin/examresult/_printmarksheet_working_old', $data, true); 
            //_printmarksheet_working_old.php
            //$this->load->view('admin/examresult/_printmarksheet', $data);
//         }else{
//             $post_exam_id = $this->input->post('post_exam_id');//
//             $post_exam_group_id = $this->input->post('post_exam_group_id');
//             $students_array = $this->input->post('exam_group_class_batch_exam_student_id');//
//             for($a=0;$a<count($students_array);$a++)
//             {

//             $array_post_exam_id = explode(",", $post_exam_id);//
//             $array_students_array = explode(",", $students_array[$a]);

            
// for($j=0;$j<$i;$j++){
//             $exam = $this->examgroup_model->getExamByID($array_post_exam_id[$j]);
//             $data['exam'] = $exam;
//             $exam_grades[$j] = $this->grade_model->getByExamType($exam->exam_group_type);
//             $data['exam_grades'][$j] = $exam_grades[$j];
//             $data['marksheet'][$j] = $this->examresult_model->getExamResults($array_post_exam_id[$j], $post_exam_group_id, $array_students_array[$j]);
//             $data['sch_setting'][$j] = $this->sch_setting_detail;
//             $data['array_students_array'][$j]=$array_students_array[$j];
//             $data['array_post_exam_id'][$j]=$array_post_exam_id[$j];
//         }
//     }
//             $student_exam_page = $this->load->view('admin/examresult/_printmarksheet', $data, true); 
//             $array = array('status' => '1', 'error' => '', 'page' => $student_exam_page);
//             echo json_encode($array);

//         }
        }
    }


    
    public function index() {
        if (!$this->rbac->hasPrivilege('exam_result', 'can_view')) {
            access_denied();
        }
                //  $this->load->helper('debug');  // Load the helper

        //  clear_logs(); 
         
        $this->session->set_userdata('top_menu', 'Examinations');
        $this->session->set_userdata('sub_menu', 'Examinations/Examresult');
        $examgroup_result = $this->examgroup_model->get();
        $data['examgrouplist'] = $examgroup_result;

        $marksheet_result = $this->marksheet_model->get();
        $data['marksheetlist'] = $marksheet_result;

        $class = $this->class_model->get();
        $data['title'] = 'Add Batch';
        $data['title_list'] = 'Recent Batch';
        $data['examType'] = $this->exam_type;
        $data['classlist'] = $class;
        $session = $this->session_model->get();
        $data['sessionlist'] = $session;
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('session_id', $this->lang->line('session'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'trim|required|xss_clean');
        //$this->form_validation->set_rules('exam_id', $this->lang->line('exam'), 'trim|required|xss_clean');

        if ($this->form_validation->run() == false) {
            
        } else {
            $exam_group_id = $this->input->post('exam_group_id');
            $exam_id = $this->input->post('exam_id');
            //print_r($exam_id);
            //exit();
            $session_id = $this->input->post('session_id');
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');

            $marksheet_template = $this->input->post('marksheet');
            //foreach($exam_id as $key => $val){
              // foreach ($exam_id as $key => $val) {
            //   $studentList=array();
            //   $exam_grades=array();
            
        for($i=0;$i<count($exam_id);$i++){
              // echo $exam_id[$i]."<br>";
            $data['marksheet_template'] = $marksheet_template;
            $exam_details = $this->examgroup_model->getExamByID($exam_id[$i]);

            $studentList[$i] = $this->examgroupstudent_model->searchExamStudents($exam_group_id, $exam_id[$i], $class_id, $section_id, $session_id);
            
            

            $exam_subjects[$i] = $this->batchsubject_model->getExamSubjects($exam_id[$i]);
            //$data['subjectList'] = $exam_subjects[$i];
            $subjectList[$i] = $exam_subjects[$i];


            if (!empty($studentList[$i])) {
                foreach ($studentList[$i] as $student_key => $student_value) {
                    $studentList[$i][$student_key]->subject_results = $this->examresult_model->getStudentResultByExam($exam_id[$i], $student_value->exam_group_class_batch_exam_student_id);
                }
            }
 
            //$data[''] 
            $studentList[$i]= $studentList[$i];
            
            $exam_grades = $this->grade_model->getByExamType($exam_details->exam_group_type);
        }
        //   log_debug("2nd chcek studentList", $studentList); 
          
            // lets try something 
            
            $allStudents =[];
            foreach($studentList as $examStudents){
                foreach($examStudents as $students){
                    
                    $allStudents[]=$students;
                    
                }
            }
            // log_debug("allStudents",$allStudents);
            
            // $uniqueStudents=[];
            
            // foreach($allStudents as $student){
                
            //     if(){
                    
            //     }
            // }
            
            //exp ends here
        //exit();
        $data['studentList'] = $studentList;
        $data['subjectList']=$subjectList;
            $data['exam_grades'] = $exam_grades;
            $data['exam_details'] = $exam_details;
            $data['exam_id'] = $exam_id;
            $data['exam_group_id'] = $exam_group_id;
        }   
        $data['sch_setting'] = $this->sch_setting_detail;
        
 
        $this->load->view('layout/header', $data);
        $this->load->view('admin/examresult/index', $data);
        $this->load->view('layout/footer', $data);
    }

    public function getStudentByClassBatch() {
        $class_id = $this->input->post('class_id');
        $section_id = $this->input->post('section_id');
        $session_id = $this->input->post('session_id');
        $data['studentList'] = $this->examgroupstudent_model->searchStudentByClassSectionSession($class_id, $section_id, $session_id);
        echo json_encode($data);
    }

    public function getExamGroupByStudent() {
        $student_id = $this->input->post('student_id');

        $data['examgrouplist'] = $this->examgroup_model->getExamGroupByStudent($student_id);
        echo json_encode($data);
    }

    public function studentresult() {
        $this->form_validation->set_error_delimiters('', '');
        $this->form_validation->set_rules('exam_group_id', 'exam_group_id', 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_id', 'student_id', 'required|trim|xss_clean');

        if ($this->form_validation->run() == false) {
            $data = array(
                'exam_group_id' => form_error('exam_group_id'),
                'student_id' => form_error('student_id'),
            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {

            $student_id = $this->input->post('student_id');
            $exam_group_id = $this->input->post('exam_group_id');
            $exam_group_exam_id = $this->input->post('exam_id');

            $examresult = array();
            $exam_grades = array();
            
            if ($exam_group_exam_id != "") {
                $examresult = $this->examgroup_model->getExamResultDetailStudent($exam_group_exam_id, $exam_group_id, $student_id);

                $data['examresult'] = $examresult;
                $exam_grades = $this->grade_model->getByExamType($examresult->exam_type);
                $data['exam_grades'] = $exam_grades;
                $examresult = $this->load->view('admin/examresult/_getExam', $data, true);
            } else {
                $exam_group = $this->examgroup_model->get($exam_group_id);
                $data['exam_group'] = $exam_group;

                $exam_grades = $this->grade_model->getByExamType($exam_group->exam_type);
                $data['exam_grades'] = $exam_grades;

                $exam_result = $this->examgroup_model->getExamGroupExamsResultByStudentID($exam_group_id, $student_id);
                $data['examresult'] = $exam_result;
                $exam_connections = $this->examgroup_model->getExamGroupConnection($exam_group_id);
                $data['exam_connections'] = $exam_connections;
                $examresult = $this->load->view('admin/examresult/_getExamGroupResult', $data, true);
            }

            $data['exam_grades'] = $exam_grades;

            $array = array('status' => '1', 'result' => $examresult, 'message' => $this->lang->line('success_message'));
            echo json_encode($array);
        }
    }

    public function getStudentCurrentResult() {
        $this->form_validation->set_rules('student_session_id', $this->lang->line('student') . " " . $this->lang->line('id'), 'trim|required|xss_clean');

        if ($this->form_validation->run() == false) {

            $msg = array(
                'student_session_id' => form_error('student_session_id'),
            );

            $array = array('status' => 0, 'error' => $msg);
        } else {
            $student_session_id = $this->input->post('student_session_id');
            $data['exam_grades'] = $this->grade_model->get();
            $exam_groups_attempt = $this->examgroup_model->getExamGroupByStudentSession($student_session_id);

            $data['exam_groups_attempt'] = $exam_groups_attempt;
            $examresult = $this->load->view('admin/examresult/_getExamGroupResult', $data, true);
            $array = array('status' => 1, 'error' => '', 'result' => $examresult);
        }
        echo json_encode($array);
    }

    public function generatemarksheet() {
        $this->form_validation->set_rules('exam_id', $this->lang->line('exam') . " " . $this->lang->line('id'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('check[]', $this->lang->line('students'), 'trim|required|xss_clean');

        if ($this->form_validation->run() == false) {

            $msg = array(
                'exam_id' => form_error('exam_id'),
                'check' => form_error('check'),
            );

            $array = array('status' => 0, 'error' => $msg);
        } else {
            echo "<pre/>";
            $exam_id = $this->input->post('exam_id');
            $students = $this->input->post('check');
            $exam = $this->examgroup_model->getExamByID($exam_id);
            $exam_id = $exam->id;
            $students_result = array();
            if (!empty($students)) {
                foreach ($students as $student_key => $student_value) {
                    print_r($student_value);
                    exit();

                    $students_result[] = $this->examresult_model->getStudentExamResult($exam_id, $student_value);
                }
            }
            print_r($students_result);
            exit();

            exit();
        }
        echo json_encode($array);
    }

    public function rankreport() {
        if (!$this->rbac->hasPrivilege('rank_report', 'can_view')) {
            access_denied();
        }

        $this->session->set_userdata('top_menu', 'Reports');
        $this->session->set_userdata('sub_menu', 'Reports/examinations');
        $this->session->set_userdata('subsub_menu', 'Reports/examinations/rankreport');
        $examgroup_result = $this->examgroup_model->get();
        $data['examgrouplist'] = $examgroup_result;

        $marksheet_result = $this->marksheet_model->get();
        $data['marksheetlist'] = $marksheet_result;

        $class = $this->class_model->get();
        $data['title'] = 'Add Batch';
        $data['title_list'] = 'Recent Batch';
        $data['examType'] = $this->exam_type;
        $data['classlist'] = $class;
        $session = $this->session_model->get();
        $data['sessionlist'] = $session;
        $this->form_validation->set_rules('class_id', $this->lang->line('class'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('session_id', $this->lang->line('session'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_group_id', $this->lang->line('exam') . " " . $this->lang->line('group'), 'trim|required|xss_clean');
        $this->form_validation->set_rules('exam_id', $this->lang->line('exam'), 'trim|required|xss_clean');

        if ($this->form_validation->run() == false) {
            
        } else {
            $exam_group_id = $this->input->post('exam_group_id');
            $exam_id = $this->input->post('exam_id');
            $session_id = $this->input->post('session_id');
            $class_id = $this->input->post('class_id');
            $section_id = $this->input->post('section_id');

            $marksheet_template = $this->input->post('marksheet');
            $data['marksheet_template'] = $marksheet_template;
            $exam_details = $this->examgroup_model->getExamByID($exam_id);

            $studentList = $this->examgroupstudent_model->searchExamStudents($exam_group_id, $exam_id, $class_id, $section_id, $session_id);
            $exam_subjects = $this->batchsubject_model->getExamSubjects($exam_id);
            $data['subjectList'] = $exam_subjects;

            if (!empty($studentList)) {
                foreach ($studentList as $student_key => $student_value) {
                    $studentList[$student_key]->subject_results = $this->examresult_model->getStudentResultByExam($exam_id, $student_value->exam_group_class_batch_exam_student_id);
                }
            }

            $data['studentList'] = $studentList;
            

            
            $exam_grades = $this->grade_model->getByExamType($exam_details->exam_group_type);
            $data['exam_grades'] = $exam_grades;
            $data['exam_details'] = $exam_details;
            $data['exam_id'] = $exam_id;
            $data['exam_group_id'] = $exam_group_id;
        }
        $data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        $this->load->view('admin/examresult/rankreport', $data);
        $this->load->view('layout/footer', $data);
    }

}