model

type AmountPerDay []struct {
	Amount float64 `json:"amount"`
	PayAt  string  `gorm:"column:payAt" json:"payAt"`
}

type Cart struct {
	ID        uint       `gorm:"primary_key" json:"id"`
	OpenID    string     `json:"openId"`
	ProductID uint       `json:"productId"`
	Count     int        `json:"count"`
	CreatedAt time.Time  `json:"createdAt"`
	UpdatedAt time.Time  `json:"updatedAt"`
	DeletedAt *time.Time `sql:"index" json:"deletedAt"`
}

type Category struct {
	ID        uint       `gorm:"primary_key" json:"id"`
	CreatedAt time.Time  `json:"createdAt"`
	UpdatedAt time.Time  `json:"updatedAt"`
	DeletedAt *time.Time `sql:"index" json:"deletedAt"`
	Name      string     `json:"name"`
	Sequence  int        `json:"sequence"`
	ParentID  int        `json:"parentId"`
	Status    int        `json:"status"`
	Remark    string     `json:"remark"`
}

type Image struct {
	ID           uint   `gorm:"primary_key" json:"id"`
	Title        string `json:"title"`
	OrignalTitle string `json:"orignalTitle"`
	URL          string `json:"url"`
	Width        uint   `json:"width"`
	Height       uint   `json:"height"`
	Mime         string `json:"mime"`
}

type Inventory struct {
	ID             uint            `gorm:"primary_key" json:"id"`
	CreatedAt      time.Time       `json:"createdAt"`
	UpdatedAt      time.Time       `json:"updatedAt"`
	DeletedAt      *time.Time      `sql:"index" json:"deletedAt"`
	ProductID      uint            `json:"productID"`
	Count          uint            `json:"count"`
	PropertyValues []PropertyValue `gorm:"many2many:inventory_property_value;ForeignKey:ID;AssociationForeignKey:ID" json:"propertyValues"`
}

type Order struct {
	ID           uint       `gorm:"primary_key" json:"id"`
	CreatedAt    time.Time  `json:"createdAt"`
	UpdatedAt    time.Time  `json:"updatedAt"`
	DeletedAt    *time.Time `sql:"index" json:"deletedAt"`
	UserID       uint       `json:"userId"`
	TotalPrice   float64    `json:"totalPrice"`
	Payment      float64    `json:"payment"`
	Freight      float64    `json:"freight"`
	Remark       string     `json:"remark"`
	Discount     int        `json:"discount"`
	DeliverStart time.Time  `json:"deliverStart"`
	DeliverEnd   time.Time  `json:"deliverEnd"`
	Status       int        `json:"status"`
	PayAt        time.Time  `json:"payAt"`
}

type OrderPerDay []struct {
	Count     int    `json:"count"`
	CreatedAt string `gorm:"column:createdAt" json:"createdAt"`
}

type PVPerDay []struct {
	PV   int    `json:"pv"`
	Date string `gorm:"column:date" json:"date"`
}

type Product struct {
	ID             uint        `gorm:"primary_key" json:"id"`
	CreatedAt      time.Time   `json:"createdAt"`
	UpdatedAt      time.Time   `json:"updatedAt"`
	DeletedAt      *time.Time  `sql:"index" json:"deletedAt"`
	Name           string      `json:"name"`
	BrowseCount    int         `json:"browseCount"`
	BuyCount       int         `json:"buyCount"`
	TotalSale      float64     `json:"totalSale"`
	Price          float64     `json:"price"`
	OriginalPrice  float64     `json:"originalPrice"`
	Status         int         `json:"status"`
	ImageID        uint        `json:"imageID"`
	Image          Image       `json:"image"`
	ImageIDs       string      `json:"imageIDs"`
	Images         []Image     `json:"images"`
	HasProperty    bool        `json:"hasProperty"`
	Properties     []Property  `json:"properties"`
	Inventories    []Inventory `json:"inventories"`
	TotalInventory uint        `json:"totalInventory"`
	Remark         string      `json:"remark"`
	Detail         string      `json:"detail"`
	Categories     []Category  `gorm:"many2many:product_category;ForeignKey:ID;AssociationForeignKey:ID" json:"categories"`
}

type Property struct {
	ID             uint            `gorm:"primary_key" json:"id"`
	CreatedAt      time.Time       `json:"createdAt"`
	UpdatedAt      time.Time       `json:"updatedAt"`
	DeletedAt      *time.Time      `sql:"index" json:"deletedAt"`
	Name           string          `json:"name"`
	ProductID      uint            `json:"productID"`
	PropertyValues []PropertyValue `json:"values"`
}

type PropertyValue struct {
	ID         uint       `gorm:"primary_key" json:"id"`
	CreatedAt  time.Time  `json:"createdAt"`
	UpdatedAt  time.Time  `json:"updatedAt"`
	DeletedAt  *time.Time `sql:"index" json:"deletedAt"`
	Name       string     `json:"name"`
	Note       string     `json:"note"`
	ProductID  uint       `json:"productID"`
	PropertyID uint       `json:"propertyID"`
}

type User struct {
	ID        uint       `gorm:"primary_key" json:"id"`
	CreatedAt time.Time  `json:"createdAt"`
	UpdatedAt time.Time  `json:"updatedAt"`
	DeletedAt *time.Time `sql:"index" json:"deletedAt"`
	ContactID string     `json:"contactId"` //默认地址
	OpenID    string     `json:"openId"`
	Nickname  string     `json:"nickname"`
	Username  string     `json:"username"`
	Email     string     `json:"email"`
	Phone     string     `json:"phone"`
	Password  string     `json:"password"`
	Token     string     `json:"token"`
	Sex       bool       `json:"sex"`
	Subscribe bool       `json:"subscribe"`
	Status    int        `json:"status"`
	Lastip    string     `json:"lastip"`
}

type UserPerDay []struct {
	Count     int    `json:"count"`
	CreatedAt string `gorm:"column:createdAt" json:"createdAt"`
}

type UserVisit struct {
	ID             uint      `gorm:"primary_key" json:"id"`
	URL            string    `json:"url"`
	Referrer       string    `json:"referrer"`
	ClientID       string    `json:"clientID"`
	UserID         uint      `json:"userID"`
	VisitTime      time.Time `json:"visitTime"`
	IP             string    `json:"ip"`
	DeviceWidth    int       `json:"deviceWidth"`
	DeviceHeight   int       `json:"deviceHeight"`
	BrowserName    string    `json:"browserName"`
	BrowserVersion string    `json:"browserVersion"`
	DeviceModel    string    `json:"deviceModel"`
	Country        string    `json:"country"`
	Language       string    `json:"language"`
	OSName         string    `json:"osName"`
	OSVersion      string    `json:"osVersion"`
}

type WeAppUser struct {
	OpenID    string `json:"openId"`
	Nickname  string `json:"nickName"`
	Gender    int    `json:"gender"`
	AvatarURL string `json:"avatarUrl"`
}