[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_298":299,"_300":301},"routes/_app.x.$handle.$name",{"_111":110,"_38":51,"_120":97,"_33":121,"_13":14,"_122":-5,"_11":123,"_124":125,"_126":127,"_128":129,"_130":131,"_26":-5,"_132":133,"_134":135,"_136":31,"_137":138,"_139":66,"_140":-5,"_141":-5,"_142":143},"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":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":78,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",13,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","2c5f6387-2ec0-4c17-b951-6edde3f64261","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","sync.ts","latestPath","fileId","dfb90b4e-7b85-11f1-989d-1607ee4eb77e","name","fileType","interval","content","/**\n * Cron job — runs every 6 hours, fetches new WhatsApp messages from Unipile\n * and stores them as todo cards in the \"inbox\" column.\n *\n * Schedule: every 6 hours (UTC): 00:00, 06:00, 12:00, 18:00\n */\nimport { initDB, insertTodo, todoExists } from \"./lib/db.ts\";\nimport { getChatMap, getMessagesSince } from \"./lib/unipile.ts\";\n\nexport default async function(interval: Interval) {\n await initDB();\n\n // Use lastRunAt for incremental sync, or 24h ago on first run\n const since = interval.lastRunAt ?? new Date(Date.now() - 24 * 60 * 60 * 1000);\n\n console.log(`Syncing WhatsApp messages since ${since.toISOString()}…`);\n\n // Fetch chat names so we can label each todo\n let chatMap: Map;\n try {\n chatMap = await getChatMap();\n } catch (e) {\n console.error(\"Failed to fetch chat map:\", e);\n chatMap = new Map();\n }\n\n // Fetch messages since last run\n const messages = await getMessagesSince(since);\n console.log(`Found ${messages.length} messages since last sync`);\n\n let newCount = 0;\n for (const msg of messages) {\n // Skip messages we already have (dedup by message_id)\n const exists = await todoExists(msg.message_id);\n if (exists) continue;\n\n const chatName = chatMap.get(msg.chat_id) ?? null;\n\n await insertTodo({\n message_id: msg.message_id,\n chat_id: msg.chat_id,\n chat_name: chatName,\n sender_id: msg.sender_id,\n text: msg.text,\n message_timestamp: msg.timestamp,\n });\n newCount++;\n }\n\n console.log(`Sync complete. ${newCount} new todos added.`);\n}\n","/**\n * Cron job — runs every 6 hours, fetches new WhatsApp messages from Unipile,\n * groups them per chat, and sends each chat's unprocessed messages to\n * Cerebras (gpt-oss-120b) to extract real, actionable todos. Extracted\n * todos are tagged with whatever project the chat is mapped to (see the\n * Settings panel in the UI) and stored in the \"inbox\" column.\n *\n * Schedule: every 6 hours (UTC): 00:00, 06:00, 12:00, 18:00\n */\nimport {\n getProjectForChat,\n initDB,\n insertTodo,\n isMessageProcessed,\n markMessagesProcessed,\n} from \"./lib/db.ts\";\nimport { extractTodos } from \"./lib/cerebras.ts\";\nimport { getChatMap, getMessagesSince, type UnipileMessage } from \"./lib/unipile.ts\";\n\nexport default async function(interval: Interval) {\n await initDB();\n\n // Use lastRunAt for incremental sync, or 24h ago on first run\n const since = interval.lastRunAt ?? new Date(Date.now() - 24 * 60 * 60 * 1000);\n\n console.log(`Syncing WhatsApp messages since ${since.toISOString()}…`);\n\n // Fetch chat names so we can label each todo\n let chatMap: Map;\n try {\n chatMap = await getChatMap();\n } catch (e) {\n console.error(\"Failed to fetch chat map:\", e);\n chatMap = new Map();\n }\n\n // Fetch messages since last run\n const messages = await getMessagesSince(since);\n console.log(`Found ${messages.length} messages since last sync`);\n\n // Drop messages we've already sent through the LLM, then group the rest by chat\n const byChat = new Map();\n for (const msg of messages) {\n if (await isMessageProcessed(msg.message_id)) continue;\n const arr = byChat.get(msg.chat_id) ?? [];\n arr.push(msg);\n byChat.set(msg.chat_id, arr);\n }\n console.log(`${byChat.size} chat(s) have unprocessed messages`);\n\n let newCount = 0;\n for (const [chatId, msgs] of byChat) {\n const chatName = chatMap.get(chatId) ?? null;\n const projectName = await getProjectForChat(chatId);\n\n let extracted: Awaited> = [];\n try {\n extracted = await extractTodos({\n chatName,\n projectName,\n messages: msgs.map((m) => ({\n sender_id: m.sender_id,\n text: m.text ?? \"\",\n timestamp: m.timestamp,\n })),\n });\n } catch (e) {\n console.error(`Cerebras extraction failed for chat ${chatId} (${chatName}):`, e);\n // Don't mark these messages processed — retry next sync.\n continue;\n }\n\n const lastMsg = msgs[msgs.length - 1];\n for (const todo of extracted) {\n if (!todo.is_actionable) continue;\n await insertTodo({\n // Synthetic id: one raw message batch can produce multiple todos.\n message_id: `llm:${lastMsg.message_id}:${crypto.randomUUID().slice(0, 8)}`,\n chat_id: chatId,\n chat_name: chatName,\n sender_id: msgs[0].sender_id,\n text: todo.title,\n summary: todo.summary,\n project: projectName,\n priority: todo.priority,\n due_date: todo.due_date,\n message_timestamp: lastMsg.timestamp,\n });\n newCount++;\n }\n\n await markMessagesProcessed(msgs.map((m) => m.message_id), chatId);\n }\n\n console.log(`Sync complete. ${newCount} new todo(s) extracted from ${byChat.size} chat(s).`);\n}\n","createdAt",["D",1783597501393],"branchVersion","branchId","a52da4fb-15ea-4f30-bbe0-39f3771bb4ad","id","b692b696-2b15-441d-a326-d712abe74fe4","whatsapp-kanban",["D",1783594988490],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","WhatsApp messages to kanban board via Unipile API","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789534799&sig=2fe932419d898cd124d0961cab25a5a9c3bd76c8b30cb3b9e71257c7b34e60a2","0910d18e-3719-43e3-9e3f-2f3a7688390c","pinnedFileId","019f468b-b4f0-7369-b149-e27a1d885fbe","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f447f-11d2-72d3-9ef7-3fd5b5a0910e","tursoName","b692b6962b15441da326d712abe74fe4","tursoHostname","b692b6962b15441da326d712abe74fe4-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_111":110,"_119":115},"org",{"_111":110,"_112":113,"_114":115,"_19":62,"_116":117,"_118":31},"branch",{"_13":96,"_38":97,"_49":48,"_98":50,"_99":100,"_101":102,"_103":56,"_104":105,"_106":107,"_108":51,"_109":110},"isOwned",18,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","pc_style","handle","displayName","Adam","avatar","https://lh3.googleusercontent.com/a/ACg8ocKezdd7dJ4xoybqc1M7fdCby5p64ImbU5Jg7JpmalJ4ktU1Bw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":293,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":294,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":295,"_91":296,"_93":297,"_95":31},"tree",[203,209,213,214,215],"files",[203,204,205,206,207,208,209,210,211,212,213,214,215],"counts",{"_193":70,"_194":164,"_195":70,"_196":197,"_198":199},"contents",[155,156,157,158,159],"upstreamProject",{"_49":105,"_38":151,"_58":152,"_60":61,"_55":56,"_89":153},"upstreamBranch",{"_49":100,"_44":144,"_145":146,"_38":97,"_98":105,"_13":147,"_99":-5,"_101":-5,"_148":149,"_53":-5,"_95":31,"_55":56,"_109":150,"_71":107,"_108":151},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","Starter template with client-side React & Hono server",{"_111":150,"_119":154},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789534799&sig=94d49ad984a50880ef894a3794e08842e7b9b626be771ff48da114d7d9a149ed",{"_49":188,"_38":189,"_36":190,"_161":-5,"_47":48,"_46":164,"_162":66,"_44":191,"_13":70,"_39":186,"_41":-5,"_30":31,"_165":-5,"_33":192},{"_49":181,"_38":182,"_36":183,"_161":-5,"_47":48,"_46":184,"_162":66,"_44":185,"_13":70,"_39":186,"_41":-5,"_30":31,"_165":-5,"_33":187},{"_49":174,"_38":175,"_36":176,"_161":-5,"_47":48,"_46":177,"_162":31,"_44":178,"_13":164,"_39":26,"_41":179,"_30":31,"_165":-5,"_33":180},{"_49":167,"_38":168,"_36":64,"_161":-5,"_47":48,"_46":169,"_162":31,"_44":170,"_13":164,"_39":171,"_41":172,"_30":31,"_165":-5,"_33":173},{"_49":160,"_38":34,"_36":37,"_161":-5,"_47":48,"_46":14,"_162":66,"_44":163,"_13":164,"_39":40,"_41":43,"_30":31,"_165":-5,"_33":166},"d442fe2e-eadf-469f-92d5-c4957bbd7488","parentId","latest",["D",1783597501393],1,"label",[34],"d3cd6483-7953-4bf5-8a37-6dd651f48b16","index.ts",5,["D",1783595052723],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport {\n deleteTodo,\n getAllTodos,\n initDB,\n updateTodoStatus,\n type TodoStatus,\n} from \"./lib/db.ts\";\n\nconst app = new Hono();\n\n// --- Simple passphrase auth ---\nconst PASSPHRASE = Deno.env.get(\"BOARD_PASSPHRASE\");\n\nfunction checkAuth(c: any): boolean {\n if (!PASSPHRASE) return true; // no passphrase set = open access\n const auth = c.req.header(\"Authorization\") ?? \"\";\n return auth === `Bearer ${PASSPHRASE}`;\n}\n\n// --- Static frontend ---\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// --- API routes ---\napp.use(\"/api/*\", cors());\n\napp.get(\"/api/todos\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n await initDB();\n const todos = await getAllTodos();\n return c.json({ todos });\n});\n\napp.patch(\"/api/todos/:id\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n const status = body.status as TodoStatus;\n const valid: TodoStatus[] = [\"inbox\", \"todo\", \"doing\", \"done\"];\n if (!valid.includes(status)) {\n return c.json({ error: \"Invalid status\" }, 400);\n }\n await updateTodoStatus(id, status);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/todos/:id\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const id = Number(c.req.param(\"id\"));\n await deleteTodo(id);\n return c.json({ ok: true });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[168],"b7ef73e1-0270-4051-ac29-3e78eeb64879","README.md","019f468b-b4f0-7369-b149-dfc02b3ec667",9,["D",1783595094729],"# WhatsApp Kanban\n\nA cron job that fetches your WhatsApp messages via [Unipile](https://developer.unipile.com/) and turns them into a todo kanban board.\n\n## How it works\n\n```mermaid\ngraph LR\n WA[WhatsApp] -->|Unipile API| Sync[\"sync.ts
(cron every 6h)\"]\n Sync -->|stores todos| DB[(SQLite)]\n UI[\"index.ts
(Hono server)\"] -->|reads/writes| DB\n Browser -->|loads kanban UI| UI\n```\n\n1. **`sync.ts`** (interval cron) — runs every 6 hours, fetches new WhatsApp messages from Unipile's `GET /api/v1/messages` endpoint, and stores them as todo cards in the \"Inbox\" column.\n2. **`index.ts`** (HTTP) — serves the React kanban UI and API routes for moving/deleting cards.\n3. **SQLite** — stores todos with 4 statuses: `inbox → todo → doing → done`.\n\n## Setup\n\n### 1. Connect your WhatsApp account to Unipile\n\nFollow the [Unipile WhatsApp guide](https://developer.unipile.com/docs/whatsapp.md) to connect your WhatsApp account. Note your **account ID** from the Unipile dashboard.\n\n### 2. Set environment variables\n\n| Env var | Description |\n| --- | --- |\n| `UNIPILE_DSN` | Your Unipile data source URL (e.g. `https://xxx.unipile.com`) |\n| `UNIPILE_API_KEY` | Your Unipile access token |\n| `UNIPILE_ACCOUNT_ID` | The WhatsApp account ID linked in Unipile |\n| `BOARD_PASSPHRASE` | A passphrase to protect your kanban board (since the val is public on free tier) |\n\n👉 Add UNIPILE_DSN here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=UNIPILE_DSN\n👉 Add UNIPILE_API_KEY here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=UNIPILE_API_KEY\n👉 Add UNIPILE_ACCOUNT_ID here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=UNIPILE_ACCOUNT_ID\n👉 Add BOARD_PASSPHRASE here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=BOARD_PASSPHRASE\n\n### 3. Test the sync\n\nRun `sync.ts` manually from the Val Town editor to pull your first batch of messages.\n\n## File structure\n\n```\nsync.ts ← Cron job (every 6h) — fetches WhatsApp messages\nindex.ts ← Hono server — serves UI + API routes\nlib/\n db.ts ← SQLite schema + todo CRUD helpers\n unipile.ts ← Unipile API client\nfrontend/\n index.html ← HTML shell\n index.tsx ← React entrypoint\n components/App.tsx ← Kanban board UI\n```\n\n## API endpoints\n\n| Method | Path | Description |\n| --- | --- | --- |\n| `GET` | `/api/todos` | List all todos |\n| `PATCH` | `/api/todos/:id` | Move a card (`{ status: \"inbox\\|todo\\|doing\\|done\" }`) |\n| `DELETE` | `/api/todos/:id` | Delete a card |\n",[175],"8ad64489-dc06-480b-a0c6-bc25388b4983","lib","2e91bb20-4ddb-46a1-baac-39eaf20965ba",2,["D",1783595012387],"directory",[182],"d9efa8a0-aa61-481d-8bb5-65332a0ea515","frontend","019f468b-b4f0-7369-b149-d8843be286ad",["D",1783594988490],[189],"pulls","branches","forks","envVars",{"_200":169,"_202":70},"connections",{"_200":70,"_201":70},"count","unfilledCount","emptyCount",{"_49":188,"_38":189,"_36":190,"_161":-5,"_47":48,"_46":164,"_162":66,"_44":290,"_13":70,"_39":186,"_41":-5,"_30":31,"_165":-5,"_217":291,"_33":292},{"_49":286,"_38":285,"_36":279,"_161":190,"_47":48,"_46":164,"_162":66,"_44":287,"_13":70,"_39":186,"_41":-5,"_30":31,"_165":-5,"_217":288,"_33":289},{"_49":276,"_38":277,"_36":278,"_161":279,"_47":48,"_46":280,"_162":31,"_44":281,"_13":164,"_39":231,"_41":282,"_30":31,"_165":-5,"_217":283,"_33":284},{"_49":269,"_38":270,"_36":271,"_161":190,"_47":48,"_46":164,"_162":66,"_44":272,"_13":70,"_39":26,"_41":273,"_30":31,"_165":-5,"_217":274,"_33":275},{"_49":261,"_38":262,"_36":263,"_161":190,"_47":48,"_46":264,"_162":66,"_44":265,"_13":164,"_39":26,"_41":266,"_30":31,"_165":-5,"_217":267,"_33":268},{"_49":254,"_38":255,"_36":256,"_161":190,"_47":48,"_46":164,"_162":66,"_44":257,"_13":70,"_39":231,"_41":258,"_30":31,"_165":-5,"_217":259,"_33":260},{"_49":181,"_38":182,"_36":183,"_161":-5,"_47":48,"_46":184,"_162":66,"_44":251,"_13":70,"_39":186,"_41":-5,"_30":31,"_165":-5,"_217":252,"_33":253},{"_49":243,"_38":244,"_36":245,"_161":183,"_47":48,"_46":246,"_162":66,"_44":247,"_13":70,"_39":231,"_41":248,"_30":31,"_165":-5,"_217":249,"_33":250},{"_49":235,"_38":236,"_36":237,"_161":183,"_47":48,"_46":238,"_162":66,"_44":239,"_13":164,"_39":231,"_41":240,"_30":31,"_165":-5,"_217":241,"_33":242},{"_49":226,"_38":227,"_36":228,"_161":183,"_47":48,"_46":229,"_162":66,"_44":230,"_13":164,"_39":231,"_41":232,"_30":31,"_165":-5,"_217":233,"_33":234},{"_49":174,"_38":175,"_36":176,"_161":-5,"_47":48,"_46":177,"_162":31,"_44":223,"_13":164,"_39":26,"_41":179,"_30":31,"_165":-5,"_217":224,"_33":225},{"_49":167,"_38":168,"_36":64,"_161":-5,"_47":48,"_46":169,"_162":31,"_44":220,"_13":164,"_39":171,"_41":172,"_30":31,"_165":-5,"_217":221,"_33":222},{"_49":160,"_38":34,"_36":37,"_161":-5,"_47":48,"_46":14,"_162":66,"_44":216,"_13":164,"_39":40,"_41":43,"_30":31,"_165":-5,"_217":218,"_33":219},["D",1783597501393],"children",[],[34],["D",1783595052723],[],[168],["D",1783595094729],[],[175],"c109312b-a6f7-4991-8ae8-767f96d10cd8","unipile.ts","dfb3650e-7b85-11f1-bc53-1607ee4eb77e",11,["D",1783597469525],"script","/**\n * Unipile API client — fetches WhatsApp messages and chat metadata.\n * Docs: https://developer.unipile.com/docs/get-messages\n * https://developer.unipile.com/docs/get-chats\n *\n * Required env vars:\n * UNIPILE_DSN — your Unipile data source name (e.g. https://xxx.unipile.com)\n * UNIPILE_API_KEY — your Unipile access token\n * UNIPILE_ACCOUNT_ID — the WhatsApp account ID linked in Unipile\n */\n\nexport interface UnipileMessage {\n message_id: string;\n chat_id: string;\n sender_id: string;\n text: string | null;\n timestamp: string;\n account_id: string;\n}\n\nexport interface UnipileChat {\n id: string;\n name: string;\n}\n\nfunction baseUrl(): string {\n const dsn = Deno.env.get(\"UNIPILE_DSN\");\n if (!dsn) throw new Error(\"UNIPILE_DSN env var not set\");\n return dsn.replace(/\\/$/, \"\");\n}\n\nfunction headers(): Record {\n const key = Deno.env.get(\"UNIPILE_API_KEY\");\n if (!key) throw new Error(\"UNIPILE_API_KEY env var not set\");\n return {\n \"X-API-KEY\": key,\n \"accept\": \"application/json\",\n };\n}\n\nfunction accountId(): string {\n const id = Deno.env.get(\"UNIPILE_ACCOUNT_ID\");\n if (!id) throw new Error(\"UNIPILE_ACCOUNT_ID env var not set\");\n return id;\n}\n\n/**\n * Fetch all WhatsApp chats (id + name), e.g. to let a user map\n * a chat/client to a project name.\n */\nexport async function getChats(): Promise {\n const url = new URL(`${baseUrl()}/api/v1/chats`);\n url.searchParams.set(\"account_id\", accountId());\n url.searchParams.set(\"account_type\", \"WHATSAPP\");\n url.searchParams.set(\"limit\", \"250\");\n\n const res = await fetch(url, { headers: headers() });\n if (!res.ok) {\n throw new Error(`Unipile chats API error: ${res.status} ${await res.text()}`);\n }\n\n const data = await res.json();\n const chats: UnipileChat[] = [];\n for (const chat of data.items ?? []) {\n if (chat.id) chats.push({ id: chat.id, name: chat.name ?? chat.id });\n }\n return chats;\n}\n\n/**\n * Fetch all WhatsApp chats to build a chat_id → name map.\n */\nexport async function getChatMap(): Promise> {\n const chats = await getChats();\n const map = new Map();\n for (const chat of chats) map.set(chat.id, chat.name);\n return map;\n}\n\n/**\n * Fetch messages since a given date. Uses the \"after\" parameter\n * and handles cursor pagination.\n */\nexport async function getMessagesSince(\n since: Date,\n): Promise {\n const allMessages: UnipileMessage[] = [];\n let cursor: string | null = null;\n\n // Fetch a slightly wider window than strictly necessary to catch\n // any messages missed during previous runs\n const after = new Date(since.getTime() - 60 * 60 * 1000); // 1h buffer\n\n for (let page = 0; page < 10; page++) {\n const url = new URL(`${baseUrl()}/api/v1/messages`);\n url.searchParams.set(\"account_id\", accountId());\n url.searchParams.set(\"after\", after.toISOString());\n url.searchParams.set(\"limit\", \"250\");\n if (cursor) url.searchParams.set(\"cursor\", cursor);\n\n const res = await fetch(url, { headers: headers() });\n if (!res.ok) {\n throw new Error(\n `Unipile messages API error: ${res.status} ${await res.text()}`,\n );\n }\n\n const data = await res.json();\n for (const msg of data.items ?? []) {\n if (msg.message_id && msg.text) {\n allMessages.push({\n message_id: msg.message_id,\n chat_id: msg.chat_id,\n sender_id: msg.sender_id,\n text: msg.text,\n timestamp: msg.timestamp,\n account_id: msg.account_id,\n });\n }\n }\n\n cursor = data.cursor;\n if (!cursor) break;\n }\n\n return allMessages;\n}\n",[],[182,227],"8dc1872f-144a-4469-ba1c-1d304e582be5","db.ts","d2e06c5a-7b85-11f1-88fa-1607ee4eb77e",12,["D",1783597487886],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type TodoStatus = \"inbox\" | \"todo\" | \"doing\" | \"done\";\nexport type TodoPriority = \"low\" | \"medium\" | \"high\";\n\nexport interface Todo {\n id: number;\n message_id: string;\n chat_id: string | null;\n chat_name: string | null;\n sender_id: string | null;\n sender_name: string | null;\n text: string | null;\n summary: string | null;\n project: string | null;\n priority: TodoPriority | null;\n due_date: string | null;\n status: TodoStatus;\n message_timestamp: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface ProjectMapping {\n chat_id: string;\n chat_name: string | null;\n project_name: string;\n updated_at: string;\n}\n\nexport const COLUMNS: { key: TodoStatus; label: string; color: string }[] = [\n { key: \"inbox\", label: \"📥 Inbox\", color: \"bg-gray-100\" },\n { key: \"todo\", label: \"📋 To Do\", color: \"bg-blue-100\" },\n { key: \"doing\", label: \"🔄 In Progress\", color: \"bg-amber-100\" },\n { key: \"done\", label: \"✅ Done\", color: \"bg-green-100\" },\n];\n\nasync function tryAlter(sql: string) {\n try {\n await sqlite.execute(sql);\n } catch {\n // column already exists — ignore\n }\n}\n\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT UNIQUE NOT NULL,\n chat_id TEXT,\n chat_name TEXT,\n sender_id TEXT,\n sender_name TEXT,\n text TEXT,\n status TEXT NOT NULL DEFAULT 'inbox',\n message_timestamp TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Additive columns for LLM-extracted todos (safe to run repeatedly)\n await tryAlter(`ALTER TABLE todos ADD COLUMN summary TEXT`);\n await tryAlter(`ALTER TABLE todos ADD COLUMN project TEXT`);\n await tryAlter(`ALTER TABLE todos ADD COLUMN priority TEXT`);\n await tryAlter(`ALTER TABLE todos ADD COLUMN due_date TEXT`);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_todos_status ON todos(status)\n `);\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_todos_project ON todos(project)\n `);\n\n // Tracks which raw WhatsApp messages have already been sent to the LLM,\n // so a chat with no actionable content isn't re-processed every sync.\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS processed_messages (\n message_id TEXT PRIMARY KEY,\n chat_id TEXT,\n processed_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Maps a WhatsApp chat (client/contact/group) to a project name.\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS project_mappings (\n chat_id TEXT PRIMARY KEY,\n chat_name TEXT,\n project_name TEXT NOT NULL,\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n\nexport async function insertTodo(\n msg: {\n message_id: string;\n chat_id?: string | null;\n chat_name?: string | null;\n sender_id?: string | null;\n sender_name?: string | null;\n text?: string | null;\n summary?: string | null;\n project?: string | null;\n priority?: TodoPriority | null;\n due_date?: string | null;\n message_timestamp?: string | null;\n },\n): Promise {\n try {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO todos\n (message_id, chat_id, chat_name, sender_id, sender_name, text, summary, project, priority, due_date, message_timestamp)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n msg.message_id,\n msg.chat_id ?? null,\n msg.chat_name ?? null,\n msg.sender_id ?? null,\n msg.sender_name ?? null,\n msg.text ?? null,\n msg.summary ?? null,\n msg.project ?? null,\n msg.priority ?? null,\n msg.due_date ?? null,\n msg.message_timestamp ?? null,\n ],\n });\n return true;\n } catch (e) {\n console.error(\"Failed to insert todo:\", e);\n return false;\n }\n}\n\nexport async function getAllTodos(): Promise {\n await initDB();\n const result = await sqlite.execute(\n \"SELECT * FROM todos ORDER BY message_timestamp DESC\",\n );\n return result.rows as unknown as Todo[];\n}\n\nexport async function updateTodoStatus(\n id: number,\n status: TodoStatus,\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE todos SET status = ?, updated_at = datetime('now') WHERE id = ?\",\n args: [status, id],\n });\n}\n\nexport async function deleteTodo(id: number): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM todos WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function todoExists(messageId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM todos WHERE message_id = ? LIMIT 1\",\n args: [messageId],\n });\n return result.rows.length > 0;\n}\n\n// --- Processed-message tracking (dedup for the LLM extraction pass) ---\n\nexport async function isMessageProcessed(messageId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM processed_messages WHERE message_id = ? LIMIT 1\",\n args: [messageId],\n });\n return result.rows.length > 0;\n}\n\nexport async function markMessagesProcessed(\n messageIds: string[],\n chatId: string | null,\n): Promise {\n if (messageIds.length === 0) return;\n const statements = messageIds.map((id) => ({\n sql: \"INSERT OR IGNORE INTO processed_messages (message_id, chat_id) VALUES (?, ?)\",\n args: [id, chatId],\n }));\n for (const stmt of statements) {\n await sqlite.execute(stmt);\n }\n}\n\n// --- Client/chat → project mapping ---\n\nexport async function getProjectMappings(): Promise {\n await initDB();\n const result = await sqlite.execute(\n \"SELECT * FROM project_mappings ORDER BY project_name ASC\",\n );\n return result.rows as unknown as ProjectMapping[];\n}\n\nexport async function getProjectForChat(chatId: string | null): Promise {\n if (!chatId) return null;\n const result = await sqlite.execute({\n sql: \"SELECT project_name FROM project_mappings WHERE chat_id = ? LIMIT 1\",\n args: [chatId],\n });\n const row = result.rows[0] as unknown as { project_name: string } | undefined;\n return row?.project_name ?? null;\n}\n\nexport async function setProjectMapping(\n chatId: string,\n chatName: string | null,\n projectName: string,\n): Promise {\n await sqlite.execute({\n sql: `INSERT INTO project_mappings (chat_id, chat_name, project_name, updated_at)\n VALUES (?, ?, ?, datetime('now'))\n ON CONFLICT(chat_id) DO UPDATE SET\n chat_name = excluded.chat_name,\n project_name = excluded.project_name,\n updated_at = datetime('now')`,\n args: [chatId, chatName, projectName],\n });\n}\n\nexport async function deleteProjectMapping(chatId: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM project_mappings WHERE chat_id = ?\",\n args: [chatId],\n });\n}\n",[],[182,236],"cc3f925f-b7cd-4ed0-ba68-61df57400f7b","cerebras.ts","84e587dc-7b8b-11f1-8559-1607ee4eb77e",10,["D",1783597458541],"/**\n * Cerebras Inference client — turns raw WhatsApp message batches into\n * structured, actionable todos using the gpt-oss-120b model.\n *\n * Docs: https://inference-docs.cerebras.ai/resources/openai\n * https://inference-docs.cerebras.ai/capabilities/structured-outputs\n *\n * Required env var:\n * CEREBRAS_API_KEY — your Cerebras Cloud API key\n */\n\nexport interface ExtractedTodo {\n title: string;\n summary: string;\n priority: \"low\" | \"medium\" | \"high\";\n is_actionable: boolean;\n due_date: string | null;\n}\n\nconst MODEL = \"gpt-oss-120b\";\n\nconst TODO_SCHEMA = {\n type: \"object\",\n properties: {\n todos: {\n type: \"array\",\n items: {\n type: \"object\",\n properties: {\n title: {\n type: \"string\",\n description: \"Short, actionable task title (max ~8 words), written as an imperative (e.g. 'Send invoice to client')\",\n },\n summary: {\n type: \"string\",\n description: \"1-2 sentence context pulled from the chat explaining the task\",\n },\n priority: { type: \"string\", enum: [\"low\", \"medium\", \"high\"] },\n is_actionable: {\n type: \"boolean\",\n description: \"false for greetings/small talk/acknowledgements that aren't really a task\",\n },\n due_date: {\n type: [\"string\", \"null\"],\n description: \"ISO 8601 date (YYYY-MM-DD) if a deadline is mentioned or implied, else null\",\n },\n },\n required: [\"title\", \"summary\", \"priority\", \"is_actionable\", \"due_date\"],\n additionalProperties: false,\n },\n },\n },\n required: [\"todos\"],\n additionalProperties: false,\n} as const;\n\nexport interface ChatMessage {\n sender_id: string | null;\n text: string;\n timestamp: string;\n}\n\n/**\n * Sends a batch of messages from a single chat to gpt-oss-120b and asks it\n * to extract concrete, actionable todo items via structured outputs.\n */\nexport async function extractTodos(opts: {\n chatName: string | null;\n projectName: string | null;\n messages: ChatMessage[];\n}): Promise {\n const apiKey = Deno.env.get(\"CEREBRAS_API_KEY\");\n if (!apiKey) throw new Error(\"CEREBRAS_API_KEY env var not set\");\n if (opts.messages.length === 0) return [];\n\n const transcript = opts.messages\n .map((m) => `[${m.timestamp}] ${m.sender_id ?? \"unknown\"}: ${m.text}`)\n .join(\"\\n\");\n\n const system = [\n \"You extract actionable to-do items from WhatsApp chat transcripts.\",\n `Chat: ${opts.chatName ?? \"unknown\"}${opts.projectName ? ` (project: ${opts.projectName})` : \"\"}`,\n \"Only include real tasks, requests, follow-ups, or commitments someone needs to act on.\",\n \"Ignore greetings, small talk, memes, forwards, and pure acknowledgements ('ok', 'thanks', 'lol').\",\n \"Merge duplicate/related asks into a single todo instead of repeating them.\",\n \"If nothing actionable is present, return an empty todos array.\",\n ].join(\"\\n\");\n\n const res = await fetch(\"https://api.cerebras.ai/v1/chat/completions\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${apiKey}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: MODEL,\n messages: [\n { role: \"system\", content: system },\n { role: \"user\", content: transcript },\n ],\n response_format: {\n type: \"json_schema\",\n json_schema: { name: \"extracted_todos\", strict: true, schema: TODO_SCHEMA },\n },\n }),\n });\n\n if (!res.ok) {\n throw new Error(`Cerebras API error: ${res.status} ${await res.text()}`);\n }\n\n const data = await res.json();\n const content = data.choices?.[0]?.message?.content ?? \"{}\";\n try {\n const parsed = JSON.parse(content);\n return (parsed.todos ?? []) as ExtractedTodo[];\n } catch (e) {\n console.error(\"Failed to parse Cerebras structured output:\", content, e);\n return [];\n }\n}\n",[],[182,244],["D",1783595012387],[210,211,212],[182],"16df641a-01b7-4b1f-ba39-d4de7794f77a","index.tsx","019f468b-b4f0-7369-b149-d5eb81405e19",["D",1783594988490],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[189,255],"f856b6ca-00de-4f73-8a82-47ce9611659f","index.html","019f468b-b4f0-7369-b149-d2dba6a9cd16",7,["D",1783595082382],"\n\n \n \n \n WhatsApp Kanban\n \n \n \n \n

