How joshrandomcodes/psa-digital-tracking-system works
This is a PSA birth-certificate request, validation, and tracking application. Citizens register or sign in, submit a request, and track its status; requests are checked through the PhilSys and PhilCRIS integration boundaries, then handled by LCRO validation and PSA staff review. The React app calls an Express API, whose controllers read and update the MySQL-backed records. The README documents a cloud-hosted Aiven database. PhilSys verification is explicitly a stub, and the excerpts do not establish a live external registry connection.
Main entry points: App.jsx Role-based App · api.js API Client · db.js MySQL Pool · server.js Express Routes
Components 20
Citizen and Staff UI
- Role-based App
client/src/App.jsx - Authentication UI
client/src/components/AuthGateway.jsx - Request Form
client/src/components/CitizenRequestForm.jsx - Live Tracker
client/src/components/LiveTracker.jsx - LCRO Queue UI
client/src/components/LcroValidationPanel.jsx - Staff Review UI
client/src/components/StaffReviewBoard.jsx - API Client
client/src/services/api.js
API and Workflow
- Express Routes
server/src/server.js - Authentication
server/src/controllers/authController.js - Request Processing
server/src/controllers/requestController.js - LCRO Validation
server/src/controllers/lcroController.js - Final Decision
server/src/controllers/psaStaffController.js
Identity and Registry
- PhilSys Gateway
server/src/integrations/philsysGateway.js - PhilCRIS Adapter
server/src/integrations/philcrisAdapter.js
Persistence
- MySQL Pool
server/src/config/db.js - Core Entities
database/schema.sql
Other components
- Citizen
- PSA staff
- Aiven MySQL
- PSA Registries
Connections 27
- Citizen → Role-based App: uses
client/src/App.jsx - PSA staff → Role-based App: uses
client/src/App.jsx - Role-based App → Authentication UI: renders
client/src/App.jsx - Role-based App → Request Form: renders
client/src/App.jsx - Role-based App → Live Tracker: renders
client/src/App.jsx - Role-based App → LCRO Queue UI: renders
client/src/App.jsx - Role-based App → Staff Review UI: renders
client/src/App.jsx - Authentication UI → API Client: auth calls
client/src/components/AuthGateway.jsx - Request Form → API Client: submits
client/src/components/CitizenRequestForm.jsx - LCRO Queue UI → API Client: validates
client/src/components/LcroValidationPanel.jsx - Staff Review UI → API Client: sends decision
client/src/components/StaffReviewBoard.jsx - Role-based App → API Client: loads queues
client/src/App.jsx - API Client → Express Routes: HTTP requests
client/src/services/api.js - Express Routes → Authentication: routes auth
server/src/server.js - Express Routes → Request Processing: routes requests
server/src/server.js - Express Routes → LCRO Validation: routes validation
server/src/server.js - Express Routes → Final Decision: routes decisions
server/src/server.js - Request Processing → PhilSys Gateway: verifies identity
server/src/controllers/requestController.js - Request Processing → PhilCRIS Adapter: checks registry
server/src/controllers/requestController.js - Authentication → MySQL Pool: queries
server/src/controllers/authController.js - Request Processing → MySQL Pool: reads and writes
server/src/controllers/requestController.js - LCRO Validation → MySQL Pool: reads and writes
server/src/controllers/lcroController.js - Final Decision → MySQL Pool: updates records
server/src/controllers/psaStaffController.js - MySQL Pool → Aiven MySQL: connects
README.md - Core Entities → MySQL Pool: defines entities
README.md - PhilSys Gateway → PSA Registries: potential integration
- PhilCRIS Adapter → PSA Registries: potential integration