# tatianaifsp/cti-projeto architecture

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

- Interactive diagram: https://gitdiagram.com/tatianaifsp/cti-projeto
- Repository: https://github.com/tatianaifsp/cti-projeto

## Overview

CTI is a web application for importing and validating commercial customer spreadsheets, processing valid rows into business data, and exploring portfolio indicators. Its principal workflow runs from browser-side spreadsheet checks through server-side revalidation and Python ETL to persistence; separate branches cover account access and administration, and dashboard reporting. The map follows the README’s documented flow and sampled source references; several API and analytics connections are documented but their implementation files were not sampled.

Main entry points: [`frontend/src/services/api.js`](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/services/api.js) (HTTP client), [`analytics-python/main.py`](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/main.py) (Batch processing), [`frontend/src/stores/upload.js`](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/stores/upload.js) (Spreadsheet checks), [`backend/src/main/java/com/cti/provedor/service/UploadService.java`](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/UploadService.java) (Upload orchestration)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_frontend["Vue web app"]
  node_upload_ui["Spreadsheet upload<br/>[UploadView.vue]"]
  node_upload_store["Spreadsheet checks<br/>[upload.js]"]
  node_report_ui["Validation report<br/>[RelatorioView.vue]"]
  node_auth_ui["Session store<br/>[auth.js]"]
  node_admin_ui["User administration"]
  node_dashboard_ui["Dashboard<br/>[DashboardView.vue]"]
  node_http_client["HTTP client<br/>[api.js]"]
end

subgraph group_backend["Spring API"]
  node_upload_controller["Upload endpoint"]
  node_upload_service["Upload orchestration<br/>[UploadService.java]"]
  node_row_validation["Row validation"]
  node_python_etl_client["Python ETL client"]
  node_auth_controller["Authentication endpoints"]
  node_auth_service["Authentication rules<br/>[AuthService.java]"]
  node_admin_controller["Admin endpoints"]
  node_user_service["User management"]
  node_user_repository[("User repository")]
  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_python_main["Batch processing<br/>[main.py]"]
  node_cleaning["Cleaning and standardization<br/>[limpeza.py]"]
  node_analysis["Statistical indicators<br/>[analise.py]"]
  node_insights["Generated insights<br/>[insights.py]"]
  node_python_storage["Batch persistence<br/>[banco.py]"]
end

subgraph group_data["Data stores"]
  node_postgres[("PostgreSQL")]
end

node_user(("User"))

node_user -->|"uploads file"| node_upload_ui
node_upload_ui -->|"checks spreadsheet"| node_upload_store
node_upload_store -->|"shows results"| node_report_ui
node_report_ui -->|"releases valid rows"| node_upload_store
node_upload_store -->|"sends valid rows"| node_http_client
node_http_client -->|"posts upload"| node_upload_controller
node_upload_controller -->|"delegates upload"| node_upload_service
node_upload_service -->|"revalidates rows"| node_row_validation
node_upload_service -->|"forwards valid rows"| node_python_etl_client
node_python_etl_client -->|"posts ETL batch"| node_python_api
node_python_api -->|"starts processing"| node_python_main
node_python_main -->|"standardizes data"| node_cleaning
node_python_main -->|"calculates indicators"| node_analysis
node_analysis -->|"generates phrases"| node_insights
node_python_main -->|"persists batch"| node_python_storage
node_python_storage -->|"writes business data"| node_postgres
node_user -->|"signs in or registers"| node_auth_ui
node_auth_ui -->|"requests authentication"| node_http_client
node_http_client -->|"calls auth API"| node_auth_controller
node_auth_controller -->|"delegates auth"| node_auth_service
node_auth_service -->|"reads and saves users"| node_user_repository
node_user -->|"administers accounts"| node_admin_ui
node_admin_ui -->|"requests user changes"| node_http_client
node_http_client -->|"calls admin API"| node_admin_controller
node_admin_controller -->|"delegates management"| node_user_service
node_user_service -->|"queries users"| node_user_repository
node_user_repository -->|"stores accounts"| node_postgres
node_user -->|"views indicators"| node_dashboard_ui
node_dashboard_ui -->|"requests dashboard data"| node_http_client
node_http_client -->|"calls dashboard API"| node_dashboard_controller
node_dashboard_controller -->|"delegates queries"| node_dashboard_service
node_dashboard_service -->|"reads batches and statistics"| node_postgres

