import { useEffect, useId, useRef, useState } from "react"; import { BodyPortal, useOverlayLayer } from "../customer-grid/OverlaySurface"; import { readWorkbookChecks } from "./sheetApi"; import type { WorkbookCheck, WorkbookCheckRef, WorkbookChecksState } from "./sheetApi"; import type { Workbook } from "./types"; import "../styles/sdlc73/sheet.css"; type DraftCheck = Omit & { id?: string }; type SaveChecks = (rules: DraftCheck[], revision: number) => Promise; const comparisons = { equals: "Equals", at_least: "At least", at_most: "At most", within: "Within a tolerance" }; const display = (value: unknown) => value === null || value === undefined ? "Blank" : String(value); export default function WorkbookChecks({ book, canEdit, busy, onSave }: { book: Workbook; canEdit: boolean; busy: boolean; onSave: SaveChecks; }) { const [open, setOpen] = useState(false); const [state, setState] = useState({ rev: book.rev, checks: [], checkResults: null }); const [error, setError] = useState(""); const [saving, setSaving] = useState(false); const [loaded, setLoaded] = useState(false); const [reload, setReload] = useState(0); const live = useRef(true); useEffect(() => { live.current = true; return () => { live.current = false; }; }, []); useEffect(() => { if (busy || saving) return; const controller = new AbortController(); let active = true; void readWorkbookChecks(book.id, controller.signal).then(result => { if (!active) return; if (result.ok) { setState(result.value); setLoaded(true); } else { setLoaded(false); setState({ rev: book.rev, checks: [], checkResults: null }); setError(result.message); } }); return () => { active = false; controller.abort(); }; }, [book.id, book.rev, busy, saving, reload]); const save = async (rules: DraftCheck[]) => { if (busy || saving || !canEdit || !loaded) return; setSaving(true); try { const saved = await onSave(rules, state.rev); if (live.current) { setState(saved); setError(""); } } catch (reason) { if (live.current) setError(reason instanceof Error ? reason.message : "Checks could not be saved."); } finally { if (live.current) { setSaving(false); setReload(value => value + 1); } } }; const failed = state.checkResults?.results.filter(row => !row.passed).length ?? 0; const tested = state.checkResults?.results.length ?? 0; return <> {open && setOpen(false)} />} ; } export function ChecksPanel({ book, state, error, busy, canEdit, onSave, onClose }: { book: Workbook; state: WorkbookChecksState; error: string; busy: boolean; canEdit: boolean; onSave: (rules: DraftCheck[]) => Promise; onClose: () => void; }) { const panelRef = useRef(null); const titleId = useId(); const first = book.sheets[0]?.id ?? ""; const [sheetId, setSheetId] = useState(first); const [address, setAddress] = useState("A1"); const [op, setOp] = useState("equals"); const [kind, setKind] = useState("number"); const [expected, setExpected] = useState("0"); const [expectedSheet, setExpectedSheet] = useState(first); const [tolerance, setTolerance] = useState("0"); const [invalid, setInvalid] = useState(""); useOverlayLayer({ panelRef, onDismiss: onClose, dismissOnOutside: false, initialFocus: "[data-overlay-autofocus]", restoreFocus: true, trapFocus: true }); const label = (ref: WorkbookCheckRef) => `${book.sheets.find(tab => tab.id === ref.sheetId)?.name ?? "Missing sheet"}!${ref.address}`; const add = async (event: React.FormEvent) => { event.preventDefault(); const cellAddress = address.trim().toUpperCase(); if (!/^[A-Z]{1,3}[1-9][0-9]*$/.test(cellAddress) || kind === "cell" && !/^[A-Z]{1,3}[1-9][0-9]*$/.test(expected.trim().toUpperCase()) || kind === "number" && (!expected.trim() || !Number.isFinite(Number(expected))) || op === "within" && (!tolerance.trim() || !Number.isFinite(Number(tolerance)) || Number(tolerance) < 0)) { setInvalid("Enter a valid cell, expected value and tolerance."); return; } setInvalid(""); const rule: DraftCheck = { cell: { sheetId, address: cellAddress }, op, expected: kind === "cell" ? { cell: { sheetId: expectedSheet, address: expected.trim().toUpperCase() } } : { value: kind === "number" ? Number(expected) : kind === "blank" ? null : kind === "true" ? true : kind === "false" ? false : expected }, ...(op === "within" ? { tolerance: Number(tolerance) } : {}) }; await onSave([...state.checks, rule]); }; const sheetOptions = book.sheets.map(tab => ); return

Workbook checks

{(error || invalid) &&

{error || invalid}

} {state.checkResults &&

Last checked:

} {!state.checks.length &&

No checks saved

}
    {state.checks.map(rule => { const result = state.checkResults?.results.find(row => row.rule.id === rule.id); return
  1. {label(rule.cell)} · {result ? result.passed ? "Passed" : "Failed" : "Awaiting refresh"} {comparisons[rule.op]}{rule.op === "within" ? ` ${rule.tolerance} of` : ""} {"cell" in rule.expected ? label(rule.expected.cell) : display(rule.expected.value)} {result && Expected {display(result.expected)} · Actual {display(result.actual)}} {result?.reason && {result.reason}} {canEdit && }
  2. ; })}
{canEdit &&
{kind === "cell" && } {["cell", "number", "text"].includes(kind) && } {op === "within" && }
}
; }