[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_119":-5,"_20":120,"_22":121,"_122":123,"_124":125,"_25":126,"_24":-5,"_127":-5,"_128":-5,"_129":53,"_130":131,"_132":53,"_133":-5,"_134":-5,"_135":136},"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","jacobbaggenstos","name","square-oos-tracker","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":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","11385ef9-0d6e-491f-bacc-2edaac1fccdf","main.ts","fileId","ae454bae-6997-11f1-bdec-1607ee4eb77e","parentId","branchId","9dcae4b9-08cc-4964-a164-6f0f30e90ef4","branchVersion",7,"latest",true,"createdAt",["D",1781880909797],6,"fileType","interval","content","import { blob } from \"https://esm.town/v/std/blob\";\n\n// ============================================================\n// Farine Bakery — OOS Tracker (Scheduled Val)\n// Runs every 15 minutes. Set cron to: */15 7-14 * * * (UTC)\n// which covers 7am–3pm Pacific Standard Time.\n// During daylight saving time adjust to: */15 6-13 * * *\n//\n// What it does each run:\n// - Fetches current catalog sold_out state from Square\n// - Diffs against last known state stored in Val Town blob\n// - Writes opened/closed OOS intervals to Supabase\n//\n// Required Val Town environment secrets:\n// SQUARE_ACCESS_TOKEN\n// SUPABASE_URL\n// SUPABASE_SERVICE_ROLE_KEY\n//\n// Location map — update if your Square location IDs change:\nconst LOCATION_MAP: Record = {\n \"LQTKG0MSFM705\": \"Red\",\n \"L17CH567XST07\": \"Bel\",\n \"LV9AVHDXETGHA\": \"Wood\",\n};\n// ============================================================\n\nexport default async function (): Promise {\n const squareToken = Deno.env.get(\"SQUARE_ACCESS_TOKEN\") ?? \"\";\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\") ?? \"\";\n const supabaseKey = Deno.env.get(\"SUPABASE_SERVICE_ROLE_KEY\") ?? \"\";\n if (!squareToken || !supabaseUrl || !supabaseKey) {\n console.error(\"Missing env vars\");\n return;\n }\n\n const now = new Date();\n const nowISO = now.toISOString();\n const todayDate = nowISO.split(\"T\")[0];\n\n // ── Fetch full catalog ───────────────────────────────────\n const currentState: Record> = {};\n const nameMap: Record = {};\n\n let cursor: string | null = null;\n do {\n const url = \"https://connect.squareup.com/v2/catalog/list?types=ITEM\" +\n (cursor ? `&cursor=${cursor}` : \"\");\n const res = await fetch(url, {\n headers: {\n \"Authorization\": `Bearer ${squareToken}`,\n \"Square-Version\": \"2024-01-18\",\n },\n });\n const data = await res.json();\n if (data.errors) {\n console.error(\"Catalog fetch error:\", data.errors);\n return;\n }\n\n for (const obj of data.objects ?? []) {\n if (obj.type !== \"ITEM\") continue;\n const base = obj.item_data?.name ?? \"\";\n for (const v of obj.item_data?.variations ?? []) {\n const vn = v.item_variation_data?.name ?? \"\";\n const displayName = vn && vn.toLowerCase() !== \"regular\"\n ? `${base} — ${vn}`\n : base;\n nameMap[v.id] = displayName;\n currentState[v.id] = {};\n for (\n const override of v.item_variation_data?.location_overrides ?? []\n ) {\n const locKey = LOCATION_MAP[override.location_id];\n if (locKey) currentState[v.id][locKey] = override.sold_out === true;\n }\n }\n }\n cursor = data.cursor ?? null;\n } while (cursor);\n\n console.log(`Fetched ${Object.keys(currentState).length} variations`);\n\n // ── Load previous state from blob storage ────────────────\n const prevState: Record> =\n await blob.getJSON(\"oos_prev_state\") ?? {};\n const isFirstRun = Object.keys(prevState).length === 0;\n\n // ── Detect transitions ───────────────────────────────────\n const wentUnavailable: Array<{ varId: string; locKey: string }> = [];\n const cameBack: Array<{ varId: string; locKey: string }> = [];\n\n if (!isFirstRun) {\n // Went unavailable: now sold_out, wasn't before\n for (const [varId, locStates] of Object.entries(currentState)) {\n for (const [locKey, soldOut] of Object.entries(locStates)) {\n const wasOut = prevState[varId]?.[locKey] ?? false;\n if (soldOut && !wasOut) wentUnavailable.push({ varId, locKey });\n if (!soldOut && wasOut) cameBack.push({ varId, locKey });\n }\n }\n\n // Came back: explicitly false override (Square removes override when available again,\n // so this catches the rarer case where it stays in overrides but flips to false)\n for (const [varId, prevLocStates] of Object.entries(prevState)) {\n for (const [locKey, wasOut] of Object.entries(prevLocStates)) {\n if (!wasOut) continue;\n const currentLocStates = currentState[varId] ?? {};\n if ((locKey in currentLocStates) && !currentLocStates[locKey]) {\n if (!cameBack.find((e) => e.varId === varId && e.locKey === locKey)) {\n cameBack.push({ varId, locKey });\n }\n }\n }\n }\n }\n\n console.log(\n `Transitions: ${wentUnavailable.length} went unavailable, ${cameBack.length} came back`,\n );\n\n // ── Hours guard ──────────────────────────────────────────\n // Only log OOS events between 7am and 3pm Pacific.\n // The cron schedule enforces this too, but this is a safety net\n // in case of timezone edge cases or manual triggers.\n const pacificHour = parseInt(\n now.toLocaleString(\"en-US\", {\n hour: \"numeric\",\n hour12: false,\n timeZone: \"America/Los_Angeles\",\n }),\n );\n const withinHours = pacificHour >= 7 && pacificHour < 15;\n if (!withinHours) {\n console.log(\n `Outside tracking hours (Pacific hour: ${pacificHour}) — skipping OOS logging`,\n );\n await blob.setJSON(\"oos_prev_state\", currentState);\n console.log(\"State saved\");\n return;\n }\n\n // ── Auto-close all open intervals at the 2:45-3pm run (last run of the day) ──\n // This ensures nothing stays open past close, even if an item never came\n // back available — we treat 3pm as the end of the tracked window.\n if (pacificHour === 14) {\n const closeAllRes = await fetch(\n `${supabaseUrl}/rest/v1/bakery_oos_events?event_date=eq.${todayDate}&unavailable_until=is.null`,\n {\n method: \"PATCH\",\n headers: {\n ...sbHeaders(supabaseKey),\n \"Prefer\": \"return=representation\",\n },\n body: JSON.stringify({ unavailable_until: nowISO }),\n },\n );\n const closedAll = await closeAllRes.json();\n const closedAllCount = Array.isArray(closedAll) ? closedAll.length : 0;\n if (closedAllCount) {\n console.log(\n `End-of-window close: ${closedAllCount} interval(s) closed at ${nowISO}`,\n );\n }\n }\n\n // ── Write OOS open events to Supabase ───────────────────\n for (const { varId, locKey } of wentUnavailable) {\n const itemName = nameMap[varId] ?? varId;\n const res = await fetch(`${supabaseUrl}/rest/v1/bakery_oos_events`, {\n method: \"POST\",\n headers: sbHeaders(supabaseKey),\n body: JSON.stringify({\n item_name: itemName,\n loc_key: locKey,\n catalog_object_id: varId,\n event_date: todayDate,\n unavailable_from: nowISO,\n unavailable_until: null,\n }),\n });\n if (!res.ok) {\n console.error(\n `Failed to open OOS for ${itemName} @ ${locKey}:`,\n await res.text(),\n );\n } else console.log(`OOS opened: ${itemName} @ ${locKey}`);\n }\n\n // ── Close intervals for items that came back ─────────────\n for (const { varId, locKey } of cameBack) {\n const itemName = nameMap[varId] ?? varId;\n const openRes = await fetch(\n `${supabaseUrl}/rest/v1/bakery_oos_events` +\n `?catalog_object_id=eq.${varId}` +\n `&loc_key=eq.${locKey}` +\n `&event_date=eq.${todayDate}` +\n `&unavailable_until=is.null` +\n `&order=unavailable_from.desc` +\n `&limit=1`,\n {\n headers: {\n \"apikey\": supabaseKey,\n \"Authorization\": `Bearer ${supabaseKey}`,\n },\n },\n );\n const openRows = await openRes.json();\n if (openRows?.length) {\n await fetch(\n `${supabaseUrl}/rest/v1/bakery_oos_events?id=eq.${openRows[0].id}`,\n {\n method: \"PATCH\",\n headers: sbHeaders(supabaseKey),\n body: JSON.stringify({ unavailable_until: nowISO }),\n },\n );\n console.log(`OOS closed: ${itemName} @ ${locKey}`);\n }\n }\n\n // ── Persist current state to blob ────────────────────────\n await blob.setJSON(\"oos_prev_state\", currentState);\n console.log(\"State saved\");\n}\n\nfunction sbHeaders(key: string): Record {\n return {\n \"apikey\": key,\n \"Authorization\": `Bearer ${key}`,\n \"Content-Type\": \"application/json\",\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",1781880909797],"children",[],[35],"1c01ed4b-6d84-4d47-8df4-af12ae56b631",["D",1781623560955],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","defca694-ccf5-4758-bcce-553c2fec57c6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e8b94-8350-7137-bfb7-95f5eb27cd43","tursoName","1c01ed4b6d844d478df4af12ae56b631","tursoHostname","1c01ed4b6d844d478df4af12ae56b631-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789510270483],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_118":114},"org",{"_11":12,"_111":112,"_113":114,"_70":71,"_115":116,"_117":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Jacob Baggenstos","avatar","https://lh3.googleusercontent.com/a/ACg8ocL0CY5ZMYqYs2LNscTftgy6UEK29MTNuUySHjVafH4qiPm0Gs7I9g=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":153,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":154,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":155,"_98":156,"_100":157,"_102":53},[150],"files",[150],"counts",{"_139":77,"_140":141,"_142":77,"_31":143,"_144":145},[137],"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":138},[35],"pulls","branches",1,"forks",{"_146":148,"_149":77},"connections",{"_146":77,"_147":77},"count","unfilledCount",4,"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":151,"_18":152},[],[35],["D",1781623560955],["D",1789510270483],{"_11":12,"_118":114},{"_11":12,"_111":112,"_113":114,"_70":71,"_115":116,"_117":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_134":191,"_192":193,"_194":195,"_196":53,"_197":53,"_198":53,"_199":44,"_200":-5,"_201":-7,"_202":-7,"_203":77,"_204":53,"_205":53,"_206":-5,"_207":53,"_208":53,"_209":53,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":16,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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