import { useEffect, useId, useRef, useState } from "react"; import { BodyPortal, useOverlayLayer } from "../customer-grid/OverlaySurface"; import { readSheetActivity } from "./sheetApi"; import type { SheetActivityResult, SheetWrite } from "./sheetApi"; export function sheetWriteTime(at: string, now = Date.now()): string { const age = Math.max(0, now - Date.parse(at)); if (!Number.isFinite(age)) return ""; if (age < 60000) return "just now"; if (age < 3600000) return `${Math.floor(age / 60000)}m ago`; if (age < 86400000) return `${Math.floor(age / 3600000)}h ago`; return `${Math.floor(age / 86400000)}d ago`; } function writer(write: SheetWrite): string { return `${write.byName || write.by}${write.via ? ` via ${write.via}` : ""}`; } /** Mounted with the workbook key so a late response cannot name another workbook's writer. */ export default function SheetActivity({ workbookId, revision, lastEdit }: { workbookId: string; revision: number; lastEdit?: SheetWrite | null; }) { const [activity, setActivity] = useState({ lastEdit: lastEdit ?? null, writes: [] }); const [open, setOpen] = useState(false); const [error, setError] = useState(""); const [now, setNow] = useState(Date.now); useEffect(() => { let active = true; let pending: AbortController | null = null; const read = async () => { setNow(Date.now()); if (pending) return; const controller = new AbortController(); pending = controller; const timeout = window.setTimeout(() => controller.abort(), 4000); try { const result = await readSheetActivity(workbookId, controller.signal); if (!active) return; if (result.ok) { setActivity(result.value); setError(""); } else { setError(result.message); if (result.status === 403 || result.status === 404) { setActivity({ lastEdit: null, writes: [] }); setOpen(false); } } } finally { window.clearTimeout(timeout); pending = null; } }; void read(); const timer = window.setInterval(() => { void read(); }, 2000); return () => { active = false; window.clearInterval(timer); pending?.abort(); }; }, [workbookId, revision]); const last = activity.lastEdit; return <> {last && } {open && setOpen(false)} />} ; } function RecentWrites({ writes, error, now, onClose }: { writes: SheetWrite[]; error: string; now: number; onClose: () => void; }) { const panelRef = useRef(null); const titleId = useId(); useOverlayLayer({ panelRef, onDismiss: onClose, dismissOnOutside: false, initialFocus: "[data-overlay-autofocus]", restoreFocus: true, trapFocus: true }); return

Recent writes

{error ?

{error}

: null}
    {writes.map((write) =>
  1. {writer(write)} {` · ${write.cells} ${write.cells === 1 ? "cell" : "cells"}`}
  2. )}
; }