package groupPower_m import ( "git.hilo.cn/hilo-common/domain" "gorm.io/gorm" "hilo-group/myerr" "time" ) type GroupPowerApplyJoin struct { Id uint64 `json:"id"` UserId uint64 `json:"user_id"` GroupPowerId uint64 `json:"group_power_id"` CreatedTime time.Time `json:"created_time"` UpdatedTime time.Time `json:"updated_time"` IsAccept int8 `json:"is_accept"` } func InsertGroupPowerApplyJoin(model *domain.Model, userId, familyId uint64) error { nowTime := time.Now() sql := "insert into group_power_apply_join(user_id,group_power_id,is_accept,created_time,updated_time) " + "value(?,?,?,?,?) on duplicate key update is_accept=?,created_time=?,updated_time=?" err := model.Db.Exec(sql, userId, familyId, 0, nowTime, nowTime, 0, nowTime, nowTime).Error if err != nil { return myerr.WrapErr(err) } return nil } func GetGroupPowerApplyJoin(model *domain.Model, userId, familyId uint64) (*GroupPowerApplyJoin, error) { res := new(GroupPowerApplyJoin) err := model.Db.Where(GroupPowerApplyJoin{UserId: userId, GroupPowerId: familyId}).Where("is_accept=0").First(&res).Error if err != nil { if err == gorm.ErrRecordNotFound { return nil, nil } else { return nil, myerr.WrapErr(err) } } return res, nil } func AcceptGroupPowerApplyJoinById(model *domain.Model, id uint64) error { err := model.Db.Exec("update group_power_apply_join set is_accept = 1 where id=?", id).Error if err != nil { return myerr.WrapErr(err) } return nil } func AcceptGroupPowerApplyJoin(model *domain.Model, userId, familyId uint64) error { err := model.Db.Exec("update group_power_apply_join set is_accept = 1 where user_id=? and group_power_id=?", userId, familyId).Error if err != nil { return myerr.WrapErr(err) } return nil }