<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>88</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>215</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>216</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>217</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>218</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>219</b><br />
<br />
<b>Warning</b>:  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 <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>220</b><br />
<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class User_model extends CI_Model {
	
	public function staff_profile() {
        $this->db->where('username', $this->session->userdata('username'));
        $query1 = $this->db->get('users');
        return $query1->result();
    }
	
	public function subjects() {
		$this->db->where('programme_id', $this->input->post('programme'));
		$this->db->order_by('course_code','ASC');
		 $query1 = $this->db->get('student_courses');
		return $query1->result();
	}
	public function get_records() {
		if(isset($_REQUEST['id'])){
		$code = base64_decode($_REQUEST['id']);
        $this->db->where('academic_year', date('Y'));
        $this->db->where('course_code', $code);
		$query = $this->db->get('evaluations');
        return $query->result();
		}
    }
	public function get_full_report() {
        $this->db->where('academic_year', date('Y'));
		$query = $this->db->get('evaluations');
        return $query->result();
    }
	public function get_tutors() {
        //$this->db->where('category','LECTURER');
		$query = $this->db->get('users');
        return $query->result();
    }
	public function report() {
		$this->db->distinct();
		$this->db->select('course_code');
		$this->db->select('semester');
		$this->db->select('academic_year');
		$c = $this->db->get('evaluations');
		foreach($c->result() as $code){
			$this->db->where('course_code',$code->course_code);
			$count = $this->db->count_all_results('report');
			if($count == 0){
				$data = array(
					'course_code' =>$code->course_code,
					'semester' =>$code->semester,
					'academic_year' =>$code->academic_year
				);
				$this->db->insert('report', $data);
			}
		}
    }
	
	public function update_report(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			//echo $no." kjbbkbkbkbdsflhgfjh";
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_1a == 'A'){ $mark1a = 5; $a++;}if($evaluations->_1a == 'B'){ $mark1a = 4; $b++;}if($evaluations->_1a == 'C'){ $mark1a = 3; $c++;}if($evaluations->_1a == 'D'){ $mark1a = 2; $d++;}if($evaluations->_1a == 'E'){ $mark1a = 1; $e++;}

			if($evaluations->_1b == 'A'){ $mark1b = 5; $a++;}if($evaluations->_1b == 'B'){ $mark1b = 4; $b++;}if($evaluations->_1b == 'C'){ $mark1b = 3; $c++;}if($evaluations->_1b == 'D'){ $mark1b = 2; $d++;}if($evaluations->_1b == 'E'){ $mark1b = 1; $e++;}
		
			if($evaluations->_2a == 'A'){ $mark2a = 5; $a++;}if($evaluations->_2a == 'B'){ $mark2a = 4; $b++;}if($evaluations->_2a == 'C'){ $mark2a = 3; $c++;}if($evaluations->_2a == 'D'){ $mark2a = 2; $d++;}if($evaluations->_2a == 'E'){ $mark2a = 1; $e++;}
		
			if($evaluations->_2b == 'A'){ $mark2b = 5; $a++;}if($evaluations->_2b == 'B'){ $mark2b = 4; $b++;}if($evaluations->_2b == 'C'){ $mark2b = 3; $c++;}if($evaluations->_2b == 'D'){ $mark2b = 2; $d++;}if($evaluations->_2b == 'E'){ $mark2b = 1; $e++;}
		
			if($evaluations->_3a == 'A'){ $mark3a = 5; $a++;}if($evaluations->_3a == 'B'){ $mark3a = 4; $b++;}if($evaluations->_3a == 'C'){ $mark3a = 3; $c++;}if($evaluations->_3a == 'D'){ $mark3a = 2; $d++;}if($evaluations->_3a == 'E'){ $mark3a = 1; $e++;}
		
			if($evaluations->_3b == 'A'){ $mark3b = 5; $a++;}if($evaluations->_3b == 'B'){ $mark3b = 4; $b++;}if($evaluations->_3b == 'C'){ $mark3b = 3; $c++;}if($evaluations->_3b == 'D'){ $mark3b = 2; $d++;}if($evaluations->_3b == 'E'){ $mark3b = 1; $e++;}
			
			if($evaluations->_4a == 'A'){ $mark4a = 5; $a++;}if($evaluations->_4a == 'B'){ $mark4a = 4; $b++;}if($evaluations->_4a == 'C'){ $mark4a = 3; $c++;}if($evaluations->_4a == 'D'){ $mark4a = 2; $d++;}if($evaluations->_4a == 'E'){ $mark4a = 1; $e++;}
		
			if($evaluations->_4b == 'A'){ $mark4b = 5; $a++;}if($evaluations->_4b == 'B'){ $mark4b = 4; $b++;}if($evaluations->_4b == 'C'){ $mark4b = 3; $c++;}if($evaluations->_4b == 'D'){ $mark4b = 2; $d++;}if($evaluations->_4b == 'E'){ $mark4b = 1; $e++;}
		
			if($evaluations->_5a == 'A'){ $mark5a = 5; $a++;}if($evaluations->_5a == 'B'){ $mark5a = 4; $b++;}if($evaluations->_5a == 'C'){ $mark5a = 3; $c++;}if($evaluations->_5a == 'D'){ $mark5a = 2; $d++;}if($evaluations->_5a == 'E'){ $mark5a = 1; $e++;}
		
			if($evaluations->_5b == 'A'){ $mark5b = 5; $a++;}if($evaluations->_5b == 'B'){ $mark5b = 4; $b++;}if($evaluations->_5b == 'C'){ $mark5b = 3; $c++;}if($evaluations->_5b == 'D'){ $mark5b = 2; $d++;}if($evaluations->_5b == 'E'){ $mark5b = 1; $e++;}
		
			$markTotal1a = $markTotal1a + $mark1a;
			$markTotal1b = $markTotal1b + $mark2b;
			$markTotal2a = $markTotal2a + $mark2a;
			$markTotal2b = $markTotal2b + $mark2b;
			$markTotal3a = $markTotal3a + $mark3a;
			$markTotal3b = $markTotal3b + $mark3b;
			$markTotal4a = $markTotal4a + $mark4a;
			$markTotal4b = $markTotal4b + $mark4b;
			$markTotal5a = $markTotal5a + $mark5a;
			$markTotal5b = $markTotal5b + $mark5b;
		}
		
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			$m2a = $markTotal2a/$no;
			$m2b = $markTotal2b/$no;
			$m3a = $markTotal3a/$no;
			$m3b = $markTotal3b/$no;
			$m4a = $markTotal4a/$no;
			$m4b = $markTotal4b/$no;
			$m5a = $markTotal5a/$no;
			$m5b = $markTotal5b/$no;
			
			$sum = $m1a + $m1b + $m2a + $m2b + $m3a + $m3b + $m4a + $m4b + $m5a + $m5b;
			
			$overall = number_format(((float)($sum)/10), 2, '.', '');
			
			$data = array(
				'gpa'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->update('report',$data);
		}
	}
	
	
	public function update_1(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$this->db->where('academic_year', date('Y'));
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			
			
			$this->db->select('_1a');
			$this->db->select('_1b');
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_1a == 'A'){ $mark1a = 5; $a++;}if($evaluations->_1a == 'B'){ $mark1a = 4; $b++;}if($evaluations->_1a == 'C'){ $mark1a = 3; $c++;}if($evaluations->_1a == 'D'){ $mark1a = 2; $d++;}if($evaluations->_1a == 'E'){ $mark1a = 1; $e++;}

			if($evaluations->_1b == 'A'){ $mark1b = 5; $a++;}if($evaluations->_1b == 'B'){ $mark1b = 4; $b++;}if($evaluations->_1b == 'C'){ $mark1b = 3; $c++;}if($evaluations->_1b == 'D'){ $mark1b = 2; $d++;}if($evaluations->_1b == 'E'){ $mark1b = 1; $e++;}
		
			$markTotal1a = $markTotal1a + $mark1a;
			$markTotal1b = $markTotal1b + $mark1b;
		}
		
		/* 
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			 */
			$sum = ($markTotal1a + $markTotal1b)/$no;
			
			$overall = number_format(((float)$sum/2), 2, '.', '');
			
			$data = array(
				'_1'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->where('semester', 1);
			$this->db->where('academic_year', date('Y'));
			$this->db->update('report',$data);
		}
	}	
	
	public function update_2(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$this->db->where('academic_year', date('Y'));
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			
			
			$this->db->select('_2a');
			$this->db->select('_2b');
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_2a == 'A'){ $mark2a = 5; $a++;}if($evaluations->_2a == 'B'){ $mark2a = 4; $b++;}if($evaluations->_2a == 'C'){ $mark2a = 3; $c++;}if($evaluations->_2a == 'D'){ $mark2a = 2; $d++;}if($evaluations->_2a == 'E'){ $mark2a = 1; $e++;}
		
			if($evaluations->_2b == 'A'){ $mark2b = 5; $a++;}if($evaluations->_2b == 'B'){ $mark2b = 4; $b++;}if($evaluations->_2b == 'C'){ $mark2b = 3; $c++;}if($evaluations->_2b == 'D'){ $mark2b = 2; $d++;}if($evaluations->_2b == 'E'){ $mark2b = 1; $e++;}
		
			$markTotal2a = $markTotal2a + $mark2a;
			$markTotal2b = $markTotal2b + $mark2b;
		}
		/* 
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			 */
			$sum = ($markTotal2a + $markTotal2b)/$no;
			
			$overall = number_format(((float)$sum/2), 2, '.', '');
			
			$data = array(
				'_2'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->where('semester', 1);
			$this->db->where('academic_year', date('Y'));
			$this->db->update('report',$data);
		}
	}
	
	public function update_3(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$this->db->where('academic_year', date('Y'));
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			
			
			$this->db->select('_3a');
			$this->db->select('_3b');
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_3a == 'A'){ $mark3a = 5; $a++;}if($evaluations->_3a == 'B'){ $mark3a = 4; $b++;}if($evaluations->_3a == 'C'){ $mark3a = 3; $c++;}if($evaluations->_3a == 'D'){ $mark3a = 2; $d++;}if($evaluations->_3a == 'E'){ $mark3a = 1; $e++;}
		
			if($evaluations->_3b == 'A'){ $mark3b = 5; $a++;}if($evaluations->_3b == 'B'){ $mark3b = 4; $b++;}if($evaluations->_3b == 'C'){ $mark3b = 3; $c++;}if($evaluations->_3b == 'D'){ $mark3b = 2; $d++;}if($evaluations->_3b == 'E'){ $mark3b = 1; $e++;}
			
			$markTotal3a = $markTotal3a + $mark3a;
			$markTotal3b = $markTotal3b + $mark3b;
		}
		/* 
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			 */
			$sum = ($markTotal3a + $markTotal3b)/$no;
			
			$overall = number_format(((float)$sum/2), 2, '.', '');
			
			$data = array(
				'_3'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->where('semester', 1);
			$this->db->where('academic_year', date('Y'));
			$this->db->update('report',$data);
		}
	}	
	
	public function update_4(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$this->db->where('academic_year', date('Y'));
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			
			
			$this->db->select('_4a');
			$this->db->select('_4b');
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_4a == 'A'){ $mark4a = 5; $a++;}if($evaluations->_4a == 'B'){ $mark4a = 4; $b++;}if($evaluations->_4a == 'C'){ $mark4a = 3; $c++;}if($evaluations->_4a == 'D'){ $mark4a = 2; $d++;}if($evaluations->_4a == 'E'){ $mark4a = 1; $e++;}
		
			if($evaluations->_4b == 'A'){ $mark4b = 5; $a++;}if($evaluations->_4b == 'B'){ $mark4b = 4; $b++;}if($evaluations->_4b == 'C'){ $mark4b = 3; $c++;}if($evaluations->_4b == 'D'){ $mark4b = 2; $d++;}if($evaluations->_4b == 'E'){ $mark4b = 1; $e++;}
		
			$markTotal4a = $markTotal4a + $mark4a;
			$markTotal4b = $markTotal4b + $mark4b;
		}
		/* 
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			 */
			$sum = ($markTotal4a + $markTotal4b)/$no;
			
			$overall = number_format(((float)$sum/2), 2, '.', '');
			
			$data = array(
				'_4'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->where('semester', 1);
			$this->db->where('academic_year', date('Y'));
			$this->db->update('report',$data);
		}
	}	
	
	public function update_5(){
		$mark1a = 0;$mark1b = 0;$mark2a = 0;$mark2b = 0;$mark3a = 0;$mark3b = 0;$mark4a = 0;$mark4b = 0;$mark5a = 0;$mark5b = 0;$markTotal = 0;$markAvg = 0;$markP = 50;
		
		
		$m1a = 0;$m1b = 0;$m2a = 0;$m2b = 0;$m3a = 0;$m3b = 0;$m4a = 0;$m4b = 0;$m5a = 0;$m5b = 0;
		
		$a = 0;	$b = 0;	$c = 0;	$d = 0;	$e = 0;

		$this->db->where('semester', 1);
		$this->db->where('academic_year', date('Y'));
		$report = $this->db->get('report');
		
		foreach($report->result() as $rep){
			
			$markTotal1a = 0;$markTotal1b = 0;$markTotal2a = 0;$markTotal2b = 0;$markTotal3a = 0;$markTotal3b = 0;$markTotal4a = 0;$markTotal4b = 0;$markTotal5a = 0;$markTotal5b = 0;
		
			$no=0;
		
			$this->db->where('course_code', $rep->course_code);
			$no = $this->db->count_all_results('evaluations');
			
			
			$this->db->select('_5a');
			$this->db->select('_5b');
			$this->db->where('course_code', $rep->course_code);
			$this->db->where('semester', 1);
			$rec = $this->db->get('evaluations');
		
		foreach($rec->result() as $evaluations){
			if($evaluations->_5a == 'A'){ $mark5a = 5; $a++;}if($evaluations->_5a == 'B'){ $mark5a = 4; $b++;}if($evaluations->_5a == 'C'){ $mark5a = 3; $c++;}if($evaluations->_5a == 'D'){ $mark5a = 2; $d++;}if($evaluations->_5a == 'E'){ $mark5a = 1; $e++;}
		
			if($evaluations->_5b == 'A'){ $mark5b = 5; $a++;}if($evaluations->_5b == 'B'){ $mark5b = 4; $b++;}if($evaluations->_5b == 'C'){ $mark5b = 3; $c++;}if($evaluations->_5b == 'D'){ $mark5b = 2; $d++;}if($evaluations->_5b == 'E'){ $mark5b = 1; $e++;}
		
			$markTotal5a = $markTotal5a + $mark5a;
			$markTotal5b = $markTotal5b + $mark5b;
		}
		/* 
			$m1a = $markTotal1a/$no;
			$m1b = $markTotal1b/$no;
			 */
			$sum = ($markTotal5a + $markTotal5b)/$no;
			
			$overall = number_format(((float)$sum/2), 2, '.', '');
			
			$data = array(
				'_5'=>$overall
			);
			$this->db->where('course_code',$rep->course_code);
			$this->db->where('semester', 1);
			$this->db->where('academic_year', date('Y'));
			$this->db->update('report',$data);
		}
	}
}