db

type DeleteParam struct {
	IDS []int32 `json:"id" validate:"required:主键值必须"`
}

type FirstParam struct {
	ID int32 `form:"id" validate:"required:主键值必须"`
}

type ListParamBase struct {
	Page     int32  `form:"page"`
	PageSize int32  `form:"page_size"`
	Order    string `form:"order"`
}

type ListResult struct {
	Data     any   `json:"data"`
	Total    int64 `json:"total"`
	Page     int32 `json:"page"`
	PageSize int32 `json:"page_size"`
}

type ModelChildren[T any] struct {
	PID      int32 `gorm:"column:pid;type:bigint;default:0;comment:父级id;index" json:"pid"`
	Level    int32 `gorm:"column:level;type:int;default:1;comment:层级;index" json:"level"`
	Children []T   `gorm:"-:migration;foreignKey:pid;references:id" json:"children"`
}

type ModelCreatedAt struct {
	CreatedAt Time `gorm:"column:created_at;autoCreateTime:milli;comment:创建时间" json:"created_at"`
}

type ModelDeletedAt struct {
	Deleted Time `gorm:"column:deleted;comment:删除时间" json:"deleted"`
}

type ModelHasChildren struct {
	HasChildren bool `gorm:"-:all;default:false" json:"hasChildren"`
}

type ModelID struct {
	ID int32 `gorm:"column:id;primaryKey;autoIncrement;comment:ID" json:"id"`
}

type ModelSort struct {
	Sort int32 `gorm:"column:sort;type:bigint;default:100;comment:排序;index" json:"sort"`
}

type ModelState struct {
	State int32 `gorm:"column:state;type:int;default:1;comment:状态:1-开启,2-关闭;index" json:"state"`
}

type ModelUpdatedAt struct {
	UpdatedAt Time `gorm:"column:updated_at;autoUpdateTime:milli;comment:更新时间" json:"updated_at"`
}

type Time time.Time

type UpdateParam struct {
	ID    int32  `json:"id" validate:"required:主键值必须"`
	Field string `json:"field" validate:"required:字段名必须"`
	Value any    `json:"value"`
}