model

type Address struct {
	ID         string `gorm:"primaryKey;not null"`
	User       User
	UserID     string `gorm:"type:varchar(255);not null;unique;index"`
	Name       string `gorm:"type:varchar(255);not null"`
	IsPrimary  bool
	CityID     string `gorm:"type:varchar(255);not null"`
	ProvinceID string `gorm:"type:varchar(255);not null"`
	Address1   string `gorm:"type:varchar(255);not null"`
	Address2   string `gorm:"type:varchar(255);not null"`
	Phone      string `gorm:"type:varchar(255);not null"`
	Email      string `gorm:"type:varchar(255);not null"`
	PostCode   string `gorm:"type:varchar(255);not null"`
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type Cart struct {
	ID              string `gorm:"primaryKey;not null;unique"`
	CartItems       []CartItem
	BaseTotalPrice  decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxAmount       decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxPercent      decimal.Decimal `gorm:"type:decimal(10,2)"`
	DiscountAmount  decimal.Decimal `gorm:"type:decimal(16,2)"`
	DiscountPercent decimal.Decimal `gorm:"type:decimal(10,2)"`
	GrandTotal      decimal.Decimal `gorm:"type:decimal(16,2)"`
}

type CartItem struct {
	ID              string `gorm:"primaryKey;not null;unique"`
	Cart            Cart
	CartID          string `gorm:"index;not null"`
	Product         Product
	ProductID       string `gorm:"index;not null"`
	Qty             int
	BasePrice       decimal.Decimal `gorm:"type:decimal(16,2)"`
	BaseTotal       decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxAmount       decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxPercent      decimal.Decimal `gorm:"type:decimal(10,2)"`
	DiscountAmount  decimal.Decimal `gorm:"type:decimal(16,2)"`
	DiscountPercent decimal.Decimal `gorm:"type:decimal(10,2)"`
	SubTotal        decimal.Decimal `gorm:"type:decimal(16,2)"`
	CreatedAt       time.Time
	UpdatedAt       time.Time
}

type Category struct {
	ID       string `gorm:"primaryKey;unique;not null"`
	ParentID string `gorm:"index"`

	Name      string `gorm:"type:varchar(255);unique;not null"`
	Slug      string `gorm:"type:varchar(255);unique;not null"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Model struct {
	Model interface{}
}

type Order struct {
	ID                  string `gorm:"primaryKey;not null;unique"`
	UserID              string `gorm:"index;not null"`
	User                User
	OrderItems          []OrderItem
	OrderCustomer       *OrderCustomer
	Code                string `gorm:"type:varchar(50);index"`
	Status              int
	OrderDate           time.Time
	PaymentDue          time.Time
	PaymentStatus       string          `gorm:"type:varchar(50);index;not null"`
	PaymentToken        string          `gorm:"type:varchar(100);index"`
	BaseTotalPrice      decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxAmount           decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxPercent          decimal.Decimal `gorm:"type:decimal(10,2)"`
	DiscountAmount      decimal.Decimal `gorm:"type:decimal(16,2)"`
	DiscountPercent     decimal.Decimal `gorm:"type:decimal(10,2)"`
	ShippingCost        decimal.Decimal `gorm:"type:decimal(16,2)"`
	GrandTotal          decimal.Decimal `gorm:"type:decimal(16,2)"`
	Note                string          `gorm:"type:text"`
	ShippingCourier     string          `gorm:"type:varchar(100);not null"`
	ShippingServiceName string          `gorm:"type:varchar(100);not null"`
	ApprovedBy          string          `gorm:"size:36"`
	ApprovedAt          time.Time
	CancelledBy         string `gorm:"size:36"`
	CancelledAt         time.Time
	CancellationNote    string `gorm:"size:255"`
	CreatedAt           time.Time
	UpdatedAt           time.Time
	DeletedAt           gorm.DeletedAt
}

type OrderCustomer struct {
	ID         string `gorm:"primaryKey;not null;unique"`
	User       User
	UserID     string `gorm:"index;not null"`
	Order      Order
	OrderID    string `gorm:"index;not null"`
	FirstName  string `gorm:"type:varchar(100);not null"`
	LastName   string `gorm:"type:varchar(100);not null"`
	CityID     string `gorm:"type:varchar(100);"`
	ProvinceID string `gorm:"type:varchar(100);"`
	Address1   string `gorm:"type:varchar(100);"`
	Address2   string `gorm:"type:varchar(100);"`
	Phone      string `gorm:"type:varchar(50);"`
	Email      string `gorm:"type:varchar(100);"`
	PostCode   string `gorm:"type:varchar(100);"`
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type OrderItem struct {
	ID              string `gorm:"primaryKey;not null;unique"`
	Order           Order
	OrderID         string `gorm:"index;not null"`
	Product         Product
	ProductID       string `gorm:"index;not null"`
	Qty             int
	BasePrice       decimal.Decimal `gorm:"type:decimal(16,2)"`
	BaseTotal       decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxAmount       decimal.Decimal `gorm:"type:decimal(16,2)"`
	TaxPercent      decimal.Decimal `gorm:"type:decimal(10,2)"`
	DiscountAmount  decimal.Decimal `gorm:"type:decimal(16,2)"`
	DiscountPercent decimal.Decimal `gorm:"type:decimal(10,2)"`
	SubTotal        decimal.Decimal `gorm:"type:decimal(16,2)"`
	Sku             string          `gorm:"size:36;index"`
	Name            string          `gorm:"size:255"`
	Weight          decimal.Decimal `gorm:"type:decimal(10,2)"`
	CreatedAt       time.Time
	UpdatedAt       time.Time
}

type Payment struct {
	ID          string `gorm:"primaryKey;not null;unique"`
	Order       Order
	OrderID     string          `gorm:"index;not null"`
	Number      string          `gorm:"type:varchar(100);index"`
	Amount      decimal.Decimal `gorm:"type:decimal(16,2)"`
	Method      string          `gorm:"type:varchar(100)"`
	Status      string          `gorm:"type:varchar(100)"`
	Token       string          `gorm:"type:varchar(100);index"`
	Payload     string          `gorm:"type:text"`
	PaymentType string          `gorm:"type:varchar(100)"`
	VaNumber    string          `gorm:"type:varchar(100)"`
	BillCode    string          `gorm:"type:varchar(100)"`
	BillKey     string          `gorm:"type:varchar(100)"`
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   gorm.DeletedAt
}

type Product struct {
	ID       string `gorm:"primaryKey;not null;unique"`
	ParentID string `gorm:"index"`
	User     User
	UserID   string `gorm:"index;not null"`

	Sku              string          `gorm:"type:varchar(100);index"`
	Name             string          `gorm:"type:varchar(255);not null"`
	Slug             string          `gorm:"type:varchar(255);not null"`
	Price            decimal.Decimal `gorm:"type:decimal(16,2);"`
	Stock            int
	Weight           decimal.Decimal `gorm:"type:decimal(10,2);"`
	ShortDescription string          `gorm:"type:text"`
	Description      string          `gorm:"type:text"`
	Status           int             `gorm:"default:0"`
	CreatedAt        time.Time
	UpdatedAt        time.Time
	DeletedAt        gorm.DeletedAt

	ProductImages []ProductImage
	Categories    []Category `gorm:"many2many:product_categories;"`
	CategoryID    []string   `json:"category_id" gorm:"-"`
}

type ProductCategories struct {
	ProductID  string `json:"product_id"`
	CategoryID string `json:"category_id"`
}

type ProductImage struct {
	ID         string `gorm:"primaryKey;not null;unique"`
	Product    Product
	ProductID  string `gorm:"index;not null"`
	Path       string `gorm:"type:text"`
	ExtraLarge string `gorm:"type:text"`
	Large      string `gorm:"type:text"`
	Medium     string `gorm:"type:text"`
	Small      string `gorm:"type:text"`
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type Shipment struct {
	ID          string `gorm:"primaryKey;not null;unique"`
	User        User
	UserID      string `gorm:"index;not null"`
	Order       Order
	OrderID     string `gorm:"index;not null"`
	TrackNumber string `gorm:"type:varchar(255);index"`
	Status      string `gorm:"type:varchar(36);index"`
}

type User struct {
	ID            string `gorm:"primaryKey;not null"`
	Addresses     []Address
	FirstName     string    `gorm:"type:varchar(255);not null"`
	LastName      string    `gorm:"type:varchar(255);not null"`
	Email         string    `gorm:"type:varchar(255);unique;not null"`
	Password      string    `gorm:"type:varchar(255);not null" json:"-"`
	RememberToken string    `gorm:"type:varchar(255);not null" json:"-"`
	CreatedAt     time.Time `json:"-"`
	UpdatedAt     time.Time `json:"-"`
}