Swan Sidewalk Cafe

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",14,"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","2cbdf3a4-a936-11f1-9c79-1607ee4eb77e","name","fileType","http","content","// iTabs — Swan Sidewalk Cafe: Merged Queue + Payments (SANDBOX)\n// Paste this whole file into a Val.town HTTP val.\n//\n// BEFORE THIS GOES LIVE WITH GRACE, replace:\n// - SANDBOX_ACCESS_TOKEN / SANDBOX_LOCATION_ID with her real Square values\n// - SQUARE_API_BASE with \"https://connect.squareup.com\" (drop \"sandbox\")\n// Until then this is safe to test freely — sandbox mode never touches real money.\n//\n// Routes:\n// GET / customer ordering menu (coffee only, M/L)\n// POST /api/order places an order -> inserted into shared queue\n// pass { manual: true } for orders Grace punches in herself\n// (skips Square payment link — she takes payment on her own terminal)\n// GET /queue Grace's iPad: add-order panel (left) + live queue (right), split on wide screens\n// GET /api/queue JSON: current active queue (done=0)\n// GET /api/history JSON: last 100 completed orders (done=1), for the History tab\n// GET /api/menu JSON: current menu (name, priceM, priceL, singleSize)\n// POST /api/menu/save { pin, items } — PIN-protected menu edit (tap \"edit\" in the customer page footer)\n// POST /api/mark-paid { orderId }\n// POST /api/mark-done { orderId }\n// POST /webhook/square Square calls this when a payment completes (auto-marks paid)\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SANDBOX_ACCESS_TOKEN = \"PASTE_YOUR_SANDBOX_ACCESS_TOKEN_HERE\";\nconst SANDBOX_LOCATION_ID = \"PASTE_YOUR_SANDBOX_LOCATION_ID_HERE\";\nconst SQUARE_API_BASE = \"https://connect.squareupsandbox.com\";\n\nconst SEED_MENU = [\n { name: \"Cappuccino\", priceM: 5.50, priceL: 6.00 },\n { name: \"Chai\", priceM: 5.50, priceL: 6.00 },\n { name: \"Dirty Chai\", priceM: 6.00, priceL: 6.50 },\n { name: \"Flat White\", priceM: 5.50, priceL: 6.00 },\n { name: \"Hot Chocolate\", priceM: 5.50, priceL: 6.00 },\n { name: \"Latte\", priceM: 5.50, priceL: 6.00 },\n { name: \"Long Black\", priceM: 4.00, priceL: 4.50 },\n { name: \"Mocha\", priceM: 6.00, priceL: 6.50 },\n { name: \"Matcha\", priceM: 5.50, priceL: 6.00 },\n { name: \"Tea\", priceM: 4.00, priceL: 4.50 },\n { name: \"Macchiato\", priceM: 4.00, priceL: 4.00, singleSize: true },\n { name: \"Long Mac Topped Up\", priceM: 5.00, priceL: 5.00, singleSize: true },\n { name: \"Espresso\", priceM: 4.50, priceL: 4.50, singleSize: true },\n];\nconst MENU_EDIT_PIN = \"7000\"; // last 4 of Grace's phone, matches her existing menu PIN\n\n// ---------- DB setup ----------\nasync function ensureTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS swan_orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_number INTEGER,\n customer_name TEXT,\n items TEXT,\n total_cents INTEGER,\n paid INTEGER DEFAULT 0,\n done INTEGER DEFAULT 0,\n square_order_id TEXT,\n created_at TEXT\n )\n `);\n // Table already existed from earlier testing without a notes column —\n // add it if missing. Errors if the column already exists, which we ignore.\n try {\n await sqlite.execute(`ALTER TABLE swan_orders ADD COLUMN notes TEXT`);\n } catch (_err) {\n // column already exists — fine, nothing to do\n }\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS swan_menu (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n price_m REAL,\n price_l REAL,\n single_size INTEGER DEFAULT 0,\n sort_order INTEGER\n )\n `);\n const countResult = await sqlite.execute({ sql: `SELECT COUNT(*) FROM swan_menu`, args: [] });\n const menuCount = Number(countResult.rows[0][0]);\n if (menuCount === 0) {\n for (let i = 0; i < SEED_MENU.length; i++) {\n const item = SEED_MENU[i];\n await sqlite.execute({\n sql: `INSERT INTO swan_menu (name, price_m, price_l, single_size, sort_order) VALUES (?, ?, ?, ?, ?)`,\n args: [item.name, item.priceM, item.priceL, item.singleSize ? 1 : 0, i],\n });\n }\n }\n // Add image_url if the table already existed from before this feature was added.\n try {\n await sqlite.execute(`ALTER TABLE swan_menu ADD COLUMN image_url TEXT`);\n } catch (_err) {\n // column already exists — fine, nothing to do\n }\n}\n\nasync function getMenu(): Promise<{ name: string; priceM: number; priceL: number; singleSize: boolean; imageUrl: string }[]> {\n const result = await sqlite.execute({\n sql: `SELECT name, price_m, price_l, single_size, image_url FROM swan_menu ORDER BY sort_order ASC, id ASC`,\n args: [],\n });\n return result.rows.map((r) => ({\n name: r[0] as string, priceM: Number(r[1]), priceL: Number(r[2]), singleSize: !!r[3], imageUrl: (r[4] as string) || \"\",\n }));\n}\n\nasync function nextOrderNumber(): Promise {\n const result = await sqlite.execute({\n sql: `SELECT MAX(order_number) as maxNum FROM swan_orders WHERE date(created_at) = date('now')`,\n args: [],\n });\n const row = result.rows[0];\n const maxNum = row && row[0] ? Number(row[0]) : 13; // start at 14 to match earlier mockups\n return maxNum + 1;\n}\n\n// ---------- Square ----------\nasync function createPaymentLink(orderNumber: number, itemsText: string, totalCents: number) {\n const idempotencyKey = crypto.randomUUID();\n const res = await fetch(SQUARE_API_BASE + \"/v2/online-checkout/payment-links\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": \"Bearer \" + SANDBOX_ACCESS_TOKEN,\n \"Square-Version\": \"2024-01-18\",\n },\n body: JSON.stringify({\n idempotency_key: idempotencyKey,\n quick_pay: {\n name: \"Order #\" + orderNumber + \" — \" + itemsText,\n price_money: { amount: totalCents, currency: \"AUD\" },\n location_id: SANDBOX_LOCATION_ID,\n },\n }),\n });\n if (!res.ok) throw new Error(\"Square API error: \" + (await res.text()));\n const data = await res.json();\n return { url: data.payment_link.url as string, squareOrderId: data.payment_link.order_id as string };\n}\n\nfunction html(body: string, status = 200) {\n return new Response(body, {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\", \"cache-control\": \"no-store\" },\n });\n}\nfunction json(obj: unknown, status = 200) {\n return new Response(JSON.stringify(obj), { status, headers: { \"content-type\": \"application/json\" } });\n}\n\n// ---------- Pages ----------\nfunction customerPage() {\n return html(`\n\n\nSwan Sidewalk Cafe\n\n\n

