[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","b126e4bc-7dc0-11f1-8e62-1607ee4eb77e","name","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { sendSMS } from \"./sendSMS.ts\";\n\n// ── Config ──────────────────────────────────────────────────\n// Your phone number (E.164 format) — SMS notifications go here\nconst OWNER_PHONE = \"+916363402782\";\n\n// ── Init SQLite table ───────────────────────────────────────\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customer_name TEXT NOT NULL,\n customer_phone TEXT NOT NULL,\n product TEXT NOT NULL,\n quantity INTEGER NOT NULL,\n location_address TEXT DEFAULT '',\n status TEXT DEFAULT 'new',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n);\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ── Serve the order form ────────────────────────────────────\napp.get(\"/\", async (c) => {\n return await serveFile(\"order-form.html\");\n});\n\n// ── Handle order submission ─────────────────────────────────\napp.post(\"/order\", async (c) => {\n try {\n const body = await c.req.json();\n const { customerName, customerPhone, product, quantity, location_address } = body;\n\n // Validate required fields\n if (!customerName || !customerPhone || !product || !quantity) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n // Save order to SQLite\n const result = await sqlite.execute({\n sql: `INSERT INTO orders (customer_name, customer_phone, product, quantity, notes)\n VALUES (?, ?, ?, ?, ?)`,\n args: [customerName, customerPhone, product, quantity, notes || \"\"],\n });\n\n const orderId = Number(result.lastInsertRowid);\n\n // Send SMS notification to the owner\n const smsBody =\n `📦 NEW ORDER #${orderId}\\n` +\n `Name: ${customerName}\\n` +\n `Phone: ${customerPhone}\\n` +\n `Product: ${product}\\n` +\n `Qty: ${quantity}` +\n (notes ? `\\nNotes: ${notes}` : \"\");\n\n try {\n await sendSMS(OWNER_PHONE, smsBody);\n } catch (smsErr) {\n // Log the error but still return success — the order is saved\n console.error(\"SMS notification failed:\", smsErr);\n }\n\n return c.json({\n success: true,\n orderId,\n message: \"Order received! We'll contact you soon.\",\n });\n } catch (err) {\n console.error(\"Order submission error:\", err);\n return c.json({ error: \"Failed to process order\" }, 500);\n }\n});\n\n// ── View all orders (admin) ─────────────────────────────────\napp.get(\"/orders\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM orders ORDER BY created_at DESC LIMIT 100\",\n );\n\n return c.json({\n count: result.rows.length,\n orders: result.rows,\n });\n});\n\nexport default app.fetch;","import { Hono } from \"npm:hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { sendSMS } from \"./sendSMS.ts\";\n\n// ── Config ──────────────────────────────────────────────────\n// Your phone number (E.164 format) — SMS notifications go here\nconst OWNER_PHONE = \"+916363402782\";\n\n// ── Init SQLite table ───────────────────────────────────────\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customer_name TEXT NOT NULL,\n customer_phone TEXT NOT NULL,\n product TEXT NOT NULL,\n quantity INTEGER NOT NULL,\n location_address TEXT DEFAULT '',\n status TEXT DEFAULT 'new',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n);\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ── Serve the order form ────────────────────────────────────\napp.get(\"/\", async (c) => {\n return await serveFile(\"order-form.html\");\n});\n\n// ── Handle order submission ─────────────────────────────────\napp.post(\"/order\", async (c) => {\n try {\n const body = await c.req.json();\n const { customerName, customerPhone, product, quantity, location_address } = body;\n\n // Validate required fields\n if (!customerName || !customerPhone || !product || !quantity) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n // Save order to SQLite\n const result = await sqlite.execute({\n sql: `INSERT INTO orders (customer_name, customer_phone, product, quantity, location_address)\n VALUES (?, ?, ?, ?, ?)`,\n args: [customerName, customerPhone, product, quantity, location_address || \"\"],\n });\n\n const orderId = Number(result.lastInsertRowid);\n\n // Send SMS notification to the owner\n const smsBody =\n `📦 NEW ORDER #${orderId}\\n` +\n `Name: ${customerName}\\n` +\n `Phone: ${customerPhone}\\n` +\n `Product: ${product}\\n` +\n `Qty: ${quantity}` +\n (location_address ? `\\location_address: location_address\n if (!result) {\n return c.json({ error: \"Failed to process order\" }, 500);\n } : \"\");\n\n try {\n await sendSMS(OWNER_PHONE, smsBody);\n } catch (smsErr) {\n // Log the error but still return success — the order is saved\n console.error(\"SMS notification failed:\", smsErr);\n }\n\n return c.json({\n success: true,\n orderId,\n message: \"Order received! We'll contact you soon.\",\n });\n } catch (err) {\n console.error(\"Order submission error:\", err);\n return c.json({ error: \"Failed to process order\" }, 500);\n }\n});\n\n// ── View all orders (admin) ─────────────────────────────────\napp.get(\"/orders\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM orders ORDER BY created_at DESC LIMIT 100\",\n );\n\n return c.json({\n count: result.rows.length,\n orders: result.rows,\n });\n});\n\nexport default app.fetch;","createdAt",["D",1783842123401],"branchVersion","branchId","38570f96-b282-4600-bbf4-6637b38d4f48","id","737cfd62-3640-49bd-9a22-8b97862c1094","PaperWork",["D",1783840198416],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Customer order form with SMS notifications via Twilio","imageUrl","b5fbbab0-f5d2-4f9c-9958-689d3b8c7e63","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f546e-8b4e-7169-a75f-2eb4fc366a6d","tursoName","737cfd62364049bd9a228b97862c1094","tursoHostname","737cfd62364049bd9a228b97862c1094-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","omkar1","handle","displayName","Omkar","avatar","https://lh3.googleusercontent.com/a/ACg8ocK_6NRQpyqMa9O2QJsLmecmENFldi1h5pGFQ24V_0iCNSrrOw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":190,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":191,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":192,"_83":193,"_85":194,"_87":25},"tree",[173,174,175,176],"files",[173,174,175,176],"counts",{"_162":62,"_163":164,"_165":62,"_166":167,"_168":169},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":156,"_32":157,"_30":158,"_137":-5,"_41":42,"_40":154,"_139":25,"_38":159,"_13":62,"_33":20,"_35":160,"_24":25,"_143":-5,"_27":161},{"_43":152,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":153,"_13":154,"_33":34,"_35":37,"_24":25,"_143":-5,"_27":155},{"_43":145,"_32":146,"_30":147,"_137":-5,"_41":42,"_40":148,"_139":25,"_38":149,"_13":62,"_33":20,"_35":150,"_24":25,"_143":-5,"_27":151},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":140,"_13":62,"_33":141,"_35":142,"_24":25,"_143":-5,"_27":144},"796986ad-8969-490e-93aa-ac0b711c310f","sendSMS.ts","0eb3b51a-7dc1-11f1-a2bd-1607ee4eb77e","parentId",4,"latest",["D",1783840355387],"script","// Twilio SMS helper — sends a text message via the Twilio REST API.\n// Requires env vars: TWILIO_ACCOUNT_SID, TWILIO_AUTH_TOKEN, TWILIO_PHONE_NUMBER\n\nexport async function sendSMS(to: string, body: string): Promise {\n const accountSid = Deno.env.get(\"TWILIO_ACCOUNT_SID\");\n const authToken = Deno.env.get(\"TWILIO_AUTH_TOKEN\");\n const fromNumber = Deno.env.get(\"TWILIO_PHONE_NUMBER\");\n\n if (!accountSid || !authToken || !fromNumber) {\n console.error(\n \"Missing Twilio env vars. Set TWILIO_ACCOUNT_SID, TWILIO_AUTH_TOKEN, and TWILIO_PHONE_NUMBER.\",\n );\n throw new Error(\"SMS not configured — missing Twilio credentials\");\n }\n\n const url =\n `https://api.twilio.com/2010-04-01/Accounts/${accountSid}/Messages.json`;\n\n const params = new URLSearchParams();\n params.append(\"From\", fromNumber);\n params.append(\"To\", to);\n params.append(\"Body\", body);\n\n const resp = await fetch(url, {\n method: \"POST\",\n headers: {\n Authorization: `Basic ${btoa(`${accountSid}:${authToken}`)}`,\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: params.toString(),\n });\n\n if (!resp.ok) {\n const errorText = await resp.text();\n console.error(\"Twilio SMS failed:\", resp.status, errorText);\n throw new Error(`SMS failed: ${resp.status} ${errorText}`);\n }\n\n console.log(\"SMS sent successfully to\", to);\n}\n","label",[135],"ea90f6e7-18d8-4b53-91f6-6983648d27ef","order-form.html","0eb9d6f2-7dc1-11f1-8746-1607ee4eb77e",5,["D",1783840355389],"\n\n\n \n \n Place an Order\n \n \n\n\n

📄

Place Your Order

Fill out the form below and we'll get back to you!

\n\n \n\n

✅

Order submitted!

We've received your order and will contact you shortly.

\n\n

⚠️

Something went wrong

Please try again or call us directly.

\n\n \n\n\n",[146],"acb2be2c-dfa7-48b7-8e87-0b91de46ffca",["D",1783842123401],9,[28],"4bffb890-eff5-44aa-b5c4-af3b978f4cdb","README.md","34691534-7dc1-11f1-a506-1607ee4eb77e",["D",1783840418592],"# PaperWork — Order System\n\nA customer order form that saves orders to a database and sends you an SMS notification on every new order.\n\n## How it works\n\n1. **Customers** visit the order form URL and fill in their name, phone, product, quantity, and notes.\n2. **The order is saved** to the val's SQLite database.\n3. **You get a text message** (SMS) on your phone with the order details.\n\n## URLs\n\n| Route | Description |\n|-------|-------------|\n| `/` | Customer order form |\n| `/order` | POST endpoint that processes orders (called by the form) |\n| `/orders` | View all saved orders as JSON (admin) |\n\n## Setup — Twilio SMS (required for notifications)\n\nYou need a [Twilio](https://www.twilio.com/) account to send SMS. Create one (free trial works) and get these three values, then add them as environment variables:\n\n1. **TWILIO_ACCOUNT_SID** — Your Twilio Account SID (found on the Twilio console dashboard)\n2. **TWILIO_AUTH_TOKEN** — Your Twilio Auth Token (found on the Twilio console dashboard)\n3. **TWILIO_PHONE_NUMBER** — Your Twilio phone number (the number Twilio assigned you, in E.164 format like `+12345678900`)\n\n👉 Add TWILIO_ACCOUNT_SID here: https://www.val.town/x/omkar1/PaperWork/environment-variables?key=TWILIO_ACCOUNT_SID\n\n👉 Add TWILIO_AUTH_TOKEN here: https://www.val.town/x/omkar1/PaperWork/environment-variables?key=TWILIO_AUTH_TOKEN\n\n👉 Add TWILIO_PHONE_NUMBER here: https://www.val.town/x/omkar1/PaperWork/environment-variables?key=TWILIO_PHONE_NUMBER\n\n## Notification phone number\n\nSMS notifications are sent to **+1 (636) 340-2782**. To change this, update `OWNER_PHONE` in `main.ts`.\n\n## Files\n\n| File | Purpose |\n|------|---------|\n| `main.ts` | Hono HTTP handler — serves form, saves orders, sends SMS |\n| `order-form.html` | Customer-facing order form (styled with Tailwind via Twind) |\n| `sendSMS.ts` | Twilio REST API helper for sending text messages |\n",[157],"pulls","branches",1,"forks","envVars",{"_170":62,"_172":62},"connections",{"_170":62,"_171":62},"count","unfilledCount","emptyCount",{"_43":156,"_32":157,"_30":158,"_137":-5,"_41":42,"_40":154,"_139":25,"_38":187,"_13":62,"_33":20,"_35":160,"_24":25,"_143":-5,"_178":188,"_27":189},{"_43":152,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":184,"_13":154,"_33":34,"_35":37,"_24":25,"_143":-5,"_178":185,"_27":186},{"_43":145,"_32":146,"_30":147,"_137":-5,"_41":42,"_40":148,"_139":25,"_38":181,"_13":62,"_33":20,"_35":150,"_24":25,"_143":-5,"_178":182,"_27":183},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":177,"_13":62,"_33":141,"_35":142,"_24":25,"_143":-5,"_178":179,"_27":180},["D",1783840355387],"children",[],[135],["D",1783840355389],[],[146],["D",1783842123401],[],[28],["D",1783840418592],[],[157],["D",1783840198416],["D",1789526460011],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_127":228,"_229":230,"_231":232,"_233":25,"_234":25,"_235":25,"_236":58,"_237":-5,"_238":-7,"_239":-7,"_240":62,"_241":25,"_242":25,"_243":-5,"_244":25,"_245":25,"_246":25,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":89,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v13