Event RSVP

\n \n {message && (\n

\n {message}\n

\n )}\n

\n );\n}\n\nconst styles = {\n container: {\n maxWidth: '400px',\n margin: '0 auto',\n padding: '20px',\n fontFamily: 'Arial, sans-serif'\n },\n form: {\n display: 'flex',\n flexDirection: 'column' as const,\n gap: '10px'\n },\n successMessage: {\n color: 'green',\n textAlign: 'center'\n },\n errorMessage: {\n color: 'red',\n textAlign: 'center'\n }\n};\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { email } = await import(\"https://esm.town/v/std/email\");\n\n const KEY = \"Rsvp\";\n const SCHEMA_VERSION = 2;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_rsvps_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n surname TEXT NOT NULL,\n cellphone TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n qr_code TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === 'POST') {\n try {\n const { name, surname, cellphone, email: userEmail } = await request.json();\n\n // Validate input\n if (!name || !surname || !cellphone || !userEmail) {\n return new Response(JSON.stringify({ \n message: \"All fields are required.\" \n }), { \n status: 400,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Validate phone number (10 digits)\n const phoneRegex = /^[0-9]{10}$/;\n if (!phoneRegex.test(cellphone)) {\n return new Response(JSON.stringify({ \n message: \"Please enter a valid 10-digit phone number.\" \n }), { \n status: 400,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Generate unique QR code data\n const qrCodeData = `RSVP:${name} ${surname}\\nPhone: ${cellphone}\\nEmail: ${userEmail}`;\n const qrCodeBase64 = await QRCode.toDataURL(qrCodeData);\n\n // Insert RSVP into database\n await sqlite.execute(`\n INSERT INTO ${KEY}_rsvps_${SCHEMA_VERSION} \n (name, surname, cellphone, email, qr_code) \n VALUES (?, ?, ?, ?, ?)\n `, [name, surname, cellphone, userEmail, qrCodeBase64]);\n\n // Send email with QR code\n await email({\n to: [userEmail],\n subject: \"Your Event RSVP Confirmation\",\n html: `\n

RSVP Confirmation

Thank you for your RSVP, ${name} ${surname}!

\n $\"Your$ \n `,\n text: `Thank you for your RSVP, ${name} ${surname}!`\n });\n\n return new Response(JSON.stringify({ \n message: \"RSVP Submitted Successfully! Check your email for the QR code.\" \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } catch (err) {\n console.error(\"RSVP Submission Error:\", err);\n \n // Check for unique constraint violation (duplicate email)\n if (err instanceof Error && err.message.includes('UNIQUE constraint failed')) {\n return new Response(JSON.stringify({ \n message: \"This email is already registered for the event.\" \n }), { \n status: 400,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n return new Response(JSON.stringify({ \n message: \"An unexpected error occurred. Please try again later.\" \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n return new Response(`\n \n \n Event RSVP\n \n \n \n

\n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/Ndosirichman/Rsvp/code/main.tsx","extension","actionData","errors"]