# danielvieira95/projeto_integrador_cti architecture

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

- Interactive diagram: https://gitdiagram.com/danielvieira95/projeto_integrador_cti
- Repository: https://github.com/danielvieira95/projeto_integrador_cti

## Overview

CTI Insights is a client-planilha ingestion and analytics application with account access and an authenticated dashboard. Its main workflow is browser-side Excel validation, backend revalidation and filtering, Python cleaning/analysis and database persistence, then Java dashboard queries rendered by Vue. The README documents the cross-service stages; source-index references and excerpts support selected internal calls. Some implementation details, particularly the upload API wiring and unsampled analytics modules, are not shown, so those links are limited to documented relationships.

Main entry points: [`frontend/src/services/api.js`](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/services/api.js) (API client), [`analytics-python/main.py`](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/main.py) (ETL orchestration), [`backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java`](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java) (User repository), [`backend/src/main/java/com/cti/provedor/service/UploadService.java`](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/UploadService.java) (Upload orchestration)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_frontend["Frontend"]
  node_upload_ui["Upload and report<br/>[UploadView.vue]"]
  node_upload_store["Upload processing<br/>[upload.js]"]
  node_api_client["API client<br/>[api.js]"]
  node_dashboard_ui["Dashboard<br/>[DashboardView.vue]"]
  node_charts["Chart rendering<br/>[BaseChart.vue]"]
  node_auth_ui["Login and registration<br/>[auth.js]"]
end

subgraph group_backend["Java backend"]
  node_upload_controller["Upload endpoint"]
  node_upload_service["Upload orchestration<br/>[UploadService.java]"]
  node_validation["Client validation"]
  node_python_etl["Python ETL client"]
  node_dashboard_controller["Dashboard endpoint"]
  node_dashboard_service["Dashboard queries"]
end

subgraph group_analytics["Python analytics"]
  node_python_api["ETL API<br/>[api.py]"]
  node_etl_entry["ETL orchestration<br/>[main.py]"]
  node_cleaning["Cleaning and standardizing<br/>[limpeza.py]"]
  node_analysis["Analysis<br/>[analise.py]"]
  node_insights["Insights<br/>[insights.py]"]
  node_python_db["Data persistence<br/>[banco.py]"]
end

subgraph group_identity["Identity and administration"]
  node_auth_controller["Authentication endpoint"]
  node_auth_service["Account service<br/>[AuthService.java]"]
  node_user_repository["User repository"]
  node_user_entity["User records<br/>[Usuario.java]"]
  node_jwt["JWT service<br/>[JwtService.java]"]
  node_admin_controller["Admin endpoint"]
  node_user_service["User administration"]
end

node_user(("User"))
node_database[("PostgreSQL")]

node_user -->|"uploads spreadsheet"| node_upload_ui
node_upload_ui -.->|"starts processing"| node_upload_store
node_upload_store -->|"sends valid rows"| node_api_client
node_api_client -->|"submits rows"| node_upload_controller
node_upload_controller -->|"delegates to"| node_upload_service
node_upload_service -->|"validates rows"| node_validation
node_upload_service -->|"forwards valid rows"| node_python_etl
node_python_etl -->|"sends ETL request"| node_python_api
node_python_api -.->|"dispatches ETL"| node_etl_entry
node_etl_entry -->|"uses cleaning"| node_cleaning
node_etl_entry -->|"runs analysis"| node_analysis
node_etl_entry -->|"persists results"| node_python_db
node_analysis -->|"uses transformations"| node_cleaning
node_analysis -->|"uses insights"| node_insights
node_python_db -->|"writes data"| node_database
node_database -->|"serves dashboard data"| node_dashboard_service
node_dashboard_controller -->|"delegates query"| node_dashboard_service
node_dashboard_ui -->|"requests dashboard"| node_api_client
node_api_client -->|"fetches statistics"| node_dashboard_controller
node_dashboard_ui -->|"renders charts"| node_charts
node_user -->|"signs in"| node_auth_ui
node_auth_ui -->|"calls auth API"| node_api_client
node_api_client -->|"sends credentials"| node_auth_controller
node_auth_controller -->|"delegates authentication"| node_auth_service
node_auth_service -->|"reads and saves users"| node_user_repository
node_auth_service -->|"creates token"| node_jwt
node_user_repository -->|"stores records"| node_user_entity
node_user_repository -.->|"persists users"| node_database
node_admin_controller -->|"delegates administration"| node_user_service
node_user_service -->|"manages users"| node_user_repository

