Paquete Demo Docker Compose Empresa Demo Cuyo S.A.

version: "3.9"

services:
  postgres:
    image: postgres:16
    container_name: faro_demo_postgres
    restart: unless-stopped
    environment:
      POSTGRES_USER: faro
      POSTGRES_PASSWORD: faro
      POSTGRES_DB: faro_demo
    ports:
      - "54329:5432"
    volumes:
      - faro_demo_pgdata:/var/lib/postgresql/data
      - ./db/init:/docker-entrypoint-initdb.d
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U faro -d faro_demo"]
      interval: 10s
      timeout: 5s
      retries: 5

  redis:
    image: redis:7
    container_name: faro_demo_redis
    restart: unless-stopped
    ports:
      - "63799:6379"
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 10s
      timeout: 5s
      retries: 5

  mailhog:
    image: mailhog/mailhog:latest
    container_name: faro_demo_mailhog
    restart: unless-stopped
    ports:
      - "8025:8025"   # UI web para inspeccionar emails de notificación
      - "1025:1025"   # SMTP capturado por FARO demo

  faro-app:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: faro_demo_app
    restart: unless-stopped
    depends_on:
      postgres:
        condition: service_healthy
      redis:
        condition: service_healthy
      mailhog:
        condition: service_started
    environment:
      NODE_ENV: demo
      DATABASE_URL: postgresql://faro:faro@postgres:5432/faro_demo
      REDIS_URL: redis://redis:6379
      FARO_DEMO_MODE: "true"
      FARO_AI_MODE: "fallback"
      SMTP_HOST: mailhog
      SMTP_PORT: "1025"
      APP_URL: http://localhost:3000
    ports:
      - "3000:3000"

volumes:
  faro_demo_pgdata:

# --- App ---
NODE_ENV=demo
APP_ENV=demo
APP_URL=http://localhost:3000

# --- Base de datos ---
DATABASE_URL=postgresql://faro:faro@localhost:54329/faro_demo
REDIS_URL=redis://localhost:63799

# --- Modo demo ---
FARO_DEMO_MODE=true
FARO_AI_MODE=fallback
FARO_DEFAULT_COMPANY_ID=10000000-0000-0000-0000-000000000001
FARO_TEST_NOW=2026-05-31T18:00:00-03:00

# --- Providers fake (no requieren credenciales) ---
EMAIL_PROVIDER=fake
STORAGE_PROVIDER=fake
AI_PROVIDER=fallback

# --- SMTP capturado por mailhog ---
SMTP_HOST=localhost
SMTP_PORT=1025

FARO Demo MVP

[OK] PostgreSQL healthy
[OK] Redis healthy
[OK] Mailhog ready
[OK] Migrations applied (V001..V040)
[OK] Base catalogs seeded
[OK] Empresa Demo Cuyo S.A. loaded (3 sucursales, 7 usuarios)
[OK] CSV dataset loaded (18 archivos, 4.820 ventas, 2.140 movimientos)
[OK] KPIs calculated
[OK] 30 MVP tensions evaluated (18 active, 10 critical/high)
[OK] Actions created (42 total, 6 critical, 5 expired)
[OK] Workflow initialized (estados mixtos)
[OK] Evidence seeded (8 submitted, 1 rejected, 11 missing)
[OK] FARO Score calculated: 66 (delta -8 vs 74)
[OK] Weekly report generated
[OK] AI fallback explanation generated
[OK] Demo check: PASS

Open:
http://localhost:3000/faro/demo
http://localhost:8025/         # Mailhog: ver notificaciones

{
  "actions_total_min": 30,
  "actions_critical_min": 6,
  "actions_expired_min": 3,
  "actions_blocked_min": 2,
  "actions_in_review_min": 2,
  "actions_with_missing_evidence_min": 8,
  "required_actions": [
    {
      "action_code": "ACT-COM-001",
      "tension_code": "TNS-001",
      "status": "in_review",
      "expected_score_recovery_max": 8
    },
    {
      "action_code": "ACT-FIN-001",
      "tension_code": "TNS-004",
      "status": "expired",
      "expected_score_recovery_max": 6
    },
    {
      "action_code": "ACT-STK-001",
      "tension_code": "TNS-006",
      "status": "blocked",
      "expected_score_recovery_max": 5
    }
  ]
}

