/
users_model.php
103 lines (90 loc) · 2.95 KB
/
users_model.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<?php if ( ! defined('BASEPATH')) die('No direct script access allowed');
class Users_model extends CI_Model {
function getAllRecords($condition=FALSE)
{
if ($condition != FALSE)
{
$this->db->where($condition);
}
$data = $this->db->get('users');
return $data;
}
function getSomeRecords($fields,$condition=FALSE)
{
foreach ($fields as $field)
{
$this->db->select($field);
}
if ($condition != FALSE)
{
$this->db->where($condition);
}
$data = $this->db->get('users');
return $data;
}
function getOTPwd($user)
{
$this->db->select('uid, users_name, password, one_time_pw, dateformat, full_name, htmleditormode');
$this->db->where('users_name',$user);
$data = $this->db->get('users',1);
return $data;
}
function deleteOTPwd($user)
{
$data = array(
'one_time_pw' => ''
);
$this->db->where('users_name',$user);
$this->db->update('users',$data);
}
function insert($new_user, $new_pass,$new_full_name,$parent_user,$new_email)
{
$this->load->library('admin/sha256','sha256');
$data=array($new_user, $this->sha256->hashing($new_pass),$new_full_name,$parent_user,$new_email);
$uquery = "INSERT INTO ".$this->db->dbprefix("users")." (users_name, password,full_name,parent_id,lang,email,create_survey,create_user,delete_user,superadmin,configurator,manage_template,manage_label)
VALUES (?, ?, ?, ?, 'auto', ?,0,0,0,0,0,0,0)";
return $this->db->query($uquery,$data);
}
function update($uid,$data)
{
$this->db->where(array("uid"=>$uid));
return $this->db->update('users',$data);
}
function updateLang($uid,$postloginlang)
{
$data = array(
'lang' => $postloginlang
);
$this->db->where(array("uid"=>$uid));
$this->db->update('users',$data);
}
function getShareSetting()
{
$this->db->where(array("uid"=>$this->session->userdata('loginID')));
$result= $this->db->get('users');
return $result->row();
}
// Resturns the full name of the user
function getName($userid)
{
$this->db->select('full_name');
$this->db->from('users');
$this->db->where(array("uid"=>$userid));
$result = $this->db->get();
return $result->row();
}
function getID($fullname)
{
$this->db->select('uid');
$this->db->from('users');
$this->db->where(array("full_name"=>$fullname));
$result = $this->db->get();
return $result->row();
}
function updatePassword($uid,$password)
{
$data = array('password' => $password);
$this->db->where(array("uid"=>$uid));
$this->db->update('users',$data);
}
}