1#@!#!123s

: / home / schoolcampuserp / srinfinityschool.in / application / controllers / admin /
Filename : Transfer_certificate.php
back
<?php
//transfer_certificate
if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Transfer_certificate extends Admin_Controller {

    public function __construct() {
        parent::__construct();
         $this->load->model('transfer_certificate_model');
         $this->load->model('class_model');
         $this->load->model('session_model');
         $this->load->model('student_model');
          $this->load->model('examresult_model');
          $this->load->model('setting_model');
          $this->load->model('studentfeemaster_model');
          $this->load->model('subjectgroup_model');
          $this->load->model('feediscount_model');
          $this->load->model('examgroupstudent_model');
          $this->load->model('examschedule_model');
        
        
        
        $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');
          
          
         
    }

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

        $this->session->set_userdata('top_menu', 'Examinations');
        $this->session->set_userdata('sub_menu', 'Examinations/marksheet');
        $data['title'] = 'Add Library';

        $this->data['certificateList'] = $this->transfer_certificate_model->get();

        $this->form_validation->set_rules('template', $this->lang->line('template'), 'trim|required|xss_clean');

        $this->form_validation->set_rules('left_logo', $this->lang->line('left') . " " . $this->lang->line('logo'), 'callback_handle_upload[left_logo]');
        $this->form_validation->set_rules('right_logo', $this->lang->line('right') . " " . $this->lang->line('logo'), 'callback_handle_upload[right_logo]');
        $this->form_validation->set_rules('background_img', $this->lang->line('background') . " " . $this->lang->line('image'), 'callback_handle_upload[background_img]');
        $this->form_validation->set_rules('left_sign', $this->lang->line('sign'), 'callback_handle_upload[left_sign]');
        $this->form_validation->set_rules('middle_sign', $this->lang->line('sign'), 'callback_handle_upload[middle_sign]');
        $this->form_validation->set_rules('right_sign', $this->lang->line('sign'), 'callback_handle_upload[right_sign]');

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

            if (isset($_POST['is_name'])) {
                $is_name = 1;
            } else {
                $is_name = 0;
            }
            if (isset($_POST['is_father_name'])) {
                $is_father_name = 1;
            } else {
                $is_father_name = 0;
            }
            if (isset($_POST['is_mother_name'])) {
                $is_mother_name = 1;
            } else {
                $is_mother_name = 0;
            }

            if (isset($_POST['is_admission_no'])) {
                $is_admission_no = 1;
            } else {
                $is_admission_no = 0;
            }
           
            if (isset($_POST['is_dob'])) {
                $is_dob = 1;
            } else {
                $is_dob = 0;
            }
            if (isset($_POST['is_teacher_remark'])) {
                $is_teacher_remark = 1;
            } else {
                $is_teacher_remark = 0;
            }
            $is_nationality = isset($_POST['is_nationality']) ? 1 : 0;
$is_category = isset($_POST['is_category']) ? 1 : 0;
$is_admission_date = isset($_POST['is_admission_date']) ? 1 : 0;
$is_last_class = isset($_POST['is_last_class']) ? 1 : 0;
$is_last_result = isset($_POST['is_last_result']) ? 1 : 0;
$is_failed = isset($_POST['is_failed']) ? 1 : 0;
$is_subjects_studied = isset($_POST['is_subjects_studied']) ? 1 : 0;
$is_pro_higher_std = isset($_POST['is_pro_higher_std']) ? 1 : 0;
$is_school_dues_paid = isset($_POST['is_school_dues_paid']) ? 1 : 0;
$is_any_fee_concession = isset($_POST['is_any_fee_concession']) ? 1 : 0;
$is_total_working_day = isset($_POST['is_total_working_day']) ? 1 : 0;
$is_total_working_day_attended = isset($_POST['is_total_working_day_attended']) ? 1 : 0;
$is_ncc = isset($_POST['is_ncc']) ? 1 : 0;
$is_extra_activities = isset($_POST['is_extra_activities']) ? 1 : 0;
$is_application_certificate = isset($_POST['is_application_certificate']) ? 1 : 0;
$is_issue_certificate = isset($_POST['is_issue_certificate']) ? 1 : 0;
$is_general_conduct = isset($_POST['is_general_conduct']) ? 1 : 0;
$is_religion_caste = isset($_POST['is_religion_caste']) ? 1 : 0;
$is_date_admission_pro = isset($_POST['is_date_admission_pro']) ? 1 : 0;
$is_all_fee_paid = isset($_POST['is_all_fee_paid']) ? 1 : 0;
$is_last_attendance = isset($_POST['is_last_attendance']) ? 1 : 0;
$is_remove_name_rolls = isset($_POST['is_remove_name_rolls']) ? 1 : 0;
$left_date = isset($_POST['left_date']) ? 1 : 0;


            $insert_data = array(
                'template' => $this->input->post('template'),
                'heading' => $this->input->post('heading'),
                'heading_size' => $this->input->post('heading_size'),
                'title' => $this->input->post('title'),
                //'exam_name' => $this->input->post('exam_name'),
                'school_name' => $this->input->post('school_name'),
                //'exam_center' => $this->input->post('exam_center'),
                'date' => $this->input->post('date'),
                'is_name' => $is_name,
                'is_father_name' => $is_father_name,
                'is_mother_name' => $is_mother_name,
                'is_admission_no' => $is_admission_no,
                'is_nationality' => $is_nationality,
                'is_category' => $is_category,
                'is_admission_date' => $is_admission_date,
                'is_last_class' => $is_last_class,
                'is_last_result' => $is_last_result,
                'is_failed' => $is_failed,
                'is_subjects_studied' => $is_subjects_studied,
                'is_pro_higher_std' => $is_pro_higher_std,
                'is_school_dues_paid' => $is_school_dues_paid,
                'is_any_fee_concession' => $is_any_fee_concession,
                'is_total_working_day' => $is_total_working_day,
                'is_total_working_day_attended' => $is_total_working_day_attended,
                'is_ncc' => $is_ncc,
                'is_extra_activities' => $is_extra_activities,
                'is_application_certificate' => $is_application_certificate,
                'is_issue_certificate' => $is_issue_certificate,
                'is_general_conduct' => $is_general_conduct,
                'is_religion_caste' => $is_religion_caste,
                'is_date_admission_pro' => $is_date_admission_pro,
                'is_all_fee_paid' => $is_all_fee_paid,
                'is_last_attendance' => $is_last_attendance,
                'is_remove_name_rolls' => $is_remove_name_rolls,
                
                'is_dob' => $is_dob,
                'is_teacher_remark' => $is_teacher_remark,
                //'content' => $this->input->post('content'),
                //'content_footer' => $this->input->post('content_footer'),
                //'exam_session' => $exam_session,
                'left_logo' => "",
                //'right_logo' => "",
                'left_date' => $left_date,
                'right_sign' => "",
                'middle_sign' => "",
                'background_img' => "",
            );

            if (isset($_FILES["left_logo"]) && !empty($_FILES["left_logo"]['name'])) {
                $time = md5($_FILES["left_logo"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["left_logo"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["left_logo"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['left_logo'] = $img_name;
            }
            // if (isset($_FILES["right_logo"]) && !empty($_FILES["right_logo"]['name'])) {
            //     $time = md5($_FILES["right_logo"]['name'] . microtime());
            //     $fileInfo = pathinfo($_FILES["right_logo"]["name"]);
            //     $img_name = $time . '.' . $fileInfo['extension'];
            //     move_uploaded_file($_FILES["right_logo"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
            //     $insert_data['right_logo'] = $img_name;
            // }
            // if (isset($_FILES["left_sign"]) && !empty($_FILES["left_sign"]['name'])) {
            //     $time = md5($_FILES["left_sign"]['name'] . microtime());
            //     $fileInfo = pathinfo($_FILES["left_sign"]["name"]);
            //     $img_name = $time . '.' . $fileInfo['extension'];
            //     move_uploaded_file($_FILES["left_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
            //     $insert_data['left_sign'] = $img_name;
            // }
            
            if (isset($_FILES["middle_sign"]) && !empty($_FILES["middle_sign"]['name'])) {
                $time = md5($_FILES["middle_sign"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["middle_sign"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["middle_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['middle_sign'] = $img_name;
            }if (isset($_FILES["right_sign"]) && !empty($_FILES["right_sign"]['name'])) {
                $time = md5($_FILES["right_sign"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["right_sign"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["right_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['right_sign'] = $img_name;
            }
            if (isset($_FILES["background_img"]) && !empty($_FILES["background_img"]['name'])) {
                $time = md5($_FILES["background_img"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["background_img"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["background_img"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['background_img'] = $img_name;
            }
            
            $this->transfer_certificate_model->add($insert_data);
            //$this->transfer_certificate_model->add($insert_data);

            $this->session->set_flashdata('msg', '<div class="alert alert-success text-left">' . $this->lang->line('success_message') . '</div>');
            redirect('admin/transfer_certificate/index');
        }

        $this->load->view('layout/header');
        $this->load->view('admin/transfer_certificate/createtransfer_certificate', $this->data);
        $this->load->view('layout/footer');
    }

    public function handle_upload($str, $var) {

        $image_validate = $this->config->item('image_validate');
        $result = $this->filetype_model->get();
        if (isset($_FILES[$var]) && !empty($_FILES[$var]['name'])) {

            $file_type = $_FILES[$var]['type'];
            $file_size = $_FILES[$var]["size"];
            $file_name = $_FILES[$var]["name"];

            $allowed_extension = array_map('trim', array_map('strtolower', explode(',', $result->image_extension)));
            $allowed_mime_type = array_map('trim', array_map('strtolower', explode(',', $result->image_mime)));
            $ext               = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
            

            if ($files = @getimagesize($_FILES[$var]['tmp_name'])) {

                if (!in_array($files['mime'], $allowed_mime_type)) {
                    $this->form_validation->set_message('handle_upload', $this->lang->line('file_type_not_allowed'));
                    return false;
                }

                if (!in_array($ext, $allowed_extension) || !in_array($file_type, $allowed_mime_type)) {
                    $this->form_validation->set_message('handle_upload', $this->lang->line('extension_not_allowed'));
                    return false;
                }
                if ($file_size > $result->image_size) {
                    $this->form_validation->set_message('handle_upload', $this->lang->line('file_size_shoud_be_less_than') . number_format($image_validate['upload_size'] / 1048576, 2) . " MB");
                    return false;
                }
            } else {
                $this->form_validation->set_message('handle_upload', $this->lang->line('file_type_not_allowed') . " " . $this->lang->line('or') . " " . $this->lang->line('extension_not_allowed'));
                return false;
            }

            return true;
        }
        return true;
    }

    public function edit($id) {
        if (!$this->rbac->hasPrivilege('design_marksheet', 'can_edit')) {
            access_denied();
        }

        $data['title'] = 'Add Library';
        $this->session->set_userdata('top_menu', 'Examinations');
        $this->session->set_userdata('sub_menu', 'Examinations/marksheet');

        $this->data['certificateList'] = $this->transfer_certificate_model->get();

        $marksheet = $this->transfer_certificate_model->get($id);

        $this->data['marksheet'] = $marksheet;

        $this->form_validation->set_rules('template', 'template', 'trim|required|xss_clean');

        $this->form_validation->set_rules('left_logo', 'left_logo', 'callback_handle_upload[left_logo]');
       // $this->form_validation->set_rules('right_logo', 'right_logo', 'callback_handle_upload[right_logo]');
        $this->form_validation->set_rules('background_img', 'background_img', 'callback_handle_upload[background_img]');
        //$this->form_validation->set_rules('left_sign', $this->lang->line('sign'), 'callback_handle_upload[left_sign]');
        $this->form_validation->set_rules('middle_sign', $this->lang->line('sign'), 'callback_handle_upload[middle_sign]');
        $this->form_validation->set_rules('right_sign', $this->lang->line('sign'), 'callback_handle_upload[right_sign]');

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

            if (isset($_POST['is_name'])) {
                $is_name = 1;
            } else {
                $is_name = 0;
            }
            if (isset($_POST['is_father_name'])) {
                $is_father_name = 1;
            } else {
                $is_father_name = 0;
            }
            if (isset($_POST['is_mother_name'])) {
                $is_mother_name = 1;
            } else {
                $is_mother_name = 0;
            }

            if (isset($_POST['is_admission_no'])) {
                $is_admission_no = 1;
            } else {
                $is_admission_no = 0;
            }
            

            if (isset($_POST['is_dob'])) {
                $is_dob = 1;
            } else {
                $is_dob = 0;
            }
            if (isset($_POST['is_teacher_remark'])) {
                $is_teacher_remark = 1;
            } else {
                $is_teacher_remark = 0;
            }
$is_nationality = isset($_POST['is_nationality']) ? 1 : 0;
$is_category = isset($_POST['is_category']) ? 1 : 0;
$is_admission_date = isset($_POST['is_admission_date']) ? 1 : 0;
$is_last_class = isset($_POST['is_last_class']) ? 1 : 0;
$is_last_result = isset($_POST['is_last_result']) ? 1 : 0;
$is_failed = isset($_POST['is_failed']) ? 1 : 0;
$is_subjects_studied = isset($_POST['is_subjects_studied']) ? 1 : 0;
$is_pro_higher_std = isset($_POST['is_pro_higher_std']) ? 1 : 0;
$is_school_dues_paid = isset($_POST['is_school_dues_paid']) ? 1 : 0;
$is_any_fee_concession = isset($_POST['is_any_fee_concession']) ? 1 : 0;
$is_total_working_day = isset($_POST['is_total_working_day']) ? 1 : 0;
$is_total_working_day_attended = isset($_POST['is_total_working_day_attended']) ? 1 : 0;
$is_ncc = isset($_POST['is_ncc']) ? 1 : 0;
$is_extra_activities = isset($_POST['is_extra_activities']) ? 1 : 0;
$is_application_certificate = isset($_POST['is_application_certificate']) ? 1 : 0;
$is_issue_certificate = isset($_POST['is_issue_certificate']) ? 1 : 0;
$is_general_conduct = isset($_POST['is_general_conduct']) ? 1 : 0;
$is_religion_caste = isset($_POST['is_religion_caste']) ? 1 : 0;
$is_date_admission_pro = isset($_POST['is_date_admission_pro']) ? 1 : 0;
$is_all_fee_paid = isset($_POST['is_all_fee_paid']) ? 1 : 0;
$is_last_attendance = isset($_POST['is_last_attendance']) ? 1 : 0;
$is_remove_name_rolls = isset($_POST['is_remove_name_rolls']) ? 1 : 0;
$left_date = isset($_POST['left_date']) ? 1 : 0;

            $insert_data = array(
                'id' => $this->input->post('id'),
                'template' => $this->input->post('template'),
                'heading' => $this->input->post('heading'),
                'heading_size' => $this->input->post('heading_size'),
                'title' => $this->input->post('title'),
                //'exam_name' => $this->input->post('exam_name'),
                'school_name' => $this->input->post('school_name'),
                //'exam_center' => $this->input->post('exam_center'),
                //'content' => $this->input->post('content'),
                //'content_footer' => $this->input->post('content_footer'),
                'date' => $this->input->post('date'),
                'is_dob' => $is_dob,
                'is_teacher_remark' => $is_teacher_remark,
                'is_name' => $is_name,
                'is_father_name' => $is_father_name,
                'is_mother_name' => $is_mother_name,
                'is_admission_no' => $is_admission_no,
                 'is_nationality' => $is_nationality,
                'is_category' => $is_category,
                'is_admission_date' => $is_admission_date,
                'is_last_class' => $is_last_class,
                'is_last_result' => $is_last_result,
                'is_failed' => $is_failed,
                'is_subjects_studied' => $is_subjects_studied,
                'is_pro_higher_std' => $is_pro_higher_std,
                'is_school_dues_paid' => $is_school_dues_paid,
                'is_any_fee_concession' => $is_any_fee_concession,
                'is_total_working_day' => $is_total_working_day,
                'is_total_working_day_attended' => $is_total_working_day_attended,
                'is_ncc' => $is_ncc,
                'is_extra_activities' => $is_extra_activities,
                'is_application_certificate' => $is_application_certificate,
                'is_issue_certificate' => $is_issue_certificate,
                'is_general_conduct' => $is_general_conduct,
                'is_religion_caste' => $is_religion_caste,
                'is_date_admission_pro' => $is_date_admission_pro,
                'is_all_fee_paid' => $is_all_fee_paid,
                'is_last_attendance' => $is_last_attendance,
                'is_remove_name_rolls' => $is_remove_name_rolls,
                'left_date' => $left_date,
            );

            if (isset($_FILES["left_logo"]) && !empty($_FILES["left_logo"]['name'])) {
                $time = md5($_FILES["left_logo"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["left_logo"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["left_logo"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['left_logo'] = $img_name;
            }
            // if (isset($_FILES["right_logo"]) && !empty($_FILES["right_logo"]['name'])) {
            //     $time = md5($_FILES["right_logo"]['name'] . microtime());
            //     $fileInfo = pathinfo($_FILES["right_logo"]["name"]);
            //     $img_name = $time . '.' . $fileInfo['extension'];
            //     move_uploaded_file($_FILES["right_logo"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
            //     $insert_data['right_logo'] = $img_name;
            // }
            // if (isset($_FILES["left_sign"]) && !empty($_FILES["left_sign"]['name'])) {
            //     $time = md5($_FILES["left_sign"]['name'] . microtime());
            //     $fileInfo = pathinfo($_FILES["left_sign"]["name"]);
            //     $img_name = $time . '.' . $fileInfo['extension'];
            //     move_uploaded_file($_FILES["left_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
            //     $insert_data['left_sign'] = $img_name;
            // }
            if (isset($_FILES["middle_sign"]) && !empty($_FILES["middle_sign"]['name'])) {
                $time = md5($_FILES["middle_sign"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["middle_sign"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["middle_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['middle_sign'] = $img_name;
            }if (isset($_FILES["right_sign"]) && !empty($_FILES["right_sign"]['name'])) {
                $time = md5($_FILES["right_sign"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["right_sign"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["right_sign"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['right_sign'] = $img_name;
            }
            if (isset($_FILES["background_img"]) && !empty($_FILES["background_img"]['name'])) {
                $time = md5($_FILES["background_img"]['name'] . microtime());
                $fileInfo = pathinfo($_FILES["background_img"]["name"]);
                $img_name = $time . '.' . $fileInfo['extension'];
                move_uploaded_file($_FILES["background_img"]["tmp_name"], "./uploads/transfer_certificate/" . $img_name);
                $insert_data['background_img'] = $img_name;
            }

            
            $this->transfer_certificate_model->add($insert_data);

            $this->session->set_flashdata('msg', '<div class="alert alert-success text-left">' . $this->lang->line('update_message') . '</div>');
            redirect('admin/transfer_certificate/index');
        }

        $this->load->view('layout/header');
        $this->load->view('admin/transfer_certificate/edittransfer_certificate', $this->data);
        $this->load->view('layout/footer');
    }

    public function delete($id) {
        if (!$this->rbac->hasPrivilege('design_marksheet', 'can_delete')) {
            access_denied();
        }
        $data['title'] = 'Certificate List';
        $this->transfer_certificate_model->remove($id);
        $this->session->set_flashdata('msg', '<div class="alert alert-success text-left">' . $this->lang->line('delete_message') . '</div>');
        redirect('admin/transfer_certificate/index');
    }

    public function view() {
        $id = $this->input->post('certificateid');
        $output = '';
        $data = array();

        $data['marksheet'] = $this->transfer_certificate_model->get($id);
        $page = $this->load->view('admin/transfer_certificate/_view', $data, true);
        echo json_encode(array('status' => 1, 'page' => $page));
    }
    
     public function transfercertificate() {
        
        $this->session->set_userdata('top_menu', 'Certificate');
        $this->session->set_userdata('sub_menu', 'admin/transfer_certificate/transfer_certificate');
       

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

        $class = $this->class_model->get();
        // $data['title'] = 'Add Batch';
        // $data['title_list'] = 'Recent Batch';
       
        $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');
       
        if ($this->form_validation->run() == false) {
            
        } else {
            $class       = $this->input->post('class_id');
        $section     = $this->input->post('section_id');
 $studentList= $this->student_model->searchByClassSection($class, $section);
 
            $marksheet_template = $this->input->post('marksheet');
            $data['marksheet_template'] = $marksheet_template;
            $data['studentList']=$studentList;

            
             


          
            
        }
        //$data['sch_setting'] = $this->sch_setting_detail;
        $this->load->view('layout/header', $data);
        $this->load->view('admin/transfer_certificate/transfercertificate', $data);
        $this->load->view('layout/footer', $data);
    }
    
    public function printtransfer_certificate()
    {
        $this->form_validation->set_rules('class_id', $this->lang->line('class_id'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('section_id', $this->lang->line('section_id') . " " . $this->lang->line('group'), 'required|trim|xss_clean');
        $this->form_validation->set_rules('student_id[]', $this->lang->line('students'), 'required|trim|xss_clean');
        $data = array();

        if ($this->form_validation->run() == false) {
            $data = array(
                'class_id' => form_error('class_id'),
                'section_id' => form_error('section_id'),
                'student_id' => form_error('student_id'),
            );
            $array = array('status' => 0, 'error' => $data);
            echo json_encode($array);
        } else {
            // $data['tsc_auto_insert']    = $this->sch_setting_detail->tsc_auto_insert;
            // $insert                            = true;
            // $data_setting                      = array();
            // $data_setting['id']                = $this->sch_setting_detail->id;
            // $data_setting['tsc_auto_insert']   = $this->sch_setting_detail->tsc_auto_insert;
            // $data_setting['tsc_update_status'] = $this->sch_setting_detail->tsc_update_status;
            // $transfer_certificate_no                      = 0;
            
            $category                     = $this->category_model->get();
        $data['categorylist']         = $category;
            $class = $this->class_model->get();
        $data['classlist'] = $class;
             $data['template'] = $this->transfer_certificate_model->get($this->input->post('marksheet_template'));
            
            $class_id = $this->input->post('class_id');
            $data['class_id']=$class_id;
            $section_id = $this->input->post('section_id');
            $students_array = $this->input->post('student_id');
             $data['student_due_fee'] = array();
            //$students = array();
       //print_r($students_array);
       $subject_groups = $this->subjectgroup_model->getByID();
       $month_array=array("January","February","March","April","May","June","July","August","September","October","November","December");
            $session_id =  $this->setting_model->getCurrentSessionName();//$this->input->post('session_id');
            // $class_id = $this->input->post('class_id');
            // $section_id = $this->input->post('section_id');
            $date1=explode('-', $session_id); 
            //echo $date1[0];
            //start att
            //echo $date1[0];
            // print_r($date1);
            // echo "<br>";
            $monthAttendance2 = array();
            $monthAttendance3 = array();
            $studentlist = $this->student_model->searchByClassSection($class_id, $section_id);
            $session_current = $this->setting_model->getCurrentSessionName();
            //print_r($session_current);
            $startMonth = $this->setting_model->getStartMonth();
            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 = 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;
            }
            // print_r($attendence_array);
            // exit();
            $res = $this->examresult_model->searchAttendenceReport($class_id, $section_id, $attendence_array);
                $student_result = $res;

            //$monthAttendance = array();
            //  print_r($res);
            // exit();
            foreach ($res as $result_k => $result_v) {


                $date = $year . "-" . $month_array[$j];
                $newdate = date('Y-m-d', strtotime($date));
                // print_r($newdate);
                // exit();
                //$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']);
            //$monthAttendance3[$result_v["admission_no"]][$j]->date=$newdate;
            //echo $newdate."<br>";
                
            }

        }

            //end att
            //$data['attendence_array']=$attendence_array;
            $data['monthAttendance2'] = $monthAttendance2;
            //$data['monthAttendance3'] = $monthAttendance3;
//$students[$student_id]['monthAttendance2']=$monthAttendance2;
            
            foreach ($students_array as $index => $student_id) {
                //$student_due_fee[$index]=$this->student_model->getStudentByClassSectionID($class_id,$section_id,$student_id);
                $student_due_fee[$index]              = $this->studentfeemaster_model->getStudentFeesByClassSectionStudent($class_id,$section_id,$student_id); 
                $student_promoted=$this->student_model->searchPromotedStudents($student_id);
                $student_Admission=$this->student_model->getAdmissionClassSectionStudents($student_id);
                foreach ($student_due_fee[$index] as $student_key => $student) {
                    $already_exists_Record_student         = $this->transfer_certificate_model->already_exists_Record($student['student_session_id'],$this->input->post('class_id'),$this->input->post('section_id'));
                    // print_r($already_exists_Record_student)."<br>";
                    // echo empty($already_exists_Record_student);
                    // exit();
                    $transfer_certificate_no='';
                    if(empty($already_exists_Record_student)){
                     if ($this->sch_setting_detail->tsc_auto_insert) {
                //if ($this->sch_setting_detail->tsc_update_status) {

                    $transfer_certificate_no = $this->sch_setting_detail->tsc_prefix . $this->sch_setting_detail->tsc_start_from;

                    $last_student         = $this->transfer_certificate_model->lastRecord();
                    $last_transfer_certificate_digit = str_replace($this->sch_setting_detail->tsc_prefix, "", $last_student->transfer_certificate_no);
if(empty($last_student)){
    $transfer_certificate_no                = $this->sch_setting_detail->tsc_prefix . $this->sch_setting_detail->tsc_start_from;
                
}else{
                   // $transfer_certificate_no                = $this->sch_setting_detail->tsc_prefix . sprintf("%0" . $this->sch_setting_detail->tsc_no_digit . "d", $last_transfer_certificate_digit + 1);
                   $last_transfer_certificate_digit = (int) $last_transfer_certificate_digit;
$transfer_certificate_no = $this->sch_setting_detail->tsc_prefix . sprintf("%0" . $this->sch_setting_detail->tsc_no_digit . "d", $last_transfer_certificate_digit + 1);

                   }
                    //$transfer_certificate_no                = $this->sch_setting_detail->tsc_prefix . sprintf("%0" . $this->sch_setting_detail->tsc_no_digit . "d", $last_transfer_certificate_digit + 1);
                    // $data_insert['admission_no'] = $admission_no;
                    // $printstudentpdf['admission_no']=$admission_no;
               // } 
                // else {
                //     $transfer_certificate_no                = $this->sch_setting_detail->tsc_prefix . $this->sch_setting_detail->tsc_start_from;
                //     // $data_insert['admission_no'] = $admission_no;
                //     // $printstudentpdf['admission_no']=$admission_no;
                // }

                $transfer_certificate_no_exists = $this->transfer_certificate_model->check_tsc_exists($transfer_certificate_no);
                if ($transfer_certificate_no_exists) {
                    $transfer_certificate_no = '';
                }
                if(!empty($transfer_certificate_no)){
                     $data_insert = array(
                    'student_session_id'    => $student['student_session_id'],
                    'class_id'      => $this->input->post('class_id'),
                    'section_id'    => $this->input->post('section_id'),
                    'session_id'    => $this->setting_model->getCurrentSession(),
                    'transfer_certificate_no' => $transfer_certificate_no,
                );
                    $this->transfer_certificate_model->add_tsc_no($data_insert);
                }
            }
                    }else{
                        $transfer_certificate_no=$already_exists_Record_student->transfer_certificate_no;
                    }
                    //print_r($student);
    // Retrieve miscellaneous fees for the current student
    $miscellaneousfees = $this->studentfeemaster_model->getStudentMiscellaneousFees($student['student_session_id']);
     $newArray    = $this->studentfeemaster_model->getdate_transport_fee($student['student_session_id']);//$routefees
        $route_fees    = $this->studentfeemaster_model->getAssignFeeRouteBystudnet($student['student_session_id']);
        $newArray_hostel    = $this->studentfeemaster_model->getdate_hostel_fee($student['student_session_id']);// $hostelfees
        $hostel_fees    = $this->studentfeemaster_model->getAssignFeeHostelBystudnet($student['student_session_id']);
       
//$student_feediscount      = $this->feediscount_model->getStudentFeesDiscount($student['student_session_id']);
 $student_discount_fee = $this->feediscount_model->getStudentFeesDiscount($student['student_session_id']);
 $exam=$this->examgroupstudent_model->studentExams($student['student_session_id']);
//  print_r($exam);
//  exit();
 if(!empty($exam)){
 // Accessing the third object (index 2) from the array
$thirdObject = $exam[(count($exam)-1)];//$exam[3];

// Accessing the 'exam' property of the third object
//$exam = $thirdObject->id;

 $examresult=$this->examresult_model->getStudentResultByExam($thirdObject->exam_group_class_batch_exam_id,$thirdObject->id);
        //  studentExams
        //  searchStudentExams
        //  searchStudentByClassSectionSession
}
if(!empty($transfer_certificate_no)){
    $student_due_fee[$index][$student_key]['transfer_certificate_no'] = $transfer_certificate_no;
}
$student_due_fee[$index][$student_key]['total_school_day']=$student['total_school_day'];
$student_due_fee[$index][$student_key]['total_present_day']=$student['total_present_day'];
// echo $student['total_school_day'].'=='.$student['total_present_day']."<br>";
// exit();
 $student_due_fee[$index][$student_key]['student_promoted'] = $student_promoted;
  $student_due_fee[$index][$student_key]['student_Admission'] = $student_Admission;
 
    // Update the current student's array with miscellaneous fees
    $student_due_fee[$index][$student_key]['miscellaneousfees'] = $miscellaneousfees;
     $student_due_fee[$index][$student_key]['newArray'] = $newArray;
      $student_due_fee[$index][$student_key]['route_fees'] = $route_fees;
       $student_due_fee[$index][$student_key]['newArray_hostel'] = $newArray_hostel;
        $student_due_fee[$index][$student_key]['hostel_fees'] = $hostel_fees;
       // $student_due_fee[$index][$student_key]['student_feediscount'] = $student_feediscount;
        $student_due_fee[$index][$student_key]['student_discount_fee'] = $student_discount_fee;
        $student_due_fee[$index][$student_key]['exam'] = $exam;
        if(!empty($exam)){
         $student_due_fee[$index][$student_key]['examresult'] = $examresult;
        }
        // $student_due_fee[$index][$student_key]['subject_groups']=$subject_groups;

        


                }
                
            }
// $data['students']=$students;
// $data['students_array']=$students_array;
$data['student_due_fee']      = $student_due_fee;
                // $data['class_id']             = $class_id;
                // $data['section_id']           = $section_id;
                $data['students_array']           = $students_array;
                $data['subject_groups']=$subject_groups;
            $student_exam_page = $this->load->view('admin/transfer_certificate/_printtransfercertificate', $data, true); 
            $array = array('status' => '1', 'error' => '', 'page' => $student_exam_page);
            echo json_encode($array);
        }
    }
    
    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));
// print_r($this->config_attendance);
// echo "<br><br>new<br><br>";
        foreach ($this->config_attendance as $att_key => $att_value) {

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

//echo $s[1].'==>'.$attendance_key."<br><br>new<br><br>";
            $attendance_key = $att_key;
            


            $r[$attendance_key] = $s[0].'=='.$s[1];
            //$r[$attendance_key]['last_attendance_date']=$s[1];
            
        }
        

        $record[$student_id] = $r;
        //  print_r($record);
        // echo "<br><br>new<br><br>";
        //  exit();

        return $record;
    }

}