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
  • School Management
  • Laravel 12
  • Polymorphic Relationships
  • WhatsApp API

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

  1. 01 Auto-Generated Student Numbers (Format: AHE25001, AHE25002, dst.)
  2. 02 Polymorphic Attendance System: single table for student and teacher attendance log
  3. 03 Unique Tuition constraint: prevents duplicate billing entries per month/student
  4. 04 Interactive analytics and attendance reporting for selected date ranges
  5. 05 Integrated WhatsApp Helper to format and validate Indonesian numbers (628xxx)
  6. 06 Library inventory tracking (books pricing & stock constraint controls)
  7. 07 Automated teacher salary sheets mapped to classes and active attendance
Technical Challenge

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.