WhatsApp Auto-Reply Dashboard

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_281":282,"_283":284},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_37":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",10,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":21,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","8b2817c0-3f98-11f0-a831-76b3cceeab13","name","index.html","fileType","content","\n\n\n \n \n WhatsApp Auto-Reply Dashboard\n \n \n 💬\">\n \n\n\n

💬

Loading WhatsApp Auto-Reply Dashboard...

\n \n \n\n","createdAt",["D",1748858485065],"branchVersion","branchId","05639eb8-3f96-11f0-847a-76b3cceeab13",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","01dad8cd-3be0-4288-b94d-c65362ebb501","directory",["D",1748858485065],"id","05632b36-3f96-11f0-847a-76b3cceeab13","untitled-3191",["D",1748857401649],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","16eccca0-3f95-11f0-ad5b-814c56c8abb0","pinnedFileId","8513feee-3f98-11f0-8c15-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d0af734c-162b-413f-ab5d-d85f6c3fb438","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Lyte","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2xObDJLVHFLclU5S3g2UkhQdEN2U0N4dCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_37":277,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":278,"_84":279,"_86":280,"_88":25},"tree",[177,186,188,190,191],"files",[177,178,179,180,181,182,183,184,185,186,187,188,189,190,191],"counts",{"_167":66,"_168":139,"_169":66,"_170":171,"_172":173},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":161,"_32":162,"_30":163,"_138":-5,"_40":41,"_39":164,"_140":62,"_37":165,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_27":166},{"_47":158,"_32":43,"_30":44,"_138":-5,"_40":41,"_39":14,"_140":62,"_37":159,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_27":160},{"_47":152,"_32":153,"_30":154,"_138":-5,"_40":41,"_39":155,"_140":62,"_37":156,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_27":157},{"_47":145,"_32":146,"_30":147,"_138":-5,"_40":41,"_39":148,"_140":62,"_37":149,"_13":66,"_34":21,"_35":150,"_24":25,"_143":-5,"_27":151},{"_47":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":62,"_37":141,"_13":66,"_34":142,"_35":109,"_24":25,"_143":-5,"_27":144},"05657288-3f96-11f0-847a-76b3cceeab13","main.tsx","05657364-3f96-11f0-847a-76b3cceeab13","parentId",1,"latest",["D",1748857401660],"script","label",[136],"3c02e03a-3f98-11f0-b61b-76b3cceeab13","README.md","3c02e10c-3f98-11f0-b61b-76b3cceeab13",2,["D",1748858352283],"# WhatsApp Auto-Reply App\n\nA web application that can handle incoming WhatsApp messages and send automated replies on your behalf.\n\n## Features\n\n- Web interface to configure auto-reply settings\n- Webhook endpoint to receive WhatsApp messages\n- Automated response system with customizable messages\n- Message history and analytics\n- Support for different reply modes (always, business hours, away message)\n\n## Setup\n\n1. **WhatsApp Business API Setup:**\n - Sign up for WhatsApp Business API through Meta Business\n - Get your access token and phone number ID\n - Set webhook URL to: `https://your-val-url.web.val.run/webhook`\n\n2. **Environment Variables:**\n Set these in your Val Town environment:\n - `WHATSAPP_ACCESS_TOKEN`: Your WhatsApp Business API access token\n - `WHATSAPP_PHONE_NUMBER_ID`: Your WhatsApp Business phone number ID\n - `WEBHOOK_VERIFY_TOKEN`: A secret token for webhook verification\n\n3. **Webhook Configuration:**\n - URL: `https://your-val-url.web.val.run/webhook`\n - Verify Token: Use the same value as `WEBHOOK_VERIFY_TOKEN`\n - Subscribe to: `messages` events\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ ├── webhook.ts # WhatsApp webhook handler\n│ ├── api.ts # API routes for frontend\n│ └── static.ts # Static file serving\n├── frontend/\n│ ├── index.html # Main web interface\n│ ├── index.tsx # React app entry point\n│ └── components/\n│ ├── App.tsx # Main app component\n│ ├── Dashboard.tsx # Settings dashboard\n│ └── MessageHistory.tsx # Message history view\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Usage\n\n1. Access the web interface to configure your auto-reply settings\n2. Set up your WhatsApp Business API webhook\n3. Messages will be automatically replied to based on your configuration\n4. Monitor message history and analytics through the dashboard\n\n## API Endpoints\n\n- `GET /` - Web interface\n- `POST /webhook` - WhatsApp webhook endpoint\n- `GET /webhook` - Webhook verification\n- `GET /api/settings` - Get current settings\n- `POST /api/settings` - Update settings\n- `GET /api/messages` - Get message history",[146],"43f02c3a-3f98-11f0-a83c-76b3cceeab13","shared","03d7de3b-9d49-4cfe-b677-dd99fdff9b36",3,["D",1748858365579],[153],"8b28260c-3f98-11f0-a831-76b3cceeab13",["D",1748858485065],[43],"4db5d620-3f98-11f0-8582-76b3cceeab13","backend","c2c06425-fde9-4a84-adf8-77689c2ed6eb",4,["D",1748858381972],[162],"pulls","branches","forks","envVars",{"_174":66,"_176":66},"connections",{"_174":66,"_175":66},"count","unfilledCount","emptyCount",{"_47":161,"_32":162,"_30":163,"_138":-5,"_40":41,"_39":164,"_140":62,"_37":274,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_193":275,"_27":276},{"_47":270,"_32":262,"_30":256,"_138":163,"_40":41,"_39":164,"_140":62,"_37":271,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_193":272,"_27":273},{"_47":263,"_32":264,"_30":265,"_138":256,"_40":41,"_39":164,"_140":62,"_37":266,"_13":66,"_34":142,"_35":267,"_24":25,"_143":-5,"_193":268,"_27":269},{"_47":253,"_32":254,"_30":255,"_138":256,"_40":41,"_39":257,"_140":62,"_37":258,"_13":66,"_34":142,"_35":259,"_24":25,"_143":-5,"_193":260,"_27":261},{"_47":249,"_32":232,"_30":226,"_138":163,"_40":41,"_39":227,"_140":62,"_37":250,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_193":251,"_27":252},{"_47":241,"_32":242,"_30":243,"_138":226,"_40":41,"_39":244,"_140":62,"_37":245,"_13":66,"_34":142,"_35":246,"_24":25,"_143":-5,"_193":247,"_27":248},{"_47":233,"_32":234,"_30":235,"_138":226,"_40":41,"_39":236,"_140":25,"_37":237,"_13":66,"_34":142,"_35":238,"_24":25,"_143":-5,"_193":239,"_27":240},{"_47":223,"_32":224,"_30":225,"_138":226,"_40":41,"_39":227,"_140":62,"_37":228,"_13":66,"_34":142,"_35":229,"_24":25,"_143":-5,"_193":230,"_27":231},{"_47":216,"_32":217,"_30":60,"_138":163,"_40":41,"_39":218,"_140":25,"_37":219,"_13":66,"_34":142,"_35":220,"_24":25,"_143":-5,"_193":221,"_27":222},{"_47":158,"_32":43,"_30":44,"_138":-5,"_40":41,"_39":14,"_140":62,"_37":213,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_193":214,"_27":215},{"_47":209,"_32":33,"_30":31,"_138":44,"_40":41,"_39":14,"_140":62,"_37":210,"_13":66,"_34":21,"_35":36,"_24":25,"_143":-5,"_193":211,"_27":212},{"_47":152,"_32":153,"_30":154,"_138":-5,"_40":41,"_39":155,"_140":62,"_37":206,"_13":66,"_34":45,"_35":-5,"_24":25,"_143":-5,"_193":207,"_27":208},{"_47":199,"_32":200,"_30":201,"_138":154,"_40":41,"_39":155,"_140":62,"_37":202,"_13":66,"_34":142,"_35":203,"_24":25,"_143":-5,"_193":204,"_27":205},{"_47":145,"_32":146,"_30":147,"_138":-5,"_40":41,"_39":148,"_140":62,"_37":196,"_13":66,"_34":21,"_35":150,"_24":25,"_143":-5,"_193":197,"_27":198},{"_47":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":62,"_37":192,"_13":66,"_34":142,"_35":109,"_24":25,"_143":-5,"_193":194,"_27":195},["D",1748857401660],"children",[],[136],["D",1748858352283],[],[146],"43f021f4-3f98-11f0-a83c-76b3cceeab13","types.ts","43f022d0-3f98-11f0-a83c-76b3cceeab13",["D",1748858365579],"// Shared types for WhatsApp Auto-Reply App\n\nexport interface WhatsAppMessage {\n id: string;\n from: string;\n timestamp: string;\n text?: {\n body: string;\n };\n type: 'text' | 'image' | 'audio' | 'video' | 'document';\n}\n\nexport interface WhatsAppWebhookPayload {\n object: string;\n entry: Array<{\n id: string;\n changes: Array<{\n value: {\n messaging_product: string;\n metadata: {\n display_phone_number: string;\n phone_number_id: string;\n };\n messages?: WhatsAppMessage[];\n statuses?: Array<{\n id: string;\n status: string;\n timestamp: string;\n recipient_id: string;\n }>;\n };\n field: string;\n }>;\n }>;\n}\n\nexport interface AutoReplySettings {\n id?: number;\n enabled: boolean;\n mode: 'always' | 'business_hours' | 'away';\n default_message: string;\n business_hours_start?: string; // HH:MM format\n business_hours_end?: string; // HH:MM format\n business_hours_message?: string;\n away_message?: string;\n keyword_responses: KeywordResponse[];\n created_at?: string;\n updated_at?: string;\n}\n\nexport interface KeywordResponse {\n id?: number;\n keyword: string;\n response: string;\n exact_match: boolean;\n}\n\nexport interface MessageLog {\n id?: number;\n whatsapp_message_id: string;\n from_number: string;\n message_text: string;\n reply_sent: boolean;\n reply_text?: string;\n timestamp: string;\n created_at?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\nexport interface DashboardStats {\n total_messages: number;\n messages_today: number;\n replies_sent: number;\n top_keywords: Array<{\n keyword: string;\n count: number;\n }>;\n}",[],[153,200],["D",1748858365579],[189],[153],"8b2816e4-3f98-11f0-a831-76b3cceeab13",["D",1748858485065],[],[43,33],["D",1748858485065],[187],[43],"8513fdea-3f98-11f0-8c15-76b3cceeab13","index.ts",9,["D",1748858474867],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport webhook from \"./routes/webhook.ts\";\nimport api from \"./routes/api.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\ntry {\n await runMigrations();\n} catch (error) {\n console.error(\"Failed to run migrations:\", error);\n}\n\n// Routes\napp.route(\"/webhook\", webhook);\napp.route(\"/api\", api);\napp.route(\"/\", staticRoutes);\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n environment: {\n hasWhatsAppToken: !!Deno.env.get(\"WHATSAPP_ACCESS_TOKEN\"),\n hasPhoneNumberId: !!Deno.env.get(\"WHATSAPP_PHONE_NUMBER_ID\"),\n hasWebhookToken: !!Deno.env.get(\"WEBHOOK_VERIFY_TOKEN\")\n }\n });\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ error: \"Not found\" }, 404);\n});\n\nconsole.log(\"WhatsApp Auto-Reply server started!\");\n\nexport default app.fetch;",[],[162,217],"6b029a9c-3f98-11f0-857b-76b3cceeab13","webhook.ts","6b029b64-3f98-11f0-857b-76b3cceeab13","c4820e9d-dbb6-4b71-9b3b-5cbf472c4441",6,["D",1748858431108],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { WhatsAppWebhookPayload, WhatsAppMessage } from \"../../shared/types.ts\";\nimport { getSettings, logMessage, updateMessageReply, findKeywordResponse } from \"../database/queries.ts\";\n\nconst webhook = new Hono();\n\n// WhatsApp webhook verification\nwebhook.get(\"/\", async (c) => {\n const mode = c.req.query(\"hub.mode\");\n const token = c.req.query(\"hub.verify_token\");\n const challenge = c.req.query(\"hub.challenge\");\n \n const verifyToken = Deno.env.get(\"WEBHOOK_VERIFY_TOKEN\");\n \n if (mode === \"subscribe\" && token === verifyToken) {\n console.log(\"Webhook verified successfully\");\n return c.text(challenge || \"\");\n }\n \n console.log(\"Webhook verification failed\");\n return c.text(\"Forbidden\", 403);\n});\n\n// WhatsApp webhook message handler\nwebhook.post(\"/\", async (c) => {\n try {\n const payload: WhatsAppWebhookPayload = await c.req.json();\n \n console.log(\"Received webhook payload:\", JSON.stringify(payload, null, 2));\n \n // Process each entry in the webhook payload\n for (const entry of payload.entry) {\n for (const change of entry.changes) {\n if (change.field === \"messages\" && change.value.messages) {\n await processMessages(change.value.messages);\n }\n }\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error processing webhook:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\nasync function processMessages(messages: WhatsAppMessage[]) {\n const settings = await getSettings();\n \n if (!settings || !settings.enabled) {\n console.log(\"Auto-reply is disabled, skipping messages\");\n return;\n }\n \n for (const message of messages) {\n try {\n // Only process text messages for now\n if (message.type !== \"text\" || !message.text) {\n console.log(`Skipping non-text message: ${message.type}`);\n continue;\n }\n \n const messageText = message.text.body;\n const fromNumber = message.from;\n const timestamp = new Date(parseInt(message.timestamp) * 1000).toISOString();\n \n // Log the incoming message\n await logMessage(message.id, fromNumber, messageText, timestamp);\n \n // Determine the appropriate reply\n const replyText = await determineReply(messageText, settings);\n \n if (replyText) {\n // Send the reply\n const success = await sendWhatsAppMessage(fromNumber, replyText);\n \n if (success) {\n // Update the message log with the reply\n await updateMessageReply(message.id, replyText);\n console.log(`Sent auto-reply to ${fromNumber}: ${replyText}`);\n } else {\n console.error(`Failed to send reply to ${fromNumber}`);\n }\n }\n } catch (error) {\n console.error(\"Error processing message:\", error);\n }\n }\n}\n\nasync function determineReply(messageText: string, settings: any): Promise {\n // First check for keyword-specific responses\n const keywordResponse = await findKeywordResponse(messageText);\n if (keywordResponse) {\n return keywordResponse;\n }\n \n // Then use mode-based responses\n switch (settings.mode) {\n case \"always\":\n return settings.default_message;\n \n case \"business_hours\":\n if (isBusinessHours(settings.business_hours_start, settings.business_hours_end)) {\n return settings.business_hours_message || settings.default_message;\n }\n return null; // Don't reply outside business hours\n \n case \"away\":\n return settings.away_message || settings.default_message;\n \n default:\n return settings.default_message;\n }\n}\n\nfunction isBusinessHours(startTime?: string, endTime?: string): boolean {\n if (!startTime || !endTime) return true;\n \n const now = new Date();\n const currentTime = now.getHours() * 60 + now.getMinutes();\n \n const [startHour, startMin] = startTime.split(\":\").map(Number);\n const [endHour, endMin] = endTime.split(\":\").map(Number);\n \n const start = startHour * 60 + startMin;\n const end = endHour * 60 + endMin;\n \n return currentTime >= start && currentTime <= end;\n}\n\nasync function sendWhatsAppMessage(to: string, message: string): Promise {\n const accessToken = Deno.env.get(\"WHATSAPP_ACCESS_TOKEN\");\n const phoneNumberId = Deno.env.get(\"WHATSAPP_PHONE_NUMBER_ID\");\n \n if (!accessToken || !phoneNumberId) {\n console.error(\"Missing WhatsApp API credentials\");\n return false;\n }\n \n try {\n const response = await fetch(\n `https://graph.facebook.com/v18.0/${phoneNumberId}/messages`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n messaging_product: \"whatsapp\",\n to: to,\n type: \"text\",\n text: {\n body: message\n }\n })\n }\n );\n \n if (response.ok) {\n const result = await response.json();\n console.log(\"Message sent successfully:\", result);\n return true;\n } else {\n const error = await response.text();\n console.error(\"Failed to send message:\", error);\n return false;\n }\n } catch (error) {\n console.error(\"Error sending WhatsApp message:\", error);\n return false;\n }\n}\n\nexport default webhook;",[],[162,232,224],"routes","7fc4beec-3f98-11f0-857d-76b3cceeab13","static.ts","7fc4bfbe-3f98-11f0-857d-76b3cceeab13",8,["D",1748858465959],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getSettings, getDashboardStats } from \"../database/queries.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\nstaticRoutes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Main page with initial data injection\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n const [settings, stats] = await Promise.all([\n getSettings(),\n getDashboardStats()\n ]);\n\n const initialData = {\n settings,\n stats,\n timestamp: new Date().toISOString()\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default staticRoutes;",[],[162,232,234],"7a30a66c-3f98-11f0-a95b-76b3cceeab13","api.ts","7a30a716-3f98-11f0-a95b-76b3cceeab13",7,["D",1748858456596],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ApiResponse } from \"../../shared/types.ts\";\nimport {\n getSettings,\n updateSettings,\n getKeywordResponses,\n addKeywordResponse,\n updateKeywordResponse,\n deleteKeywordResponse,\n getMessageHistory,\n getDashboardStats\n} from \"../database/queries.ts\";\n\nconst api = new Hono();\n\n// Get current settings\napi.get(\"/settings\", async (c) => {\n try {\n const settings = await getSettings();\n const response: ApiResponse = {\n success: true,\n data: settings\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error getting settings:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to get settings\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update settings\napi.post(\"/settings\", async (c) => {\n try {\n const body = await c.req.json();\n await updateSettings(body);\n \n const response: ApiResponse = {\n success: true,\n data: { message: \"Settings updated successfully\" }\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error updating settings:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to update settings\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get keyword responses\napi.get(\"/keywords\", async (c) => {\n try {\n const keywords = await getKeywordResponses();\n const response: ApiResponse = {\n success: true,\n data: keywords\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error getting keywords:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to get keywords\"\n };\n return c.json(response, 500);\n }\n});\n\n// Add keyword response\napi.post(\"/keywords\", async (c) => {\n try {\n const { keyword, response, exact_match } = await c.req.json();\n \n if (!keyword || !response) {\n const apiResponse: ApiResponse = {\n success: false,\n error: \"Keyword and response are required\"\n };\n return c.json(apiResponse, 400);\n }\n \n await addKeywordResponse(keyword, response, exact_match || false);\n \n const apiResponse: ApiResponse = {\n success: true,\n data: { message: \"Keyword response added successfully\" }\n };\n return c.json(apiResponse);\n } catch (error) {\n console.error(\"Error adding keyword:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to add keyword response\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update keyword response\napi.put(\"/keywords/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const { keyword, response, exact_match } = await c.req.json();\n \n if (!keyword || !response) {\n const apiResponse: ApiResponse = {\n success: false,\n error: \"Keyword and response are required\"\n };\n return c.json(apiResponse, 400);\n }\n \n await updateKeywordResponse(id, keyword, response, exact_match || false);\n \n const apiResponse: ApiResponse = {\n success: true,\n data: { message: \"Keyword response updated successfully\" }\n };\n return c.json(apiResponse);\n } catch (error) {\n console.error(\"Error updating keyword:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to update keyword response\"\n };\n return c.json(response, 500);\n }\n});\n\n// Delete keyword response\napi.delete(\"/keywords/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n await deleteKeywordResponse(id);\n \n const response: ApiResponse = {\n success: true,\n data: { message: \"Keyword response deleted successfully\" }\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error deleting keyword:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to delete keyword response\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get message history\napi.get(\"/messages\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"50\");\n const offset = parseInt(c.req.query(\"offset\") || \"0\");\n \n const messages = await getMessageHistory(limit, offset);\n const response: ApiResponse = {\n success: true,\n data: messages\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error getting messages:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to get message history\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get dashboard statistics\napi.get(\"/stats\", async (c) => {\n try {\n const stats = await getDashboardStats();\n const response: ApiResponse = {\n success: true,\n data: stats\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error getting stats:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to get dashboard statistics\"\n };\n return c.json(response, 500);\n }\n});\n\n// Test endpoint to send a test message\napi.post(\"/test-message\", async (c) => {\n try {\n const { to, message } = await c.req.json();\n \n if (!to || !message) {\n const response: ApiResponse = {\n success: false,\n error: \"Phone number and message are required\"\n };\n return c.json(response, 400);\n }\n \n const accessToken = Deno.env.get(\"WHATSAPP_ACCESS_TOKEN\");\n const phoneNumberId = Deno.env.get(\"WHATSAPP_PHONE_NUMBER_ID\");\n \n if (!accessToken || !phoneNumberId) {\n const response: ApiResponse = {\n success: false,\n error: \"WhatsApp API credentials not configured\"\n };\n return c.json(response, 500);\n }\n \n const whatsappResponse = await fetch(\n `https://graph.facebook.com/v18.0/${phoneNumberId}/messages`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${accessToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n messaging_product: \"whatsapp\",\n to: to,\n type: \"text\",\n text: {\n body: message\n }\n })\n }\n );\n \n if (whatsappResponse.ok) {\n const result = await whatsappResponse.json();\n const response: ApiResponse = {\n success: true,\n data: { message: \"Test message sent successfully\", result }\n };\n return c.json(response);\n } else {\n const error = await whatsappResponse.text();\n const response: ApiResponse = {\n success: false,\n error: `Failed to send test message: ${error}`\n };\n return c.json(response, 500);\n }\n } catch (error) {\n console.error(\"Error sending test message:\", error);\n const response: ApiResponse = {\n success: false,\n error: \"Failed to send test message\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default api;",[],[162,232,242],"6b02a956-3f98-11f0-857b-76b3cceeab13",["D",1748858431108],[182,183,184],[162,232],"5d97b48c-3f98-11f0-a75f-76b3cceeab13","queries.ts","5d97b536-3f98-11f0-a75f-76b3cceeab13","6ea90ad0-a19b-41fd-b23b-428785e9ec5e",5,["D",1748858408623],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { AutoReplySettings, KeywordResponse, MessageLog, DashboardStats } from \"../../shared/types.ts\";\n\n// Settings queries\nexport async function getSettings(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM auto_reply_settings_v1 ORDER BY id DESC LIMIT 1\"\n );\n \n if (result.length === 0) return null;\n \n const settings = result[0];\n const keywords = await getKeywordResponses();\n \n return {\n id: settings.id,\n enabled: Boolean(settings.enabled),\n mode: settings.mode,\n default_message: settings.default_message,\n business_hours_start: settings.business_hours_start,\n business_hours_end: settings.business_hours_end,\n business_hours_message: settings.business_hours_message,\n away_message: settings.away_message,\n keyword_responses: keywords,\n created_at: settings.created_at,\n updated_at: settings.updated_at\n };\n}\n\nexport async function updateSettings(settings: Partial): Promise {\n const current = await getSettings();\n \n if (current) {\n // Update existing settings\n await sqlite.execute(`\n UPDATE auto_reply_settings_v1 \n SET enabled = ?, mode = ?, default_message = ?, \n business_hours_start = ?, business_hours_end = ?,\n business_hours_message = ?, away_message = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [\n settings.enabled ?? current.enabled,\n settings.mode ?? current.mode,\n settings.default_message ?? current.default_message,\n settings.business_hours_start ?? current.business_hours_start,\n settings.business_hours_end ?? current.business_hours_end,\n settings.business_hours_message ?? current.business_hours_message,\n settings.away_message ?? current.away_message,\n current.id\n ]);\n } else {\n // Create new settings\n await sqlite.execute(`\n INSERT INTO auto_reply_settings_v1 \n (enabled, mode, default_message, business_hours_start, business_hours_end, business_hours_message, away_message)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n settings.enabled ?? true,\n settings.mode ?? 'always',\n settings.default_message ?? 'Thank you for your message!',\n settings.business_hours_start,\n settings.business_hours_end,\n settings.business_hours_message,\n settings.away_message\n ]);\n }\n}\n\n// Keyword response queries\nexport async function getKeywordResponses(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM keyword_responses_v1 ORDER BY keyword ASC\"\n );\n \n return result.map(row => ({\n id: row.id,\n keyword: row.keyword,\n response: row.response,\n exact_match: Boolean(row.exact_match)\n }));\n}\n\nexport async function addKeywordResponse(keyword: string, response: string, exactMatch: boolean = false): Promise {\n await sqlite.execute(`\n INSERT INTO keyword_responses_v1 (keyword, response, exact_match)\n VALUES (?, ?, ?)\n `, [keyword.toLowerCase(), response, exactMatch ? 1 : 0]);\n}\n\nexport async function updateKeywordResponse(id: number, keyword: string, response: string, exactMatch: boolean): Promise {\n await sqlite.execute(`\n UPDATE keyword_responses_v1 \n SET keyword = ?, response = ?, exact_match = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [keyword.toLowerCase(), response, exactMatch ? 1 : 0, id]);\n}\n\nexport async function deleteKeywordResponse(id: number): Promise {\n await sqlite.execute(\"DELETE FROM keyword_responses_v1 WHERE id = ?\", [id]);\n}\n\n// Message log queries\nexport async function logMessage(\n whatsappMessageId: string,\n fromNumber: string,\n messageText: string,\n timestamp: string,\n replySent: boolean = false,\n replyText?: string\n): Promise {\n await sqlite.execute(`\n INSERT OR REPLACE INTO message_logs_v1 \n (whatsapp_message_id, from_number, message_text, reply_sent, reply_text, timestamp)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [whatsappMessageId, fromNumber, messageText, replySent ? 1 : 0, replyText, timestamp]);\n}\n\nexport async function updateMessageReply(whatsappMessageId: string, replyText: string): Promise {\n await sqlite.execute(`\n UPDATE message_logs_v1 \n SET reply_sent = 1, reply_text = ?\n WHERE whatsapp_message_id = ?\n `, [replyText, whatsappMessageId]);\n}\n\nexport async function getMessageHistory(limit: number = 50, offset: number = 0): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM message_logs_v1 \n ORDER BY timestamp DESC \n LIMIT ? OFFSET ?\n `, [limit, offset]);\n \n return result.map(row => ({\n id: row.id,\n whatsapp_message_id: row.whatsapp_message_id,\n from_number: row.from_number,\n message_text: row.message_text,\n reply_sent: Boolean(row.reply_sent),\n reply_text: row.reply_text,\n timestamp: row.timestamp,\n created_at: row.created_at\n }));\n}\n\nexport async function getDashboardStats(): Promise {\n // Total messages\n const totalResult = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM message_logs_v1\"\n );\n \n // Messages today\n const todayResult = await sqlite.execute(`\n SELECT COUNT(*) as count FROM message_logs_v1 \n WHERE DATE(timestamp) = DATE('now')\n `);\n \n // Replies sent\n const repliesResult = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM message_logs_v1 WHERE reply_sent = 1\"\n );\n \n // Top keywords (approximate based on message content)\n const keywordsResult = await sqlite.execute(`\n SELECT keyword, COUNT(*) as count\n FROM keyword_responses_v1 kr\n JOIN message_logs_v1 ml ON LOWER(ml.message_text) LIKE '%' || kr.keyword || '%'\n GROUP BY keyword\n ORDER BY count DESC\n LIMIT 5\n `);\n \n return {\n total_messages: totalResult[0].count,\n messages_today: todayResult[0].count,\n replies_sent: repliesResult[0].count,\n top_keywords: keywordsResult.map(row => ({\n keyword: row.keyword,\n count: row.count\n }))\n };\n}\n\n// Find matching keyword response for a message\nexport async function findKeywordResponse(messageText: string): Promise {\n const keywords = await getKeywordResponses();\n const lowerMessage = messageText.toLowerCase();\n \n // First try exact matches\n for (const keyword of keywords) {\n if (keyword.exact_match && lowerMessage === keyword.keyword) {\n return keyword.response;\n }\n }\n \n // Then try partial matches\n for (const keyword of keywords) {\n if (!keyword.exact_match && lowerMessage.includes(keyword.keyword)) {\n return keyword.response;\n }\n }\n \n return null;\n}",[],[162,262,254],"database","4db5ca18-3f98-11f0-8582-76b3cceeab13","migrations.ts","4db5caea-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema for WhatsApp Auto-Reply App\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Auto-reply settings table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS auto_reply_settings_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n enabled BOOLEAN NOT NULL DEFAULT 1,\n mode TEXT NOT NULL DEFAULT 'always' CHECK (mode IN ('always', 'business_hours', 'away')),\n default_message TEXT NOT NULL,\n business_hours_start TEXT,\n business_hours_end TEXT,\n business_hours_message TEXT,\n away_message TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Keyword responses table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS keyword_responses_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n keyword TEXT NOT NULL,\n response TEXT NOT NULL,\n exact_match BOOLEAN NOT NULL DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Message logs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS message_logs_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n whatsapp_message_id TEXT UNIQUE NOT NULL,\n from_number TEXT NOT NULL,\n message_text TEXT NOT NULL,\n reply_sent BOOLEAN NOT NULL DEFAULT 0,\n reply_text TEXT,\n timestamp TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_message_logs_timestamp \n ON message_logs_v1(timestamp)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_message_logs_from_number \n ON message_logs_v1(from_number)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_keyword_responses_keyword \n ON keyword_responses_v1(keyword)\n `);\n\n // Insert default settings if none exist\n const existingSettings = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM auto_reply_settings_v1\"\n );\n\n if (existingSettings[0].count === 0) {\n await sqlite.execute(`\n INSERT INTO auto_reply_settings_v1 \n (enabled, mode, default_message, business_hours_start, business_hours_end, business_hours_message, away_message)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n 1,\n 'always',\n 'Thank you for your message! This is an automated reply. I will get back to you as soon as possible.',\n '09:00',\n '17:00',\n 'Thank you for your message! Our business hours are 9 AM to 5 PM. I will respond during business hours.',\n 'I am currently away and will respond to your message when I return. Thank you for your patience!'\n ]);\n\n // Insert some default keyword responses\n const defaultKeywords = [\n { keyword: 'hello', response: 'Hello! How can I help you today?', exact_match: false },\n { keyword: 'hi', response: 'Hi there! Thanks for reaching out.', exact_match: false },\n { keyword: 'help', response: 'I\\'d be happy to help! Please describe what you need assistance with.', exact_match: false },\n { keyword: 'price', response: 'For pricing information, please visit our website or I\\'ll get back to you with details soon.', exact_match: false },\n { keyword: 'hours', response: 'Our business hours are Monday to Friday, 9 AM to 5 PM.', exact_match: false }\n ];\n\n for (const keyword of defaultKeywords) {\n await sqlite.execute(`\n INSERT INTO keyword_responses_v1 (keyword, response, exact_match)\n VALUES (?, ?, ?)\n `, [keyword.keyword, keyword.response, keyword.exact_match ? 1 : 0]);\n }\n }\n\n console.log(\"Database migrations completed successfully!\");\n}",[],[162,262,264],"4db5d814-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],[179,180],[162,262],["D",1748858381972],[178,181,185],[162],["D",1748857401649],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":314,"_315":316,"_317":318,"_319":25,"_320":25,"_321":25,"_322":62,"_323":-5,"_324":-7,"_325":-7,"_326":66,"_327":25,"_328":25,"_329":-5,"_330":25,"_331":25,"_332":25,"_333":-5},"ENV",{"_285":286,"_287":288,"_289":90,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v10