TMRWatchComm/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 true, nil
}

func GetUserInfo(username string) map[string]interface{} {
	valuesMap := make([]map[string]interface{}, 1)
	valuesMap2 := make([]map[string]interface{}, 1)
	tqueryData, err := Dbs.Queryx("SELECT * FROM  `user` WHERE `username` = ? and `enable` >0 ", username)
	if err != nil {
		return nil
	}
	valuesMap, err = rows2mapObjects(tqueryData)

	if err != nil {
		return nil
	}
	if len(valuesMap) > 0 {
		tqueryData2, err := Dbs.Queryx("SELECT r.`name`,r.`id` FROM `user` u JOIN `user_role` ur ON u.`id`=ur.`user_id` JOIN `role` r ON r.id=ur.`role_id` WHERE r.`enable`>0 AND u.username=?", username)
		if err == nil {
			valuesMap2, err = rows2mapObjects(tqueryData2)
			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
}*/