Society Dashboard (Supabase)

This project is a simple static frontend for one society: Signature Park.

Folder Structure

• public/
  • login.html: Login page
  • index.html: Main dashboard
  • styles.css: Shared UI styles
  • login.js: Login page logic
  • app.js: Dashboard logic
  • config.js: Auto-generated frontend config
• scripts/
  • generate-config.ps1: Generates public/config.js from root .env
• sql/migrations/
  • society_management_migration.sql: Main schema/tables setup
• sql/auth/
  • supabase_users_auth_setup.sql: App user profile + auth helper setup
• .env: Environment values

Important Security Rules

• Do not put service_role key in frontend files.
• Do not put database password in frontend files.
• Frontend should use only anon key.

Run

1. Run sql/migrations/society_management_migration.sql in Supabase SQL Editor.
2. Run sql/auth/supabase_users_auth_setup.sql in Supabase SQL Editor.
3. Ensure .env has the correct values.
4. Run PowerShell: ./scripts/generate-config.ps1.
5. Open public/login.html in browser.
6. After login, you will be redirected to public/index.html.

Notes

• Society is fixed in the dashboard as Signature Park (society_id = 101).
• You only need one login account for office use.