Project Tracker

Build Checklist

Track completed and pending work across the concert site and music school system. Check items as they are completed โ€” progress is saved automatically in this browser.

Overall Progress

0%
0 completed 0 pending 0 total

๐ŸŽต Concert Site

Registration Page
Performer card with instrument dropdown (Piano, Violin, etc.)
Piece information โ€” title, composer, duration
Guest management and pricing
PayPal and Zelle payment options
Time slot capacity tracking (11 AM / 12 PM)
Duplicate email detection
Supabase DB save with retry logic
Formspree + EmailJS confirmation email
Sponsored by Steinway Piano Galleries section
Admin Panel
Dashboard with live stats
Registrations โ€” view, confirm, cancel, manual add, export CSV
Concert Program โ€” generate, reorder, lock/unlock, print per slot
Events management
Email Campaigns (Mailchimp)
PayPal Sync
Sandbox / Live mode toggle
Health Check
Inventory management
Security โ€” change password, session info
API Config โ€” status of all integrations
Pending
Fix Twilio SMS โ€” not receiving texts Bug
Remove unused admin-v2.html and admin-legacy.html files

๐ŸŽ“ Music School System

Foundation
Separate Supabase project (RWM Music School DB)
Complete schema v3 โ€” 29 tables, multi-school, multi-currency (USD/PEN)
Multi-school architecture โ€” RWM-US (Alpharetta GA) + RWM-PE (Trujillo Peru)
School switcher โ€” sidebar dropdown persisted in localStorage
Sandbox / Live mode toggle on all school pages โ€” blocks DB writes in sandbox
Deploy school system to Porkbun (risingwithmelodies.org/school/) Deploy
Modules โ€” Completed
Students โ€” full enrollment form, guardian, financial aid, auto student ID, search, filter, export CSV
Programs โ€” class types (Music/English/Arts/Sports), instrument, pricing (USD/PEN), activate/deactivate
Staff โ€” roles, instruments taught, hourly/monthly rate, hire date, bio, CSV export
Enrollments โ€” student + program + teacher + schedule, tuition type, discount %, status management
Attendance โ€” daily lesson tracking, auto-generate from schedule, Present/Absent/Late/Excused, notes
Gradebook โ€” assessments (practical/theory/recital/exam), grade entry, report cards with publish/print
Billing โ€” monthly + per-lesson invoices, payment recording (Zelle/cash/check), multi-currency
Scholarships & Donors โ€” scholarship programs, student awards, donor profiles, donation tracking
Dashboard Analytics โ€” 8 live stats, today's schedule with attendance dots, recent students, quick actions
Inventory โ€” instruments, books, equipment, loan tracking with availability bar
Communications โ€” announcements, email (mailto), SMS (Twilio), draft/send history
Volunteers โ€” concert registrants auto-saved to school DB, manual add, CSV export
Concert โ†’ School cross-save โ€” donors saved to Scholarships, volunteers saved to Volunteers (RWM-PE)
Stripe integration for online tuition payments + manual invoice creation
Parent / Student Portal โ€” login, overview, attendance, invoices, Stripe pay, report cards

๐Ÿ“„ Documentation

Admin User Guides
Docs home page
Concert Admin User Guide
School Admin User Guide
Deploy docs to Porkbun (risingwithmelodies.org/docs/) Deploy
Technical & Operations
Technical Reference โ€” system architecture, data model
Deployment Guide โ€” build and upload to Porkbun workflow
Operations Guide โ€” weekly/monthly checklist
Troubleshooting Guide โ€” common issues and fixes