v2

type Activity struct {
	bun.BaseModel `bun:"activities"`

	ActivityID int             `bun:",pk,autoincrement" json:"-"`
	Start      int64           `json:"start"`
	End        null.Int        `json:"end,omitempty" swaggertype:"integer"`
	LabelI18n  json.RawMessage `json:"label_i18n" swaggertype:"object"`
	Existence  json.RawMessage `json:"existence" swaggertype:"object"`
}

type AdvancedQueryResult struct {
	AdvancedResults []any `json:"advanced_results"`
}

type DropInfo struct {
	bun.BaseModel `bun:"drop_infos"`

	DropID     int             `bun:",pk,autoincrement" json:"-"`
	Server     string          `json:"-"`
	StageID    int             `json:"-"`
	ItemID     int             `json:"-"`
	ArkStageID string          `bun:"-" json:"-"`
	ArkItemID  string          `bun:"-" json:"itemId,omitempty"`
	DropType   string          `json:"dropType"`
	RangeID    int             `json:"-"`
	Bounds     json.RawMessage `json:"bounds" swaggertype:"object"`
	Extras     json.RawMessage `json:"-" swaggertype:"object"`

	Item      *Item            `bun:"rel:belongs-to,join:item_id=item_id" json:"-"`
	Stage     *Stage           `bun:"rel:belongs-to,join:stage_id=stage_id" json:"-"`
	TimeRange *model.TimeRange `bun:"rel:belongs-to,join:range_id=range_id" json:"-"`
}

type DropMatrixQueryResult struct {
	Matrix []*OneDropMatrixElement `json:"matrix"`
}

type Dummy struct{}

type Item struct {
	bun.BaseModel `bun:"items"`

	ItemID      int             `bun:",pk,autoincrement" json:"-"`
	ArkItemID   string          `json:"itemId"`
	Name        string          `bun:"-" json:"name"`
	NameI18n    json.RawMessage `bun:"name" json:"name_i18n" swaggertype:"object"`
	Existence   json.RawMessage `json:"existence" swaggertype:"object"`
	ItemType    string          `bun:"column:type" json:"itemType"`
	SortID      int             `json:"sortId"`
	Rarity      int             `json:"rarity"`
	Group       null.String     `json:"groupID,omitempty" swaggertype:"string"`
	Sprite      null.String     `json:"-" swaggertype:"string"`
	SpriteCoord *[]int          `bun:"-" json:"spriteCoord,omitempty"`
	Keywords    json.RawMessage `json:"-" swaggertype:"object"`
	AliasMap    json.RawMessage `bun:"-" json:"alias,omitempty" swaggertype:"array,string"`
	PronMap     json.RawMessage `bun:"-" json:"pron,omitempty" swaggertype:"array,string"`
}

type LoginResponse struct {
	UserID string `json:"userID"`
}

type OneDrop struct {
	ItemID   string `json:"itemId" example:"30012"`
	Quantity int    `json:"quantity" example:"1"`
}

type OneDropMatrixElement struct {
	StageID   string   `json:"stageId" example:"main_01-07"`
	ItemID    string   `json:"itemId" example:"30012"`
	Times     int      `json:"times" example:"1061347"`
	Quantity  int      `json:"quantity" example:"1322056"`
	StdDev    float64  `json:"stdDev" example:"0.114514"`
	StartTime int64    `json:"start" example:"1556676000000"`
	EndTime   null.Int `json:"end,omitempty" swaggertype:"integer"`
}

type OneItemTrend struct {
	Quantity []int `json:"quantity"`
	Times    []int `json:"times"`
}

type OnePatternMatrixElement struct {
	StageID   string   `json:"stageId" example:"main_01-07"`
	Pattern   *Pattern `json:"pattern"`
	Times     int      `json:"times" example:"641734"`
	Quantity  int      `json:"quantity" example:"159486"`
	StartTime int64    `json:"start" example:"1633032000000"`
	EndTime   null.Int `json:"end,omitempty" swaggertype:"integer" extensions:"x-nullable"`
}

type Pattern struct {
	PatternID int        `json:"-" example:"1"`
	Drops     []*OneDrop `json:"drops"`
}

