[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_91":-7,"_92":43,"_29":-7,"_93":-5,"_15":94,"_95":96,"_97":98,"_99":100,"_101":102,"_103":-5,"_104":-5,"_105":-5,"_106":38,"_107":108,"_109":38,"_110":-5,"_111":-5,"_112":113},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","jacobbaggenstos","name","square-oos-tracker","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":72,"_73":74,"_75":76,"_77":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","9dcae4b9-08cc-4964-a164-6f0f30e90ef4","createdAt",["D",1781623560961],"updatedAt",["D",1781880909797],"main","projectId","1c01ed4b-6d84-4d47-8df4-af12ae56b631","version",7,"forkedBranchId","forkedBranchVersion","lockfileKey","1781880909900-esm.town_v_jacobbaggenstos_square-oos-tracker@7-main","deletedAt",["D",1781623560955],"legacyEnvVars",false,"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,"_90":86},"org",{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Jacob Baggenstos","avatar","https://lh3.googleusercontent.com/a/ACg8ocL0CY5ZMYqYs2LNscTftgy6UEK29MTNuUySHjVafH4qiPm0Gs7I9g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_20":28,"_13":14,"_22":149,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":150,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":151,"_73":152,"_75":153,"_77":38},"tree",[144],"files",[144],"counts",{"_133":52,"_17":134,"_135":52,"_136":137,"_138":139},"contents",[114],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":115,"_13":116,"_117":118,"_119":-5,"_120":21,"_121":30,"_122":123,"_22":124,"_29":125,"_126":127,"_128":129,"_130":38,"_131":-5,"_92":132},"11385ef9-0d6e-491f-bacc-2edaac1fccdf","main.ts","fileId","ae454bae-6997-11f1-bdec-1607ee4eb77e","parentId","branchId","branchVersion","latest",true,["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","label",[116],"pulls",1,"forks","envVars",{"_140":142,"_143":52},"connections",{"_140":52,"_141":52},"count","unfilledCount",4,"emptyCount",{"_20":115,"_13":116,"_117":118,"_119":-5,"_120":21,"_121":30,"_122":123,"_22":145,"_29":125,"_126":127,"_128":129,"_130":38,"_131":-5,"_146":147,"_92":148},["D",1781880909797],"children",[],[116],["D",1781623560955],["D",1789510270483],{"_11":12,"_90":86},{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_111":187,"_188":189,"_190":191,"_192":38,"_193":38,"_194":38,"_195":123,"_196":-5,"_197":-7,"_198":-7,"_199":52,"_200":38,"_201":38,"_202":-5,"_203":38,"_204":38,"_205":38,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":26,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1