/* ========================= CONFIGURAZIONE ========================= */ // Inserisci qui la NUOVA chiave Google Maps (non quella eventualmente esposta in precedenza). const GOOGLE_MAPS_API_KEY="AIzaSyA4aqSTaiCvd5Bzv9kQJaFQ_doiZNKQeTA"; const SUPABASE_URL="https://syumewscephqgmqiqtxw.supabase.co"; // Inserisci qui la Publishable key che inizia con sb_publishable_... const SUPABASE_PUBLISHABLE_KEY="sb_publishable_VHWr13zM-wvDjlVyUnti2g_oh9Z8OC4"; /* Dataset iniziale: 369 record */ let places=[]; let submittedApproved=[]; let map,geocoder,infoWindow,markers=[],selectedTavKey=null; const ADMIN_UID="7bb1ab28-e6b2-4032-8055-4dac1bf5edfe"; let currentUser=null,currentProfile=null,isSignup=false,isAdmin=false; let adminOverrides=new Map(), deletedTavKeys=new Set(), geocodeRunning=false; const supabaseConfigured=!SUPABASE_URL.startsWith("YOUR_")&&!SUPABASE_PUBLISHABLE_KEY.startsWith("YOUR_"); const sb=supabaseConfigured ? supabase.createClient(SUPABASE_URL,SUPABASE_PUBLISHABLE_KEY,{auth:{persistSession:true,autoRefreshToken:true,detectSessionInUrl:true}}) : null; function esc(s){return String(s??"").replace(/[&<>"']/g,m=>({"&":"&","<":"<",">":">",'"':""","'":"'"}[m]));} function clean(s){return String(s??"").normalize("NFD").replace(/[\u0300-\u036f]/g,"").toUpperCase();} function closeModal(id){document.getElementById(id).classList.remove("show")} function openModal(id){document.getElementById(id).classList.add("show")} function coordCount(){return places.filter(p=>Number.isFinite(p.lat)&&Number.isFinite(p.lng)).length;} function initMap(){ map=new google.maps.Map(document.getElementById("map"),{center:{lat:41.9,lng:12.6},zoom:6,mapTypeControl:true,streetViewControl:false}); geocoder=new google.maps.Geocoder(); infoWindow=new google.maps.InfoWindow(); loadCountries(); loadRegions(); updateRegionVisibility(); applyAutoGeoCache(); render(); loadApprovedSubmissions(); updateAuthUI(); setTimeout(autoGeocodeFirstLoad,1200); } window.initMap=initMap; async function loadApprovedSubmissions(){ if(!sb) return; const {data:deleted,error:de}=await sb.from("tav_deleted").select("tav_key"); if(!de&&deleted) deletedTavKeys=new Set(deleted.map(x=>String(x.tav_key))); const {data,error}=await sb.from("tav_submissions").select("*").eq("status","approved").order("created_at",{ascending:true}); if(!error&&data){submittedApproved=data.map(p=>({...p,_id:`submission-${p.id}`})).filter(p=>!deletedTavKeys.has(String(p._id)));} const {data:ov,error:oe}=await sb.from("tav_coordinate_overrides").select("*"); if(!oe&&ov){ [...places,...submittedApproved].forEach(p=>{const o=ov.find(x=>String(x.tav_key)===String(p._id));if(o){p.lat=o.lat;p.lng=o.lng;p.coord_source=o.note?.startsWith("AUTO_GOOGLE")?"Google Maps":"Admin";p.precision=o.note?.startsWith("AUTO_GOOGLE")?"Geolocalizzato":"Verificato manualmente";p.admin_verified=!o.note?.startsWith("AUTO_GOOGLE");p.admin_note=o.note||"";}}); } const {data:info,error:ie}=await sb.from("tav_admin_overrides").select("*"); if(!ie&&info){adminOverrides=new Map(info.map(x=>[String(x.tav_key),x])); places.forEach(p=>applyAdminInfo(p)); submittedApproved.forEach(p=>applyAdminInfo(p)); } render(); } async function updateAuthUI(){ if(!sb){ document.getElementById("userArea").innerHTML='Backend utenti da configurare'; return; } const {data}=await sb.auth.getUser(); currentUser=data?.user||null; if(currentUser){ const {data:p}=await sb.from("profiles").select("display_name,role").eq("id",currentUser.id).maybeSingle(); currentProfile=p; isAdmin=(p?.role==="admin") || (currentUser?.id===ADMIN_UID); console.log("TAV admin status",{user:currentUser?.id,role:p?.role,isAdmin}); if(isAdmin) document.body.classList.add("isAdmin"); else document.body.classList.remove("isAdmin"); document.getElementById("userArea").innerHTML=`${esc(p?.display_name||currentUser.email)} ${isAdmin?'':''} `; if(isAdmin){document.getElementById("adminBox").classList.add("show");loadPending();} render(); }else{ isAdmin=false; document.getElementById("adminBox").classList.remove("show"); document.getElementById("userArea").innerHTML=''; render(); } } const WORLD_COUNTRIES=["ITALIA","REGNO UNITO","TURCHIA","RUSSIA","FRANCIA","GERMANIA","SPAGNA","PORTOGALLO","SVIZZERA","AUSTRIA","BELGIO","PAESI BASSI","DANIMARCA","SVEZIA","NORVEGIA","FINLANDIA","IRLANDA","POLONIA","CECHIA","SLOVACCHIA","UNGHERIA","ROMANIA","BULGARIA","GRECIA","SERBIA","CROAZIA","SLOVENIA","BOSNIA ED ERZEGOVINA","MONTENEGRO","MACEDONIA DEL NORD","ALBANIA","KOSOVO","UCRAINA","MOLDAVIA","LITUANIA","LETTONIA","ESTONIA","ISLANDA","STATI UNITI","CANADA","MESSICO","BRASILE","ARGENTINA","CILE","URUGUAY","AUSTRALIA","NUOVA ZELANDA","GIAPPONE","CINA","COREA DEL SUD","INDIA","SUDAFRICA","EMIRATI ARABI UNITI","QATAR","ARABIA SAUDITA","ISRAELE","EGITTO","MAROCCO","TUNISIA","ALGERIA","TURCHIA"]; function loadCountries(){ const sel=document.getElementById("country"); const present=places.map(p=>String(p.country||"").trim()).filter(Boolean); const names=[...new Set([...WORLD_COUNTRIES,...present])].sort((a,b)=>a.localeCompare(b,"it")); names.forEach(c=>{let o=document.createElement("option");o.value=clean(c);o.textContent=c;sel.appendChild(o);}); } function loadRegions(){ const sel=document.getElementById("region"); sel.innerHTML=''; const country=clean(document.getElementById("country")?.value||""); const source=country?places.filter(p=>clean(p.country||"")===country):places; [...new Set(source.map(p=>p.region).filter(Boolean))].sort((a,b)=>a.localeCompare(b,"it")).forEach(r=>{let o=document.createElement("option");o.value=clean(r);o.textContent=r;sel.appendChild(o)}); } function updateRegionVisibility(){ const country=clean(document.getElementById("country")?.value||""); const region=document.getElementById("region"); // La selezione della regione è utile soprattutto per l'Italia; per gli altri Paesi la nascondiamo. const isItaly=!country||country==="ITALIA"; region.style.display=isItaly?"":"none"; if(!isItaly) region.value=""; loadRegions(); } function applyAdminInfo(p){ const o=adminOverrides.get(String(p._id)); if(!o)return p; ["name","province","region","address","phone","email","website"].forEach(k=>{if(o[k]!==null&&o[k]!==undefined)p[k]=o[k];}); p.notes=o.more_info||p.notes||""; p.more_info=o.more_info||""; p.facilities=o.facilities||p.facilities||""; p.specialties=Array.isArray(o.specialties)?o.specialties:(p.specialties||[]); p.photos=Array.isArray(o.photos)?o.photos:(p.photos||[]); return p; } function allPlaces(){ return places.filter(p=>!deletedTavKeys.has(String(p._id))).concat(submittedApproved.map(p=>applyAdminInfo({...p,_id:`submission-${p.id}`})).filter(p=>!deletedTavKeys.has(String(p._id)))); } const REGION_APPROX={ "ABRUZZO":{lat:42.35,lng:13.40},"BASILICATA":{lat:40.50,lng:16.10},"CALABRIA":{lat:39.05,lng:16.35},"CAMPANIA":{lat:40.90,lng:14.80},"EMILIA-ROMAGNA":{lat:44.50,lng:11.30},"FRIULI-VENEZIA GIULIA":{lat:46.10,lng:13.15},"LAZIO":{lat:42.00,lng:12.80},"LIGURIA":{lat:44.30,lng:8.90},"LOMBARDIA":{lat:45.50,lng:9.90},"MARCHE":{lat:43.50,lng:13.20},"MOLISE":{lat:41.65,lng:14.65},"PIEMONTE":{lat:45.05,lng:7.75},"PUGLIA":{lat:41.05,lng:16.80},"SARDEGNA":{lat:40.10,lng:9.10},"SICILIA":{lat:37.60,lng:14.00},"TOSCANA":{lat:43.45,lng:11.10},"TRENTINO-ALTO ADIGE":{lat:46.10,lng:11.15},"UMBRIA":{lat:42.95,lng:12.55},"VALLE D'AOSTA":{lat:45.74,lng:7.32},"VENETO":{lat:45.60,lng:11.95} }; function provisionalPosition(p,index){ if(Number.isFinite(p.lat)&&Number.isFinite(p.lng)) return {lat:p.lat,lng:p.lng,provisional:false}; // Punto SOLO VISIVO per non perdere il TAV dalla mappa: non è una geolocalizzazione. // Viene volutamente separato dai punti Google/manuali e sostituito appena il TAV viene geolocalizzato. const base=REGION_APPROX[String(p.region||"").toUpperCase()]||{lat:41.90,lng:12.50}; const n=Number(String(p._id||"").replace(/\\D/g,""))||index||1; const angle=(n*2.399963); const radius=0.22+((n%9)*0.035); return {lat:base.lat+Math.cos(angle)*radius,lng:base.lng+Math.sin(angle)*radius,provisional:true}; } function markerPosition(p,index){return provisionalPosition(p,index);} function statusFor(p){ const exact=Number.isFinite(p.lat)&&Number.isFinite(p.lng); if(!exact)return {label:"Da geolocalizzare",cls:"pending"}; if(p.admin_verified||p.coord_source==="Admin"||p.coord_source==="ADMIN")return {label:"Verificato manualmente",cls:"verified"}; if(p.coord_source==="Google Maps"||String(p.coord_source||"").toUpperCase().includes("GOOGLE"))return {label:"Google Maps",cls:"google"}; return {label:"Geolocalizzato",cls:"google"}; } function displayName(p){return String(p.name||"").replace(/\bNeoFitav\b/gi,"").replace(/\s{2,}/g," ").trim();} function markerIcon(p){const st=statusFor(p);let fill="#f59e0b";if(st.label==="Google Maps")fill="#3b82f6";if(st.label==="Verificato manualmente")fill="#ef4444";return {path:google.maps.SymbolPath.CIRCLE,scale:8,fillColor:fill,fillOpacity:0.95,strokeColor:"#ffffff",strokeWeight:2};} function render(){ const all=allPlaces(),q=clean(document.getElementById("q").value),country=clean(document.getElementById("country").value),region=clean(document.getElementById("region").value),geo=document.getElementById("geo").value; if(markers.length) markers.forEach(m=>m.setMap(null)); markers=[]; const filtered=all.filter(p=>{ const txt=clean(`${displayName(p)} ${p.province||""} ${p.region||""} ${p.address||""} ${p.country||""}`); if(q&&!txt.includes(q))return false; if(country&&clean(p.country||"")!==country)return false; if(region&&clean(p.region||"")!==region)return false; if(geo==="geo"&&!Number.isFinite(p.lat))return false;if(geo==="nogeo"&&Number.isFinite(p.lat))return false;return true; }); const exactCount=all.filter(p=>Number.isFinite(p.lat)&&Number.isFinite(p.lng)).length; document.getElementById("count").textContent=filtered.length; document.getElementById("stats").textContent=`${exactCount} con posizione · ${all.length-exactCount} da verificare`; const list=document.getElementById("list");list.innerHTML=""; filtered.forEach(p=>{ const el=document.createElement("div");el.className="item"+(String(selectedTavKey)===String(p._id)?" selected":"");el.dataset.tavKey=String(p._id); const st=statusFor(p); el.innerHTML=`${esc(displayName(p))} ${esc(st.label)}

