\n \n \n \n\n",[18,89],"ecfda0a3-6b59-4c95-a760-16dae247d012",["D",1783594988490],"\n",[18,95],"81e05fa2-23f4-4b4a-9286-7bf0cef33dd1",["D",1783594988490],[18,100],"pulls","branches","forks","envVars",{"_96":236,"_237":26},"connections",{"_96":26,"_235":26},"unfilledCount",5,"emptyCount",{"_34":202,"_13":18,"_75":111,"_44":-5,"_36":37,"_203":41,"_204":24,"_38":337,"_40":26,"_78":101,"_206":-5,"_80":30,"_207":-5,"_259":338,"_17":339},{"_34":225,"_13":100,"_75":99,"_44":111,"_36":37,"_203":41,"_204":24,"_38":334,"_40":26,"_78":101,"_206":-5,"_80":30,"_207":-5,"_259":335,"_17":336},{"_34":326,"_13":327,"_75":328,"_44":99,"_36":37,"_203":329,"_204":24,"_38":330,"_40":275,"_78":79,"_206":331,"_80":30,"_207":-5,"_259":332,"_17":333},{"_34":318,"_13":319,"_75":320,"_44":99,"_36":37,"_203":321,"_204":24,"_38":322,"_40":26,"_78":79,"_206":323,"_80":30,"_207":-5,"_259":324,"_17":325},{"_34":221,"_13":95,"_75":94,"_44":111,"_36":37,"_203":41,"_204":24,"_38":315,"_40":26,"_78":21,"_206":223,"_80":30,"_207":-5,"_259":316,"_17":317},{"_34":217,"_13":89,"_75":88,"_44":111,"_36":37,"_203":104,"_204":24,"_38":312,"_40":41,"_78":21,"_206":219,"_80":30,"_207":-5,"_259":313,"_17":314},{"_34":213,"_13":77,"_75":76,"_44":111,"_36":37,"_203":41,"_204":24,"_38":309,"_40":26,"_78":79,"_206":215,"_80":30,"_207":-5,"_259":310,"_17":311},{"_34":305,"_13":288,"_75":282,"_44":-5,"_36":37,"_203":275,"_204":24,"_38":306,"_40":26,"_78":101,"_206":-5,"_80":30,"_207":-5,"_259":307,"_17":308},{"_34":297,"_13":298,"_75":299,"_44":282,"_36":37,"_203":300,"_204":24,"_38":301,"_40":26,"_78":79,"_206":302,"_80":30,"_207":-5,"_259":303,"_17":304},{"_34":289,"_13":290,"_75":291,"_44":282,"_36":37,"_203":292,"_204":24,"_38":293,"_40":41,"_78":79,"_206":294,"_80":30,"_207":-5,"_259":295,"_17":296},{"_34":279,"_13":280,"_75":281,"_44":282,"_36":37,"_203":283,"_204":24,"_38":284,"_40":41,"_78":79,"_206":285,"_80":30,"_207":-5,"_259":286,"_17":287},{"_34":271,"_13":272,"_75":273,"_44":-5,"_36":37,"_203":151,"_204":24,"_38":274,"_40":275,"_78":21,"_206":276,"_80":30,"_207":-5,"_259":277,"_17":278},{"_34":262,"_13":263,"_75":124,"_44":-5,"_36":37,"_203":264,"_204":24,"_38":265,"_40":266,"_78":267,"_206":268,"_80":30,"_207":-5,"_259":269,"_17":270},{"_34":252,"_13":253,"_75":254,"_44":-5,"_36":37,"_203":255,"_204":24,"_38":256,"_40":41,"_78":257,"_206":258,"_80":30,"_207":-5,"_259":260,"_17":261},"d442fe2e-eadf-469f-92d5-c4957bbd7488","sync.ts","dfb90b4e-7b85-11f1-989d-1607ee4eb77e",13,["D",1783597501393],"interval","/**\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","children",[],[253],"f2b69411-214e-4bbd-9fc2-c192e6985fa1","index.ts",15,["D",1783597511896],3,"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 deleteProjectMapping,\n deleteTodo,\n getAllTodos,\n getProjectMappings,\n initDB,\n setProjectMapping,\n updateTodoStatus,\n type TodoStatus,\n} from \"./lib/db.ts\";\nimport { getChats } from \"./lib/unipile.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\n// --- WhatsApp chats (for the client → project mapping UI) ---\napp.get(\"/api/chats\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n try {\n const chats = await getChats();\n return c.json({ chats });\n } catch (e) {\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// --- Client/chat → project name mappings ---\napp.get(\"/api/project-mappings\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const mappings = await getProjectMappings();\n return c.json({ mappings });\n});\n\napp.put(\"/api/project-mappings/:chatId\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const chatId = c.req.param(\"chatId\");\n const body = await c.req.json();\n const projectName = String(body.project_name ?? \"\").trim();\n const chatName = body.chat_name ? String(body.chat_name) : null;\n if (!projectName) return c.json({ error: \"project_name is required\" }, 400);\n await setProjectMapping(chatId, chatName, projectName);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/project-mappings/:chatId\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const chatId = c.req.param(\"chatId\");\n await deleteProjectMapping(chatId);\n return c.json({ ok: true });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[],[263],"a5b205e9-78b9-4606-ba58-9f98162822ad","README.md","019f468b-b4f0-7369-b149-dfc02b3ec667",["D",1783597601658],2,"# WhatsApp Kanban\n\nA cron job that fetches your WhatsApp messages via [Unipile](https://developer.unipile.com/), uses **Cerebras Inference (`gpt-oss-120b`)** to extract real, actionable todos from the chatter, and organizes them on a kanban board — grouped by whatever **project** you map each client/chat to.\n\n## How it works\n\n```mermaid\ngraph LR\n WA[WhatsApp] -->|Unipile API| Sync[\"sync.ts
(cron every 6h)\"]\n Sync -->|raw messages per chat| LLM[\"Cerebras gpt-oss-120b
structured extraction\"]\n LLM -->|actionable todos| DB[(SQLite)]\n Map[\"project_mappings
(client → project)\"] -->|tags todos| Sync\n UI[\"index.ts
(Hono server)\"] -->|reads/writes| DB\n Browser -->|loads kanban UI + settings| UI\n```\n\n1. **`sync.ts`** (interval cron) — runs every 6 hours, fetches new WhatsApp messages from Unipile, groups unprocessed messages per chat, and sends each batch to **Cerebras (`gpt-oss-120b`)** with a strict JSON schema (`response_format: json_schema`) to pull out real tasks — ignoring small talk. Extracted todos are tagged with the project mapped to that chat (if any) and stored in the \"Inbox\" column.\n2. **`lib/cerebras.ts`** — Cerebras Inference client (OpenAI-compatible API) doing structured-output extraction: title, summary, priority, due date, and whether a message is actually actionable.\n3. **`lib/db.ts`** — SQLite schema: todos (`inbox → todo → doing → done`), a `project_mappings` table (chat → project), and a `processed_messages` table so chats without actionable content aren't re-sent to the LLM every sync.\n4. **`index.ts`** (HTTP) — serves the React kanban UI, todo CRUD routes, and project-mapping routes.\n5. **Settings panel** (⚙️ in the UI) — lists your WhatsApp chats/clients and lets you assign each one a project name.\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. Get a Cerebras API key\n\nSign up at the [Cerebras Cloud Console](https://inference-docs.cerebras.ai/quickstart) and create an API key. Todos are extracted using the `gpt-oss-120b` model via Cerebras's OpenAI-compatible API.\n\n### 3. 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| `CEREBRAS_API_KEY` | Your Cerebras Cloud API key (used for todo extraction) |\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 CEREBRAS_API_KEY here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=CEREBRAS_API_KEY\n👉 Add BOARD_PASSPHRASE here: https://www.val.town/x/pc_style/whatsapp-kanban/environment-variables?key=BOARD_PASSPHRASE\n\n### 4. Map clients/chats to projects\n\nOpen the board, click **⚙️ Settings**, and give each WhatsApp chat a project name. Any todos extracted from that chat going forward will be tagged with that project. Use the project filter dropdown on the board to focus on one project at a time.\n\n### 5. Test the sync\n\nRun `sync.ts` manually from the Val Town editor to pull your first batch of messages and extract todos.\n\n## File structure\n\n```\nsync.ts ← Cron job (every 6h) — fetches messages, runs LLM extraction\nindex.ts ← Hono server — serves UI + API routes\nlib/\n db.ts ← SQLite schema + todo/project-mapping CRUD helpers\n unipile.ts ← Unipile API client (messages + chats)\n cerebras.ts ← Cerebras (gpt-oss-120b) structured-output extraction\nfrontend/\n index.html ← HTML shell\n index.tsx ← React entrypoint\n components/\n App.tsx ← Kanban board UI (project badges, filter, settings launcher)\n Settings.tsx ← Client → project mapping panel\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| `GET` | `/api/chats` | List WhatsApp chats from Unipile (for the mapping UI) |\n| `GET` | `/api/project-mappings` | List chat → project mappings |\n| `PUT` | `/api/project-mappings/:chatId` | Set/update a mapping (`{ project_name, chat_name }`) |\n| `DELETE` | `/api/project-mappings/:chatId` | Remove a mapping |\n",[],[272],"c109312b-a6f7-4991-8ae8-767f96d10cd8","unipile.ts","dfb3650e-7b85-11f1-bc53-1607ee4eb77e","2e91bb20-4ddb-46a1-baac-39eaf20965ba",11,["D",1783597469525],"/**\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",[],[288,280],"lib","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",[],[288,290],"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",[],[288,298],"8ad64489-dc06-480b-a0c6-bc25388b4983",["D",1783595012387],[246,247,248],[288],["D",1783594988490],[],[18,77],["D",1783595082382],[],[18,89],["D",1783594988490],[],[18,95],"4373f0ed-0d9b-43c6-8f6e-df96d144d8c2","Settings.tsx","afe65998-7b8b-11f1-b37f-1607ee4eb77e",16,["D",1783597530688],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Chat {\n id: string;\n name: string;\n}\n\ninterface Mapping {\n chat_id: string;\n chat_name: string | null;\n project_name: string;\n updated_at: string;\n}\n\nfunction apiHeaders(): Record {\n const h: Record = { \"Content-Type\": \"application/json\" };\n const pass = localStorage.getItem(\"board_passphrase\");\n if (pass) h[\"Authorization\"] = `Bearer ${pass}`;\n return h;\n}\n\nexport function Settings({ onClose }: { onClose: () => void }) {\n const [chats, setChats] = useState([]);\n const [mappings, setMappings] = useState([]);\n const [drafts, setDrafts] = useState>({});\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [saving, setSaving] = useState(null);\n\n async function load() {\n setLoading(true);\n setError(null);\n try {\n const [chatsRes, mapsRes] = await Promise.all([\n fetch(\"/api/chats\", { headers: apiHeaders() }),\n fetch(\"/api/project-mappings\", { headers: apiHeaders() }),\n ]);\n const chatsData = await chatsRes.json();\n const mapsData = await mapsRes.json();\n if (chatsData.error) {\n setError(`Couldn't load WhatsApp chats: ${chatsData.error}`);\n }\n setChats(chatsData.chats ?? []);\n setMappings(mapsData.mappings ?? []);\n } catch (e) {\n setError(String(e));\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n load();\n }, []);\n\n const mappingByChat = new Map(mappings.map((m) => [m.chat_id, m]));\n\n async function saveMapping(chatId: string, chatName: string | null) {\n const value = (drafts[chatId] ?? mappingByChat.get(chatId)?.project_name ?? \"\").trim();\n if (!value) return;\n setSaving(chatId);\n try {\n await fetch(`/api/project-mappings/${encodeURIComponent(chatId)}`, {\n method: \"PUT\",\n headers: apiHeaders(),\n body: JSON.stringify({ project_name: value, chat_name: chatName }),\n });\n await load();\n } finally {\n setSaving(null);\n }\n }\n\n async function removeMapping(chatId: string) {\n setSaving(chatId);\n try {\n await fetch(`/api/project-mappings/${encodeURIComponent(chatId)}`, {\n method: \"DELETE\",\n headers: apiHeaders(),\n });\n await load();\n } finally {\n setSaving(null);\n }\n }\n\n // Union of chats fetched live from Unipile + any mapping whose chat isn't in that list\n const rows = [...chats];\n for (const m of mappings) {\n if (!rows.find((c) => c.id === m.chat_id)) {\n rows.push({ id: m.chat_id, name: m.chat_name ?? m.chat_id });\n }\n }\n\n return (\n

⚙️ Client → Project Mapping

\n \n

\n Assign each WhatsApp chat/client to a project name. New todos synced from that chat will be\n tagged with the project automatically.\n

\n\n {error &&

{error}

}\n\n {loading\n ?

Loading…

\n : rows.length === 0\n ?

No WhatsApp chats found yet.

\n : (\n

\n {rows.map((chat) => {\n const mapping = mappingByChat.get(chat.id);\n const draft = drafts[chat.id] ?? mapping?.project_name ?? \"\";\n return (\n

{chat.name}

{chat.id}

\n \n setDrafts((d) => ({ ...d, [chat.id]: (e.target as HTMLInputElement).value }))}\n class=\"w-40 border border-gray-300 rounded-md px-2 py-1 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n saveMapping(chat.id, chat.name)}\n disabled={saving === chat.id || !draft.trim()}\n class=\"text-xs bg-blue-500 hover:bg-blue-600 disabled:opacity-40 text-white rounded-md px-3 py-1.5\"\n >\n Save\n \n {mapping && (\n removeMapping(chat.id)}\n disabled={saving === chat.id}\n class=\"text-xs text-gray-400 hover:text-red-500 px-1\"\n title=\"Remove mapping\"\n >\n ✕\n \n )}\n

\n );\n })}\n

\n )}\n

\n );\n}\n",[],[18,100,319],"1a6aef42-d118-4860-bdcf-c6356d5fb4b2","App.tsx","019f468b-b4f0-7369-b149-c3f2f6f7a406",17,["D",1783597562274],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useCallback, useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { Settings } from \"./Settings.tsx\";\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 summary: string | null;\n project: string | null;\n priority: string | null;\n due_date: 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\nconst PRIORITY_STYLE: Record = {\n high: \"bg-red-100 text-red-700\",\n medium: \"bg-amber-100 text-amber-700\",\n low: \"bg-gray-100 text-gray-500\",\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

\n {todo.project && (\n \n 📁 {todo.project}\n \n )}\n {todo.priority && (\n \n {todo.priority}\n \n )}\n {todo.due_date && (\n \n 📅 {todo.due_date}\n \n )}\n

{todo.text}

\n {todo.summary &&

{todo.summary}

}\n

\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 const [showSettings, setShowSettings] = useState(false);\n const [projectFilter, setProjectFilter] = useState(\"all\");\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 const projects = useMemo(() => {\n const set = new Set();\n for (const t of todos) if (t.project) set.add(t.project);\n return [...set].sort();\n }, [todos]);\n\n const visibleTodos = useMemo(() => {\n if (projectFilter === \"all\") return todos;\n if (projectFilter === \"__unassigned__\") return todos.filter((t) => !t.project);\n return todos.filter((t) => t.project === projectFilter);\n }, [todos, projectFilter]);\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 setProjectFilter((e.target as HTMLSelectElement).value)}\n class=\"text-sm border border-gray-300 rounded-lg px-2 py-1 bg-white\"\n >\n \n \n {projects.map((p) => )}\n \n {visibleTodos.length} cards\n { setLoading(true); fetchTodos(); }}\n class=\"text-sm text-blue-500 hover:text-blue-700\"\n >\n ↻ Refresh\n \n setShowSettings(true)}\n class=\"text-sm text-gray-500 hover:text-gray-800\"\n >\n ⚙️ Settings\n \n

\n\n {loading ? (\n

Loading…

\n ) : (\n

\n {COLUMNS.map((col) => {\n const colTodos = visibleTodos.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 · Todos extracted by gpt-oss-120b (Cerebras)\n

\n\n {showSettings && { setShowSettings(false); fetchTodos(); }} />}\n

\n );\n}\n",[],[18,100,327],["D",1783594988490],[240,241],[18,100],["D",1783594988490],[239,242,243,244],[18],["D",1783594988490],["D",1789525245864],{"_11":12,"_168":83},{"_11":12,"_163":164,"_82":83,"_31":81,"_165":166,"_167":30},{"_40":151,"_13":16,"_34":37,"_152":113,"_153":72,"_154":155,"_156":117,"_157":158,"_159":160,"_161":14,"_162":12},"ctx",{"_53":-5,"_189":378,"_379":380,"_381":382,"_383":30,"_384":30,"_385":30,"_386":24,"_387":-5,"_388":-7,"_389":-7,"_390":26,"_391":30,"_392":30,"_393":-5,"_394":30,"_395":30,"_396":30,"_397":-5},"ENV",{"_349":350,"_351":352,"_353":16,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377},"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"]

History · frontend