File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/academic_year/models/Academic_year_model.php
Back
<?php Class Academic_year_model extends CI_Model{ function getAcademicYears() { $data = $this->db->get_where('academic_years')->result_array(); foreach ($data as $key => $value) { if ($this->db->table_exists('ap_deprecated_units') && $this->db->table_exists('ap_deprecated_overall_ap') ) { $is_deletable = $this->db->get_where('ap_deprecated_units',array('academic_year_id' => $value['id']))->row_array(); if(empty($is_deletable)) $data[$key]['is_deletable'] = 1; else $data[$key]['is_deletable'] = 0; if($data[$key]['is_deletable'] == 1) { $is_deletable = $this->db->get_where('ap_deprecated_overall_ap',array('academic_year_id' => $value['id']))->row_array(); if(empty($is_deletable)) $data[$key]['is_deletable'] = 1; else $data[$key]['is_deletable'] = 0; } } } //pr($data);exit; return $data; } function getCurrentAcademicYear() { $year = $this->db->get_where('academic_years',array('year_start <=' => date('Y-m-d'),'year_end >='=> date('Y-m-d')))->row_array(); if(empty($year)) { $this->session->set_flashdata('error', t('no_active_academic_year_error',1)); redirect('academic_year/listing'); } return $year; } function editAcademic_year($array) { $id = $array['id']; unset($array['id']); return $this->db->update('academic_years', $array, array('id' => $id)); } function addAcademic_year($array) { return $this->db->insert('academic_years', $array); } function bulkAction($array) { $idArray = explode(':', $array['ids']); switch($array['action']){ case 'Delete': foreach($idArray as $id){ $this->db->delete('academic_years', array('id' => $id)); } break; } } function deleteAcademic_year($id) { echo 'deleting academic year'; $this->db->delete('academic_years', array('id' => $id)); echo 'deleteing terms of the year<br/>'; $terms = $this->db->get_where('ay_terms',['ay_id'=>$id])->result_array(); echo 'deleting teacher class arrangement<br/>'; $this->db->delete('tb_tea_class_sub',['ay_id',$id]); echo 'deleting classes<br/>'; $this->db->delete('tb_class',['ac_year_id',$id]); echo 'deleting student form<br/>'; $this->db->delete('sv_student_form',['ay_id',$id]); echo 'deleting student group<br/>'; $this->db->delete('student_group',['ay_id',$id]); echo 'deleting worflowk filledm form<br/>'; $this->db->delete('wf_filled_form',['ay_id',$id]); foreach($terms as $term) { echo 'deleting term data<br/>'; $this->db->delete('tb_tea_class_sub',['term_id'=>$id]); $this->db->delete('sv_student_form',['term_id'=>$id]); echo 'deleting student scroe'; $this->db->delete('student_score',['term_id'=>$id]); echo 'deleting student predict'; $this->db->delete('sr_predict',['term_id'=>$id]); echo 'deleting student conduct'; $this->db->delete('sr_conduct',['term_id'=>$id]); echo 'deleting other student records'; $this->db->delete('sr_details',['term_id'=>$id]); $this->db->delete('ay_terms',['ay_id'=>$id]); } } function getAcademicYear($id) { return $this->db->get_where('academic_years', array('id' => $id))->row_array(); } function getAcademicYearByLabel($label) { return $this->db->get_where('academic_years', array('year_label' => trim($label)))->row_array(); } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.54 |
proxy
|
phpinfo
|
Settings