Back to Overview
04 / 05
CASE STUDY · 04Next.js 16 & Prisma MySQL2024–26

Evershine Academy ERP & LMS

Multi-campus educational ERP & LMS featuring live biometric fingerprint integration, 7-role portals & automated finance engine.

Screen 1 of 14Auto-scrolling every 3s
https://evershineacadmey.com
Evershine Academy ERP & LMS — 01 Public Gateway
01 Public Gateway

Public admissions landing page with multi-campus programs, shifts, and direct LMS access

Application Screen Flow (Click any tag to jump to that screen)
Executive Architecture

System Overview & Engineering Longevity

A comprehensive enterprise-grade educational ERP and learning management system engineered for multi-campus institutions operating across morning, evening, and night shifts. Built with Next.js 16 App Router, React 19, Prisma ORM, and MySQL, the platform integrates live hardware biometric fingerprint machines for automated attendance reconciliation, alongside mission-critical academic and financial operations: multi-step online admissions, automated monthly fee invoices with printable 3-part bank challans (jsPDF), penalty policy calculations, staff payroll ledgers, continuous student performance evaluation, and 7 distinct role-based portals (Super Admin, Campus Admin, Teacher, Accountant, Student, Parent, Guardian).

Core Innovations

Key Engineering Highlights

On-premise biometric fingerprint machine integration syncing daily student & staff attendance
Automated penalty policy assessments for unexcused absences, late arrivals & fee delays
Comprehensive staff payroll & salary slip generator with attendance-based deductions
Examination management with automated hall ticket / roll number slip issuance
Teacher classroom suite: daily scoring, student targets, monthly monitoring & grade entry
End-of-term student promotion engine with academic year session rollover
Document printing vault: QR student/faculty ID cards, bonafide & character certificates
7 role-based portals: Super Admin, Admin, Teacher, Accountant, Student, Parent, Guardian
Automated 3-part bank fee challans (jsPDF), partial payment tracking & P&L ledgers
Multi-campus architecture with 3 shifts (Morning, Evening, Night) & prayer-synced timetables
Public admission portal with CNIC duplicate protection & administrative lead queue
Argon2id password hashing, campus-scoped data isolation, role assumption & audit logging
Deployment & Repository
Launch Live System
Technologies & Protocols
Next.js 16React 19TypeScriptPrisma ORMMySQLTailwind CSS 4NextAuth.js 5Argon2idBiometric Machine SDKjsPDF / ExcelJSCloudinaryResendHostinger VPS
Production Standard

Architected with clean domain separation, strict TypeScript contracts, and automated telemetry logging.

Live Biometrics

Hardware Integration

On-premise fingerprint machine attendance sync

7 Portals

Role-Based Portals

Super Admin, Admin, Teacher, Accountant, Student, Parent, Guardian

3 Shifts

Shift Scheduling

Morning, Evening, and Night coaching

100%

ACID Financial Safety

Atomic Prisma transactions for fee ledgers

14 Modules

Production Engines

Biometrics, ERP, HR, Exams, Promotions & Portals

14 Screens

Verified UI Flows

Interactive walkthrough across all key dashboards

Execution Pipeline

End-to-End System Data Flow

How user inputs, computer vision pipelines, and transaction protocols flow across the stack.

STEP 01

Multi-Role Identity & Session Verification

User authenticates through NextAuth.js; Argon2id verifies credentials and issues campus-scoped session tokens with one of 7 RBAC roles.

STEP 02

Hardware Biometric Sync & Attendance Pipeline

On-premise fingerprint machine punch records are uploaded/synced, parsed row-by-row, and validated against enrolled shift rosters.

STEP 03

Campus & Shift Scoped API Gateways

Route handlers validate request payloads via Zod schemas and enforce campus isolation barriers before querying the database.

STEP 04

Prisma Transactional Ledger & Penalty Engine

Financial transactions (challan creation, fee receipts, penalty assessments, payroll entries) execute inside atomic Prisma transactions.

STEP 05

Client-Side Vector Document Rendering

Challans, ID cards, roll number slips, and result cards compile dynamically into print-ready vector PDFs using jsPDF/html2canvas.

STEP 06

Automated Scheduled Cron Routines

Hostinger cron triggers protected endpoints with CRON_SECRET to calculate late penalties, sync attendance, and dispatch email notices.

Module Architecture

System Capabilities & 14+ Functional Modules

14 Production Subsystems
Hardware Integration & IoT

Hardware Biometric Fingerprint Integration & Log Sync

Direct integration with on-premise biometric fingerprint attendance machines deployed across academy branches. Ingests daily check-in and check-out punch logs for both students and teaching staff. Validates timestamps row-by-row, auto-associates punches with scheduled coaching shifts (Morning, Evening, Night), and flags unexcused absences or late arrivals automatically in the centralized database.

