Bratcher Family Command Center

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_182":183,"_184":185},"routes/_app.x.$handle.$name",{"_97":96,"_31":43,"_106":87,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":56,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","gcal.ts","latestPath","fileId","d4d8ce16-a0ac-11f1-b762-1607ee4eb77e","name","fileType","script","content","// 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\", \"lauren@kynorml.org\");\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","createdAt",["D",1787679959092],"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","24e41b00-a09d-11f1-9191-1607ee4eb77e","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",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":52,"_102":103,"_104":24},"branch",{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"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",{"_41":42,"_31":43,"_36":177,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":178,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":179,"_81":180,"_83":181,"_85":24},"tree",[164,165,166],"files",[164,165,166],"counts",{"_153":60,"_154":155,"_156":60,"_157":158,"_159":160},"contents",[128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":150,"_31":27,"_29":30,"_134":-5,"_39":40,"_38":14,"_136":24,"_36":151,"_13":60,"_32":33,"_34":35,"_23":24,"_139":-5,"_26":152},{"_41":141,"_31":142,"_29":54,"_134":-5,"_39":40,"_38":143,"_136":24,"_36":144,"_13":145,"_32":146,"_34":147,"_23":24,"_139":148,"_26":149},{"_41":131,"_31":132,"_29":133,"_134":-5,"_39":40,"_38":135,"_136":56,"_36":137,"_13":60,"_32":33,"_34":138,"_23":24,"_139":-5,"_26":140},"f3fe306d-ab54-4118-88a0-b311881d11d5","todoist.ts","7afda9e6-a0a9-11f1-8170-1607ee4eb77e","parentId",9,"latest",["D",1787678519846],"// 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",[132],"947a02bf-6680-4043-b2c2-fca167a2f77e","new-file-5594.ts",12,["D",1787679840722],4,"http","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\";\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}\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 schedHTML = sched.rows.length\n ? sched.rows.map((r) => {\n const col = COLORS[r.who as string] || COLORS.All;\n const whoLabel = r.recurring ? `${r.who} · daily` : r.who;\n return `

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

${r.title}

` +\n `

${whoLabel}

` +\n `

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

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;","bratcher-fam-dash",[142],"ed68a899-38bf-4dfc-b31c-867d03b1c012",["D",1787679959092],[27],"pulls","branches",1,"forks","envVars",{"_161":145,"_163":60},"connections",{"_161":155,"_162":60},"count","unfilledCount","emptyCount",{"_41":150,"_31":27,"_29":30,"_134":-5,"_39":40,"_38":14,"_136":24,"_36":174,"_13":60,"_32":33,"_34":35,"_23":24,"_139":-5,"_168":175,"_26":176},{"_41":141,"_31":142,"_29":54,"_134":-5,"_39":40,"_38":143,"_136":24,"_36":171,"_13":145,"_32":146,"_34":147,"_23":24,"_139":148,"_168":172,"_26":173},{"_41":131,"_31":132,"_29":133,"_134":-5,"_39":40,"_38":135,"_136":56,"_36":167,"_13":60,"_32":33,"_34":138,"_23":24,"_139":-5,"_168":169,"_26":170},["D",1787678519846],"children",[],[132],["D",1787679840722],[],[142],["D",1787679959092],[],[27],["D",1787450588310],["D",1789497078049],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":52,"_102":103,"_104":24},{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_125":215,"_216":217,"_218":219,"_220":24,"_221":24,"_222":24,"_223":56,"_224":-5,"_225":-7,"_226":-7,"_227":60,"_228":24,"_229":24,"_230":-5,"_231":24,"_232":24,"_233":24,"_234":-5},"ENV",{"_186":187,"_188":189,"_190":87,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214},"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"]

Add Task

Add Event

Add Budget Alert

Edit Note

Diff · v13