<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
defined('BASEPATH') OR exit('No direct script access allowed');

class Matokeo extends CI_Controller {
    function __construct() {
        parent::__construct();
    }
    
    
	public function index()
	{
		$this->load->view('includes/uploading_header');
		$this->load->view('users/public/public');
		$this->load->view('includes/uploading_footer');
		
	}
	
    
    
	public function test()
	{
		$this->load->view('includes/uploading_header');
		$this->load->view('users/public/public_test');
		$this->load->view('includes/uploading_footer');
		
	}
	
    public function regions(){
        $region = base64_decode($_REQUEST['rid']);
        
        $this->db->like('name',$region,'BOTH');
        $gg = $this->db->get('regions');
        foreach($gg->result() as $row){
            redirect('https://results.avet.co.tz/Matokeo/?rid='.base64_encode($row->id));
        }
        if($gg->num_rows() == 0){
            $this->db->like('url',$region,'BOTH');
            $gg = $this->db->get('exam_groups');
            foreach($gg->result() as $row){
                redirect('https://results.avet.co.tz/Matokeo/?gid='.base64_encode($row->group_id));
            }
            if($gg->num_rows() == 0){
                redirect('https://aven.com/Page_not_found');
            }
        }
    }
    

	
	public function futa(){
	    $this->db->distinct();
        $this->db->select('school_id');
        $this->db->where('exam_id',37);
        $this->db->where('candidate','NC');
        $this->db->order_by('school_id','asc');
        foreach($this->db->get('monthly_results')->result() as $sch){
            $this->db->where('school_id',$sch->school_id);
            $this->db->where('id_number','0004');
            $this->db->where('admission_year',2019);
            $this->db->where('class_admitted',4);
            $count = $this->db->count_all_results('students');
           
            if($count == 0){
                foreach($this->db->where('school_id',$sch->school_id)->get('schools')->result() as $schn){
                    echo $schn->school_name."<br/>";
                }
            }
        }
	}
	
	
	
	
	
	public function check_schools(){
	    $this->db->distinct()->select('school_id');
	    $this->db->where('region',17)->where('school_type','SS');
	    $ss = $this->db->get('schools');
	    
	    echo $ss->num_rows()."<br/>";
	    
	    foreach($ss->result() as $schools){
	        $this->db->where('exam_id',36);
	        $this->db->where('school_id',$schools->school_id);
	        $count = $this->db->count_all_results('schools_position');
	        if($count == 0){
	            echo $schools->school_id."<br/>";
	        }
	    }
	}
	

	public function testing()
	{
		
	}
	
	public function view()
	{
	    
    //  	$this->load->view('users/public/tempo');
		
		$this->load->view('includes/uploading_header');
		$this->load->view('users/public/view');
		$this->load->view('includes/uploading_footer');
	}
	
	
	public function print_pdf_testing() {
	    
        $category = base64_decode($_REQUEST['category']);
        
            
		//  $this->load->view('users/public/tempo');
        	$this->load->view('includes/uploading_header');
    		$this->load->view('users/public/print_pdf_testing');
    		$this->load->view('includes/uploading_footer'); 
        
        
	
    }
    
	
	public function print_full_sheet_officers_number() {
	    
	   
	    $this->load->helper('url');
        $this->load->library('user_agent');
        
        $browser = $this->agent->browser();
        $browserVersion = $this->agent->version();
        $platform = $this->agent->platform();
        $full_user_agent_string = $_SERVER['HTTP_USER_AGENT'];
           
        $browser = $this->agent->browser();
        $version = $this->agent->version();
        $platform = $this->agent->platform();
        $full_user_agent_string = $_SERVER['HTTP_USER_AGENT'];
              
              
	    $school_id = base64_decode($_REQUEST['school_id']);
	    $exam_id = base64_decode($_REQUEST['exam_id']);
        
        $referer = "";
        if(isset($_SERVER['HTTP_REFERER'])) {
          $referer = $_SERVER['HTTP_REFERER'];
       }
        
        ## Inserting last seen;
        $data = array(
            'school_id'=>$school_id,
            'exam_id'=>$exam_id,
            'last_seen'=>date('d-m-Y H:i:s'),
            'browser'=>$browser,
            'version'=>$version,
            'platform'=>$platform,
            'platform'=>$platform,
            'full_string'=>$full_user_agent_string,
            'referer'=>$referer,
        );
        
        $this->db->insert('view_results',$data);
        
        
        $category = base64_decode($_REQUEST['category']);
        
        if($category == 'P'){
            
		    //$this->load->view('users/public/tempo');
            $this->load->view('includes/uploading_header');
    		$this->load->view('users/public/print_full_sheet_officers_number');
    		$this->load->view('includes/uploading_footer'); 
        }else{
            
		//  $this->load->view('users/public/tempo');
        	$this->load->view('includes/uploading_header');
    		$this->load->view('users/public/print_full_sheet_officers_number_secondary');
    		$this->load->view('includes/uploading_footer'); 
        }
        
	
    }
    
    
    public function check_monthly_result(){
        $this->db->distinct()->select('reg_number');
        $this->db->where('exam_id',37);
        $this->db->where('candidate','NC');
        $this->db->where('region_id',3);
        foreach($this->db->get('monthly_results')->result() as $student){
            
            $this->db->select('reg_number, COUNT(subject_id) as  subjects, school_id');
            $this->db->where('exam_id',37);
            $this->db->where('candidate','NC');
            $this->db->where('region_id',3);
            $this->db->where('reg_number',$student->reg_number);
            foreach($this->db->get('ca')->result() as $ca){
                if($ca->subjects == 0){
                    $this->db->where('reg_number',$student->reg_number);
                    $this->db->from('students as s');
                    $this->db->join('schools sc','sc.school_id=s.school_id');
                    $ff = $this->db->get();
                    foreach($ff->result() as $dd){
                        echo $dd->school_name." ".$dd->id_number;
                    }
                    // $this->db->where('exam_id',37);
                    // $this->db->where('candidate','NC');
                    // $this->db->where('region_id',3);
                    // $this->db->where('reg_number',$student->reg_number);
                    // $this->db->delete('monthly_results');
                    echo "<br/>";
                }
            }
        }
    }
	
