models

type Address struct {
	AddressId    uint64 `json:"addressId" gorm:"column:addressId; primary_key; not null;"`
	Contact      string `json:"contact" gorm:"column:contact; type:varchar(32); not null;"`
	Telephone    string `json:"telephone" gorm:"column:telephone; type:varchar(15); not null;"`
	IsDefault    bool   `json:"isDefault" gorm:"column:isDefault; default:false; not null;"`
	Country      string `json:"country" gorm:"column:country; not null;"`
	ProvinceCity string `json:"city" gorm:"column:city; not null;"`
	Details      string `json:"details" gorm:"column:details; not null;"`
	Status       string `json:"status" gorm:"column:status; type:varchar(10); default:'active'; not null;"`
	UserId       uint64 `json:"userId" gorm:"column:userId; not null;"`
	BaseModel
}

type AddressDTO struct {
	AddressId    uint64 `json:"addressId"`
	Contact      string `json:"contact"`
	Telephone    string `json:"telephone"`
	IsDefault    bool   `json:"isDefault"`
	Country      string `json:"country"`
	ProvinceCity string `json:"provinceCity"`
	Details      string `json:"details"`
	UserId       uint64 `json:"userId"`
}

type Advert struct {
	AdvertId   uint64 `json:"advertId" gorm:"column:advertId; primary_key; not null;"`
	AdvertUrl  string `json:"advertUrl" gorm:"column:advertUrl; not null;"`
	RelativeId uint64 `json:"relativeId" gorm:"column:relativeId; not null;"`
	Remark     string `json:"remark" gorm:"column:remark; not null;"`
	BaseModel
}

type BaseModel struct {
	CreatedAt time.Time  `json:"createdAt" gorm:"column:createdAt;type:dateTime"`
	UpdatedAt time.Time  `json:"updatedAt" gorm:"column:updatedAt;type:dateTime"`
	DeletedAt *time.Time `json:"-" gorm:"column:deletedAt;type:dateTime" sql:"index"`
}

type Category struct {
	CategoryId       uint64 `json:"categoryId" gorm:"column:categoryId; primary_key; not null;"`
	CategoryName     string `json:"categoryName" gorm:"column:categoryName; not null; type:varchar(10);"`
	CategoryIcon     string `json:"categoryIcon" gorm:"column:categoryIcon; not null;"`
	CategoryPriority uint8  `json:"categoryPriority" gorm:"column:categoryPriority; not null; default:0;"`
	Status           string `json:"status" gorm:"column:status; not null; default:'active';"`
	ClassifyId       uint64 `json:"classifyId" gorm:"column:classifyId; not null;"`
	BaseModel
}

type Classify struct {
	ClassifyId       uint64 `json:"classifyId" gorm:"column:classifyId; not null; primary_key;"`
	ClassifyName     string `json:"classifyName" gorm:"column:classifyName; type: varchar(10); not null;"`
	ClassifyIcon     string `json:"classifyIcon" gorm:"column:classifyIcon; not null;"`
	ClassifyPriority uint8  `json:"classifyPriority" gorm:"column:classifyPriority; default:0; not null;"`
	Status           string `json:"status" gorm:"column:status; not null; default:'active';"`
	BaseModel
}

type ClassifyVO struct {
	ClassifyId       uint64 `json:"classifyId" gorm:"column:classifyId; not null; primary_key;"`
	ClassifyName     string `json:"classifyName" gorm:"column:classifyName; type: varchar(10); not null;"`
	ClassifyIcon     string `json:"classifyIcon" gorm:"column:classifyIcon; not null;"`
	ClassifyPriority uint8  `json:"classifyPriority" gorm:"column:classifyPriority; default:0; not null;"`

	CategoryId       uint64 `json:"categoryId" gorm:"column:categoryId; primary_key; not null;"`
	CategoryName     string `json:"categoryName" gorm:"column:categoryName; not null; type:varchar(10);"`
	CategoryIcon     string `json:"categoryIcon" gorm:"column:categoryIcon; not null;"`
	CategoryPriority uint8  `json:"categoryPriority" gorm:"column:categoryPriority; not null; default:0;"`
}

