5x night item 3: wire nonqm segment agent count (union of non-FHA condo agents + 1-9-unit/mixed listing agents) — was unwired/0, now 1696

b6a5bddff4963a2f86f33bd7681e24fae0eea95f · 2026-06-28 23:03:08 -0700 · Steve

Files touched

M scripts/serve.js

Diff

commit b6a5bddff4963a2f86f33bd7681e24fae0eea95f
Author: Steve <steve@designerwallcoverings.com>
Date:   Sun Jun 28 23:03:08 2026 -0700

    5x night item 3: wire nonqm segment agent count (union of non-FHA condo agents + 1-9-unit/mixed listing agents) — was unwired/0, now 1696
---
 scripts/serve.js | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/scripts/serve.js b/scripts/serve.js
index 2dd8897..9a359cc 100644
--- a/scripts/serve.js
+++ b/scripts/serve.js
@@ -526,6 +526,12 @@ app.get('/api/segments', async (req, res) => {
            ) u`)).rows[0].n;
       } else if (seg.src === 'nonqm') {
         props = (await brokerdb.pool.query(`SELECT (SELECT count(*) FROM condo WHERE warrantable_status<>'fha_approved') + (SELECT count(*) FROM listing WHERE units BETWEEN 1 AND 9 OR type ILIKE '%mixed%') n`)).rows[0].n;
+        // agents across BOTH union legs (was unwired → showed 0): non-FHA condo agents ∪ 1-9-unit/mixed listing agents
+        agents = (await brokerdb.pool.query(
+          `SELECT count(DISTINCT broker_id)::int n FROM (
+             SELECT bc.broker_id FROM condo c JOIN broker_condo bc ON bc.condo_id=c.id WHERE c.warrantable_status<>'fha_approved'
+             UNION SELECT bl.broker_id FROM listing l JOIN broker_listing bl ON bl.listing_id=l.id WHERE (l.units BETWEEN 1 AND 9 OR l.type ILIKE '%mixed%')
+           ) u`)).rows[0].n;
       }
       const noAgents = (seg.src === 'sfr' || seg.src === 'assumable') && agents === 0;
       out.push({ key, label: seg.label, product: seg.product, hook: seg.hook, props, agents,

← f98b8af 5x night item 1: map.html — aerial-img onerror graceful fall · back to Commercialrealestate · 5x night-log: items 1+3 done; queue + method note for next w cdaa2b4 →