\n \n \n \n\n",[],[19,86,191],"37478e76-e267-4a56-b46b-dc15e9c014cf","auth.tsx","0ed6945c-808e-11f1-9b85-1607ee4eb77e",162,["D",1784153405097],"/** @jsxImportSource npm:hono@4/jsx */\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The template's own live preview (owned by the \"templates\" org) is publicly\n// viewable. Your remix is owned by your org, so it requires login.\nconst IS_TEMPLATE_PREVIEW = parseVal().username === \"templates\";\n\n// Val Town handles allowed in besides org members — James and team.\nconst ALLOWED_USERS = [\"jayhype\"];\n\n// Auth guard for the dashboard. The x-debug-token header bypass lets headless\n// agents (and curl) hit the dashboard for debugging without a browser login.\nexport async function requireOrgMember(c: any, next: any) {\n if (IS_TEMPLATE_PREVIEW && c.req.method === \"GET\") return next();\n const debugToken = Deno.env.get(\"DEBUG_TOKEN\");\n if (debugToken && c.req.header(\"x-debug-token\") === debugToken) return next();\n const session = await getOAuthUserData(c.req.raw);\n if (!session) return c.html();\n const allowed = session.isOrgMember ||\n ALLOWED_USERS.includes(session.user.username?.toLowerCase() ?? \"\");\n if (!allowed) {\n return c.html(, 403);\n }\n await next();\n}\n\nfunction Shell({ title, children }: { title: string; children: any }) {\n return (\n \n \n \n \n {title}\n \n \n \n

\n {children}\n

\n \n \n );\n}\n\nfunction LoginPage() {\n return (\n \n

🔒

GitHub Leads Dashboard

\n \n $\"\"$ \n Sign in with Val Town\n \n

\n \n );\n}\n\nfunction UnauthorizedPage({ username }: { username: string }) {\n return (\n \n

⛔

Access Denied

\n You must be a member of this val's organization to view the dashboard.\n

\n Logged in as {username}\n

\n \n );\n}\n",[],[19,86,199],"76b0dafb-253e-41a2-b6e2-6b4b31e6f6ba","app.tsx","2d703346-808e-11f1-a292-1607ee4eb77e",166,["D",1784208421885],9,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n// The dashboard app: score-sorted list of lead cards, filterable by score bucket.\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { marked } from \"https://esm.sh/marked@12\";\n\nconst QUALIFIED_SCORE = 80; // keep in sync with utils/db.ts\n\ninterface Lead {\n login: string;\n activity: string | null; // JSON: [{ type, repo, when? }]\n email: string | null;\n status: string;\n score: number | null;\n card: string | null;\n error: string | null;\n flagged: string | null;\n created_at: number;\n scored_at: number | null;\n contacted_at: number | null;\n}\n\nfunction shortDate(ts: number | null): string | null {\n if (!ts) return null;\n return new Date(ts).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n}\n\n// When the person last acted on our repos (starred/forked/PR'd) — the date\n// that matters, not when our cron processed them.\nfunction lastActivityDate(lead: Lead): string | null {\n try {\n const acts = JSON.parse(lead.activity ?? \"[]\") as { when?: string }[];\n const last = acts.map((a) => a.when).filter(Boolean).sort().at(-1);\n if (!last) return null;\n return new Date(last).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n } catch {\n return null;\n }\n}\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__: { initialLeads: Lead[] };\n }\n}\n\nconst BUCKETS = [\"ALL\", \"80+\", \"50–79\", \"<50\", \"PENDING\"] as const;\ntype Bucket = (typeof BUCKETS)[number];\n\nfunction bucket(lead: Lead): Bucket {\n if (lead.status !== \"done\") return \"PENDING\";\n const s = lead.score ?? 0;\n if (s >= QUALIFIED_SCORE) return \"80+\";\n if (s >= 50) return \"50–79\";\n return \"<50\";\n}\n\nconst SCORE_BADGE: Record = {\n \"80+\": \"bg-green-100 text-green-800\",\n \"50–79\": \"bg-yellow-100 text-yellow-800\",\n \"<50\": \"bg-gray-100 text-gray-400\",\n PENDING: \"bg-blue-100 text-blue-800\",\n ALL: \"\",\n};\n\n// First non-label line of the card is \"Name — title\".\nfunction headline(lead: Lead): string {\n const lines = (lead.card ?? \"\").split(\"\\n\").map((l) => l.trim()).filter(Boolean);\n return lines.find((l) => !/^(Verdict|Score|Company|Why|Opener|Links):/i.test(l)) ?? lead.login;\n}\n\nfunction App({ initialLeads }: { initialLeads: Lead[] }) {\n const [leads, setLeads] = useState(initialLeads);\n const [filter, setFilter] = useState(\"ALL\");\n const [open, setOpen] = useState(null);\n const [username, setUsername] = useState(\"\");\n\n const counts = useMemo(() => {\n const c: Record = {};\n for (const l of leads) c[bucket(l)] = (c[bucket(l)] ?? 0) + 1;\n return c;\n }, [leads]);\n\n // Uncontacted qualified leads first — they're the to-do list — then by score.\n const visible = useMemo(() => {\n const list = filter === \"ALL\" ? leads : leads.filter((l) => bucket(l) === filter);\n const todo = (l: Lead) =>\n l.status === \"done\" && (l.score ?? 0) >= QUALIFIED_SCORE && !l.contacted_at ? 0 : 1;\n return [...list].sort(\n (a, b) => todo(a) - todo(b) || (b.score ?? -1) - (a.score ?? -1),\n );\n }, [leads, filter]);\n\n async function toggleContacted(lead: Lead) {\n const contacted = !lead.contacted_at;\n // Optimistic; the server is the source of truth on next fetch.\n setLeads((ls) =>\n ls.map((l) => (l.login === lead.login ? { ...l, contacted_at: contacted ? Date.now() : null } : l))\n );\n await fetch(`/api/leads/${encodeURIComponent(lead.login)}/contacted`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ contacted }),\n });\n }\n\n async function scoreUsername(e: React.FormEvent) {\n e.preventDefault();\n if (!username.trim()) return;\n await fetch(\"/api/leads\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ github_username: username.trim() }),\n });\n setUsername(\"\");\n setLeads(await (await fetch(\"/api/leads\")).json());\n }\n\n return (\n

