CurveLink

# CurveLink

## Overview
A smart community notification platform built with Node.js and Express that allows building management to broadcast emergency notifications and safety alerts to subscribed residents via Twilio SMS.

## Project Structure
- `server.js` - Main Express server with API endpoints
- `db.js` - PostgreSQL database layer using pg pool
- `twilio-tools.js` - Twilio SMS sending utilities
- `index.html` - Public subscription landing page (modern startup design with Inter font)
- `report.html` - Resident report submission page (dark mode, lightning bolt theme)
- `report.js` - Report page frontend logic with subscriber verification
- `admin.html` - Admin dashboard for managing alerts
- `admin.js` - Admin dashboard frontend logic
- `admin.css` - Admin dashboard styles
- `setup.sql` - Database schema for PostgreSQL

## Key Features
- SMS subscription management (START/STOP commands)
- Auto-Welcome SMS sent on subscription with report page link
- Issue reporting via SMS (REPORT command saves to database)
- Web-based report submission (verified subscribers only)
- Broadcast alerts to all subscribers
- Admin dashboard for viewing subscribers and message history
- Twilio webhook integration for incoming/outgoing SMS

## Configuration
The following environment variables are required for full functionality:

### Required Secrets (add via Secrets tab)
- `TWILIO_ACCOUNT_SID` - Twilio Account SID
- `TWILIO_AUTH_TOKEN` - Twilio Auth Token
- `TWILIO_PHONE_NUMBER` - Your Twilio phone number
- `BROADCAST_API_KEY` - API key for broadcast endpoint authentication
- `ADMIN_PASSWORD` - Password required to authorize broadcasts and dismiss reports

### Automatically Configured
- `DATABASE_URL` - PostgreSQL connection string (provided by Replit)

## Development
- Server runs on port 5000
- Database: PostgreSQL with tables for subscribers, messages, message_recipients, and reports
- Run with: `npm start`
- Sandbox Mode: Set `NODE_ENV=development` to log SMS to console instead of sending real texts

## API Endpoints
- `POST /sms` - Twilio webhook for incoming SMS
- `POST /broadcast` - Send alert to all subscribers (requires x-api-key header)
- `POST /admin/broadcast` - Password-protected broadcast from admin UI
- `POST /reports/:id/dismiss` - Password-protected dismiss report
- `POST /api/subscribe` - Public subscription endpoint (sends welcome SMS)
- `POST /api/report` - Verified subscriber report submission
- `GET /subscribers` - List all active subscribers
- `GET /alerts` - List all sent alerts
- `GET /reports` - List all resident-reported issues
- `GET /admin` - Admin Command Center
- `GET /report.html` - Resident report submission page

## Recent Changes
- January 24, 2026: Added Auto-Welcome SMS on subscription with report page URL
- January 24, 2026: Created report.html/report.js - web-based report submission for verified subscribers
- January 24, 2026: Added /api/report endpoint with subscriber verification
- January 24, 2026: Added "Report an issue" link to landing page footer
- January 24, 2026: Fixed Safety Inbox button responsiveness with proper event listeners
- January 17, 2026: Built Admin Command Center with dark mode UI, Safety Inbox, password-protected broadcasts
- January 17, 2026: Redesigned landing page with dark mode aesthetic, green accent color, Inter font
- January 17, 2026: Implemented REPORT SMS feature - residents can text "REPORT [issue]" to log issues to database
- January 17, 2026: Initial Replit setup, configured for port 5000, PostgreSQL database initialized