Draftsim Content Spend

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":53,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","313b61ce-74ce-11f1-80b1-1607ee4eb77e","name","fileType","script","content","// contentSpend.valtown.ts - Draftsim Content Spend dashboard (val.town HTTP val).\n//\n// GENERATED by build-valtown.mjs from core.mjs + render.mjs.\n// Do not edit by hand; edit those sources and re-run `node build-valtown.mjs`.\n//\n// Deploy (free tier / public code, private data):\n// 1. Upload history.json -> private blob \"contentspend_history\"\n// and rates.json -> private blob \"contentspend_rates\".\n// 2. Create a new HTTP val, paste this whole file.\n// 3. Set env vars: ASANA_TOKEN (required) and ACCESS_KEY (recommended).\n// The pay numbers live in your private blobs, never in this public source.\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// ---------------------------------------------------------------------------\n// core (embedded from core.mjs)\n// ---------------------------------------------------------------------------\n// core.mjs - runtime-agnostic data layer (Node 18+ and Deno both have global fetch).\n// No env/fs access here; the caller passes the Asana token and the history object.\n// This same source is embedded verbatim into the val.town build (see build-valtown.mjs),\n// so the local demo and the hosted val compute identically.\n\nconst ASANA_BASE = \"https://app.asana.com/api/1.0\";\nconst PROJECT_GID = \"1200493284657065\"; // \"Draftsim Articles\"\nconst DEFAULTS = { writingRate: 0.037, editingRate: 0.02, fixedAvgMonths: 3 };\n\nasync function asanaGet(pathAndQuery, token) {\n const res = await fetch(`${ASANA_BASE}${pathAndQuery}`, {\n headers: { Authorization: `Bearer ${token}`, Accept: \"application/json\" },\n });\n if (!res.ok) {\n throw new Error(\n `Asana ${pathAndQuery} -> ${res.status} ${await res.text()}`,\n );\n }\n return res.json();\n}\n\nasync function getPublishedSection(token) {\n const { data } = await asanaGet(\n `/projects/${PROJECT_GID}/sections?opt_fields=name`,\n token,\n );\n const sec = data.find((s) => /^published/i.test(s.name)); // \"Published (Done)\"\n if (!sec) throw new Error(\"Published section not found in Draftsim Articles\");\n return sec;\n}\n\nasync function getPublishedTasks(sectionGid, token) {\n const tasks = [];\n let offset;\n const fields =\n \"name,tags.name,custom_fields.name,custom_fields.display_value,custom_fields.number_value,custom_fields.date_value\";\n while (true) {\n const q = new URLSearchParams({ limit: \"100\", opt_fields: fields });\n if (offset) q.set(\"offset\", offset);\n const data = await asanaGet(`/sections/${sectionGid}/tasks?${q}`, token);\n tasks.push(...data.data);\n offset = data.next_page?.offset;\n if (!offset) break;\n }\n return tasks;\n}\n\nfunction cfMap(task) {\n const m = {};\n for (const cf of task.custom_fields || []) m[cf.name] = cf;\n return m;\n}\n\nconst SET_CODE = /^[A-Z0-9]{2,4}$/; // MTG set-code tags: MSH, FDN, DSK, TDM...\n\n// Classify an article by Asana signals into its content lifecycle.\nfunction classify(task) {\n const tags = (task.tags || []).map((t) => t.name);\n if (tags.includes(\"Writer Update\") || /\$update\$/i.test(task.name)) {\n return { cls: \"Update\", setCode: null };\n }\n const set = tags.find((t) => SET_CODE.test(t));\n if (set) return { cls: \"New set\", setCode: set };\n if (tags.includes(\"New\")) return { cls: \"New article\", setCode: null };\n return { cls: \"News / Other\", setCode: null };\n}\n\n// Aggregate the live \"Published (Done)\" section into this month's word counts,\n// pricing each writer and editor at THEIR actual per-word rate from payroll\n// (rates.json). The section only ever holds the current month, so undated items\n// are treated as current-month too. Writing words = words on authored items;\n// editing words = words on items that have an editor assigned. Editors paid\n// hourly (not per-word) are flagged and excluded from the per-word editing total\n// - their pay lives in the historical hourly bucket instead.\nfunction buildCurrentMonth(tasks, rates, now = new Date()) {\n const key = `${now.getFullYear()}-${\n String(now.getMonth() + 1).padStart(2, \"0\")\n }`;\n const daysInMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0)\n .getDate();\n const dayOfMonth = now.getDate();\n const fracElapsed = dayOfMonth / daysInMonth;\n\n let writtenWords = 0,\n editedWords = 0,\n articles = 0,\n unattributedWords = 0,\n sectionWords = 0;\n const authors = new Map();\n const editors = new Map();\n const articleList = []; // raw per-article rows; the client costs them at live rates\n\n for (const t of tasks) {\n const cf = cfMap(t);\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const dv = cf[\"Publish Date\"]?.date_value;\n const pub = dv && typeof dv === \"object\" ? dv.date : null;\n const author = cf[\"Author\"]?.display_value || null;\n const editor = cf[\"Editor\"]?.display_value || null;\n const monthKey = pub ? pub.slice(0, 7) : key;\n if (monthKey !== key) continue;\n\n const { cls, setCode } = classify(t);\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Article Type\"]?.display_value || null,\n cls,\n setCode,\n words: wc,\n author,\n editor,\n date: pub,\n });\n\n articles++;\n sectionWords += wc;\n if (author) {\n writtenWords += wc;\n const a = authors.get(author) || { name: author, words: 0, articles: 0 };\n a.words += wc;\n a.articles++;\n authors.set(author, a);\n } else {\n unattributedWords += wc;\n }\n if (editor) {\n editedWords += wc;\n const e = editors.get(editor) || { name: editor, words: 0, articles: 0 };\n e.words += wc;\n e.articles++;\n editors.set(editor, e);\n }\n }\n\n // attach each person's rate + month-to-date cost\n const writerRate = (n) => rates.writers[n];\n let writingCost = 0;\n const byAuthor = [...authors.values()].sort((a, b) => b.words - a.words).map(\n (a) => {\n const known = writerRate(a.name) != null;\n const rate = known ? writerRate(a.name) : rates.defaultWriteRate;\n const cost = a.words * rate;\n writingCost += cost;\n return { ...a, rate, cost, fallback: !known };\n },\n );\n\n let editingCost = 0, perwordEditedWords = 0;\n const byEditor = [...editors.values()].sort((a, b) => b.words - a.words).map(\n (e) => {\n const r = rates.editors[e.name];\n if (r && r.type === \"hourly\") {\n return {\n ...e,\n type: \"hourly\",\n rate: r.rate,\n cost: null,\n fallback: false,\n };\n }\n const known = !!(r && r.type === \"perword\");\n const rate = known ? r.rate : rates.defaultEditRate;\n const cost = e.words * rate;\n editingCost += cost;\n perwordEditedWords += e.words;\n return { ...e, type: \"perword\", rate, cost, fallback: !known };\n },\n );\n\n return {\n key,\n label: now.toLocaleString(\"en-US\", { month: \"long\", year: \"numeric\" }),\n dayOfMonth,\n daysInMonth,\n fracElapsed,\n articles,\n writtenWords,\n editedWords,\n perwordEditedWords,\n unattributedWords,\n sectionWords,\n writingCost,\n editingCost,\n byAuthor,\n byEditor,\n articleList: articleList.sort((a, b) => b.words - a.words),\n };\n}\n\n// One call that does the live Asana fetch + folds in the history + rate snapshots.\nasync function assembleData(token, history, rates, now = new Date()) {\n const sec = await getPublishedSection(token);\n const tasks = await getPublishedTasks(sec.gid, token);\n return {\n generatedAt: now.toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n }),\n section: sec.name,\n defaults: DEFAULTS,\n rates,\n currentMonth: buildCurrentMonth(tasks, rates, now),\n history: history.months,\n lastClosedMonth: history.lastClosedMonth,\n recurring: history.recurring || [],\n };\n}\n\n// ---------------------------------------------------------------------------\n// render (embedded from render.mjs)\n// ---------------------------------------------------------------------------\n// render.mjs - dashboard HTML + client logic for the Draftsim content-spend tracker.\n// Pure: takes the assembled `data` object and returns an HTML string.\n// Each article is costed at its own author/editor rate (from payroll -> rates.json);\n// the rates are editable per-person in the writer/editor tables and recompute live.\n\nfunction renderPage(data) {\n const json = JSON.stringify(data).replace(/\n\n\n\n\nDraftsim Content Spend\n\n\n\n \n\n

