Skip to content

Instantly share code, notes, and snippets.

@omeryaco
omeryaco / LOVABLE_PROMPT_MIA2_PART3_FILTER_CANCELLED.md
Created May 26, 2026 12:23
MIA2 Part 3: Cohort Funnel filter cancelled members (locked 2026-05-26)

MIA2 Part 3: Cohort Funnel — exclude cancelled members from classifier

Pattern. Lovable Deploy Discipline. 3 phases with paste-back verification gates.

Scope. ONE surgical line change in ONE file: supabase/functions/get-cohort-funnel/index.ts. No schema changes, no frontend, no other files, no npm installs.

Project. JBC Connect. Closes the double-count bug surfaced by MIA2 Parts 1+2 (Pauline OLD row still counted in C3 Sent + Clicked alongside Pauline NEW row).


@omeryaco
omeryaco / LOVABLE_PROMPT_MIA2_PART2_COHORT_FUNNEL_SECONDARY_EMAIL.md
Created May 26, 2026 10:24
MIA2 Part 2: Cohort Funnel secondary_email match (locked 2026-05-26)

MIA2 Part 2: Cohort Funnel — secondary_email match for Resend lookups

Pattern. Lovable Deploy Discipline. 3 phases with paste-back verification gates.

Scope. Two surgical line changes in ONE file: supabase/functions/get-cohort-funnel/index.ts. No schema changes, no frontend changes, no other files touched, no npm installs.

Project. JBC Connect. Closes the cohort funnel email-attribution gap created by MIA2 Part 1 Pauline merge (her C3 cohort send went to ph@jkfestival.dk which is now her secondary_email; without this fix, her click attribution goes dark).


@omeryaco
omeryaco / LOVABLE_PROMPT_MIA1_SCHEMA_AND_REGISTER.md
Created May 24, 2026 20:30
MIA1: JBC Identity Architecture v2 — Schema Foundation + RegisterPage redesign (locked 2026-05-24)

MIA1: Identity Architecture v2 — Schema Foundation + RegisterPage redesign

Pattern. Lovable Deploy Discipline. 3 phases with paste-back verification gates between each.

Scope. ONE migration file (schema + indexes + FK constraints + 94-row backfill + handle_new_user trigger update via CREATE OR REPLACE FUNCTION) + ONE frontend file modification (src/pages/RegisterPage.tsx) + TWO locale file modifications (src/locales/en.json + src/locales/da.json). NO other files touched. NO npm dependency changes.

Project. JBC Connect. Identity Architecture v2 foundational schema, post-Pauline-duplicate-incident architectural response. Closes ticket 9.12 schema portion. Other ticket 9.12 portions (consumer refactor, full frontend redesign) deferred to MIA1.5 sub-cycles.


@omeryaco
omeryaco / LOVABLE_PROMPT_M22_1_FUNNEL_POLISH.md
Created May 23, 2026 21:19
M22.1 Cohort Funnel Executive Polish — full prompt with intact JSX

M22.1: Cohort Funnel Executive Polish

Pattern. Lovable Deploy Discipline. 3 phases with paste-back verification gates between each.

Scope. Frontend-only refactor of src/components/admin/CohortFunnelCard.tsx. Edge function get-cohort-funnel and its response shape stay byte-identical. AdminDashboardPage placement (L17 import, L351 JSX usage) stays byte-identical. No new npm dependencies.

Project. JBC Connect, board-internal executive cohort funnel dashboard. M22 main shipped a data-correct table. M22.1 elevates it to executive board-viewing quality.