forked from 1340691923/ElasticView
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathGmUserModel.go
More file actions
83 lines (71 loc) · 2.48 KB
/
Copy pathGmUserModel.go
File metadata and controls
83 lines (71 loc) · 2.48 KB
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
package model
import (
"github.com/1340691923/ElasticView/engine/db"
"github.com/1340691923/ElasticView/engine/logs"
"github.com/1340691923/ElasticView/platform-basic-libs/util"
"strings"
"go.uber.org/zap"
)
// GmUserModel GM用户
type GmUserModel struct {
ID int32 `json:"id" db:"id"`
Username string `json:"username" db:"username"`
Password string `json:"password" db:"password"`
RoleId int32 `json:"role_id" db:"role_id"`
Realname string `json:"realname" db:"realname"`
}
//密码进行md5混淆
func (this GmUserModel) GetPassword() string {
return util.MD5HexHash([]byte(this.Password))
}
//是否存在该用户
func (this GmUserModel) Exsit() (b bool, err error) {
var count int
err = db.Sqlx.Get(&count, "select count(*) from gm_user where username = ? and role_id = ? limit 1;", this.Username, this.RoleId)
if err != nil {
logs.Logger.Error("err", zap.String("err.Error()", err.Error()))
return
}
if count > 0 {
b = true
}
return
}
//登录
func (this GmUserModel) GetUserByUP() (gmUser GmUserModel, err error) {
err = db.Sqlx.Get(&gmUser, "select id,username,password,role_id,realname from gm_user where username = ? and password = ? limit 1;", this.Username, this.GetPassword())
return
}
//通过id查询用户信息
func (this GmUserModel) GetUserById() (gmUser GmUserModel, err error) {
err = db.Sqlx.Get(&gmUser, "select id,username,password,role_id,realname from gm_user where id = ?;", this.ID)
return
}
//新增用户
func (this GmUserModel) Insert() (id int64, err error) {
rlt, err := db.Sqlx.Exec("insert into gm_user(username,password,role_id,realname)values(?,?,?,?)", this.Username, this.GetPassword(), this.RoleId, this.Realname)
if err != nil {
return
}
id, _ = rlt.LastInsertId()
return
}
// Update
func (this GmUserModel) Update() (err error) {
if strings.TrimSpace(this.Password) == "" {
_, err = db.Sqlx.Exec("update gm_user set username = ?,role_id=?,realname=? where id = ? ;", this.Username, this.RoleId, this.Realname, this.ID)
return
}
_, err = db.Sqlx.Exec("update gm_user set username = ?,password=?,role_id=?,realname=? where id = ? ;", this.Username, this.GetPassword(), this.RoleId, this.Realname, this.ID)
return
}
// Select
func (this GmUserModel) Select() (gmUser []GmUserModel, err error) {
err = db.Sqlx.Select(&gmUser, "select id,username,password,role_id,realname from gm_user ;")
return
}
// Delete
func (this GmUserModel) Delete() (err error) {
_, err = db.Sqlx.Exec("delete from gm_user where id = ? ;", this.ID)
return
}