${esc(p.province||"")} · ${esc(p.region||"")}

${isAdmin?'':''}

`; el.querySelector(".focus").onclick=()=>focusPlace(p); el.onclick=(ev)=>{if(ev.target.closest("button"))return;focusPlace(p);}; el.querySelector(".gmap").onclick=()=>window.open("https://www.google.com/maps/search/?api=1&query="+encodeURIComponent(`${displayName(p)} ${p.province||""} ${p.region||""} Italia`),"_blank"); const ae=el.querySelector(".adminEdit"); if(ae) ae.onclick=(ev)=>{ev.stopPropagation();openEditCoord(p);}; list.appendChild(el); }); filtered.forEach((p,index)=>{ const pos=markerPosition(p,index+1), exact=Number.isFinite(p.lat)&&Number.isFinite(p.lng), st=statusFor(p); const marker=new google.maps.Marker({map,position:{lat:pos.lat,lng:pos.lng},title:displayName(p),draggable:false,opacity:exact?1:0.48,icon:markerIcon(p)}); marker.__tavKey=p._id; marker.addListener("click",()=>focusPlace(p,marker));markers.push(marker); }); } function focusPlace(p,anchorMarker){ selectedTavKey=String(p._id); if(!anchorMarker){ anchorMarker=markers.find(m=>String(m.__tavKey)===String(p._id))||null; } document.querySelectorAll('.item.selected').forEach(el=>el.classList.remove('selected')); const selected=document.querySelector(`.item[data-tav-key="${CSS.escape(String(p._id))}"]`); if(selected){selected.classList.add('selected');selected.scrollIntoView({behavior:'smooth',block:'center'});} const pos=anchorMarker&&anchorMarker.getPosition() ? {lat:anchorMarker.getPosition().lat(),lng:anchorMarker.getPosition().lng()} : markerPosition(p,1); map.panTo(pos); map.setZoom(Number.isFinite(p.lat)&&Number.isFinite(p.lng)?16:11); const st=statusFor(p); const website=p.website||p.site||p.url||p.web||''; const websiteHtml=website?`
🌐 Sito internet`:""; const email=p.email?`
✉️ ${esc(p.email)}`:""; const phone=p.phone?`
☎️ ${esc(p.phone)}`:""; const address=p.address?`
📍 ${esc(p.address)}`:""; const info=p.more_info||p.notes?`