On-premise biometric fingerprint device log ingestion for students & faculty
Dual-channel import with row-by-row Excel/API validation and duplicate detection
Timestamp parsing auto-associating punches with Morning/Evening/Night coaching shifts
Automated unexcused absence & late-entry detection feeding into penalty calculations
Institutional Governance

Penalty Policies & Automated Fine Assessment Engine

Automated disciplinary governance system enforcing institutional rules for unexcused absences, consecutive late entries, uniform infractions, and overdue tuition fee grace periods. Calculates daily and monthly fines dynamically, appending penalties directly onto student monthly fee challans or executing deductions on faculty payroll.

Configurable penalty rules for late coming, missed classes, and overdue fee dates
Automated batch penalty calculation engine executing during monthly billing cycles
Dynamic appending of assessed penalties onto printable 3-part bank challans
Administrative waiver and dispute override workflow with immutable audit trails
HR & Financial Ledger

Faculty HR, Staff Payroll & Salary Slips Ledger

Comprehensive staff compensation suite supporting multi-tier compensation models: fixed base pay, coaching shift stipends, and hourly rates. Automatically reconciles payroll against biometric attendance logs and approved leaves, calculates net disbursements, and generates printable branded salary slips.

Dynamic compensation engine supporting base salaries and shift-specific stipends
Automated payroll deductions calculated directly from biometric absence logs
Printable branded staff salary slips with line-item earnings and deductions
Campus-level operational expense ledger tracking utility bills, rent, and reserve funds
Core Academic Infrastructure

Academic Engine & Multi-Shift Scheduling

Engineered a multi-campus, multi-shift academic structure supporting Morning, Evening, and Night coaching sessions. Manages student batch enrollment (Shaheen, Parwaaz, Junoon), section allocations, subject offerings, teacher assignments, and classroom room capacity allocations.

Multi-campus hierarchical structure: Campus → Batch → Class → Section → Room
3 concurrent shift engines: Morning, Evening, and Night coaching schedules
Subject offering allocation with teacher scheduling conflict detection
Classroom room allocations with physical capacity threshold enforcement
Financial Ledger & Billing

Finance & Automated 3-Part Bank Fee Challan ERP

Automated financial billing pipeline that generates monthly fee invoices and printable 3-part bank fee challans (Student Copy, Bank Copy, Academy Copy) rendered via jsPDF and html2canvas. Handles partial payments, proof-of-payment image uploads, late fee penalty calculations, operational expense ledgers, and profit & loss statements.

Automated monthly fee invoice generation with batch processing and unique Challan IDs
Printable branded 3-copy bank challans rendered via jsPDF and html2canvas
Payment proof upload verification with accountant approval workflows
Configurable late fee penalties, reserve fund ledger, and P&L financial summaries
Pedagogical Telemetry

Teacher Classroom Suite: Daily Scores & Targets

Comprehensive continuous evaluation suite for teaching faculty. Teachers record daily classroom participation, homework marks, and quiz scores. Tracks individual student target performance against monthly monitoring benchmarks and provides a fast grade entry portal with draft and declared result publication states.

Daily performance scoring desk tracking participation, homework, and mini-quizzes
Monthly student target tracking comparing benchmark goals against actual scores
Fast teacher grade entry portal with draft and declared result states
Teacher feedback registry capturing student evaluations and administrative reviews
Examination Governance

Examination Engine, Date Sheets & Digital Roll No. Slips

Complete examination management system handling term examination schedules, room allocations, and invigilation rosters. Automatically compiles and renders printable digital roll number slips (hall tickets) with student photographs, seat numbers, and examination guidelines.

Automated examination date sheet publication with subject-wise scheduling
Digital roll number slip generation with student photo, roll number & seat allocation
Student self-service download portal for official examination date sheets
Subject-wise and class-wise examination mark aggregation feeding terminal report cards
Lifecycle Automation

End-of-Term Student Promotion & Session Rollover

Automated student lifecycle transition engine evaluating cumulative academic scores, exam results, and attendance percentages against promotion criteria. Orchestrates batch student promotions to the next class grade, handles section reassignments, and initializes new academic sessions.

Automated pass/fail and promotion eligibility evaluation engine
Batch promotion workflow transferring eligible students to next grade (e.g. 9th → 10th)
Academic session rollover transitioning curriculum and archiving historical records
Section retention and conditional promotion handling for borderline students
Security & Tenancy

7-Tier Role-Based Access Control & Role Assumptions

A strict permission-based architecture isolating access across 7 user roles: Super Admin, Campus Admin, Teacher, Accountant, Student, Parent, and Guardian. Features campus-scoped data isolation and a specialized Super Admin role assumption tool for administrative troubleshooting.

