// Terminal Atlas page — one page per shipping facility (carrier hub, cold storage, // dry storage, port, etc.). Doubles as a Trojan horse for driver acquisition: // drivers searching "UPS Commerce City driver entrance" land here. // // Pulls live data from Supabase: entity, attributes, status log, recent tips, // recent wait-time reports. Submission widgets write back to the DB. const { useState: useStateT, useEffect: useEffectT, useMemo: useMemoT } = React; function TerminalPage({ slug, onNav }) { const [terminal, setTerminal] = useStateT(null); const [parent, setParent] = useStateT(null); const [city, setCity] = useStateT(null); const [attrs, setAttrs] = useStateT([]); const [statusLog, setStatusLog] = useStateT([]); const [tips, setTips] = useStateT([]); const [waits, setWaits] = useStateT([]); const [loading, setLoading] = useStateT(true); const [waitInput, setWaitInput] = useStateT(""); const [waitSubmitted, setWaitSubmitted] = useStateT(false); const [tipInput, setTipInput] = useStateT(""); const [tipRole, setTipRole] = useStateT("driver"); const [tipSeverity, setTipSeverity] = useStateT("moderate"); const [tipPublic, setTipPublic] = useStateT(false); const [tipEmail, setTipEmail] = useStateT(""); const [tipSubmitted, setTipSubmitted] = useStateT(false); const [tipToken, setTipToken] = useStateT(null); useEffectT(() => { if (!window.SI_DB) { setLoading(false); return; } (async () => { const ents = await window.SI_DB.raw.select( "entities", `select=*&slug=eq.${encodeURIComponent(slug)}` ); if (!ents || !ents.length) { setLoading(false); return; } const t = ents[0]; setTerminal(t); const [parentEnts, cityRows, attrRows, logRows, tipRows, waitRows] = await Promise.all([ t.parent_id ? window.SI_DB.raw.select("entities", `select=slug,name&id=eq.${t.parent_id}`) : Promise.resolve([]), t.primary_city_id ? window.SI_DB.raw.select("cities", `select=*&id=eq.${t.primary_city_id}`) : Promise.resolve([]), window.SI_DB.raw.select( "entity_attributes", `select=key,value&entity_id=eq.${t.id}&order=key.asc` ), window.SI_DB.raw.select( "facility_status_log", `select=*&entity_id=eq.${t.id}&order=start_date.desc&limit=5` ), window.SI_DB.raw.select( "intel_submissions", `select=raw_text,submitter_role,parsed_intel_type,created_at&facility_id=eq.${t.id}&status=eq.verified&order=created_at.desc&limit=20` ), window.SI_DB.raw.select( "wait_time_reports", `select=minutes,created_at&facility_id=eq.${t.id}&order=created_at.desc&limit=12` ), ]); setParent(parentEnts && parentEnts[0]); setCity(cityRows && cityRows[0]); setAttrs(attrRows || []); setStatusLog(logRows || []); setTips(tipRows || []); setWaits(waitRows || []); setLoading(false); })(); }, [slug]); const attrMap = useMemoT(() => { const m = {}; attrs.forEach((a) => { m[a.key] = a.value; }); return m; }, [attrs]); // Current status: most recent open log row whose end_date is null or in future const currentStatus = useMemoT(() => { const now = new Date().toISOString().slice(0, 10); return statusLog.find((s) => !s.end_date || s.end_date >= now); }, [statusLog]); const avgWait = useMemoT(() => { if (!waits.length) return null; const total = waits.reduce((a, w) => a + w.minutes, 0); return Math.round(total / waits.length); }, [waits]); function timeAgo(iso) { const ms = Date.now() - new Date(iso).getTime(); const m = Math.floor(ms / 60000); if (m < 60) return `${m}m ago`; const h = Math.floor(m / 60); if (h < 24) return `${h}h ago`; const d = Math.floor(h / 24); return `${d}d ago`; } async function submitWait(e) { e.preventDefault(); const minutes = parseInt(waitInput, 10); if (!minutes || minutes < 0 || minutes > 600) return; await window.SI_DB.submitWaitTime(terminal.id, minutes); setWaitInput(""); setWaitSubmitted(true); // Refetch const newWaits = await window.SI_DB.raw.select( "wait_time_reports", `select=minutes,created_at&facility_id=eq.${terminal.id}&order=created_at.desc&limit=12` ); setWaits(newWaits || []); } function generateToken() { // 32 chars of alphanumeric — short enough for a URL, long enough to be unguessable const chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; let t = ""; const arr = new Uint8Array(32); (window.crypto || window.msCrypto).getRandomValues(arr); for (let i = 0; i < 32; i++) t += chars[arr[i] % chars.length]; return t; } async function submitTip(e) { e.preventDefault(); if (!tipInput.trim()) return; const token = generateToken(); await window.SI_DB.submitIntel({ facility_id: terminal.id, carrier_id: terminal.parent_id, city_id: terminal.primary_city_id, submitter_role: tipRole, raw_text: tipInput.trim(), severity: tipSeverity, visibility: tipPublic ? "public" : "sealed", submitter_token: token, submitter_email: tipEmail.trim() || null, status: "pending", }); setTipInput(""); setTipEmail(""); setTipPublic(false); setTipToken(token); setTipSubmitted(true); } if (loading) { return (
Loading terminal…
); } if (!terminal) { return (

Terminal not found

We don't have this facility in the atlas yet.

); } return (
onNav("home")}>← Atlas home
{parent ? parent.name : "Independent"} · Terminal {city ? `· ${city.name}, ${city.state}` : ""}

{terminal.name}

{terminal.address || "Address not yet on file"}

{currentStatus && currentStatus.status !== "open" && (
🚧 {currentStatus.status.replace("_", " ")} {currentStatus.end_date ? ` through ${new Date(currentStatus.end_date).toLocaleDateString("en-US", { month: "short", year: "numeric" })}` : ""} {currentStatus.notes ? ` — ${currentStatus.notes}` : ""}
)}

Facility

Address{terminal.address || "—"}
{attrMap.driver_entrance &&
Driver entrance{attrMap.driver_entrance}
} {attrMap.hours_driver &&
Hours{attrMap.hours_driver}
} {attrMap.phone &&
Phone{attrMap.phone}
} {attrMap.services &&
Services{attrMap.services}
} {attrMap.aircraft_capacity &&
Air capacity{attrMap.aircraft_capacity}
} {parent &&
Operated by{parent.name}
}

Driver tips ({tips.length})

{tips.length === 0 ? (

No tips yet — be the first.

) : ( tips.map((t, i) => (
"{t.raw_text}"
{t.submitter_role} · {timeAgo(t.created_at)}
)) )}
{tipSubmitted ? (
✓ Tip submitted.
Editor will review before publishing. Save this URL to manage or delete your submission later:
{tipToken && ( {window.location.origin}/#/manage?token={tipToken} )}
) : (