[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_383":384,"_385":386},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_284":-5,"_20":285,"_22":286,"_287":288,"_289":290,"_26":291,"_24":292,"_293":-5,"_294":-5,"_295":57,"_296":297,"_298":48,"_299":-5,"_300":-5,"_301":302},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Lyte","name","untitled-3191","branchName","main","version","path","frontend/components","project",{"_36":231,"_13":14,"_49":232,"_233":-5,"_234":57,"_235":236,"_237":236,"_238":-5,"_239":-5,"_240":241,"_242":168,"_243":48,"_244":48,"_245":-5,"_246":51,"_247":248,"_249":-5,"_250":-5,"_251":-5,"_252":-5,"_253":254,"_255":254,"_256":257,"_258":257,"_259":257,"_260":254,"_261":254,"_262":263,"_264":265,"_266":267,"_268":57},"tree",[81,82,83,84,85],"file",{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":78,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_18":80},"contents",[33,34,35],"upstream","pull","ahead","behind","envVars",{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":73,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":75},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_18":68},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":59},"id","e1af2016-3f98-11f0-81dc-76b3cceeab13","MessageHistory.tsx","fileId","e1af20c0-3f98-11f0-81dc-76b3cceeab13","parentId","239b2b7c-0f39-4327-aa9a-feae4d2f4ccf","branchId","05639eb8-3f96-11f0-847a-76b3cceeab13","branchVersion",14,"latest",true,"createdAt",["D",1748858630234],0,"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 { MessageLog } from \"../../shared/types.ts\";\n\nexport default function MessageHistory() {\n const [messages, setMessages] = useState([]);\n const [loading, setLoading] = useState(true);\n const [page, setPage] = useState(0);\n const [hasMore, setHasMore] = useState(true);\n const [filter, setFilter] = useState<'all' | 'replied' | 'no_reply'>('all');\n\n const loadMessages = async (pageNum: number = 0, reset: boolean = false) => {\n setLoading(true);\n try {\n const response = await fetch(`/api/messages?limit=20&offset=${pageNum * 20}`);\n const result = await response.json();\n \n if (result.success) {\n const newMessages = result.data;\n if (reset) {\n setMessages(newMessages);\n } else {\n setMessages(prev => [...prev, ...newMessages]);\n }\n setHasMore(newMessages.length === 20);\n }\n } catch (error) {\n console.error('Error loading messages:', error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n loadMessages(0, true);\n }, []);\n\n const handleLoadMore = () => {\n const nextPage = page + 1;\n setPage(nextPage);\n loadMessages(nextPage);\n };\n\n const handleRefresh = () => {\n setPage(0);\n loadMessages(0, true);\n };\n\n const filteredMessages = messages.filter(message => {\n switch (filter) {\n case 'replied':\n return message.reply_sent;\n case 'no_reply':\n return !message.reply_sent;\n default:\n return true;\n }\n });\n\n const formatPhoneNumber = (number: string) => {\n // Simple formatting for display\n if (number.length >= 10) {\n return `${number.slice(0, -10)}${number.slice(-10, -7)}-${number.slice(-7, -4)}-${number.slice(-4)}`;\n }\n return number;\n };\n\n const formatTimestamp = (timestamp: string) => {\n return new Date(timestamp).toLocaleString();\n };\n\n return (\n

\n {/* Header */}\n

Message History

View all incoming messages and auto-replies

\n \n \n \n Refresh\n \n

\n\n {/* Filters */}\n

\n Filter:\n

\n {[\n { key: 'all', label: 'All Messages', count: messages.length },\n { key: 'replied', label: 'Replied', count: messages.filter(m => m.reply_sent).length },\n { key: 'no_reply', label: 'No Reply', count: messages.filter(m => !m.reply_sent).length }\n ].map(({ key, label, count }) => (\n setFilter(key as any)}\n className={`inline-flex items-center px-3 py-1.5 rounded-full text-sm font-medium ${\n filter === key\n ? 'bg-blue-100 text-blue-800'\n : 'bg-gray-100 text-gray-700 hover:bg-gray-200'\n }`}\n >\n {label} ({count})\n \n ))}\n

\n\n {/* Messages List */}\n

