[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_190":191,"_192":193},"routes/_app.x.$handle.$name",{"_104":103,"_38":51,"_113":94,"_33":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":63,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":37,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":31},"version",19,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","52be5bbd-0d1c-4e9c-b97a-fbd812f8dbb6","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","new-file-5594.ts","latestPath","fileId","24e41b00-a09d-11f1-9191-1607ee4eb77e","name","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\";\nimport {\n completeTodoistTask,\n fetchTodoistWork,\n reopenTodoistTask,\n TODOIST_PROJECTS,\n} from \"./todoist.ts\";\nimport {\n fetchTodayEvents,\n gcalAuthUrl,\n gcalConfigured,\n gcalHandleCallback,\n} from \"./gcal.ts\";\nfunction esc(s: unknown) {\n return String(s).replace(/&/g, \"&\").replace(//g, \">\").replace(/\"/g, \""\");\n}\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\nconst COLORS: Record = {\n Lauren: \"#2E9C8A\",\n Matthew: \"#2E5FA0\",\n Colin: \"#C07B18\",\n Lily: \"#7B5EA0\",\n Ben: \"#4D7C45\",\n All: \"#5A7052\",\n};\nconst PEOPLE = [\"Lauren\", \"Matthew\", \"Colin\", \"Lily\", \"Ben\", \"All\"];\nfunction today() {\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: \"America/Chicago\" });\n}\nfunction fmtDate(d: string) {\n const dt = new Date(d + \"T12:00:00\");\n return [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"][dt.getDay()] + \" \" +\n [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\",\n ][dt.getMonth()] +\n \" \" + dt.getDate();\n}\nfunction getWeekDates(): string[] {\n const t = new Date(today() + \"T12:00:00Z\");\n const dow = t.getUTCDay();\n const mon = new Date(t);\n mon.setUTCDate(t.getUTCDate() - (dow === 0 ? 6 : dow - 1));\n return Array.from({ length: 7 }, (_, i) => {\n const d = new Date(mon);\n d.setUTCDate(mon.getUTCDate() + i);\n return d.toISOString().slice(0, 10);\n });\n}\nasync function setup() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_schedule(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, time TEXT, who TEXT DEFAULT 'All',\n date TEXT DEFAULT '', recurring INTEGER DEFAULT 0)`);\n try {\n await sqlite.execute(\n \"ALTER TABLE cc_schedule ADD COLUMN recurring INTEGER DEFAULT 0\",\n );\n } catch { /**/ }\n try {\n await sqlite.execute(\n \"ALTER TABLE cc_schedule ADD COLUMN date TEXT DEFAULT ''\",\n );\n } catch { /**/ }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_tasks(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, who TEXT DEFAULT 'All',\n priority TEXT DEFAULT 'Normal', done INTEGER DEFAULT 0, due_date TEXT)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_alerts(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, note TEXT DEFAULT '',\n urgency TEXT DEFAULT 'Normal', active INTEGER DEFAULT 1)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_chores(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL, sort_order INTEGER DEFAULT 0)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_chore_done(\n chore_id INTEGER NOT NULL, date TEXT NOT NULL,\n PRIMARY KEY(chore_id, date))`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS cc_seed(key TEXT PRIMARY KEY)`,\n );\n const s1 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v1'\");\n if (!s1.rows.length) {\n await sqlite.batch([\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Court Mon Aug 25\",\n \"Rent owed $6,928 · Cash $2,668 · Writ not filed\",\n \"High\",\n ],\n },\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Ben SSI Sept 1\",\n \"$994/mo — pay toward rent immediately\",\n \"Normal\",\n ],\n },\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Colin refund ~$4,042\",\n \"Expected Sept 24 — clear rent balance\",\n \"Normal\",\n ],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\n \"Call Walmart — confirm job offer still open\",\n \"Matthew\",\n \"High\",\n ],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Contact landlord re: $2,668 now + plan\", \"Lauren\", \"High\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Push Golden Door inspection\", \"Lauren\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Clean room\", \"Colin\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Dishes\", \"Lily\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Reading time\", \"Ben\", \"Normal\"],\n },\n { sql: \"INSERT INTO cc_seed(key) VALUES('v1')\" },\n ]);\n }\n const s2 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v2'\");\n if (!s2.rows.length) {\n const chores = [\n \"Kitchen Clean (after dinner)\",\n \"Sweep & Mop\",\n \"Laundry\",\n \"Bathroom Clean\",\n \"Take Out Trash\",\n \"Vacuum Living Room\",\n \"Wipe Down Surfaces\",\n ];\n for (let i = 0; i < chores.length; i++) {\n await sqlite.execute({\n sql: \"INSERT INTO cc_chores(name,sort_order) VALUES(?,?)\",\n args: [chores[i], i],\n });\n }\n await sqlite.execute(\"INSERT INTO cc_seed(key) VALUES('v2')\");\n }\n const s3 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v3'\");\n if (!s3.rows.length) {\n const daily = [\n [\"Morning Routine\", \"06:30\", \"All\"],\n [\"Breakfast\", \"07:30\", \"All\"],\n [\"Lunch\", \"11:30\", \"All\"],\n [\"Dinner\", \"18:00\", \"All\"],\n [\"Before Bed Routines\", \"20:00\", \"All\"],\n [\"Lights Out\", \"21:30\", \"All\"],\n ];\n for (const [title, time, who] of daily) {\n await sqlite.execute({\n sql:\n \"INSERT INTO cc_schedule(title,time,who,date,recurring) VALUES(?,?,?,'',1)\",\n args: [title, time, who],\n });\n }\n await sqlite.execute(\"INSERT INTO cc_seed(key) VALUES('v3')\");\n }\n}\napp.get(\"/privacy\", (c) =>\n c.html(`Privacy Policy — Bratcher Family Command Center\n\n

Privacy Policy

Bratcher Family Command Center is a private household dashboard used by one family.

When you connect a Google account, this app requests read-only access to your Google Calendar to display the day’s events on the family dashboard. Calendar data is fetched on demand, displayed on the dashboard, and is not shared with, sold to, or disclosed to any third party. OAuth tokens are stored privately in the app’s own database and are used solely to read calendar events.

You can revoke access at any time from your Google Account permissions page.

Contact: lauren@kynorml.org

