Set Admin Password

\n \n

\n );\n }\n\n return (\n

Wedding RSVP Dashboard 📊

\n \n

Guest Statistics

Total Invited: {stats.totalInvited}

Attending: {stats.attending}

Not Attending: {stats.notAttending}

Total Guests: {stats.totalGuests}

\n \n

Catering Estimates

Main Dishes: {cateringEstimates.mainDishes} 🍽️

Vegetarian Dishes: {cateringEstimates.vegetarianDishes} 🥗

Vegan Dishes: {cateringEstimates.veganDishes} 🥬

Drinks: {cateringEstimates.drinks} 🍷

Alcohol Servings: {cateringEstimates.alcoholServings} 🍸

\n\n

Guest List

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {guests.map((guest, index) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

Name	Email	Attending	Guests	Food Preference	Dietary Restrictions	Timestamp
{guest.name}	{guest.email}	{guest.attending}	{guest.guests}	{guest.food_preference}	{guest.dietary_restrictions}	{new Date(guest.timestamp).toLocaleString()}

\n );\n}\n\n// Main RSVP Form Component\nfunction App() {\n const [name, setName] = useState('');\n const [email, setEmail] = useState('');\n const [attending, setAttending] = useState<'yes' | 'no'>('yes');\n const [guests, setGuests] = useState(0);\n const [dietaryRestrictions, setDietaryRestrictions] = useState('');\n const [foodPreference, setFoodPreference] = useState<'meat' | 'vegetarian' | 'vegan'>('meat');\n const [submitted, setSubmitted] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n const response = await fetch('/rsvp', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n name, \n email, \n attending, \n guests, \n dietaryRestrictions,\n foodPreference\n })\n });\n \n if (response.ok) {\n setSubmitted(true);\n }\n };\n\n if (submitted) {\n return

Thank you for your RSVP! 🎉💍

;\n }\n\n return (\n

Wedding RSVP 💒

\n Name:\n setName(e.target.value)} \n required \n style={{ width: '100%', padding: '10px', margin: '10px 0' }}\n />\n

\n Email:\n setEmail(e.target.value)} \n required \n style={{ width: '100%', padding: '10px', margin: '10px 0' }}\n />\n

\n Will you attend?\n \n