type PatternMatrixQueryResult struct {
	PatternMatrix []*OnePatternMatrixElement `json:"pattern_matrix"`
}

type RecognitionReportResponse struct {
	TaskId string   `json:"taskId" example:"0522ce0083000000-1wE2I9dvMFXXzBMpSCYM81rJ0T3tLrAQ"`
	Errors []string `json:"errors"`
}

type ReportResponse struct {
	ReportHash string `json:"reportHash" example:"0522ce0083000000-1wE2I9dvMFXXzBMpSCYM81rJ0T3tLrAQ"`
}

type SiteStats struct {
	TotalStageTimes     []*TotalStageTime    `json:"totalStageTimes"`
	TotalStageTimes24H  []*TotalStageTime    `json:"totalStageTimes_24h"`
	TotalItemQuantities []*TotalItemQuantity `json:"totalItemQuantities"`
	TotalSanityCost     int                  `json:"totalApCost"`
}

type Stage struct {
	bun.BaseModel `bun:"stages"`

	StageID    int    `bun:",pk,autoincrement" json:"-"`
	ArkStageID string `json:"stageId" example:"main_01-07"`
	ZoneID     int    `json:"-"`
	ArkZoneID  string `bun:"-" json:"zoneId" example:"main_1"`
	// StageType is the type of the stage
	// * MAIN - Mainline Stages
	// * SUB - Sub Stages
	// * ACTIVITY - Activity Stages
	// * DAILY - Daily Stages
	StageType        string          `json:"stageType" enums:"MAIN,SUB,ACTIVITY,DAILY" example:"MAIN"`
	Code             string          `bun:"-" json:"code" example:"1-7"`
	CodeI18n         json.RawMessage `bun:"code" json:"code_i18n" swaggertype:"object"`
	ExtraProcessType null.String     `json:"-" example:"false"`
	IsGacha          bool            `bun:"-" json:"isGacha,omitempty" example:"false"`
	Sanity           null.Int        `json:"apCost" swaggertype:"integer" example:"6"`
	Existence        json.RawMessage `json:"existence" swaggertype:"object"`
	MinClearTime     null.Int        `json:"minClearTime" swaggertype:"integer" extension:"x-nullable" example:"118000"`
	RecognitionOnly  []string        `bun:"-" json:"recognitionOnly,omitempty" extension:"x-nullable"`

	Zone *model.Zone `bun:"rel:belongs-to,join:zone_id=zone_id" json:"-"`

	DropInfos []*DropInfo `bun:"rel:has-many,join:stage_id=stage_id" json:"dropInfos,omitempty"`
}

type StageTrend struct {
	Results   map[string]*OneItemTrend `json:"results"`
	StartTime int64                    `json:"startTime"`
}

type TotalItemQuantity struct {
	ItemID   string `json:"itemId" bun:"ark_item_id"`
	Quantity int    `json:"quantity" bun:"total_quantity"`
}

type TotalStageTime struct {
	StageID string `json:"stageId" bun:"ark_stage_id"`
	Times   int    `json:"times" bun:"total_times"`
}

type TrendQueryResult struct {
	Trend map[string]*StageTrend `json:"trend"`
}

type UniqueUserCountBySource struct {
	SourceName string `json:"source_name" bun:"source_name"`
	Count      int    `json:"count" bun:"count"`
}

type Zone struct {
	bun.BaseModel `bun:"zones"`

	ZoneID       int             `bun:",pk,autoincrement" json:"-"`
	ArkZoneID    string          `json:"zoneId"`
	Index        int             `json:"zoneIndex"`
	Category     string          `json:"type"`
	Type         null.String     `json:"subType" swaggertype:"string"`
	ZoneName     string          `bun:"-" json:"zoneName"`
	ZoneNameI18n json.RawMessage `bun:"name" json:"zoneName_i18n" swaggertype:"object"`
	Existence    json.RawMessage `json:"existence" swaggertype:"object"`
	Background   null.String     `json:"background,omitempty" swaggertype:"string"`
	StageIds     []string        `bun:"-" json:"stages"`

	Stages []*model.Stage `bun:"rel:has-many,join:zone_id=zone_id" json:"-"`
}