\n`));\n// --- Google Calendar auth ---\napp.get(\"/auth/google\", (c) => {\n if (!gcalConfigured()) {\n return c.text(\"Google client not configured yet (GOOGLE_CLIENT_ID / GOOGLE_CLIENT_SECRET).\", 500);\n }\n return c.redirect(gcalAuthUrl());\n});\napp.get(\"/auth/google/callback\", async (c) => {\n const code = c.req.query(\"code\");\n if (!code) return c.text(\"Google sign-in was cancelled or failed: \" + (c.req.query(\"error\") ?? \"no code\"), 400);\n try {\n const account = await gcalHandleCallback(code);\n return c.html(\n `

✅ Google Calendar connected

Signed in as ${account}.

← Back to the dashboard

`,\n );\n } catch (e) {\n return c.text(String(e), 500);\n }\n});\n// --- Alerts bridge (Chief-of-Staff check-ins) ---\nfunction alertsAuthorized(c: any): boolean {\n const secret = Deno.env.get(\"ALERTS_WEBHOOK_SECRET\");\n if (!secret) return false;\n const given = c.req.header(\"x-alerts-secret\") ??\n (c.req.header(\"authorization\") ?? \"\").replace(/^Bearer\\s+/i, \"\");\n return given === secret;\n}\napp.post(\"/api/alerts\", async (c) => {\n if (!alertsAuthorized(c)) return c.json({ ok: false, error: \"unauthorized\" }, 401);\n const body = await c.req.json().catch(() => null);\n if (!body || !body.title) return c.json({ ok: false, error: \"title required\" }, 400);\n await setup();\n const urgency = body.urgency === \"High\" ? \"High\" : \"Normal\";\n const r = await sqlite.execute({\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [String(body.title).slice(0, 200), String(body.note ?? \"\").slice(0, 600), urgency],\n });\n return c.json({ ok: true, id: Number(r.lastInsertRowid ?? 0) });\n});\napp.get(\"/api/alerts\", async (c) => {\n if (!alertsAuthorized(c)) return c.json({ ok: false, error: \"unauthorized\" }, 401);\n await setup();\n const rows = await sqlite.execute(\n \"SELECT id,title,note,urgency,active FROM cc_alerts WHERE active=1 ORDER BY id DESC\",\n );\n return c.json(rows.rows);\n});\napp.post(\"/api/alerts/dismiss\", async (c) => {\n if (!alertsAuthorized(c)) return c.json({ ok: false, error: \"unauthorized\" }, 401);\n const { id } = await c.req.json().catch(() => ({}));\n if (!id) return c.json({ ok: false, error: \"id required\" }, 400);\n await sqlite.execute({ sql: \"UPDATE cc_alerts SET active=0 WHERE id=?\", args: [id] });\n return c.json({ ok: true });\n});\napp.get(\"/api/gcal-probe\", async (c) => {\n if (!alertsAuthorized(c)) return c.json({ error: \"unauthorized\" }, 401);\n const tok = Deno.env.get(\"GOOGLE_TOKEN\");\n if (!tok) return c.json({ hasToken: false });\n let info: any = {};\n try {\n info = await (await fetch(\n \"https://www.googleapis.com/oauth2/v3/tokeninfo?access_token=\" + encodeURIComponent(tok),\n )).json();\n } catch (e) { info = { err: String(e) }; }\n let calStatus = 0, calError: string | null = null, sample: string | null = null;\n try {\n const cal = await fetch(\n \"https://www.googleapis.com/calendar/v3/calendars/primary/events?maxResults=1&singleEvents=true&orderBy=startTime&timeMin=\" +\n encodeURIComponent(new Date().toISOString()),\n { headers: { Authorization: \"Bearer \" + tok } },\n );\n calStatus = cal.status;\n const body = await cal.json().catch(() => null);\n calError = body?.error?.message ?? null;\n sample = body?.items?.[0]?.summary ?? null;\n } catch (e) { calError = String(e); }\n return c.json({\n hasToken: true,\n scope: info.scope ?? null,\n expiresIn: info.expires_in ?? null,\n email: info.email ?? null,\n calStatus, calError, sample,\n });\n});\n// --- API ---\napp.post(\"/todoist/complete\", async (c) => {\n try {\n const { id } = await c.req.json();\n await completeTodoistTask(String(id));\n return c.json({ ok: true });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 502);\n }\n});\napp.post(\"/todoist/reopen\", async (c) => {\n try {\n const { id } = await c.req.json();\n await reopenTodoistTask(String(id));\n return c.json({ ok: true });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 502);\n }\n});\napp.post(\"/task/toggle\", async (c) => {\n const { id, done } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE cc_tasks SET done=? WHERE id=?\",\n args: [done ? 1 : 0, id],\n });\n return c.json({ ok: true });\n});\napp.post(\"/task/add\", async (c) => {\n const { title, who, priority } = await c.req.json();\n await sqlite.execute({\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [title, who, priority || \"Normal\"],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/task/:id\", async (c) => {\n await sqlite.execute({\n sql: \"DELETE FROM cc_tasks WHERE id=?\",\n args: [c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n});\napp.post(\"/schedule/add\", async (c) => {\n const { title, time, who, date, recurring } = await c.req.json();\n await sqlite.execute({\n sql:\n \"INSERT INTO cc_schedule(title,time,who,date,recurring) VALUES(?,?,?,?,?)\",\n args: [\n title,\n time,\n who,\n recurring ? \"\" : (date || today()),\n recurring ? 1 : 0,\n ],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/schedule/:id\", async (c) => {\n await sqlite.execute({\n sql: \"DELETE FROM cc_schedule WHERE id=?\",\n args: [c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n});\napp.post(\"/alert/dismiss\", async (c) => {\n const { id } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE cc_alerts SET active=0 WHERE id=?\",\n args: [id],\n });\n return c.json({ ok: true });\n});\napp.post(\"/alert/add\", async (c) => {\n const { title, note, urgency } = await c.req.json();\n await sqlite.execute({\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [title, note || \"\", urgency || \"Normal\"],\n });\n return c.json({ ok: true });\n});\napp.post(\"/alert/edit\", async (c) => {\n const { id, title, note, urgency } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE cc_alerts SET title=?,note=?,urgency=? WHERE id=?\",\n args: [title, note || \"\", urgency || \"Normal\", id],\n });\n return c.json({ ok: true });\n});\napp.post(\"/chore/toggle\", async (c) => {\n const { id, date, done } = await c.req.json();\n if (done) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO cc_chore_done(chore_id,date) VALUES(?,?)\",\n args: [id, date],\n });\n } else {\n await sqlite.execute({\n sql: \"DELETE FROM cc_chore_done WHERE chore_id=? AND date=?\",\n args: [id, date],\n });\n }\n return c.json({ ok: true });\n});\napp.post(\"/chore/add\", async (c) => {\n const { name } = await c.req.json();\n const cnt =\n (await sqlite.execute(\"SELECT COUNT(*) as n FROM cc_chores\")).rows[0];\n await sqlite.execute({\n sql: \"INSERT INTO cc_chores(name,sort_order) VALUES(?,?)\",\n args: [name, cnt.n],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/chore/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.execute({\n sql: \"DELETE FROM cc_chore_done WHERE chore_id=?\",\n args: [id],\n });\n await sqlite.execute({ sql: \"DELETE FROM cc_chores WHERE id=?\", args: [id] });\n return c.json({ ok: true });\n});\n// --- Main page ---\napp.get(\"/\", async (c) => {\n await setup();\n const t = today();\n const week = getWeekDates();\n const todayIdx = week.indexOf(t);\n let wxCurrent = \"\";\n let wxForecastHTML = \"\";\n try {\n const wr = await fetch(\"https://wttr.in/Bowling+Green,KY?format=j1\", {\n signal: AbortSignal.timeout(3000),\n });\n const wx = await wr.json();\n const cur = wx.current_condition?.[0];\n if (cur) {\n wxCurrent = cur.temp_F + \"°F · \" + (cur.weatherDesc?.[0]?.value || \"\") +\n \" · Feels \" + cur.FeelsLikeF + \"°\";\n }\n const WICO: Record = {\n 113: \"☀️\",\n 116: \"🌤\",\n 119: \"⛅\",\n 122: \"☁️\",\n 143: \"🌫\",\n 176: \"🌦\",\n 179: \"🌨\",\n 182: \"🌧\",\n 200: \"⛈\",\n 227: \"❄️\",\n 248: \"🌫\",\n 263: \"🌦\",\n 293: \"🌦\",\n 296: \"🌦\",\n 299: \"🌧\",\n 302: \"🌧\",\n 305: \"🌧\",\n 308: \"🌧\",\n 353: \"🌦\",\n 356: \"🌧\",\n 359: \"🌧\",\n 386: \"⛈\",\n 389: \"⛈\",\n };\n const DS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n wxForecastHTML = (wx.weather || []).slice(0, 3).map((d: any) => {\n const dt = new Date(d.date + \"T12:00:00\");\n const icon = WICO[parseInt(d.hourly?.[4]?.weatherCode || \"113\")] || \"🌡\";\n return `

