From 1a53b90590d70be1b389f33ae81c47f0d5238d48 Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期三, 12 八月 2020 10:18:06 +0800
Subject: [PATCH] add userClient
---
models/user.go | 35 +++++++++++++++++++++++++++++++++--
1 files changed, 33 insertions(+), 2 deletions(-)
diff --git a/models/user.go b/models/user.go
index 3d15d2d..ea773c9 100644
--- a/models/user.go
+++ b/models/user.go
@@ -36,7 +36,7 @@
func (u *User) SelectById(uid string) error {
o := orm.NewOrm()
- err := o.Raw("select * from ? where id=?", u.TableName(), uid).QueryRow(u)
+ err := o.QueryTable(u.TableName()).Filter("id", uid).One(u)
return err
}
@@ -48,16 +48,38 @@
func (u *User) GetAllUsers() (all []User,err error) {
o := orm.NewOrm()
- _, err = o.Raw("select * from ?", u.TableName()).QueryRows(&all)
+ _, err = o.QueryTable(u.TableName()).All(&all)
if err != nil {
return nil, err
}
return all,nil
}
+func (u *User) GetAllMapByPhone() (map[string]User, map[string]User) {
+ m := make(map[string]User)
+ idM := make(map[string]User)
+ all, _ := u.GetAllUsers()
+ if all !=nil {
+ for _,p := range all {
+ m[p.PhoneNum] = p
+ idM[p.Id] = p
+ }
+ }
+ return m, idM
+}
+
func (u *User) Update() (int64, error) {
o := orm.NewOrm()
return o.Update(u)
+}
+
+func (u *User) SyncHikPersonId(phoneNum string, hikPersonId string) (int64, error) {
+ o := orm.NewOrm()
+ res, err := o.Raw("update sys_user set id=? where phoneNum=?", hikPersonId, phoneNum).Exec()
+ if err != nil {
+ return 0, err
+ }
+ return res.RowsAffected()
}
func Login(username, password string) bool {
@@ -69,3 +91,12 @@
o := orm.NewOrm()
return o.Update(u, "isDelete")
}
+
+func (u *User) Delete(id string) (int64, error) {
+ o := orm.NewOrm()
+ res, err := o.Raw("delete from sys_user where id=?", id).Exec()
+ if err != nil {
+ return 0, err
+ }
+ return res.RowsAffected()
+}
\ No newline at end of file
--
Gitblit v1.8.0