\n {codeNames.map((name, index) => (\n

\n {name}\n

\n ))}\n

\n );\n}\n\nfunction App() {\n const [nickname, setNickname] = useState('');\n const [dates] = useState(generateNextFifteenDays());\n const [selectedDates, setSelectedDates] = useState([]);\n\n const handleDateToggle = (date: string) => {\n setSelectedDates(prev => \n prev.includes(date) \n ? prev.filter(d => d !== date)\n : [...prev, date]\n );\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!nickname || selectedDates.length === 0) {\n alert('🕵️ Lütfen takma ad ve tarih seçin');\n return;\n }\n\n const response = await fetch('/submit-vote', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ nickname, dates: selectedDates })\n });\n\n if (response.ok) {\n window.location.href = '/results';\n }\n };\n\n const handleViewResults = () => {\n window.location.href = '/results';\n };\n\n return (\n

\n \n

\n 🕵️‍♀️\n Codenames Gizli Görev Takvimi\n 🎲\n

\n setNickname(e.target.value)}\n style={{ \n width: '100%', \n padding: '10px', \n marginBottom: '15px',\n backgroundColor: gameStyles.boardBackground,\n color: gameStyles.textColor,\n border: `2px solid ${gameStyles.borderColor}`,\n borderRadius: '5px',\n fontStyle: 'italic'\n }}\n />\n

\n {dates.map(date => (\n

handleDateToggle(date.displayDate)}\n >\n

\n {date.dayName}\n

\n {date.displayDate}\n

\n {selectedDates.includes(date.displayDate) && (\n

\n )}\n

\n ))}\n

\n \n \n

\n \n

\n );\n}\n\nfunction ResultsPage() {\n const [votes, setVotes] = useState([]);\n const [loading, setLoading] = useState(true);\n const [dateFrequency, setDateFrequency] = useState<{[key: string]: number}>({});\n\n useEffect(() => {\n async function fetchVotes() {\n const response = await fetch('/get-votes');\n const data = await response.json();\n setVotes(data);\n \n const frequency = data.reduce((acc, vote) => {\n vote.dates.split(', ').forEach(date => {\n acc[date] = (acc[date] || 0) + 1;\n });\n return acc;\n }, {});\n \n setDateFrequency(frequency);\n setLoading(false);\n }\n fetchVotes();\n }, []);\n\n const handleDeleteVote = async (id: number) => {\n const response = await fetch('/delete-vote', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ id })\n });\n\n if (response.ok) {\n setVotes(prev => prev.filter(vote => vote.id !== id));\n }\n };\n\n const handleBackToVote = () => {\n window.location.href = '/';\n };\n\n if (loading) return

🕵️ Yükleniyor...

;\n\n return (\n

\n \n

\n 🔍\n Codenames Gizli Görev Sonuçları\n 📋\n

\n \n

\n 🎯 Tarih Popülerliği\n

\n {Object.entries(dateFrequency)\n .sort((a, b) => b[1] - a[1])\n .map(([date, count]) => (\n

0 ? gameStyles.boardBackground : 'transparent',\n borderRadius: '5px',\n margin: '5px 0'\n }}\n >\n 📅 {date}\n 🏆 {count} oy\n

\n ))}\n

\n\n

\n 🕵️ Bireysel Oylar\n

\n {votes.map(vote => (\n

🕴️ {vote.nickname}

\n 📆 {vote.dates}\n

\n \n

\n ))}\n

\n\n \n

\n );\n}\n\nfunction client() {\n const root = document.getElementById(\"root\");\n const path = window.location.pathname;\n\n if (path === '/results') {\n createRoot(root).render();\n } else {\n createRoot(root).render();\n }\n}\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 KEY = \"safeBlushRabbit\";\n const SCHEMA_VERSION = 10;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_votes_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nickname TEXT NOT NULL,\n dates TEXT NOT NULL\n )\n `);\n\n const url = new URL(request.url);\n \n if (request.method === 'POST' && url.pathname === '/submit-vote') {\n const { nickname, dates } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_votes_${SCHEMA_VERSION} (nickname, dates) VALUES (?, ?)`, \n [nickname, dates.join(', ')]\n );\n return new Response(null, { status: 302, headers: { Location: \"/results\" }});\n }\n\n if (request.method === 'GET' && url.pathname === '/get-votes') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_votes_${SCHEMA_VERSION}`);\n return Response.json(result.rows);\n }\n\n if (request.method === 'POST' && url.pathname === '/delete-vote') {\n const { id } = await request.json();\n await sqlite.execute(\n `DELETE FROM ${KEY}_votes_${SCHEMA_VERSION} WHERE id = ?`, \n [id]\n );\n return new Response('Silindi', { status: 200 });\n }\n\n return new Response(`\n \n \n Codenames Gizli Görev Tercihi\n \n \n \n \n

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