Admin Reporting Interface

Internal tool for managing program tags, user locations, and attendance data across tenant DBs.

Features

• Program Tags: Manage funding tags (ASES, ELOP, 21C) with bulk ops and multi-tenant reports
• User Locations: Assign staff to schools
• Attendance ER Codes: Edit early release codes with tenant presets
• Audit Log: Full change history in Google Sheets

Tenants

SAUSD, Winters, SJCA, Romoland, Oakland, Fruitvale, Beaumont

Security (2025-01-01)

• Google OAuth (@attendly.com only)
• UUID validation, sanitized errors, parameterized queries
• Fixed: deleted exposed test endpoint, added input validation

Tech Stack

Next.js 16, React 19, TypeScript, PostgreSQL, Google Sheets API, NextAuth.js v5, Tailwind/shadcn

API Routes

Programs: /api/programs, /api/programs/[id]/tags, /api/programs/bulk-tags, /api/programs/stats, /api/reports/all-tenants

Users: /api/users, /api/users/[id]/location

Attendance: /api/attendance-codes, /api/attendance-codes/[id]

Other: /api/audit-log

Repository

attendly/reporting/admin-reporting-interface

Tags: development internal-tools admin