{
  "expired_actions_min": 3,
  "blocked_actions_min": 2,
  "open_escalations_min": 2,
  "timeline_events_min": 80,
  "required_events": [
    "tension_detected",
    "action_created",
    "action_assigned",
    "action_expired",
    "evidence_submitted",
    "evidence_rejected",
    "action_escalated",
    "score_recalculated",
    "weekly_report_generated"
  ]
}

{
  "period_start": "2026-05-25",
  "period_end": "2026-05-31",
  "score": {
    "current": 66,
    "previous": 74,
    "delta": -8,
    "status": "warning",
    "confidence_min": 80,
    "confidence_status": "good"
  },
  "components": {
    "kpi_health":        { "expected": 20, "tolerance": 3 },
    "tension_health":    { "expected": 14, "tolerance": 3 },
    "execution_health":  { "expected": 12, "tolerance": 3 },
    "evidence_health":   { "expected": 10, "tolerance": 3 },
    "governance_health": { "expected": 10, "tolerance": 2 }
  },
  "required_negative_drivers": [
    "TNS-001", "TNS-004", "TNS-006",
    "ACTION_EXPIRED", "EVIDENCE_MISSING"
  ],
  "required_recovery_opportunities": [
    "ACT-COM-001", "ACT-FIN-001", "ACT-STK-001"
  ],
  "recovery_after_actions": {
    "score_current_after_actions": 74,
    "score_delta_after_actions": 8,
    "score_status_after_actions": "attention",
    "recovery_explanation": "La recuperación se produce por cierre de acciones críticas con evidencia aprobada."
  }
}

{
  "report_type": "weekly_executive",
  "must_include": [
    "Empresa Demo Cuyo S.A.",
    "FARO Score",
    "66",
    "-8",
    "Crecimiento no rentable",
    "acciones vencidas",
    "evidencia",
    "escalamientos",
    "decisiones requeridas"
  ],
  "required_sections": [
    "Resumen ejecutivo",
    "FARO Score",
    "Tensiones principales",
    "Acciones críticas",
    "Evidencias",
    "Escalamientos",
    "Decisiones requeridas",
    "Foco próxima semana"
  ],
  "status_expected": "generated"
}

{
  "mode": "fallback_or_provider",
  "score_explanation": {
    "must_include_refs":      ["SCORE", "TNS-001"],
    "must_not_include_refs":  ["TNS-999"],
    "must_include_numbers":   [66, -8],
    "must_not_invent_actions": true,
    "must_have_missing_information_array": true
  },
  "slots": {
    "score_current":      { "source": "faro.score_snapshots", "value": 66 },
    "score_previous":     { "source": "faro.score_snapshots", "value": 74 },
    "top_tension":         { "source": "faro.tensions",        "value": "TNS-001" },
    "top_action":          { "source": "faro.actions",         "value": "ACT-COM-001" },
    "missing_evidence":    { "source": "faro.evidence",        "value": ["EVD-012", "EVD-008"] }
  },
  "audit_trail": {
    "prompt_template_id": "PROMPT-WEEKLY-EXEC-v1",
    "slots_resolved_at":  "2026-05-31T17:55:00-03:00",
    "provider_used":      "fallback",
    "validation_passed":  true
  },
  "guardrails": {
    "invalid_source_ref_rejected": true,
    "prompt_injection_detected":   true,
    "fallback_available":          true
  }
}

INSERT INTO faro.companies (
  company_id,
  company_code,
  name,
  industry_code,
  country,
  timezone,
  ai_enabled
)
VALUES (
  '10000000-0000-0000-0000-000000000001',
  'EMP-DEMO',
  'Empresa Demo Cuyo S.A.',
  'commerce_construction_supplies',
  'AR',
  'America/Argentina/Mendoza',
  true
)
ON CONFLICT (company_id)
DO UPDATE SET
  name = EXCLUDED.name,
  industry_code = EXCLUDED.industry_code,
  timezone = EXCLUDED.timezone,
  updated_at = now();

