'; } function showResult(){ const brand = brandEl.value; const model = modelEl.value; const version = versionEl.value; const year = Number(yearEl.value); const use = useEl.value; if(!brand || !model || !version || !year){ resultEl.innerHTML = '

Onvolledige selectie

Selecteer merk, model, uitvoering en bouwjaar.

'; return; } let matches = matchingBase().filter(v => year >= Number(v.yearFrom || 0) && year <= Number(v.yearTo || 9999) ); if(use !== "both"){ matches = matches.filter(v => String(v.plug) === use); } if(!matches.length){ resultEl.innerHTML = '

Geen directe match gevonden

' + '

Voor ' + esc(brand + " " + model + " " + version + " " + year) + ' staat nog geen passende set in deze selector.

' + ''; return; } const dedicated = matches.filter(v => v.isDedicated); const standard = matches.filter(v => !v.isDedicated); /* Belangrijk: Voor sommige voertuigen bestaat een G8 UNI-oplossing én een G13 P&P/dedicated oplossing. De selector mag dan niet alleen de dedicated regel tonen; de klant moet beide keuzes zien. Daarom tonen we standaard alle passende matches, tenzij de gebruiker expliciet G8 of G13 kiest. */ const chosen = matches.slice().sort(function(a, b){ const plugOrder = Number(a.plug || 0) - Number(b.plug || 0); if (plugOrder !== 0) return plugOrder; if (a.isDedicated === b.isDedicated) return String(a.product || '').localeCompare(String(b.product || ''), 'nl'); return a.isDedicated ? -1 : 1; }); let intro = ''; if (dedicated.length && standard.length) { intro = '

Meerdere passende CAN-bus opties gevonden

' + '

Voor deze selectie zijn zowel standaard MP2S-CAN opties als Plug & Play / dedicated opties beschikbaar. Kies G8 voor aanhanger/fietsendrager of G13 voor caravan/professioneel gebruik.

'; } else if (dedicated.length) { intro = '

Plug & Play / dedicated set beschikbaar

' + '

Voor deze selectie is een voertuigspecifieke oplossing beschikbaar.

'; } else { intro = '

Standaard MP2S-CAN oplossing

' + '

Voor deze selectie is geen Plug & Play set in de lijst gevonden. De standaard CAN-bus uitvoering is het uitgangspunt.

'; } resultEl.innerHTML = intro + '

Voertuig: ' + esc(brand + " " + model + (version ? " · " + version : "") + " · " + year) + '