\n {filteredMessages.length === 0 ? (\n

📭

No messages found

\n {filter === 'all' \n ? \"No messages have been received yet.\"\n : `No messages match the \"${filter.replace('_', ' ')}\" filter.`\n }\n

\n ) : (\n

\n {filteredMessages.map((message) => (\n

\n {/* Message Header */}\n

\n \n {formatPhoneNumber(message.from_number)}\n \n \n {message.reply_sent ? '✅ Replied' : '⏳ No Reply'}\n \n

\n \n {formatTimestamp(message.timestamp)}\n \n

\n\n {/* Incoming Message */}\n

{message.message_text}

\n\n {/* Auto Reply */}\n {message.reply_sent && message.reply_text && (\n

{message.reply_text}

Auto-reply

\n )}\n

\n\n {/* Message Actions */}\n

\n navigator.clipboard.writeText(message.message_text)}\n className=\"text-gray-400 hover:text-gray-600\"\n title=\"Copy message\"\n >\n \n \n

\n ))}\n

\n )}\n\n {/* Load More Button */}\n {hasMore && filteredMessages.length > 0 && (\n

\n \n {loading ? (\n <>\n \n Loading...\n \n ) : (\n 'Load More Messages'\n )}\n \n

\n )}\n

\n\n {/* Summary Stats */}\n {filteredMessages.length > 0 && (\n

{filteredMessages.length}

Total Messages

\n {filteredMessages.filter(m => m.reply_sent).length}\n

Auto-Replies Sent

\n {Math.round((filteredMessages.filter(m => m.reply_sent).length / filteredMessages.length) * 100)}%\n

Reply Rate

\n )}\n