🦢 Swan Sidewalk Cafe

Coffee & Drinks

\n \n

0 items

\n \n

Your Order

Name (optional)

\n \n

Notes (optional) — e.g. no sugar, oat milk

\n \n \n \n

\n\n

Owner access

\n \n \n \n \n

\n \n \n

\n\n

Edit Menu

Prices are for Medium — Large is a separate field per item

\n \n \n \n

\n\n\n\n\n\n `);\n}\n\nfunction queuePage() {\n return html(`\n\n\nSwan Sidewalk Cafe — Queue\n\n\n

🦢 Swan Sidewalk Cafe

0 waiting

Add Order

Size

Medium

Large

Name (optional)

\n \n

Notes (optional)

\n \n \n

\n\n\n `);\n}\n\n// ---------- Router ----------\nexport default async function (req: Request): Promise {\n await ensureTable();\n const url = new URL(req.url);\n\n if (url.pathname === \"/\" && req.method === \"GET\") return customerPage();\n if (url.pathname === \"/queue\" && req.method === \"GET\") return queuePage();\n\n if (url.pathname === \"/api/menu\" && req.method === \"GET\") {\n return json(await getMenu());\n }\n\n if (url.pathname === \"/api/menu/save\" && req.method === \"POST\") {\n const body = await req.json();\n if (body.pin !== MENU_EDIT_PIN) return json({ error: \"Invalid PIN\" }, 403);\n const items = body.items as { name: string; priceM: number; priceL: number; singleSize?: boolean; imageUrl?: string }[];\n await sqlite.execute({ sql: `DELETE FROM swan_menu`, args: [] });\n for (let i = 0; i < items.length; i++) {\n const item = items[i];\n await sqlite.execute({\n sql: `INSERT INTO swan_menu (name, price_m, price_l, single_size, sort_order, image_url) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [item.name, item.priceM, item.priceL, item.singleSize ? 1 : 0, i, item.imageUrl || \"\"],\n });\n }\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/order\" && req.method === \"POST\") {\n const body = await req.json();\n const menu = await getMenu();\n const items = body.items as { name: string; qty: number; size: string }[];\n const isManual = !!body.manual; // manual entries (Grace's iPad panel) skip Square payment link\n let totalCents = 0;\n const itemsText = items.map((i) => {\n const menuItem = menu.find((m) => m.name === i.name)!;\n const price = menuItem.singleSize ? menuItem.priceM : (i.size === \"L\" ? menuItem.priceL : menuItem.priceM);\n totalCents += Math.round(price * 100) * i.qty;\n return i.qty + \"× \" + i.name + (menuItem.singleSize ? \"\" : \" (\" + i.size + \")\");\n }).join(\", \");\n\n const orderNumber = await nextOrderNumber();\n const insertResult = await sqlite.execute({\n sql: `INSERT INTO swan_orders (order_number, customer_name, items, total_cents, paid, done, notes, created_at)\n VALUES (?, ?, ?, ?, 0, 0, ?, datetime('now'))`,\n args: [orderNumber, body.name || \"\", itemsText, totalCents, body.notes || \"\"],\n });\n const dbId = insertResult.lastInsertRowid;\n\n if (isManual) {\n // Grace takes payment on her own terminal — she taps Mark Paid herself, no Square link needed.\n return json({ orderId: dbId, orderNumber, payUrl: null });\n }\n\n try {\n const { url: payUrl, squareOrderId } = await createPaymentLink(orderNumber, itemsText, totalCents);\n await sqlite.execute({\n sql: `UPDATE swan_orders SET square_order_id = ? WHERE id = ?`,\n args: [squareOrderId, dbId],\n });\n return json({ orderId: dbId, orderNumber, payUrl });\n } catch (err) {\n // Payment link failed (e.g. Square keys not filled in yet) — order is still queued, just unpaid.\n return json({ orderId: dbId, orderNumber, payUrl: null, error: String(err) });\n }\n }\n\n if (url.pathname === \"/api/queue\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql: `SELECT id, order_number, customer_name, items, total_cents, paid, notes FROM swan_orders\n WHERE done = 0 ORDER BY id ASC`,\n args: [],\n });\n const orders = result.rows.map((r) => ({\n id: r[0], order_number: r[1], customer_name: r[2], items: r[3], total_cents: r[4], paid: !!r[5], notes: r[6],\n }));\n return json(orders);\n }\n\n if (url.pathname === \"/api/history\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql: `SELECT id, order_number, customer_name, items, total_cents, paid, notes FROM swan_orders\n WHERE done = 1 ORDER BY id DESC LIMIT 100`,\n args: [],\n });\n const orders = result.rows.map((r) => ({\n id: r[0], order_number: r[1], customer_name: r[2], items: r[3], total_cents: r[4], paid: !!r[5], notes: r[6],\n }));\n return json(orders);\n }\n\n if (url.pathname === \"/api/mark-paid\" && req.method === \"POST\") {\n const { orderId } = await req.json();\n await sqlite.execute({ sql: `UPDATE swan_orders SET paid = 1 WHERE id = ?`, args: [orderId] });\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/mark-done\" && req.method === \"POST\") {\n const { orderId } = await req.json();\n await sqlite.execute({ sql: `UPDATE swan_orders SET done = 1 WHERE id = ?`, args: [orderId] });\n return json({ ok: true });\n }\n\n // Square calls this URL when a payment completes, IF you configure a webhook\n // subscription in the Square dashboard pointing here. Optional for MVP —\n // without it, Grace just taps \"Mark Paid\" manually for QR orders too.\n if (url.pathname === \"/webhook/square\" && req.method === \"POST\") {\n const event = await req.json();\n if (event.type === \"payment.updated\" && event.data?.object?.payment?.status === \"COMPLETED\") {\n const squareOrderId = event.data.object.payment.order_id;\n await sqlite.execute({\n sql: `UPDATE swan_orders SET paid = 1 WHERE square_order_id = ?`,\n args: [squareOrderId],\n });\n }\n return json({ received: true });\n }\n\n return html(\"

Not found

\", 404);\n}","// iTabs — Swan Sidewalk Cafe: Merged Queue + Payments (SANDBOX)\n// Paste this whole file into a Val.town HTTP val.\n//\n// BEFORE THIS GOES LIVE WITH GRACE, replace:\n// - SANDBOX_ACCESS_TOKEN / SANDBOX_LOCATION_ID with her real Square values\n// - SQUARE_API_BASE with \"https://connect.squareup.com\" (drop \"sandbox\")\n// Until then this is safe to test freely — sandbox mode never touches real money.\n//\n// Routes:\n// GET / customer ordering menu (coffee only, M/L)\n// POST /api/order places an order -> inserted into shared queue\n// pass { manual: true } for orders Grace punches in herself\n// (skips Square payment link — she takes payment on her own terminal)\n// GET /queue Grace's iPad: add-order panel (left) + live queue (right), split on wide screens\n// GET /api/queue JSON: current active queue (done=0)\n// GET /api/history JSON: last 100 completed orders (done=1), for the History tab\n// GET /api/menu JSON: current menu (name, priceM, priceL, singleSize)\n// POST /api/menu/save { pin, items } — PIN-protected menu edit (tap \"edit\" in the customer page footer)\n// POST /api/mark-paid { orderId }\n// POST /api/mark-done { orderId }\n// POST /webhook/square Square calls this when a payment completes (auto-marks paid)\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SANDBOX_ACCESS_TOKEN = \"PASTE_YOUR_SANDBOX_ACCESS_TOKEN_HERE\";\nconst SANDBOX_LOCATION_ID = \"PASTE_YOUR_SANDBOX_LOCATION_ID_HERE\";\nconst SQUARE_API_BASE = \"https://connect.squareupsandbox.com\";\n\nconst SEED_MENU = [\n { name: \"Cappuccino\", priceM: 5.50, priceL: 6.00 },\n { name: \"Chai\", priceM: 5.50, priceL: 6.00 },\n { name: \"Dirty Chai\", priceM: 6.00, priceL: 6.50 },\n { name: \"Flat White\", priceM: 5.50, priceL: 6.00 },\n { name: \"Hot Chocolate\", priceM: 5.50, priceL: 6.00 },\n { name: \"Latte\", priceM: 5.50, priceL: 6.00 },\n { name: \"Long Black\", priceM: 4.00, priceL: 4.50 },\n { name: \"Mocha\", priceM: 6.00, priceL: 6.50 },\n { name: \"Matcha\", priceM: 5.50, priceL: 6.00 },\n { name: \"Tea\", priceM: 4.00, priceL: 4.50 },\n { name: \"Macchiato\", priceM: 4.00, priceL: 4.00, singleSize: true },\n { name: \"Long Mac Topped Up\", priceM: 5.00, priceL: 5.00, singleSize: true },\n { name: \"Espresso\", priceM: 4.50, priceL: 4.50, singleSize: true },\n];\nconst MENU_EDIT_PIN = \"7000\"; // last 4 of Grace's phone, matches her existing menu PIN\n\n// ---------- DB setup ----------\nasync function ensureTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS swan_orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_number INTEGER,\n customer_name TEXT,\n items TEXT,\n total_cents INTEGER,\n paid INTEGER DEFAULT 0,\n done INTEGER DEFAULT 0,\n square_order_id TEXT,\n created_at TEXT\n )\n `);\n // Table already existed from earlier testing without a notes column —\n // add it if missing. Errors if the column already exists, which we ignore.\n try {\n await sqlite.execute(`ALTER TABLE swan_orders ADD COLUMN notes TEXT`);\n } catch (_err) {\n // column already exists — fine, nothing to do\n }\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS swan_menu (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n price_m REAL,\n price_l REAL,\n single_size INTEGER DEFAULT 0,\n sort_order INTEGER\n )\n `);\n const countResult = await sqlite.execute({\n sql: `SELECT COUNT(*) FROM swan_menu`,\n args: [],\n });\n const menuCount = Number(countResult.rows[0][0]);\n if (menuCount === 0) {\n for (let i = 0; i < SEED_MENU.length; i++) {\n const item = SEED_MENU[i];\n await sqlite.execute({\n sql:\n `INSERT INTO swan_menu (name, price_m, price_l, single_size, sort_order) VALUES (?, ?, ?, ?, ?)`,\n args: [item.name, item.priceM, item.priceL, item.singleSize ? 1 : 0, i],\n });\n }\n }\n // Add image_url if the table already existed from before this feature was added.\n try {\n await sqlite.execute(`ALTER TABLE swan_menu ADD COLUMN image_url TEXT`);\n } catch (_err) {\n // column already exists — fine, nothing to do\n }\n}\n\nasync function getMenu(): Promise<\n {\n name: string;\n priceM: number;\n priceL: number;\n singleSize: boolean;\n imageUrl: string;\n }[]\n> {\n const result = await sqlite.execute({\n sql:\n `SELECT name, price_m, price_l, single_size, image_url FROM swan_menu ORDER BY sort_order ASC, id ASC`,\n args: [],\n });\n return result.rows.map((r) => ({\n name: r[0] as string,\n priceM: Number(r[1]),\n priceL: Number(r[2]),\n singleSize: !!r[3],\n imageUrl: (r[4] as string) || \"\",\n }));\n}\n\nasync function nextOrderNumber(): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT MAX(order_number) as maxNum FROM swan_orders WHERE date(created_at) = date('now')`,\n args: [],\n });\n const row = result.rows[0];\n const maxNum = row && row[0] ? Number(row[0]) : 13; // start at 14 to match earlier mockups\n return maxNum + 1;\n}\n\n// ---------- Square ----------\nasync function createPaymentLink(\n orderNumber: number,\n itemsText: string,\n totalCents: number,\n) {\n const idempotencyKey = crypto.randomUUID();\n const res = await fetch(\n SQUARE_API_BASE + \"/v2/online-checkout/payment-links\",\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": \"Bearer \" + SANDBOX_ACCESS_TOKEN,\n \"Square-Version\": \"2024-01-18\",\n },\n body: JSON.stringify({\n idempotency_key: idempotencyKey,\n quick_pay: {\n name: \"Order #\" + orderNumber + \" — \" + itemsText,\n price_money: { amount: totalCents, currency: \"AUD\" },\n location_id: SANDBOX_LOCATION_ID,\n },\n }),\n },\n );\n if (!res.ok) throw new Error(\"Square API error: \" + (await res.text()));\n const data = await res.json();\n return {\n url: data.payment_link.url as string,\n squareOrderId: data.payment_link.order_id as string,\n };\n}\n\nfunction html(body: string, status = 200) {\n return new Response(body, {\n status,\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}\nfunction json(obj: unknown, status = 200) {\n return new Response(JSON.stringify(obj), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n\n// ---------- Pages ----------\nfunction customerPage() {\n return html(`\n\n\nSwan Sidewalk Cafe\n\n\n

🦢 Swan Sidewalk Cafe

Coffee & Drinks

\n \n

0 items

\n \n

Your Order

Name (optional)

\n \n

Notes (optional) — e.g. no sugar, oat milk

\n \n \n \n

\n\n

Owner access

\n \n \n \n \n

\n \n \n

\n\n

Edit Menu

\n \n \n

\n \n \n \n

\n\n\n\n\n\n `);\n}\n\nfunction queuePage() {\n return html(`\n\n\nSwan Sidewalk Cafe — Queue\n\n\n

🦢 Swan Sidewalk Cafe

0 waiting

Add Order

Size

Medium

Large

Name (optional)

\n \n

Notes (optional)

\n \n \n

\n\n\n `);\n}\n\n// ---------- Router ----------\nexport default async function (req: Request): Promise {\n await ensureTable();\n const url = new URL(req.url);\n\n if (url.pathname === \"/\" && req.method === \"GET\") return customerPage();\n if (url.pathname === \"/queue\" && req.method === \"GET\") return queuePage();\n\n if (url.pathname === \"/api/menu\" && req.method === \"GET\") {\n return json(await getMenu());\n }\n\n if (url.pathname === \"/api/menu/save\" && req.method === \"POST\") {\n const body = await req.json();\n if (body.pin !== MENU_EDIT_PIN) return json({ error: \"Invalid PIN\" }, 403);\n const items = body.items as {\n name: string;\n priceM: number;\n priceL: number;\n singleSize?: boolean;\n imageUrl?: string;\n }[];\n await sqlite.execute({ sql: `DELETE FROM swan_menu`, args: [] });\n for (let i = 0; i < items.length; i++) {\n const item = items[i];\n await sqlite.execute({\n sql:\n `INSERT INTO swan_menu (name, price_m, price_l, single_size, sort_order, image_url) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n item.name,\n item.priceM,\n item.priceL,\n item.singleSize ? 1 : 0,\n i,\n item.imageUrl || \"\",\n ],\n });\n }\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/order\" && req.method === \"POST\") {\n const body = await req.json();\n const menu = await getMenu();\n const items = body.items as { name: string; qty: number; size: string }[];\n const isManual = !!body.manual; // manual entries (Grace's iPad panel) skip Square payment link\n let totalCents = 0;\n const itemsText = items.map((i) => {\n const menuItem = menu.find((m) => m.name === i.name)!;\n const price = menuItem.singleSize\n ? menuItem.priceM\n : (i.size === \"L\" ? menuItem.priceL : menuItem.priceM);\n totalCents += Math.round(price * 100) * i.qty;\n return i.qty + \"× \" + i.name +\n (menuItem.singleSize ? \"\" : \" (\" + i.size + \")\");\n }).join(\", \");\n\n const orderNumber = await nextOrderNumber();\n const insertResult = await sqlite.execute({\n sql:\n `INSERT INTO swan_orders (order_number, customer_name, items, total_cents, paid, done, notes, created_at)\n VALUES (?, ?, ?, ?, 0, 0, ?, datetime('now'))`,\n args: [\n orderNumber,\n body.name || \"\",\n itemsText,\n totalCents,\n body.notes || \"\",\n ],\n });\n const dbId = insertResult.lastInsertRowid;\n\n if (isManual) {\n // Grace takes payment on her own terminal — she taps Mark Paid herself, no Square link needed.\n return json({ orderId: dbId, orderNumber, payUrl: null });\n }\n\n try {\n const { url: payUrl, squareOrderId } = await createPaymentLink(\n orderNumber,\n itemsText,\n totalCents,\n );\n await sqlite.execute({\n sql: `UPDATE swan_orders SET square_order_id = ? WHERE id = ?`,\n args: [squareOrderId, dbId],\n });\n return json({ orderId: dbId, orderNumber, payUrl });\n } catch (err) {\n // Payment link failed (e.g. Square keys not filled in yet) — order is still queued, just unpaid.\n return json({\n orderId: dbId,\n orderNumber,\n payUrl: null,\n error: String(err),\n });\n }\n }\n\n if (url.pathname === \"/api/queue\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql:\n `SELECT id, order_number, customer_name, items, total_cents, paid, notes FROM swan_orders\n WHERE done = 0 ORDER BY id ASC`,\n args: [],\n });\n const orders = result.rows.map((r) => ({\n id: r[0],\n order_number: r[1],\n customer_name: r[2],\n items: r[3],\n total_cents: r[4],\n paid: !!r[5],\n notes: r[6],\n }));\n return json(orders);\n }\n\n if (url.pathname === \"/api/history\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql:\n `SELECT id, order_number, customer_name, items, total_cents, paid, notes FROM swan_orders\n WHERE done = 1 ORDER BY id DESC LIMIT 100`,\n args: [],\n });\n const orders = result.rows.map((r) => ({\n id: r[0],\n order_number: r[1],\n customer_name: r[2],\n items: r[3],\n total_cents: r[4],\n paid: !!r[5],\n notes: r[6],\n }));\n return json(orders);\n }\n\n if (url.pathname === \"/api/mark-paid\" && req.method === \"POST\") {\n const { orderId } = await req.json();\n await sqlite.execute({\n sql: `UPDATE swan_orders SET paid = 1 WHERE id = ?`,\n args: [orderId],\n });\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/mark-done\" && req.method === \"POST\") {\n const { orderId } = await req.json();\n await sqlite.execute({\n sql: `UPDATE swan_orders SET done = 1 WHERE id = ?`,\n args: [orderId],\n });\n return json({ ok: true });\n }\n\n // Square calls this URL when a payment completes, IF you configure a webhook\n // subscription in the Square dashboard pointing here. Optional for MVP —\n // without it, Grace just taps \"Mark Paid\" manually for QR orders too.\n if (url.pathname === \"/webhook/square\" && req.method === \"POST\") {\n const event = await req.json();\n if (\n event.type === \"payment.updated\" &&\n event.data?.object?.payment?.status === \"COMPLETED\"\n ) {\n const squareOrderId = event.data.object.payment.order_id;\n await sqlite.execute({\n sql: `UPDATE swan_orders SET paid = 1 WHERE square_order_id = ?`,\n args: [squareOrderId],\n });\n }\n return json({ received: true });\n }\n\n return html(\"

Not found

\", 404);\n}","createdAt",["D",1788679879153],"branchVersion","branchId","e5fb57a9-fdb6-4263-84e0-a4f9b21280b5","id","7ff719c7-db0f-4c8b-9c28-2a153e4314b2","sidewalk-cafe-2",["D",1788618556875],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","9e73754f-780d-46b7-924e-110519305b47","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d76ed-e14a-727a-b612-7191b6d5a9b7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jgwynne7_4bf3679b","handle","displayName","iTabs-Menu","avatar","https://avatars.githubusercontent.com/u/177847225?v=4","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":151,"_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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":152,"_80":153,"_82":154,"_84":25},"tree",[146],"files",[146],"counts",{"_135":62,"_136":137,"_138":62,"_139":140,"_141":142},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":133,"_27":134},"6a3c636c-cb84-4464-adc4-a422ef2812c1","parentId","latest",["D",1788679879153],13,"label","swan-sidewalk-cafe",[28],"pulls","branches",1,"forks","envVars",{"_143":62,"_145":62},"connections",{"_143":62,"_144":62},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":147,"_13":131,"_33":34,"_35":37,"_24":25,"_132":133,"_148":149,"_27":150},["D",1788679879153],"children",[],[28],["D",1788618556875],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":188,"_189":190,"_191":192,"_193":25,"_194":25,"_195":25,"_196":58,"_197":-5,"_198":-7,"_199":-7,"_200":62,"_201":25,"_202":25,"_203":-5,"_204":25,"_205":25,"_206":25,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":86,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v14