INSERT INTO faro.branches (
  branch_id, company_id, branch_code, name, city, province, country, is_active
)
VALUES
( '11000000-0000-0000-0000-000000000001',
  '10000000-0000-0000-0000-000000000001',
  'BR-MDZ-CENTRO', 'Mendoza Centro', 'Mendoza', 'Mendoza', 'AR', true ),
( '11000000-0000-0000-0000-000000000002',
  '10000000-0000-0000-0000-000000000001',
  'BR-MDZ-NORTE', 'Mendoza Norte', 'Mendoza', 'Mendoza', 'AR', true ),
( '11000000-0000-0000-0000-000000000003',
  '10000000-0000-0000-0000-000000000001',
  'BR-SJ', 'Sucursal San Juan', 'San Juan', 'San Juan', 'AR', true )
ON CONFLICT (branch_id)
DO UPDATE SET
  name = EXCLUDED.name,
  updated_at = now();

#!/usr/bin/env bash
set -euo pipefail

echo "FARO Demo Pipeline · starting"

# 1. Ingesta CSV a RAW
echo "[1/14] Loading CSVs to RAW..."
pnpm demo:load-csv --dir data/csv

# 2. Validación RAW
echo "[2/14] Validating RAW..."
pnpm demo:validate-raw

# 3. Promoción a staging
echo "[3/14] Promoting RAW to staging..."
pnpm demo:promote-staging

# 4. Normalización
echo "[4/14] Normalizing staging..."
pnpm demo:normalize

# 5. Upsert master data
echo "[5/14] Upserting master data..."
pnpm demo:upsert-master

# 6. Insert facts
echo "[6/14] Inserting facts..."
pnpm demo:insert-facts

# 7. KPIs
echo "[7/14] Calculating KPIs..."
pnpm demo:kpis

# 8. Reglas y tensiones
echo "[8/14] Evaluating rules and detecting tensions..."
pnpm demo:rules

# 9. Acciones recomendadas
echo "[9/14] Creating recommended actions..."
pnpm demo:actions

# 10. Workflow checker
echo "[10/14] Running workflow checker..."
pnpm demo:workflow

# 11. Evidencias
echo "[11/14] Seeding demo evidence..."
pnpm demo:evidence

# 12. Notificaciones
echo "[12/14] Dispatching demo notifications..."
pnpm demo:notify

# 13. Score y reporte semanal
echo "[13/14] Calculating FARO Score and generating weekly report..."
pnpm demo:score
pnpm demo:report

# 14. IA fallback / provider
echo "[14/14] Generating AI explanation (slots + audit_trail)..."
pnpm demo:ai

echo ""
echo "FARO Demo Pipeline · PASS"
echo "Run scripts/demo-check.sh to validate outputs."

FARO Demo Check

[DB]
[OK] migrations applied (V001..V040)
[OK] demo company exists (Empresa Demo Cuyo S.A.)
[OK] users and roles exist (7 usuarios)
[OK] RLS test passed (viewer no ve otra empresa)

[Data]
[OK] products loaded: 260
[OK] customers loaded: 180
[OK] sales loaded: 4.820
[OK] stock movements loaded: 2.140
[OK] AR records loaded: 620
[OK] purchases loaded: 410

[Pipeline]
[OK] KPIs calculated (confidence avg 88%)
[OK] TNS-001 detected (priority_score 92)
[OK] TNS-004 detected
[OK] TNS-006 detected
[OK] 30 MVP tensions evaluated
[OK] 18 tensions active
[OK] 10 tensions critical/high

[Workflow]
[OK] actions created: 42
[OK] actions expired: 5
[OK] actions blocked: 3
[OK] escalations open: 3
[OK] evidence submitted: 8
[OK] evidence approved: 5
[OK] evidence missing: 11

[Score]
[OK] score current: 66
[OK] score previous: 74
[OK] delta: -8
[OK] confidence: 82 (≥ 80)
[OK] recovery potential: +8

[Reports]
[OK] weekly report generated
[OK] report contains FARO Score
[OK] report contains TNS-001
[OK] report contains decisiones requeridas

[AI]
[OK] fallback explanation generated
[OK] no invalid source refs
[OK] audit_trail complete

Result: PASS