How ludwingh28/etl works
Cruz imex is a business-intelligence system: users authenticate, receive role- and permission-aware access to sales, product, route, inventory, supplier and download dashboards, while administrators manage accounts and reports. The React application routes users to dashboard pages; a Django API provides backend services, and a separate ETL package loads sales and reference data into PostgreSQL. A second Django project under References is visible in the tree but its relationship to the main application is unclear. Dashboard-to-API and ETL-to-dashboard data links are not established by the excerpts, so they are omitted or marked unverified.
Main entry points: App.tsx Route dispatcher · database.py PostgreSQL pool · etl_ventas.py Sales ETL · views.py Business API
Components 22
Web application
- Route dispatcher
frontend/src/App.tsx - Session context
frontend/src/context/AuthContext.tsx - Permission routes
frontend/src/constants/routes.ts - Dashboard shell
frontend/src/components/DashboardLayout.tsx - Sales dashboards
frontend/src/pages/DashboardNewNacional.tsx - Product dashboards
frontend/src/pages/DashboardComportamientoProductos.tsx - Route dashboards
frontend/src/pages/DashboardDistribucionRutas.tsx - Supplier dashboards
frontend/src/pages/DashboardSoftysCanales.tsx - User administration
frontend/src/pages/AdminGestionUsuarios.tsx
API and identity
- Business API
backend/api/views.py - Token authentication
backend/api/authentication.py - User and domain models
backend/api/models.py - Application databases
backend/cruzimex/settings.py
Data ingestion
- Sales ETL
References/etl-main/etl-main/etl_ventas.py - Product loading
References/etl-main/etl-main/cargar_productos.py - Seller loading
References/etl-main/etl-main/cargar_vendedores.py - ETL configuration
References/etl-main/etl-main/config.py - PostgreSQL pool
References/etl-main/etl-main/database.py
Reference service
- Legacy stream service
References/back-main/back-main/stream/views.py - Legacy stream models
References/back-main/back-main/stream/models.py
Other components
- BI user
- Administrator
Connections 22
- BI user → Route dispatcher: uses
- Administrator → Route dispatcher: uses
- Route dispatcher → Session context: provides session
frontend/src/App.tsx - Route dispatcher → Permission routes: selects landing route
frontend/src/App.tsx - Route dispatcher → Sales dashboards: routes to
frontend/src/App.tsx - Route dispatcher → Product dashboards: routes to
frontend/src/App.tsx - Route dispatcher → Route dashboards: routes to
frontend/src/App.tsx - Route dispatcher → Supplier dashboards: routes to
frontend/src/App.tsx - Route dispatcher → User administration: routes to
frontend/src/App.tsx - Dashboard shell → Session context: renders navigation
frontend/src/components/DashboardLayout.tsx - Session context → Business API: requests session services
- Token authentication → User and domain models: checks user profile
backend/api/authentication.py - Business API → User and domain models: uses domain models
backend/api/views.py - Business API → Application databases: accesses persistence
- Sales ETL → PostgreSQL pool: uses connections
References/etl-main/etl-main/etl_ventas.py - Sales ETL → ETL configuration: uses settings
References/etl-main/etl-main/etl_ventas.py - Sales ETL → Product loading: loads reference data
- Product loading → PostgreSQL pool: uses connections
References/etl-main/etl-main/cargar_productos.py - Product loading → ETL configuration: uses settings
References/etl-main/etl-main/cargar_productos.py - Seller loading → PostgreSQL pool: uses connections
- PostgreSQL pool → ETL configuration: configures pool
References/etl-main/etl-main/database.py - Legacy stream service → Legacy stream models: queries models
References/back-main/back-main/stream/views.py