' + '' + ''; } function parseCsv(text){ const rows = []; let row = []; let value = ''; let inQuotes = false; for(let i = 0; i < text.length; i++){ const char = text[i]; const next = text[i + 1]; if(char === '"'){ if(inQuotes && next === '"'){ value += '"'; i++; } else { inQuotes = !inQuotes; } } else if(char === ',' && !inQuotes){ row.push(value); value = ''; } else if((char === '\n' || char === '\r') && !inQuotes){ if(char === '\r' && next === '\n') i++; row.push(value); if(row.some(cell => String(cell).trim() !== '')) rows.push(row); row = []; value = ''; } else { value += char; } } if(value || row.length){ row.push(value); if(row.some(cell => String(cell).trim() !== '')) rows.push(row); } return rows; } function normalizeKey(key){ return String(key || '') .trim() .toLowerCase() .replace(/\s+/g, '_') .replace(/[.()\-/]/g, '_') .replace(/_+/g, '_') .replace(/^_|_$/g, ''); } function pick(obj, keys, fallback){ for(const key of keys){ const normalized = normalizeKey(key); if(obj[normalized] !== undefined && String(obj[normalized]).trim() !== '') return String(obj[normalized]).trim(); } return fallback || ''; } function extractPlug(value){ const s = String(value || '').toUpperCase(); if(s.includes('G13') || s === '13') return '13'; if(s.includes('G8') || s === '8') return '8'; const m = s.match(/\b(7|8|13)\b/); return m ? m[1] : ''; } function csvToVehicles(csv){ const parsed = parseCsv(csv); if(parsed.length < 2) return []; const headers = parsed[0].map(normalizeKey); return parsed.slice(1).map(function(row){ const obj = {}; headers.forEach(function(header, index){ obj[header] = row[index] || ''; }); const active = pick(obj, ['actief_voor_selector','active','actief'], 'Ja'); if(String(active).trim().toLowerCase() === 'nee' || String(active).trim().toLowerCase() === 'no') return null; const brand = pick(obj, ['brand','merk']); const model = pick(obj, ['model']); const version = pick(obj, ['version','versie','uitvoering','variant']); const yearFrom = Number(pick(obj, ['yearFrom','year_from','vanaf','bouwjaar_vanaf'], '0')); const yearToRaw = pick(obj, ['yearTo','year_to','tot','bouwjaar_t_m','bouwjaar_tm','bouwjaar_t/m'], ''); const yearTo = Number(yearToRaw || yearFrom || 2035); const plug = extractPlug(pick(obj, ['plug','stekker','stekker_uitvoering','g8_g13','uitvoering_g'])); const product = pick(obj, ['product','set','quasar_set','product_name','set_naam']); const org = pick(obj, ['org','type','set_type','dedicated','p_p','p_en_p']); const ecs = pick(obj, ['ecs','ecs_ref','ecs_reference','ecs_referentie']); const ownUrl = pick(obj, ['ownUrl','own_url','jouwweb_url','webshop_url','url']); const module = pick(obj, ['module','modulefamilie'], 'MP2S-CAN'); const pdc = pick(obj, ['pdc']); const fog = pick(obj, ['fog','mistlamp']); const c2 = pick(obj, ['c2','c2_controle']); const yearLabel = pick(obj, ['yearLabel','year_label','bouwjaar','bouwjaar_tekst','jaren'], (yearFrom && yearTo ? yearFrom + ' - ' + yearTo : '')); const note = pick(obj, ['controle_opmerking','opmerking','note']); const dedicatedFlag = pick(obj, ['dedicated_p_p_beschikbaar','dedicated_beschikbaar','p_p_beschikbaar'], ''); const orgUpper = String(org || '').toUpperCase(); const productUpper = String(product || '').toUpperCase(); const dedicatedUpper = String(dedicatedFlag || '').toUpperCase(); const isDedicated = orgUpper.includes('P2P') || orgUpper.includes('P&P') || orgUpper.includes('DEDICATED') || dedicatedUpper === 'JA' || dedicatedUpper === 'YES' || ((productUpper.includes('VW-59') || productUpper.includes('VW59')) && String(plug) === '13'); const dedicatedNote = ((productUpper.includes('VW-59') || productUpper.includes('VW59')) && String(plug) === '13') ? 'Volgens nadere informatie van Quasar wordt deze G13-VW59 uitvoering geleverd met dedicated kabel.' : note; return { brand, model, version, yearLabel, yearFrom: yearFrom || 1900, yearTo: yearTo || 2035, plug, product, module, org, pdc, fog, c2, ecs, ownUrl: ownUrl || ('/producten/' + String(product || 'mp2s-can').toLowerCase().replace(/\s+/g,'-').replace(/[^a-z0-9\-]/g,'')), isDedicated, dedicatedNote }; }).filter(function(v){ return v && v.brand && v.model && v.product; }); } async function loadVehicleData(){ if(!GOOGLE_SHEET_CSV_URL){ fillBrands(); return; } try { const response = await fetch(GOOGLE_SHEET_CSV_URL); if(!response.ok) throw new Error('CSV niet bereikbaar'); const csv = await response.text(); const imported = csvToVehicles(csv); if(imported.length) VEHICLES = imported; fillBrands(); } catch(error){ console.warn('Google Sheet kon niet worden geladen. Interne data wordt gebruikt.', error); fillBrands(); } } brandEl.addEventListener("change", fillModels); modelEl.addEventListener("change", fillVersions); versionEl.addEventListener("change", fillYears); searchBtn.addEventListener("click", showResult); loadVehicleData(); })();