Takvim

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_243":244,"_245":246},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",54,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","85f07e0d-f02f-4927-9b94-6558ef12733c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":26,"_40":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":26,"_40":41},"deleted",false,"deletedHere","path","index.html","latestPath","fileId","96b99036-b0fe-11f1-b94d-1607ee4eb77e","name","fileType","content","`\n\n\n\n\nTakvim\n\n\n\n\n

\n \n

\n Düz.Düzenle\n \n \n

\n\n

\n PztSalÇarPerCumCmtPaz\n

\n\n\n\n\n\n\n\n\n\n\n","\n\n\n\n\nTakvim\n\n\n\n\n

\n \n

\n Düz.Düzenle\n \n \n

\n\n

\n PztSalÇarPerCumCmtPaz\n

\n\n\n\n\n\n\n\n\n\n\n","createdAt",["D",1789474295918],"branchVersion","branchId","7cc41e5b-7347-409f-bdd2-d6cabae85cc2","id","b6c508ed-5367-4c80-adf4-89148338dcf2","scheduler",["D",1787102792105],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Aylık takvim todo + mail bildirimleri | SQLite, cron, nodemailer","imageUrl","36451bfa-e5dd-4ea2-8063-aefa91faa516","pinnedFileId","02883800-9b6d-11f1-8f0e-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0178b-157e-745d-828e-eb11a1cff70a","tursoName","b6c508ed53674c80adf489148338dcf2","tursoHostname","b6c508ed53674c80adf489148338dcf2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",78,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","user9823475","handle","displayName","okan akar","avatar","https://lh3.googleusercontent.com/a/ACg8ocKVv87Cs_fECuMIhkwYWxOb1IWIAtks8lzjYrrflQ1fhtYr6A=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":238,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":239,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":240,"_89":241,"_91":242,"_93":31},"tree",[209,210,211,212,213,214,215],"files",[209,210,211,212,213,214,215],"counts",{"_199":68,"_200":173,"_201":68,"_202":203,"_204":205},"contents",[136,137,138,139,140,141,142],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":192,"_38":193,"_36":194,"_146":-5,"_46":47,"_45":195,"_148":31,"_43":196,"_13":173,"_39":26,"_40":197,"_30":31,"_152":-5,"_33":198},{"_48":183,"_38":184,"_36":185,"_146":-5,"_46":47,"_45":186,"_148":31,"_43":187,"_13":188,"_39":189,"_40":190,"_30":31,"_152":-5,"_33":191},{"_48":175,"_38":176,"_36":177,"_146":-5,"_46":47,"_45":178,"_148":31,"_43":179,"_13":180,"_39":150,"_40":181,"_30":31,"_152":-5,"_33":182},{"_48":171,"_38":34,"_36":37,"_146":-5,"_46":47,"_45":14,"_148":31,"_43":172,"_13":173,"_39":26,"_40":42,"_30":31,"_152":-5,"_33":174},{"_48":162,"_38":163,"_36":62,"_146":-5,"_46":47,"_45":164,"_148":31,"_43":165,"_13":166,"_39":167,"_40":168,"_30":31,"_152":169,"_33":170},{"_48":154,"_38":155,"_36":156,"_146":-5,"_46":47,"_45":157,"_148":31,"_43":158,"_13":159,"_39":150,"_40":160,"_30":31,"_152":-5,"_33":161},{"_48":143,"_38":144,"_36":145,"_146":-5,"_46":47,"_45":147,"_148":31,"_43":149,"_13":68,"_39":150,"_40":151,"_30":31,"_152":-5,"_33":153},"df1fd52e-57fa-4c5f-bfac-aca6c22e8ee7","time.ts","78e945ce-b0fe-11f1-900b-1607ee4eb77e","parentId",50,"latest",["D",1789474242182],"script","/**\n * Timezone helpers. All scheduling / \"today\" logic runs on Europe/Berlin.\n * Dates are plain \"YYYY-MM-DD\" strings computed in the Berlin timezone.\n */\n\nexport const TZ = \"Europe/Berlin\";\n\n/** Today's date in Berlin as \"YYYY-MM-DD\". */\nexport function todayStr(d: Date = new Date()): string {\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: TZ,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(d);\n}\n\n/** Current HH:MM in Berlin (24h). */\nexport function nowHM(d: Date = new Date()): string {\n const parts = new Intl.DateTimeFormat(\"en-GB\", {\n timeZone: TZ,\n hour: \"2-digit\",\n minute: \"2-digit\",\n hourCycle: \"h23\",\n }).formatToParts(d);\n const get = (t: string) => parts.find((p) => p.type === t)!.value.padStart(2, \"0\");\n return `${get(\"hour\")}:${get(\"minute\")}`;\n}\n\n/** Current year and month (1-12) in Berlin. */\nexport function currentMonth(): { y: number; m: number } {\n const p = new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: TZ,\n year: \"numeric\",\n month: \"numeric\",\n }).formatToParts(new Date());\n const get = (t: string) => Number(partsGet(p, t));\n return { y: get(\"year\"), m: get(\"month\") };\n}\n\n/**\n * Add n days to a \"YYYY-MM-DD\" string. Pure date arithmetic via UTC so the\n * wall-clock date is unchanged across DST boundaries.\n */\nexport function addDays(dateStr: string, n: number): string {\n const [y, m, d] = dateStr.split(\"-\").map(Number);\n const dt = new Date(Date.UTC(y, m - 1, d + n));\n return dt.toISOString().slice(0, 10);\n}\n\nfunction partsGet(parts: Intl.DateTimeFormatPart[], t: string): string {\n return parts.find((p) => p.type === t)?.value ?? \"\";\n}\n","label",[144],"f91bffe7-081d-43e8-b3cb-7a580a764039","run.ts","c25bf25a-9b6f-11f1-b373-1607ee4eb77e",49,["D",1789474242125],11,"import nodemailer from \"npm:nodemailer\";\n\n/** Recipient for reminder emails. */\nexport const TO = \"akarokan.97@gmail.com\";\n\nconst transporter = nodemailer.createTransport({\n service: \"gmail\",\n auth: {\n user: Deno.env.get(\"GMAIL_USER\"),\n pass: Deno.env.get(\"GMAIL_PASS\"),\n },\n});\n\n/**\n * Send an email via Gmail SMTP to the recipient in `TO`.\n * Requires GMAIL_USER / GMAIL_PASS env vars (app password for Gmail).\n */\nexport async function sendMail(\n opts: { subject: string; text: string },\n): Promise {\n await transporter.sendMail({\n from: Deno.env.get(\"GMAIL_USER\"),\n to: TO,\n subject: opts.subject,\n text: opts.text,\n });\n}\n",[155],"78e32065-d2b5-497a-9cc7-088445fc3e26","main.ts",52,["D",1789474269215],15,"http","import { Hono } from \"npm:hono\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport * as db from \"./db.ts\";\n\nconst SECRET = Deno.env.get(\"APP_SECRET\");\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nconst DATE_RE = /^\\d{4}-\\d{2}-\\d{2}$/;\n\n/** Constant-time check; fails closed when APP_SECRET is unset. */\nfunction authorized(secretQuery: string | null): boolean {\n if (!SECRET) return false;\n if (!secretQuery || secretQuery.length !== SECRET.length) return false;\n let diff = 0;\n for (let i = 0; i < SECRET.length; i++) diff |= secretQuery.charCodeAt(i) ^ SECRET.charCodeAt(i);\n return diff === 0;\n}\n\n// --------------------------- pages ---------------------------\n\napp.get(\"/\", async (c) => {\n if (!authorized(c.req.query(\"s\"))) return c.text(\"Unauthorized\", 401);\n const html = await readFile(\"/index.html\");\n return c.html(html);\n});\n\napp.get(\"/app.js\", async (c) => {\n const js = await readFile(\"/app.js\");\n return new Response(js, { headers: { \"content-type\": \"text/javascript; charset=utf-8\" } });\n});\n\n// --------------------------- api ---------------------------\n\nconst requireAuth = async (c: Parameters[\"0\"] extends never ? never : any): Promise => {\n if (!authorized(c.req.query(\"s\"))) {\n c.status(401);\n return false;\n }\n return true;\n};\n\napp.get(\"/api/tasks\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n return c.json(await db.listTasksAll());\n});\n\napp.get(\"/api/settings\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n return c.json({ times: await db.getSettingsTimes() });\n});\n\napp.post(\"/api/settings\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const b = (await c.req.json()) as { times?: string[] };\n const times = (b.times ?? []).filter((x) => DATE_RE.test(x) === false && /^\\d{2}:\\d{2}$/.test(x));\n await db.setSettingsTimes(times);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/tasks\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const b = (await c.req.json()) as { date?: string; text?: string };\n const date = String(b.date ?? \"\");\n const text = String(b.text ?? \"\").trim();\n if (!DATE_RE.test(date) || !text) return c.json({ error: \"Bad request\" }, 400);\n const id = await db.insertTask({ date, text });\n return c.json({ id });\n});\n\napp.post(\"/api/tasks/:id/toggle\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"Bad request\" }, 400);\n await db.toggleTask(id);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/tasks/:id/update\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"Bad request\" }, 400);\n const b = (await c.req.json()) as { text?: string; red_enabled?: number; date?: string };\n const text = typeof b.text === \"string\" ? b.text.trim() : undefined;\n const red = typeof b.red_enabled === \"number\" ? (b.red_enabled ? 1 : 0) : undefined;\n\n if (typeof b.date === \"string\" && DATE_RE.test(b.date)) {\n const t = await db.getTask(id);\n if (t && t.date !== b.date) {\n await db.moveTaskToDate(id, b.date, { text, red_enabled: red });\n return c.json({ ok: true });\n }\n }\n await db.updateTaskInPlace(id, { text, red_enabled: red });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/tasks/:id/position\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"Bad request\" }, 400);\n const b = (await c.req.json()) as { position?: number };\n if (typeof b.position !== \"number\") return c.json({ error: \"Bad request\" }, 400);\n await db.updateTaskInPlace(id, { position: b.position });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/day/:date/move\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const date = c.req.param(\"date\");\n if (!DATE_RE.test(date)) return c.json({ error: \"Bad request\" }, 400);\n return c.json(await db.moveDayForward(date));\n});\n\napp.post(\"/api/undo\", async (c) => {\n if (!(await requireAuth(c))) return c.json({ error: \"Unauthorized\" }, 401);\n const ok = await db.undoLastMove();\n return c.json({ ok });\n});\n\nexport default app.fetch;\n","task-scheduler",[163],"92795b78-a09f-45d3-82d4-e510b5dfa921",["D",1789474295918],1,[34],"9b5babc2-6d02-4857-93dd-0c5403ea2029","db.ts","36a8cd0c-9b6d-11f1-aee4-1607ee4eb77e",51,["D",1789474258547],3,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { addDays } from \"./time.ts\";\n\nexport type TaskStatus = \"open\" | \"done\" | \"moved\";\n\nexport interface Task {\n id: number;\n date: string; // YYYY-MM-DD (Berlin)\n text: string;\n position: number;\n status: TaskStatus;\n moved_to_id: number | null;\n moved_from_id: number | null;\n red_enabled: number; // 1 | 0\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS tasks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n text TEXT NOT NULL,\n position INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'open',\n moved_to_id INTEGER,\n moved_from_id INTEGER,\n red_enabled INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS email_sent (\n day TEXT NOT NULL,\n time TEXT NOT NULL,\n PRIMARY KEY (day, time)\n)`);\n\nconst CREATE_TASK_SQL =\n `INSERT INTO tasks (date, text, position, status, moved_to_id, moved_from_id, red_enabled, created_at)\n VALUES (?, ?, ?, 'open', NULL, NULL, ?, ?)`;\n\nexport async function getTask(id: number): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE id = ?\",\n args: [id],\n });\n return res.rows[0] as Task | undefined;\n}\n\nexport async function listTasksAll(): Promise {\n const res = await sqlite.execute(\"SELECT * FROM tasks ORDER BY date, position, id\");\n return res.rows as Task[];\n}\n\nexport async function insertTask(p: {\n date: string;\n text: string;\n red_enabled?: number;\n position?: number;\n}): Promise {\n const cnt = await sqlite.execute({\n sql: \"SELECT COUNT(*) AS c FROM tasks WHERE date = ?\",\n args: [p.date],\n });\n const c = Number((cnt.rows[0] as { c: number }).c ?? 0);\n const pos = p.position ?? c + 1;\n const res = await sqlite.execute({\n sql: CREATE_TASK_SQL,\n args: [p.date, p.text, pos, p.red_enabled ?? 1, new Date().toISOString()],\n });\n return Number(res.lastInsertRowid);\n}\n\n/** Flip a task between done and open. */\nexport async function toggleTask(id: number): Promise {\n const t = await getTask(id);\n if (!t) return;\n const ns: TaskStatus = t.status === \"done\" ? \"open\" : \"done\";\n await sqlite.execute({\n sql: \"UPDATE tasks SET status = ? WHERE id = ?\",\n args: [ns, id],\n });\n}\n\n/** Update text / red_enabled / position in place (no status change). */\nexport async function updateTaskInPlace(\n id: number,\n patch: { text?: string; red_enabled?: number; position?: number },\n): Promise {\n const sets: string[] = [];\n const args: (string | number)[] = [];\n if (patch.text !== undefined) {\n sets.push(\"text = ?\");\n args.push(patch.text);\n }\n if (patch.red_enabled !== undefined) {\n sets.push(\"red_enabled = ?\");\n args.push(patch.red_enabled);\n }\n if (patch.position !== undefined) {\n sets.push(\"position = ?\");\n args.push(patch.position);\n }\n if (!sets.length) return;\n args.push(id);\n await sqlite.execute({ sql: `UPDATE tasks SET ${sets.join(\", \")} WHERE id = ?`, args });\n}\n\n/**\n * Move a single task to another date: the original becomes `moved` (strike-out),\n * a fresh open copy is created on the new date. text/red overrides (optional)\n * are then applied to the copy.\n */\nexport async function moveTaskToDate(\n id: number,\n newDate: string,\n overrides: { text?: string; red_enabled?: number } = {},\n): Promise {\n const t = await getTask(id);\n if (!t || t.date === newDate) return;\n const copyId = await insertTask({\n date: newDate,\n text: overrides.text ?? t.text,\n red_enabled: overrides.red_enabled ?? t.red_enabled,\n });\n await sqlite.execute({\n sql: \"UPDATE tasks SET moved_from_id = ? WHERE id = ?\",\n args: [id, copyId],\n });\n await sqlite.execute({\n sql: \"UPDATE tasks SET status = 'moved', moved_to_id = ? WHERE id = ?\",\n args: [copyId, id],\n });\n}\n\nexport interface MovePair {\n orig: number;\n copy: number;\n}\n\nexport interface MoveRecord {\n from_date: string;\n to_date: string;\n pairs: MovePair[];\n}\n\nasync function saveLastMove(m: MoveRecord): Promise {\n await sqlite.execute({ sql: \"DELETE FROM settings WHERE key = ?\", args: [\"last_move\"] });\n await sqlite.execute({\n sql: \"INSERT INTO settings (key, value) VALUES (?, ?)\",\n args: [\"last_move\", JSON.stringify(m)],\n });\n}\n\nasync function getLastMove(): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT value FROM settings WHERE key = ?\",\n args: [\"last_move\"],\n });\n const row = res.rows[0] as { value: string } | undefined;\n if (!row) return null;\n try {\n const v = JSON.parse(row.value);\n if (v && Array.isArray(v.pairs)) return v;\n } catch {\n /* ignore */\n }\n return null;\n}\n\n/**\n * \"Kalanları sonraki güne aktar\": copy every open task on `date` to\n * date+1, mark the originals moved. Records the batch for undo.\n */\nexport async function moveDayForward(date: string): Promise<{\n ok: boolean;\n count: number;\n to_date: string;\n}> {\n const all = await listTasksAll();\n const open = all\n .filter((t) => t.date === date && t.status === \"open\")\n .sort((a, b) => a.position - b.position || a.id - b.id);\n if (!open.length) return { ok: false, count: 0, to_date: addDays(date, 1) };\n\n const next = addDays(date, 1);\n const pairs: MovePair[] = [];\n for (const t of open) {\n const copyId = await insertTask({ date: next, text: t.text, red_enabled: t.red_enabled });\n await sqlite.execute({\n sql: \"UPDATE tasks SET moved_from_id = ? WHERE id = ?\",\n args: [t.id, copyId],\n });\n await sqlite.execute({\n sql: \"UPDATE tasks SET status = 'moved', moved_to_id = ? WHERE id = ?\",\n args: [copyId, t.id],\n });\n pairs.push({ orig: t.id, copy: copyId });\n }\n await saveLastMove({ from_date: date, to_date: next, pairs });\n return { ok: true, count: pairs.length, to_date: next };\n}\n\n/** Undo the last move-forward: delete the copies, restore originals to open. */\nexport async function undoLastMove(): Promise {\n const m = await getLastMove();\n if (!m) return false;\n for (const p of m.pairs) {\n await sqlite.execute({ sql: \"DELETE FROM tasks WHERE id = ?\", args: [p.copy] });\n await sqlite.execute({\n sql: \"UPDATE tasks SET status = 'open', moved_to_id = NULL WHERE id = ?\",\n args: [p.orig],\n });\n }\n await sqlite.execute({ sql: \"DELETE FROM settings WHERE key = ?\", args: [\"last_move\"] });\n return true;\n}\n\n/* ----------------------------- settings ----------------------------- */\n\nconst DEFAULT_TIMES = [\"09:00\", \"14:00\", \"21:00\"];\n\nexport async function getSettingsTimes(): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT value FROM settings WHERE key = ?\",\n args: [\"notify_times\"],\n });\n const row = res.rows[0] as { value: string } | undefined;\n if (!row) return [...DEFAULT_TIMES];\n try {\n const v = JSON.parse(row.value);\n if (Array.isArray(v) && v.length) return v.filter((x) => typeof x === \"string\" && /^\\d{2}:\\d{2}$/.test(x));\n } catch {\n /* ignore */\n }\n return [...DEFAULT_TIMES];\n}\n\nexport async function setSettingsTimes(times: string[]): Promise {\n const clean = times.length ? times : [DEFAULT_TIMES[0]];\n await sqlite.execute({ sql: \"DELETE FROM settings WHERE key = ?\", args: [\"notify_times\"] });\n await sqlite.execute({\n sql: \"INSERT INTO settings (key, value) VALUES (?, ?)\",\n args: [\"notify_times\", JSON.stringify(clean)],\n });\n}\n\n/* --------------------------- email dedupe ---------------------------- */\n\nexport async function emailSent(day: string, time: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT 1 AS x FROM email_sent WHERE day = ? AND time = ?\",\n args: [day, time],\n });\n return !!res.rows[0];\n}\n\nexport async function markEmail(day: string, time: string): Promise {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO email_sent (day, time) VALUES (?, ?)\",\n args: [day, time],\n });\n}\n",[176],"29b913f9-bedc-4ff5-b36e-a6e3b4dcfeca","cron.ts","36ba2304-9b6d-11f1-aee4-1607ee4eb77e",34,["D",1787105129031],6,"interval","import { getDueTasks, updateTask } from \"./db.ts\";\nimport { executeTask, sendMail } from \"./run.ts\";\n\nconst DAY = 24 * 60 * 60 * 1000;\n\n/** Compute the next run_at for a repeating task, or null if it's a one-off. */\nexport function nextRunAt(repeat: string, now: Date): string | null {\n if (repeat === \"daily\") return new Date(now.getTime() + DAY).toISOString();\n if (repeat === \"weekly\") return new Date(now.getTime() + 7 * DAY).toISOString();\n return null;\n}\n\nexport default async function (interval: Interval) {\n const due = await getDueTasks();\n for (const row of due) {\n const now = new Date();\n const result = await executeTask(row);\n if (result.ok) {\n const next = nextRunAt(row.repeat, now);\n await updateTask(row.id, next ? \"pending\" : \"done\", next ?? row.run_at);\n } else {\n console.error(\"Task failed:\", row.id, result.error);\n await updateTask(row.id, \"error\", row.run_at);\n try {\n await sendMail({\n subject: \"Scheduled task failed\",\n text:\n `Scheduled task #${row.id} (\"${row.task}\") failed:\\n\\n` +\n result.error,\n });\n } catch (emailErr) {\n console.error(\"Failed to send failure email:\", emailErr);\n }\n }\n }\n}\n",[184],"f7f640a0-5b11-4b6c-8cf0-607f55b94c93","README.md","6ba67bc6-9b6d-11f1-acc3-1607ee4eb77e",26,["D",1787103600307],"# Task Scheduler\n\nAn LLM-powered task scheduler on Val Town. Type a plain-language instruction; it's parsed by OpenAI into a scheduled task, stored in SQLite, and executed by a every-minute cron that delivers the result by email or as a hosted page.\n\nLive at **https://task-scheduler.val.run/**\n\n## How it works\n\n```\n/?t=... ──► LLM parses into {\"run_at\",\"repeat\",\"task\",\"output\"} ──► SQLite `tasks`\n ──► cron (every minute)\n ├─ mail → generate text → std/email\n └─ page → cards JSON → blob → email link → /s/{key}\n```\n\n### 1. Database (`db.ts`)\nSQLite table `tasks`:\n`id`, `run_at` (ISO timestamp), `repeat` (`none`/`daily`/`weekly`), `task`, `output` (`mail`/`page`), `status` (`pending`/`done`/`error`).\n\n### 2. HTTP endpoint (`main.ts`)\n- `GET /?t=` — parses the instruction with OpenAI (`std/openai`, model `gpt-5.4-nano`, using `max_completion_tokens`). The current UTC time is passed into the prompt so \"in 5 minutes\" / \"tomorrow at 8am\" resolve correctly. `output` is `page` when the instruction mentions a site/page/link (or is visual), else `mail`. Inserts the task and returns a confirmation page.\n- `GET /s/{key}` — serves a saved page.\n\n### 3. Cron (`cron.ts`)\nRuns every minute (`* * * * *` UTC). Finds `status = pending AND run_at <= now`. For each:\n- `mail` → generate content with OpenAI, send via `std/email`.\n- `page` → generate `{\"cards\":[{title,type:\"list\"|\"text\",content:[...]}]}`, embed into the self-contained page template, store under a random blob key, email only the `/s/{key}` link.\n- Then mark `done`, or compute the next `run_at` if it repeats daily/weekly.\n- On any failure: mark `error` and email the message.\n- Email subjects are LLM-generated as three pipe-separated parts, e.g. `To do list | Scheduled for 19.08 03:36 | Val` — the LLM phrases the middle schedule note per task (date/time for one-offs, \"Daily at 8am\" / \"Every Monday\" for recurring).\n\n## Page design (`page.html`)\nVertical list of cards. Clicking a card expands/collapses it. `list` cards render one checkbox per item — checked items show strikethrough, persisted in `localStorage` per card. Clicking anywhere on a checklist row toggles that item's checkbox; checkboxes are custom-styled to match the dark theme (accent fill + white check when checked).\n\n## Files\n| File | Type | Purpose |\n| --- | --- | --- |\n| `main.ts` | http | Title/parse endpoint + `/s/{key}` page server |\n| `db.ts` | script | SQLite helpers |\n| `llm.ts` | script | OpenAI helpers (parse task, generate mail/page content) |\n| `cron.ts` | interval | Every-minute scheduler |\n| `page.html` | file | Card page template |\n| `README.md` | file | This doc |\n\n## Usage\n```text\n/?t=remind me in 5 minutes to drink water\n/?t=daily at 8am send me a weather summary\n/?t=every week make a page with a checklist for my project kickoff\n```\n\n## Setup\nNo environment variables required — `std/openai` and `std/email` use Val Town's built-in credentials (the `valtown` token is injected automatically). Just remix or deploy the val.\n",[193],"pulls","branches","forks","envVars",{"_206":180,"_208":68},"connections",{"_206":68,"_207":68},"count","unfilledCount","emptyCount",{"_48":192,"_38":193,"_36":194,"_146":-5,"_46":47,"_45":195,"_148":31,"_43":235,"_13":173,"_39":26,"_40":197,"_30":31,"_152":-5,"_217":236,"_33":237},{"_48":183,"_38":184,"_36":185,"_146":-5,"_46":47,"_45":186,"_148":31,"_43":232,"_13":188,"_39":189,"_40":190,"_30":31,"_152":-5,"_217":233,"_33":234},{"_48":175,"_38":176,"_36":177,"_146":-5,"_46":47,"_45":178,"_148":31,"_43":229,"_13":180,"_39":150,"_40":181,"_30":31,"_152":-5,"_217":230,"_33":231},{"_48":171,"_38":34,"_36":37,"_146":-5,"_46":47,"_45":14,"_148":31,"_43":226,"_13":173,"_39":26,"_40":42,"_30":31,"_152":-5,"_217":227,"_33":228},{"_48":162,"_38":163,"_36":62,"_146":-5,"_46":47,"_45":164,"_148":31,"_43":223,"_13":166,"_39":167,"_40":168,"_30":31,"_152":169,"_217":224,"_33":225},{"_48":154,"_38":155,"_36":156,"_146":-5,"_46":47,"_45":157,"_148":31,"_43":220,"_13":159,"_39":150,"_40":160,"_30":31,"_152":-5,"_217":221,"_33":222},{"_48":143,"_38":144,"_36":145,"_146":-5,"_46":47,"_45":147,"_148":31,"_43":216,"_13":68,"_39":150,"_40":151,"_30":31,"_152":-5,"_217":218,"_33":219},["D",1789474242182],"children",[],[144],["D",1789474242125],[],[155],["D",1789474269215],[],[163],["D",1789474295918],[],[34],["D",1789474258547],[],[176],["D",1787105129031],[],[184],["D",1787103600307],[],[193],["D",1787102792105],["D",1789534231467],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":276,"_277":278,"_279":280,"_281":31,"_282":31,"_283":31,"_284":64,"_285":-5,"_286":-7,"_287":-7,"_288":68,"_289":31,"_290":31,"_291":-5,"_292":31,"_293":31,"_294":31,"_295":-5},"ENV",{"_247":248,"_249":250,"_251":95,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Bildirim saatleri

Bildirim saatleri

Diff · v54