alex/tilbudgivern

Fork 0

Files

T

alexpolo1 4a372d2e28 clean up

2025-10-30 18:28:58 +00:00

2.9 KiB

Raw Permalink Blame History

✅ INSTALLATION MANUALS & HOUR ESTIMATION - KOMPLET IMPLEMENTATION

Dato: 29. Oktober 2025
Status: ✅ KOMPLET
PM2 Restarts: #331

🎯 Hvad Er Implementeret

1. Database Struktur ✅

ALTER TABLE project_materials ADD COLUMN varenr VARCHAR(50);
CREATE INDEX idx_varenr ON project_materials(varenr);

Project 21 har nu 7 materialer med varenr
Total materialeværdi: 76.065 DKK

2. Installation Manual Service ✅

Fil: backend/src/services/installationManualService.js

Funktioner:

checkMissingManuals(projectId) - Find materialer uden vejledninger
fetchManual(varenr) - Hent enkelt vejledning via scraper
fetchMultipleManuals(varenrs) - Bulk hentning (max 10, 2s delay)
getManual(varenr) - Hent fra database
calculateInstallationHours(manual, quantity, area) - Beregn timer

3. API Endpoints ✅

GET /api/installation-manuals/check-missing

curl "http://localhost:4031/api/installation-manuals/check-missing?projectId=21"

Returns: 7 manglende manuals for projekt 21

GET /api/installation-manuals/:varenr

Returns manual med parsed JSON fields

GET /api/project-materials/:projectId

Returns materials med hasManual status

POST /api/installation-manuals/fetch-missing

Bulk-henter manglende manuals (max 10 ad gangen)

POST /api/pricing/scrape-manual

Scraper enkelt manual via Python script

4. Hour Estimation Integration ✅

Opdaterede Endpoints:

POST /api/pdf/generate
POST /api/quotes/generate-static
POST /api/quotes/generate-ai

Logik:

// 1. Hent materialer med manual info
SELECT pm.*, im.time_estimate_per_unit, im.skill_level
FROM project_materials pm
LEFT JOIN installation_manuals im ON pm.varenr = im.varenr

// 2. Beregn timer per material
let hours = quantity * time_estimate_per_unit

// 3. Apply difficulty multiplier
if (skill_level === 'svær') hours *= 1.3
else if (skill_level === 'medium') hours *= 1.15

// 4. Brug manual-hours hvis ingen tasks findes
if (calculatedHoursFromManuals > 0 && totalLaborHours === 0) {
  totalLaborHours = calculatedHoursFromManuals
}

5. Test Data ✅

Projekt 21: "Tag udskiftning - Røsevangen 44"

Kunde: Alexander Warme
Materialer: 7 stk (alle med varenr)
Total: 76.065 DKK

🧪 Quick Test

# Tjek manglende manuals
curl -s "http://localhost:4031/api/installation-manuals/check-missing?projectId=21" | jq

# Generer PDF med hour estimation
curl -X POST http://localhost:4031/api/pdf/generate \
  -H "Content-Type: application/json" \
  -d '{"projectId": 21, "quoteText": "Test tilbud"}' \
  --output /tmp/quote_21.pdf

✅ Success Criteria - OPFYLDT

Database har varenr kolonne
API endpoints fungerer
Timer beregnes baseret på manuals
PDF generation inkluderer calculated hours
Test projekt 21 fungerer

🚀 READY FOR PRODUCTION! 🚀

2.9 KiB Raw Permalink Blame History