[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","stevekrouse","name","dateme","path","pages/join","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":66,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/stevekrouse/dateme/code/pages/join","extension","id","d16ddb90-5cf0-11f1-8e90-1607ee4eb77e","join","fileId","6c8a4e44-e595-11ef-85be-e6cdfca9ef9f","parentId","78e859c0-e58f-11ef-b429-e6cdfca9ef9f","branchId","6ea333ec-e58d-11ef-b8f1-e6cdfca9ef9f","branchVersion",246,"latest",true,"createdAt",["D",1780232480057],"version",28,"fileType","script","content","/** @jsxImportSource npm:hono@3.12.12/jsx */\nimport { sendEmailBestEffort } from \"../lib/send_email.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono@3.12.12\";\nimport DuplicateUrlError from \"../components/DuplicateUrlError.tsx\";\nimport JoinForm, { type JoinDefaults } from \"../components/JoinForm.tsx\";\nimport { createProfile, findExistingProfileOwner, parseProfileForm } from \"../lib/profile_persist.ts\";\nimport Layout from \"./layout\";\n\nconst label = (value: unknown): string => {\n if (Array.isArray(value)) return value.length ? value.join(\", \") : \"-\";\n if (value === null || value === undefined || value === \"\") return \"-\";\n return String(value);\n};\n\nconst escapeHtml = (s: string): string =>\n s.replace(/&/g, \"&\").replace(//g, \">\").replace(/\\\"/g, \""\");\n\ntype PublicationStatus = { published: boolean; status: string; detail: string };\n\nfunction derivePublicationStatus(row: any): PublicationStatus {\n if (!row) return { published: false, status: \"missing\", detail: \"No saved row found after insert\" };\n if (row.blocked_at) return { published: false, status: \"banned\", detail: `Banned at ${row.blocked_at}` };\n if (row.DeletedAt) return { published: false, status: \"paused\", detail: `Soft-deleted at ${row.DeletedAt}` };\n return { published: true, status: \"published\", detail: \"Visible in browse/search\" };\n}\n\nasync function loadPublicationStatus(email: string, profile: string): Promise {\n const { rows } = await sqlite.execute({\n sql: \"select DeletedAt, blocked_at from DateMeDocs where UserEmail = ? and Profile = ? limit 1\",\n args: [email, JSON.stringify(profile)],\n });\n return derivePublicationStatus((rows as any[])[0]);\n}\n\nfunction buildSubmitNotification(form: any, email: string, origin: string, publication: PublicationStatus) {\n const adminUrl = `${origin}/admin/users/${encodeURIComponent(email)}`;\n const submittedAt = new Date().toISOString();\n const radius = form.lookingForRadiusMi == null ? \"Anywhere\" : `${form.lookingForRadiusMi} mi`;\n const locations = form.chips?.map((c: any) => c.label) ?? [];\n const rows = [\n [\"Status\", `${publication.published ? \"Published\" : \"Unpublished\"} (${publication.status}; ${publication.detail})`],\n [\"Name\", form.name],\n [\"Email\", email],\n [\"Profile\", form.profile],\n [\"Admin\", adminUrl],\n [\"Submitted\", submittedAt],\n [\"Age\", form.age],\n [\"Birthday\", form.birthday],\n [\"Gender\", form.genders],\n [\"Interested in\", form.interestedIn],\n [\"Style\", form.styleArr],\n [\"Locations\", locations],\n [\"Location flexibility\", form.locationFlexibility],\n [\"Looking for age\", `${form.lookingForAgeMin}-${form.lookingForAgeMax}`],\n [\"Search radius\", radius],\n ];\n const text = rows.map(([k, v]) => `${k}: ${label(v)}`).join(\"\\n\");\n const htmlRows = rows.map(([k, v]) => `\n \n ${escapeHtml(k)}\n ${escapeHtml(label(v))}\n `).join(\"\");\n const html = `\n

${escapeHtml(form.name)} submitted a Date Me profile.

\n Manage in admin\n

\n ${htmlRows}

`;\n return { subject: `Date Me Doc Submit Success: ${form.name} [${publication.status}]`, text, html };\n}\n\nfunction requireEmail(c: any): string | Response {\n const email = c.get(\"user\")?.email;\n return email || c.redirect(\"/\", 302);\n}\n\nasync function userHasProfile(email: string): Promise {\n const { rows } = await sqlite.execute({\n sql: \"select 1 from DateMeDocs where UserEmail = ? limit 1\",\n args: [email],\n });\n return rows.length > 0;\n}\n\nfunction defaultsFromBody(body: Record): JoinDefaults {\n const arr = (k: string): string[] => {\n const v = body[k];\n return Array.isArray(v) ? v.map(String) : v ? [String(v)] : [];\n };\n // Re-hydrate chips that came in via locations[]= JSON entries so the form\n // can show them again on error.\n const rawLocs = body[\"locations[]\"];\n const locArr = Array.isArray(rawLocs) ? rawLocs : rawLocs ? [rawLocs] : [];\n const Locations = locArr\n .map((v: any) => {\n try { return JSON.parse(String(v)); } catch { return null; }\n })\n .filter((x: any) => x && typeof x.label === \"string\");\n const num = (k: string) => {\n const v = body[k];\n if (v == null || v === \"\") return undefined;\n const n = Number(v);\n return Number.isFinite(n) ? n : undefined;\n };\n return {\n Name: body.Name ? String(body.Name) : undefined,\n Profile: body.Profile ? String(body.Profile) : undefined,\n Birthday: body.Birthday ? String(body.Birthday) : undefined,\n Gender: arr(\"Gender[]\"),\n InterestedIn: arr(\"InterestedIn[]\"),\n Style: body.Style ? String(body.Style) : undefined,\n LocationFlexibility: body.LocationFlexibility ? String(body.LocationFlexibility) : undefined,\n Locations,\n LookingForAgeMin: num(\"LookingForAgeMin\"),\n LookingForAgeMax: num(\"LookingForAgeMax\"),\n LookingForRadiusMi: num(\"LookingForRadiusMi\"),\n };\n}\n\n\n\nexport const Form = async (c: any) => {\n const email = requireEmail(c);\n if (typeof email !== \"string\") return email;\n // If they already have a profile, send them to edit instead of creating a duplicate.\n if (await userHasProfile(email)) return c.redirect(\"/me/edit\", 302);\n return c.html(\n \n \n ,\n );\n};\n\nexport const Submit = async (c: any) => {\n const email = requireEmail(c);\n if (typeof email !== \"string\") return email;\n if (await userHasProfile(email)) return c.redirect(\"/me/edit\", 302);\n\n const body = await c.req.parseBody({ all: true });\n const defaults = defaultsFromBody(body);\n\n const renderError = (reason: any) =>\n c.html(\n \n \n ,\n );\n\n const parsed = await parseProfileForm(body);\n if (!parsed.ok) return renderError(parsed.reason);\n\n // Check for an existing row with this Profile URL before INSERT, so we can\n // give a human error instead of leaking a UNIQUE constraint failure.\n const existing = await findExistingProfileOwner(parsed.form.profile);\n if (existing) {\n return renderError(\n ,\n );\n }\n\n try {\n await createProfile(parsed.form, email);\n } catch (e) {\n console.error(\"[join] error:\", e);\n // Race condition fallback: if two submits raced past the pre-check above,\n // the second one hits a PRIMARY KEY/UNIQUE failure. Show the duplicate\n // message rather than the generic one.\n if (/UNIQUE|PRIMARY KEY/i.test(String(e))) {\n const after = await findExistingProfileOwner(parsed.form.profile);\n return renderError(\n ,\n );\n }\n await sendEmailBestEffort({\n subject: \"Date Me Doc Submit Error: \" + parsed.form.name,\n text: `${email}\\n\\n${String(e)}`,\n });\n return renderError(\"Something went wrong saving your submission. Try again or email steve@val.town.\");\n }\n // Profile saved. Notify Steve — but a failed notification must never break the\n // user's successful submission, so it's best-effort and lives outside the try\n // above (a thrown notification used to be misread as a save failure → 500).\n const publication = await loadPublicationStatus(email, parsed.form.profile);\n await sendEmailBestEffort(buildSubmitNotification(parsed.form, email, new URL(c.req.url).origin, publication));\n return c.redirect(\"/me\", 302);\n};\n\nexport const join = new Hono();\njoin.get(\"/\", Form);\njoin.post(\"/\", Submit);\nexport default join.fetch;\n","deleted",false,"label",[47,24],"pages","6ea2d636-e58d-11ef-b8f1-e6cdfca9ef9f",["D",1738958108106],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","The Date Me Directory, an alternative dating site","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","d8c06b22-e58e-11ef-942a-e6cdfca9ef9f","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","6ea2d636e58d11efb8f1e6cdfca9ef9f","tursoHostname","6ea2d636e58d11efb8f1e6cdfca9ef9f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789687835965],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_102":-5,"_103":104,"_58":59,"_105":106,"_107":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",275,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":156,"_157":44,"_158":44,"_159":-5,"_160":44,"_161":44,"_162":44,"_163":-5},"ENV",{"_113":114,"_115":116,"_117":93,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount",0,"flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]