[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_312":313,"_314":315},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/Dashboard.tsx","latestPath","fileId","c965f8fe-3f98-11f0-8c15-76b3cceeab13","name","Dashboard.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 type { AutoReplySettings, DashboardStats, KeywordResponse } from \"../../shared/types.ts\";\n\ninterface DashboardProps {\n settings: AutoReplySettings | null;\n stats: DashboardStats | null;\n onSettingsUpdate: (settings: AutoReplySettings) => void;\n onRefresh: () => void;\n}\n\nexport default function Dashboard({ settings, stats, onSettingsUpdate, onRefresh }: DashboardProps) {\n const [formData, setFormData] = useState>({});\n const [keywords, setKeywords] = useState([]);\n const [newKeyword, setNewKeyword] = useState({ keyword: '', response: '', exact_match: false });\n const [editingKeyword, setEditingKeyword] = useState(null);\n const [saving, setSaving] = useState(false);\n const [testMessage, setTestMessage] = useState({ to: '', message: '' });\n const [testResult, setTestResult] = useState(null);\n\n useEffect(() => {\n if (settings) {\n setFormData(settings);\n setKeywords(settings.keyword_responses || []);\n }\n }, [settings]);\n\n const handleSaveSettings = async () => {\n setSaving(true);\n try {\n const response = await fetch('/api/settings', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(formData)\n });\n \n const result = await response.json();\n if (result.success) {\n onSettingsUpdate({ ...settings, ...formData } as AutoReplySettings);\n // Flash success\n document.body.classList.add('success-flash');\n setTimeout(() => document.body.classList.remove('success-flash'), 500);\n } else {\n alert('Error saving settings: ' + result.error);\n }\n } catch (error) {\n alert('Error saving settings: ' + error);\n } finally {\n setSaving(false);\n }\n };\n\n const handleAddKeyword = async () => {\n if (!newKeyword.keyword || !newKeyword.response) return;\n \n try {\n const response = await fetch('/api/keywords', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(newKeyword)\n });\n \n const result = await response.json();\n if (result.success) {\n const keywordsRes = await fetch('/api/keywords');\n const keywordsData = await keywordsRes.json();\n if (keywordsData.success) {\n setKeywords(keywordsData.data);\n }\n setNewKeyword({ keyword: '', response: '', exact_match: false });\n } else {\n alert('Error adding keyword: ' + result.error);\n }\n } catch (error) {\n alert('Error adding keyword: ' + error);\n }\n };\n\n const handleUpdateKeyword = async () => {\n if (!editingKeyword) return;\n \n try {\n const response = await fetch(`/api/keywords/${editingKeyword.id}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(editingKeyword)\n });\n \n const result = await response.json();\n if (result.success) {\n const keywordsRes = await fetch('/api/keywords');\n const keywordsData = await keywordsRes.json();\n if (keywordsData.success) {\n setKeywords(keywordsData.data);\n }\n setEditingKeyword(null);\n } else {\n alert('Error updating keyword: ' + result.error);\n }\n } catch (error) {\n alert('Error updating keyword: ' + error);\n }\n };\n\n const handleDeleteKeyword = async (id: number) => {\n if (!confirm('Are you sure you want to delete this keyword response?')) return;\n \n try {\n const response = await fetch(`/api/keywords/${id}`, {\n method: 'DELETE'\n });\n \n const result = await response.json();\n if (result.success) {\n setKeywords(keywords.filter(k => k.id !== id));\n } else {\n alert('Error deleting keyword: ' + result.error);\n }\n } catch (error) {\n alert('Error deleting keyword: ' + error);\n }\n };\n\n const handleTestMessage = async () => {\n if (!testMessage.to || !testMessage.message) {\n alert('Please enter both phone number and message');\n return;\n }\n \n try {\n const response = await fetch('/api/test-message', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(testMessage)\n });\n \n const result = await response.json();\n if (result.success) {\n setTestResult('✅ Test message sent successfully!');\n } else {\n setTestResult('❌ Failed to send test message: ' + result.error);\n }\n } catch (error) {\n setTestResult('❌ Error sending test message: ' + error);\n }\n \n setTimeout(() => setTestResult(null), 5000);\n };\n\n return (\n

\n {/* Stats Cards */}\n {stats && (\n

📊

Total Messages

{stats.total_messages}

\n \n

📅

Today

{stats.messages_today}

\n \n

✅

Replies Sent

{stats.replies_sent}

\n \n

🔥

Top Keywords

\n {stats.top_keywords.length > 0 \n ? stats.top_keywords.slice(0, 2).map(k => k.keyword).join(', ')\n : 'None yet'\n }\n

\n )}\n\n

\n {/* Settings Panel */}\n

Auto-Reply Settings

\n \n

\n {/* Enable/Disable */}\n

\n setFormData({ ...formData, enabled: e.target.checked })}\n className=\"h-4 w-4 text-blue-600 focus:ring-blue-500 border-gray-300 rounded\"\n />\n \n Enable auto-replies\n \n

