# carftsman/dashboard_analyst_web architecture

> Architecture diagram of the GitHub repository carftsman/dashboard_analyst_web, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/carftsman/dashboard_analyst_web
- Repository: https://github.com/carftsman/dashboard_analyst_web

## Overview

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: [`prisma/prismaClient.js`](https://github.com/carftsman/dashboard_analyst_web/blob/main/prisma/prismaClient.js) (Application database), [`app.js`](https://github.com/carftsman/dashboard_analyst_web/blob/main/app.js) (Express app), [`controllers/uploadController.js`](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/uploadController.js) (Upload and analysis), [`controllers/reportController.js`](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/reportController.js) (Report management)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_api["API and access"]
  node_app["Express app<br/>[app.js]"]
  node_auth_routes["Auth routes<br/>[authRoutes.js]"]
  node_upload_routes["Upload routes<br/>[uploadRoutes.js]"]
  node_dashboard_routes["Dashboard routes<br/>[dashboardRoutes.js]"]
  node_report_routes["Report routes<br/>[reportRoutes.js]"]
  node_data_routes["Data routes"]
  node_other_routes["Other API routes"]
end

subgraph group_analytics["Dashboard and data"]
  node_upload_controller["Upload and analysis"]
  node_mapping["Column mapping<br/>[mappingService.js]"]
  node_chart_engine["Chart calculations<br/>[chartEngine.js]"]
  node_normalize["Key normalization<br/>[normalizeKey.js]"]
  node_safe_eval["Safe expressions<br/>[safeEval.js]"]
  node_dashboard_controller["Dashboard management"]
  node_widget_controller["Widget management"]
  node_chart_controller["Chart endpoints<br/>[chartController.js]"]
  node_report_controller["Report management"]
  node_search_controller["Search"]
end

subgraph group_management["Identity and administration"]
  node_auth_middleware["Auth and roles<br/>[authMiddleware.js]"]
  node_auth_controller["Authentication<br/>[authController.js]"]
  node_user_controller["User administration<br/>[userController.js]"]
  node_activity["Activity logging<br/>[activityLogger.js]"]
  node_log_controller["Log queries<br/>[logController.js]"]
end

subgraph group_storage["Persistence and integrations"]
  node_database[("Application database<br/>[prismaClient.js]")]
  node_azure[("Azure Blob Storage")]
  node_logger["Application logger<br/>[logger.js]"]
end

node_client(("API client"))
node_excel["Excel upload"]

node_client -->|"sends requests"| node_app
node_app -->|"mounts public"| node_auth_routes
node_app -->|"verifies requests"| node_auth_middleware
node_app -->|"logs activity"| node_activity
node_app -->|"mounts routes"| node_upload_routes
node_app -->|"mounts routes"| node_dashboard_routes
node_app -->|"mounts routes"| node_report_routes
node_app -->|"mounts routes"| node_data_routes
node_app -->|"mounts routes"| node_other_routes
node_auth_routes -->|"dispatches to"| node_auth_controller
node_auth_routes -->|"guards endpoints"| node_auth_middleware
node_auth_controller -->|"reads and writes"| node_database
node_upload_routes -->|"dispatches to"| node_upload_controller
node_upload_routes -->|"guards endpoints"| node_auth_middleware
node_excel -->|"provides workbook"| node_upload_routes
node_upload_controller -->|"stores and reads data"| node_database
node_upload_controller -->|"uses mapping"| node_mapping
node_upload_controller -->|"requests analysis"| node_chart_engine
node_chart_engine -->|"normalizes keys"| node_normalize
node_chart_engine -->|"uses expressions"| node_safe_eval
node_mapping -->|"uses expressions"| node_safe_eval
node_dashboard_routes -->|"dispatches to"| node_dashboard_controller
node_dashboard_routes -->|"guards endpoints"| node_auth_middleware
node_dashboard_controller -->|"manages dashboards"| node_database
node_widget_controller -->|"manages widgets"| node_database
node_chart_controller -->|"reads chart data"| node_database
node_report_routes -->|"dispatches to"| node_report_controller
node_report_controller -->|"stores report metadata"| node_database
node_report_controller -->|"uploads report HTML"| node_azure
node_report_controller -->|"calls blob service"| node_azure
node_data_routes -->|"dispatches data calls"| node_upload_controller
node_data_routes -->|"dispatches reports"| node_report_controller
node_search_controller -->|"searches records"| node_database
node_user_controller -->|"manages users"| node_database
node_log_controller -->|"reads activity records"| node_database
node_activity -->|"records activity"| node_database
node_activity -->|"writes logs"| node_logger
node_auth_middleware -->|"checks user status"| node_database

click node_app "https://github.com/carftsman/dashboard_analyst_web/blob/main/app.js"
click node_auth_routes "https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/authRoutes.js"
click node_upload_routes "https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/uploadRoutes.js"
click node_dashboard_routes "https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/dashboardRoutes.js"
click node_report_routes "https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/reportRoutes.js"
click node_data_routes "https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/dashboardDataRoutes.js"
click node_other_routes "https://github.com/carftsman/dashboard_analyst_web/tree/main/routes"
click node_auth_middleware "https://github.com/carftsman/dashboard_analyst_web/blob/main/middleware/authMiddleware.js"
click node_auth_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/authController.js"
click node_user_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/userController.js"
click node_activity "https://github.com/carftsman/dashboard_analyst_web/blob/main/middleware/activityLogger.js"
click node_upload_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/uploadController.js"
click node_mapping "https://github.com/carftsman/dashboard_analyst_web/blob/main/services/mappingService.js"
click node_chart_engine "https://github.com/carftsman/dashboard_analyst_web/blob/main/services/chartEngine.js"
click node_normalize "https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/normalizeKey.js"
click node_safe_eval "https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/safeEval.js"
click node_dashboard_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/dashboardController.js"
click node_widget_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/widgetController.js"
click node_chart_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/chartController.js"
click node_report_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/reportController.js"
click node_search_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/searchController.js"
click node_log_controller "https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/logController.js"
click node_database "https://github.com/carftsman/dashboard_analyst_web/blob/main/prisma/prismaClient.js"
click node_logger "https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/logger.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_app,node_auth_routes,node_upload_routes,node_dashboard_routes,node_report_routes,node_data_routes,node_other_routes,node_client toneBlue
class node_upload_controller,node_mapping,node_chart_engine,node_normalize,node_safe_eval,node_dashboard_controller,node_widget_controller,node_chart_controller,node_report_controller,node_search_controller toneAmber
class node_auth_middleware,node_auth_controller,node_user_controller,node_activity,node_log_controller toneMint
class node_database,node_azure,node_logger toneRose
class node_excel toneIndigo
```

## Components

### API and access

- [Express app](https://github.com/carftsman/dashboard_analyst_web/blob/main/app.js): `app.js`
- [Auth routes](https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/authRoutes.js): `routes/authRoutes.js`
- [Upload routes](https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/uploadRoutes.js): `routes/uploadRoutes.js`
- [Dashboard routes](https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/dashboardRoutes.js): `routes/dashboardRoutes.js`
- [Report routes](https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/reportRoutes.js): `routes/reportRoutes.js`
- [Data routes](https://github.com/carftsman/dashboard_analyst_web/blob/main/routes/dashboardDataRoutes.js): `routes/dashboardDataRoutes.js`
- [Other API routes](https://github.com/carftsman/dashboard_analyst_web/tree/main/routes): `routes`

### Dashboard and data

- [Upload and analysis](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/uploadController.js): `controllers/uploadController.js`
- [Column mapping](https://github.com/carftsman/dashboard_analyst_web/blob/main/services/mappingService.js): `services/mappingService.js`
- [Chart calculations](https://github.com/carftsman/dashboard_analyst_web/blob/main/services/chartEngine.js): `services/chartEngine.js`
- [Key normalization](https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/normalizeKey.js): `utils/normalizeKey.js`
- [Safe expressions](https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/safeEval.js): `utils/safeEval.js`
- [Dashboard management](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/dashboardController.js): `controllers/dashboardController.js`
- [Widget management](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/widgetController.js): `controllers/widgetController.js`
- [Chart endpoints](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/chartController.js): `controllers/chartController.js`
- [Report management](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/reportController.js): `controllers/reportController.js`
- [Search](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/searchController.js): `controllers/searchController.js`

### Identity and administration

- [Auth and roles](https://github.com/carftsman/dashboard_analyst_web/blob/main/middleware/authMiddleware.js): `middleware/authMiddleware.js`
- [Authentication](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/authController.js): `controllers/authController.js`
- [User administration](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/userController.js): `controllers/userController.js`
- [Activity logging](https://github.com/carftsman/dashboard_analyst_web/blob/main/middleware/activityLogger.js): `middleware/activityLogger.js`
- [Log queries](https://github.com/carftsman/dashboard_analyst_web/blob/main/controllers/logController.js): `controllers/logController.js`

### Persistence and integrations

- [Application database](https://github.com/carftsman/dashboard_analyst_web/blob/main/prisma/prismaClient.js): `prisma/prismaClient.js`
- **Azure Blob Storage**
- [Application logger](https://github.com/carftsman/dashboard_analyst_web/blob/main/utils/logger.js): `utils/logger.js`

### Other components

- **API client**
- **Excel upload**

## Connections

- API client → Express app: sends requests (evidence: `app.js`)
- Express app → Auth routes: mounts public (evidence: `app.js`)
- Express app → Auth and roles: verifies requests (evidence: `app.js`)
- Express app → Activity logging: logs activity (evidence: `app.js`)
- Express app → Upload routes: mounts routes (evidence: `app.js`)
- Express app → Dashboard routes: mounts routes (evidence: `app.js`)
- Express app → Report routes: mounts routes (evidence: `app.js`)
- Express app → Data routes: mounts routes (evidence: `app.js`)
- Express app → Other API routes: mounts routes (evidence: `app.js`)
- Auth routes → Authentication: dispatches to (evidence: `routes/authRoutes.js`)
- Auth routes → Auth and roles: guards endpoints (evidence: `routes/authRoutes.js`)
- Authentication → Application database: reads and writes (evidence: `controllers/authController.js`)
- Upload routes → Upload and analysis: dispatches to (evidence: `routes/uploadRoutes.js`)
- Upload routes → Auth and roles: guards endpoints (evidence: `routes/uploadRoutes.js`)
- Excel upload → Upload routes: provides workbook (evidence: `routes/uploadRoutes.js`)
- Upload and analysis → Application database: stores and reads data (evidence: `controllers/uploadController.js`)
- Upload and analysis → Column mapping: uses mapping (evidence: `controllers/uploadController.js`)
- Upload and analysis → Chart calculations: requests analysis (evidence: `controllers/uploadController.js`)
- Chart calculations → Key normalization: normalizes keys (evidence: `services/chartEngine.js`)
- Chart calculations → Safe expressions: uses expressions (evidence: `services/chartEngine.js`)
- Column mapping → Safe expressions: uses expressions (evidence: `services/mappingService.js`)
- Dashboard routes → Dashboard management: dispatches to (evidence: `routes/dashboardRoutes.js`)
- Dashboard routes → Auth and roles: guards endpoints (evidence: `routes/dashboardRoutes.js`)
- Dashboard management → Application database: manages dashboards (evidence: `controllers/dashboardController.js`)
- Widget management → Application database: manages widgets (evidence: `controllers/widgetController.js`)
- Chart endpoints → Application database: reads chart data
- Report routes → Report management: dispatches to (evidence: `routes/reportRoutes.js`)
- Report management → Application database: stores report metadata (evidence: `controllers/reportController.js`)
- Report management → Azure Blob Storage: uploads report HTML (evidence: `controllers/reportController.js`)
- Report management → Azure Blob Storage: calls blob service (evidence: `controllers/reportController.js`)
- Data routes → Upload and analysis: dispatches data calls (evidence: `routes/dashboardDataRoutes.js`)
- Data routes → Report management: dispatches reports (evidence: `routes/dashboardDataRoutes.js`)
- Search → Application database: searches records
- User administration → Application database: manages users (evidence: `controllers/userController.js`)
- Log queries → Application database: reads activity records (evidence: `controllers/logController.js`)
- Activity logging → Application database: records activity (evidence: `middleware/activityLogger.js`)
- Activity logging → Application logger: writes logs (evidence: `middleware/activityLogger.js`)
- Auth and roles → Application database: checks user status (evidence: `middleware/authMiddleware.js`)
