Member Addresses

\n ⬇ Download TSV\n

\n \n \n \n \n \n \n \n \n ${tableRows}\n

Email	Tier	Name	Address	Address Line 2	City	State	Zip	Country

\n \n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// Buttondown newsletter helpers\n// ---------------------------------------------------------------------------\n\nasync function getButtondownSubscriber(email) {\n const res = await fetch(\n `https://api.buttondown.email/v1/subscribers/${encodeURIComponent(email)}`,\n { headers: { Authorization: `Token ${BUTTONDOWN_API_KEY}` } },\n );\n if (res.status === 404) return null;\n if (!res.ok) throw new Error(`Buttondown error: ${res.status}`);\n return res.json();\n}\n\nasync function subscribeToButtondown(email) {\n const existing = await getButtondownSubscriber(email);\n if (existing && existing.type === \"unsubscribed\") {\n // Use bulk resubscribe action for previously unsubscribed subscribers\n const res = await fetch(\"https://api.buttondown.email/v1/bulk-actions\", {\n method: \"POST\",\n headers: {\n Authorization: `Token ${BUTTONDOWN_API_KEY}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n action: \"resubscribe\",\n metadata: { ids: [existing.id] },\n }),\n });\n if (!res.ok) throw new Error(`Buttondown resubscribe error: ${res.status}`);\n return res.json();\n }\n // Create new subscriber (or existing with non-unsubscribed status)\n const res = await fetch(\"https://api.buttondown.email/v1/subscribers\", {\n method: \"POST\",\n headers: {\n Authorization: `Token ${BUTTONDOWN_API_KEY}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ email_address: email, type: \"regular\" }),\n });\n if (!res.ok) throw new Error(`Buttondown subscribe error: ${res.status}`);\n return res.json();\n}\n\n// ---------------------------------------------------------------------------\n// Main handler\n// ---------------------------------------------------------------------------\n\nexport default async function handler(request) {\n const url = new URL(request.url);\n const path = url.pathname;\n\n // Handle CORS preflight for member-facing endpoints\n if (request.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: corsHeaders });\n }\n\n // -------------------------------------------------------------------------\n // Member-facing: GET /address — check + return current address\n // POST /address — upsert address\n // -------------------------------------------------------------------------\n\n if (path === \"/address\") {\n const email = await verifyMemberToken(request);\n if (!email) {\n return jsonResponse({ error: \"Unauthorized\" }, 401, corsHeaders);\n }\n\n const member = await getMemberByEmail(email);\n if (!member) {\n return jsonResponse({ error: \"Member not found\" }, 404, corsHeaders);\n }\n\n const memberUUID = member.id;\n\n if (request.method === \"GET\") {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM addresses WHERE member_uuid = ?\",\n args: [memberUUID],\n });\n const address = result.rows.length ? rowToAddress(result.rows[0]) : null;\n return jsonResponse({ address }, 200, corsHeaders);\n }\n\n if (request.method === \"POST\") {\n const { name, address1, address2, city, state, zip, country } =\n await request.json();\n await sqlite.execute({\n sql:\n `INSERT INTO addresses (member_uuid, name, address1, address2, city, state, zip, country)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(member_uuid) DO UPDATE SET\n name = excluded.name,\n address1 = excluded.address1,\n address2 = excluded.address2,\n city = excluded.city,\n state = excluded.state,\n zip = excluded.zip,\n country = excluded.country`,\n args: [memberUUID, name, address1, address2, city, state, zip, country],\n });\n return jsonResponse({ success: true }, 200, corsHeaders);\n }\n\n return jsonResponse({ error: \"Method not allowed\" }, 405, corsHeaders);\n }\n\n // -------------------------------------------------------------------------\n // Admin: GET /admin — table UI + optional ?download=1 for TSV\n // POST /admin/save — upsert address by uuid\n // -------------------------------------------------------------------------\n\n if (path === \"/admin\" || path === \"/admin/save\") {\n if (url.searchParams.get(\"token\") !== ADMIN_TOKEN) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n // Save endpoint\n if (path === \"/admin/save\" && request.method === \"POST\") {\n const {\n member_uuid,\n name,\n address1,\n address2,\n city,\n state,\n zip,\n country,\n } = await request.json();\n await sqlite.execute({\n sql:\n `INSERT INTO addresses (member_uuid, name, address1, address2, city, state, zip, country)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(member_uuid) DO UPDATE SET\n name = excluded.name,\n address1 = excluded.address1,\n address2 = excluded.address2,\n city = excluded.city,\n state = excluded.state,\n zip = excluded.zip,\n country = excluded.country`,\n args: [\n member_uuid,\n name,\n address1,\n address2,\n city,\n state,\n zip,\n country,\n ],\n });\n return jsonResponse({ success: true });\n }\n\n // Admin UI + TSV download\n if (path === \"/admin\" && request.method === \"GET\") {\n const members = await getPhysicalMembers();\n\n const addressResult = members.length\n ? await sqlite.execute({\n sql: `SELECT * FROM addresses WHERE member_uuid IN (${\n members.map(() => \"?\").join(\",\")\n })`,\n args: members.map((m) => m.uuid),\n })\n : { rows: [] };\n\n // TSV download\n if (url.searchParams.get(\"download\") === \"1\") {\n const addrMap = Object.fromEntries(\n addressResult.rows.map((row) => {\n const a = rowToAddress(row);\n return [a.member_uuid, a];\n }),\n );\n const header = [\n \"Email\",\n \"Name\",\n \"Address\",\n \"Address Line 2\",\n \"City\",\n \"State\",\n \"Zipcode\",\n \"Country\",\n \"Ounces\",\n \"Length\",\n \"Width\",\n \"Height\",\n \"Tier\",\n ];\n const rows = [\n header,\n ...members.map((m) => {\n const a = addrMap[m.uuid] || {};\n return [\n m.email,\n a.name || \"\",\n a.address1 || \"\",\n a.address2 || \"\",\n a.city || \"\",\n a.state || \"\",\n a.zip || \"\",\n a.country || \"\",\n \"\",\n \"\",\n \"\",\n \"\",\n m.tierName,\n ];\n }),\n ];\n const tsv = toUTF16TSV(rows);\n return new Response(tsv, {\n headers: {\n \"Content-Type\": \"text/tab-separated-values; charset=utf-16le\",\n \"Content-Disposition\": 'attachment; filename=\"addresses.txt\"',\n },\n });\n }\n\n // HTML table\n const html = adminHTML(members, addressResult.rows, ADMIN_TOKEN);\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n }\n\n // -------------------------------------------------------------------------\n // Newsletter: GET /newsletter — check Buttondown status\n // POST /newsletter — subscribe\n // -------------------------------------------------------------------------\n\n if (path === \"/newsletter\") {\n const email = await verifyMemberToken(request);\n if (!email) {\n return jsonResponse({ error: \"Unauthorized\" }, 401, corsHeaders);\n }\n\n if (request.method === \"GET\") {\n try {\n const subscriber = await getButtondownSubscriber(email);\n const subscribed = subscriber !== null && subscriber.type === \"regular\";\n return jsonResponse({ subscribed }, 200, corsHeaders);\n } catch (e) {\n return jsonResponse({ error: e.message }, 500, corsHeaders);\n }\n }\n\n if (request.method === \"POST\") {\n try {\n await subscribeToButtondown(email);\n return jsonResponse(\n { success: true, subscribed: true },\n 200,\n corsHeaders,\n );\n } catch (e) {\n return jsonResponse({ error: e.message }, 500, corsHeaders);\n }\n }\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","deleted","label",[107],"pulls","branches",1,"forks","envVars",{"_131":133,"_134":40},"connections",{"_131":40,"_132":40},"count","unfilledCount",4,"emptyCount",{"_18":106,"_20":107,"_108":109,"_110":-5,"_111":66,"_112":64,"_113":100,"_22":136,"_63":115,"_116":117,"_118":119,"_120":26,"_121":-5,"_137":138,"_83":139},["D",1780716875027],"children",[],[107],["D",1780701962396],{"_16":17,"_81":77},{"_16":17,"_75":-5,"_76":77,"_33":34,"_78":79,"_80":26},{"_63":64,"_20":65,"_18":66,"_67":19,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":21,"_74":17},"ctx",{"_56":-5,"_102":177,"_178":179,"_180":181,"_182":26,"_183":26,"_184":26,"_185":100,"_186":-5,"_187":-7,"_188":-7,"_189":40,"_190":26,"_191":26,"_192":-5,"_193":26,"_194":26,"_195":26,"_196":-5},"ENV",{"_148":149,"_150":151,"_152":65,"_153":154,"_155":156,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Search