← back to Rentv
Fold RENTV Live Console into rentv app: /live + /api/live/* (Node Sheets port of live_server.py)
c08379c82d477692a81c76fee99477eaa5e200c8 · 2026-08-13 13:56:00 -0700 · Steve
Files touched
A public/live/index.htmlA public/nav-agent/nav-agent.cssA public/nav-agent/nav-agent.jsA scripts/lib/sheets.cjsM server.js
Diff
commit c08379c82d477692a81c76fee99477eaa5e200c8
Author: Steve <steve@designerwallcoverings.com>
Date: Thu Aug 13 13:56:00 2026 -0700
Fold RENTV Live Console into rentv app: /live + /api/live/* (Node Sheets port of live_server.py)
---
public/live/index.html | 409 +++++++++++++++++++++++++++++++++++
public/nav-agent/nav-agent.css | 100 +++++++++
public/nav-agent/nav-agent.js | 478 +++++++++++++++++++++++++++++++++++++++++
scripts/lib/sheets.cjs | 178 +++++++++++++++
server.js | 36 ++++
5 files changed, 1201 insertions(+)
diff --git a/public/live/index.html b/public/live/index.html
new file mode 100644
index 00000000..35c9ad9a
--- /dev/null
+++ b/public/live/index.html
@@ -0,0 +1,409 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+<meta charset="utf-8">
+<meta name="viewport" content="width=device-width, initial-scale=1">
+<title>RENTV Live Console</title>
+<link rel="stylesheet" href="/nav-agent/nav-agent.css">
+<style>
+ :root{
+ --bg:#0e1116; --panel:#161b22; --panel2:#1c232d; --line:#2b333d;
+ --ink:#e6edf3; --dim:#9aa7b4; --accent:#4c9be8; --green:#cbe6b4; --greenink:#1a2e10;
+ --chip:#232c37; --fs:14px;
+ }
+ *{box-sizing:border-box}
+ body{margin:0;font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,sans-serif;
+ background:var(--bg);color:var(--ink);font-size:var(--fs)}
+ header{position:sticky;top:0;z-index:40;background:var(--panel);border-bottom:1px solid var(--line);
+ display:flex;align-items:center;gap:14px;padding:10px 16px;flex-wrap:wrap}
+ header h1{font-size:16px;margin:0;font-weight:700;letter-spacing:.3px}
+ header h1 span{color:var(--accent)}
+ select,button,input{font:inherit;color:var(--ink);background:var(--panel2);border:1px solid var(--line);
+ border-radius:8px;padding:6px 10px}
+ button{cursor:pointer}
+ button:hover{border-color:var(--accent)}
+ .seg{display:inline-flex;border:1px solid var(--line);border-radius:8px;overflow:hidden}
+ .seg button{border:0;border-radius:0;background:var(--panel2)}
+ .seg button.on{background:var(--accent);color:#04121f;font-weight:700}
+ .grow{flex:1}
+ .sync{display:flex;align-items:center;gap:8px;color:var(--dim);font-size:12px}
+ .dot{width:9px;height:9px;border-radius:50%;background:#3fb950;box-shadow:0 0 8px #3fb95088}
+ .dot.stale{background:#d29922;box-shadow:none}
+ .dot.err{background:#f85149}
+ #wrap{padding:14px 16px 120px}
+ /* table */
+ table{border-collapse:collapse;width:100%;background:var(--panel);border:1px solid var(--line);border-radius:10px;overflow:hidden}
+ thead th{position:sticky;top:56px;background:var(--panel2);text-align:left;padding:8px 10px;border-bottom:1px solid var(--line);
+ font-size:12px;color:var(--dim);white-space:nowrap;z-index:5}
+ tbody td{padding:7px 10px;border-bottom:1px solid var(--line);vertical-align:top;max-width:340px}
+ tbody tr:hover{background:#1a212b}
+ td[contenteditable]{outline:none}
+ td[contenteditable]:focus{background:#0d2b3f;box-shadow:inset 0 0 0 2px var(--accent)}
+ td.saved{background:var(--green);color:var(--greenink);transition:background .2s}
+ td.enriched{box-shadow:inset 3px 0 0 #7bc043;background:rgba(123,192,67,.10)}
+ td.enriched:focus{box-shadow:inset 0 0 0 2px var(--accent)}
+ .card.enriched-card{box-shadow:inset 3px 0 0 #7bc043}
+ .legend{display:inline-flex;align-items:center;gap:6px;color:var(--dim);font-size:12px}
+ .legend .sw{width:12px;height:12px;border-radius:3px;background:rgba(123,192,67,.25);box-shadow:inset 3px 0 0 #7bc043}
+ td a{color:var(--accent);text-decoration:none}
+ .rowbtn{background:var(--accent);color:#04121f;border:0;border-radius:6px;padding:3px 9px;font-size:12px;font-weight:700;cursor:pointer;white-space:nowrap}
+ .namecell{font-weight:600}
+ /* cards (list + grid modes) */
+ .cards{display:grid;gap:12px}
+ .cards.grid{grid-template-columns:repeat(auto-fill,minmax(300px,1fr))}
+ .cards.list{grid-template-columns:1fr}
+ .card{background:var(--panel);border:1px solid var(--line);border-radius:12px;padding:14px 16px;position:relative}
+ .card:hover{border-color:var(--accent)}
+ .card .co{font-weight:700;font-size:15px}
+ .card .nm{color:var(--ink);margin-top:2px}
+ .card .ro{color:var(--dim);font-size:13px}
+ .card .meta{margin-top:8px;display:flex;flex-wrap:wrap;gap:6px}
+ .badge{background:var(--chip);border:1px solid var(--line);border-radius:20px;padding:2px 9px;font-size:11px;color:var(--dim)}
+ .badge.ok{color:var(--green);border-color:#3a5228}
+ .card .act{position:absolute;top:12px;right:12px}
+ .empty{color:var(--dim);padding:40px;text-align:center}
+ /* composer drawer */
+ #scrim{position:fixed;inset:0;background:#000a;z-index:60;display:none}
+ #drawer{position:fixed;top:0;right:0;height:100%;width:min(560px,100%);background:var(--panel);
+ border-left:1px solid var(--line);z-index:61;transform:translateX(100%);transition:transform .22s;
+ display:flex;flex-direction:column}
+ #drawer.open{transform:none}
+ #drawer header{position:static;background:var(--panel2)}
+ .dbody{padding:16px;overflow:auto;flex:1}
+ .dbody h2{margin:0 0 2px;font-size:18px}
+ .dbody .sub{color:var(--dim);font-size:13px;margin-bottom:12px}
+ .fieldgrid{display:grid;grid-template-columns:auto 1fr;gap:4px 12px;font-size:13px;margin-bottom:14px}
+ .fieldgrid .k{color:var(--dim)}
+ .row{display:flex;gap:8px;flex-wrap:wrap;align-items:center;margin:10px 0}
+ label.lbl{color:var(--dim);font-size:12px;min-width:64px}
+ textarea{width:100%;min-height:230px;background:var(--panel2);border:1px solid var(--line);border-radius:10px;
+ color:var(--ink);padding:12px;font:inherit;line-height:1.5;resize:vertical}
+ .subj{width:100%;margin-bottom:8px}
+ .actions{display:flex;gap:8px;flex-wrap:wrap;padding:12px 16px;border-top:1px solid var(--line);background:var(--panel2)}
+ .actions .primary{background:var(--accent);color:#04121f;font-weight:700;border:0}
+ .chdis{opacity:.4;pointer-events:none}
+ .hint{color:var(--dim);font-size:12px}
+</style>
+</head>
+<body>
+<header>
+ <h1>RENTV <span>Live Console</span></h1>
+ <select id="tab" title="Sheet tab"></select>
+ <div class="seg" id="viewseg" title="View mode">
+ <button data-v="table">▤ Table</button>
+ <button data-v="list">☰ List</button>
+ <button data-v="grid">▦ Grid</button>
+ </div>
+ <span class="legend" title="Cells filled by enrichment (or edited here) are light-green in the sheet"><span class="sw"></span>enriched</span>
+ <span class="grow"></span>
+ <span class="sync"><span class="dot" id="dot"></span><span id="syncmsg">connecting…</span></span>
+ <button id="refresh" title="Pull latest now">↻ Refresh</button>
+</header>
+
+<div id="wrap"><div class="empty">Loading the sheet…</div></div>
+
+<div id="scrim"></div>
+<div id="drawer">
+ <header>
+ <strong>✍ Draft outreach</strong><span class="grow"></span>
+ <button id="dclose">✕ Close</button>
+ </header>
+ <div class="dbody">
+ <h2 id="d-company">—</h2>
+ <div class="sub" id="d-who">—</div>
+ <div class="fieldgrid" id="d-fields"></div>
+
+ <div class="row">
+ <label class="lbl">Contact via</label>
+ <div class="seg" id="chanseg">
+ <button data-c="email">✉ Email</button>
+ <button data-c="linkedin">in LinkedIn</button>
+ <button data-c="phone">☎ Phone</button>
+ </div>
+ </div>
+ <div class="row">
+ <label class="lbl">Purpose</label>
+ <select id="purpose">
+ <option value="partnership">Partnership / intro</option>
+ <option value="sponsorship">Conference sponsorship</option>
+ <option value="speaker">Speaker / panel invite</option>
+ <option value="followup">Follow-up</option>
+ </select>
+ <label class="lbl">Tone</label>
+ <select id="tone">
+ <option value="warm">Warm</option>
+ <option value="direct">Direct</option>
+ <option value="formal">Formal</option>
+ </select>
+ <button id="regen">↻ Regenerate</button>
+ </div>
+
+ <input class="subj" id="d-subject" placeholder="Subject line">
+ <textarea id="d-body"></textarea>
+ <div class="row"><span class="hint" id="d-target"></span></div>
+ <div class="row">
+ <button id="enhance">✨ Enhance (local AI · $0)</button>
+ <span class="hint">Polishes the draft with a local model — nothing sent.</span>
+ </div>
+ </div>
+ <div class="actions">
+ <button class="primary" id="act-go">Open in Email</button>
+ <button id="act-copy">⧉ Copy draft</button>
+ <span class="grow"></span>
+ <span class="hint">Draft only — you send it. Contacts © Steve Bloom / RENTV.</span>
+ </div>
+</div>
+
+<script src="/nav-agent/nav-agent.js" defer></script>
+<script>
+const $ = s => document.querySelector(s);
+const LS = { get:(k,d)=>{try{return JSON.parse(localStorage.getItem('rentv.'+k))??d}catch(e){return d}},
+ set:(k,v)=>localStorage.setItem('rentv.'+k,JSON.stringify(v)) };
+let DATA={gid:0,title:'',headers:[],rows:[]}, ROLE={}, VIEW=LS.get('view','table'), GID=LS.get('gid',null);
+let editing=false, lastPull=0, curRow=null, curChan='email';
+let GREENSET=new Set(); // "r,c" cells that are light-green (enriched/added) in the sheet
+
+// ---- field role detection (map header labels -> semantic roles) --------------
+function findCol(preds){ for(const p of preds){ const i=DATA.headers.findIndex(h=>p.test(h)); if(i>=0) return i; } return -1; }
+function detectRoles(){
+ ROLE = {
+ name: findCol([/^contact name$/i,/\bname\b/i]),
+ company: findCol([/company\/venue/i,/^company$/i,/venue/i,/firm/i]),
+ position:findCol([/^position$/i,/title/i,/role/i]),
+ email: findCol([/^email$/i]),
+ email2: findCol([/updated email/i]),
+ phone: findCol([/^phone 1$/i,/^phone$/i]),
+ cphone: findCol([/company phone/i]),
+ liC: findCol([/linkedin \(contact\)/i]),
+ liCo: findCol([/linkedin \(company\)/i]),
+ mvpN: findCol([/marketing\/vp name/i]),
+ mvpP: findCol([/marketing\/vp position/i]),
+ mvpL: findCol([/marketing\/vp linkedin/i]),
+ };
+}
+const g=(r,i)=> (i>=0 && i<r.length)? String(r[i]||'').trim() : '';
+function contact(r){
+ const nm=g(r,ROLE.name), co=g(r,ROLE.company);
+ return {
+ name:nm, first:(nm.split(/[\s,]+/)[0]||'').trim(), company:co, position:g(r,ROLE.position),
+ email:g(r,ROLE.email)||g(r,ROLE.email2), phone:g(r,ROLE.phone)||g(r,ROLE.cphone),
+ liC:hrefOf(g(r,ROLE.liC)), liCo:hrefOf(g(r,ROLE.liCo)),
+ mvpN:g(r,ROLE.mvpN), mvpP:g(r,ROLE.mvpP), mvpL:hrefOf(g(r,ROLE.mvpL)),
+ };
+}
+function hrefOf(v){ const m=String(v).match(/https?:\/\/[^\s"')]+/i); return m?m[0]:(/linkedin\.com/i.test(v)?('https://'+v.replace(/^https?:\/\//,'')):''); }
+
+// ---- load / live pull --------------------------------------------------------
+async function loadMeta(){
+ const tabs=await (await fetch('/api/live/meta')).json();
+ const sel=$('#tab'); sel.innerHTML='';
+ tabs.forEach(t=>{const o=document.createElement('option');o.value=t.gid;o.textContent=t.title;sel.appendChild(o);});
+ if(GID==null || !tabs.find(t=>t.gid==GID)) GID=tabs[0].gid;
+ sel.value=GID;
+}
+async function pull(force, _try){
+ if(editing && !force) return;
+ const myGid=GID;
+ try{
+ const d=await (await fetch('/api/live/tab?gid='+GID)).json();
+ if(myGid!==GID) return; // user switched tabs mid-fetch — drop stale result
+ if(d.error){
+ if((d.retry || (_try||0)<3)){ setSync('stale','quota — retrying…'); return setTimeout(()=>pull(force,(_try||0)+1), 2500); }
+ throw new Error(d.error);
+ }
+ const changed = JSON.stringify(d)!==JSON.stringify(DATA);
+ DATA=d; detectRoles(); lastPull=Date.now();
+ setSync('ok');
+ if(changed) render();
+ }catch(e){
+ if((_try||0)<3){ setSync('stale','load hiccup — retrying…'); return setTimeout(()=>pull(force,(_try||0)+1), 2500); }
+ setSync('err',e.message);
+ }
+}
+const FMTCACHE={}; // gid -> Set of "r,c" green cells (cache so revisiting a tab costs 0 reads)
+async function pullFormat(){
+ // heavy (includeGridData) — only on tab-load / manual refresh, never on the 12s poll
+ const myGid=GID;
+ if(FMTCACHE[myGid]){ GREENSET=FMTCACHE[myGid]; applyGreen(); return; }
+ try{
+ const d=await (await fetch('/api/live/format?gid='+myGid)).json();
+ if(myGid!==GID) return;
+ if(d && d.green){ GREENSET=new Set(d.green); FMTCACHE[myGid]=GREENSET; applyGreen(); }
+ }catch(e){ /* non-fatal — enrichment tint is cosmetic */ }
+}
+function applyGreen(){
+ document.querySelectorAll('td[data-r]').forEach(td=>{
+ td.classList.toggle('enriched', GREENSET.has(td.dataset.r+','+td.dataset.c));
+ });
+ // card mode: flag a card if any of its cells are enriched
+ document.querySelectorAll('.card[data-r]').forEach(c=>{
+ let any=false; const r=c.dataset.r;
+ GREENSET.forEach(k=>{ if(k.split(',')[0]===r) any=true; });
+ c.classList.toggle('enriched-card', any);
+ });
+}
+function setSync(state,msg){
+ const dot=$('#dot');
+ dot.className='dot'+(state==='err'?' err':state==='stale'?' stale':'');
+ $('#syncmsg').textContent = state==='err' ? ('sync error: '+(msg||'')) :
+ ('live · synced '+Math.max(0,Math.round((Date.now()-lastPull)/1000))+'s ago · '+DATA.rows.length+' rows');
+}
+setInterval(()=>{ if(Date.now()-lastPull>25000) $('#dot').classList.add('stale'); if(!editing) setSync('ok'); },1000);
+
+// ---- render: table | list | grid --------------------------------------------
+const MAXROWS=1200;
+function render(){
+ const wrap=$('#wrap');
+ if(!DATA.rows.length){ wrap.innerHTML='<div class="empty">No rows in this tab.</div>'; return; }
+ document.querySelectorAll('#viewseg button').forEach(b=>b.classList.toggle('on',b.dataset.v===VIEW));
+ const capped = DATA.rows.length>MAXROWS;
+ const banner = capped ? '<div class="empty" style="padding:10px;color:#d29922">Showing first '+MAXROWS+' of '+DATA.rows.length+' rows — use ⚙ search/filter (bottom-left) to narrow, or pick a smaller tab.</div>' : '';
+ wrap.innerHTML = banner + (VIEW==='table' ? tableHTML() : cardsHTML(VIEW));
+ wireGrid(); applyGreen();
+ // let Nav Agent (re)model the new grid
+ if(window.NavAgent && window.NavAgent.mount){ try{ window.NavAgent.mount({target: VIEW==='table'?'#grid':'#cards', title:DATA.title}); }catch(e){} }
+}
+function tableHTML(){
+ let h='<table id="grid" data-nav-grid><thead><tr><th></th>';
+ DATA.headers.forEach(hd=> h+='<th>'+esc(hd)+'</th>'); h+='</tr></thead><tbody>';
+ DATA.rows.slice(0,MAXROWS).forEach((r,ri)=>{
+ h+='<tr><td><button class="rowbtn" data-r="'+ri+'">✍ Draft</button></td>';
+ r.forEach((c,ci)=>{
+ const isName=ci===ROLE.name, gr=GREENSET.has(ri+','+ci);
+ const cls=[isName?'namecell':'', gr?'enriched':''].filter(Boolean).join(' ');
+ h+='<td data-field="'+esc(DATA.headers[ci]||'')+'" data-r="'+ri+'" data-c="'+ci+'" contenteditable="true"'+
+ (cls?' class="'+cls+'"':'')+'>'+cellRender(c)+'</td>';
+ });
+ h+='</tr>';
+ });
+ return h+'</tbody></table>';
+}
+function cardsHTML(mode){
+ let h='<div class="cards '+mode+'" id="cards" data-nav-grid>';
+ DATA.rows.slice(0,MAXROWS).forEach((r,ri)=>{
+ const c=contact(r);
+ h+='<div class="card" data-r="'+ri+'">'+
+ '<button class="rowbtn act" data-r="'+ri+'">✍ Draft</button>'+
+ '<div class="co" data-field="Company/Venue">'+esc(c.company||'—')+'</div>'+
+ (c.name?'<div class="nm" data-field="Contact Name">'+esc(c.name)+'</div>':'')+
+ (c.position?'<div class="ro" data-field="Position">'+esc(c.position)+'</div>':'')+
+ '<div class="meta">'+
+ badge('✉', c.email, 'Email')+ badge('☎', c.phone, 'Phone')+
+ badge('in', c.liC||c.liCo, 'LinkedIn')+ badge('★', c.mvpN, 'Mktg/VP')+
+ '</div></div>';
+ });
+ return h+'</div>';
+}
+function badge(ic,val,label){ return '<span class="badge'+(val?' ok':'')+'" data-field="'+label+'">'+ic+' '+esc(label)+(val?' ✓':'')+'</span>'; }
+function cellRender(v){ const u=hrefOf(v); if(u&&/^https?:/i.test(v)) return '<a href="'+esc(u)+'" target="_blank" rel="noopener">'+esc(v.length>40?u.replace(/^https?:\/\/(www\.)?/,''):v)+'</a>'; return esc(v); }
+function esc(s){ return String(s==null?'':s).replace(/[&<>"]/g,m=>({'&':'&','<':'<','>':'>','"':'"'}[m])); }
+
+function wireGrid(){
+ document.querySelectorAll('.rowbtn').forEach(b=> b.onclick=e=>{e.stopPropagation();openDraft(+b.dataset.r);});
+ document.querySelectorAll('.card').forEach(c=> c.onclick=()=>openDraft(+c.dataset.r));
+ document.querySelectorAll('td[contenteditable]').forEach(td=>{
+ td.addEventListener('focus',()=>{editing=true; td._orig=td.textContent;});
+ td.addEventListener('blur',()=>saveCell(td));
+ td.addEventListener('keydown',e=>{ if(e.key==='Enter'&&!e.shiftKey){e.preventDefault();td.blur();} });
+ });
+}
+async function saveCell(td){
+ editing=false;
+ const val=td.textContent.trim();
+ if(val===String(td._orig||'').trim()) return;
+ const r=+td.dataset.r, c=+td.dataset.c;
+ try{
+ const res=await (await fetch('/api/live/write',{method:'POST',headers:{'Content-Type':'application/json'},
+ body:JSON.stringify({gid:GID,row0:r,col0:c,value:val})})).json();
+ if(res.ok){ DATA.rows[r][c]=val; GREENSET.add(r+','+c); td.classList.add('saved');
+ setTimeout(()=>{td.classList.remove('saved'); td.classList.add('enriched');},1200); }
+ else throw new Error(res.error||'write failed');
+ }catch(e){ td.textContent=td._orig||''; setSync('err',e.message); }
+}
+
+// ---- draft composer ----------------------------------------------------------
+function openDraft(ri){
+ curRow=ri; const c=contact(DATA.rows[ri]);
+ $('#d-company').textContent=c.company||'(no company)';
+ $('#d-who').textContent=[c.name,c.position].filter(Boolean).join(' · ')||'—';
+ const F=$('#d-fields'); F.innerHTML='';
+ const add=(k,v,link)=>{ if(!v)return; F.insertAdjacentHTML('beforeend','<div class="k">'+k+'</div><div>'+(link?'<a href="'+esc(link)+'" target="_blank" rel="noopener">'+esc(v)+'</a>':esc(v))+'</div>'); };
+ add('Email',c.email,c.email?'mailto:'+c.email:''); add('Phone',c.phone,c.phone?'tel:'+c.phone.replace(/[^0-9+]/g,''):'');
+ add('LinkedIn',c.liC?'Contact profile':(c.liCo?'Company page':''),c.liC||c.liCo);
+ add('Marketing / VP',[c.mvpN,c.mvpP].filter(Boolean).join(' — '),c.mvpL);
+ // enable channels that have data; pick a sensible default
+ const avail={email:!!c.email, linkedin:!!(c.liC||c.mvpL||c.liCo), phone:!!c.phone};
+ document.querySelectorAll('#chanseg button').forEach(b=>{ b.classList.toggle('chdis',!avail[b.dataset.c]); });
+ curChan = avail[curChan]?curChan : (avail.email?'email':avail.linkedin?'linkedin':avail.phone?'phone':'email');
+ syncChanUI(); regen();
+ $('#scrim').style.display='block'; $('#drawer').classList.add('open');
+}
+function closeDraft(){ $('#scrim').style.display='none'; $('#drawer').classList.remove('open'); }
+function syncChanUI(){ document.querySelectorAll('#chanseg button').forEach(b=>b.classList.toggle('on',b.dataset.c===curChan));
+ $('#d-subject').style.display = curChan==='email'?'block':'none';
+ $('#act-go').textContent = curChan==='email'?'Open in Email':curChan==='linkedin'?'Open LinkedIn':'Call';
+}
+function regen(){
+ const c=contact(DATA.rows[curRow]); const p=$('#purpose').value, tone=$('#tone').value;
+ const d=buildDraft(c,curChan,p,tone);
+ $('#d-subject').value=d.subject||''; $('#d-body').value=d.body;
+ $('#d-target').textContent = d.target?('→ '+d.target):'';
+}
+function buildDraft(c,chan,purpose,tone){
+ const first=(c.first && /^[A-Za-z]/.test(c.first))?c.first:'there', co=c.company||'your team';
+ const hi = tone==='formal'?('Dear '+(c.name||first)+','): (tone==='direct'?('Hi '+first+' —'):('Hi '+first+','));
+ const val={
+ partnership:`I run partnerships for RENTV (Real Estate News Television), the CRE industry's video news network. I'd love to explore ways ${co} and RENTV could work together — from featuring your deals and leadership on our broadcasts to co-marketing across our commercial-real-estate audience.`,
+ sponsorship:`RENTV is lining up sponsors for our upcoming commercial real estate conference, and ${co} stood out as a strong fit. Sponsors get on-camera visibility, stage presence, and direct access to an audience of CRE principals, brokers, and capital sources.`,
+ speaker:`We're building the panel lineup for RENTV's upcoming CRE conference and I'd like to invite ${(c.mvpN||c.name)?('someone from '+co):(co)} to join as a speaker. Your perspective would resonate with our audience of commercial real estate leaders.`,
+ followup:`Following up on RENTV's outreach to ${co} — I wanted to make sure this reached the right person and see whether it's worth a short call this week.`
+ }[purpose];
+ const close = tone==='formal'?'Kind regards,\nSteve Bloom\nRENTV — Real Estate News Television':'Best,\nSteve Bloom\nRENTV — Real Estate News Television';
+ if(chan==='email'){
+ const subj={partnership:'RENTV × '+co+' — partnership',sponsorship:co+' as a RENTV CRE conference sponsor',
+ speaker:'Speaker invite — RENTV CRE conference',followup:'Following up — RENTV × '+co}[purpose];
+ return {subject:subj, body:`${hi}\n\n${val}\n\nWould you be open to a 15-minute call this week? Happy to work around your schedule.\n\n${close}`,
+ target:c.email||'(no email on file)'};
+ }
+ if(chan==='linkedin'){
+ const who = c.mvpN?`${c.mvpN}${c.mvpP?' ('+c.mvpP+')':''} at ${co}`:co;
+ const note=`${hi.replace(/ —$/,'')} — I run partnerships at RENTV (CRE video news). ${purpose==='sponsorship'?'We\'re selecting sponsors for our CRE conference and '+co+' is a great fit.':purpose==='speaker'?'I\'d love to invite '+co+' onto a panel at our CRE conference.':'I\'d love to connect about ways RENTV and '+co+' could work together.'} Open to a quick chat?`;
+ return {subject:'', body:note.slice(0,600), target:(c.liC||c.mvpL||c.liCo)||'(no LinkedIn on file)'};
+ }
+ // phone script
+ return {subject:'', target:c.phone||'(no phone on file)',
+ body:`CALL SCRIPT — ${co}${c.name?' ('+c.name+')':''}\n\n• Opener: "Hi${c.name?' '+first:''}, this is Steve Bloom with RENTV, the commercial real estate news network."\n• Reason: ${val}\n• Ask: "Is there a good 15 minutes this week to walk through it?"\n• If gatekeeper: ask for ${c.mvpN||'the marketing or partnerships lead'}.\n• Leave-behind: offer to email details${c.email?' to '+c.email:''}.`};
+}
+async function doEnhance(){
+ const btn=$('#enhance'); const old=btn.textContent; btn.textContent='✨ thinking…'; btn.disabled=true;
+ const c=contact(DATA.rows[curRow]);
+ const prompt=`Rewrite this ${curChan} outreach so it sounds natural, concise and professional. Keep it truthful, keep the sender "Steve Bloom, RENTV". Return ONLY the rewritten message, no preamble.\n\n---\n${$('#d-body').value}`;
+ try{ const r=await (await fetch('/api/live/enhance',{method:'POST',headers:{'Content-Type':'application/json'},body:JSON.stringify({prompt})})).json();
+ if(r.ok && r.text) $('#d-body').value=r.text; else alert(r.error||'local model unavailable'); }
+ catch(e){ alert('enhance failed: '+e.message); }
+ finally{ btn.textContent=old; btn.disabled=false; }
+}
+function doGo(){
+ const c=contact(DATA.rows[curRow]);
+ if(curChan==='email'){ const to=c.email; if(!to)return alert('No email on file.');
+ location.href='mailto:'+to+'?subject='+encodeURIComponent($('#d-subject').value)+'&body='+encodeURIComponent($('#d-body').value); }
+ else if(curChan==='linkedin'){ const u=c.liC||c.mvpL||c.liCo; if(!u)return alert('No LinkedIn on file.'); navigator.clipboard?.writeText($('#d-body').value); window.open(u,'_blank','noopener'); }
+ else { const p=c.phone; if(!p)return alert('No phone on file.'); location.href='tel:'+p.replace(/[^0-9+]/g,''); }
+}
+
+// ---- events ------------------------------------------------------------------
+$('#tab').onchange=e=>{ GID=+e.target.value; LS.set('gid',GID); GREENSET=new Set(); pull(true).then(pullFormat); };
+document.querySelectorAll('#viewseg button').forEach(b=> b.onclick=()=>{ VIEW=b.dataset.v; LS.set('view',VIEW); render(); });
+$('#refresh').onclick=()=>pull(true).then(pullFormat);
+$('#dclose').onclick=closeDraft; $('#scrim').onclick=closeDraft;
+document.querySelectorAll('#chanseg button').forEach(b=> b.onclick=()=>{ if(b.classList.contains('chdis'))return; curChan=b.dataset.c; syncChanUI(); regen(); });
+$('#purpose').onchange=regen; $('#tone').onchange=regen; $('#regen').onclick=regen;
+$('#enhance').onclick=doEnhance; $('#act-go').onclick=doGo;
+$('#act-copy').onclick=()=>{ navigator.clipboard?.writeText(($('#d-subject').value?('Subject: '+$('#d-subject').value+'\n\n'):'')+$('#d-body').value); $('#act-copy').textContent='✓ Copied'; setTimeout(()=>$('#act-copy').textContent='⧉ Copy draft',1200); };
+document.addEventListener('keydown',e=>{ if(e.key==='Escape')closeDraft(); });
+
+// ---- boot --------------------------------------------------------------------
+(async()=>{ await loadMeta(); await pull(true); pullFormat(); setInterval(()=>pull(false),12000); })();
+</script>
+</body>
+</html>
diff --git a/public/nav-agent/nav-agent.css b/public/nav-agent/nav-agent.css
new file mode 100644
index 00000000..844d7879
--- /dev/null
+++ b/public/nav-agent/nav-agent.css
@@ -0,0 +1,100 @@
+/* ============================================================================
+ * Nav Agent — universal grid-controls drop-in (v1.0)
+ * Left field-toggle panel + sort-every-field + grouping + movable/removable/
+ * expandable data panels. Zero dependencies. Additive & defensive.
+ * Honors the house internal-line-viewer spec (left panel, density type-scale,
+ * tight cards, localStorage-persisted).
+ * ==========================================================================*/
+
+:root{
+ --na-acc:var(--acc,#1f9e8f);
+ --na-line:var(--line,#2a2f3a);
+ --na-bg:var(--panel,#12151c);
+ --na-bg2:var(--bg,#0c0e13);
+ --na-fg:var(--fg,#e7e9ee);
+ --na-mut:var(--mut,#8b93a3);
+}
+
+/* ---- launcher (bottom-left cog) --------------------------------------- */
+.na-launch{position:fixed;left:14px;bottom:14px;z-index:2147483000;
+ width:42px;height:42px;border-radius:50%;border:1px solid var(--na-line);
+ background:var(--na-bg);color:var(--na-fg);font-size:19px;cursor:pointer;
+ display:flex;align-items:center;justify-content:center;
+ box-shadow:0 4px 18px rgba(0,0,0,.45);transition:transform .15s}
+.na-launch:hover{transform:scale(1.08);border-color:var(--na-acc)}
+
+/* ---- left field/sort/group panel -------------------------------------- */
+.na-panel{position:fixed;left:0;top:0;bottom:0;width:290px;z-index:2147483001;
+ background:var(--na-bg);border-right:1px solid var(--na-line);color:var(--na-fg);
+ display:flex;flex-direction:column;font:13px/1.4 system-ui,-apple-system,Segoe UI,Roboto,sans-serif;
+ transform:translateX(-100%);transition:transform .2s ease;box-shadow:2px 0 24px rgba(0,0,0,.4)}
+.na-panel.open{transform:translateX(0)}
+.na-panel header{display:flex;align-items:center;gap:8px;padding:12px 14px;
+ border-bottom:1px solid var(--na-line);font-weight:600;letter-spacing:.3px}
+.na-panel header .na-title{flex:1}
+.na-panel header button{background:none;border:0;color:var(--na-mut);cursor:pointer;font-size:16px;padding:2px 6px;border-radius:4px}
+.na-panel header button:hover{color:var(--na-fg);background:rgba(255,255,255,.06)}
+.na-body{flex:1;overflow:auto;padding:8px 12px 40px}
+.na-sec{border-top:1px solid var(--na-line);padding:10px 0}
+.na-sec:first-child{border-top:0}
+.na-sec>.na-h{display:flex;align-items:center;gap:6px;cursor:pointer;
+ font-weight:600;color:var(--na-mut);text-transform:uppercase;font-size:11px;letter-spacing:.6px;user-select:none}
+.na-sec>.na-h::before{content:'▸';font-size:9px;transition:transform .15s}
+.na-sec.open>.na-h::before{transform:rotate(90deg)}
+.na-sec .na-c{display:none;padding:8px 2px 2px}
+.na-sec.open .na-c{display:block}
+.na-search{width:100%;box-sizing:border-box;background:var(--na-bg2);border:1px solid var(--na-line);
+ color:var(--na-fg);border-radius:6px;padding:8px 10px;margin:4px 0 10px;font-size:13px}
+.na-fieldrow{display:flex;align-items:center;gap:8px;padding:4px 2px;cursor:pointer;border-radius:4px}
+.na-fieldrow:hover{background:rgba(255,255,255,.04)}
+.na-fieldrow input{accent-color:var(--na-acc);cursor:pointer}
+.na-fieldrow .na-cnt{margin-left:auto;color:var(--na-mut);font-size:11px}
+.na-row{display:flex;gap:6px;align-items:center;margin:6px 0}
+.na-row label{color:var(--na-mut);min-width:52px}
+.na-row select,.na-row input[type=range]{flex:1;background:var(--na-bg2);border:1px solid var(--na-line);
+ color:var(--na-fg);border-radius:6px;padding:6px 8px;font-size:13px}
+.na-mini{display:flex;gap:6px;flex-wrap:wrap;margin-top:6px}
+.na-mini button{background:var(--na-bg2);border:1px solid var(--na-line);color:var(--na-fg);
+ border-radius:6px;padding:5px 9px;font-size:12px;cursor:pointer}
+.na-mini button:hover,.na-mini button.on{border-color:var(--na-acc);color:var(--na-acc)}
+.na-reset{width:100%;margin-top:14px;background:var(--na-bg2);border:1px solid var(--na-line);
+ color:var(--na-fg);border-radius:6px;padding:9px;cursor:pointer;font-size:13px}
+.na-reset:hover{border-color:#c0563f;color:#e08a76}
+.na-note{color:var(--na-mut);font-size:11px;padding:2px;line-height:1.5}
+
+/* ---- grouping headers injected into the grid -------------------------- */
+.na-group-h{grid-column:1/-1;display:flex;align-items:center;gap:8px;
+ padding:8px 4px;margin:6px 0 2px;border-bottom:1px solid var(--na-line);
+ color:var(--na-acc);font-weight:600;font-size:13px;cursor:pointer;user-select:none}
+.na-group-h .na-gcount{color:var(--na-mut);font-weight:400}
+.na-group-h.collapsed + .na-group-body{display:none}
+table .na-group-h{display:table-row}
+table .na-group-h td{padding:8px 6px;color:var(--na-acc);font-weight:600;border-bottom:1px solid var(--na-line)}
+
+/* ---- movable / resizable / removable data-panel chrome ---------------- */
+.na-wrap{position:relative}
+.na-bar{display:flex;align-items:center;gap:6px;padding:4px 8px;cursor:move;
+ background:var(--na-bg);border:1px solid var(--na-line);border-bottom:0;
+ border-radius:6px 6px 0 0;color:var(--na-mut);font-size:12px;user-select:none}
+.na-bar .na-bt{flex:1;font-weight:600;color:var(--na-fg)}
+.na-bar button{background:none;border:0;color:var(--na-mut);cursor:pointer;font-size:14px;padding:1px 5px;border-radius:4px}
+.na-bar button:hover{color:var(--na-fg);background:rgba(255,255,255,.08)}
+.na-wrap.na-float{position:fixed;z-index:2000;box-shadow:0 10px 40px rgba(0,0,0,.55);
+ background:var(--na-bg2);border-radius:6px;resize:both;overflow:auto;min-width:280px;min-height:160px}
+.na-wrap.na-collapsed .na-inner{display:none}
+.na-wrap.na-removed{display:none}
+.na-wrap.na-max{position:fixed;inset:12px;z-index:2001;background:var(--na-bg2);
+ box-shadow:0 10px 60px rgba(0,0,0,.6);overflow:auto;resize:none}
+.na-restorebar{position:fixed;left:14px;bottom:66px;z-index:2147483000;display:flex;flex-direction:column;gap:6px}
+.na-restorebar button{background:var(--na-bg);border:1px solid var(--na-line);color:var(--na-fg);
+ border-radius:6px;padding:6px 10px;font-size:12px;cursor:pointer}
+.na-restorebar button:hover{border-color:var(--na-acc)}
+
+/* ---- merged mode: folded INTO an existing house panel ----------------- */
+.na-merge{border-top:1px dashed var(--na-line);margin-top:12px;padding-top:10px}
+.na-merge .na-mh{display:flex;align-items:center;gap:6px;font-weight:600;color:var(--na-acc);
+ text-transform:uppercase;font-size:11px;letter-spacing:.6px;margin-bottom:8px}
+.na-merge .na-row label{color:var(--na-mut);min-width:48px}
+.na-merge select{background:var(--na-bg2);border:1px solid var(--na-line);color:var(--na-fg);border-radius:6px;padding:6px 8px;font-size:13px;flex:1}
+
+@media (max-width:640px){.na-panel{width:86vw}}
diff --git a/public/nav-agent/nav-agent.js b/public/nav-agent/nav-agent.js
new file mode 100644
index 00000000..991a82fd
--- /dev/null
+++ b/public/nav-agent/nav-agent.js
@@ -0,0 +1,478 @@
+/* ============================================================================
+ * Nav Agent — universal grid-controls drop-in (v1.0)
+ *
+ * Drop one <script src=".../nav-agent.js" defer></script> (+ the CSS) onto any
+ * page. It auto-detects the primary data grid (a <table> or a .grid/.card list),
+ * then injects:
+ * • a LEFT collapsible panel: text search, per-FIELD show/hide toggles,
+ * sort-by-any-field (asc/desc), group-by-any-field, density slider
+ * • movable / resizable / collapsible / removable / maximizable panel chrome
+ * on the grid itself
+ * All state persists to localStorage, namespaced per page path, so every
+ * surface remembers its own layout. Strictly additive & wrapped in try/catch —
+ * if it can't understand a page it degrades (panel chrome + search + density)
+ * and never throws into the host page.
+ *
+ * Manual control: window.NavAgent.mount({ target:'#grid', title:'Deals' })
+ * Opt-out a page: <body data-nav-agent="off">
+ * Force a target: <div id="grid" data-nav-grid> ... </div>
+ * ==========================================================================*/
+(function () {
+ 'use strict';
+ if (window.NavAgent) return;
+
+ var _uid = 0;
+ var navKey = function (target) {
+ if (!target.getAttribute('data-na-uid')) target.setAttribute('data-na-uid', target.id || ('g' + (++_uid)));
+ return 'navagent:' + location.pathname + ':' + target.getAttribute('data-na-uid');
+ };
+ var load = function (key) { try { return JSON.parse(localStorage.getItem(key)) || {}; } catch (e) { return {}; } };
+ var save = function (key, s) { try { localStorage.setItem(key, JSON.stringify(s)); } catch (e) {} };
+ var slug = function (t) { return String(t || '').toLowerCase().replace(/[^a-z0-9]+/g, '-').replace(/^-|-$/g, '') || 'f'; };
+ var txt = function (el) { return (el && el.textContent || '').trim(); };
+ // magnitude-aware numeric parse — $2.1B > $780M > 42. Handles K/M/B/T + commas.
+ var num = function (v) {
+ var s = String(v).replace(/,/g, '').trim();
+ var m = s.match(/-?\d*\.?\d+/); if (!m) return null;
+ var n = parseFloat(m[0]); if (isNaN(n)) return null;
+ var suf = (s.slice(m.index + m[0].length).match(/[kmbt]/i) || [''])[0].toLowerCase();
+ var mult = { k: 1e3, m: 1e6, b: 1e9, t: 1e12 }[suf] || 1;
+ return n * mult;
+ };
+ var el = function (tag, cls, html) { var e = document.createElement(tag); if (cls) e.className = cls; if (html != null) e.innerHTML = html; return e; };
+
+ /* -- target detection -------------------------------------------------- */
+ function findTarget(opt) {
+ if (opt && opt.target) return document.querySelector(opt.target);
+ var q = document.querySelector('[data-nav-grid]');
+ if (q) return q;
+ // biggest visible table wins, else #grid, else first .grid, else .cards
+ var tables = [].slice.call(document.querySelectorAll('table'))
+ .filter(function (t) { return t.querySelector('tbody tr') && t.offsetParent !== null; })
+ .sort(function (a, b) { return b.querySelectorAll('tr').length - a.querySelectorAll('tr').length; });
+ if (tables[0] && tables[0].querySelectorAll('tr').length > 2) return tables[0];
+ return document.querySelector('#grid') || document.querySelector('.grid') ||
+ document.querySelector('.cards') || tables[0] || null;
+ }
+
+ /* -- field model ------------------------------------------------------- */
+ // Returns { kind:'table'|'cards', fields:[{key,label,idx?,cls?}], items() }
+ function model(target) {
+ if (target.tagName === 'TABLE') {
+ var ths = [].slice.call(target.querySelectorAll('thead th, thead td'));
+ if (!ths.length) { // header-less table: synthesize from first row
+ var r0 = target.querySelector('tbody tr, tr');
+ ths = r0 ? [].slice.call(r0.children).map(function (_, i) { var s = el('th'); s.textContent = 'Col ' + (i + 1); return s; }) : [];
+ }
+ var fields = ths.map(function (th, i) { return { key: slug(txt(th)) + '-' + i, label: txt(th) || ('Col ' + (i + 1)), idx: i }; });
+ return {
+ kind: 'table', fields: fields,
+ rows: function () { return [].slice.call(target.querySelectorAll('tbody tr')).filter(function (r) { return !r.classList.contains('na-group-h'); }); },
+ cellText: function (row, f) { var c = row.children[f.idx]; return txt(c); }
+ };
+ }
+ // card grid — infer fields from repeated child element classes / [data-field]
+ var cards = [].slice.call(target.children).filter(function (c) { return c.nodeType === 1 && !c.classList.contains('na-group-h') && !c.classList.contains('na-group-body'); });
+ var sample = cards.slice(0, 24), seen = {}, order = [];
+ sample.forEach(function (card) {
+ [].slice.call(card.querySelectorAll('[data-field]')).forEach(function (n) {
+ var k = n.getAttribute('data-field'); if (!seen[k]) { seen[k] = { key: slug(k), label: k, cls: '[data-field="' + k + '"]', df: k, hits: 0 }; order.push(seen[k]); } seen[k].hits++;
+ });
+ // also collect direct-child element classes as coarse fields when no data-field present
+ [].slice.call(card.children).forEach(function (n) {
+ var cls = (n.className && typeof n.className === 'string') ? n.className.split(/\s+/)[0] : '';
+ if (!cls || cls.indexOf('na-') === 0) return;
+ var k = 'c-' + cls;
+ if (!seen[k]) { seen[k] = { key: slug(cls), label: cls.replace(/[-_]/g, ' '), cls: '.' + cls, hits: 0 }; order.push(seen[k]); } seen[k].hits++;
+ });
+ });
+ // keep fields present on a majority of sampled cards (stable structure)
+ var min = Math.max(1, Math.floor(sample.length * 0.4));
+ var fields = order.filter(function (f) { return f.hits >= min; });
+ return {
+ kind: 'cards', cards: true, fields: fields,
+ rows: function () { return [].slice.call(target.children).filter(function (c) { return c.nodeType === 1 && !c.classList.contains('na-group-h') && !c.classList.contains('na-group-body') && c.offsetParent !== null || (c.nodeType === 1 && !c.classList.contains('na-group-h')); }); },
+ cellText: function (card, f) { var n = f.df ? card.querySelector('[data-field="' + f.df + '"]') : card.querySelector(f.cls); return txt(n); }
+ };
+ }
+
+ /* -- one instance ------------------------------------------------------ */
+ function Agent(target, opt) {
+ var key = navKey(target);
+ var st = load(key);
+ var M = model(target);
+ var self = { target: target, model: M, state: st, key: key };
+ var applyingSort = false;
+
+ /* field show/hide via CONTAINER classes (survives host re-renders) */
+ function fieldStyleTag() {
+ var id = 'na-style-' + key.replace(/[^a-z0-9]/gi, '');
+ var tag = document.getElementById(id) || (function () { var t = el('style'); t.id = id; document.head.appendChild(t); return t; })();
+ var css = '';
+ (st.hidden || []).forEach(function (key) {
+ var f = M.fields.filter(function (x) { return x.key === key; })[0]; if (!f) return;
+ if (M.kind === 'table') {
+ css += 'table[data-na] thead th:nth-child(' + (f.idx + 1) + '),table[data-na] tbody td:nth-child(' + (f.idx + 1) + '){display:none}';
+ } else {
+ css += target.getAttribute('data-na-sel') + ' ' + f.cls + '{display:none}';
+ }
+ });
+ tag.textContent = css;
+ }
+
+ function applySort() {
+ if (!st.sort) return;
+ var f = M.fields.filter(function (x) { return x.key === st.sort; })[0]; if (!f) return;
+ var dir = st.dir === 'desc' ? -1 : 1;
+ var rows = M.rows();
+ if (!rows.length) return;
+ applyingSort = true;
+ // detect numeric
+ var numeric = rows.slice(0, 12).every(function (r) { var v = M.cellText(r, f); return v === '' || num(v) !== null; });
+ rows.sort(function (a, b) {
+ var va = M.cellText(a, f), vb = M.cellText(b, f);
+ if (numeric) { var na = num(va), nb = num(vb); na = na == null ? -Infinity : na; nb = nb == null ? -Infinity : nb; return (na - nb) * dir; }
+ return va.localeCompare(vb, undefined, { numeric: true }) * dir;
+ });
+ var parent = M.kind === 'table' ? target.querySelector('tbody') : target;
+ rows.forEach(function (r) { parent.appendChild(r); });
+ applyGroup(); // grouping depends on sorted order
+ applyingSort = false;
+ }
+
+ function clearGroups() {
+ [].slice.call(target.querySelectorAll('.na-group-h')).forEach(function (n) { n.remove(); });
+ }
+
+ function applyGroup() {
+ clearGroups();
+ if (!st.group) return;
+ var f = M.fields.filter(function (x) { return x.key === st.group; })[0]; if (!f) return;
+ var rows = M.rows(), last = null, parent = M.kind === 'table' ? target.querySelector('tbody') : target;
+ var counts = {};
+ rows.forEach(function (r) { var v = M.cellText(r, f) || '—'; counts[v] = (counts[v] || 0) + 1; });
+ rows.forEach(function (r) {
+ var v = M.cellText(r, f) || '—';
+ if (v !== last) {
+ var h;
+ if (M.kind === 'table') { h = el('tr', 'na-group-h'); var td = el('td'); td.colSpan = M.fields.length; td.innerHTML = '▸ ' + esc(v) + ' <span class="na-gcount">(' + counts[v] + ')</span>'; h.appendChild(td); }
+ else { h = el('div', 'na-group-h', '▸ ' + esc(v) + ' <span class="na-gcount">(' + counts[v] + ')</span>'); }
+ parent.insertBefore(h, r); last = v;
+ }
+ });
+ }
+
+ function applySearch() {
+ var qraw = (st.q || '').toLowerCase();
+ M.rows().forEach(function (r) {
+ var show = !qraw || r.textContent.toLowerCase().indexOf(qraw) >= 0;
+ r.style.display = show ? '' : 'none';
+ });
+ }
+
+ function applyAll() { fieldStyleTag(); applySort(); applySearch(); }
+
+ /* re-apply after host re-renders (debounced, ignores our own mutations).
+ If the FIELD SET changed (async data arrived, filter repopulated), tell
+ mount() to rebuild the panel UI. */
+ function fieldSig(m) { return m.kind + ':' + m.fields.map(function (f) { return f.key; }).join(','); }
+ var sig = fieldSig(M);
+ var t;
+ var mo = new MutationObserver(function () {
+ if (applyingSort) return;
+ clearTimeout(t); t = setTimeout(function () {
+ M = model(target); self.model = M;
+ var ns = fieldSig(M);
+ if (ns !== sig) { sig = ns; if (self.onFields) try { self.onFields(); } catch (e) {} }
+ applyAll();
+ }, 140);
+ });
+ try { mo.observe(M.kind === 'table' ? (target.querySelector('tbody') || target) : target, { childList: true }); } catch (e) {}
+
+ self.applyAll = applyAll;
+ self.applySort = applySort;
+ self.applyGroup = applyGroup;
+ self.applySearch = applySearch;
+ self.save = function () { save(key, st); };
+ return self;
+ }
+
+ function esc(s) { return String(s).replace(/[&<>"]/g, function (c) { return ({ '&': '&', '<': '<', '>': '>', '"': '"' })[c]; }); }
+
+ /* -- panel UI ---------------------------------------------------------- */
+ function buildPanel(agent, opt) {
+ var M = agent.model, st = agent.state;
+ var panel = el('aside', 'na-panel');
+ panel.setAttribute('role', 'dialog'); panel.setAttribute('aria-label', 'View controls');
+ var title = (opt && opt.title) || document.title || 'View';
+ panel.appendChild(el('header', null,
+ '<span class="na-title">⚙ View · ' + esc(title) + '</span>' +
+ '<button class="na-x" title="Close">✕</button>'));
+ var body = el('div', 'na-body'); panel.appendChild(body);
+
+ // search
+ var search = el('input', 'na-search'); search.type = 'search'; search.placeholder = 'Search all fields…';
+ search.value = st.q || '';
+ search.addEventListener('input', function () { st.q = search.value; agent.save(); agent.applySearch(); });
+ body.appendChild(search);
+
+ function section(label, openDefault) {
+ var s = el('div', 'na-sec' + (openDefault ? ' open' : ''));
+ s.appendChild(el('div', 'na-h', label));
+ var c = el('div', 'na-c'); s.appendChild(c);
+ s.querySelector('.na-h').addEventListener('click', function () { s.classList.toggle('open'); });
+ body.appendChild(s); return c;
+ }
+
+ var haveFields = M.fields && M.fields.length;
+
+ // FIELDS toggle
+ if (haveFields) {
+ var fc = section('Fields (' + M.fields.length + ')', true);
+ st.hidden = st.hidden || [];
+ M.fields.forEach(function (f) {
+ var row = el('label', 'na-fieldrow');
+ var cb = el('input'); cb.type = 'checkbox'; cb.checked = st.hidden.indexOf(f.key) < 0;
+ cb.addEventListener('change', function () {
+ var i = st.hidden.indexOf(f.key);
+ if (cb.checked && i >= 0) st.hidden.splice(i, 1);
+ else if (!cb.checked && i < 0) st.hidden.push(f.key);
+ agent.save(); agent.applyAll();
+ });
+ row.appendChild(cb);
+ row.appendChild(el('span', null, esc(f.label)));
+ fc.appendChild(row);
+ });
+ var mini = el('div', 'na-mini',
+ '<button data-all>All</button><button data-none>None</button>');
+ mini.querySelector('[data-all]').onclick = function () { st.hidden = []; agent.save(); agent.applyAll(); refreshChecks(); };
+ mini.querySelector('[data-none]').onclick = function () { st.hidden = M.fields.map(function (f) { return f.key; }); agent.save(); agent.applyAll(); refreshChecks(); };
+ fc.appendChild(mini);
+ function refreshChecks() { [].slice.call(fc.querySelectorAll('.na-fieldrow input')).forEach(function (cb, i) { cb.checked = st.hidden.indexOf(M.fields[i].key) < 0; }); }
+ }
+
+ // SORT
+ if (haveFields) {
+ var sc = section('Sort', true);
+ var srow = el('div', 'na-row', '<label>Field</label>');
+ var sel = el('select'); sel.appendChild(new Option('— none —', ''));
+ M.fields.forEach(function (f) { sel.appendChild(new Option(f.label, f.key)); });
+ sel.value = st.sort || ''; srow.appendChild(sel); sc.appendChild(srow);
+ var dir = el('div', 'na-mini', '<button data-asc>▲ Asc</button><button data-desc>▼ Desc</button>');
+ function markDir() { dir.querySelector('[data-asc]').classList.toggle('on', st.dir !== 'desc'); dir.querySelector('[data-desc]').classList.toggle('on', st.dir === 'desc'); }
+ sel.addEventListener('change', function () { st.sort = sel.value; agent.save(); agent.applySort(); });
+ dir.querySelector('[data-asc]').onclick = function () { st.dir = 'asc'; markDir(); agent.save(); agent.applySort(); };
+ dir.querySelector('[data-desc]').onclick = function () { st.dir = 'desc'; markDir(); agent.save(); agent.applySort(); };
+ markDir(); sc.appendChild(dir);
+ }
+
+ // GROUP
+ if (haveFields) {
+ var gc = section('Group by', false);
+ var grow = el('div', 'na-row', '<label>Field</label>');
+ var gsel = el('select'); gsel.appendChild(new Option('— none —', ''));
+ M.fields.forEach(function (f) { gsel.appendChild(new Option(f.label, f.key)); });
+ gsel.value = st.group || ''; grow.appendChild(gsel); gc.appendChild(grow);
+ gsel.addEventListener('change', function () { st.group = gsel.value; agent.save(); agent.applyGroup(); });
+ }
+
+ // DENSITY (only if the target reacts to --cols or has a page density var)
+ var dc = section('Density', false);
+ var drow = el('div', 'na-row', '<label>Cols</label>');
+ var rng = el('input'); rng.type = 'range'; rng.min = 2; rng.max = 12; rng.value = st.cols || getComputedCols(agent.target) || 5;
+ rng.addEventListener('input', function () { st.cols = +rng.value; agent.save(); setCols(agent.target, +rng.value); });
+ drow.appendChild(rng); dc.appendChild(drow);
+ dc.appendChild(el('div', 'na-note', 'Adjusts grid columns where the layout supports it.'));
+ if (st.cols) setCols(agent.target, st.cols);
+
+ if (!haveFields) body.appendChild(el('div', 'na-note',
+ 'No structured fields detected on this grid — field toggles, sort & group need <code><table></code> headers or <code>[data-field]</code>/classed card elements. Search, density and the movable panel are active.'));
+
+ var reset = el('button', 'na-reset', '↺ Reset this page’s view');
+ reset.onclick = function () { try { localStorage.removeItem(agent.key); } catch (e) {} location.reload(); };
+ body.appendChild(reset);
+
+ panel.querySelector('.na-x').onclick = function () { panel.classList.remove('open'); };
+ document.body.appendChild(panel);
+ return panel;
+ }
+
+ function getComputedCols(t) { try { var v = getComputedStyle(t).getPropertyValue('--cols'); return v ? parseInt(v) : null; } catch (e) { return null; } }
+ function setCols(t, n) {
+ try {
+ t.style.setProperty('--cols', n);
+ // fallback for grids without a --cols hook
+ if (!/grid-template-columns/.test(t.style.cssText) && getComputedStyle(t).display === 'grid')
+ t.style.gridTemplateColumns = 'repeat(' + n + ',minmax(0,1fr))';
+ } catch (e) {}
+ }
+
+ /* -- movable / resizable / removable panel chrome ---------------------- */
+ function chrome(agent, opt) {
+ var t = agent.target;
+ if (t.closest('.na-wrap')) return;
+ var wrap = el('div', 'na-wrap');
+ var title = (opt && opt.title) || document.title || 'Data';
+ var bar = el('div', 'na-bar',
+ '<span class="na-bt">▤ ' + esc(title) + '</span>' +
+ '<button data-collapse title="Collapse">▁</button>' +
+ '<button data-max title="Maximize / float">⤢</button>' +
+ '<button data-remove title="Remove panel">✕</button>');
+ var inner = el('div', 'na-inner');
+ t.parentNode.insertBefore(wrap, t);
+ wrap.appendChild(bar); wrap.appendChild(inner); inner.appendChild(t);
+
+ var g = agent.state.geo || {};
+ bar.querySelector('[data-collapse]').onclick = function () { wrap.classList.toggle('na-collapsed'); persist(); };
+ bar.querySelector('[data-max]').onclick = function () { wrap.classList.toggle('na-max'); wrap.classList.remove('na-float'); persist(); };
+ bar.querySelector('[data-remove]').onclick = function () { wrap.classList.add('na-removed'); addRestore(); persist(); };
+
+ // drag to float/move
+ var down = null;
+ bar.addEventListener('mousedown', function (e) {
+ if (e.target.tagName === 'BUTTON') return;
+ var r = wrap.getBoundingClientRect();
+ if (!wrap.classList.contains('na-float')) { wrap.classList.add('na-float'); wrap.style.left = r.left + 'px'; wrap.style.top = r.top + 'px'; wrap.style.width = r.width + 'px'; }
+ down = { x: e.clientX, y: e.clientY, l: parseFloat(wrap.style.left) || r.left, t: parseFloat(wrap.style.top) || r.top };
+ e.preventDefault();
+ });
+ window.addEventListener('mousemove', function (e) {
+ if (!down) return;
+ wrap.style.left = (down.l + e.clientX - down.x) + 'px';
+ wrap.style.top = Math.max(0, down.t + e.clientY - down.y) + 'px';
+ });
+ window.addEventListener('mouseup', function () { if (down) { down = null; persist(); } });
+
+ function persist() {
+ agent.state.geo = {
+ float: wrap.classList.contains('na-float'), max: wrap.classList.contains('na-max'),
+ collapsed: wrap.classList.contains('na-collapsed'), removed: wrap.classList.contains('na-removed'),
+ left: wrap.style.left, top: wrap.style.top, width: wrap.style.width, height: wrap.style.height
+ };
+ agent.save();
+ }
+ function addRestore() {
+ var rb = document.querySelector('.na-restorebar') || (function () { var b = el('div', 'na-restorebar'); document.body.appendChild(b); return b; })();
+ var btn = el('button', null, '⟲ ' + esc(title));
+ btn.onclick = function () { wrap.classList.remove('na-removed'); btn.remove(); persist(); };
+ rb.appendChild(btn);
+ }
+ // restore saved geometry
+ if (g.float) { wrap.classList.add('na-float'); ['left', 'top', 'width', 'height'].forEach(function (k) { if (g[k]) wrap.style[k] = g[k]; }); }
+ if (g.max) wrap.classList.add('na-max');
+ if (g.collapsed) wrap.classList.add('na-collapsed');
+ if (g.removed) { wrap.classList.add('na-removed'); addRestore(); }
+ }
+
+ /* -- merged mode: fold into an existing house panel ("2 into 1") ------- */
+ function findHousePanel(target) {
+ var asides = [].slice.call(document.querySelectorAll('aside, .sidebar, .panel-left, [data-house-panel]'));
+ for (var i = 0; i < asides.length; i++) {
+ var a = asides[i];
+ if (a.classList.contains('na-panel')) continue;
+ if (a.contains(target)) continue; // a real control sidebar won't contain the grid
+ if (a.querySelector('input, select, details, .toggle, .chip')) return a; // has controls
+ }
+ return null;
+ }
+
+ function buildMergeSection(agent, house, opt) {
+ var M = agent.model, st = agent.state;
+ var old = house.querySelector('.na-merge'); if (old) old.remove();
+ var box = el('div', 'na-merge');
+ box.appendChild(el('div', 'na-mh', '⚙ Nav Agent'));
+ if (M.fields && M.fields.length) {
+ // sort ANY field (superset of the house's fixed sort options)
+ var srow = el('div', 'na-row', '<label>Sort</label>');
+ var ssel = el('select'); ssel.appendChild(new Option('— none —', ''));
+ M.fields.forEach(function (f) { ssel.appendChild(new Option(f.label, f.key)); });
+ ssel.value = st.sort || ''; srow.appendChild(ssel); box.appendChild(srow);
+ var dir = el('div', 'na-mini', '<button data-asc>▲ Asc</button><button data-desc>▼ Desc</button>');
+ function markDir() { dir.querySelector('[data-asc]').classList.toggle('on', st.dir !== 'desc'); dir.querySelector('[data-desc]').classList.toggle('on', st.dir === 'desc'); }
+ ssel.onchange = function () { st.sort = ssel.value; agent.save(); agent.applySort(); };
+ dir.querySelector('[data-asc]').onclick = function () { st.dir = 'asc'; agent.save(); agent.applySort(); markDir(); };
+ dir.querySelector('[data-desc]').onclick = function () { st.dir = 'desc'; agent.save(); agent.applySort(); markDir(); };
+ markDir(); box.appendChild(dir);
+ // group ANY field
+ var grow = el('div', 'na-row', '<label>Group</label>');
+ var gsel = el('select'); gsel.appendChild(new Option('— none —', ''));
+ M.fields.forEach(function (f) { gsel.appendChild(new Option(f.label, f.key)); });
+ gsel.value = st.group || ''; gsel.onchange = function () { st.group = gsel.value; agent.save(); agent.applyGroup(); };
+ grow.appendChild(gsel); box.appendChild(grow);
+ }
+ box.appendChild(el('div', 'na-note', 'Drag the grid’s ▤ bar to float · ▁ collapse · ⤢ maximize · ✕ remove.'));
+ house.appendChild(box);
+ return box;
+ }
+
+ /* -- public mount ------------------------------------------------------ */
+ var API = {
+ instances: [],
+ mount: function (opt) {
+ opt = opt || {};
+ try {
+ var target = findTarget(opt);
+ if (!target) return null;
+ if (target.__naMounted) return target.__naAgent;
+ target.__naMounted = true;
+ if (target.tagName === 'TABLE') target.setAttribute('data-na', '1');
+ else target.setAttribute('data-na-sel', target.id ? '#' + target.id : '.' + (target.className.split(/\s+/)[0] || 'grid'));
+ var agent = Agent(target, opt);
+ target.__naAgent = agent;
+ // "2 into 1": if the page already has a house control panel, fold into it
+ var house = opt.merge === false ? null : findHousePanel(target);
+ // (re)build the controls — called again by the observer when fields change
+ function makePanel() {
+ if (house) { agent._merge = buildMergeSection(agent, house, opt); return; }
+ var wasOpen = agent._panel && agent._panel.classList.contains('open');
+ if (agent._panel) agent._panel.remove();
+ agent._panel = buildPanel(agent, opt);
+ if (wasOpen) agent._panel.classList.add('open');
+ }
+ agent.onFields = makePanel;
+ agent.merged = !!house;
+ makePanel();
+ chrome(agent, opt);
+ agent.applyAll();
+
+ // standalone launcher only when NOT merged into a house panel
+ if (!house && !document.querySelector('.na-launch')) {
+ var b = el('button', 'na-launch', '⚙'); b.title = 'View controls';
+ b.onclick = function () {
+ var anyOpen = document.querySelector('.na-panel.open');
+ [].slice.call(document.querySelectorAll('.na-panel')).forEach(function (p) { p.classList.toggle('open', !anyOpen); });
+ };
+ document.body.appendChild(b);
+ }
+ API.instances.push(agent);
+ return agent;
+ } catch (e) { if (window.console) console.warn('[nav-agent] mount skipped:', e); return null; }
+ }
+ };
+ window.NavAgent = API;
+
+ function boot() {
+ try {
+ var body = document.body;
+ if (!body || body.getAttribute('data-nav-agent') === 'off') return;
+ // wait a tick for API-driven grids to render their first batch
+ var tries = 0;
+ (function attempt() {
+ var t = findTarget();
+ var populated = false;
+ if (t) {
+ if (t.tagName === 'TABLE') populated = !!t.querySelector('tbody tr');
+ else {
+ var kids = [].slice.call(t.children).filter(function (c) { return c.nodeType === 1; });
+ // ignore an empty-state placeholder (a lone div, often "No … match")
+ populated = !!t.querySelector('.card') || kids.length >= 2;
+ }
+ }
+ if (populated || tries++ > 32) { API.mount(); return; } // mount anyway after ~8s; observer fills fields when data arrives
+ setTimeout(attempt, 250);
+ })();
+ } catch (e) {}
+ }
+ if (document.readyState === 'loading') document.addEventListener('DOMContentLoaded', boot);
+ else boot();
+})();
diff --git a/scripts/lib/sheets.cjs b/scripts/lib/sheets.cjs
new file mode 100644
index 00000000..93986055
--- /dev/null
+++ b/scripts/lib/sheets.cjs
@@ -0,0 +1,178 @@
+'use strict';
+// sheets.cjs — Node port of rentv-sheet-enrich/lib.py (+ live_server.py helpers).
+// Pure built-in fetch, no googleapis SDK. Refreshes an access token from the desktop
+// OAuth client + SHEETS_REFRESH_TOKEN, then talks to the Sheets REST API v4.
+//
+// Every cell this module WRITES is stamped LIGHT-GREEN so Steve can see at a glance
+// what was auto-filled vs. what was already in the sheet. ADD-only, never bulk-overwrite.
+//
+// Credentials resolve from process.env first, then fall back to the canonical
+// ~/Projects/secrets-manager/.env (so the refresh token is never duplicated into this
+// repo). On Kamatera prod, secrets-manager is absent — set YT_UPLOAD_CLIENT_ID,
+// YT_UPLOAD_CLIENT_SECRET, SHEETS_REFRESH_TOKEN (+ optional SHEET_ID) in rentv/.env.
+const fs = require('fs');
+const os = require('os');
+const path = require('path');
+
+const API = 'https://sheets.googleapis.com/v4/spreadsheets';
+const DEFAULT_SID = '1yDmtj9Wxe71SaoQm8xpFsn722B4Ws67hTtPIHeXoN9E';
+// Light green fill for auto-populated cells (≈ #cbe6b4) — matches lib.py GREEN exactly.
+const GREEN = { red: 0.796, green: 0.902, blue: 0.706 };
+
+// Lazily read the canonical secrets file once (fallback only; env wins).
+let _fileEnv = null;
+function fileEnv() {
+ if (_fileEnv) return _fileEnv;
+ _fileEnv = {};
+ try {
+ const p = path.join(os.homedir(), 'Projects', 'secrets-manager', '.env');
+ for (const ln of fs.readFileSync(p, 'utf8').split('\n')) {
+ const m = ln.match(/^([A-Z0-9_]+)=(.*)$/);
+ if (m) _fileEnv[m[1]] = m[2].replace(/^["']|["']$/g, '');
+ }
+ } catch { /* no secrets file (e.g. prod) — rely on process.env */ }
+ return _fileEnv;
+}
+const cred = (k) => process.env[k] || fileEnv()[k];
+const SID = () => cred('SHEET_ID') || DEFAULT_SID;
+
+// ── OAuth: refresh-token grant, cached ~50min ───────────────────────────────
+let _tok = null, _tokExp = 0;
+async function accessToken() {
+ const now = Date.now();
+ if (_tok && now < _tokExp) return _tok;
+ const cid = cred('YT_UPLOAD_CLIENT_ID');
+ const csec = cred('YT_UPLOAD_CLIENT_SECRET');
+ const rt = cred('SHEETS_REFRESH_TOKEN');
+ if (!rt) throw new Error('Not connected — SHEETS_REFRESH_TOKEN missing (run connect.py).');
+ const body = new URLSearchParams({
+ client_id: cid, client_secret: csec, refresh_token: rt, grant_type: 'refresh_token',
+ });
+ const r = await fetch('https://oauth2.googleapis.com/token', {
+ method: 'POST', headers: { 'Content-Type': 'application/x-www-form-urlencoded' }, body,
+ });
+ if (!r.ok) throw new Error(`OAuth token refresh -> ${r.status}: ${(await r.text()).slice(0, 300)}`);
+ const j = await r.json();
+ _tok = j.access_token;
+ _tokExp = now + Math.max(60, (j.expires_in || 3600) - 300) * 1000; // refresh 5min early
+ return _tok;
+}
+
+// A 429/quota error the caller can surface as a soft "retry shortly" (HTTP 503).
+class QuotaError extends Error {}
+
+async function sreq(method, url, body) {
+ const tok = await accessToken();
+ const r = await fetch(url, {
+ method,
+ headers: { Authorization: `Bearer ${tok}`, 'Content-Type': 'application/json' },
+ body: body != null ? JSON.stringify(body) : undefined,
+ });
+ if (!r.ok) {
+ const txt = (await r.text()).slice(0, 500);
+ if (r.status === 429 || /RESOURCE_EXHAUSTED|RATE_LIMIT/.test(txt)) {
+ throw new QuotaError('Sheets read quota (60/min) hit — retrying shortly');
+ }
+ throw new Error(`Sheets API ${method} ${url.split('?')[0]} -> ${r.status}: ${txt}`);
+ }
+ return r.json();
+}
+
+// Retry a Sheets-reading fn, backing off on 429 (matches live_server.py retry()).
+async function retry(fn, tries = 5) {
+ for (let i = 0; i < tries; i++) {
+ try { return await fn(); }
+ catch (e) {
+ if (e instanceof QuotaError && i < tries - 1) {
+ await new Promise((res) => setTimeout(res, 1500 * (i + 1)));
+ continue;
+ }
+ throw e;
+ }
+ }
+}
+
+// ── raw helpers (port of lib.py) ────────────────────────────────────────────
+const getMeta = () =>
+ sreq('GET', `${API}/${SID()}?fields=sheets(properties(sheetId,title,gridProperties))`);
+
+function a1(title) { return encodeURIComponent("'" + String(title).replace(/'/g, "''") + "'"); }
+
+const readTab = async (title) =>
+ (await sreq('GET', `${API}/${SID()}/values/${a1(title)}?majorDimension=ROWS`)).values || [];
+
+async function batchFill(sheetId, cells) {
+ if (!cells || !cells.length) return { skipped: true };
+ const requests = cells.map((c) => ({
+ updateCells: {
+ start: { sheetId, rowIndex: c.row0, columnIndex: c.col0 },
+ rows: [{ values: [{
+ userEnteredValue: c.formula ? { formulaValue: String(c.value) } : { stringValue: String(c.value) },
+ userEnteredFormat: { backgroundColor: GREEN },
+ }] }],
+ fields: 'userEnteredValue,userEnteredFormat.backgroundColor',
+ },
+ }));
+ const CHUNK = 400; let total = 0;
+ for (let i = 0; i < requests.length; i += CHUNK) {
+ await sreq('POST', `${API}/${SID()}:batchUpdate`, { requests: requests.slice(i, i + CHUNK) });
+ total += requests.slice(i, i + CHUNK).length;
+ }
+ return { totalUpdatedCells: total };
+}
+
+// ── console-facing helpers (port of live_server.py) ─────────────────────────
+async function meta() {
+ const m = await retry(getMeta);
+ return m.sheets.map((s) => ({ gid: s.properties.sheetId, title: s.properties.title }));
+}
+
+async function titleForGid(gid) {
+ const m = await retry(getMeta);
+ const hit = m.sheets.find((s) => s.properties.sheetId === Number(gid));
+ if (!hit) throw new Error(`No tab with gid=${gid}`);
+ return hit.properties.title;
+}
+
+async function tab(gid) {
+ gid = Number(gid);
+ const title = await titleForGid(gid);
+ const rows = await retry(() => readTab(title));
+ const headers = rows.length ? rows[0].map((h) => String(h).trim()) : [];
+ const w = headers.length;
+ const body = (rows.slice(1)).map((r) => Array.from({ length: w }, (_, i) => (i < r.length ? r[i] : '')));
+ return { gid, title, headers, rows: body };
+}
+
+// Sparse 'r,c' list (0-based over DATA rows) of light-green (auto-filled) cells.
+async function greenMap(gid) {
+ gid = Number(gid);
+ const title = await titleForGid(gid);
+ const rng = a1(title);
+ const url = `${API}/${SID()}?ranges=${rng}&includeGridData=true`
+ + '&fields=sheets.data.rowData.values.effectiveFormat.backgroundColor';
+ const res = await retry(() => sreq('GET', url));
+ const isGreen = (bg) => bg
+ && Math.abs((bg.red ?? 1) - GREEN.red) < 0.06
+ && Math.abs((bg.green ?? 1) - GREEN.green) < 0.06
+ && Math.abs((bg.blue ?? 1) - GREEN.blue) < 0.06;
+ let rowData = [];
+ try { rowData = res.sheets[0].data[0].rowData || []; } catch { rowData = []; }
+ const green = [];
+ rowData.forEach((row, ri) => {
+ if (ri === 0) return; // header row -> data index is ri-1
+ (row.values || []).forEach((cell, ci) => {
+ const bg = (cell.effectiveFormat || {}).backgroundColor;
+ if (isGreen(bg)) green.push(`${ri - 1},${ci}`);
+ });
+ });
+ return { gid, green };
+}
+
+// row0 is 0-based over DATA rows shown in the UI; +1 for the header row.
+async function writeCell(gid, row0, col0, value, formula = false) {
+ await batchFill(Number(gid), [{ row0: Number(row0) + 1, col0: Number(col0), value, formula }]);
+ return { ok: true };
+}
+
+module.exports = { meta, tab, greenMap, writeCell, QuotaError, GREEN };
diff --git a/server.js b/server.js
index 78415d09..e9b8b1ae 100644
--- a/server.js
+++ b/server.js
@@ -2818,6 +2818,42 @@ app.use((req, res, next) => {
}
next();
});
+// ── RENTV Live Console (TK-10542) — folded in from rentv-sheet-enrich/live_server.py ──────────
+// Two-way web console over the RENTV CRE-contacts Google Sheet: pull tabs (Sheet→UI), write a
+// single cell green (UI→Sheet), optional local-Ollama draft polish ($0). ADD-only, never bulk
+// overwrite. Admin-gated like every other internal tool. Sheets creds resolve in sheets.cjs
+// (process.env → ~/Projects/secrets-manager/.env fallback). Registered BEFORE the catch-all
+// static/injector below so /live can never leak un-authed via express.static, and so the console
+// is served raw (res.sendFile) without the site toggle/nav/footer being spliced into it.
+const sheets = require('./scripts/lib/sheets.cjs');
+const DRAFT_MODEL = process.env.DRAFT_MODEL || 'qwen3:14b';
+const liveErr = (r, e) => (e instanceof sheets.QuotaError)
+ ? r.status(503).json({ error: e.message, retry: true })
+ : r.status(500).json({ error: String(e && e.message || e).slice(0, 400) });
+const sendConsole = (_q, r) => r.sendFile(path.join(PUB, 'live', 'index.html'));
+app.get('/live', adminOnly, sendConsole);
+app.get('/live/', adminOnly, sendConsole);
+app.get('/api/live/meta', adminOnly, async (_q, r) => { try { r.json(await sheets.meta()); } catch (e) { liveErr(r, e); } });
+app.get('/api/live/tab', adminOnly, async (q, r) => { try { r.json(await sheets.tab(q.query.gid || '0')); } catch (e) { liveErr(r, e); } });
+app.get('/api/live/format', adminOnly, async (q, r) => { try { r.json(await sheets.greenMap(q.query.gid || '0')); } catch (e) { liveErr(r, e); } });
+app.post('/api/live/write', adminOnly, async (q, r) => {
+ try { const b = q.body || {}; r.json(await sheets.writeCell(b.gid, b.row0, b.col0, b.value ?? '', !!b.formula)); }
+ catch (e) { liveErr(r, e); }
+});
+app.post('/api/live/enhance', adminOnly, async (q, r) => {
+ try {
+ const resp = await fetch(OLLAMA_URL + '/api/generate', {
+ method: 'POST', headers: { 'Content-Type': 'application/json' },
+ body: JSON.stringify({ model: DRAFT_MODEL, prompt: (q.body || {}).prompt || '', stream: false, options: { temperature: 0.5 } }),
+ signal: AbortSignal.timeout(60000),
+ });
+ if (!resp.ok) return r.json({ ok: false, error: 'local model unavailable (' + resp.status + ')' });
+ let out = String((await resp.json()).response || '').trim();
+ if (out.includes('</think>')) out = out.split('</think>')[1].trim(); // strip qwen <think> blocks
+ r.json({ ok: true, text: out });
+ } catch (e) { r.json({ ok: false, error: 'local model unavailable (' + String(e && e.message || e).slice(0, 120) + ')' }); }
+});
+
// Inject the Front End ⇄ Backend toggle into HTML pages that express.static would serve
// (index + direct *.html + extensionless→.html), mirroring its extensions:['html'] resolution.
// Non-HTML assets (js/css/img/json/mp4) fall straight through to express.static untouched.
← 1c6d8d99 auto-data-snapshot: 2026-08-13T13:27:38 (7 data files) — dat
·
back to Rentv
·
auto-data-snapshot: 2026-08-13T13:58:08 (7 data files) — dat 2166d7d2 →