ERP Web Application – University Management System
Decoupled Monorepo ERP with Dynamic Routing & S3 Storage
Project Overview
This University ERP System is a comprehensive, production-grade full-stack web application actively being built to centralize and streamline the administrative operations of Gyanmanjari Innovative University. Built with a decoupled React frontend and Node.js REST API backend.
Overview
This University ERP (Enterprise Resource Planning) System is a comprehensive, production-grade full-stack web application actively being built to centralize and streamline the administrative operations of an educational institution. The system is architected as a decoupled monorepo — a dedicated React.js frontend served via Vite, and a standalone Node.js/Express.js REST API backend — communicating over HTTP with JWT-secured endpoints.
Frontend Architecture
The frontend is built with React.js 18 using Vite as the build tool for fast HMR and optimized production bundling. The UI leverages the Datta Able React Admin Template as its base shell, customized extensively with React Bootstrap (v5) components and SCSS for styling. All pages are lazy-loaded using React.lazy() and Suspense, ensuring the bundle is code-split per route and initial load times remain optimal even as the module count grows.
Database-Driven Routing & Config
A standout architectural decision is the fully database-driven sidebar and routing system. Rather than hard-coding navigation links or page routes in the frontend, both the sidebar menu structure and the React Router route definitions are fetched dynamically from the backend API at runtime. This means adding a new module to the ERP requires only a database record — no frontend redeployment. The system is also environment-aware, switching between LOCAL (show all routes, no role filtering) and PRODUCTION (role-filtered routes and menus) modes via a VITE_ENVIRONMENT flag. An AuthGuard HOC protects all admin routes, redirecting unauthenticated users to the login page.
Academic & Human Resource Modules
The application is organized into three primary business domains: Academic Settings (Full CRUD management for Faculties, Levels, Programs, Batches, Sessions, Semesters, Sections, Classrooms, Courses, and enrollments, with relational linking tables); Human Resources (Staff lifecycle, designations, departments, shifts); and the ERP Settings Panel (role assignment, frontend routes, and backend API linkages).
Form Validation, Charting & Data Export
State management is handled via React Context API, with form handling powered by Formik and Yup for schema-based validation. The dashboard integrates D3.js and React Google Charts for data visualizations, and Google Maps (@react-google-maps/api) for map-based features. Data export is supported via jsPDF + jspdf-autotable for PDF generation, PapaParse for CSV parsing, and SheetJS (XLSX) for Excel exports.
Robust Node.js Backend
The backend is a Node.js + Express.js REST API server following a clean, domain-separated structure — routes, controllers, models, validators, and Knex query builders are all organized per business module. Knex.js serves as the SQL query builder with a full migration pipeline (36 migrations) for version-controlled, reproducible MySQL schema evolution. Authentication is handled via JWT with bcrypt for password hashing. File and document uploads are managed by Multer and stored either locally (dev) or via AWS S3 using the official @aws-sdk/client-s3 SDK. A MinIO S3-compatible object storage server is provisioned locally via Docker Compose for development parity.
Screenshots & Gallery
