\");\n\n const signaturesSection = `\n

Current Signatures

${signaturesList}
No signatures yet. Be the first to sign!

`;\n\n let mainContent;\n let additionalScripts = \"\";\n\n if (pageType === \"form\") {\n additionalScripts = `\n \n \n `;\n\n mainContent = `\n ${signaturesSection}\n

Add your signature

\n \n

`;\n } else if (pageType === \"thankyou\") {\n mainContent = `\n

Thank you for signing.

\n ${signaturesSection}\n

\n ← Back to petition\n

`;\n }\n\n return new Response(\n `\n \n \n \n \n \n Creative Voices Speaking\n \n \n \n \n \n ${additionalScripts}\n ${getPetitionStyles()}\n \n \n

Creative Voices Speaking

From A Nationwide Group Of Theatre Artists

\n We the undersigned, practitioners of the theatre arts, are concerned\n by the political takeovers of the Kennedy Center in Washington DC and\n other aspects of our democracy. These actions are antithetical to our\n mission as creative artists who write, act, direct, produce, design,\n and work in all aspects of theater production.\n

\n We stand for theater that is free to express any and all points of view;\n free to create characters of our imagination, situations, feelings,\n places and thoughts that move us, bring us joy and sorrow, and dramatize\n all aspects of the human condition. National policies and practices must\n allow us the freedom to do our jobs unfettered by political actions.\n

\n ${mainContent}\n

\n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\n// Helper function for petition page styles\nfunction getPetitionStyles() {\n return `\n \n `;\n}\n\n// Helper function to create error pages\nfunction createErrorPage(message, details = \"\") {\n return new Response(\n `\n \n \n \n \n Creative Voices Speaking\n ${getPetitionStyles()}\n \n \n

Creative Voices Speaking

${message}

\n ${details ? `

${details}

` : \"\"}\n

\n ← Back to petition\n

\n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n status: 400,\n },\n );\n}\n\n// Admin page handler\nasync function handleAdminPage(req: Request): Promise {\n if (req.method === \"GET\") {\n return new Response(\n `\n \n \n \n \n Admin - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Admin Login

