File manager

File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/survey/controllers/Students.php

Back
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Students extends MY_Controller { function __construct() { parent::__construct(); $this->load->model('Students/Students_model'); $this->load->model('Subject/Subject_model'); $this->load->model('Form/Form_model'); $this->load->model('Academic_year/Academic_year_model'); $this->load->model('Academic_year/Term_model'); $this->load->model('Class_group/Class_group_model'); $this->load->model('Student_Form_model'); } function all_survey($ay_id=0,$term_id=0) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $ac_years = $this->Academic_year_model->getAcademicYears(); if($ay_id==0) { $ay_id = $this->Academic_year_model->getCurrentAcademicYear()['id']; redirect('/survey/students/all_survey/'.$ay_id); } $data['terms'] = $this->Term_model->getTerms($ay_id); if($term_id==0) { if(!empty($data['terms'])) redirect('/survey/students/all_survey/'.$ay_id . '/' . $data['terms'][0]['id']); } $data['term_id'] = $term_id; $data['ac_years'] = $ac_years; $data['ay_id']=$ay_id; $data['class_forms'] = $this->Student_Form_model->getClassForms($term_id); $data['subject_forms'] = $this->Student_Form_model->getSubjectForms($term_id,"all"); $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "student_survey_all"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "sv_top"; $data['sub_menu'] = "sv_all"; $data['pagetitle'] = ts('all student class survey',1); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function class_listing($ay_id=0, $term_id=0) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $ac_years = $this->Academic_year_model->getAcademicYears(); if($ay_id==0) $ay_id = $this->Academic_year_model->getCurrentAcademicYear()['id']; if($ay_id==0) { redirect('/survey/students/class_listing/'.$ay_id); } $data['terms'] = $this->Term_model->getTerms($ay_id); if($term_id==0) { if(!empty($data['terms'])) redirect('/survey/students/class_listing/'.$ay_id . '/' . $data['terms'][0]['id']); } $data['ac_years'] = $ac_years; $data['terms'] = $this->Term_model->getTerms($ay_id); $data['term_id'] = $term_id; $data['ay_id']=$ay_id; $data['stu_forms'] = $this->Student_Form_model->getClassForms($term_id); $data['classes'] = $this->Class_group_model->getClassesOnly($ay_id); $data['forms'] = $this->Form_model->getForms(); $data['ac_years'] = $this->Academic_year_model->getAcademicYears(); $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "student_class_survey"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "sv_top"; $data['sub_menu'] = "sv_list"; $data['pagetitle'] = ts('student class survey',1); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function subject_listing($ay_id=0, $term_id=0) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $ac_years = $this->Academic_year_model->getAcademicYears(); if($ay_id==0) $ay_id = $this->Academic_year_model->getCurrentAcademicYear()['id']; if($ay_id==0) { redirect('/survey/students/subject_listing/'.$ay_id); } $data['terms'] = $this->Term_model->getTerms($ay_id); if($term_id==0) { if(!empty($data['terms'])) redirect('/survey/students/subject_listing/'.$ay_id . '/' . $data['terms'][0]['id']); } $data['ac_years'] = $ac_years; $data['terms'] = $this->Term_model->getTerms($ay_id); $data['term_id'] = $term_id; $data['ay_id']=$ay_id; $data['stu_forms'] = $this->Student_Form_model->getSubjectForms($term_id); $data['forms'] = $this->Form_model->getForms(); $data['subjects'] = $this->Subject_model->getSubjects(); $data['ac_years'] = $this->Academic_year_model->getAcademicYears(); $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "student_subject_survey"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "sv_top"; $data['sub_menu'] = "sv_list"; $data['pagetitle'] = ts('student subject survey',1); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function class_form($id) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['form_id'] = $id; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "class_form"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "sv_top"; $data['sub_menu'] = "sv_list"; $form = $this->Student_Form_model->getForm($id); $data['form'] = $form; $data['classes'] = $this->Class_group_model->getUserClass($this->session->userdata('id'),$form->ay_id); $data['structure'] = preg_replace(array('/&/','/"/','/'/','/</','/>/'),array('&','"','\'','<','>'),preg_replace("/(^[\r\n]\|[\r\n]+)[\s\t][\r\n]+/", "", $this->Student_Form_model->getFormStructure($id)->structure)); $data['pagetitle'] = ts('student class survey',1); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function subject_form($id) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $data = $this->data; $data['form_id'] = $id; $data['header'] = TRUE; $data['sidebar'] = TRUE; $data['_view'] = "subject_form"; $data['quickbar'] = TRUE; $data['footer'] = TRUE; $data['top_menu'] = "sv_top"; $data['sub_menu'] = "sv_list"; $form = $this->Student_Form_model->getForm($id); $data['form'] = $form; $data['groups'] = $this->Class_group_model->getTermSubjectClassUser($form->term_id,$form->subject_id); $data['structure'] = preg_replace(array('/&/','/"/','/'/','/</','/>/'),array('&','"','\'','<','>'),preg_replace("/(^[\r\n]\|[\r\n]+)[\s\t][\r\n]+/", "", $this->Student_Form_model->getFormStructure($id)->structure)); $data['pagetitle'] = ts('student subject survey',1); $this->load->view('basetemplate', $data); } else { redirect("login"); } } function editing($form,$student) { if($this->session->userdata("user_id")) { echo $this->Student_Form_model->editing($form,$student); } else { redirect("login"); } } function get_answer($form,$student) { if($this->session->userdata("user_id")) { $data = $this->Student_Form_model->getAnswer($form,$student); if(empty($data)) echo json_encode(array('editing'=>0,'answer'=>'','user'=>'')); else echo json_encode(array('editing'=>$data->editing,'answer'=>$data->answer,'user'=>allUsers($data->uid,1))); } else { redirect("login"); } } function get_subjects($form,$student) { if($this->session->userdata("user_id")) { $data = $this->Student_Form_model->getSubjects($form,$student); if(empty($data)) echo json_encode($data); else echo json_encode($data); } else { redirect("login"); } } function add_class($ay_id,$term) { if($this->session->userdata("user_id")) { if($this->Student_Form_model->addClassForm($ay_id,$term)) $this->session->set_flashdata('success', $this->lang->line('user_data_update_success')); else $this->session->set_flashdata('error', $this->lang->line('user_data_update_error')); redirect($_SERVER['HTTP_REFERER']); } else { redirect("login"); } } function add_subject($ay_id,$term) { if($this->session->userdata("user_id")) { if($this->Student_Form_model->addSubjectForm($ay_id,$term)) $this->session->set_flashdata('success', $this->lang->line('user_data_update_success')); else $this->session->set_flashdata('error', $this->lang->line('user_data_update_error')); redirect($_SERVER['HTTP_REFERER']); } else { redirect("login"); } } function delete_subject($form) { if($this->session->userdata("user_id")) { if($this->Student_Form_model->deleteSubjectForm($form)) $this->session->set_flashdata('success', $this->lang->line('user_data_update_success')); else $this->session->set_flashdata('error', $this->lang->line('user_data_update_error')); redirect($_SERVER['HTTP_REFERER']); } else { redirect("login"); } } function delete_class($form) { if($this->session->userdata("user_id")) { if($this->Student_Form_model->deleteClassForm($form)) $this->session->set_flashdata('success', $this->lang->line('user_data_update_success')); else $this->session->set_flashdata('error', $this->lang->line('user_data_update_error')); redirect($_SERVER['HTTP_REFERER']); } else { redirect("login"); } } function save_form() { if($this->session->userdata("user_id")) { $this->Student_Form_model->saveForm(); } else { redirect("login"); } } function getSubjectStudentDT($id) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $this->Student_Form_model->getSubjectStudentDT($id); } else { redirect("login"); } } function getClassStudentDT($id) { if($this->session->userdata("user_id")) { //if(!$this->acl->hasPermission('DELETE_ALL_INVENTORY')) // show_error($this->lang->line('no_permission_error')); $this->Student_Form_model->getClassStudentDT($id); } else { redirect("login"); } } function getStudentSubject($student_id,$term_id) { $this->db->select('sv_student_form.id as sv_form_id, sv_student_form., form.title, form.structure, tb_subjects., student_group.'); $this->db->join('sv_student_form','sv_student_form.term_id = '. $term_id . ' AND student_group.subject_id = sv_student_form.subject_id'); $this->db->join('form' , 'sv_student_form.form_id = form.id'); $this->db->join('tb_subjects' , 'sv_student_form.subject_id = tb_subjects.id'); $result = $this->db->get_where('student_group',['student_id'=>$student_id,'student_group.term_id'=>$term_id])->result_array(); echo json_encode($result); } function getStudentClass($student_id,$ay_id, $term_id) { $this->db->select('sv_student_form.id as sv_form_id, sv_student_form., form., student_class.,tb_class.title'); $this->db->join('sv_student_form','sv_student_form.subject_id =0 and sv_student_form.term_id = '. $term_id); $this->db->join('tb_class','student_class.class_id = tb_class.id'); $this->db->join('form' , 'sv_student_form.form_id = form.id'); $result = $this->db->get_where('student_class',['student_id'=>$student_id,'student_class.ay_id'=>$ay_id])->result_array(); echo json_encode($result); } function import($form) { $form_obj = $this->db->get_where('sv_student_form',['id'=>$form])->row_array(); $template = $form_obj['import_template']; $import = import_xls('answer','./files/tmp_upload'); foreach($import['data'] as $data) { $output = $template; $student = $this->db->get_where('students',['student_no'=>$data[0]])->row_array(); if(!empty($student)) { $sid = $student['id']; foreach($import['header'] as $i=>$key) { $key = addcslashes($key,"()"); $output = preg_replace('/{{{'.$key.'}}}/', $data[$i], $output); } $output = preg_replace('/{{{[a-zA-Z0-9\_\-]+}}}/', '-', $output); $exist = $this->db->get_where('sv_filled_student_form',['form_id'=>$form, 'student_id'=>$sid,'uid'=>$this->session->userdata('id')])->row_array(); if(!empty($exist)) { $this->db->update('sv_filled_student_form',['answer'=>$output],['form_id'=>$form,'editing'=>0,'student_id'=>$sid,'uid'=>$this->session->userdata('id')]); } else { $this->db->insert('sv_filled_student_form',['answer'=>$output,'form_id'=>$form,'editing'=>0,'student_id'=>$sid,'uid'=>$this->session->userdata('id')]); } } } redirect($_SERVER['HTTP_REFERER']); } function get_import_template($id) { $form_obj = $this->db->get_where('sv_student_form',['id'=>$id])->row_array(); $template = $form_obj['import_template']; echo $template; } function save_import_template($id) { $this->db->update('sv_student_form',['import_template'=>$_POST['template']],['id'=>$id]); redirect($_SERVER['HTTP_REFERER']); } }

| ver. 1.4 | Github | . | PHP 7.2.34 | Generation time: 0.39 | proxy | phpinfo | Settings