load->database(); $this->load->library('session'); $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0'); $this->output->set_header('Pragma: no-cache'); } public function index() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($this->session->userdata('admin_login') == 1) { redirect(base_url() . 'admin/panel/', 'refresh'); } } function message($param1 = 'message_home', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'send_new') { $this->session->set_flashdata('flash_message' , get_phrase('message_sent')); $message_thread_code = $this->crud_model->send_new_private_message(); move_uploaded_file($_FILES["file_name"]["tmp_name"], "uploads/messages/" . $_FILES["file_name"]["name"]); redirect(base_url() . 'admin/message/message_read/' . $message_thread_code, 'refresh'); } if ($param1 == 'send_reply') { $this->session->set_flashdata('flash_message' , get_phrase('reply_sent')); $this->crud_model->send_reply_message($param2); move_uploaded_file($_FILES["file_name"]["tmp_name"], "uploads/messages/" . $_FILES["file_name"]["name"]); redirect(base_url() . 'admin/message/message_read/' . $param2, 'refresh'); } if ($param1 == 'message_read') { $page_data['current_message_thread_code'] = $param2; $this->crud_model->mark_thread_messages_read($param2); } $page_data['infouser'] = $param2; $page_data['message_inner_page_name'] = $param1; $page_data['page_name'] = 'message'; $page_data['page_title'] = get_phrase('private_messages'); $this->load->view('backend/index', $page_data); } function admins($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['email'] = $this->input->post('email'); $data['birthday'] = $this->input->post('birthday'); $data['phone'] = $this->input->post('phone'); $data['address'] = $this->input->post('address'); $data['password'] = sha1($this->input->post('password')); $data['owner_status'] = $this->input->post('type'); $this->db->insert('admin', $data); $admin_id = $this->db->insert_id(); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/admin_image/' . $admin_id . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/admins/', 'refresh'); } if ($param1 == 'edit') { $this->crud_model->admin_edit($param2); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/admin_profile/'.$param2 ."/", 'refresh'); } if ($param1 == 'delete') { $this->db->where('admin_id', $param2); $this->db->delete('admin'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/admins/', 'refresh'); } $page_data['page_name'] = 'admins'; $page_data['page_title'] = get_phrase('admins'); $this->load->view('backend/index', $page_data); } function admin_profile($admin_id) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'admin_profile'; $page_data['page_title'] = get_phrase('profile'); $page_data['admin_id'] = $admin_id; $this->load->view('backend/index', $page_data); } function teachers($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['salary'] = $this->input->post('salary'); $data['sex'] = $this->input->post('sex'); $data['address'] = $this->input->post('address'); $data['phone'] = $this->input->post('phone'); $data['email'] = $this->input->post('email'); $data['birthday'] = $this->input->post('birthday'); $data['password'] = sha1($this->input->post('password')); $this->db->insert('teacher', $data); $teacher_id = $this->db->insert_id(); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/teacher_image/' . $teacher_id . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/teachers/', 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['salary'] = $this->input->post('salary'); $data['birthday'] = $this->input->post('birthday'); $data['sex'] = $this->input->post('sex'); $data['address'] = $this->input->post('address'); $data['phone'] = $this->input->post('phone'); $data['email'] = $this->input->post('email'); if($this->input->post('password') != ""){ $data['password'] = sha1($this->input->post('password')); } $this->db->where('teacher_id', $param2); $this->db->update('teacher', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/teacher_image/' . $param2 . '.jpg'); redirect(base_url() . 'admin/teacher_profile/'. $param2, 'refresh'); } if($param1 == 'accept') { $pending = $this->db->get_where('pending_users', array('user_id' => $param2))->result_array(); foreach ($pending as $row) { $data['name'] = $row['name']; $data['email'] = $row['email']; $data['username'] = $row['username']; $data['sex'] = $row['sex']; $data['address'] = $row['address']; $data['password'] = $row['password']; $data['phone'] = $row['phone']; $this->db->insert('teacher', $data); $teacher_id = $this->db->insert_id(); $this->crud_model->account_confirm('teacher', $teacher_id); } $this->db->where('user_id', $param2); $this->db->delete('pending_users'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/teachers/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('teacher_id', $param2); $this->db->delete('teacher'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/teachers/', 'refresh'); } $page_data['teachers'] = $this->db->get('teacher')->result_array(); $page_data['page_name'] = 'teachers'; $page_data['page_title'] = get_phrase('teachers'); $this->load->view('backend/index', $page_data); } function teacher_profile($teacher_id) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'teacher_profile'; $page_data['page_title'] = get_phrase('profile'); $page_data['teacher_id'] = $teacher_id; $this->load->view('backend/index', $page_data); } function parents($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['email'] = $this->input->post('email'); $data['password'] = sha1($this->input->post('password')); $data['phone'] = $this->input->post('phone'); $data['address'] = $this->input->post('address'); $data['profession'] = $this->input->post('profession'); $this->db->insert('parent', $data); $parent_id = $this->db->insert_id(); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/parent_image/' . $parent_id . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/parents/', 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['email'] = $this->input->post('email'); $data['phone'] = $this->input->post('phone'); $data['address'] = $this->input->post('address'); $data['profession'] = $this->input->post('profession'); if($this->input->post('password') != ""){ $data['password'] = sha1($this->input->post('password')); } $this->db->where('parent_id' , $param2); $this->db->update('parent' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/parent_image/' . $param2 . '.jpg'); redirect(base_url() . 'admin/parent_profile/'.$param2."/", 'refresh'); } if($param1 == 'accept') { $pending = $this->db->get_where('pending_users', array('user_id' => $param2))->result_array(); foreach ($pending as $row) { $data['name'] = $row['name']; $data['email'] = $row['email']; $data['username'] = $row['username']; $data['profession'] = $row['profession']; $data['address'] = $row['address']; $data['password'] = $row['password']; $data['phone'] = $row['phone']; $this->db->insert('parent', $data); $parent_id = $this->db->insert_id(); $this->crud_model->account_confirm('parent', $parent_id); } $this->db->where('user_id', $param2); $this->db->delete('pending_users'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/parents/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('parent_id' , $param2); $this->db->delete('parent'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/parents/', 'refresh'); } $page_data['page_title'] = get_phrase('parents'); $page_data['page_name'] = 'parents'; $this->load->view('backend/index', $page_data); } function marks() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'marks'; $page_data['page_title'] = get_phrase('marks'); $this->load->view('backend/index', $page_data); } function notify($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'markssms') { $sms_status = $this->db->get_where('settings' , array('type' => 'sms_status'))->row()->description; $year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; require_once 'smsGateway.php'; $email = $this->db->get_where('settings' , array('type' => 'android_email'))->row()->description; $pass = $this->db->get_where('settings' , array('type' => 'android_password'))->row()->description; $device = $this->db->get_where('settings' , array('type' => 'android_device'))->row()->description; $object = new SmsGateway($email, $pass); $class_id = $this->input->post('class_id'); $receiver = $this->input->post('receiver'); $students = $this->db->get_where('enroll' , array('class_id' => $class_id, 'year' => $year))->result_array(); $nums = array(); $message = $this->input->post('message'); foreach ($students as $row) { if ($receiver == 'student') { $phones = $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->phone; } if ($receiver == 'parent') { $parent_id = $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->parent_id; $phones = $this->db->get_where('parent' , array('parent_id' => $parent_id))->row()->phone; } array_push($nums, $phones); if ($sms_status == 'twilio') { $this->crud_model->twilio("".$message."","".$phones.""); }else if ($sms_status == 'clickatell') { $this->crud_model->clickatell($message,$phones); } } if ($sms_status == 'android') { $result = $object->sendMessageToManyNumbers($nums, $message, $device); } $this->session->set_flashdata('flash_message' , get_phrase('sent_successfully')); redirect(base_url() . 'admin/notify/', 'refresh'); } if($param1 == 'bulkemail') { $this->crud_model->bulk_email($this->input->post('type'), $this->input->post('subject'), $this->input->post('message')); $this->session->set_flashdata('flash_message' , get_phrase('sent_successfully')); redirect(base_url() . 'admin/notify/', 'refresh'); } $page_data['page_name'] = 'notify'; $page_data['page_title'] = get_phrase('notifications'); $this->load->view('backend/index', $page_data); } function parent_profile($parent_id) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['parent_id'] = $parent_id; $page_data['page_name'] = 'parent_profile'; $page_data['page_title'] = get_phrase('profile'); $this->load->view('backend/index', $page_data); } function delete_student($student_id, $class_id) { $tables = array('student', 'attendance', 'enroll', 'invoice', 'mark', 'payment', 'students_request', 'student_question', 'reporte_alumnos'); $this->db->delete($tables, array('student_id' => $student_id)); $threads = $this->db->get('message_thread')->result_array(); if (count($threads) > 0) { foreach ($threads as $row) { $sender = explode('-', $row['sender']); $receiver = explode('-', $row['reciever']); if (($sender[0] == 'student' && $sender[1] == $student_id) || ($receiver[0] == 'student' && $receiver[1] == $student_id)) { $thread_code = $row['message_thread_code']; $this->db->delete('message', array('message_thread_code' => $thread_code)); $this->db->delete('message_thread', array('message_thread_code' => $thread_code)); } } } $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/students_area/', 'refresh'); } function attendance_selector() { $data['class_id'] = $this->input->post('class_id'); $data['year'] = $this->input->post('year'); $originalDate =$this->input->post('timestamp'); $newDate = date("d-m-Y", strtotime($originalDate)); $data['timestamp'] = strtotime($newDate); $data['section_id'] = $this->input->post('section_id'); $query = $this->db->get_where('attendance' ,array( 'class_id'=>$data['class_id'], 'section_id'=>$data['section_id'], 'year'=>$data['year'], 'timestamp'=>$data['timestamp'])); if($query->num_rows() < 1) { $students = $this->db->get_where('enroll' , array('class_id' => $data['class_id'] , 'section_id' => $data['section_id'] , 'year' => $data['year']))->result_array(); foreach($students as $row) { $attn_data['class_id'] = $data['class_id']; $attn_data['year'] = $data['year']; $attn_data['timestamp'] = $data['timestamp']; $attn_data['section_id'] = $data['section_id']; $attn_data['student_id'] = $row['student_id']; $this->db->insert('attendance' , $attn_data); } } redirect(base_url().'admin/manage_attendance/'.$data['class_id'].'/'.$data['section_id'].'/'.$data['timestamp'],'refresh'); } function attendance_update($class_id = '' , $section_id = '' , $timestamp = '') { require_once 'smsGateway.php'; $email = $this->db->get_where('settings' , array('type' => 'android_email'))->row()->description; $pass = $this->db->get_where('settings' , array('type' => 'android_password'))->row()->description; $device = $this->db->get_where('settings' , array('type' => 'android_device'))->row()->description; $object = new SmsGateway($email, $pass); $sms_status = $this->db->get_where('settings' , array('type' => 'sms_status'))->row()->description; $notify = $this->db->get_where('settings' , array('type' => 'absences'))->row()->description; $running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $attendance_of_students = $this->db->get_where('attendance' , array('class_id'=>$class_id,'section_id'=>$section_id,'year'=>$running_year,'timestamp'=>$timestamp))->result_array(); foreach($attendance_of_students as $row) { $attendance_status = $this->input->post('status_'.$row['attendance_id']); $this->db->where('attendance_id' , $row['attendance_id']); $this->db->update('attendance' , array('status' => $attendance_status)); if ($attendance_status == 2) { $student_name = $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->name; $parent_id = $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->parent_id; $parent_em = $this->db->get_where('parent' , array('parent_id' => $parent_id))->row()->email; $receiver = $this->db->get_where('parent' , array('parent_id' => $parent_id))->row()->phone; $message = 'Su hijo' . ' ' . $student_name . ' esta ausente el día de hoy.'; if($notify == 1) { if ($sms_status == 'android') { $result = $object->sendMessageToNumber($receiver, $message, $device); } else if ($sms_status == 'twilio') { $this->crud_model->twilio($message,"".$receiver.""); } else if ($sms_status == 'clickatell') { $this->crud_model->clickatell($message,$receiver); } } $this->crud_model->attendance($student_name, "".$parent_em.""); } } $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url().'admin/manage_attendance/'.$class_id.'/'.$section_id.'/'.$timestamp , 'refresh'); } function update_news($code) { if($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['code'] = $code; $page_data['page_name'] = 'update_news'; $page_data['page_title'] = get_phrase('update_news'); $this->load->view('backend/index', $page_data); } function database($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'restore') { $this->crud_model->import_db(); $this->session->set_flashdata('flash_message' , get_phrase('restored')); redirect(base_url() . 'admin/database/', 'refresh'); } if($param1 == 'create') { $this->crud_model->create_backup(); $this->session->set_flashdata('flash_message' , get_phrase('backup_created')); redirect(base_url() . 'admin/database/', 'refresh'); } $page_data['page_name'] = 'database'; $page_data['page_title'] = get_phrase('database'); $this->load->view('backend/index', $page_data); } function panel() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'panel'; $page_data['page_title'] = get_phrase('dashboard'); $this->load->view('backend/index', $page_data); } function sms($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'update') { $data['description'] = $this->input->post('sms_status'); $this->db->where('type' , 'sms_status'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/sms/', 'refresh'); } if($param1 == 'android') { $data['description'] = $this->input->post('android_email'); $this->db->where('type' , 'android_email'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('android_password'); $this->db->where('type' , 'android_password'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('android_device'); $this->db->where('type' , 'android_device'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/sms/', 'refresh'); } if($param1 == 'clickatell') { $data['description'] = $this->input->post('clickatell_username'); $this->db->where('type' , 'clickatell_username'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('clickatell_password'); $this->db->where('type' , 'clickatell_password'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('clickatell_api'); $this->db->where('type' , 'clickatell_api'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/sms/', 'refresh'); } if($param1 == 'twilio') { $data['description'] = $this->input->post('twilio_account'); $this->db->where('type' , 'twilio_account'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('authentication_token'); $this->db->where('type' , 'authentication_token'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('registered_phone'); $this->db->where('type' , 'registered_phone'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/sms/', 'refresh'); } if($param1 == 'services') { $data['description'] = $this->input->post('absences'); $this->db->where('type' , 'absences'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('students_reports'); $this->db->where('type' , 'students_reports'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('p_new_invoice'); $this->db->where('type' , 'p_new_invoice'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('new_homework'); $this->db->where('type' , 'new_homework'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('s_new_invoice'); $this->db->where('type' , 's_new_invoice'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/sms/', 'refresh'); } $page_data['page_name'] = 'sms'; $page_data['page_title'] = get_phrase('sms'); $this->load->view('backend/index', $page_data); } function email($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'template') { $data['subject'] = $this->input->post('subject'); $data['body'] = $this->input->post('body'); $this->db->where('email_template_id', $param2); $this->db->update('email_template', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/email/', 'refresh'); } if ($param1 == 'update') { $this->load->helper('file'); $data = 'input->post('smtp_host').'";'."\n".'' .'$config["smtp_user"] ="'.$this->input->post('smtp_user').'";'."\n".'' .'$config["smtp_pass"] ="'.$this->input->post('smtp_pass').'";'."\n".'' .'$config["smtp_port"] ="'.$this->input->post('smtp_port').'";'."\n".'' .'$config["smtp_timeout"] ="'.$this->input->post('smtp_timeout').'";'."\n".'' .'$config["wordwrap"] = "TRUE";'."\n".'' .'$config["wrapchars"] = "76";'."\n".'' .'$config["mailtype"] ="'.$this->input->post('mail_type').'";'."\n".'' .'$config["charset"] ="'.$this->input->post('char_set').'";'."\n".'' .'$config["validate"] = "FALSE";'."\n".'' .'$config["priority"] = "3";'."\n".'' .'$config["crlf"] = "\r\n";'."\n".'' .'$config["newline"]="'. '\r\n'.'";'."\n".'' .'$config["bcc_batch_mode"] ="'. 'FALSE' .'";'."\n".'' .'$config["bcc_batch_size"] ="'. '200' .'";'."\n".''; if ( ! write_file('./application/config/email.php', $data)) { $this->session->set_flashdata('error_message', 'Error'); redirect(base_url() . 'admin/email/', 'refresh'); } else { $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/email/', 'refresh'); } } $page_data['page_name'] = 'email'; $page_data['current_email_template_id'] = 1; $page_data['page_title'] = get_phrase('email_settings'); $this->load->view('backend/index', $page_data); } function view_teacher_report() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'view_teacher_report'; $page_data['page_title'] = get_phrase('teacher_report'); $this->load->view('backend/index', $page_data); } function translate($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'update') { $page_data['edit_profile'] = $param2; } if ($param1 == 'update_phrase') { $language = $param2; $total_phrase = $this->input->post('total_phrase'); for($i = 1 ; $i < $total_phrase ; $i++) { $this->db->where('phrase_id' , $i); $this->db->update('language' , array($language => $this->input->post('phrase'.$i))); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/translate/update/'.$language, 'refresh'); } if ($param1 == 'do_update') { $language = $this->input->post('language'); $data[$language] = $this->input->post('phrase'); $this->db->where('phrase_id', $param2); $this->db->update('language', $data); $this->session->set_flashdata('flash_message', ""); redirect(base_url() . 'admin/translate/', 'refresh'); } $page_data['page_name'] = 'translate'; $page_data['page_title'] = get_phrase('translate'); $this->load->view('backend/index', $page_data); } function polls($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'create') { $db['status'] = 0; $this->db->update('polls', $db); $data['question'] = $this->input->post('question'); foreach ($this->input->post('options') as $row) { $data['options'] .= $row . ','; } $data['user'] = $this->input->post('user'); $data['status'] = 1; $data['date'] = date('d M, Y'); $data['poll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $this->db->insert('polls', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/polls/', 'refresh'); } if($param1 == 'response') { $data['poll_code'] = $this->input->post('poll_code'); $data['answer'] = $this->input->post('answer'); $user = $this->session->userdata('login_user_id'); $user_type = $this->session->userdata('login_type'); $data['user'] = $user_type ."-".$user; $data['date'] = date('d M, Y'); $this->db->insert('poll_response', $data); } if($param1 == 'delete') { $this->db->where('poll_code', $param2); $this->db->delete('polls'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/polls/', 'refresh'); } $page_data['page_name'] = 'polls'; $page_data['page_title'] = get_phrase('polls'); $this->load->view('backend/index', $page_data); } function view_poll($code) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['code'] = $code; $page_data['page_name'] = 'view_poll'; $page_data['page_title'] = get_phrase('poll_details'); $this->load->view('backend/index', $page_data); } function admissions($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'reject') { $this->db->where('user_id', $param2); $this->db->delete('pending_users'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/admissions/', 'refresh'); } $page_data['page_name'] = 'admissions'; $page_data['page_title'] = get_phrase('admissions'); $this->load->view('backend/index', $page_data); } function teacher_routine() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $teacher_id = $this->input->post('teacher_id'); $page_data['page_name'] = 'teacher_routine'; $page_data['teacher_id'] = $teacher_id; $page_data['page_title'] = get_phrase('teacher_routine'); $this->load->view('backend/index', $page_data); } function add_student() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'add_student'; $page_data['page_title'] = get_phrase('add_student'); $this->load->view('backend/index', $page_data); } function get_class_area() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $id = $this->input->post('class_id'); redirect(base_url() . 'admin/students_area/'.$id."/", 'refresh'); } function student_bulk($param1 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if($param1 == 'add_bulk_student') { $names = $this->input->post('name'); $rolls = $this->input->post('roll'); $emails = $this->input->post('username'); $passwords = $this->input->post('password'); $date = strtotime(date("d M,Y")); $phones = $this->input->post('phone'); $genders = $this->input->post('sex'); $student_entries = sizeof($names); for($i = 0; $i < $student_entries; $i++) { $data['name'] = $names[$i]; $data['username'] = $emails[$i]; $data['password'] = sha1($passwords[$i]); $data['date'] = strtotime(date("d M,Y")); $data['phone'] = $phones[$i]; $data['sex'] = $genders[$i]; if($data['name'] == '' || $data['username'] == '' || $data['password'] == '') continue; $this->db->insert('student' , $data); $student_id = $this->db->insert_id(); $data2['enroll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data2['student_id'] = $student_id; $data2['class_id'] = $this->input->post('class_id'); if($this->input->post('section_id') != '') { $data2['section_id'] = $this->input->post('section_id'); } $data2['roll'] = $rolls[$i]; $data2['date_added'] = strtotime(date("Y-m-d H:i:s")); $data2['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('enroll' , $data2); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/students_area/' . $this->input->post('class_id')."/" , 'refresh'); } if($param1 == 'excel') { move_uploaded_file($_FILES['excel']['tmp_name'], 'uploads/excel.xlsx'); include 'simplexlsx.class.php'; $xlsx = new SimpleXLSX('uploads/excel.xlsx'); list($num_cols, $num_rows) = $xlsx->dimension(); $f = 0; foreach( $xlsx->rows() as $r ) { if ($f == 0) { $f++; continue; } for( $i=0; $i < $num_cols; $i++ ) { if ($i == 0) $data['name'] = $r[$i]; else if ($i == 1) $data['username'] = $r[$i]; else if($i == 2) $data['password'] = sha1($r[$i]); else if($i == 3) $data['phone'] = $r[$i]; else if($i == 4) $data['sex'] = $r[$i]; else if($i == 5) $data['date'] = strtotime(date("d M,Y")); } $this->db->insert('student' , $data); $student_id = $this->db->insert_id(); for($x=0; $x < $num_cols; $x++) { $data2['roll'] = $r[$x]; $data2['enroll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data2['student_id'] = $student_id; $data2['class_id'] = $this->input->post('class_id'); $data2['section_id'] = $this->input->post('section_id'); $data2['date_added'] = strtotime(date("Y-m-d H:i:s")); $data2['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; } $this->db->insert('enroll' , $data2); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/add_student/', 'refresh'); } $page_data['page_name'] = 'student_bulk'; $page_data['page_title'] = get_phrase('student_bulk'); $this->load->view('backend/index', $page_data); } function student_portal($student_id, $param1='') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $class_id = $this->db->get_where('enroll' , array('student_id' => $student_id , 'year' => $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description))->row()->class_id; $student_name = $this->db->get_where('student' , array('student_id' => $student_id))->row()->name; $class_name = $this->db->get_where('class' , array('class_id' => $class_id))->row()->name; $system = $this->db->get_where('settings' , array('type'=>'system_name'))->row()->description; $page_data['page_name'] = 'student_portal'; $page_data['page_title'] = get_phrase('student_portal'); $page_data['student_id'] = $student_id; $page_data['class_id'] = $class_id; $this->load->view('backend/index', $page_data); } function get_sections($class_id) { $page_data['class_id'] = $class_id; $this->load->view('backend/admin/student_bulk_sections' , $page_data); } function my_account($param1 = "", $page_id = "") { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page' , current_url()); redirect(base_url(), 'refresh'); } if($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['email'] = $this->input->post('email'); $data['phone'] = $this->input->post('phone'); $data['address'] = $this->input->post('address'); $data['birthday'] = $this->input->post('birthday'); if($this->input->post('password') != "") { $data['password'] = sha1($this->input->post('password')); } $this->db->where('admin_id', $this->session->userdata('login_user_id')); $this->db->update('admin', $data); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/admin_image/' . $this->session->userdata('login_user_id') . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/my_account/', 'refresh'); } $data['page_name'] = 'my_account'; $data['page_title'] = get_phrase('profile'); $this->load->view('backend/index', $data); } function request($param1 = "", $param2 = "") { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == "accept") { $data['status'] = 1; $this->db->update('request', $data, array('request_id' => $param2)); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/request/', 'refresh'); } if ($param1 == "reject") { $data['status'] = 2; $this->db->update('request', $data, array('request_id' => $param2)); $this->session->set_flashdata('flash_message' , get_phrase('rejected_successfully')); redirect(base_url() . 'admin/request/', 'refresh'); } $data['page_name'] = 'request'; $data['page_title'] = get_phrase('permissions'); $this->load->view('backend/index', $data); } function request_student($param1 = "", $param2 = "") { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == "accept") { $data['status'] = 1; $this->db->update('students_request', $data, array('request_id' => $param2)); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/request/', 'refresh'); } if ($param1 == "reject") { $data['status'] = 2; $this->db->update('students_request', $data, array('request_id' => $param2)); $this->session->set_flashdata('flash_message' , get_phrase('rejected_successfully')); redirect(base_url() . 'admin/request/', 'refresh'); } if($param1 == 'delete') { $this->db->where('report_code',$param2); $this->db->delete('report_response'); $this->db->where('code',$param2); $this->db->delete('reports'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/request_student/', 'refresh'); } if($param1 == 'delete_teacher') { $this->db->where('report_code',$param2); $this->db->delete('reporte_alumnos'); $this->db->where('report_code',$param2); $this->db->delete('reporte_mensaje'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/request_student/', 'refresh'); } $data['page_name'] = 'request_student'; $data['page_title'] = get_phrase('reports'); $this->load->view('backend/index', $data); } function create_report_message($code = '') { $data['message'] = $this->input->post('message'); $data['report_code'] = $this->input->post('report_code'); $data['timestamp'] = date("d M, Y"); $data['sender_type'] = $this->session->userdata('login_type'); $data['sender_id'] = $this->session->userdata('login_user_id'); return $this->db->insert('reporte_mensaje', $data); } function view_report($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if($param1 == 'update') { $data['status'] = 1; $this->db->where('report_code', $param2); $this->db->update('reporte_alumnos', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/view_report/'.$param2, 'refresh'); } $page_data['report_code'] = $param1; $page_data['page_title'] = get_phrase('report_details'); $page_data['page_name'] = 'view_report'; $this->load->view('backend/index', $page_data); } function invoice($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['student_id'] = $this->input->post('student_id'); $data['class_id'] = $this->input->post('class_id'); $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['amount'] = $this->input->post('amount'); $data['amount_paid'] = $this->input->post('amount_paid'); $data['due'] = $data['amount'] - $data['amount_paid']; $data['status'] = $this->input->post('status'); $data['creation_timestamp'] = strtotime($this->input->post('date')); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('invoice', $data); $invoice_id = $this->db->insert_id(); $data2['invoice_id'] = $invoice_id; $data2['student_id'] = $this->input->post('student_id'); $data2['title'] = $this->input->post('title'); $data2['description'] = $this->input->post('description'); $data2['payment_type'] = 'income'; $data2['method'] = $this->input->post('method'); $data2['amount'] = $this->input->post('amount_paid'); $data2['timestamp'] = strtotime($this->input->post('date')); $data2['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('payment' , $data2); $student_name = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->name; $student_email = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->email; $student_phone = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->phone; $parent_id = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->parent_id; $parent_phone = $this->db->get_where('parent', array('parent_id' => $parent_id))->row()->phone; $parent_email = $this->db->get_where('parent', array('parent_id' => $parent_id))->row()->email; $notify = $this->db->get_where('settings' , array('type' => 'p_new_invoice'))->row()->description; $notify2 = $this->db->get_where('settings' , array('type' => 's_new_invoice'))->row()->description; $message = "A new invoice has been generated for " . $student_name; require_once 'smsGateway.php'; $email = $this->db->get_where('settings' , array('type' => 'android_email'))->row()->description; $pass = $this->db->get_where('settings' , array('type' => 'android_password'))->row()->description; $device = $this->db->get_where('settings' , array('type' => 'android_device'))->row()->description; $object = new SmsGateway($email, $pass); $sms_status = $this->db->get_where('settings' , array('type' => 'sms_status'))->row()->description; if($notify == 1) { if ($sms_status == 'android') { $result = $object->sendMessageToNumber($parent_phone, $message, $device); } else if ($sms_status == 'twilio') { $this->crud_model->twilio($message,"".$parent_phone.""); } else if ($sms_status == 'clickatell') { $this->crud_model->clickatell($message,$parent_phone); } } $this->crud_model->parent_new_invoice($student_name, "".$parent_email.""); if($notify2 == 1) { if ($sms_status == 'android') { $result = $object->sendMessageToNumber($student_phone, $message, $device); } else if ($sms_status == 'twilio') { $this->crud_model->twilio($message,"".$student_phone.""); } else if ($sms_status == 'clickatell') { $this->crud_model->clickatell($message,$student_phone); } } $this->crud_model->student_new_invoice($student_name, "".$student_email.""); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/payments', 'refresh'); } if ($param1 == 'do_update') { $data['student_id'] = $this->input->post('student_id'); $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['amount'] = $this->input->post('amount'); $data['status'] = $this->input->post('status'); $this->db->where('invoice_id', $param2); $this->db->update('invoice', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/students_payments/', 'refresh'); }else if ($param1 == 'edit') { $page_data['edit_data'] = $this->db->get_where('invoice', array('invoice_id' => $param2))->result_array(); } if ($param1 == 'delete') { $this->db->where('invoice_id', $param2); $this->db->delete('invoice'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/students_payments/', 'refresh'); } $page_data['page_name'] = 'invoice'; $this->db->order_by('creation_timestamp', 'desc'); $page_data['invoices'] = $this->db->get('invoice')->result_array(); $this->load->view('backend/index', $page_data); } function invoice_details($id) { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $page_data['invoice_id'] = $id; $page_data['page_title'] = get_phrase('invoice_details'); $page_data['page_name'] = 'invoice_details'; $this->load->view('backend/index', $page_data); } function looking_report($report_code = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $page_data['code'] = $report_code; $page_data['page_name'] = 'looking_report'; $page_data['page_title'] = get_phrase('report_details'); $this->load->view('backend/index', $page_data); } function students_area($id) { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $id = $this->input->post('class_id'); if ($id == '') { $id = $this->db->get('class')->first_row()->class_id; } $page_data['page_name'] = 'students_area'; $page_data['page_title'] = get_phrase('students_area'); $page_data['id'] = $id; $this->load->view('backend/index', $page_data); } function student($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['birthday'] = $this->input->post('birthday'); $data['date'] = strtotime(date("d M,Y")); $data['sex'] = $this->input->post('sex'); $data['address'] = $this->input->post('address'); $data['phone'] = $this->input->post('phone'); $data['email'] = $this->input->post('email'); $data['password'] = sha1($this->input->post('password')); $data['parent_id'] = $this->input->post('parent_id'); $data['dormitory_id'] = $this->input->post('dormitory_id'); $data['transport_id'] = $this->input->post('transport_id'); $this->db->insert('student', $data); $student_id = $this->db->insert_id(); $data2['student_id'] = $student_id; $data2['enroll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data2['class_id'] = $this->input->post('class_id'); if ($this->input->post('section_id') != '') { $data2['section_id'] = $this->input->post('section_id'); } $data2['roll'] = $this->input->post('roll'); $data2['date_added'] = strtotime(date("Y-m-d H:i:s")); $data2['year'] = $running_year; $this->db->insert('enroll', $data2); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/student_image/' . $student_id . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/add_student/', 'refresh'); } if ($param1 == 'do_update') { $data['name'] = $this->input->post('name'); $data['username'] = $this->input->post('username'); $data['phone'] = $this->input->post('phone'); $data['address'] = $this->input->post('address'); $data['parent_id'] = $this->input->post('parent_id'); $data['birthday'] = $this->input->post('birthday'); $data['dormitory_id'] = $this->input->post('dormitory_id'); $data['transport_id'] = $this->input->post('transport_id'); $data['student_session'] = $this->input->post('student_session'); $data['email'] = $this->input->post('email'); $data['sex'] = $this->input->post('sex'); if($this->input->post('password') != "") { $data['password'] = sha1($this->input->post('password')); } $this->db->where('student_id', $param2); $this->db->update('student', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/student_image/' . $param2 . '.jpg'); $this->crud_model->clear_cache(); redirect(base_url() . 'admin/student_portal/'. $param2, 'refresh'); } if($param1 == 'accept') { $pending = $this->db->get_where('pending_users', array('user_id' => $param2))->result_array(); foreach ($pending as $row) { $data['name'] = $row['name']; $data['email'] = $row['email']; $data['username'] = $row['username']; $data['sex'] = $row['sex']; $data['address'] = $row['address']; $data['password'] = $row['password']; $data['birthday'] = $row['birthday']; $data['parent_id'] = $row['parent_id']; $data['phone'] = $row['phone']; $data['date'] = date('d M, Y'); $this->db->insert('student', $data); $student_id = $this->db->insert_id(); $data2['student_id'] = $student_id; $data2['enroll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data2['class_id'] = $row['class_id']; $data2['section_id'] = $row['section_id']; $data2['roll'] = $row['roll']; $data2['date_added'] = strtotime(date("Y-m-d H:i:s")); $data2['year'] = $running_year; $this->db->insert('enroll', $data2); $this->crud_model->account_confirm('student', $student_id); } $this->db->where('user_id', $param2); $this->db->delete('pending_users'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/students_area/', 'refresh'); } } function student_promotion($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if($param1 == 'promote') { $running_year = $this->input->post('running_year'); $from_class_id = $this->input->post('promotion_from_class_id'); $students_of_promotion_class = $this->db->get_where('enroll' , array('class_id' => $from_class_id , 'year' => $running_year))->result_array(); foreach($students_of_promotion_class as $row) { $enroll_data['enroll_code'] = substr(md5(rand(0, 1000000)), 0, 7); $enroll_data['student_id'] = $row['student_id']; $enroll_data['class_id'] = $this->input->post('promotion_status_'.$row['student_id']); $enroll_data['year'] = $this->input->post('promotion_year'); $enroll_data['date_added'] = strtotime(date("Y-m-d H:i:s")); $this->db->insert('enroll' , $enroll_data); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_promoted')); redirect(base_url() . 'admin/student_promotion' , 'refresh'); } $page_data['page_title'] = get_phrase('student_promotion'); $page_data['page_name'] = 'student_promotion'; $this->load->view('backend/index', $page_data); } function get_students_to_promote($class_id_from , $class_id_to , $running_year , $promotion_year) { $page_data['class_id_from'] = $class_id_from; $page_data['class_id_to'] = $class_id_to; $page_data['running_year'] = $running_year; $page_data['promotion_year'] = $promotion_year; $this->load->view('backend/admin/student_promotion_selector' , $page_data); } function events($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if ($param1 == 'create') { $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['datefrom'] = $this->input->post('datefrom'); $data['dateto'] = $this->input->post('dateto'); $this->db->insert('events', $data); redirect(base_url() . 'admin/events/', 'refresh'); } if ($param1 == 'edit') { $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['datefrom'] = $this->input->post('datefrom'); $data['dateto'] = $this->input->post('dateto'); $this->db->where('event_id' , $param2); $this->db->update('events' , $data); redirect(base_url() . 'admin/events/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('event_id' , $param2); $this->db->delete('events'); redirect(base_url() . 'admin/events/', 'refresh'); } $page_data['page_title'] = get_phrase('add_event'); $page_data['page_name'] = 'events'; $this->load->view('backend/index', $page_data); } function view_marks($student_id = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $class_id = $this->db->get_where('enroll' , array('student_id' => $student_id , 'year' =>$year))->row()->class_id; $page_data['class_id'] = $class_id; $page_data['page_name'] = 'view_marks'; $page_data['page_title'] = get_phrase('marks'); $page_data['student_id'] = $student_id; $this->load->view('backend/index', $page_data); } function subject_marks($data) { $page_data['data'] = $data; $page_data['page_name'] = 'subject_marks'; $page_data['page_title'] = get_phrase('subject_marks'); $this->load->view('backend/index',$page_data); } function courses($param1 = '', $param2 = '' , $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['class_id'] = $this->input->post('class_id'); $data['teacher_id'] = $this->input->post('teacher_id'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('subject', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/courses/', 'refresh'); } if ($param1 == 'update_labs') { $class_id = $this->db->get_where('subject', array('subject_id' => $param2))->row()->class_id; $data['la1'] = $this->input->post('la1'); $data['la2'] = $this->input->post('la2'); $data['la3'] = $this->input->post('la3'); $data['la4'] = $this->input->post('la4'); $data['la5'] = $this->input->post('la5'); $data['la6'] = $this->input->post('la6'); $data['la7'] = $this->input->post('la7'); $data['la8'] = $this->input->post('la8'); $data['la9'] = $this->input->post('la9'); $data['la10'] = $this->input->post('la10'); $this->db->where('subject_id', $param2); $this->db->update('subject', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/marks_upload/'.$this->input->post('exam_id')."/".$class_id."/".$this->input->post('section_id')."/".$param2, 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->where('subject_id', $param2); $this->db->update('subject', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/courses/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('subject_id', $param2); $this->db->delete('subject'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/courses/', 'refresh'); } $class = $this->input->post('class_id'); if ($class == '') { $class = $this->db->get('class')->first_row()->class_id; } $page_data['class'] = $class; $page_data['subjects'] = $this->db->get_where('subject' , array('class_id' => $param1))->result_array(); $page_data['page_name'] = 'coursess'; $page_data['page_title'] = get_phrase('subjects'); $this->load->view('backend/index', $page_data); } function manage_classes($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->insert('class', $data); $class_id = $this->db->insert_id(); $data2['class_id'] = $class_id; $data2['name'] = 'A'; $this->db->insert('section' , $data2); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/manage_classes/', 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->where('class_id', $param2); $this->db->update('class', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/manage_classes/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('class_id', $param2); $this->db->delete('class'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/manage_classes/', 'refresh'); } $page_data['classes'] = $this->db->get('class')->result_array(); $page_data['page_name'] = 'manage_class'; $page_data['page_title'] = get_phrase('manage_class'); $this->load->view('backend/index', $page_data); } function get_subject($class_id) { $subject = $this->db->get_where('subject' , array('class_id' => $class_id))->result_array(); foreach ($subject as $row) { echo '' . $row['name'] . ''; } } function upload_book() { $data['libro_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data['nombre'] = $this->input->post('nombre'); $data['autor'] = $this->input->post('autor'); $data['description'] = $this->input->post('description'); $data['class_id'] = $this->input->post('class_id'); $data['subject_id'] = $this->input->post('subject_id'); $data['uploader_type'] = $this->session->userdata('login_type'); $data['uploader_id'] = $this->session->userdata('login_user_id'); $data['year'] = $this->db->get_where('settings',array('type'=>'running_year'))->row()->description; $data['timestamp'] = strtotime(date("Y-m-d H:i:s")); $files = $_FILES['file_name']; $this->load->library('upload'); $config['upload_path'] = 'uploads/libreria/'; $config['allowed_types'] = '*'; $_FILES['file_name']['name'] = $files['name']; $_FILES['file_name']['type'] = $files['type']; $_FILES['file_name']['tmp_name'] = $files['tmp_name']; $_FILES['file_name']['size'] = $files['size']; $this->upload->initialize($config); $this->upload->do_upload('file_name'); $data['file_name'] = $_FILES['file_name']['name']; $this->db->insert('libreria', $data); redirect(base_url() . 'index.php?admin/virtual_library/' . $data['class_id'] , 'refresh'); } function download_book($libro_code) { $file_name = $this->db->get_where('libreria', array('libro_code' => $libro_code))->row()->file_name; $this->load->helper('download'); $data = file_get_contents("uploads/libreria/" . $file_name); $name = $file_name; force_download($name, $data); } function delete_book($libro_id) { $this->crud_model->delete_book($libro_id); redirect(base_url() . 'admin/virtual_library/' . $data['class_id'] , 'refresh'); } function section($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $class = $this->input->post('class_id'); if ($class == '') { $class = $this->db->get('class')->first_row()->class_id; } if($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->where('section_id', $param2); $this->db->update('section', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/section/', 'refresh'); } $page_data['page_name'] = 'section'; $page_data['page_title'] = get_phrase('sections'); $page_data['class'] = $class; $this->load->view('backend/index', $page_data); } function sections($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['class_id'] = $this->input->post('class_id'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->insert('section' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/section/' . $data['class_id'] ."/", 'refresh'); } if ($param1 == 'edit') { $data['name'] = $this->input->post('name'); $data['class_id'] = $this->input->post('class_id'); $data['teacher_id'] = $this->input->post('teacher_id'); $this->db->where('section_id' , $param2); $this->db->update('section' , $data); redirect(base_url() . 'admin/section/' . $data['class_id'] , 'refresh'); } if ($param1 == 'delete') { $this->db->where('section_id' , $param2); $this->db->delete('section'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/section/' , 'refresh'); } } function get_class_section($class_id) { $sections = $this->db->get_where('section' , array('class_id' => $class_id))->result_array(); echo '' . get_phrase('select') . ''; foreach ($sections as $row) { echo '' . $row['name'] . ''; } } function get_class_stundets($section_id) { $students = $this->db->get_where('enroll' , array('section_id' => $section_id))->result_array(); foreach ($students as $row) { echo '' . $this->db->get_where('student', array('student_id'=> $row['student_id']))->row()->name . ''; } } function get_class_subject($class_id) { $subjects = $this->db->get_where('subject' , array('class_id' => $class_id))->result_array(); foreach ($subjects as $row) { echo '' . $row['name'] . ''; } } function get_class_students($class_id) { $students = $this->db->get_where('enroll' , array( 'class_id' => $class_id , 'year' => $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description ))->result_array(); foreach ($students as $row) { $name = $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->name; echo '' . $name . ''; } } function semesters($param1 = '', $param2 = '' , $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['start'] = $this->input->post('start'); $data['end'] = $this->input->post('end'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('exam', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/semesters/', 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $data['start'] = $this->input->post('start'); $data['end'] = $this->input->post('end'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->where('exam_id', $param2); $this->db->update('exam', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/semesters/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('exam_id', $param2); $this->db->delete('exam'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/semesters/', 'refresh'); } $page_data['exams'] = $this->db->get('exam')->result_array(); $page_data['page_name'] = 'semester'; $page_data['page_title'] = get_phrase('semesters'); $this->load->view('backend/index', $page_data); } function update_book($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['book_id'] = $param1; $page_data['page_name'] = 'update_book'; $page_data['page_title'] = get_phrase('update_book'); $this->load->view('backend/index', $page_data); } function upload_marks() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'upload_marks'; $page_data['page_title'] = get_phrase('upload_marks'); $this->load->view('backend/index', $page_data); } function marks_upload($exam_id = '' , $class_id = '' , $section_id = '' , $subject_id = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['exam_id'] = $exam_id; $page_data['class_id'] = $class_id; $page_data['subject_id'] = $subject_id; $page_data['section_id'] = $section_id; $page_data['page_name'] = 'marks_upload'; $page_data['page_title'] = get_phrase('upload_marks'); $this->load->view('backend/index', $page_data); } function marks_selector() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $data['exam_id'] = $this->input->post('exam_id'); $data['class_id'] = $this->input->post('class_id'); $data['section_id'] = $this->input->post('section_id'); $data['subject_id'] = $this->input->post('subject_id'); $data['year'] = $this->db->get_where('settings' , array('type'=>'running_year'))->row()->description; $students = $this->db->get_where('enroll' , array('class_id' => $data['class_id'] , 'section_id' => $data['section_id'] , 'year' => $data['year']))->result_array(); foreach($students as $row) { $verify_data = array('exam_id' => $data['exam_id'], 'class_id' => $data['class_id'], 'section_id' => $data['section_id'], 'student_id' => $row['student_id'], 'subject_id' => $data['subject_id'], 'year' => $data['year']); $query = $this->db->get_where('mark' , $verify_data); if($query->num_rows() < 1) { $data['student_id'] = $row['student_id']; $this->db->insert('mark' , $data); } } redirect(base_url() . 'admin/marks_upload/' . $data['exam_id'] . '/' . $data['class_id'] . '/' . $data['section_id'] . '/' . $data['subject_id'] , 'refresh'); } function marks_update($exam_id = '' , $class_id = '' , $section_id = '' , $subject_id = '') { $running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $marks_of_students = $this->db->get_where('mark' , array('exam_id' => $exam_id, 'class_id' => $class_id,'section_id' => $section_id, 'year' => $running_year,'subject_id' => $subject_id))->result_array(); foreach($marks_of_students as $row) { $obtained_marks = $this->input->post('marks_obtained_'.$row['mark_id']); $labouno = $this->input->post('lab_uno_'.$row['mark_id']); $labodos = $this->input->post('lab_dos_'.$row['mark_id']); $labotres = $this->input->post('lab_tres_'.$row['mark_id']); $labocuatro = $this->input->post('lab_cuatro_'.$row['mark_id']); $labocinco = $this->input->post('lab_cinco_'.$row['mark_id']); $laboseis = $this->input->post('lab_seis_'.$row['mark_id']); $labosiete = $this->input->post('lab_siete_'.$row['mark_id']); $laboocho = $this->input->post('lab_ocho_'.$row['mark_id']); $comment = $this->input->post('comment_'.$row['mark_id']); $labonueve = $this->input->post('lab_nueve_'.$row['mark_id']); $labototal = $obtained_marks + $labouno + $labodos + $labotres + $labocuatro + $labocinco + $laboseis + $labosiete + $laboocho + $labonueve; $this->db->where('mark_id' , $row['mark_id']); $this->db->update('mark' , array('mark_obtained' => $obtained_marks , 'labuno' => $labouno , 'labdos' => $labodos, 'labtres' => $labotres, 'labcuatro' => $labocuatro, 'labcinco' => $labocinco, 'labseis' => $laboseis , 'labsiete' => $labosiete, 'labocho' => $laboocho, 'labnueve' => $labonueve, 'labtotal' => $labototal, 'comment' => $comment)); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url().'admin/marks_upload/'.$exam_id.'/'.$class_id.'/'.$section_id.'/'.$subject_id , 'refresh'); } function tab_sheet($class_id = '' , $exam_id = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($this->input->post('operation') == 'selection') { $page_data['exam_id'] = $this->input->post('exam_id'); $page_data['class_id'] = $this->input->post('class_id'); if ($page_data['exam_id'] > 0 && $page_data['class_id'] > 0) { redirect(base_url() . 'admin/tab_sheet/' . $page_data['class_id'] . '/' . $page_data['exam_id'] , 'refresh'); } else { redirect(base_url() . 'admin/tab_sheet/', 'refresh'); } } $page_data['exam_id'] = $exam_id; $page_data['class_id'] = $class_id; $page_data['page_info'] = 'Exam marks'; $page_data['page_name'] = 'tab_sheet'; $page_data['page_title'] = get_phrase('tabulation_sheet'); $this->load->view('backend/index', $page_data); } function tab_sheet_print($class_id , $exam_id) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['class_id'] = $class_id; $page_data['exam_id'] = $exam_id; $this->load->view('backend/admin/tab_sheet_print' , $page_data); } function marks_get_subject($class_id) { $page_data['class_id'] = $class_id; $this->load->view('backend/admin/marks_get_subject' , $page_data); } function class_routine($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['class_id'] = $this->input->post('class_id'); if($this->input->post('section_id') != '') { $data['section_id'] = $this->input->post('section_id'); } $subject_id = $this->input->post('subject_id'); $teacher_id = $this->db->get_where('subject', array('subject_id' => $subject_id))->row()->teacher_id; $data['subject_id'] = $this->input->post('subject_id'); $data['time_start'] = $this->input->post('time_start') + (12 * ($this->input->post('starting_ampm') - 1)); $data['time_end'] = $this->input->post('time_end') + (12 * ($this->input->post('ending_ampm') - 1)); $data['time_start_min'] = $this->input->post('time_start_min'); $data['time_end_min'] = $this->input->post('time_end_min'); $data['day'] = $this->input->post('day'); $data['teacher_id'] = $teacher_id; $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('class_routine', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/class_routine_view/', 'refresh'); } if ($param1 == 'update') { $data['time_start'] = $this->input->post('time_start') + (12 * ($this->input->post('starting_ampm') - 1)); $data['time_end'] = $this->input->post('time_end') + (12 * ($this->input->post('ending_ampm') - 1)); $data['time_start_min'] = $this->input->post('time_start_min'); $data['time_end_min'] = $this->input->post('time_end_min'); $data['day'] = $this->input->post('day'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->where('class_routine_id', $param2); $this->db->update('class_routine', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/class_routine_view/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('class_routine_id', $param2); $this->db->delete('class_routine'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/class_routine_view/' . $class_id, 'refresh'); } } function exam_routine($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $data['class_id'] = $this->input->post('class_id'); if($this->input->post('section_id') != '') { $data['section_id'] = $this->input->post('section_id'); } $data['teacher_id'] = $this->db->get_where('subject', array('subject_id' => $this->input->post('subject_id')))->row()->teacher_id; $data['subject_id'] = $this->input->post('subject_id'); $data['time_start'] = $this->input->post('time_start') + (12 * ($this->input->post('starting_ampm') - 1)); $data['time_end'] = $this->input->post('time_end') + (12 * ($this->input->post('ending_ampm') - 1)); $data['time_start_min'] = $this->input->post('time_start_min'); $data['time_end_min'] = $this->input->post('time_end_min'); $data['fecha'] = $this->input->post('fecha'); $data['day'] = $this->input->post('day'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('horarios_examenes', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/looking_routine/', 'refresh'); } if ($param1 == 'update') { $data['time_start'] = $this->input->post('time_start') + (12 * ($this->input->post('starting_ampm') - 1)); $data['time_end'] = $this->input->post('time_end') + (12 * ($this->input->post('ending_ampm') - 1)); $data['time_start_min'] = $this->input->post('time_start_min'); $data['time_end_min'] = $this->input->post('time_end_min'); $data['day'] = $this->input->post('day'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->where('horario_id', $param2); $this->db->update('horarios_examenes', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/looking_routine/', 'refresh'); } if ($param1 == 'delete') { $class_id = $this->db->get_where('horarios_examenes' , array('horario_id' => $param2))->row()->class_id; $this->db->where('horario_id', $param2); $this->db->delete('horarios_examenes'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/looking_routine/', 'refresh'); } } function looking_routine() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $id = $this->input->post('class_id'); if ($id == '') { $id = $this->db->get('class')->first_row()->class_id; } $page_data['page_name'] = 'looking_routine'; $page_data['id'] = $id; $page_data['page_title'] = get_phrase('exam_routine'); $this->load->view('backend/index', $page_data); } function add_exam_routine() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'add_exam_routine'; $page_data['page_title'] = get_phrase('add_exam_routine'); $this->load->view('backend/index', $page_data); } function class_routine_add() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'class_routine_add'; $page_data['page_title'] = ""; $this->load->view('backend/index', $page_data); } function class_routine_view($class_id) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $id = $this->input->post('class_id'); if ($id == '') { $id = $this->db->get('class')->first_row()->class_id; } $page_data['page_name'] = 'class_routine_view'; $page_data['id'] = $id; $page_data['page_title'] = get_phrase('class_routine'); $this->load->view('backend/index', $page_data); } function get_class_section_subject($class_id) { $page_data['class_id'] = $class_id; $this->load->view('backend/admin/class_routine_section_subject_selector' , $page_data); } function section_subject_edit($class_id , $class_routine_id) { $page_data['class_id'] = $class_id; $page_data['class_routine_id'] = $class_routine_id; $this->load->view('backend/admin/class_routine_section_subject_edit' , $page_data); } function attendance() { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $page_data['page_name'] = 'attendance'; $page_data['page_title'] = get_phrase('attendance'); $this->load->view('backend/index', $page_data); } function manage_attendance($class_id = '' , $section_id = '' , $timestamp = '') { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $class_name = $this->db->get_where('class' , array('class_id' => $class_id))->row()->name; $page_data['class_id'] = $class_id; $page_data['timestamp'] = $timestamp; $page_data['page_name'] = 'manage_attendance'; $section_name = $this->db->get_where('section' , array('section_id' => $section_id))->row()->name; $page_data['section_id'] = $section_id; $page_data['page_title'] = get_phrase('attendance'); $this->load->view('backend/index', $page_data); } function get_sectionss($class_id) { $sections = $this->db->get_where('section' , array('class_id' => $class_id))->result_array(); foreach ($sections as $row) { echo '' . $row['name'] . ''; } } function get_section($class_id) { $page_data['class_id'] = $class_id; $this->load->view('backend/admin/manage_attendance_section_holder' , $page_data); } function attendance_report() { $page_data['month'] = date('m'); $page_data['page_name'] = 'attendance_report'; $page_data['page_title'] = get_phrase('attendance_report'); $this->load->view('backend/index',$page_data); } function report_attendance_view($class_id = '' , $section_id = '', $month = '') { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $class_name = $this->db->get_where('class' , array('class_id' => $class_id))->row()->name; $page_data['class_id'] = $class_id; $page_data['month'] = $month; $page_data['page_name'] = 'report_attendance_view'; $section_name = $this->db->get_where('section' , array('section_id' => $section_id))->row()->name; $page_data['section_id'] = $section_id; $page_data['page_title'] = get_phrase('attendance_report'); $this->load->view('backend/index', $page_data); } function news_message($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == 'add') { $this->crud_model->create_news_message($this->input->post('codigo')); } } function notice_message($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == 'add') { $this->crud_model->create_notice_message($param2); } } function news($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == 'create') { $news_code = $this->crud_model->create_news(); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/news/', 'refresh'); } if($param1 == 'create_event') { $this->crud_model->create_event(); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/news/', 'refresh'); } if ($param1 == 'delete') { unlink('uploads/news_images/'.$param2. ".jpg"); $id = $this->db->get_where('news', array('news_code' => $param2))->row()->news_id; $this->db->where('news_code' , $param2); $this->db->delete('news'); $this->db->where('news_id' , $id); $this->db->delete('mensaje_reporte'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/news/', 'refresh'); } $page_data['page_name'] = 'news'; $page_data['page_title'] = get_phrase('noticeboard'); $this->load->view('backend/index', $page_data); } function update($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if ($param1 == 'news') { $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['date'] = date('d, M Y'); $data['users'] = $this->input->post('users'); $this->db->where('news_code', $param2); $this->db->update('news', $data); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/news_images/' . $param2 . '.jpg'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/news/', 'refresh'); } if($param1 == 'event') { $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['date'] = date('d, M Y'); $data['users'] = $this->input->post('users'); $data['from_'] = $this->input->post('from'); $data['to_'] = $this->input->post('to'); $this->db->where('news_code', $param2); $this->db->update('news', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/news_images/' . $param2 . '.jpg'); redirect(base_url() . 'admin/news/', 'refresh'); } } function create_report($param1 = '', $param2 = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } if($param1 == 'send') { $parent_id = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->parent_id; $student_name = $this->db->get_where('student', array('student_id' => $this->input->post('student_id')))->row()->name; $parent_phone = $this->db->get_where('parent', array('parent_id' => $parent_id))->row()->phone; $parent_email = $this->db->get_where('parent', array('parent_id' => $parent_id))->row()->email; $data['student_id'] = $this->input->post('student_id'); $data['class_id'] = $this->input->post('class_id'); $data['section_id'] = $this->input->post('section_id'); $one = 'admin'; $two = $this->session->userdata('login_user_id'); $data['user_id'] = $one."-".$two; $data['title'] = $this->input->post('title'); $data['description'] = $this->input->post('description'); $data['file'] = $_FILES["file_name"]["name"]; $data['date'] = date('d M, Y'); $data['priority'] = $this->input->post('priority'); $data['status'] = 0; $data['code'] = substr(md5(rand(0, 1000000)), 0, 7); $this->db->insert('reports', $data); $this->crud_model->students_reports("".$student_name."", "".$parent_email.""); move_uploaded_file($_FILES["file_name"]["tmp_name"], 'uploads/report_files/'. $_FILES["file_name"]["name"]); $notify = $this->db->get_where('settings' , array('type' => 'students_reports'))->row()->description; if($notify == 1) { $message = "A behavioral report has been created for " . $student_name; require_once 'smsGateway.php'; $email = $this->db->get_where('settings' , array('type' => 'android_email'))->row()->description; $pass = $this->db->get_where('settings' , array('type' => 'android_password'))->row()->description; $device = $this->db->get_where('settings' , array('type' => 'android_device'))->row()->description; $object = new SmsGateway($email, $pass); $sms_status = $this->db->get_where('settings' , array('type' => 'sms_status'))->row()->description; if ($sms_status == 'android') { $result = $object->sendMessageToNumber($parent_phone, $message, $device); } else if ($sms_status == 'twilio') { $this->crud_model->twilio($message,"".$parent_phone.""); } else if ($sms_status == 'clickatell') { $this->crud_model->clickatell($message,$parent_phone); } } $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/request_student/', 'refresh'); } if($param1 == 'response') { $data['report_code'] = $this->input->post('report_code'); $data['message'] = $this->input->post('message'); $data['date'] = date('d M, Y'); $data['sender_type'] = $this->session->userdata('login_type'); $data['sender_id'] = $this->session->userdata('login_user_id'); $this->db->insert('report_response', $data); } if($param1 == 'update') { $data['status'] = 1; $this->db->where('code', $param2); $this->db->update('reports', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/looking_report/'.$param2, 'refresh'); } } function update_events($code) { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'update_events'; $page_data['page_title'] = get_phrase('update_event'); $page_data['code'] = $code; $this->load->view('backend/index', $page_data); } function send_news() { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'enviar_noticia'; $page_data['page_title'] = get_phrase('send_news'); $this->load->view('backend/index', $page_data); } function attendance_report_selector() { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $data['class_id'] = $this->input->post('class_id'); $data['year'] = $this->input->post('year'); $data['month'] = $this->input->post('month'); $data['section_id'] = $this->input->post('section_id'); redirect(base_url().'admin/report_attendance_view/'.$data['class_id'].'/'.$data['section_id'].'/'.$data['month'],'refresh'); } function read($code = "") { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $page_data['page_name'] = 'read'; $page_data['page_title'] = get_phrase('noticeboard'); $page_data['code'] = $code; $this->load->view('backend/index', $page_data); } function unit_content() { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } $id = $this->input->post('class_id'); if ($id == '') { $id = $this->db->get('class')->first_row()->class_id; } $page_data['id'] = $id; $page_data['page_name'] = 'unit_content'; $page_data['page_title'] = get_phrase('syllabus'); $this->load->view('backend/index', $page_data); } function upload_unit_content() { $fileTypes = array('jpg', 'jpeg', 'gif', 'png', 'xlsx', 'pdf', 'doc', 'docx', 'ppt', 'pptx', 'pps', 'ppsx', 'odt', 'xls', 'xlsx', '.mp3', 'wav', 'mp4', 'mov', 'wmv', 'txt'); // Allowed file extensions $fileParts = pathinfo($_FILES['file_name']['name']); if (in_array(strtolower($fileParts['extension']), $fileTypes)) { $data['academic_syllabus_code'] = substr(md5(rand(0, 1000000)), 0, 7); $data['title'] = $this->input->post('title'); $data['class_id'] = $this->input->post('class_id'); $data['subject_id'] = $this->input->post('subject_id'); $data['file_type'] = $this->input->post('file_type'); $data['uploader_type'] = $this->session->userdata('login_type'); $data['uploader_id'] = $this->session->userdata('login_user_id'); $data['year'] = $this->db->get_where('settings',array('type'=>'running_year'))->row()->description; $data['date'] = date("d M, Y"); $files = $_FILES['file_name']; $this->load->library('upload'); $config['upload_path'] = 'uploads/syllabus/'; $config['allowed_types'] = '*'; $_FILES['file_name']['name'] = $files['name']; $_FILES['file_name']['type'] = $files['type']; $_FILES['file_name']['tmp_name'] = $files['tmp_name']; $_FILES['file_name']['size'] = $files['size']; $this->upload->initialize($config); $this->upload->do_upload('file_name'); $data['file_name'] = $_FILES['file_name']['name']; $this->db->insert('academic_syllabus', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_uploaded')); redirect(base_url() . 'admin/unit_content/' , 'refresh'); } else { $this->session->set_flashdata('error_message' , "Extension not allowed."); redirect(base_url() . 'admin/unit_content' , 'refresh'); } } function download_unit_content($academic_syllabus_code) { $file_name = $this->db->get_where('academic_syllabus', array('academic_syllabus_code' => $academic_syllabus_code))->row()->file_name; $this->load->helper('download'); $data = file_get_contents("uploads/syllabus/" . $file_name); $name = $file_name; force_download($name, $data); } function delete_unit_content($academic_syllabus_id) { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $this->crud_model->delete_unit($academic_syllabus_id); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/unit_content/', 'refresh'); } function students_payments($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $page_data['page_name'] = 'students_payments'; $page_data['page_title'] = get_phrase('student_payments'); $this->db->order_by('creation_timestamp', 'desc'); $page_data['invoices'] = $this->db->get('invoice')->result_array(); $this->load->view('backend/index', $page_data); } function payments($param1 = '' , $param2 = '' , $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $page_data['page_name'] = 'payments'; $page_data['page_title'] = get_phrase('payments'); $this->load->view('backend/index', $page_data); } function expense($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if ($param1 == 'create') { $data['title'] = $this->input->post('title'); $data['expense_category_id'] = $this->input->post('expense_category_id'); $data['description'] = $this->input->post('description'); $data['payment_type'] = 'expense'; $data['method'] = $this->input->post('method'); $data['amount'] = $this->input->post('amount'); $data['timestamp'] = strtotime($this->input->post('timestamp')); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->insert('payment' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/expense', 'refresh'); } if ($param1 == 'edit') { $data['title'] = $this->input->post('title'); $data['expense_category_id'] = $this->input->post('expense_category_id'); $data['description'] = $this->input->post('description'); $data['payment_type'] = 'expense'; $data['method'] = $this->input->post('method'); $data['amount'] = $this->input->post('amount'); $data['year'] = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $this->db->where('payment_id' , $param2); $this->db->update('payment' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/expense', 'refresh'); } if ($param1 == 'delete') { $this->db->where('payment_id' , $param2); $this->db->delete('payment'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/expense/', 'refresh'); } $page_data['page_name'] = 'expense'; $page_data['page_title'] = get_phrase('expense'); $this->load->view('backend/index', $page_data); } function expense_category($param1 = '' , $param2 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $this->db->insert('expense_category' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/expense'); } if ($param1 == 'update') { $data['name'] = $this->input->post('name'); $this->db->where('expense_category_id' , $param2); $this->db->update('expense_category' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/expense'); } if ($param1 == 'delete') { $this->db->where('expense_category_id' , $param2); $this->db->delete('expense_category'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/expense'); } $page_data['page_name'] = 'expense'; $page_data['page_title'] = get_phrase('expense'); $this->load->view('backend/index', $page_data); } function teacher_attendance() { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $page_data['page_name'] = 'teacher_attendance'; $page_data['page_title'] = get_phrase('teacher_attendance'); $this->load->view('backend/index', $page_data); } function teacher_attendance_report() { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $page_data['month'] = date('m'); $page_data['page_name'] = 'teacher_attendance_report'; $page_data['page_title'] = get_phrase('teacher_attendance_report'); $this->load->view('backend/index',$page_data); } function teacher_report_selector() { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $data['year'] = $this->input->post('year'); $data['month'] = $this->input->post('month'); $this->session->set_flashdata('flash_message' , "Información generada con éxito"); redirect(base_url().'admin/teacher_report_view/'.$data['month'],'refresh'); } function teacher_report_view($month = '') { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $page_data['month'] = $month; $page_data['page_name'] = 'teacher_report_view'; $page_data['page_title'] = get_phrase('teacher_attendance_report'); $this->load->view('backend/index', $page_data); } function attendance_teacher() { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $data['year'] = $this->input->post('year'); $str = $this->input->post('timestamp'); $originalDate =$this->input->post('timestamp'); $newDate = date("d-m-Y", strtotime($originalDate)); $data['timestamp'] = strtotime($newDate); $query = $this->db->get_where('teacher_attendance' ,array('year'=>$data['year'],'timestamp'=>$data['timestamp'])); if($query->num_rows() < 1) { $teacher = $this->db->get_where('teacher')->result_array(); foreach($teacher as $row) { $attn_data['teacher_id'] = $row['teacher_id']; $attn_data['year'] = $data['year']; $attn_data['timestamp'] = $data['timestamp']; $this->db->insert('teacher_attendance' , $attn_data); } } redirect(base_url().'admin/teacher_attendance_view/'. $data['timestamp'],'refresh'); } function attendance_update2($timestamp = '') { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page', current_url()); redirect(base_url(), 'refresh'); } $running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; $attendance_of = $this->db->get_where('teacher_attendance' , array('year'=>$running_year,'timestamp'=>$timestamp))->result_array(); foreach($attendance_of as $row) { $attendance_status = $this->input->post('status_'.$row['attendance_id']); $this->db->where('attendance_id' , $row['attendance_id']); $this->db->update('teacher_attendance' , array('status' => $attendance_status)); } $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url().'admin/teacher_attendance_view/'.$timestamp , 'refresh'); } function teacher_attendance_view($timestamp = '') { if($this->session->userdata('admin_login')!=1) { redirect(base_url() , 'refresh'); } $page_data['timestamp'] = $timestamp; $page_data['page_name'] = 'teacher_attendance_view'; $page_data['page_title'] = get_phrase('teacher_attendance'); $this->load->view('backend/index', $page_data); } function school_bus($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if ($param1 == 'create') { $data['route_name'] = $this->input->post('route_name'); $data['number_of_vehicle'] = $this->input->post('number_of_vehicle'); $data['driver_name'] = $this->input->post('driver_name'); $data['driver_phone'] = $this->input->post('driver_phone'); $data['route'] = $this->input->post('route'); $data['route_fare'] = $this->input->post('route_fare'); $this->db->insert('transport', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/school_bus/', 'refresh'); } if ($param1 == 'update') { $data['route_name'] = $this->input->post('route_name'); $data['number_of_vehicle'] = $this->input->post('number_of_vehicle'); $data['driver_name'] = $this->input->post('driver_name'); $data['driver_phone'] = $this->input->post('driver_phone'); $data['route'] = $this->input->post('route'); $data['route_fare'] = $this->input->post('route_fare'); $this->db->where('transport_id', $param2); $this->db->update('transport', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/school_bus', 'refresh'); } if ($param1 == 'delete') { $this->db->where('transport_id', $param2); $this->db->delete('transport'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/school_bus/', 'refresh'); } $page_data['transports'] = $this->db->get('transport')->result_array(); $page_data['page_name'] = 'school_bus'; $page_data['page_title'] = get_phrase('school_bus'); $this->load->view('backend/index', $page_data); } function classrooms($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } if ($param1 == 'create') { $data['name'] = $this->input->post('name'); $data['number'] = $this->input->post('number'); $this->db->insert('dormitory', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/classrooms/', 'refresh'); } if ($param1 == 'update') { $data['name'] = $this->input->post('number'); $data['number'] = $this->input->post('name'); $this->db->where('dormitory_id', $param2); $this->db->update('dormitory', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/classrooms/', 'refresh'); } if ($param1 == 'delete') { $this->db->where('dormitory_id', $param2); $this->db->delete('dormitory'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/classrooms/', 'refresh'); } $page_data['dormitories'] = $this->db->get('dormitory')->result_array(); $page_data['page_name'] = 'classroom'; $page_data['page_title'] = get_phrase('classrooms'); $this->load->view('backend/index', $page_data); } function system_settings($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'do_update') { $data['description'] = $this->input->post('system_name'); $this->db->where('type' , 'system_name'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('system_title'); $this->db->where('type' , 'system_title'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('address'); $this->db->where('type' , 'address'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('phone'); $this->db->where('type' , 'phone'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('language'); $this->db->where('type' , 'language'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('currency'); $this->db->where('type' , 'currency'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('paypal_email'); $this->db->where('type' , 'paypal_email'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('system_email'); $this->db->where('type' , 'system_email'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('rtl'); $this->db->where('type' , 'rtl'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('running_year'); $this->db->where('type' , 'running_year'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/system_settings/', 'refresh'); } if($param1 == 'skin') { $data['description'] = $this->input->post('skin'); $this->db->where('type' , 'skin'); $this->db->update('settings' , $data); move_uploaded_file($_FILES['slide1']['tmp_name'], 'uploads/slider/slider1.png'); move_uploaded_file($_FILES['slide2']['tmp_name'], 'uploads/slider/slider2.png'); move_uploaded_file($_FILES['slide3']['tmp_name'], 'uploads/slider/slider3.png'); move_uploaded_file($_FILES['favicon']['tmp_name'], 'uploads/favicon.png'); move_uploaded_file($_FILES['logow']['tmp_name'], 'uploads/logo-white.png'); move_uploaded_file($_FILES['userfile']['tmp_name'], 'uploads/logo.png'); move_uploaded_file($_FILES['avatar']['tmp_name'], 'uploads/user.jpg'); move_uploaded_file($_FILES['bglogin']['tmp_name'], 'uploads/bglogin.jpg'); move_uploaded_file($_FILES['logocolor']['tmp_name'], 'uploads/logo-color.png'); move_uploaded_file($_FILES['icon_white']['tmp_name'], 'uploads/logo-icon.png'); $this->crud_model->clear_cache(); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/system_settings/', 'refresh'); } if($param1 == 'social') { $data['description'] = $this->input->post('facebook'); $this->db->where('type' , 'facebook'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('twitter'); $this->db->where('type' , 'twitter'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('instagram'); $this->db->where('type' , 'instagram'); $this->db->update('settings' , $data); $data['description'] = $this->input->post('youtube'); $this->db->where('type' , 'youtube'); $this->db->update('settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/system_settings/', 'refresh'); } $page_data['page_name'] = 'system_settings'; $page_data['page_title'] = get_phrase('system_settings'); $page_data['settings'] = $this->db->get('settings')->result_array(); $this->load->view('backend/index', $page_data); } function prueba() { } function academic_settings($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) { redirect(base_url(), 'refresh'); } if ($param1 == 'do_update') { $data['description'] = $this->input->post('report_teacher'); $this->db->where('type' , 'report_teacher'); $this->db->update('academic_settings' , $data); $data['description'] = $this->input->post('minium_mark'); $this->db->where('type' , 'minium_mark'); $this->db->update('academic_settings' , $data); $data['description'] = $this->input->post('routine'); $this->db->where('type' , 'routine'); $this->db->update('academic_settings' , $data); $data['description'] = $this->input->post('tabulation'); $this->db->where('type' , 'tabulation'); $this->db->update('academic_settings' , $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/academic_settings/', 'refresh'); } $page_data['page_name'] = 'academic_settings'; $page_data['page_title'] = get_phrase('academic_settings'); $page_data['settings'] = $this->db->get('settings')->result_array(); $this->load->view('backend/index', $page_data); } function library($param1 = '', $param2 = '', $param3 = '') { if ($this->session->userdata('admin_login') != 1) redirect('login', 'refresh'); if ($param1 == 'create') { $fileTypes = array('pdf', 'doc', 'docx', '.mp3', 'wav', 'mp4', 'mov', 'wmv', 'txt'); // Allowed file extensions $fileParts = pathinfo($_FILES['file_name']['name']); if($this->input->post('type') == 'virtual') { if (in_array(strtolower($fileParts['extension']), $fileTypes)) { $data['name'] = $this->input->post('name'); $data['description'] = $this->input->post('description'); $data['price'] = $this->input->post('price'); $data['author'] = $this->input->post('author'); $data['class_id'] = $this->input->post('class_id'); $data['type'] = $this->input->post('type'); $data['file_name'] = $_FILES["file_name"]["name"]; $data['status'] = $this->input->post('status'); move_uploaded_file($_FILES["file_name"]["tmp_name"], "uploads/library/" . $_FILES["file_name"]["name"]); $this->db->insert('book', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_uploaded')); redirect(base_url() . 'admin/library', 'refresh'); } else { $this->session->set_flashdata('error_message' , "Extension not allowed."); redirect(base_url() . 'admin/unit_content' , 'refresh'); } }else { $data['name'] = $this->input->post('name'); $data['description'] = $this->input->post('description'); $data['price'] = $this->input->post('price'); $data['author'] = $this->input->post('author'); $data['class_id'] = $this->input->post('class_id'); $data['type'] = $this->input->post('type'); $data['status'] = $this->input->post('status'); $this->db->insert('book', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_added')); redirect(base_url() . 'admin/library', 'refresh'); } } if ($param1 == 'update') { $fileTypes = array('pdf', 'doc', 'docx', '.mp3', 'wav', 'mp4', 'mov', 'wmv', 'txt'); // Allowed file extensions $fileParts = pathinfo($_FILES['file_name']['name']); if($this->input->post('type') == 'virtual') { if (in_array(strtolower($fileParts['extension']), $fileTypes)) { $data['name'] = $this->input->post('name'); $data['description'] = $this->input->post('description'); $data['price'] = $this->input->post('price'); $data['author'] = $this->input->post('author'); $data['class_id'] = $this->input->post('class_id'); $data['type'] = $this->input->post('type'); $data['file_name'] = $_FILES["file_name"]["name"]; $data['status'] = $this->input->post('status'); move_uploaded_file($_FILES["file_name"]["tmp_name"], "uploads/library/" . $_FILES["file_name"]["name"]); $this->db->where('book_id', $param2); $this->db->update('book', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/update_book/'.$param2, 'refresh'); } else { $this->session->set_flashdata('error_message' , "No extension allowed."); redirect(base_url() . 'admin/update_book/'.$param2, 'refresh'); } }else { $data['name'] = $this->input->post('name'); $data['description'] = $this->input->post('description'); $data['price'] = $this->input->post('price'); $data['author'] = $this->input->post('author'); $data['class_id'] = $this->input->post('class_id'); $data['type'] = $this->input->post('type'); $data['status'] = $this->input->post('status'); $this->db->where('book_id', $param2); $this->db->update('book', $data); $this->session->set_flashdata('flash_message' , get_phrase('successfully_updated')); redirect(base_url() . 'admin/update_book/'.$param2, 'refresh'); } } if ($param1 == 'delete') { $this->db->where('book_id', $param2); $this->db->delete('book'); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/library', 'refresh'); } $id = $this->input->post('class_id'); if ($id == '') { $id = $this->db->get('class')->first_row()->class_id; } $page_data['id'] = $id; $page_data['page_name'] = 'library'; $page_data['page_title'] = get_phrase('library'); $this->load->view('backend/index', $page_data); } function marks_print_view($student_id , $exam_id) { if ($this->session->userdata('admin_login') != 1) { redirect('login', 'refresh'); } $class_id = $this->db->get_where('enroll' , array( 'student_id' => $student_id , 'year' => $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description ))->row()->class_id; $class_name = $this->db->get_where('class' , array('class_id' => $class_id))->row()->name; $page_data['student_id'] = $student_id; $page_data['class_id'] = $class_id; $page_data['exam_id'] = $exam_id; $this->load->view('backend/admin/marks_print_view', $page_data); } function files($task = "", $code = "") { if ($this->session->userdata('admin_login') != 1) { $this->session->set_userdata('last_page' , current_url()); redirect(base_url(), 'refresh'); } if ($task == 'create') { $this->crud_model->teacher_files(); $this->session->set_flashdata('flash_message' , get_phrase('successfully_uploaded')); redirect(base_url() . 'admin/files' , 'refresh'); } if($task == 'download') { $file_name = $this->db->get_where('teacher_files', array('file_code' => $code))->row()->file; $this->load->helper('download'); $data = file_get_contents("uploads/teacher_files/" . $file_name); $name = $file_name; force_download($name, $data); } if ($task == 'delete') { $file_name = $this->db->get_where('teacher_files', array('file_code' => $code))->row()->file; $this->db->where('file_code',$code); $this->db->delete('teacher_files'); unlink('uploads/teacher_files/'.$file_name); $this->session->set_flashdata('flash_message' , get_phrase('successfully_deleted')); redirect(base_url() . 'admin/files'); } $data['page_name'] = 'files'; $data['page_title'] = get_phrase('teacher_files'); $this->load->view('backend/index', $data); } }