catering/routers/restful/user.go

package restful

type User struct {
	Id         int    `xorm:"not null pk autoincr INT(10)"`
	Username   string `xorm:"default '''' comment('账号') VARCHAR(50)"`
	Password   string `xorm:"default '''' comment('密码') VARCHAR(50)"`
	Empid      int    `xorm:"default -1 INT(11)"`
	Sort       int    `xorm:"default 0 INT(11)"`
	Enable     int    `xorm:"default 1 TINYINT(4)"`
	CreatedOn  int    `xorm:"default NULL comment('创建时间') INT(11)"`
	ModifiedOn int    `xorm:"default NULL comment('更新时间') INT(11)"`
	DeletedOn  int    `xorm:"default 0 comment('删除时间戳') INT(11)"`
}

/*
type UserRole struct {
	Id        int `xorm:"not null pk autoincr INT(10)"`
	UserId    int `xorm:"default NULL comment('用户ID') INT(11)"`
	RoleId    int `xorm:"default NULL comment('角色ID') INT(11)"`
	DeletedOn int `xorm:"default 0 comment('删除时间戳') INT(11)"`
}

type Role struct {
	Id         int    `xorm:"not null pk autoincr INT(10)"`
	Name       string `xorm:"default '''' comment('名字') VARCHAR(50)"`
	Sort       int    `xorm:"default 0 INT(11)"`
	Enable     int    `xorm:"default 1 TINYINT(4)"`
	CreatedOn  int    `xorm:"default NULL comment('创建时间') INT(11)"`
	ModifiedOn int    `xorm:"default NULL comment('更新时间') INT(11)"`
	DeletedOn  int    `xorm:"default 0 comment('删除时间戳') INT(11)"`
}
*/
func CheckUser(username, password string) (bool, error) {
	has, err := Engine.Exist(&User{Username: username, Password: password})
	return has, err
}

func GetUserInfo(username string) map[string]interface{} {
	valuesMap, err := Engine.SQL("SELECT * FROM  `user` WHERE `username` = ? and `enable` >0 ", username).Query().List()

	if err != nil {
		return nil
	}
	if len(valuesMap) > 0 {
		// valuesMap[0]["role"] = nil
		valuesMap2, err := Engine.SQL("SELECT r.`name`,r.`id` FROM `user` u  JOIN `role` r ON r.id=u.`roleid` WHERE r.`enable`>0 AND u.username=?", username).Query().List()
		if err == nil {
			valuesMap[0]["role"] = valuesMap2
		}
		return valuesMap[0]
	}
	return nil
}

/*
func GetByName(username string) (User, error) {
	user := &User{Username:username}
	has, err := engine.Get(user)

	var valuesMap1 = make(map[string]string)
	engine.Find(&User{Username: username,Password:password})

	has, err := db.Sql("select * from article where id=?", 2).Get(&valuesMap1)

	has, err := engine.Exist(&User{Username: username})
	err := engine.Where("name = ?", name).And("age > 10").Limit(10, 0).Find(&users)
	has, err := engine.Where("Username = ?", username).Get(&user)
	return has, err
}*/