[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_119":-5,"_20":120,"_22":121,"_122":123,"_124":125,"_25":126,"_24":-5,"_127":-5,"_128":-5,"_129":53,"_130":131,"_132":44,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","pranavjawale","name","barcode-agent","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","b9819897-da40-4cd7-b9f8-243727bb5d51","main.ts","fileId","4978c66c-7f48-11f1-b161-1607ee4eb77e","parentId","branchId","2a1002db-706b-4f60-bf0b-b2bfab77cdbd","branchVersion",10,"latest",true,"createdAt",["D",1784107574164],9,"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 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);\n\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 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 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 [\n o.order_id,\n o.subject || \"\",\n o.to_name || \"\",\n o.address || \"\",\n o.city || \"\",\n o.pincode || \"\",\n o.state || \"\",\n o.phone || \"\",\n o.source || \"manual\",\n new Date().toISOString(),\n ]\n );\n return Response.json({ ok: true });\n }\n\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 [\n o.order_id,\n o.subject || \"\",\n o.to_name || \"\",\n o.address || \"\",\n o.city || \"\",\n o.pincode || \"\",\n o.state || \"\",\n o.phone || \"\",\n id,\n ]\n );\n return Response.json({ ok: true });\n }\n\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 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,\n localOnly = 0,\n failed = 0;\n for (const row of result.rows as any[]) {\n const payload = {\n order_id: row.order_id,\n subject: row.subject,\n to_name: row.to_name,\n address: row.address,\n city: row.city,\n pincode: row.pincode,\n state: row.state,\n phone: row.phone,\n barcode_format: \"CODE128\",\n barcode_value: row.order_id,\n created_at: row.created_at,\n approved_at: new Date().toISOString(),\n };\n const result2 = await sendToCompany(payload);\n let status = \"failed\";\n if (result2.ok) {\n status = \"sent\";\n sent++;\n } else if (result2.reason === \"no-endpoint\") {\n status = \"sent-locally\";\n localOnly++;\n } else {\n failed++;\n }\n await sqlite.execute(`UPDATE orders SET status=?, approved_at=? WHERE id=?`, [\n status,\n payload.approved_at,\n row.id,\n ]);\n }\n return Response.json({ sent, localOnly, failed });\n }\n\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 = String.raw`\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 is wrong, then approve.

\n Loading…\n

\n \n

\n\n

Sent / Recent

Nothing yet.

\n\n\n\n

Bulk Import

New Order (manual)

Review Queue Refresh

Sent / Recent

Company Endpoint

Review Queue

Code