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) 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
}

func (u *User) GetAllMap() (map[string]User) {
	idM := make(map[string]User)
	all, _ := u.GetAllUsers()
	if all !=nil {
		for _,p := range all {
			idM[p.Id] = p
		}
	}
	return idM
}

func (u *User) Update() (int64, error) {
	o := orm.NewOrm()
	return o.Update(u)
}

func (u *User) UpdatePhoneNum(phoneNum string, hikPersonId string) (int64, error) {
	o := orm.NewOrm()
	res, err := o.Raw("update sys_user set phoneNum=? where id=?", phoneNum, hikPersonId).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")
}

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()
}