<?php 
class Adminuser_model extends CI_Model {
	public function _consruct(){
		parent::_construct();
 	}


public function get_allusers(){
	$this->db->select('admin.*,roles.roles');
	$this->db->join('roles','admin.user_type = roles.id');
	return $this->db->get('admin')->result();
}

public function insert_user($data){
	$data['password'] = md5($data['password']);
	if($this->db->insert('admin',$data)){
		return true;

	}
}

public function get_users_by_id($id){
	$result = $this->db->get_where('admin',array('id'=>$id))->row();
	if($result){
		return $result;
	}else{
		return false;
	}
}

public function edit_user($data,$id){
	if($this->db->update('admin',$data,array('id'=>$id))){
		return true;
	}
}

public function delete_user($id){
	if($this->db->delete('admin',array('id'=>$id))){
		return true;
	}
}

public function get_details(){
	return $query = $this->db->get('tbl_controllers')->result();
}

public function get_access($id){
	$rs = $this->db->where('user_type',$id)->get('tbl_role_permission')->row();
	$result = array();
	if(count($rs)>0){
		$result = explode(',', $rs->page_id);
	} else {
		$result = array();
	}
	return $result;
}

public function get_functions($id){
	$this->db->where('c_id',$id);
	$query = $this->db->get('tbl_controller_functions');
	return $query->result();
}

public function update_role($data,$id){

	$datas =array(
		          'page_id'=>$data
		    );
	$selects =$this->db->query("select * from tbl_role_permission where user_type ='$id'"); 

	if($selects->num_rows() == 0) {
	
	 $datas =array('user_type'=>$id,
		          'page_id'=>$data
		    );
		if( $this->db->insert('tbl_role_permission',$datas)){
			return 1;
		}else{
			return 2;
		}
	}else{

		 foreach($selects->result_array() as $row){

			$this->db->where('user_type', $id);
			$query = $this->db->update('tbl_role_permission',$datas);
			
			if($query){
				return 3;
			}else{
				return 4;
			}
		}
	}
}






  

}
?>