Jetour BI
|
e56d72c644
|
Add n8n service to docker-compose
- docker-compose: n8n container (port 5678) with PostgreSQL backend
- n8n/: 7 TypeScript workflow files + import script + README
- Workflows: 4 CMS BI data ingestion + 3 email reports
- README: updated with n8n env vars and port
- .dockerignore: exclude import.sh from container
|
2026-06-18 20:52:36 +00:00 |
|
Jetour BI
|
3f6824d86c
|
Add Docker support
- Dockerfile: multi-stage Python 3.12 slim build
- docker-compose.yml: app + PostgreSQL 16 with healthcheck
- requirements.txt: fastapi, uvicorn, psycopg, passlib, jose
- .dockerignore: exclude venv, pycache, secrets
- app.py: env-based DB config (DB_HOST/PORT/NAME/USER/PASSWORD)
- README: Docker deploy instructions
|
2026-06-18 20:47:23 +00:00 |
|
Jetour BI
|
9ff9ec27e9
|
Add database migrations + README
- migrations/001_initial.sql: full schema with 12 tables, triggers, indexes
- migrate.py: idempotent migration runner with version tracking
- README.md: deploy instructions, architecture overview
- .gitignore: exclude migration tracking data
|
2026-06-18 20:43:33 +00:00 |
|
root
|
8f206aa4f1
|
Initial commit: Jetour BI Dashboard
FastAPI backend with PostgreSQL queries for sales/CRM pipeline.
Chart.js dark-themed dashboard with:
- Pipeline funnel, velocity, conversion rates
- Monthly trend, lead sources, model distribution
- Vehicle order overview with per-color breakdown + subtotals
- Salesperson leaderboard, new vs used, lost reason analysis
- Email report settings (recipients + SMTP config)
- n8n integration for daily/weekly/monthly reports
|
2026-06-18 20:41:05 +00:00 |
|