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->userdata('reg_number'))) { $this->session->set_flashdata('flash_data', 'You don\'t have access!'); redirect('Welcome'); }elseif($this->session->userdata('school_type')!='PS'){ $this->session->set_flashdata('flash_data', 'You don\'t have access!'); redirect('Private_area'); }elseif($this->session->userdata('type')=='Parent'){ $this->session->set_flashdata('flash_data', 'You don\'t have access!'); redirect('Parents_area'); } } //this function redirecting different pages after users loged in public function index() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/home'); $this->load->view('includes/primary/primary_footer'); } //this function redirecting different pages after users loged in ##********************************************************************************* ## PERIODS STARTS HERE... public function periods() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/periods'); $this->load->view('includes/primary/primary_footer'); } public function assign_subjects_periods(){ $this->db->where('region_id',$this->session->userdata('region')); $this->db->where('district_id',$this->session->userdata('district')); $this->db->where('category',$this->security->xss_clean($this->input->post('students_type'))); $gett=$this->db->get('all_subjects_region'); 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); $cunty= $this->db->count_all_results('assign_subects_period'); if( $cunty>0){ // redirect('Secondary/assign_subject?subject_assigned_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'students_type'=>$students_type, ); //echo $data; $this->db->insert('assign_subects_period', $data); } } } redirect('Primary/assign_subject?sent'); } public function create_streams(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('category',$this->security->xss_clean($this->input->post('category'))); $this->db->where('streams',$this->security->xss_clean($this->input->post('stream'))); $gett=$this->db->count_all_results('assign_stream_period'); if($gett>0){ // do nothing }else{ $data=array( 'school_id'=>$this->session->userdata('school_id'), 'class_level'=>$this->security->xss_clean($this->input->post('class_level')), 'streams'=>$this->security->xss_clean($this->input->post('stream')), 'category'=>$this->security->xss_clean($this->input->post('category')), ); $this->db->insert('assign_stream_period',$data); } redirect('Primary/register_streams?sent'); } public function create_streams1(){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$this->security->xss_clean($this->input->post('class_level'))); $this->db->where('category',$this->security->xss_clean($this->input->post('category'))); $this->db->where('streams',$this->security->xss_clean($this->input->post('stream'))); $gett=$this->db->count_all_results('assign_stream_period'); if($gett>0){ // do nothing }else{ $data=array( 'school_id'=>$this->session->userdata('school_id'), 'class_level'=>$this->security->xss_clean($this->input->post('class_level')), 'streams'=>$this->security->xss_clean($this->input->post('stream')), 'category'=>$this->security->xss_clean($this->input->post('category')), ); $this->db->insert('assign_stream_period',$data); } redirect('Primary/register_streams?sent'); } public function assign_subjects_periods1(){ $this->db->where('region_id',$this->session->userdata('region')); $this->db->where('district_id',$this->session->userdata('district')); $this->db->where('category',$this->security->xss_clean($this->input->post('students_type'))); $gett=$this->db->get('all_subjects_region'); 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); $cunty= $this->db->count_all_results('assign_subects_period'); if( $cunty>0){ // redirect('Secondary/assign_subject?subject_assigned_exist'); }else{ $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'students_type'=>$students_type, ); //echo $data; $this->db->insert('assign_subects_period', $data); } } } redirect('Primary/assign_subject?sent'); } public function remove_sub(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('subject_id', $this->uri->segment(3)); $this->db->where('students_type', $this->uri->segment(4)); $this->db->delete('assign_subects_period'); redirect('Primary/assign_subject?deleted'); } public function remove_stream_period(){ $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('id', $this->uri->segment(3)); $this->db->delete('assign_stream_period'); redirect('Primary/register_streams?deleted'); } public function assign_subject() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/assign_subject'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/assign_subject'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function register_streams() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_streams'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_streams'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function untaught_periods() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/untaught_periods'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/untaught_periods'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function selected_date(){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/selected_date'); $this->load->view('includes/primary/uploading_footer'); } public function school_periods_report(){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/school_periods_report'); $this->load->view('includes/primary/uploading_footer'); } public function insert_untaught_periods(){ if($_POST){ $date = $this->input->post('date'); $ym=explode('/',$date); $year=$ym[2]; $month=$ym[1]; $dy=$ym[0]; $date = $year."-".$month."-".$dy; $ddate = $date; $year = substr($ddate,0,4); $datew = new DateTime($ddate); $week = $datew->format("W"); $day = $this->input->post('day'); $class_level = $this->input->post('class_level'); $subject_id = $this->input->post('subject_id'); $stream = $this->input->post('stream'); $category = $this->input->post('category'); $period = $this->input->post('period'); //get year and month if($period == 0 || $period == '' || $period < 1){ #update periods $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('category',$category); $this->db->where('class_level',$class_level); $this->db->where('stream',$stream); $this->db->where('date',$date); $this->db->delete('untaught_periods'); }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('category',$category); $this->db->where('class_level',$class_level); $this->db->where('stream',$stream); $this->db->where('date',$date); $count = $this->db->count_all_results('untaught_periods'); if($count == 0){ #insert values $data = array( 'school_id'=>$this->session->userdata('school_id'), 'subject_id'=>$subject_id, 'category'=>$category, 'class_level'=>$class_level, 'stream'=>$stream, 'periods'=>$period, 'date'=>$date, 'year'=>$year, 'month'=>$month, 'day'=>$day, 'region'=>$this->session->userdata('region'), 'district'=>$this->session->userdata('district'), 'week'=>$week, ); $this->db->insert('untaught_periods',$data); }else{ #update periods $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('subject_id',$subject_id); $this->db->where('category',$category); $this->db->where('class_level',$class_level); $this->db->where('stream',$stream); $this->db->where('date',$date); $this->db->update('untaught_periods',array('periods'=>$period)); } } } } public function period_comments(){ $class = $this->input->post('class_level'); $ddate = date("Y-m-d", strtotime($this->input->post('date'))); $year = substr($ddate,0,4); $date = new DateTime($ddate); $week = $date->format("W"); $dto = new DateTime(); $dto->setISODate($year, $week); $week_start = $dto->format('Y-m-d'); $dto->modify('+6 days'); $week_end = $dto->format('Y-m-d'); $data = array( 'school_id'=>$this->session->userdata('school_id'), 'district'=>$this->session->userdata('district'), 'region'=>$this->session->userdata('region'), 'week_start'=>$week_start, 'week_end'=>$week_end, 'week_number'=>$week, 'class_level'=>$class, 'commited_by'=>$this->session->userdata('reg_number') != '' ? $this->session->userdata('reg_number') : $this->session->userdata('school_reg_number'), 'date_commited'=>date('Y-m-d H:i:s'), ); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('week_number',$week); $this->db->where('class_level',$class); $this->db->where('week_end',$week_end); $cc = $this->db->count_all_results('periods_commits'); if(!$cc){ $this->db->insert('periods_commits',$data); } redirect($_SERVER['HTTP_REFERER']); } ## PERIODS ENDS HERE ##********************************************************************************* public function home_test() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/home_test'); $this->load->view('includes/primary/primary_footer'); } public function get_students(){ $reg=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->like('full_name', $this->input->post('name'),"BOTH"); $this->db->limit(50); $q = $this->db->get('students'); foreach($q->result() as $st){ $academic_year =date('Y'); $round=$this->input->post('round'); $this->db->where('academic_year', $academic_year); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $st->reg_number); $this->db->where('status', 0); $this->db->limit(1); $query = $this->db->get('classes'); foreach ($query->result() as $rows) { $this->db->where('reg_number', $rows->reg_number); $query = $this->db->get('students'); foreach ($query->result() as $rowws) { $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year', $academic_year); $querry = $this->db->get('classes'); foreach ($querry->result() as $row_amount) { $reg = $rowws->reg_number; $sch_type = $row_amount->schoolar_type; $cat = $row_amount->category; //$pay_type = $row_amount->payment_type; $year = $row_amount->academic_year; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('status',0); $this->db->where('reg_number',$reg_number); $get=$this->db->get('classes'); foreach($get->result() as $row){?>
category=='N'){ echo strtoupper($rowws->full_name).' - Nursery '.$rows->class_level . "-" . $rows->stream; }else{ echo strtoupper($rowws->full_name).' - Standard '.$rows->class_level . "-" . $rows->stream; } ?> Amount Required Amount Paid Amount Remained
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); // $this->db->where('schoolars_type',$row->schoolar_type); $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payment type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss){ $name= $rowss->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check=$this->db->count_all_results('reduced_payments'); if($check>0){ //selecting fee from reduced payments $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowff){ $required1 = $required1+$rowff->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; echo '' ; echo ''; echo ''; } }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowff){ $required1 = $required1+$rowff->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; echo '' ; echo ''; echo ''; } } } /// finding amounts for different schoolars type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); $this->db->where('schoolars_type',$row->schoolar_type); // $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payement type$this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss1){ $name1= $rowss1->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check1=$this->db->count_all_results('reduced_payments'); if($check1>0){ //selecting from reduced payement $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payment_id',$rows->payment_id); $this->db->where('reg_number',$reg_number); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowffs){ $required2 = $required2 + $rowffs->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; echo '' ; echo ''; echo ''; } }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowffs){ $required2 = $required2 + $rowffs->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; echo '' ; echo ''; echo ''; } } } echo '' ; echo ''; echo ''; echo ''; ?>
'; echo $name.'= '; echo ''; echo number_format($rowff->amount).' '; ?> '; echo '
'; echo $name.'= '; echo ''; echo number_format($rowff->amount).' '; ?> '; echo '
'; echo $name1.'= '; echo ''; echo number_format($rowffs->amount).' '; ?> '; echo '
'; echo $name1.'= '; echo ''; echo number_format($rowffs->amount).' '; ?> '; echo '
'; echo 'TOTAL= '; echo ''; $total_required=$required1+$required2; echo number_format($total_required); echo '
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); // $this->db->where('schoolars_type',$row->schoolar_type); $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payment type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss){ $name= $rowss->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowff){ $required1 = $required1+$rowff->amount; //finding paid amount for this payment type $trans_type_amount1=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount1=$tr->amount; } // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; echo '' ; echo ''; echo ''; echo ''; } } /// finding amounts for different schoolars type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); $this->db->where('schoolars_type',$row->schoolar_type); // $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payement type$this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss1){ $name1= $rowss1->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowffs){ $required2 = $required2 + $rowffs->amount; //finding paid amount for this payment type $trans_type_amount2=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount2=$tr->amount; } // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; echo '' ; echo ''; echo ''; echo ''; }} $paid=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; if($paid==0 || $paid==''){ echo '' ; echo ''; echo ''; echo ''; }else{ echo '' ; echo ''; echo ''; echo ''; } } ?>
'; echo $name.'= '; echo ''; echo number_format($trans_type_amount1).' '; echo '
'; echo $name1.'= '; echo ''; echo number_format($trans_type_amount2).' '; echo '
'; echo 'TOTAL= '; echo ''; echo '---'; echo '
'; echo 'TOTAL= '; echo ''; echo number_format($paid); echo '
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); // $this->db->where('schoolars_type',$row->schoolar_type); $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payment type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss){ $name= $rowss->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check=$this->db->count_all_results('reduced_payments'); if($check>0){ //select from reduced payments $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowff){ $required1 = $rowff->amount; $required11 = $required11 + $rowff->amount; //finding paid amount for this payment type $trans_type_amount1=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount1=$tr->amount; } //echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; echo '' ; echo ''; echo ''; } }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowff){ $required1 = $rowff->amount; $required11 = $required11 + $rowff->amount; //finding paid amount for this payment type $trans_type_amount1=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount1=$tr->amount; } //echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; echo '' ; echo ''; echo ''; } } } /// finding amounts for different schoolars type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); $this->db->where('schoolars_type',$row->schoolar_type); // $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ //getting the name of payement type$this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$rows->payment_id); foreach($this->db->get('payments_type')->result() as $rowss1){ $name1= $rowss1->name; } $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check1=$this->db->count_all_results('reduced_payments'); if($check1>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowffs){ $required2 = $rowffs->amount; $required22 = $required22 + $rowffs->amount; //finding paid amount for this payment type $trans_type_amount2=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount2=$tr->amount; } // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; echo '' ; echo ''; echo ''; } } else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowffs){ $required2 = $rowffs->amount; $required22 = $required22 + $rowffs->amount; //finding paid amount for this payment type $trans_type_amount2=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $this->db->where('payment_type',$rows->payment_id); $get_trans_type=$this->db->get('transactions'); foreach($get_trans_type->result() as $tr){ $trans_type_amount2=$tr->amount; } // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; echo '' ; echo ''; echo ''; } } } $total_remained=$required11+$required22; $paid=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; } if($total_remained>$paid){?> ' ; echo ''; echo ''; echo ''; } ?>
'; echo $name.'= '; echo ''; if($required1>$trans_type_amount1){?> Pay '; echo '
'; echo $name.'= '; echo ''; if($required1>$trans_type_amount1){?> Pay '; echo '
'; echo $name1.'= '; echo ''; if($required2>$trans_type_amount2){?> Pay '; echo '
'; echo $name1.'= '; echo ''; if($required2>$trans_type_amount2){?> Pay '; echo '
TOTAL=
TOTAL=
'; echo 'TOTAL = '; echo '
'; echo '---'; echo '
security->xss_clean($this->input->post('date')); $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $receiver=$this->security->xss_clean($this->input->post('receiver')); redirect('Primary/sent_sms?date='.base64_encode($date).'&&month='.base64_encode($month).'&&year='.base64_encode($year).'&&receiver='.base64_encode($receiver)); } public function serach_sms_by_month(){ $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $receiver=$this->security->xss_clean($this->input->post('receiver')); redirect('Primary/sent_sms?monthh='.base64_encode($month).'&&yearr='.base64_encode($year).'&&receiverr='.base64_encode($receiver)); } public function delete_sms_by_date(){ $date= $this->security->xss_clean($this->input->post('date')); $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $this->db->where('date',$date); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->delete('sent_sms'); redirect('Primary/delete_sms?deleted'); } public function delete_sms_by_month(){ $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->delete('sent_sms'); redirect('Primary/delete_sms?deleted'); } public function delete_sms_by_year(){ $year= $this->security->xss_clean($this->input->post('year')); $this->db->where('year',$year); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->delete('sent_sms'); redirect('Primary/delete_sms?deleted'); } public function confirm_sms_payments(){ $transaction_id=trim($this->security->xss_clean($this->input->post('transaction_id'))); //echo $transaction_id;exit(); $url = 'http://www.afel.co.tz/Confirm_sms_payments_primary'; $fields = array( 'key= '=>"179103@afel_1990/2017", 'transaction_id= '=>trim($this->security->xss_clean($this->input->post('transaction_id'))), 'paid_for= '=>"sms", 'payer_id= '=>$this->session->userdata('school_id'), 'payer_name= '=>$this->session->userdata('school_name'), ); $fields_string = ''; //url-ify the data for the POST foreach($fields as $key=>$value) { $fields_string .= $key.$value.'&'; } rtrim($fields_string, '&'); //open connection $ch = curl_init(); //set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL, $url); curl_setopt($ch,CURLOPT_POST, count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string); //execute post $result = curl_exec($ch); //close connection curl_close($ch); if($result == 1){ redirect('Primary/buy_sms?status=sent&&id='.base64_encode($transaction_id)); }else{ redirect('Primary/buy_sms?status=error&&id='.base64_encode($transaction_id)); } } public function calculate_results_p_level_background_monthly() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_monthly'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_monthly'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function calculate_results_p_level_background_mid() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_mid'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_mid'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function calculate_results_p_level_background_term() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_term'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_p_level_background_term'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function publish_results_p_level_background() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_p_level_background'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_p_level_background'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function calculate_results_n_level_background_monthly() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_monthly'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_monthly'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function calculate_results_n_level_background_mid() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_mid'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_mid'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function calculate_results_n_level_background_term() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_term'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/calculate_results_n_level_background_term'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function publish_results_n_level_background() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_n_level_background'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_n_level_background'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function insert_class_teachers(){ $class=substr($this->security->xss_clean($this->input->post('class_level')),0,1); $stream=substr($this->security->xss_clean($this->input->post('class_level')),1,2); $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'stream'=>$stream, 'category'=>$this->security->xss_clean($this->input->post('category')), 'academic_year'=>date('Y'), ); $this->db->insert('class_teachers',$data); redirect('Primary/class_teachers_primary?sent'); } public function insert_class_teachers_n(){ $class=substr($this->security->xss_clean($this->input->post('class_level')),0,1); $stream=substr($this->security->xss_clean($this->input->post('class_level')),1,2); $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'stream'=>$stream, 'category'=>$this->security->xss_clean($this->input->post('category')), 'academic_year'=>date('Y'), ); $this->db->insert('class_teachers',$data); redirect('Primary/class_teachers_primary?sent'); } public function delete_class_teacher(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->delete('class_teachers'); redirect('Primary/class_teachers_primary?deleted'); } public function subject_teachers_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/subject_teachers_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',9); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/subject_teachers_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function insert_subject_teachers(){ $class=substr($this->security->xss_clean($this->input->post('class_level')),0,1); $stream=substr($this->security->xss_clean($this->input->post('class_level')),1,1); $subject_id=substr($this->security->xss_clean($this->input->post('class_level')),2); //echo $this->security->xss_clean($this->input->post('class_level')).' '.$class.' '.$stream.' '.$subject_id;exit(); $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'category' => $this->security->xss_clean($this->input->post('category')), 'class_level' => $class, 'stream' => $stream, 'reg_number' => $this->security->xss_clean($this->input->post('reg_number')), 'academic_year' => date('Y') ); //echo $data; $this->db->insert('subjects_assigned', $data); redirect('Primary/subject_teachers_primary?sent'); } public function insert_subject_teachers_n(){ $class=substr($this->security->xss_clean($this->input->post('class_level')),0,1); $stream=substr($this->security->xss_clean($this->input->post('class_level')),1,1); $subject_id=substr($this->security->xss_clean($this->input->post('class_level')),2); //echo $this->security->xss_clean($this->input->post('class_level')).' '.$class.' '.$stream.' '.$subject_id;exit(); $data = array( 'school_id' => $this->session->userdata('school_id'), 'subject_id' => $subject_id, 'category' => $this->security->xss_clean($this->input->post('category')), 'class_level' => $class, 'stream' => $stream, 'reg_number' => $this->security->xss_clean($this->input->post('reg_number')), 'academic_year' => date('Y') ); //echo $data; $this->db->insert('subjects_assigned', $data); redirect('Primary/subject_teachers_primary?sent'); } public function delete_subject_teacher(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->where('category', 'P'); $this->db->delete('subjects_assigned'); redirect('Primary/subject_teachers_primary?deleted'); } public function delete_subject_teacher_n(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->where('category', 'N'); $this->db->delete('subjects_assigned'); redirect('Primary/subject_teachers_primary?deleted'); } public function send_evaluation(){ $class=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$this->security->xss_clean($this->input->post('reg_number'))); $this->db->where('academic_year',date('Y')); foreach($this->db->get('classes')->result() as $row){ $class=$row->class_level; } $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'evaluation_id'=>$this->security->xss_clean($this->input->post('evaluation')), 'grade'=>$this->security->xss_clean($this->input->post('grade')), 'term'=>$this->security->xss_clean($this->input->post('term')), 'academic_year'=>date('Y'), ); $this->db->insert('students_evaluation',$data); redirect('Primary/evaluate_students_p_level?sent'); } public function send_evaluation1(){ $class=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$this->security->xss_clean($this->input->post('reg_number'))); $this->db->where('academic_year',date('Y')); foreach($this->db->get('classes')->result() as $row){ $class=$row->class_level; } $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'evaluation_id'=>$this->security->xss_clean($this->input->post('evaluation')), 'grade'=>$this->security->xss_clean($this->input->post('grade')), 'term'=>$this->security->xss_clean($this->input->post('term')), 'academic_year'=>date('Y'), ); $this->db->insert('students_evaluation',$data); redirect('Primary/evaluate_students_p_level?sent'); } public function send_evaluation_n(){ $class=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$this->security->xss_clean($this->input->post('reg_number'))); $this->db->where('academic_year',date('Y')); foreach($this->db->get('classes')->result() as $row){ $class=$row->class_level; } $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'evaluation_id'=>$this->security->xss_clean($this->input->post('evaluation')), 'grade'=>$this->security->xss_clean($this->input->post('grade')), 'term'=>$this->security->xss_clean($this->input->post('term')), 'academic_year'=>date('Y'), ); $this->db->insert('students_evaluation',$data); redirect('Primary/evaluate_students_n_level?sent'); } public function send_evaluation_n1(){ $class=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$this->security->xss_clean($this->input->post('reg_number'))); $this->db->where('academic_year',date('Y')); foreach($this->db->get('classes')->result() as $row){ $class=$row->class_level; } $data=array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number'=>$this->security->xss_clean($this->input->post('reg_number')), 'class_level'=>$class, 'evaluation_id'=>$this->security->xss_clean($this->input->post('evaluation')), 'grade'=>$this->security->xss_clean($this->input->post('grade')), 'term'=>$this->security->xss_clean($this->input->post('term')), 'academic_year'=>date('Y'), ); $this->db->insert('students_evaluation',$data); redirect('Primary/evaluate_students_n_level?sent'); } public function income_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/income_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/income_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function balance_sheet_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/balance_sheet_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/balance_sheet_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function revenue_reports_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/revenue_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/revenue_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function expenditures_reports_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/expenditures_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/expenditures_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function expenditures_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/expenditures_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/expenditures_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function delete_transactionn(){ $no=base64_decode($_GET['no']); $reg_number=base64_decode($_GET['reg']); $this->db->where('school_receipt', $no); $this->db->delete('transactions'); redirect('Primary/students_details_primary?id='.base64_encode($reg_number)); } public function delete_postoponed(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->delete('postpone_payments'); redirect('Primary/postpone_payments_primary?deleted'); } public function delete_revenue(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->delete('revenue'); redirect('Primary/income_primary?deleted'); } public function delete_expenditure(){ $no=base64_decode($_GET['id']); $this->db->where('id', $no); $this->db->delete('expenditures'); redirect('Primary/expenditures_primary?deleted'); } public function register_students_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function create_groups() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/create_groups'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/create_groups'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function add_members() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/add_members'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/add_members'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function print_members() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/print_members'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/print_members'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function insert_group(){ $data=array( 'name'=>$this->security->xss_clean($this->input->post('group_name')), 'school_id'=>$this->session->userdata('school_id'), ); $this->db->insert('groups',$data); redirect('Primary/create_groups?sent'); } public function remove_members(){ if($_POST){ $this->db->where('group_id',$this->input->post('id')); $this->db->where('academic_year',$this->input->post('year')); $this->db->where('reg_number',$this->input->post('reg_number')); $this->db->delete('group_members'); } } public function notify() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/notify_sms'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/notify_sms'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function sms() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/sms'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/sms'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function sent_sms() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/sent_sms_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/sent_sms_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function delete_sms() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/delete_sms'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/delete_sms'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function billing_reports() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/billing_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/billing_reports_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function print_sms_receipt() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/print_sms_receipt'); $this->load->view('includes/primary/uploading_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/print_sms_receipt'); $this->load->view('includes/primary/uploading_footer'); }else{ redirect('Private_area'); } } } } public function site_visit() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/site_visit'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/site_visit'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function buy_sms() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/buy_sms'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',7); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/buy_sms'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function students_list_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_list_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_list_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function all_students_list() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/all_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/all_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function gender_students_list() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/gender_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/gender_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function schoolar_students_list() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/schoolar_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/schoolar_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function class_students_list() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/class_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/class_students_list'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function students_details_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_details_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_details_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_results_by_excel_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_by_excel_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_by_excel_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_results_by_excel_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_by_excel_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_by_excel_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function publish_results_n(){ $term = base64_decode($_REQUEST['term']); $data1 = array( 'status' => 1 ); $this->db->select('status'); $this->db->where('term', $term); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('academic_year', date('Y')); $this->db->not_like('category','P'); $this->db->update('exam', $data1); redirect('Primary/publish_results_n_level?published'); } public function undo_publish_results_n(){ $term = base64_decode($_REQUEST['term']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('term', $term); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('academic_year', date('Y')); $this->db->not_like('category','P'); $this->db->update('exam', $data1); redirect('Primary/publish_results_n_level?published'); } public function publish_monthly_results_n(){ $month = base64_decode($_REQUEST['month']); $data1 = array( 'status' => 1 ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('month', $month); $this->db->where('academic_year', date('Y')); $this->db->not_like('category','P'); $this->db->update('ca', $data1); redirect('Primary/publish_results_n_level?published'); } public function undo_publish_monthly_results_n(){ $month = base64_decode($_REQUEST['month']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('month', $month); $this->db->where('academic_year', date('Y')); $this->db->not_like('category','P'); $this->db->update('ca', $data1); redirect('Primary/publish_results_n_level?published'); } public function publish_results_p(){ $term = base64_decode($_REQUEST['term']); $data1 = array( 'status' => 1 ); $this->db->select('status'); $this->db->where('term', $term); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('academic_year', date('Y')); $this->db->where('category','P'); $this->db->update('exam', $data1); redirect('Primary/publish_results_p_level?published'); } public function undo_publish_results_p(){ $term = base64_decode($_REQUEST['term']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('term', $term); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('academic_year', date('Y')); $this->db->where('category','P'); $this->db->update('exam', $data1); redirect('Primary/publish_results_p_level?published'); } public function publish_monthly_results_p(){ $month = base64_decode($_REQUEST['month']); $data1 = array( 'status' => 1 ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('month', $month); $this->db->where('academic_year', date('Y')); $this->db->where('category','P'); $this->db->update('ca', $data1); redirect('Primary/publish_results_p_level?published'); } public function undo_publish_monthly_results_p(){ $month = base64_decode($_REQUEST['month']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('month', $month); $this->db->where('academic_year', date('Y')); $this->db->where('category','P'); $this->db->update('ca', $data1); redirect('Primary/publish_results_p_level?published'); } public function upload_results_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_results() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_ca() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_ca'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_ca'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_uploaded_ca_n() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_ca_n'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_ca_n'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_uploaded_ca_p() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_ca_p'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_ca_p'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_uploaded_exam_p() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_exam_p'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_exam_p'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_uploaded_exam_n() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_exam_n'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_uploaded_exam_n'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_incomplete_ca() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_ca'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_ca'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_incomplete_ca_n() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_ca_n'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_ca_n'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_incomplete_exam() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_exam'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_exam'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_incomplete_exam_n() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_exam_n'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_incomplete_exam_n'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_exam() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_exam'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_exam'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function publish_results_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_results_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_results_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function results_statistics() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/results_statistics'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/results_statistics'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function evaluate_students_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/evaluate_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',3); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/evaluate_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function students_attendance_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_attendance_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',4); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_attendance_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function suspended_students_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/suspended_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',8); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/suspended_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function precautioned_students_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/precautioned_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',8); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/precautioned_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function dismissed_students_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/dismissed_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/dismissed_students_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function graduates_p_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/graduates_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/graduates_p_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function register_students_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function students_list_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_list_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_list_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function upload_results_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/upload_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function publish_results_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/publish_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_results_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',2); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_results_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function evaluate_students_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/evaluate_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',3); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/evaluate_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function students_attendance_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_attendance_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',4); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/students_attendance_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function suspended_students_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/suspended_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',8); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/suspended_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function precautioned_students_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/precautioned_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',8); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/precautioned_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function dismissed_students_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/dismissed_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/dismissed_students_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function graduates_n_level() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/graduates_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',1); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/graduates_n_level'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function register_staffs_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_staffs_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',9); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/register_staffs_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function class_teachers_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/class_teachers_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',9); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/class_teachers_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function staffs_details_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/staffs_details_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',9); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/staffs_details_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function insert_payments_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/insert_payments_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/insert_payments_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function print_receipt() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/print_receipt'); $this->load->view('includes/primary/uploading_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/print_receipt'); $this->load->view('includes/primary/uploading_footer'); }else{ redirect('Private_area'); } } } } public function postpone_payments_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/postpone_payments_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/postpone_payments_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function enter_payments_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/enter_payments_primary'); $this->load->view('includes/primary/uploading_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/enter_payments_primary'); $this->load->view('includes/primary/uploading_footer'); }else{ redirect('Private_area'); } } } } public function clear_payments_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/clear_payments_primary'); $this->load->view('includes/primary/uploading_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/uploading_header'); $this->load->view('users/primary/clear_payments_primary'); $this->load->view('includes/primary/uploading_footer'); }else{ redirect('Private_area'); } } } } public function view_payments_by_type_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_type_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_type_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function payments_statistics() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/payments_statistics'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/payments_statistics'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_payments_by_amount_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_amount_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_amount_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_payments_by_bank_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_bank_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_bank_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_payments_by_list_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_list_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_list_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function view_payments_by_date_primary() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_date_primary'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/view_payments_by_date_primary'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function register_manager() { $this->db->where('reg_number', str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10)))); $count=$this->db->count_all_results('staffs'); $this->db->where('school_mobile', $this->security->xss_clean($this->input->post('mobile'))); $county=$this->db->count_all_results('schools'); if($count>0 || $county>0){ redirect('Primary/register_staffs_primary?Exists'); }else{ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number' =>str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10))), 'education' => $this->security->xss_clean($this->input->post('education')), 'skills' => $this->security->xss_clean($this->input->post('skills')), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'password' => MD5($this->security->xss_clean($this->input->post('password'))), 'password_reset' => $this->security->xss_clean($this->input->post('password')), 'category' => 'Manager', 'title' => 'Manager', 'type' => 'User', 'registered_year'=>date('Y') ); $this->db->insert('staffs', $data); redirect('Primary/register_staffs_primary?sent'); } } public function assigned_subjects() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/assigned_subjects'); $this->load->view('includes/primary/primary_footer'); } public function assigned_class() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/assigned_class'); $this->load->view('includes/primary/primary_footer'); } public function class_students_primary() { $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/class_students_primary'); $this->load->view('includes/primary/primary_footer'); } public function receipt_reports() { $type=$this->session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/receipt_reports'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',5); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/receipt_reports'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } public function search_receipt_report(){ $get=$this->security->xss_clean($this->input->post('year')); redirect('Primary/receipt_reports?year='.base64_encode($get)); } public function insert_postponed() { $data = array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number' =>$this->security->xss_clean($this->input->post('reg_number')), 'amount' => str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'date' => $this->security->xss_clean($this->input->post('date')), 'month' => $this->security->xss_clean($this->input->post('month')), 'year' => $this->security->xss_clean($this->input->post('year')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'category' => substr($this->security->xss_clean($this->input->post('reg_number')),0,1), 'payment_type' => $this->security->xss_clean($this->input->post('payment_type')) ); $this->db->insert('postpone_payments', $data); redirect('Primary/postpone_payments_primary?sent'); } public function insert_revenue() { if($this->session->userdata('type')=="Admin"){ $issuer_title=$this->session->userdata('type'); } else{ $issuer_title=$this->session->userdata('title'); } $date=$this->security->xss_clean($this->input->post('date')); $month=substr($this->security->xss_clean($this->input->post('date')),0,2); $year=substr($this->security->xss_clean($this->input->post('date')),6,10); $data = array( 'school_id'=>$this->session->userdata('school_id'), 'amount' => str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'date' => $date, 'month' => $month, 'year' => $year, 'income' => $this->security->xss_clean($this->input->post('income')), 'issuer' => $this->session->userdata('full_name'), 'issuer_title' => $issuer_title, ); $this->db->insert('revenue', $data); redirect('Primary/income_primary?sent'); } public function insert_expenditure() { if($this->session->userdata('type')=="Admin"){ $issuer_title=$this->session->userdata('type'); } else{ $issuer_title=$this->session->userdata('title'); } $date=$this->security->xss_clean($this->input->post('date')); $month=substr($this->security->xss_clean($this->input->post('date')),0,2); $year=substr($this->security->xss_clean($this->input->post('date')),6,10); $data = array( 'school_id'=>$this->session->userdata('school_id'), 'amount' => str_replace(',','',$this->security->xss_clean($this->input->post('amount'))), 'date' => $date, 'month' => $month, 'year' => $year, 'expenditure ' => $this->security->xss_clean($this->input->post('expenses')), 'issuer' => $this->session->userdata('full_name'), 'issuer_title' => $issuer_title, ); $this->db->insert('expenditures', $data); redirect('Primary/expenditures_primary?sent'); } public function register_teachers() { $this->db->where('reg_number', str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10)))); $count=$this->db->count_all_results('staffs'); $this->db->where('school_mobile', $this->security->xss_clean($this->input->post('mobile'))); $county=$this->db->count_all_results('schools'); if($count>0 || $county>0){ redirect('Primary/register_staffs_primary?Exists'); }else{ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number' =>str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10))), 'education' => $this->security->xss_clean($this->input->post('education')), 'skills' => $this->security->xss_clean($this->input->post('skills')), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'password' => MD5($this->security->xss_clean($this->input->post('password'))), 'password_reset' => $this->security->xss_clean($this->input->post('password')), 'category' => 'Teacher', 'title' => 'Teacher', 'type' => 'User', 'registered_year'=>date('Y') ); $this->db->insert('staffs', $data); redirect('Primary/register_staffs_primary?sent'); } } public function register_secretary() { $this->db->where('reg_number', str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10)))); $count=$this->db->count_all_results('staffs'); $this->db->where('school_mobile', $this->security->xss_clean($this->input->post('mobile'))); $county=$this->db->count_all_results('schools'); if($count>0 || $county>0){ redirect('Primary/register_staffs_primary?Exists'); }else{ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number' =>str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10))), 'education' => $this->security->xss_clean($this->input->post('education')), 'skills' => $this->security->xss_clean($this->input->post('skills')), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'password' => MD5($this->security->xss_clean($this->input->post('password'))), 'password_reset' => $this->security->xss_clean($this->input->post('password')), 'category' => 'Secretary', 'title' => 'Secretary', 'type' => 'User', 'registered_year'=>date('Y') ); $this->db->insert('staffs', $data); redirect('Primary/register_staffs_primary?sent'); } } public function register_accountants() { $this->db->where('reg_number', str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10)))); $count=$this->db->count_all_results('staffs'); $this->db->where('school_mobile', $this->security->xss_clean($this->input->post('mobile'))); $county=$this->db->count_all_results('schools'); if($count>0 || $county>0){ redirect('Primary/register_staffs_primary?Exists'); }else{ $data = array( 'school_id'=>$this->session->userdata('school_id'), 'reg_number' =>str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10))), 'education' => $this->security->xss_clean($this->input->post('education')), 'skills' => $this->security->xss_clean($this->input->post('skills')), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'password' => MD5($this->security->xss_clean($this->input->post('password'))), 'password_reset' => $this->security->xss_clean($this->input->post('password')), 'category' => 'Accountant', 'title' => 'Accountant', 'type' => 'User', 'registered_year'=>date('Y') ); $this->db->insert('staffs', $data); redirect('Primary/register_staffs_primary?sent'); } } public function change_position() { $reg=''; $pos=''; $reg_number = $this->security->xss_clean($this->input->post('reg_number')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('title',$this->security->xss_clean($this->input->post('position'))); $get=$this->db->get('staffs'); foreach($get->result() as $row){ $reg=$row->reg_number; $pos=$row->category; } $data = array( 'title' => $this->security->xss_clean($this->input->post('position')), ); $data1 = array( 'title' =>$pos, ); $this->db->where('reg_number', $reg_number); $this->db->update('staffs', $data); $this->db->where('reg_number', $reg); $this->db->update('staffs', $data1); redirect('Primary/register_staffs_primary?changed'); } public function delete_staff(){ $data=array( 'status'=>1, 'released_year'=>date('Y') ); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('reg_number', $this->security->xss_clean($this->input->post('reg_number'))); $this->db->update('staffs',$data); redirect('Primary/register_staffs_primary?deleted'); } public function register_primary_students(){ $chool_name=$this->session->userdata('school_reg_number'); $name= strtoupper(str_replace(array(':', '\\', '/', '*','.','-','_'),'',$chool_name)); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('full_name',$this->security->xss_clean($this->input->post('full_name'))); $this->db->where('class_admitted',$this->security->xss_clean($this->input->post('class_admitted'))); $this->db->where('admission_year',$this->security->xss_clean($this->input->post('admission_year'))); $this->db->where('admission_number',$this->security->xss_clean($this->input->post('admission_number'))); $this->db->where('category',$this->security->xss_clean($this->input->post('category'))); $count= $this->db->count_all_results('students'); if($count>0){ redirect('Primary/register_students_p_level?Exists'); }else{ $cl = 0; $new=''; $reg=''; $check = $this->User_model->check_student(); if (empty($check)) { //Getting the Reg_number $level = $this->security->xss_clean($this->input->post('class_admitted')); if ($level == 1) { $cl = date('Y'); } else if ($level == 2) { $cl = (date('Y') - 1); } else if ($level == 3) { $cl = (date('Y') - 2); } else if ($level == 4) { $cl = (date('Y') - 3); }else if ($level == 5) { $cl = (date('Y') - 4); }else if ($level == 6) { $cl = (date('Y') - 5); } else { $cl = (date('Y') - 7); } //echo $name.' '.$cl;exit(); $current = "P".$name.".".$cl .".".sprintf("%03s",($reg+1)); //dunping data to the database $data = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'birth_day' => $this->security->xss_clean($this->input->post('birth_day')), 'admission_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_admitted' => $this->security->xss_clean($this->input->post('class_admitted')), 'admitted_from' => $this->security->xss_clean($this->input->post('admitted_from')), 'living_place' => $this->security->xss_clean($this->input->post('living_place')), 'nationality' => $this->security->xss_clean($this->input->post('nationality')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'category' => $this->security->xss_clean($this->input->post('category')), 'admission_number'=>$this->security->xss_clean($this->input->post('admission_number')), 'password'=>MD5('default'), 'password_recover'=>'default' ); $data2 = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'academic_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_level' => $this->security->xss_clean($this->input->post('class_admitted')), 'stream' => $this->security->xss_clean($this->input->post('stream')), 'schoolar_type' => $this->security->xss_clean($this->input->post('schoolar_type')), 'category' => $this->security->xss_clean($this->input->post('category')) ); $this->db->insert('students', $data); $this->db->insert('classes', $data2); redirect('Primary/register_students_p_level?Sent'); }else{ foreach ($check as $num) { $reg = $num->reg_number; // echo $reg;exit(); $cl = $num->class_level; $reg = $num->reg_number; $cl = $num->class_level; $new = substr($reg,-8,4); $reg = substr($reg, -3,4); $current = "P".$name.".".$new.'.'.sprintf("%03s",($reg+1)); // echo $num->reg_number.' => '. $current;exit(); //dunping data to the database $data = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'birth_day' => $this->security->xss_clean($this->input->post('birth_day')), 'admission_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_admitted' => $this->security->xss_clean($this->input->post('class_admitted')), 'admitted_from' => $this->security->xss_clean($this->input->post('admitted_from')), 'living_place' => $this->security->xss_clean($this->input->post('living_place')), 'nationality' => $this->security->xss_clean($this->input->post('nationality')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'category' => $this->security->xss_clean($this->input->post('category')), 'admission_number'=>$this->security->xss_clean($this->input->post('admission_number')), 'password'=>MD5('default'), 'password_recover'=>'default' ); $data2 = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'academic_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_level' => $this->security->xss_clean($this->input->post('class_admitted')), 'stream' => $this->security->xss_clean($this->input->post('stream')), 'schoolar_type' => $this->security->xss_clean($this->input->post('schoolar_type')), 'category' => $this->security->xss_clean($this->input->post('category')) ); $this->db->insert('students', $data); $this->db->insert('classes', $data2); redirect('Primary/register_students_p_level?Sent'); } } } } public function register_nursery_students(){ $chool_name=$this->session->userdata('school_reg_number'); $name= strtoupper(str_replace(array(':', '\\', '/', '*','.','-','_'),'',$chool_name)); $category=substr($this->security->xss_clean($this->input->post('class_admitted')),0,1); $level = substr($this->security->xss_clean($this->input->post('class_admitted')),1,10); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->where('full_name',$this->security->xss_clean($this->input->post('full_name'))); $this->db->where('class_admitted',$this->security->xss_clean($this->input->post('class_admitted'))); $this->db->where('admission_year',$this->security->xss_clean($this->input->post('admission_year'))); $this->db->where('admission_number',$this->security->xss_clean($this->input->post('admission_number'))); $this->db->where('category',$category); $count= $this->db->count_all_results('students'); if($count>0){ redirect('Primary/register_students_n_level?Exists'); }else{ $cl = 0; $new=''; $reg=''; $check = $this->User_model->check_student_n(); if (empty($check)) { //Getting the Reg_number $level = substr($this->security->xss_clean($this->input->post('class_admitted')),1,10); //echo $level;exit(); if ($level == 1) { $cl = date('Y'); } else if ($level == 2) { $cl = (date('Y') - 1); } else if ($level == 3) { $cl = (date('Y') - 2); } else if ($level == 4) { $cl = (date('Y') - 3); }else if ($level == 5) { $cl = (date('Y') - 4); }else if ($level == 6) { $cl = (date('Y') - 5); } else { $cl = (date('Y') - 7); } //echo $name.' '.$cl;exit(); $current = $category.$name.".".$cl .".".sprintf("%03s",($reg+1)); //dunping data to the database // echo $current; exit(); $data = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'birth_day' => $this->security->xss_clean($this->input->post('birth_day')), 'admission_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_admitted' => $level, 'admitted_from' => $this->security->xss_clean($this->input->post('admitted_from')), 'living_place' => $this->security->xss_clean($this->input->post('living_place')), 'nationality' => $this->security->xss_clean($this->input->post('nationality')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'category' =>$category, 'admission_number'=>$this->security->xss_clean($this->input->post('admission_number')), 'password'=>MD5('default'), 'password_recover'=>'default' ); $data2 = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'academic_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_level' => $level, 'stream' => $this->security->xss_clean($this->input->post('stream')), 'schoolar_type' => $this->security->xss_clean($this->input->post('schoolar_type')), 'category' => $category ); $this->db->insert('students', $data); $this->db->insert('classes', $data2); redirect('Primary/register_students_n_level?Sent'); }else{ foreach ($check as $num) { $reg = $num->reg_number; // echo $reg;exit(); $cl = $num->class_level; $reg = $num->reg_number; $cl = $num->class_level; $new = substr($reg,-8,4); $reg = substr($reg, -3,4); $current = $category.$name.".".$new.'.'.sprintf("%03s",($reg+1)); // echo $num->reg_number.' => '. $current;exit(); //dunping data to the database $data = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'birth_day' => $this->security->xss_clean($this->input->post('birth_day')), 'admission_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_admitted' => $level, 'admitted_from' => $this->security->xss_clean($this->input->post('admitted_from')), 'living_place' => $this->security->xss_clean($this->input->post('living_place')), 'nationality' => $this->security->xss_clean($this->input->post('nationality')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), 'category' => $category, 'admission_number'=>$this->security->xss_clean($this->input->post('admission_number')), 'password'=>MD5('default'), 'password_recover'=>'default' ); $data2 = array( 'reg_number' => $current, 'school_id' => $this->session->userdata('school_id'), 'academic_year' => $this->security->xss_clean($this->input->post('admission_year')), 'class_level' => $level, 'stream' => $this->security->xss_clean($this->input->post('stream')), 'schoolar_type' => $this->security->xss_clean($this->input->post('schoolar_type')), 'category' => $category ); $this->db->insert('students', $data); $this->db->insert('classes', $data2); redirect('Primary/register_students_n_level?Sent'); } } } } public function edit_student_info(){ $reg_number=$this->security->xss_clean($this->input->post('reg_number')); $data = array( 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'birth_day' => $this->security->xss_clean($this->input->post('birth_day')), 'admission_year' => $this->security->xss_clean($this->input->post('admission_year')), // 'class_admitted' => $this->security->xss_clean($this->input->post('class_admitted')), 'admitted_from' => $this->security->xss_clean($this->input->post('admitted_from')), 'living_place' => $this->security->xss_clean($this->input->post('living_place')), 'nationality' => $this->security->xss_clean($this->input->post('nationality')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')) ); $this->db->where('reg_number', $reg_number); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->update('students', $data); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&&message=edited'); } public function edit_staff_info(){ $reg_number=str_replace("-","",('0'.substr($this->security->xss_clean($this->input->post('mobile')), -10))); $data = array( 'education' => $this->security->xss_clean($this->input->post('education')), 'skills' => $this->security->xss_clean($this->input->post('skills')), 'full_name' => $this->security->xss_clean($this->input->post('full_name')), 'gender' => $this->security->xss_clean($this->input->post('gender')), 'email' => $this->security->xss_clean($this->input->post('email')), 'mobile' => $this->security->xss_clean($this->input->post('mobile')), //'password' => MD5($this->security->xss_clean($this->input->post('password'))), //'/password_reset' => $this->security->xss_clean($this->input->post('password')), ); $this->db->where('reg_number', $reg_number); $this->db->where('school_id', $this->session->userdata('school_id')); $this->db->update('staffs', $data); redirect('Primary/staffs_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function change_class(){ $reg_number = $this->security->xss_clean($this->input->post('reg_number')); $data1 = array( 'class_level' => $this->security->xss_clean($this->input->post('class_level')), 'stream' => $this->security->xss_clean($this->input->post('stream')), 'academic_year' => date('Y'), ); $this->db->select('class_level'); $this->db->select('stream'); $this->db->select('academic_year'); $this->db->where('reg_number', $reg_number); $this->db->where('category', $this->security->xss_clean($this->input->post('category'))); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function change_stream(){ $reg_number = $this->security->xss_clean($this->input->post('reg_number')); $data1 = array( 'stream' => $this->security->xss_clean($this->input->post('stream')) ); $this->db->select('stream'); $this->db->where('reg_number', $reg_number); $this->db->where('category', $this->security->xss_clean($this->input->post('category'))); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function change_schoolar_type(){ $reg_number = $this->security->xss_clean($this->input->post('reg_number')); $data1 = array( 'schoolar_type' => $this->security->xss_clean($this->input->post('schoolar_type')) ); $this->db->select('schoolar_type'); $this->db->where('reg_number', $reg_number); $this->db->where('category', $this->security->xss_clean($this->input->post('category'))); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function dismiss_student(){ $reason=$this->security->xss_clean($this->input->post('reason')); $reg_number =$this->security->xss_clean($this->input->post('reg_number')); $data1 = array( 'status' => 1 ); $data2 = array( 'school_id' =>$this->session->userdata('school_id'), 'reg_number' =>$reg_number, 'reason' => $reason ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); $this->db->insert('dismissed_students', $data2); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&&message=edited'); } public function restore_dismissed(){ $reg_number = base64_decode($_REQUEST['id']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); $this->db->where('reg_number', $reg_number); $this->db->delete('dismissed_students'); redirect('Primary/students_details_primary?id='.base64_encode($reg_number).'&&message=edited'); } public function restore_primary_dismissed(){ $reg_number = base64_decode($_REQUEST['id']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); $this->db->where('reg_number', $reg_number); $this->db->delete('dismissed_students'); redirect('Primary/dismissed_students_p_level'); } public function restore_nursery_dismissed(){ $reg_number = base64_decode($_REQUEST['id']); $data1 = array( 'status' => 0 ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->where('academic_year', date('Y')); $this->db->update('classes', $data1); $this->db->where('reg_number', $reg_number); $this->db->delete('dismissed_students'); redirect('Primary/dismissed_students_n_level'); } public function dismiss_teacher(){ $reg_number = base64_decode($_REQUEST['id']); $data1 = array( 'status' => 1, 'released_year'=>date('Y') ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->update('staffs', $data1); redirect('Primary/staffs_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function restore_teacher_dismissed(){ $reg_number = base64_decode($_REQUEST['id']); $data1 = array( 'status' => 0, 'released_year'=>'--' ); $this->db->select('status'); $this->db->where('reg_number', $reg_number); $this->db->update('staffs', $data1); redirect('Primary/staffs_details_primary?id='.base64_encode($reg_number).'&& message=edited'); } public function search_graduate_p() { $year= $this->security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

GRADUATES LIST IN

GRADUATES LIST IN <?php echo $year ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('category',$category); $this->db->where('class_level',7); $this->db->where('academic_year',$year); $this->db->where('status',0); $get=$this->db->get('classes'); foreach($get->result() as $rows){ $this->db->where('reg_number',$rows->reg_number); $gety=$this->db->get('students'); foreach($gety->result() as $row){ $i++; ?>
S/N Reg Number Name Gnder Class Schoolar Mobile Email
S/N Reg Number Name Gnder Class Schoolar Mobile Email
reg_number;?> full_name;?> gender;?> class_level.' - '.$rows->stream;?> schoolar_type=='D'){ echo 'Day'; }elseif($rows->schoolar_type=='B'){ echo 'Boarding'; }else{ echo 'Undifined schoolar type, Pleas contact your admin'; } ?> mobile;?> email;?>
security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

GRADUATES LIST IN

GRADUATES LIST IN <?php echo $year ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('category',$category); $this->db->where('class_level',2); $this->db->where('academic_year',$year); $this->db->where('status',0); $get=$this->db->get('classes'); foreach($get->result() as $rows){ $this->db->where('reg_number',$rows->reg_number); $gety=$this->db->get('students'); foreach($gety->result() as $row){ $i++; ?>
S/N Reg Number Name Gnder Class Schoolar Mobile Email
S/N Reg Number Name Gnder Class Schoolar Mobile Email
reg_number;?> full_name;?> gender;?> class_level.' - '.$rows->stream;?> schoolar_type=='D'){ echo 'Day'; }elseif($rows->schoolar_type=='B'){ echo 'Boarding'; }else{ echo 'Undifined schoolar type, Pleas contact your admin'; } ?> mobile;?> email;?>
security->xss_clean($this->input->post('date')); $payment_type= $this->security->xss_clean($this->input->post('bank_type')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$payment_type); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ $bankk= $b->name; } ?>

ACCOUNT PAYMENTS RECORDS ON

Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_deposited',$date); $this->db->where('bank',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo ' Tsh '.number_format($amount->amount); } } ?>

ACCOUNT LIST OF STUDENTS PAID IN THIS DATE ()

<?php echo $bankk ?> ACCOUNT LIST OF STUDENTS PAID ON (<?php echo $date ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_deposited',$date); $this->db->where('bank',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('date')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

SCHOOL FEES PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total= Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total= Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN THIS DATE ()

LIST OF STUDENTS PAID ON (<?php echo $date ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $this->db->where('payment_type',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('date_received')); ?>

STUDENTS PAYMENTS RECORDS RECEIVED ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total= Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total= Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAYMENTS RECEIVED ON

LIST OF STUDENTS PAYMENTS RECEIVED ON <?php echo $date ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Paid for Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> amount); ?>
security->xss_clean($this->input->post('date_deposited')); ?>

STUDENTS PAYMENTS RECORDS DEPOSITED ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_deposited',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_deposited',$date); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_deposited',$date); $this->db->where('payment_method','Payslip'); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAYMENTS DEPOSITED ON

LIST OF STUDENTS PAYMENTS DEPOSITED ON <?php echo $date ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_deposited',$date); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Paid for Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> amount); ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

SCHOOL FEES PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN THIS DATE ()

LIST OF STUDENTS PAID ON (<?php echo $month .' - '.$year; ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('bank_type')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$payment_type); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ $bankk= $b->name; } ?>

ACCOUNT PAYMENTS RECORDS ON

Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('bank',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo ' Tsh '.number_format($amount->amount); } } ?>

