SOP Form Submitted

Form: ${formName}

By: ${userName}

Time: ${new Date().toISOString()}

${JSON.stringify(data, null, 2)}

`,\n });\n } catch (e) {\n console.error(\"Email failed:\", e);\n }\n return c.json({ ok: true });\n});\n\napp.get(\"/api/submissions\", async (c) => {\n const result = await sqlite.execute(\n `SELECT * FROM submissions ORDER BY submitted_at DESC`\n );\n const submissions = result.rows.map(r => ({\n id: r[0] ?? r.id,\n userName: r[1] ?? r.user_name,\n formName: r[2] ?? r.form_name,\n data: JSON.parse((r[3] ?? r.data) as string),\n submittedAt: r[4] ?? r.submitted_at\n }));\n return c.json({ submissions });\n});\n\napp.get(\"/api/drafts\", async (c) => {\n const result = await sqlite.execute(\n `SELECT user_name, form_name, updated_at FROM drafts ORDER BY updated_at DESC`\n );\n const drafts = result.rows.map(r => ({\n userName: r[0] ?? r.user_name,\n formName: r[1] ?? r.form_name,\n updatedAt: r[2] ?? r.updated_at\n }));\n return c.json({ drafts });\n});\n\napp.get(\"/api/status/:userName\", async (c) => {\n const userName = c.req.param(\"userName\");\n const [subs, drfs] = await Promise.all([\n sqlite.execute({ sql: `SELECT form_name, submitted_at FROM submissions WHERE user_name = ? ORDER BY submitted_at DESC`, args: [userName] }),\n sqlite.execute({ sql: `SELECT form_name, updated_at FROM drafts WHERE user_name = ? ORDER BY updated_at DESC`, args: [userName] }),\n ]);\n return c.json({\n submissions: subs.rows.map(r => ({ formName: r[0] ?? r.form_name, submittedAt: r[1] ?? r.submitted_at })),\n drafts: drfs.rows.map(r => ({ formName: r[0] ?? r.form_name, updatedAt: r[1] ?? r.updated_at })),\n });\n});\n\n// === FILE UPLOADS (Val.town Blob storage) ===\napp.post(\"/api/upload\", async (c) => {\n const formData = await c.req.formData();\n const file = formData.get(\"file\") as File | null;\n const userName = formData.get(\"userName\") as string || \"anonymous\";\n const formName = formData.get(\"formName\") as string || \"unknown\";\n if (!file) return c.json({ error: \"No file provided\" }, 400);\n\n const timestamp = Date.now();\n const safeName = file.name.replace(/[^a-zA-Z0-9._-]/g, \"_\");\n const key = `sop/${formName}/${userName}/${timestamp}-${safeName}`;\n\n const arrayBuffer = await file.arrayBuffer();\n await blob.set(key, new Uint8Array(arrayBuffer));\n await blob.set(`meta:${key}`, JSON.stringify({\n name: file.name, type: file.type, size: file.size,\n uploadedAt: new Date().toISOString(), userName, formName,\n }));\n\n return c.json({ ok: true, key, name: file.name, size: file.size, type: file.type });\n});\n\napp.get(\"/api/files/:key{.+}\", async (c) => {\n const key = c.req.param(\"key\");\n const data = await blob.get(key);\n if (!data) return c.json({ error: \"Not found\" }, 404);\n let contentType = \"application/octet-stream\";\n try {\n const meta = await blob.getJSON(`meta:${key}`) as any;\n if (meta?.type) contentType = meta.type;\n } catch (_) {}\n return new Response(data, { headers: { \"Content-Type\": contentType, \"Cache-Control\": \"public, max-age=31536000\" } });\n});\n\napp.delete(\"/api/files/:key{.+}\", async (c) => {\n const key = c.req.param(\"key\");\n await blob.delete(key);\n await blob.delete(`meta:${key}`);\n return c.json({ ok: true });\n});\n\nexport default app.fetch;\n","deleted","label",[103],"permalink","https://www.val.town/x/kunalmanelkar/sop-backend/code/main.ts","extension","actionData","errors"]