Add Shipment

[{"_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",{"_97":96,"_32":45,"_106":87,"_27":53,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"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",13,"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","7a1cfe08-76c6-11f1-9335-1607ee4eb77e","name","fileType","http","content","/**\n * The Artsy Home — Order Tracking (Val Town version)\n * Looks up by Order ID only, using our own saved shipment list.\n */\n\nimport sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst ALLOWED_ORIGIN = \"https://theartsyhome.pk\";\nconst POSTEX_BASE = \"https://api.postex.pk/services/integration/api/order/v1\";\n\nconst POSTEX_STATUS_LABELS = {\n \"Unbooked\": \"✅ Order Confirmed — Preparing for Shipment\",\n \"Booked\": \"📦 Booked with Courier\",\n \"PostEx WareHouse\": \"🟡 In Transit\",\n \"Picked By PostEx\": \"🟡 In Transit\",\n \"En-Route to PostEx warehouse\": \"🟡 In Transit\",\n \"Out For Delivery\": \"🔵 Out for Delivery\",\n \"Delivered\": \"🟢 Delivered\",\n \"Attempted\": \"🔴 Delivery Attempted\",\n \"Delivery Under Review\": \"🔴 Delivery Under Review\",\n \"Returned\": \"↩️ Returned\",\n \"Out For Return\": \"↩️ Being Returned\",\n \"Un-Assigned By Me\": \"📦 Preparing Shipment\",\n \"Expired\": \"🔴 Delivery Issue\",\n};\n\nconst NOT_FOUND_MESSAGE =\n \"We couldn't find that order number. Please double-check and try again, or contact us on WhatsApp.\";\n\nfunction cors() {\n return {\n \"Access-Control-Allow-Origin\": ALLOWED_ORIGIN,\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n}\n\nfunction json(body, status = 200) {\n return new Response(JSON.stringify(body), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...cors() },\n });\n}\n\nfunction html(body, status = 200) {\n return new Response(body, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction normalizeOrderRef(ref) {\n return (ref || \"\").replace(/[^a-zA-Z0-9]/g, \"\").toLowerCase();\n}\n\nasync function ensureTable() {\n await sqlite.execute({\n sql: `CREATE TABLE IF NOT EXISTS shipments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_ref TEXT,\n order_ref_key TEXT,\n tracking_number TEXT,\n created_at TEXT\n )`,\n args: [],\n });\n // Patches an older version of this table that didn't have this column.\n // Safe to run every time — does nothing once the column already exists.\n try {\n await sqlite.execute({\n sql: `ALTER TABLE shipments ADD COLUMN order_ref_key TEXT`,\n args: [],\n });\n } catch {\n // Already there — fine.\n }\n}\n\nasync function saveShipment({ orderRef, trackingNumber }) {\n await ensureTable();\n await sqlite.execute({\n sql:\n `INSERT INTO shipments (order_ref, order_ref_key, tracking_number, created_at)\n VALUES (?, ?, ?, ?)`,\n args: [\n orderRef,\n normalizeOrderRef(orderRef),\n trackingNumber,\n new Date().toISOString(),\n ],\n });\n}\n\nasync function findShipmentByOrderRef(orderRef) {\n await ensureTable();\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM shipments WHERE order_ref_key = ? ORDER BY created_at DESC LIMIT 1`,\n args: [normalizeOrderRef(orderRef)],\n });\n return result.rows[0] || null;\n}\n\nasync function recentShipments() {\n await ensureTable();\n const result = await sqlite.execute({\n sql: `SELECT * FROM shipments ORDER BY created_at DESC LIMIT 20`,\n args: [],\n });\n return result.rows;\n}\n\nasync function fetchPostExStatus(trackingNumber) {\n const token = Deno.env.get(\"POSTEX_API_TOKEN\");\n if (!token || !trackingNumber) return null;\n\n const url = `${POSTEX_BASE}/track-order/${\n encodeURIComponent(trackingNumber)\n }`;\n\n try {\n const res = await fetch(url, { method: \"GET\", headers: { token } });\n if (!res.ok) return null;\n const data = await res.json();\n const status = data?.dist?.transactionStatus;\n if (!status) return null;\n return { label: POSTEX_STATUS_LABELS[status] || `🚚 ${status}` };\n } catch {\n return null;\n }\n}\n\nfunction adminFormPage(rows, message) {\n const rowsHtml = rows.map((r) => `\n \n ${\n r.order_ref || \"\"\n }\n ${\n r.tracking_number || \"\"\n }\n \n `).join(\"\");\n\n return `\n\n\n \n Add Shipment — The Artsy Home\n\n\n

\n ${\n message\n ? `

${message}

`\n : \"\"\n }\n \n\n

Recently Added

\n \n \n \n \n \n ${\n rowsHtml ||\n ``\n }\n

Order ID	Tracking Number
No entries yet

\n\n`;\n}\n\nexport default async function (req) {\n const reqUrl = new URL(req.url);\n const isAdmin = reqUrl.searchParams.has(\"admin\");\n\n if (req.method === \"GET\" && isAdmin) {\n try {\n const rows = await recentShipments();\n return html(adminFormPage(rows, null));\n } catch (err) {\n return html(\n adminFormPage([], \"Error loading: \" + String(err?.message || err)),\n );\n }\n }\n\n if (req.method === \"POST\" && isAdmin) {\n try {\n const form = await req.formData();\n const pin = form.get(\"pin\");\n if (pin !== Deno.env.get(\"ADMIN_PIN\")) {\n const rows = await recentShipments();\n return html(adminFormPage(rows, \"❌ Wrong PIN — nothing was saved.\"));\n }\n await saveShipment({\n orderRef: form.get(\"orderRef\"),\n trackingNumber: form.get(\"trackingNumber\"),\n });\n const rows = await recentShipments();\n return html(adminFormPage(rows, \"✅ Saved!\"));\n } catch (err) {\n return html(\n adminFormPage([], \"Error saving: \" + String(err?.message || err)),\n );\n }\n }\n\n if (req.method === \"GET\") {\n return new Response(\"OK\", { headers: { \"Content-Type\": \"text/plain\" } });\n }\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: cors() });\n }\n if (req.method !== \"POST\") {\n return json({ error: \"Method not allowed\" }, 405);\n }\n\n let orderId;\n try {\n ({ orderId } = await req.json());\n } catch {\n return json({ error: \"Invalid request.\" }, 400);\n }\n\n if (!orderId) {\n return json({ error: \"Order number is required.\" }, 400);\n }\n\n let shipment;\n try {\n shipment = await findShipmentByOrderRef(orderId);\n } catch (err) {\n return json({\n error: \"Something went wrong. Please try again.\",\n debug: String(err?.message || err),\n }, 500);\n }\n\n if (!shipment) {\n return json({ error: NOT_FOUND_MESSAGE }, 404);\n }\n\n let statusLabel = \"✅ Order Confirmed — Preparing for Shipment\";\n const postExStatus = await fetchPostExStatus(shipment.tracking_number);\n if (postExStatus?.label) statusLabel = postExStatus.label;\n\n return json({\n customerName: null,\n orderName: shipment.order_ref,\n status: statusLabel,\n estimatedDeliveryAt: null,\n deliveredAt: null,\n tracking: {\n number: shipment.tracking_number,\n url: null,\n company: \"PostEx\",\n },\n statusPageUrl: null,\n });\n}","/**\n * The Artsy Home — Order Tracking (Val Town version)\n * Looks up by Order ID only. Returns full PostEx timeline.\n */\n\nimport sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst ALLOWED_ORIGIN = \"https://theartsyhome.pk\";\nconst POSTEX_BASE = \"https://api.postex.pk/services/integration/api/order/v1\";\n\nconst POSTEX_STATUS_LABELS = {\n \"Unbooked\": \"✅ Order Confirmed — Preparing for Shipment\",\n \"Booked\": \"📦 Booked with Courier\",\n \"PostEx WareHouse\": \"🟡 In Transit\",\n \"Picked By PostEx\": \"🟡 In Transit\",\n \"En-Route to PostEx warehouse\": \"🟡 In Transit\",\n \"Out For Delivery\": \"🔵 Out for Delivery\",\n \"Delivered\": \"🟢 Delivered\",\n \"Attempted\": \"🔴 Delivery Attempted\",\n \"Delivery Under Review\": \"🔴 Delivery Under Review\",\n \"Returned\": \"↩️ Returned\",\n \"Out For Return\": \"↩️ Being Returned\",\n \"Un-Assigned By Me\": \"📦 Preparing Shipment\",\n \"Expired\": \"🔴 Delivery Issue\",\n};\n\nconst NOT_FOUND_MESSAGE =\n \"We couldn't find that order number. Please double-check and try again, or contact us on WhatsApp.\";\n\nfunction cors() {\n return {\n \"Access-Control-Allow-Origin\": ALLOWED_ORIGIN,\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n}\n\nfunction json(body, status = 200) {\n return new Response(JSON.stringify(body), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...cors() },\n });\n}\n\nfunction html(body, status = 200) {\n return new Response(body, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction normalizeOrderRef(ref) {\n return (ref || \"\").replace(/[^a-zA-Z0-9]/g, \"\").toLowerCase();\n}\n\nfunction timelineIcon(message) {\n const m = (message || \"\").toLowerCase();\n if (m.includes(\"deliver\")) return \"🟢\";\n if (m.includes(\"return\")) return \"↩️\";\n if (m.includes(\"attempt\")) return \"🔴\";\n if (m.includes(\"out for\") || m.includes(\"route\")) return \"🔵\";\n if (m.includes(\"transit\") || m.includes(\"warehouse\") || m.includes(\"hub\")) {\n return \"🟡\";\n }\n return \"📦\";\n}\n\nasync function ensureTable() {\n await sqlite.execute({\n sql: `CREATE TABLE IF NOT EXISTS shipments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_ref TEXT,\n order_ref_key TEXT,\n tracking_number TEXT,\n created_at TEXT\n )`,\n args: [],\n });\n try {\n await sqlite.execute({\n sql: `ALTER TABLE shipments ADD COLUMN order_ref_key TEXT`,\n args: [],\n });\n } catch {}\n}\n\nasync function saveShipment({ orderRef, trackingNumber }) {\n await ensureTable();\n await sqlite.execute({\n sql:\n `INSERT INTO shipments (order_ref, order_ref_key, tracking_number, created_at)\n VALUES (?, ?, ?, ?)`,\n args: [\n orderRef,\n normalizeOrderRef(orderRef),\n trackingNumber,\n new Date().toISOString(),\n ],\n });\n}\n\nasync function findShipmentByOrderRef(orderRef) {\n await ensureTable();\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM shipments WHERE order_ref_key = ? ORDER BY created_at DESC LIMIT 1`,\n args: [normalizeOrderRef(orderRef)],\n });\n return result.rows[0] || null;\n}\n\nasync function recentShipments() {\n await ensureTable();\n const result = await sqlite.execute({\n sql: `SELECT * FROM shipments ORDER BY created_at DESC LIMIT 20`,\n args: [],\n });\n return result.rows;\n}\n\nasync function fetchPostExDetails(trackingNumber) {\n const token = Deno.env.get(\"POSTEX_API_TOKEN\");\n if (!token || !trackingNumber) return null;\n\n const url = `${POSTEX_BASE}/track-order/${\n encodeURIComponent(trackingNumber)\n }`;\n\n try {\n const res = await fetch(url, { method: \"GET\", headers: { token } });\n if (!res.ok) return null;\n const data = await res.json();\n const dist = data?.dist;\n if (!dist) return null;\n\n const history = Array.isArray(dist.transactionStatusHistory)\n ? dist.transactionStatusHistory.map((h) => ({\n label: h.transactionStatusMessage,\n icon: timelineIcon(h.transactionStatusMessage),\n time: h.createDatetime || null,\n }))\n : [];\n\n return {\n label: POSTEX_STATUS_LABELS[dist.transactionStatus] ||\n (dist.transactionStatus ? `🚚 ${dist.transactionStatus}` : null),\n trackingNumber: dist.trackingNumber || trackingNumber,\n history,\n };\n } catch {\n return null;\n }\n}\n\nfunction adminFormPage(rows, message) {\n const rowsHtml = rows.map((r) => `\n \n ${\n r.order_ref || \"\"\n }\n ${\n r.tracking_number || \"\"\n }\n \n `).join(\"\");\n\n return `\n\n\n \n Add Shipment — The Artsy Home\n\n\n

Add Shipment

\n ${\n message\n ? `

${message}

`\n : \"\"\n }\n \n\n

Recently Added

\n \n \n \n \n \n ${\n rowsHtml ||\n ``\n }\n

Order ID	Tracking Number
No entries yet

\n\n`;\n}\n\nexport default async function (req) {\n const reqUrl = new URL(req.url);\n const isAdmin = reqUrl.searchParams.has(\"admin\");\n\n if (req.method === \"GET\" && isAdmin) {\n try {\n const rows = await recentShipments();\n return html(adminFormPage(rows, null));\n } catch (err) {\n return html(\n adminFormPage([], \"Error loading: \" + String(err?.message || err)),\n );\n }\n }\n\n if (req.method === \"POST\" && isAdmin) {\n try {\n const form = await req.formData();\n const pin = form.get(\"pin\");\n if (pin !== Deno.env.get(\"ADMIN_PIN\")) {\n const rows = await recentShipments();\n return html(adminFormPage(rows, \"❌ Wrong PIN — nothing was saved.\"));\n }\n await saveShipment({\n orderRef: form.get(\"orderRef\"),\n trackingNumber: form.get(\"trackingNumber\"),\n });\n const rows = await recentShipments();\n return html(adminFormPage(rows, \"✅ Saved!\"));\n } catch (err) {\n return html(\n adminFormPage([], \"Error saving: \" + String(err?.message || err)),\n );\n }\n }\n\n if (req.method === \"GET\") {\n return new Response(\"OK\", { headers: { \"Content-Type\": \"text/plain\" } });\n }\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: cors() });\n }\n if (req.method !== \"POST\") {\n return json({ error: \"Method not allowed\" }, 405);\n }\n\n let orderId;\n try {\n ({ orderId } = await req.json());\n } catch {\n return json({ error: \"Invalid request.\" }, 400);\n }\n\n if (!orderId) {\n return json({ error: \"Order number is required.\" }, 400);\n }\n\n let shipment;\n try {\n shipment = await findShipmentByOrderRef(orderId);\n } catch (err) {\n return json({\n error: \"Something went wrong. Please try again.\",\n debug: String(err?.message || err),\n }, 500);\n }\n\n if (!shipment) {\n return json({ error: NOT_FOUND_MESSAGE }, 404);\n }\n\n const details = await fetchPostExDetails(shipment.tracking_number);\n const statusLabel = details?.label ||\n \"✅ Order Confirmed — Preparing for Shipment\";\n\n return json({\n orderId: shipment.order_ref,\n trackingNumber: shipment.tracking_number,\n courier: \"PostEx\",\n status: statusLabel,\n lastUpdated: new Date().toISOString(),\n timeline: details?.history || [],\n });\n}","createdAt",["D",1783103820315],"branchVersion","branchId","b5c92e09-c509-4a7f-9ca9-37b043898675","id","190a7806-167c-4323-bd61-870f8b0ead6b","artsy-home-track-order",["D",1783073024914],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","39d983a7-5545-4419-9a36-09c45a00d620","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f276a-b7b0-713f-8a05-077debe64b9c","tursoName","190a7806167c4323bd61870f8b0ead6b","tursoHostname","190a7806167c4323bd61870f8b0ead6b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789521640046],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","alnoorfurniture","handle","displayName","Alnoor furniture","avatar","https://lh3.googleusercontent.com/a/ACg8ocJC0quSY5IOAYi5gGtxRGhh7gUfIhGabSly0ZQ8r0hQQVp03xY2=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_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":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":123,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"ace0ead9-eb43-469e-b5ba-ee795420cabb","parentId","latest",["D",1783103820315],12,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":146,"_147":61},"connections",{"_144":61,"_145":61},"count","unfilledCount",5,"emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":123,"_38":149,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_150":151,"_27":152},["D",1783103820315],"children",[],[28],["D",1783073024914],["D",1789521640046],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_80":-5,"_125":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":123,"_200":-5,"_201":-7,"_202":-7,"_203":61,"_204":25,"_205":25,"_206":-5,"_207":25,"_208":25,"_209":25,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":87,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"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"]

Diff · v13