\n Fixed-pay average\n

\n \n \n \n

\n history window for hourly/salary/contractor forecast\n

\n Current-month basis\n

\n \n \n

\n \n

\n \n \n per-person rates from payroll: edit any below\n

\n\n

Monthly content spend

\n\n

This month: writers

Words from Asana × each writer's payroll rate. Edit a rate to re-cost.

\n \n \n \n \n

Writer	Articles	Words	$/word	Est. $

This month: editors

Per-word editors costed here; hourly editors sit in the fixed bucket.

\n \n \n \n \n

Editor	Articles	Words	Rate	Est. $

\n\n

Expected pay this month: by person

Per-word pay for work published so far this month + each person's recurring/fixed monthly pay (3-mo avg). Edit rates above to re-cost.

\n \n \n \n

Person	Writing	Editing	Hourly / fixed	Total

\n\n

By content type

New-set vs new vs updates vs news, from Asana tags (work to date).

\n \n \n \n

Content type	Articles	Words	Cost

By article type

Asana \"Article Type\" field (work to date).

\n \n \n \n

Article type	Articles	Words	Cost

\n\n

Articles published this month

Every published item with its word count and estimated cost (writer + editor rate). Click a header to sort.

\n \n \n \n \n \n \n \n \n \n \n \n

Article	Class	Type	Words	Writer	Editor	Cost

