How rogeriobertolino/cti_insights works
CTI Insights imports XLSX workbooks, analyzes and persists the resulting metrics and records, then presents dashboards and reports. The documented workflow and sampled calls support the main upload-to-analysis path; source excerpts do not show all API routing or database configuration, so those links are limited to explicit documentation or direct calls.
Main entry points: index.js Application routes · ImportService.java Import coordinator · dataStore.js API data store · AppLayout.vue Workspace shell
Components 20
Vue interface
- Workbook upload
src/views/UploadView.vue - API data store
src/dataStore.js - Application routes
src/router/index.js - Workspace shell
src/layouts/AppLayout.vue - Header
src/components/Header.vue - Navigation sidebar
src/components/Sidebar.vue - Home page
src/views/HomeView.vue - Login page
src/views/LoginView.vue - Charts dashboard
src/views/GraficosView.vue - Reports
src/views/RelatoriosView.vue
Import API
- Imports API
backend/src/main/java/br/com/cti/insights/imports/ImportController.java - Import coordinator
backend/src/main/java/br/com/cti/insights/imports/ImportService.java - Python bridge
backend/src/main/java/br/com/cti/insights/imports/PythonAnalysisService.java
Analysis engine
- Workbook analysis
python/analyze.py
Persistent data
- Import batches
backend/src/main/java/br/com/cti/insights/imports/ImportBatch.java - Batch repository
backend/src/main/java/br/com/cti/insights/imports/ImportBatchRepository.java - Imported records
backend/src/main/java/br/com/cti/insights/imports/ImportedRecord.java - Record repository
backend/src/main/java/br/com/cti/insights/imports/ImportedRecordRepository.java
Other components
- Analyst
- PostgreSQL
Connections 24
- Analyst → Workbook upload: selects workbook
src/views/UploadView.vue - Workbook upload → API data store: uploads XLSX
src/views/UploadView.vue - API data store → Imports API: POST imports
README.md - Imports API → Import coordinator: delegates processing
backend/src/main/java/br/com/cti/insights/imports/ImportController.java - Import coordinator → Batch repository: saves batch
backend/src/main/java/br/com/cti/insights/imports/ImportService.java - Import coordinator → Python bridge: invokes analysis
backend/src/main/java/br/com/cti/insights/imports/ImportService.java - Python bridge → Workbook analysis: runs script
README.md - Import coordinator → Record repository: saves records
backend/src/main/java/br/com/cti/insights/imports/ImportService.java - Import coordinator → Batch repository: updates status
backend/src/main/java/br/com/cti/insights/imports/ImportService.java - Batch repository → Import batches: persists batches
backend/src/main/java/br/com/cti/insights/imports/ImportBatchRepository.java - Record repository → Imported records: persists records
backend/src/main/java/br/com/cti/insights/imports/ImportedRecordRepository.java - Import batches → PostgreSQL: stored in
README.md - Imported records → PostgreSQL: stored in
README.md - API data store → Imports API: GET latest
README.md - Charts dashboard → API data store: loads latest
src/views/GraficosView.vue - Reports → API data store: reads analysis
src/views/RelatoriosView.vue - Application routes → Home page: routes to
src/router/index.js - Application routes → Login page: routes to
src/router/index.js - Application routes → Workspace shell: routes to
src/router/index.js - Application routes → Workbook upload: routes to
src/router/index.js - Application routes → Reports: routes to
src/router/index.js - Application routes → Charts dashboard: routes to
src/router/index.js - Workspace shell → Header: renders
src/layouts/AppLayout.vue - Workspace shell → Navigation sidebar: renders
src/layouts/AppLayout.vue