[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_193":194,"_195":196},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_145":-5,"_20":146,"_22":147,"_148":149,"_150":151,"_25":152,"_24":-5,"_153":-5,"_154":-5,"_155":55,"_156":157,"_158":46,"_159":-5,"_160":-5,"_161":162},"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-agent2","branchName","main","version","path","","project",{"_35":88,"_13":14,"_47":89,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":19,"_96":-5,"_97":98,"_99":39,"_100":46,"_101":-5,"_102":-5,"_103":72,"_104":105,"_106":107,"_108":109,"_110":111,"_112":-5,"_113":114,"_115":114,"_116":117,"_118":117,"_119":117,"_120":114,"_121":114,"_122":123,"_124":125,"_126":127,"_128":55},"tree",[75,76,77],"file","contents",[32,33,34],"upstream","pull","ahead","behind","envVars",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":73,"_52":-5,"_54":55,"_56":-5,"_18":74},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","c492db90-69e9-40f6-a18f-eb88d7b271d6","main.ts","fileId","5f63c458-802f-11f1-8d9b-1607ee4eb77e","parentId","branchId","58a53d6a-c024-4ec6-82de-34756b05d3f9","branchVersion",30,"latest",true,"createdAt",["D",1784265033349],14,"fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\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\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 result = await sqlite.execute(`SELECT key, value FROM settings`);\n const cfg: Record = {};\n for (const row of result.rows as any[]) {\n cfg[row.key as string] = row.value as string;\n }\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 (\n parts[0] === \"api\" && parts[1] === \"queue\" && parts[2] &&\n req.method === \"PATCH\"\n ) {\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 (\n parts[0] === \"api\" && parts[1] === \"queue\" && parts[2] &&\n req.method === \"DELETE\"\n ) {\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(\n `SELECT * FROM orders WHERE status = 'queued' ORDER BY id ASC`,\n );\n const rows = result.rows as any[];\n if (rows.length === 0) {\n return Response.json({ sent: 0, localOnly: 0, failed: 0, errorMsg: \"\" });\n }\n\n const approvedAt = new Date().toISOString();\n let labelsHtml = \"\";\n for (const row of rows) {\n labelsHtml +=\n '

' +\n '

Order No :- ' +\n (row.order_id || \"\") + \"

\" +\n (row.subject\n ? '

Sub :- ' +\n row.subject + \"

\"\n : \"\") +\n '

' +\n '

' +\n (row.to_name || \"\") + \"

\" +\n (row.address\n ? '

' +\n row.address + \"

\"\n : \"\") +\n '

' +\n (row.city ? \"City :- \" + row.city + \" \" : \"\") +\n (row.pincode ? \"Pincode :- \" + row.pincode : \"\") +\n \"

\" +\n (row.state\n ? '

State :- ' +\n row.state + \"

\"\n : \"\") +\n (row.phone\n ? '

Phone No :- ' +\n row.phone + \"

\"\n : \"\") +\n \"

\";\n }\n const html = \"

\" + rows.length + \" Approved Label(s)

\" +\n \"

Forward this to the company, or save/print each label below.

\" +\n labelsHtml;\n\n let sent = 0, failed = 0, errorMsg = \"\";\n try {\n await email({ subject: rows.length + \" approved order label(s)\", html });\n sent = rows.length;\n } catch (e) {\n failed = rows.length;\n errorMsg = String(e);\n }\n\n for (const row of rows) {\n await sqlite.execute(\n `UPDATE orders SET status=?, approved_at=? WHERE id=?`,\n [\n sent ? \"sent\" : \"failed\",\n approvedAt,\n row.id,\n ],\n );\n }\n return Response.json({ sent, localOnly: 0, failed, errorMsg });\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

Upload sheet → Auto-generated → Review → Approve All

\n \n

\n\n

Bulk Import

Upload a CSV or Excel file. 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 upload. Fix anything that is wrong, then approve.

\n Loading…\n

\n \n

\n\n

Sent / Recent

Nothing yet.

\n\n\n\n\n\n`;","deleted",false,"label",[37],"9eb621a6-268f-4fa1-80ea-580afea5e02a","emailImport.ts","d7d98dbc-8031-11f1-8d4e-1607ee4eb77e",19,["D",1784108781581],4,"email","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport * as XLSX from \"https://esm.sh/xlsx@0.18.5\";\n\nconst FIELD_ALIASES: Record = {\n order_id: [\"orderno\", \"order_no\", \"orderid\", \"order_id\", \"order\"],\n subject: [\"sub\", \"subject\", \"description\", \"desc\"],\n to_name: [\"to\", \"name\", \"customer\", \"customername\", \"customer_name\"],\n address: [\"address\", \"addr\"],\n city: [\"city\"],\n pincode: [\"pincode\", \"pin\", \"zip\", \"zipcode\", \"postalcode\"],\n state: [\"state\"],\n phone: [\n \"phone\",\n \"phoneno\",\n \"phone_no\",\n \"mobile\",\n \"contact\",\n \"contactno\",\n \"phonenumber\",\n ],\n};\n\nfunction normalizeHeader(h: string) {\n return String(h).toLowerCase().replace(/[^a-z0-9]/g, \"\");\n}\n\nfunction mapRow(row: Record) {\n const out: Record = {\n order_id: \"\",\n subject: \"\",\n to_name: \"\",\n address: \"\",\n city: \"\",\n pincode: \"\",\n state: \"\",\n phone: \"\",\n };\n const normEntries = Object.keys(row).map((k) =>\n [normalizeHeader(k), row[k]] as [string, any]\n );\n for (const field in FIELD_ALIASES) {\n for (const alias of FIELD_ALIASES[field]) {\n const found = normEntries.find(([nk]) => nk === alias);\n if (found && String(found[1]).trim() !== \"\") {\n out[field] = String(found[1]).trim();\n break;\n }\n }\n }\n return out;\n}\n\nexport default async function (email: any) {\n await 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\n for (const file of email.attachments || []) {\n const name = (file.name || \"\").toLowerCase();\n if (\n !name.endsWith(\".xlsx\") && !name.endsWith(\".xls\") &&\n !name.endsWith(\".csv\")\n ) continue;\n\n const buf = await file.arrayBuffer();\n const wb = XLSX.read(buf, { type: \"array\" });\n const sheet = wb.Sheets[wb.SheetNames[0]];\n const rows = XLSX.utils.sheet_to_json(sheet, { defval: \"\" });\n\n for (const row of rows) {\n const m = mapRow(row as Record);\n if (!m.order_id) continue;\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', 'email', ?)`,\n [\n m.order_id,\n m.subject,\n m.to_name,\n m.address,\n m.city,\n m.pincode,\n m.state,\n m.phone,\n new Date().toISOString(),\n ],\n );\n }\n }\n}",[59],"eafb84e1-8a75-41c0-8dae-cbb486d40106","untitled-folder-927","d73b25e2-8030-11f1-b5de-1607ee4eb77e",7,["D",1784108268287],0,"directory",[68],{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":73,"_52":-5,"_54":55,"_56":-5,"_79":86,"_18":87},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":83,"_18":84},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":80,"_18":81},["D",1784265033349],"children",[],[37],["D",1784108781581],[],[59],["D",1784108268287],[],[68],"d22e6ac4-540c-4305-bd93-438de58801a1",["D",1784107637713],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","b06013a6-81b3-49dd-80cf-634d329e0e67","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f453e-0d63-723f-98e1-1ec926ebd78e","tursoName","d22e6ac4540c4305bd93438de58801a1","tursoHostname","d22e6ac4540c4305bd93438de58801a1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525843977],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_144":140},"org",{"_11":12,"_137":138,"_139":140,"_97":98,"_141":142,"_143":55},"branch",{"_17":44,"_13":16,"_35":42,"_129":88,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Pranav Jawale","avatar","https://lh3.googleusercontent.com/a/ACg8ocLX5l6cRGJzG_8cO8o0z7FAiO7O8oLS4HKggBrqERpW3xDe6A=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":88,"_13":14,"_47":188,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":19,"_96":-5,"_97":98,"_99":39,"_100":46,"_101":-5,"_102":-5,"_103":72,"_104":105,"_106":107,"_108":109,"_110":189,"_112":-5,"_113":114,"_115":114,"_116":117,"_118":117,"_119":117,"_120":114,"_121":114,"_122":190,"_124":191,"_126":192,"_128":55},[179,180,181],"files",[179,180,181],"counts",{"_169":72,"_170":171,"_172":72,"_31":173,"_174":175},[163,164,165],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":73,"_52":-5,"_54":55,"_56":-5,"_18":168},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_18":167},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":166},[37],[59],[68],"pulls","branches",1,"forks",{"_176":72,"_178":72},"connections",{"_176":72,"_177":72},"count","unfilledCount","emptyCount",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":73,"_52":-5,"_54":55,"_56":-5,"_79":186,"_18":187},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":184,"_18":185},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":182,"_18":183},[],[37],[],[59],[],[68],["D",1784107637713],["D",1789525843977],{"_11":12,"_144":140},{"_11":12,"_137":138,"_139":140,"_97":98,"_141":142,"_143":55},{"_17":44,"_13":16,"_35":42,"_129":88,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"ctx",{"_122":-5,"_160":226,"_227":228,"_229":230,"_231":55,"_232":55,"_233":55,"_234":46,"_235":-5,"_236":-7,"_237":-7,"_238":72,"_239":55,"_240":55,"_241":-5,"_242":55,"_243":55,"_244":55,"_245":-5},"ENV",{"_197":198,"_199":200,"_201":16,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225},"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"]

\" + rows.length + \" Approved Label(s)

Bulk Import

New Order (manual)

Review Queue Refresh

Sent / Recent

Company Endpoint

Review Queue

Code