click node_upload_ui "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/views/UploadView.vue"
click node_upload_store "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/stores/upload.js"
click node_api_client "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/services/api.js"
click node_dashboard_ui "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/views/DashboardView.vue"
click node_charts "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/components/BaseChart.vue"
click node_upload_controller "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/UploadController.java"
click node_upload_service "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/UploadService.java"
click node_validation "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java"
click node_python_etl "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/PythonEtlService.java"
click node_python_api "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/api.py"
click node_etl_entry "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/main.py"
click node_cleaning "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/limpeza.py"
click node_analysis "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/analise.py"
click node_insights "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/insights.py"
click node_python_db "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/banco.py"
click node_auth_ui "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/stores/auth.js"
click node_auth_controller "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/AuthController.java"
click node_auth_service "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/AuthService.java"
click node_user_repository "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java"
click node_user_entity "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/model/Usuario.java"
click node_jwt "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/config/JwtService.java"
click node_admin_controller "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java"
click node_user_service "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/UsuarioService.java"
click node_dashboard_controller "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/DashboardController.java"
click node_dashboard_service "https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/DashboardService.java"

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_upload_ui,node_upload_store,node_api_client,node_dashboard_ui,node_charts,node_auth_ui,node_user toneBlue
class node_upload_controller,node_upload_service,node_validation,node_python_etl,node_dashboard_controller,node_dashboard_service,node_database toneAmber
class node_python_api,node_etl_entry,node_cleaning,node_analysis,node_insights,node_python_db toneMint
class node_auth_controller,node_auth_service,node_user_repository,node_user_entity,node_jwt,node_admin_controller,node_user_service toneRose
```

## Components

### Frontend

- [Upload and report](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/views/UploadView.vue): `frontend/src/views/UploadView.vue`
- [Upload processing](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/stores/upload.js): `frontend/src/stores/upload.js`
- [API client](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/services/api.js): `frontend/src/services/api.js`
- [Dashboard](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/views/DashboardView.vue): `frontend/src/views/DashboardView.vue`
- [Chart rendering](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/components/BaseChart.vue): `frontend/src/components/BaseChart.vue`
- [Login and registration](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/frontend/src/stores/auth.js): `frontend/src/stores/auth.js`

### Java backend

- [Upload endpoint](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/UploadController.java): `backend/src/main/java/com/cti/provedor/controller/UploadController.java`
- [Upload orchestration](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/UploadService.java): `backend/src/main/java/com/cti/provedor/service/UploadService.java`
- [Client validation](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java): `backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java`
- [Python ETL client](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/PythonEtlService.java): `backend/src/main/java/com/cti/provedor/service/PythonEtlService.java`
- [Dashboard endpoint](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/DashboardController.java): `backend/src/main/java/com/cti/provedor/controller/DashboardController.java`
- [Dashboard queries](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/DashboardService.java): `backend/src/main/java/com/cti/provedor/service/DashboardService.java`

### Python analytics

- [ETL API](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/api.py): `analytics-python/api.py`
- [ETL orchestration](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/main.py): `analytics-python/main.py`
- [Cleaning and standardizing](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/limpeza.py): `analytics-python/limpeza.py`
- [Analysis](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/analise.py): `analytics-python/analise.py`
- [Insights](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/insights.py): `analytics-python/insights.py`
- [Data persistence](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/analytics-python/banco.py): `analytics-python/banco.py`

### Identity and administration

- [Authentication endpoint](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/AuthController.java): `backend/src/main/java/com/cti/provedor/controller/AuthController.java`
- [Account service](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/AuthService.java): `backend/src/main/java/com/cti/provedor/service/AuthService.java`
- [User repository](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java): `backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java`
- [User records](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/model/Usuario.java): `backend/src/main/java/com/cti/provedor/model/Usuario.java`
- [JWT service](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/config/JwtService.java): `backend/src/main/java/com/cti/provedor/config/JwtService.java`
- [Admin endpoint](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java): `backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java`
- [User administration](https://github.com/danielvieira95/projeto_integrador_cti/blob/master/backend/src/main/java/com/cti/provedor/service/UsuarioService.java): `backend/src/main/java/com/cti/provedor/service/UsuarioService.java`

### Other components

- **User**
- **PostgreSQL**

## Connections

- User → Upload and report: uploads spreadsheet
- Upload and report → Upload processing: starts processing
- Upload processing → API client: sends valid rows
- API client → Upload endpoint: submits rows
- Upload endpoint → Upload orchestration: delegates to (evidence: `backend/src/main/java/com/cti/provedor/service/UploadService.java`)
- Upload orchestration → Client validation: validates rows (evidence: `backend/src/main/java/com/cti/provedor/service/UploadService.java`)
- Upload orchestration → Python ETL client: forwards valid rows (evidence: `backend/src/main/java/com/cti/provedor/service/UploadService.java`)
- Python ETL client → ETL API: sends ETL request
- ETL API → ETL orchestration: dispatches ETL
- ETL orchestration → Cleaning and standardizing: uses cleaning (evidence: `analytics-python/main.py`)
- ETL orchestration → Analysis: runs analysis (evidence: `analytics-python/main.py`)
- ETL orchestration → Data persistence: persists results (evidence: `analytics-python/main.py`)
- Analysis → Cleaning and standardizing: uses transformations (evidence: `analytics-python/analise.py`)
- Analysis → Insights: uses insights (evidence: `analytics-python/analise.py`)
- Data persistence → PostgreSQL: writes data
- PostgreSQL → Dashboard queries: serves dashboard data
- Dashboard endpoint → Dashboard queries: delegates query (evidence: `backend/src/main/java/com/cti/provedor/controller/DashboardController.java`)
- Dashboard → API client: requests dashboard (evidence: `frontend/src/views/DashboardView.vue`)
- API client → Dashboard endpoint: fetches statistics
- Dashboard → Chart rendering: renders charts (evidence: `frontend/src/views/DashboardView.vue`)
- User → Login and registration: signs in
- Login and registration → API client: calls auth API (evidence: `frontend/src/stores/auth.js`)
- API client → Authentication endpoint: sends credentials
- Authentication endpoint → Account service: delegates authentication (evidence: `backend/src/main/java/com/cti/provedor/controller/AuthController.java`)
- Account service → User repository: reads and saves users (evidence: `backend/src/main/java/com/cti/provedor/service/AuthService.java`)
- Account service → JWT service: creates token (evidence: `backend/src/main/java/com/cti/provedor/service/AuthService.java`)
- User repository → User records: stores records (evidence: `backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java`)
- User repository → PostgreSQL: persists users
- Admin endpoint → User administration: delegates administration (evidence: `backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java`)
- User administration → User repository: manages users (evidence: `backend/src/main/java/com/cti/provedor/service/UsuarioService.java`)
