[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_307":308,"_309":310},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",12,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/App.tsx","latestPath","fileId","9cd0db56-3f98-11f0-8f53-76b3cceeab13","name","App.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport MessageHistory from \"./MessageHistory.tsx\";\nimport type { AutoReplySettings, DashboardStats } from \"../../shared/types.ts\";\n\ninterface AppProps {\n initialData: {\n settings?: AutoReplySettings;\n stats?: DashboardStats;\n timestamp?: string;\n };\n}\n\nexport default function App({ initialData }: AppProps) {\n const [activeTab, setActiveTab] = useState<'dashboard' | 'messages'>('dashboard');\n const [settings, setSettings] = useState(initialData.settings || null);\n const [stats, setStats] = useState(initialData.stats || null);\n const [loading, setLoading] = useState(false);\n\n const refreshData = async () => {\n setLoading(true);\n try {\n const [settingsRes, statsRes] = await Promise.all([\n fetch('/api/settings'),\n fetch('/api/stats')\n ]);\n \n const settingsData = await settingsRes.json();\n const statsData = await statsRes.json();\n \n if (settingsData.success) {\n setSettings(settingsData.data);\n }\n \n if (statsData.success) {\n setStats(statsData.data);\n }\n } catch (error) {\n console.error('Error refreshing data:', error);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n {/* Header */}\n

💬

\n WhatsApp Auto-Reply\n

\n Manage your automated responses\n

\n \n

\n {settings && (\n

\n \n {settings.enabled ? 'Active' : 'Inactive'}\n \n

\n )}\n \n \n \n Refresh\n \n

\n\n {/* Navigation Tabs */}\n

\n setActiveTab('dashboard')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'dashboard'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n

\n ⚙️\n Dashboard\n

\n \n \n setActiveTab('messages')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'messages'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n

\n 📝\n Message History\n

\n \n

\n\n {/* Main Content */}\n

\n {activeTab === 'dashboard' && (\n \n )}\n \n {activeTab === 'messages' && (\n \n )}\n

\n\n {/* Footer */}\n \n

\n );\n}","createdAt",["D",1748858514692],"branchVersion","branchId","05639eb8-3f96-11f0-847a-76b3cceeab13",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","239b2b7c-0f39-4327-aa9a-feae4d2f4ccf","components","directory",["D",1748858514692],"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",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"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",{"_49":50,"_32":51,"_38":303,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":304,"_86":305,"_88":306,"_90":25},"tree",[181,190,195,197,198],"files",[181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_171":68,"_172":141,"_173":68,"_174":175,"_176":177},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":165,"_32":166,"_30":167,"_140":-5,"_41":42,"_40":168,"_142":64,"_38":169,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":170},{"_49":159,"_32":160,"_30":161,"_140":-5,"_41":42,"_40":162,"_142":64,"_38":163,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":164},{"_49":153,"_32":154,"_30":155,"_140":-5,"_41":42,"_40":156,"_142":64,"_38":157,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":158},{"_49":146,"_32":147,"_30":148,"_140":-5,"_41":42,"_40":149,"_142":64,"_38":150,"_13":68,"_34":21,"_36":151,"_24":25,"_144":-5,"_27":152},{"_49":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":64,"_38":143,"_13":68,"_34":35,"_36":111,"_24":25,"_144":-5,"_27":145},"05657288-3f96-11f0-847a-76b3cceeab13","main.tsx","05657364-3f96-11f0-847a-76b3cceeab13","parentId",1,"latest",["D",1748857401660],"label",[138],"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",[147],"43f02c3a-3f98-11f0-a83c-76b3cceeab13","shared","03d7de3b-9d49-4cfe-b677-dd99fdff9b36",3,["D",1748858365579],[154],"8b28260c-3f98-11f0-a831-76b3cceeab13","frontend","01dad8cd-3be0-4288-b94d-c65362ebb501",10,["D",1748858485065],[160],"4db5d620-3f98-11f0-8582-76b3cceeab13","backend","c2c06425-fde9-4a84-adf8-77689c2ed6eb",4,["D",1748858381972],[166],"pulls","branches","forks","envVars",{"_178":68,"_180":68},"connections",{"_178":68,"_179":68},"count","unfilledCount","emptyCount",{"_49":165,"_32":166,"_30":167,"_140":-5,"_41":42,"_40":168,"_142":64,"_38":300,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":301,"_27":302},{"_49":296,"_32":288,"_30":282,"_140":167,"_41":42,"_40":168,"_142":64,"_38":297,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":298,"_27":299},{"_49":289,"_32":290,"_30":291,"_140":282,"_41":42,"_40":168,"_142":64,"_38":292,"_13":68,"_34":35,"_36":293,"_24":25,"_144":-5,"_200":294,"_27":295},{"_49":279,"_32":280,"_30":281,"_140":282,"_41":42,"_40":283,"_142":64,"_38":284,"_13":68,"_34":35,"_36":285,"_24":25,"_144":-5,"_200":286,"_27":287},{"_49":275,"_32":258,"_30":252,"_140":167,"_41":42,"_40":253,"_142":64,"_38":276,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":277,"_27":278},{"_49":267,"_32":268,"_30":269,"_140":252,"_41":42,"_40":270,"_142":64,"_38":271,"_13":68,"_34":35,"_36":272,"_24":25,"_144":-5,"_200":273,"_27":274},{"_49":259,"_32":260,"_30":261,"_140":252,"_41":42,"_40":262,"_142":25,"_38":263,"_13":68,"_34":35,"_36":264,"_24":25,"_144":-5,"_200":265,"_27":266},{"_49":249,"_32":250,"_30":251,"_140":252,"_41":42,"_40":253,"_142":64,"_38":254,"_13":68,"_34":35,"_36":255,"_24":25,"_144":-5,"_200":256,"_27":257},{"_49":242,"_32":243,"_30":62,"_140":167,"_41":42,"_40":244,"_142":25,"_38":245,"_13":68,"_34":35,"_36":246,"_24":25,"_144":-5,"_200":247,"_27":248},{"_49":159,"_32":160,"_30":161,"_140":-5,"_41":42,"_40":162,"_142":64,"_38":239,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":240,"_27":241},{"_49":235,"_32":46,"_30":45,"_140":161,"_41":42,"_40":14,"_142":64,"_38":236,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":237,"_27":238},{"_49":231,"_32":33,"_30":31,"_140":45,"_41":42,"_40":14,"_142":64,"_38":232,"_13":68,"_34":35,"_36":37,"_24":25,"_144":-5,"_200":233,"_27":234},{"_49":224,"_32":225,"_30":226,"_140":161,"_41":42,"_40":162,"_142":64,"_38":227,"_13":68,"_34":21,"_36":228,"_24":25,"_144":-5,"_200":229,"_27":230},{"_49":216,"_32":217,"_30":218,"_140":161,"_41":42,"_40":219,"_142":64,"_38":220,"_13":68,"_34":35,"_36":221,"_24":25,"_144":-5,"_200":222,"_27":223},{"_49":153,"_32":154,"_30":155,"_140":-5,"_41":42,"_40":156,"_142":64,"_38":213,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_200":214,"_27":215},{"_49":206,"_32":207,"_30":208,"_140":155,"_41":42,"_40":156,"_142":64,"_38":209,"_13":68,"_34":35,"_36":210,"_24":25,"_144":-5,"_200":211,"_27":212},{"_49":146,"_32":147,"_30":148,"_140":-5,"_41":42,"_40":149,"_142":64,"_38":203,"_13":68,"_34":21,"_36":151,"_24":25,"_144":-5,"_200":204,"_27":205},{"_49":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":64,"_38":199,"_13":68,"_34":35,"_36":111,"_24":25,"_144":-5,"_200":201,"_27":202},["D",1748857401660],"children",[],[138],["D",1748858352283],[],[147],"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}",[],[154,207],["D",1748858365579],[196],[154],"8e527440-3f98-11f0-859a-76b3cceeab13","index.tsx","8e5274ea-3f98-11f0-859a-76b3cceeab13",11,["D",1748858490376],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\n// Get initial data injected by the server\nconst initialData = (window as any).__INITIAL_DATA__ || {};\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[160,217],"8b2816e4-3f98-11f0-a831-76b3cceeab13","index.html","8b2817c0-3f98-11f0-a831-76b3cceeab13",["D",1748858485065],"\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",[],[160,225],"9cd0da7a-3f98-11f0-8f53-76b3cceeab13",["D",1748858514692],[],[160,46,33],"9cd100a4-3f98-11f0-8f53-76b3cceeab13",["D",1748858514692],[192],[160,46],["D",1748858485065],[191,193,194],[160],"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;",[],[166,243],"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;",[],[166,258,250],"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;",[],[166,258,260],"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;",[],[166,258,268],"6b02a956-3f98-11f0-857b-76b3cceeab13",["D",1748858431108],[186,187,188],[166,258],"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}",[],[166,288,280],"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}",[],[166,288,290],"4db5d814-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],[183,184],[166,288],["D",1748858381972],[182,185,189],[166],["D",1748857401649],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":340,"_341":342,"_343":344,"_345":25,"_346":25,"_347":25,"_348":64,"_349":-5,"_350":-7,"_351":-7,"_352":68,"_353":25,"_354":25,"_355":-5,"_356":25,"_357":25,"_358":25,"_359":-5},"ENV",{"_311":312,"_313":314,"_315":92,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339},"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 · v12