package groupPower_m import ( "git.hilo.cn/hilo-common/domain" "git.hilo.cn/hilo-common/resource/mysql" "gorm.io/gorm" "hilo-group/common/utime" "time" ) type GroupPowerGrade struct { GroupPowerId int64 `json:"group_power_id"` Exp int64 `json:"exp"` Grade int32 `json:"grade"` ExpireAt time.Time `json:"expire_at"` } func (this *GroupPower) Get(model *domain.Model) (*GroupPower, error) { group := new(GroupPower) err := model.Db.Where(this).First(&group).Error if err != nil { if err == gorm.ErrRecordNotFound { return nil, nil } return nil, err } grade := new(GroupPowerGrade) err = model.Db.Model(&GroupPowerGrade{}).Where("group_power_id=? and expire_at > ?", this.ID, time.Now().Format(utime.Layout)).First(&grade).Error if err != nil && err != gorm.ErrRecordNotFound { return nil, err } if grade.GroupPowerId > 0 { group.Grade = mysql.Num(grade.Grade) group.Exp = mysql.Num(grade.Exp) group.NextExp = mysql.Num(grade.Exp) } return group, nil } func (gpu *GroupPowerUser) GetBy(model *domain.Model, pageSize, pageIndex int) ([]*GroupPowerUser, error) { rows := make([]*GroupPowerUser, 0) err := model.Db.Where(gpu).Order("field(`role`, 2, 3, 1)").Limit(pageSize).Offset(pageIndex - 1).Find(&rows).Error if err != nil { return nil, err } return rows, nil }