[{"_1":2,"_371":-5,"_372":-5},"loaderData",{"_3":4,"_92":93,"_301":302},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22,"_34":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","16f2931b3e0f3a1f0749f6d2640b9447dd6106a9","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":22,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":22,"_91":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":22,"_21":22,"_83":73,"_84":85,"_86":73,"_87":46,"_88":22,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_94":95,"_96":97,"_98":44,"_99":100,"_101":-7,"_102":103,"_149":150,"_278":279,"_280":281,"_290":291,"_165":292,"_295":-5,"_296":-5,"_297":22,"_298":22,"_299":300},"handle","sahar","name","law-student-tracker","branchName","path","oncall-selection.http.tsx","version","project",{"_104":105,"_96":97,"_106":107,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_148":22},"id","f758470a-6eda-11f0-a225-0224a6c84d84","createdAt",["D",1754054718011],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","692ed020-0d91-11f0-a027-a973a7805c27","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","9c7a30de-d50c-484d-8048-00c4d2857bea","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydjJ5emk0MWJLd3hWMW1iWHZSOVFGdnBiRjYifQ","org",{"_94":95,"_135":132,"_14":114},"avatar","branch",{"_101":138,"_96":44,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":97,"_147":95},84,"f758b6b8-6eda-11f0-a225-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[151,173,184,195,204,213,222,231,240,249,258,267],{"_104":152,"_96":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_106":162,"_101":163,"_164":165,"_166":167,"_168":22,"_169":-5,"_170":171,"_99":172},"5636ba54-f004-11f0-bb34-42dde27851f2","README.md","fileId","b6153ade-ef4d-11f0-9c60-42dde27851f2","parentId","branchId","branchVersion",75,"latest",true,["D",1768256186537],2,"fileType","file","content","# Law Student Tracker - Val.town Project\n\nAutomates attendance tracking and cold-call selection for both T&E and L&C classes.\n\n## Vals\n\n| File | Type | Purpose |\n|------|------|---------|\n| **T&E (Trusts & Estates)** | | |\n| `oncall-selection.http.tsx` | HTTP | Algorithmically selects 6 students for cold-calling |\n| `oncall-notify.cron.tsx` | Cron | Emails on-call list before class (3 PM) |\n| `te-report-prompt.cron.tsx` | Cron | Reminds Sarah to submit T&E report (6 PM) |\n| **L&C (Law & Capitalism)** | | |\n| `lc-oncall-selection.http.tsx` | HTTP | Looks up preset on-call from syllabus |\n| `lc-oncall-notify.cron.tsx` | Cron | Emails on-call list before class (8 AM) |\n| `lc-report-prompt.cron.tsx` | Cron | Reminds Sarah to submit L&C report (12 PM) |\n| **Shared** | | |\n| `post-class-report.http.tsx` | HTTP | Receives reports, updates tracking, triggers alerts |\n| `process-form-reports-api.http.tsx` | HTTP | Parses Google Form responses, calls post-class-report |\n| `process-form-reports-schedule.cron.tsx` | Cron | Triggers form processing (every 10 min) |\n| `main.http.tsx` | HTTP | Sheets connection test |\n| `utils.tsx` | Script | Shared utilities |\n\n## Environment Variables\n\nSet these in Val.town UI (Settings → Environment Variables):\n\n| Variable | Purpose |\n|----------|---------|\n| `GOOGLE_APPLICATION_CREDENTIALS` | Service account JSON (full string) |\n| `REPORT_API_KEY` | Secret key for report submissions |\n| `POST_CLASS_REPORT_URL` | URL for post-class-report.http.tsx |\n| `PROCESS_FORM_REPORTS_URL` | URL for process-form-reports-api.http.tsx |\n\n## Cron Schedules\n\nSet in Val.town UI for each cron val. Times are UTC:\n\n| Val | EST Time | UTC Cron |\n|-----|----------|----------|\n| **T&E** | | |\n| `oncall-notify` | 3 PM Mon/Wed | `0 20 * * 1,3` |\n| `te-report-prompt` | 6 PM Mon/Wed | `0 23 * * 1,3` |\n| **L&C** | | |\n| `lc-oncall-notify` | 8 AM Mon/Wed | `0 13 * * 1,3` |\n| `lc-report-prompt` | 12 PM Mon/Wed | `0 17 * * 1,3` |\n\n**Note:** Adjust for DST. These are EST (UTC-5). EDT (summer) is UTC-4.\n\n## Report Submission\n\nPOST to `post-class-report.http.tsx` endpoint with:\n\n```bash\ncurl -X POST \"https://sahar--{hash}.web.val.run\" \\\n -H \"Content-Type: application/json\" \\\n -H \"X-API-Key: YOUR_REPORT_API_KEY\" \\\n -d '{\n \"date\": \"2026-01-12\",\n \"class_type\": \"te\",\n \"cold_calls\": [\n {\"student_name\": \"Alice Adams\", \"result\": \"completed\", \"performance\": \"great\"},\n {\"student_name\": \"Bob Baker\", \"result\": \"absent\"},\n {\"student_name\": \"Carol Chen\", \"result\": \"refused\"}\n ],\n \"absences\": [\"David Davis\"]\n }'\n```\n\n**Fields:**\n- `date`: Class date (YYYY-MM-DD)\n- `class_type`: \"te\" or \"lc\"\n- `cold_calls`: Array of students called on\n - `result`: \"completed\" | \"absent\" | \"refused\"\n - `performance`: \"great\" | \"normal\" | \"bad\" (only for completed)\n- `absences`: Other absent students (not on on-call list)\n\n**Response:**\n```json\n{\n \"success\": true,\n \"date\": \"2026-01-12\",\n \"cold_calls_logged\": 3,\n \"absences_logged\": 1,\n \"unprepared_processed\": 0,\n \"alerts_sent\": []\n}\n```\n\n## Alerts\n\nAutomatic email alerts at thresholds:\n- **3 absences** → Contact dean + student\n- **5 concerning events** → Contact student\n\nConcerning events = absent + unprepared + refused + bad performance.\n\n## Sheet Structure\n\nUses Google Sheet with tabs:\n\n**Shared:**\n- **Form Responses 1** - Student self-reports (form-owned, read-only)\n- **Cold Call Log** - Audit trail of actual cold calls\n\n**T&E:**\n- **T&E Roster** - Student list + cumulative tracking (columns: student_name, last_name, pool, cold_call_count, last_called, absences, concerning_events)\n- **T&E On-Call** - Daily on-call selections (for idempotency)\n\n**L&C:**\n- **L&C Roster** - Student list + cumulative tracking (same columns, minus pool)\n- **L&C Assignments** - Preset syllabus schedule (columns: date, student_name)\n- **L&C On-Call** - Daily on-call cache (for idempotency)\n\n### L&C Setup\n\n1. Create `L&C Roster` tab with columns: student_name, last_name, cold_call_count, last_called, absences, concerning_events\n2. Create `L&C Assignments` tab with columns: date, student_name\n3. Populate `L&C Assignments` with syllabus data (one row per student per date)\n\nExample L&C Assignments:\n| date | student_name |\n|------|--------------|\n| 2026-01-13 | Alice Adams |\n| 2026-01-13 | Bob Baker |\n| 2026-01-15 | Carol Chen |\n","deleted","label","children",[],[153],{"_104":174,"_96":175,"_154":176,"_156":-5,"_157":139,"_158":177,"_160":161,"_106":178,"_101":179,"_164":180,"_166":181,"_168":22,"_169":-5,"_170":182,"_99":183},"2794d398-f004-11f0-8299-42dde27851f2","lc-oncall-notify.cron.tsx","2b409878-ef56-11f0-bf11-42dde27851f2",72,["D",1768256108301],3,"interval","/**\n * L&C On-Call Notification\n * Runs 8 AM EST Mon/Wed (1 PM UTC)\n * Fetches preset on-call students and emails the list to professor.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst LC_ONCALL_ENDPOINT = \"https://sahar--2b3b7afaef5611f0bec642dde27851f2.web.val.run\";\n\nexport default async function () {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n if (!notificationEmail) {\n throw new Error(\"NOTIFICATION_EMAIL env var not set. Configure in Val.town settings.\");\n }\n\n // Call the selection endpoint\n let result;\n try {\n const response = await fetch(LC_ONCALL_ENDPOINT);\n result = await response.json();\n } catch (fetchError) {\n await email({\n // Val.town free tier: emails go to account owner\n subject: \"[Law Tracker] L&C On-Call Selection Failed - Network Error\",\n text: `Failed to reach selection endpoint:\\n\\n${fetchError}\\n\\nEndpoint: ${LC_ONCALL_ENDPOINT}`,\n });\n throw fetchError;\n }\n\n if (!result.success) {\n await email({\n // Val.town free tier: emails go to account owner\n subject: \"[Law Tracker] L&C On-Call Selection Failed\",\n text: `Error fetching on-call students:\\n\\n${result.error}\\n\\nDate: ${result.date}`,\n });\n return;\n }\n\n if (result.selected.length === 0) {\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[L&C] No On-Call Students - ${result.date}`,\n text: `No students are assigned for on-call today in the L&C Assignments sheet.\\n\\nIs this a class day? Check the assignments if needed.`,\n });\n return;\n }\n\n // Format the student list\n const studentList = result.selected\n .map((name: string, i: number) => `${i + 1}. ${name}`)\n .join(\"\\n\");\n\n const emailBody = `Today's on-call students for Law & Capitalism:\n\n${studentList}\n\n${result.fromCache ? \"(Retrieved from cache)\" : \"(Fresh from syllabus assignments)\"}\n`;\n\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[L&C] On-Call List for ${result.date}`,\n text: emailBody,\n });\n\n console.log(`Sent L&C on-call notification for ${result.date}`);\n}\n",[],[175],{"_104":185,"_96":186,"_154":187,"_156":-5,"_157":139,"_158":188,"_160":161,"_106":189,"_101":190,"_164":191,"_166":192,"_168":22,"_169":-5,"_170":193,"_99":194},"8d16b98c-f006-11f0-836a-42dde27851f2","lc-oncall-selection.http.tsx","2b3b7afa-ef56-11f0-bec6-42dde27851f2",76,["D",1768257137597],5,"http","/**\n * L&C On-Call Selection\n *\n * Unlike T&E (algorithmic), L&C uses PRESET assignments from syllabus.\n * Just looks up today's date in the assignments tab and returns those students.\n *\n * Idempotent: Returns stored selection if already fetched for today.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { formatDate, getAuthClient, parseSheetDate, SHEET_ID, SHEET_TABS } from \"./utils.tsx\";\n\n// Local aliases for readability\nconst TABS = {\n ASSIGNMENTS: SHEET_TABS.LC_ASSIGNMENTS,\n ONCALL: SHEET_TABS.LC_ON_CALL,\n} as const;\n\n/**\n * Main selection logic - just lookup, no algorithm.\n * @param sheetId - Google Sheet ID\n * @param mockDate - Optional date to use instead of today (for testing)\n */\nasync function selectOnCall(\n sheetId: string,\n mockDate?: Date,\n): Promise<{\n success: boolean;\n date: string;\n selected: string[];\n fromCache: boolean;\n error?: string;\n}> {\n const effectiveDate = mockDate || new Date();\n const today = formatDate(effectiveDate);\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create On-Call cache tab\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check cache first (idempotency)\n await onCallSheet.loadHeaderRow();\n const cachedRows = await onCallSheet.getRows();\n const todayCache = cachedRows.filter((row) => row.get(\"date\") === today);\n\n if (todayCache.length > 0) {\n return {\n success: true,\n date: today,\n selected: todayCache.map((row) => row.get(\"student_name\")),\n fromCache: true,\n };\n }\n\n // Look up today's assignments\n const assignmentsSheet = doc.sheetsByTitle[TABS.ASSIGNMENTS];\n if (!assignmentsSheet) {\n return {\n success: false,\n date: today,\n selected: [],\n fromCache: false,\n error: `Tab \"${TABS.ASSIGNMENTS}\" not found. Create it with columns: date, student_name`,\n };\n }\n\n await assignmentsSheet.loadHeaderRow();\n const assignmentRows = await assignmentsSheet.getRows();\n\n // Find students assigned for today\n const todayStudents: string[] = [];\n for (const row of assignmentRows) {\n const assignDate = row.get(\"date\");\n const parsedDate = parseSheetDate(assignDate);\n if (parsedDate === today) {\n const name = row.get(\"student_name\");\n if (name) todayStudents.push(name);\n }\n }\n\n if (todayStudents.length === 0) {\n return {\n success: true,\n date: today,\n selected: [],\n fromCache: false,\n warning: `No students assigned for ${today} in L&C Assignments`,\n };\n }\n\n // Store in cache\n const now = new Date().toISOString();\n for (const name of todayStudents) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n selected: todayStudents,\n fromCache: false,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n selected: [],\n fromCache: false,\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n\n // Parse mockDate for testing (e.g., ?mockDate=2026-01-12)\n // Allows tests to run on any day by pretending it's a specific date\n let mockDate: Date | undefined;\n const mockDateParam = url.searchParams.get(\"mockDate\");\n if (mockDateParam) {\n const parsed = new Date(mockDateParam);\n if (!isNaN(parsed.getTime())) {\n mockDate = parsed;\n }\n }\n\n const result = await selectOnCall(sheetId, mockDate);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",[],[186],{"_104":196,"_96":197,"_154":198,"_156":-5,"_157":139,"_158":199,"_160":161,"_106":200,"_101":179,"_164":180,"_166":201,"_168":22,"_169":-5,"_170":202,"_99":203},"8d3514b8-f006-11f0-82df-42dde27851f2","lc-report-prompt.cron.tsx","e4ab0ea2-ef4b-11f0-b248-42dde27851f2",82,["D",1768257137796],"/**\n * Law & Capitalism Post-Class Report Prompt\n * Runs 12 PM EST Mon/Wed (5 PM UTC)\n * Reminds professor to submit post-class report.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\nimport { formatDate } from \"./utils.tsx\";\n\nexport default async function() {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n if (!notificationEmail) {\n throw new Error(\"NOTIFICATION_EMAIL env var not set. Configure in Val.town settings.\");\n }\n\n const today = formatDate(new Date());\n\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[L&C] Post-Class Report - ${today}`,\n text: `Hi Sarah,\n\nTime to submit your post-class report for Law & Capitalism.\n\nPlease note:\n- Who was absent\n- How the on-call students performed (great/normal/bad)\n- Any students who refused when called\n\nReply to this email or use the reporting form.\n\nThanks!\n`,\n });\n\n console.log(`Sent L&C report prompt for ${today}`);\n}\n",[],[197],{"_104":205,"_96":206,"_154":207,"_156":-5,"_157":139,"_158":208,"_160":161,"_106":209,"_101":190,"_164":191,"_166":210,"_168":22,"_169":-5,"_170":211,"_99":212},"8d266b3e-f006-11f0-82df-42dde27851f2","main.http.tsx","c49a6e2c-ef47-11f0-9984-42dde27851f2",80,["D",1768257137698],"/**\n * Google Sheets Connection Test\n *\n * Tests that we can read from a Google Sheet using the service account.\n * Useful for verifying credentials are configured correctly.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { getAuthClient, SHEET_ID } from \"./utils.tsx\";\n\n/**\n * Reads the first sheet and returns first few rows as a test.\n */\nasync function testSheetRead(sheetId: string): Promise<{\n success: boolean;\n title?: string;\n sheetName?: string;\n rowCount?: number;\n headers?: string[];\n sample?: Record[];\n error?: string;\n}> {\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n\n await doc.loadInfo();\n\n const sheet = doc.sheetsByIndex[0];\n await sheet.loadHeaderRow();\n const rows = await sheet.getRows({ limit: 5 });\n\n return {\n success: true,\n title: doc.title,\n sheetName: sheet.title,\n rowCount: sheet.rowCount,\n headers: sheet.headerValues,\n sample: rows.map((row) => row.toObject()),\n };\n } catch (error) {\n return {\n success: false,\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n// HTTP endpoint for testing\nexport default async function (req: Request): Promise {\n // Allow overriding sheet ID via query param for testing\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n\n const result = await testSheetRead(sheetId);\n\n return Response.json(result, {\n status: result.success ? 200 : 500,\n });\n}\n",[],[206],{"_104":214,"_96":215,"_154":216,"_156":-5,"_157":139,"_158":217,"_160":161,"_106":218,"_101":179,"_164":180,"_166":219,"_168":22,"_169":-5,"_170":220,"_99":221},"e0309382-f000-11f0-a8c0-42dde27851f2","oncall-notify.cron.tsx","e4ba617c-ef4b-11f0-be8e-42dde27851f2",67,["D",1768254699971],"/**\n * T&E On-Call Notification\n * Runs 3 PM EST Mon/Wed (8 PM UTC)\n * Selects on-call students and emails the list to professor.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\n\n// Import the selection function from our HTTP val\n// Val.town allows importing from other vals in the same project\nconst ONCALL_ENDPOINT = \"https://sahar--78f39bfeef4911f0a9a742dde27851f2.web.val.run\";\n\nexport default async function() {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n if (!notificationEmail) {\n throw new Error(\"NOTIFICATION_EMAIL env var not set. Configure in Val.town settings.\");\n }\n\n // Call the oncall-selection endpoint\n let result;\n try {\n const response = await fetch(ONCALL_ENDPOINT);\n result = await response.json();\n } catch (fetchError) {\n await email({\n // Val.town free tier: emails go to account owner\n subject: \"[Law Tracker] On-Call Selection Failed - Network Error\",\n text: `Failed to reach selection endpoint:\\n\\n${fetchError}\\n\\nEndpoint: ${ONCALL_ENDPOINT}`,\n });\n throw fetchError;\n }\n\n if (!result.success) {\n // Send error notification\n await email({\n // Val.town free tier: emails go to account owner\n subject: \"[Law Tracker] On-Call Selection Failed\",\n text: `Error selecting on-call students:\\n\\n${result.error}\\n\\nDate: ${result.date}`,\n });\n return;\n }\n\n // Format the student list\n const studentList = result.selected\n .map((name: string, i: number) => `${i + 1}. ${name}`)\n .join(\"\\n\");\n\n const emailBody = `Today's on-call students for T&E:\n\n${studentList}\n\nPool: ${result.pool === \"mon\" ? \"Monday (A-M)\" : \"Wednesday (N-Z)\"}\n${result.excluded.length > 0 ? `\\nExcluded (same-day report): ${result.excluded.join(\", \")}` : \"\"}\n`;\n\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[T&E] On-Call List for ${result.date}`,\n text: emailBody,\n });\n\n console.log(`Sent on-call notification for ${result.date}`);\n}\n",[],[215],{"_104":223,"_96":100,"_154":224,"_156":-5,"_157":139,"_158":225,"_160":161,"_106":226,"_101":227,"_164":191,"_166":228,"_168":22,"_169":-5,"_170":229,"_99":230},"8d190d72-f006-11f0-acd7-42dde27851f2","78f39bfe-ef49-11f0-a9a7-42dde27851f2",77,["D",1768257137599],8,"/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { formatDate, getAuthClient, parseSheetDate, SHEET_ID, SHEET_TABS } from \"./utils.tsx\";\n\n// Local aliases for readability\nconst TABS = {\n ROSTER: SHEET_TABS.TE_ROSTER,\n SELF_REPORTS: SHEET_TABS.STUDENT_SELF_REPORTS,\n ONCALL: SHEET_TABS.TE_ON_CALL,\n COLD_CALL_LOG: SHEET_TABS.COLD_CALL_LOG,\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Gets day of week pool. Returns \"mon\" or \"wed\", or null if neither.\n * @param date - Optional date to check (defaults to today)\n */\nfunction getDayPool(date: Date = new Date()): \"mon\" | \"wed\" | null {\n const day = date.getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool (A-M = mon, N-Z = wed).\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n }\n }\n\n return { warnings };\n}\n\n/**\n * Main selection logic.\n * @param sheetId - Google Sheet ID\n * @param forceRecompute - If true, recompute even if cached\n * @param mockDate - Optional date to use instead of today (for testing)\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n mockDate?: Date,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const effectiveDate = mockDate || new Date();\n const today = formatDate(effectiveDate);\n const pool = getDayPool(effectiveDate);\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Parse mockDate for testing (e.g., ?mockDate=2026-01-12)\n // Allows tests to run on any day by pretending it's a specific date\n let mockDate: Date | undefined;\n const mockDateParam = url.searchParams.get(\"mockDate\");\n if (mockDateParam) {\n const parsed = new Date(mockDateParam);\n if (!isNaN(parsed.getTime())) {\n mockDate = parsed;\n }\n }\n\n const result = await selectOnCall(sheetId, forceRecompute, mockDate);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",[],[100],{"_104":232,"_96":233,"_154":234,"_156":-5,"_157":139,"_158":138,"_160":161,"_106":235,"_101":236,"_164":191,"_166":237,"_168":22,"_169":-5,"_170":238,"_99":239},"b8cdf29c-f007-11f0-b219-42dde27851f2","post-class-report.http.tsx","53e764dc-ef4c-11f0-9c60-42dde27851f2",["D",1768257640434],13,"/**\n * Post-Class Report Endpoint\n * Receives Sarah's post-class report, updates tracking, triggers alerts.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport {\n type ColdCallEntry,\n getAuthClient,\n isConcerningEvent,\n parseSheetDate,\n type ReportPayload,\n SHEET_ID,\n SHEET_TABS,\n} from \"./utils.tsx\";\n\n// Local aliases for readability\nconst TABS = {\n TE_ROSTER: SHEET_TABS.TE_ROSTER,\n LC_ROSTER: SHEET_TABS.LC_ROSTER,\n COLD_CALL_LOG: SHEET_TABS.COLD_CALL_LOG,\n SELF_REPORTS: SHEET_TABS.STUDENT_SELF_REPORTS,\n} as const;\n\n// Alert thresholds\nconst ABSENCE_THRESHOLD = 3;\nconst CONCERNING_THRESHOLD = 5;\n\n/**\n * Fetches concerning event history for a student from Cold Call Log.\n * Returns formatted strings like \"2026-01-13: Absent (bad)\"\n */\nasync function getStudentHistory(\n logSheet: { getRows: () => Promise string }>> },\n studentName: string,\n includeCompleted = false,\n): Promise {\n const rows = await logSheet.getRows();\n const history: string[] = [];\n\n for (const row of rows) {\n if (row.get(\"student_name\") !== studentName) continue;\n\n const date = row.get(\"date\");\n const result = row.get(\"result\");\n const performance = row.get(\"performance\");\n\n // Only include concerning events unless includeCompleted\n const isConcerning = isConcerningEvent(\n result as ColdCallEntry[\"result\"],\n performance as ColdCallEntry[\"performance\"],\n );\n\n if (isConcerning || includeCompleted) {\n let entry = `${date}: ${result}`;\n if (performance && performance !== \"normal\") {\n entry += ` (${performance})`;\n }\n history.push(entry);\n }\n }\n\n return history;\n}\n\nasync function sendAlert(\n to: string,\n student: string,\n alertType: \"absences\" | \"concerning\",\n count: number,\n history: string[],\n) {\n const subject = alertType === \"absences\"\n ? `[ALERT] ${student} - ${count} absences`\n : `[ALERT] ${student} - ${count} concerning events`;\n\n const action = alertType === \"absences\"\n ? \"Contact dean + student per policy.\"\n : \"Contact student.\";\n\n const alertLabel = alertType === \"concerning\" ? \"concerning events\" : \"absences\";\n const body = `${student} has reached ${count} ${alertLabel}.\n\nHistory:\n${history.map((h) => `- ${h}`).join(\"\\n\")}\n\nAction needed: ${action}\n`;\n\n // Val.town free tier: emails go to account owner (filter in Gmail)\n await email({ subject, text: body });\n}\n\n/**\n * Check if threshold is reached and send alert if so.\n * Returns true if alert was sent.\n */\nasync function checkAndSendThresholdAlert(params: {\n studentName: string;\n alertType: \"absences\" | \"concerning\";\n newCount: number;\n threshold: number;\n notificationEmail: string | undefined;\n alerts: string[];\n logSheet: { getRows: () => Promise string }>> };\n extraHistoryItem?: string; // Optional extra item to add to history\n}): Promise {\n const { studentName, alertType, newCount, threshold, notificationEmail, alerts, logSheet, extraHistoryItem } = params;\n\n if (newCount !== threshold || !notificationEmail) {\n return false;\n }\n\n alerts.push(`${studentName}: ${threshold} ${alertType}`);\n\n let history = await getStudentHistory(logSheet, studentName);\n\n // Filter to absences only for absence alerts\n if (alertType === \"absences\") {\n history = history.filter((h) => h.includes(\"absent\"));\n }\n\n // Add extra item if provided (e.g., \"Absent (not on call list)\")\n if (extraHistoryItem) {\n history.push(extraHistoryItem);\n }\n\n await sendAlert(notificationEmail, studentName, alertType, newCount, history);\n return true;\n}\n\nexport default async function (req: Request): Promise {\n // Auth check\n const apiKey = Deno.env.get(\"REPORT_API_KEY\");\n const reqKey = req.headers.get(\"X-API-Key\");\n if (!apiKey || reqKey !== apiKey) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n\n let payload: ReportPayload;\n try {\n payload = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON\" }, { status: 400 });\n }\n\n // Validate payload\n if (!payload.date || !payload.class_type || !payload.cold_calls) {\n return Response.json({ error: \"Missing required fields\" }, { status: 400 });\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(SHEET_ID, auth);\n await doc.loadInfo();\n\n // Get or create Cold Call Log\n let logSheet = doc.sheetsByTitle[TABS.COLD_CALL_LOG];\n if (!logSheet) {\n logSheet = await doc.addSheet({\n title: TABS.COLD_CALL_LOG,\n headerValues: [\"date\", \"student_name\", \"result\", \"performance\"],\n });\n }\n\n // Get roster based on class type\n const rosterTabName = payload.class_type === \"lc\" ? TABS.LC_ROSTER : TABS.TE_ROSTER;\n const rosterSheet = doc.sheetsByTitle[rosterTabName];\n if (!rosterSheet) {\n return Response.json({ error: `Roster not found: ${rosterTabName}` }, { status: 500 });\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Create roster lookup\n const rosterByName = new Map();\n for (const row of rosterRows) {\n const name = row.get(\"student_name\");\n if (name && !rosterByName.has(name)) {\n rosterByName.set(name, row);\n }\n }\n\n const alerts: string[] = [];\n const processedUnprepared = new Set();\n\n // Process unprepared self-reports for this date\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n for (const row of selfReportRows) {\n const reportDate = row.get(\"Date of class you'll be absent, late-arriving/early-departing, or unprepared\");\n const reportType = row.get(\"Will you be absent, unprepared, or late/early?\") || \"\";\n const studentName = row.get(\"Your name\");\n\n if (!reportDate || !studentName) continue;\n\n // Check if this is for today's date and is \"unprepared\"\n const reportDateStr = parseSheetDate(reportDate);\n if (!reportDateStr) continue; // Skip unparseable dates\n\n if (reportDateStr === payload.date && reportType.toLowerCase().includes(\"unprepared\")) {\n // Find student in roster (case-insensitive match)\n const normalizedName = studentName.toLowerCase().trim();\n\n for (const [rosterName, rosterRow] of rosterByName) {\n if (rosterName.toLowerCase().trim() === normalizedName && !processedUnprepared.has(rosterName)) {\n processedUnprepared.add(rosterName);\n\n // Log to Cold Call Log for history tracking\n await logSheet.addRow({\n date: payload.date,\n student_name: rosterName,\n result: \"unprepared\",\n performance: \"self-reported\",\n });\n\n const prevConcerning = parseInt(rosterRow.get(\"concerning_events\") || \"0\", 10);\n const newConcerning = prevConcerning + 1;\n rosterRow.set(\"concerning_events\", String(newConcerning));\n\n await checkAndSendThresholdAlert({\n studentName: rosterName,\n alertType: \"concerning\",\n newCount: newConcerning,\n threshold: CONCERNING_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n });\n\n await rosterRow.save();\n break;\n }\n }\n }\n }\n }\n\n // Process cold calls\n for (const call of payload.cold_calls) {\n // Update roster\n const rosterRow = rosterByName.get(call.student_name);\n if (!rosterRow) {\n console.warn(`Student \"${call.student_name}\" not found in roster - skipping`);\n continue; // Skip unknown students entirely\n }\n\n // Add to Cold Call Log\n await logSheet.addRow({\n date: payload.date,\n student_name: call.student_name,\n result: call.result,\n performance: call.performance || \"\",\n });\n\n // Update cold call count\n const prevCount = parseInt(rosterRow.get(\"cold_call_count\") || \"0\", 10);\n rosterRow.set(\"cold_call_count\", String(prevCount + 1));\n rosterRow.set(\"last_called\", payload.date);\n\n // Check if concerning event - but skip if already counted as unprepared\n const alreadyCountedAsUnprepared = processedUnprepared.has(call.student_name);\n if (isConcerningEvent(call.result, call.performance) && !alreadyCountedAsUnprepared) {\n const prevConcerning = parseInt(rosterRow.get(\"concerning_events\") || \"0\", 10);\n const newConcerning = prevConcerning + 1;\n rosterRow.set(\"concerning_events\", String(newConcerning));\n\n await checkAndSendThresholdAlert({\n studentName: call.student_name,\n alertType: \"concerning\",\n newCount: newConcerning,\n threshold: CONCERNING_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n });\n }\n\n // Update absences if they were absent when called\n if (call.result === \"absent\") {\n const prevAbsences = parseInt(rosterRow.get(\"absences\") || \"0\", 10);\n const newAbsences = prevAbsences + 1;\n rosterRow.set(\"absences\", String(newAbsences));\n\n await checkAndSendThresholdAlert({\n studentName: call.student_name,\n alertType: \"absences\",\n newCount: newAbsences,\n threshold: ABSENCE_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n });\n }\n\n await rosterRow.save();\n }\n\n // Process general absences (students not on on-call list who were absent)\n for (const absentName of payload.absences || []) {\n const rosterRow = rosterByName.get(absentName);\n if (rosterRow) {\n // Log to Cold Call Log for history tracking\n await logSheet.addRow({\n date: payload.date,\n student_name: absentName,\n result: \"absent\",\n performance: \"not-on-call\",\n });\n\n const prevAbsences = parseInt(rosterRow.get(\"absences\") || \"0\", 10);\n const newAbsences = prevAbsences + 1;\n rosterRow.set(\"absences\", String(newAbsences));\n\n const prevConcerning = parseInt(rosterRow.get(\"concerning_events\") || \"0\", 10);\n const newConcerning = prevConcerning + 1;\n rosterRow.set(\"concerning_events\", String(newConcerning));\n\n await checkAndSendThresholdAlert({\n studentName: absentName,\n alertType: \"absences\",\n newCount: newAbsences,\n threshold: ABSENCE_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n });\n\n await checkAndSendThresholdAlert({\n studentName: absentName,\n alertType: \"concerning\",\n newCount: newConcerning,\n threshold: CONCERNING_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n });\n\n await rosterRow.save();\n }\n }\n\n return Response.json({\n success: true,\n date: payload.date,\n cold_calls_logged: payload.cold_calls.length,\n absences_logged: (payload.absences || []).length,\n unprepared_processed: processedUnprepared.size,\n alerts_sent: alerts,\n });\n } catch (error) {\n return Response.json(\n { error: error instanceof Error ? error.message : String(error) },\n { status: 500 },\n );\n }\n}\n",[],[233],{"_104":241,"_96":242,"_154":243,"_156":-5,"_157":139,"_158":244,"_160":161,"_106":245,"_101":179,"_164":191,"_166":246,"_168":22,"_169":-5,"_170":247,"_99":248},"8d2c664c-f006-11f0-beb5-42dde27851f2","process-form-reports-api.http.tsx","f8380de8-efe2-11f0-8ae6-42dde27851f2",81,["D",1768257137702],"/**\n * Process Form Reports (HTTP Endpoint)\n *\n * Reads Sarah's post-class report submissions from \"Form Responses\" sheet tab,\n * matches student names against rosters, and POSTs to post-class-report endpoint.\n *\n * Called by: process-form-reports-schedule.cron.tsx (every 10 min)\n * Can also be called directly for testing: GET or POST\n *\n * Form columns (expected):\n * A: Timestamp\n * B: Class (\"T&E\" or \"Law & Capitalism\")\n * C: Date\n * D: Class cancelled (Yes/No) - if Yes, logs cancellation and skips student data\n * E: Completed (great) - comma-separated names\n * F: Completed (normal) - comma-separated names\n * G: Completed (bad) - comma-separated names\n * H: Absent when called - comma-separated names\n * I: Refused when called - comma-separated names\n * J: Other absences - comma-separated names\n * K: Processed timestamp (we write this)\n *\n * Edge cases handled:\n * - Class cancelled: Logs to \"Cancelled Classes\" tab, no student data recorded\n * - Name typos: Fuzzy matching (Levenshtein distance <= 2), unmatched go to Pending Review\n * - Student adds/drops: Sarah edits roster directly in Google Sheets\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport {\n type ColdCallEntry,\n findMatchingName,\n getAuthClient,\n type NameMatch,\n parseClassType,\n parseNameList,\n parseSheetDate,\n type ReportPayload,\n SHEET_ID,\n SHEET_TABS,\n} from \"./utils.tsx\";\n\n// POST endpoint for reports - MUST be set in Val.town env vars\nfunction getPostClassReportEndpoint(): string {\n const url = Deno.env.get(\"POST_CLASS_REPORT_URL\");\n if (!url) {\n throw new Error(\n \"POST_CLASS_REPORT_URL env var not set. Configure in Val.town settings.\"\n );\n }\n return url;\n}\n\n// Local aliases for readability\nconst TABS = {\n FORM_RESPONSES: SHEET_TABS.SARAH_CLASS_REPORTS,\n TE_ROSTER: SHEET_TABS.TE_ROSTER,\n LC_ROSTER: SHEET_TABS.LC_ROSTER,\n PENDING_REVIEW: SHEET_TABS.PENDING_REVIEW,\n CANCELLED_CLASSES: SHEET_TABS.CANCELLED_CLASSES,\n} as const;\n\n// Form column headers (adjust if Sarah's form uses different names)\nconst FORM_COLUMNS = {\n TIMESTAMP: \"Timestamp\",\n CLASS: \"Class\",\n DATE: \"Date\",\n CLASS_CANCELLED: \"Class cancelled\", // Yes/No - if Yes, skip student data processing\n COMPLETED_GREAT: \"Completed (great)\",\n COMPLETED_NORMAL: \"Completed (normal)\",\n COMPLETED_BAD: \"Completed (bad)\",\n ABSENT_WHEN_CALLED: \"Absent when called\",\n REFUSED_WHEN_CALLED: \"Refused when called\",\n OTHER_ABSENCES: \"Other absences\",\n PROCESSED: \"Processed\", // We add this column\n} as const;\n\ninterface UnmatchedName {\n inputName: string;\n field: string;\n closestCandidate?: string;\n closestDistance?: number;\n}\n\n/**\n * Get or create the Pending Review sheet tab for unmatched names.\n */\nasync function getOrCreatePendingReviewSheet(doc: GoogleSpreadsheet) {\n let sheet = doc.sheetsByTitle[TABS.PENDING_REVIEW];\n if (!sheet) {\n sheet = await doc.addSheet({\n title: TABS.PENDING_REVIEW,\n headerValues: [\n \"timestamp\",\n \"class\",\n \"date\",\n \"input_name\",\n \"field\",\n \"closest_match\",\n \"distance\",\n \"resolved\",\n ],\n });\n } else {\n await sheet.loadHeaderRow();\n }\n return sheet;\n}\n\n/**\n * Get or create the Cancelled Classes sheet tab for logging cancelled dates.\n */\nasync function getOrCreateCancelledClassesSheet(doc: GoogleSpreadsheet) {\n let sheet = doc.sheetsByTitle[TABS.CANCELLED_CLASSES];\n if (!sheet) {\n sheet = await doc.addSheet({\n title: TABS.CANCELLED_CLASSES,\n headerValues: [\"timestamp\", \"class\", \"date\", \"reported_by\"],\n });\n } else {\n await sheet.loadHeaderRow();\n }\n return sheet;\n}\n\n/**\n * Check if \"Class cancelled\" field indicates cancellation.\n * Handles \"Yes\", \"yes\", \"Y\", \"y\", checkbox true, etc.\n */\nfunction isClassCancelled(value: string): boolean {\n if (!value) return false;\n const lower = value.toLowerCase().trim();\n return lower === \"yes\" || lower === \"y\" || lower === \"true\" || lower === \"1\";\n}\n\n/**\n * Process names from a form field, matching against roster.\n * Returns matched names and unmatched entries.\n */\nfunction processNameField(\n rawValue: string,\n rosterNames: string[],\n fieldName: string,\n): { matched: string[]; unmatched: UnmatchedName[] } {\n const names = parseNameList(rawValue);\n const matched: string[] = [];\n const unmatched: UnmatchedName[] = [];\n\n for (const name of names) {\n const result: NameMatch = findMatchingName(name, rosterNames);\n if (result.matched) {\n matched.push(result.rosterName);\n } else {\n unmatched.push({\n inputName: name,\n field: fieldName,\n closestCandidate: result.closestCandidate,\n closestDistance: result.closestDistance,\n });\n }\n }\n\n return { matched, unmatched };\n}\n\n/**\n * Send email notification about unmatched names.\n */\nasync function notifyUnmatchedNames(\n notificationEmail: string,\n classType: string,\n date: string,\n unmatched: UnmatchedName[],\n) {\n const details = unmatched\n .map((u) => {\n let line = `- \"${u.inputName}\" (from ${u.field})`;\n if (u.closestCandidate) {\n line +=\n ` - closest match: \"${u.closestCandidate}\" (distance: ${u.closestDistance})`;\n }\n return line;\n })\n .join(\"\\n\");\n\n // Val.town free tier: emails go to account owner (filter in Gmail)\n await email({\n subject: `[Law Tracker] Unmatched Names - ${classType} ${date}`,\n text:\n `The following names from your post-class report could not be matched to the roster:\n\n${details}\n\nPlease check spelling and update the \"Pending Review\" sheet tab to resolve.\n\nThese students' data was NOT recorded. You may need to submit a correction.\n`,\n });\n}\n\n/**\n * Write unmatched names to Pending Review sheet for later resolution.\n */\nasync function writeToPendingReview(\n sheet: Awaited>,\n classType: string,\n date: string,\n unmatched: UnmatchedName[],\n) {\n const timestamp = new Date().toISOString();\n\n for (const u of unmatched) {\n await sheet.addRow({\n timestamp,\n class: classType,\n date,\n input_name: u.inputName,\n field: u.field,\n closest_match: u.closestCandidate || \"\",\n distance: u.closestDistance?.toString() || \"\",\n resolved: \"\",\n });\n }\n}\n\nexport default async function (_req: Request): Promise {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n const apiKey = Deno.env.get(\"REPORT_API_KEY\");\n\n if (!apiKey) {\n return Response.json(\n { error: \"REPORT_API_KEY env var not set. Configure in Val.town settings.\" },\n { status: 500 }\n );\n }\n\n // Fail fast if POST_CLASS_REPORT_URL not configured\n let postClassReportEndpoint: string;\n try {\n postClassReportEndpoint = getPostClassReportEndpoint();\n } catch (error) {\n return Response.json(\n { error: error instanceof Error ? error.message : String(error) },\n { status: 500 }\n );\n }\n\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(SHEET_ID, auth);\n await doc.loadInfo();\n\n // Get Form Responses sheet\n const formSheet = doc.sheetsByTitle[TABS.FORM_RESPONSES];\n if (!formSheet) {\n console.log(\"No Form Responses sheet found. Nothing to process.\");\n return Response.json({ processed: 0, message: \"No Form Responses sheet\" });\n }\n\n await formSheet.loadHeaderRow();\n const formRows = await formSheet.getRows();\n\n // Get both rosters\n const teRosterSheet = doc.sheetsByTitle[TABS.TE_ROSTER];\n const lcRosterSheet = doc.sheetsByTitle[TABS.LC_ROSTER];\n\n const teRosterNames: string[] = [];\n const lcRosterNames: string[] = [];\n\n if (teRosterSheet) {\n await teRosterSheet.loadHeaderRow();\n const teRows = await teRosterSheet.getRows();\n for (const row of teRows) {\n const name = row.get(\"student_name\");\n if (name) teRosterNames.push(name);\n }\n }\n\n if (lcRosterSheet) {\n await lcRosterSheet.loadHeaderRow();\n const lcRows = await lcRosterSheet.getRows();\n for (const row of lcRows) {\n const name = row.get(\"student_name\");\n if (name) lcRosterNames.push(name);\n }\n }\n\n // Lazy-load pending review sheet only if needed\n let pendingReviewSheet:\n | Awaited>\n | null = null;\n\n let processedCount = 0;\n const errors: string[] = [];\n\n for (const row of formRows) {\n // Skip already processed rows\n const processedTimestamp = row.get(FORM_COLUMNS.PROCESSED);\n if (processedTimestamp) {\n continue;\n }\n\n const classRaw = row.get(FORM_COLUMNS.CLASS);\n const dateRaw = row.get(FORM_COLUMNS.DATE);\n\n const classType = parseClassType(classRaw);\n const date = parseSheetDate(dateRaw);\n\n if (!classType) {\n errors.push(`Row skipped: unknown class \"${classRaw}\"`);\n continue;\n }\n\n if (!date) {\n errors.push(`Row skipped: unparseable date \"${dateRaw}\"`);\n continue;\n }\n\n // Check if class was cancelled - if so, log it and skip student data processing\n const cancelledRaw = row.get(FORM_COLUMNS.CLASS_CANCELLED) || \"\";\n if (isClassCancelled(cancelledRaw)) {\n // Log to Cancelled Classes sheet\n const cancelledSheet = await getOrCreateCancelledClassesSheet(doc);\n await cancelledSheet.addRow({\n timestamp: new Date().toISOString(),\n class: classRaw,\n date: date,\n reported_by: \"Sarah (form)\",\n });\n\n console.log(\n `Class cancelled: ${classRaw} on ${date} - no student data recorded`,\n );\n\n // Mark as processed so we don't re-process\n row.set(FORM_COLUMNS.PROCESSED, new Date().toISOString());\n await row.save();\n processedCount++;\n continue; // Skip all student data processing\n }\n\n // Select appropriate roster\n const rosterNames = classType === \"te\" ? teRosterNames : lcRosterNames;\n\n if (rosterNames.length === 0) {\n errors.push(`Row skipped: no roster found for ${classType}`);\n continue;\n }\n\n // Process each field\n const allUnmatched: UnmatchedName[] = [];\n const coldCalls: ColdCallEntry[] = [];\n const absences: string[] = [];\n\n // Completed (great)\n const greatResult = processNameField(\n row.get(FORM_COLUMNS.COMPLETED_GREAT) || \"\",\n rosterNames,\n \"Completed (great)\",\n );\n for (const name of greatResult.matched) {\n coldCalls.push({\n student_name: name,\n result: \"completed\",\n performance: \"great\",\n });\n }\n allUnmatched.push(...greatResult.unmatched);\n\n // Completed (normal)\n const normalResult = processNameField(\n row.get(FORM_COLUMNS.COMPLETED_NORMAL) || \"\",\n rosterNames,\n \"Completed (normal)\",\n );\n for (const name of normalResult.matched) {\n coldCalls.push({\n student_name: name,\n result: \"completed\",\n performance: \"normal\",\n });\n }\n allUnmatched.push(...normalResult.unmatched);\n\n // Completed (bad)\n const badResult = processNameField(\n row.get(FORM_COLUMNS.COMPLETED_BAD) || \"\",\n rosterNames,\n \"Completed (bad)\",\n );\n for (const name of badResult.matched) {\n coldCalls.push({\n student_name: name,\n result: \"completed\",\n performance: \"bad\",\n });\n }\n allUnmatched.push(...badResult.unmatched);\n\n // Absent when called\n const absentCalledResult = processNameField(\n row.get(FORM_COLUMNS.ABSENT_WHEN_CALLED) || \"\",\n rosterNames,\n \"Absent when called\",\n );\n for (const name of absentCalledResult.matched) {\n coldCalls.push({ student_name: name, result: \"absent\" });\n }\n allUnmatched.push(...absentCalledResult.unmatched);\n\n // Refused when called\n const refusedResult = processNameField(\n row.get(FORM_COLUMNS.REFUSED_WHEN_CALLED) || \"\",\n rosterNames,\n \"Refused when called\",\n );\n for (const name of refusedResult.matched) {\n coldCalls.push({ student_name: name, result: \"refused\" });\n }\n allUnmatched.push(...refusedResult.unmatched);\n\n // Other absences (not cold-called, just noted absent)\n const otherAbsencesResult = processNameField(\n row.get(FORM_COLUMNS.OTHER_ABSENCES) || \"\",\n rosterNames,\n \"Other absences\",\n );\n absences.push(...otherAbsencesResult.matched);\n allUnmatched.push(...otherAbsencesResult.unmatched);\n\n // Handle unmatched names - CRITICAL: Don't silently drop\n if (allUnmatched.length > 0) {\n // Initialize pending review sheet if needed\n if (!pendingReviewSheet) {\n pendingReviewSheet = await getOrCreatePendingReviewSheet(doc);\n }\n\n // Write to Pending Review sheet\n await writeToPendingReview(\n pendingReviewSheet,\n classRaw,\n date,\n allUnmatched,\n );\n\n // Send email notification\n if (notificationEmail) {\n await notifyUnmatchedNames(\n notificationEmail,\n classRaw,\n date,\n allUnmatched,\n );\n }\n\n console.warn(\n `${allUnmatched.length} unmatched names for ${classRaw} ${date}:`,\n allUnmatched.map((u) => u.inputName),\n );\n }\n\n // Only POST if we have some matched data\n if (coldCalls.length > 0 || absences.length > 0) {\n const payload: ReportPayload = {\n date,\n class_type: classType,\n cold_calls: coldCalls,\n absences,\n };\n\n try {\n const response = await fetch(postClassReportEndpoint, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"X-API-Key\": apiKey,\n },\n body: JSON.stringify(payload),\n });\n\n const result = await response.json();\n\n if (!response.ok) {\n errors.push(\n `POST failed for ${classRaw} ${date}: ${\n result.error || response.status\n }`,\n );\n continue; // Don't mark as processed if POST failed\n }\n\n console.log(`Posted report for ${classRaw} ${date}:`, result);\n } catch (fetchError) {\n errors.push(`POST failed for ${classRaw} ${date}: ${fetchError}`);\n continue; // Don't mark as processed if POST failed\n }\n }\n\n // Mark row as processed by writing timestamp to column J\n row.set(FORM_COLUMNS.PROCESSED, new Date().toISOString());\n await row.save();\n processedCount++;\n }\n\n // Log summary\n const summary = {\n processed: processedCount,\n errors: errors.length,\n errorDetails: errors,\n };\n\n console.log(\"Processing complete:\", summary);\n\n // Send error summary if there were issues\n if (errors.length > 0) {\n // Val.town free tier: emails go to account owner (filter in Gmail)\n await email({\n subject: `[Law Tracker] Form Processing Errors (${errors.length})`,\n text: `The following errors occurred while processing form responses:\n\n${errors.map((e) => `- ${e}`).join(\"\\n\")}\n\nSuccessfully processed: ${processedCount} reports\n`,\n });\n }\n\n return Response.json(summary);\n}\n",[],[242],{"_104":250,"_96":251,"_154":252,"_156":-5,"_157":139,"_158":253,"_160":161,"_106":254,"_101":163,"_164":180,"_166":255,"_168":22,"_169":-5,"_170":256,"_99":257},"e021eb2a-f000-11f0-8215-42dde27851f2","process-form-reports-schedule.cron.tsx","966fb8b8-efe2-11f0-b659-42dde27851f2",65,["D",1768254699900],"/**\n * Process Form Reports - Scheduled Trigger\n * Runs every 10 minutes (configure in Val.town UI)\n *\n * Calls the process-form-reports HTTP endpoint to check for new form submissions.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\n\n// Get the HTTP endpoint URL - MUST be set after pushing process-form-reports-api.http.tsx\nfunction getProcessFormReportsEndpoint(): string {\n const url = Deno.env.get(\"PROCESS_FORM_REPORTS_URL\");\n if (!url) {\n throw new Error(\n \"PROCESS_FORM_REPORTS_URL env var not set. Configure in Val.town settings.\"\n );\n }\n return url;\n}\n\nexport default async function () {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n const endpoint = getProcessFormReportsEndpoint();\n\n let result;\n try {\n const response = await fetch(endpoint);\n result = await response.json();\n\n if (!response.ok) {\n throw new Error(result.error || `HTTP ${response.status}`);\n }\n } catch (fetchError) {\n // Send error notification\n if (notificationEmail) {\n await email({\n // Val.town free tier: emails go to account owner\n subject: \"[Law Tracker] Form Processing Failed - Network Error\",\n text: `Failed to reach form processing endpoint:\\n\\n${fetchError}\\n\\nEndpoint: ${endpoint}`,\n });\n }\n throw fetchError;\n }\n\n // Log result\n console.log(\"Form processing complete:\", result);\n\n // Only notify if there were errors (successful processing is silent)\n if (result.errors > 0 && notificationEmail) {\n // The HTTP endpoint already sends detailed error emails,\n // so we just log here to avoid duplicate notifications\n console.warn(`Form processing had ${result.errors} errors`);\n }\n}\n",[],[251],{"_104":259,"_96":260,"_154":261,"_156":-5,"_157":139,"_158":262,"_160":161,"_106":263,"_101":179,"_164":180,"_166":264,"_168":22,"_169":-5,"_170":265,"_99":266},"8d222bb4-f006-11f0-8fea-42dde27851f2","te-report-prompt.cron.tsx","e4b192e0-ef4b-11f0-b248-42dde27851f2",79,["D",1768257137598],"/**\n * T&E Post-Class Report Prompt\n * Runs 6 PM EST Mon/Wed (11 PM UTC)\n * Reminds professor to submit post-class report.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\nimport { formatDate } from \"./utils.tsx\";\n\nexport default async function() {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n if (!notificationEmail) {\n throw new Error(\"NOTIFICATION_EMAIL env var not set. Configure in Val.town settings.\");\n }\n\n const today = formatDate(new Date());\n\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[T&E] Post-Class Report - ${today}`,\n text: `Hi Sarah,\n\nTime to submit your post-class report for T&E.\n\nPlease note:\n- Who was absent (not on self-report list)\n- Who you called on and their performance (great/normal/bad)\n- Any students who refused when called\n\nReply to this email or use the reporting form.\n\nThanks!\n`,\n });\n\n console.log(`Sent T&E report prompt for ${today}`);\n}\n",[],[260],{"_104":268,"_96":269,"_154":270,"_156":-5,"_157":139,"_158":271,"_160":161,"_106":272,"_101":273,"_164":274,"_166":275,"_168":22,"_169":-5,"_170":276,"_99":277},"8d376920-f006-11f0-beb5-42dde27851f2","utils.tsx","da859f36-ef65-11f0-8c45-42dde27851f2",83,["D",1768257137798],4,"script","/**\n * Shared utilities for Law Student Tracker\n * Contains name matching, normalization, fuzzy matching, and auth functions.\n */\n\nimport { JWT } from \"npm:google-auth-library\";\n\n// ============================================================================\n// Sheet Tab Names (single source of truth)\n// ============================================================================\n\n/**\n * Google Sheet tab names. Use these constants instead of hardcoded strings.\n */\nexport const SHEET_TABS = {\n // T&E class\n TE_ROSTER: \"T&E Roster\",\n TE_ON_CALL: \"T&E On-Call\",\n\n // L&C class\n LC_ROSTER: \"L&C Roster\",\n LC_ASSIGNMENTS: \"L&C Assignments\",\n LC_ON_CALL: \"L&C On-Call\",\n\n // Shared tracking\n COLD_CALL_LOG: \"Cold Call Log\",\n\n // Form inputs\n STUDENT_SELF_REPORTS: \"Form Responses 1\", // Student self-report form (absences/unprepared)\n SARAH_CLASS_REPORTS: \"Form Responses\", // Sarah's post-class report form\n\n // System-managed\n PENDING_REVIEW: \"Pending Review\", // Unmatched names for manual review\n CANCELLED_CLASSES: \"Cancelled Classes\", // Log of cancelled class dates\n} as const;\n\n// ============================================================================\n// Sheet ID (single source of truth)\n// ============================================================================\n\n/**\n * Google Sheet ID. For production, set SHEET_ID env var in Val.town.\n * Falls back to test sheet if not set.\n */\nexport const SHEET_ID = Deno.env.get(\"SHEET_ID\") || \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// ============================================================================\n// Shared Types\n// ============================================================================\n\n/**\n * A single cold call result from a post-class report.\n */\nexport interface ColdCallEntry {\n student_name: string;\n result: \"completed\" | \"absent\" | \"refused\";\n performance?: \"great\" | \"normal\" | \"bad\";\n}\n\n/**\n * Payload for POST /post-class-report endpoint.\n */\nexport interface ReportPayload {\n date: string;\n class_type: \"te\" | \"lc\";\n cold_calls: ColdCallEntry[];\n absences: string[]; // Names of students who were absent (not on on-call list)\n}\n\n/**\n * Determines if a cold call result is a \"concerning event\" for threshold tracking.\n * Concerning events: absent, refused, unprepared (self-reported), or bad performance.\n */\nexport function isConcerningEvent(\n result: ColdCallEntry[\"result\"] | \"unprepared\",\n performance?: ColdCallEntry[\"performance\"] | \"self-reported\",\n): boolean {\n return result === \"absent\" || result === \"refused\" || result === \"unprepared\" || performance === \"bad\";\n}\n\n/**\n * Formats a Date object as YYYY-MM-DD string for comparison and storage.\n */\nexport function formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n// ============================================================================\n// Authentication\n// ============================================================================\n\n/**\n * Creates authenticated JWT client for Google Sheets API.\n * Requires GOOGLE_APPLICATION_CREDENTIALS env var containing JSON credentials.\n */\nexport function getAuthClient(): JWT {\n const credsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credsJson) {\n throw new Error(\n \"GOOGLE_APPLICATION_CREDENTIALS env var not set. Configure in Val.town settings.\",\n );\n }\n const creds = JSON.parse(credsJson);\n return new JWT({\n email: creds.client_email,\n key: creds.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"],\n });\n}\n\n// ============================================================================\n// Name Matching\n// ============================================================================\n\n/**\n * Normalize a name for comparison:\n * - Lowercase\n * - Collapse multiple whitespace to single space\n * - Trim leading/trailing whitespace\n * - Handle \"Last, First\" -> \"First Last\" conversion\n */\nexport function normalizeName(name: string): string {\n if (!name || typeof name !== \"string\") return \"\";\n\n let normalized = name.toLowerCase().trim().replace(/\\s+/g, \" \");\n\n // Handle \"Last, First\" format -> \"First Last\"\n if (normalized.includes(\",\")) {\n const [last, first] = normalized.split(\",\").map((s) => s.trim());\n if (first && last) {\n normalized = `${first} ${last}`;\n }\n }\n\n return normalized;\n}\n\n/**\n * Calculate Levenshtein distance between two strings.\n * Used for fuzzy matching names with typos.\n */\nexport function levenshteinDistance(a: string, b: string): number {\n if (a.length === 0) return b.length;\n if (b.length === 0) return a.length;\n\n const matrix: number[][] = [];\n\n // Initialize first column\n for (let i = 0; i <= b.length; i++) {\n matrix[i] = [i];\n }\n\n // Initialize first row\n for (let j = 0; j <= a.length; j++) {\n matrix[0][j] = j;\n }\n\n // Fill in the rest\n for (let i = 1; i <= b.length; i++) {\n for (let j = 1; j <= a.length; j++) {\n if (b.charAt(i - 1) === a.charAt(j - 1)) {\n matrix[i][j] = matrix[i - 1][j - 1];\n } else {\n matrix[i][j] = Math.min(\n matrix[i - 1][j - 1] + 1, // substitution\n matrix[i][j - 1] + 1, // insertion\n matrix[i - 1][j] + 1, // deletion\n );\n }\n }\n }\n\n return matrix[b.length][a.length];\n}\n\n/**\n * Match result from findMatchingName\n */\nexport interface NameMatchResult {\n matched: true;\n rosterName: string;\n inputName: string;\n matchType: \"exact\" | \"normalized\" | \"fuzzy\";\n distance?: number; // Only for fuzzy matches\n}\n\nexport interface NameNoMatchResult {\n matched: false;\n inputName: string;\n closestCandidate?: string;\n closestDistance?: number;\n}\n\nexport type NameMatch = NameMatchResult | NameNoMatchResult;\n\n/**\n * Find matching name from roster given an input name.\n * Attempts matching in order:\n * 1. Exact match (case-sensitive)\n * 2. Normalized match (case-insensitive, whitespace normalized, Last/First flip)\n * 3. Fuzzy match (Levenshtein distance <= 2)\n *\n * @param inputName - The name from the form\n * @param rosterNames - Array of canonical names from the roster\n * @param maxDistance - Maximum Levenshtein distance for fuzzy match (default 2)\n * @returns NameMatch indicating success/failure and details\n */\nexport function findMatchingName(\n inputName: string,\n rosterNames: string[],\n maxDistance = 2,\n): NameMatch {\n if (!inputName || !rosterNames.length) {\n return { matched: false, inputName: inputName || \"\" };\n }\n\n // 1. Exact match\n if (rosterNames.includes(inputName)) {\n return {\n matched: true,\n rosterName: inputName,\n inputName,\n matchType: \"exact\",\n };\n }\n\n // 2. Normalized match\n const normalizedInput = normalizeName(inputName);\n const normalizedRoster = rosterNames.map((n) => ({\n original: n,\n normalized: normalizeName(n),\n }));\n\n for (const { original, normalized } of normalizedRoster) {\n if (normalized === normalizedInput) {\n return {\n matched: true,\n rosterName: original,\n inputName,\n matchType: \"normalized\",\n };\n }\n }\n\n // 3. Fuzzy match - find best match within threshold\n let bestMatch: { name: string; distance: number } | null = null;\n\n for (const { original, normalized } of normalizedRoster) {\n const distance = levenshteinDistance(normalizedInput, normalized);\n if (distance <= maxDistance) {\n if (!bestMatch || distance < bestMatch.distance) {\n bestMatch = { name: original, distance };\n }\n }\n }\n\n if (bestMatch) {\n return {\n matched: true,\n rosterName: bestMatch.name,\n inputName,\n matchType: \"fuzzy\",\n distance: bestMatch.distance,\n };\n }\n\n // No match found - return closest candidate for debugging\n let closest: { name: string; distance: number } | null = null;\n for (const { original, normalized } of normalizedRoster) {\n const distance = levenshteinDistance(normalizedInput, normalized);\n if (!closest || distance < closest.distance) {\n closest = { name: original, distance };\n }\n }\n\n return {\n matched: false,\n inputName,\n closestCandidate: closest?.name,\n closestDistance: closest?.distance,\n };\n}\n\n/**\n * Parse comma-separated list of names.\n * Handles leading/trailing whitespace around each name.\n * Filters out empty strings.\n */\nexport function parseNameList(input: string): string[] {\n if (!input || typeof input !== \"string\") return [];\n\n return input\n .split(\",\")\n .map((s) => s.trim())\n .filter((s) => s.length > 0);\n}\n\n/**\n * Map class string from form to canonical class_type.\n * Form might say \"T&E\", \"Trusts & Estates\", \"te\", etc.\n */\nexport function parseClassType(classStr: string): \"te\" | \"lc\" | null {\n if (!classStr) return null;\n\n const lower = classStr.toLowerCase().trim();\n\n if (\n lower === \"te\" ||\n lower === \"t&e\" ||\n lower.includes(\"trusts\") ||\n lower.includes(\"estates\")\n ) {\n return \"te\";\n }\n\n if (\n lower === \"lc\" ||\n lower === \"l&c\" ||\n lower.includes(\"capitalism\") ||\n lower.includes(\"law &\")\n ) {\n return \"lc\";\n }\n\n return null;\n}\n\n/**\n * Parse date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable.\n */\nexport function parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n return fallback.toISOString().split(\"T\")[0];\n }\n\n return null;\n}\n",[],[269],"files",[151,173,184,195,204,213,222,231,240,249,258,267],"counts",{"_282":32,"_283":284,"_285":32,"_286":287},"pulls","branches",1,"forks","envVars",{"_288":190,"_289":32},"count","emptyCount","contents",[],{"_104":223,"_96":100,"_154":224,"_156":-5,"_157":139,"_158":225,"_160":161,"_106":293,"_101":227,"_164":191,"_166":228,"_168":22,"_169":-5,"_99":294},["D",1768257137599],[100],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_94":95,"_96":97,"_98":44,"_99":100,"_102":303,"_165":308,"_311":312,"_356":357,"_368":-7,"_369":32,"_370":22},{"_104":105,"_96":97,"_106":304,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":305,"_133":306,"_136":307,"_148":22},["D",1754054718011],{"_94":95,"_131":132},{"_94":95,"_135":132,"_14":114},{"_101":138,"_96":44,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":97,"_147":95},{"_104":223,"_96":100,"_154":224,"_156":-5,"_157":139,"_158":225,"_160":161,"_106":309,"_101":227,"_164":191,"_166":228,"_168":22,"_169":-5,"_99":310},["D",1768257137599],[100],"history",[313,315,321,327,332,337,342,347,352],{"_104":223,"_157":139,"_154":224,"_96":100,"_166":228,"_164":191,"_101":227,"_156":-5,"_106":314,"_158":225,"_169":-5},["D",1768257137599],{"_104":316,"_157":139,"_154":224,"_96":100,"_166":317,"_164":191,"_101":318,"_156":-5,"_106":319,"_158":320,"_169":-5},"faa238b4-ef6b-11f0-9add-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { formatDate, getAuthClient, parseSheetDate, SHEET_TABS } from \"./utils.tsx\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Local aliases for readability\nconst TABS = {\n ROSTER: SHEET_TABS.TE_ROSTER,\n SELF_REPORTS: SHEET_TABS.STUDENT_SELF_REPORTS,\n ONCALL: SHEET_TABS.TE_ON_CALL,\n COLD_CALL_LOG: SHEET_TABS.COLD_CALL_LOG,\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Gets day of week pool. Returns \"mon\" or \"wed\", or null if neither.\n * @param date - Optional date to check (defaults to today)\n */\nfunction getDayPool(date: Date = new Date()): \"mon\" | \"wed\" | null {\n const day = date.getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool (A-M = mon, N-Z = wed).\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n }\n }\n\n return { warnings };\n}\n\n/**\n * Main selection logic.\n * @param sheetId - Google Sheet ID\n * @param forceRecompute - If true, recompute even if cached\n * @param mockDate - Optional date to use instead of today (for testing)\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n mockDate?: Date,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const effectiveDate = mockDate || new Date();\n const today = formatDate(effectiveDate);\n const pool = getDayPool(effectiveDate);\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Parse mockDate for testing (e.g., ?mockDate=2026-01-12)\n // Allows tests to run on any day by pretending it's a specific date\n let mockDate: Date | undefined;\n const mockDateParam = url.searchParams.get(\"mockDate\");\n if (mockDateParam) {\n const parsed = new Date(mockDateParam);\n if (!isNaN(parsed.getTime())) {\n mockDate = parsed;\n }\n }\n\n const result = await selectOnCall(sheetId, forceRecompute, mockDate);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",7,["D",1768190749374],48,{"_104":322,"_157":139,"_154":224,"_96":100,"_166":323,"_164":191,"_101":324,"_156":-5,"_106":325,"_158":326,"_169":-5},"691b5610-ef6a-11f0-8be1-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { getAuthClient, parseSheetDate, SHEET_TABS } from \"./utils.tsx\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Local aliases for readability\nconst TABS = {\n ROSTER: SHEET_TABS.TE_ROSTER,\n SELF_REPORTS: SHEET_TABS.STUDENT_SELF_REPORTS,\n ONCALL: SHEET_TABS.TE_ON_CALL,\n COLD_CALL_LOG: SHEET_TABS.COLD_CALL_LOG,\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Gets day of week pool. Returns \"mon\" or \"wed\", or null if neither.\n * @param date - Optional date to check (defaults to today)\n */\nfunction getDayPool(date: Date = new Date()): \"mon\" | \"wed\" | null {\n const day = date.getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool (A-M = mon, N-Z = wed).\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool`,\n );\n }\n }\n\n return { warnings };\n}\n\n/**\n * Main selection logic.\n * @param sheetId - Google Sheet ID\n * @param forceRecompute - If true, recompute even if cached\n * @param mockDate - Optional date to use instead of today (for testing)\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n mockDate?: Date,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const effectiveDate = mockDate || new Date();\n const today = formatDate(effectiveDate);\n const pool = getDayPool(effectiveDate);\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Parse mockDate for testing (e.g., ?mockDate=2026-01-12)\n // Allows tests to run on any day by pretending it's a specific date\n let mockDate: Date | undefined;\n const mockDateParam = url.searchParams.get(\"mockDate\");\n if (mockDateParam) {\n const parsed = new Date(mockDateParam);\n if (!isNaN(parsed.getTime())) {\n mockDate = parsed;\n }\n }\n\n const result = await selectOnCall(sheetId, forceRecompute, mockDate);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",6,["D",1768190075718],45,{"_104":328,"_157":139,"_154":224,"_96":100,"_166":329,"_164":191,"_101":190,"_156":-5,"_106":330,"_158":331,"_169":-5},"3629be50-ef64-11f0-94db-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets day of week pool. Returns \"mon\" or \"wed\", or null if neither.\n * @param date - Optional date to check (defaults to today)\n */\nfunction getDayPool(date: Date = new Date()): \"mon\" | \"wed\" | null {\n const day = date.getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Parses date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable (caller should warn and skip, not crash).\n */\nfunction parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing but log warning\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n console.warn(`parseSheetDate: using native Date for \"${trimmed}\" - verify format is correct`);\n return formatDate(fallback);\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n * @param sheetId - Google Sheet ID\n * @param forceRecompute - If true, recompute even if cached\n * @param mockDate - Optional date to use instead of today (for testing)\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n mockDate?: Date,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const effectiveDate = mockDate || new Date();\n const today = formatDate(effectiveDate);\n const pool = getDayPool(effectiveDate);\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Parse mockDate for testing (e.g., ?mockDate=2026-01-12)\n // Allows tests to run on any day by pretending it's a specific date\n let mockDate: Date | undefined;\n const mockDateParam = url.searchParams.get(\"mockDate\");\n if (mockDateParam) {\n const parsed = new Date(mockDateParam);\n if (!isNaN(parsed.getTime())) {\n mockDate = parsed;\n }\n }\n\n const result = await selectOnCall(sheetId, forceRecompute, mockDate);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768187413277],39,{"_104":333,"_157":139,"_154":224,"_96":100,"_166":334,"_164":191,"_101":273,"_156":-5,"_106":335,"_158":336,"_169":-5},"b0e1329a-ef5a-11f0-b74b-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets today's day of week. Returns \"mon\" or \"wed\", or null if neither.\n */\nfunction getTodayPool(): \"mon\" | \"wed\" | null {\n const day = new Date().getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Parses date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable (caller should warn and skip, not crash).\n */\nfunction parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing but log warning\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n console.warn(`parseSheetDate: using native Date for \"${trimmed}\" - verify format is correct`);\n return formatDate(fallback);\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const today = formatDate(new Date());\n const pool = getTodayPool();\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n const result = await selectOnCall(sheetId, forceRecompute);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768183324203],31,{"_104":338,"_157":139,"_154":224,"_96":100,"_166":339,"_164":191,"_101":179,"_156":-5,"_106":340,"_158":341,"_169":-5},"a650ed30-ef4f-11f0-b47d-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Production sheet ID (test: 1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM)\nconst SHEET_ID = \"1J72KztsIjItFpgPrYz5uPndZWNf4XI5mc_hpUW669A8\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets today's day of week. Returns \"mon\" or \"wed\", or null if neither.\n */\nfunction getTodayPool(): \"mon\" | \"wed\" | null {\n const day = new Date().getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Parses date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable (caller should warn and skip, not crash).\n */\nfunction parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing but log warning\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n console.warn(`parseSheetDate: using native Date for \"${trimmed}\" - verify format is correct`);\n return formatDate(fallback);\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const today = formatDate(new Date());\n const pool = getTodayPool();\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n const result = await selectOnCall(sheetId, forceRecompute);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768178581987],26,{"_104":343,"_157":139,"_154":224,"_96":100,"_166":344,"_164":191,"_101":163,"_156":-5,"_106":345,"_158":346,"_169":-5},"5c6b9ce2-ef4f-11f0-ae30-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID - switch to production when approved\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets today's day of week. Returns \"mon\" or \"wed\", or null if neither.\n */\nfunction getTodayPool(): \"mon\" | \"wed\" | null {\n const day = new Date().getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Parses date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable (caller should warn and skip, not crash).\n */\nfunction parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing but log warning\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n console.warn(`parseSheetDate: using native Date for \"${trimmed}\" - verify format is correct`);\n return formatDate(fallback);\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n fromCache: boolean;\n excluded: string[];\n error?: string;\n}> {\n const today = formatDate(new Date());\n const pool = getTodayPool();\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n fromCache: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n fromCache: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n const parsedDate = parseSheetDate(reportDate);\n if (parsedDate === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n fromCache: false, // Just computed and stored\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n fromCache: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n const result = await selectOnCall(sheetId, forceRecompute);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768178458036],23,{"_104":348,"_157":139,"_154":224,"_96":100,"_166":349,"_164":191,"_101":284,"_156":-5,"_106":350,"_158":351,"_169":-5},"c4f40790-ef4a-11f0-a834-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID - switch to production when approved\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets today's day of week. Returns \"mon\" or \"wed\", or null if neither.\n */\nfunction getTodayPool(): \"mon\" | \"wed\" | null {\n const day = new Date().getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n wasStored: boolean;\n excluded: string[];\n error?: string;\n}> {\n const today = formatDate(new Date());\n const pool = getTodayPool();\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n wasStored: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n wasStored: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n wasStored: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool (dedupe by name)\n const seen = new Set();\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => {\n if (!s.student_name || s.pool !== pool) return false;\n if (seen.has(s.student_name)) return false;\n seen.add(s.student_name);\n return true;\n });\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n // Parse the date - might be in various formats\n const parsedDate = new Date(reportDate);\n if (formatDate(parsedDate) === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n wasStored: false,\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n wasStored: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Allow testing with mock day\n const mockDay = url.searchParams.get(\"mockDay\");\n if (mockDay) {\n // Override getTodayPool for testing\n // This is hacky but useful for testing\n const originalGetTodayPool = getTodayPool;\n // Can't override easily, so just note this in response\n }\n\n const result = await selectOnCall(sheetId, forceRecompute);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768176485931],9,{"_104":353,"_157":139,"_154":224,"_96":100,"_166":354,"_164":191,"_101":32,"_156":-5,"_106":355,"_158":318,"_169":-5},"78f39b68-ef49-11f0-a9a7-42dde27851f2","/**\n * T&E On-Call Selection\n *\n * Selects 6 students for cold-calling based on:\n * - Day of week (Mon = first half alphabet, Wed = second half)\n * - Exclusion of same-day self-reports\n * - Prioritization by fewest actual cold calls\n *\n * Idempotent: Returns stored selection if already computed for today.\n */\n\nimport { GoogleSpreadsheet, GoogleSpreadsheetRow } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID - switch to production when approved\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// Tab names\nconst TABS = {\n ROSTER: \"T&E Roster\",\n SELF_REPORTS: \"Form Responses 1\", // Existing form tab\n ONCALL: \"T&E On-Call\",\n COLD_CALL_LOG: \"Cold Call Log\",\n} as const;\n\ninterface RosterStudent {\n student_name: string;\n last_name: string;\n pool: \"mon\" | \"wed\";\n cold_call_count: number;\n last_called: string;\n absences: number;\n concerning_events: number;\n}\n\ninterface OnCallEntry {\n date: string;\n student_name: string;\n notified_at: string;\n}\n\ninterface SelfReport {\n timestamp: string;\n name: string;\n date: string;\n type: string;\n}\n\n/**\n * Creates authenticated JWT client with read/write scope.\n */\nfunction getAuthClient(): JWT {\n const credentialsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credentialsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\n }\n\n const credentials = JSON.parse(credentialsJson);\n\n return new JWT({\n email: credentials.client_email,\n key: credentials.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"], // Read + Write\n });\n}\n\n/**\n * Gets today's day of week. Returns \"mon\" or \"wed\", or null if neither.\n */\nfunction getTodayPool(): \"mon\" | \"wed\" | null {\n const day = new Date().getDay();\n if (day === 1) return \"mon\";\n if (day === 3) return \"wed\";\n return null;\n}\n\n/**\n * Formats date as YYYY-MM-DD for comparison.\n */\nfunction formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n/**\n * Fisher-Yates shuffle for randomizing ties.\n */\nfunction shuffle(array: T[]): T[] {\n const result = [...array];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\n/**\n * Main selection logic.\n */\nasync function selectOnCall(\n sheetId: string,\n forceRecompute = false,\n): Promise<{\n success: boolean;\n date: string;\n pool: \"mon\" | \"wed\" | null;\n selected: string[];\n wasStored: boolean;\n excluded: string[];\n error?: string;\n}> {\n const today = formatDate(new Date());\n const pool = getTodayPool();\n\n // Validate day of week\n if (!pool) {\n return {\n success: false,\n date: today,\n pool: null,\n selected: [],\n wasStored: false,\n excluded: [],\n error: \"Today is not Monday or Wednesday. On-call selection only runs on class days.\",\n };\n }\n\n try {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(sheetId, auth);\n await doc.loadInfo();\n\n // Get or create tabs\n let onCallSheet = doc.sheetsByTitle[TABS.ONCALL];\n if (!onCallSheet) {\n onCallSheet = await doc.addSheet({\n title: TABS.ONCALL,\n headerValues: [\"date\", \"student_name\", \"notified_at\"],\n });\n }\n\n // Check if today already has selections (idempotency)\n await onCallSheet.loadHeaderRow();\n const existingRows = await onCallSheet.getRows();\n const todaySelections = existingRows.filter(\n (row) => row.get(\"date\") === today,\n );\n\n if (todaySelections.length > 0 && !forceRecompute) {\n return {\n success: true,\n date: today,\n pool,\n selected: todaySelections.map((row) => row.get(\"student_name\")),\n wasStored: true,\n excluded: [],\n };\n }\n\n // Get roster\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n wasStored: false,\n excluded: [],\n error: `Tab \"${TABS.ROSTER}\" not found. Please create roster first.`,\n };\n }\n\n await rosterSheet.loadHeaderRow();\n const rosterRows = await rosterSheet.getRows();\n\n // Parse roster and filter to today's pool\n const roster: RosterStudent[] = rosterRows\n .map((row) => ({\n student_name: row.get(\"student_name\") || \"\",\n last_name: row.get(\"last_name\") || \"\",\n pool: (row.get(\"pool\") || \"\").toLowerCase() as \"mon\" | \"wed\",\n cold_call_count: parseInt(row.get(\"cold_call_count\") || \"0\", 10),\n last_called: row.get(\"last_called\") || \"\",\n absences: parseInt(row.get(\"absences\") || \"0\", 10),\n concerning_events: parseInt(row.get(\"concerning_events\") || \"0\", 10),\n }))\n .filter((s) => s.pool === pool && s.student_name);\n\n // Validate pool assignment\n const poolValidation = validatePoolAssignment(roster, pool);\n if (poolValidation.warnings.length > 0) {\n console.warn(\"Pool assignment warnings:\", poolValidation.warnings);\n }\n\n // Get today's self-reports\n const selfReportsSheet = doc.sheetsByTitle[TABS.SELF_REPORTS];\n const excludedNames: string[] = [];\n\n if (selfReportsSheet) {\n await selfReportsSheet.loadHeaderRow();\n const selfReportRows = await selfReportsSheet.getRows();\n\n // Find students who submitted same-day reports\n for (const row of selfReportRows) {\n const reportDate = row.get(\n \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\",\n );\n if (reportDate) {\n // Parse the date - might be in various formats\n const parsedDate = new Date(reportDate);\n if (formatDate(parsedDate) === today) {\n const name = row.get(\"Your name\");\n if (name) excludedNames.push(name.toLowerCase().trim());\n }\n }\n }\n }\n\n // Filter out excluded students\n const eligible = roster.filter(\n (s) => !excludedNames.includes(s.student_name.toLowerCase().trim()),\n );\n\n // Sort by cold_call_count (ascending) with random shuffle for ties\n const grouped = new Map();\n for (const student of eligible) {\n const count = student.cold_call_count;\n if (!grouped.has(count)) grouped.set(count, []);\n grouped.get(count)!.push(student);\n }\n\n // Sort groups by count, shuffle within each group\n const sortedCounts = [...grouped.keys()].sort((a, b) => a - b);\n const sorted: RosterStudent[] = [];\n for (const count of sortedCounts) {\n sorted.push(...shuffle(grouped.get(count)!));\n }\n\n // Take top 6\n const selected = sorted.slice(0, 6);\n const selectedNames = selected.map((s) => s.student_name);\n\n // Store selections if we computed new ones\n if (forceRecompute && todaySelections.length > 0) {\n // Delete existing selections for today\n for (const row of todaySelections) {\n await row.delete();\n }\n }\n\n // Write new selections\n const now = new Date().toISOString();\n for (const name of selectedNames) {\n await onCallSheet.addRow({\n date: today,\n student_name: name,\n notified_at: now,\n });\n }\n\n return {\n success: true,\n date: today,\n pool,\n selected: selectedNames,\n wasStored: false,\n excluded: excludedNames,\n };\n } catch (error) {\n return {\n success: false,\n date: today,\n pool,\n selected: [],\n wasStored: false,\n excluded: [],\n error: error instanceof Error ? error.message : String(error),\n };\n }\n}\n\n/**\n * Validates pool assignments look reasonable.\n * Warns if a student's last name suggests wrong pool.\n */\nfunction validatePoolAssignment(\n roster: RosterStudent[],\n pool: \"mon\" | \"wed\",\n): { warnings: string[] } {\n const warnings: string[] = [];\n\n // Get all last names in this pool, sorted\n const lastNames = roster.map((s) => s.last_name.toLowerCase()).sort();\n\n if (lastNames.length === 0) {\n warnings.push(`No students found in ${pool} pool`);\n return { warnings };\n }\n\n // Simple heuristic: Monday should be A-M, Wednesday should be N-Z\n const midpoint = \"m\";\n for (const student of roster) {\n const firstLetter = student.last_name.toLowerCase()[0];\n if (pool === \"mon\" && firstLetter > midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (mon but last name > M)`,\n );\n } else if (pool === \"wed\" && firstLetter <= midpoint) {\n warnings.push(\n `Student \"${student.student_name}\" (last name: ${student.last_name}) may be in wrong pool (wed but last name <= M)`,\n );\n }\n }\n\n return { warnings };\n}\n\n// HTTP endpoint\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const sheetId = url.searchParams.get(\"sheetId\") || SHEET_ID;\n const forceRecompute = url.searchParams.get(\"force\") === \"true\";\n\n // Allow testing with mock day\n const mockDay = url.searchParams.get(\"mockDay\");\n if (mockDay) {\n // Override getTodayPool for testing\n // This is hacky but useful for testing\n const originalGetTodayPool = getTodayPool;\n // Can't override easily, so just note this in response\n }\n\n const result = await selectOnCall(sheetId, forceRecompute);\n\n return Response.json(result, {\n status: result.success ? 200 : 400,\n });\n}\n",["D",1768175928930],"versions",[358,360,361,362,363,364,365,366,367],{"_165":313,"_359":315},"previous",{"_165":315,"_359":321},{"_165":321,"_359":327},{"_165":327,"_359":332},{"_165":332,"_359":337},{"_165":337,"_359":342},{"_165":342,"_359":347},{"_165":347,"_359":352},{"_165":352,"_359":-5},"versionNumber","page","hasNext","actionData","errors"]

sahar

law-student-tracker

History for oncall-selection.http.tsx