package models import ( "eta/eta_mini_crm/utils" "fmt" "github.com/beego/beego/v2/client/orm" "strings" "time" ) // UserLevel 用户等级表 type UserLevel struct { UserLevelId int `orm:"column(user_level_id);pk"` LevelRank int `description:"等级编号"` LevelName string `description:"等级名称"` State int `description:"状态:0-禁用;1-启用"` SysUserId int `description:"创建人ID"` SysUserRealName string `description:"创建人姓名"` CreateTime time.Time `description:"创建时间"` ModifyTime time.Time `description:"修改时间"` } func (m *UserLevel) TableName() string { return "user_level" } type UserLevelCols struct { PrimaryId string LevelRank string LevelName string State string SysUserId string SysUserRealName string CreateTime string ModifyTime string } func (m *UserLevel) Cols() UserLevelCols { return UserLevelCols{ PrimaryId: "user_level_id", LevelRank: "level_rank", LevelName: "level_name", State: "state", SysUserId: "sys_user_id", SysUserRealName: "sys_user_real_name", CreateTime: "create_time", ModifyTime: "modify_time", } } func (m *UserLevel) Create() (err error) { o := orm.NewOrm() id, err := o.Insert(m) if err != nil { return } m.UserLevelId = int(id) return } func (m *UserLevel) CreateMulti(items []*UserLevel) (err error) { if len(items) == 0 { return } o := orm.NewOrm() _, err = o.InsertMulti(len(items), items) return } func (m *UserLevel) Update(cols []string) (err error) { o := orm.NewOrm() _, err = o.Update(m, cols...) return } func (m *UserLevel) Remove() (err error) { o := orm.NewOrm() sql := fmt.Sprintf(`DELETE FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.Cols().PrimaryId) _, err = o.Raw(sql, m.UserLevelId).Exec() return } func (m *UserLevel) MultiRemove(ids []int) (err error) { if len(ids) == 0 { return } o := orm.NewOrm() sql := fmt.Sprintf(`DELETE FROM %s WHERE %s IN (%s)`, m.TableName(), m.Cols().PrimaryId, utils.GetOrmInReplace(len(ids))) _, err = o.Raw(sql, ids).Exec() return } func (m *UserLevel) RemoveByCondition(condition string, pars []interface{}) (err error) { if condition == "" { return } o := orm.NewOrm() sql := fmt.Sprintf(`DELETE FROM %s WHERE %s`, m.TableName(), condition) _, err = o.Raw(sql, pars).Exec() return } func (m *UserLevel) GetItemById(id int) (item *UserLevel, err error) { o := orm.NewOrm() sql := fmt.Sprintf(`SELECT * FROM %s WHERE 1=1 AND %s = ? LIMIT 1`, m.TableName(), m.Cols().PrimaryId) err = o.Raw(sql, id).QueryRow(&item) return } func (m *UserLevel) GetItemByCondition(condition string, pars []interface{}, orderRule string) (item *UserLevel, err error) { o := orm.NewOrm() order := `` if orderRule != "" { order = ` ORDER BY ` + orderRule } sql := fmt.Sprintf(`SELECT * FROM %s WHERE 1=1 %s %s LIMIT 1`, m.TableName(), condition, order) err = o.Raw(sql, pars).QueryRow(&item) return } func (m *UserLevel) GetCountByCondition(condition string, pars []interface{}) (count int, err error) { o := orm.NewOrm() sql := fmt.Sprintf(`SELECT COUNT(1) FROM %s WHERE 1=1 %s`, m.TableName(), condition) err = o.Raw(sql, pars).QueryRow(&count) return } func (m *UserLevel) GetItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string) (items []*UserLevel, err error) { o := orm.NewOrm() fields := strings.Join(fieldArr, ",") if len(fieldArr) == 0 { fields = `*` } order := fmt.Sprintf(`ORDER BY %s DESC`, m.Cols().CreateTime) if orderRule != "" { order = ` ORDER BY ` + orderRule } sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s`, fields, m.TableName(), condition, order) _, err = o.Raw(sql, pars).QueryRows(&items) return } func (m *UserLevel) GetPageItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string, startSize, pageSize int) (items []*UserLevel, err error) { o := orm.NewOrm() fields := strings.Join(fieldArr, ",") if len(fieldArr) == 0 { fields = `*` } order := fmt.Sprintf(`ORDER BY %s DESC`, m.Cols().CreateTime) if orderRule != "" { order = ` ORDER BY ` + orderRule } sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s LIMIT ?,?`, fields, m.TableName(), condition, order) _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items) return } type UserLevelItem struct { UserLevelId int `description:"等级ID"` LevelRank int `description:"等级编号"` LevelName string `description:"等级名称"` State int `description:"状态:0-禁用;1-启用"` SysUserId int `description:"创建人ID"` SysUserRealName string `description:"创建人姓名"` CreateTime string `description:"创建时间"` ModifyTime string `description:"修改时间"` ClassifyIds []int `description:"关联分类ID"` } func (m *UserLevel) Format2Item() (item *UserLevelItem) { item = new(UserLevelItem) item.UserLevelId = m.UserLevelId item.LevelRank = m.LevelRank item.LevelName = m.LevelName item.State = m.State item.SysUserId = m.SysUserId item.SysUserRealName = m.SysUserRealName item.CreateTime = utils.TimeTransferString(utils.FormatDateTime, m.CreateTime) item.ModifyTime = utils.TimeTransferString(utils.FormatDateTime, m.ModifyTime) item.ClassifyIds = make([]int, 0) return }