From 246ba3b0b0bf0477675d7592c35bd2d1681d44c3 Mon Sep 17 00:00:00 2001 From: liuxiaolong <liuxiaolong@aiotlink.com> Date: 星期二, 11 八月 2020 15:54:52 +0800 Subject: [PATCH] fix aliasArr --- models/user.go | 26 +++++++++++++++++++++++--- 1 files changed, 23 insertions(+), 3 deletions(-) diff --git a/models/user.go b/models/user.go index 5e2e8f0..df2b4e9 100644 --- a/models/user.go +++ b/models/user.go @@ -36,30 +36,50 @@ 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 } func (u *User) SelectByPhoneNum(phoneNum string) error { o := orm.NewOrm() - err := o.Raw("select * from ? where phoneNum=?", u.TableName(), phoneNum).QueryRow(u) + err := o.QueryTable(u.TableName()).Filter("phoneNum", phoneNum).One(u) return err } 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 { + m := make(map[string]User) + all, _ := u.GetAllUsers() + if all !=nil { + for _,p := range all { + m[p.PhoneNum] = p + } + } + return m +} + 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 { return false -- Gitblit v1.8.0