ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/models/User_model.php |
<?php
Class User_Model extends CI_Model{
protected $user_table_name = 'SH_Users';
protected $role_table_name = 'SH_Roles';
protected $primary_key = 'UserID';
protected $order_by = '';
protected $fields_detail = 'UserID, UserName, UserPassword, UserEmail, UserRole, Status';
protected $fields_summary = 'UserName, UserPassword';
Public function __construct()
{
parent::__construct();
}
//////////////////////////////////////////////Users///////////////////////////////////////////
function get_user($id){
return $this->db->get_where($this->user_table_name, array($this->primary_key => $id))->row_array();
}
function get_user_details($user_name, $password){
//$this->db->select('UserID,UserName,UserPassword');
$this->db->select('*');
$this->db->where('UserName', $user_name);
// $this->db->where('UserPassword', $password);
return $this->db->get($this->user_table_name)->row_array();
}
function get_user_by_name($name){
return $this->db->get_where($this->user_table_name, array('UserName' => $name))->row_array();
}
function get_user_role($user_id){
$this->db->select('UserRole, RoleName');
$this->db->where('UserID', $user_id);
$this->db->join($this->role_table_name, $this->role_table_name.'.RoleID='.$this->user_table_name.'.UserRole');
return $this->db->get($this->user_table_name)->row_array();
}
function get_users($fields = '', $where = array()){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields_detail);
}
if (count($where)) {
$this->db->where($where);
}
$Query = $this->db->get($this->user_table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function get_users_summary($fields = '', $where = array()){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields_summary);
}
if (count($where)) {
$this->db->where($where);
}
$Query = $this->db->get($this->user_table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function insert_user($data){
$data['CreationDate'] = $data['UpdationDate'] = date('Y-m-d H:i:s');
$success = $this->db->insert($this->user_table_name, $data);
if ($success) {
return $this->db->insert_id();
} else {
return FALSE;
}
}
public function update_user($data, $UserID) {
$this->db->where('UserID', $UserID);
return $this->db->update('SH_Users', $data);
}
public function delete_user($id) {
$this->db->select('UserRole');
$role = $this->db->get_where($this->user_table_name,array($this->primary_key => $id))->row_array();
//Check id super admin
if(!($role['UserRole']==0)){
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->user_table_name);
}
return false;
}
//////////////////////////////////////////////Roles///////////////////////////////////////////
function get_role($id){
return $this->db->get_where($this->role_table_name, array('RoleID' => $id))->row();
}
function get_role_by_name($name){
return $this->db->get_where($this->role_table_name, array('RoleName' => $name))->row();
}
function get_roles($fields = '', $where = array()){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields_detail);
}
if (count($where)) {
$this->db->where($where);
}
$Query = $this->db->get($this->role_table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function insert_role($data){
$data['CreationDate'] = $data['UpdationDate'] = date('Y-m-d H:i:s');
$success = $this->db->insert($this->role_table_name, $data);
if ($success) {
return $this->db->insert_id();
} else {
return FALSE;
}
}
public function delete_role($id) {
$this->db->select('UserID');
$user = $this->db->get_where($this->user_table_name, array('UserRole' => $id))->row_array();
//check if any user is assigned that role
if(!count($user)){
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->user_table_name);
}
return false;
}
}
?>
Kontol Shell Bypass