type IAddress interface {
	QueryAddresses(userId uint64) (*[]Address, error)
	CreateAddress(dto *AddressDTO) error
	QueryAddressByAddressId(userId uint64, addressId uint64) (*Address, error)
	UpdateAddress(dto *AddressDTO) error
	DeleteAddressByAddressId(userId uint64, addressId uint64) error
	SetDefaultAddress(userId uint64, addressId uint64) error
}

type IAdvert interface {
	InsertAdvert() error
	UpdateAdvertByAdvertId() error
	QueryAdvertList() ([]Advert, error)
}

type IClassify interface {
	QueryClassifies() (*[]Classify, error)
	CreateClassify() error
	CreateCategory(category *Category) error
}

type IOrders interface {
	QueryOrders(userId uint64, orderType string, pageIndex int) (*[]OrderForm, error)
	PlaceOrder(dto *PlaceOrderDTO) error
	OrderCompleted(userId uint64, orderId uint64) error
	OrderCancel(userId uint64, orderId uint64) error
	QueryOrderDetails(userId uint64, orderId uint64) error
}

type IProduct interface {
	InsertProduct(dtos *ProductDTO) error
	InsertMultipleProducts(dtos *[]ProductDTO) error
	QueryProductsByProductType(productType string, pageIndex int) (*[]Product, error)
	QueryProductDetails(productId uint64) (interface{}, error)
	QueryInventoryDetails(inventoryId uint64) (interface{}, error)
}

type ITeamOperation interface {
	QueryTeamByInvitationCode(invitationCode string) error
	QueryUserTeams(userId uint64) (*TeamVO, error)
}

type IUserOperation interface {
	Register(dto UserRegisterDTO) error
	CheckIsUserExistByUserId(userId uint64) (bool, error)
	CheckIsUserExistByTelephone(telephone string) (bool, error)
	QueryByUserId(userId string) *User
	LoginByTelephone(telephone string, password string) error
	LoginByWechat(jsCode string, wechatUserProfile string, invitationCode string) (*UserWechatVO, error)
}

type Inventory struct {
	InventoryId   uint64  `json:"inventoryId" gorm:"column:inventoryId; primary_key; not null;"`
	Quantity      uint    `json:"quantity" gorm:"column:quantity; default: 1000; not null;"`
	OriginPrice   float64 `json:"originPrice" gorm:"column:originPrice; type: decimal(10, 2); default: 1.00; not null;"`
	SalesNum      uint    `json:"salesNum" gorm:"column:salesNum; default: 0; not null;"`
	Commission    string  `json:"commission" gorm:"column:commission; default: '0%'; not null;"`       // description(Product commission, income=originPrice * commission)
	Specification string  `json:"specification" gorm:"column:specification; default: '默认'; not null;"` // description(Product specification...)
	ProductId     uint64  `json:"productId" gorm:"column:productId; not null;"`
	Status        string  `json:"status" gorm:"column:status; default: 'active'; type: varchar(10); not null;"`
	BaseModel
}

type OrderForm struct {
	OrderId       uint64     `json:"orderId" gorm:"column:orderId; primary_key; not null;"`
	OrderNumber   int64      `json:"orderNumber" gorm:"column:orderNumber; not null;"`
	TotalAmount   float64    `json:"totalAmount" gorm:"column:totalAmount; type: decimal(10, 2); default: 1.00; not null;"`
	TotalDiscount float64    `json:"totalDiscount" gorm:"column:totalDiscount; type: decimal(10, 2); default: 0.00; not null;"`
	Remark        string     `json:"remark" gorm:"column:remark; not null;"`
	Invoice       string     `json:"invoice" gorm:"column:invoice; type: ENUM('PAPER', 'ELECTRONIC', 'NONE'); default:'ELECTRONIC'; not null;"`
	Status        string     `` /* 141-byte string literal not displayed */
	OutTradeNo    uint64     `json:"outTradeNo" gorm:"column:outTradeNo; not null;"`
	AddressId     uint64     `json:"addressId" gorm:"column:addressId; not null;"`
	UserId        uint64     `json:"userId" gorm:"column:userId; not null;"`
	Outbounds     []Outbound `json:"outbounds" gorm:"column:outbounds;ForeignKey:orderId;"`
	BaseModel
}