Maggiori informazioni
${esc(p.more_info||p.notes)}

`:""; const facilities=p.facilities?`

Campi disponibili
${esc(p.facilities).replace(/\\n/g,"
")}

`:""; const specialties=Array.isArray(p.specialties)&&p.specialties.length?`

Specialità
${p.specialties.map(x=>`${esc(x)}`).join("")}

`:""; const link=Number.isFinite(p.lat)&&Number.isFinite(p.lng)?`
Apri questa posizione in Google Maps ↗`:""; const photos=Array.isArray(p.photos)&&p.photos.length?`

${p.photos.slice(0,6).map(u=>`

`).join('')}

`:""; const edit=isAdmin?`

`:""; infoWindow.setContent(`

${esc(displayName(p))}

${esc(p.province||'')} · ${esc(p.region||'')}

${esc(st.label)}

${address}${websiteHtml}${email}${phone}${info}${facilities}${specialties}${photos}${link}${edit}

`); infoWindow.open({map,anchor:anchorMarker||undefined}); } function openEditCoordByKey(key){const p=allPlaces().find(x=>String(x._id)===String(key));if(p)openEditCoord(p);} document.getElementById("q").oninput=render;document.getElementById("country").onchange=()=>{updateRegionVisibility();render();};document.getElementById("region").onchange=render;document.getElementById("geo").onchange=render; document.getElementById("loginBtn").onclick=()=>openModal("authModal"); document.getElementById("addBtn").onclick=()=>{if(!currentUser){openModal("authModal");return}openModal("addModal")}; document.getElementById("switchAuth").onclick=()=>{ isSignup=!isSignup;document.getElementById("authTitle").textContent=isSignup?"Registrati":"Accedi"; document.getElementById("authAction").textContent=isSignup?"Crea account":"Accedi"; document.getElementById("switchAuth").textContent=isSignup?"Hai già un account? Accedi":"Non hai un account? Registrati"; }; document.getElementById("authAction").onclick=async()=>{ const email=document.getElementById("authEmail").value.trim(),password=document.getElementById("authPassword").value; const msg=document.getElementById("authMsg"); if(!sb){msg.textContent="Configura prima Supabase nel file.";return} let res=isSignup?await sb.auth.signUp({email,password}):await sb.auth.signInWithPassword({email,password}); if(res.error){msg.textContent=res.error.message;return} msg.textContent=isSignup?"Controlla la tua email per confermare l'account.":"Accesso effettuato."; if(!isSignup){closeModal("authModal");await updateAuthUI();await loadApprovedSubmissions()} }; async function logout(){if(sb)await sb.auth.signOut();await updateAuthUI();document.getElementById("adminBox").classList.remove("show")} async function uploadPhotos(files,folder){ if(!sb||!files?.length)return []; const urls=[]; for(const file of Array.from(files).slice(0,8)){ if(!file.type.startsWith("image/"))continue; const ext=(file.name.split(".").pop()||"jpg").toLowerCase().replace(/[^a-z0-9]/g,""); const path=`${folder}/${crypto.randomUUID()}.${ext}`; const {error}=await sb.storage.from("tav-photos").upload(path,file,{upsert:false,contentType:file.type}); if(error)throw error; const {data}=sb.storage.from("tav-photos").getPublicUrl(path); if(data?.publicUrl)urls.push(data.publicUrl); } return urls; } function previewFiles(input,targetId){const box=document.getElementById(targetId);box.innerHTML="";Array.from(input.files||[]).slice(0,8).forEach(f=>{if(!f.type.startsWith("image/"))return;const u=URL.createObjectURL(f);box.innerHTML+=` Anteprima

`;});} document.getElementById("fPhotos").addEventListener("change",e=>previewFiles(e.target,"addPhotoPreview")); document.getElementById("editPhotos").addEventListener("change",e=>previewFiles(e.target,"editPhotoPreview")); document.getElementById("applyGpsBtn").onclick=applyGpsCoordinates; function setupAddCountryFields(){ const sel=document.getElementById("fCountry"), region=document.getElementById("fRegion"); if(!sel||!region||sel.dataset.ready==="1") return; const present=places.map(p=>String(p.country||"").trim()).filter(Boolean); const names=[...new Set([...WORLD_COUNTRIES,...present])].sort((a,b)=>a.localeCompare(b,"it")); sel.innerHTML=''+names.map(c=>``).join(""); region.innerHTML=''; sel.addEventListener("change",()=>{ const c=clean(sel.value), italy=c==="ITALIA"; document.getElementById("fRegionWrap").style.display=italy?"":"none"; region.required=italy; if(!italy){region.value=""; return;} const regs=[...new Set(places.filter(p=>clean(p.country||"")===c).map(p=>p.region).filter(Boolean))].sort((a,b)=>a.localeCompare(b,"it")); region.innerHTML=''+regs.map(r=>``).join(""); }); sel.dataset.ready="1"; } const _openModal=window.openModal; window.openModal=function(id){ _openModal(id); if(id==="addModal") setupAddCountryFields(); }; async function submitTav(){ if(!sb||!currentUser){document.getElementById("addMsg").textContent="Devi essere autenticato.";return} const country=document.getElementById("fCountry").value.trim(); const italy=clean(country)==="ITALIA"; const region=document.getElementById("fRegion").value.trim(); const coords=document.getElementById("fCoords").value.trim().split(",").map(Number); const files=document.getElementById("fPhotos").files; const lat=coords[0], lng=coords[1]; const msg=document.getElementById("addMsg"); if(!document.getElementById("fName").value.trim()||!country||(italy&&!region)||!Number.isFinite(lat)||!Number.isFinite(lng)||lat<-90||lat>90||lng<-180||lng>180){ msg.textContent=italy?"Nome, nazione, regione e coordinate GPS valide sono obbligatori.":"Nome, nazione e coordinate GPS valide sono obbligatori."; return; } try{ const photos=await uploadPhotos(files,`submissions/${currentUser.id}`); const row={ user_id:currentUser.id, name:document.getElementById("fName").value.trim(), country, province:document.getElementById("fProvince").value.trim()||null, region:italy?region:null, address:document.getElementById("fAddress").value.trim()||null, phone:document.getElementById("fPhone").value.trim()||null, email:document.getElementById("fEmail").value.trim()||null, website:document.getElementById("fWebsite").value.trim()||null, notes:document.getElementById("fNotes").value.trim()||null, facilities:document.getElementById("fFacilities").value.trim()||null, specialties:document.getElementById("fSpecialties").value.split(",").map(x=>x.trim()).filter(Boolean), photos,lat,lng,status:"pending" }; const {error}=await sb.from("tav_submissions").insert(row);if(error)throw error; msg.textContent="Proposta inviata. Sarà visibile nella mappa dopo l'approvazione."; setTimeout(()=>closeModal("addModal"),1000); }catch(e){msg.textContent=e.message||"Errore durante il caricamento.";} } document.getElementById("submitTav").onclick=submitTav; async function loadPending(){ if(!sb||!isAdmin)return; const {data,error}=await sb.from("tav_submissions").select("*").eq("status","pending").order("created_at",{ascending:true}); const box=document.getElementById("pendingList"); if(error){box.innerHTML='

Errore caricamento proposte.

';return} if(!data?.length){box.innerHTML='

Nessuna proposta in attesa.

';return} box.innerHTML=data.map(p=>`

${esc(p.name)}

${esc(p.province)} · ${esc(p.region)}${p.address?" · "+esc(p.address):""}
${esc(p.notes||"")}${p.facilities?"
Campi: "+esc(p.facilities):""}${Array.isArray(p.specialties)&&p.specialties.length?"
Specialità: "+esc(p.specialties.join(", ")): ""}

`).join(""); } let editTarget=null,editMarker=null,editMap=null,editGeocoder=null; function openEditCoord(p){ if(!isAdmin||!currentUser){alert("Operazione riservata all'amministratore.");return;} if(!window.google||!google.maps){alert("Google Maps non è ancora pronta. Attendi il caricamento della mappa.");return;} editTarget=p; document.getElementById("editCoordName").textContent=`${displayName(p)} — ${p.province||""}, ${p.region||""}`; document.getElementById("editName").value=displayName(p);document.getElementById("editProvince").value=p.province||"";document.getElementById("editRegion").value=p.region||"";document.getElementById("editAddress").value=p.address||"";document.getElementById("editPhone").value=p.phone||"";document.getElementById("editEmail").value=p.email||"";document.getElementById("editWebsite").value=p.website||p.site||p.url||p.web||"";document.getElementById("editMoreInfo").value=p.more_info||p.notes||"";document.getElementById("editFacilities").value=p.facilities||"";document.getElementById("editSpecialties").value=Array.isArray(p.specialties)?p.specialties.join(", "):(p.specialties||"");document.getElementById("editSource").value=p.admin_note||"";document.getElementById("editPhotos").value="";document.getElementById("editPhotoPreview").innerHTML=(p.photos||[]).map(u=>`

`).join("");document.getElementById("editCoordMsg").textContent=""; openModal("editCoordModal");setTimeout(()=>{initCoordEditor(p);if(editMap)google.maps.event.trigger(editMap,"resize");},120); } function initCoordEditor(p){ if(!window.google||!google.maps)return; editGeocoder=editGeocoder||new google.maps.Geocoder(); const lat=Number.isFinite(p.lat)?p.lat:null,lng=Number.isFinite(p.lng)?p.lng:null,fallback=markerPosition(p,1); const show=(pos,zoom=15)=>{if(!editMap){editMap=new google.maps.Map(document.getElementById("coordEditorMap"),{center:pos,zoom,mapTypeControl:true,streetViewControl:false,fullscreenControl:true});}else{editMap.setCenter(pos);editMap.setZoom(zoom);}if(editMarker)editMarker.setMap(null);editMarker=new google.maps.Marker({map:editMap,position:pos,draggable:true,title:"Trascina il puntatore sul TAV"});editMarker.addListener("dragend",()=>syncEditorCoords(editMarker.getPosition()));syncEditorCoords(editMarker.getPosition());}; if(lat!==null&&lng!==null){show({lat,lng},17);return;}show(fallback,10); const queries=buildGeocodeQueries(p);editGeocoder.geocode({address:queries[0]},(res,status)=>{if(status==="OK"&&res[0]){const g=res[0].geometry.location;show({lat:g.lat(),lng:g.lng()},15);document.getElementById("editCoordMsg").textContent="Posizione iniziale trovata da Google: controllala e trascina il marker prima di salvare.";}else document.getElementById("editCoordMsg").textContent="Nessuna posizione automatica affidabile: sposta il marker manualmente.";}); } function applyGpsCoordinates(){ const lat=Number(document.getElementById("editLat").value),lng=Number(document.getElementById("editLng").value); const msg=document.getElementById("editCoordMsg"); if(!Number.isFinite(lat)||!Number.isFinite(lng)||lat<-90||lat>90||lng<-180||lng>180){ msg.textContent="Inserisci coordinate valide: latitudine da -90 a 90 e longitudine da -180 a 180."; return; } const pos={lat,lng}; if(!editMap){ editMap=new google.maps.Map(document.getElementById("coordEditorMap"),{center:pos,zoom:17,mapTypeControl:true,streetViewControl:false,fullscreenControl:true}); }else{editMap.setCenter(pos);editMap.setZoom(17);} if(editMarker) editMarker.setMap(null); editMarker=new google.maps.Marker({map:editMap,position:pos,draggable:true,title:"Trascina il puntatore sul TAV"}); editMarker.addListener("dragend",()=>syncEditorCoords(editMarker.getPosition())); syncEditorCoords(editMarker.getPosition()); msg.textContent="Posizione impostata dalle coordinate GPS. Puoi ancora trascinare il marker per correggerla."; } function syncEditorCoords(pos){if(!pos)return;document.getElementById("editLat").value=pos.lat().toFixed(6);document.getElementById("editLng").value=pos.lng().toFixed(6);} async function saveAdminCoord(){ if(!isAdmin||!currentUser||!editTarget){document.getElementById("editCoordMsg").textContent="Operazione riservata all'amministratore.";return;} const lat=Number(document.getElementById("editLat").value),lng=Number(document.getElementById("editLng").value),note=document.getElementById("editSource").value.trim(); if(!Number.isFinite(lat)||!Number.isFinite(lng)||lat<-90||lat>90||lng<-180||lng>180){document.getElementById("editCoordMsg").textContent="Sposta il marker su una posizione valida.";return;} if(!sb){document.getElementById("editCoordMsg").textContent="Backend non configurato.";return;} try{ const files=document.getElementById("editPhotos").files, photos=[...(editTarget.photos||[])]; const newPhotos=await uploadPhotos(files,`admin/${String(editTarget._id).replace(/[^a-zA-Z0-9_-]/g,"_")}`);photos.push(...newPhotos); const key=String(editTarget._id); const {error:ie}=await sb.from("tav_admin_overrides").upsert({tav_key:key,name:document.getElementById("editName").value.trim(),province:document.getElementById("editProvince").value.trim()||null,region:document.getElementById("editRegion").value.trim()||null,address:document.getElementById("editAddress").value.trim()||null,phone:document.getElementById("editPhone").value.trim()||null,email:document.getElementById("editEmail").value.trim()||null,website:document.getElementById("editWebsite").value.trim()||null,more_info:document.getElementById("editMoreInfo").value.trim()||null,facilities:document.getElementById("editFacilities").value.trim()||null,specialties:document.getElementById("editSpecialties").value.split(",").map(x=>x.trim()).filter(Boolean),photos,updated_by:currentUser.id,updated_at:new Date().toISOString()},{onConflict:"tav_key"}); if(ie)throw ie; const {error:ce}=await sb.from("tav_coordinate_overrides").upsert({tav_key:key,name:document.getElementById("editName").value.trim(),province:document.getElementById("editProvince").value.trim()||null,region:document.getElementById("editRegion").value.trim()||null,lat,lng,note:note||"Verifica amministratore",verified_by:currentUser.id,verified_at:new Date().toISOString()},{onConflict:"tav_key"}); if(ce)throw ce; editTarget.name=document.getElementById("editName").value.trim();editTarget.province=document.getElementById("editProvince").value.trim();editTarget.region=document.getElementById("editRegion").value.trim();editTarget.address=document.getElementById("editAddress").value.trim();editTarget.phone=document.getElementById("editPhone").value.trim();editTarget.email=document.getElementById("editEmail").value.trim();editTarget.website=document.getElementById("editWebsite").value.trim();editTarget.more_info=document.getElementById("editMoreInfo").value.trim();editTarget.facilities=document.getElementById("editFacilities").value.trim();editTarget.specialties=document.getElementById("editSpecialties").value.split(",").map(x=>x.trim()).filter(Boolean);editTarget.photos=photos;editTarget.lat=lat;editTarget.lng=lng;editTarget.coord_source="Admin";editTarget.precision="Verificato manualmente";editTarget.admin_verified=true;editTarget.admin_note=note; adminOverrides.set(key,{tav_key:key,name:editTarget.name,province:editTarget.province,region:editTarget.region,address:editTarget.address,phone:editTarget.phone,email:editTarget.email,website:editTarget.website,more_info:editTarget.more_info,facilities:editTarget.facilities,specialties:editTarget.specialties,photos}); try{localStorage.removeItem(autoGeoKey(editTarget));}catch(e){} if(editMarker)editMarker.setMap(null);closeModal("editCoordModal");render();focusPlace(editTarget); }catch(e){document.getElementById("editCoordMsg").textContent=e.message||"Errore durante il salvataggio.";} } async function deleteTav(){ if(!isAdmin||!currentUser||!editTarget){alert("Operazione riservata all'amministratore.");return;} const name=displayName(editTarget); if(!confirm(`Sei sicuro di voler eliminare "${name}"?\n\nIl TAV verrà rimosso dalla mappa e dall'elenco.`)) return; if(!sb){document.getElementById("editCoordMsg").textContent="Backend non configurato.";return;} const key=String(editTarget._id); try{ const {error:di}=await sb.from("tav_deleted").upsert({tav_key:key,deleted_by:currentUser.id,deleted_at:new Date().toISOString()},{onConflict:"tav_key"}); if(di) throw di; await sb.from("tav_coordinate_overrides").delete().eq("tav_key",key); await sb.from("tav_admin_overrides").delete().eq("tav_key",key); if(key.startsWith("submission-")){ const submissionId=key.replace(/^submission-/,""); await sb.from("tav_submissions").delete().eq("id",submissionId); } deletedTavKeys.add(key); submittedApproved=submittedApproved.filter(x=>String(x._id)!==key); places=places.filter(x=>String(x._id)!==key); if(editMarker) editMarker.setMap(null); closeModal("editCoordModal"); render(); document.getElementById("adminBox").classList.add("show"); if(isAdmin) loadPending(); }catch(e){ document.getElementById("editCoordMsg").textContent=e.message||"Errore durante l'eliminazione."; } } document.getElementById("deleteTavBtn").onclick=deleteTav; document.getElementById("saveCoordBtn").onclick=saveAdminCoord; function buildGeocodeQueries(p){ const name=displayName(p).replace(/\bNEOFITAV\b/gi,"").replace(/\s+/g," ").trim(); const core=(p.core||name).replace(/\bNEOFITAV\b/gi,"").replace(/\s+/g," ").trim(); const prov=p.province||"", reg=p.region||"", country=p.country||"Italia"; const suffix=[prov,reg,country].filter(Boolean).join(", "); // Prima le formule richieste dall'amministratore: A.S.D. T.A.V. + nome. return [ `A.S.D. T.A.V. ${core}, ${suffix}`, `A.S.D. T.A.V. ${name}, ${suffix}`, `A.S.D. T.A.V. ${core}, ${reg}, ${prov}, ${country}`, `A.S.D. TAV ${core}, ${suffix}`, `A.S.D. Tiro A Volo ${core}, ${suffix}`, `T.A.V. ${core}, ${suffix}`, `Tiro A Volo ${core}, ${suffix}`, `A.S.D. ${core}, ${suffix}`, `${name}, ${suffix}` ]; } function geocodeOne(p){ return new Promise(resolve=>{ const queries=buildGeocodeQueries(p); let qi=0; const goodTypes=new Set(["establishment","point_of_interest","premise","street_address","route","subpremise"]); const badOnly=new Set(["country","administrative_area_level_1","administrative_area_level_2","administrative_area_level_3","locality","postal_code","political"]); const tokens=clean(`${p.core||p.name||""}`).split(/[^A-Z0-9]+/).filter(x=>x.length>=4); const score=(r,q)=>{ const types=r.types||[]; const comps=r.address_components||[]; if(types.every(t=>badOnly.has(t))) return -999; if(!types.some(t=>goodTypes.has(t))) return -999; const expectedCountry=clean(p.country||"ITALIA"); const resultCountry=clean((comps.find(c=>(c.types||[]).includes("country"))||{}).long_name||""); if(expectedCountry==="ITALIA" && resultCountry && !["ITALIA","ITALY"].includes(resultCountry))return -999; const hay=clean(`${r.formatted_address||""} ${r.name||""} ${q}`); let sc=0; tokens.forEach(t=>{if(hay.includes(t))sc+=8;}); const prov=clean(p.province||""); const reg=clean(p.region||""); if(prov&&hay.includes(prov))sc+=12; if(reg&&hay.includes(reg))sc+=8; if(types.includes("point_of_interest"))sc+=15; if(types.includes("establishment"))sc+=12; if(types.includes("premise"))sc+=8; if(types.includes("street_address"))sc+=7; if(types.includes("route"))sc+=3; if(r.partial_match)sc-=10; if(r.geometry?.location_type==="ROOFTOP")sc+=20; if(r.geometry?.location_type==="RANGE_INTERPOLATED")sc+=8; if(r.geometry?.location_type==="GEOMETRIC_CENTER")sc+=2; if(r.geometry?.location_type==="APPROXIMATE")sc-=2; return sc; }; const next=()=>{ if(qi>=queries.length){resolve(null);return;} const q=queries[qi++]; const countryCode=(clean(p.country||"")==="ITALIA")?"IT":undefined; const req={address:q}; if(countryCode) req.componentRestrictions={country:countryCode}; geocoder.geocode(req,(res,status)=>{ if(status==="OK"&&Array.isArray(res)&&res.length){ const ranked=res.map(r=>({r,s:score(r,q)})).filter(x=>x.s>-999).sort((a,b)=>b.s-a.s); if(ranked.length&&ranked[0].s>=10){ const r=ranked[0].r; resolve({lat:r.geometry.location.lat(),lng:r.geometry.location.lng(),query:q,types:r.types||[],formatted:r.formatted_address||"",locationType:r.geometry.location_type||"",score:ranked[0].s}); return; } } next(); }); }; next(); }); } function autoGeoKey(p){return "tav_auto_geo_"+String(p._id);} function readAutoGeo(p){ try{const v=localStorage.getItem(autoGeoKey(p)); return v?JSON.parse(v):null;}catch(e){return null;} } function writeAutoGeo(p,hit){ try{localStorage.setItem(autoGeoKey(p),JSON.stringify(hit));}catch(e){} } function applyAutoGeoCache(){ let n=0; places.forEach(p=>{ if(Number.isFinite(p.lat)&&Number.isFinite(p.lng)) return; const h=readAutoGeo(p); if(h&&Number.isFinite(h.lat)&&Number.isFinite(h.lng)){ p.lat=h.lat;p.lng=h.lng;p.coord_source="Google Maps";p.precision="Geolocalizzato";p.admin_verified=false;p.auto_geo=true;n++; } }); if(n) render(); return n; } async function geocodeMissing(opts={}){ if(geocodeRunning||!geocoder)return; geocodeRunning=true; const btn=document.getElementById("geocodeMissingBtn"),msg=document.getElementById("geocodeMsg"),autoMsg=document.getElementById("autoGeoStatus"); if(btn)btn.disabled=true; const missing=places.filter(p=>!Number.isFinite(p.lat)||!Number.isFinite(p.lng)); let done=0,found=0; const concurrency=3; const worker=async()=>{ while(true){ const i=done++; if(i>=missing.length)return; const p=missing[i]; const text=`Geolocalizzazione ${Math.min(i+1,missing.length)}/${missing.length}: ${displayName(p)}`; if(msg)msg.textContent=text; if(autoMsg)autoMsg.textContent="🔎 Ricerca automatica Google: "+text; const hit=await geocodeOne(p); if(hit){ p.lat=hit.lat;p.lng=hit.lng;p.coord_source="Google Maps";p.precision="Geolocalizzato";p.admin_verified=false;p.auto_geo=true; writeAutoGeo(p,hit); found++; } render(); } }; await Promise.all(Array.from({length:Math.min(concurrency,missing.length)},()=>worker())); if(msg)msg.textContent=`Operazione completata: ${found} nuove posizioni trovate su ${missing.length} TAV.`; if(autoMsg)autoMsg.textContent=`✓ Geolocalizzazione automatica completata: ${found} posizioni trovate. Quelle non trovate restano da verificare.`; if(btn)btn.disabled=false; geocodeRunning=false; } document.getElementById("geocodeMissingBtn").onclick=()=>geocodeMissing({manual:true}); async function autoGeocodeFirstLoad(){ if(!geocoder||geocodeRunning)return; const cached=applyAutoGeoCache(); const missing=places.filter(p=>!Number.isFinite(p.lat)||!Number.isFinite(p.lng)); if(!missing.length){ const el=document.getElementById("autoGeoStatus");if(el)el.textContent="✓ Tutti i TAV hanno già una posizione."; return; } const el=document.getElementById("autoGeoStatus"); if(el)el.textContent=`🔎 Prima geolocalizzazione automatica: ${missing.length} TAV ancora da cercare…`; await geocodeMissing({auto:true}); } function excelSafe(v){ if(v===null||v===undefined) return ""; if(Array.isArray(v)) return v.join(", "); if(typeof v==="object") return JSON.stringify(v); return v; } async function backupCompleteExcel(){ if(!isAdmin || !currentUser){ alert("Il backup è riservato all'amministratore."); return; } if(!sb){ alert("Backend Supabase non configurato."); return; } const btn=document.getElementById("backupExcelBtn"); const oldText=btn?btn.textContent:""; if(btn){btn.disabled=true;btn.textContent="⏳ Preparazione backup...";} try{ const [ {data:coord,error:coordErr}, {data:info,error:infoErr}, {data:approved,error:approvedErr}, {data:deleted,error:deletedErr} ]=await Promise.all([ sb.from("tav_coordinate_overrides").select("*"), sb.from("tav_admin_overrides").select("*"), sb.from("tav_submissions").select("*").eq("status","approved").order("created_at",{ascending:true}), sb.from("tav_deleted").select("*") ]); const errors=[coordErr,infoErr,approvedErr,deletedErr].filter(Boolean); if(errors.length) throw errors[0]; const coordMap=new Map((coord||[]).map(x=>[String(x.tav_key),x])); const infoMap=new Map((info||[]).map(x=>[String(x.tav_key),x])); // Effective dataset: original 369 records + approved user submissions, // with administrator data/coordinates applied exactly as the map does. const baseRows=places .filter(p=>!deletedTavKeys.has(String(p._id))) .map(p=>{ const c=coordMap.get(String(p._id))||{}; const o=infoMap.get(String(p._id))||{}; const row={...p}; if(o.name!==undefined&&o.name!==null) row.name=o.name; if(o.province!==undefined&&o.province!==null) row.province=o.province; if(o.region!==undefined&&o.region!==null) row.region=o.region; if(o.address!==undefined&&o.address!==null) row.address=o.address; if(o.phone!==undefined&&o.phone!==null) row.phone=o.phone; if(o.email!==undefined&&o.email!==null) row.email=o.email; if(o.more_info!==undefined&&o.more_info!==null) row.more_info=o.more_info; if(o.facilities!==undefined&&o.facilities!==null) row.facilities=o.facilities; if(o.specialties!==undefined&&o.specialties!==null) row.specialties=o.specialties; if(o.photos!==undefined&&o.photos!==null) row.photos=o.photos; if(c.lat!==undefined&&c.lat!==null) row.lat=c.lat; if(c.lng!==undefined&&c.lng!==null) row.lng=c.lng; if(c.note!==undefined&&c.note!==null) row.admin_note=c.note; row.coord_status=Number.isFinite(Number(row.lat))&&Number.isFinite(Number(row.lng)) ? (c.tav_key ? (String(c.note||"").startsWith("AUTO_GOOGLE") ? "Google Maps" : "Verificato manualmente") : (row.coord_source||"")) : "Da verificare"; return row; }); const approvedRows=(approved||[]) .map(p=>({...p,_id:`submission-${p.id}`})) .filter(p=>!deletedTavKeys.has(String(p._id))) .map(p=>{ const c=coordMap.get(String(p._id))||{}; const o=infoMap.get(String(p._id))||{}; const row={...p}; if(o.name!==undefined&&o.name!==null) row.name=o.name; if(o.province!==undefined&&o.province!==null) row.province=o.province; if(o.region!==undefined&&o.region!==null) row.region=o.region; if(o.address!==undefined&&o.address!==null) row.address=o.address; if(o.phone!==undefined&&o.phone!==null) row.phone=o.phone; if(o.email!==undefined&&o.email!==null) row.email=o.email; if(o.more_info!==undefined&&o.more_info!==null) row.more_info=o.more_info; if(o.facilities!==undefined&&o.facilities!==null) row.facilities=o.facilities; if(o.specialties!==undefined&&o.specialties!==null) row.specialties=o.specialties; if(o.photos!==undefined&&o.photos!==null) row.photos=o.photos; if(c.lat!==undefined&&c.lat!==null) row.lat=c.lat; if(c.lng!==undefined&&c.lng!==null) row.lng=c.lng; if(c.note!==undefined&&c.note!==null) row.admin_note=c.note; row.coord_status=Number.isFinite(Number(row.lat))&&Number.isFinite(Number(row.lng)) ? (c.tav_key ? (String(c.note||"").startsWith("AUTO_GOOGLE") ? "Google Maps" : "Verificato manualmente") : "GPS proposta approvata") : "Da verificare"; return row; }); const effective=[...baseRows,...approvedRows]; const effectiveCols=[ "_id","country","region","province","name","address","phone","email","website","site","url","web", "notes","more_info","facilities","specialties","photos","lat","lng","coord_source","precision", "coord_status","admin_verified","admin_note","auto_geo","core","user_id","status","created_at", "reviewed_by","reviewed_at" ]; const toRows=(rows,cols=effectiveCols)=>rows.map(r=>{ const o={}; cols.forEach(k=>o[k]=excelSafe(r[k])); return o; }); const originalRows=places.map(p=>{ const o={}; Object.keys(p).forEach(k=>o[k]=excelSafe(p[k])); return o; }); const coordRows=(coord||[]).map(r=>Object.fromEntries(Object.keys(r).map(k=>[k,excelSafe(r[k])]))); const infoRows=(info||[]).map(r=>Object.fromEntries(Object.keys(r).map(k=>[k,excelSafe(r[k])]))); const approvedRaw=(approved||[]).map(r=>Object.fromEntries(Object.keys(r).map(k=>[k,excelSafe(r[k])]))); const deletedRaw=(deleted||[]).map(r=>Object.fromEntries(Object.keys(r).map(k=>[k,excelSafe(r[k])]))); const wb=XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(toRows(effective)),"TAV_COMPLETI"); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(originalRows),"DATI_ORIGINALI"); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(infoRows),"OVERRIDE_DATI_ADMIN"); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(coordRows),"OVERRIDE_COORDINATE"); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(approvedRaw),"PROPOSTE_APPROVATE"); XLSX.utils.book_append_sheet(wb,XLSX.utils.json_to_sheet(deletedRaw),"TAV_ELIMINATI"); // Add a small metadata sheet so the backup date/source are unambiguous. const meta=[ ["Backup completo TAV",""], ["Data/ora backup",new Date().toISOString()], ["Amministratore",currentUser.email||currentUser.id||""], ["TAV effettivi inclusi",effective.length], ["Record originali",originalRows.length], ["Override dati admin",infoRows.length], ["Override coordinate",coordRows.length], ["Proposte approvate",approvedRaw.length], ["TAV eliminati",deletedRaw.length], ["Nota","TAV_COMPLETI contiene i dati effettivi risultanti dall'unione dei dati iniziali con gli override salvati in Supabase."], ["Nota","Gli altri fogli conservano i dati sorgente/override necessari per un backup completo."] ]; XLSX.utils.book_append_sheet(wb,XLSX.utils.aoa_to_sheet(meta),"INFO_BACKUP"); const stamp=new Date().toISOString().replace(/[:.]/g,"-").slice(0,19); XLSX.writeFile(wb,`BACKUP_COMPLETO_TAV_${stamp}.xlsx`); }catch(e){ console.error("Backup Excel:",e); alert("Errore durante il backup Excel: "+(e.message||e)); }finally{ if(btn){btn.disabled=false;btn.textContent=oldText||"💾 Backup completo Excel";} } } document.getElementById("backupExcelBtn").onclick=backupCompleteExcel; async function moderate(id,status){ if(!sb||!isAdmin)return; const {error}=await sb.from("tav_submissions").update({status,reviewed_by:currentUser.id,reviewed_at:new Date().toISOString()}).eq("id",id); if(error)alert(error.message);else{await loadPending();await loadApprovedSubmissions();} } async function toggleAdmin(){document.getElementById("adminBox").classList.toggle("show");if(isAdmin)loadPending()} if(sb)sb.auth.onAuthStateChange(()=>setTimeout(async()=>{await updateAuthUI();render();},0));

🛡️ Modifica TAV

Accedi

Proponi un nuovo TAV