Portal Komunitas Cluster Symphonia Martinez
Portal komunitas & operasional untuk Kluster Symphonia Martinez, Summarecon Serpong.
Spesifikasi lengkap ada di PRD.md.
Tech Stack
| Lapisan | Teknologi |
|---|
| Framework | Next.js 16 (App Router, TypeScript, RSC) |
| Styling | Tailwind CSS v4 + shadcn/ui |
| Database / Auth | Supabase (PostgreSQL, Auth, Storage, RLS) |
| Client Supabase | @supabase/ssr (browser, server, middleware, admin) |
| Form & Validasi | react-hook-form + zod |
| QR / PDF | qrcode.react, jspdf |
| Cron | Vercel Cron (vercel.json) -> /api/cron/daily-report |
Setup
npm install
cp .env.example .env.local # lalu isi kredensial Supabase
npm run dev
Environment
Lihat .env.example. Wajib: NEXT_PUBLIC_SUPABASE_URL,
NEXT_PUBLIC_SUPABASE_ANON_KEY, SUPABASE_SERVICE_ROLE_KEY, CRON_SECRET.
Database
Sudah diterapkan ke project Supabase zfirgedhrkwatjgtfskh (via MCP). Migrasi:
| File | Isi |
|---|
0001_initial_schema.sql | 9 tabel PRD, index, trigger auto-profil_warga, ENABLE RLS |
0002_rls_policies.sql | Policy RLS per peran + helper my_role()/my_unit_id() + RPC verifikasi_surat (anon) |
0003_harden_functions.sql | Pindahkan fungsi internal ke schema private (tak diekspos PostgREST) |
0004_fk_covering_indexes.sql | Index penutup foreign key |
seed.sql | Unit contoh M-01, M-02, M-12 + cara set role pengurus |
Regenerate tipe setelah skema berubah (sudah dilakukan sekali ke
src/types/database.types.ts):
npx supabase gen types typescript --project-id zfirgedhrkwatjgtfskh --schema public > src/types/database.types.ts
Advisor keamanan: satu-satunya WARN tersisa adalah verifikasi_surat yang
memang sengaja dibuka untuk anon (halaman verifikasi QR publik).
Struktur Folder
src/
├── app/
│ ├── (auth)/ # login, register (tanpa shell portal)
│ ├── (portal)/ # area login: guard + shell nav per role
│ │ ├── dashboard/
│ │ ├── iuran/ surat/ kupon/ toko/ # Modul warga
│ │ └── admin/
│ │ ├── warga/ # Modul 1 - master data
│ │ ├── iuran/ kas/ # Modul 2 - bendahara
│ │ ├── surat/ # Modul 3 - approval ketua RT
│ │ ├── event/ event/scan/ # Modul 4 - seksi acara
│ │ └── toko/{pos,produk,mutasi,opname,belanja}/ # Modul 5
│ ├── verify/letter/[token]/ # verifikasi surat publik (ber-QR)
│ └── api/cron/daily-report/ # rekap harian Toko Martinez (22.00 WIB)
├── components/
│ ├── ui/ # shadcn/ui
│ ├── providers/ # theme + toaster
│ ├── layout/ shared/
├── lib/
│ ├── supabase/ # client.ts, server.ts, session.ts, admin.ts
│ ├── constants.ts format.ts rbac.ts
│ └── validations/ # skema zod per modul
├── server/
│ ├── actions/ # Server Actions per modul
│ └── queries/ # query data reusable
├── types/ # database.types.ts + alias domain
├── hooks/
└── proxy.ts # (Next 16) refresh sesi Supabase + guard route
supabase/
├── migrations/0001_initial_schema.sql
└── seed.sql
