package models

import (
	"gitee.com/lzzandlyx/seckilling/database/mysql"
	"gorm.io/gorm"
	"time"
)

func NewSecKillAction() *SecKillAction {
	return new(SecKillAction)
}

func (sa *SecKillAction) GetSecKillActions() (list []*SecKillAction, err error) {
	startOfDay := time.Now().Truncate(24 * time.Hour)
	endOfDay := startOfDay.Add(24 * 4 * time.Hour)
	err = mysql.WithMysql(func(db *gorm.DB) error {
		// 查询 start_time 在这三天内的活动数据
		return db.Where("start_time >= ? AND start_time < ?", startOfDay, endOfDay).Order("start_time").Find(&list).Error
	})

	return
}

// 秒杀活动表
type SecKillAction struct {
	gorm.Model
	No        string    `gorm:"type:char(36);unique;not null;comment:秒杀活动唯一编号"`
	StartTime time.Time `gorm:"type:datetime;index;not null;comment:开始时间"`
	Duration  uint64    `gorm:"type:tinyint(1);not null;default:1;comment:活动持续时间（h）"`
	State     string    `gorm:"type:char(1);index;not null;default:0;comment:活动状态0-未开启 1-进行中 2-已结束 3-已取消 4-活动异常"`
}