Capacity Prompt — Prompt Couture

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","promptcouture","name","Pulse_Staging","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","4a859bf6-5a73-11f1-a632-ee650bb23af1","pulseStaging.ts","fileId","99782b62-49f1-11f1-99a7-ee650bb23af1","parentId","branchId","99732ffe-49f1-11f1-99a7-ee650bb23af1","branchVersion",23,"latest",true,"createdAt",["D",1779958664300],22,"fileType","http","content","// Capacity Prompt — Val.town HTTP val\n// Adapted from Cloudflare Worker. Deploy at https://www.val.town/new/http\n// Set NOTION_TOKEN as env var (Settings → Environment Variables)\n\nconst NOTION_VERSION = \"2025-09-03\";\nconst DATA_SOURCE_ID = \"8e81c66e-8498-4057-bc6b-1268a47ae175\";\n\n// Consultoras que NÃO entregam workshops — escondidas das rows e do filtro\nconst EXCLUDED_CONSULTANTS = new Set([\n \"Ana Prieto\",\n \"Beatriz Fernandes\",\n \"Bruna Bittencourt\",\n \"Rosa Fernandez\",\n]);\n\nconst ALL_CONSULTANTS = [\n \"Marta Gallego\",\n \"Patricia Navarro\",\n \"Laetitia Dupuich\",\n \"Roser Loureiro\",\n \"Blanca Perez\",\n \"Clara Badia\",\n \"Elda de Salas\",\n \"Giovanna Thereza\",\n \"Monica Moreno\",\n \"Monica Sarasa\",\n \"Carlota Anduiza\",\n \"Belen Revilla\",\n \"Bruna Molineiro\",\n \"Fernanda Brunoro\",\n \"Leticia Dias\",\n \"Carla Nadal\",\n \"Luciano Gomes\",\n];\n\n// 10 marcas Inditex — qualquer outra brand vira \"CLIENTES\" no Tipo Cliente\nconst INDITEX_BRANDS = new Set([\n \"Bershka\",\n \"Lefties\",\n \"Massimo Dutti\",\n \"Oysho\",\n \"Pull&Bear\",\n \"Stradivarius\",\n \"Tempe\",\n \"Zara\",\n \"Zara Home\",\n \"Multibrand\",\n]);\n\nconst MONTHS_ES = [\n \"ENE\",\n \"FEB\",\n \"MAR\",\n \"APR\",\n \"MAY\",\n \"JUN\",\n \"JUL\",\n \"AGO\",\n \"SEP\",\n \"OCT\",\n \"NOV\",\n \"DIC\",\n];\n\n// Slug → nome completo. Inclui também as 4 consultoras em EXCLUDED_CONSULTANTS\n// porque elas podem querer ver a vista pessoal mesmo não entregando workshops.\n// Product Managers — rota /pm/ renderiza vista global (mesma view geral que /),\n// porta de entrada distinta pra futuramente diferenciar permissões/escopo sem mexer no resto.\nconst PM_SLUG_TO_NAME: Record = {\n \"marta-gallego\": \"Marta Gallego\",\n \"monica-moreno\": \"Monica Moreno\",\n};\n\n// PM de Inditex — rota /pm-inditex/ com filtro tipoCliente=INDITEX pré-aplicado.\nconst PM_INDITEX_SLUG_TO_NAME: Record = {\n \"belen-revilla\": \"Belen Revilla\",\n};\n\nconst SLUG_TO_NAME: Record = {\n \"ana-prieto\": \"Ana Prieto\",\n \"beatriz-fernandes\": \"Beatriz Fernandes\",\n \"belen-revilla\": \"Belen Revilla\",\n \"blanca-perez\": \"Blanca Perez\",\n \"bruna-bittencourt\": \"Bruna Bittencourt\",\n \"bruna-molineiro\": \"Bruna Molineiro\",\n \"carla-nadal\": \"Carla Nadal\",\n \"carlota-anduiza\": \"Carlota Anduiza\",\n \"clara-badia\": \"Clara Badia\",\n \"elda-de-salas\": \"Elda de Salas\",\n \"fernanda-brunoro\": \"Fernanda Brunoro\",\n \"giovanna-thereza\": \"Giovanna Thereza\",\n \"laetitia-dupuich\": \"Laetitia Dupuich\",\n \"leticia-dias\": \"Leticia Dias\",\n \"luciano-gomes\": \"Luciano Gomes\",\n \"marta-gallego\": \"Marta Gallego\",\n \"monica-moreno\": \"Monica Moreno\",\n \"monica-sarasa\": \"Monica Sarasa\",\n \"patricia-navarro\": \"Patricia Navarro\",\n \"roser-loureiro\": \"Roser Loureiro\",\n};\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname.endsWith(\"/api/workshops\")) {\n return await fetchWorkshops();\n }\n\n if (url.pathname.endsWith(\"/health\")) {\n return new Response(\n JSON.stringify({ ok: true, time: new Date().toISOString() }),\n {\n headers: { \"content-type\": \"application/json\" },\n },\n );\n }\n\n // Rota /pm-inditex/ — vista pré-filtrada por tipoCliente=INDITEX\n const pmInditexMatch = url.pathname.match(/\\/pm-inditex\\/([a-z0-9-]+)\\/?$/);\n if (pmInditexMatch) {\n const slug = pmInditexMatch[1];\n const name = PM_INDITEX_SLUG_TO_NAME[slug];\n if (!name) {\n return new Response(`PM Inditex \"${slug}\" não encontrada.`, {\n status: 404,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n const pmiHTML = HTML.replace(\n \"\",\n ``,\n );\n return new Response(pmiHTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-cache, no-store, must-revalidate\",\n \"x-frame-options\": \"ALLOWALL\",\n \"content-security-policy\": \"frame-ancestors *\",\n },\n });\n }\n\n // Rota /pm/ — vista global pra Product Managers (sem filtro nem mascaramento)\n const pmMatch = url.pathname.match(/\\/pm\\/([a-z0-9-]+)\\/?$/);\n if (pmMatch) {\n const slug = pmMatch[1];\n const name = PM_SLUG_TO_NAME[slug];\n if (!name) {\n return new Response(`PM \"${slug}\" não encontrada.`, {\n status: 404,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n const pmHTML = HTML.replace(\n \"\",\n ``,\n );\n return new Response(pmHTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-cache, no-store, must-revalidate\",\n \"x-frame-options\": \"ALLOWALL\",\n \"content-security-policy\": \"frame-ancestors *\",\n },\n });\n }\n\n // Rota /c/ — vista pré-filtrada por consultora\n const consultantMatch = url.pathname.match(/\\/c\\/([a-z0-9-]+)\\/?$/);\n if (consultantMatch) {\n const slug = consultantMatch[1];\n const name = SLUG_TO_NAME[slug];\n if (!name) {\n return new Response(`Consultora \"${slug}\" não encontrada.`, {\n status: 404,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n }\n const customHTML = HTML\n .replace(\n \"Capacity Prompt — Prompt Couture\",\n `${name} — Capacity Prompt`,\n )\n .replace(\n \"\",\n ``,\n );\n return new Response(customHTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-cache, no-store, must-revalidate\",\n \"x-frame-options\": \"ALLOWALL\",\n \"content-security-policy\": \"frame-ancestors *\",\n },\n });\n }\n\n return new Response(HTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-cache, no-store, must-revalidate\",\n \"x-frame-options\": \"ALLOWALL\",\n \"content-security-policy\": \"frame-ancestors *\",\n },\n });\n}\n\n// Fonte de dados: Google Apps Script Web App (lê do Sheet \"Pulse Workshops SSOT\").\n// Substituiu Notion data source em 24-mai-2026. Notion fica como mirror congelado.\nconst APPS_SCRIPT_URL =\n \"https://script.google.com/macros/s/AKfycbz2bCPEOuienbyhPLzLFKOlXwfNnb1XKeRiOWAlJD6WT_deo88SWGDCA2qkaes3wIHc/exec\";\n\nasync function fetchWorkshops(): Promise {\n try {\n const r = await fetch(APPS_SCRIPT_URL, {\n headers: { \"Cache-Control\": \"no-cache\" },\n });\n if (!r.ok) return jsonError(`Apps Script error ${r.status}`, r.status);\n const data = await r.json();\n if (data.error) return jsonError(`Apps Script: ${data.error}`, 500);\n\n return new Response(\n JSON.stringify({\n workshops: data.workshops || [],\n consultants: ALL_CONSULTANTS,\n excludedConsultants: Array.from(EXCLUDED_CONSULTANTS),\n weeks: data.weeks || [],\n lastUpdated: data.lastUpdated || new Date().toISOString(),\n source: data.source || \"apps-script\",\n }),\n {\n headers: {\n \"content-type\": \"application/json\",\n \"cache-control\": \"public, max-age=30\",\n \"access-control-allow-origin\": \"*\",\n },\n },\n );\n } catch (e: any) {\n return jsonError(`fetch error: ${e.message}`, 500);\n }\n}\n\nfunction jsonError(msg: string, status: number): Response {\n return new Response(JSON.stringify({ error: msg }), {\n status,\n headers: {\n \"content-type\": \"application/json\",\n \"access-control-allow-origin\": \"*\",\n },\n });\n}\n\nfunction readSelect(p: any) {\n return p?.select?.name || null;\n}\nfunction readTitle(p: any) {\n return (p?.title || []).map((t: any) => t.plain_text).join(\"\");\n}\nfunction readText(p: any) {\n return (p?.rich_text || []).map((t: any) => t.plain_text).join(\"\");\n}\nfunction readDate(p: any) {\n return p?.date?.start || null;\n}\nfunction readUrl(p: any) {\n return p?.url || null;\n}\n\nfunction isoWeek(dateStr: string | null) {\n if (!dateStr) return null;\n const d = new Date(dateStr + \"T00:00:00Z\");\n const target = new Date(d.valueOf());\n const dayNr = (d.getUTCDay() + 6) % 7;\n target.setUTCDate(target.getUTCDate() - dayNr + 3);\n const firstThursday = new Date(Date.UTC(target.getUTCFullYear(), 0, 4));\n const diff = (target as any) - (firstThursday as any);\n const week = 1 + Math.round(diff / (7 * 24 * 3600 * 1000));\n return { week, year: target.getUTCFullYear() };\n}\n\nfunction normalize(page: any) {\n const props = page.properties || {};\n const startDate = readDate(props[\"WS Start\"]);\n const endDate = readDate(props[\"WS End\"]);\n const iso = isoWeek(startDate);\n const dStart = startDate ? new Date(startDate + \"T00:00:00Z\") : null;\n const brand = readSelect(props[\"Brand\"]);\n const monthNum = dStart ? dStart.getUTCMonth() : null;\n const monthEs = monthNum != null ? MONTHS_ES[monthNum] : null;\n const quarterNum = monthNum != null ? Math.floor(monthNum / 3) + 1 : null;\n return {\n id: page.id,\n name: readTitle(props[\"WS ID\"]),\n type: readSelect(props[\"WS Type\"]),\n brand,\n status: readSelect(props[\"Fecha Status\"]),\n section: readSelect(props[\"Section\"]),\n tipoCliente: brand && INDITEX_BRANDS.has(brand) ? \"INDITEX\" : \"CLIENTES\",\n consultant1: readSelect(props[\"Consultant 1\"]),\n role1: readSelect(props[\"Consultant 1 Role\"]),\n consultant2: readSelect(props[\"Consultant 2\"]),\n role2: readSelect(props[\"Consultant 2 Role\"]),\n region: readSelect(props[\"Region\"]),\n location: readText(props[\"Location\"]),\n notes: readText(props[\"Notes\"]),\n asanaTaskId: readText(props[\"Asana Task ID\"]),\n asanaUrl: readUrl(props[\"Asana URL\"]),\n start: startDate,\n end: endDate || startDate,\n week: iso ? iso.week : null,\n weekKey: iso ? `${iso.year}-W${iso.week}` : null,\n year: iso ? iso.year : null,\n monthNum,\n monthEs,\n monthKey: dStart\n ? `${dStart.getUTCFullYear()}-${String(monthNum! + 1).padStart(2, \"0\")}`\n : null,\n quarterNum,\n quarterKey: dStart && quarterNum\n ? `${dStart.getUTCFullYear()}-Q${quarterNum}`\n : null,\n notionUrl: page.url,\n };\n}\n\nfunction buildWeekMeta(workshops: any[]) {\n const weeksMap = new Map();\n workshops.forEach((w) => {\n if (!w.week) return;\n const key = `${w.year}-${w.week}`;\n if (!weeksMap.has(key)) {\n const d = isoWeekToDate(w.year, w.week);\n weeksMap.set(key, {\n week: w.week,\n year: w.year,\n label: `W${w.week}`,\n monthStart: MONTHS_ES[d.getUTCMonth()],\n monthNum: d.getUTCMonth(),\n dayStart: d.getUTCDate(),\n iso: d.toISOString().slice(0, 10),\n });\n }\n });\n return Array.from(weeksMap.values()).sort((a: any, b: any) =>\n a.year - b.year || a.week - b.week\n );\n}\n\nfunction isoWeekToDate(year: number, week: number) {\n const simple = new Date(Date.UTC(year, 0, 1 + (week - 1) * 7));\n const dow = simple.getUTCDay();\n const ISOweekStart = simple;\n if (dow <= 4) {\n ISOweekStart.setUTCDate(simple.getUTCDate() - simple.getUTCDay() + 1);\n } else ISOweekStart.setUTCDate(simple.getUTCDate() + 8 - simple.getUTCDay());\n return ISOweekStart;\n}\n\nconst HTML = `\n\n\n\n\nPulse · Prompt Couture\n\n\n\n\n\n\n\n\n\n\n

\n\n

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

\n\n

Cargando datos del Notion…

\n\n \n

\n\n

\n\n\n\n`;","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1779958664300],"children",[],[35],"997219fc-49f1-11f1-99a7-ee650bb23af1",["D",1778143743552],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","64662b90-afcf-4753-90ce-78ade120b2d4","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e0199-7b1c-766c-94bf-7fb961bf5511","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","prompt couture","avatar","https://avatars.githubusercontent.com/u/213539682?v=4","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":149,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":150,"_95":151,"_97":152,"_99":53},[146],"files",[146],"counts",{"_136":77,"_137":138,"_139":77,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":135},[35],"pulls","branches",1,"forks",{"_143":77,"_145":77},"connections",{"_143":77,"_144":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":147,"_18":148},[],[35],["D",1778143743552],{"_11":12,"_115":111},{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_131":186,"_187":188,"_189":190,"_191":53,"_192":53,"_193":53,"_194":44,"_195":-5,"_196":-7,"_197":-7,"_198":77,"_199":53,"_200":53,"_201":-5,"_202":53,"_203":53,"_204":53,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Code