\n \n \n \n\n",[],[189,262],"ecfda0a3-6b59-4c95-a760-16dae247d012","favicon.svg","019f468b-b4f0-7369-b149-cf47cce5f1ec",["D",1783594988490],"\n",[],[189,270],"a8dc0f62-be0f-4867-bdbd-5484b0c835b8","App.tsx","019f468b-b4f0-7369-b149-c3f2f6f7a406","019f468b-b4f0-7369-b149-cbac2c950bf8",6,["D",1783595082368],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState, useCallback } from \"https://esm.sh/react@18.2.0\";\n\ninterface Todo {\n id: number;\n message_id: string;\n chat_id: string | null;\n chat_name: string | null;\n sender_id: string | null;\n text: string | null;\n status: string;\n message_timestamp: string | null;\n created_at: string;\n}\n\nconst COLUMNS = [\n { key: \"inbox\", label: \"📥 Inbox\", color: \"bg-gray-100\", border: \"border-gray-300\" },\n { key: \"todo\", label: \"📋 To Do\", color: \"bg-blue-50\", border: \"border-blue-300\" },\n { key: \"doing\", label: \"🔄 In Progress\", color: \"bg-amber-50\", border: \"border-amber-300\" },\n { key: \"done\", label: \"✅ Done\", color: \"bg-green-50\", border: \"border-green-300\" },\n];\n\nfunction getAuthHeader(): string | null {\n return localStorage.getItem(\"board_passphrase\");\n}\n\nfunction apiHeaders(): Record {\n const h: Record = { \"Content-Type\": \"application/json\" };\n const pass = getAuthHeader();\n if (pass) h[\"Authorization\"] = `Bearer ${pass}`;\n return h;\n}\n\nfunction timeAgo(ts: string | null): string {\n if (!ts) return \"\";\n const d = new Date(ts);\n const diff = Date.now() - d.getTime();\n const hrs = Math.floor(diff / 3600000);\n if (hrs < 1) return \"just now\";\n if (hrs < 24) return `${hrs}h ago`;\n const days = Math.floor(hrs / 24);\n return `${days}d ago`;\n}\n\nfunction Card({ todo, onMove, onDelete }: {\n todo: Todo;\n onMove: (id: number, dir: -1 | 1) => void;\n onDelete: (id: number) => void;\n}) {\n const idx = COLUMNS.findIndex((c) => c.key === todo.status);\n return (\n

