/* ============================================================================ export.jsx — the Data Export ecosystem. Tier A · Quick Report (journalists): printable HTML/PDF with a map snapshot, the top memories, and summary statistics. Tier B · Structured Dataset (researchers): CSV / JSON / GeoJSON of the full metadata for every filtered result, moderation status included. Privacy: only public, already-published data is serialised — no raw uploads, names, or IPs ever leave the archive. ============================================================================ */ // ---- the canonical export row (pure function of a memory) ------------------ const EXPORT_COLS = [ "id", "latitude", "longitude", "year", "month", "day", "category", "tags", "timestamp_submitted", "hash_arweave", "media_url", "is_verified", "language", "ward", "content_type", "text_vi", "text_en", ]; function deriveRow(m) { const d = parseMemoryDate(m); const verified = isVerified(m); const media = memoryMedia(m); const hash = verified ? arweaveHash(m.id) : ""; const media_url = media === "text" ? "" : (verified ? "https://arweave.net/" + hash : ""); return { id: m.id, latitude: +(+m.lat).toFixed(5), longitude: +(+m.lng).toFixed(5), year: d.year, month: d.month, // null when unknown day: d.day, // null when unknown category: catOf(m.cat).en, tags: deriveTags(m), timestamp_submitted: submittedISO(m), hash_arweave: hash || null, media_url: media_url || null, is_verified: verified, language: memoryLang(m), ward: m.ward || null, content_type: media, text_vi: m.vi || "", text_en: m.en || "", }; } // ---- serialisers ----------------------------------------------------------- function csvCell(v) { if (v == null) return ""; if (Array.isArray(v)) v = v.join(";"); v = String(v); return /[",\n]/.test(v) ? '"' + v.replace(/"/g, '""') + '"' : v; } function toCSV(rows) { const head = EXPORT_COLS.join(","); const body = rows.map((r) => EXPORT_COLS.map((c) => csvCell(r[c])).join(",")).join("\n"); return head + "\n" + body + "\n"; } function toJSON(rows) { return JSON.stringify({ archive: "Miền Ký Ức — Memory Lane", generated: new Date().toISOString(), privacy: "Public testimony only. Names and IPs stripped.", count: rows.length, records: rows, }, null, 2); } function toGeoJSON(rows) { return JSON.stringify({ type: "FeatureCollection", generated: new Date().toISOString(), features: rows.map((r) => { const props = { ...r }; delete props.latitude; delete props.longitude; return { type: "Feature", geometry: { type: "Point", coordinates: [r.longitude, r.latitude] }, properties: props }; }), }, null, 2); } function downloadText(name, text, mime) { const blob = new Blob([text], { type: mime + ";charset=utf-8" }); const url = URL.createObjectURL(blob); const a = document.createElement("a"); a.href = url; a.download = name; document.body.appendChild(a); a.click(); a.remove(); setTimeout(() => URL.revokeObjectURL(url), 3000); } // ---- statistics ------------------------------------------------------------ function computeStats(results) { const total = results.length; const verified = results.filter(isVerified).length; const byCat = {}; CATS.forEach((c) => (byCat[c.key] = 0)); const byYear = {}; results.forEach((m) => { byCat[m.cat] = (byCat[m.cat] || 0) + 1; const y = parseMemoryDate(m).year || 0; byYear[y] = (byYear[y] || 0) + 1; }); const peak = Object.entries(byYear).map(([y, n]) => [+y, n]).sort((a, b) => b[1] - a[1]).slice(0, 3); const years = Object.keys(byYear).map(Number).filter(Boolean); const span = years.length ? [Math.min(...years), Math.max(...years)] : null; return { total, verified, unverified: total - verified, byCat, byYear, peak, span }; } function topMemories(results, n) { return results.slice().sort((a, b) => (parseMemoryDate(b).year - parseMemoryDate(a).year) || (isVerified(b) - isVerified(a)) ).slice(0, n); } // ---- filter summary (human readable) -------------------------------------- function summarizeFilters(lang, range, adv, shape, compiled) { const S = STR[lang]; const out = []; const mm = (m) => (m == null ? "" : "-" + String(m).padStart(2, "0")); out.push(`${S.temporal}: ${range[0]}${mm(adv.fM)}${adv.precision === "day" ? mm(adv.fD) : ""} → ${range[1]}${mm(adv.tM)}${adv.precision === "day" ? mm(adv.tD) : ""}`); if (shape) out.push(shape.type === "circle" ? `${S.spatial}: ◯ ${shape.radius >= 1000 ? (shape.radius / 1000).toFixed(2) + "km" : Math.round(shape.radius) + "m"}` : `${S.spatial}: ⬡ ${shape.latlngs.length} ${S.points}`); if (adv.query.trim()) out.push(`${S.textSearch}: ${adv.query.trim()}`); if (adv.cats.length) out.push(`${S.category}: ${adv.cats.map((k) => catOf(k)[lang]).join(", ")}`); if (adv.content.length) out.push(`${S.fContent}: ${adv.content.join(", ")}`); if (adv.langs.length) out.push(`${S.fLang}: ${adv.langs.join(", ")}`); if (adv.status !== "all") out.push(`${S.fStatus}: ${adv.status === "verified" ? S.stVer : S.stUnver}`); return out; } // ---- map snapshot (SVG, equirectangular within result bbox) ---------------- function buildSnapshotSVG(results, shape) { const W = 680, H = 384, pad = 34; const pts = results.map((m) => [m.lat, m.lng]); let lats = pts.map((p) => p[0]), lngs = pts.map((p) => p[1]); if (shape && shape.type === "polygon") { shape.latlngs.forEach((p) => { lats.push(p[0]); lngs.push(p[1]); }); } if (shape && shape.type === "circle") { lats.push(shape.center[0]); lngs.push(shape.center[1]); } if (!lats.length) { lats = [HANOI_CENTER[0]]; lngs = [HANOI_CENTER[1]]; } let minLat = Math.min(...lats), maxLat = Math.max(...lats), minLng = Math.min(...lngs), maxLng = Math.max(...lngs); let dLat = maxLat - minLat, dLng = maxLng - minLng; if (dLat < 0.004) { const c = (minLat + maxLat) / 2; minLat = c - 0.004; maxLat = c + 0.004; dLat = 0.008; } if (dLng < 0.004) { const c = (minLng + maxLng) / 2; minLng = c - 0.004; maxLng = c + 0.004; dLng = 0.008; } const sx = (lng) => pad + ((lng - minLng) / dLng) * (W - 2 * pad); const sy = (lat) => pad + ((maxLat - lat) / dLat) * (H - 2 * pad); let g = ``; for (let i = 1; i < 6; i++) { const gx = pad + (i / 6) * (W - 2 * pad), gy = pad + (i / 6) * (H - 2 * pad); g += ``; g += ``; } g += ``; if (shape && shape.type === "polygon" && shape.latlngs.length >= 3) { const d = shape.latlngs.map((p) => sx(p[1]) + "," + sy(p[0])).join(" "); g += ``; } if (shape && shape.type === "circle") { const cx = sx(shape.center[1]), cy = sy(shape.center[0]); const edgeLng = shape.center[1] + shape.radius / (111320 * Math.cos(shape.center[0] * Math.PI / 180)); const rx = Math.abs(sx(edgeLng) - cx); const edgeLat = shape.center[0] + shape.radius / 110540; const ry = Math.abs(sy(edgeLat) - cy); g += ``; } results.forEach((m) => { const c = catOf(m.cat).color; g += ``; }); return `${g}`; } // ---- Quick Report HTML ----------------------------------------------------- function buildReportHTML(lang, results, range, adv, shape) { const S = STR[lang]; const st = computeStats(results); const tops = topMemories(results, 10); const snap = buildSnapshotSVG(results, shape); const fsum = summarizeFilters(lang, range, adv, shape, null); const esc = (s) => String(s == null ? "" : s).replace(/[&<>]/g, (c) => ({ "&": "&", "<": "<", ">": ">" }[c])); const gen = new Date(); const catRows = CATS.filter((c) => st.byCat[c.key]).map((c) => `
${esc(c[lang])}${st.byCat[c.key]}
`).join(""); const peakStr = st.peak.map(([y, n]) => `${y} (${n})`).join(" · ") || "—"; const topRows = tops.map((m, i) => `
  • ${String(i + 1).padStart(2, "0")}
    ${esc(catOf(m.cat)[lang])} · ${esc(m.ward || "—")} · ${esc(lang === "vi" ? m.date : (m.dateEn || m.date))} ${isVerified(m) ? '✓ ' + esc(S.stVer) + "" : '' + esc(S.stUnver) + ""}
    ${esc(lang === "vi" ? m.vi : m.en)}
    • `).join(""); return ` ${esc(S.siteName)} — ${esc(S.tierAName)}
    ${esc(S.tierAName)} · ${esc(S.tierAFor)}
    ${esc(S.siteName)}
    ${esc(lang === "vi" ? "Tạo lúc" : "Generated")} ${gen.toLocaleString(lang === "vi" ? "vi-VN" : "en-GB")} · ${st.total} ${esc(S.matchCount)}
    ${esc(lang === "vi" ? "Ảnh chụp bản đồ" : "Map snapshot")}
    ${snap}
    ${CATS.map((c) => `${esc(c[lang])}`).join("")}
    ${fsum.map((f) => `${esc(f)}`).join("")}
    ${esc(lang === "vi" ? "Thống kê tóm tắt" : "Summary statistics")}
    ${esc(S.matchCount)}
    ${st.total}
    ${esc(S.stVer)}
    ${st.verified}
    ${esc(S.stUnver)}
    ${st.unverified}
    ${esc(lang === "vi" ? "Năm cao điểm" : "Peak dates")}
    ${peakStr}
    ${esc(lang === "vi" ? "Khoảng năm" : "Date span")}
    ${st.span ? st.span[0] + " – " + st.span[1] : "—"}
    ${catRows}
    ${esc(lang === "vi" ? "10 ký ức tiêu biểu" : "Top 10 memories")}
      ${topRows}
    ${esc(S.privacyNote)}
    `; } function openReport(html) { const w = window.open("", "_blank"); if (w && w.document) { w.document.open(); w.document.write(html); w.document.close(); } else downloadText("ky-uc-ha-noi-report.html", html, "text/html"); } // ---- the export modal ------------------------------------------------------ function ExportModal({ lang, results, range, adv, shape, onClose }) { const S = STR[lang]; const rows = React.useMemo(() => results.map(deriveRow), [results]); const stamp = () => new Date().toISOString().slice(0, 10); const fname = (ext) => `ky-uc-ha-noi_${stamp()}_${rows.length}.${ext}`; const doReport = () => openReport(buildReportHTML(lang, results, range, adv, shape)); const dlReport = () => downloadText(fname("html"), buildReportHTML(lang, results, range, adv, shape), "text/html"); React.useEffect(() => { const onKey = (e) => { if (e.key === "Escape") onClose(); }; window.addEventListener("keydown", onKey); return () => window.removeEventListener("keydown", onKey); }, [onClose]); return (
    { if (e.target === e.currentTarget) onClose(); }}>
    ); } window.ExportModal = ExportModal; window.deriveRow = deriveRow;