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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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`;","createdAt",["D",1731496526370],"version",9,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","jesi_rgb","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybDNINGM4S2pwNWZNWHJuN3lmWXhHUW4wVFIifQ","forkedVal","interval","slug","jesi_rgb/secretsanta","description","@jsxImportSource https://esm.sh/react","versions",[141,144,148,152,156,160,164,168,171,174],{"_117":118,"_142":-5,"_115":143,"_112":110},"prId",["D",1731496526370],{"_117":145,"_142":-5,"_115":146,"_112":147},8,["D",1731496213182],"daad6732-a1af-11ef-8b05-e6cdfca9ef9f",{"_117":149,"_142":-5,"_115":150,"_112":151},7,["D",1731495572594],"5cdb4adc-a1ae-11ef-8e17-e6cdfca9ef9f",{"_117":153,"_142":-5,"_115":154,"_112":155},6,["D",1731495552053],"509d1430-a1ae-11ef-8e17-e6cdfca9ef9f",{"_117":157,"_142":-5,"_115":158,"_112":159},5,["D",1731495358459],"dd38cc00-a1ad-11ef-81fa-e6cdfca9ef9f",{"_117":161,"_142":-5,"_115":162,"_112":163},4,["D",1731494670060],"42e73840-a1ac-11ef-bf59-e6cdfca9ef9f",{"_117":165,"_142":-5,"_115":166,"_112":167},3,["D",1731494502695],"df25c8da-a1ab-11ef-988f-e6cdfca9ef9f",{"_117":90,"_142":-5,"_115":169,"_112":170},["D",1731494451643],"c0b74b08-a1ab-11ef-9f95-e6cdfca9ef9f",{"_117":124,"_142":-5,"_115":172,"_112":173},["D",1731494395645],"9f56ce8e-a1ab-11ef-9668-e6cdfca9ef9f",{"_117":31,"_142":-5,"_115":175,"_112":176},["D",1731494321095],"72ea8336-a1ab-11ef-8513-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.pulls._index",{"_95":96,"_94":184,"_129":130,"_137":138,"_98":99,"_208":31,"_209":31,"_50":51,"_210":211},{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":185,"_117":118,"_119":26,"_120":31,"_121":31,"_122":31,"_123":124,"_125":31,"_126":31,"_127":-5,"_20":186,"_133":-5,"_134":-7,"_135":136,"_137":138,"_139":187},["D",1731496526370],{"_129":130,"_131":132},[188,190,192,194,196,198,200,202,204,206],{"_117":118,"_142":-5,"_115":189,"_112":110},["D",1731496526370],{"_117":145,"_142":-5,"_115":191,"_112":147},["D",1731496213182],{"_117":149,"_142":-5,"_115":193,"_112":151},["D",1731495572594],{"_117":153,"_142":-5,"_115":195,"_112":155},["D",1731495552053],{"_117":157,"_142":-5,"_115":197,"_112":159},["D",1731495358459],{"_117":161,"_142":-5,"_115":199,"_112":163},["D",1731494670060],{"_117":165,"_142":-5,"_115":201,"_112":167},["D",1731494502695],{"_117":90,"_142":-5,"_115":203,"_112":170},["D",1731494451643],{"_117":124,"_142":-5,"_115":205,"_112":173},["D",1731494395645],{"_117":31,"_142":-5,"_115":207,"_112":176},["D",1731494321095],"page","count","prs",[],"routes/_app","actionData","errors"]