Secret Santa

Create a new Secret Santa group

\n setNewParticipant(e.target.value)}\n placeholder=\"Enter participant name\"\n className=\"input\"\n />\n \n \n

\n {p} \n

Exclusions

\n \n

\n {p1} cannot be matched with {p2}\n \n

\n \n

\n );\n }\n\n if (page === \"share\") {\n return (\n

Share this link with your friends

\n Group ID: {groupId}\n

\n Link: {window.location.origin}?id={groupId}\n

\n );\n }\n\n if (page === \"participate\") {\n return (\n

Secret Santa Participation

\n Group ID: {groupId}\n

\n {!selectedParticipant ? (\n <>\n \n \n ) : (\n

Your name: {selectedParticipant}

\n )}\n {match && (\n

Your Secret Santa Match

{match}

\n )}\n

\n );\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 url = new URL(request.url);\n const SCHEMA_VERSION = 3;\n const KEY = \"secretsanta\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_groups_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n participants TEXT NOT NULL,\n exclusions TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_matches_${SCHEMA_VERSION} (\n group_id TEXT NOT NULL,\n giver TEXT NOT NULL,\n receiver TEXT NOT NULL,\n PRIMARY KEY (group_id, giver)\n )\n `);\n\n if (url.pathname === \"/create-group\") {\n if (request.method === \"POST\") {\n const formData = await request.formData();\n const participants = JSON.parse(formData.get(\"participants\"));\n const exclusions = JSON.parse(formData.get(\"exclusions\"));\n const id = Math.random().toString(36).substr(2, 9);\n await sqlite.execute(\n `INSERT INTO ${KEY}_groups_${SCHEMA_VERSION} (id, participants, exclusions) VALUES (?, ?, ?)`,\n [id, JSON.stringify(participants), JSON.stringify(exclusions)],\n );\n return new Response(JSON.stringify({ id }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n }\n\n if (url.pathname === \"/participants\") {\n const id = url.searchParams.get(\"id\");\n const result = await sqlite.execute(\n `SELECT participants FROM ${KEY}_groups_${SCHEMA_VERSION} WHERE id = ?`,\n [id],\n );\n if (result.rows.length > 0) {\n const participants = JSON.parse(result.rows[0].participants);\n return new Response(JSON.stringify(participants), { headers: { \"Content-Type\": \"application/json\" } });\n }\n }\n\n if (url.pathname === \"/get-match\") {\n const id = url.searchParams.get(\"id\");\n const participant = url.searchParams.get(\"participant\");\n\n // Check if a match already exists\n const existingMatch = await sqlite.execute(\n `SELECT receiver FROM ${KEY}_matches_${SCHEMA_VERSION} WHERE group_id = ? AND giver = ?`,\n [id, participant],\n );\n\n if (existingMatch.rows.length > 0) {\n return new Response(JSON.stringify({ match: existingMatch.rows[0].receiver }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // If no match exists, create a new one\n const groupData = await sqlite.execute(\n `SELECT participants, exclusions FROM ${KEY}_groups_${SCHEMA_VERSION} WHERE id = ?`,\n [id],\n );\n\n if (groupData.rows.length > 0) {\n const participants = JSON.parse(groupData.rows[0].participants);\n const exclusions = JSON.parse(groupData.rows[0].exclusions);\n const takenMatches = (await sqlite.execute(\n `SELECT receiver FROM ${KEY}_matches_${SCHEMA_VERSION} WHERE group_id = ?`,\n [id],\n )).rows.map(row => row.receiver);\n\n const availableMatches = participants.filter(p =>\n p !== participant\n && !takenMatches.includes(p)\n && !exclusions.some(([p1, p2]) => (p1 === participant && p2 === p) || (p2 === participant && p1 === p))\n );\n\n if (availableMatches.length > 0) {\n const match = availableMatches[Math.floor(Math.random() * availableMatches.length)];\n await sqlite.execute(\n `INSERT INTO ${KEY}_matches_${SCHEMA_VERSION} (group_id, giver, receiver) VALUES (?, ?, ?)`,\n [id, participant, match],\n );\n return new Response(JSON.stringify({ match }), { headers: { \"Content-Type\": \"application/json\" } });\n } else {\n return new Response(JSON.stringify({ error: \"No available matches\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n }\n\n return new Response(\n `\n \n \n Secret Santa App\n \n \n \n \n \n

