GRAYBYTE WORDPRESS FILE MANAGER3374

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Users_model extends CI_Model
{
	var $table = TABLE_USERS;
	var $table_user_role = TABLE_USER_ROLES;
	var $table_role_rights = TABLE_ROLE_RIGHTS;
	var $table_modules = TABLE_MODULES;
	var $table_company_info = TABLE_COMPANY_INFO;
		
	public function __construct()
    {
        parent::__construct();
    }
    
	public function userRoleSave($data_array, $id = 0)
	{
		if($id == 0) {
			$this->db->insert($this->table_user_role, $data_array);
			$last_id = $this->db->insert_id();
		} else {
			$this->db->where('user_role_id', $id);
			$this->db->update($this->table_user_role, $data_array);
			$last_id = $id;
		}
		return $last_id;
	}
	
	public function userSave($data_array, $id = 0)
	{
		if($id == 0) {
			$this->db->insert($this->table, $data_array);
			$last_id = $this->db->insert_id();
		} else {
			$this->db->where('user_id', $id);
			$this->db->update($this->table, $data_array);
			$last_id = $id;
		}
		return $last_id;
	}
	public function companyInfoSave($data_array, $id = 0)
	{
		if($id == 0) {
			$this->db->insert($this->table_company_info, $data_array);
			$last_id = $this->db->insert_id();
		} else {
			$this->db->where('id', $id);
			$this->db->update($this->table_company_info, $data_array);
			$last_id = $id;
		}
		return $last_id;
	}
	
	public function getUserRoleList($is_visible = 0)
	{
		$this->db->select('*');	
		if($is_visible > 0) $this->db->where('is_visible', 1);
		$this->db->order_by('user_role_name', 'ASC');
		return $this->db->get($this->table_user_role)->result();
	}
	
	public function getUserList($user_status = 0)
	{
		$this->db->select('u.*,ur.user_role_code,ur.user_role_name');	
		$this->db->from($this->table. ' u');
		$this->db->join($this->table_user_role. ' ur', 'ur.user_role_id = u.user_role_id');
		if($user_status > 0) $this->db->where('u.user_status', 1);
		$this->db->where('user_id <>', userInfo('user_id'));
		$this->db->order_by('u.doc', 'DESC');
		return $this->db->get()->result();

	}
	
	public function getUserRoleData($user_role_id)
	{
		$this->db->select('*');
		$this->db->where('user_role_id', $user_role_id);
		$this->db->limit(1);
		return $this->db->get($this->table_user_role)->row();
	}
	
	public function getUserData($user_id)
	{
		$this->db->select('u.*,ur.user_role_code,ur.user_role_name');	
		$this->db->from($this->table. ' u');
		$this->db->join($this->table_user_role. ' ur', 'ur.user_role_id = u.user_role_id');
		$this->db->where('u.user_id', $user_id);
		$this->db->limit(1);
		return $this->db->get($this->table)->row();
	}
	public function getCompanyData()
	{
		$this->db->select('*');
		$this->db->limit(1);
		return $this->db->get($this->table_company_info)->row();
	}
	
	public function  checkUserRoleRight($user_role_id)
	{
		$this->db->select('*');	
		$this->db->where('user_role_id', $user_role_id);
		$row_count = $this->db->get($this->table_role_rights)->num_rows();
		if($row_count > 0) {
			$this->db->where('user_role_id', $user_role_id);
      		$this->db->delete($this->table_role_rights); 	
		}
	}
	
	public function getUserRoleRight($user_role_id)
	{
		$this->db->select('*');	
		$this->db->where('user_role_id', $user_role_id);
		return $this->db->get($this->table_role_rights)->result();
	}
	
	public function getAllModules()
	{
		$this->db->select('*');	
		$this->db->where('is_visible', 1);
		$this->db->order_by('module_order', 'ASC');
		return $this->db->get($this->table_modules)->result();
	}
	
	public function getUserRoleNameById($user_role_id)
	{
		$this->db->select('user_role_name');	
		$this->db->where('user_role_id', $user_role_id);
		$this->db->limit(1);
		$user_role = $this->db->get($this->table_user_role)->row();
		return $user_role->user_role_name;
			
	}

}