Customer Flows

1. StepOne — Event type selection (occasion_type enum)
2. StepEventDetails — Date, time slot, group size, city, neighbourhood
3. StepRequirements — Budget tier, cuisine preference, venue type, special requirements
4. EnquiryModal — Customer details (name, email, phone, company)
5. Submit → Supabase INSERT into enquiries table
        ↓
   DB Trigger: tr_sync_enquiry_currency (BEFORE INSERT)
   DB Trigger: on_enquiry_created_broadcast (AFTER INSERT) → matches venues
   DB Trigger: send_enquiry_notification (AFTER INSERT) → calls send-lead-email Edge Function

Customer logs in → sees all enquiries across 4 tabs:
  - Pending (awaiting venue responses)
  - Bids Received (proposals received from venues)
  - Confirmed (booking confirmed)
  - Completed (event done)
        ↓
Clicks enquiry → sees all proposals received from venues
        ↓
ProposalTemplate shows:
  - Venue details, pricing, selected packages
  - Payment terms, venue policies
  - AI-generated proposal content
        ↓
Customer confirms one proposal →
  ├── Confirmed proposal → status: "confirmed"
  ├── Other proposals → status: "declined" (auto)
  ├── Enquiry → status: "confirmed" + confirmed_proposal_id + confirmed_venue_id set
  set
  └── DB Trigger: trigger_sync_settlement → creates commission_settlements
      DB Trigger: proposal-confirmation-email → sends confirmation emails

venue_leads statuses (pending/accepted/declined/connected/closed_won/closed_lost)
→ Updated MANUALLY by the merchant via the leads dashboard
        ↓
DB Trigger: trigger_sync_settlement → creates commission_settlements record
DB Trigger: proposal-confirmation-email → sends confirmation emails