[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"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":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",7,"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","4978c66c-7f48-11f1-b161-1607ee4eb77e","name","fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_id TEXT,\n subject TEXT,\n to_name TEXT,\n address TEXT,\n city TEXT,\n pincode TEXT,\n state TEXT,\n phone TEXT,\n status TEXT,\n created_at TEXT,\n approved_at TEXT\n )\n`);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname === \"/api/settings\" && req.method === \"GET\") {\n const result = await sqlite.execute(`SELECT key, value FROM settings`);\n const cfg: Record = {};\n for (const row of result.rows) cfg[row.key as string] = row.value as string;\n return Response.json({ url: cfg.apiUrl || \"\", auth: cfg.apiAuth || \"\" });\n }\n\n if (url.pathname === \"/api/settings\" && req.method === \"POST\") {\n const body = await req.json();\n await sqlite.execute(\n `INSERT INTO settings (key, value) VALUES ('apiUrl', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n [body.url || \"\"]\n );\n await sqlite.execute(\n `INSERT INTO settings (key, value) VALUES ('apiAuth', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n [body.auth || \"\"]\n );\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/orders\" && req.method === \"POST\") {\n const o = await req.json();\n await sqlite.execute(\n `INSERT INTO orders (order_id, subject, to_name, address, city, pincode, state, phone, status, created_at, approved_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [o.order_id, o.subject, o.to_name, o.address, o.city, o.pincode, o.state, o.phone, o.status, o.created_at, o.approved_at]\n );\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/orders\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT order_id, status, approved_at FROM orders ORDER BY id DESC LIMIT 25`\n );\n const items = result.rows.map((r: any) => ({\n order_id: r.order_id,\n status: r.status,\n approved_at: r.approved_at,\n }));\n return Response.json(items);\n }\n\n if (url.pathname === \"/api/send\" && req.method === \"POST\") {\n const payload = await req.json();\n const result = await sqlite.execute(`SELECT key, value FROM settings`);\n const cfg: Record = {};\n for (const row of result.rows) cfg[row.key as string] = row.value as string;\n\n if (!cfg.apiUrl) {\n return Response.json({ ok: false, reason: \"no-endpoint\" });\n }\n try {\n const headers: Record = { \"Content-Type\": \"application/json\" };\n if (cfg.apiAuth) headers[\"Authorization\"] = cfg.apiAuth;\n const res = await fetch(cfg.apiUrl, {\n method: \"POST\",\n headers,\n body: JSON.stringify(payload),\n });\n if (!res.ok) throw new Error(\"Status \" + res.status);\n return Response.json({ ok: true });\n } catch (e) {\n return Response.json({ ok: false, reason: String(e) });\n }\n }\n\n if (url.pathname === \"/\" && req.method === \"GET\") {\n return new Response(HTML, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n\nconst HTML = `\n\n\n\n\nManifest — Order Barcode Agent\n\n\n\n\n\n

Order Fulfillment · Automated

Barcode Agent

Generate → Review → Approve → Send

\n \n

New Order

\n Order No\n \n Sub / Description\n \n To (Customer name)\n \n Address\n \n

\n City\n \n

\n Pincode\n \n

\n State\n \n Phone No\n \n \n

\n\n

Sent / Recent

Nothing yet — approved orders will show up here.

\n\n\n\n\n\n`;","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_id TEXT,\n subject TEXT,\n to_name TEXT,\n address TEXT,\n city TEXT,\n pincode TEXT,\n state TEXT,\n phone TEXT,\n status TEXT,\n source TEXT,\n created_at TEXT,\n approved_at TEXT\n )\n`);\n\nasync function getSettings() {\n const result = await sqlite.execute(`SELECT key, value FROM settings`);\n const cfg: Record = {};\n for (const row of result.rows) cfg[row.key as string] = row.value as string;\n return cfg;\n}\n\nasync function sendToCompany(payload: any) {\n const cfg = await getSettings();\n if (!cfg.apiUrl) return { ok: false, reason: \"no-endpoint\" };\n try {\n const headers: Record = { \"Content-Type\": \"application/json\" };\n if (cfg.apiAuth) headers[\"Authorization\"] = cfg.apiAuth;\n const res = await fetch(cfg.apiUrl, { method: \"POST\", headers, body: JSON.stringify(payload) });\n if (!res.ok) throw new Error(\"Status \" + res.status);\n return { ok: true };\n } catch (e) {\n return { ok: false, reason: String(e) };\n }\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const parts = url.pathname.split(\"/\").filter(Boolean); // e.g. ['api','queue','12']\n\n // ---- Settings ----\n if (url.pathname === \"/api/settings\" && req.method === \"GET\") {\n const cfg = await getSettings();\n return Response.json({ url: cfg.apiUrl || \"\", auth: cfg.apiAuth || \"\" });\n }\n if (url.pathname === \"/api/settings\" && req.method === \"POST\") {\n const body = await req.json();\n await sqlite.execute(\n `INSERT INTO settings (key, value) VALUES ('apiUrl', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n [body.url || \"\"]\n );\n await sqlite.execute(\n `INSERT INTO settings (key, value) VALUES ('apiAuth', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n [body.auth || \"\"]\n );\n return Response.json({ ok: true });\n }\n\n // ---- Queue: list ----\n if (url.pathname === \"/api/queue\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT id, order_id, subject, to_name, address, city, pincode, state, phone, source FROM orders WHERE status = 'queued' ORDER BY id ASC`\n );\n return Response.json(result.rows);\n }\n\n // ---- Queue: add (manual entry or bulk upload row) ----\n if (url.pathname === \"/api/queue\" && req.method === \"POST\") {\n const o = await req.json();\n await sqlite.execute(\n `INSERT INTO orders (order_id, subject, to_name, address, city, pincode, state, phone, status, source, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'queued', ?, ?)`,\n [o.order_id, o.subject || \"\", o.to_name || \"\", o.address || \"\", o.city || \"\", o.pincode || \"\", o.state || \"\", o.phone || \"\", o.source || \"manual\", new Date().toISOString()]\n );\n return Response.json({ ok: true });\n }\n\n // ---- Queue: edit one item ----\n if (parts[0] === \"api\" && parts[1] === \"queue\" && parts[2] && req.method === \"PATCH\") {\n const id = parts[2];\n const o = await req.json();\n await sqlite.execute(\n `UPDATE orders SET order_id=?, subject=?, to_name=?, address=?, city=?, pincode=?, state=?, phone=? WHERE id=?`,\n [o.order_id, o.subject || \"\", o.to_name || \"\", o.address || \"\", o.city || \"\", o.pincode || \"\", o.state || \"\", o.phone || \"\", id]\n );\n return Response.json({ ok: true });\n }\n\n // ---- Queue: discard one item ----\n if (parts[0] === \"api\" && parts[1] === \"queue\" && parts[2] && req.method === \"DELETE\") {\n const id = parts[2];\n await sqlite.execute(`DELETE FROM orders WHERE id = ?`, [id]);\n return Response.json({ ok: true });\n }\n\n // ---- Queue: approve all ----\n if (url.pathname === \"/api/queue/approve\" && req.method === \"POST\") {\n const result = await sqlite.execute(`SELECT * FROM orders WHERE status = 'queued' ORDER BY id ASC`);\n let sent = 0, localOnly = 0, failed = 0;\n for (const row of result.rows as any[]) {\n const payload = {\n order_id: row.order_id, subject: row.subject, to_name: row.to_name,\n address: row.address, city: row.city, pincode: row.pincode, state: row.state, phone: row.phone,\n barcode_format: \"CODE128\", barcode_value: row.order_id,\n created_at: row.created_at, approved_at: new Date().toISOString()\n };\n const result2 = await sendToCompany(payload);\n let status = \"failed\";\n if (result2.ok) { status = \"sent\"; sent++; }\n else if (result2.reason === \"no-endpoint\") { status = \"sent-locally\"; localOnly++; }\n else { failed++; }\n await sqlite.execute(\n `UPDATE orders SET status=?, approved_at=? WHERE id=?`,\n [status, payload.approved_at, row.id]\n );\n }\n return Response.json({ sent, localOnly, failed });\n }\n\n // ---- History ----\n if (url.pathname === \"/api/history\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT order_id, status, approved_at FROM orders WHERE status != 'queued' ORDER BY id DESC LIMIT 50`\n );\n return Response.json(result.rows);\n }\n\n if (url.pathname === \"/\" && req.method === \"GET\") {\n return new Response(HTML, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n\nconst HTML = `\n\n\n\n\nManifest — Order Barcode Agent\n\n\n\n\n\n

Order Fulfillment · Automated

Barcode Agent

Email arrives → Auto-generated → Review → Approve All

\n \n

\n\n

Bulk Import

Or upload a sheet manually. Columns: Order No, Sub, Name/To, Address, City, Pincode, State, Phone.

\n \n \n

Tap to choose a CSV or Excel file

\n \n

\n\n

New Order (manual)

\n Order No\n \n Sub / Description\n \n To (Customer name)\n \n Address\n \n

City

Pincode

\n State\n \n Phone No\n \n \n

\n\n

Review Queue

Orders land here automatically from email or upload. Fix anything that's wrong, then approve.

\n Loading…\n

\n \n

\n\n

Sent / Recent

Nothing yet.

\n\n\n\n

New Order

Sent / Recent

Company Endpoint

Bulk Import

New Order (manual)

Review Queue Refresh

Sent / Recent

Company Endpoint

Review Queue

Diff · v7