click node_upload_ui "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/UploadView.vue"
click node_upload_store "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/stores/upload.js"
click node_report_ui "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/RelatorioView.vue"
click node_auth_ui "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/stores/auth.js"
click node_admin_ui "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/AdminUsuariosView.vue"
click node_dashboard_ui "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/DashboardView.vue"
click node_http_client "https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/services/api.js"
click node_upload_controller "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/UploadController.java"
click node_upload_service "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/UploadService.java"
click node_row_validation "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java"
click node_python_etl_client "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/PythonEtlService.java"
click node_auth_controller "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/AuthController.java"
click node_auth_service "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/AuthService.java"
click node_admin_controller "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java"
click node_user_service "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/UsuarioService.java"
click node_user_repository "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java"
click node_dashboard_controller "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/DashboardController.java"
click node_dashboard_service "https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/DashboardService.java"
click node_python_api "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/api.py"
click node_python_main "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/main.py"
click node_cleaning "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/limpeza.py"
click node_analysis "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/analise.py"
click node_insights "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/insights.py"
click node_python_storage "https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/banco.py"

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_report_ui,node_auth_ui,node_admin_ui,node_dashboard_ui,node_http_client,node_user toneBlue
class node_upload_controller,node_upload_service,node_row_validation,node_python_etl_client,node_auth_controller,node_auth_service,node_admin_controller,node_user_service,node_user_repository,node_dashboard_controller,node_dashboard_service toneAmber
class node_python_api,node_python_main,node_cleaning,node_analysis,node_insights,node_python_storage toneMint
class node_postgres toneRose
```

## Components

### Vue web app

- [Spreadsheet upload](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/UploadView.vue): `frontend/src/views/UploadView.vue`
- [Spreadsheet checks](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/stores/upload.js): `frontend/src/stores/upload.js`
- [Validation report](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/RelatorioView.vue): `frontend/src/views/RelatorioView.vue`
- [Session store](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/stores/auth.js): `frontend/src/stores/auth.js`
- [User administration](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/AdminUsuariosView.vue): `frontend/src/views/AdminUsuariosView.vue`
- [Dashboard](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/views/DashboardView.vue): `frontend/src/views/DashboardView.vue`
- [HTTP client](https://github.com/tatianaifsp/cti-projeto/blob/main/frontend/src/services/api.js): `frontend/src/services/api.js`

### Spring API

- [Upload endpoint](https://github.com/tatianaifsp/cti-projeto/blob/main/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/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/UploadService.java): `backend/src/main/java/com/cti/provedor/service/UploadService.java`
- [Row validation](https://github.com/tatianaifsp/cti-projeto/blob/main/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/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/PythonEtlService.java): `backend/src/main/java/com/cti/provedor/service/PythonEtlService.java`
- [Authentication endpoints](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/AuthController.java): `backend/src/main/java/com/cti/provedor/controller/AuthController.java`
- [Authentication rules](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/AuthService.java): `backend/src/main/java/com/cti/provedor/service/AuthService.java`
- [Admin endpoints](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java): `backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java`
- [User management](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/service/UsuarioService.java): `backend/src/main/java/com/cti/provedor/service/UsuarioService.java`
- [User repository](https://github.com/tatianaifsp/cti-projeto/blob/main/backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java): `backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java`
- [Dashboard endpoint](https://github.com/tatianaifsp/cti-projeto/blob/main/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/tatianaifsp/cti-projeto/blob/main/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/tatianaifsp/cti-projeto/blob/main/analytics-python/api.py): `analytics-python/api.py`
- [Batch processing](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/main.py): `analytics-python/main.py`
- [Cleaning and standardization](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/limpeza.py): `analytics-python/limpeza.py`
- [Statistical indicators](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/analise.py): `analytics-python/analise.py`
- [Generated insights](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/insights.py): `analytics-python/insights.py`
- [Batch persistence](https://github.com/tatianaifsp/cti-projeto/blob/main/analytics-python/banco.py): `analytics-python/banco.py`

### Data stores

- **PostgreSQL**

### Other components

- **User**

## Connections

- User → Spreadsheet upload: uploads file
- Spreadsheet upload → Spreadsheet checks: checks spreadsheet
- Spreadsheet checks → Validation report: shows results (evidence: `frontend/src/views/RelatorioView.vue`)
- Validation report → Spreadsheet checks: releases valid rows (evidence: `frontend/src/views/RelatorioView.vue`)
- Spreadsheet checks → HTTP client: sends valid rows
- HTTP client → Upload endpoint: posts upload
- Upload endpoint → Upload orchestration: delegates upload
- Upload orchestration → Row validation: revalidates 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: posts ETL batch
- ETL API → Batch processing: starts processing
- Batch processing → Cleaning and standardization: standardizes data (evidence: `analytics-python/main.py`)
- Batch processing → Statistical indicators: calculates indicators (evidence: `analytics-python/main.py`)
- Statistical indicators → Generated insights: generates phrases (evidence: `analytics-python/analise.py`)
- Batch processing → Batch persistence: persists batch (evidence: `analytics-python/main.py`)
- Batch persistence → PostgreSQL: writes business data
- User → Session store: signs in or registers
- Session store → HTTP client: requests authentication (evidence: `frontend/src/stores/auth.js`)
- HTTP client → Authentication endpoints: calls auth API
- Authentication endpoints → Authentication rules: delegates auth (evidence: `backend/src/main/java/com/cti/provedor/controller/AuthController.java`)
- Authentication rules → User repository: reads and saves users (evidence: `backend/src/main/java/com/cti/provedor/service/AuthService.java`)
- User → User administration: administers accounts
- User administration → HTTP client: requests user changes (evidence: `frontend/src/views/AdminUsuariosView.vue`)
- HTTP client → Admin endpoints: calls admin API
- Admin endpoints → User management: delegates management (evidence: `backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java`)
- User management → User repository: queries users (evidence: `backend/src/main/java/com/cti/provedor/service/UsuarioService.java`)
- User repository → PostgreSQL: stores accounts
- User → Dashboard: views indicators
- Dashboard → HTTP client: requests dashboard data (evidence: `frontend/src/views/DashboardView.vue`)
- HTTP client → Dashboard endpoint: calls dashboard API
- Dashboard endpoint → Dashboard queries: delegates queries (evidence: `backend/src/main/java/com/cti/provedor/controller/DashboardController.java`)
- Dashboard queries → PostgreSQL: reads batches and statistics