\n\n {/* Mode Selection */}\n

\n Reply Mode\n setFormData({ ...formData, mode: e.target.value as any })}\n className=\"mt-1 block w-full pl-3 pr-10 py-2 text-base border-gray-300 focus:outline-none focus:ring-blue-500 focus:border-blue-500 sm:text-sm rounded-md\"\n >\n \n \n \n \n

\n\n {/* Default Message */}\n

\n Default Message\n setFormData({ ...formData, default_message: e.target.value })}\n rows={3}\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Enter your default auto-reply message...\"\n />\n

\n\n {/* Business Hours Settings */}\n {formData.mode === 'business_hours' && (\n

Business Hours

\n Start Time\n setFormData({ ...formData, business_hours_start: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n />\n

\n End Time\n setFormData({ ...formData, business_hours_end: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n />\n

\n Business Hours Message\n setFormData({ ...formData, business_hours_message: e.target.value })}\n rows={2}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Message to send during business hours...\"\n />\n

\n )}\n\n {/* Away Message Settings */}\n {formData.mode === 'away' && (\n

\n Away Message\n setFormData({ ...formData, away_message: e.target.value })}\n rows={3}\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Enter your away message...\"\n />\n

\n )}\n\n \n {saving ? 'Saving...' : 'Save Settings'}\n \n

\n\n {/* Test Message Panel */}\n

Test Message

\n \n

\n Phone Number\n setTestMessage({ ...testMessage, to: e.target.value })}\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"e.g., +1234567890\"\n />\n

\n \n

\n Message\n setTestMessage({ ...testMessage, message: e.target.value })}\n rows={3}\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Enter test message...\"\n />\n

\n \n \n Send Test Message\n \n \n {testResult && (\n

\n {testResult}\n

\n )}\n

\n\n {/* Keyword Responses */}\n

Keyword Responses

\n \n {/* Add New Keyword */}\n

Add New Keyword Response

