Bratcher Family Command Center

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_101":102,"_103":104},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","laurenbratcher","name","bratcher_command","path","app.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":-5,"_53":-5,"_54":55,"_56":25,"_57":32,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":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/laurenbratcher/bratcher_command/code/app.ts","extension","id","987d91f1-cc8f-41ae-83ea-92f9931a5266","fileId","9f8ae7b2-9f12-11f1-8720-1607ee4eb77e","parentId","branchId","ced2491d-259c-4ca2-ab05-2b3dd49c357c","branchVersion",6,"latest",true,"createdAt",["D",1787505090856],"version",1,"fileType","http","content","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Sub-page URLs â set these in Val.town env vars after deploying each sub-page\nconst FINANCE_URL = Deno.env.get(\"CC_FINANCE_URL\") || \"\";\nconst STRATEGY_URL = Deno.env.get(\"CC_STRATEGY_URL\") || \"\";\nconst BENEFITS_URL = Deno.env.get(\"CC_BENEFITS_URL\") || \"\";\nconst CREDIT_URL = Deno.env.get(\"CC_CREDIT_URL\") || \"\";\n\nconst COLORS: Record = {\n Lauren: \"#2E9C8A\", Matthew: \"#2E5FA0\", Colin: \"#C07B18\",\n Lily: \"#7B5EA0\", Ben: \"#4D7C45\", All: \"#5A7052\"\n};\nconst PEOPLE = [\"Lauren\", \"Matthew\", \"Colin\", \"Lily\", \"Ben\", \"All\"];\n\nfunction today() { return new Date().toISOString().split(\"T\")[0]; }\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 [\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"][dt.getMonth()] +\n \" \" + dt.getDate();\n}\nfunction getWeekDates(): string[] {\n const t = new Date(); const dow = t.getDay();\n const mon = new Date(t); mon.setDate(t.getDate() - (dow === 0 ? 6 : dow - 1));\n return Array.from({length:7}, (_,i) => {\n const d = new Date(mon); d.setDate(mon.getDate() + i);\n return d.toISOString().slice(0,10);\n });\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 // migration: add recurring column if missing\n try { await sqlite.execute(\"ALTER TABLE cc_schedule ADD COLUMN recurring INTEGER DEFAULT 0\"); } catch {/**/}\n try { await sqlite.execute(\"ALTER TABLE cc_schedule ADD COLUMN date TEXT DEFAULT ''\"); } 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(`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 { sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\"Court Mon Aug 25\", \"Rent owed $6,928 Â· Cash $2,668 Â· Writ not filed\", \"High\"] },\n { sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\"Ben SSI Sept 1\", \"$994/mo â pay toward rent immediately\", \"Normal\"] },\n { sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\",\n args: [\"Colin refund ~$4,042\", \"Expected Sept 24 â clear rent balance\", \"Normal\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Call Walmart â confirm job offer still open\", \"Matthew\", \"High\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Contact landlord re: $2,668 now + plan\", \"Lauren\", \"High\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Push Golden Door inspection\", \"Lauren\", \"Normal\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Clean room\", \"Colin\", \"Normal\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Dishes\", \"Lily\", \"Normal\"] },\n { sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\",\n args: [\"Reading time\", \"Ben\", \"Normal\"] },\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 = [\"Kitchen Clean (after dinner)\",\"Sweep & Mop\",\"Laundry\",\n \"Bathroom Clean\",\"Take Out Trash\",\"Vacuum Living Room\",\"Wipe Down Surfaces\"];\n for (let i = 0; i < chores.length; i++) {\n await sqlite.execute({ sql: \"INSERT INTO cc_chores(name,sort_order) VALUES(?,?)\", args: [chores[i], i] });\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({ sql: \"INSERT INTO cc_schedule(title,time,who,date,recurring) VALUES(?,?,?,'',1)\", args: [title, time, who] });\n }\n await sqlite.execute(\"INSERT INTO cc_seed(key) VALUES('v3')\");\n }\n}\n\n// --- API ---\napp.post(\"/task/toggle\", async (c) => {\n const { id, done } = await c.req.json();\n await sqlite.execute({ sql: \"UPDATE cc_tasks SET done=? WHERE id=?\", args: [done?1:0, id] });\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({ sql: \"INSERT INTO cc_tasks(title,who,priority) VALUES(?,?,?)\", args: [title, who, priority||\"Normal\"] });\n return c.json({ ok: true });\n});\napp.delete(\"/task/:id\", async (c) => {\n await sqlite.execute({ sql: \"DELETE FROM cc_tasks WHERE id=?\", args: [c.req.param(\"id\")] });\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({ sql: \"INSERT INTO cc_schedule(title,time,who,date,recurring) VALUES(?,?,?,?,?)\", args: [title, time, who, recurring ? '' : (date||today()), recurring?1:0] });\n return c.json({ ok: true });\n});\napp.delete(\"/schedule/:id\", async (c) => {\n await sqlite.execute({ sql: \"DELETE FROM cc_schedule WHERE id=?\", args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n});\napp.post(\"/alert/dismiss\", async (c) => {\n const { id } = await c.req.json();\n await sqlite.execute({ sql: \"UPDATE cc_alerts SET active=0 WHERE id=?\", args: [id] });\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({ sql: \"INSERT INTO cc_alerts(title,note,urgency) VALUES(?,?,?)\", args: [title, note||\"\", urgency||\"Normal\"] });\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({ sql: \"UPDATE cc_alerts SET title=?,note=?,urgency=? WHERE id=?\", args: [title, note||\"\", urgency||\"Normal\", id] });\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({ sql: \"INSERT OR IGNORE INTO cc_chore_done(chore_id,date) VALUES(?,?)\", args: [id, date] });\n } else {\n await sqlite.execute({ sql: \"DELETE FROM cc_chore_done WHERE chore_id=? AND date=?\", args: [id, date] });\n }\n return c.json({ ok: true });\n});\napp.post(\"/chore/add\", async (c) => {\n const { name } = await c.req.json();\n const cnt = (await sqlite.execute(\"SELECT COUNT(*) as n FROM cc_chores\")).rows[0];\n await sqlite.execute({ sql: \"INSERT INTO cc_chores(name,sort_order) VALUES(?,?)\", args: [name, cnt.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({ sql: \"DELETE FROM cc_chore_done WHERE chore_id=?\", args: [id] });\n await sqlite.execute({ sql: \"DELETE FROM cc_chores WHERE id=?\", args: [id] });\n return c.json({ ok: true });\n});\n\n// --- Main page ---\napp.get(\"/\", async (c) => {\n await setup();\n const t = today();\n const week = getWeekDates(); // MonâSun\n const todayIdx = week.indexOf(t);\n\n // Weather\n let wxCurrent = \"\"; let wxForecastHTML = \"\";\n try {\n const wr = await fetch(\"https://wttr.in/Bowling+Green,KY?format=j1\", { signal: AbortSignal.timeout(3000) });\n const wx = await wr.json();\n const cur = wx.current_condition?.[0];\n if (cur) wxCurrent = cur.temp_F + \"Â°F Â· \" + (cur.weatherDesc?.[0]?.value||\"\") + \" Â· Feels \" + cur.FeelsLikeF + \"Â°\";\n const WICO: Record = {113:\"âï¸\",116:\"ð¤\",119:\"â\",122:\"âï¸\",143:\"ð«\",176:\"ð¦\",179:\"ð¨\",182:\"ð§\",200:\"â\",227:\"âï¸\",248:\"ð«\",263:\"ð¦\",293:\"ð¦\",296:\"ð¦\",299:\"ð§\",302:\"ð§\",305:\"ð§\",308:\"ð§\",353:\"ð¦\",356:\"ð§\",359:\"ð§\",386:\"â\",389:\"â\"};\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 `

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

