tahap 2

Phase 2 is complete. Here's what was built:

New files:

src/db/schema.ts — added orderItems, orderStatusHistory, orderPayments, whatsappNotificationLogs tables

src/lib/wa.ts — invoice + status-update message builder, buildDeepLink()

src/lib/orderCode.ts — ORD-YYMMDD-XXXXX generator with collision retry

src/routes/orders.ts — 6 endpoints

src/routes/reports.ts — revenue report with client_created_at fallback

Verified:

POST /orders creates order + items in one transaction (3.5 kg × Rp7000 = Rp24.500) ✓

Status chain masuk → proses → selesai with history recorded ✓

Invalid transition selesai → proses correctly rejected ✓

Cash payment auto-marks paymentStatus=paid when fully covered ✓

WA deep-link generates https://wa.me/628...?text=*NOTA LAUNDRY...* with formatted nota ✓

Revenue report returns order_count: 1, total_rupiah: 24500 for today ✓