Billing System — Implementation Status & Resume Guide

plans                   — Free, Starter, Pro, Business definitions
services                — Service catalog (blog, media, platform)
plan_service_limits     — Limits per plan × service × key
subscriptions           — One per tenant, links to plan + Razorpay
tenant_services         — Effective limits (rebuilt on plan/addon change)
tenant_coins            — Coin wallet (one per tenant)
coin_transactions       — Credit/debit ledger
coin_packs              — Purchasable coin bundles
addon_catalog           — Available add-ons
tenant_addons           — Purchased add-ons per tenant
processed_payment_events — Idempotency tracking for webhooks

tenant ──→ subscription ──→ plan ──→ plan_service_limits
tenant ──→ tenant_services (effective limits, rebuilt by rebuildEntitlements)
tenant ──→ tenant_coins ──→ coin_transactions
tenant ──→ tenant_addons ──→ addon_catalog

RAZORPAY_KEY_ID=rzp_test_xxxxxxxxxxxxx           # Test key (switch to live for prod)
RAZORPAY_KEY_SECRET=xxxxxxxxxxxxxxxxxxxxxxxx      # Test secret
RAZORPAY_WEBHOOK_SECRET=<generated-strong-string> # Must match Razorpay Dashboard

NEXT_PUBLIC_GATEWAY_URL=http://127.0.0.1:8788     # Points to Cloudflare Workers gateway

1. Login to Razorpay Dashboard → Settings → API Keys → Generate Live Key
2. Create Plans in Razorpay Dashboard:
   - Starter Monthly (₹499/mo)
   - Starter Yearly (₹4,999/yr)
   - Pro Monthly (₹1,999/mo)
   - Pro Yearly (₹19,999/yr)
   - Business Monthly (₹4,999/mo)
   - Business Yearly (₹49,999/yr)
3. Copy Plan IDs (plan_...) and update seed.sql:
   - plans.razorpay_plan_id_monthly
   - plans.razorpay_plan_id_yearly
4. Set Webhook URL in Razorpay Dashboard:
   URL: https://logicspike-gateway.starkdipanshu456.workers.dev/manager/billing/webhook
   Events: subscription.activated, subscription.cancelled, subscription.updated, payment.captured
5. Update production secrets:
   - RAZORPAY_KEY_ID (live key)
   - RAZORPAY_KEY_SECRET (live secret)
   - RAZORPAY_WEBHOOK_SECRET (must match dashboard)

UPDATE plans SET razorpay_plan_id_monthly = 'plan_LIVE_xxx' WHERE id = 'starter';
UPDATE plans SET razorpay_plan_id_yearly  = 'plan_LIVE_yyy' WHERE id = 'starter';
-- repeat for pro, business

INSERT INTO coin_packs (id, name, coins, bonus_pct, price_paise, sort_order, is_active)
VALUES
  ('pack_100',  '100 Coins',  100,  0,  9900,   1, true),
  ('pack_500',  '500 Coins',  500,  10, 44900,  2, true),
  ('pack_1000', '1000 Coins', 1000, 20, 79900,  3, true);
 
INSERT INTO addon_catalog (id, display_name, description, service_code, limit_key, units_per_purchase, coin_cost_per_unit, is_recurring, is_active)
VALUES
  ('addon_extra_posts',   'Extra Blog Posts',   '+50 blog posts',    'blog',     'posts',      50,  100, false, true),
  ('addon_extra_storage', 'Extra Storage',      '+5 GB storage',     'media',    'storage_mb', 5120, 200, true,  true),
  ('addon_extra_seats',   'Extra Team Seats',   '+5 team members',   'platform', 'seats',      5,   150, true,  true);

- POST /posts          → check blog.posts limit
- POST /upload         → check media.storage_mb limit
- POST /invitations    → check platform.seats limit
- POST /api-keys       → check platform.api_keys limit
- POST /custom-roles   → check platform.custom_roles limit

// providers/stripe.provider.ts
export class StripeProvider implements IPaymentProvider { ... }

□ Checkout flow: Free → Starter (test card 4111 1111 1111 1111)
□ Payment verify: Signature validation passes
□ Webhook: payment.captured event credits coins
□ Upgrade: Starter → Pro (via change-plan)
□ Downgrade: Pro → Starter (scheduled at cycle end)
□ Cancel: Subscription cancels at period end
□ Coin purchase: Buy pack → verify → balance increases
□ Addon buy: Deducts coins, creates addon, entitlements rebuild
□ Addon cancel: Pauses addon, entitlements rebuild
□ Invoice list: Shows payment history from Razorpay
□ Billing info: Save + load company name and GST
□ Access control: Non-owners see limited tabs
□ Free plan auto-provision: New workspace gets free plan

# Type-check billing code
npx tsc --noEmit --project apps/manager/tsconfig.json
 
# Run dev
turbo run dev
 
# Re-seed database
psql $DATABASE_URL < apps/manager/seed.sql
 
# Generate Razorpay webhook secret
node -e "console.log(require('crypto').randomBytes(32).toString('hex'))"