{todo.text}

\n {todo.chat_name && 💬 {todo.chat_name}}\n {\" \"}\n {timeAgo(todo.message_timestamp)}\n

\n onMove(todo.id, -1)}\n disabled={idx <= 0}\n class=\"text-gray-400 hover:text-gray-700 disabled:opacity-20 disabled:cursor-not-allowed text-sm px-1\"\n title=\"Move left\"\n >\n ←\n \n onMove(todo.id, 1)}\n disabled={idx >= COLUMNS.length - 1}\n class=\"text-gray-400 hover:text-gray-700 disabled:opacity-20 disabled:cursor-not-allowed text-sm px-1\"\n title=\"Move right\"\n >\n →\n \n onDelete(todo.id)}\n class=\"text-gray-300 hover:text-red-500 text-sm px-1 ml-1\"\n title=\"Delete\"\n >\n ✕\n \n

\n );\n}\n\nexport function App() {\n const [todos, setTodos] = useState([]);\n const [loading, setLoading] = useState(true);\n const [authed, setAuthed] = useState(() => !!getAuthHeader());\n const [passInput, setPassInput] = useState(\"\");\n const [authError, setAuthError] = useState(false);\n\n const fetchTodos = useCallback(async () => {\n try {\n const res = await fetch(\"/api/todos\", { headers: apiHeaders() });\n if (res.status === 401) {\n setAuthed(false);\n return;\n }\n const data = await res.json();\n setTodos(data.todos ?? []);\n } catch (e) {\n console.error(\"Failed to fetch todos:\", e);\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n if (authed) fetchTodos();\n }, [authed, fetchTodos]);\n\n // Auto-refresh every 60s\n useEffect(() => {\n if (!authed) return;\n const t = setInterval(fetchTodos, 60000);\n return () => clearInterval(t);\n }, [authed, fetchTodos]);\n\n async function handleLogin() {\n localStorage.setItem(\"board_passphrase\", passInput);\n const res = await fetch(\"/api/todos\", { headers: apiHeaders() });\n if (res.status === 401) {\n localStorage.removeItem(\"board_passphrase\");\n setAuthError(true);\n return;\n }\n setAuthed(true);\n setAuthError(false);\n }\n\n async function handleMove(id: number, dir: -1 | 1) {\n const todo = todos.find((t) => t.id === id);\n if (!todo) return;\n const idx = COLUMNS.findIndex((c) => c.key === todo.status);\n const next = COLUMNS[idx + dir];\n if (!next) return;\n // Optimistic update\n setTodos((prev) => prev.map((t) => t.id === id ? { ...t, status: next.key } : t));\n await fetch(`/api/todos/${id}`, {\n method: \"PATCH\",\n headers: apiHeaders(),\n body: JSON.stringify({ status: next.key }),\n });\n }\n\n async function handleDelete(id: number) {\n setTodos((prev) => prev.filter((t) => t.id !== id));\n await fetch(`/api/todos/${id}`, {\n method: \"DELETE\",\n headers: apiHeaders(),\n });\n }\n\n if (!authed) {\n return (\n

🔐 WhatsApp Kanban

Enter your passphrase to access the board

\n setPassInput((e.target as HTMLInputElement).value)}\n onKeyDown={(e) => e.key === \"Enter\" && handleLogin()}\n placeholder=\"Passphrase\"\n class=\"w-full border border-gray-300 rounded-lg px-4 py-2 mb-2 focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n {authError &&

Wrong passphrase

}\n \n Enter\n \n

\n );\n }\n\n return (\n

WhatsApp Kanban

\n {todos.length} cards\n { setLoading(true); fetchTodos(); }}\n class=\"text-sm text-blue-500 hover:text-blue-700\"\n >\n ↻ Refresh\n \n

