package models

// DashboardDailyStat 仪表盘每日统计表
type DashboardDailyStat struct {
	ID                  int64 `json:"id" gorm:"primarykey;comment:ID"`
	StatDate            int64 `json:"stat_date" gorm:"type:bigint;not null;default:0;comment:统计日期(YYYYMMDD格式)"`
	TotalReceivingNum   int64 `json:"total_receiving_num" gorm:"not null;default:0;comment:总入库次数"`
	TotalOutboundNum    int64 `json:"total_outbound_num" gorm:"not null;default:0;comment:总出库次数"`
	TotalSalesCount     int64 `json:"total_sales_count" gorm:"not null;default:0;comment:总销售订单数"`
	ProductTotal        int64 `json:"product_total" gorm:"not null;default:0;comment:商品总量"`
	InventoryTotal      int64 `json:"inventory_total" gorm:"not null;default:0;comment:库存总量"`
	TodayInbound        int64 `json:"today_inbound" gorm:"not null;default:0;comment:今日入库次数"`
	TodayOutbound       int64 `json:"today_outbound" gorm:"not null;default:0;comment:今日出库次数"`
	YesterdayInbound    int64 `json:"yesterday_inbound" gorm:"not null;default:0;comment:昨日入库次数"`
	YesterdayOutbound   int64 `json:"yesterday_outbound" gorm:"not null;default:0;comment:昨日出库次数"`
	TodaySalesCount     int64 `json:"today_sales_count" gorm:"not null;default:0;comment:今日销售订单数"`
	YesterdaySalesCount int64 `json:"yesterday_sales_count" gorm:"not null;default:0;comment:昨日销售订单数"`
	CreatedAt           int64 `json:"created_at" gorm:"type:bigint;not null;default:0;comment:创建时间戳(秒)"`
	UpdatedAt           int64 `json:"updated_at" gorm:"type:bigint;not null;default:0;comment:更新时间戳(秒)"`
	IsDel               int8  `json:"is_del" gorm:"type:tinyint(1);not null;default:0;comment:逻辑删除标记(0:未删除,1:已删除)"`
}

func (DashboardDailyStat) TableName() string {
	return "dashboard_daily_stat"
}

func (DashboardDailyStat) TableOptions() string {
	return "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='仪表盘每日统计表'"
}