Order schema for PhoenixKit Billing system.

Manages orders with line items, amounts, and billing information. Orders serve as the primary document for tracking what users purchased.

Schema Fields

Identity & Relations

• user_uuid: Foreign key to the user who placed the order
• billing_profile_uuid: Foreign key to the billing profile used
• order_number: Unique order identifier (e.g., "ORD-2024-0001")
• status: Order status workflow

Payment

• payment_method: Payment method (Phase 1: "bank" only)
• currency: ISO 4217 currency code

Line Items

• line_items: JSONB array of items purchased

Financial

• subtotal: Sum of line items before tax/discount
• tax_amount: Calculated tax amount
• tax_rate: Applied tax rate (0.20 = 20%)
• discount_amount: Discount applied
• discount_code: Coupon/referral code used
• total: Final amount to be paid

Snapshots & Notes

• billing_snapshot: Copy of billing profile at order time
• notes: Customer-visible notes
• internal_notes: Admin-only notes

Status Workflow

draft → pending → confirmed → paid
               ↘         ↘
             cancelled   refunded

Line Item Structure

[
  {
    "name": "Pro Plan - Monthly",
    "description": "Professional subscription plan",
    "quantity": 1,
    "unit_price": "99.00",
    "total": "99.00",
    "sku": "PLAN-PRO-M"
  }
]

Usage Examples

# Create an order
{:ok, order} = Billing.create_order(user, %{
  billing_profile_uuid: profile.uuid,
  currency: "EUR",
  line_items: [
    %{name: "Pro Plan", quantity: 1, unit_price: "99.00", total: "99.00"}
  ],
  subtotal: "99.00",
  total: "99.00"
})

# Confirm order
{:ok, order} = Billing.confirm_order(order)

# Mark as paid
{:ok, order} = Billing.mark_order_paid(order)