MatchAid

\n \n\n

Submit a request

\n\n

Open requests

\n \n\n

Loading…

\n\n

\n \n \n \n

\n\n \n\n \n

,\n );\n});\n\n// --- API: list requests with filters/pagination ---\napp.get(\"/api/requests\", async (c) => {\n const u = new URL(c.req.url);\n\n // pagination\n const page = Math.max(1, parseInt(u.searchParams.get(\"page\") || \"1\"));\n const limit = Math.min(\n 50,\n Math.max(5, parseInt(u.searchParams.get(\"limit\") || \"10\")),\n );\n const offset = (page - 1) * limit;\n\n // sort\n const sortParam = u.searchParams.get(\"sort\") === \"amount\"\n ? \"amount\"\n : \"recent\";\n const sortSql = sortParam === \"amount\"\n ? \"amount DESC, createdAt DESC\"\n : \"createdAt DESC\";\n\n // filters\n const q = (u.searchParams.get(\"q\") || \"\").trim();\n const min = parseInt(u.searchParams.get(\"min\") || \"\");\n const max = parseInt(u.searchParams.get(\"max\") || \"\");\n const status = u.searchParams.get(\"status\") || \"\";\n const flags = u.searchParams.get(\"flags\") || \"\";\n\n const parts: string[] = [];\n const args: any[] = [];\n if (q) {\n parts.push(\"note LIKE ?\");\n args.push(`%${q.replace(/[%_]/g, \"\\\\$&\")}%`);\n }\n if (Number.isFinite(min) && min > 0) {\n parts.push(\"amount >= ?\");\n args.push(min);\n }\n if (Number.isFinite(max) && max > 0) {\n parts.push(\"amount <= ?\");\n args.push(max);\n }\n if (status === \"open\") parts.push(\"fulfilled = 0\");\n if (status === \"fulfilled\") parts.push(\"fulfilled = 1\");\n if (flags === \"hide\") parts.push(\"flagged = 0\");\n if (flags === \"only\") parts.push(\"flagged = 1\");\n\n const where = parts.length ? `WHERE ${parts.join(\" AND \")}` : \"\";\n\n const totalRes = await sqlite.execute({\n sql: `SELECT COUNT(*) AS c FROM requests ${where}`,\n args,\n });\n const total = Number(totalRes.rows[0]?.[0] ?? 0);\n\n const listRes = await sqlite.execute({\n sql: `SELECT id, name, cashtag, amount, note, createdAt, flagged, fulfilled\n FROM requests\n ${where}\n ORDER BY ${sortSql}\n LIMIT ? OFFSET ?`,\n args: [...args, limit, offset],\n });\n\n const items = listRes.rows.map((r) => ({\n id: String(r[0]),\n name: String(r[1]),\n cashtag: String(r[2]),\n amount: Number(r[3]),\n note: r[4] ? String(r[4]) : \"\",\n createdAt: String(r[5]),\n flagged: Boolean(r[6]),\n fulfilled: Boolean(r[7]),\n }));\n\n return c.json({ total, page, pageSize: limit, items });\n});\n\n// --- actions: add, flag, fulfill ---\napp.post(\"/add\", async (c) => {\n const body = await c.req.parseBody();\n const name = sanitizeText(String(body.name || \"\"), 64);\n const cashtag = sanitizeCashtag(String(body.cashtag || \"\"));\n const amount = parseAmount(String(body.amount || \"\"));\n const note = sanitizeText(String(body.note || \"\"), 240);\n\n const errors: string[] = [];\n if (!name) errors.push(\"Name required.\");\n if (!cashtag) errors.push(\"Valid CashTag required.\");\n if (amount <= 0 || amount > 1000) errors.push(\"Amount must be 1–1000 USD.\");\n if (errors.length) return c.json({ error: errors.join(\" \") }, 400);\n\n const res = await sqlite.execute({\n sql:\n `INSERT INTO requests (id, name, cashtag, amount, note, createdAt, flagged, fulfilled)\n VALUES (?, ?, ?, ?, ?, ?, 0, 0)`,\n args: [\n crypto.randomUUID(),\n name,\n cashtag,\n amount,\n note,\n new Date().toISOString(),\n ],\n });\n\n if (res.rowsAffected < 1) return c.json({ error: \"Failed to save.\" }, 500);\n return c.json({ ok: \"Request added.\" }, 201);\n});\n\napp.post(\"/flag\", async (c) => {\n const body = await c.req.parseBody();\n const id = sanitizeId(String(body.id || \"\"));\n const action = String(body.action || \"flag\").toLowerCase();\n if (!id) return c.json({ error: \"Invalid ID.\" }, 400);\n const val = action === \"unflag\" ? 0 : 1;\n const res = await sqlite.execute({\n sql: \"UPDATE requests SET flagged = ? WHERE id = ?\",\n args: [val, id],\n });\n if (res.rowsAffected < 1) return c.json({ error: \"No change.\" }, 400);\n return c.json({ ok: val ? \"Request flagged.\" : \"Flag removed.\" });\n});\n\napp.post(\"/fulfill\", async (c) => {\n const body = await c.req.parseBody();\n const id = sanitizeId(String(body.id || \"\"));\n const action = String(body.action || \"fulfill\").toLowerCase();\n if (!id) return c.json({ error: \"Invalid ID.\" }, 400);\n const val = action === \"unfulfill\" ? 0 : 1;\n const res = await sqlite.execute({\n sql: \"UPDATE requests SET fulfilled = ? WHERE id = ?\",\n args: [val, id],\n });\n if (res.rowsAffected < 1) return c.json({ error: \"No change.\" }, 400);\n return c.json({ ok: val ? \"Marked fulfilled.\" : \"Marked unfulfilled.\" });\n});\n\nexport default app.fetch;\n\n// --- utils (server) ---\nfunction sanitizeText(s: string, max: number) {\n return s.trim().slice(0, max);\n}\nfunction sanitizeCashtag(tag: string) {\n const cleaned = tag.replace(/^\\$/, \"\").trim().toLowerCase();\n return cleaned.match(/^[a-z0-9_]{1,32}$/)?.[0] || \"\";\n}\nfunction parseAmount(s: string) {\n const n = Number(String(s).replace(/[^0-9.]/g, \"\"));\n return isFinite(n) ? Math.round(n) : 0;\n}\nfunction sanitizeId(s: string) {\n return s.trim().match(/^[a-f0-9-]{10,}$/i)?.[0] || \"\";\n}\n\n// --- client script ---\nconst clientJs = `\nconst flashBox = document.getElementById('flash');\nconst addForm = document.getElementById('addForm');\nconst filtersForm = document.getElementById('filters');\nconst reqList = document.getElementById('reqList');\nconst listState = document.getElementById('listState');\nconst prevBtn = document.getElementById('prevBtn');\nconst nextBtn = document.getElementById('nextBtn');\nconst pageInfo = document.getElementById('pageInfo');\n\nlet page = 1, limit = 10, sort = 'recent', q = '', min = '', max = '', status = '', flags = '';\n\nfunction setFlash(kind, msg){\n flashBox.innerHTML = msg ? '