\n\n

Recent months: actual paid (from payroll)

Real dollars paid per category. The current month is a live estimate; everything else is booked.

\n \n \n \n

Month	Writing	Editing	Hourly	Salary	Contractor	Total

\n\n

\n\n\n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// val.town HTTP handler\n// ---------------------------------------------------------------------------\nexport default async function (req: Request): Promise {\n const token = Deno.env.get(\"ASANA_TOKEN\");\n if (!token) {\n return new Response(\"Missing ASANA_TOKEN env var\", { status: 500 });\n }\n // Access gate: this page shows pay rates + payroll spend. Set an ACCESS_KEY\n // env var and the page requires ?key= (or an Authorization: Bearer\n // header). Leave ACCESS_KEY unset to make the page open to anyone with\n // the URL - not recommended for this data.\n const gate = Deno.env.get(\"ACCESS_KEY\");\n if (gate) {\n const url = new URL(req.url);\n const supplied = url.searchParams.get(\"key\") ||\n (req.headers.get(\"authorization\") || \"\").replace(/^Bearer\\s+/i, \"\");\n if (supplied !== gate) {\n return new Response(\"Unauthorized. Append ?key=... to the URL.\", {\n status: 401,\n });\n }\n }\n\n // Pay data comes from private blob storage, not the (public) source.\n let HISTORY: any, RATES: any;\n try {\n [HISTORY, RATES] = await Promise.all([\n blob.getJSON(\"contentspend_history\"),\n blob.getJSON(\"contentspend_rates\"),\n ]);\n } catch (e: any) {\n return new Response(\"Could not read data blobs: \" + e.message, {\n status: 500,\n });\n }\n if (!HISTORY || !RATES) {\n return new Response(\n \"Missing data blobs. Upload contentspend_history and contentspend_rates.\",\n { status: 500 },\n );\n }\n\n try {\n const data = await assembleData(token, HISTORY, RATES);\n if (new URL(req.url).pathname.startsWith(\"/api\")) {\n return new Response(JSON.stringify(data, null, 2), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n return new Response(renderPage(data), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (err: any) {\n return new Response(\n `

