[{"_1":2,"_377":-5,"_378":-5},"loaderData",{"_3":4,"_92":93,"_361":362},"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":73,"_100":101,"_102":103,"_149":150,"_302":303,"_304":305,"_314":315,"_193":-5,"_355":-5,"_356":-5,"_357":22,"_358":22,"_359":360},"handle","sahar","name","law-student-tracker","branchName","path","version",46,"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",{"_100":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,186,197,207,218,227,236,246,256,265,274,283,292],{"_104":152,"_96":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":22,"_106":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":168,"_99":185},"35f48bb8-ef64-11f0-9f0f-42dde27851f2","tests","fileId","35f48c6c-ef64-11f0-9f0f-42dde27851f2","parentId","branchId","branchVersion",35,"latest",["D",1768187412940],"fileType","directory","content","deleted","label","children",[169,177],{"_104":170,"_96":171,"_154":172,"_156":155,"_157":139,"_158":173,"_160":22,"_106":174,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":175,"_99":176},"361036ce-ef64-11f0-9f0f-42dde27851f2","integration","3610384a-ef64-11f0-9f0f-42dde27851f2",37,["D",1768187413116],[],[153,171],{"_104":178,"_96":179,"_154":180,"_156":155,"_157":139,"_158":181,"_160":22,"_106":182,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":183,"_99":184},"36023876-ef64-11f0-9f0f-42dde27851f2","unit","36023934-ef64-11f0-9f0f-42dde27851f2",36,["D",1768187413032],[],[153,179],[153],{"_104":187,"_96":188,"_154":189,"_156":-5,"_157":139,"_158":190,"_160":22,"_106":191,"_100":192,"_162":193,"_164":194,"_165":22,"_166":-5,"_167":195,"_99":196},"f0ffb77e-ef56-11f0-8d31-42dde27851f2","README.md","b6153ade-ef4d-11f0-9c60-42dde27851f2",30,["D",1768181713790],1,"file","# 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| `main.http.tsx` | HTTP | Sheets connection test |\n| `setup-test-data.http.tsx` | HTTP | Creates test roster (dev only) |\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| `NOTIFICATION_EMAIL` | Email for notifications (Sarah or test) |\n| `REPORT_API_KEY` | Secret key for report submissions |\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**Important:** After first push, get the `lc-oncall-selection.http.tsx` endpoint URL from Val.town UI and update line 10 of `lc-oncall-notify.cron.tsx`.\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",[],[188],{"_104":198,"_96":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_106":202,"_100":32,"_162":203,"_164":204,"_165":22,"_166":-5,"_167":205,"_99":206},"2b40972e-ef56-11f0-bf11-42dde27851f2","lc-oncall-notify.cron.tsx","2b409878-ef56-11f0-bf11-42dde27851f2",28,["D",1768181381997],"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\n// Get endpoint URL from Val.town UI after first push\nconst LC_ONCALL_ENDPOINT = \"\"; // TODO: Fill in after first vt push\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 if (!LC_ONCALL_ENDPOINT) {\n throw new Error(\"LC_ONCALL_ENDPOINT not configured. Get URL from Val.town UI.\");\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 to: notificationEmail,\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 to: notificationEmail,\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 to: notificationEmail,\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 to: notificationEmail,\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",[],[199],{"_104":208,"_96":209,"_154":210,"_156":-5,"_157":139,"_158":211,"_160":22,"_106":212,"_100":213,"_162":214,"_164":215,"_165":22,"_166":-5,"_167":216,"_99":217},"690c0ea8-ef6a-11f0-9f73-42dde27851f2","lc-oncall-selection.http.tsx","2b3b7afa-ef56-11f0-bec6-42dde27851f2",43,["D",1768190075639],3,"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 { getAuthClient, SHEET_TABS } from \"./utils.tsx\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\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 * 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 */\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\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n console.warn(`parseSheetDate: using native Date for \"${trimmed}\"`);\n return formatDate(fallback);\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\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 error: `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",[],[209],{"_104":219,"_96":220,"_154":221,"_156":-5,"_157":139,"_158":222,"_160":22,"_106":223,"_100":192,"_162":203,"_164":224,"_165":22,"_166":-5,"_167":225,"_99":226},"b61e22d4-ef4d-11f0-ae25-42dde27851f2","lc-report-prompt.cron.tsx","e4ab0ea2-ef4b-11f0-b248-42dde27851f2",18,["D",1768177749505],"/**\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\";\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 = new Date().toISOString().split(\"T\")[0];\n\n await email({\n to: notificationEmail,\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",[],[220],{"_104":228,"_96":229,"_154":230,"_156":-5,"_157":139,"_158":231,"_160":22,"_106":232,"_100":213,"_162":214,"_164":233,"_165":22,"_166":-5,"_167":234,"_99":235},"b0e67728-ef5a-11f0-866b-42dde27851f2","main.http.tsx","c49a6e2c-ef47-11f0-9984-42dde27851f2",32,["D",1768183324229],"/**\n * Google Sheets Read Test\n *\n * Tests that we can read from a Google Sheet using the service account.\n * This is Phase 1 - just verify credentials work before building real logic.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\n// Test sheet ID\nconst TEST_SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n/**\n * Creates an authenticated JWT client from the service account credentials\n * stored in the GOOGLE_APPLICATION_CREDENTIALS env var.\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.readonly\"],\n });\n}\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\") || TEST_SHEET_ID;\n\n const result = await testSheetRead(sheetId);\n\n return Response.json(result, {\n status: result.success ? 200 : 500,\n });\n}\n",[],[229],{"_104":237,"_96":238,"_154":239,"_156":-5,"_157":139,"_158":240,"_160":22,"_106":241,"_100":242,"_162":203,"_164":243,"_165":22,"_166":-5,"_167":244,"_99":245},"ede16d70-ef4d-11f0-b1f0-42dde27851f2","oncall-notify.cron.tsx","e4ba617c-ef4b-11f0-be8e-42dde27851f2",21,["D",1768177843090],2,"/**\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 to: notificationEmail,\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 to: notificationEmail,\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 to: notificationEmail,\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",[],[238],{"_104":247,"_96":248,"_154":249,"_156":-5,"_157":139,"_158":250,"_160":22,"_106":251,"_100":252,"_162":214,"_164":253,"_165":22,"_166":-5,"_167":254,"_99":255},"691b5610-ef6a-11f0-8be1-42dde27851f2","oncall-selection.http.tsx","78f39bfe-ef49-11f0-a9a7-42dde27851f2",45,["D",1768190075718],6,"/**\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",[],[248],{"_104":257,"_96":258,"_154":259,"_156":-5,"_157":139,"_158":101,"_160":22,"_106":260,"_100":261,"_162":214,"_164":262,"_165":22,"_166":-5,"_167":263,"_99":264},"6920859a-ef6a-11f0-a9f5-42dde27851f2","post-class-report.http.tsx","53e764dc-ef4c-11f0-9c60-42dde27851f2",["D",1768190075698],7,"/**\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_TABS,\n} 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 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 =\n result === \"absent\" || result === \"refused\" || performance === \"bad\";\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 body = `${student} has reached ${count} ${alertType}.\n\nHistory:\n${history.map((h) => `- ${h}`).join(\"\\n\")}\n\nAction needed: ${action}\n`;\n\n await email({ to, 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\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return Response.json({ error: \"Roster not found\" }, { 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 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 extraHistoryItem: `${payload.date}: Self-reported unprepared`,\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 // 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 roster\n const rosterRow = rosterByName.get(call.student_name);\n if (rosterRow) {\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\n if (isConcerningEvent(call.result, call.performance)) {\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\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 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 const extraHistoryItem = `${payload.date}: Absent (not on call list)`;\n\n await checkAndSendThresholdAlert({\n studentName: absentName,\n alertType: \"absences\",\n newCount: newAbsences,\n threshold: ABSENCE_THRESHOLD,\n notificationEmail,\n alerts,\n logSheet,\n extraHistoryItem,\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 extraHistoryItem,\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",[],[258],{"_104":266,"_96":267,"_154":268,"_156":-5,"_157":139,"_158":269,"_160":22,"_106":270,"_100":242,"_162":203,"_164":271,"_165":22,"_166":-5,"_167":272,"_99":273},"69150350-ef6a-11f0-b5bf-42dde27851f2","process-form-reports.cron.tsx","da8eaa36-ef65-11f0-a707-42dde27851f2",44,["D",1768190075643],"/**\n * Process Form Reports\n * Cron: every 10 minutes (configure in Val.town UI)\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 * 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_TABS,\n} from \"./utils.tsx\";\n\n// Test sheet ID - switch to production when deploying\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\n// POST endpoint for reports - get actual URL from Val.town UI\nconst POST_CLASS_REPORT_ENDPOINT = Deno.env.get(\"POST_CLASS_REPORT_URL\") ||\n \"https://sahar--PLACEHOLDER.web.val.run\"; // TODO: Set in env\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 }\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 }\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 await email({\n to: notificationEmail,\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 () {\n const notificationEmail = Deno.env.get(\"NOTIFICATION_EMAIL\");\n const apiKey = Deno.env.get(\"REPORT_API_KEY\");\n\n if (!apiKey) {\n throw new Error(\n \"REPORT_API_KEY env var not set. Configure in Val.town settings.\",\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 { 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(POST_CLASS_REPORT_ENDPOINT, {\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 && notificationEmail) {\n await email({\n to: notificationEmail,\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 summary;\n}\n",[],[267],{"_104":275,"_96":276,"_154":277,"_156":-5,"_157":139,"_158":278,"_160":22,"_106":279,"_100":192,"_162":214,"_164":280,"_165":22,"_166":-5,"_167":281,"_99":282},"b60ad3be-ef4d-11f0-bb12-42dde27851f2","setup-test-data.http.tsx","39cf80c2-ef4a-11f0-9a85-42dde27851f2",15,["D",1768177749408],"/**\n * Setup Test Data\n * Creates T&E Roster tab with sample students for testing.\n * Run once, then delete.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { JWT } from \"npm:google-auth-library\";\n\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\nfunction getAuthClient(): JWT {\n const credsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set\");\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\nexport default async function (): Promise {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(SHEET_ID, auth);\n await doc.loadInfo();\n\n // Create T&E Roster tab\n let roster = doc.sheetsByTitle[\"T&E Roster\"];\n if (!roster) {\n roster = await doc.addSheet({\n title: \"T&E Roster\",\n headerValues: [\"student_name\", \"last_name\", \"pool\", \"cold_call_count\", \"last_called\", \"absences\", \"concerning_events\"],\n });\n }\n\n // Add test students (A-M = mon, N-Z = wed)\n const testStudents = [\n { student_name: \"Alice Adams\", last_name: \"Adams\", pool: \"mon\", cold_call_count: 2 },\n { student_name: \"Bob Baker\", last_name: \"Baker\", pool: \"mon\", cold_call_count: 1 },\n { student_name: \"Carol Chen\", last_name: \"Chen\", pool: \"mon\", cold_call_count: 0 },\n { student_name: \"David Davis\", last_name: \"Davis\", pool: \"mon\", cold_call_count: 3 },\n { student_name: \"Eve Evans\", last_name: \"Evans\", pool: \"mon\", cold_call_count: 0 },\n { student_name: \"Frank Foster\", last_name: \"Foster\", pool: \"mon\", cold_call_count: 1 },\n { student_name: \"Grace Garcia\", last_name: \"Garcia\", pool: \"mon\", cold_call_count: 2 },\n { student_name: \"Henry Hill\", last_name: \"Hill\", pool: \"mon\", cold_call_count: 0 },\n { student_name: \"Nancy Nelson\", last_name: \"Nelson\", pool: \"wed\", cold_call_count: 1 },\n { student_name: \"Oscar Ortiz\", last_name: \"Ortiz\", pool: \"wed\", cold_call_count: 0 },\n { student_name: \"Paula Park\", last_name: \"Park\", pool: \"wed\", cold_call_count: 2 },\n { student_name: \"Quinn Quinn\", last_name: \"Quinn\", pool: \"wed\", cold_call_count: 0 },\n { student_name: \"Rachel Rivera\", last_name: \"Rivera\", pool: \"wed\", cold_call_count: 1 },\n { student_name: \"Steve Smith\", last_name: \"Smith\", pool: \"wed\", cold_call_count: 3 },\n { student_name: \"Tom Taylor\", last_name: \"Taylor\", pool: \"wed\", cold_call_count: 0 },\n { student_name: \"Uma Upton\", last_name: \"Upton\", pool: \"wed\", cold_call_count: 1 },\n ];\n\n for (const s of testStudents) {\n await roster.addRow({\n student_name: s.student_name,\n last_name: s.last_name,\n pool: s.pool,\n cold_call_count: s.cold_call_count,\n last_called: \"\",\n absences: 0,\n concerning_events: 0,\n });\n }\n\n return Response.json({ success: true, added: testStudents.length });\n}\n",[],[276],{"_104":284,"_96":285,"_154":286,"_156":-5,"_157":139,"_158":287,"_160":22,"_106":288,"_100":192,"_162":203,"_164":289,"_165":22,"_166":-5,"_167":290,"_99":291},"b62b37b2-ef4d-11f0-9d95-42dde27851f2","te-report-prompt.cron.tsx","e4b192e0-ef4b-11f0-b248-42dde27851f2",20,["D",1768177749547],"/**\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\";\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 = new Date().toISOString().split(\"T\")[0];\n\n await email({\n to: notificationEmail,\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",[],[285],{"_104":293,"_96":294,"_154":295,"_156":-5,"_157":139,"_158":296,"_160":22,"_106":297,"_100":32,"_162":298,"_164":299,"_165":22,"_166":-5,"_167":300,"_99":301},"da859e64-ef65-11f0-8c45-42dde27851f2","utils.tsx","da859f36-ef65-11f0-8c45-42dde27851f2",40,["D",1768188118534],"script","/**\n * Shared utilities for Law Student Tracker\n * Contains name matching, normalization, and fuzzy matching functions.\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",[],[294],"files",[151,169,177,186,197,207,218,227,236,246,256,265,274,283,292],"counts",{"_306":32,"_307":192,"_308":32,"_309":310},"pulls","branches","forks","envVars",{"_311":312,"_313":32},"count",5,"emptyCount","contents",[316,319,322,325,328,331,334,337,340,343,346,349,352],{"_104":152,"_96":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":22,"_106":317,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_99":318},["D",1768187412940],[153],{"_104":187,"_96":188,"_154":189,"_156":-5,"_157":139,"_158":190,"_160":22,"_106":320,"_100":192,"_162":193,"_164":194,"_165":22,"_166":-5,"_99":321},["D",1768181713790],[188],{"_104":198,"_96":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_106":323,"_100":32,"_162":203,"_164":204,"_165":22,"_166":-5,"_99":324},["D",1768181381997],[199],{"_104":208,"_96":209,"_154":210,"_156":-5,"_157":139,"_158":211,"_160":22,"_106":326,"_100":213,"_162":214,"_164":215,"_165":22,"_166":-5,"_99":327},["D",1768190075639],[209],{"_104":219,"_96":220,"_154":221,"_156":-5,"_157":139,"_158":222,"_160":22,"_106":329,"_100":192,"_162":203,"_164":224,"_165":22,"_166":-5,"_99":330},["D",1768177749505],[220],{"_104":228,"_96":229,"_154":230,"_156":-5,"_157":139,"_158":231,"_160":22,"_106":332,"_100":213,"_162":214,"_164":233,"_165":22,"_166":-5,"_99":333},["D",1768183324229],[229],{"_104":237,"_96":238,"_154":239,"_156":-5,"_157":139,"_158":240,"_160":22,"_106":335,"_100":242,"_162":203,"_164":243,"_165":22,"_166":-5,"_99":336},["D",1768177843090],[238],{"_104":247,"_96":248,"_154":249,"_156":-5,"_157":139,"_158":250,"_160":22,"_106":338,"_100":252,"_162":214,"_164":253,"_165":22,"_166":-5,"_99":339},["D",1768190075718],[248],{"_104":257,"_96":258,"_154":259,"_156":-5,"_157":139,"_158":101,"_160":22,"_106":341,"_100":261,"_162":214,"_164":262,"_165":22,"_166":-5,"_99":342},["D",1768190075698],[258],{"_104":266,"_96":267,"_154":268,"_156":-5,"_157":139,"_158":269,"_160":22,"_106":344,"_100":242,"_162":203,"_164":271,"_165":22,"_166":-5,"_99":345},["D",1768190075643],[267],{"_104":275,"_96":276,"_154":277,"_156":-5,"_157":139,"_158":278,"_160":22,"_106":347,"_100":192,"_162":214,"_164":280,"_165":22,"_166":-5,"_99":348},["D",1768177749408],[276],{"_104":284,"_96":285,"_154":286,"_156":-5,"_157":139,"_158":287,"_160":22,"_106":350,"_100":192,"_162":203,"_164":289,"_165":22,"_166":-5,"_99":351},["D",1768177749547],[285],{"_104":293,"_96":294,"_154":295,"_156":-5,"_157":139,"_158":296,"_160":22,"_106":353,"_100":32,"_162":298,"_164":299,"_165":22,"_166":-5,"_99":354},["D",1768188118534],[294],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_102":363,"_100":101,"_368":369},{"_104":105,"_96":97,"_106":364,"_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":365,"_133":366,"_136":367,"_148":22},["D",1754054718011],{"_94":95,"_131":132},{"_94":95,"_135":132,"_14":114},{"_100":138,"_96":44,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":97,"_147":95},"changes",[370],{"_193":371,"_373":374,"_165":22,"_99":258,"_376":258},{"_154":259,"_96":258,"_162":214,"_164":262,"_106":372,"_158":101,"_157":139},["D",1768190075698],"previous",{"_154":259,"_96":258,"_162":214,"_164":375},"/**\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 { JWT } from \"npm:google-auth-library\";\nimport { email } from \"https://esm.town/v/std/email\";\n\n// Test sheet ID\nconst SHEET_ID = \"1LxYnsxrimzrYnTbwGn_jAdQrY5pZJj9KeY54ASBaJHM\";\n\nconst TABS = {\n ROSTER: \"T&E Roster\",\n COLD_CALL_LOG: \"Cold Call Log\",\n SELF_REPORTS: \"Form Responses 1\",\n} as const;\n\n// Alert thresholds\nconst ABSENCE_THRESHOLD = 3;\nconst CONCERNING_THRESHOLD = 5;\n\ninterface ColdCallEntry {\n student_name: string;\n result: \"completed\" | \"absent\" | \"refused\";\n performance?: \"great\" | \"normal\" | \"bad\";\n}\n\ninterface 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\nfunction getAuthClient(): JWT {\n const credsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credsJson) {\n throw new Error(\"GOOGLE_APPLICATION_CREDENTIALS env var not set. Configure in Val.town settings.\");\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 * 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 fallback.toISOString().split(\"T\")[0];\n }\n\n console.warn(`parseSheetDate: could not parse \"${trimmed}\"`);\n return null;\n}\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 =\n result === \"absent\" || result === \"refused\" || performance === \"bad\";\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 body = `${student} has reached ${count} ${alertType}.\n\nHistory:\n${history.map((h) => `- ${h}`).join(\"\\n\")}\n\nAction needed: ${action}\n`;\n\n await email({ to, subject, text: body });\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\n const rosterSheet = doc.sheetsByTitle[TABS.ROSTER];\n if (!rosterSheet) {\n return Response.json({ error: \"Roster not found\" }, { 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 const prevConcerning = parseInt(rosterRow.get(\"concerning_events\") || \"0\", 10);\n const newConcerning = prevConcerning + 1;\n rosterRow.set(\"concerning_events\", String(newConcerning));\n\n if (newConcerning === CONCERNING_THRESHOLD && notificationEmail) {\n alerts.push(`${rosterName}: ${CONCERNING_THRESHOLD} concerning events (unprepared)`);\n // Get history from Cold Call Log + current unprepared event\n const history = await getStudentHistory(logSheet, rosterName);\n history.push(`${payload.date}: Self-reported unprepared`);\n await sendAlert(\n notificationEmail,\n rosterName,\n \"concerning\",\n newConcerning,\n history,\n );\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 // 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 roster\n const rosterRow = rosterByName.get(call.student_name);\n if (rosterRow) {\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\n const isConcerning =\n call.result === \"absent\" ||\n call.result === \"refused\" ||\n call.performance === \"bad\";\n\n if (isConcerning) {\n const prevConcerning = parseInt(rosterRow.get(\"concerning_events\") || \"0\", 10);\n const newConcerning = prevConcerning + 1;\n rosterRow.set(\"concerning_events\", String(newConcerning));\n\n if (newConcerning === CONCERNING_THRESHOLD && notificationEmail) {\n alerts.push(`${call.student_name}: ${CONCERNING_THRESHOLD} concerning events`);\n // Current event already logged above, fetch full history\n const history = await getStudentHistory(logSheet, call.student_name);\n await sendAlert(\n notificationEmail,\n call.student_name,\n \"concerning\",\n newConcerning,\n history,\n );\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 if (newAbsences === ABSENCE_THRESHOLD && notificationEmail) {\n alerts.push(`${call.student_name}: ${ABSENCE_THRESHOLD} absences`);\n // Get absence history (rows where result=\"absent\")\n const allHistory = await getStudentHistory(logSheet, call.student_name);\n const absenceHistory = allHistory.filter((h) => h.includes(\"absent\"));\n await sendAlert(\n notificationEmail,\n call.student_name,\n \"absences\",\n newAbsences,\n absenceHistory,\n );\n }\n }\n\n await rosterRow.save();\n }\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 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 if (newAbsences === ABSENCE_THRESHOLD && notificationEmail) {\n alerts.push(`${absentName}: ${ABSENCE_THRESHOLD} absences`);\n // Get past cold-call absences + current general absence\n const allHistory = await getStudentHistory(logSheet, absentName);\n const absenceHistory = allHistory.filter((h) => h.includes(\"absent\"));\n absenceHistory.push(`${payload.date}: Absent (not on call list)`);\n await sendAlert(\n notificationEmail,\n absentName,\n \"absences\",\n newAbsences,\n absenceHistory,\n );\n }\n\n if (newConcerning === CONCERNING_THRESHOLD && notificationEmail) {\n alerts.push(`${absentName}: ${CONCERNING_THRESHOLD} concerning events`);\n // Get full concerning history + current absence\n const history = await getStudentHistory(logSheet, absentName);\n history.push(`${payload.date}: Absent (not on call list)`);\n await sendAlert(\n notificationEmail,\n absentName,\n \"concerning\",\n newConcerning,\n history,\n );\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","latestPath","actionData","errors"]