[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_300":301,"_302":303},"routes/_app.x.$handle.$name",{"_111":110,"_38":51,"_120":97,"_33":121,"_13":14,"_122":-5,"_11":123,"_124":125,"_126":127,"_128":129,"_130":131,"_26":-5,"_132":133,"_134":135,"_136":31,"_137":138,"_139":66,"_140":-5,"_141":-5,"_142":143},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":78,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",6,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5309cf6c-8fa9-4b3d-931b-a60143ec0fcb","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","scan-gmail.ts","latestPath","fileId","a4ff0bde-7d6a-11f1-8d57-1607ee4eb77e","name","fileType","interval","content","import { scanGmail } from \"./gmail.ts\";\nimport { getOrdersForConfirmation } from \"./db.ts\";\nimport { sendConfirmationEmails } from \"./send-confirmation-email.ts\";\n\nexport default async function (interval: Interval) {\n console.log(`🔄 Gmail scan started at ${new Date().toISOString()}`);\n console.log(` Last run: ${interval.lastRunAt ?? \"first run\"}`);\n\n // Step 1: Scan Gmail for new order/shipping emails\n const scanResult = await scanGmail();\n console.log(` Scan result:`, scanResult);\n\n // Step 2: Send confirmation emails for packages that should have arrived\n if (scanResult.error === null) {\n const pendingOrders = await getOrdersForConfirmation();\n if (pendingOrders.length > 0) {\n console.log(`📬 Sending confirmation emails for ${pendingOrders.length} packages`);\n await sendConfirmationEmails(pendingOrders);\n } else {\n console.log(\"✅ No packages pending confirmation\");\n }\n }\n\n console.log(`✅ Done at ${new Date().toISOString()}`);\n}\n","import { scanGmail } from \"./gmail.ts\";\nimport { getOrdersForConfirmation } from \"./db.ts\";\nimport { sendConfirmationEmails } from \"./send-confirmation-email.ts\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport default async function (interval: Interval) {\n console.log(`🔄 Gmail scan started at ${new Date().toISOString()}`);\n console.log(` Last run: ${interval.lastRunAt ?? \"first run\"}`);\n\n // Step 1: Scan Gmail for new order/shipping emails\n const scanResult = await scanGmail();\n console.log(` Scan result:`, scanResult);\n\n // Step 2: Send confirmation emails for packages that should have arrived\n if (scanResult.error === null) {\n const pendingOrders = await getOrdersForConfirmation();\n if (pendingOrders.length > 0) {\n console.log(`📬 Sending confirmation emails for ${pendingOrders.length} packages`);\n const baseUrl = httpEndpoint(\"./index.ts\");\n await sendConfirmationEmails(pendingOrders, baseUrl);\n } else {\n console.log(\"✅ No packages pending confirmation\");\n }\n }\n\n console.log(`✅ Done at ${new Date().toISOString()}`);\n}\n","createdAt",["D",1783803269182],"branchVersion","branchId","31d32e2d-7e5f-4d55-b267-dc6b8c48ab98","id","b59279da-d98a-4e6c-8850-d4254db64611","order-tracker",["D",1783803158516],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track orders, shipping, arrival dates in a calendar","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789545599&sig=91cfcc631bd9f3dd8274549c04838d172adf2572755982193460d49bfd04bd62","bf338674-fda8-4a0e-8fad-7b37cb5cc983","pinnedFileId","019f52f4-2036-751f-8749-2fa9c3c7813a","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f52e9-adf8-77fb-83e8-d6c15967a23c","tursoName","b59279dad98a4e6c8850d4254db64611","tursoHostname","b59279dad98a4e6c8850d4254db64611-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_111":110,"_119":115},"org",{"_111":110,"_112":113,"_114":115,"_19":62,"_116":117,"_118":31},"branch",{"_13":96,"_38":97,"_49":48,"_98":50,"_99":100,"_101":102,"_103":56,"_104":105,"_106":107,"_108":51,"_109":110},"isOwned",15,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","adoran","handle","displayName","Adora N","avatar","https://lh3.googleusercontent.com/a/ACg8ocLX491kPKV6up_39D9RfH3dFN86Q-HlPoXrfwv86VqwOhgDlQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":295,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":296,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":297,"_91":298,"_93":299,"_95":31},"tree",[219,226,227,228,229,230,231],"files",[219,220,221,222,223,224,225,226,227,228,229,230,231],"counts",{"_209":70,"_210":175,"_211":70,"_212":213,"_214":215},"contents",[155,156,157,158,159,160,161],"upstreamProject",{"_49":105,"_38":151,"_58":152,"_60":61,"_55":56,"_89":153},"upstreamBranch",{"_49":100,"_44":144,"_145":146,"_38":97,"_98":105,"_13":147,"_99":-5,"_101":-5,"_148":149,"_53":-5,"_95":31,"_55":56,"_109":150,"_71":107,"_108":151},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","Starter template with client-side React & Hono server",{"_111":150,"_119":154},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789545599&sig=2316df07e67031dd48e537f6ce0c4c14b92716fed790ec83ecf27974cc65aa31",{"_49":203,"_38":204,"_36":205,"_165":-5,"_47":48,"_46":175,"_167":66,"_44":206,"_13":70,"_39":207,"_41":-5,"_30":31,"_171":-5,"_33":208},{"_49":197,"_38":198,"_36":199,"_165":-5,"_47":48,"_46":175,"_167":31,"_44":200,"_13":70,"_39":26,"_41":201,"_30":31,"_171":-5,"_33":202},{"_49":190,"_38":191,"_36":192,"_165":-5,"_47":48,"_46":193,"_167":66,"_44":194,"_13":70,"_39":169,"_41":195,"_30":31,"_171":-5,"_33":196},{"_49":183,"_38":184,"_36":185,"_165":-5,"_47":48,"_46":186,"_167":66,"_44":187,"_13":70,"_39":169,"_41":188,"_30":31,"_171":-5,"_33":189},{"_49":177,"_38":178,"_36":64,"_165":-5,"_47":48,"_46":175,"_167":31,"_44":179,"_13":70,"_39":180,"_41":181,"_30":31,"_171":-5,"_33":182},{"_49":173,"_38":34,"_36":37,"_165":-5,"_47":48,"_46":14,"_167":66,"_44":174,"_13":175,"_39":40,"_41":43,"_30":31,"_171":-5,"_33":176},{"_49":162,"_38":163,"_36":164,"_165":-5,"_47":48,"_46":166,"_167":31,"_44":168,"_13":70,"_39":169,"_41":170,"_30":31,"_171":-5,"_33":172},"7fa98afa-dbf0-43c9-b26e-7bb30e52544c","send-confirmation-email.ts","a504a22e-7d6a-11f1-946e-1607ee4eb77e","parentId",5,"latest",["D",1783803241330],"script","import nodemailer from \"npm:nodemailer\";\nimport { confirmOrder } from \"./db.ts\";\n\nfunction getTransporter() {\n const gmailUser = Deno.env.get(\"GMAIL_USER\");\n const gmailPass = Deno.env.get(\"GMAIL_PASS\");\n\n if (!gmailUser || !gmailPass) {\n throw new Error(\"GMAIL_USER and GMAIL_PASS environment variables are required\");\n }\n\n return nodemailer.createTransport({\n service: \"gmail\",\n auth: { user: gmailUser, pass: gmailPass },\n });\n}\n\nexport async function sendConfirmationEmails(orders: any[]) {\n const gmailUser = Deno.env.get(\"GMAIL_USER\");\n if (!gmailUser) return;\n\n const transporter = getTransporter();\n\n for (const order of orders) {\n try {\n const confirmUrl = `${Deno.env.get(\"VAL_TOWN_HOST\") ?? \"https://adoran-order-tracker.web.val.run\"}/api/orders/${order.id}/confirm`;\n\n await transporter.sendMail({\n from: gmailUser,\n to: gmailUser,\n subject: `📦 Did you receive your ${order.retailer} package?`,\n text: `Hi there!\n\nWe noticed your package from ${order.retailer} should have arrived.\n\nOrder: ${order.subject}\n${order.tracking_number ? `Tracking: ${order.carrier} ${order.tracking_number}` : \"\"}\n${order.estimated_arrival ? `Estimated arrival: ${order.estimated_arrival}` : \"\"}\n\nDid you receive this package?\n✅ Yes, I got it: ${confirmUrl}\n\nIf you haven't received it yet, you can ignore this email — we'll check again later.\n\n— Order Tracker`,\n html: `

