# davidalexandru23/aplicatie_sm architecture

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

- Interactive diagram: https://gitdiagram.com/davidalexandru23/aplicatie_sm
- Repository: https://github.com/davidalexandru23/aplicatie_sm

## Overview

This is an internal SSM/HR and hygiene-course management application. Its principal workflow is maintaining client and employee records, importing Excel registers with preview and CNP-based reconciliation, then generating and downloading official DOCX/PDF/XLSX documents. Other documented capabilities include risk assessments, training, hygiene sessions, EIP assignments, compliance checks, role-based access, and audit logging. The README documents product capabilities; sampled routes and library references establish several internal calls. Some UI-to-route and unsampled subsystem wiring is not shown, so those links are omitted.

Main entry points: [`src/lib/prisma.ts`](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/prisma.ts) (PostgreSQL data), [`src/app/page.tsx`](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/page.tsx) (Web workspace), [`src/app/api/documents/generate/route.ts`](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/documents/generate/route.ts) (Document generation routes), [`src/app/api/employees/route.ts`](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/employees/route.ts) (Employee registry)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workspace["Workspace and access"]
  node_webui["Web workspace<br/>[page.tsx]"]
  node_authroutes["Authentication routes<br/>[route.ts]"]
  node_auth["Session authentication<br/>[auth.ts]"]
  node_authconstants["Session constants<br/>[auth-constants.ts]"]
  node_rbac["Role permissions<br/>[rbac.ts]"]
end

subgraph group_records["Client and workforce records"]
  node_clients["Client registry<br/>[route.ts]"]
  node_employees["Employee registry<br/>[route.ts]"]
  node_caen["CAEN catalog<br/>[caen-catalog.ts]"]
  node_caenselector["CAEN selector<br/>[caen-selector.tsx]"]
end

subgraph group_safety["Safety and training"]
  node_risk["Risk assessments<br/>[route.ts]"]
  node_riskpresets["CAEN risk presets"]
  node_compliance["Employee compliance<br/>[compliance.ts]"]
  node_training["Training records<br/>[route.ts]"]
  node_hygiene["Hygiene sessions<br/>[route.ts]"]
  node_hygienenumbering["Certificate numbering"]
  node_eip["EIP assignments<br/>[route.ts]"]
end

subgraph group_documents["Import and documents"]
  node_imports["Import preview and commit<br/>[route.ts]"]
  node_importer["Excel reconciliation<br/>[importer.ts]"]
  node_exporter["Data export<br/>[exporter.ts]"]
  node_generation["Document generation routes<br/>[route.ts]"]
  node_batchgeneration["Batch generation route<br/>[route.ts]"]
  node_definitions["Template definitions<br/>[definitions.ts]"]
  node_resolver["Placeholder resolver<br/>[resolver.ts]"]
  node_generator["Format generators<br/>[generator.ts]"]
  node_hygieneexcel["Hygiene Excel output<br/>[hygiene-excel.ts]"]
end

subgraph group_platform["Persistence and safeguards"]
  node_privacy["Privacy and audit<br/>[security.ts]"]
  node_database[("PostgreSQL data<br/>[prisma.ts]")]
end

node_operator(("Staff user"))

node_operator -->|"uses"| node_webui
node_webui -->|"starts import"| node_imports
node_imports -->|"reconciles"| node_importer
node_importer -->|"reads birth dates"| node_exporter
node_operator -->|"manages records"| node_webui
node_employees -->|"validates CNP"| node_importer
node_employees -->|"calculates status"| node_compliance
node_employees -->|"sanitizes response"| node_rbac
node_caenselector -->|"searches catalog"| node_caen
node_operator -->|"requests documents"| node_webui
node_webui -->|"requests generation"| node_generation
node_generation -->|"resolves fields"| node_resolver
node_generation -->|"generates file"| node_generator
node_batchgeneration -->|"resolves fields"| node_resolver
node_batchgeneration -->|"generates files"| node_generator
node_batchgeneration -->|"checks expiry"| node_compliance
node_resolver -->|"loads risk profile"| node_riskpresets
node_operator -->|"manages risk"| node_webui
node_risk -->|"uses CAEN profiles"| node_riskpresets
node_operator -->|"manages training"| node_webui
node_hygiene -->|"assigns numbers"| node_hygienenumbering
node_operator -->|"manages hygiene"| node_webui
node_employees -->|"reads and writes"| node_database
node_clients -->|"reads and writes"| node_database
node_imports -->|"commits records"| node_database
node_risk -->|"persists assessments"| node_database
node_training -->|"records training"| node_database
node_hygiene -->|"stores sessions"| node_database
node_eip -->|"stores assignments"| node_database
node_hygienenumbering -->|"allocates numbers"| node_database
node_generation -->|"checks templates"| node_definitions
node_generator -->|"generates workbook"| node_hygieneexcel
node_generation -.->|"stores generated records"| node_database
node_privacy -->|"writes audit events"| node_database
node_auth -->|"uses cookie settings"| node_authconstants
node_authroutes -.->|"authenticates sessions"| node_auth
node_imports -->|"logs import"| node_privacy