	public function check_students(){
	    $i=0;
	    $this->db->where('region',17);
	    $this->db->where('school_type','SS');
	    foreach($this->db->get('schools')->result() as $school){
	        $boys = $girls = $total = 0;
	        
	        $this->db->where('candidate','NC');
	        $this->db->where('school_id',$school->school_id);
	        $this->db->where('admission_year',date('Y'));
	         $this->db->where('class_admitted',4);
	        $this->db->where('gender','M');
	        $boys = $this->db->count_all_results('students');
	        
	        $this->db->where('candidate','NC');
	        $this->db->where('school_id',$school->school_id);
	        $this->db->where('admission_year',date('Y'));
	         $this->db->where('class_admitted',4);
	        $this->db->where('gender','F');
	        $girls = $this->db->count_all_results('students');
	        
	        $this->db->where('candidate','NC');
	        $this->db->where('admission_year',date('Y'));
	        $this->db->where('class_admitted',4);
	        $this->db->where('school_id',$school->school_id);
	        $total = $this->db->count_all_results('students');
	        
	        $tt = $boys + $girls;
	        
	        if($tt != $total){
	            $i++;
	            foreach($this->db->where('id',$school->district)->get('regions_distrincts')->result() as $ds){
	                echo $i." - ".$school->school_name." - ".$school->school_id."<br/> ".$ds->district_name." Total ".$tt." SUM-B-G: ".$total."<br/>";
	            }
	        }
	    }
	}
	
	
	public function check_marks(){
	    $exam = $exam_id = 37;$i=0;
	    $this->db->where('exam_id',$exam);
	    foreach($this->db->get('ca_sub')->result() as $data){
	        $i++;
	        foreach($this->db->where('school_id',$data->school_id)->get('schools')->result() as $school){
	            
    	        foreach($this->db->where('id',$school->district)->get('regions_distrincts')->result() as $ds){
    	            foreach($this->db->where('subject_id',$data->subject_id)->get('all_subjects')->result() as $sub){
    	                $subject = $sub->name;
    	           
        	            foreach($this->db->where('reg_number',$data->reg_number)->get('students')->result() as $student){
        	                
        	                if($student->admission_year != $data->academic_year){
        	                    $this->db->where('reg_number',$data->reg_number);
        	                    $this->db->where('exam_id',$exam_id);
        	                    $this->db->where('school_id',$data->school_id);
        	                    $this->db->where('academic_year',$data->academic_year);
        	                    $this->db->delete('ca_sub');
        	                    
        	                    echo "DELETE THIS - ";
        	               
        	                    //echo $i." - ".$ds->district_name." ".$school->school_name." - ".$student->id_number." Sub: ".$subject." -  Mark: ".$data->mark."<br/>";
        	                }
        	            }
    	            }
                }
                 
	        }
	    }
	    
	    
	    
	}
	
	
    
}