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

/** @jsxImportSource https://esm.sh/react */ import React, { useState, useEffect } from "https://esm.sh/react"; import { createRoot } from "https://esm.sh/react-dom/client"; import Cookies from "https://esm.sh/js-cookie"; function App() { const [proposals, setProposals] = useState([]); const [newProposal, setNewProposal] = useState({ title: '', proposer: '', targetCount: 10 }); const [signature, setSignature] = useState(''); const [signedProposals, setSignedProposals] = useState(new Set()); useEffect(() => { fetchProposals(); const signed = Cookies.get('signedProposals'); if (signed) { setSignedProposals(new Set(JSON.parse(signed))); } }, []); const fetchProposals = async () => { const response = await fetch('/proposals'); const data = await response.json(); setProposals(data); }; const handleSubmitProposal = async (e) => { e.preventDefault(); await fetch('/proposals', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify(newProposal), }); setNewProposal({ title: '', proposer: '', targetCount: 10 }); fetchProposals(); }; const handleSignProposal = async (id, proposer) => { if (signedProposals.has(id.toString())) { alert("Уже подписано!"); return; } if (proposer === signature) { alert("Нельзя подписать своё!"); return; } const response = await fetch(`/proposals/${id}/sign`, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ name: signature }), }); if (response.ok) { const newSignedProposals = new Set(signedProposals); newSignedProposals.add(id.toString()); setSignedProposals(newSignedProposals); Cookies.set('signedProposals', JSON.stringify(Array.from(newSignedProposals))); } setSignature(''); fetchProposals(); }; const handleCancelSignature = async (id, name) => { const response = await fetch(`/proposals/${id}/cancel`, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ name }), }); if (response.ok) { const newSignedProposals = new Set(signedProposals); newSignedProposals.delete(id.toString()); setSignedProposals(newSignedProposals); Cookies.set('signedProposals', JSON.stringify(Array.from(newSignedProposals))); fetchProposals(); } }; const getProposalStatus = (proposal) => { const now = new Date(); const creationDate = new Date(proposal.createdAt); const weekLater = new Date(creationDate.getTime() + 7 * 24 * 60 * 60 * 1000); if (now > weekLater) { return proposal.signatures.length >= proposal.targetCount ? "Собрано" : "Не собрано"; } else if (proposal.signatures.length >= proposal.targetCount) { return "Собрано"; } else { return "Активно"; } }; const getRemainingSignatures = (proposal) => { return Math.max(0, proposal.targetCount - proposal.signatures.length); }; const getProgressPercentage = (proposal) => { return Math.min(100, (proposal.signatures.length / proposal.targetCount) * 100); }; return (

{proposals.map((proposal) => (

{proposal.title}

Автор: {proposal.proposer}

Создано: {new Date(proposal.createdAt).toLocaleString('ru-RU', {day: 'numeric', month: 'short', year: 'numeric'})}

Цель: {proposal.targetCount} подписей

Статус: {getProposalStatus(proposal)}

Осталось подписей: {getRemainingSignatures(proposal)}

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

Подписи:

{proposal.signatures.length > 0 ? (

{sig.name} - {new Date(sig.date).toLocaleString('ru-RU', {day: 'numeric', month: 'short', year: 'numeric'})} {signedProposals.has(proposal.id.toString()) && sig.name === signature && ( )}

) : (

Нет подписей

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

setSignature(e.target.value)} />

)}

))}

); } function client() { createRoot(document.getElementById("root")).render(); } if (typeof document !== "undefined") { client(); } export default async function server(request: Request): Promise { const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); const SCHEMA_VERSION = 2 const KEY = new URL(import.meta.url).pathname.split("/").at(-1); await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_proposals_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, proposer TEXT NOT NULL, signatures TEXT DEFAULT '[]', targetCount INTEGER NOT NULL, createdAt DATETIME DEFAULT CURRENT_TIMESTAMP ) `); const url = new URL(request.url); if (url.pathname === '/proposals' && request.method === 'GET') { const result = await sqlite.execute(`SELECT * FROM ${KEY}_proposals_${SCHEMA_VERSION}`); const proposals = result.rows.map(row => ({ ...row, signatures: JSON.parse(row.signatures), })); return new Response(JSON.stringify(proposals), { headers: { 'Content-Type': 'application/json' }, }); } if (url.pathname === '/proposals' && request.method === 'POST') { const { title, proposer, targetCount } = await request.json(); await sqlite.execute( `INSERT INTO ${KEY}_proposals_${SCHEMA_VERSION} (title, proposer, targetCount) VALUES (?, ?, ?)`, [title, proposer, targetCount] ); return new Response(JSON.stringify({ success: true }), { headers: { 'Content-Type': 'application/json' }, }); } if (url.pathname.startsWith('/proposals/') && url.pathname.endsWith('/sign') && request.method === 'POST') { const id = url.pathname.split('/')[2]; const { name } = await request.json(); const result = await sqlite.execute( `SELECT signatures, proposer FROM ${KEY}_proposals_${SCHEMA_VERSION} WHERE id = ?`, [id] ); const { signatures, proposer } = result.rows[0]; const signaturesList = JSON.parse(signatures); if (proposer !== name && !signaturesList.some(sig => sig.name === name)) { signaturesList.push({ name, date: new Date().toISOString() }); await sqlite.execute( `UPDATE ${KEY}_proposals_${SCHEMA_VERSION} SET signatures = ? WHERE id = ?`, [JSON.stringify(signaturesList), id] ); } return new Response(JSON.stringify({ success: true }), { headers: { 'Content-Type': 'application/json' }, }); } if (url.pathname.startsWith('/proposals/') && url.pathname.endsWith('/cancel') && request.method === 'POST') { const id = url.pathname.split('/')[2]; const { name } = await request.json(); const result = await sqlite.execute( `SELECT signatures FROM ${KEY}_proposals_${SCHEMA_VERSION} WHERE id = ?`, [id] ); const { signatures } = result.rows[0]; const signaturesList = JSON.parse(signatures); const updatedSignatures = signaturesList.filter(sig => sig.name !== name); await sqlite.execute( `UPDATE ${KEY}_proposals_${SCHEMA_VERSION} SET signatures = ? WHERE id = ?`, [JSON.stringify(updatedSignatures), id] ); return new Response(JSON.stringify({ success: true }), { headers: { 'Content-Type': 'application/json' }, }); } return new Response(` Предложения заказов

`, { headers: { "content-type": "text/html", }, }); }

neighborhoodOrderApp