' +\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`;","children",[],[58],"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}",[],[69],["D",1784108268287],[],[19],"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",1789438866375],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_138":134},"org",{"_11":12,"_131":132,"_133":134,"_91":92,"_135":136,"_137":51},"branch",{"_17":60,"_13":16,"_33":39,"_123":81,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":14,"_130":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",{"_33":81,"_13":14,"_44":178,"_83":-5,"_84":51,"_85":86,"_87":86,"_88":89,"_90":-5,"_91":92,"_93":59,"_94":43,"_95":-5,"_96":-5,"_97":46,"_98":99,"_100":101,"_102":103,"_104":179,"_106":-5,"_107":108,"_109":108,"_110":111,"_112":111,"_113":111,"_114":108,"_115":108,"_116":180,"_118":181,"_120":182,"_122":51},[169,170,171],"files",[169,170,171],"counts",{"_159":46,"_160":161,"_162":46,"_32":163,"_164":165},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":-5,"_50":51,"_52":-5,"_18":158},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_166":46,"_168":46},"connections",{"_166":46,"_167":46},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":78,"_17":46,"_47":48,"_49":-5,"_50":51,"_52":-5,"_65":176,"_18":177},{"_33":68,"_13":69,"_35":70,"_37":-5,"_38":39,"_40":71,"_42":43,"_44":72,"_17":73,"_47":74,"_49":75,"_50":51,"_52":-5,"_65":174,"_18":175},{"_33":57,"_13":58,"_35":59,"_37":-5,"_38":39,"_40":60,"_42":43,"_44":61,"_17":62,"_47":63,"_49":64,"_50":51,"_52":-5,"_65":172,"_18":173},[],[58],[],[69],[],[19],["D",1784107637713],["D",1789438866375],{"_11":12,"_138":134},{"_11":12,"_131":132,"_133":134,"_91":92,"_135":136,"_137":51},{"_17":60,"_13":16,"_33":39,"_123":81,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":14,"_130":12},"ctx",{"_116":-5,"_155":216,"_217":218,"_219":220,"_221":51,"_222":51,"_223":51,"_224":43,"_225":-5,"_226":-7,"_227":-7,"_228":46,"_229":51,"_230":51,"_231":-5,"_232":51,"_233":51,"_234":51,"_235":-5},"ENV",{"_187":188,"_189":190,"_191":16,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215},"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