[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_299":300,"_301":302},"routes/_app.x.$handle.$name",{"_112":111,"_38":52,"_121":98,"_33":122,"_13":14,"_123":-5,"_11":124,"_125":126,"_127":128,"_129":130,"_131":132,"_26":-5,"_133":134,"_135":136,"_137":31,"_138":139,"_140":67,"_141":-5,"_142":-5,"_143":144},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_38":52,"_45":53,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":62,"_19":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":91,"_92":93,"_94":95,"_96":31},"version",12,"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":39,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":31},"previous",{"_36":37,"_38":39,"_40":41,"_42":43},"deleted",false,"deletedHere","path","lib/db.ts","latestPath","fileId","d2e06c5a-7b85-11f1-88fa-1607ee4eb77e","name","db.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type TodoStatus = \"inbox\" | \"todo\" | \"doing\" | \"done\";\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 status: TodoStatus;\n message_timestamp: string | null;\n created_at: 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\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 await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_todos_status ON todos(status)\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 message_timestamp?: string | null;\n },\n): Promise {\n try {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO todos (message_id, chat_id, chat_name, sender_id, sender_name, text, 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.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","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","createdAt",["D",1783597487886],"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=1789577999&sig=2ab81189fced4fb576e9436da67acbaf730951eef80212e8dc3c2bf0f6be2f57","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",{"_112":111,"_120":116},"org",{"_112":111,"_113":114,"_115":116,"_19":63,"_117":118,"_119":31},"branch",{"_13":97,"_38":98,"_50":49,"_99":51,"_100":101,"_102":103,"_104":57,"_105":106,"_107":108,"_109":52,"_110":111},"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",{"_50":51,"_38":52,"_45":294,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":62,"_19":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":295,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":296,"_92":297,"_94":298,"_96":31},"tree",[209,215,219,220,221],"files",[209,210,211,212,213,214,215,216,217,218,219,220,221],"counts",{"_199":71,"_200":176,"_201":71,"_202":203,"_204":205},"contents",[156,157,158,159,160],"upstreamProject",{"_50":106,"_38":152,"_59":153,"_61":62,"_56":57,"_90":154},"upstreamBranch",{"_50":101,"_45":145,"_146":147,"_38":98,"_99":106,"_13":148,"_100":-5,"_102":-5,"_149":150,"_54":-5,"_96":31,"_56":57,"_110":151,"_72":108,"_109":152},"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",{"_112":151,"_120":155},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789577999&sig=aa7aec25480c67f41f9650e8445afc21cf1a6c5fd3969752b90fbd3f6a604c46",{"_50":194,"_38":195,"_36":196,"_164":-5,"_48":49,"_47":176,"_166":67,"_45":197,"_13":71,"_40":192,"_42":-5,"_30":31,"_170":-5,"_33":198},{"_50":187,"_38":188,"_36":189,"_164":-5,"_48":49,"_47":190,"_166":67,"_45":191,"_13":71,"_40":192,"_42":-5,"_30":31,"_170":-5,"_33":193},{"_50":180,"_38":181,"_36":182,"_164":-5,"_48":49,"_47":183,"_166":31,"_45":184,"_13":176,"_40":26,"_42":185,"_30":31,"_170":-5,"_33":186},{"_50":172,"_38":173,"_36":65,"_164":-5,"_48":49,"_47":174,"_166":31,"_45":175,"_13":176,"_40":177,"_42":178,"_30":31,"_170":-5,"_33":179},{"_50":161,"_38":162,"_36":163,"_164":-5,"_48":49,"_47":165,"_166":31,"_45":167,"_13":71,"_40":168,"_42":169,"_30":31,"_170":-5,"_33":171},"a612924f-75ec-40dd-928e-df9af686a27c","sync.ts","dfb90b4e-7b85-11f1-989d-1607ee4eb77e","parentId",4,"latest",["D",1783595033908],"interval","/**\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","label",[162],"d3cd6483-7953-4bf5-8a37-6dd651f48b16","index.ts",5,["D",1783595052723],1,"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",[173],"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",[181],"8ad64489-dc06-480b-a0c6-bc25388b4983","lib","2e91bb20-4ddb-46a1-baac-39eaf20965ba",2,["D",1783595012387],"directory",[188],"d9efa8a0-aa61-481d-8bb5-65332a0ea515","frontend","019f468b-b4f0-7369-b149-d8843be286ad",["D",1783594988490],[195],"pulls","branches","forks","envVars",{"_206":174,"_208":71},"connections",{"_206":71,"_207":71},"count","unfilledCount","emptyCount",{"_50":194,"_38":195,"_36":196,"_164":-5,"_48":49,"_47":176,"_166":67,"_45":291,"_13":71,"_40":192,"_42":-5,"_30":31,"_170":-5,"_223":292,"_33":293},{"_50":287,"_38":286,"_36":280,"_164":196,"_48":49,"_47":176,"_166":67,"_45":288,"_13":71,"_40":192,"_42":-5,"_30":31,"_170":-5,"_223":289,"_33":290},{"_50":277,"_38":278,"_36":279,"_164":280,"_48":49,"_47":281,"_166":31,"_45":282,"_13":176,"_40":41,"_42":283,"_30":31,"_170":-5,"_223":284,"_33":285},{"_50":270,"_38":271,"_36":272,"_164":196,"_48":49,"_47":176,"_166":67,"_45":273,"_13":71,"_40":26,"_42":274,"_30":31,"_170":-5,"_223":275,"_33":276},{"_50":262,"_38":263,"_36":264,"_164":196,"_48":49,"_47":265,"_166":67,"_45":266,"_13":176,"_40":26,"_42":267,"_30":31,"_170":-5,"_223":268,"_33":269},{"_50":255,"_38":256,"_36":257,"_164":196,"_48":49,"_47":176,"_166":67,"_45":258,"_13":71,"_40":41,"_42":259,"_30":31,"_170":-5,"_223":260,"_33":261},{"_50":187,"_38":188,"_36":189,"_164":-5,"_48":49,"_47":190,"_166":67,"_45":252,"_13":71,"_40":192,"_42":-5,"_30":31,"_170":-5,"_223":253,"_33":254},{"_50":244,"_38":245,"_36":246,"_164":189,"_48":49,"_47":247,"_166":67,"_45":248,"_13":71,"_40":41,"_42":249,"_30":31,"_170":-5,"_223":250,"_33":251},{"_50":240,"_38":39,"_36":37,"_164":189,"_48":49,"_47":14,"_166":67,"_45":241,"_13":176,"_40":41,"_42":44,"_30":31,"_170":-5,"_223":242,"_33":243},{"_50":232,"_38":233,"_36":234,"_164":189,"_48":49,"_47":235,"_166":67,"_45":236,"_13":176,"_40":41,"_42":237,"_30":31,"_170":-5,"_223":238,"_33":239},{"_50":180,"_38":181,"_36":182,"_164":-5,"_48":49,"_47":183,"_166":31,"_45":229,"_13":176,"_40":26,"_42":185,"_30":31,"_170":-5,"_223":230,"_33":231},{"_50":172,"_38":173,"_36":65,"_164":-5,"_48":49,"_47":174,"_166":31,"_45":226,"_13":176,"_40":177,"_42":178,"_30":31,"_170":-5,"_223":227,"_33":228},{"_50":161,"_38":162,"_36":163,"_164":-5,"_48":49,"_47":165,"_166":31,"_45":222,"_13":71,"_40":168,"_42":169,"_30":31,"_170":-5,"_223":224,"_33":225},["D",1783595033908],"children",[],[162],["D",1783595052723],[],[173],["D",1783595094729],[],[181],"c109312b-a6f7-4991-8ae8-767f96d10cd8","unipile.ts","dfb3650e-7b85-11f1-bc53-1607ee4eb77e",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",[],[188,233],"8dc1872f-144a-4469-ba1c-1d304e582be5",["D",1783597487886],[],[188,39],"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",[],[188,245],["D",1783595012387],[216,217,218],[188],"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();",[],[195,256],"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",[],[195,263],"ecfda0a3-6b59-4c95-a760-16dae247d012","favicon.svg","019f468b-b4f0-7369-b149-cf47cce5f1ec",["D",1783594988490],"\n",[],[195,271],"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",[],[195,286,278],"components","81e05fa2-23f4-4b4a-9286-7bf0cef33dd1",["D",1783594988490],[211],[195,286],["D",1783594988490],[210,212,213,214],[195],["D",1783594988490],["D",1789525245864],{"_112":111,"_120":116},{"_112":111,"_113":114,"_115":116,"_19":63,"_117":118,"_119":31},{"_13":97,"_38":98,"_50":49,"_99":51,"_100":101,"_102":103,"_104":57,"_105":106,"_107":108,"_109":52,"_110":111},"ctx",{"_90":-5,"_142":332,"_333":334,"_335":336,"_337":31,"_338":31,"_339":31,"_340":67,"_341":-5,"_342":-7,"_343":-7,"_344":71,"_345":31,"_346":31,"_347":-5,"_348":31,"_349":31,"_350":31,"_351":-5},"ENV",{"_303":304,"_305":306,"_307":98,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331},"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 · v12