<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 check_student() {
        $this->db->where('class_level', $this->security->xss_clean($this->input->post('class_admitted')));
        $this->db->where('category', $this->security->xss_clean($this->input->post('category')));
        $this->db->where('school_id', $this->session->userdata('school_id'));
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        
        // print_r($form);
        // exit;
        return $form->result();
    } 
	
	 public function check_student_ooficer() {
        $this->db->where('class_level', $this->security->xss_clean($this->input->post('class_admitted')));
        $this->db->where('category', $this->input->post('category'));
        
        if($this->input->post('category') =='A'){
            $academic = $this->session->userdata('academic_year_a_level');
        }else{
            $academic = date('Y');
        }
        $this->db->where('academic_year', $academic);
        $this->db->where('school_id',$this->security->xss_clean($this->input->post('school_id')));
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        
        return $form->result();
    } 
    
     public function check_student_ooficer_pc() {
        $this->db->where('class_level', $this->security->xss_clean($this->input->post('class_admittedp')));
        $this->db->where('category', $this->security->xss_clean($this->input->post('category')));
       // $this->db->where('candidate', $this->security->xss_clean($this->input->post('candidate')));
        $this->db->where('school_id',$this->security->xss_clean($this->input->post('school_id')));
        
        if($this->input->post('category') =='A'){
            $academic = $this->session->userdata('academic_year_a_level');
        }else{
            $academic = date('Y');
        }
        $this->db->where('academic_year', $academic);
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        return $form->result();
    } 
	
	 public function check_student_o() {
		$this->db->where('class_level', $this->security->xss_clean($this->input->post('class_admitted')));
        $this->db->where('category', $this->security->xss_clean($this->input->post('category')));
        $this->db->where('school_id', $this->session->userdata('school_id'));
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        return $form->result();
    } 
	
	public function check_student_o_officers() {
		$this->db->where('class_level', $this->security->xss_clean($this->input->post('class_admitted')));
        $this->db->where('category', $this->security->xss_clean($this->input->post('category')));
        $this->db->where('school_id',$this->security->xss_clean($this->input->post('school_id')));
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        return $form->result();
    } 
	
	public function check_student_n() {
		$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('class_level', $level);
        $this->db->where('category', $category);
        $this->db->where('school_id', $this->session->userdata('school_id'));
        $this->db->order_by('reg_number', 'desc');
        $this->db->limit(1);
        $form = $this->db->get('classes');
        return $form->result();
    } 
	
	// Simple model example
	public function check_password() {
        $pass = $this->security->xss_clean($this->input->post('password'));
        $this->db->where('password', MD5($pass));
        $query = $this->db->get('schools');
        return $query->num_rows();
    }
    
     public function change_passwords() {
        $_SESSION['school_id'] = $this->session->userdata('school_id');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password' => MD5($pass),
        );
        $this->db->select('passwaord');
        $this->db->where('school_id', $_SESSION['school_id']);
        $this->db->update('schools', $data1);
    }
    
     public function change_passwords_reset() {
        $_SESSION['school_id'] = $this->session->userdata('school_id');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password_recover' => $pass,
        );
        $this->db->select('password_recover');
        $this->db->where('school_id', $_SESSION['school_id']);
        $this->db->update('schools', $data1);
    }
	
	
	public function change_passwords_officiers() {
        $_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password' => MD5($pass),
        );
        $this->db->select('passwaord');
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->update('education_officers', $data1);
    }
    
     public function change_passwords_reset_officers() {
        $_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password_recover' => $pass,
        );
        $this->db->select('password_recover');
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->update('education_officers', $data1);
    }
	
	
	public function check_password_officers() {
		$_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password'));
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->where('password', MD5($pass));
        $query = $this->db->get('education_officers');
        return $query->num_rows();
    }
    
	public function check_password1() {
		$_SESSION['school_id'] = $this->session->userdata('school_id');
		$_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password'));
		$this->db->where('school_id', $_SESSION['school_id']);
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->where('password', MD5($pass));
        $query = $this->db->get('staffs');
        return $query->num_rows();
    }
     public function change_passwords1() {
        $_SESSION['school_id'] = $this->session->userdata('school_id');
		$_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password' => MD5($pass),
        );
        $this->db->select('passwaord');
        $this->db->where('school_id', $_SESSION['school_id']);
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->update('staffs', $data1);
    }
    
     public function change_passwords_reset1() {
        $_SESSION['school_id'] = $this->session->userdata('school_id');
        $_SESSION['reg_number'] = $this->session->userdata('reg_number');
        $pass = $this->security->xss_clean($this->input->post('password1'));
        $data1 = array(
            'password_reset' => $pass,
        );
        $this->db->select('password_reset');
        $this->db->where('school_id', $_SESSION['school_id']);
        $this->db->where('reg_number', $_SESSION['reg_number']);
        $this->db->update('staffs', $data1);
    }
}