How carftsman/dashboard_analyst_web works
This is an Express API for a role-based analytics dashboard. Analysts upload Excel data, map it to dashboard columns, process and analyze it, then use the resulting data in dashboard widgets and exports; users can also save and retrieve reports. The graph groups the API entry points, dashboard and data workflows, identity and administration, and persistence/integrations. Source excerpts show the main upload, dashboard, authentication, and report paths; other listed capabilities are included where the source index or route definitions support them, without assuming unshown call details.
Main entry points: prismaClient.js Application database · app.js Express app · uploadController.js Upload and analysis · reportController.js Report management
Components 27
API and access
- Express app
app.js - Auth routes
routes/authRoutes.js - Upload routes
routes/uploadRoutes.js - Dashboard routes
routes/dashboardRoutes.js - Report routes
routes/reportRoutes.js - Data routes
routes/dashboardDataRoutes.js - Other API routes
routes
Dashboard and data
- Upload and analysis
controllers/uploadController.js - Column mapping
services/mappingService.js - Chart calculations
services/chartEngine.js - Key normalization
utils/normalizeKey.js - Safe expressions
utils/safeEval.js - Dashboard management
controllers/dashboardController.js - Widget management
controllers/widgetController.js - Chart endpoints
controllers/chartController.js - Report management
controllers/reportController.js - Search
controllers/searchController.js
Identity and administration
- Auth and roles
middleware/authMiddleware.js - Authentication
controllers/authController.js - User administration
controllers/userController.js - Activity logging
middleware/activityLogger.js - Log queries
controllers/logController.js
Persistence and integrations
- Application database
prisma/prismaClient.js - Azure Blob Storage
- Application logger
utils/logger.js
Other components
- API client
- Excel upload
Connections 38
- API client → Express app: sends requests
app.js - Express app → Auth routes: mounts public
app.js - Express app → Auth and roles: verifies requests
app.js - Express app → Activity logging: logs activity
app.js - Express app → Upload routes: mounts routes
app.js - Express app → Dashboard routes: mounts routes
app.js - Express app → Report routes: mounts routes
app.js - Express app → Data routes: mounts routes
app.js - Express app → Other API routes: mounts routes
app.js - Auth routes → Authentication: dispatches to
routes/authRoutes.js - Auth routes → Auth and roles: guards endpoints
routes/authRoutes.js - Authentication → Application database: reads and writes
controllers/authController.js - Upload routes → Upload and analysis: dispatches to
routes/uploadRoutes.js - Upload routes → Auth and roles: guards endpoints
routes/uploadRoutes.js - Excel upload → Upload routes: provides workbook
routes/uploadRoutes.js - Upload and analysis → Application database: stores and reads data
controllers/uploadController.js - Upload and analysis → Column mapping: uses mapping
controllers/uploadController.js - Upload and analysis → Chart calculations: requests analysis
controllers/uploadController.js - Chart calculations → Key normalization: normalizes keys
services/chartEngine.js - Chart calculations → Safe expressions: uses expressions
services/chartEngine.js - Column mapping → Safe expressions: uses expressions
services/mappingService.js - Dashboard routes → Dashboard management: dispatches to
routes/dashboardRoutes.js - Dashboard routes → Auth and roles: guards endpoints
routes/dashboardRoutes.js - Dashboard management → Application database: manages dashboards
controllers/dashboardController.js - Widget management → Application database: manages widgets
controllers/widgetController.js - Chart endpoints → Application database: reads chart data
- Report routes → Report management: dispatches to
routes/reportRoutes.js - Report management → Application database: stores report metadata
controllers/reportController.js - Report management → Azure Blob Storage: uploads report HTML
controllers/reportController.js - Report management → Azure Blob Storage: calls blob service
controllers/reportController.js - Data routes → Upload and analysis: dispatches data calls
routes/dashboardDataRoutes.js - Data routes → Report management: dispatches reports
routes/dashboardDataRoutes.js - Search → Application database: searches records
- User administration → Application database: manages users
controllers/userController.js - Log queries → Application database: reads activity records
controllers/logController.js - Activity logging → Application database: records activity
middleware/activityLogger.js - Activity logging → Application logger: writes logs
middleware/activityLogger.js - Auth and roles → Application database: checks user status
middleware/authMiddleware.js