Import Shangoo Pharmacy tax profile: prescription_fill table + 277 fills + 83 meds + /prescriptions viewer

542a632bc42ea30eb9e1d8aab4e4719e0068a070 · 2026-07-08 14:38:12 -0700 · Steve

- 0009_prescription_fills.sql: fill-history table (date/drug/rx/qty/days/doctor/plan/plan-paid, raw OCR audit)
- scripts/load-abrams-rx.js: OCR-parsed loader, reconciled to doc totals (Natalia 220 fills / $136,254.86 of $136,328.74)
- creates person Steve (self) + Natalia (spouse); dedupes 83 medications into medication table
- routes/prescriptions.js + views/prescriptions.ejs: read-only viewer w/ per-person totals + filter; nav 'Rx'

Files touched

M server.js
M views/partials/header.ejs

Diff

commit 542a632bc42ea30eb9e1d8aab4e4719e0068a070
Author: Steve <steve@designerwallcoverings.com>
Date:   Wed Jul 8 14:38:12 2026 -0700

    Import Shangoo Pharmacy tax profile: prescription_fill table + 277 fills + 83 meds + /prescriptions viewer
    
    - 0009_prescription_fills.sql: fill-history table (date/drug/rx/qty/days/doctor/plan/plan-paid, raw OCR audit)
    - scripts/load-abrams-rx.js: OCR-parsed loader, reconciled to doc totals (Natalia 220 fills / $136,254.86 of $136,328.74)
    - creates person Steve (self) + Natalia (spouse); dedupes 83 medications into medication table
    - routes/prescriptions.js + views/prescriptions.ejs: read-only viewer w/ per-person totals + filter; nav 'Rx'
---
 server.js                 | 2 ++
 views/partials/header.ejs | 1 +
 2 files changed, 3 insertions(+)

diff --git a/server.js b/server.js
index fcc24cf..7ec6b9e 100644
--- a/server.js
+++ b/server.js
@@ -27,6 +27,7 @@ const reordersRouter = require('./routes/reorders');
 const warrantiesRouter = require('./routes/warranties');
 const peopleRouter = require('./routes/people');
 const medicationsRouter = require('./routes/medications');
+const prescriptionsRouter = require('./routes/prescriptions');
 
 const app = express();
 const PORT = parseInt(process.env.PORT || '9931', 10);
@@ -89,6 +90,7 @@ app.use(reordersRouter);            // /reorders, /api/reorders*
 app.use(warrantiesRouter);          // /warranties, /api/warranties*
 app.use(peopleRouter);              // /household, /api/people*
 app.use(medicationsRouter);         // /medications, /api/medications*
+app.use(prescriptionsRouter);       // /prescriptions, /api/prescriptions
 
 // Step-up-required routes (must re-verify TOTP within 60s)
 app.use('/import', requireStepUp, importRouter);
diff --git a/views/partials/header.ejs b/views/partials/header.ejs
index a6bc282..3a4a795 100644
--- a/views/partials/header.ejs
+++ b/views/partials/header.ejs
@@ -27,6 +27,7 @@
       <a href="/warranties">Warranties</a>
       <a href="/reorders">Reorders</a>
       <a href="/medications">Meds</a>
+      <a href="/prescriptions">Rx</a>
       <a href="/household">Household</a>
       <a href="/purchases">Purchases</a>
       <a href="/claims">Claims</a>

← 6589647 auto-save: 2026-07-08T14:36:14 (5 files) — lib/ids.js db/mig · back to AbramsOS · FDA recall cross-reference: clean drug names, derive generic 78b80e6 →