Claude VM
a6c03a091e
Moved from gov-agreg/src/pages/achizitii/* to root (drop prefix). - 22 pages migrated, 127 files total - All internal links: /achizitii/X → /X (176 occurrences fixed) - AchizitiiLayout subnav rewritten: /X paths, top-right link to vreaudigital.ro hub - BaseLayout new (vreau.digital branding, OG tags, site URL) - astro.config.mjs: site https://vreau.digital, server output (was static) - docker-compose: port 5096 (vreaudigital is 5095), container vreau-digital - deploy.sh: paths /opt/vreau-digital, log /var/log/vreau-digital-deploy.log Backend shared with gov-agreg: - PostgreSQL satra (same schemas: seap, firms, anaf, anre, ...) - Photon, Martin tiles - Infisical /vreaudigital path (DATABASE_URL etc. shared) build: PASS (npx astro check 0 errors, npm run build 5s vite + 10s server)
1.5 KiB
1.5 KiB
AAAS ORDIN 278/2005 — historical AVAS firms — handoff
State at 2026-05-11:
aaas.firme: 11 firms, allaaas_status='active_holding'(current state shareholdings from the live portfolio page).- The Ordin 278/2005 historical list (~500-800 firms managed by AAAS predecessor AVAS/APAPS) is NOT on aaas.gov.ro.
Why deferred
- Source uncertainty: the PDF needs to be located via Monitorul Oficial or via Google scholar searches; current aaas.gov.ro nav doesn't expose it.
- Schema implication: would add new
aaas_status='historical_avas'enum value (text column, no DDL needed) — but the PR to add it didn't fit in budget without first locating the actual PDF.
Recommended approach (~3-4h)
- Locate PDF: search
site:monitorul-oficial.ro "ORDIN 278/2005" AVAS lista societatior trylegex.ro,lege5.ro,legislatie.just.rosearches. - Extract:
pdftotext -layoutthen regex^(\d+\.\s+)?([A-ZĂÂÎȘȚ"' \-]+ (S\.?A|S\.?R\.?L\.?))\s+(\d{6,9})$for name + CUI rows. - Fuzzy-match to firms.entities: use
firms.normalize_company_name+pg_trgmsimilarity ≥ 0.9 to resolve names → CUIs where the PDF lacks them. - Insert with
aaas_status='historical_avas'(text value, no schema migration). - Verify: union with current 11 active firms; expected total 500-800.
Defer reason
Source location uncertain, work could easily blow past 4h if the PDF turns out to be image-only (would need OCR). Lower ROI vs. fixing the WSP cron (which was completely broken).