${\n DS[dt.getDay()]\n }${icon}${d.maxtempF}°${d.mintempF}°

`;\n }).join(\"\");\n } catch { /**/ }\n const [sched, tasks, alerts, chores] = await Promise.all([\n sqlite.execute({\n sql:\n \"SELECT * FROM cc_schedule WHERE date=? OR recurring=1 ORDER BY time\",\n args: [t],\n }),\n sqlite.execute(\n \"SELECT * FROM cc_tasks WHERE done=0 ORDER BY CASE priority WHEN 'High' THEN 0 ELSE 1 END, who\",\n ),\n sqlite.execute(\n \"SELECT * FROM cc_alerts WHERE active=1 ORDER BY CASE urgency WHEN 'High' THEN 0 ELSE 1 END\",\n ),\n sqlite.execute(\"SELECT * FROM cc_chores ORDER BY sort_order\"),\n ]);\n const work = await fetchTodoistWork();\n const doneRows = chores.rows.length\n ? (await sqlite.execute({\n sql: `SELECT chore_id,date FROM cc_chore_done WHERE date IN (${\n week.map(() => \"?\").join(\",\")\n })`,\n args: week,\n })).rows\n : [];\n const doneSet = new Set(doneRows.map((r) => r.chore_id + \"|\" + r.date));\n const allDone = await sqlite.execute(\n \"SELECT chore_id, date FROM cc_chore_done ORDER BY date\",\n );\n const byChore = new Map();\n for (const r of allDone.rows) {\n const k = Number(r.chore_id);\n if (!byChore.has(k)) byChore.set(k, []);\n byChore.get(k)!.push(String(r.date));\n }\n const dayDiff = (a: string, b: string) =>\n Math.round(\n (new Date(b + \"T12:00:00Z\").getTime() - new Date(a + \"T12:00:00Z\").getTime()) / 86400000,\n );\n const streaks = new Map();\n for (const [cid, dates] of byChore) {\n const uniq = [...new Set(dates)].sort();\n let best = 0, run = 0;\n let prev: string | null = null;\n for (const d of uniq) {\n run = prev !== null && dayDiff(prev, d) === 1 ? run + 1 : 1;\n if (run > best) best = run;\n prev = d;\n }\n let cur = 0;\n const last = uniq[uniq.length - 1];\n if (last && dayDiff(last, t) <= 1) {\n cur = 1;\n for (let i = uniq.length - 1; i > 0; i--) {\n if (dayDiff(uniq[i - 1], uniq[i]) === 1) cur++;\n else break;\n }\n }\n streaks.set(cid, { cur, best, total: uniq.length });\n }\n const streakChip = (id: unknown) => {\n const s = streaks.get(Number(id));\n if (!s || !s.total) return \"\";\n if (s.cur >= 2) {\n return `🔥 ${s.cur}`;\n }\n return `${s.total}✓`;\n };\n const DS2 = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n const MO2 = [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\",\n ];\n const wkStart = new Date(week[0] + \"T12:00:00\"),\n wkEnd = new Date(week[6] + \"T12:00:00\");\n const wkLabel = MO2[wkStart.getMonth()] + \" \" + wkStart.getDate() + \" — \" +\n MO2[wkEnd.getMonth()] + \" \" + wkEnd.getDate();\n const DOW_SHORT = [\"MO\", \"TU\", \"WE\", \"TH\", \"FR\", \"SA\", \"SU\"];\n const gcal = await fetchTodayEvents(t);\n const schedItems: { key: string; html: string }[] = [];\n if (gcal.connected && !gcal.error) {\n for (const e of gcal.events) {\n schedItems.push({\n key: e.allDay ? \"00:00\" : (e.time24 ?? \"99:99\"),\n html: `

` +\n `${e.allDay ? \"all day\" : esc(e.time ?? \"\")}` +\n `

${esc(e.title)}

` +\n `

Lauren · Google Calendar${e.location ? \" · \" + esc(e.location) : \"\"}

` +\n `📅

`,\n });\n }\n }\n for (const r of sched.rows) {\n const col = COLORS[r.who as string] || COLORS.All;\n const whoLabel = r.recurring ? `${r.who} · daily` : r.who;\n schedItems.push({\n key: (r.time as string) || \"99:99\",\n html: `

` +\n `${(r.time as string) || \"—\"}` +\n `

${r.title}

` +\n `

${whoLabel}

` +\n `

`,\n });\n }\n schedItems.sort((a, b) => a.key.localeCompare(b.key));\n let schedNote = \"\";\n if (gcal.configured && !gcal.connected) {\n schedNote =\n `

📅 Connect Google Calendar to show Lauren’s real events here (one-time sign-in as lauren@kynorml.org).

`;\n } else if (gcal.error) {\n schedNote = `

Google Calendar error: ${esc(gcal.error)}

`;\n }\n const schedHTML = schedNote +\n (schedItems.length ? schedItems.map((i) => i.html).join(\"\") : `

No events today — add one!

`);\n const alertsHTML = alerts.rows.length\n ? alerts.rows.map((r) =>\n `

` +\n `

` +\n (r.urgency === \"High\" ? `HIGH` : \"\") +\n `${r.title}` +\n `

` +\n `` +\n `

` +\n (r.note ? `

${r.note}

` : \"\") +\n `

`\n ).join(\"\")\n : `

No notes pinned — add one below!

`;\n let workHTML = \"\";\n if (!work.configured) {\n workHTML =\n `

To connect Todoist: add a TODOIST_API_TOKEN environment variable to this val in val.town, then reload.

`;\n } else if (work.error) {\n workHTML =\n `

Todoist is unreachable right now (${esc(work.error)}). Try a refresh in a minute.

`;\n } else {\n workHTML = work.tasks.length\n ? work.tasks.map((t) =>\n `

` +\n `

${esc(t.content)}` +\n (t.priority === 4\n ? ` P1`\n : t.priority === 3\n ? ` P2`\n : \"\") +\n `

` +\n `${t.projectName}` +\n (t.overdue\n ? `Overdue · ${fmtDate(t.due)}`\n : t.dueTime\n ? `Today ${t.dueTime}`\n : `Today`) +\n `

` +\n `↗

`\n ).join(\"\")\n : `

No work tasks due today — clear runway! 🎉

`;\n }\n const tasksHTML = tasks.rows.length\n ? tasks.rows.map((r) => {\n const col = COLORS[r.who as string] || COLORS.All;\n return `

` +\n `

${r.title}` +\n (r.priority === \"High\" ? ` HIGH` : \"\") +\n `

` +\n `

${r.who}` +\n (r.due_date\n ? `Due ${fmtDate(r.due_date as string)}`\n : \"\") +\n `

` +\n `` +\n `

`;\n }).join(\"\")\n : `

All done! 🎉

`;\n const choreGridHTML = chores.rows.length\n ? `

${\n DOW_SHORT.map((d, i) =>\n `

${d}

`\n ).join(\"\")\n }

` +\n chores.rows.map((r) =>\n `

` +\n `

${r.name}${streakChip(r.id)}` +\n `

` +\n `

${\n week.map((d, i) => {\n const done = doneSet.has(r.id + \"|\" + d);\n const isToday = i === todayIdx;\n return `

` +\n (done\n ? ``\n : \"\") +\n `

`;\n }).join(\"\")\n }

`\n ).join(\"\")\n : `

No chores added yet.

`;\n const pOpts = PEOPLE.map((p) => ``).join(\n \"\",\n );\n return c.html(`\n\n\n\n\nBratcher Family Command Center\n\n\n\n\n\n

\n\n\n

\n 📅 Today's Schedule\n \n

${schedHTML}

\n 📌 Bulletin Board\n

\n ${alertsHTML}\n

\n \n \n

\n ✅ Tasks\n \n

Lauren — Work (Todoist)

\n ${workHTML}\n

Family

\n ${tasksHTML}\n

\n 🧹 House Chore Routines\n ${wkLabel}\n

\n ${choreGridHTML}\n

\n \n \n

\n 💰 Budget Overview\n \n

\n ${\n alerts.rows.map((r) =>\n `

` +\n `${r.title}` +\n (r.note ? `${r.note}` : \"\") +\n `

`\n ).join(\"\") || `

No budget alerts

`\n }\n \n

\n 🚗 Car Research\n Used · Traditional Auto · Aug 2026\n

✓ Best Choice

Mazda CX-5 2019–2021

6-spd torque-converter auto · ~$18–26k

25 city / 31 hwy mpg · Easy back-seat kid access · Top reliability rankings

+ Runner-Up

Mazda3 Hatch 2019–2023

6-spd torque-converter auto · ~$15–21k

28 city / 36 hwy mpg · More nimble in city · Same great transmission

🔑 Manual saves money

You + Matthew both drive stick — manuals run $1–3k cheaper. Worth asking about.

✗ Transmissions to avoid

CVT (Honda/Nissan/Subaru/Toyota) · Dual-clutch / DSG (Ford PowerShift, VW, some Hyundai/Kia)

🔧 Before you buy

Independent pre-purchase inspection ~$100–150. Ask them to check transmission fluid & leaks specifically.

\n\n

\n \n

\n\n\n`);\n});\nexport default app.fetch;","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\";\nimport {\n completeTodoistTask,\n fetchTodoistWork,\n reopenTodoistTask,\n TODOIST_PROJECTS,\n} from \"./todoist.ts\";\nimport {\n fetchTodayEvents,\n gcalAuthUrl,\n gcalConfigured,\n gcalHandleCallback,\n} from \"./gcal.ts\";\nfunction esc(s: unknown) {\n return String(s).replace(/&/g, \"&\").replace(//g, \">\").replace(/\"/g, \""\");\n}\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\nconst COLORS: Record = {\n Lauren: \"#2E9C8A\",\n Matthew: \"#2E5FA0\",\n Colin: \"#C07B18\",\n Lily: \"#7B5EA0\",\n Ben: \"#4D7C45\",\n All: \"#5A7052\",\n};\nconst PEOPLE = [\"Lauren\", \"Matthew\", \"Colin\", \"Lily\", \"Ben\", \"All\"];\nfunction today() {\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: \"America/Chicago\" });\n}\nfunction fmtDate(d: string) {\n const dt = new Date(d + \"T12:00:00\");\n return [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"][dt.getDay()] + \" \" +\n [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\",\n ][dt.getMonth()] +\n \" \" + dt.getDate();\n}\nfunction getWeekDates(): string[] {\n const t = new Date(today() + \"T12:00:00Z\");\n const dow = t.getUTCDay();\n const mon = new Date(t);\n mon.setUTCDate(t.getUTCDate() - (dow === 0 ? 6 : dow - 1));\n return Array.from({ length: 7 }, (_, i) => {\n const d = new Date(mon);\n d.setUTCDate(mon.getUTCDate() + i);\n return d.toISOString().slice(0, 10);\n });\n}\nasync function setup() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_schedule(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, time TEXT, who TEXT DEFAULT 'All',\n date TEXT DEFAULT '', recurring INTEGER DEFAULT 0)`);\n try {\n await sqlite.execute(\n \"ALTER TABLE cc_schedule ADD COLUMN recurring INTEGER DEFAULT 0\",\n );\n } catch { /**/ }\n try {\n await sqlite.execute(\n \"ALTER TABLE cc_schedule ADD COLUMN date TEXT DEFAULT ''\",\n );\n } catch { /**/ }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_tasks(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, who TEXT DEFAULT 'All',\n priority TEXT DEFAULT 'Normal', done INTEGER DEFAULT 0, due_date TEXT)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_alerts(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL, note TEXT DEFAULT '',\n urgency TEXT DEFAULT 'Normal', active INTEGER DEFAULT 1)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_chores(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL, sort_order INTEGER DEFAULT 0)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_chore_done(\n chore_id INTEGER NOT NULL, date TEXT NOT NULL,\n PRIMARY KEY(chore_id, date))`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS cc_seed(key TEXT PRIMARY KEY)`,\n );\n const s1 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v1'\");\n if (!s1.rows.length) {\n await sqlite.batch([\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Court Mon Aug 25\",\n \"Rent owed $6,928 · Cash $2,668 · Writ not filed\",\n \"High\",\n ],\n },\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Ben SSI Sept 1\",\n \"$994/mo — pay toward rent immediately\",\n \"Normal\",\n ],\n },\n {\n sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\n \"Colin refund ~$4,042\",\n \"Expected Sept 24 — clear rent balance\",\n \"Normal\",\n ],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\n \"Call Walmart — confirm job offer still open\",\n \"Matthew\",\n \"High\",\n ],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Contact landlord re: $2,668 now + plan\", \"Lauren\", \"High\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Push Golden Door inspection\", \"Lauren\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Clean room\", \"Colin\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Dishes\", \"Lily\", \"Normal\"],\n },\n {\n sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Reading time\", \"Ben\", \"Normal\"],\n },\n { sql: \"INSERT INTO cc_seed(key) VALUES('v1')\" },\n ]);\n }\n const s2 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v2'\");\n if (!s2.rows.length) {\n const chores = [\n \"Kitchen Clean (after dinner)\",\n \"Sweep & Mop\",\n \"Laundry\",\n \"Bathroom Clean\",\n \"Take Out Trash\",\n \"Vacuum Living Room\",\n \"Wipe Down Surfaces\",\n ];\n for (let i = 0; i < chores.length; i++) {\n await sqlite.execute({\n sql: \"INSERT INTO cc_chores(name,sort_order) VALUES(?,?)\",\n args: [chores[i], i],\n });\n }\n await sqlite.execute(\"INSERT INTO cc_seed(key) VALUES('v2')\");\n }\n const s3 = await sqlite.execute(\"SELECT key FROM cc_seed WHERE key='v3'\");\n if (!s3.rows.length) {\n const daily = [\n [\"Morning Routine\", \"06:30\", \"All\"],\n [\"Breakfast\", \"07:30\", \"All\"],\n [\"Lunch\", \"11:30\", \"All\"],\n [\"Dinner\", \"18:00\", \"All\"],\n [\"Before Bed Routines\", \"20:00\", \"All\"],\n [\"Lights Out\", \"21:30\", \"All\"],\n ];\n for (const [title, time, who] of daily) {\n await sqlite.execute({\n sql:\n \"INSERT INTO cc_schedule(title,time,who,date,recurring) VALUES(?,?,?,'',1)\",\n args: [title, time, who],\n });\n }\n await sqlite.execute(\"INSERT INTO cc_seed(key) VALUES('v3')\");\n }\n}\napp.get(\"/privacy\", (c) =>\n c.html(`Privacy Policy — Bratcher Family Command Center\n\n

Privacy Policy

Bratcher Family Command Center is a private household dashboard used by one family.

You can revoke access at any time from your Google Account permissions page.

Contact: lauren@kynorml.org

✅ Google Calendar connected

Signed in as ${account}.

← Back to the dashboard

${\n DS[dt.getDay()]\n }${icon}${d.maxtempF}°${d.mintempF}°

` +\n `${e.allDay ? \"all day\" : esc(e.time ?? \"\")}` +\n `

${esc(e.title)}

` +\n `

Lauren · Google Calendar${e.location ? \" · \" + esc(e.location) : \"\"}

` +\n `📅

` +\n `${(r.time as string) || \"—\"}` +\n `

${r.title}

` +\n `

${whoLabel}

` +\n `

`,\n });\n }\n schedItems.sort((a, b) => a.key.localeCompare(b.key));\n let schedNote = \"\";\n if (gcal.configured && !gcal.connected) {\n schedNote =\n `

📅 Connect Google Calendar to show Lauren’s real events here (one-time sign-in as lauren@kynorml.org).

`;\n } else if (gcal.error) {\n schedNote = `

Google Calendar error: ${esc(gcal.error)}

`;\n }\n const schedHTML = schedNote +\n (schedItems.length ? schedItems.map((i) => i.html).join(\"\") : `

No events today — add one!

`);\n const alertsHTML = alerts.rows.length\n ? alerts.rows.map((r) =>\n `

` +\n `

` +\n (r.urgency === \"High\" ? `HIGH` : \"\") +\n `${r.title}` +\n `

` +\n `` +\n `

` +\n (r.note ? `

${r.note}

` : \"\") +\n `

`\n ).join(\"\")\n : `

No notes pinned — add one below!

`;\n let workHTML = \"\";\n if (!work.configured) {\n workHTML =\n `

To connect Todoist: add a TODOIST_API_TOKEN environment variable to this val in val.town, then reload.

`;\n } else if (work.error) {\n workHTML =\n `

Todoist is unreachable right now (${esc(work.error)}). Try a refresh in a minute.

`;\n } else {\n workHTML = work.tasks.length\n ? work.tasks.map((t) =>\n `

` +\n `

${esc(t.content)}` +\n (t.priority === 4\n ? ` P1`\n : t.priority === 3\n ? ` P2`\n : \"\") +\n `

` +\n `${t.projectName}` +\n (t.overdue\n ? `Overdue · ${fmtDate(t.due)}`\n : t.dueTime\n ? `Today ${t.dueTime}`\n : `Today`) +\n `

` +\n `↗

`\n ).join(\"\")\n : `

No work tasks due today — clear runway! 🎉

`;\n }\n const tasksHTML = tasks.rows.length\n ? tasks.rows.map((r) => {\n const col = COLORS[r.who as string] || COLORS.All;\n return `

` +\n `

${r.title}` +\n (r.priority === \"High\" ? ` HIGH` : \"\") +\n `

` +\n `

${r.who}` +\n (r.due_date\n ? `Due ${fmtDate(r.due_date as string)}`\n : \"\") +\n `

` +\n `` +\n `

`;\n }).join(\"\")\n : `

All done! 🎉

`;\n const choreGridHTML = chores.rows.length\n ? `

${\n DOW_SHORT.map((d, i) =>\n `

${d}

`\n ).join(\"\")\n }

` +\n chores.rows.map((r) =>\n `

` +\n `

${r.name}${streakChip(r.id)}` +\n `

` +\n `

${\n week.map((d, i) => {\n const done = doneSet.has(r.id + \"|\" + d);\n const isToday = i === todayIdx;\n return `

` +\n (done\n ? ``\n : \"\") +\n `

`;\n }).join(\"\")\n }

`\n ).join(\"\")\n : `

No chores added yet.

`;\n const pOpts = PEOPLE.map((p) => ``).join(\n \"\",\n );\n return c.html(`\n\n\n\n\nBratcher Family Command Center\n\n\n\n\n\n

\n\n\n

\n 📅 Today's Schedule\n \n

${schedHTML}

\n 📌 Bulletin Board\n

\n ${alertsHTML}\n

\n \n \n

\n ✅ Tasks\n \n

Lauren — Work (Todoist)

\n ${workHTML}\n

Family

\n ${tasksHTML}\n

\n 🧹 House Chore Routines\n ${wkLabel}\n

\n ${choreGridHTML}\n

\n \n \n

\n 💰 Budget Overview\n \n

\n ${\n alerts.rows.map((r) =>\n `

` +\n `${r.title}` +\n (r.note ? `${r.note}` : \"\") +\n `

`\n ).join(\"\") || `

No budget alerts

`\n }\n \n

\n 🚗 Car Research\n Used · Traditional Auto · Aug 2026\n

✓ Best Choice

Mazda CX-5 2019–2021

6-spd torque-converter auto · ~$18–26k

25 city / 31 hwy mpg · Easy back-seat kid access · Top reliability rankings

+ Runner-Up

Mazda3 Hatch 2019–2023

6-spd torque-converter auto · ~$15–21k

28 city / 36 hwy mpg · More nimble in city · Same great transmission

🔑 Manual saves money

You + Matthew both drive stick — manuals run $1–3k cheaper. Worth asking about.

✗ Transmissions to avoid

CVT (Honda/Nissan/Subaru/Toyota) · Dual-clutch / DSG (Ford PowerShift, VW, some Hyundai/Kia)

🔧 Before you buy

Independent pre-purchase inspection ~$100–150. Ask them to check transmission fluid & leaks specifically.

\n\n

\n \n

\n\n\n`);\n});\nexport default app.fetch;","createdAt",["D",1787691874790],"branchVersion","branchId","396515d3-aae3-4565-8448-6c3beaa32d6d","id","9df0dfb1-4b3f-46b2-81e0-229a67dc0a88","bratcher_command_center",["D",1787450588310],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","a34d3984-f7ff-45c7-8cf9-da348239030b","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02ab2-177b-7333-b8d0-654b7dc95254","tursoName","9df0dfb14b3f46b281e0229a67dc0a88","tursoHostname","9df0dfb14b3f46b281e0229a67dc0a88-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":60,"_109":110,"_111":31},"branch",{"_13":93,"_38":94,"_49":48,"_95":50,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":51,"_102":103},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","laurenbratcher","handle","displayName","Lauren Bratcher","avatar","https://lh3.googleusercontent.com/a/ACg8ocJbOXDwjhfMAGEIlJWXa7oDRpWz83Z4wRjsExqR4SYZegQHGaM=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":185,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":37,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":186,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":187,"_88":188,"_90":189,"_92":31},"tree",[172,173,174],"files",[172,173,174],"counts",{"_161":67,"_162":158,"_163":67,"_164":165,"_166":167},"contents",[135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":153,"_38":154,"_36":155,"_141":-5,"_47":48,"_46":156,"_143":63,"_44":157,"_13":158,"_39":145,"_41":159,"_30":31,"_147":-5,"_33":160},{"_49":149,"_38":34,"_36":37,"_141":-5,"_47":48,"_46":14,"_143":63,"_44":150,"_13":142,"_39":40,"_41":43,"_30":31,"_147":151,"_33":152},{"_49":138,"_38":139,"_36":140,"_141":-5,"_47":48,"_46":142,"_143":63,"_44":144,"_13":67,"_39":145,"_41":146,"_30":31,"_147":-5,"_33":148},"f3fe306d-ab54-4118-88a0-b311881d11d5","todoist.ts","7afda9e6-a0a9-11f1-8170-1607ee4eb77e","parentId",9,"latest",["D",1787678519846],"script","// Todoist integration — Bratcher Family Command Center\nconst TODOIST_API = \"https://api.todoist.com/api/v1\";\n\nexport const TODOIST_PROJECTS: { id: string; name: string; color: string }[] = [\n { id: \"6hJr82PMcQGqmvpM\", name: \"VMP Admin\", color: \"#2E5FA0\" },\n { id: \"6hJr82Q5Q68R8mMP\", name: \"KY NORML\", color: \"#4D7C45\" },\n { id: \"6hJr82MM48jrQMFh\", name: \"CGN / Golden Door\", color: \"#C07B18\" },\n];\n\nfunction token(): string | undefined {\n return Deno.env.get(\"TODOIST_API_TOKEN\");\n}\n\nexport function chicagoToday(): string {\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: \"America/Chicago\" });\n}\n\nexport interface WorkTask {\n id: string;\n content: string;\n projectId: string;\n projectName: string;\n projectColor: string;\n due: string;\n dueTime: string | null;\n overdue: boolean;\n priority: number;\n url: string;\n}\n\nfunction dueParts(due: any): { date: string | null; time: string | null } {\n const raw = due?.datetime ?? due?.date;\n if (!raw) return { date: null, time: null };\n const s = String(raw);\n if (!s.includes(\"T\")) return { date: s.slice(0, 10), time: null };\n if (s.endsWith(\"Z\")) {\n const dt = new Date(s);\n return {\n date: dt.toLocaleDateString(\"en-CA\", { timeZone: \"America/Chicago\" }),\n time: dt.toLocaleTimeString(\"en-US\", { timeZone: \"America/Chicago\", hour: \"numeric\", minute: \"2-digit\" }),\n };\n }\n const dt = new Date(s);\n return {\n date: s.slice(0, 10),\n time: dt.toLocaleTimeString(\"en-US\", { hour: \"numeric\", minute: \"2-digit\" }),\n };\n}\n\nasync function fetchProjectTasks(projectId: string): Promise {\n const tok = token();\n if (!tok) return [];\n const out: any[] = [];\n let cursor: string | null = null;\n for (let page = 0; page < 5; page++) {\n const u = new URL(TODOIST_API + \"/tasks\");\n u.searchParams.set(\"project_id\", projectId);\n u.searchParams.set(\"limit\", \"200\");\n if (cursor) u.searchParams.set(\"cursor\", cursor);\n const r = await fetch(u, {\n headers: { Authorization: \"Bearer \" + tok },\n signal: AbortSignal.timeout(4500),\n });\n if (!r.ok) throw new Error(\"Todoist API \" + r.status);\n const j = await r.json();\n out.push(...(j.results ?? []));\n cursor = j.next_cursor ?? null;\n if (!cursor) break;\n }\n return out;\n}\n\nexport async function fetchTodoistWork(): Promise<\n { tasks: WorkTask[]; configured: boolean; error: string | null }\n> {\n if (!token()) return { tasks: [], configured: false, error: null };\n const todayStr = chicagoToday();\n try {\n const all = await Promise.all(TODOIST_PROJECTS.map((p) => fetchProjectTasks(p.id)));\n const tasks: WorkTask[] = [];\n all.forEach((list, i) => {\n const proj = TODOIST_PROJECTS[i];\n for (const t of list) {\n const { date, time } = dueParts(t.due);\n if (!date || date > todayStr) continue;\n tasks.push({\n id: String(t.id),\n content: String(t.content ?? \"\"),\n projectId: proj.id,\n projectName: proj.name,\n projectColor: proj.color,\n due: date,\n dueTime: time,\n overdue: date < todayStr,\n priority: Number(t.priority ?? 1),\n url: t.url ?? \"https://app.todoist.com/app/task/\" + t.id,\n });\n }\n });\n tasks.sort((a, b) => (a.due < b.due ? -1 : a.due > b.due ? 1 : 0) || (b.priority - a.priority));\n return { tasks, configured: true, error: null };\n } catch (e: any) {\n return { tasks: [], configured: true, error: String(e?.message ?? e) };\n }\n}\n\nasync function todoistPost(path: string): Promise {\n const tok = token();\n if (!tok) throw new Error(\"TODOIST_API_TOKEN not set\");\n const r = await fetch(TODOIST_API + path, {\n method: \"POST\",\n headers: { Authorization: \"Bearer \" + tok },\n signal: AbortSignal.timeout(6000),\n });\n if (!r.ok && r.status !== 204) throw new Error(\"Todoist write failed: \" + r.status);\n}\n\nexport async function completeTodoistTask(id: string): Promise {\n await todoistPost(\"/tasks/\" + encodeURIComponent(id) + \"/close\");\n}\n\nexport async function reopenTodoistTask(id: string): Promise {\n await todoistPost(\"/tasks/\" + encodeURIComponent(id) + \"/reopen\");\n}\n","label",[139],"d17451d3-dadd-4820-a9a7-a59aa17faaef",["D",1787691874790],"bratcher-fam-dash",[34],"f760035f-797c-4d1c-98d2-52409e7957b0","gcal.ts","d4d8ce16-a0ac-11f1-b762-1607ee4eb77e",15,["D",1787680494514],1,"// Google Calendar integration — Bratcher Family Command Center\nimport { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\";\n\nconst CAL_SCOPE = \"https://www.googleapis.com/auth/calendar.readonly\";\nexport const GCAL_REDIRECT = \"https://bratcher-fam-dash.val.run/auth/google/callback\";\n\nfunction clientId() {\n return Deno.env.get(\"GOOGLE_CLIENT_ID\");\n}\nfunction clientSecret() {\n return Deno.env.get(\"GOOGLE_CLIENT_SECRET\");\n}\n\nexport function gcalConfigured(): boolean {\n return !!(clientId() && clientSecret());\n}\n\nexport async function gcalSetup() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS cc_google_tokens(\n id INTEGER PRIMARY KEY CHECK (id=1),\n refresh_token TEXT, access_token TEXT, expires_at INTEGER, account TEXT)`);\n}\n\nexport function gcalAuthUrl(): string {\n const u = new URL(\"https://accounts.google.com/o/oauth2/v2/auth\");\n u.searchParams.set(\"client_id\", clientId()!);\n u.searchParams.set(\"redirect_uri\", GCAL_REDIRECT);\n u.searchParams.set(\"response_type\", \"code\");\n u.searchParams.set(\"scope\", CAL_SCOPE + \" https://www.googleapis.com/auth/userinfo.email\");\n u.searchParams.set(\"access_type\", \"offline\");\n u.searchParams.set(\"prompt\", \"consent\");\n u.searchParams.set(\"login_hint\", \"a.lauren.kie@gmail.com\");\n return u.toString();\n}\n\nexport async function gcalHandleCallback(code: string): Promise {\n const r = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n code,\n client_id: clientId()!,\n client_secret: clientSecret()!,\n redirect_uri: GCAL_REDIRECT,\n grant_type: \"authorization_code\",\n }),\n });\n const j = await r.json();\n if (!r.ok) throw new Error(\"Token exchange failed: \" + JSON.stringify(j).slice(0, 300));\n let account = \"\";\n try {\n const ui = await (await fetch(\"https://www.googleapis.com/oauth2/v3/userinfo\", {\n headers: { Authorization: \"Bearer \" + j.access_token },\n })).json();\n account = ui.email ?? \"\";\n } catch { /**/ }\n await gcalSetup();\n await sqlite.execute({\n sql: `INSERT INTO cc_google_tokens(id,refresh_token,access_token,expires_at,account)\n VALUES(1,?,?,?,?)\n ON CONFLICT(id) DO UPDATE SET\n refresh_token=COALESCE(excluded.refresh_token, cc_google_tokens.refresh_token),\n access_token=excluded.access_token,\n expires_at=excluded.expires_at,\n account=excluded.account`,\n args: [j.refresh_token ?? null, j.access_token, Date.now() + (j.expires_in ?? 3500) * 1000, account],\n });\n return account;\n}\n\nasync function accessToken(): Promise {\n await gcalSetup();\n const r = await sqlite.execute(\"SELECT * FROM cc_google_tokens WHERE id=1\");\n const row: any = r.rows[0];\n if (!row || !row.refresh_token) return null;\n if (row.access_token && Number(row.expires_at) > Date.now() + 60000) {\n return row.access_token as string;\n }\n const resp = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: clientId()!,\n client_secret: clientSecret()!,\n refresh_token: String(row.refresh_token),\n grant_type: \"refresh_token\",\n }),\n });\n const j = await resp.json();\n if (!resp.ok) throw new Error(\"Google token refresh failed: \" + (j.error_description ?? j.error ?? resp.status));\n await sqlite.execute({\n sql: \"UPDATE cc_google_tokens SET access_token=?, expires_at=? WHERE id=1\",\n args: [j.access_token, Date.now() + (j.expires_in ?? 3500) * 1000],\n });\n return j.access_token as string;\n}\n\nexport interface CalEvent {\n title: string;\n allDay: boolean;\n time: string | null; // \"9:30 AM\"\n time24: string | null; // \"09:30\" for sorting\n location: string | null;\n}\n\nfunction chicagoOffset(dayStr: string): string {\n const dt = new Date(dayStr + \"T12:00:00Z\");\n const parts = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: \"America/Chicago\",\n timeZoneName: \"longOffset\",\n }).formatToParts(dt);\n const off = parts.find((p) => p.type === \"timeZoneName\")?.value ?? \"GMT-05:00\";\n return off.replace(\"GMT\", \"\") || \"-05:00\";\n}\n\nexport async function fetchTodayEvents(dayStr: string): Promise<\n { configured: boolean; connected: boolean; events: CalEvent[]; error: string | null }\n> {\n if (!gcalConfigured()) return { configured: false, connected: false, events: [], error: null };\n try {\n const tok = await accessToken();\n if (!tok) return { configured: true, connected: false, events: [], error: null };\n const off = chicagoOffset(dayStr);\n const u = new URL(\"https://www.googleapis.com/calendar/v3/calendars/primary/events\");\n u.searchParams.set(\"singleEvents\", \"true\");\n u.searchParams.set(\"orderBy\", \"startTime\");\n u.searchParams.set(\"timeMin\", `${dayStr}T00:00:00${off}`);\n u.searchParams.set(\"timeMax\", `${dayStr}T23:59:59${off}`);\n u.searchParams.set(\"maxResults\", \"25\");\n const r = await fetch(u, {\n headers: { Authorization: \"Bearer \" + tok },\n signal: AbortSignal.timeout(5000),\n });\n const j = await r.json();\n if (!r.ok) throw new Error(j?.error?.message ?? \"Calendar API \" + r.status);\n const events: CalEvent[] = (j.items ?? [])\n .filter((e: any) => e.status !== \"cancelled\")\n .map((e: any) => {\n const allDay = !!e.start?.date && !e.start?.dateTime;\n let time: string | null = null, time24: string | null = null;\n if (e.start?.dateTime) {\n const d = new Date(e.start.dateTime);\n time = d.toLocaleTimeString(\"en-US\", {\n timeZone: \"America/Chicago\", hour: \"numeric\", minute: \"2-digit\",\n });\n time24 = d.toLocaleTimeString(\"en-GB\", {\n timeZone: \"America/Chicago\", hour: \"2-digit\", minute: \"2-digit\", hour12: false,\n });\n }\n return { title: e.summary ?? \"(no title)\", allDay, time, time24, location: e.location ?? null };\n });\n return { configured: true, connected: true, events, error: null };\n } catch (e: any) {\n return { configured: true, connected: true, events: [], error: String(e?.message ?? e) };\n }\n}\n\nexport async function gcalAccount(): Promise {\n await gcalSetup();\n const r = await sqlite.execute(\"SELECT account FROM cc_google_tokens WHERE id=1\");\n return (r.rows[0]?.account as string) ?? null;\n}\n",[154],"pulls","branches","forks","envVars",{"_168":170,"_171":67},"connections",{"_168":158,"_169":67},"count","unfilledCount",4,"emptyCount",{"_49":153,"_38":154,"_36":155,"_141":-5,"_47":48,"_46":156,"_143":63,"_44":182,"_13":158,"_39":145,"_41":159,"_30":31,"_147":-5,"_176":183,"_33":184},{"_49":149,"_38":34,"_36":37,"_141":-5,"_47":48,"_46":14,"_143":63,"_44":179,"_13":142,"_39":40,"_41":43,"_30":31,"_147":151,"_176":180,"_33":181},{"_49":138,"_38":139,"_36":140,"_141":-5,"_47":48,"_46":142,"_143":63,"_44":175,"_13":67,"_39":145,"_41":146,"_30":31,"_147":-5,"_176":177,"_33":178},["D",1787678519846],"children",[],[139],["D",1787691874790],[],[34],["D",1787680494514],[],[154],["D",1787450588310],["D",1789497078049],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":60,"_109":110,"_111":31},{"_13":93,"_38":94,"_49":48,"_95":50,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":51,"_102":103},"ctx",{"_86":-5,"_132":223,"_224":225,"_226":227,"_228":31,"_229":31,"_230":31,"_231":63,"_232":-5,"_233":-7,"_234":-7,"_235":67,"_236":31,"_237":31,"_238":-5,"_239":31,"_240":31,"_241":31,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":94,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"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"]

Privacy Policy

✅ Google Calendar connected

Add Task

Add Event

Add Budget Alert

Edit Note

Privacy Policy

✅ Google Calendar connected

Add Task

Add Event

Add Budget Alert

Edit Note

Diff · v19