\n \n \n \n\n",[],[152,169,188],"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",[],[152,169,196],"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",[],[152,169,204],"a9ae1a9b-3628-4c21-b06f-02f2e1b999e0","inputs","d292f7ec-808d-11f1-8cb9-1607ee4eb77e",61,["D",1784148203624],[219],[213],{"_36":220,"_13":221,"_65":222,"_67":214,"_69":70,"_71":223,"_73":74,"_38":224,"_17":101,"_77":138,"_79":225,"_81":53,"_82":-5,"_104":226,"_18":227},"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",[],[213,221],"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=1789538399&sig=a00a4becc4680a8590282c71f67a5a90cced15b6cf36b1cbc7f38f8370bfce19","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",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_277":273},"org",{"_11":12,"_270":271,"_272":273,"_236":-5,"_274":275,"_276":74},"branch",{"_17":206,"_13":16,"_36":70,"_42":228,"_45":37,"_47":266,"_267":55,"_268":43,"_269":59,"_60":14,"_56":12},144,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Val Town ","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyWnQ5cFE0c3pleVRCSEVTWmxzaXJsTUlGciJ9","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":228,"_13":14,"_38":365,"_51":-5,"_230":53,"_54":55,"_231":55,"_232":233,"_234":235,"_236":237,"_238":98,"_239":74,"_240":-5,"_241":-5,"_242":87,"_58":243,"_244":245,"_246":247,"_248":366,"_250":-5,"_251":252,"_253":252,"_254":255,"_256":255,"_257":255,"_258":252,"_259":252,"_260":367,"_262":368,"_264":369,"_52":53},[317,319,326,329,331,332],"files",[317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332],"counts",{"_307":87,"_308":101,"_309":87,"_35":310,"_311":312},[305],{"_36":84,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":85,"_73":74,"_38":86,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_18":304},"upstreamProject",{"_36":43,"_13":61,"_232":301,"_234":235,"_54":55,"_260":302},"upstreamBranch",{"_36":37,"_38":299,"_40":300,"_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,"_277":303},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789538399&sig=ed57122c136965e1015088c1b79a18d1d4e6250d1eb81abacde1e740f48894e7",[19],{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":76,"_77":78,"_79":80,"_81":53,"_82":-5,"_18":306},[19,64],"pulls","branches","forks",{"_313":315,"_316":87},"connections",{"_313":101,"_314":87},"count","unfilledCount",3,"emptyCount",{"_36":212,"_13":213,"_65":214,"_67":-5,"_69":70,"_71":215,"_73":74,"_38":216,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_104":363,"_18":364},{"_36":220,"_13":221,"_65":222,"_67":214,"_69":70,"_71":223,"_73":74,"_38":224,"_17":101,"_77":138,"_79":225,"_81":53,"_82":-5,"_104":361,"_18":362},{"_36":151,"_13":152,"_65":153,"_67":-5,"_69":70,"_71":154,"_73":74,"_38":155,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_104":359,"_18":360},{"_36":168,"_13":169,"_65":170,"_67":153,"_69":70,"_71":171,"_73":74,"_38":172,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_104":357,"_18":358},{"_36":203,"_13":204,"_65":205,"_67":170,"_69":70,"_71":206,"_73":74,"_38":207,"_17":208,"_77":78,"_79":209,"_81":53,"_82":-5,"_104":355,"_18":356},{"_36":195,"_13":196,"_65":197,"_67":170,"_69":70,"_71":198,"_73":74,"_38":199,"_17":101,"_77":78,"_79":200,"_81":53,"_82":-5,"_104":353,"_18":354},{"_36":187,"_13":188,"_65":189,"_67":170,"_69":70,"_71":190,"_73":74,"_38":191,"_17":101,"_77":24,"_79":192,"_81":53,"_82":-5,"_104":351,"_18":352},{"_36":179,"_13":180,"_65":181,"_67":170,"_69":70,"_71":182,"_73":74,"_38":183,"_17":34,"_77":78,"_79":184,"_81":53,"_82":-5,"_104":349,"_18":350},{"_36":160,"_13":161,"_65":162,"_67":153,"_69":70,"_71":163,"_73":74,"_38":164,"_17":112,"_77":138,"_79":165,"_81":53,"_82":-5,"_104":347,"_18":348},{"_36":123,"_13":124,"_65":125,"_67":-5,"_69":70,"_71":126,"_73":74,"_38":127,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_104":345,"_18":346},{"_36":142,"_13":143,"_65":144,"_67":125,"_69":70,"_71":145,"_73":74,"_38":146,"_17":147,"_77":24,"_79":148,"_81":53,"_82":-5,"_104":343,"_18":344},{"_36":132,"_13":133,"_65":134,"_67":125,"_69":70,"_71":135,"_73":74,"_38":136,"_17":137,"_77":138,"_79":139,"_81":53,"_82":-5,"_104":341,"_18":342},{"_36":84,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":85,"_73":74,"_38":116,"_17":87,"_77":88,"_79":-5,"_81":53,"_82":-5,"_104":339,"_18":340},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":120,"_17":76,"_77":78,"_79":80,"_81":53,"_82":-5,"_104":337,"_18":338},{"_36":107,"_13":108,"_65":109,"_67":-5,"_69":70,"_71":110,"_73":74,"_38":111,"_17":112,"_77":24,"_79":113,"_81":53,"_82":-5,"_104":335,"_18":336},{"_36":96,"_13":97,"_65":98,"_67":-5,"_69":70,"_71":99,"_73":74,"_38":100,"_17":101,"_77":102,"_79":103,"_81":53,"_82":-5,"_104":333,"_18":334},[],[97],[],[108],[],[19,64],[330],[19],[],[124,133],[],[124,143],[327,328],[124],[],[152,161],[],[152,169,180],[],[152,169,188],[],[152,169,196],[],[152,169,204],[321,322,323,324],[152,169],[320,325],[152],[],[213,221],[318],[213],["D",1783725503703],["D",1789526460011],{"_11":12,"_277":273},{"_11":12,"_270":271,"_272":273,"_236":-5,"_274":275,"_276":74},{"_17":206,"_13":16,"_36":70,"_42":228,"_45":37,"_47":266,"_267":55,"_268":43,"_269":59,"_60":14,"_56":12},"ctx",{"_260":-5,"_296":403,"_404":405,"_406":407,"_408":53,"_409":53,"_410":53,"_411":74,"_412":-5,"_413":-7,"_414":-7,"_415":87,"_416":53,"_417":53,"_418":-5,"_419":53,"_420":53,"_421":53,"_422":-5},"ENV",{"_374":375,"_376":377,"_378":16,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402},"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"]