{/* Project selector — only relevant for the 4 operational tabs */}
{tab !== "sites" && (
{lang === "fr" ? "Projet" : "Project"}
{!activeProject && (
{lang === "fr"
? "Sélectionnez un projet pour saisir les données de référence."
: "Pick a project to enter baseline data."}
)}
);
}
// =====================================================================
// ImportSitesModal — paste-or-upload a CSV of sites, preview, commit.
// Expected columns (header line, case-insensitive, any column order):
// code, name, kind, region, country_iso2, beneficiaries, staff_count,
// status, lat, lng
// Only `name` is strictly required; everything else is optional. Code
// is auto-generated when blank. Country defaults to SN. Status defaults
// to 'ok'. lat/lng (when both present and numeric) populate
// metadata.coords + the PostGIS location via set_site_location.
// =====================================================================
function ImportSitesModal({ lang, projects, defaultProject, onClose, onImported }) {
const [projectCode, setProjectCode] = useStateB("");
const [csvText, setCsvText] = useStateB("");
const [parsed, setParsed] = useStateB(null); // { headers, rows, errors }
const [busy, setBusy] = useStateB(false);
const [err, setErr] = useStateB(null);
const [progress, setProgress] = useStateB(null); // { done, total, failures }
const fileRef = useRefB(null);
// Resolve the default project's legacy code from its UUID (which is
// what activeProject holds).
useEffectB(() => {
if (projectCode) return;
if (defaultProject && projects && projects.length > 0) {
const p = projects.find((x) => x.uuid === defaultProject) || projects[0];
if (p) setProjectCode(p.id);
} else if (projects && projects.length > 0) {
setProjectCode(projects[0].id);
}
}, [projects, defaultProject]);
// Minimal CSV parser: handles quoted fields, escaped quotes ("") and
// multi-line cells. Doesn't try to support every Excel quirk, but
// covers the common copy-paste-from-spreadsheet case.
const parseCSV = (text) => {
const rows = [];
let cur = [];
let buf = "";
let inQ = false;
for (let i = 0; i < text.length; i++) {
const ch = text[i];
if (inQ) {
if (ch === '"' && text[i + 1] === '"') { buf += '"'; i++; }
else if (ch === '"') { inQ = false; }
else { buf += ch; }
} else {
if (ch === '"') { inQ = true; }
else if (ch === ',' || ch === ';' || ch === '\t') { cur.push(buf); buf = ""; }
else if (ch === '\n' || ch === '\r') {
if (buf !== "" || cur.length) { cur.push(buf); rows.push(cur); cur = []; buf = ""; }
if (ch === '\r' && text[i + 1] === '\n') i++;
} else { buf += ch; }
}
}
if (buf !== "" || cur.length) { cur.push(buf); rows.push(cur); }
return rows;
};
const tryParse = (text) => {
setErr(null);
if (!text || !text.trim()) { setParsed(null); return; }
const grid = parseCSV(text.trim()).filter((r) => r.length > 0 && r.some((c) => c && c.trim()));
if (grid.length < 2) { setErr(lang === "fr" ? "Au moins un en-tête + une ligne de données sont requis." : "Need at least a header + one data row."); setParsed(null); return; }
const headers = grid[0].map((h) => (h || "").trim().toLowerCase());
const expected = ["code","name","kind","region","country_iso2","beneficiaries","staff_count","status","lat","lng"];
const missing = ["name"].filter((req) => !headers.includes(req));
if (missing.length) { setErr((lang === "fr" ? "Colonne(s) manquante(s) : " : "Missing column(s): ") + missing.join(", ")); setParsed(null); return; }
const idx = Object.fromEntries(expected.map((k) => [k, headers.indexOf(k)]));
const rows = grid.slice(1).map((r, i) => {
const get = (k) => idx[k] >= 0 ? (r[idx[k]] || "").trim() : "";
const lat = parseFloat(get("lat")); const lng = parseFloat(get("lng"));
return {
_row: i + 2,
code: get("code"),
name: get("name"),
kind: get("kind"),
region: get("region"),
country_iso2: (get("country_iso2") || "SN").toUpperCase(),
beneficiaries: get("beneficiaries") ? Number(get("beneficiaries")) : null,
staff_count: get("staff_count") ? Number(get("staff_count")) : null,
status: get("status") || "ok",
coords: (!isNaN(lat) && !isNaN(lng)) ? { lat, lng } : null,
};
});
const errors = rows.filter((r) => !r.name).map((r) => "Ligne " + r._row + " : nom manquant.");
setParsed({ headers, rows, errors });
};
const onFileChosen = (e) => {
const file = e.target.files && e.target.files[0];
e.target.value = "";
if (!file) return;
const reader = new FileReader();
reader.onload = (ev) => { setCsvText(ev.target.result); tryParse(ev.target.result); };
reader.onerror = () => setErr(lang === "fr" ? "Échec lecture fichier." : "File read failed.");
reader.readAsText(file);
};
const onCommit = async () => {
if (!parsed || !projectCode) return;
setBusy(true); setErr(null);
const valid = parsed.rows.filter((r) => r.name);
setProgress({ done: 0, total: valid.length, failures: [] });
for (let i = 0; i < valid.length; i++) {
const r = valid[i];
try {
await window.melr.createSite(projectCode, {
code: r.code || ("S-" + Date.now().toString(36) + "-" + i),
name: r.name,
kind: r.kind || null,
region: r.region || null,
country_iso2: r.country_iso2,
beneficiaries: r.beneficiaries,
staff_count: r.staff_count,
status: r.status,
coords: r.coords,
});
setProgress((p) => ({ ...p, done: i + 1 }));
} catch (ex) {
setProgress((p) => ({ ...p, done: i + 1, failures: [...p.failures, { row: r._row, name: r.name, err: ex.message }] }));
}
}
setBusy(false);
// Auto-close if nothing failed.
const failCount = (progress && progress.failures && progress.failures.length) || 0;
if (failCount === 0) await onImported();
};
const Modal = window.Modal;
const inp = { width: "100%", padding: "6px 8px", borderRadius: 6, border: "1px solid var(--line)", fontSize: 12.5, background: "var(--bg, white)", color: "var(--text)", boxSizing: "border-box", fontFamily: "inherit" };
const lbl = { display: "block", fontSize: 10.5, color: "var(--text-faint)", marginBottom: 3, textTransform: "uppercase", letterSpacing: "0.04em", marginTop: 10 };
return (
}
>
{lang === "fr"
? "Collez un CSV ou téléversez un fichier. Colonnes attendues (séparées par virgule, point-virgule ou tabulation, dans n'importe quel ordre) :"
: "Paste a CSV or upload a file. Expected columns (comma / semicolon / tab separated, any order):"}
name (obligatoire), code, kind, region, country_iso2, beneficiaries, staff_count, status, lat, lng