\n );\n}","deleted",false,"label",[60,61,38],"frontend","components","c965f714-3f98-11f0-8c15-76b3cceeab13","Dashboard.tsx","c965f8fe-3f98-11f0-8c15-76b3cceeab13",13,["D",1748858589487],"/** @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}",[60,61,63],"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}",[60,61,70],"9cd100a4-3f98-11f0-8f53-76b3cceeab13","01dad8cd-3be0-4288-b94d-c65362ebb501",["D",1748858514692],"directory",[60,61],{"_36":156,"_13":157,"_39":158,"_41":-5,"_43":44,"_45":159,"_47":48,"_49":160,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":161,"_18":162},{"_36":118,"_13":60,"_39":77,"_41":-5,"_43":44,"_45":119,"_47":48,"_49":120,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":121,"_18":122},{"_36":103,"_13":104,"_39":105,"_41":-5,"_43":44,"_45":106,"_47":48,"_49":107,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":108,"_18":109},{"_36":95,"_13":96,"_39":97,"_41":-5,"_43":44,"_45":98,"_47":48,"_49":99,"_17":51,"_52":24,"_54":100,"_56":57,"_58":-5,"_92":101,"_18":102},{"_36":86,"_13":87,"_39":88,"_41":-5,"_43":44,"_45":89,"_47":48,"_49":90,"_17":51,"_52":53,"_54":91,"_56":57,"_58":-5,"_92":93,"_18":94},"05657288-3f96-11f0-847a-76b3cceeab13","main.tsx","05657364-3f96-11f0-847a-76b3cceeab13",1,["D",1748857401660],"","children",[],[87],"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",[],[96],"43f02c3a-3f98-11f0-a83c-76b3cceeab13","shared","03d7de3b-9d49-4cfe-b677-dd99fdff9b36",3,["D",1748858365579],[110],[104],{"_36":111,"_13":112,"_39":113,"_41":105,"_43":44,"_45":106,"_47":48,"_49":114,"_17":51,"_52":53,"_54":115,"_56":57,"_58":-5,"_92":116,"_18":117},"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}",[],[104,112],"8b28260c-3f98-11f0-a831-76b3cceeab13",10,["D",1748858485065],[123,124,125],[60],{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":141,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":142,"_18":143},{"_36":134,"_13":135,"_39":136,"_41":77,"_43":44,"_45":119,"_47":48,"_49":137,"_17":51,"_52":24,"_54":138,"_56":57,"_58":-5,"_92":139,"_18":140},{"_36":126,"_13":127,"_39":128,"_41":77,"_43":44,"_45":129,"_47":48,"_49":130,"_17":51,"_52":53,"_54":131,"_56":57,"_58":-5,"_92":132,"_18":133},"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();",[],[60,127],"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",[],[60,135],["D",1748858514692],[144,145,146],[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":153,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_92":154,"_18":155},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":150,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_92":151,"_18":152},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":147,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_92":148,"_18":149},["D",1748858630234],[],[60,61,38],["D",1748858589487],[],[60,61,63],["D",1748858514692],[],[60,61,70],"4db5d620-3f98-11f0-8582-76b3cceeab13","backend","c2c06425-fde9-4a84-adf8-77689c2ed6eb",4,["D",1748858381972],[163,164,165],[157],{"_36":208,"_13":209,"_39":210,"_41":158,"_43":44,"_45":159,"_47":48,"_49":211,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":212,"_18":213},{"_36":175,"_13":176,"_39":177,"_41":158,"_43":44,"_45":178,"_47":48,"_49":179,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":180,"_18":181},{"_36":166,"_13":167,"_39":168,"_41":158,"_43":44,"_45":169,"_47":48,"_49":170,"_17":89,"_52":171,"_54":172,"_56":57,"_58":-5,"_92":173,"_18":174},"e3cf0352-3f98-11f0-86b7-76b3cceeab13","index.ts","8513feee-3f98-11f0-8c15-76b3cceeab13",15,["D",1748858633794],"http","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;",[],[157,167],"6b02a956-3f98-11f0-857b-76b3cceeab13","routes","c4820e9d-dbb6-4b71-9b3b-5cbf472c4441",6,["D",1748858431108],[182,183,184],[157,176],{"_36":200,"_13":201,"_39":202,"_41":177,"_43":44,"_45":203,"_47":48,"_49":204,"_17":51,"_52":53,"_54":205,"_56":57,"_58":-5,"_92":206,"_18":207},{"_36":192,"_13":193,"_39":194,"_41":177,"_43":44,"_45":195,"_47":48,"_49":196,"_17":98,"_52":53,"_54":197,"_56":57,"_58":-5,"_92":198,"_18":199},{"_36":185,"_13":186,"_39":187,"_41":177,"_43":44,"_45":178,"_47":48,"_49":188,"_17":51,"_52":53,"_54":189,"_56":57,"_58":-5,"_92":190,"_18":191},"6b029a9c-3f98-11f0-857b-76b3cceeab13","webhook.ts","6b029b64-3f98-11f0-857b-76b3cceeab13",["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;",[],[157,176,186],"008a48f8-3f99-11f0-b6e4-76b3cceeab13","static.ts","7fc4bfbe-3f98-11f0-857d-76b3cceeab13",17,["D",1748858681996],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/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 try {\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 } catch (dataError) {\n console.log(\"Could not load initial data, serving basic page:\", dataError);\n // Continue with basic HTML if data loading fails\n }\n\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.html(`\n \n \n \n WhatsApp Auto-Reply\n \n \n \n

WhatsApp Auto-Reply Dashboard

\n \n \n `);\n }\n});\n\nexport default staticRoutes;",[],[157,176,193],"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;",[],[157,176,201],"4db5d814-3f98-11f0-8582-76b3cceeab13","database","6ea90ad0-a19b-41fd-b23b-428785e9ec5e",["D",1748858381972],[214,215],[157,209],{"_36":224,"_13":225,"_39":226,"_41":210,"_43":44,"_45":159,"_47":48,"_49":227,"_17":51,"_52":53,"_54":228,"_56":57,"_58":-5,"_92":229,"_18":230},{"_36":216,"_13":217,"_39":218,"_41":210,"_43":44,"_45":219,"_47":48,"_49":220,"_17":51,"_52":53,"_54":221,"_56":57,"_58":-5,"_92":222,"_18":223},"5d97b48c-3f98-11f0-a75f-76b3cceeab13","queries.ts","5d97b536-3f98-11f0-a75f-76b3cceeab13",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}",[],[157,209,217],"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}",[],[157,209,225],"05632b36-3f96-11f0-847a-76b3cceeab13",["D",1748857401649],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","16eccca0-3f95-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","d0af734c-162b-413f-ab5d-d85f6c3fb438","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_283":279},"org",{"_11":12,"_277":-5,"_278":279,"_240":241,"_280":281,"_282":57},"branch",{"_17":195,"_13":16,"_36":44,"_269":231,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":-5,"_275":14,"_276":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2xObDJLVHFLclU5S3g2UkhQdEN2U0N4dCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":231,"_13":14,"_49":379,"_233":-5,"_234":57,"_235":236,"_237":236,"_238":-5,"_239":-5,"_240":241,"_242":168,"_243":48,"_244":48,"_245":-5,"_246":51,"_247":248,"_249":-5,"_250":-5,"_251":-5,"_252":-5,"_253":254,"_255":254,"_256":257,"_258":257,"_259":257,"_260":254,"_261":254,"_262":380,"_264":381,"_266":382,"_268":57},[319,328,335,337,338],"files",[319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338],"counts",{"_310":51,"_311":89,"_312":51,"_32":313,"_314":315},[304,305,306],{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":78,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_18":303},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":73,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":309},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_18":308},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":307},[60,61,38],[60,61,63],[60,61,70],"pulls","branches","forks",{"_316":51,"_318":51},"connections",{"_316":51,"_317":51},"count","unfilledCount","emptyCount",{"_36":156,"_13":157,"_39":158,"_41":-5,"_43":44,"_45":159,"_47":48,"_49":160,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":377,"_18":378},{"_36":208,"_13":209,"_39":210,"_41":158,"_43":44,"_45":159,"_47":48,"_49":211,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":375,"_18":376},{"_36":224,"_13":225,"_39":226,"_41":210,"_43":44,"_45":159,"_47":48,"_49":227,"_17":51,"_52":53,"_54":228,"_56":57,"_58":-5,"_92":373,"_18":374},{"_36":216,"_13":217,"_39":218,"_41":210,"_43":44,"_45":219,"_47":48,"_49":220,"_17":51,"_52":53,"_54":221,"_56":57,"_58":-5,"_92":371,"_18":372},{"_36":175,"_13":176,"_39":177,"_41":158,"_43":44,"_45":178,"_47":48,"_49":179,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":369,"_18":370},{"_36":200,"_13":201,"_39":202,"_41":177,"_43":44,"_45":203,"_47":48,"_49":204,"_17":51,"_52":53,"_54":205,"_56":57,"_58":-5,"_92":367,"_18":368},{"_36":192,"_13":193,"_39":194,"_41":177,"_43":44,"_45":195,"_47":48,"_49":196,"_17":98,"_52":53,"_54":197,"_56":57,"_58":-5,"_92":365,"_18":366},{"_36":185,"_13":186,"_39":187,"_41":177,"_43":44,"_45":178,"_47":48,"_49":188,"_17":51,"_52":53,"_54":189,"_56":57,"_58":-5,"_92":363,"_18":364},{"_36":166,"_13":167,"_39":168,"_41":158,"_43":44,"_45":169,"_47":48,"_49":170,"_17":89,"_52":171,"_54":172,"_56":57,"_58":-5,"_92":361,"_18":362},{"_36":118,"_13":60,"_39":77,"_41":-5,"_43":44,"_45":119,"_47":48,"_49":120,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":359,"_18":360},{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":141,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":357,"_18":358},{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":153,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_92":355,"_18":356},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":150,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_92":353,"_18":354},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":147,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_92":351,"_18":352},{"_36":134,"_13":135,"_39":136,"_41":77,"_43":44,"_45":119,"_47":48,"_49":137,"_17":51,"_52":24,"_54":138,"_56":57,"_58":-5,"_92":349,"_18":350},{"_36":126,"_13":127,"_39":128,"_41":77,"_43":44,"_45":129,"_47":48,"_49":130,"_17":51,"_52":53,"_54":131,"_56":57,"_58":-5,"_92":347,"_18":348},{"_36":103,"_13":104,"_39":105,"_41":-5,"_43":44,"_45":106,"_47":48,"_49":107,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_92":345,"_18":346},{"_36":111,"_13":112,"_39":113,"_41":105,"_43":44,"_45":106,"_47":48,"_49":114,"_17":51,"_52":53,"_54":115,"_56":57,"_58":-5,"_92":343,"_18":344},{"_36":95,"_13":96,"_39":97,"_41":-5,"_43":44,"_45":98,"_47":48,"_49":99,"_17":51,"_52":24,"_54":100,"_56":57,"_58":-5,"_92":341,"_18":342},{"_36":86,"_13":87,"_39":88,"_41":-5,"_43":44,"_45":89,"_47":48,"_49":90,"_17":51,"_52":53,"_54":91,"_56":57,"_58":-5,"_92":339,"_18":340},[],[87],[],[96],[],[104,112],[336],[104],[],[60,127],[],[60,135],[],[60,61,38],[],[60,61,63],[],[60,61,70],[330,331,332],[60,61],[329,333,334],[60],[],[157,167],[],[157,176,186],[],[157,176,193],[],[157,176,201],[324,325,326],[157,176],[],[157,209,217],[],[157,209,225],[321,322],[157,209],[320,323,327],[157],["D",1748857401649],{"_11":12,"_283":279},{"_11":12,"_277":-5,"_278":279,"_240":241,"_280":281,"_282":57},{"_17":195,"_13":16,"_36":44,"_269":231,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":-5,"_275":14,"_276":12},"ctx",{"_262":-5,"_300":416,"_417":418,"_419":420,"_421":57,"_422":57,"_423":57,"_424":48,"_425":-5,"_426":-7,"_427":-7,"_428":51,"_429":57,"_430":57,"_431":-5,"_432":57,"_433":57,"_434":57,"_435":-5},"ENV",{"_387":388,"_389":390,"_391":16,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]