\n {attending === 'yes' && (\n <>\n

\n Number of Guests:\n setGuests(Number(e.target.value))} \n min=\"0\" \n style={{ width: '100%', padding: '10px', margin: '10px 0' }}\n />\n

\n Food Preference:\n \n

\n Dietary Restrictions:\n

setDietaryRestrictions(e.target.value)}\n                style={{ width: '100%', padding: '10px', margin: '10px 0' }}\n              />\n            </div>\n          </>\n        )}\n        <button \n          type=\"submit\" \n          style={{ \n            width: '100%', \n            padding: '10px', \n            backgroundColor: '#4CAF50', \n            color: 'white', \n            border: 'none' \n          }}\n        >\n          Submit RSVP\n        </button>\n      </form>\n    </div>\n  );\n}\n\nfunction client() {\n  const path = window.location.pathname;\n  \n  if (path === '/admin') {\n    // Fetch admin data and render admin dashboard\n    fetch('/admin')\n      .then(response => response.json())\n      .then(data => {\n        createRoot(document.getElementById(\"root\")).render(\n          <AdminDashboard \n            stats={data.stats} \n            guests={data.guests}\n            cateringEstimates={data.cateringEstimates} \n          />\n        );\n      })\n      .catch(error => {\n        console.error('Error fetching admin data:', error);\n        createRoot(document.getElementById(\"root\")).render(\n          <div>Error loading admin dashboard</div>\n        );\n      });\n  } else {\n    createRoot(document.getElementById(\"root\")).render(<App />);\n  }\n}\n\nif (typeof document !== \"undefined\") { client(); }\n\n// Rest of the server-side code remains the same as in the previous version (unchanged)\nexport default async function server(request: Request): Promise<Response> {\n  const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n  const KEY = \"weddingInviteRSVPPage\";\n  const SCHEMA_VERSION = 4; // Increment for new schema\n\n  // Updated table to include food preference and admin password\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_guests_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      name TEXT NOT NULL,\n      email TEXT NOT NULL UNIQUE,\n      attending TEXT NOT NULL,\n      guests INTEGER,\n      food_preference TEXT,\n      dietary_restrictions TEXT,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_admin_${SCHEMA_VERSION} (\n      password TEXT\n    )\n  `);\n\n  const url = new URL(request.url);\n\n  // Set admin password endpoint\n  if (url.pathname === '/set-admin-password') {\n    const password = url.searchParams.get('password');\n    if (password) {\n      // Clear existing passwords and set new one\n      await sqlite.execute(`DELETE FROM ${KEY}_admin_${SCHEMA_VERSION}`);\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_admin_${SCHEMA_VERSION} (password) VALUES (?)\n      `, [password]);\n\n      return new Response(JSON.stringify({ success: true }), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n  }\n\n  // Admin dashboard with full guest details\n  if (url.pathname === '/admin') {\n    // Check if admin password is set\n    const adminCheck = await sqlite.execute(`\n      SELECT COUNT(*) as count FROM ${KEY}_admin_${SCHEMA_VERSION}\n    `);\n\n    if (adminCheck.rows[0].count === 0) {\n      return new Response(JSON.stringify({ \n        error: 'Admin password not set' \n      }), {\n        status: 401,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    // Fetch all guests\n    const guests = await sqlite.execute(`\n      SELECT * FROM ${KEY}_guests_${SCHEMA_VERSION}\n    `);\n\n    const attendingGuests = guests.rows.filter(g => g.attending === 'yes');\n    const notAttendingGuests = guests.rows.filter(g => g.attending === 'no');\n\n    const stats = {\n      totalInvited: guests.rows.length,\n      attending: attendingGuests.length,\n      notAttending: notAttendingGuests.length,\n      totalGuests: attendingGuests.reduce((sum, g) => sum + (g.guests || 1), 0)\n    };\n\n    // Catering estimation logic\n    const foodCounts = attendingGuests.reduce((acc, guest) => {\n      acc[guest.food_preference] = (acc[guest.food_preference] || 0) + (guest.guests || 1);\n      return acc;\n    }, {});\n\n    const cateringEstimates = {\n      mainDishes: stats.totalGuests,\n      vegetarianDishes: foodCounts['vegetarian'] || 0,\n      veganDishes: foodCounts['vegan'] || 0,\n      drinks: Math.ceil(stats.totalGuests * 2), // 2 drinks per person\n      alcoholServings: Math.ceil(stats.totalGuests * 1.5) // 1.5 alcoholic drinks per person\n    };\n\n    return new Response(JSON.stringify({ \n      stats, \n      guests: guests.rows,\n      cateringEstimates \n    }), {\n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Handle RSVP submission\n  if (request.method === 'POST' && url.pathname === '/rsvp') {\n    const body = await request.json();\n    try {\n      await sqlite.execute(`\n        INSERT OR REPLACE INTO ${KEY}_guests_${SCHEMA_VERSION} \n        (name, email, attending, guests, food_preference, dietary_restrictions) \n        VALUES (?, ?, ?, ?, ?, ?)\n      `, [\n        body.name, \n        body.email, \n        body.attending, \n        body.guests || 0, \n        body.foodPreference || 'meat',\n        body.dietaryRestrictions || ''\n      ]);\n\n      return new Response(JSON.stringify({ success: true }), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    } catch (error) {\n      return new Response(JSON.stringify({ error: error.message }), {\n        status: 500,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n  }\n\n  // Main page\n  return new Response(`\n    <html>\n      <head>\n        <title>Wedding RSVP</title>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <style>\n          body { \n            font-family: Arial, sans-serif; \n            max-width: 800px; \n            margin: 0 auto; \n            padding: 20px; \n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}","deleted","label",[98],"permalink","https://www.val.town/x/Miriamanna22/weddingInviteRSVPPage/code/main.tsx","extension","actionData","errors"]
</article></body></html>