7 dedicated user roles with scoped permissions and custom dashboard navigation
Campus-scoped data isolation preventing cross-branch data leaks
Super Admin role assumption mode allowing secure impersonation for support
Argon2id password hashing, NextAuth.js session orchestration & immutable audit logs
Operational Automation

Dual-Tier Attendance Telemetry & Daily Roster

Comprehensive attendance tracking for both student bodies and teaching faculties. Features one-click bulk status marking (Present, Absent, Late, Excused), shift-specific rosters, and automated monthly attendance percentage calculations feeding into student report cards.

Student classroom attendance with instant Present/Absent/Late/Excused status toggles
Daily faculty attendance with shift filtering (Morning/Evening/Night) and HR penalty overrides
Monthly attendance percentage aggregation feeding into student result cards
Shift-based filters and automated alert dispatch for unexcused student absences
User Experience & Engagement

Guardian Telemetry & Student Self-Service Portals

Dedicated portals for students and guardians. Guardians monitor linked child profiles, attendance percentages, exam schedules, and fee status. Students access active courses, submit elective choices, download roll number slips, and file leave requests.

Guardian portal linking multiple children with single login oversight
Real-time attendance telemetry (e.g. 83% attendance badge) and prayer-time integrated timetables
Student elective subject selection desk with administrative approval workflows
Digital roll number slips and examination date sheet downloads
Institutional Governance

Grievance Resolution Registry & Staff Leave Desk

Centralized institutional governance portal for filing formal concerns and evaluating staff leave requests. Provides administrative evaluation desks, instant applicant notification dispatch, and immutable audit logs.

Staff leave review desk with approval/rejection decision triggers and instant notification dispatch
Role-scoped grievance submission for parents, students, teachers, and administrative staff
Structured resolution state machine with public and confidential audit logs
Real-time metrics: total requests, pending evaluations, approved count, and rejections
Vector Document Engine

Document Printing Vault: QR ID Cards & Certificates

Automated vector document generation engine compiling high-resolution student and teacher ID cards with dynamic scannable QR verification codes, official Bonafide Student Certificates, Character Certificates, and terminal Report Cards.

Student and teacher ID card generation with dynamic scannable QR verification codes
Official institutional Bonafide Student Certificates and Character Certificates
Pixel-perfect vector layout rendering with jsPDF and html2canvas
Batch printing pipelines for commencement and enrollment seasons
Enrollment Marketing & CRM

Public Admissions Pipeline & Lead Management

Public multi-step online student admission application workflow with program and shift selection. Implements CNIC / B-Form duplicate protection, document upload support via Cloudinary, and an administrative admission queue for screening and registration issuance.

Multi-step online admission form for prospective students across campuses
CNIC / B-Form duplicate detection preventing redundant registrations
Administrative lead intake queue with test score entry and fee package assignment
Automated registration number generation upon formal admission approval
Technical Hardening

Key Engineering Bottlenecks & Solutions

Challenge 01

Hardware Biometric Fingerprint Synchronization & Shift Auto-Matching

Physical biometric machines generate raw timestamp punches without semantic awareness of student sections or staff shifts. Engineered a high-throughput parser and reconciliation pipeline that maps punch timestamps against scheduled class and coaching windows (Morning, Evening, Night), accounting for grace periods, unexcused absences, and half-day thresholds.

Engineered & Hardened
Challenge 02

Multi-Campus Data Segregation Without Complex Multi-Database Overhead

Rather than spinning up disconnected databases per campus, engineered a unified Prisma relational schema enforcing campus-scoped compound foreign keys and middleware-level tenancy checks. This guarantees total data isolation while enabling Super Admins to view aggregated cross-campus financial and academic metrics.

Engineered & Hardened
Challenge 03

Financial Consistency & High-Volume Fee Challan Generation

Generating monthly invoices across hundreds of students with differing fee packages, discounts, and previous balances risks data race conditions. Built an idempotent batch generation engine that operates inside sequential database transactions, generating unique Challan IDs (e.g. CHL/MBE_261018/2627/JUN) and preventing duplicate billing.

Engineered & Hardened
Challenge 04

Pixel-Perfect Branded 3-Copy Bank Challans & Result Cards

Designed bespoke vector templates using jsPDF and html2canvas with exact print dimensions (A4 split into Student Copy, Bank Copy, and Academy Copy). Optimized rendering pipelines to eliminate font rasterization blur and ensure barcode/QR code scan reliability.

Engineered & Hardened
Next Case Study

Autonomous Neural Copilot (JON OS)

Voice-activated autonomous AI copilot with Groq LLaMA 3.3 70B & Whisper Large v3.

View Next System