How anish1302d/sp-college-approval-hub works
S.P. College Approval and Workflow Management System supports faculty procurement requests through committee completeness review, Principal review, and amount-based financial approval; it also manages faculty issues and college operational data. The React interface calls an Express API backed by PostgreSQL, with supporting file storage, notifications, and reporting. The README documents approval rules and retained request history. Several subsystem links below are based on the README or SOURCE INDEX references; unsampled implementations are not inferred beyond those links.
Main entry points: db.js Database access and RLS · app.js API route registration · App.jsx Portal and page routing · requests.js Request workflow API
Components 24
React interface
- Portal and page routing
src/App.jsx - Request screens
src/components/modals/NewRequestModal.jsx - Review queue
src/pages/ReviewQueue.jsx - API client
src/api/client.js - Session and app state
src/context/AppContext.jsx - Data and action hooks
src/hooks/useApi.js
Approval workflow
- Request workflow API
server/src/routes/requests.js
College operations
- Operational APIs
server/src/routes - Faculty issue management
server/src/routes/issues.js - Inventory management
server/src/routes/inventory.js - Budget provisions
server/src/routes/budget.js - Master data management
server/src/routes/master.js - User administration
server/src/routes/admin.js
API platform
- Authentication API
server/src/routes/auth.js - API route registration
server/src/app.js - Token and role checks
server/src/auth.js - Database access and RLS
server/src/db.js - PostgreSQL
Supporting services
- Reports API
server/src/routes/reports.js - Attachment storage
server/src/storage.js - Email notifications
server/src/mailer.js - Report generation
server/src/reporting.js - PDF report rendering
server/src/pdfReport.js
Other components
- Faculty and approvers
Connections 29
- Faculty and approvers → Portal and page routing: uses portal
- Portal and page routing → Session and app state: uses state
src/App.jsx - Portal and page routing → Request screens: routes requests
- Portal and page routing → Review queue: routes reviews
src/App.jsx - Request screens → API client: submits requests
src/components/modals/NewRequestModal.jsx - Review queue → Data and action hooks: loads queue
src/pages/ReviewQueue.jsx - Data and action hooks → API client: calls API
src/hooks/useApi.js - Session and app state → API client: restores session
src/context/AppContext.jsx - API client → API route registration: sends API requests
- API route registration → Authentication API: registers routes
server/src/app.js - API route registration → Request workflow API: registers routes
server/src/app.js - API route registration → Reports API: registers routes
server/src/app.js - API route registration → Operational APIs: registers routes
server/src/app.js - Authentication API → Token and role checks: issues tokens
server/src/routes/auth.js - Authentication API → Database access and RLS: queries accounts
server/src/routes/auth.js - Request workflow API → Database access and RLS: reads and writes workflow
server/src/routes/requests.js - Request workflow API → Email notifications: sends notifications
server/src/routes/requests.js - Request workflow API → Attachment storage: handles attachments
server/src/routes/requests.js - Operational APIs → Database access and RLS: uses database
server/src/routes/auth.js - Reports API → Database access and RLS: queries report data
server/src/routes/reports.js - Reports API → Report generation: builds reports
server/src/routes/reports.js - Reports API → PDF report rendering: renders PDFs
server/src/routes/reports.js - Faculty issue management → Database access and RLS: uses database
- Inventory management → Database access and RLS: uses database
- Budget provisions → Database access and RLS: queries budget
server/src/routes/budget.js - Master data management → Database access and RLS: uses database
- User administration → Database access and RLS: queries accounts
server/src/routes/admin.js - Database access and RLS → PostgreSQL: queries
server/src/db.js - Attachment storage → PostgreSQL: stores attachment metadata