click node_webui "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/page.tsx"
click node_authroutes "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/auth/login/route.ts"
click node_auth "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/auth.ts"
click node_authconstants "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/auth-constants.ts"
click node_rbac "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/rbac.ts"
click node_clients "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/clients/route.ts"
click node_employees "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/employees/route.ts"
click node_caen "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/caen-catalog.ts"
click node_caenselector "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/components/caen-selector.tsx"
click node_imports "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/imports/preview/route.ts"
click node_importer "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/importer.ts"
click node_exporter "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/exporter.ts"
click node_generation "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/documents/generate/route.ts"
click node_batchgeneration "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/documents/generate-batch/route.ts"
click node_definitions "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/definitions.ts"
click node_resolver "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/resolver.ts"
click node_generator "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/generator.ts"
click node_risk "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/risk-assessments/route.ts"
click node_riskpresets "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/risk/caen-risk-presets.ts"
click node_compliance "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/compliance.ts"
click node_training "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/trainings/record/route.ts"
click node_hygiene "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/hygiene/sessions/route.ts"
click node_hygienenumbering "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/hygiene-numbering.ts"
click node_eip "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/eip/assignments/route.ts"
click node_hygieneexcel "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/hygiene-excel.ts"
click node_privacy "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/security.ts"
click node_database "https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/prisma.ts"

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_webui,node_authroutes,node_auth,node_authconstants,node_rbac,node_operator toneBlue
class node_clients,node_employees,node_caen,node_caenselector toneAmber
class node_risk,node_riskpresets,node_compliance,node_training,node_hygiene,node_hygienenumbering,node_eip toneMint
class node_imports,node_importer,node_exporter,node_generation,node_batchgeneration,node_definitions,node_resolver,node_generator,node_hygieneexcel toneRose
class node_privacy,node_database toneIndigo
```

## Components

### Workspace and access

- [Web workspace](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/page.tsx): `src/app/page.tsx`
- [Authentication routes](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/auth/login/route.ts): `src/app/api/auth/login/route.ts`
- [Session authentication](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/auth.ts): `src/lib/auth.ts`
- [Session constants](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/auth-constants.ts): `src/lib/auth-constants.ts`
- [Role permissions](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/rbac.ts): `src/lib/rbac.ts`

### Client and workforce records

- [Client registry](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/clients/route.ts): `src/app/api/clients/route.ts`
- [Employee registry](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/employees/route.ts): `src/app/api/employees/route.ts`
- [CAEN catalog](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/caen-catalog.ts): `src/lib/caen-catalog.ts`
- [CAEN selector](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/components/caen-selector.tsx): `src/components/caen-selector.tsx`

### Safety and training

- [Risk assessments](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/risk-assessments/route.ts): `src/app/api/risk-assessments/route.ts`
- [CAEN risk presets](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/risk/caen-risk-presets.ts): `src/lib/risk/caen-risk-presets.ts`
- [Employee compliance](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/compliance.ts): `src/lib/compliance.ts`
- [Training records](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/trainings/record/route.ts): `src/app/api/trainings/record/route.ts`
- [Hygiene sessions](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/hygiene/sessions/route.ts): `src/app/api/hygiene/sessions/route.ts`
- [Certificate numbering](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/hygiene-numbering.ts): `src/lib/hygiene-numbering.ts`
- [EIP assignments](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/eip/assignments/route.ts): `src/app/api/eip/assignments/route.ts`

### Import and documents

- [Import preview and commit](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/imports/preview/route.ts): `src/app/api/imports/preview/route.ts`
- [Excel reconciliation](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/importer.ts): `src/lib/importer.ts`
- [Data export](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/exporter.ts): `src/lib/exporter.ts`
- [Document generation routes](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/documents/generate/route.ts): `src/app/api/documents/generate/route.ts`
- [Batch generation route](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/app/api/documents/generate-batch/route.ts): `src/app/api/documents/generate-batch/route.ts`
- [Template definitions](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/definitions.ts): `src/lib/templates/definitions.ts`
- [Placeholder resolver](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/resolver.ts): `src/lib/templates/resolver.ts`
- [Format generators](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/generator.ts): `src/lib/templates/generator.ts`
- [Hygiene Excel output](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/templates/hygiene-excel.ts): `src/lib/templates/hygiene-excel.ts`

### Persistence and safeguards

- [Privacy and audit](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/security.ts): `src/lib/security.ts`
- [PostgreSQL data](https://github.com/davidalexandru23/aplicatie_sm/blob/main/src/lib/prisma.ts): `src/lib/prisma.ts`

### Other components

- **Staff user**

## Connections

- Staff user → Web workspace: uses (evidence: `README.md`)
- Web workspace → Import preview and commit: starts import (evidence: `README.md`)
- Import preview and commit → Excel reconciliation: reconciles
- Excel reconciliation → Data export: reads birth dates (evidence: `src/lib/importer.ts`)
- Staff user → Web workspace: manages records (evidence: `README.md`)
- Employee registry → Excel reconciliation: validates CNP (evidence: `src/app/api/employees/route.ts`)
- Employee registry → Employee compliance: calculates status (evidence: `src/app/api/employees/route.ts`)
- Employee registry → Role permissions: sanitizes response (evidence: `src/app/api/employees/route.ts`)
- CAEN selector → CAEN catalog: searches catalog (evidence: `src/components/caen-selector.tsx`)
- Staff user → Web workspace: requests documents (evidence: `README.md`)
- Web workspace → Document generation routes: requests generation (evidence: `README.md`)
- Document generation routes → Placeholder resolver: resolves fields (evidence: `src/app/api/documents/generate/route.ts`)
- Document generation routes → Format generators: generates file (evidence: `src/app/api/documents/generate/route.ts`)
- Batch generation route → Placeholder resolver: resolves fields (evidence: `src/app/api/documents/generate-batch/route.ts`)
- Batch generation route → Format generators: generates files (evidence: `src/app/api/documents/generate-batch/route.ts`)
- Batch generation route → Employee compliance: checks expiry (evidence: `src/app/api/documents/generate-batch/route.ts`)
- Placeholder resolver → CAEN risk presets: loads risk profile (evidence: `src/lib/templates/resolver.ts`)
- Staff user → Web workspace: manages risk (evidence: `README.md`)
- Risk assessments → CAEN risk presets: uses CAEN profiles (evidence: `src/app/api/risk-assessments/route.ts`)
- Staff user → Web workspace: manages training (evidence: `README.md`)
- Hygiene sessions → Certificate numbering: assigns numbers (evidence: `src/app/api/hygiene/sessions/route.ts`)
- Staff user → Web workspace: manages hygiene (evidence: `README.md`)
- Employee registry → PostgreSQL data: reads and writes (evidence: `src/app/api/employees/route.ts`)
- Client registry → PostgreSQL data: reads and writes (evidence: `src/app/api/clients/route.ts`)
- Import preview and commit → PostgreSQL data: commits records
- Risk assessments → PostgreSQL data: persists assessments (evidence: `src/app/api/risk-assessments/route.ts`)
- Training records → PostgreSQL data: records training (evidence: `src/app/api/trainings/record/route.ts`)
- Hygiene sessions → PostgreSQL data: stores sessions (evidence: `src/app/api/hygiene/sessions/route.ts`)
- EIP assignments → PostgreSQL data: stores assignments (evidence: `src/app/api/eip/assignments/route.ts`)
- Certificate numbering → PostgreSQL data: allocates numbers (evidence: `src/lib/hygiene-numbering.ts`)
- Document generation routes → Template definitions: checks templates (evidence: `src/app/api/documents/generate/route.ts`)
- Format generators → Hygiene Excel output: generates workbook (evidence: `src/lib/templates/generator.ts`)
- Document generation routes → PostgreSQL data: stores generated records (evidence: `src/app/api/documents/generate/route.ts`)
- Privacy and audit → PostgreSQL data: writes audit events (evidence: `src/lib/security.ts`)
- Session authentication → Session constants: uses cookie settings (evidence: `src/lib/auth.ts`)
- Authentication routes → Session authentication: authenticates sessions
- Import preview and commit → Privacy and audit: logs import
