condos table DRE# (Cody gate): resolve broker_dre BEFORE the null-guard so agents-only listings show the license (not '—'), + digit-format guard before linking

a5ff4d2297caaef66ea0006b3fe2ed0048594d42 · 2026-08-03 11:22:16 -0700 · Steve Abrams

Files touched

M public/condos.html

Diff

commit a5ff4d2297caaef66ea0006b3fe2ed0048594d42
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 3 11:22:16 2026 -0700

    condos table DRE# (Cody gate): resolve broker_dre BEFORE the null-guard so agents-only listings show the license (not '—'), + digit-format guard before linking
---
 public/condos.html | 12 ++++++++----
 1 file changed, 8 insertions(+), 4 deletions(-)

diff --git a/public/condos.html b/public/condos.html
index 4a95ffd..05c556f 100644
--- a/public/condos.html
+++ b/public/condos.html
@@ -236,14 +236,18 @@ function applyDrill(kind,val){ if(val==null||val==='') return;
 function fval(c,f){ return f.calc?f.calc(c):c[f.k]; }
 function fcell(c,f){ const v=fval(c,f);
   if(f.badge) return statusBadge(c.warrantable_status||c.warrant_signal||'—');
+  // broker_dre resolves BEFORE the null-guard (Cody gate): a listing may carry the license in
+  // agents[0].dre while the flat broker_dre is empty — the table must match the card, not show '—'.
+  if(f.k==='broker_dre'){ const primary=(v!=null&&v!=='')?v:(c.agents&&c.agents[0]&&c.agents[0].dre);
+    if(!primary) return '—';
+    const extra=(Array.isArray(c.agents)&&c.agents.length>1)?` <span style="color:var(--mut);font-size:10px" title="${c.agents.length-1} co-agent license(s) — see card/detail">+${c.agents.length-1}</span>`:'';
+    if(!/^\d{6,8}$/.test(String(primary))) return esc(String(primary))+extra;   // defensive: only link a real DRE#
+    const u=c.dre_url||('https://www2.dre.ca.gov/PublicASP/pplinfo.asp?License_id='+primary);
+    return `<a href="${esc(u)}" target="_blank" rel="noopener noreferrer" title="Full CA DRE license record">${esc(primary)} ↗</a>${extra}`; }
   if(v==null||v==='') return '—';
   if(f.money) return '$'+(+v).toLocaleString()+(f.suf||'');
   if(f.num) return (+v).toLocaleString();
   if(f.date){ return dateTimeSpan(v)||'—'; }
-  if(f.k==='broker_dre'){ const primary=v||(c.agents&&c.agents[0]&&c.agents[0].dre); if(!primary) return '—';
-    const u=c.dre_url||('https://www2.dre.ca.gov/PublicASP/pplinfo.asp?License_id='+primary);
-    const extra=(Array.isArray(c.agents)&&c.agents.length>1)?` <span style="color:var(--mut);font-size:10px" title="${c.agents.length-1} co-agent license(s) — see card/detail">+${c.agents.length-1}</span>`:'';
-    return `<a href="${esc(u)}" target="_blank" rel="noopener noreferrer" title="Full CA DRE license record">${esc(primary)} ↗</a>${extra}`; }
   if(f.k==='firm_name') return drillSpan('firm',v);
   if(f.k==='city') return drillSpan('city',v);
   return esc(v)+(f.suf||'');

← ea6498d condos table: add drillable DRE# column (License# → CA DRE r · back to Commercialrealestate · fetch-sfr-agents: record ALL license numbers per SFR listing 5bb6bfb →