\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","label",[99],"permalink","https://www.val.town/x/velocity/cron/code/main.ts","extension","actionData","errors"]

Assignment Due Soon!