ACCOUNT LIST OF STUDENTS PAID ON

<?php echo $bankk ?> ACCOUNT LIST OF STUDENTS PAID ON <?php echo $month .' - '.$year; ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('bank',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('month_received')); $year= $this->security->xss_clean($this->input->post('year')); ?>

SCHOOL FEES PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAYMENTS RECEIVED ON

LIST OF STUDENTS PAYMENTS RECEIVED ON(<?php echo $month .' - '.$year; ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('month_deposited')); $year= $this->security->xss_clean($this->input->post('year')); ?>

PAYMENTS RECORDS DEPOSITED ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month_deposited',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month_deposited',$month); $this->db->where('paid_year',$year); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month_deposited',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month_deposited',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAYMENTS DEPOSITED ON

LIST OF STUDENTS PAYMENTS DEPOSITED ON <?php echo $month .' - '.$year; ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month_deposited',$month); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

SCHOOL FEES PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $this->db->where('payment_type',$payment_type); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN THIS YEAR ()

LIST OF STUDENTS PAID ON (<?php echo $year ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('payment_type',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('bank_type')); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$payment_type); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ $bankk= $b->name; } ?>

ACCOUNT PAYMENTS RECORDS ON

Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('bank',$payment_type); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo ' Tsh '.number_format($amount->amount); } } ?>

