hd/models/tug_of_war.go

package models

import (
	"hudongzhuanjia/utils/define"
	"time"

	"github.com/ouxuanserver/osmanthuswine/src/core"
)

type TugOfWar struct {
	Id         int64     `json:"id" description:"主键"`
	Model      string    `json:"model" description:"拔河模式.随机分配模式|H5挑选模式|大屏幕二维码模式"`
	Status     string    `json:"status" description:"拔河活动状态[未开始，准备中，进行中，已结束]"`
	Number     int       `json:"number" description:"预测人数"`
	ActivityId int64     `json:"activity_id" description:"主活动id"`
	IsDelete   bool      `json:"is_delete" xorm:"default(0)" description:"是否删除"`
	CreatedAt  time.Time `json:"created_at" xorm:"created" description:"创建时间"`
	UpdatedAt  time.Time `json:"updated_at" xorm:"updated" description:"更新时间"`
}

func (t *TugOfWar) TableName() string {
	return TableNamePrefix + "tug_of_war"
}

func (t *TugOfWar) GetByActivityId(aid int64, status string) (bool, error) {
	return core.GetXormAuto().Where("is_delete=0 and activity_id=? and status=?", aid, status).
		Desc("created_at").Get(t)
}

func (t *TugOfWar) GetCurrent(aid int64) (bool, error) {
	return core.GetXormAuto().Where("is_delete=0 and activity_id=? and (status=? or status=?)",
		aid, define.StatusReady, define.StatusRunning).Get(t)
}

func (t *TugOfWar) UpdateStatusById(id int64, status string) (int64, error) {
	t.Status = status
	t.UpdatedAt = time.Now()
	return core.GetXormAuto().Where("is_delete=0 and id=?", id).Cols("status", "updated_at").Update(t)
}

func (t *TugOfWar) UpdateToStatusByAid(aid int64, before, after string) (int64, error) {
	t.Status = after
	t.UpdatedAt = time.Now()
	return core.GetXormAuto().Where("is_delete=0 and status=? and activity_id=?", before, aid).
		Cols("status", "updated_at").Update(t)
}

func UpdateTOWStatusByActivityId(aid int64) (int64, error) {
	return core.GetXormAuto().Where("is_delete=0 and activity_id=?", aid).
		Update(&TugOfWar{Status: define.StatusNotBegin})
}