How bansagjohndave915-cloud/grading-portal-system works
GradeSystem is a school grade-management web application with administrator, teacher, and student interfaces backed by an Express API and MySQL. Its central workflow lets teachers preview and submit Excel grade sheets, administrators review or lock uploads, and students access grades; the API also supports student imports, school-year and class administration, and reporting. The graph preserves these distinct capabilities and the database layer. The README is empty, and the available frontend excerpts do not establish the UI-to-API calls, so those links are omitted; unsampled routes are represented only where the source index identifies their wiring.
Main entry points: server.js HTTP server · db.js MySQL database · studentRoutes.js Student routes · gradeRoutes.js Grade routes
Components 25
User interfaces
- Admin interface
GradeSystem/CLIENT/JS/admin.js - Teacher interface
GradeSystem/CLIENT/JS/teacher.js - Student interface
GradeSystem/CLIENT/JS/student.js - Login interface
GradeSystem/CLIENT/JS/login.js - API client
GradeSystem/CLIENT/JS/api.js
API routing
- HTTP server
GradeSystem/CLIENT/backend/server.js - Auth routes
GradeSystem/CLIENT/backend/routes/authRoutes.js - Student routes
GradeSystem/CLIENT/backend/routes/studentRoutes.js - Teacher routes
GradeSystem/CLIENT/backend/routes/teacherRoutes.js - Subject routes
GradeSystem/CLIENT/backend/routes/subjectRoutes.js - School-year routes
GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js - Section routes
GradeSystem/CLIENT/backend/routes/sectionRoutes.js - Grade routes
GradeSystem/CLIENT/backend/routes/gradeRoutes.js - Report routes
GradeSystem/CLIENT/backend/routes/reportRoutes.js - Authentication
GradeSystem/CLIENT/backend/controllers/authController.js - Role checks
GradeSystem/CLIENT/backend/middleware/authMiddleware.js
School records
- Student records
GradeSystem/CLIENT/backend/controllers/studentController.js - Student import
GradeSystem/CLIENT/backend/controllers/studentImportController.js - Teacher assignments
GradeSystem/CLIENT/backend/controllers/teacherController.js - Subject records
GradeSystem/CLIENT/backend/controllers/subjectController.js - School-year setup
GradeSystem/CLIENT/backend/controllers/schoolYearController.js - Section records
GradeSystem/CLIENT/backend/controllers/sectionController.js
Grade workflow
- Grade uploads
GradeSystem/CLIENT/backend/controllers/gradeController.js - Reports
GradeSystem/CLIENT/backend/controllers/reportController.js
Data access
- MySQL database
GradeSystem/CLIENT/backend/config/db.js
Connections 29
- HTTP server → Auth routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Student routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Teacher routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Subject routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → School-year routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Section routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Grade routes: mounts
GradeSystem/CLIENT/backend/server.js - HTTP server → Report routes: mounts
GradeSystem/CLIENT/backend/server.js - Auth routes → Authentication: routes to
GradeSystem/CLIENT/backend/routes/authRoutes.js - Student routes → Student records: routes to
GradeSystem/CLIENT/backend/routes/studentRoutes.js - Student routes → Student import: routes to
GradeSystem/CLIENT/backend/routes/studentRoutes.js - Teacher routes → Teacher assignments: routes to
GradeSystem/CLIENT/backend/routes/teacherRoutes.js - Subject routes → Subject records: routes to
GradeSystem/CLIENT/backend/routes/subjectRoutes.js - School-year routes → School-year setup: routes to
GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js - Section routes → Section records: routes to
GradeSystem/CLIENT/backend/routes/sectionRoutes.js - Grade routes → Grade uploads: routes to
GradeSystem/CLIENT/backend/routes/gradeRoutes.js - Report routes → Reports: routes to
GradeSystem/CLIENT/backend/routes/reportRoutes.js - Student routes → Role checks: checks access
GradeSystem/CLIENT/backend/routes/studentRoutes.js - Grade routes → Role checks: checks access
GradeSystem/CLIENT/backend/routes/gradeRoutes.js - Report routes → Role checks: checks access
GradeSystem/CLIENT/backend/routes/reportRoutes.js - Authentication → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/authController.js - Student records → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/studentController.js - Student import → MySQL database: imports records
GradeSystem/CLIENT/backend/controllers/studentImportController.js - Teacher assignments → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/teacherController.js - Subject records → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/subjectController.js - School-year setup → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/schoolYearController.js - Section records → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/sectionController.js - Grade uploads → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/gradeController.js - Reports → MySQL database: queries
GradeSystem/CLIENT/backend/controllers/reportController.js