\n \n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n\n if (req.method === \"POST\") {\n const formData = await req.formData();\n const password = formData.get(\"password\")?.toString();\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\n `\n \n \n \n Admin - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Admin Login

Invalid password. Please try again.

\n ← Back to login\n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" }, status: 401 },\n );\n }\n\n // Get all signatures\n const signaturesResult = await sqlite.execute(\n `SELECT id, name, email, organization, signed_at FROM ${TABLE_NAME} ORDER BY signed_at DESC`,\n );\n const signatures = signaturesResult.rows || [];\n\n const signatureRows = signatures.map(row => `\n \n ${row[0]}\n ${row[1]}\n ${row[2] || \"\"}\n ${row[3] || \"\"}\n ${row[4]}\n \n \n \n \n `).join(\"\");\n\n return new Response(\n `\n \n \n \n \n Admin Dashboard - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Admin Dashboard

\n \n Import CSV\n View Petition\n

\n \n

Signatures (${signatures.length} total)

\n \n \n \n \n \n \n \n \n \n \n \n \n \n ${signatureRows}\n \n

ID	Name	Email	Organization	Signed At	Actions

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n\n return new Response(\"Method not allowed\", { status: 405 });\n}\n\n// Helper function for admin styles\nfunction getAdminStyles() {\n return `\n \n `;\n}\n\n// Admin delete handler\nasync function handleAdminDelete(req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const formData = await req.formData();\n const id = formData.get(\"id\")?.toString();\n const password = formData.get(\"password\")?.toString();\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n if (!id) {\n return new Response(\"Missing ID\", { status: 400 });\n }\n\n // Delete the signature\n await sqlite.execute(`DELETE FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n\n // Redirect back to admin page with password\n return new Response(\n `\n \n \n \n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}\n\n// Admin export handler\nasync function handleAdminExport(req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const formData = await req.formData();\n const password = formData.get(\"password\")?.toString();\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n // Get all signatures\n const signaturesResult = await sqlite.execute(\n `SELECT name, email, organization, signed_at FROM ${TABLE_NAME} ORDER BY signed_at ASC`,\n );\n const signatures = signaturesResult.rows || [];\n\n // Create CSV content\n const csvHeader = \"Name,Email,Organization,Signed At\\n\";\n const csvRows = signatures.map(row => {\n const name = `\"${row[0].toString().replace(/\"/g, \"\\\"\\\"\")}\"`;\n const email = `\"${row[1].toString().replace(/\"/g, \"\\\"\\\"\")}\"`;\n const organization = row[2] ? `\"${row[2].toString().replace(/\"/g, \"\\\"\\\"\")}\"` : \"\\\"\\\"\";\n const signedAt = `\"${row[3].toString().replace(/\"/g, \"\\\"\\\"\")}\"`;\n return `${name},${email},${organization},${signedAt}`;\n }).join(\"\\n\");\n\n const csvContent = csvHeader + csvRows;\n\n // Generate filename with current date\n const now = new Date();\n const filename = `petition_signatures_${now.getFullYear()}-${String(now.getMonth() + 1).padStart(2, \"0\")}-${\n String(now.getDate()).padStart(2, \"0\")\n }.csv`;\n\n return new Response(csvContent, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=\"${filename}\"`,\n },\n });\n}\n\n// Admin import handler\nasync function handleAdminImport(req: Request): Promise {\n const url = new URL(req.url);\n const password = url.searchParams.get(\"password\");\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n if (req.method === \"GET\") {\n // Show import form\n return new Response(\n `\n \n \n \n \n Import CSV - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Import Signatures

CSV Format: The file should have columns: Name, Email, Organization, Signed At

Note: This will add new signatures and update existing ones based on email address.

\n \n \n \n

\n ← Back to Admin Dashboard\n

\n \n \n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n\n if (req.method === \"POST\") {\n try {\n const formData = await req.formData();\n const csvFile = formData.get(\"csvFile\") as File;\n\n if (!csvFile) {\n throw new Error(\"No file uploaded\");\n }\n\n const csvContent = await csvFile.text();\n const lines = csvContent.split(\"\\n\").filter(line => line.trim());\n\n if (lines.length < 2) {\n throw new Error(\"CSV file must have at least a header and one data row\");\n }\n\n // Skip header row and process data\n const dataLines = lines.slice(1);\n let importedCount = 0;\n let skippedCount = 0;\n const errors = [];\n\n for (let i = 0; i < dataLines.length; i++) {\n const line = dataLines[i].trim();\n if (!line) continue;\n\n try {\n // Parse CSV line (simple parsing - handles quoted fields)\n const fields = parseCSVLine(line);\n\n if (fields.length < 2) {\n errors.push(`Line ${i + 2}: Not enough fields`);\n continue;\n }\n\n const name = fields[0]?.trim();\n const email = fields[1]?.trim();\n const organization = fields[2]?.trim() || null;\n const signedAt = fields[3]?.trim() || new Date().toISOString();\n\n if (!name || !email) {\n errors.push(`Line ${i + 2}: Missing name or email`);\n continue;\n }\n\n // Validate field lengths\n if (name.length > 100) {\n errors.push(`Line ${i + 2}: Name too long (${name.length} chars, max 100)`);\n continue;\n }\n if (email.length > 254) {\n errors.push(`Line ${i + 2}: Email too long (${email.length} chars, max 254)`);\n continue;\n }\n if (organization && organization.length > 200) {\n errors.push(`Line ${i + 2}: Organization too long (${organization.length} chars, max 200)`);\n continue;\n }\n\n // Check if email already exists\n const existingResult = await sqlite.execute(\n `SELECT id FROM ${TABLE_NAME} WHERE email = ?`,\n [email],\n );\n\n if (existingResult.rows && existingResult.rows.length > 0) {\n // Update existing signature instead of skipping\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET name = ?, organization = ? WHERE email = ?`,\n [name, organization, email],\n );\n skippedCount++; // Still count as \"skipped\" for reporting, but actually updated\n continue;\n }\n\n // Insert the signature\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (name, email, organization, signed_at) VALUES (?, ?, ?, ?)`,\n [name, email, organization, signedAt],\n );\n\n importedCount++;\n } catch (error) {\n errors.push(`Line ${i + 2}: ${error.message}`);\n }\n }\n\n // Show results\n const errorSection = errors.length > 0\n ? `

Errors encountered:

${error}

`\n : \"\";\n\n return new Response(\n `\n \n \n \n Import Results - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Import Results

\n \n

Import completed!

Imported: ${importedCount} new signatures

Updated: ${skippedCount} existing signatures

\n \n ${errorSection}\n \n

\n ← Back to Admin Dashboard\n

\n \n \n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n } catch (error) {\n return new Response(\n `\n \n \n \n Import Error - Creative Voices Speaking\n ${getAdminStyles()}\n \n \n

Import Error

\n \n

Import failed: ${error.message}

\n \n

\n ← Try Again\n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" }, status: 400 },\n );\n }\n }\n\n return new Response(\"Method not allowed\", { status: 405 });\n}\n\n// Helper function to parse CSV line (handles quoted fields)\nfunction parseCSVLine(line: string): string[] {\n const fields = [];\n let current = \"\";\n let inQuotes = false;\n let i = 0;\n\n while (i < line.length) {\n const char = line[i];\n\n if (char === \"\\\"\") {\n if (inQuotes && line[i + 1] === \"\\\"\") {\n // Escaped quote\n current += \"\\\"\";\n i += 2;\n } else {\n // Toggle quote state\n inQuotes = !inQuotes;\n i++;\n }\n } else if (char === \",\" && !inQuotes) {\n // End of field\n fields.push(current.trim());\n current = \"\";\n i++;\n } else {\n current += char;\n i++;\n }\n }\n\n // Add the last field\n fields.push(current.trim());\n\n // Remove surrounding quotes from fields\n return fields.map(field => {\n if (field.startsWith(\"\\\"\") && field.endsWith(\"\\\"\")) {\n return field.slice(1, -1);\n }\n return field;\n });\n}","deleted","label","creative-voices-speaking",[99],"permalink","https://www.val.town/x/creativevoicesspeaking/petition/code/main.tsx","extension","actionData","errors"]