How danielvieira95/projeto_integrador_cti works
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: api.js API client · main.py ETL orchestration · UsuarioRepository.java User repository · UploadService.java Upload orchestration
Components 27
Frontend
- Upload and report
frontend/src/views/UploadView.vue - Upload processing
frontend/src/stores/upload.js - API client
frontend/src/services/api.js - Dashboard
frontend/src/views/DashboardView.vue - Chart rendering
frontend/src/components/BaseChart.vue - Login and registration
frontend/src/stores/auth.js
Java backend
- Upload endpoint
backend/src/main/java/com/cti/provedor/controller/UploadController.java - Upload orchestration
backend/src/main/java/com/cti/provedor/service/UploadService.java - Client validation
backend/src/main/java/com/cti/provedor/service/ClienteValidacaoService.java - Python ETL client
backend/src/main/java/com/cti/provedor/service/PythonEtlService.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 - ETL orchestration
analytics-python/main.py - Cleaning and standardizing
analytics-python/limpeza.py - Analysis
analytics-python/analise.py - Insights
analytics-python/insights.py - Data persistence
analytics-python/banco.py
Identity and administration
- Authentication endpoint
backend/src/main/java/com/cti/provedor/controller/AuthController.java - Account service
backend/src/main/java/com/cti/provedor/service/AuthService.java - User repository
backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java - User records
backend/src/main/java/com/cti/provedor/model/Usuario.java - JWT service
backend/src/main/java/com/cti/provedor/config/JwtService.java - Admin endpoint
backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java - User administration
backend/src/main/java/com/cti/provedor/service/UsuarioService.java
Other components
- User
- PostgreSQL
Connections 30
- 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
backend/src/main/java/com/cti/provedor/service/UploadService.java - Upload orchestration → Client validation: validates 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: sends ETL request
- ETL API → ETL orchestration: dispatches ETL
- ETL orchestration → Cleaning and standardizing: uses cleaning
analytics-python/main.py - ETL orchestration → Analysis: runs analysis
analytics-python/main.py - ETL orchestration → Data persistence: persists results
analytics-python/main.py - Analysis → Cleaning and standardizing: uses transformations
analytics-python/analise.py - Analysis → Insights: uses insights
analytics-python/analise.py - Data persistence → PostgreSQL: writes data
- PostgreSQL → Dashboard queries: serves dashboard data
- Dashboard endpoint → Dashboard queries: delegates query
backend/src/main/java/com/cti/provedor/controller/DashboardController.java - Dashboard → API client: requests dashboard
frontend/src/views/DashboardView.vue - API client → Dashboard endpoint: fetches statistics
- Dashboard → Chart rendering: renders charts
frontend/src/views/DashboardView.vue - User → Login and registration: signs in
- Login and registration → API client: calls auth API
frontend/src/stores/auth.js - API client → Authentication endpoint: sends credentials
- Authentication endpoint → Account service: delegates authentication
backend/src/main/java/com/cti/provedor/controller/AuthController.java - Account service → User repository: reads and saves users
backend/src/main/java/com/cti/provedor/service/AuthService.java - Account service → JWT service: creates token
backend/src/main/java/com/cti/provedor/service/AuthService.java - User repository → User records: stores records
backend/src/main/java/com/cti/provedor/repository/UsuarioRepository.java - User repository → PostgreSQL: persists users
- Admin endpoint → User administration: delegates administration
backend/src/main/java/com/cti/provedor/controller/AdminUsuarioController.java - User administration → User repository: manages users
backend/src/main/java/com/cti/provedor/service/UsuarioService.java