[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","95d6107c-e38b-11f0-a0f8-42dde27851f2","name","fileType","http","content","// Canvas Tracker - Notification Cron Job\n// Deploy this to Val.town as a scheduled HTTP endpoint\n// Set schedule to run every 15 minutes\n\nconst SUPABASE_URL = \"https://kecogkbhsnvumglmwrhj.supabase.co\";\nconst SUPABASE_SERVICE_KEY =\n \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImtlY29na2Joc252dW1nbG13cmhqIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc2Njg1NTk3MSwiZXhwIjoyMDgyNDMxOTcxfQ.hvzpDMicZX5SeVtJ3i7NBx4yKFrnUIrGfnsbxqY3WMI\";\nconst RESEND_API_KEY = \"re_R11URwPu_MSSBDMFa6dHRFiUkkr7sN7jz\";\n\nconst REMINDER_NAMES = {\n \"24_hour\": \"24 hours\",\n \"3_hour\": \"3 hours\",\n \"1_hour\": \"1 hour\",\n};\n\nasync function supabaseRpc(functionName, params = {}) {\n const response = await fetch(`${SUPABASE_URL}/rest/v1/rpc/${functionName}`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"apikey\": SUPABASE_SERVICE_KEY,\n \"Authorization\": `Bearer ${SUPABASE_SERVICE_KEY}`,\n },\n body: JSON.stringify(params),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Supabase RPC error: ${error}`);\n }\n\n return response.json();\n}\n\nasync function sendEmail(to, subject, html) {\n const response = await fetch(\"https://api.resend.com/emails\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${RESEND_API_KEY}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n from: \"Canvas Tracker \",\n to: [to],\n subject: subject,\n html: html,\n }),\n });\n\n const result = await response.json();\n\n if (!response.ok) {\n console.error(\"Email failed:\", result);\n throw new Error(result.message || \"Failed to send email\");\n }\n\n return result;\n}\n\nfunction formatDueDate(dueDate) {\n const date = new Date(dueDate);\n return date.toLocaleString(\"en-US\", {\n weekday: \"short\",\n month: \"short\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n hour12: true,\n });\n}\n\nfunction generateEmailHtml(reminder) {\n const timeUntilDue = REMINDER_NAMES[reminder.reminder_type] ||\n reminder.reminder_type;\n\n return `\n \n \n \n \n \n \n

\n \n

Hey! You have an assignment due in ${timeUntilDue}:

\n \n

${reminder.assignment_title}

📚 ${reminder.course_name}

📅 Due: ${\n formatDueDate(reminder.due_date)\n }

\n ${\n reminder.canvas_url\n ? `
Open in Canvas →`\n : \"\"\n }\n

\n \n

Don't forget to submit on time! You've got this! 💪

\n \n

\n \n \n `;\n}\n\nexport default async function handler(req) {\n console.log(\"🔍 Checking for pending reminders...\");\n\n try {\n // Get all pending reminders from database\n const reminders = await supabaseRpc(\"get_pending_reminders\");\n\n console.log(`📋 Found ${reminders.length} pending reminders`);\n\n let sent = 0;\n let failed = 0;\n const details = [];\n\n for (const reminder of reminders) {\n const timeUntilDue = REMINDER_NAMES[reminder.reminder_type];\n\n try {\n console.log(\n `📧 Sending ${timeUntilDue} reminder for \"${reminder.assignment_title}\" to ${reminder.user_email}`,\n );\n\n // Send email\n await sendEmail(\n reminder.user_email,\n `⏰ \"${reminder.assignment_title}\" due in ${timeUntilDue}!`,\n generateEmailHtml(reminder),\n );\n\n // Mark as sent in database\n await supabaseRpc(\"mark_reminder_sent\", {\n p_assignment_id: reminder.assignment_id,\n p_reminder_type: reminder.reminder_type,\n });\n\n console.log(`✅ Sent successfully!`);\n sent++;\n details.push({ assignment: reminder.assignment_title, status: \"sent\" });\n } catch (error) {\n console.error(`❌ Failed:`, error.message);\n failed++;\n details.push({\n assignment: reminder.assignment_title,\n status: \"failed\",\n error: error.message,\n });\n }\n\n // Small delay between emails\n await new Promise((resolve) => setTimeout(resolve, 200));\n }\n\n console.log(`\\n📊 Summary: ${sent} sent, ${failed} failed`);\n\n return Response.json({\n success: true,\n sent,\n failed,\n total: reminders.length,\n details,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"❌ Cron job error:\", error);\n return Response.json({\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n }, { status: 500 });\n }\n}","script","createdAt",["D",1766885057548],"branchVersion","branchId","95d48662-e38b-11f0-a0f8-42dde27851f2","id","95d44e22-e38b-11f0-a0f8-42dde27851f2","cron",["D",1766884910213],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019b4ded-bd08-71b9-8d9c-c95cd2f73a6a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b4ded-bd09-700e-8b9f-ff48e1433587","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","velocity","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3R29zaGNPekxzUnIyOHNEWW5SaTRzMWk1UiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":149,"_78":150,"_80":151,"_82":25},"tree",[143],"files",[143],"counts",{"_132":60,"_133":134,"_135":60,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":37,"_35":36,"_24":25,"_130":-5,"_27":131},"eda6ac3a-e38b-11f0-8bb5-42dde27851f2","parentId","latest",["D",1766885057548],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":60,"_142":60},"connections",{"_140":60,"_141":60},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":144,"_13":129,"_33":37,"_35":36,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1766885057548],"children",[],[28],["D",1766884910213],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":194,"_195":-5,"_196":-7,"_197":-7,"_198":60,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Assignment Due Soon!

Diff · v4