/* === Comms schedule upload (admin) === Comms' project-management tool exports a task list per product (Task Name / Status / Planned Start / Planned Completion / Actual Completion / Approvals). Drop one or MORE exports here, link each to its tracked work item, and choose what to apply. Nothing is written silently: the publish target and status are one-click adoptions (same philosophy as the milestone "Use N" button), and the full plan is stored on the work item (w.commsPlan) so the panel can show where the product sits in Comms' pipeline. Re-upload a refreshed export any time — the card shows the slip against what's stored. The product name lives only in the export's FILENAME, so each card offers a fuzzy-matched work-item guess to confirm. */ function cuParse(rawText, fileName) { const rows = parseCsvText(rawText); if (!rows.length) return null; const header = rows[0].map((x) => x.trim()); const col = (n) => header.indexOf(n); if (col("Task Name") < 0 || col("Planned Completion Date") < 0) return null; const tasks = rows.slice(1) .filter((r) => r.length >= 3 && (r[col("Task Name")] || "").trim()) .map((r) => { const get = (n) => (r[col(n)] || "").trim(); return { name: get("Task Name"), status: get("Status"), plannedStart: get("Planned Start Date"), plannedEnd: get("Planned Completion Date"), actualEnd: get("Actual Completion Date"), approvals: get("Approvals"), }; }); if (!tasks.length) return null; const parseD = (s) => { const d = new Date(s); return isNaN(d) ? null : d; }; const fmt = (d) => d ? d.toLocaleDateString("en-US", { month: "short", day: "numeric", year: "numeric" }) : null; // "Done" trusts the Actual Completion Date first; status text is a loose // backup (the pre-kickoff sample only shows "New" — vocabulary TBD). const isDone = (t) => !!t.actualEnd || /complete|done|closed/i.test(t.status); const target = tasks.reduce((mx, t) => { const d = parseD(t.plannedEnd); return d && (!mx || d > mx) ? d : mx; }, null); const start = tasks.reduce((mn, t) => { const d = parseD(t.plannedStart); return d && (!mn || d < mn) ? d : mn; }, null); const lastActual = tasks.reduce((mx, t) => { const d = parseD(t.actualEnd); return d && (!mx || d > mx) ? d : mx; }, null); const done = tasks.filter(isDone).length; const firstOpen = tasks.find((t) => !isDone(t)); return { source: fileName, updated: new Date().toLocaleDateString("en-US", { month: "short", day: "numeric", year: "numeric" }), titleHint: fileName.replace(/_?Exported_Tasks.*$/i, "").replace(/\.csv$/i, "").replace(/_+/g, " ").trim(), tasks, total: tasks.length, done, target: fmt(target), start: fmt(start), completedOn: done === tasks.length ? fmt(lastActual) : null, currentPhase: done === 0 ? "not started" : (firstOpen ? firstOpen.name : "all tasks complete"), }; } /* Best-overlap work item for a filename-derived title hint (a guess to confirm, never auto-applied). */ function cuGuessWork(titleHint) { const words = titleHint.toLowerCase().split(/\s+/).filter((x) => x.length > 3); let best = null, bestScore = 0; for (const w of window.WORK_ITEMS || []) { const t = w.title.toLowerCase(); const score = words.filter((x) => t.includes(x)).length; if (score > bestScore) { best = w; bestScore = score; } } return bestScore >= 2 ? best.id : ""; } function CommsUpload({ onClose }) { const [cards, setCards] = React.useState([]); const [err, setErr] = React.useState(null); const [busy, setBusy] = React.useState(false); const [done, setDone] = React.useState(null); React.useEffect(() => { const onKey = (e) => { if (e.key === "Escape") onClose(); }; window.addEventListener("keydown", onKey); return () => window.removeEventListener("keydown", onKey); }, [onClose]); function handleFiles(e) { setErr(null); setDone(null); for (const f of [...e.target.files]) { const reader = new FileReader(); reader.onload = () => { try { const plan = cuParse(String(reader.result).replace(/^/, ""), f.name); if (!plan) { setErr(`"${f.name}" doesn't look like a Comms task export (needs Task Name + Planned Completion Date columns).`); return; } setCards((prev) => { if (prev.some((c) => c.plan.source === f.name)) return prev; const workId = cuGuessWork(plan.titleHint); return [...prev, { plan, workId, applyDue: true, applyStatus: plan.done > 0, applyCompleted: !!plan.completedOn }]; }); } catch (ex) { setErr(`${f.name}: ${String(ex.message || ex)}`); } }; reader.readAsText(f, "utf-8"); } e.target.value = ""; } const setCard = (i, patch) => setCards(cards.map((c, x) => x === i ? { ...c, ...patch } : c)); const linked = cards.filter((c) => c.workId); async function commit() { setBusy(true); setErr(null); try { const events = linked.map((c) => { const w = (window.WORK_ITEMS || []).find((x) => x.id === c.workId); const statusText = `with Comms — ${c.plan.currentPhase}`.slice(0, 80); const patch = { commsPlan: c.plan }; const prev = { commsPlan: w.commsPlan || null }; if (c.applyDue && c.plan.target) { patch.due = c.plan.target; patch.firmness = "quoted"; // dates from a real plan prev.due = w.due || null; prev.firmness = w.firmness || null; } if (c.applyStatus && !c.applyCompleted) { patch.status = statusText; prev.status = w.status || null; } if (c.applyCompleted && c.plan.completedOn) { patch.completedDate = c.plan.completedOn; prev.completedDate = w.completedDate || null; } return { entityType: "work", entityId: c.workId, action: "update", patch, prev, note: "Comms schedule sync" }; }); events.push({ entityType: "meta", entityId: "app", action: "update", patch: { lastCommsUpload: new Date().toISOString() }, prev: { lastCommsUpload: (window.META && window.META.lastCommsUpload) || null } }); for (let i = 0; i < events.length; i += 40) await window.Store.commit(events.slice(i, i + 40)); setDone(`Applied ${linked.length} schedule(s).`); setCards([]); } catch (ex) { setErr(String(ex.message || ex)); } finally { setBusy(false); } } const input = { width: "100%", padding: "5px 8px", borderRadius: 4, border: "1px solid var(--border)", background: "var(--surface-2)", font: "500 12px/1.3 var(--sans)", outline: "none", }; return ( <>
); } Object.assign(window, { CommsUpload });