Предложения заказов

\n \n

\n {proposals.map((proposal) => (\n

\n {proposal.title}\n \n {getProposalStatus(proposal)}\n \n

\n \n {formatRelativeTime(proposal.createdAt)}\n \n

Автор: {proposal.proposer}

\n {proposal.signatures.length}/{proposal.targetCount} подписей\n

\n {proposal.signatures.length}/{proposal.targetCount}\n

Подписи:

\n {proposal.signatures.length > 0 ? (\n

\n {sig.name}\n {formatRelativeTime(sig.date)}\n {signedProposals.has(proposal.id.toString()) && sig.name === signature && (\n \n )}\n

\n ) : (\n

Нет подписей

\n )}\n {getProposalStatus(proposal) === \"Активно\" && !signedProposals.has(proposal.id.toString()) && (\n

\n setSignature(e.target.value)}\n />\n

\n \n

\n )}\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 SCHEMA_VERSION = 2\n const KEY = \"neighborhoodOrderApp\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_proposals_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n proposer TEXT NOT NULL,\n signatures TEXT DEFAULT '[]',\n targetCount INTEGER NOT NULL,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n const url = new URL(request.url);\n \n if (url.pathname === '/proposals' && request.method === 'GET') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_proposals_${SCHEMA_VERSION}`);\n const proposals = result.rows.map(row => ({\n ...row,\n signatures: JSON.parse(row.signatures),\n }));\n return new Response(JSON.stringify(proposals), {\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n if (url.pathname === '/proposals' && request.method === 'POST') {\n const { title, proposer, targetCount } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_proposals_${SCHEMA_VERSION} (title, proposer, targetCount) VALUES (?, ?, ?)`,\n [title, proposer, targetCount]\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n if (url.pathname.startsWith('/proposals/') && url.pathname.endsWith('/sign') && request.method === 'POST') {\n const id = url.pathname.split('/')[2];\n const { name } = await request.json();\n const result = await sqlite.execute(\n `SELECT signatures, proposer FROM ${KEY}_proposals_${SCHEMA_VERSION} WHERE id = ?`,\n [id]\n );\n const { signatures, proposer } = result.rows[0];\n const signaturesList = JSON.parse(signatures);\n if (proposer !== name && !signaturesList.some(sig => sig.name === name)) {\n signaturesList.push({ name, date: new Date().toISOString() });\n await sqlite.execute(\n `UPDATE ${KEY}_proposals_${SCHEMA_VERSION} SET signatures = ? WHERE id = ?`,\n [JSON.stringify(signaturesList), id]\n );\n }\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n if (url.pathname.startsWith('/proposals/') && url.pathname.endsWith('/cancel') && request.method === 'POST') {\n const id = url.pathname.split('/')[2];\n const { name } = await request.json();\n const result = await sqlite.execute(\n `SELECT signatures FROM ${KEY}_proposals_${SCHEMA_VERSION} WHERE id = ?`,\n [id]\n );\n const { signatures } = result.rows[0];\n const signaturesList = JSON.parse(signatures);\n const updatedSignatures = signaturesList.filter(sig => sig.name !== name);\n await sqlite.execute(\n `UPDATE ${KEY}_proposals_${SCHEMA_VERSION} SET signatures = ? WHERE id = ?`,\n [JSON.stringify(updatedSignatures), id]\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n return new Response(`\n \n \n \n \n \n Предложения заказов\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}","deleted","label",[99],"permalink","https://www.val.town/x/zlpkhr/neighborhoodOrderApp/code/main.tsx","extension","actionData","errors"]