models

type Address struct {
	gorm.Model
	UserID      uint
	ContactName string
	Phone       string
	City        string
	Address1    string
	Address2    string
}

type Agency struct {
	gorm.Model
	CustomerID   uint
	Customer     Customer
	AgencyItemID uint
	AgencyItem   AgencyItem
	Balance      float32
}

type AgencyItem struct {
	gorm.Model
	Type   string
	Amount uint
	Rate   uint
}

type AgencyLog struct {
	gorm.Model
	CustomerID    uint
	Customer      Customer
	AgencyBalance float32
	Opr           string
	Desc          string
}

type Article struct {
	gorm.Model
	Author   User
	AuthorID uint
	Title    string
	Content  string `gorm:"type:text"`
	publish2.Version
	publish2.Schedule
	publish2.Visible
}

type Category struct {
	gorm.Model
	sorting.Sorting
	Name string
	Code string
}

type Chart struct {
	Total string
	Date  time.Time
}

type Collection struct {
	gorm.Model
	Name string
}

type Color struct {
	gorm.Model
	sorting.Sorting
	Name string
	Code string `l10n:"sync"`
}

type ColorVariation struct {
	gorm.Model
	ProductID      uint
	Product        Product
	ColorID        uint
	Color          Color
	ColorCode      string
	Images         media_library.MediaBox
	SizeVariations []SizeVariation
}

type ColorVariationImage struct {
	gorm.Model
	ColorVariationID uint
	Image            ColorVariationImageStorage `sql:"type:varchar(4096)"`
}

type ColorVariationImageStorage struct{ oss.OSS }

type Customer struct {
	gorm.Model
	Name   string // wx name
	Wechat string // wx id
	Phone  string
}

type FeeSetting struct {
	ShippingFee     uint
	GiftWrappingFee uint
	CODFee          uint `gorm:"column:cod_fee"`
	TaxRate         int
}

type Material struct {
	gorm.Model
	l10n.Locale
	Name string
	Code string `l10n:"sync"`
}

type MediaLibrary struct {
	Title string
	media_library.MediaLibrary
}

type Order struct {
	gorm.Model
	CustomerID    uint
	Customer      Customer
	PaymentAmount float32
	//AbandonedReason   string
	DiscountValue     uint
	TrackingNumber    *string
	ShippedAt         *time.Time
	ReturnedAt        *time.Time
	ShippingAddressID uint
	ShippingAddress   Address
	OrderItems        []OrderItem
	State             string
}

type OrderItem struct {
	gorm.Model
	OrderID         uint
	SizeVariationID uint
	SizeVariation   SizeVariation
	Quantity        uint
	Price           float32
	//DiscountRate    uint
	State string
}

type Owner struct {
	Name    string
	Contact string
	Email   string
}

type Page struct {
	gorm.Model

	Title         string
	TitleWithSlug slug.Slug

	QorWidgetSettings       []widget.QorWidgetSetting `gorm:"many2many:page_qor_widget_settings;ForeignKey:id;AssociationForeignKey:name"`
	QorWidgetSettingsSorter sorting.SortableCollection

	publish2.Version
	publish2.Schedule
	publish2.Visible
}

type Product struct {
	gorm.Model
	sorting.SortingDESC

	Name string
	//NameWithSlug          slug.Slug    `l10n:"sync"`
	Code                  string       `l10n:"sync"`
	CategoryID            uint         `l10n:"sync"`
	Category              Category     `l10n:"sync"`
	Collections           []Collection `l10n:"sync" gorm:"many2many:product_collections;"`
	MadeCountry           string       `l10n:"sync"`
	MainImage             media_library.MediaBox
	Price                 float32          `l10n:"sync"`
	Description           string           `sql:"size:2000"`
	ColorVariations       []ColorVariation `l10n:"sync"`
	ColorVariationsSorter sorting.SortableCollection
	ProductProperties     ProductProperties `sql:"type:text"`
	Seo                   qor_seo.Setting
}

type ProductImage struct {
	gorm.Model
	Title        string
	Color        Color
	ColorID      uint
	Category     Category
	CategoryID   uint
	SelectedType string
	File         media_library.MediaLibraryStorage `sql:"size:4294967295;" media_library:"url:/system/{{class}}/{{primary_key}}/{{column}}.{{extension}}"`
}

type ProductProperties []ProductProperty

type ProductProperty struct {
	Name  string
	Value string
}

type Setting struct {
	gorm.Model
	//FeeSetting
	location.Location `location:"name:Company Address"`
}

type Size struct {
	gorm.Model
	sorting.Sorting
	Name string
	Code string `l10n:"sync"`
}

type SizeVariation struct {
	gorm.Model
	ColorVariationID  uint
	ColorVariation    ColorVariation
	SizeID            uint
	Size              Size
	AvailableQuantity uint
}

type Store struct {
	gorm.Model
	StoreName string
	Owner     Owner
	Phone     string
	Email     string
	location.Location
	sorting.Sorting
}

type User struct {
	gorm.Model
	Email     string
	Password  string
	Name      sql.NullString
	Gender    string
	Role      string
	Addresses []Address

	// Confirm
	ConfirmToken string
	Confirmed    bool

	// Recover
	RecoverToken       string
	RecoverTokenExpiry *time.Time
}