package models
|
|
import (
|
"github.com/astaxie/beego/orm"
|
)
|
|
type User struct {
|
Id string `orm:"pk;size(50);column(id)" json:"id"`
|
Username string `orm:"size(250);column(username)" json:"username"`
|
PhoneNum string `orm:"size(20);column(phoneNum)" json:"phoneNum"` //手机号
|
Password string `orm:"size(50);column(password)" json:"password"`
|
TrueName string `orm:"size(250);column(trueName)" json:"trueName"` //真实姓名
|
Gender int `orm:"size(1);column(gender)" json:"gender"` //性别
|
IdCard string `orm:"size(250);column(idCard)" json:"idCard"` //身份证号
|
Age int `orm:"size(8);column(age)" json:"age"` //年龄
|
Address string `orm:"size(200);column(address)" json:"gender"` //地址
|
|
Email string `orm:"size(200);column(email)" json:"email"` //邮箱
|
IsDelete bool `orm:"size(1);default(0);column(isDelete)" json:"isDelete"`
|
}
|
|
func (u *User) TableName() string {
|
return "sys_user"
|
}
|
|
func (u *User) TableUnique() [][]string {
|
return [][]string {
|
[]string{"phoneNum"},
|
}
|
}
|
|
func (u *User) Insert() (int64,error) {
|
o := orm.NewOrm()
|
return o.Insert(u)
|
}
|
|
func (u *User) SelectById(uid string) error {
|
o := orm.NewOrm()
|
err := o.QueryTable(u.TableName()).Filter("id", uid).One(u)
|
return err
|
}
|
|
func (u *User) SelectByPhoneNum(phoneNum string) error {
|
o := orm.NewOrm()
|
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.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 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
|
}
|
|
func (u *User) DeleteById() (int64, error) {
|
o := orm.NewOrm()
|
return o.Update(u, "isDelete")
|
}
|