`;\n }).join(\"\");\n } catch {/**/}\n\n const [sched, tasks, alerts, chores] = await Promise.all([\n sqlite.execute({ sql: \"SELECT * FROM cc_schedule WHERE date=? OR recurring=1 ORDER BY time\", args: [t] }),\n sqlite.execute(\"SELECT * FROM cc_tasks WHERE done=0 ORDER BY CASE priority WHEN 'High' THEN 0 ELSE 1 END, who\"),\n sqlite.execute(\"SELECT * FROM cc_alerts WHERE active=1 ORDER BY CASE urgency WHEN 'High' THEN 0 ELSE 1 END\"),\n sqlite.execute(\"SELECT * FROM cc_chores ORDER BY sort_order\"),\n ]);\n\n // Chore done map\n const doneRows = chores.rows.length\n ? (await sqlite.execute({\n sql: `SELECT chore_id,date FROM cc_chore_done WHERE date IN (${week.map(()=>\"?\").join(\",\")})`,\n args: week\n })).rows\n : [];\n const doneSet = new Set(doneRows.map(r => r.chore_id + \"|\" + r.date));\n\n // Week label\n const DS2 = [\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\"];\n const MO2 = [\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"];\n const wkStart = new Date(week[0]+\"T12:00:00\"), wkEnd = new Date(week[6]+\"T12:00:00\");\n const wkLabel = MO2[wkStart.getMonth()]+\" \"+wkStart.getDate()+\" â \"+MO2[wkEnd.getMonth()]+\" \"+wkEnd.getDate();\n const DOW_SHORT = [\"MO\",\"TU\",\"WE\",\"TH\",\"FR\",\"SA\",\"SU\"];\n\n // Schedule HTML\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\n // Alerts / Bulletin HTML\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\n // Tasks HTML\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\" ? ` HBÉGH` : \"\") +\n `

` +\n `

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

` +\n `` +\n `

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

All done! ð

`;\n\n // Chore grid HTML\n const choreGridHTML = chores.rows.length\n ? `

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

${d}

`).join(\"\")}

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

` +\n `

${r.name}` +\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 }).join(\"\")}

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

No chores added yet.

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

\n\n\n

\n\n

\n ð Today's Schedule\n \n

${schedHTML}

\n\n

\n ð Bulletin Board\n

\n ${alertsHTML}\n

\n \n \n

\n\n

\n â Family Tasks\n \n

${tasksHTML}

\n\n

\n ð§¹ House Chore Routines\n ${wkLabel}\n

\n ${choreGridHTML}\n

\n \n \n

\n\n

\n ð° Budget Overview\n \n

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

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

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

No budget alerts

`}\n ${FINANCE_URL ? `` : ''}\n

\n\n

\n\n\n

\n \n

\n\n

\n \n

\n\n

\n \n

\n\n

\n \n

\n\n\n\n`);\n});\n\nexport default app.fetch;","deleted",false,"label",[14],"97212119-db06-4432-b400-29897fe0c23a",["D",1787503747686],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","a34d3984-f7ff-45c7-8cf9-da348239030b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02ab2-177b-7333-b8d0-654b7dc95254","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_100":96},"org",{"_9":10,"_93":94,"_95":96,"_54":55,"_97":98,"_99":42},"branch",{"_35":30,"_11":84,"_22":28,"_85":45,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":12,"_92":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Lauren Bratcher","avatar","https://lh3.googleusercontent.com/a/ACg8ocJbOXDwjhfMAGEIlJWXa7oDRpWz83Z4wRjsExqR4SYZegQHGaM=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_77":-5,"_134":135,"_136":137,"_138":139,"_140":42,"_141":42,"_142":42,"_143":32,"_144":-5,"_145":-7,"_146":-7,"_147":61,"_148":42,"_149":42,"_150":-5,"_151":42,"_152":42,"_153":42,"_154":-5},"ENV",{"_105":106,"_107":108,"_109":84,"_110":111,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133},"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"]

Add Task

Add Event

Add Budget Alert

Edit Note