Course Management — AHE Student Management System
Course Management is a school management system built with Laravel 12 for AHE (Ahlan Wa Sahlan Education). It features polymorphic attendance, automated student ID sequence, tuition billing checks, and automated WhatsApp parent alerts.
- Year
- 2026
- Role
- Full Stack Developer
- Duration
- 2 weeks
- Status
- Completed
Overview
Course Management is a highly-tuned administration platform for Ahlan Wa Sahlan Education (AHE). It simplifies daily operations by integrating polymorphic database relations for tracking student/teacher attendance under a single schema, managing monthly tuition cycles, and calculating teacher salaries.
Key Capabilities
- 01 Auto-Generated Student Numbers (Format: AHE25001, AHE25002, dst.)
- 02 Polymorphic Attendance System: single table for student and teacher attendance log
- 03 Unique Tuition constraint: prevents duplicate billing entries per month/student
- 04 Interactive analytics and attendance reporting for selected date ranges
- 05 Integrated WhatsApp Helper to format and validate Indonesian numbers (628xxx)
- 06 Library inventory tracking (books pricing & stock constraint controls)
- 07 Automated teacher salary sheets mapped to classes and active attendance
Structuring a polymorphic database architecture for the attendance log so that it cleanly handles both student and teacher relations, while preventing duplicates through compound indices.