eta_forum_hub/models/user.go

package models

import (
	"eta/eta_forum_hub/utils"
	"github.com/beego/beego/v2/client/orm"
	"github.com/rdlucklib/rdluck_tools/paging"
	"time"
)

type User struct {
	UserId               int `orm:"column(user_id);pk"`
	BusinessCode         string
	EtaBusinessId        int
	RealName             string `description:"姓名"`
	Mobile               string
	Email                string
	UserName             string `description:"用户名"`
	NickName             string `description:"昵称"`
	CountryCode          string `description:"区号，86、852、886等"`
	LastLoginTime        time.Time
	IsFreeLogin          int `description:"是否30天免登录，0否，1是"`
	RegisterTime         time.Time
	LastCollectChartTime string `description:"最近收藏图表时间"`
	Enabled              int
	DepartmentName       string `description:"部门名称"`
	Position             string `description:"岗位"`
	PositionStatus       int    `description:"在职状态：1:在职，0:离职"`
	CreatedTime          time.Time
	LastUpdatedTime      time.Time `description:"最近一次更新时间"`
}

// 用户详情出参
type UserResp struct {
	Detail *User
}

func GetUserByBusinessCodeAndMobile(businessCode, mobile, countryCode string) (item *User, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM user WHERE business_code=? AND mobile = ? AND country_code =?  LIMIT 1`
	err = o.Raw(sql, businessCode, mobile, countryCode).QueryRow(&item)
	return
}

func GetUserByMobiles(mobiles []string) (items []*User, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM user WHERE mobile in (` + utils.GetOrmInReplace(len(mobiles)) + `)`
	_, err = o.Raw(sql, mobiles).QueryRows(&items)
	return
}

// GetUserByMobileCountryCode 根据手机号和区号获取用户信息
func GetUserByMobileCountryCode(mobile, countryCode string) (item *User, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM user WHERE mobile = ? `
	sql += ` and country_code =? `
	sql += ` LIMIT 1 `
	err = o.Raw(sql, mobile, countryCode).QueryRow(&item)
	return
}

func GetUserByUserId(userId int) (item *User, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM user WHERE user_id=? `
	err = o.Raw(sql, userId).QueryRow(&item)
	return
}

