Skip to content

Instantly share code, notes, and snippets.

View andrewsteinmeyer's full-sized avatar

Andrew Steinmeyer andrewsteinmeyer

View GitHub Profile
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Symptom Tracker — Home v2 Prototype</title>
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet">
<style>
:root {
--teal-600: #5BC5C2;

Symptom Tracker — Homepage & UX Improvements Spec

Version: 1.0
Designer: Jonsi
Date: 2026-03-11
Status: Staging only. Do not deploy to production.


1. Parent Home Page — Redesign

@andrewsteinmeyer
andrewsteinmeyer / 003_nuke_and_rebuild_rls.sql
Created March 10, 2026 15:03
JP Symptom Tracker — Nuclear RLS fix (drop all SELECT policies, rebuild without circular refs)
-- 003: Nuclear RLS fix — drop ALL select policies and rebuild without circular refs
-- The issue: children ↔ provider_connections cross-reference each other in SELECT policies
-- ============================================================
-- DROP ALL EXISTING SELECT POLICIES
-- ============================================================
-- children
DROP POLICY IF EXISTS "Parents can read their own children" ON children;
DROP POLICY IF EXISTS "Providers can read connected children" ON children;
@andrewsteinmeyer
andrewsteinmeyer / rls_fix.sql
Created March 10, 2026 14:59
JP Symptom Tracker - RLS policy fix
-- Fix RLS policies that use subqueries with OR (causes issues on some Supabase versions)
-- Split compound policies into separate parent + provider policies
DROP POLICY IF EXISTS "Parents can read their own children" ON children;
CREATE POLICY "Parents can read their own children"
ON children FOR SELECT USING (parent_id = auth.uid());
CREATE POLICY "Providers can read connected children"
ON children FOR SELECT USING (id IN (SELECT child_id FROM provider_connections WHERE provider_id = auth.uid()));
DROP POLICY IF EXISTS "Parents can read tracked symptoms for their children" ON tracked_symptoms;
@andrewsteinmeyer
andrewsteinmeyer / 001_initial_schema.sql
Last active March 10, 2026 14:56
JP Symptom Tracker - Supabase schema migration
-- Initial schema for PANS/PANDAS symptom tracker
-- profiles table (extends auth.users)
CREATE TABLE profiles (
id uuid REFERENCES auth.users ON DELETE CASCADE PRIMARY KEY,
role text NOT NULL CHECK (role IN ('parent', 'provider')),
display_name text,
created_at timestamptz DEFAULT now() NOT NULL,
updated_at timestamptz DEFAULT now() NOT NULL
);
@andrewsteinmeyer
andrewsteinmeyer / DESIGN-SPEC.md
Created March 10, 2026 02:35
JP Symptom Tracker — UX/UI Design Spec & Prototypes (Jonsi)

Journey Symptom Tracker — Design Specification

Version: 1.0
Designer: Jonsi
Date: 2026-03-09
Status: For Review


1. Design Philosophy

@andrewsteinmeyer
andrewsteinmeyer / jp-new-patient-inquiry-sequence-v2.html
Created March 6, 2026 17:52
Journey Pediatrics — New Patient Inquiry Email Sequence v2 (from John, hardcoded Calendly link, GHL-ready HTML)
<!--
Journey Pediatrics — New Patient Inquiry Email Sequence (v2)
Trigger: Someone submits the website intake form (has NOT booked an intro call)
Goal: Build trust, introduce JP, convert to intro call booking
Voice: Warm, personal, 6th–8th grade reading level
From: John from Journey Pediatrics (Family Communications Manager)
Prepared by: Loki | Date: 2026-03-06 | Revision: v2
Implementation: GHL workflow
-->
@andrewsteinmeyer
andrewsteinmeyer / jp-new-patient-inquiry-sequence.html
Created March 6, 2026 17:35
Journey Pediatrics — New Patient Inquiry Email Sequence (HTML for GHL)
<!--
Journey Pediatrics — New Patient Inquiry Email Sequence
Trigger: Someone submits the website intake form (has NOT booked an intro call)
Goal: Build trust, introduce JP, convert to intro call booking
Voice: Warm, personal, 6th–8th grade reading level
From: Alice from Journey Pediatrics
Prepared by: Loki | Date: 2026-03-06
Implementation: GHL workflow
-->
@andrewsteinmeyer
andrewsteinmeyer / deliverable.md
Created March 5, 2026 18:39
JP GHL Build — API Audit & Manual Build Instructions (2026-03-05)

JP GHL Build — API Audit & Manual Build Instructions

Date: 2026-03-05 | Agent: Friday | Location: le94xYtmg53BNHTpgAQv


1. API Status: ✅ CONFIRMED WORKING

PIT token pit-f40e2362-... verified. All read endpoints functional.

@andrewsteinmeyer
andrewsteinmeyer / compiled-all-emails.md
Created March 5, 2026 16:01
Journey Pediatrics — 14 Branded HTML Email Templates (GHL-ready)

Journey Pediatrics — HTML Email Templates

Designed by Jonsi | Copy by Pepper (v3)

Brand Colours

  • Teal: #5BBFBD — Bird icon, accents, info boxes, links
  • Coral: #D48A6B — Typography, CTA buttons, testimonial borders
  • Dark text: #3D3D3D
  • Light teal bg: #F0F9F8
  • Light coral bg: #FDF5F2