[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","user9823475","name","scheduler","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/user9823475/scheduler/code/db.ts","extension","id","61ea9eb7-604c-4682-a8ff-4f1f2da9d991","fileId","36a8cd0c-9b6d-11f1-aee4-1607ee4eb77e","parentId","branchId","7cc41e5b-7347-409f-bdd2-d6cabae85cc2","branchVersion",70,"latest",true,"createdAt",["D",1789475135180],"version",4,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { addDays } from \"./time.ts\";\n\n// Eski zamanlayıcının \"tasks\" tablosuyla çakışmasın diye yeni adlar kullanılıyor.\nexport type Status = \"open\" | \"done\" | \"moved\";\nexport interface Task {\n id: number;\n date: string;\n text: string;\n position: number;\n status: Status;\n moved_to_id: number | null;\n moved_from_id: number | null;\n red_enabled: number;\n}\nexport interface MovePair {\n orig: number;\n copy: number;\n prev: Status;\n}\nexport interface LastMove {\n from_date: string;\n to_date: string;\n pairs: MovePair[];\n}\n\n// std/sqlite satırları dizi olarak da dönebilir; ikisini de nesneye çevir.\nfunction toObjects(res: any): any[] {\n const cols: string[] = res.columns ?? [];\n return (res.rows ?? []).map((r: any) =>\n Array.isArray(r) ? Object.fromEntries(cols.map((c, i) => [c, r[i]])) : r\n );\n}\nasync function q(sql: string, args: unknown[] = []): Promise {\n return toObjects(await sqlite.execute({ sql, args: args as any[] }));\n}\nasync function run(sql: string, args: unknown[] = []) {\n return await sqlite.execute({ sql, args: args as any[] });\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS todo_items (\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)`);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS todo_settings (key TEXT PRIMARY KEY, value TEXT)`,\n);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS todo_sent (\n day TEXT NOT NULL, time TEXT NOT NULL, PRIMARY KEY (day, time)\n)`);\n\nfunction norm(r: any): Task {\n return {\n id: Number(r.id),\n date: String(r.date),\n text: String(r.text),\n position: Number(r.position),\n status: r.status as Status,\n moved_to_id: r.moved_to_id == null ? null : Number(r.moved_to_id),\n moved_from_id: r.moved_from_id == null ? null : Number(r.moved_from_id),\n red_enabled: Number(r.red_enabled),\n };\n}\n\n/* ------------------------------ görevler ------------------------------ */\n\nexport async function listTasks(): Promise {\n return (await q(\"SELECT * FROM todo_items ORDER BY date, position, id\")).map(\n norm,\n );\n}\n\nexport async function getTask(id: number): Promise {\n const r = await q(\"SELECT * FROM todo_items WHERE id = ?\", [id]);\n return r[0] ? norm(r[0]) : null;\n}\n\nasync function nextPos(date: string): Promise {\n const r = await q(\n \"SELECT COALESCE(MAX(position), 0) AS p FROM todo_items WHERE date = ?\",\n [date],\n );\n return Number(r[0]?.p ?? 0) + 1;\n}\n\nasync function insert(\n date: string,\n text: string,\n red: number,\n status: Status = \"open\",\n fromId: number | null = null,\n): Promise {\n const res = await run(\n `INSERT INTO todo_items (date, text, position, status, moved_from_id, red_enabled, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n date,\n text,\n await nextPos(date),\n status,\n fromId,\n red,\n new Date().toISOString(),\n ],\n );\n return Number(res.lastInsertRowid);\n}\n\nexport async function addTasks(date: string, texts: string[]): Promise {\n for (const t of texts) await insert(date, t, 1);\n}\n\nexport async function toggle(id: number): Promise {\n const t = await getTask(id);\n if (!t || t.status === \"moved\") return;\n await run(\"UPDATE todo_items SET status = ? WHERE id = ?\", [\n t.status === \"done\" ? \"open\" : \"done\",\n id,\n ]);\n}\n\nexport async function updateInPlace(\n id: number,\n p: { text?: string; red_enabled?: number },\n) {\n const t = await getTask(id);\n if (!t || t.status === \"moved\") return;\n await run(\"UPDATE todo_items SET text = ?, red_enabled = ? WHERE id = ?\", [\n p.text || t.text,\n p.red_enabled ?? t.red_enabled,\n id,\n ]);\n}\n\nexport async function reorder(ids: number[]): Promise {\n for (let i = 0; i < ids.length; i++) {\n await run(\"UPDATE todo_items SET position = ? WHERE id = ?\", [\n i + 1,\n ids[i],\n ]);\n }\n}\n\n// Kopyayı yeni güne aç, orijinalin üstünü çiz.\nasync function copyTo(\n t: Task,\n date: string,\n text: string,\n red: number,\n status: Status,\n): Promise {\n const copy = await insert(date, text, red, status, t.id);\n await run(\n \"UPDATE todo_items SET status = 'moved', moved_to_id = ? WHERE id = ?\",\n [copy, t.id],\n );\n return { orig: t.id, copy, prev: t.status };\n}\n\n/** \"Kalanları sonraki güne aktar\": sadece açık görevler, bir gün ileri. */\nexport async function moveDay(date: string): Promise {\n const open = (await listTasks()).filter((t) =>\n t.date === date && t.status === \"open\"\n );\n if (!open.length) return 0;\n const to = addDays(date, 1);\n const pairs: MovePair[] = [];\n for (const t of open) {\n pairs.push(await copyTo(t, to, t.text, t.red_enabled, \"open\"));\n }\n await setLastMove({ from_date: date, to_date: to, pairs });\n return pairs.length;\n}\n\n/** Düzenleme ekranından tek görevi başka bir tarihe taşı. */\nexport async function moveOne(\n id: number,\n date: string,\n p: { text?: string; red_enabled?: number },\n) {\n const t = await getTask(id);\n if (!t || t.status === \"moved\" || t.date === date) return;\n const pair = await copyTo(\n t,\n date,\n p.text || t.text,\n p.red_enabled ?? t.red_enabled,\n t.status,\n );\n await setLastMove({ from_date: t.date, to_date: date, pairs: [pair] });\n}\n\n/** Son aktarmayı geri al. Kopya sonradan tekrar taşındıysa geri almaz. */\nexport async function undo(): Promise {\n const m = await getLastMove();\n if (!m) return false;\n for (const p of m.pairs) {\n const c = await getTask(p.copy);\n if (c && c.status === \"moved\") return false;\n }\n for (const p of m.pairs) {\n await run(\"DELETE FROM todo_items WHERE id = ?\", [p.copy]);\n await run(\n \"UPDATE todo_items SET status = ?, moved_to_id = NULL WHERE id = ?\",\n [p.prev, p.orig],\n );\n }\n await run(\"DELETE FROM todo_settings WHERE key = 'last_move'\");\n return true;\n}\n\n/* ------------------------------ ayarlar ------------------------------ */\n\nasync function getSetting(key: string): Promise {\n const r = await q(\"SELECT value FROM todo_settings WHERE key = ?\", [key]);\n if (!r[0]) return null;\n try {\n return JSON.parse(String(r[0].value));\n } catch {\n return null;\n }\n}\nasync function setSetting(key: string, value: unknown) {\n await run(\n `INSERT INTO todo_settings (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n [key, JSON.stringify(value)],\n );\n}\n\nexport async function getLastMove(): Promise {\n const v = await getSetting(\"last_move\");\n return v && Array.isArray(v.pairs) ? v : null;\n}\nasync function setLastMove(m: LastMove) {\n await setSetting(\"last_move\", m);\n}\n\nconst DEFAULT_TIMES = [\"09:00\", \"14:00\", \"21:00\"];\nconst TIME_RE = /^([01]\\d|2[0-3]):[0-5]\\d$/;\n\nexport async function getTimes(): Promise {\n const v = await getSetting(\"notify_times\");\n const ok = Array.isArray(v) ? v.filter((x) => TIME_RE.test(x)) : [];\n return ok.length ? ok : [...DEFAULT_TIMES];\n}\nexport async function setTimes(times: string[]) {\n const clean = [...new Set(times.filter((x) => TIME_RE.test(x)))].sort();\n await setSetting(\"notify_times\", clean.length ? clean : DEFAULT_TIMES);\n}\n\n/* ---------------------------- mail kayıtları ---------------------------- */\n\nexport async function wasSent(day: string, time: string): Promise {\n return (await q(\"SELECT 1 AS x FROM todo_sent WHERE day = ? AND time = ?\", [\n day,\n time,\n ])).length > 0;\n}\nexport async function markSent(day: string, time: string) {\n await run(\"INSERT OR IGNORE INTO todo_sent (day, time) VALUES (?, ?)\", [\n day,\n time,\n ]);\n}\nexport async function pruneSent(beforeDay: string) {\n await run(\"DELETE FROM todo_sent WHERE day < ?\", [beforeDay]);\n}","deleted",false,"label",[14],"b6c508ed-5367-4c80-adf4-89148338dcf2",["D",1787102792105],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Aylık takvim todo + mail bildirimleri | SQLite, cron, nodemailer","imageUrl","userId","36451bfa-e5dd-4ea2-8063-aefa91faa516","pinnedFileId","02883800-9b6d-11f1-8f0e-1607ee4eb77e","pinPreview","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",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",78,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","okan akar","avatar","https://lh3.googleusercontent.com/a/ACg8ocKVv87Cs_fECuMIhkwYWxOb1IWIAtks8lzjYrrflQ1fhtYr6A=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]