[{"_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",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":53,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","velocity","name","cron","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","3ae87bf8-f706-11f0-bfec-42dde27851f2","main.ts","fileId","95d6107c-e38b-11f0-a0f8-42dde27851f2","parentId","branchId","95d48662-e38b-11f0-a0f8-42dde27851f2","branchVersion",12,"latest",true,"createdAt",["D",1769026657855],11,"fileType","interval","content","// Canvas Tracker - Notification Cron Job\n// Free: 24h reminder only | Pro: All 6 reminder times\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 \"72_hour\": \"3 days\",\n \"48_hour\": \"2 days\",\n \"24_hour\": \"24 hours\",\n \"12_hour\": \"12 hours\",\n \"6_hour\": \"6 hours\",\n \"1_hour\": \"1 hour\",\n};\n\n// Free users only get 24h reminder\nconst FREE_REMINDER_TYPES = [\"24_hour\"];\n// Pro users get all reminders\nconst PRO_REMINDER_TYPES = [\n \"72_hour\",\n \"48_hour\",\n \"24_hour\",\n \"12_hour\",\n \"6_hour\",\n \"1_hour\",\n];\n\nconst sleep = (ms) => new Promise((resolve) => setTimeout(resolve, ms));\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 const text = await response.text();\n if (!text) return null;\n\n try {\n return JSON.parse(text);\n } catch {\n return null;\n }\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 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, isPro) {\n const timeUntilDue = REMINDER_NAMES[reminder.reminder_type] ||\n reminder.reminder_type;\n\n const proNote = !isPro\n ? `\n

\n ⭐ Upgrade to Pro for reminders at 72h, 48h, 12h, 6h, and 1h before deadlines!\n

\n `\n : \"\";\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 ${proNote}\n

\n \n

\n \n \n `;\n}\n\nexport default async function (interval) {\n console.log(\"🔍 Checking for pending reminders...\");\n\n try {\n const reminders = await supabaseRpc(\"get_pending_reminders\");\n\n console.log(`📋 Found ${reminders.length} pending reminders`);\n\n if (reminders.length === 0) {\n return {\n success: true,\n message: \"No pending reminders\",\n timestamp: new Date().toISOString(),\n };\n }\n\n let emailsSent = 0;\n let skipped = 0;\n let failed = 0;\n\n for (const reminder of reminders) {\n const timeUntilDue = REMINDER_NAMES[reminder.reminder_type];\n const isPro = reminder.is_pro === true;\n\n // Check if user should get this reminder based on their plan\n const allowedReminders = isPro ? PRO_REMINDER_TYPES : FREE_REMINDER_TYPES;\n\n if (!allowedReminders.includes(reminder.reminder_type)) {\n // Skip this reminder for free users, but mark it as sent so we don't check again\n console.log(\n `⏭️ Skipping ${reminder.reminder_type} for free user ${reminder.user_email}`,\n );\n await supabaseRpc(\"mark_reminder_sent\", {\n p_assignment_id: reminder.assignment_id,\n p_reminder_type: reminder.reminder_type,\n });\n skipped++;\n continue;\n }\n\n // Only send if email notifications are enabled\n if (!reminder.notification_email) {\n console.log(\n `⏭️ Skipping \"${reminder.assignment_title}\" - email notifications disabled`,\n );\n await supabaseRpc(\"mark_reminder_sent\", {\n p_assignment_id: reminder.assignment_id,\n p_reminder_type: reminder.reminder_type,\n });\n skipped++;\n continue;\n }\n\n try {\n console.log(\n `📧 Sending ${\n isPro ? \"PRO\" : \"FREE\"\n } ${reminder.reminder_type} email for \"${reminder.assignment_title}\" to ${reminder.user_email}`,\n );\n\n await sendEmail(\n reminder.user_email,\n `⏰ \"${reminder.assignment_title}\" due in ${timeUntilDue}!`,\n generateEmailHtml(reminder, isPro),\n );\n\n emailsSent++;\n console.log(`✅ Email sent!`);\n\n // Mark as sent\n await supabaseRpc(\"mark_reminder_sent\", {\n p_assignment_id: reminder.assignment_id,\n p_reminder_type: reminder.reminder_type,\n });\n console.log(`📝 Marked as sent`);\n } catch (error) {\n console.error(`❌ Failed:`, error.message);\n failed++;\n }\n\n // Wait 600ms between emails to respect rate limit\n await sleep(600);\n }\n\n console.log(\n `\\n📊 Summary: ${emailsSent} emails sent, ${skipped} skipped (free tier), ${failed} failed`,\n );\n\n return {\n success: true,\n emailsSent,\n skipped,\n failed,\n total: reminders.length,\n timestamp: new Date().toISOString(),\n };\n } catch (error) {\n console.error(\"❌ Cron job error:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n };\n }\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1769026657855],"children",[],[35],"95d44e22-e38b-11f0-a0f8-42dde27851f2",["D",1766884910213],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","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",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3R29zaGNPekxzUnIyOHNEWW5SaTRzMWk1UiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1766884910213],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Assignment Due Soon!

Code