[{"_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",{"_97":96,"_32":45,"_106":87,"_27":107,"_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":124,"_125":-5,"_126":-5,"_127":128},"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":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",8,"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","6b3cc846-4f02-11f1-ac30-ee650bb23af1","name","fileType","http","content","export default async function (req: Request): Promise {\n // --- Configuration ---\n const AIRTABLE_TOKEN = Deno.env.get(\"AIRTABLE_TOKEN\");\n const BASE_ID = \"appA3k5TJszw0hhPk\"; // ⚠️ Deine Base-ID\n const CONTENT_TABLE = \"tbld4T7iPTN6NvIRu\"; // ⚠️ Deine Content Table ID\n const SLOTS_TABLE = \"tblbI9SZEw9sbaNCq\"; // ⚠️ Deine Posting Slots Table ID\n \n const DAYS_TO_LOOK_AHEAD = 14;\n \n // --- Helper: Airtable API Call ---\n async function airtable(method: string, path: string, body?: any) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${path}`;\n const res = await fetch(url, {\n method,\n headers: {\n \"Authorization\": `Bearer ${AIRTABLE_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (!res.ok) {\n const error = await res.text();\n throw new Error(`Airtable error ${res.status}: ${error}`);\n }\n return res.json();\n }\n \n // --- 1. Fetch all Approved Content (no slot yet, not locked) ---\n const approvedFilter = encodeURIComponent(\n `AND({Status} = \"✅ Approved\", BLANK() = {Scheduled Date}, NOT({Scheduling Lock}))`\n );\n const approvedRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${approvedFilter}&sort[0][field]=Created&sort[0][direction]=asc&maxRecords=50`\n );\n const approvedRecords = approvedRes.records;\n \n if (approvedRecords.length === 0) {\n return Response.json({ message: \"No approved content to schedule\", scheduled: 0 });\n }\n \n // --- 2. Lock all selected records immediately (atomic reservation) ---\n for (const rec of approvedRecords) {\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${rec.id}`, {\n fields: {\n \"Scheduling Lock\": true,\n \"Scheduling Locked At\": new Date().toISOString(),\n },\n });\n } catch (e) {\n console.error(`Failed to lock ${rec.id}:`, e);\n }\n }\n \n // --- 3. Fetch all Posting Slots (Active only) ---\n const slotsFilter = encodeURIComponent(`{Active} = TRUE()`);\n const slotsRes = await airtable(\n \"GET\",\n `${SLOTS_TABLE}?filterByFormula=${slotsFilter}&maxRecords=200`\n );\n const allSlots = slotsRes.records;\n \n // --- 4. Fetch all currently Scheduled Content (from yesterday to future) ---\n const today = new Date();\n const yesterdayDate = new Date(today);\n yesterdayDate.setDate(today.getDate() - 1);\n const futureDate = new Date(today);\n futureDate.setDate(today.getDate() + DAYS_TO_LOOK_AHEAD + 1);\n const yesterdayStr = yesterdayDate.toISOString().split(\"T\")[0];\n const futureStr = futureDate.toISOString().split(\"T\")[0];\n \n const scheduledFilter = encodeURIComponent(\n `AND(OR({Status} = \"📅 Scheduled\", {Status} = \"🟢 Posted\"), IS_AFTER({Scheduled Date}, \"${yesterdayStr}\"), IS_BEFORE({Scheduled Date}, \"${futureStr}\"))`\n );\n const scheduledRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${scheduledFilter}&maxRecords=1000`\n );\n const scheduledRecords = scheduledRes.records;\n \n // --- 5. Build \"occupancy map\": BatchID|Date|SlotID|Type → count ---\n const occupancy: Record = {};\n \n for (const rec of scheduledRecords) {\n const batchId = (rec.fields.Batch as string[])?.[0];\n const slotId = (rec.fields[\"Scheduled Slot\"] as string[])?.[0];\n const date = rec.fields[\"Scheduled Date\"] as string;\n const type = rec.fields[\"Content-Typ\"] as string;\n \n if (batchId && slotId && date && type) {\n const key = `${batchId}|${date}|${slotId}|${type}`;\n occupancy[key] = (occupancy[key] || 0) + 1;\n }\n }\n \n // --- 6. For each approved record, find next free slot ---\n const results: Array<{ contentId: string; scheduled?: { date: string; slotId: string }; error?: string }> = [];\n \n for (const content of approvedRecords) {\n const contentBatchId = (content.fields.Batch as string[])?.[0];\n const contentType = content.fields[\"Content-Typ\"] as string;\n \n if (!contentBatchId || !contentType) {\n // Unlock and skip\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"Missing Batch or Content-Typ\" });\n continue;\n }\n \n // Get slots for this batch\n const batchSlots = allSlots\n .filter(s => (s.fields.Batch as string[])?.[0] === contentBatchId)\n .sort((a, b) => \n ((a.fields[\"Slot-Nummer\"] as number) || 0) - ((b.fields[\"Slot-Nummer\"] as number) || 0)\n );\n \n if (batchSlots.length === 0) {\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"No active slots for batch\" });\n continue;\n }\n \n // Try each day, each slot\n let scheduled = false;\n for (let dayOffset = 0; dayOffset < DAYS_TO_LOOK_AHEAD && !scheduled; dayOffset++) {\n const tryDate = new Date(today);\n tryDate.setDate(today.getDate() + dayOffset);\n const tryDateStr = tryDate.toISOString().split(\"T\")[0];\n \n for (const slot of batchSlots) {\n const slotId = slot.id;\n const capacityField = contentType === \"Trial Reel\" \n ? \"Trial Reels in Slot\" \n : \"Main Reels in Slot\";\n const capacity = (slot.fields[capacityField] as number) || 0;\n \n if (capacity === 0) continue;\n \n const key = `${contentBatchId}|${tryDateStr}|${slotId}|${contentType}`;\n const currentCount = occupancy[key] || 0;\n \n if (currentCount < capacity) {\n // Defensive Re-Check: query Airtable directly\n const recheckFilter = encodeURIComponent(\n `AND(ARRAYJOIN({Batch}) = \"${contentBatchId}\", IS_SAME({Scheduled Date}, \"${tryDateStr}\", \"day\"), ARRAYJOIN({Scheduled Slot}) = \"${slotId}\", {Content-Typ} = \"${contentType}\", OR({Status} = \"📅 Scheduled\", {Status} = \"🟢 Posted\"))`\n );\n \n try {\n const recheckRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${recheckFilter}&maxRecords=10`\n );\n \n if (recheckRes.records.length >= capacity) {\n // Already at capacity, update map and try next slot\n occupancy[key] = recheckRes.records.length;\n continue;\n }\n \n // Free slot confirmed – schedule\n occupancy[key] = recheckRes.records.length + 1;\n \n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: {\n \"Scheduled Date\": tryDateStr,\n \"Scheduled Slot\": [slotId],\n \"Status\": \"📅 Scheduled\",\n \"Scheduling Lock\": false,\n },\n });\n \n results.push({ \n contentId: content.id, \n scheduled: { date: tryDateStr, slotId } \n });\n scheduled = true;\n break;\n } catch (e) {\n results.push({ contentId: content.id, error: `Re-check or update failed: ${e.message}` });\n scheduled = true;\n break;\n }\n }\n }\n }\n \n if (!scheduled) {\n // Unlock if nothing was found\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"No free slot in next 14 days\" });\n }\n }\n \n // --- 7. Return summary ---\n const successCount = results.filter(r => r.scheduled).length;\n const errorCount = results.filter(r => r.error).length;\n \n return Response.json({\n message: `Scheduled ${successCount}, errors: ${errorCount}`,\n total: results.length,\n successCount,\n errorCount,\n results,\n });\n}","export default async function (req: Request): Promise {\n // --- Configuration ---\n const AIRTABLE_TOKEN = Deno.env.get(\"AIRTABLE_TOKEN\");\n const BASE_ID = \"appA3k5TJszw0hhPk\"; // ⚠️ Deine Base-ID\n const CONTENT_TABLE = \"tbld4T7iPTN6NvIRu\"; // ⚠️ Deine Content Table ID\n const SLOTS_TABLE = \"tblbI9SZEw9sbaNCq\"; // ⚠️ Deine Posting Slots Table ID\n \n const DAYS_TO_LOOK_AHEAD = 14;\n \n // --- Helper: Airtable API Call ---\n async function airtable(method: string, path: string, body?: any) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${path}`;\n const res = await fetch(url, {\n method,\n headers: {\n \"Authorization\": `Bearer ${AIRTABLE_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (!res.ok) {\n const error = await res.text();\n throw new Error(`Airtable error ${res.status}: ${error}`);\n }\n return res.json();\n }\n \n // --- 1. Fetch all Approved Content (no slot yet, not locked) ---\n const approvedFilter = encodeURIComponent(\n `AND({Status} = \"✅ Approved\", BLANK() = {Scheduled Date}, NOT({Scheduling Lock}))`\n );\n const approvedRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${approvedFilter}&sort[0][field]=Created&sort[0][direction]=asc&maxRecords=50`\n );\n const approvedRecords = approvedRes.records;\n \n if (approvedRecords.length === 0) {\n return Response.json({ message: \"No approved content to schedule\", scheduled: 0 });\n }\n \n // --- 2. Lock all selected records immediately (atomic reservation) ---\n for (const rec of approvedRecords) {\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${rec.id}`, {\n fields: {\n \"Scheduling Lock\": true,\n \"Scheduling Locked At\": new Date().toISOString(),\n },\n });\n } catch (e) {\n console.error(`Failed to lock ${rec.id}:`, e);\n }\n }\n \n // --- 3. Fetch all Posting Slots (Active only) ---\n const slotsFilter = encodeURIComponent(`{Active} = TRUE()`);\n const slotsRes = await airtable(\n \"GET\",\n `${SLOTS_TABLE}?filterByFormula=${slotsFilter}&maxRecords=200`\n );\n const allSlots = slotsRes.records;\n \n // --- 4. Fetch all currently Scheduled Content (from yesterday to future) ---\n const today = new Date();\n const yesterdayDate = new Date(today);\n yesterdayDate.setDate(today.getDate() - 1);\n const futureDate = new Date(today);\n futureDate.setDate(today.getDate() + DAYS_TO_LOOK_AHEAD + 1);\n const yesterdayStr = yesterdayDate.toISOString().split(\"T\")[0];\n const futureStr = futureDate.toISOString().split(\"T\")[0];\n \n const scheduledFilter = encodeURIComponent(\n `AND(OR({Status} = \"📅 Scheduled\", {Status} = \"🟢 Posted\"), IS_AFTER({Scheduled Date}, \"${yesterdayStr}\"), IS_BEFORE({Scheduled Date}, \"${futureStr}\"))`\n );\n const scheduledRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${scheduledFilter}&maxRecords=1000`\n );\n const scheduledRecords = scheduledRes.records;\n \n // --- 5. Build \"occupancy map\": BatchID|Date|SlotID|Type → count ---\n const occupancy: Record = {};\n \n for (const rec of scheduledRecords) {\n const batchId = (rec.fields.Batch as string[])?.[0];\n const slotId = (rec.fields[\"Scheduled Slot\"] as string[])?.[0];\n const date = rec.fields[\"Scheduled Date\"] as string;\n const type = rec.fields[\"Content-Typ\"] as string;\n \n if (batchId && slotId && date && type) {\n const key = `${batchId}|${date}|${slotId}|${type}`;\n occupancy[key] = (occupancy[key] || 0) + 1;\n }\n }\n \n // --- 6. For each approved record, find next free slot ---\n const results: Array<{ contentId: string; scheduled?: { date: string; slotId: string }; error?: string }> = [];\n \n for (const content of approvedRecords) {\n const contentBatchId = (content.fields.Batch as string[])?.[0];\n const contentType = content.fields[\"Content-Typ\"] as string;\n \n if (!contentBatchId || !contentType) {\n // Unlock and skip\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"Missing Batch or Content-Typ\" });\n continue;\n }\n \n // Get slots for this batch\n const batchSlots = allSlots\n .filter(s => (s.fields.Batch as string[])?.[0] === contentBatchId)\n .sort((a, b) => \n ((a.fields[\"Slot-Nummer\"] as number) || 0) - ((b.fields[\"Slot-Nummer\"] as number) || 0)\n );\n \n if (batchSlots.length === 0) {\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"No active slots for batch\" });\n continue;\n }\n \n // Try each day, each slot\n let scheduled = false;\n for (let dayOffset = 0; dayOffset < DAYS_TO_LOOK_AHEAD && !scheduled; dayOffset++) {\n const tryDate = new Date(today);\n tryDate.setDate(today.getDate() + dayOffset);\n const tryDateStr = tryDate.toISOString().split(\"T\")[0];\n \n for (const slot of batchSlots) {\n const slotId = slot.id;\n const capacityField = contentType === \"Trial Reel\" \n ? \"Trial Reels in Slot\" \n : \"Main Reels in Slot\";\n const capacity = (slot.fields[capacityField] as number) || 0;\n \n if (capacity === 0) continue;\n \n const key = `${contentBatchId}|${tryDateStr}|${slotId}|${contentType}`;\n const currentCount = occupancy[key] || 0;\n \n if (currentCount < capacity) {\n // Defensive Re-Check: query Airtable directly\n const recheckFilter = encodeURIComponent(\n `AND(ARRAYJOIN({Batch}) = \"${contentBatchId}\", IS_SAME({Scheduled Date}, \"${tryDateStr}\", \"day\"), ARRAYJOIN({Scheduled Slot}) = \"${slotId}\", {Content-Typ} = \"${contentType}\", OR({Status} = \"📅 Scheduled\", {Status} = \"🟢 Posted\"))`\n );\n \n try {\n const recheckRes = await airtable(\n \"GET\",\n `${CONTENT_TABLE}?filterByFormula=${recheckFilter}&maxRecords=10`\n );\n \n if (recheckRes.records.length >= capacity) {\n // Already at capacity, update map and try next slot\n occupancy[key] = recheckRes.records.length;\n continue;\n }\n \n // Free slot confirmed – schedule\n occupancy[key] = recheckRes.records.length + 1;\n \n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: {\n \"Scheduled Date\": tryDateStr,\n \"Scheduled Slot\": [slotId],\n \"Status\": \"📅 Scheduled\",\n \"Scheduling Lock\": false,\n },\n });\n \n results.push({ \n contentId: content.id, \n scheduled: { date: tryDateStr, slotId } \n });\n scheduled = true;\n break;\n } catch (e) {\n results.push({ contentId: content.id, error: `Re-check or update failed: ${e.message}` });\n scheduled = true;\n break;\n }\n }\n }\n }\n \n if (!scheduled) {\n // Unlock if nothing was found\n try {\n await airtable(\"PATCH\", `${CONTENT_TABLE}/${content.id}`, {\n fields: { \"Scheduling Lock\": false },\n });\n } catch (e) {}\n results.push({ contentId: content.id, error: \"No free slot in next 14 days\" });\n }\n }\n \n // --- 7. Return summary ---\n const successCount = results.filter(r => r.scheduled).length;\n const errorCount = results.filter(r => r.error).length;\n \n return Response.json({\n message: `Scheduled ${successCount}, errors: ${errorCount}`,\n total: results.length,\n successCount,\n errorCount,\n results,\n });\n}","createdAt",["D",1778704081295],"branchVersion","branchId","6b39452c-4f02-11f1-ac30-ee650bb23af1","id","6b38886c-4f02-11f1-ac30-ee650bb23af1","SCHEDULER",["D",1778700723258],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0f3c4642-b82f-4fcb-90be-f2764ffdf8cd","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e22d0-ba68-71ca-a744-f3d6ae0dd5ec","tursoName","6b38886c4f0211f1ac30ee650bb23af1","tursoHostname","6b38886c4f0211f1ac30ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789513858534],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","robinbehrens","handle","displayName","Robin Behrens","avatar","https://lh3.googleusercontent.com/a/ACg8ocIxG1-f848brPEIEectyL8ItKrNu5jbUgXiAxIicSyrvtG4wQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":154,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":155,"_81":156,"_83":157,"_85":25},"tree",[148],"files",[148],"counts",{"_137":60,"_138":139,"_140":60,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"3cc73480-4f0a-11f1-b613-ee650bb23af1","parentId","latest",["D",1778704081295],7,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":139,"_147":60},"connections",{"_145":60,"_146":60},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":149,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_150":151,"_27":152},["D",1778704081295],"children",[],[28],["D",1778700723258],["D",1789513858534],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_126":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":124,"_200":-5,"_201":-7,"_202":-7,"_203":60,"_204":25,"_205":25,"_206":-5,"_207":25,"_208":25,"_209":25,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":87,"_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","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Diff · v8