Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 88

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 215

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 216

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 217

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 218

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 219

Warning: Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php on line 220
load->model('User_model'); $this->load->helper("url"); $this->load->library("pagination"); if (!$this->session->userdata('school_reg_number')) { $this->session->set_flashdata('flash_data', 'You don\'t have access!'); redirect('Welcome'); } } //this function redirecting different pages after users loged in public function index() { } public function create_classes(){ $highest_level=$this->security->xss_clean($this->input->post('level')); $students_type=$this->security->xss_clean($this->input->post('students_type')); $school_type=$this->security->xss_clean($this->input->post('school_type')); $name=$this->security->xss_clean($this->input->post('name')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type', $students_type); $countd=$this->db->count_all_results('primary_class_levels'); if($countd>0){ redirect('User_admin/school_settings?Error'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $count=$this->db->count_all_results('primary_class_levels'); $this->db->where('school_id',$this->session->userdata('school_id')); $counts=$this->db->count_all_results('students_settings'); if($count>0 && $counts>0){ $tudents_types=2; }else{ $tudents_types= $students_type; } for($i=1;$i<=$highest_level;$i++){ if($i==1){ $namee=$name.' I'; }elseif($i==2){ $namee=$name.' II'; }elseif($i==3){ $namee=$name.' III'; }elseif($i==4){ $namee=$name.' IV'; }elseif($i==5){ $namee=$name.' V'; }elseif($i==6){ $namee=$name.' VI'; }elseif($i==7){ $namee=$name.' VII'; } $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $students_type, 'school_type'=>$school_type, 'level'=>$i, 'students_type_name'=>$name, 'name'=>$namee, ); $this->db->insert('primary_class_levels', $data); } $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $tudents_types, 'schoolars_type'=>'No' ); if($count>0 && $counts>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('students_settings', $data1); }else{ $this->db->insert('students_settings', $data1); } redirect('User_admin/school_settings?sent'); } } public function delete_classes(){ $id= base64_decode($_REQUEST['category']); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$id); $this->db->delete('primary_class_levels'); redirect('User_admin/school_settings?deleted'); } public function insert_students_type(){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'schoolars_type'=>'No' ); $this->db->insert('students_settings', $data); redirect('User_admin/students_settings?sent'); } public function insert_students_type1(){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type1')), 'schoolars_type'=>'No' ); $this->db->insert('students_settings', $data); redirect('User_admin/students_settings?sent'); } //upload video... public function upload_logos() { if ( isset($_FILES["file"])) { //if there was an error uploading the file if ($_FILES["file"]["error"] > 0) { echo "Return Code: " . $_FILES["file"]["error"] . "
"; } else { $filename=basename( $_FILES['file']['name']); $new = time().rand(); $ext = pathinfo($filename, PATHINFO_EXTENSION); $target =$new . '_' .$filename; $target = str_replace(" ", "_", $target); $storagename = "./template/school_logos/".$target; move_uploaded_file($_FILES["file"]["tmp_name"], $storagename); function formatBytes($bytes, $precision) { $units = array('B', 'KB', 'MB', 'GB', 'TB'); $bytes = max($bytes, 0); $pow = floor(($bytes ? log($bytes) : 0) / log(1024)); $pow = min($pow, count($units) - 1); // Uncomment one of the following alternatives $bytes /= pow(1024, $pow); // $bytes /= (1 << (10 * $pow)); return round($bytes, $precision) . ' ' . $units[$pow]; } $data = array( 'school_logo'=>$target, ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('schools',$data); redirect('User_admin/general_settings?sent'); } } else { redirect('User_admin/general_settings?not_sent'); } } public function edit_school_info(){ $data = array( 'school_name' => $this->security->xss_clean($this->input->post('school_name')), 'school_type' => $this->security->xss_clean($this->input->post('school_type')), 'school_email' => $this->security->xss_clean($this->input->post('school_email')), 'school_mobile' => $this->security->xss_clean($this->input->post('school_mobile')), 'other_mobile' => $this->security->xss_clean($this->input->post('other_mobile')), 'school_moto' => $this->security->xss_clean($this->input->post('school_moto')), 'school_header' => $this->security->xss_clean($this->input->post('school_header')), 'school_address' => $this->security->xss_clean($this->input->post('school_address')), 'school_location' => $this->security->xss_clean($this->input->post('school_location')), 'country' => $this->security->xss_clean($this->input->post('country')), 'school_website' =>$this->security->xss_clean($this->input->post('school_website')), 'school_reg_number'=>$this->security->xss_clean($this->input->post('school_reg_number')), 'full_name'=>$this->security->xss_clean($this->input->post('full_name')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('schools',$data); redirect('User_admin/general_settings?edited'); } public function insert_streams(){ $data = array( 'school_id' =>$this->session->userdata('school_id'), 'streams' => $this->security->xss_clean($this->input->post('streams')), ); $this->db->insert('stream_settings',$data); redirect('User_admin/students_settings?sent'); } public function insert_mode_of_assessment_ps(){ $mode= $this->security->xss_clean($this->input->post('mode')); $mode1= $this->security->xss_clean($this->input->post('mode1')); $modes= $this->security->xss_clean($this->input->post('modes')); $modet= $this->security->xss_clean($this->input->post('modet')); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type','N'); $cound=$this->db->count_all_results('primary_class_levels'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type','S'); $coundd=$this->db->count_all_results('primary_class_levels'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type','T'); $counddd=$this->db->count_all_results('primary_class_levels'); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } if($cound>0){ if($mode1=='Double'){ $ca_per1= $this->security->xss_clean($this->input->post('ca_percent1')); $exa_per1=$this->security->xss_clean($this->input->post('exam_percent1')); }elseif($mode1=='Single'){ $ca_per1= 100; $exa_per1=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type1'))); $countt=$this->db->count_all_results('assessment_settings'); } if($coundd>0){ if($modes=='Double'){ $ca_pers= $this->security->xss_clean($this->input->post('ca_percents')); $exa_pers=$this->security->xss_clean($this->input->post('exam_percents')); }elseif($modes=='Single'){ $ca_pers= 100; $exa_pers=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_types'))); $countts=$this->db->count_all_results('assessment_settings'); } if($counddd>0){ if($modet=='Double'){ $ca_pert= $this->security->xss_clean($this->input->post('ca_percentt')); $exa_pert=$this->security->xss_clean($this->input->post('exam_percentt')); }elseif($modet=='Single'){ $ca_pert= 100; $exa_pert=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_typet'))); $counttt=$this->db->count_all_results('assessment_settings'); } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $count=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0 && $countt>0 && $countts>0 && $counttt>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'monthly' => $this->security->xss_clean($this->input->post('monthly')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); if($cound>0){ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type1')), 'monthly' => $this->security->xss_clean($this->input->post('monthly1')), 'mode' => $this->security->xss_clean($this->input->post('mode1')), 'ca_percent' => $ca_per1, 'exam_percent' => $exa_per1 ); } if($coundd>0){ $data2 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_types')), 'monthly' => $this->security->xss_clean($this->input->post('monthlys')), 'mode' => $this->security->xss_clean($this->input->post('modes')), 'ca_percent' => $ca_pers, 'exam_percent' => $exa_pers ); } if($counddd>0){ $data3 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_typet')), 'monthly' => $this->security->xss_clean($this->input->post('monthlyt')), 'mode' => $this->security->xss_clean($this->input->post('modet')), 'ca_percent' => $ca_pert, 'exam_percent' => $exa_pert ); } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $this->db->update('assessment_settings', $data); if($cound>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type1'))); $this->db->update('assessment_settings', $data1); } if($coundd>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_types'))); $this->db->update('assessment_settings', $data2); } if($counddd>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_typet'))); $this->db->update('assessment_settings', $data3); } redirect('User_admin/results_settings?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'monthly' => $this->security->xss_clean($this->input->post('monthly')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); if($cound>0){ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type1')), 'monthly' => $this->security->xss_clean($this->input->post('monthly1')), 'mode' => $this->security->xss_clean($this->input->post('mode1')), 'ca_percent' => $ca_per1, 'exam_percent' => $exa_per1 ); } if($coundd>0){ $data2 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_types')), 'monthly' => $this->security->xss_clean($this->input->post('monthlys')), 'mode' => $this->security->xss_clean($this->input->post('modes')), 'ca_percent' => $ca_pers, 'exam_percent' => $exa_pers ); } if($counddd>0){ $data3 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_typet')), 'monthly' => $this->security->xss_clean($this->input->post('monthlyt')), 'mode' => $this->security->xss_clean($this->input->post('modet')), 'ca_percent' => $ca_pert, 'exam_percent' => $exa_pert ); } $this->db->insert('assessment_settings', $data); if($cound>0){ $this->db->insert('assessment_settings', $data1); } if($coundd>0){ $this->db->insert('assessment_settings', $data2); } if($counddd>0){ $this->db->insert('assessment_settings', $data3); } redirect('User_admin/results_settings?sent'); } } public function insert_mode_of_assessment_ss(){ $mode= $this->security->xss_clean($this->input->post('mode2')); $mode1= $this->security->xss_clean($this->input->post('mode3')); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent2')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent2')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } if($mode1=='Double'){ $ca_per1= $this->security->xss_clean($this->input->post('ca_percent3')); $exa_per1=$this->security->xss_clean($this->input->post('exam_percent3')); }elseif($mode1=='Single'){ $ca_per1= 100; $exa_per1=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type2'))); $count=$this->db->count_all_results('assessment_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type3'))); $countt=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0 && $countt>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type2')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type3')), 'mode' => $mode1, 'ca_percent' => $ca_per1, 'exam_percent' => $exa_per1 ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type2'))); $this->db->update('assessment_settings', $data); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type3'))); $this->db->update('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type2')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type3')), 'mode' => $mode1, 'ca_percent' => $ca_per1, 'exam_percent' => $exa_per1 ); $this->db->insert('assessment_settings', $data); $this->db->insert('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); } } public function insert_mode_of_assessment_p(){ $mode= $this->security->xss_clean($this->input->post('mode4')); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent4')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent4')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type4'))); $count=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type4')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type4'))); $this->db->update('assessment_settings', $data); redirect('User_admin/results_settings?sent'); }else{ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type4')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->insert('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); } } public function insert_mode_of_assessment_n(){ $mode= $this->security->xss_clean($this->input->post('mode5')); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent5')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent5')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type5'))); $count=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type5')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type5'))); $this->db->update('assessment_settings', $data); redirect('User_admin/results_settings?sent'); }else{ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type5')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->insert('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); } } public function insert_mode_of_assessment_o(){ $mode= $this->security->xss_clean($this->input->post('mode6')); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent6')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent6')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type6'))); $count=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type6')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type6'))); $this->db->update('assessment_settings', $data); redirect('User_admin/results_settings?sent'); }else{ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type6')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->insert('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); } } public function insert_mode_of_assessment_a(){ $mode= $this->security->xss_clean($this->input->post('mode7')); if($mode=='Double'){ $ca_per= $this->security->xss_clean($this->input->post('ca_percent7')); $exa_per=$this->security->xss_clean($this->input->post('exam_percent7')); }elseif($mode=='Single'){ $ca_per= 100; $exa_per=100; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type7'))); $count=$this->db->count_all_results('assessment_settings'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type7')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type7'))); $this->db->update('assessment_settings', $data); redirect('User_admin/results_settings?sent'); }else{ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type7')), 'mode' => $mode, 'ca_percent' => $ca_per, 'exam_percent' => $exa_per ); $this->db->insert('assessment_settings', $data1); redirect('User_admin/results_settings?sent'); } } public function update_students_type(){ $data = array( 'students_type' => $this->security->xss_clean($this->input->post('students_typee')), ); $this->db->select('students_type'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('students_settings',$data); // $this->db->where('school_id',$this->session->userdata('school_id')); // $this->db->delete('assessment_settings'); // $this->db->delete('evalution_remarks'); // $this->db->delete('evalution_settings'); // $this->db->delete('general_subjects'); // $this->db->delete('grade_settings'); // $this->db->delete('grading_method'); // $this->db->delete('instruction_reports'); // $this->db->delete('stream_settings'); // $this->db->delete('subjects'); redirect('User_admin/students_settings?sent'); } public function update_students_type1(){ $data = array( 'students_type' => $this->security->xss_clean($this->input->post('students_typee1')), ); $this->db->select('students_type'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('students_settings', $data); // $this->db->where('school_id',$this->session->userdata('school_id')); // $this->db->delete('assessment_settings'); // $this->db->delete('evalution_remarks'); // $this->db->delete('evalution_settings'); // $this->db->delete('general_subjects'); // $this->db->delete('grade_settings'); // $this->db->delete('grading_method'); // $this->db->delete('instruction_reports'); // $this->db->delete('stream_settings'); // $this->db->delete('subjects'); redirect('User_admin/students_settings?sent'); } public function insert_schoolars_type(){ $this->db->where('school_id',$this->session->userdata('school_id')); $count=$this->db->count_all_results('students_settings'); if($count==0){ redirect('User_admin/students_settings?set_school_type_first'); }else{ $data = array( 'schoolars_type' => $this->security->xss_clean($this->input->post('schoolars_type')), ); $this->db->select('schoolars_type'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->update('students_settings', $data); redirect('User_admin/students_settings?sent'); } } function delete_grades(){ $id=base64_decode($_REQUEST['type']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type', $id); $this->db->delete('grade_settings'); redirect('User_admin/set_grades?deleted'); } function delete_division(){ $id=base64_decode($_REQUEST['type']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type', $id); $this->db->delete('division_settings'); redirect('User_admin/division_settings?deleted'); } function delete_point(){ $id=base64_decode($_REQUEST['type']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('students_type', $id); $this->db->delete('point_settings'); redirect('User_admin/point_settings?deleted'); } public function insert_grades_ps(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('grade')); $students= $this->security->xss_clean($this->input->post('students_type')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('grade_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('grade_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('grade_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_mark; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/set_grades?Error'); }elseif($start_new>100){ redirect('User_admin/set_grades?Error'); } } } public function insert_grades_ns(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('grade')); $students= $this->security->xss_clean($this->input->post('students_type')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('grade_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('grade_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('grade_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_mark; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/set_grades?Error'); }elseif($start_new>100){ redirect('User_admin/set_grades?Error'); } } } public function insert_point_a(){ $students= 'A'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('point',$this->security->xss_clean($this->input->post('point'))); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('point_settings'); if($count1>0){ redirect('User_admin/point_settings?Error'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'grade' => $this->security->xss_clean($this->input->post('grade')), 'point' => $this->security->xss_clean($this->input->post('point')), 'students_type' => $students, 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('point_settings',$data); redirect('User_admin/point_settings?sent'); } } public function insert_point_o(){ $students= 'O'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('point',$this->security->xss_clean($this->input->post('point'))); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('point_settings'); if($count1>0){ redirect('User_admin/point_settings?Error'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'grade' => $this->security->xss_clean($this->input->post('grade')), 'point' => $this->security->xss_clean($this->input->post('point')), 'students_type' => $students, 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('point_settings',$data); redirect('User_admin/point_settings?sent'); } } public function insert_division_a(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('division')); $students= 'A'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('division_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('division',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('division_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_point' => $this->security->xss_clean($this->input->post('start')), 'end_point' => $this->security->xss_clean($this->input->post('end')), 'division' => $this->security->xss_clean($this->input->post('grade')), 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('division_settings',$data); redirect('User_admin/division_settings?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('division_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_point; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_point' => $this->security->xss_clean($this->input->post('start')), 'end_point' => $this->security->xss_clean($this->input->post('end')), 'division' => $this->security->xss_clean($this->input->post('grade')), 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('division_settings',$data); redirect('User_admin/division_settings?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/division_settings?Error'); }elseif($start_new>21){ redirect('User_admin/division_settings?Error'); } } } public function insert_division_o(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('division')); $students= 'O'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('division_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('division',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('division_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_point' => $this->security->xss_clean($this->input->post('start')), 'end_point' => $this->security->xss_clean($this->input->post('end')), 'division' => $this->security->xss_clean($this->input->post('grade')), 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('division_settings',$data); redirect('User_admin/division_settings?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('division_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_point; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_point' => $this->security->xss_clean($this->input->post('start')), 'end_point' => $this->security->xss_clean($this->input->post('end')), 'division' => $this->security->xss_clean($this->input->post('grade')), 'remark' => $this->security->xss_clean($this->input->post('remark')) ); $this->db->insert('division_settings',$data); redirect('User_admin/division_settings?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/division_settings?Error'); }elseif($start_new>35){ redirect('User_admin/division_settings?Error'); } } } public function insert_grades_o(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('grade')); $students= 'O'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('grade_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('grade_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('grade_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_point; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/set_grades?Error'); }elseif($start_new>100){ redirect('User_admin/set_grades?Error'); } } } public function insert_grades_a(){ $last_grade=''; $start_new=''; $start= $this->security->xss_clean($this->input->post('start')); $end= $this->security->xss_clean($this->input->post('end')); $grade= $this->security->xss_clean($this->input->post('grade')); $students= 'A'; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $count=$this->db->count_all_results('grade_settings'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->where('grade',$this->security->xss_clean($this->input->post('grade'))); $count1=$this->db->count_all_results('grade_settings'); if($count==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students); $this->db->order_by('id','asc'); $get_last_grade=$this->db->get('grade_settings'); foreach( $get_last_grade->result() as $row){ $last_grade=$row->end_mark; $start_new=$last_grade+1; } if($start==$start_new && $count1==0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'start_mark' => $this->security->xss_clean($this->input->post('start')), 'end_mark' => $this->security->xss_clean($this->input->post('end')), 'grade' => $this->security->xss_clean($this->input->post('grade')) ); $this->db->insert('grade_settings',$data); redirect('User_admin/set_grades?sent'); }elseif($start_new<$start || $start_new>$start){ redirect('User_admin/set_grades?Error'); }elseif($start_new>100){ redirect('User_admin/set_grades?Error'); } } } public function evalution_remarks(){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'grade' => $this->security->xss_clean($this->input->post('grade')), 'remark' => $this->security->xss_clean($this->input->post('remark')), ); $this->db->insert('evalution_remarks', $data); redirect('User_admin/evaluation_settings?sent'); } public function register_subjects(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->like('subject_name',$this->security->xss_clean($this->input->post('subject_name'))); $count=$this->db->count_all_results('general_subjects'); if($count>0){ redirect('User_admin/subjects_settings?subject_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_name' => $this->security->xss_clean($this->input->post('subject_name')), 'report_name' => $this->security->xss_clean($this->input->post('report_name')), ); $this->db->insert('general_subjects', $data); redirect('User_admin/subjects_settings?sent'); } } public function register_combination(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->like('combination',$this->security->xss_clean($this->input->post('comb_name'))); $count=$this->db->count_all_results('combinations'); if($count>0){ redirect('User_admin/combinations_settings?comb_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'combination' => $this->security->xss_clean($this->input->post('comb_name')), ); $this->db->insert('combinations', $data); redirect('User_admin/combinations_settings?sent'); } } public function register_income(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->like('name',$this->security->xss_clean($this->input->post('income'))); $count=$this->db->count_all_results('income'); if($count>0){ redirect('User_admin/income_settings?income_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'name' => $this->security->xss_clean($this->input->post('income')), ); $this->db->insert('income', $data); redirect('User_admin/income_settings?sent'); } } public function register_expenses(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->like('name',$this->security->xss_clean($this->input->post('expenses'))); $count=$this->db->count_all_results('expenses'); if($count>0){ redirect('User_admin/expenses_settings?expenses_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'name' => $this->security->xss_clean($this->input->post('expenses')), ); $this->db->insert('expenses', $data); redirect('User_admin/expenses_settings?sent'); } } public function register_values(){ $code=''; if($this->security->xss_clean($this->input->post('code'))==''){ $code='no'; }else{ $code=$this->security->xss_clean($this->input->post('code')); } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('status',0); $this->db->like('evaluation_value',$this->security->xss_clean($this->input->post('evaluation_value'))); $count=$this->db->count_all_results('evalution_settings'); if($count>0){ redirect('User_admin/evaluation_settings?value_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'evaluation_value' => $this->security->xss_clean($this->input->post('evaluation_value')), 'code' =>$code ); $this->db->insert('evalution_settings', $data); redirect('User_admin/evaluation_settings?sent'); } } public function insert_grading_ps(){ $count=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $count=$this->db->count_all_results('grading_method'); $grade1=$this->security->xss_clean($this->input->post('grading1')); $grade2=$this->security->xss_clean($this->input->post('grading2')); if($grade2==''){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'average' => 'Yes', 'division' => 'No' ); if($count>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $this->db->update('grading_method',$data); }else{ $this->db->insert('grading_method',$data); } }elseif($grade1==''){ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'average' => 'No', 'division' => 'Yes' ); if($count>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $this->db->update('grading_method',$data1); }else{ $this->db->insert('grading_method',$data1); } }else{ $data2 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type')), 'average' => 'Yes', 'division' => 'Yes' ); if($count>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $this->db->update('grading_method',$data2); }else{ $this->db->insert('grading_method',$data2); } } redirect('User_admin/results_calculations?sent'); } public function insert_grading__ss(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type2'))); $count=$this->db->count_all_results('grading_method'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type3'))); $countt=$this->db->count_all_results('grading_method'); //echo $count.' '.$countt;exit(); if($count>0 && $countt>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type2')), 'grading' => $this->security->xss_clean($this->input->post('grading2')) ); $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type3')), 'grading' => $this->security->xss_clean($this->input->post('grading3')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type2'))); $this->db->update('grading_method', $data); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type3'))); $this->db->update('grading_method', $data1); redirect('User_admin/results_calculations?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type2')), 'grading' => $this->security->xss_clean($this->input->post('grading2')) ); $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type3')), 'grading' => $this->security->xss_clean($this->input->post('grading3')) ); $this->db->insert('grading_method', $data); $this->db->insert('grading_method', $data1); redirect('User_admin/results_calculations?sent'); } } public function insert_grading_p(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type4'))); $count=$this->db->count_all_results('grading_method'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type4')), 'grading' => $this->security->xss_clean($this->input->post('grading4')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type4'))); $this->db->update('grading_method', $data); redirect('User_admin/results_calculations?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type4')), 'grading' => $this->security->xss_clean($this->input->post('grading4')) ); $this->db->insert('grading_method', $data); redirect('User_admin/results_calculations?sent'); } } public function insert_grading_n(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type5'))); $count=$this->db->count_all_results('grading_method'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type5')), 'grading' => $this->security->xss_clean($this->input->post('grading5')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type5'))); $this->db->update('grading_method', $data); redirect('User_admin/results_calculations?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type5')), 'grading' => $this->security->xss_clean($this->input->post('grading5')) ); $this->db->insert('grading_method', $data); redirect('User_admin/results_calculations?sent'); } } public function insert_grading_o(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type6'))); $count=$this->db->count_all_results('grading_method'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type6')), 'grading' => $this->security->xss_clean($this->input->post('grading6')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type6'))); $this->db->update('grading_method', $data); redirect('User_admin/results_calculations?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type6')), 'grading' => $this->security->xss_clean($this->input->post('grading6')) ); $this->db->insert('grading_method', $data); redirect('User_admin/results_calculations?sent'); } } public function insert_grading_a(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type7'))); $count=$this->db->count_all_results('grading_method'); //echo $count.' '.$countt;exit(); if($count>0){ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type7')), 'grading' => $this->security->xss_clean($this->input->post('grading7')) ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type7'))); $this->db->update('grading_method', $data); redirect('User_admin/results_calculations?sent'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'students_type' => $this->security->xss_clean($this->input->post('students_type7')), 'grading' => $this->security->xss_clean($this->input->post('grading7')) ); $this->db->insert('grading_method', $data); redirect('User_admin/results_calculations?sent'); } } public function paymenets_type(){ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'name'=>$this->security->xss_clean($this->input->post('name')) ); $this->db->insert('payments_type',$data); redirect('User_admin/payments_types_settings?sent'); } public function insert_banks(){ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'name'=>$this->security->xss_clean($this->input->post('name')) ); $this->db->insert('banks',$data); redirect('User_admin/bank_accounts?sent'); } public function payments_type1(){ $payer1 = substr($this->security->xss_clean($this->input->post('payer1')),0,1); $payer2 = substr($this->security->xss_clean($this->input->post('payer2')),0,1); $payer3 = substr($this->security->xss_clean($this->input->post('payer3')),0,1); $payer4 = substr($this->security->xss_clean($this->input->post('payer4')),0,1); $payer5 = substr($this->security->xss_clean($this->input->post('payer5')),0,1); $payer6 = substr($this->security->xss_clean($this->input->post('payer6')),0,1); $payer7 = substr($this->security->xss_clean($this->input->post('payer7')),0,1); $payer8 = substr($this->security->xss_clean($this->input->post('payer8')),0,1); $payer9 = substr($this->security->xss_clean($this->input->post('payer9')),0,1); $students_type1 = substr($this->security->xss_clean($this->input->post('payer1')),0,2); $students_type2 = substr($this->security->xss_clean($this->input->post('payer2')),0,2); $students_type3 = substr($this->security->xss_clean($this->input->post('payer3')),0,2); $students_type4 = substr($this->security->xss_clean($this->input->post('payer4')),0,2); $students_type5 = substr($this->security->xss_clean($this->input->post('payer5')),0,2); $students_type6 = substr($this->security->xss_clean($this->input->post('payer6')),0,2); $students_type7 = substr($this->security->xss_clean($this->input->post('payer7')),0,2); $students_type8 = substr($this->security->xss_clean($this->input->post('payer8')),0,2); $students_type9 = substr($this->security->xss_clean($this->input->post('payer9')),0,2); $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_type =$this->security->xss_clean($this->input->post('payment_type')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $data =array( ); } public function assign_payments_type11(){ $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $installments =$this->security->xss_clean($this->input->post('installments')); $installments =$this->security->xss_clean($this->input->post('installments')); $gett=$this->db->get('class_levels'); foreach($gett->result() as $ros){ $class_level = substr($this->security->xss_clean($this->input->post('payer'.trim($ros->level))),0,1); $students_type = substr($this->security->xss_clean($this->input->post('payer'.trim($ros->level))),1,2); echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_type, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); // redirect('User_admin/payments_types_settings?sent'); } } public function assign_payments_type1(){ if($this->session->userdata('school_type')=='PS'){ $school_type='PS'; $table='primary_class_levels'; }else{ $school_type='SS'; $table='class_levels'; } $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); //$students_type =$this->security->xss_clean($this->input->post('students_type')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $installments =$this->security->xss_clean($this->input->post('installments')); $this->db->where('school_type',$school_type); //$this->db->where('students_type',$students_type); $gett=$this->db->get($table); foreach($gett->result() as $ros){ $class_level = substr($this->security->xss_clean($this->input->post('payer'.trim($ros->level).$ros->students_type)),0,1); $students_types = substr($this->security->xss_clean($this->input->post('payer'.trim($ros->level).$ros->students_type)),1,2); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level', $class_level); $this->db->where('payment_id', $payment_id); $this->db->where('students_type',$students_types ); $this->db->where('schoolars_type',$schoolars_type ); $count=$this->db->count_all_results('payers'); if($count>0){ continue; }else{ //echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_types, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); } } redirect('User_admin/payments_types_settings?sent'); } public function assign_payments_type2(){ $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $installments =$this->security->xss_clean($this->input->post('installments')); $class_level = substr($this->security->xss_clean($this->input->post('payer')),0,1); $students_type = substr($this->security->xss_clean($this->input->post('payer')),1,2); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level', $class_level); $this->db->where('payment_id', $payment_id); $this->db->where('students_type',$students_type ); $this->db->where('schoolars_type',$schoolars_type ); $count=$this->db->count_all_results('payers'); if($count>0){ redirect('User_admin/payments_types_settings?Exists'); }else{ echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_type, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); redirect('User_admin/payments_types_settings?sent'); } } public function assign_payments_type3(){ $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $installments =$this->security->xss_clean($this->input->post('installments')); $class_level = substr($this->security->xss_clean($this->input->post('payer')),0,1); $students_type = substr($this->security->xss_clean($this->input->post('payer')),1,2); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level', $class_level); $this->db->where('payment_id', $payment_id); $this->db->where('students_type',$students_type ); $this->db->where('schoolars_type',$schoolars_type ); $count=$this->db->count_all_results('payers'); if($count>0){ redirect('User_admin/payments_types_settings?Exists'); }else{ //echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_type, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); redirect('User_admin/payments_types_settings?sent'); } } public function assign_payments_type4(){ $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $installments =$this->security->xss_clean($this->input->post('installments')); $class_level = substr($this->security->xss_clean($this->input->post('payer')),0,1); $students_type = substr($this->security->xss_clean($this->input->post('payer')),1,2); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level', $class_level); $this->db->where('payment_id', $payment_id); $this->db->where('students_type',$students_type ); $this->db->where('schoolars_type',$schoolars_type ); $count=$this->db->count_all_results('payers'); if($count>0){ redirect('User_admin/payments_types_settings?Exists'); }else{ echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_type, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); redirect('User_admin/payments_types_settings?sent'); } } public function assign_payments_type5(){ $schoolars_type =$this->security->xss_clean($this->input->post('schoolars_type')); $payment_id =$this->security->xss_clean($this->input->post('payment_id')); $payment_time =$this->security->xss_clean($this->input->post('payment_time')); $installments =$this->security->xss_clean($this->input->post('installments')); $class_level = substr($this->security->xss_clean($this->input->post('payer')),0,1); $students_type = substr($this->security->xss_clean($this->input->post('payer')),1,2); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level', $class_level); $this->db->where('payment_id', $payment_id); $this->db->where('students_type',$students_type ); $this->db->where('schoolars_type',$schoolars_type ); $count=$this->db->count_all_results('payers'); if($count>0){ redirect('User_admin/payments_types_settings?Exists'); }else{ //echo 'schoolar = '.$schoolars_type.'; payment_id= '.$payment_id.' installments= '.$installments. ' time= '.$payment_time.' class level= '.$class_level.' students type= '.$students_type.'
'; $data = array( 'school_id' => $this->session->userdata('school_id'), 'payment_id' => $payment_id, 'students_type'=>$students_type, 'schoolars_type'=>$schoolars_type, 'payment_time'=>$payment_time, 'class_level' => $class_level, 'installments' => $installments, ); $this->db->insert('payers', $data); redirect('User_admin/payments_types_settings?sent'); } } public function assign_subjects_class(){ $this->db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){ $subject_id= $this->security->xss_clean($this->input->post('subject'.trim($ros->subject_id))); $students_type= $this->security->xss_clean($this->input->post('students_type')); if($subject_id>0){ $this->db->where('students_type', $students_type); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('stream',$this->security->xss_clean($this->input->post('stream'))); $cunty= $this->db->count_all_results('subjects'); if( $cunty>0){ redirect('User_admin/subjects_settings?subject_assigned_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'students_type'=>$students_type, 'class_level' => $this->security->xss_clean($this->input->post('class_level')), 'stream' => $this->security->xss_clean($this->input->post('stream')), ); //echo $data; $this->db->insert('subjects', $data); } } } redirect('User_admin/subjects_settings?sent'); } public function assign_sub_subjects_class(){ $this->db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){ $sub_subject_id= $this->security->xss_clean($this->input->post('sub_subject'.trim($ros->subject_id))); $percent= $this->security->xss_clean($this->input->post('percent'.trim($ros->subject_id))); $students_type= $this->security->xss_clean($this->input->post('students_type')); $main_subject_id= $this->security->xss_clean($this->input->post('main_subject_id')); if($sub_subject_id>0){ $this->db->where('students_type', $students_type); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('sub_subject_id',$sub_subject_id); $this->db->where('main_subject_id',$main_subject_id); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('stream',$this->security->xss_clean($this->input->post('stream'))); $cunty= $this->db->count_all_results('sub_subjects'); if( $cunty>0){ redirect('User_admin/sub_subjects?subject_assigned_exist'); }elseif($sub_subject_id == $main_subject_id){ redirect('User_admin/sub_subjects?not_allowed'); }elseif($percent==''){ redirect('User_admin/sub_subjects?not_allowed'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'sub_subject_id' => $sub_subject_id, 'percent' => $percent, 'main_subject_id' => $main_subject_id, 'students_type'=>$students_type, 'class_level' => $this->security->xss_clean($this->input->post('class_level')), 'stream' => $this->security->xss_clean($this->input->post('stream')), ); //echo $data; $this->db->insert('sub_subjects', $data); } } } redirect('User_admin/sub_subjects?sent'); } public function assign_subjects_calculation(){ $this->db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){ $subject_id= $this->security->xss_clean($this->input->post('subject'.trim($ros->subject_id))); $students_type= $this->security->xss_clean($this->input->post('students_type')); if($subject_id>0){ $this->db->where('students_type', $students_type); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('stream',$this->security->xss_clean($this->input->post('stream'))); $cunty= $this->db->count_all_results(' subjects_calculations'); if( $cunty>0){ redirect('User_admin/results_calculations?subject_assigned_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'students_type'=>$students_type, 'class_level' => $this->security->xss_clean($this->input->post('class_level')), 'stream' => $this->security->xss_clean($this->input->post('stream')), ); //echo $data; $this->db->insert('subjects_calculations', $data); } } } redirect('User_admin/results_calculations?sent'); } public function assign_subjects_calculations(){ $this->db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){ $subject_id= $this->security->xss_clean($this->input->post('subject'.trim($ros->subject_id))); $students_type= $this->security->xss_clean($this->input->post('students_type')); if($subject_id>0){ $this->db->where('students_type', $students_type); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('stream',$this->security->xss_clean($this->input->post('stream'))); $cunty= $this->db->count_all_results(' subjects_calculations_div'); if( $cunty>0){ redirect('User_admin/results_calculations?subject_assigned_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'students_type'=>$students_type, 'class_level' => $this->security->xss_clean($this->input->post('class_level')), 'stream' => $this->security->xss_clean($this->input->post('stream')), ); //echo $data; $this->db->insert('subjects_calculations_div', $data); } } } redirect('User_admin/results_calculations?sent'); } function assign_activities(){ $this->db->order_by('activity_id','asc'); $get= $this->db->get('general_activities'); foreach($get->result() as $ros){ $activity_id= $this->security->xss_clean($this->input->post('activity'.$ros->activity_id)); $this->db->where('activity_id', $activity_id); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('account_id',$this->security->xss_clean($this->input->post('account_id'))); $county= $this->db->count_all_results('access_levels'); $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'activity_id'=>$activity_id, 'account_id' => $this->security->xss_clean($this->input->post('account_id')), ); if($activity_id==''){ }elseif($county>0){ }else{ $this->db->insert('access_levels', $data1); } // echo $activity_id; } redirect('User_admin/accounts_settings?sent'); } function remove_income(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('income_id', $this->uri->segment(3)); $this->db->delete('income'); redirect('User_admin/income_settings?deleted'); } function remove_expenses(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('expenses_id', $this->uri->segment(3)); $this->db->delete('expenses'); redirect('User_admin/expenses_settings?deleted'); } function remove_class_level(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->where('class_level', $this->uri->segment(4)); $this->db->where('students_type', $this->uri->segment(5)); $this->db->where('stream', $this->uri->segment(6)); $this->db->delete('subjects'); redirect('User_admin/subjects_settings?deleted'); } function remove_sub_class_level(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('main_subject_id', $this->uri->segment(3)); $this->db->where('class_level', $this->uri->segment(4)); $this->db->where('students_type', $this->uri->segment(5)); $this->db->where('stream', $this->uri->segment(6)); $this->db->delete('sub_subjects'); redirect('User_admin/sub_subjects?deleted'); } function edit_subject_name(){ $data=array( 'subject_name'=>$this->input->post('subject_name') ); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->input->post('subject_id')); $this->db->update('general_subjects',$data); redirect('User_admin/subjects_settings?deleted'); } function edit_subject_report_name(){ $data=array( 'report_name'=>$this->input->post('report_name') ); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->input->post('subject_id')); $this->db->update('general_subjects',$data); redirect('User_admin/subjects_settings?deleted'); } function remove_class_level_calculation(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->where('class_level', $this->uri->segment(4)); $this->db->where('students_type', $this->uri->segment(5)); $this->db->where('stream', $this->uri->segment(6)); $this->db->delete('subjects_calculations'); redirect('User_admin/results_calculations?deleted'); } function remove_class_level_calculations(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->where('class_level', $this->uri->segment(4)); $this->db->where('students_type', $this->uri->segment(5)); $this->db->where('stream', $this->uri->segment(6)); $this->db->delete('subjects_calculations_div'); redirect('User_admin/results_calculations?deleted'); } function remove_access_level(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('account_id', $this->uri->segment(3)); $this->db->where('activity_id', $this->uri->segment(4)); $this->db->delete('access_levels'); redirect('User_admin/accounts_settings?deleted'); } function disable_subject(){ $data=array( 'status'=>1, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->Update('general_subjects', $data); redirect('User_admin/subjects_settings?disabled'); } function disable_comb(){ $data=array( 'status'=>1, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('id', $this->uri->segment(3)); $this->db->Update('combinations', $data); redirect('User_admin/combinations_settings?disabled'); } function disable_subject_calculations(){ $data=array( 'status'=>1, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->Update('subjects_calculations', $data); redirect('User_admin/results_calculations?disabled'); } function remove_evaluation(){ $data=array( 'status'=>1, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('evalution_id', $this->uri->segment(3)); $this->db->Update('evalution_settings', $data); redirect('User_admin/evaluation_settings?disabled'); } function remove_evaluation_remark(){ $data=array( 'status'=>1, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('id', $this->uri->segment(3)); $this->db->Update('evalution_remarks', $data); redirect('User_admin/evaluation_settings?deleted'); } function activate_subject_calculations(){ $data=array( 'status'=>0, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->Update('subjects_calculations', $data); redirect('User_admin/results_calculations?activated'); } function activate_subject(){ $data=array( 'status'=>0, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->Update('general_subjects', $data); redirect('User_admin/subjects_settings?activated'); } function activate_comb(){ $data=array( 'status'=>0, ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('id', $this->uri->segment(3)); $this->db->Update('combinations', $data); redirect('User_admin/combinations_settings?activated'); } function remove_payment(){ $id=base64_decode($_REQUEST['id']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('payment_id', $id); $this->db->delete('payments_type'); redirect('User_admin/payments_types_settings?deleted'); } function remove_bank(){ $id=base64_decode($_REQUEST['id']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('bank_id', $id); $this->db->delete('banks'); redirect('User_admin/bank_accounts?deleted'); } function delete_payer(){ $id=base64_decode($_REQUEST['id']); $class=base64_decode($_REQUEST['class']); $type=base64_decode($_REQUEST['type']); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('payment_id', $id); $this->db->where('class_level', $class); $this->db->where('students_type', $type); $this->db->delete('payers'); redirect('User_admin/payments_types_settings?deleted'); } public function fee_amount(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$this->security->xss_clean($this->input->post('payment_id'))); $this->db->where('payer_id',$this->security->xss_clean($this->input->post('payer_id'))); $this->db->where('academic_year',$this->security->xss_clean($this->input->post('academic_year'))); $count=$this->db->count_all_results('register_fees'); if($count>0){ $amount_per_istallment = str_replace(',','',$this->security->xss_clean($this->input->post('amount')))/($this->security->xss_clean($this->input->post('installments'))); $data1=array( 'school_id'=>$this->session->userdata('school_id'), 'payment_id'=>$this->security->xss_clean($this->input->post('payment_id')), 'payer_id'=>$this->security->xss_clean($this->input->post('payer_id')), 'amount'=> str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'amount_per_istallment'=>$amount_per_istallment, 'academic_year'=>$this->security->xss_clean($this->input->post('academic_year')), ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$this->security->xss_clean($this->input->post('payment_id'))); $this->db->where('payer_id',$this->security->xss_clean($this->input->post('payer_id'))); $this->db->where('academic_year',$this->security->xss_clean($this->input->post('academic_year'))); $this->db->update('register_fees',$data1); }else{ $amount_per_istallment = str_replace(',','',$this->security->xss_clean($this->input->post('amount')))/($this->security->xss_clean($this->input->post('installments'))); $data=array( 'school_id'=>$this->session->userdata('school_id'), 'payment_id'=>$this->security->xss_clean($this->input->post('payment_id')), 'payer_id'=>$this->security->xss_clean($this->input->post('payer_id')), 'amount'=> str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'amount_per_istallment'=>$amount_per_istallment, 'academic_year'=>$this->security->xss_clean($this->input->post('academic_year')), ); $this->db->insert('register_fees',$data); } } public function fee_amounts(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$this->security->xss_clean($this->input->post('payment_id'))); $this->db->where('payer_id',$this->security->xss_clean($this->input->post('payer_id'))); $this->db->where('academic_year',$this->security->xss_clean($this->input->post('academic_year'))); $count=$this->db->count_all_results('register_fees'); if($count>0){ $amount_per_istallment = str_replace(',','',$this->security->xss_clean($this->input->post('amount')))/($this->security->xss_clean($this->input->post('installments'))); $data1=array( 'school_id'=>$this->session->userdata('school_id'), 'payment_id'=>$this->security->xss_clean($this->input->post('payment_id')), 'payer_id'=>$this->security->xss_clean($this->input->post('payer_id')), 'amount'=> str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'amount_per_istallment'=>$amount_per_istallment, 'academic_year'=>$this->security->xss_clean($this->input->post('academic_year')), ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$this->security->xss_clean($this->input->post('payment_id'))); $this->db->where('payer_id',$this->security->xss_clean($this->input->post('payer_id'))); $this->db->where('academic_year',$this->security->xss_clean($this->input->post('academic_year'))); $this->db->update('register_fees',$data1); }else{ $amount_per_istallment = str_replace(',','',$this->security->xss_clean($this->input->post('amount')))/($this->security->xss_clean($this->input->post('installments'))); $data=array( 'school_id'=>$this->session->userdata('school_id'), 'payment_id'=>$this->security->xss_clean($this->input->post('payment_id')), 'payer_id'=>$this->security->xss_clean($this->input->post('payer_id')), 'amount'=> str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'amount_per_istallment'=>$amount_per_istallment, 'academic_year'=>$this->security->xss_clean($this->input->post('academic_year')), ); $this->db->insert('register_fees',$data); } } public function insert_insrtuctions(){ for($k=0; $k<=10;$k++){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$this->security->xss_clean($this->input->post('students_type'))); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('term',$this->security->xss_clean($this->input->post('term'))); $this->db->where('academic_year',$this->security->xss_clean($this->input->post('academic_year'))); $this->db->where('instructions',$this->security->xss_clean($this->input->post('instructions'.$k))); $count=$this->db->count_all_results('instruction_reports'); if($count>0 || $this->security->xss_clean($this->input->post('instructions'.$k))==''){ continue; }else{ $data1 = array( 'school_id' => $this->session->userdata('school_id'), 'class_level' =>$this->security->xss_clean($this->input->post('class_level')), 'students_type'=>$this->security->xss_clean($this->input->post('students_type')), 'instructions' => $this->security->xss_clean($this->input->post('instructions'.$k)), 'academic_year' => $this->security->xss_clean($this->input->post('academic_year')), 'term' => $this->security->xss_clean($this->input->post('term')) ); $this->db->insert('instruction_reports', $data1); } } redirect('User_admin/reports_settings?sent'); } public function user_data_submit_subjects() { $table=''; if($this->session->userdata('school_type')=='PS'){ $table='primary_class_levels'; }else{ $table='class_levels'; } $posted_data=$this->input->post('class_level'); //echo $posted_data;exit(); $class_level=substr($posted_data,0,1); $students_type=substr($posted_data,1,1); $stream=substr($posted_data,2,3); $class_name=$this->input->post('class_name'); //echo $students_type;exit(); $this->db->where('level',$class_level); $this->db->where('students_type',$students_type); $get=$this->db->get($table); foreach($get->result() as $ro){?>