Error: ${err.message}\\n\\n${err.stack}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n}","// contentSpend.valtown.ts - Draftsim Content Spend dashboard (val.town HTTP val).\n//\n// GENERATED by build-valtown.mjs from core.mjs + render.mjs.\n// Do not edit by hand; edit those sources and re-run `node build-valtown.mjs`.\n//\n// Deploy (free tier / public code, private data):\n// 1. Upload history.json -> private blob \"contentspend_history\"\n// and rates.json -> private blob \"contentspend_rates\".\n// 2. Create a new HTTP val, paste this whole file.\n// 3. Set env vars: ASANA_TOKEN (required) and ACCESS_KEY (recommended).\n// The pay numbers live in your private blobs, never in this public source.\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// ---------------------------------------------------------------------------\n// core (embedded from core.mjs)\n// ---------------------------------------------------------------------------\n// core.mjs - runtime-agnostic data layer (Node 18+ and Deno both have global fetch).\n// No env/fs access here; the caller passes the Asana token and the history object.\n// This same source is embedded verbatim into the val.town build (see build-valtown.mjs),\n// so the local demo and the hosted val compute identically.\n\nconst ASANA_BASE = \"https://app.asana.com/api/1.0\";\nconst PROJECT_GID = \"1200493284657065\"; // \"Draftsim Articles\"\nconst DEFAULTS = { writingRate: 0.037, editingRate: 0.02, fixedAvgMonths: 3 };\n\nasync function asanaGet(pathAndQuery, token) {\n const res = await fetch(`${ASANA_BASE}${pathAndQuery}`, {\n headers: { Authorization: `Bearer ${token}`, Accept: \"application/json\" },\n });\n if (!res.ok) throw new Error(`Asana ${pathAndQuery} -> ${res.status} ${await res.text()}`);\n return res.json();\n}\n\nasync function getPublishedSection(token) {\n const { data } = await asanaGet(`/projects/${PROJECT_GID}/sections?opt_fields=name`, token);\n const sec = data.find((s) => /^published/i.test(s.name)); // \"Published (Done)\"\n if (!sec) throw new Error(\"Published section not found in Draftsim Articles\");\n return sec;\n}\n\nasync function getPublishedTasks(sectionGid, token) {\n const tasks = [];\n let offset;\n const fields =\n \"name,tags.name,custom_fields.name,custom_fields.display_value,custom_fields.number_value,custom_fields.date_value\";\n while (true) {\n const q = new URLSearchParams({ limit: \"100\", opt_fields: fields });\n if (offset) q.set(\"offset\", offset);\n const data = await asanaGet(`/sections/${sectionGid}/tasks?${q}`, token);\n tasks.push(...data.data);\n offset = data.next_page?.offset;\n if (!offset) break;\n }\n return tasks;\n}\n\nfunction cfMap(task) {\n const m = {};\n for (const cf of task.custom_fields || []) m[cf.name] = cf;\n return m;\n}\n\nconst SET_CODE = /^[A-Z0-9]{2,4}$/; // MTG set-code tags: MSH, FDN, DSK, TDM...\n\n// Classify an article by Asana signals into its content lifecycle.\nfunction classify(task) {\n const tags = (task.tags || []).map((t) => t.name);\n if (tags.includes(\"Writer Update\") || /\$update\$/i.test(task.name)) {\n return { cls: \"Update\", setCode: null };\n }\n const set = tags.find((t) => SET_CODE.test(t));\n if (set) return { cls: \"New set\", setCode: set };\n if (tags.includes(\"New\")) return { cls: \"New article\", setCode: null };\n return { cls: \"News / Other\", setCode: null };\n}\n\n// Aggregate the live \"Published (Done)\" section into this month's word counts,\n// pricing each writer and editor at THEIR actual per-word rate from payroll\n// (rates.json). The section only ever holds the current month, so undated items\n// are treated as current-month too. Writing words = words on authored items;\n// editing words = words on items that have an editor assigned. Editors paid\n// hourly (not per-word) are flagged and excluded from the per-word editing total\n// - their pay lives in the historical hourly bucket instead.\nfunction buildCurrentMonth(tasks, rates, now = new Date()) {\n const key = `${now.getFullYear()}-${String(now.getMonth() + 1).padStart(2, \"0\")}`;\n const daysInMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0).getDate();\n const dayOfMonth = now.getDate();\n const fracElapsed = dayOfMonth / daysInMonth;\n\n let writtenWords = 0, editedWords = 0, articles = 0, unattributedWords = 0, sectionWords = 0;\n const authors = new Map();\n const editors = new Map();\n const articleList = []; // raw per-article rows; the client costs them at live rates\n\n for (const t of tasks) {\n const cf = cfMap(t);\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const dv = cf[\"Publish Date\"]?.date_value;\n const pub = dv && typeof dv === \"object\" ? dv.date : null;\n const author = cf[\"Author\"]?.display_value || null;\n const editor = cf[\"Editor\"]?.display_value || null;\n const monthKey = pub ? pub.slice(0, 7) : key;\n if (monthKey !== key) continue;\n\n const { cls, setCode } = classify(t);\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Article Type\"]?.display_value || null,\n cls, setCode,\n words: wc, author, editor,\n date: pub,\n });\n\n articles++;\n sectionWords += wc;\n if (author) {\n writtenWords += wc;\n const a = authors.get(author) || { name: author, words: 0, articles: 0 };\n a.words += wc; a.articles++; authors.set(author, a);\n } else {\n unattributedWords += wc;\n }\n if (editor) {\n editedWords += wc;\n const e = editors.get(editor) || { name: editor, words: 0, articles: 0 };\n e.words += wc; e.articles++; editors.set(editor, e);\n }\n }\n\n // attach each person's rate + month-to-date cost\n const writerRate = (n) => rates.writers[n];\n let writingCost = 0;\n const byAuthor = [...authors.values()].sort((a, b) => b.words - a.words).map((a) => {\n const known = writerRate(a.name) != null;\n const rate = known ? writerRate(a.name) : rates.defaultWriteRate;\n const cost = a.words * rate;\n writingCost += cost;\n return { ...a, rate, cost, fallback: !known };\n });\n\n let editingCost = 0, perwordEditedWords = 0;\n const byEditor = [...editors.values()].sort((a, b) => b.words - a.words).map((e) => {\n const r = rates.editors[e.name];\n if (r && r.type === \"hourly\") {\n return { ...e, type: \"hourly\", rate: r.rate, cost: null, fallback: false };\n }\n const known = !!(r && r.type === \"perword\");\n const rate = known ? r.rate : rates.defaultEditRate;\n const cost = e.words * rate;\n editingCost += cost;\n perwordEditedWords += e.words;\n return { ...e, type: \"perword\", rate, cost, fallback: !known };\n });\n\n return {\n key,\n label: now.toLocaleString(\"en-US\", { month: \"long\", year: \"numeric\" }),\n dayOfMonth, daysInMonth, fracElapsed,\n articles, writtenWords, editedWords, perwordEditedWords, unattributedWords, sectionWords,\n writingCost, editingCost,\n byAuthor, byEditor,\n articleList: articleList.sort((a, b) => b.words - a.words),\n };\n}\n\n// One call that does the live Asana fetch + folds in the history + rate snapshots.\nasync function assembleData(token, history, rates, now = new Date()) {\n const sec = await getPublishedSection(token);\n const tasks = await getPublishedTasks(sec.gid, token);\n return {\n generatedAt: now.toLocaleString(\"en-US\", {\n month: \"short\", day: \"numeric\", year: \"numeric\", hour: \"numeric\", minute: \"2-digit\",\n }),\n section: sec.name,\n defaults: DEFAULTS,\n rates,\n currentMonth: buildCurrentMonth(tasks, rates, now),\n history: history.months,\n lastClosedMonth: history.lastClosedMonth,\n recurring: history.recurring || [],\n };\n}\n\n// ---------------------------------------------------------------------------\n// render (embedded from render.mjs)\n// ---------------------------------------------------------------------------\n// render.mjs - dashboard HTML + client logic for the Draftsim content-spend tracker.\n// Pure: takes the assembled `data` object and returns an HTML string.\n// Each article is costed at its own author/editor rate (from payroll -> rates.json);\n// the rates are editable per-person in the writer/editor tables and recompute live.\n\nfunction renderPage(data) {\n const json = JSON.stringify(data).replace(/\n\n\n\n\nDraftsim Content Spend\n\n\n\n \n\n