📦 Package Confirmation

We noticed your package from ${order.retailer} should have arrived.

\n \n \n ${order.tracking_number ? `` : \"\"}\n ${order.estimated_arrival ? `` : \"\"}\n

Order:	${order.subject}
Tracking:	${order.carrier} ${order.tracking_number}
Est. arrival:	${order.estimated_arrival}

Did you receive this package?

\n ✅ Yes, I got it!\n

If you haven't received it yet, you can ignore this email.

— Order Tracker

`,\n });\n\n console.log(` 📧 Sent confirmation email for order #${order.id} (${order.retailer})`);\n } catch (error) {\n console.error(` ❌ Failed to send email for order #${order.id}:`, error);\n }\n }\n}\n","label",[163],"79d3b1c2-04c6-49fb-aa02-0d52323cb4bc",["D",1783803269182],1,[34],"b8afb3b3-f628-407e-a97d-aa3a8679a73a","index.ts",["D",1783803158516],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n",[178],"be66b4da-33c3-472d-9ddc-18286bec8bb3","gmail.ts","99af356a-7d6a-11f1-9710-1607ee4eb77e",3,["D",1783803222305],"import { ImapFlow } from \"npm:imapflow\";\nimport { upsertOrder, getScanState, updateScanState } from \"./db.ts\";\n\n// Search keywords for different email types\nconst ORDER_KEYWORDS = [\"order confirmation\", \"your order\", \"order receipt\", \"purchase confirmation\", \"thank you for your order\", \"order placed\", \"invoice\"];\nconst SHIPPING_KEYWORDS = [\"shipped\", \"shipping update\", \"tracking\", \"dispatched\", \"on the way\", \"out for delivery\", \"in transit\"];\nconst DELIVERY_KEYWORDS = [\"delivered\", \"package arrived\", \"delivery confirmation\", \"has been delivered\"];\n\nconst CARRIER_PATTERNS: { carrier: string; pattern: RegExp }[] = [\n { carrier: \"UPS\", pattern: /\\b(1Z\\s?[A-Z0-9]{3}\\s?[A-Z0-9]{3}\\s?\\d{2}\\s?\\d{4}\\s?\\d{4})\\b/i },\n { carrier: \"FedEx\", pattern: /\\b(\\d{12}|\\d{15}|\\d{20})\\b/ },\n { carrier: \"USPS\", pattern: /\\b(\\d{20,22})\\b/ },\n { carrier: \"DHL\", pattern: /\\b(\\d{10})\\b/i },\n { carrier: \"Amazon\", pattern: /\\b(TBA\\d{12})\\b/i },\n];\n\nconst RETAILER_DOMAINS: Record = {\n \"amazon.com\": \"Amazon\",\n \"amazon.ca\": \"Amazon\",\n \"amazon.co.uk\": \"Amazon\",\n \"ebay.com\": \"eBay\",\n \"etsy.com\": \"Etsy\",\n \"walmart.com\": \"Walmart\",\n \"target.com\": \"Target\",\n \"bestbuy.com\": \"Best Buy\",\n \"homedepot.com\": \"Home Depot\",\n \"lowes.com\": \"Lowe's\",\n \"wayfair.com\": \"Wayfair\",\n \"costco.com\": \"Costco\",\n \"apple.com\": \"Apple\",\n \"shopify.com\": \"Shopify Store\",\n \"paypal.com\": \"PayPal\",\n \"stripe.com\": \"Stripe\",\n \"ups.com\": \"UPS\",\n \"fedex.com\": \"FedEx\",\n \"usps.com\": \"USPS\",\n \"dhl.com\": \"DHL\",\n};\n\nfunction detectEmailType(subject: string, body: string): string {\n const text = (subject + \" \" + body).toLowerCase();\n if (DELIVERY_KEYWORDS.some(k => text.includes(k))) return \"delivery\";\n if (SHIPPING_KEYWORDS.some(k => text.includes(k))) return \"shipping\";\n if (ORDER_KEYWORDS.some(k => text.includes(k))) return \"order\";\n return \"order\"; // default to order\n}\n\nfunction extractTrackingNumber(text: string): { tracking_number: string; carrier: string } | null {\n for (const { carrier, pattern } of CARRIER_PATTERNS) {\n const match = text.match(pattern);\n if (match) {\n return { tracking_number: match[1].replace(/\\s/g, \"\"), carrier };\n }\n }\n return null;\n}\n\nfunction extractRetailer(from: string): string {\n const emailMatch = from.match(/<([^>]+)>/);\n const email = emailMatch ? emailMatch[1] : from;\n const domain = email.split(\"@\")[1]?.toLowerCase() ?? \"\";\n for (const [domainKey, name] of Object.entries(RETAILER_DOMAINS)) {\n if (domain.includes(domainKey)) return name;\n }\n // Try to extract company name from domain\n const parts = domain.split(\".\");\n if (parts.length >= 2) {\n return parts[parts.length - 2].charAt(0).toUpperCase() + parts[parts.length - 2].slice(1);\n }\n return \"Unknown Retailer\";\n}\n\nfunction extractEstimatedArrival(text: string): string | null {\n // Look for delivery date patterns\n const datePatterns = [\n /(?:arriv(?:e|ing|al)|deliver(?:y|ed|s)|expect(?:ed)?)(?:\\s+(?:on|by|between))?\\s+([A-Z][a-z]+ \\d{1,2}(?:,? \\d{4})?)/i,\n /(?:arriv(?:e|ing|al)|deliver(?:y|ed|s)|expect(?:ed)?)(?:\\s+(?:on|by|between))?\\s+(\\d{1,2}\\/\\d{1,2}\\/?\\d{0,4})/i,\n /estimated\\s+(?:delivery|arrival)[:\\s]+([A-Z][a-z]+ \\d{1,2}(?:,? \\d{4})?)/i,\n /estimated\\s+(?:delivery|arrival)[:\\s]+(\\d{1,2}\\/\\d{1,2}\\/?\\d{0,4})/i,\n ];\n\n for (const pattern of datePatterns) {\n const match = text.match(pattern);\n if (match) {\n const dateStr = match[1];\n const parsed = new Date(dateStr);\n if (!isNaN(parsed.getTime())) {\n return parsed.toISOString().split(\"T\")[0];\n }\n // Try adding current year if missing\n const withYear = `${dateStr}, ${new Date().getFullYear()}`;\n const parsedWithYear = new Date(withYear);\n if (!isNaN(parsedWithYear.getTime())) {\n return parsedWithYear.toISOString().split(\"T\")[0];\n }\n }\n }\n return null;\n}\n\nfunction extractOrderTotal(text: string): string | null {\n const patterns = [\n /(?:total|amount|order total)[:\\s]+\\$?(\\d+\\.?\\d{0,2})/i,\n /\\$(\\d{1,4}\\.\\d{2})/,\n ];\n for (const pattern of patterns) {\n const match = text.match(pattern);\n if (match) return `$${match[1]}`;\n }\n return null;\n}\n\nexport async function scanGmail() {\n const gmailUser = Deno.env.get(\"GMAIL_USER\");\n const gmailPass = Deno.env.get(\"GMAIL_PASS\");\n\n if (!gmailUser || !gmailPass) {\n console.log(\"⚠️ Gmail credentials not set. Skipping scan.\");\n console.log(\"Set GMAIL_USER and GMAIL_PASS environment variables.\");\n return { scanned: 0, newOrders: 0, updated: 0, error: \"Missing credentials\" };\n }\n\n const client = new ImapFlow({\n host: \"imap.gmail.com\",\n port: 993,\n secure: true,\n auth: { user: gmailUser, pass: gmailPass },\n logger: false,\n });\n\n try {\n await client.connect();\n await client.mailboxOpen(\"INBOX\");\n\n const state = await getScanState();\n const since = state.last_scan_date\n ? new Date(state.last_scan_date)\n : new Date(Date.now() - 7 * 24 * 60 * 60 * 1000); // Default: last 7 days\n\n const sinceStr = since.toISOString().split(\"T\")[0];\n\n // Search for emails since last scan with order/shipping related subjects\n const searchCriteria = {\n since: since,\n subject: [\"order\", \"shipped\", \"shipping\", \"tracking\", \"delivery\", \"delivered\", \"package\", \"purchase\", \"receipt\", \"invoice\", \"dispatched\", \"confirmation\"],\n };\n\n const messages = await client.search(searchCriteria, { uid: true });\n console.log(`📧 Found ${messages.length} potential order emails since ${sinceStr}`);\n\n let newOrders = 0;\n let updated = 0;\n let maxUid = state.last_message_uid;\n\n for (const uid of messages) {\n if (uid <= state.last_message_uid) continue;\n\n const msg = await client.fetchOne(uid, { envelope: true, source: true, uid: true }, { uid: true });\n if (!msg) continue;\n\n const envelope = msg.envelope;\n const subject = envelope?.subject ?? \"(no subject)\";\n const from = envelope?.from?.[0] ? `${envelope.from[0].name ?? \"\"} <${envelope.from[0].address ?? \"\"}>` : \"unknown\";\n const date = envelope?.date ? new Date(envelope.date).toISOString() : new Date().toISOString();\n const messageId = envelope?.messageId ?? `${uid}-${date}`;\n\n // Parse email body\n const source = msg.source instanceof Uint8Array\n ? new TextDecoder().decode(msg.source)\n : String(msg.source ?? \"\");\n\n // Extract text content (simple: strip HTML tags)\n const bodyText = source\n .replace(/<[^>]*>/g, \" \")\n .replace(/ /g, \" \")\n .replace(/\\s+/g, \" \")\n .trim();\n\n const emailType = detectEmailType(subject, bodyText);\n const tracking = extractTrackingNumber(subject + \" \" + bodyText);\n const retailer = extractRetailer(from);\n const estimatedArrival = extractEstimatedArrival(subject + \" \" + bodyText);\n const orderTotal = extractOrderTotal(bodyText);\n\n const result = await upsertOrder({\n message_id: messageId,\n retailer,\n subject,\n email_date: date,\n email_type: emailType,\n tracking_number: tracking?.tracking_number,\n carrier: tracking?.carrier,\n estimated_arrival: estimatedArrival,\n order_total: orderTotal,\n });\n\n if (result.updated) {\n updated++;\n } else {\n newOrders++;\n }\n\n if (uid > maxUid) maxUid = uid;\n console.log(` ✓ [${emailType}] ${retailer}: ${subject.substring(0, 60)}`);\n }\n\n await updateScanState(new Date().toISOString(), maxUid);\n await client.logout();\n\n console.log(`✅ Scan complete: ${newOrders} new, ${updated} updated`);\n return { scanned: messages.length, newOrders, updated, error: null };\n } catch (error) {\n console.error(\"❌ Gmail scan error:\", error);\n try { await client.logout(); } catch {}\n return { scanned: 0, newOrders: 0, updated: 0, error: String(error) };\n }\n}\n",[184],"99438914-13a8-41d2-a7ca-df3dad4f5f72","db.ts","99a81abe-7d6a-11f1-993d-1607ee4eb77e",2,["D",1783803222304],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Order {\n id: number;\n message_id: string;\n retailer: string;\n subject: string;\n email_date: string;\n email_type: string;\n tracking_number: string | null;\n carrier: string | null;\n estimated_arrival: string | null;\n status: string;\n order_total: string | null;\n items: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT UNIQUE NOT NULL,\n retailer TEXT,\n subject TEXT,\n email_date TEXT,\n email_type TEXT,\n tracking_number TEXT,\n carrier TEXT,\n estimated_arrival TEXT,\n status TEXT DEFAULT 'ordered',\n order_total TEXT,\n items TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS scan_state (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n last_scan_date TEXT,\n last_message_uid INTEGER DEFAULT 0\n )`,\n },\n {\n sql: `INSERT OR IGNORE INTO scan_state (id, last_scan_date, last_message_uid) VALUES (1, NULL, 0)`,\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_orders_status ON orders(status)`,\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_orders_estimated_arrival ON orders(estimated_arrival)`,\n },\n ]);\n}\n\nexport async function upsertOrder(order: {\n message_id: string;\n retailer: string;\n subject: string;\n email_date: string;\n email_type: string;\n tracking_number?: string;\n carrier?: string;\n estimated_arrival?: string;\n order_total?: string;\n items?: string;\n}) {\n // Check if order exists by message_id\n const existing = await sqlite.execute({\n sql: \"SELECT id, status FROM orders WHERE message_id = ?\",\n args: [order.message_id],\n });\n\n if (existing.rows.length > 0) {\n // Update existing order with new info (but don't downgrade status)\n const row = existing.rows[0] as any;\n const statusMap: Record = {\n ordered: 0,\n shipped: 1,\n out_for_delivery: 2,\n delivered: 3,\n confirmed: 4,\n };\n const currentStatusRank = statusMap[row.status] ?? 0;\n const newStatusRank = statusMap[order.email_type === \"delivery\" ? \"delivered\" : order.email_type === \"shipping\" ? \"shipped\" : \"ordered\"] ?? 0;\n const finalStatus = newStatusRank > currentStatusRank\n ? (order.email_type === \"delivery\" ? \"delivered\" : order.email_type === \"shipping\" ? \"shipped\" : row.status)\n : row.status;\n\n await sqlite.execute({\n sql: `UPDATE orders SET\n retailer = COALESCE(?, retailer),\n subject = ?,\n email_date = ?,\n email_type = ?,\n tracking_number = COALESCE(?, tracking_number),\n carrier = COALESCE(?, carrier),\n estimated_arrival = COALESCE(?, estimated_arrival),\n order_total = COALESCE(?, order_total),\n items = COALESCE(?, items),\n status = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n args: [\n order.retailer, order.subject, order.email_date, order.email_type,\n order.tracking_number ?? null, order.carrier ?? null,\n order.estimated_arrival ?? null, order.order_total ?? null,\n order.items ?? null, finalStatus, row.id,\n ],\n });\n return { updated: true, id: row.id };\n }\n\n const status = order.email_type === \"delivery\" ? \"delivered\" : order.email_type === \"shipping\" ? \"shipped\" : \"ordered\";\n const result = await sqlite.execute({\n sql: `INSERT INTO orders (message_id, retailer, subject, email_date, email_type, tracking_number, carrier, estimated_arrival, status, order_total, items)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n order.message_id, order.retailer, order.subject, order.email_date,\n order.email_type, order.tracking_number ?? null, order.carrier ?? null,\n order.estimated_arrival ?? null, status,\n order.order_total ?? null, order.items ?? null,\n ],\n });\n return { updated: false, id: Number(result.lastInsertRowid) };\n}\n\nexport async function getAllOrders(): Promise {\n await initDB();\n const result = await sqlite.execute(\n \"SELECT * FROM orders ORDER BY email_date DESC\"\n );\n return result.rows as unknown as Order[];\n}\n\nexport async function getOrderById(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE id = ?\",\n args: [id],\n });\n return (result.rows[0] as unknown as Order) ?? null;\n}\n\nexport async function confirmOrder(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"UPDATE orders SET status = 'confirmed', updated_at = CURRENT_TIMESTAMP WHERE id = ?\",\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n\nexport async function getOrdersForConfirmation(): Promise {\n // Get orders that are delivered or have an estimated arrival that's today/past\n const today = new Date().toISOString().split(\"T\")[0];\n const result = await sqlite.execute({\n sql: `SELECT * FROM orders\n WHERE status IN ('delivered', 'shipped')\n AND (estimated_arrival IS NOT NULL AND estimated_arrival <= ?)\n AND status != 'confirmed'\n ORDER BY estimated_arrival ASC`,\n args: [today],\n });\n return result.rows as unknown as Order[];\n}\n\nexport async function getScanState() {\n const result = await sqlite.execute(\"SELECT * FROM scan_state WHERE id = 1\");\n return result.rows[0] as { last_scan_date: string | null; last_message_uid: number };\n}\n\nexport async function updateScanState(lastScanDate: string, lastMessageUid: number) {\n await sqlite.execute({\n sql: \"UPDATE scan_state SET last_scan_date = ?, last_message_uid = ? WHERE id = 1\",\n args: [lastScanDate, lastMessageUid],\n });\n}\n\nexport async function getStats() {\n await initDB();\n const total = await sqlite.execute(\"SELECT COUNT(*) as count FROM orders\");\n const byStatus = await sqlite.execute({\n sql: `SELECT status, COUNT(*) as count FROM orders GROUP BY status`,\n });\n const pendingConfirms = await sqlite.execute({\n sql: `SELECT COUNT(*) as count FROM orders WHERE status IN ('delivered', 'shipped') AND status != 'confirmed'`,\n });\n\n return {\n total: (total.rows[0] as any).count,\n byStatus: byStatus.rows.reduce((acc: Record, row: any) => {\n acc[row.status] = row.count;\n return acc;\n }, {}),\n pendingConfirmations: (pendingConfirms.rows[0] as any).count,\n };\n}\n",[191],"8368a079-7fb3-4983-9803-ea235c775747","README.md","019f52f4-2036-751f-8749-2951064acbc7",["D",1783803158516],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[198],"f22c9242-5c2c-44d1-9f97-ac07e49a8df8","frontend","019f52f4-2036-751f-8749-2692611b1b18",["D",1783803158516],"directory",[204],"pulls","branches","forks","envVars",{"_216":70,"_218":70},"connections",{"_216":70,"_217":70},"count","unfilledCount","emptyCount",{"_49":203,"_38":204,"_36":205,"_165":-5,"_47":48,"_46":175,"_167":66,"_44":292,"_13":70,"_39":207,"_41":-5,"_30":31,"_171":-5,"_233":293,"_33":294},{"_49":288,"_38":280,"_36":275,"_165":205,"_47":48,"_46":175,"_167":66,"_44":289,"_13":70,"_39":207,"_41":-5,"_30":31,"_171":-5,"_233":290,"_33":291},{"_49":281,"_38":282,"_36":283,"_165":275,"_47":48,"_46":175,"_167":31,"_44":284,"_13":70,"_39":169,"_41":285,"_30":31,"_171":-5,"_233":286,"_33":287},{"_49":272,"_38":273,"_36":274,"_165":275,"_47":48,"_46":175,"_167":31,"_44":276,"_13":70,"_39":169,"_41":277,"_30":31,"_171":-5,"_233":278,"_33":279},{"_49":265,"_38":266,"_36":267,"_165":205,"_47":48,"_46":175,"_167":66,"_44":268,"_13":70,"_39":26,"_41":269,"_30":31,"_171":-5,"_233":270,"_33":271},{"_49":258,"_38":259,"_36":260,"_165":205,"_47":48,"_46":175,"_167":31,"_44":261,"_13":70,"_39":26,"_41":262,"_30":31,"_171":-5,"_233":263,"_33":264},{"_49":251,"_38":252,"_36":253,"_165":205,"_47":48,"_46":175,"_167":66,"_44":254,"_13":70,"_39":169,"_41":255,"_30":31,"_171":-5,"_233":256,"_33":257},{"_49":197,"_38":198,"_36":199,"_165":-5,"_47":48,"_46":175,"_167":31,"_44":248,"_13":70,"_39":26,"_41":201,"_30":31,"_171":-5,"_233":249,"_33":250},{"_49":190,"_38":191,"_36":192,"_165":-5,"_47":48,"_46":193,"_167":66,"_44":245,"_13":70,"_39":169,"_41":195,"_30":31,"_171":-5,"_233":246,"_33":247},{"_49":183,"_38":184,"_36":185,"_165":-5,"_47":48,"_46":186,"_167":66,"_44":242,"_13":70,"_39":169,"_41":188,"_30":31,"_171":-5,"_233":243,"_33":244},{"_49":177,"_38":178,"_36":64,"_165":-5,"_47":48,"_46":175,"_167":31,"_44":239,"_13":70,"_39":180,"_41":181,"_30":31,"_171":-5,"_233":240,"_33":241},{"_49":173,"_38":34,"_36":37,"_165":-5,"_47":48,"_46":14,"_167":66,"_44":236,"_13":175,"_39":40,"_41":43,"_30":31,"_171":-5,"_233":237,"_33":238},{"_49":162,"_38":163,"_36":164,"_165":-5,"_47":48,"_46":166,"_167":31,"_44":232,"_13":70,"_39":169,"_41":170,"_30":31,"_171":-5,"_233":234,"_33":235},["D",1783803241330],"children",[],[163],["D",1783803269182],[],[34],["D",1783803158516],[],[178],["D",1783803222305],[],[184],["D",1783803222304],[],[191],["D",1783803158516],[],[198],"68fa35ab-f210-4e87-900d-e8b305b7bb4b","index.tsx","019f52f4-2036-751f-8749-2377c32a3766",["D",1783803158516],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[204,252],"8752d0b3-dd88-4c81-99c6-88cf83d3288b","index.html","019f52f4-2036-751f-8749-1d603d4637d4",["D",1783803158516],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[204,259],"37e43383-6683-406c-9c25-7b1bb3916a38","favicon.svg","019f52f4-2036-751f-8749-1b3fd97bdbce",["D",1783803158516],"\n",[],[204,266],"483cda10-555e-4700-9aca-476899f94c4c","Counter.tsx","019f52f4-2036-751f-8749-1325b470f3ea","019f52f4-2036-751f-8749-15c69b12f487",["D",1783803158516],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[204,280,273],"components","5d6bf5dd-abc0-488c-81e4-c242d37a8328","App.tsx","019f52f4-2036-751f-8749-0c3647c2c90b",["D",1783803158516],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[204,280,282],"0f8df77e-fb68-4181-a220-8242a8cf2ba6",["D",1783803158516],[221,222],[204,280],["D",1783803158516],[220,223,224,225],[204],["D",1783803158516],["D",1789526460011],{"_111":110,"_119":115},{"_111":110,"_112":113,"_114":115,"_19":62,"_116":117,"_118":31},{"_13":96,"_38":97,"_49":48,"_98":50,"_99":100,"_101":102,"_103":56,"_104":105,"_106":107,"_108":51,"_109":110},"ctx",{"_89":-5,"_141":333,"_334":335,"_336":337,"_338":31,"_339":31,"_340":31,"_341":66,"_342":-5,"_343":-7,"_344":-7,"_345":70,"_346":31,"_347":31,"_348":-5,"_349":31,"_350":31,"_351":31,"_352":-5},"ENV",{"_304":305,"_306":307,"_308":97,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332},"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 · v6