How sqlalan/cti works
CTI Insights turns manually maintained client spreadsheets into validated, standardized client data, persisted records, statistical summaries and dashboard insights. The main workflow runs from browser-side spreadsheet checks through Spring validation and a Python ETL to PostgreSQL; Spring then serves dashboard data back to the Vue interface. Separate capabilities include account access and administration, manual client and contract management, processing history, and a file-based statistical report. Some backend routes and frontend components are unsampled, so links for those branches rely on README documentation.
Main entry points: api.js API client · main.py ETL orchestration · Upload.vue Spreadsheet upload · UploadService.java Upload validation
Components 22
Vue frontend
- Spreadsheet upload
frontend/src/pages/Upload.vue - Sheet validation
frontend/src/dados/esquemaPlanilha.js - Upload state
frontend/src/stores/uploadStore.js - API client
frontend/src/services/api.js - Dashboard
frontend/src/views/DashboardView.vue - Processing history
frontend/src/components/HistoricoProcessamentos.vue - Login and accounts
frontend/src/pages/Login.vue
Spring backend
- Upload validation
backend/src/main/java/br/com/cti/insights/service/UploadService.java - Validated row DTO
backend/src/main/java/br/com/cti/insights/dto/ClienteDTO.java - Python ETL client
backend/src/main/java/br/com/cti/insights/service/PythonEtlService.java - Dashboard reader
backend/src/main/java/br/com/cti/insights/service/DashboardService.java - Client management
backend/src/main/java/br/com/cti/insights/service/ClienteService.java - Account management
backend/src/main/java/br/com/cti/insights/service/UsuarioService.java
Python ETL
- ETL API
analytics-python/api.py - ETL orchestration
analytics-python/main.py - Data cleaning
analytics-python/limpeza.py - Statistical analysis
analytics-python/analise.py - ETL persistence
analytics-python/banco.py - Insight generation
analytics-python/insights.py
Analytics
- Offline report
analytics-python/relatorio.py
Other components
- Consultor
- PostgreSQL
Connections 22
- Consultor → Spreadsheet upload: uploads sheet
README.md - Spreadsheet upload → Sheet validation: validates rows
frontend/src/pages/Upload.vue - Spreadsheet upload → Upload state: submits batch
frontend/src/pages/Upload.vue - Upload state → API client: sends upload
frontend/src/stores/uploadStore.js - API client → Upload validation: posts batch
README.md - Upload validation → Validated row DTO: validates rows
backend/src/main/java/br/com/cti/insights/service/UploadService.java - Upload validation → Python ETL client: forwards valid rows
backend/src/main/java/br/com/cti/insights/service/UploadService.java - Python ETL client → ETL API: posts ETL request
README.md - ETL API → ETL orchestration: dispatches ETL
README.md - ETL orchestration → Data cleaning: cleans data
analytics-python/main.py - ETL orchestration → Statistical analysis: calculates statistics
analytics-python/main.py - ETL orchestration → ETL persistence: persists results
analytics-python/main.py - Statistical analysis → Insight generation: uses analysis
analytics-python/analise.py - ETL persistence → PostgreSQL: writes ETL data
README.md - Dashboard → API client: requests dashboard
README.md - API client → Dashboard reader: requests dashboard
README.md - Dashboard reader → PostgreSQL: reads dashboard data
README.md - Processing history → API client: loads batches
frontend/src/components/HistoricoProcessamentos.vue - Login and accounts → API client: submits credentials
- Account management → PostgreSQL: stores accounts
- Client management → PostgreSQL: manages client records
- Offline report → Statistical analysis: produces report