\n Fixed-pay average\n

\n \n \n \n

\n history window for hourly/salary/contractor forecast\n

\n Current-month basis\n

\n \n \n

\n \n

\n \n \n per-person rates from payroll: edit any below\n

\n\n

Monthly content spend

\n\n

This month: writers

Words from Asana × each writer's payroll rate. Edit a rate to re-cost.

\n \n \n \n \n

Writer	Articles	Words	$/word	Est. $

This month: editors

Per-word editors costed here; hourly editors sit in the fixed bucket.

\n \n \n \n \n

Editor	Articles	Words	Rate	Est. $

\n\n

Expected pay this month: by person

Per-word pay for work published so far this month + each person's recurring/fixed monthly pay (3-mo avg). Edit rates above to re-cost.

\n \n \n \n

Person	Writing	Editing	Hourly / fixed	Total

\n\n

By content type

New-set vs new vs updates vs news, from Asana tags (work to date).

\n \n \n \n

Content type	Articles	Words	Cost

By article type

Asana \"Article Type\" field (work to date).

\n \n \n \n

Article type	Articles	Words	Cost

\n\n

Articles published this month

Every published item with its word count and estimated cost (writer + editor rate). Click a header to sort.

\n \n \n \n \n \n \n \n \n \n \n \n

Article	Class	Type	Words	Writer	Editor	Cost

