From 13a31b1caab8ffa0049dc8299cab8b8c4a31b6ed Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期二, 11 八月 2020 15:32:06 +0800
Subject: [PATCH] test

---
 models/user.go |   35 ++++++++++++++++++++++++++++-------
 1 files changed, 28 insertions(+), 7 deletions(-)

diff --git a/models/user.go b/models/user.go
index 5e2e8f0..43365e0 100644
--- a/models/user.go
+++ b/models/user.go
@@ -36,23 +36,35 @@
 
 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)
-	if err != nil {
-		return nil, err
+	//o := orm.NewOrm()
+	//_, err = o.QueryTable(u.TableName()).All(&all)
+	//if err != nil {
+	//	return nil, err
+	//}
+	//return all,nil
+	return nil, 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 all,nil
+	return m
 }
 
 func (u *User) Update() (int64, error) {
@@ -60,6 +72,15 @@
 	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