const SHEET_URL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vQQyw-owPjlAQrUIHP9LgWd4lNUH3eVEJAlUPBB9w_yUE9NJ46R75C9A0JHEj8G9_JjfXtfFTnGbAnZ/pub?output=csv"; const CACHE_KEY = "oleon_property_insights_html"; const CACHE_TIME_KEY = "oleon_property_insights_time"; const CACHE_DURATION = 1000 * 60 * 30; // 30 mins function parseCSVLine(line) { const result = []; let current = ""; let inQuotes = false; for (let i = 0; i < line.length; i++) { const char = line[i]; const nextChar = line[i + 1]; if (char === '"' && inQuotes && nextChar === '"') { current += '"'; i++; } else if (char === '"') { inQuotes = !inQuotes; } else if (char === ',' && !inQuotes) { result.push(current.trim()); current = ""; } else { current += char; } } result.push(current.trim()); return result; } function formatUKDate(dateStr) { if (!dateStr) return ""; const parts = dateStr.split("/"); if (parts.length === 3) { const day = parts[0]; const month = parts[1]; const year = parts[2]; const parsedDate = new Date(`${year}-${month}-${day}`); if (!isNaN(parsedDate)) { return parsedDate.toLocaleDateString("en-GB", { day: "numeric", month: "long", year: "numeric" }); } } return dateStr; } function buildHTML(data) { const rows = data.trim().split("\n").slice(1); let html = ""; rows.forEach(row => { if (!row.trim()) return; const cols = parseCSVLine(row); if (cols.length < 6) return; const image = cols[0]?.replace(/^"|"$/g, "").trim(); const title = cols[1]?.replace(/^"|"$/g, "").trim(); const desc = cols[2]?.replace(/^"|"$/g, "").trim(); const link = cols[3]?.replace(/^"|"$/g, "").trim(); const rawDate = cols[4]?.replace(/^"|"$/g, "").trim(); const status = cols[5]?.replace(/^"|"$/g, "").trim().toLowerCase(); const date = formatUKDate(rawDate); if (status !== "live") return; if (!title || !link) return; const isOleonLink = link.startsWith("https://oleonproperties.com") || link.startsWith("https://www.oleonproperties.com") || link.startsWith("/"); const cardLink = link.replace(/^https:\/\/(?:www\.)?oleonproperties\.com/, "") || "/"; html += `

${title}

${desc}

Continue Reading →

`; }); return html || "

No insights available.

"; } const container = document.getElementById("insights"); const cachedHTML = localStorage.getItem(CACHE_KEY); const cachedTime = localStorage.getItem(CACHE_TIME_KEY); const now = Date.now(); if (cachedHTML && cachedTime && (now - cachedTime < CACHE_DURATION)) { container.innerHTML = cachedHTML; } fetch(SHEET_URL) .then(response => response.text()) .then(data => { const html = buildHTML(data); container.innerHTML = html; localStorage.setItem(CACHE_KEY, html); localStorage.setItem(CACHE_TIME_KEY, now.toString()); }) .catch(error => { console.error("Error loading insights:", error); if (!cachedHTML) { container.innerHTML = "

Unable to load insights right now.

"; } });

Property Insights