auto-save: 2026-07-26T08:11:40 (1 files) — src/server/index.ts

4b82a3d3ee0e5dd6504f23856116b73ab1f819d5 · 2026-07-26 08:11:41 -0700 · Steve Abrams

Files touched

M src/server/index.ts

Diff

commit 4b82a3d3ee0e5dd6504f23856116b73ab1f819d5
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sun Jul 26 08:11:41 2026 -0700

    auto-save: 2026-07-26T08:11:40 (1 files) — src/server/index.ts
---
 src/server/index.ts | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/src/server/index.ts b/src/server/index.ts
index e3bd5e9..6d0426f 100644
--- a/src/server/index.ts
+++ b/src/server/index.ts
@@ -259,6 +259,12 @@ app.get('/api/brokers', async (req, res) => {
     if (req.query.city) { params.push(String(req.query.city).toUpperCase()); conds.push(`upper(b.city) = $${params.length}`); }
     if (req.query.q) { params.push('%' + String(req.query.q) + '%'); conds.push(`(b.name ILIKE $${params.length} OR f.name ILIKE $${params.length} OR b.license_no ILIKE $${params.length})`); }
     if (req.query.firm) { params.push('%' + String(req.query.firm) + '%'); conds.push(`f.name ILIKE $${params.length}`); }
+    if (req.query.status) {
+      const s = String(req.query.status).toLowerCase();
+      // convenience: ?status=active matches ACTIVE + "ACTIVE UNDER REVIEW"; else exact-ish match
+      if (s === 'active') { conds.push(`b.license_status ILIKE 'active%'`); }
+      else { params.push(s); conds.push(`lower(b.license_status) = $${params.length}`); }
+    }
     const where = conds.length ? 'WHERE ' + conds.join(' AND ') : '';
     params.push(limit, offset);
     const r = await query(

← 9c0ce40 Parcel coverage: 2026-07-26 re-probe intel (Franklin OH shp- · back to Nationalrealestate · brokers: license_status filter (?status=active) on /api/brok a74ceb3 →