ACCOUNT LIST OF STUDENTS PAID IN

<?php echo $bankk ?> ACCOUNT LIST OF STUDENTS PAID ON (<?php echo $year ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('bank',$payment_type); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('year')); $payment_type= $this->security->xss_clean($this->input->post('payment_type')); ?>

PAYMENTS RECORDS IN

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN

LIST OF STUDENTS PAID IN <?php echo $year ?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('payment_type')); $date= $this->security->xss_clean($this->input->post('date')); $type_name=''; if($import=='All'){ ?>

STUDENTS PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

STUDENTS LIST PAID IN THIS DATE ()

LIST OF STUDENTS PAID ON (<?php echo $date ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('date')); $list= substr($import,0,1); $type= substr($import,1,2); if($type=='N'){ $type_name='NURSERY '; }elseif($type=='P'){ $type_name='STANDARD '; }else{ $type_name='FORM '; } ?>

PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

STUDENTS LIST PAID IN THIS DATE ()

LIST OF STUDENTS PAID ON (<?php echo $date ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date_issued',$date); $this->db->where('class_level',$list); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('payment_type')); $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); if($import=='All'){ $type_name=''; $list= substr($import,0,1); $type= substr($import,1,2); if($type=='N'){ $type_name='NURSERY '; }elseif($type=='P'){ $type_name='STANDARD '; }else{ $type_name='FORM '; } ?>

STUDENTS PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cas Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

STUDENTS LIST PAID ON ()

LIST OF STUDENTS PAID ON (<?php echo $month .' - '.$year; ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class level Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>

PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('class_level',$list); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

STUDENTS LIST PAID ON ()

LIST OF STUDENTS PAID ON (<?php echo $month .' - '.$year; ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('year')); $import= $this->security->xss_clean($this->input->post('payment_type')); if($import=='All'){ $type_name=''; $list= substr($import,0,1); $type= substr($import,1,2); if($type=='N'){ $type_name='NURSERY '; }elseif($type=='P'){ $type_name='STANDARD '; }else{ $type_name='FORM '; } ?>

STUDENTS PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN THIS YEAR ()

LIST OF STUDENTS PAID ON (<?php echo $year ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Class Level Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number); $this->db->where('academic_year', $ro->paid_year); $get=$this->db->get('classes'); foreach($get->result() as $rows){ if($rows->category=='N'){ echo 'Nursery '.$ro->class_level; }elseif($rows->category=='P'){ echo 'Standard '.$ro->class_level; }else{ echo 'Form '.$ro->class_level; } } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>

STUDENTS PAYMENTS RECORDS ON

Payslip Amountdb->distinct(); $this->db->select('bank'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $bank){ $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $this->db->where('bank', $bank->bank); $getys=$this->db->get('transactions'); foreach($getys->result() as $bankamount){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$bank->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name.' Account = '.number_format($bankamount->amount).'
'; } } } echo '
'; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Payslip'); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Payslip Total = Tsh '.number_format($amount->amount); } } ?>
Cash Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_method','Cash'); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Cash Total = Tsh '.number_format($amount->amount); } } ?>
Total Amount db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $gety=$this->db->get('transactions'); foreach($gety->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Grand Total = Tsh '.number_format($amount->amount); } } ?>

LIST OF STUDENTS PAID IN THIS YEAR ()

LIST OF STUDENTS PAID ON (<?php echo $year ?>)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('paid_year',$year); $this->db->where('class_level',$list); $get=$this->db->get('transactions'); foreach($get->result() as $ro){?>
Full Name Payment Type Payment Method Bank Amount Paid (Tsh)
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number', $ro->reg_number ); $gety=$this->db->get('students'); foreach($gety->result() as $row){ echo $row->full_name; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$ro->payment_type); foreach($this->db->get('payments_type')->result() as $rows){ echo $rows->name; } ?> payment_method; ?> bank==''||$ro->bank=='none'){ echo '---'; }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('bank_id',$ro->bank); $get_bank=$this->db->get('banks'); foreach($get_bank->result() as $b){ echo $b->name; }} ?> amount); ?>
security->xss_clean($this->input->post('year')); ?>

STUDENTS PAYMENTS RECORDS FOR ACADEMIC YEAR

STUDENTS PAYMENTS RECORDS FOR <?php echo $year ?> ACADEMIC YEAR
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('status',0); $get=$this->db->get('classes'); foreach($get->result() as $row){?>
Full Name Class Level Amount Required Amount Paid Amount Remained Status
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$row->reg_number); foreach($this->db->get('students')->result() as $name){ echo $name->full_name; $reg_number=$name->reg_number; } ?> category=='N'){ echo 'Nursery '.$row->class_level; }elseif($row->category=='P'){ echo 'Standard '.$row->class_level; }else{ echo 'Form '.$row->class_level; } ?> db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); // $this->db->where('schoolars_type',$row->schoolar_type); $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check1=$this->db->count_all_results('reduced_payments'); if($check1>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowff){ $required1 = $required1+$rowff->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; } }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowff){ $required1 = $required1+$rowff->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowff->amount).'
'; } } } /// finding amounts for different schoolars type $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('class_level',$row->class_level); $this->db->where('students_type',$row->category); $this->db->where('schoolars_type',$row->schoolar_type); // $this->db->where('schoolars_type',2); $get=$this->db->get('payers'); foreach($get->result() as $rows){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $check2=$this->db->count_all_results('reduced_payments'); if($check2>0){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$reg_number); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('reduced_payments'); foreach($get_feee->result() as $rowffs){ $required2 = $required2 + $rowffs->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; } }else{ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$rows->payer_id); $this->db->where('payment_id',$rows->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowffs){ $required2 = $required2 + $rowffs->amount; // echo 'Payer id = '. $rows->payer_id.', schoolar type = '.$rows->schoolars_type.' Amount ='.number_format($rowffs->amount).'
'; } } } $total_required=$required1+$required2; echo number_format($total_required); ?> 		db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; if($paid==0 || $paid==''){ echo '---'; }else{ echo number_format($paid); } } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; } if($total_required>$paid){ echo number_format($total_required-$paid); }elseif($total_required==$paid){ echo '---'; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; } if($total_required<$paid){ echo 'Complete'; }else{ echo 'Not complete'; } ?>
security->xss_clean($this->input->post('amount'))); if($amount=='' || $amount==0){ echo 'Fill Amount'; }else{ $year= date('Y'); ?>

STUDENTS LIST PAID BELOW Tsh. RECORDS FOR ACADEMIC YEAR

STUDENTS LIST PAID BELOW <b>Tsh. <?php echo number_format($amount) ?></b> RECORDS FOR <?php echo $year ?> ACADEMIC YEAR
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('status',0); $get=$this->db->get('classes'); foreach($get->result() as $row){ $paid=0; $this->db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('reg_number',$row->reg_number); $get_trans=$this->db->get('transactions'); foreach($get_trans->result() as $paid_amount){ $paid=$paid_amount->amount; if($paid<$amount){?>
Full Name Class Level Amount Paid
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('reg_number',$row->reg_number); foreach($this->db->get('students')->result() as $name){ echo $name->full_name; } ?> category=='N'){ echo 'Nursery '.$row->class_level; }elseif($row->category=='P'){ echo 'Standard '.$row->class_level; }else{ echo 'Form '.$row->class_level; } ?>
security->xss_clean($this->input->post('year')); ?>

GENERAL PAYMENTS REPORTS FOR ACADEMIC YEAR

GENERAL PAYMENTS REPORTS FOR <?php echo $year ?> ACADEMIC YEAR
Total Number of Students db->where('school_id',$this->session->userdata('school_id')); $this->db->where('status',0); $this->db->where('academic_year',$year); $count=$this->db->count_all_results('classes'); echo $count; ?>
Total Amount Required db->where('school_id',$this->session->userdata('school_id')); $get=$this->db->get('payers'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('payment_id',$row->payment_id); $fee_type=$this->db->get('payments_type'); foreach($fee_type->result() as $ro){ $name=$ro->name; } if($row->schoolars_type==2){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('status',0); $this->db->where('class_level',$row->class_level); $this->db->where('category',$row->students_type); $this->db->where('academic_year',$year); $countt1=$this->db->count_all_results('classes'); //selecting from the register fees table $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$row->payer_id); $this->db->where('payment_id',$row->payment_id); $get_fee=$this->db->get('register_fees'); foreach($get_fee->result() as $rowf){ $total_amount1=$rowf->amount*$countt1; // echo 'Total= '.number_format($total_amount1).'
'; // echo 'Amount = '.$rowf->amount.' Total= '.$total_amount1.' '. $name.' |'. $row->payment_id.' '.$row->payer_id.' '.$row->class_level.' '.$row->students_type.' '.$row->schoolars_type.' both schoolar type = '.$countt1.'
'; $sum+= $total_amount1; } }else{ $total_amount2=0; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('status',0); $this->db->where('class_level',$row->class_level); $this->db->where('schoolar_type',$row->schoolars_type); $this->db->where('category',$row->students_type); $this->db->where('academic_year',$year); $countt2=$this->db->count_all_results('classes'); //selecting from the register fees table $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('payer_id',$row->payer_id); $this->db->where('payment_id',$row->payment_id); $get_feee=$this->db->get('register_fees'); foreach($get_feee->result() as $rowff){ $total_amount2=$rowff->amount*$countt2; // echo ' Total= '.number_format($total_amount2).' '.'
'; // echo 'Amount = '.$rowff->amount.' Total= '.$total_amount2.' '. $name.' |'.$row->payment_id.' '.$row->payer_id.' '.$row->class_level.' '.$row->schoolars_type.' schoolar ='.$countt2.'
'; $sum1+= $total_amount2; } } } $required=$sum+ $sum1; echo 'Tsh '. number_format(($required)).' There is something to do'; ?>
Amount Paid db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); foreach($this->db->get('transactions')->result() as $amount){ if($amount->amount=='' || $amount->amount==0){ echo '---'; }else{ echo 'Tsh '.number_format($amount->amount); } $paid_amount=$amount->amount; } ?>
Amount Remained $paid_amount){ echo 'Tsh '.number_format($required-$paid_amount); }elseif($required=$paid_amount){ echo '---'; }else{ echo '---'; } ?>
security->xss_clean($this->input->post('date')); $income_type= $this->security->xss_clean($this->input->post('income_type')); if($income_type=='All'){?>

REVENUE COLLECTED ON

db->distinct(); $this->db->select('income'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $get=$this->db->get('revenue'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$row->income); $gety=$this->db->get('income'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $this->db->where('income',$row->income); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $income_type= $this->security->xss_clean($this->input->post('income_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$income_type); $gety=$this->db->get('income'); foreach($gety->result() as $t){ $name= $t->name; } ?>

REVENUE COLLECTED ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $this->db->where('income',$income_type); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $date1= $this->security->xss_clean($this->input->post('date1')); $income_type= $this->security->xss_clean($this->input->post('income_type')); if($income_type=='All'){?>

REVENUE COLLECTED ON

db->distinct(); $this->db->select('income'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $get=$this->db->get('revenue'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$row->income); $gety=$this->db->get('income'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $this->db->where('income',$row->income); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $date1= $this->security->xss_clean($this->input->post('date1')); $income_type= $this->security->xss_clean($this->input->post('income_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$income_type); $gety=$this->db->get('income'); foreach($gety->result() as $t){ $name= $t->name; } ?>

REVENUE COLLECTED ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $this->db->where('income',$income_type); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $income_type= $this->security->xss_clean($this->input->post('income_type')); if($income_type=='All'){?>

REVENUE COLLECTED ON

db->distinct(); $this->db->select('income'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $get=$this->db->get('revenue'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$row->income); $gety=$this->db->get('income'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('income',$row->income); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $income_type= $this->security->xss_clean($this->input->post('income_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$income_type); $gety=$this->db->get('income'); foreach($gety->result() as $t){ $name= $t->name; } ?>

REVENUE COLLECTED ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('income',$income_type); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $income_type= $this->security->xss_clean($this->input->post('income_type')); if($income_type=='All'){?>

REVENUE COLLECTED ON

db->distinct(); $this->db->select('income'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $get=$this->db->get('revenue'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$row->income); $gety=$this->db->get('income'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('income',$row->income); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $income_type= $this->security->xss_clean($this->input->post('income_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('income_id',$income_type); $gety=$this->db->get('income'); foreach($gety->result() as $t){ $name= $t->name; } ?>

REVENUE COLLECTED ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('income',$income_type); $gets=$this->db->get('revenue'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); if($expenses_type=='All'){?>

EXPENDITURES ON

db->distinct(); $this->db->select('expenditure'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $get=$this->db->get('expenditures'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$row->expenditure); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $this->db->where('expenditure',$row->expenditure); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$expenses_type); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ $name= $t->name; } ?>

EXPENDITURES ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date',$date); $this->db->where('expenditure',$expenses_type); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $date1= $this->security->xss_clean($this->input->post('date1')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); if($expenses_type=='All'){?>

EXPENDITURES ON

db->distinct(); $this->db->select('expenditure'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $get=$this->db->get('expenditures'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$row->expenditure); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $this->db->where('expenditure',$row->expenditure); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('date')); $date1= $this->security->xss_clean($this->input->post('date1')); $income_type= $this->security->xss_clean($this->input->post('income_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$expenses_type); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ $name= $t->name; } ?>

EXPENDITURES ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('date >=', $date); $this->db->where('date <=', $date1); $this->db->where('expenditure',$expenses_type); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); if($expenses_type=='All'){?>

EXPENDITURES ON

db->distinct(); $this->db->select('expenditure'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $get=$this->db->get('expenditures'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$row->expenditure); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('expenditure',$row->expenditure); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$expenses_type); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ $name= $t->name; } ?>

EXPENDITURES ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('expenditure',$expenses_type); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); if($expenses_type=='All'){?>

EXPENDITURES ON

db->distinct(); $this->db->select('expenditure'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $get=$this->db->get('expenditures'); foreach($get->result() as $row){?>
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$row->expenditure); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ echo $t->name; } ?> db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('expenditure',$row->expenditure); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('year')); $expenses_type= $this->security->xss_clean($this->input->post('expenses_type')); $name=''; $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('expenses_id',$expenses_type); $gety=$this->db->get('expenses'); foreach($gety->result() as $t){ $name= $t->name; } ?>

EXPENDITURES ON

TOTAL db->select_sum('amount'); $this->db->where('school_id',$this->session->userdata('school_id')); //$this->db->where('month',$month); $this->db->where('year',$year); $this->db->where('expenditure',$expenses_type); $gets=$this->db->get('expenditures'); foreach($gets->result() as $r){ echo 'Tsh '.number_format($r->amount); } ?>
input->post('exam_id'); $exam_name = $district_exam = $region=""; $can = "NC"; $candidate = "NC"; $this->db->where('examination_id',$exam_id); $s = $this->db->get('examination'); foreach($s->result() as $ex){ $exam_name = $ex->exam_name; $district_exam = $ex->district; $region = $ex->region; $year = $ex->academic_year; $class = $ex->class_level; $category = $ex->category; $month = $ex->month; $exam_status = $ex->status; } $school = $this->session->userdata('school_id'); $this->db->where('students_type',$category); $this->db->where('level',$class); foreach($this->db->get('class_levels')->result() as $a){ $class_name = $a->name; } ?>

STANDARD


Print full Sheet by Position       Print full Sheet Alphabetically      
Print full Sheet by Numbers      

Print all reports (Kiswahili)       Print all reports (English)

PRINT SUBJECTS RANKS     PRINT SUBJECTS GRADE REPORT     PRINT BEST STUDENTS IN SUBJECTS


db->where('school_id',$this->session->userdata('school_id')); $this->db->where('academic_year',$year); $this->db->where('month',$month); $this->db->where('class_level',$class); $this->db->where('category',$category); $this->db->where('exam_id',$exam_id); $this->db->order_by('all_position','asc'); $get_results=$this->db->get('monthly_results'); foreach($get_results->result() as $results){?>
ID/NUMBER NAME TOTAL MARKS AVERAGE GRADE POSITION KISWAHILI ENGLISH
reg_number,-3);?> reg_number; $this->db->where('reg_number',$reg_number); $this->db->where('school_id',$this->session->userdata('school_id')); $get_students=$this->db->get('students'); foreach($get_students->result() as $tudent){ echo strtoupper($tudent->full_name); } ?> total_marks;?> average;?> grade;?> all_position;?> view more... view more...
security->xss_clean($this->input->post('class_level')); $month= $this->security->xss_clean($this->input->post('month')); $year= $this->security->xss_clean($this->input->post('academic_year')); $category='P'; $month_name; $this->db->where('month_id', $month); $gett=$this->db->get('primary_months'); foreach($gett->result() as $rows){ $month_name=$rows->name; } ?>

STANDARD MONTHLY TEST ()

STANDARD <?php echo $class.' '.$month. ' '.$year ?> MONTHLY TEST
db->where('school_id',$this->session->userdata('school_id')); $this->db->where('students_type','P'); $get=$this->db->get('grading_method'); foreach($get->result() as $row){ if($row->grading=='Average'){ $this->db->distinct(); $this->db->select('reg_number'); $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('academic_year',$year); $this->db->where('class_level',$class); $this->db->where('category', $category); $get_reg=$this->db->get('ca'); foreach($get_reg->result() as $row_reg){ $number_of_sudents++; $number_of_subjects=0; $sum_of_marks=0; $average_of_marks=0; echo $row_reg->reg_number.'
'; echo 'Average Calculations'.'
'; //finding subjects which are included in calculations $this->db->where('class_level',$class); $this->db->where('students_type', $category); $this->db->where('school_id', $this->session->userdata('school_id')); $gett= $this->db->get('subjects_calculations'); foreach($gett->result() as $rowt){ $this->db->where('subject_id',$rowt->subject_id); $this->db->where('school_id', $this->session->userdata('school_id')); $getf= $this->db->get('general_subjects'); foreach($getf->result() as $rowf){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('month',$month); $this->db->where('academic_year',$year); $this->db->where('class_level',$class); $this->db->where('reg_number',$row_reg->reg_number); $this->db->where('category', $category); $this->db->where('subject_id', $rowt->subject_id); $get_ca=$this->db->get('ca'); foreach($get_ca->result() as $row_ca){ $number_of_subjects++; $sum_of_marks=$sum_of_marks+$row_ca->mark; echo $rowt->subject_id.' = '.$rowf->subject_name.' = ' .$row_ca->mark.'
'; } } } $average_of_marks=($sum_of_marks/$number_of_subjects); $average_of_marks=round($average_of_marks,2); echo 'Number of subjects attempted = '.$number_of_subjects.' Sum of marks = '.$sum_of_marks.' Average = '.$average_of_marks.'

'; } echo 'Number of students = '.$number_of_sudents; }elseif($row->grading=='Division'){ echo 'Division calculations'; }elseif($row->grading=='GPA'){ echo 'GPA calculations'; }else{ echo 'Undifined calculations'; } } ?>
security->xss_clean($this->input->post('class_level')); $mid_term= $this->security->xss_clean($this->input->post('mid_term')); $year= $this->security->xss_clean($this->input->post('academic_year')); ?>

STANDARD MID-TERM TEST ( OF TERM )

STANDARD <?php echo $class.' - '.$year ?> MID-TERM TEST ( OF TERM <?php echo $mid_term ?>)</b>

Results goes here

security->xss_clean($this->input->post('class_level')); $term= $this->security->xss_clean($this->input->post('term')); $year= $this->security->xss_clean($this->input->post('academic_year')); ?>

STANDARD TERM RESULTS

STANDARD <?php echo $class.' - '.$year ?> TERM <?php echo $term ?> RESULTS</b>

Results goes here

session->userdata('type'); $title=$this->session->userdata('title'); if($type=='Admin' || $title=='Manager'){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/reports_settings'); $this->load->view('includes/primary/primary_footer'); }else{ $this->db->like('name',$title); $get=$this->db->get('general_accounts'); foreach($get->result() as $row){ $this->db->where('school_id',$this->session->userdata('school_id')); $this->db->where('activity_id',3); $this->db->where('account_id',$row->account_id); $count=$this->db->count_all_results('access_levels'); if($count>0){ $this->load->view('includes/primary/primary_header'); $this->load->view('users/primary/reports_settings'); $this->load->view('includes/primary/primary_footer'); }else{ redirect('Private_area'); } } } } 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('Primary/reports_settings?sent'); } public function user_data_submit_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'); if($students_type=='A'){ $academic_year=$this->session->userdata('academic_year_a_level'); }else{ $academic_year=date('Y'); } //echo $students_type;exit(); $this->db->where('level',$class_level); $this->db->where('school_id',$this->session->userdata('school_id')); $get=$this->db->get('primary_class_levels'); 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('Primary/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'); }else{ $academic_year=date('Y'); } $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('primary_class_levels'); foreach($get->result() as $ro){?>

Instructions report To name?>

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

input->post('password1'); $pass2 = $this->input->post('password2'); if ($pass1 == $pass2) { $pass = $this->User_model->check_password1(); if ($pass > 0) { $pass = $this->input->post('password'); $data1['password'] = MD5($pass); if ($_POST) { $this->User_model->change_passwords1(); $this->User_model->change_passwords_reset1(); redirect('Primary?Changed'); } else { redirect('Primary'); } } else { redirect('Primary?Error'); } } else { redirect('Primary?Error1'); } } //function to logout and destroy sessions public function logout() { //finding url $url=''; $this->db->where('school_id',$this->session->userdata('school_id')); $get=$this->db->get('schools'); foreach($get->result() as $row){ $url=$row->url; } if($this->session->userdata('type')=='Admin'){ $data = ['school_reg_number', 'school_reg_number']; $this->session->unset_userdata($data); if($url==''){ //redirecting to normal page redirect('Welcome/login'); }else{ redirect('Welcome/login/'.$url); } }else{ $data = ['reg_number', 'reg_number']; $this->session->unset_userdata($data); if($url==''){ //redirecting to normal page redirect('Welcome/login'); }else{ redirect('Welcome/login/'.$url); } } } }