type Outbound struct {
	OutboundId       uint64  `json:"outboundId" gorm:"column:outboundId; primary_key; not null;"`
	OrderId          uint64  `json:"orderId" gorm:"column:orderId; not null;"`
	ProductId        uint64  `json:"productId" gorm:"column:productId; not null;"`
	ProductName      string  `json:"productName" gorm:"column:productName; not null;"`
	ProductPic       string  `json:"productPic" gorm:"column:productPic; not null;"`
	ProductThum      string  `json:"productThum" gorm:"column:productThum; not null;"`
	ProductUnitPrice float64 `json:"productUnitPrice" gorm:"column:productUnitPrice; type: decimal(10, 2); not null;"`
	Discount         float64 `json:"discount" gorm:"column:discount; type: decimal(10, 2); not null;"`
	Count            uint8   `json:"count" gorm:"default:1; not null;"`
	Amount           float64 `json:"amount" gorm:"type: decimal(10, 2); default: 0.00; not null;"`
	Status           string  `json:"status" gorm:"column:status; default: 'active'; not null;"`
	BaseModel
}

type OutboundDTO struct {
	ProductId        uint64  `json:"productId" gorm:"column:productId;"`
	ProductName      string  `json:"productName" gorm:"column:productName;"`
	ProductPic       string  `json:"productPic" gorm:"column:productPic;"`
	ProductThum      string  `json:"productThum" gorm:"column:productThum;"`
	ProductUnitPrice float64 `json:"productUnitPrice" gorm:"column:productUnitPrice; type: decimal(10, 2);"`
	Discount         float64 `json:"discount" gorm:"column:discount; type: decimal(10, 2);"`
	Count            uint8   `json:"count" gorm:"default:1;"`
	Amount           float64 `json:"amount" gorm:"type: decimal(10, 2); default: 0.00;"`
}

type Picture struct {
	PictureId   uint64 `json:"pictureId" gorm:"column:pictureId; primary_key; not null;"`
	PictureName string `json:"pictureName" gorm:"column:pictureName; not null;"`
	Priority    uint8  `json:"priority" gorm:"column:priority; default: 0; not null;"`
	Status      string `json:"status" gorm:"column:status; default: 'active'; type: varchar(10); not null;"`
	BaseModel
}

type PlaceOrderDTO struct {
	UserId        uint64        `json:"userId" gorm:"column:userId"`
	AddressId     uint64        `json:"addressId" gorm:"column:addressId"`
	TotalDiscount float64       `json:"totalDiscount" gorm:"totalDiscount; type: decimal(10, 2);"`
	TotalAmount   float64       `json:"totalAmount" gorm:"totalAmount; type: decimal(10, 2);"`
	Invoice       string        `json:"invoice" gorm:"column:invoice;"`
	Remark        string        `json:"remark" gorm:"column:remark"`
	Outbounds     []OutboundDTO `json:"products" gorm:"column:products"`
}

type Product struct {
	ProductId      uint64      `json:"productId" gorm:"column:productId; primary_key; not null;"`
	ProductName    string      `json:"productName" gorm:"column:productName; not null;"`
	ProductSubName string      `json:"productSubName" gorm:"column:productSubName; not null;"`
	ProductPic     string      `json:"productPic" gorm:"column:productPic; not null;"`
	ProductThum    string      `json:"productThum" gorm:"column:productThum; not null;"`
	ProductDesc    string      `json:"productDesc" gorm:"column:productDesc; not null;"`
	Priority       uint8       `json:"priority" gorm:"default:0; not null;"`
	ProductType    string      `json:"productType" gorm:"column:productType; default: 'normal'; type: enum('recommend', 'normal', 'specific'); not null;"` // description(Here will have 3 types, include 'recommend', 'normal', 'specific')
	Status         string      `json:"status" gorm:"column:status; default: 'active'; type: varchar(10); not null;"`
	Inventories    []Inventory `json:"inventories" gorm:"column: inventories;"`
	BaseModel
}