\n\n {loading ? (\n

Loading…

\n ) : (\n

\n {COLUMNS.map((col) => {\n const colTodos = todos.filter((t) => t.status === col.key);\n return (\n

{col.label}

\n {colTodos.length}\n

\n {colTodos.length === 0 ? (\n

No cards

\n ) : (\n colTodos.map((todo) => (\n \n ))\n )}\n

\n );\n })}\n

\n )}\n\n

\n View source\n {\" · \"}\n Auto-refreshes every 60s · Syncs from WhatsApp every 6h\n

\n );\n}\n",[],[189,285,277],"components","81e05fa2-23f4-4b4a-9286-7bf0cef33dd1",["D",1783594988490],[205],[189,285],["D",1783594988490],[204,206,207,208],[189],["D",1783594988490],["D",1789525245864],{"_111":110,"_119":115},{"_111":110,"_112":113,"_114":115,"_19":62,"_116":117,"_118":31},{"_13":96,"_38":97,"_49":48,"_98":50,"_99":100,"_101":102,"_103":56,"_104":105,"_106":107,"_108":51,"_109":110},"ctx",{"_89":-5,"_141":331,"_332":333,"_334":335,"_336":31,"_337":31,"_338":31,"_339":66,"_340":-5,"_341":-7,"_342":-7,"_343":70,"_344":31,"_345":31,"_346":-5,"_347":31,"_348":31,"_349":31,"_350":-5},"ENV",{"_302":303,"_304":305,"_306":97,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330},"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"]

Diff · v13