[{"_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",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"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":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",6,"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","ae454bae-6997-11f1-bdec-1607ee4eb77e","name","fileType","interval","content","// Learn more: https://docs.val.town/vals/cron/\nexport default async function (interval: Interval) {\n console.log(interval);\n}\nimport { blob } from \"https://esm.town/v/std/blob@0.1.0\";\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 // ── 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}","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 // ── 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}","createdAt",["D",1781624428286],"branchVersion","branchId","9dcae4b9-08cc-4964-a164-6f0f30e90ef4","id","1c01ed4b-6d84-4d47-8df4-af12ae56b631","square-oos-tracker",["D",1781623560955],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","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",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jacobbaggenstos","handle","displayName","Jacob Baggenstos","avatar","https://lh3.googleusercontent.com/a/ACg8ocL0CY5ZMYqYs2LNscTftgy6UEK29MTNuUySHjVafH4qiPm0Gs7I9g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_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":65,"_66":67,"_68":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"7862419e-7c4e-46b0-b7ad-8b7ecfad7376","parentId","latest",["D",1781624428286],5,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":146,"_147":61},"connections",{"_144":61,"_145":61},"count","unfilledCount",4,"emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":149,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_150":151,"_27":152},["D",1781624428286],"children",[],[28],["D",1781623560955],["D",1789510270483],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_125":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":200,"_201":-5,"_202":-7,"_203":-7,"_204":61,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_162":163,"_164":165,"_166":88,"_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","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 · v6