How tatianaifsp/cti-projeto works
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: api.js HTTP client · main.py Batch processing · upload.js Spreadsheet checks · UploadService.java Upload orchestration
Components 26
Vue web app
- Spreadsheet upload
frontend/src/views/UploadView.vue - Spreadsheet checks
frontend/src/stores/upload.js - Validation report
frontend/src/views/RelatorioView.vue - Session store
frontend/src/stores/auth.js - User administration
frontend/src/views/AdminUsuariosView.vue - Dashboard
frontend/src/views/DashboardView.vue - HTTP client
frontend/src/services/api.js
Spring API
- Upload endpoint
backend/src/main/java/com/cti/provedor/controller/UploadController.java - Upload orchestration
backend/src/main/java/com/cti/provedor/service/UploadService.java - Row validation
backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java - Python ETL client
backend/src/main/java/com/cti/provedor/service/PythonEtlService.java - Authentication endpoints
backend/src/main/java/com/cti/provedor/controller/AuthController.java - Authentication rules
backend/src/main/java/com/cti/provedor/service/AuthService.java - Admin endpoints
backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java - User management
backend/src/main/java/com/cti/provedor/service/UsuarioService.java - User repository
backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java - Dashboard endpoint
backend/src/main/java/com/cti/provedor/controller/DashboardController.java - Dashboard queries
backend/src/main/java/com/cti/provedor/service/DashboardService.java
Python analytics
- ETL API
analytics-python/api.py - Batch processing
analytics-python/main.py - Cleaning and standardization
analytics-python/limpeza.py - Statistical indicators
analytics-python/analise.py - Generated insights
analytics-python/insights.py - Batch persistence
analytics-python/banco.py
Data stores
- PostgreSQL
Other components
- User
Connections 32
- User → Spreadsheet upload: uploads file
- Spreadsheet upload → Spreadsheet checks: checks spreadsheet
- Spreadsheet checks → Validation report: shows results
frontend/src/views/RelatorioView.vue - Validation report → Spreadsheet checks: releases valid rows
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
backend/src/main/java/com/cti/provedor/service/UploadService.java - Upload orchestration → Python ETL client: forwards valid rows
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
analytics-python/main.py - Batch processing → Statistical indicators: calculates indicators
analytics-python/main.py - Statistical indicators → Generated insights: generates phrases
analytics-python/analise.py - Batch processing → Batch persistence: persists batch
analytics-python/main.py - Batch persistence → PostgreSQL: writes business data
- User → Session store: signs in or registers
- Session store → HTTP client: requests authentication
frontend/src/stores/auth.js - HTTP client → Authentication endpoints: calls auth API
- Authentication endpoints → Authentication rules: delegates auth
backend/src/main/java/com/cti/provedor/controller/AuthController.java - Authentication rules → User repository: reads and saves users
backend/src/main/java/com/cti/provedor/service/AuthService.java - User → User administration: administers accounts
- User administration → HTTP client: requests user changes
frontend/src/views/AdminUsuariosView.vue - HTTP client → Admin endpoints: calls admin API
- Admin endpoints → User management: delegates management
backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java - User management → User repository: queries users
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
frontend/src/views/DashboardView.vue - HTTP client → Dashboard endpoint: calls dashboard API
- Dashboard endpoint → Dashboard queries: delegates queries
backend/src/main/java/com/cti/provedor/controller/DashboardController.java - Dashboard queries → PostgreSQL: reads batches and statistics