type ProductDTO struct {
	Quantity      uint    `json:"quantity"`
	OriginPrice   float64 `json:"originPrice"`
	Commission    string  `json:"commission"`
	Specification string  `json:"specification"`

	ProductName    string `json:"productName"`
	ProductSubName string `json:"productSubName"`
	ProductPic     string `json:"productPic"`
	ProductThum    string `json:"productThum"`
	ProductDesc    string `json:"productDesc"`
	Priority       uint8  `json:"priority"`
	ProductType    string `json:"productType"`
}

type SMS struct {
	UserId        uint64    `json:"userId" gorm:"column:userId; not null;"`
	OperationMode string    `json:"operationMode" gorm:"column:operationMode; not null; type:varchar(10);"`
	SecurityCode  string    `json:"securityCode" gorm:"column:securityCode; type:varchar(6); not null;"`
	Telephone     string    `json:"telephone"`
	ExpiresAt     time.Time `json:"expiresAt" gorm:"column:expiresAt; type:dateTime; not null;"`
	CreatedAt     time.Time `json:"createdAt" gorm:"column:createdAt;type:dateTime"`
}

type Team struct {
	TeamId         uint64 `json:"teamId" gorm:"column:teamId; primary_key; not null;"`
	TopLevelAgent  uint64 `json:"topLevelAgent" gorm:"column:topLevelAgent; not null;"`
	SuperiorAgent  uint64 `json:"superiorAgent" gorm:"column:superiorAgent; not null;"`
	Status         string `json:"status" gorm:"column:status; default:'active'; not null;"`
	Channel        string `json:"channel" gorm:"column:channel; default:'Wechat'; not null;"`
	InvitationCode string `json:"invitationCode" gorm:"column:invitationCode; unique; type:varchar(6); not null;"`
	UserId         uint64 `json:"userId" gorm:"column:userId;not null;"`
	BaseModel
}

type TeamVO struct {
	Team              Team `json:"team"`
	SecondAgentsCount uint `json:"secondAgentsCount"`
	ThirdAgentsCount  uint `json:"thirdAgentsCount"`
}

type User struct {
	UserId uint64 `json:"userId" gorm:"column:userId;primary_key;not null"`
	UserProfile
	Role      uint16    `json:"role" gorm:"column:role; default:10; not null;"`
	Status    string    `json:"status" gorm:"column:status; type:varchar(10); default:'active'; not null;"`
	Channel   string    `json:"channel" gorm:"column:channel; type:varchar(12); not null;"`
	Addresses []Address `json:"addresses" gorm:"column:addresses;"`
	BaseModel
}

type UserProfile struct {
	Telephone string `json:"telephone" gorm:"column:telephone; type:varchar(11);not null"`
	Username  string `json:"username" gorm:"column:username; type:varchar(18);not null"`
	Password  string `json:"-" gorm:"column:password; type:varchar(24);null"`
	Nickname  string `json:"nickname" gorm:"column:nickname; type:varchar(16);not null;"`
	Male      bool   `json:"male" gorm:"column:male; not null; default:false;"`
	Signature string `json:"signature" gorm:"not null; default:'This guy is lazy...'"`
}

type UserRegisterDTO struct {
	Telephone      string `json:"telephone"`
	Password       string `json:"password"`
	Nickname       string `json:"nickname"`
	InvitationCode string `json:"invitationCode"`
}

type UserWechatVO struct {
	User          *User      `json:"user"`
	WechatSession *WxSession `json:"wechatSession"`
}

type WechatMP struct {
	// contains filtered or unexported fields
}

type Wuid struct {
	H uint  `gorm:"primary_key; AUTO_INCREMENT; not null;"`
	X uint8 `gorm:"unique_index; default: '0'; not null;"`
}

type WxSession struct {
	SessionId         uint64 `json:"sessionId" gorm:"column:sessionId; not null; primary_key;"`
	Skey              string `json:"skey" gorm:"column:skey; not null;"`
	SessionKey        string `json:"sessionKey" gorm:"column:sessionKey; not null;" `
	WechatUserProfile string `json:"wechatUserProfile" gorm:"column:wechatUserProfile; not null;"`
	OpenId            string `json:"openId" gorm:"column:openId; index; not null;"`
	UserId            uint64 `json:"userId" gorm:"column:userId; not null;"`
	BaseModel
}