Learning Management System (LMS) allowing easy access to digital Al-Qur'an, student's daily-monthly statistics on learning progress, whilst also monitoring their attendance.
Software stack:
Learning Management System (LMS) to track student and teacher attendance, alongside academia participant statistics (recent activities log, records, and reports). Complemented with a helper feature for teachers to stay updated, and a feedback + attendance report provision that formats to a predetermined styling for guardian/parents communication via WhatsApp.
Software stack:
Key Features
Authentication:
- (At the moment) uses a shared teacher account that validates identity based on database teacher name data; streamlining storage resources: standard login + session identity (enables individual activity accountability)
- Real-time GPS geofencing ensuring teacher attendance in school when marking work entry and leave; leveraging school coordinates, the "fence" radius, and the teacher's device location)
Feedback via WhatsApp Mechanism:
Attendance Report Parents WhatsApp Mechanism:
Recent Activities Log:
Reports:
A suite of internal tools encompassing Enterprise Resource Planning (ERP) system, custom sales calculator, and a Human Resource Management (HRM) system, accessible through a centralized gateway (portal).
Software stack (restricted to only using vanilla without frameworks per constraints given):
Key Features
Portal:
- Custom lightweight codebase structure (following Model-View-Controller paradigm), encompassing routing and dispatching
- Secure Single Sign On (SSO) portal as the central authentication gateway to propagate identity throughout the 3 internal tools based on JSON Web Tokens (JWT); complemented by cross application logout chain
- Role Based Access Conrol (RBAC); different roles have different privileges
- Cross Site Request Forgery (CSRF) protection: leveraging session tokens for secure form submissions 
ERP System:
- PDF document generation (text + images) from table data via DomPDF
- Asynchronous fetch requests to backend endpoints for table displaying and dropdown options (smoother transition)
Custom Sales Calculator:
- Complex business logic translation (brittle excel formulas to code) via reverse engineering
- Leveraged python scripting to extract and analyze the excel file structure and data
HRM System:
- Cross site scripting (XSS) and CSRF attack mitigation via session hardening; XSS mitigation include output sanitizing before rendering (htmlspecialchars())
- SQL injection prevention sing PHP Document Object (PDO) prepared statements; not concatenating strings into queries;
- Data aggregation and analytics visualization in dashboard