💬

Loading WhatsApp Auto-Reply Dashboard...

\n \n \n\n",[18,66],"9cd100a4-3f98-11f0-8f53-76b3cceeab13",["D",1748858514692],[18,90],"pulls","branches",1,"forks","envVars",{"_192":26,"_194":26},"connections",{"_192":26,"_193":26},"count","unfilledCount","emptyCount",{"_35":341,"_13":289,"_64":282,"_45":-5,"_37":38,"_164":332,"_165":24,"_39":342,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":343,"_17":344},{"_35":337,"_13":328,"_64":322,"_45":282,"_37":38,"_164":332,"_165":24,"_39":338,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":339,"_17":340},{"_35":329,"_13":330,"_64":331,"_45":322,"_37":38,"_164":332,"_165":24,"_39":333,"_41":26,"_67":81,"_167":334,"_68":30,"_168":-5,"_220":335,"_17":336},{"_35":319,"_13":320,"_64":321,"_45":322,"_37":38,"_164":323,"_165":24,"_39":324,"_41":26,"_67":81,"_167":325,"_68":30,"_168":-5,"_220":326,"_17":327},{"_35":315,"_13":299,"_64":293,"_45":282,"_37":38,"_164":294,"_165":24,"_39":316,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":317,"_17":318},{"_35":307,"_13":308,"_64":309,"_45":293,"_37":38,"_164":310,"_165":24,"_39":311,"_41":26,"_67":81,"_167":312,"_68":30,"_168":-5,"_220":313,"_17":314},{"_35":300,"_13":301,"_64":302,"_45":293,"_37":38,"_164":128,"_165":24,"_39":303,"_41":226,"_67":81,"_167":304,"_68":30,"_168":-5,"_220":305,"_17":306},{"_35":290,"_13":291,"_64":292,"_45":293,"_37":38,"_164":294,"_165":24,"_39":295,"_41":26,"_67":81,"_167":296,"_68":30,"_168":-5,"_220":297,"_17":298},{"_35":280,"_13":281,"_64":104,"_45":282,"_37":38,"_164":283,"_165":24,"_39":284,"_41":186,"_67":285,"_167":286,"_68":30,"_168":-5,"_220":287,"_17":288},{"_35":163,"_13":18,"_64":92,"_45":-5,"_37":38,"_164":42,"_165":24,"_39":277,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":278,"_17":279},{"_35":181,"_13":90,"_64":89,"_45":92,"_37":38,"_164":84,"_165":24,"_39":274,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":275,"_17":276},{"_35":267,"_13":268,"_64":269,"_45":89,"_37":38,"_164":84,"_165":24,"_39":270,"_41":26,"_67":81,"_167":271,"_68":30,"_168":-5,"_220":272,"_17":273},{"_35":259,"_13":260,"_64":261,"_45":89,"_37":38,"_164":262,"_165":24,"_39":263,"_41":26,"_67":81,"_167":264,"_68":30,"_168":-5,"_220":265,"_17":266},{"_35":251,"_13":252,"_64":253,"_45":89,"_37":38,"_164":254,"_165":24,"_39":255,"_41":26,"_67":81,"_167":256,"_68":30,"_168":-5,"_220":257,"_17":258},{"_35":177,"_13":66,"_64":65,"_45":92,"_37":38,"_164":42,"_165":24,"_39":248,"_41":26,"_67":21,"_167":179,"_68":30,"_168":-5,"_220":249,"_17":250},{"_35":173,"_13":80,"_64":79,"_45":92,"_37":38,"_164":74,"_165":24,"_39":245,"_41":26,"_67":81,"_167":175,"_68":30,"_168":-5,"_220":246,"_17":247},{"_35":241,"_13":240,"_64":234,"_45":-5,"_37":38,"_164":235,"_165":24,"_39":242,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_220":243,"_17":244},{"_35":231,"_13":232,"_64":233,"_45":234,"_37":38,"_164":235,"_165":24,"_39":236,"_41":26,"_67":81,"_167":237,"_68":30,"_168":-5,"_220":238,"_17":239},{"_35":223,"_13":224,"_64":225,"_45":-5,"_37":38,"_164":226,"_165":24,"_39":227,"_41":26,"_67":21,"_167":228,"_68":30,"_168":-5,"_220":229,"_17":230},{"_35":215,"_13":216,"_64":217,"_45":-5,"_37":38,"_164":186,"_165":24,"_39":218,"_41":26,"_67":81,"_167":219,"_68":30,"_168":-5,"_220":221,"_17":222},"05657288-3f96-11f0-847a-76b3cceeab13","main.tsx","05657364-3f96-11f0-847a-76b3cceeab13",["D",1748857401660],"","children",[],[216],"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",[],[224],"43f021f4-3f98-11f0-a83c-76b3cceeab13","types.ts","43f022d0-3f98-11f0-a83c-76b3cceeab13","03d7de3b-9d49-4cfe-b677-dd99fdff9b36",3,["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}",[],[240,232],"shared","43f02c3a-3f98-11f0-a83c-76b3cceeab13",["D",1748858365579],[212],[240],["D",1748858490376],[],[18,80],["D",1748858485065],[],[18,66],"e1af2016-3f98-11f0-81dc-76b3cceeab13","MessageHistory.tsx","e1af20c0-3f98-11f0-81dc-76b3cceeab13",14,["D",1748858630234],"/** @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}",[],[18,90,252],"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}",[],[18,90,260],"9cd0da7a-3f98-11f0-8f53-76b3cceeab13","App.tsx","9cd0db56-3f98-11f0-8f53-76b3cceeab13",["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}",[],[18,90,268],["D",1748858514692],[206,207,208],[18,90],["D",1748858485065],[205,209,210],[18],"e3cf0352-3f98-11f0-86b7-76b3cceeab13","index.ts","c2c06425-fde9-4a84-adf8-77689c2ed6eb",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;",[],[289,281],"backend","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;",[],[289,299,291],"routes","008a48f8-3f99-11f0-b6e4-76b3cceeab13","static.ts","7fc4bfbe-3f98-11f0-857d-76b3cceeab13",["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;",[],[289,299,301],"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;",[],[289,299,308],"6b02a956-3f98-11f0-857b-76b3cceeab13",["D",1748858431108],[200,201,202],[289,299],"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}",[],[289,328,320],"database","4db5ca18-3f98-11f0-8582-76b3cceeab13","migrations.ts","4db5caea-3f98-11f0-8582-76b3cceeab13",4,["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}",[],[289,328,330],"4db5d814-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],[197,198],[289,328],"4db5d620-3f98-11f0-8582-76b3cceeab13",["D",1748858381972],[196,199,203],[289],["D",1748857401649],{"_11":12,"_141":71},{"_11":12,"_137":-5,"_70":71,"_31":69,"_138":139,"_140":30},{"_41":128,"_13":16,"_35":38,"_129":94,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"ctx",{"_54":-5,"_160":382,"_383":384,"_385":386,"_387":30,"_388":30,"_389":30,"_390":24,"_391":-5,"_392":-7,"_393":-7,"_394":26,"_395":30,"_396":30,"_397":-5,"_398":30,"_399":30,"_400":30,"_401":-5},"ENV",{"_353":354,"_355":356,"_357":16,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381},"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"]

History · frontend