func GetUserByUserName(userName string) (item *User, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM user WHERE user_name=? `
	err = o.Raw(sql, userName).QueryRow(&item)
	return
}

// 更新User信息
func (User *User) Update(cols []string) (err error) {
	o := orm.NewOrm()
	_, err = o.Update(User, cols...)
	return
}

// 获取该用户数量
func GetUserCountByCondition(condition string, pars []interface{}) (count int, err error) {
	o := orm.NewOrm()
	tmpSql := `SELECT *
			FROM
				user
			WHERE
				1=1 `
	if condition != "" {
		tmpSql += condition
	}
	sql := `SELECT COUNT(1) AS count FROM (` + tmpSql + `) AS c `
	err = o.Raw(sql, pars).QueryRow(&count)
	return
}

// 获取该用户列表
func GetUserPageListByCondition(condition string, pars []interface{}, startSize, pageSize int) (items []*User, err error) {
	o := orm.NewOrm()
	tmpSql := `SELECT *
			FROM
				user
			WHERE
				1=1 `
	if condition != "" {
		tmpSql += condition
	}
	tmpSql += ` ORDER BY user_id DESC Limit ?,?`
	_, err = o.Raw(tmpSql, pars, startSize, pageSize).QueryRows(&items)
	return
}

type BusinessUser struct {
	UserId          int
	BusinessCode    string
	BusinessName    string
	RealName        string `description:"姓名"`
	Mobile          string
	Email           string
	CountryCode     string `description:"区号，86、852、886等"`
	LastLoginTime   string
	Enabled         int
	DepartmentName  string `description:"部门名称"`
	Position        string `description:"岗位"`
	PositionStatus  int    `description:"在职状态：1:在职，0:离职"`
	CreatedTime     string
	LastUpdatedTime string `description:"最近一次更新时间"`
}

type UserListResp struct {
	Paging *paging.PagingItem
	List   []*BusinessUser
}

// 新增用户请求参数
type AddUserReq struct {
	RealName    string `description:"姓名"`
	CountryCode string `description:"区号，86、852、886等"`
	Mobile      string `description:"手机号"`
	//Email          string `description:"邮箱"`
	Position       string `description:"职位"`
	PositionStatus int    `description:"在职状态：1:在职，0:离职"`
	BusinessCode   string `description:"商家编码"`
	DepartmentName string `description:"联系人部门"`
}

// 删除客户请求参数
type DeleteUserReq struct {
	UserId int
}

// 新增客户请求参数
type EditUserReq struct {
	UserId      int
	RealName    string `description:"姓名"`
	CountryCode string `description:"区号，86、852、886等"`
	Mobile      string `description:"手机号"`
	//Email          string `description:"邮箱"`
	Position       string `description:"职位"`
	PositionStatus int    `description:"在职状态：1:在职，0:离职"`
	BusinessCode   string `description:"商家编码"`
	DepartmentName string `description:"联系人部门"`
}

func DeleteUser(userId int) (err error) {
	o := orm.NewOrm()
	sql := ` DELETE FROM user WHERE user_id=? `
	_, err = o.Raw(sql, userId).Exec()
	return
}

// 联系人导入预览数据返回
type ImportListResp struct {
	ValidUser  []*User `description:"有效客户数据"`
	RepeatUser []*User `description:"重复客户数据"`
}

// 新增客户请求参数
type ChangeUserBusinessReq struct {
	UserId       int
	BusinessCode string `description:"商家编码"`
}

// UserEditEnabledReq 用户状态编辑
type UserEditEnabledReq struct {
	UserId  int `description:"系统用户id"`
	Enabled int `description:"1:有效，0:禁用"`
}

type VerifyCodeReq struct {
	//VerifyType  int    `description:"验证方式: 1-手机号; 2-邮箱"`
	CaptchaId   string `description:"验证码ID"`
	CaptchaCode string `description:"图形验证码"`
	Mobile      string `description:"手机号"`
	TelAreaCode string `description:"手机区号"`
	//Email       string `description:"邮箱"`
	//Source      int    `description:"来源：1-登录；2-异常登录校验；3-忘记密码"`
}

// 入参
type UserLoginReq struct {
	//LoginType   int    `description:"登录方式: 1-账号; 2-手机号; 3-邮箱"`
	Username    string `description:"账号"`
	Password    string `description:"密码"`
	Mobile      string `description:"手机号"`
	Email       string `description:"邮箱"`
	VerifyCode  string `description:"验证码"`
	IsRemember  int    `description:"是否60天保持登录，0否，1是"`
	ReqTime     string `description:"登录时间戳"`
	TelAreaCode string `description:"区号"`
}

type LoginResp struct {
	Authorization  string
	RealName       string `description:"系统用户姓名"`
	Mobile         string `description:"手机号"`
	UserId         int    `description:"系统用户id"`
	BusinessName   string `description:"商家名称"`
	BusinessCode   string `description:"商家编码"`
	DepartmentName string `description:"部门名称"`
	Position       string `description:"岗位"`
}

type ForgetAccountGetReq struct {
	CaptchaId   string `description:"验证码ID"`
	CaptchaCode string `description:"图形验证码"`
	UserName    string `description:"用户名"`
}

type ForgetAccountCheckResp struct {
	Mobile      string `description:"手机号"`
	Email       string `description:"邮箱"`
	TelAreaCode string `description:"手机区号"`
}

type ForgetCodeVerifyReq struct {
	FindType    int    `description:"密码找回方式: 1-手机号; 2-邮箱"`
	VerifyCode  string `description:"验证码"`
	UserName    string `description:"用户名"`
	Mobile      string `description:"手机号"`
	Email       string `description:"邮箱"`
	TelAreaCode string `description:"区号"`
}

type ForgetResetPassReq struct {
	UserName   string `description:"用户名"`
	Password   string `description:"密码"`
	RePassword string `description:"重复密码"`
}