Handle: \\${code.handle}

Category: \\${code.category}

Details: \\${code.details || 'N/A'}

Time left:

\n \\`;\n container.appendChild(codeElement);\n });\n updateCountdowns();\n }\n\n function updateCountdowns() {\n const countdowns = document.querySelectorAll('.countdown');\n const now = new Date();\n countdowns.forEach(countdown => {\n const createdAt = new Date(countdown.dataset.created);\n const timeLeft = 300 - Math.floor((now - createdAt) / 1000);\n const countdownValue = countdown.querySelector('.countdown-value');\n if (timeLeft > 0) {\n countdownValue.textContent = \\`\\${timeLeft} seconds\\`;\n } else {\n countdownValue.textContent = 'Expired';\n }\n });\n }\n\n function formatPhoneNumber(phoneNumberString) {\n const cleaned = phoneNumberString.replace(/\\\\D/g, '');\n const match = cleaned.match(/^(\\\\d{0,3})(\\\\d{0,3})(\\\\d{0,4})$/);\n if (match) {\n const parts = [match[1], match[2], match[3]].filter(Boolean);\n if (parts.length === 1) {\n return \\`(\\${parts[0]}\\`;\n } else if (parts.length === 2) {\n return \\`(\\${parts[0]}) \\${parts[1]}\\`;\n } else if (parts.length === 3) {\n return \\`(\\${parts[0]}) \\${parts[1]}-\\${parts[2]}\\`;\n }\n }\n return phoneNumberString;\n }\n\n document.getElementById('phone').addEventListener('input', function(e) {\n const input = e.target;\n const formatted = formatPhoneNumber(input.value);\n input.value = formatted;\n });\n\n function validatePhoneNumber(phone) {\n const phoneRegex = /^\\\$\\\\d{3}\\\$\\\\s\\\\d{3}-\\\\d{4}$/;\n return phoneRegex.test(phone);\n }\n\n document.getElementById('generate').addEventListener('click', () => {\n const handle = document.getElementById('handle').value;\n const phone = document.getElementById('phone').value;\n const category = document.getElementById('category').value;\n const details = document.getElementById('details').value;\n\n if (!handle || !phone || !category) {\n alert('Please fill in all required fields');\n return;\n }\n\n if (!validatePhoneNumber(phone)) {\n alert('Please enter a valid phone number');\n return;\n }\n\n fetch('/generate', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ handle, phone, category, details }),\n })\n .then(response => response.json())\n .then(newCode => {\n existingCodes.unshift(newCode);\n renderExistingCodes();\n });\n });\n\n document.getElementById('filterCategory').addEventListener('change', updateExistingCodes);\n\n updateExistingCodes();\n setInterval(updateCountdowns, 1000);\n`;\n\nexport default async function server(req: Request): Promise {\n try {\n await initDB();\n const url = new URL(req.url);\n\n if (url.pathname === '/generate' && req.method === 'POST') {\n const { handle, phone, category, details } = await req.json();\n const id = nanoid();\n const created_at = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, handle, phone, category, details, created_at) VALUES (?, ?, ?, ?, ?, ?)`,\n [id, handle, phone, category, details, created_at]\n );\n\n const qrCodeText = `sms:${phone.replace(/\\D/g, '')}?body=Hi! I'm ${handle} from Razza. Let's chat about ${category}!`;\n const qrCodeSvg = generateQRCode(qrCodeText);\n\n const newCode = { id, handle, phone, category, details, qrCodeSvg, created_at };\n return new Response(JSON.stringify(newCode), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (url.pathname === '/existing-qr-codes' && req.method === 'GET') {\n const category = url.searchParams.get('category') || '';\n let query = `\n SELECT * FROM ${TABLE_NAME}\n WHERE created_at > datetime('now', '-5 minutes')\n `;\n const params = [];\n\n if (category && category !== '') {\n query += ` AND category = ?`;\n params.push(category);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n const now = new Date();\n const existingCodes = result.rows\n .filter(row => {\n const createdAt = new Date(row.created_at);\n return (now.getTime() - createdAt.getTime()) < 300000;\n })\n .map(row => ({\n ...row,\n qrCodeSvg: generateQRCode(`sms:${row.phone.replace(/\\D/g, '')}?body=Hi! I'm ${row.handle} from Razza. Let's chat about ${row.category}!`)\n }));\n\n return new Response(JSON.stringify(existingCodes), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(`\n \n \n \n \n \n Razza\n \n \n \n

Razza

New Chat

\n \n \n \n \n \n

Existing Chats

\n \n

\n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n } catch (error) {\n console.error('Server error:', error);\n return new Response(`An error occurred on the server: ${error.message}`, { status: 500 });\n }\n}","deleted","label",[99],"permalink","https://www.val.town/x/gio/razza/code/main.tsx","extension","actionData","errors"]