GitHub Leads

\n\n

\n {BUCKETS.map((v) => (\n setFilter(v)}\n className={`px-3 py-1 rounded-full text-sm border ${\n filter === v ? \"bg-gray-900 text-white border-gray-900\" : \"bg-white border-gray-200\"\n }`}\n >\n {v.toLowerCase()} {v === \"ALL\" ? leads.length : counts[v] ?? 0}\n \n ))}\n

\n\n

\n {visible.map((lead) => {\n const b = bucket(lead);\n return (\n

\n setOpen(open === lead.login ? null : lead.login)}\n className=\"w-full text-left px-4 py-3 flex items-center gap-3 cursor-pointer\"\n >\n \n {lead.status === \"done\" ? lead.score ?? \"—\" : \"…\"}\n \n \n {lead.login}\n {lead.status === \"done\" && (\n · {headline(lead)}\n )}\n {lead.flagged && · {lead.flagged}}\n {lead.error && · {lead.error}}\n \n \n \n {lastActivityDate(lead) ?? shortDate(lead.created_at)}\n \n e.stopPropagation()}\n title={lead.contacted_at ? \"Mark not contacted\" : \"Mark contacted\"}\n >\n toggleContacted(lead)}\n />\n {lead.contacted_at ? `contacted ${shortDate(lead.contacted_at)}` : \"contacted\"}\n \n \n

\n {open === lead.login && lead.card && (\n \n )}\n

\n );\n })}\n {visible.length === 0 && (\n

Nothing here yet.

\n )}\n

\n \n );\n}\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No root element found\");\ncreateRoot(root).render();\n",[],[19,86,207],"a9ae1a9b-3628-4c21-b06f-02f2e1b999e0","inputs","d292f7ec-808d-11f1-8cb9-1607ee4eb77e",61,["D",1784148203624],[222],[216],{"_36":223,"_13":224,"_66":225,"_68":217,"_70":71,"_72":226,"_74":75,"_38":227,"_17":108,"_78":79,"_80":228,"_82":53,"_83":-5,"_111":229,"_18":230},"dd36b046-1612-484d-bd5b-82a9b298e6fe","github.ts","fa7f3b30-808d-11f1-80cc-1607ee4eb77e",76,["D",1784148381651],"// cron: poll for new github activity, add to db.\nimport { Octokit } from \"npm:octokit@5.0.5\";\nimport { getLead, insertPending } from \"../utils/db.ts\";\n\n// GitHub orgs we watch. Activity on these repos is what makes someone a lead.\nexport const WATCHED = [\"miracodeai\", \"dbprohq\"];\n\n// Our own team — never lead-scored. The maintainer check below catches\n// unlisted team accounts, but add known handles here.\nexport const EXCLUDE_USERS = new Set([\n \"JSMira\",\n \"jayhyp\",\n \"JackHyp\",\n \"coolio85\",\n \"modrink\",\n \"JDSmith97\",\n]);\n\nexport default async function (interval: Interval) {\n // First run looks back one hour; history was handled by the backlog report.\n const lastChecked = interval.lastRunAt ?? new Date(Date.now() - 60 * 60 * 1000);\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n\n const events = (await Promise.all(\n WATCHED.map((org) =>\n octokit.paginate(octokit.rest.activity.listPublicOrgEvents, { org, per_page: 100 })\n ),\n ))\n .flat()\n .filter((e: any) => new Date(e.created_at) > lastChecked)\n .filter((e: any) =>\n e.actor?.login && !e.actor.login.includes(\"[bot]\") && !EXCLUDE_USERS.has(e.actor.login)\n );\n\n const byActor = Map.groupBy(events, (e: any) => e.actor.login as string);\n console.log(`${events.length} new events from ${byActor.size} people`);\n\n for (const [login, actorEvents] of byActor) {\n if (await getLead(login)) continue; // already known — first contact is the signal\n\n const activity = actorEvents.map((e: any) => ({\n type: e.type,\n repo: e.repo?.name,\n when: e.created_at?.slice(0, 10),\n title: e.payload?.issue?.title ?? e.payload?.pull_request?.title ?? undefined,\n }));\n\n // Maintainer signals: merging others' PRs or pushing straight to the repo.\n // Probably a team account missing from EXCLUDE_USERS — ask, don't score.\n const looksLikeMaintainer = actorEvents.some((e: any) =>\n e.type === \"PushEvent\" ||\n (e.type === \"PullRequestEvent\" && e.payload?.action === \"closed\" &&\n e.payload?.pull_request?.merged &&\n e.payload?.pull_request?.user?.login !== login)\n );\n\n await insertPending(login, activity, {\n flagged: looksLikeMaintainer ? \"maintainer?\" : undefined,\n });\n console.log(`new: ${login}${looksLikeMaintainer ? \" (flagged maintainer?)\" : \"\"}`);\n }\n}\n",[],[216,224],"1248533c-8cdc-4f42-9610-73e9cbc5e37d",["D",1783725503703],"legacyEnvVars","httpPrivacy","description","GitHub lead qualification for DB Pro / Mira","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789531199&sig=85259275c3f510f18b5f15ee4fa3e8a8f16108b5b00d73bcb58746bcd213bc33","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","ba7bb5fb-1abb-4ffb-8f3d-7c244782e5f7","tursoName","1248533c8cdc4f42961073e9cbc5e37d","tursoHostname","1248533c8cdc4f42961073e9cbc5e37d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789439460012],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_280":276},"org",{"_11":12,"_273":274,"_275":276,"_239":-5,"_277":278,"_279":75},"branch",{"_17":209,"_13":16,"_36":71,"_42":231,"_45":37,"_47":269,"_270":55,"_271":43,"_272":59,"_60":14,"_56":12},144,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Val Town ","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyWnQ5cFE0c3pleVRCSEVTWmxzaXJsTUlGciJ9","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":231,"_13":14,"_38":371,"_51":-5,"_233":53,"_54":55,"_234":55,"_235":236,"_237":238,"_239":240,"_241":105,"_242":75,"_243":-5,"_244":-5,"_245":90,"_58":246,"_247":248,"_249":250,"_251":372,"_253":-5,"_254":255,"_256":255,"_257":258,"_259":258,"_260":258,"_261":255,"_262":255,"_263":373,"_265":374,"_267":375,"_52":53},[323,325,332,335,337,338],"files",[323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338],"counts",{"_313":90,"_314":108,"_315":90,"_35":316,"_317":318},[309,310],{"_36":93,"_70":71,"_66":69,"_13":19,"_80":-5,"_78":91,"_17":90,"_68":-5,"_38":307,"_72":95,"_83":-5,"_18":308},"upstreamProject",{"_36":43,"_13":61,"_235":304,"_237":238,"_54":55,"_263":305},"upstreamBranch",{"_36":37,"_38":302,"_40":303,"_13":16,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1767974365657],["D",1783726173324],"Find customers to sell to from GitHub activity",{"_11":57,"_280":306},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789531199&sig=c4c4bdc5c2acbb6312e40d49bdb32dbf55ef8c86dbe1955b3579126e34f9a554",["D",1784148204925],[19],{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":89,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_18":312},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":76,"_17":77,"_78":79,"_80":81,"_82":53,"_83":-5,"_18":311},[19,65],[19,86],"pulls","branches","forks",{"_319":321,"_322":90},"connections",{"_319":108,"_320":90},"count","unfilledCount",3,"emptyCount",{"_36":215,"_13":216,"_66":217,"_68":-5,"_70":71,"_72":218,"_74":75,"_38":219,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_111":369,"_18":370},{"_36":223,"_13":224,"_66":225,"_68":217,"_70":71,"_72":226,"_74":75,"_38":227,"_17":108,"_78":79,"_80":228,"_82":53,"_83":-5,"_111":367,"_18":368},{"_36":93,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":95,"_74":75,"_38":167,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_111":365,"_18":366},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":175,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_111":363,"_18":364},{"_36":206,"_13":207,"_66":208,"_68":87,"_70":71,"_72":209,"_74":75,"_38":210,"_17":211,"_78":136,"_80":212,"_82":53,"_83":-5,"_111":361,"_18":362},{"_36":198,"_13":199,"_66":200,"_68":87,"_70":71,"_72":201,"_74":75,"_38":202,"_17":108,"_78":136,"_80":203,"_82":53,"_83":-5,"_111":359,"_18":360},{"_36":190,"_13":191,"_66":192,"_68":87,"_70":71,"_72":193,"_74":75,"_38":194,"_17":108,"_78":24,"_80":195,"_82":53,"_83":-5,"_111":357,"_18":358},{"_36":182,"_13":183,"_66":184,"_68":87,"_70":71,"_72":185,"_74":75,"_38":186,"_17":34,"_78":136,"_80":187,"_82":53,"_83":-5,"_111":355,"_18":356},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":172,"_17":77,"_78":79,"_80":81,"_82":53,"_83":-5,"_111":353,"_18":354},{"_36":140,"_13":141,"_66":142,"_68":-5,"_70":71,"_72":143,"_74":75,"_38":144,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_111":351,"_18":352},{"_36":158,"_13":159,"_66":160,"_68":142,"_70":71,"_72":161,"_74":75,"_38":162,"_17":163,"_78":24,"_80":164,"_82":53,"_83":-5,"_111":349,"_18":350},{"_36":149,"_13":150,"_66":151,"_68":142,"_70":71,"_72":152,"_74":75,"_38":153,"_17":154,"_78":79,"_80":155,"_82":53,"_83":-5,"_111":347,"_18":348},{"_36":122,"_13":123,"_66":124,"_68":-5,"_70":71,"_72":125,"_74":75,"_38":126,"_17":90,"_78":91,"_80":-5,"_82":53,"_83":-5,"_111":345,"_18":346},{"_36":130,"_13":131,"_66":132,"_68":124,"_70":71,"_72":133,"_74":75,"_38":134,"_17":135,"_78":136,"_80":137,"_82":53,"_83":-5,"_111":343,"_18":344},{"_36":114,"_13":115,"_66":116,"_68":-5,"_70":71,"_72":117,"_74":75,"_38":118,"_17":77,"_78":24,"_80":119,"_82":53,"_83":-5,"_111":341,"_18":342},{"_36":103,"_13":104,"_66":105,"_68":-5,"_70":71,"_72":106,"_74":75,"_38":107,"_17":108,"_78":109,"_80":110,"_82":53,"_83":-5,"_111":339,"_18":340},[],[104],[],[115],[],[123,131],[336],[123],[],[141,150],[],[141,159],[333,334],[141],[],[19,65],[],[19,86,183],[],[19,86,191],[],[19,86,199],[],[19,86,207],[327,328,329,330],[19,86],[326,331],[19],[],[216,224],[324],[216],["D",1783725503703],["D",1789439460012],{"_11":12,"_280":276},{"_11":12,"_273":274,"_275":276,"_239":-5,"_277":278,"_279":75},{"_17":209,"_13":16,"_36":71,"_42":231,"_45":37,"_47":269,"_270":55,"_271":43,"_272":59,"_60":14,"_56":12},"ctx",{"_263":-5,"_299":409,"_410":411,"_412":413,"_414":53,"_415":53,"_416":53,"_417":75,"_418":-5,"_419":-7,"_420":-7,"_421":90,"_422":53,"_423":53,"_424":-5,"_425":53,"_426":53,"_427":53,"_428":-5},"ENV",{"_380":381,"_382":383,"_384":16,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]