\n\n

Recent months: actual paid (from payroll)

Real dollars paid per category. The current month is a live estimate; everything else is booked.

\n \n \n \n

Month	Writing	Editing	Hourly	Salary	Contractor	Total

\n\n

\n\n\n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// val.town HTTP handler\n// ---------------------------------------------------------------------------\nexport default async function (req: Request): Promise {\n // Everything sensitive lives in PRIVATE blob storage (this source is public on\n // the free tier): pay data in contentspend_history / contentspend_rates, and the\n // Asana token + access key in contentspend_config = { asanaToken, accessKey }.\n // Env vars (ASANA_TOKEN / ACCESS_KEY) override the config blob if you set them.\n let HISTORY: any, RATES: any, CFG: any;\n try {\n [HISTORY, RATES, CFG] = await Promise.all([\n blob.getJSON(\"contentspend_history\"),\n blob.getJSON(\"contentspend_rates\"),\n blob.getJSON(\"contentspend_config\").catch(() => null),\n ]);\n } catch (e: any) {\n return new Response(\"Could not read data blobs: \" + e.message, { status: 500 });\n }\n if (!HISTORY || !RATES) {\n return new Response(\n \"Missing data blobs. Upload contentspend_history and contentspend_rates.\",\n { status: 500 },\n );\n }\n\n const token = Deno.env.get(\"ASANA_TOKEN\") || (CFG && CFG.asanaToken);\n if (!token) {\n return new Response(\"Missing Asana token (set ASANA_TOKEN env var or asanaToken in contentspend_config).\", { status: 500 });\n }\n // Access gate: this page shows pay rates + payroll spend. With an access key set\n // (accessKey in the config blob, or the ACCESS_KEY env var) the page requires\n // ?key= (or an Authorization: Bearer header).\n const gate = Deno.env.get(\"ACCESS_KEY\") || (CFG && CFG.accessKey);\n if (gate) {\n const url = new URL(req.url);\n const supplied =\n url.searchParams.get(\"key\") ||\n (req.headers.get(\"authorization\") || \"\").replace(/^Bearer\\s+/i, \"\");\n if (supplied !== gate) {\n return new Response(\"Unauthorized. Append ?key=... to the URL.\", { status: 401 });\n }\n }\n\n try {\n const data = await assembleData(token, HISTORY, RATES);\n if (new URL(req.url).pathname.startsWith(\"/api\")) {\n return new Response(JSON.stringify(data, null, 2), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n return new Response(renderPage(data), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (err: any) {\n return new Response(\n `

Error: ${err.message}\\n\\n${err.stack}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n}","createdAt",["D",1782856929286],"branchVersion","branchId","cae77d29-818c-492b-959e-6a982f9df982","id","e7d98772-0509-432f-b71a-a6330d42ebc1","content-spend",["D",1782856436302],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","019bd925-31f2-71b7-9f59-cedf4ab98166","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019bd925-31f2-71b7-9f59-d0cff0553afe","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",8,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Jakedraftsim","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM4VkIyMW5TdXh3TEVDZHZIcllIQ0d1blF1OSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":149,"_79":150,"_81":151,"_83":25},"tree",[143],"files",[143],"counts",{"_132":61,"_133":134,"_135":61,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"9c4b539b-bf9e-4ad7-a331-1c6f6411afe9","parentId","latest",["D",1782856929286],2,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":61,"_142":61},"connections",{"_140":61,"_141":61},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":144,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1782856929286],"children",[],[28],["D",1782856436302],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":194,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_156":157,"_158":159,"_160":85,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v3