base

type Entity struct {
	ID        uuid.UUID      `gorm:"type:uuid;default:gen_random_uuid();comment:主键"`
	CreatedAt time.Time      `gorm:"comment:创建时间"`
	UpdatedAt time.Time      `gorm:"comment:更新时间"`
	DeletedAt gorm.DeletedAt `gorm:"index;comment:删除时间"`
}

type FuzzyField struct {
	Name  string `json:"name"`  //查询字段名称
	Value any    `json:"value"` //查询字段值
}

type GTEField struct {
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type GTField struct {
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type JSONField struct {
	TermFields  []JSONTermField
	FuzzyFields []JSONFuzzyField
	LTEFields   []JSONLTEField
	LTFields    []JSONLTField
	GTEFields   []JSONGTEField
	GTFields    []JSONGTField
	ArrayFields []TermField
}

type JSONFuzzyField struct {
	Field string `json:"field"` //json字段名
	Name  string `json:"name"`  //查询字段名称
	Value any    `json:"value"` //查询字段值
}

type JSONGTEField struct {
	Field string  `json:"field"` //json字段名
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type JSONGTField struct {
	Field string  `json:"field"` //json字段名
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type JSONLTEField struct {
	Field string  `json:"field"` //json字段名
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type JSONLTField struct {
	Field string  `json:"field"` //json字段名
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type JSONTermField struct {
	Field string `json:"field"` //json字段名
	Name  string `json:"name"`  //查询字段名称
	Value []any  `json:"value"` //查询字段值
}

type LTEField struct {
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type LTField struct {
	Name  string  `json:"name"`
	Value float64 `json:"value"`
}

type Model struct {
	ID        int64          `gorm:"primaryKey;autoIncrement:false;comment:主键"`
	CreatedAt time.Time      `gorm:"comment:创建时间"`
	UpdatedAt time.Time      `gorm:"comment:更新时间"`
	DeletedAt gorm.DeletedAt `gorm:"index;comment:删除时间"`
}

type NotNullField struct {
	Name string `json:"name"` //查询字段名称
}

type OrFuzzyField struct {
	Names []string `json:"names"` //查询字段名称
	Value any      `json:"value"` //查询字段值
}

type PageQuery struct {
	Page  int `form:"page"`  //页数
	Limit int `form:"limit"` //每页个数
}

type PreloadField struct {
	Name string
	Args []any
}

type RawSearchCriteria struct {
	SelectSql string
	CountSql  string
	Where     []string
	OrderSql  string
	Values    []any
	PageQuery
}

type SearchCriteria struct {
	PageQuery
	Columns string
	Table   string
	SearchField
	Preloads       []PreloadField
	Joins          []string
	Order          string
	Group          string
	OrFuzzys       []OrFuzzyField
	NoPageQuery    bool
	ContainsDelete bool
}

type SearchField struct {
	TermFields    []TermField
	FuzzyFields   []FuzzyField
	LTEFields     []LTEField
	LTFields      []LTField
	GTEFields     []GTEField
	GTFields      []GTField
	JSONField     JSONField
	NotMullFields []NotNullField
}

type TermField struct {
	Name  string `json:"name"`  //查询字段名称
	Value []any  `json:"value"` //查询字段值
}