\n \n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n}\n\nconst css = `\n:root {\n --primary-color: #e63946;\n --secondary-color: #457b9d;\n --background-color: #f1faee;\n --text-color: #1d3557;\n --card-background: #ffffff;\n}\n\nbody {\n font-family: 'Nunito', sans-serif;\n background-color: var(--background-color);\n color: var(--text-color);\n line-height: 1.6;\n margin: 0;\n padding: 0;\n}\n\n.container {\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\n\nh1, h2, h3 {\n font-family: 'DM Serif Display', cursive;\n color: var(--primary-color);\n}\n\nh1 {\n font-size: 3.5rem;\n text-align: center;\n margin-bottom: 2rem;\n text-shadow: 2px 2px 4px rgba(0,0,0,0.1);\n}\n\nh2 {\n font-size: 2.5rem;\n}\n\nh3 {\n font-size: 2rem;\n}\n\n.card {\n background-color: var(--card-background);\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n padding: 2rem;\n margin-bottom: 2rem;\n}\n\n.form-group {\n margin-bottom: 1rem;\n}\n\n.input, .select {\n width: 100%;\n padding: 0.5rem;\n margin-bottom: 1rem;\n border: 1px solid #ccc;\n border-radius: 4px;\n font-size: 1rem;\n font-family: 'Nunito', sans-serif;\n}\n\n.btn {\n display: inline-block;\n padding: 0.5rem 1rem;\n border: none;\n border-radius: 4px;\n font-size: 1rem;\n font-family: 'Nunito', sans-serif;\n font-weight: 700;\n cursor: pointer;\n transition: all 0.3s ease;\n}\n\n.btn-primary {\n background-color: var(--primary-color);\n color: white;\n}\n\n.btn-secondary {\n background-color: var(--secondary-color);\n color: white;\n}\n\n.btn-danger {\n background-color: #e76f51;\n color: white;\n}\n\n.btn-small {\n font-size: 0.8rem;\n padding: 0.3rem 0.6rem;\n}\n\n.btn-large {\n font-size: 1.2rem;\n padding: 0.7rem 1.4rem;\n}\n\n.btn:hover {\n opacity: 0.9;\n transform: translateY(-2px);\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n}\n\n.btn:disabled {\n background-color: #ccc;\n cursor: not-allowed;\n}\n\n.list {\n list-style-type: none;\n padding: 0;\n}\n\n.list-item {\n background-color: #f8f9fa;\n border: 1px solid #e9ecef;\n border-radius: 4px;\n padding: 0.5rem 1rem;\n margin-bottom: 0.5rem;\n display: flex;\n justify-content: space-between;\n align-items: center;\n}\n\n.match-result {\n text-align: center;\n margin-top: 2rem;\n padding: 1rem;\n background-color: #e9ecef;\n border-radius: 4px;\n}\n\n.match-name {\n font-size: 2rem;\n font-weight: bold;\n color: var(--primary-color);\n}\n\n.participant-name {\n font-size: 1.2rem;\n margin-bottom: 1rem;\n}\n\n.footer-link {\n text-align: center;\n margin-top: 2rem;\n font-family: 'Nunito', sans-serif;\n}\n\n.footer-link a {\n color: var(--secondary-color);\n text-decoration: none;\n}\n\n.footer-link a:hover {\n text-decoration: underline;\n}\n\n@media (max-width: 600px) {\n .container {\n padding: 10px;\n }\n \n .card {\n padding: 1rem;\n }\n \n h1 {\n font-size: 2.5rem;\n }\n\n h2 {\n font-size: 2rem;\n }\n\n h3 {\n font-size: 1.5rem;\n }\n}\n`;","deleted","label","children",[],[152],"files",[150],"counts",{"_173":31,"_174":175,"_176":31,"_177":31},"pulls","branches",1,"forks","envVars","contents",[180],{"_107":151,"_100":152,"_153":120,"_154":-5,"_155":140,"_156":139,"_157":113,"_109":181,"_104":159,"_160":161,"_162":163,"_164":27,"_165":-5,"_103":182},["D",1731496526370],[152],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name._index",{"_98":99,"_100":101,"_102":-7,"_104":-7,"_105":190,"_178":194,"_197":-7,"_198":-5,"_199":-5,"_169":200,"_204":205},{"_107":108,"_100":101,"_109":191,"_111":-5,"_112":113,"_114":115,"_116":-5,"_117":-5,"_12":118,"_119":120,"_121":113,"_122":-5,"_123":31,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_133":27,"_21":192,"_137":193},["D",1746205994530],{"_98":99,"_135":136},{"_104":139,"_100":42,"_107":140,"_141":108,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":101,"_147":99},[195],{"_107":151,"_100":152,"_153":120,"_154":-5,"_155":140,"_156":139,"_157":113,"_109":181,"_104":159,"_160":161,"_162":163,"_164":27,"_165":-5,"_103":196},[152],"readme","upstream","pull",[201],{"_107":151,"_100":152,"_153":120,"_154":-5,"_155":140,"_156":139,"_157":113,"_109":158,"_104":159,"_160":161,"_162":163,"_164":27,"_165":-5,"_166":202,"_103":203},[],[152],"previews",[201],"routes/_app","actionData","errors"]