console: /api/summit/licensed (realestate DB) + facet wiring — title/escrow/contractor/lender/attorney load real licensed names, grounded letters

13b6880c934608d60bba7b5a5a284fca717cde7c · 2026-07-30 21:41:57 -0700 · Steve
Files touched

M public/social.html
Diff

commit 13b6880c934608d60bba7b5a5a284fca717cde7c
Author: Steve <steve@designerwallcoverings.com>
Date:   Thu Jul 30 21:41:57 2026 -0700

    console: /api/summit/licensed (realestate DB) + facet wiring — title/escrow/contractor/lender/attorney load real licensed names, grounded letters
---
 public/social.html | 26 ++++++++++++++++++++------
 1 file changed, 20 insertions(+), 6 deletions(-)

diff --git a/public/social.html b/public/social.html
index 3737c091..b985fb33 100644
--- a/public/social.html
+++ b/public/social.html
@@ -497,7 +497,7 @@
   function fchip(txt,on,reg,group){ return '<span class="gchip'+(on?' on':'')+(reg?' reg':'')+'" data-fg="'+group+'" data-fk="'+esc(txt)+'">'+esc(txt)+'</span>'; }
   function selArr(o){ return Object.keys(o).filter(function(k){ return o[k]; }); }
   function renderFacets(){
-    document.getElementById('fRoles').innerHTML=GROLES_F.map(function(r){ return fchip(r,GF.roles[r],!!GF_REGROLE[r],'roles'); }).join('');
+    document.getElementById('fRoles').innerHTML=GROLES_F.map(function(r){ return fchip(r,GF.roles[r],!!GF_REGROLE[r]||!!GF_LICENSED[r],'roles'); }).join('');
     document.getElementById('fMarkets').innerHTML=GMKTS.map(function(m){ return fchip(m.k,GF.markets[m.k],m.reg,'markets'); }).join('');
     document.getElementById('fSectors').innerHTML=GSECS.map(function(s){ return fchip(s,GF.sectors[s],false,'sectors'); }).join('');
     composeSeg();
@@ -507,13 +507,14 @@
     var roleKw=roles.map(function(r){ return ROLE_KW[r]||r; }).join(' OR ');
     var terms=[secs.join(' '),'commercial real estate',roleKw,mkts.map(function(m){ return m.replace(/\s*\(.*\)/,''); }).join(' ')].filter(Boolean).join(' ').replace(/\s+/g,' ').trim();
     var regMkt=mkts.filter(function(m){ var g=GMKTS.filter(function(z){return z.k===m;})[0]; return g&&g.reg; })[0];
-    var regRole=roles.filter(function(r){ return GF_REGROLE[r]; })[0];
-    var registry=!!(regMkt&&regRole);
+    var usreRole=roles.filter(function(r){ return GF_REGROLE[r]; })[0];
+    var licRole=roles.filter(function(r){ return GF_LICENSED[r]; })[0];
+    var registry=!!((regMkt&&usreRole)||licRole);   // usre needs a CA metro; licensed roles are all-SoCal
     var tag=document.getElementById('fTag'); tag.className='ftag '+(registry?'reg':'lens'); tag.textContent=registry?'registry ✓ real names':'LinkedIn search';
     document.getElementById('fOut').textContent=(roles.length||mkts.length||secs.length)?terms:'Pick role · market · sector…';
     var rb=document.getElementById('fReg'); rb.style.display=registry?'':'none';
-    if(registry) rb.textContent='⤵ Load '+regMkt+' '+regRole.split(' ')[0].toLowerCase();
-    GF._terms=terms; GF._regMkt=regMkt; GF._regRole=regRole; GF._registry=registry; GF._roles=roles; GF._mkts=mkts; GF._secs=secs;
+    if(registry){ rb.textContent=licRole ? ('⤵ Load '+GF_LICENSED[licRole]+(regMkt?(' · '+regMkt):' · all SoCal')) : ('⤵ Load '+regMkt+' '+usreRole.split(' ')[0].toLowerCase()); }
+    GF._terms=terms; GF._regMkt=regMkt; GF._usreRole=usreRole; GF._licRole=licRole; GF._registry=registry; GF._roles=roles; GF._mkts=mkts; GF._secs=secs;
   }
   document.getElementById('gfacet').addEventListener('click',function(e){
     var c=e.target.closest('.gchip'); if(!c)return;
@@ -529,7 +530,20 @@
     gsave(l); grender(); gmsg('Segment pinned ✓');
   };
   document.getElementById('fReg').onclick=function(){
-    if(!GF._registry)return; var type=GF_REGROLE[GF._regRole], metro=GF._regMkt;
+    if(!GF._registry)return;
+    if(GF._licRole){ // licensed CRE roles from the realestate DB (title/escrow/contractor/lender/attorney)
+      var lrole=GF_LICENSED[GF._licRole], mkt=GF._regMkt||'';
+      gmsg('Loading '+lrole+'…');
+      fetch('/api/summit/licensed?role='+encodeURIComponent(lrole)+(mkt?('&market='+encodeURIComponent(mkt)):'')+'&limit=200',{credentials:'same-origin'})
+        .then(function(r){ return r.json(); }).then(function(d){
+          var l=gload(), seen={}; l.forEach(function(x){ if(x.rid) seen[x.rid]=1; }); var now=Date.now(), added=0;
+          (d.rows||[]).forEach(function(r){ var rid='L'+r.id; if(seen[rid])return; seen[rid]=1;
+            l.push({id:gid(),rid:rid,kind:'contact',cat:GF._licRole,name:cap(r.entity_name),sub:[cap(r.city||''),r.license_type||''].filter(Boolean).join(' · ')+(r.license_no?(' · '+r.license_no):''),terms:r.entity_name+' '+(r.city||'')+' commercial real estate',market:r.market,status:0,added:now}); added++; });
+          gsave(l); grender(); gmsg(added ? ('Loaded '+added+' '+lrole+' ✓') : 'No new records.');
+        }).catch(function(){ gmsg('realestate unavailable.'); });
+      return;
+    }
+    var type=GF_REGROLE[GF._usreRole], metro=GF._regMkt;
     gmsg('Loading '+metro+'…');
     fetch('/api/summit/leads?type='+type+'&metro='+encodeURIComponent(metro)+'&limit=100',{credentials:'same-origin'})
       .then(function(r){ return r.json(); }).then(function(d){
← 2d3f9477 yoloforever: 🎯 CALIFORNIA QUALITY GATE PASSED (71% coverage · back to Rentv 2026 · pr-intelligence: Arizona Phase-2 seed (67 real AZ CRE orgs, 2ed7c872 →