efrilmandClaude Opus 5
992bb04816
Products like fish are sold per weighing (4.2 ons, 5.6 ons), which the order line could not represent: quantity is INTEGER and prices are always computed as quantity * unit_price. Model one weighing as one order line. quantity stays INTEGER and keeps meaning "how many items"; the measured amount goes into a new nullable order_items.weight, and the line is priced weight * unit_price. Two weighings of the same product are two lines, never merged into one. Keeping quantity integral avoids float comparisons in void, refund and split bill, where accumulated rounding error would silently misbehave — "1.4 + 1.4 + 1.4" is not 4.2 in float64, which would leave a fully paid split-bill item marked unpaid. BillableQuantity() is now the single place that decides between weight and count; every price and cost calculation goes through it. Missing one would bill a 4.2 ons fish as a single ons — wrong money, no error. Two database constraints back the design: a weighed line always carries a positive weight, and its quantity is pinned to 1. The latter also makes void all-or-nothing for weighed lines, so the row-splitting branch can never produce a zero-weight remainder row. Also wires product.unit_id through the API, which was previously not settable at all, and corrects the misleading comment on the request's unit_price field — that value has never been used; price always comes from the database. Design notes and the audit of every price multiplication site are in docs/rfc-weight-based-products.md. Co-Authored-By: Claude Opus 5 (1M context) <noreply@anthropic.com>
75 lines
3.5 KiB
Go
75 lines
3.5 KiB
Go
package entities
|
|
|
|
import (
|
|
"time"
|
|
|
|
"github.com/google/uuid"
|
|
"gorm.io/gorm"
|
|
)
|
|
|
|
type Product struct {
|
|
ID uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()" json:"id"`
|
|
OrganizationID uuid.UUID `gorm:"type:uuid;not null;index" json:"organization_id" validate:"required"`
|
|
CategoryID uuid.UUID `gorm:"type:uuid;not null;index" json:"category_id" validate:"required"`
|
|
SKU *string `gorm:"size:100;index" json:"sku"`
|
|
Name string `gorm:"not null;size:255" json:"name" validate:"required,min=1,max=255"`
|
|
Description *string `gorm:"type:text" json:"description"`
|
|
Price float64 `gorm:"type:decimal(10,2);not null" json:"price" validate:"required,min=0"`
|
|
Cost float64 `gorm:"type:decimal(10,2);default:0.00" json:"cost" validate:"min=0"`
|
|
BusinessType string `gorm:"size:50;default:'restaurant'" json:"business_type"`
|
|
ImageURL *string `gorm:"size:500" json:"image_url"`
|
|
PrinterType string `gorm:"size:50;default:'kitchen'" json:"printer_type"`
|
|
UnitID *uuid.UUID `gorm:"type:uuid;index" json:"unit_id"`
|
|
SellBy string `gorm:"size:20;default:'unit'" json:"sell_by"`
|
|
HasIngredients bool `gorm:"default:false" json:"has_ingredients"`
|
|
Metadata Metadata `gorm:"type:jsonb;default:'{}'" json:"metadata"`
|
|
IsActive bool `gorm:"default:true" json:"is_active"`
|
|
CreatedAt time.Time `gorm:"autoCreateTime" json:"created_at"`
|
|
UpdatedAt time.Time `gorm:"autoUpdateTime" json:"updated_at"`
|
|
|
|
Organization Organization `gorm:"foreignKey:OrganizationID" json:"organization,omitempty"`
|
|
Category Category `gorm:"foreignKey:CategoryID" json:"category,omitempty"`
|
|
Unit *Unit `gorm:"foreignKey:UnitID" json:"unit,omitempty"`
|
|
ProductVariants []ProductVariant `gorm:"foreignKey:ProductID" json:"variants,omitempty"`
|
|
ProductRecipes []ProductRecipe `gorm:"foreignKey:ProductID" json:"product_recipes,omitempty"`
|
|
Inventory []Inventory `gorm:"foreignKey:ProductID" json:"inventory,omitempty"`
|
|
OrderItems []OrderItem `gorm:"foreignKey:ProductID" json:"order_items,omitempty"`
|
|
ProductOutletPrices []ProductOutletPrice `gorm:"foreignKey:ProductID" json:"product_outlet_prices,omitempty"`
|
|
}
|
|
|
|
func (p *Product) BeforeCreate(tx *gorm.DB) error {
|
|
if p.ID == uuid.Nil {
|
|
p.ID = uuid.New()
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func (Product) TableName() string {
|
|
return "products"
|
|
}
|
|
|
|
type ProductVariant struct {
|
|
ID uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()" json:"id"`
|
|
ProductID uuid.UUID `gorm:"type:uuid;not null;index" json:"product_id" validate:"required"`
|
|
Name string `gorm:"not null;size:255" json:"name" validate:"required,min=1,max=255"`
|
|
PriceModifier float64 `gorm:"type:decimal(10,2);default:0.00" json:"price_modifier"`
|
|
Cost float64 `gorm:"type:decimal(10,2);default:0.00" json:"cost" validate:"min=0"`
|
|
Metadata Metadata `gorm:"type:jsonb;default:'{}'" json:"metadata"`
|
|
CreatedAt time.Time `gorm:"autoCreateTime" json:"created_at"`
|
|
UpdatedAt time.Time `gorm:"autoUpdateTime" json:"updated_at"`
|
|
|
|
Product Product `gorm:"foreignKey:ProductID" json:"product,omitempty"`
|
|
OrderItems []OrderItem `gorm:"foreignKey:ProductVariantID" json:"order_items,omitempty"`
|
|
}
|
|
|
|
func (pv *ProductVariant) BeforeCreate(tx *gorm.DB) error {
|
|
if pv.ID == uuid.Nil {
|
|
pv.ID = uuid.New()
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func (ProductVariant) TableName() string {
|
|
return "product_variants"
|
|
}
|