How libuna2005/cusg-system works
CUSG Attendance Portal is a PHP/MySQL campus attendance application. Officers scan student QR codes at events; attendance is recorded for the event, while students can view their attendance and administrators manage events, targeting, attendance controls, and reporting. The graph preserves the README’s major capabilities, including batch scanning, population summaries, and photo caching. Several feature paths are represented from the tree and README; their internal wiring is not asserted where source excerpts do not show it.
Main entry points: attendance.php Attendance View · cusg_mysql_schema.sql MySQL Data · config.php Database Connection · register.php Student Registration
Components 26
Event Operations
- Event Management
api/admin/events.php - Event Groups
api/admin/event_groups.php - Excuse Management
api/admin/excuse.php - Attendance Export
api/admin/export_attendance.php - Population Summary
api/admin/students.php
Accounts
- Student Registration
api/auth/register.php - Student Profile
api/student/profile.php - Photo Uploads
api/lib/uploads.php - Photo Cache
views/admin.html - Authentication
api/auth/login.php
Attendance
- Scan Panel
views/admin.html - Live QR Scan
api/admin/scan.php - Batch Upload
api/admin/scan_batch.php - Attendance View
api/student/attendance.php - Attendance Lock
api/admin/attendance_lock.php - Session Completion
api/admin/session_completion.php - Unresolved Scans
api/admin/unresolved_scans.php - Upload Audit
api/admin/upload_audit_log.php
Shared Backend
- Scan Helpers
api/lib/scan_common.php - Common Helpers
api/lib/common.php - Schema Helpers
api/lib/schema.php - Database Connection
api/config.php - MySQL Data
database/cusg_mysql_schema.sql
Other components
- Student Officer
- Student
- Administrator
Connections 28
- Student Officer → Scan Panel: scans QR
readme.md - Scan Panel → Live QR Scan: submits scans
- Student Officer → Batch Upload: uploads batch
readme.md - Live QR Scan → MySQL Data: records attendance
readme.md - Batch Upload → MySQL Data: records attendance
api/admin/scan_batch.php - Batch Upload → Scan Helpers: uses helpers
api/admin/scan_batch.php - Live QR Scan → Scan Helpers: uses helpers
api/admin/scan.php - Student → Attendance View: views attendance
- Attendance View → MySQL Data: reads attendance
api/student/attendance.php - Administrator → Attendance Lock: sets lock
- Administrator → Event Management: manages events
- Administrator → Event Groups: manages groups
- Administrator → Excuse Management: manages excuses
- Administrator → Attendance Export: exports attendance
- Administrator → Population Summary: views population
readme.md - Administrator → Unresolved Scans: reviews scans
- Administrator → Upload Audit: reviews uploads
- Student → Student Registration: registers
- Student → Student Profile: updates profile
- Student Registration → Photo Uploads: saves photo
api/auth/register.php - Student Profile → MySQL Data: updates profile
api/student/profile.php - Database Connection → MySQL Data: connects to
api/config.php - Student Registration → Database Connection: loads connection
api/auth/register.php - Student Profile → Database Connection: loads connection
api/student/profile.php - Attendance View → Database Connection: loads connection
api/student/attendance.php - Attendance View → Common Helpers: uses helpers
api/student/attendance.php - Attendance View → Schema Helpers: uses helpers
api/student/attendance.php - Photo Cache → Photo Uploads: caches photos
readme.md