' + escapeHtml(msg) + '

' : '';\n}\n\nfunction buildUrl(){\n const p = new URLSearchParams({ page:String(page), limit:String(limit), sort });\n if(q) p.set('q', q); if(min) p.set('min', min); if(max) p.set('max', max);\n if(status) p.set('status', status); if(flags) p.set('flags', flags);\n return '/api/requests?' + p.toString();\n}\n\nasync function loadList(){\n listState.textContent='Loading…'; reqList.innerHTML='';\n try{\n const res = await fetch(buildUrl(), { headers:{ accept:'application/json' } });\n const data = await res.json();\n const { items, total, page: p, pageSize } = data;\n const totalPages = Math.max(1, Math.ceil(total / pageSize));\n pageInfo.textContent = 'Page ' + p + ' of ' + totalPages + ' • ' + total + ' total';\n prevBtn.disabled = p <= 1; nextBtn.disabled = p >= totalPages;\n if(!items.length){ listState.textContent='No requests match these filters.'; return; }\n listState.textContent='';\n reqList.innerHTML = items.map(itemToHtml).join('');\n hookItemActions();\n }catch(e){\n listState.textContent='Failed to load.';\n }\n}\n\nfunction hookItemActions(){\n reqList.querySelectorAll('.copyBtn').forEach(btn => {\n btn.addEventListener('click', () => copyTag(btn.getAttribute('data-tag')||''));\n });\n reqList.querySelectorAll('form[action=\"/flag\"]').forEach(form => {\n form.addEventListener('submit', async (e)=>{ e.preventDefault(); await postForm(form); await loadList(); });\n });\n reqList.querySelectorAll('form[action=\"/fulfill\"]').forEach(form => {\n form.addEventListener('submit', async (e)=>{ e.preventDefault(); await postForm(form); await loadList(); });\n });\n}\n\nfunction itemToHtml(r){\n const cashUrl = buildCashUrl(r.cashtag, r.amount, r.note);\n const webUrl = 'https://cash.app/$' + encodeURIComponent(r.cashtag);\n const badges = (r.flagged ? 'Flagged' : '')\n + (r.fulfilled ? ' Fulfilled' : '');\n return \\`\n

\\${escapeHtml(r.name)}

\\${timeAgo(r.createdAt)} • $\\${escapeHtml(r.cashtag)}

\n $\\${fmt(r.amount)}
\\${badges}\n

\n \\${r.note ? '

' + escapeHtml(r.note) + '

' : ''}\n

\n Donate via Cash App\n View profile\n \n \n \n

\\`;\n}\n\nfunction copyTag(tag){\n const text = '$' + tag;\n if(navigator.clipboard){ navigator.clipboard.writeText(text).then(()=>setFlash('ok','Copied: '+text)); }\n else { prompt('Copy cashtag:', text); }\n}\n\naddForm.addEventListener('submit', async (e)=>{\n e.preventDefault(); setFlash('', '');\n const body = new URLSearchParams(new FormData(addForm) as any);\n const res = await fetch('/add', { method:'POST', headers:{ 'content-type':'application/x-www-form-urlencoded' }, body });\n const data = await res.json().catch(()=>({}));\n if(res.ok){ setFlash('ok', data.ok || 'Request added.'); addForm.reset(); await loadList(); }\n else { setFlash('error', data.error || 'Failed to add.'); }\n});\n\nfiltersForm.addEventListener('submit', async (e)=>{\n e.preventDefault();\n const fd = new FormData(filtersForm);\n q = (fd.get('q')||'').toString().trim();\n min = (fd.get('min')||'').toString();\n max = (fd.get('max')||'').toString();\n sort = (fd.get('sort')||'recent').toString();\n status = (fd.get('status')||'').toString();\n flags = (fd.get('flags')||'').toString();\n page = 1;\n await loadList();\n});\n\nprevBtn.addEventListener('click', async ()=>{ if(page>1){ page--; await loadList(); }});\nnextBtn.addEventListener('click', async ()=>{ page++; await loadList(); });\n\nasync function postForm(form){\n const fd = new FormData(form);\n const body = new URLSearchParams(fd as any);\n const res = await fetch(form.getAttribute('action'), { method:'POST', headers:{ 'content-type':'application/x-www-form-urlencoded' }, body });\n const data = await res.json().catch(()=>({}));\n if(res.ok) setFlash('ok', data.ok || 'Updated.'); else setFlash('error', data.error || 'Update failed.');\n}\n\nfunction escapeHtml(s){ return String(s).replace(/&/g,'&').replace(//g,'>'); }\nfunction escapeAttr(s){ return String(s).replace(/\"/g,'"').replace(//g,'>'); }\nfunction fmt(n){ return new Intl.NumberFormat('en-US',{ maximumFractionDigits:0 }).format(Number(n)||0); }\nfunction timeAgo(iso){ const t=new Date(iso).getTime(), now=Date.now(), s=Math.max(1,Math.floor((now-t)/1000)); const u=[['day',86400],['hour',3600],['min',60],['sec',1]]; for(const [l,z] of u){ if(s>=z){ const v=Math.floor(s/z); return v+' '+l+(v>1?'s':'')+' ago'; } } return 'just now'; }\nfunction buildCashUrl(tag, amount, note){ const base='https://cash.app/$'+encodeURIComponent(tag); const q=new URLSearchParams(); if(Number(amount)>0) q.set('amount', String(amount)); if(note) q.set('note', String(note).slice(0,140)); const qs=q.toString(); return qs? base+'?'+qs : base; }\n\nloadList();\n`;\n\n// --- styles ---\nconst styles = `\n:root { --bg:#0b0f14; --card:#131922; --text:#e6edf3; --muted:#9aa7b0; --accent:#2bbf74; --danger:#ff5c5c; --border:#223042; }\n* { box-sizing:border-box; }\nbody { margin:0; font-family: ui-sans-serif, system-ui, -apple-system, Segoe UI, Roboto, Helvetica, Arial; background: var(--bg); color: var(--text); }\n.container { max-width:980px; margin:0 auto; padding:20px; display:grid; gap:16px; grid-template-columns: 1fr; }\n.header { display:block; }\n.sub { color: var(--muted); }\n.card { background: var(--card); border: 1px solid var(--border); border-radius: 12px; padding: 16px; }\nlabel { display:block; font-weight:600; margin:12px 0 6px; }\ninput, textarea, select { width:100%; padding:10px 12px; background:#0f141b; color:var(--text); border:1px solid var(--border); border-radius:8px; outline:none; }\ntextarea { min-height:80px; resize:vertical; }\n.row { display:flex; gap:10px; }\n.col { flex:1; }\n.actions { margin-top:12px; display:flex; gap:8px; align-items:center; }\n.btn { display:inline-flex; align-items:center; gap:8px; font-weight:700; padding:10px 14px; border-radius:8px; border:1px solid var(--border); cursor:pointer; text-decoration:none; }\n.btn.primary { background: var(--accent); color:#06210f; border-color:#1a8e56; }\n.btn.outline { background: transparent; color: var(--text); }\n.btn.danger { background: var(--danger); color:#1a0a0a; border-color:#c94848; }\n.small { font-size:12px; }\n.muted { color: var(--muted); }\n.flash { padding: 10px 12px; border-radius:8px; margin-bottom: 10px; font-weight:600; }\n.flash.ok { background:#10281b; border:1px solid #1a8e56; color:#9ef3c8; }\n.flash.error { background:#2a1414; border:1px solid #c94848; color:#ffb3b3; }\n.controls { display:flex; flex-wrap:wrap; gap:10px; margin-bottom:10px; align-items:flex-end; }\n.controls .control { min-width:160px; }\nul.req { list-style:none; padding:0; margin:0; display:flex; flex-direction:column; gap:12px; }\nli.item { border:1px solid var(--border); border-radius:12px; padding:12px; background:#0f141b; }\n.itemHead { display:flex; justify-content:space-between; align-items:center; gap:10px; }\n.name { font-weight:700; }\n.badges { display:flex; gap:8px; align-items:center; flex-wrap:wrap; }\n.badge { font-size:12px; padding:2px 6px; border-radius:6px; border:1px solid var(--border); color: var(--muted); }\n.badge.flagged { border-color:#c94848; color:#ffb3b3; }\n.badge.fulfilled { border-color:#2bbf74; color:#9ef3c8; }\n.cta { margin-top:10px; display:flex; gap:10px; align-items:center; flex-wrap:wrap; }\n.pagination { display:flex; gap:8px; margin-top:12px; align-items:center; }\n.note { color: var(--muted); }\n.footer { margin-top:8px; }\n`;","deleted","label","borrow",[99],"permalink","https://www.val.town/x/ziggyware/Borrowy/code/main.ts","extension","actionData","errors"]