Struktur Folder

Skema Supabase

Tabel profiles

id · balance · expires_at · total_used · total_topped_up
is_admin · is_pro_account · is_unlimited_deploy
deploy_count_today · deploy_reset_at

Tabel projects

id · user_id · name · files(jsonb) · messages(jsonb) · is_pro
custom_domain · deployed_url · deployed_at
vercel_project_id · vercel_url
user_domain · user_domain_verified · user_domain_dns
share_token · share_enabled · share_views · share_created_at

Tabel Lain

• transactions — transaksi credit (spend/add)
• top_up_requests — request top up manual (bank/QRIS)
• admin_notifications — notif admin (user baru / top up)
• ai_usage_logs — tracking cost per AI call

RPC Functions

• spend_credits(amount, reason, metadata) — potong credit
• add_credits(user_id, amount, reason, metadata) — admin only
• activate_unlimited_deploy() — 250 cr, unlimited deploy

Pricing

Paket Top Up

Unlock

Charge per Action (Level-Based Multiplier)

Model AI (Kenari.id)

Quality Level

Route Flow

User Chat

User → CommandBar → Canvas.handleSubmit()
  → POST /api/chat
    → classifier (auto / standard / smart / premium)
    → resolveKenariModel
    → build prompt + workspace context
    → Kenari call (fallback Luna)
    → return actions + summary
  → applyActions() → workspace context update
  → save ke Supabase

User Deploy

User → Header "Deploy" → gate check
  → [belum Pro] UpsellDialog (deploy-options)
     → 50 cr (Project) / 250 cr (Unlimited)
     → activate + set is_pro
  → DeployDialog → POST /api/deploy
    → auto-inject package.json + next.config + tsconfig
    → Vercel API v13 deployments
    → poll sampai READY
    → add custom subdomain
  → Save deployed_url ke projects

User Preview (Next.js)

PreviewPane → NextJSPreview
  → detect Next.js
  → auto-deploy ke Vercel preview
  → poll ready → iframe render
  → cache 5 menit

User Top Up

User → TopUpDialog → submit form (bank/QRIS)
  → INSERT top_up_requests
  → trigger notify_admin_topup_request → INSERT admin_notifications
  → AdminNotifBell realtime (badge)
  → Admin approve → RPC add_credits
  → trigger realtime user side

Struktur Folder

Skema Supabase

Tabel Utama

• customers — id, name, phone, address, workspace_id
• bookings — customer_id, package_id, total_price, guest_count, booking_date, booking_time, address, notes, status, is_outdoor, assigned_employee_id
• packages — name, description, price, duration, category, pricing_type, max_guests, extra_guest_price, default_is_outdoor
• employees — name, employee_id, role, photo_url, face_descriptor
• admin_users — name, email, role, avatar_url
• attendance — check_in/out, lat/lng, selfie_url, status, is_late, late_minutes, late_penalty, early_leave_penalty, overtime_bonus, work_type, booking_id, scheduled_start/end
• business_schedule — day_of_week, is_working_day, open_time, close_time
• holiday_settings — date, is_holiday, note
• finance — amount, status, payment_method, notes, description, booking_date, type (income/expense), category
• invoices — invoice_number, items, subtotal, total, status, issued_at
• image_generations — user_id, user_type, prompt, image_url, model, date
• push_subscriptions — user_id, endpoint, keys

Tabel Checklist Item Paket

• package_items — template item per paket (id, package_id, name, sort_order)
• booking_items — checklist per booking (booking_id, name, status, done_by, done_at, deadline)

Route Flow

Booking

/bookings → form → handlePackageChange()
  → auto-set is_outdoor dari packages.default_is_outdoor
  → auto-assign assigned_employee_id = Tulus (kecuali vendor)
  → INSERT bookings
    → trigger auto-populate booking_items dari package_items
  → is_outdoor dikontrol radio (admin bisa override, karyawan disabled)

Absensi

/employee-dashboard → loadData()
  → cek business_schedule + holiday_settings
  → cek bookings hari ini WHERE is_outdoor = true
    → ada outdoor: work_type = 'field' (skip telat + early leave)
    → gak ada: work_type = 'studio' (jam kantor 09:00-18:00)
  → verify wajah (face-api compare descriptor)
  → check-in: hitung telat (grace 15 menit) → INSERT attendance
  → check-out: hitung overtime (dari jam tutup, min 60 menit)
             + early leave penalty

Checklist via Pepo Chat

User: "tandai MUA selesai untuk booking Andi"
  → /api/chat/ai
  → classifier → executeTool('update_booking_item', {item_name, status})
  → update booking_items.status = 'done'
  → save done_by + done_at
  → AI kasih konfirmasi

Expense via Pepo Chat

User: "catat pengeluaran bensin 2000"
  → AI: create_expense → auto-detect category 'transport'
  → INSERT finance { type: 'expense', category, description, amount }
  → AI: "Pengeluaran Rp 2.000 untuk Bensin (transport) berhasil dicatat."

Dashboard

/dashboard → loadData()
  → query bookings + customers + booking_items pending
  → hitung KPI: booking/revenue/customer bulan ini vs bulan lalu
  → chart: revenue 7 hari + service mix donut
  → upcoming: booking 7 hari ke depan
  → pending checklist: top 5 dengan urgency