\n setNewKeyword({ ...newKeyword, keyword: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Keyword...\"\n />\n setNewKeyword({ ...newKeyword, response: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n placeholder=\"Response...\"\n />\n

\n setNewKeyword({ ...newKeyword, exact_match: e.target.checked })}\n className=\"h-4 w-4 text-blue-600 focus:ring-blue-500 border-gray-300 rounded\"\n />\n Exact match\n

\n \n Add Keyword\n \n

\n\n {/* Keywords List */}\n

\n {keywords.map((keyword) => (\n

\n {editingKeyword?.id === keyword.id ? (\n

\n setEditingKeyword({ ...editingKeyword, keyword: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n />\n setEditingKeyword({ ...editingKeyword, response: e.target.value })}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm\"\n />\n

\n setEditingKeyword({ ...editingKeyword, exact_match: e.target.checked })}\n className=\"h-4 w-4 text-blue-600 focus:ring-blue-500 border-gray-300 rounded\"\n />\n Exact\n

\n ) : (\n

\n \"{keyword.keyword}\"\n →\n {keyword.response}\n {keyword.exact_match && (\n \n Exact\n \n )}\n

\n )}\n \n

\n {editingKeyword?.id === keyword.id ? (\n <>\n \n Save\n \n setEditingKeyword(null)}\n className=\"text-gray-600 hover:text-gray-900 text-sm\"\n >\n Cancel\n \n \n ) : (\n <>\n setEditingKeyword(keyword)}\n className=\"text-blue-600 hover:text-blue-900 text-sm\"\n >\n Edit\n \n handleDeleteKeyword(keyword.id!)}\n className=\"text-red-600 hover:text-red-900 text-sm\"\n >\n Delete\n \n \n )}\n

\n ))}\n \n {keywords.length === 0 && (\n

\n No keyword responses configured yet. Add one above to get started!\n

\n )}\n

\n );\n}","createdAt",["D",1748858589487],"branchVersion","branchId","05639eb8-3f96-11f0-847a-76b3cceeab13","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_31":44,"_37":308,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":309,"_79":310,"_81":311,"_83":24},"tree",[175,184,190,192,193],"files",[175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193],"counts",{"_165":61,"_166":134,"_167":61,"_168":169,"_170":171},"contents",[125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":163,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":157,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":158},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":150,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":152},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":143,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_26":145},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":57,"_37":136,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_26":138},"05657288-3f96-11f0-847a-76b3cceeab13","main.tsx","05657364-3f96-11f0-847a-76b3cceeab13","parentId",1,"latest",["D",1748857401660],"label",[131],"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",[140],"43f02c3a-3f98-11f0-a83c-76b3cceeab13","shared","03d7de3b-9d49-4cfe-b677-dd99fdff9b36",3,["D",1748858365579],"directory",[147],"8b28260c-3f98-11f0-a831-76b3cceeab13","frontend","01dad8cd-3be0-4288-b94d-c65362ebb501",10,["D",1748858485065],[154],"4db5d620-3f98-11f0-8582-76b3cceeab13","backend","c2c06425-fde9-4a84-adf8-77689c2ed6eb",4,["D",1748858381972],[160],"pulls","branches","forks","envVars",{"_172":61,"_174":61},"connections",{"_172":61,"_173":61},"count","unfilledCount","emptyCount",{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":305,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":306,"_26":307},{"_42":301,"_31":293,"_29":287,"_133":161,"_40":41,"_39":162,"_135":57,"_37":302,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":303,"_26":304},{"_42":294,"_31":295,"_29":296,"_133":287,"_40":41,"_39":162,"_135":57,"_37":297,"_13":61,"_33":34,"_35":298,"_23":24,"_137":-5,"_195":299,"_26":300},{"_42":284,"_31":285,"_29":286,"_133":287,"_40":41,"_39":288,"_135":57,"_37":289,"_13":61,"_33":34,"_35":290,"_23":24,"_137":-5,"_195":291,"_26":292},{"_42":280,"_31":263,"_29":257,"_133":161,"_40":41,"_39":258,"_135":57,"_37":281,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":282,"_26":283},{"_42":272,"_31":273,"_29":274,"_133":257,"_40":41,"_39":275,"_135":57,"_37":276,"_13":61,"_33":34,"_35":277,"_23":24,"_137":-5,"_195":278,"_26":279},{"_42":264,"_31":265,"_29":266,"_133":257,"_40":41,"_39":267,"_135":24,"_37":268,"_13":61,"_33":34,"_35":269,"_23":24,"_137":-5,"_195":270,"_26":271},{"_42":254,"_31":255,"_29":256,"_133":257,"_40":41,"_39":258,"_135":57,"_37":259,"_13":61,"_33":34,"_35":260,"_23":24,"_137":-5,"_195":261,"_26":262},{"_42":247,"_31":248,"_29":55,"_133":161,"_40":41,"_39":249,"_135":24,"_37":250,"_13":61,"_33":34,"_35":251,"_23":24,"_137":-5,"_195":252,"_26":253},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":244,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":245,"_26":246},{"_42":240,"_31":231,"_29":227,"_133":155,"_40":41,"_39":235,"_135":57,"_37":241,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":242,"_26":243},{"_42":232,"_31":233,"_29":234,"_133":227,"_40":41,"_39":235,"_135":57,"_37":236,"_13":61,"_33":34,"_35":237,"_23":24,"_137":-5,"_195":238,"_26":239},{"_42":226,"_31":32,"_29":30,"_133":227,"_40":41,"_39":14,"_135":57,"_37":228,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_195":229,"_26":230},{"_42":219,"_31":220,"_29":221,"_133":155,"_40":41,"_39":156,"_135":57,"_37":222,"_13":61,"_33":20,"_35":223,"_23":24,"_137":-5,"_195":224,"_26":225},{"_42":211,"_31":212,"_29":213,"_133":155,"_40":41,"_39":214,"_135":57,"_37":215,"_13":61,"_33":34,"_35":216,"_23":24,"_137":-5,"_195":217,"_26":218},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":208,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":209,"_26":210},{"_42":201,"_31":202,"_29":203,"_133":148,"_40":41,"_39":149,"_135":57,"_37":204,"_13":61,"_33":34,"_35":205,"_23":24,"_137":-5,"_195":206,"_26":207},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":198,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_195":199,"_26":200},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":57,"_37":194,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_195":196,"_26":197},["D",1748857401660],"children",[],[131],["D",1748858352283],[],[140],"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}",[],[147,202],["D",1748858365579],[191],[147],"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();",[],[154,212],"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",[],[154,220],"c965f714-3f98-11f0-8c15-76b3cceeab13","239b2b7c-0f39-4327-aa9a-feae4d2f4ccf",["D",1748858589487],[],[154,231,32],"components","9cd0da7a-3f98-11f0-8f53-76b3cceeab13","App.tsx","9cd0db56-3f98-11f0-8f53-76b3cceeab13",12,["D",1748858514692],"/** @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}",[],[154,231,233],"9cd100a4-3f98-11f0-8f53-76b3cceeab13",["D",1748858514692],[186,187],[154,231],["D",1748858485065],[185,188,189],[154],"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;",[],[160,248],"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;",[],[160,263,255],"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;",[],[160,263,265],"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;",[],[160,263,273],"6b02a956-3f98-11f0-857b-76b3cceeab13",["D",1748858431108],[180,181,182],[160,263],"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}",[],[160,293,285],"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}",[],[160,293,295],"4db5d814-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],[177,178],[160,293],["D",1748858381972],[176,179,183],[160],["D",1748857401649],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":345,"_346":347,"_348":349,"_350":24,"_351":24,"_352":24,"_353":57,"_354":-5,"_355":-7,"_356":-7,"_357":61,"_358":24,"_359":24,"_360":-5,"_361":24,"_362":24,"_363":24,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":85,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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 · v13