Assign Subjects To name.'-'.$stream?>

session->userdata('school_type')=='PS'){ $table='primary_class_levels'; }else{ $table='class_levels'; } $posted_data=$this->input->post('class_level'); //echo $posted_data;exit(); $class_level=substr($posted_data,0,1); $students_type=substr($posted_data,1,1); $stream=substr($posted_data,2,3); $class_name=$this->input->post('class_name'); //echo $students_type;exit(); $this->db->where('level',$class_level); $this->db->where('students_type',$students_type); $get=$this->db->get($table); foreach($get->result() as $ro){?>

Assign Sub Subjects To Main Subject For name.'-'.$stream?>

Select main subject db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){?>

subject_name; ?>

Select sub subjects and enter percent of contribution db->where('school_id',$this->session->userdata('school_id')); $gett=$this->db->get('general_subjects'); foreach($gett->result() as $ros){?>

subject_name ?>

session->userdata('school_type')=='PS'){ $table='primary_class_levels'; }else{ $table='class_levels'; } $posted_data=$this->input->post('class_level'); $class_level=substr($posted_data,0,1); $students_type=substr($posted_data,1,1); $stream=substr($posted_data,2); $class_name=$this->input->post('class_name'); //echo $students_type.' level '.$class_level.' stream ='.$stream.;exit(); $this->db->where('level',$class_level); $this->db->where('students_type',$students_type); $get=$this->db->get($table); foreach($get->result() as $ro){?>

Check Subjects for Average calculations To name.'-'.$stream?>

Check Subjects for Division calculations To name.'-'.$stream?>

input->post('class_level'); $class_level=substr($posted_data,0,1); $students_type=substr($posted_data,1,2); $class_name=$this->input->post('class_name'); $term=$this->input->post('term'); if($students_type=='A'){ $academic_year=$this->session->userdata('academic_year_a_level'); $table='class_levels'; }else{ $academic_year=date('Y'); $table='primary_class_levels'; } //echo $students_type;exit(); $this->db->where('level',$class_level); $this->db->where('students_type',$students_type); $this->db->where('school_id', $this->session->userdata('school_id')); $get=$this->db->get($table); foreach($get->result() as $ro){?>

db->where('school_id', $this->session->userdata('school_id')); $this->db->where('id',$id); $this->db->delete('instruction_reports'); redirect('User_admin/reports_settings?deleted'); } public function user_data_get_instructions() { $academic_year=''; $posted_data=$this->input->post('class_level'); $class_level=substr($posted_data,0,1); $students_type=substr($posted_data,1,2); $class_name=$this->input->post('class_name'); $term=$this->input->post('term'); //echo $students_type;exit(); if($students_type=='A'){ $academic_year=$this->session->userdata('academic_year_a_level'); $table='class_levels'; }else{ $academic_year=date('Y'); $table='primary_class_levels'; } $this->db->where('level',$class_level); $this->db->where('students_type',$students_type); $this->db->where('school_id',$this->session->userdata('school_id')); $get=$this->db->get($table); foreach($get->result() as $ro){?>

Instructions report To name?> Term

db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type',$students_type); $this->db->where('class_level',$class_level); $this->db->where('term',$term); $this->db->where('academic_year',$academic_year); $get=$this->db->get('instruction_reports'); foreach($get->result() as $ros){ $i++; ?>

'.$i.'. '.$ros->instructions ?> Delete