How astv2008/entrecol works
Entrecol is a web application for authorized users to query payroll and entertainment reports and for administrators to load source files. The principal flow is browser → FastAPI routes → report services and repositories → MariaDB, with optional PDF generation. A separate upload flow validates and transforms payroll, book, and movie files before loading them and returning a load report. Authentication adds mandatory TOTP, revocable sessions, roles, and auditing. The graph follows documented capabilities and sampled import/call evidence; unsampled report routes and service internals are shown as subsystems, with uncertain links omitted.
Main entry points: reportes_pdf.py PDF report routes · router.py API routes · reportes_nomina.py Report routes · service.py Payroll ETL
Components 34
Web and API
- Static frontend
frontend/js/pages/reportes.js - FastAPI application
backend/app/main.py - API routes
backend/app/api/v1/router.py
Identity and audit
- Authentication routes
backend/app/api/v1/auth.py - Auth and audit service
backend/app/security/service.py - Auth dependencies
backend/app/security/dependencies.py - Security records
backend/app/models/seguridad.py
Reporting
- Report routes
backend/app/api/v1/reportes_nomina.py - Entertainment routes
backend/app/api/v1/reportes_entretenimiento.py - PDF report routes
backend/app/api/v1/reportes_pdf.py - Payroll report services
backend/app/services/reporte_nomina.py - Personal report services
backend/app/services/reporte_personal.py - Health and pension reports
backend/app/services/reporte_salud_pension.py - Novelty reports
backend/app/services/reporte_novedades.py - Book reports
backend/app/services/reporte_libros.py - Movie reports
backend/app/services/reporte_peliculas.py - Report repositories
backend/app/repositories/nomina.py - Entertainment repository
backend/app/repositories/entretenimiento.py - PDF generation
backend/app/reports/pdf.py
Data ingestion
- Upload routes
backend/app/api/v1/cargas.py - Load report
backend/app/etl/common.py - Payroll ETL
backend/app/etl/nomina/service.py - Books ETL
backend/app/etl/libros/service.py - Movies ETL
backend/app/etl/peliculas/service.py - Payroll extraction
backend/app/etl/nomina/extractor.py - Book extraction
backend/app/etl/libros/extractor.py - Movie extraction
backend/app/etl/peliculas/extractor.py - File transformers
backend/app/etl/nomina/transformer.py - Catalog resolution
backend/app/etl/catalogos.py - Payroll loader
backend/app/etl/nomina/loader.py - Book loader
backend/app/etl/libros/loader.py - Movie loader
backend/app/etl/peliculas/loader.py
Persistence
- Database sessions
backend/app/db/session.py
Other components
- Browser user
Connections 47
- Browser user → Static frontend: uses
- Static frontend → FastAPI application: calls API
- FastAPI application → API routes: mounts
backend/app/main.py - API routes → Authentication routes: registers
backend/app/api/v1/router.py - API routes → Upload routes: registers
backend/app/api/v1/router.py - API routes → Report routes: registers
backend/app/api/v1/router.py - API routes → Entertainment routes: registers
backend/app/api/v1/router.py - API routes → PDF report routes: registers
backend/app/api/v1/router.py - Authentication routes → Auth and audit service: uses
backend/app/api/v1/auth.py - Authentication routes → Auth dependencies: uses
backend/app/api/v1/auth.py - Auth dependencies → Auth and audit service: uses
backend/app/security/dependencies.py - Auth and audit service → Security records: persists
backend/app/security/service.py - Upload routes → Payroll ETL: dispatches
backend/app/api/v1/cargas.py - Upload routes → Books ETL: dispatches
backend/app/api/v1/cargas.py - Upload routes → Movies ETL: dispatches
backend/app/api/v1/cargas.py - Payroll ETL → Payroll extraction: extracts
backend/app/etl/nomina/service.py - Books ETL → Book extraction: extracts
backend/app/etl/libros/service.py - Movies ETL → Movie extraction: extracts
backend/app/etl/peliculas/service.py - Payroll ETL → File transformers: transforms
backend/app/etl/nomina/service.py - Books ETL → File transformers: transforms
backend/app/etl/libros/service.py - Movies ETL → File transformers: transforms
backend/app/etl/peliculas/service.py - Payroll ETL → Payroll loader: loads
backend/app/etl/nomina/service.py - Books ETL → Book loader: loads
backend/app/etl/libros/service.py - Movies ETL → Movie loader: loads
backend/app/etl/peliculas/service.py - Payroll ETL → Load report: returns
backend/app/etl/nomina/service.py - Books ETL → Load report: returns
backend/app/etl/libros/service.py - Movies ETL → Load report: returns
backend/app/etl/peliculas/service.py - Payroll loader → Catalog resolution: resolves
backend/app/etl/nomina/loader.py - Book loader → Catalog resolution: resolves
backend/app/etl/libros/loader.py - Movie loader → Catalog resolution: resolves
backend/app/etl/peliculas/loader.py - Report routes → Payroll report services: serves
- Report routes → Personal report services: serves
- Report routes → Health and pension reports: serves
- Report routes → Novelty reports: serves
- Entertainment routes → Book reports: serves
- Entertainment routes → Movie reports: serves
- PDF report routes → PDF generation: generates
backend/app/api/v1/reportes_pdf.py - PDF report routes → Report repositories: queries
backend/app/api/v1/reportes_pdf.py - PDF report routes → Entertainment repository: queries
backend/app/api/v1/reportes_pdf.py - PDF report routes → Payroll report services: uses
backend/app/api/v1/reportes_pdf.py - PDF report routes → Personal report services: uses
backend/app/api/v1/reportes_pdf.py - PDF report routes → Health and pension reports: uses
backend/app/api/v1/reportes_pdf.py - PDF report routes → Novelty reports: uses
backend/app/api/v1/reportes_pdf.py - PDF report routes → Book reports: uses
backend/app/api/v1/reportes_pdf.py - PDF report routes → Movie reports: uses
backend/app/api/v1/reportes_pdf.py - Report repositories → Database sessions: queries
- Entertainment repository → Database sessions: queries