[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_344":345,"_346":347},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_258":-5,"_20":259,"_22":260,"_261":262,"_263":264,"_26":265,"_24":266,"_267":268,"_269":270,"_271":51,"_272":273,"_274":71,"_275":-5,"_276":-5,"_277":278},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","adoran","name","order-tracker","branchName","main","version","path","frontend/index.html","project",{"_36":208,"_13":14,"_38":209,"_49":-5,"_210":51,"_52":53,"_211":53,"_212":213,"_214":215,"_216":217,"_218":109,"_219":71,"_220":-5,"_221":-5,"_222":121,"_56":223,"_224":225,"_226":227,"_228":229,"_230":-5,"_231":232,"_233":232,"_234":235,"_236":235,"_237":235,"_238":232,"_239":232,"_240":241,"_242":243,"_244":245,"_50":51},"tree",[81,82,83,84,85,86,87],"file",{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_18":79},"contents",[],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",14,"behind",2,"envVars","id","961078ea-f528-11ef-aa68-569c3dd06744","createdAt",["D",1740674013689],"updatedAt",["D",1785420707976],"projectId","96102714-f528-11ef-aa68-569c3dd06744",91,"forkedBranchId","forkedBranchVersion","lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","deletedAt","isOwned",false,"privacy","public","userHandle","templates","orgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","react-hono-starter","a602b446-83d0-4dab-8130-c09091f3137b","index.html","fileId","019f52f4-2036-751f-8749-1d603d4637d4","parentId","019f52f4-2036-751f-8749-2692611b1b18","branchId","31d32e2d-7e5f-4d55-b267-dc6b8c48ab98","branchVersion",9,"latest",true,["D",1783803308890],1,"fileType","content","\n\n \n \n \n 📦 Order Tracker\n \n \n \n \n

\n \n \n \n\n","deleted","label",[80,61],"frontend",{"_36":140,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":73,"_70":71,"_38":141,"_17":121,"_74":142,"_75":-5,"_77":51,"_78":-5,"_95":143,"_18":144},{"_36":132,"_13":133,"_62":134,"_64":-5,"_66":67,"_68":135,"_70":71,"_38":136,"_17":73,"_74":24,"_75":137,"_77":51,"_78":-5,"_95":138,"_18":139},{"_36":125,"_13":126,"_62":127,"_64":-5,"_66":67,"_68":34,"_70":71,"_38":128,"_17":121,"_74":93,"_75":129,"_77":51,"_78":-5,"_95":130,"_18":131},{"_36":116,"_13":117,"_62":118,"_64":-5,"_66":67,"_68":119,"_70":71,"_38":120,"_17":121,"_74":93,"_75":122,"_77":51,"_78":-5,"_95":123,"_18":124},{"_36":107,"_13":108,"_62":109,"_64":-5,"_66":67,"_68":110,"_70":71,"_38":111,"_17":73,"_74":112,"_75":113,"_77":51,"_78":-5,"_95":114,"_18":115},{"_36":98,"_13":99,"_62":100,"_64":-5,"_66":67,"_68":101,"_70":71,"_38":102,"_17":73,"_74":103,"_75":104,"_77":51,"_78":-5,"_95":105,"_18":106},{"_36":88,"_13":89,"_62":90,"_64":-5,"_66":67,"_68":91,"_70":71,"_38":92,"_17":73,"_74":93,"_75":94,"_77":51,"_78":-5,"_95":96,"_18":97},"d7b13da3-e59a-4621-9476-5777c8132213","send-confirmation-email.ts","a504a22e-7d6a-11f1-946e-1607ee4eb77e",7,["D",1783803269182],"script","import nodemailer from \"npm:nodemailer\";\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[], baseUrl: string) {\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 = `${baseUrl}/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","children",[],[89],"79d3b1c2-04c6-49fb-aa02-0d52323cb4bc","scan-gmail.ts","a4ff0bde-7d6a-11f1-8d57-1607ee4eb77e",6,["D",1783803269182],"interval","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",[],[99],"966ad398-d516-43fb-b5d6-bf0c138be87e","index.ts","019f52f4-2036-751f-8749-2fa9c3c7813a",8,["D",1783803282701],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport {\n initDB,\n getAllOrders,\n getOrderById,\n confirmOrder,\n getStats,\n getScanState,\n} from \"./db.ts\";\nimport { scanGmail } from \"./gmail.ts\";\nimport { sendConfirmationEmails } from \"./send-confirmation-email.ts\";\n\nconst app = new Hono();\n\n// Initialize database on first request\nlet dbReady = false;\nasync function ensureDB() {\n if (!dbReady) {\n await initDB();\n dbReady = true;\n }\n}\n\n// ─── Frontend ──────────────────────────────────────────────\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ─── API: Orders ──────────────────────────────────────────\napp.get(\"/api/orders\", async (c) => {\n await ensureDB();\n const orders = await getAllOrders();\n return c.json({ orders });\n});\n\napp.get(\"/api/orders/:id\", async (c) => {\n await ensureDB();\n const id = Number(c.req.param(\"id\"));\n const order = await getOrderById(id);\n if (!order) return c.json({ error: \"Order not found\" }, 404);\n return c.json({ order });\n});\n\napp.post(\"/api/orders/:id/confirm\", async (c) => {\n await ensureDB();\n const id = Number(c.req.param(\"id\"));\n const success = await confirmOrder(id);\n if (!success) return c.json({ error: \"Order not found\" }, 404);\n return c.json({ success: true, message: \"Package confirmed!\" });\n});\n\n// GET version for email link clicks (simple redirect to dashboard)\napp.get(\"/api/orders/:id/confirm\", async (c) => {\n await ensureDB();\n const id = Number(c.req.param(\"id\"));\n await confirmOrder(id);\n // Redirect to dashboard with success indicator\n return new Response(null, {\n status: 302,\n headers: { Location: \"/?confirmed=\" + id },\n });\n});\n\n// ─── API: Stats ───────────────────────────────────────────\napp.get(\"/api/stats\", async (c) => {\n await ensureDB();\n const stats = await getStats();\n return c.json(stats);\n});\n\n// ─── API: Calendar ────────────────────────────────────────\napp.get(\"/api/calendar\", async (c) => {\n await ensureDB();\n const orders = await getAllOrders();\n // Group orders by estimated_arrival date\n const calendar: Record = {};\n for (const order of orders) {\n const dateKey = order.estimated_arrival ?? order.email_date?.split(\"T\")[0] ?? \"unknown\";\n if (!calendar[dateKey]) calendar[dateKey] = [];\n calendar[dateKey].push({\n id: order.id,\n retailer: order.retailer,\n subject: order.subject,\n status: order.status,\n tracking_number: order.tracking_number,\n carrier: order.carrier,\n order_total: order.order_total,\n });\n }\n return c.json({ calendar });\n});\n\n// ─── API: Gmail Status ────────────────────────────────────\napp.get(\"/api/gmail/status\", async (c) => {\n await ensureDB();\n const hasCreds = !!Deno.env.get(\"GMAIL_USER\") && !!Deno.env.get(\"GMAIL_PASS\");\n const scanState = await getScanState();\n return c.json({\n connected: hasCreds,\n email: Deno.env.get(\"GMAIL_USER\") ?? null,\n lastScan: scanState?.last_scan_date ?? null,\n });\n});\n\n// ─── API: Manual Scan ─────────────────────────────────────\napp.post(\"/api/scan\", async (c) => {\n await ensureDB();\n const result = await scanGmail();\n\n // Also send confirmation emails if any pending\n if (result.error === null) {\n const { getOrdersForConfirmation } = await import(\"./db.ts\");\n const pending = await getOrdersForConfirmation();\n if (pending.length > 0) {\n const baseUrl = new URL(c.req.url).origin;\n await sendConfirmationEmails(pending, baseUrl);\n }\n }\n\n return c.json(result);\n});\n\n// ─── Error handling ───────────────────────────────────────\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[],[108],"be66b4da-33c3-472d-9ddc-18286bec8bb3","gmail.ts","99af356a-7d6a-11f1-9710-1607ee4eb77e",3,["D",1783803222305],0,"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",[],[117],"99438914-13a8-41d2-a7ca-df3dad4f5f72","db.ts","99a81abe-7d6a-11f1-993d-1607ee4eb77e",["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",[],[126],"ff861358-a854-4d51-8131-2f05dda88185","README.md","019f52f4-2036-751f-8749-2951064acbc7",15,["D",1783803389109],"# 📦 Order Tracker\n\nTrack online shopping orders, shipping updates, and arrival dates in a calendar — with automatic package confirmation emails.\n\n## Features\n\n- **📊 Calendar view** — Orders plotted on a monthly calendar by estimated arrival date\n- **📋 Order list** — Filterable list with status badges, tracking numbers, and order totals\n- **🔍 Gmail scanning** — Automatically scans your Gmail for order confirmations, shipping updates, and delivery notifications every 15 minutes\n- **✅ Package confirmation** — Sends \"Did you receive this?\" emails when packages are due, with a one-click confirm link\n- **📈 Stats dashboard** — Track ordered, shipped, delivered, and confirmed counts\n\n## Architecture\n\n```mermaid\ngraph LR\n Gmail[\"Gmail (IMAP)\"] -->|scan every 15min| Scan[\"scan-gmail.ts
(interval)\"]\n Scan -->|parse & store| DB[\"SQLite
(orders table)\"]\n Scan -->|if due| Email[\"send-confirmation-email.ts
(Gmail SMTP)\"]\n Email -->|confirm link| Browser\n Browser -->|dashboard| Hono[\"index.ts
(HTTP + API)\"]\n Hono -->|serves| React[\"React Dashboard
(calendar + orders)\"]\n Hono -->|queries| DB\n```\n\n## Setup\n\n### 1. Gmail App Password\n\n1. Go to [Google Account Security](https://myaccount.google.com/security)\n2. Enable **2-Step Verification** (required)\n3. Go to [App Passwords](https://myaccount.google.com/apppasswords)\n4. Create a new app password for \"Mail\" → \"Other\" (name it \"Val Town\")\n5. Copy the 16-character password\n\n### 2. Set Environment Variables\n\n👉 Add GMAIL_USER here: https://www.val.town/x/adoran/order-tracker/environment-variables?key=GMAIL_USER\n\n👉 Add GMAIL_PASS here: https://www.val.town/x/adoran/order-tracker/environment-variables?key=GMAIL_PASS\n\n- `GMAIL_USER` — Your full Gmail address (e.g. `you@gmail.com`)\n- `GMAIL_PASS` — The app password from step 1\n\n### 3. Start Tracking\n\nVisit the dashboard and click **🔍 Scan Now** to do an initial scan of your last 7 days of email. The automatic interval will then scan every 15 minutes going forward.\n\n## How It Works\n\n1. **Gmail IMAP scan** (`gmail.ts`) — Connects via IMAP, searches for emails with order/shipping/tracking-related subjects\n2. **Email parsing** — Extracts tracking numbers (UPS, FedEx, USPS, DHL, Amazon), carrier, retailer, estimated arrival dates, and order totals using regex patterns\n3. **SQLite storage** (`db.ts`) — Deduplicates by message ID, updates status progression (ordered → shipped → delivered → confirmed)\n4. **Confirmation emails** (`send-confirmation-email.ts`) — When a package's estimated arrival date has passed, sends an email via Gmail SMTP with a one-click confirm link\n5. **Dashboard** — React SPA with calendar grid and filterable order list\n\n## File Structure\n\n```\nindex.ts ← Hono server (API + serves frontend)\ndb.ts ← SQLite schema & query helpers\ngmail.ts ← Gmail IMAP scanning & email parsing\nscan-gmail.ts ← Interval job (every 15 min)\nsend-confirmation-email.ts ← Confirmation email sender (Gmail SMTP)\nfrontend/\n index.html ← HTML shell (Twind + React)\n index.tsx ← React entrypoint\n components/\n App.tsx ← Root component (state, data fetching)\n Header.tsx ← Stats bar + Gmail status + view toggle\n Calendar.tsx ← Monthly calendar grid with order details\n OrderList.tsx ← Filterable order cards with confirm buttons\n```\n\n## API Routes\n\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | `/` | Dashboard (React SPA) |\n| GET | `/api/orders` | All orders |\n| GET | `/api/orders/:id` | Single order |\n| POST | `/api/orders/:id/confirm` | Confirm package received |\n| GET | `/api/orders/:id/confirm` | Confirm via email link (redirects to dashboard) |\n| GET | `/api/stats` | Order counts by status |\n| GET | `/api/calendar` | Orders grouped by date |\n| GET | `/api/gmail/status` | Gmail connection status & last scan |\n| POST | `/api/scan` | Manually trigger Gmail scan |\n",[],[133],"f22c9242-5c2c-44d1-9f97-ac07e49a8df8",["D",1783803158516],"directory",[145,146,147,148],[80],{"_36":166,"_13":167,"_62":168,"_64":65,"_66":67,"_68":73,"_70":71,"_38":169,"_17":121,"_74":142,"_75":-5,"_77":51,"_78":-5,"_95":170,"_18":171},{"_36":159,"_13":160,"_62":161,"_64":65,"_66":67,"_68":73,"_70":71,"_38":162,"_17":121,"_74":24,"_75":163,"_77":51,"_78":-5,"_95":164,"_18":165},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":156,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_95":157,"_18":158},{"_36":149,"_13":150,"_62":151,"_64":65,"_66":67,"_68":73,"_70":71,"_38":152,"_17":121,"_74":93,"_75":153,"_77":51,"_78":-5,"_95":154,"_18":155},"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();",[],[80,150],["D",1783803308890],[],[80,61],"37e43383-6683-406c-9c25-7b1bb3916a38","favicon.svg","019f52f4-2036-751f-8749-1b3fd97bdbce",["D",1783803158516],"\n",[],[80,160],"0f8df77e-fb68-4181-a220-8242a8cf2ba6","components","019f52f4-2036-751f-8749-15c69b12f487",["D",1783803158516],[172,173,174,175],[80,167],{"_36":200,"_13":201,"_62":202,"_64":168,"_66":67,"_68":203,"_70":71,"_38":204,"_17":73,"_74":93,"_75":205,"_77":51,"_78":-5,"_95":206,"_18":207},{"_36":192,"_13":193,"_62":194,"_64":168,"_66":67,"_68":195,"_70":71,"_38":196,"_17":121,"_74":93,"_75":197,"_77":51,"_78":-5,"_95":198,"_18":199},{"_36":184,"_13":185,"_62":186,"_64":168,"_66":67,"_68":187,"_70":71,"_38":188,"_17":121,"_74":93,"_75":189,"_77":51,"_78":-5,"_95":190,"_18":191},{"_36":176,"_13":177,"_62":178,"_64":168,"_66":67,"_68":179,"_70":71,"_38":180,"_17":121,"_74":93,"_75":181,"_77":51,"_78":-5,"_95":182,"_18":183},"a29719c1-a1d5-4bf9-bfca-658fa9804267","OrderList.tsx","e42cca30-7d6a-11f1-81e0-1607ee4eb77e",12,["D",1783803347173],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Order {\n id: number;\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}\n\ninterface OrderListProps {\n orders: Order[];\n onConfirm: (id: number) => void;\n confirmedId: number | null;\n}\n\nconst STATUS_COLORS: Record = {\n ordered: \"bg-blue-500\",\n shipped: \"bg-purple-500\",\n out_for_delivery: \"bg-orange-500\",\n delivered: \"bg-green-500\",\n confirmed: \"bg-gray-400\",\n};\n\nconst STATUS_ICONS: Record = {\n ordered: \"📋\",\n shipped: \"🚚\",\n out_for_delivery: \"📦\",\n delivered: \"📬\",\n confirmed: \"✅\",\n};\n\ntype FilterType = \"all\" | \"pending\" | \"ordered\" | \"shipped\" | \"delivered\" | \"confirmed\";\n\nconst FILTERS: { label: string; value: FilterType }[] = [\n { label: \"All\", value: \"all\" },\n { label: \"⏳ Pending\", value: \"pending\" },\n { label: \"📋 Ordered\", value: \"ordered\" },\n { label: \"🚚 Shipped\", value: \"shipped\" },\n { label: \"📬 Delivered\", value: \"delivered\" },\n { label: \"✅ Confirmed\", value: \"confirmed\" },\n];\n\nexport function OrderList({ orders, onConfirm, confirmedId }: OrderListProps) {\n const [filter, setFilter] = useState(\"all\");\n\n const filtered = orders.filter(o => {\n if (filter === \"all\") return true;\n if (filter === \"pending\") return o.status === \"delivered\" || o.status === \"shipped\";\n return o.status === filter;\n });\n\n return (\n

\n {/* Filter buttons */}\n

\n {FILTERS.map(f => (\n setFilter(f.value)}\n class={`px-3 py-1.5 rounded-lg text-sm font-medium transition-colors cursor-pointer ${\n filter === f.value ? \"bg-indigo-600 text-white\" : \"bg-white text-gray-600 border border-gray-200 hover:bg-gray-50\"\n }`}\n >\n {f.label}\n \n ))}\n

\n\n {/* Order cards */}\n {filtered.length === 0 ? (\n

📭

No orders found. Try scanning your Gmail!

\n ) : (\n

\n {filtered.map(order => (\n \n ))}\n

\n )}\n

\n );\n}\n\nfunction OrderCard({ order, onConfirm, confirmed }: { order: Order; onConfirm: (id: number) => void; confirmed: boolean }) {\n const needsConfirm = (order.status === \"delivered\" || order.status === \"shipped\") && order.status !== \"confirmed\";\n const emailDate = new Date(order.email_date).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" });\n const arrivalDate = order.estimated_arrival\n ? new Date(order.estimated_arrival + \"T00:00:00\").toLocaleDateString(\"en-US\", { weekday: \"short\", month: \"short\", day: \"numeric\" })\n : null;\n const today = new Date().toISOString().split(\"T\")[0];\n const isOverdue = order.estimated_arrival && order.estimated_arrival < today && order.status !== \"confirmed\";\n\n return (\n

\n {/* Left: info */}\n

\n \n {STATUS_ICONS[order.status]} {order.status.replace(/_/g, \" \")}\n \n {isOverdue && (\n \n ⚠️ Overdue\n \n )}\n

{order.retailer}

{order.subject}

\n\n

\n 📅 {emailDate}\n {arrivalDate && (\n \n 📬 Est. arrival: {arrivalDate}\n \n )}\n {order.tracking_number && (\n 🚚 {order.carrier}: {order.tracking_number}\n )}\n {order.order_total && (\n 💰 {order.order_total}\n )}\n

\n\n {/* Right: confirm button */}\n {needsConfirm && (\n onConfirm(order.id)}\n class={`px-4 py-2 rounded-lg text-sm font-medium whitespace-nowrap transition-colors cursor-pointer ${\n confirmed ? \"bg-green-100 text-green-700\" : \"bg-green-600 text-white hover:bg-green-700\"\n }`}\n >\n {confirmed ? \"✅ Confirmed!\" : \"✅ Confirm Received\"}\n \n )}\n {order.status === \"confirmed\" && (\n

✅ Received

\n )}\n

\n );\n}\n",[],[80,167,177],"6df3a3c5-9259-4f1e-abda-b0498746ec4c","Header.tsx","e4151048-7d6a-11f1-bc3f-1607ee4eb77e",11,["D",1783803347165],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface Stats {\n total: number;\n byStatus: Record;\n pendingConfirmations: number;\n}\n\ninterface GmailStatus {\n connected: boolean;\n email: string | null;\n lastScan: string | null;\n}\n\ninterface HeaderProps {\n stats: Stats | null;\n gmailStatus: GmailStatus | null;\n onScan: () => void;\n scanning: boolean;\n scanResult: string | null;\n view: \"calendar\" | \"orders\";\n onViewChange: (v: \"calendar\" | \"orders\") => void;\n}\n\nconst STATUS_COLORS: Record = {\n ordered: \"bg-blue-100 text-blue-700\",\n shipped: \"bg-purple-100 text-purple-700\",\n out_for_delivery: \"bg-orange-100 text-orange-700\",\n delivered: \"bg-green-100 text-green-700\",\n confirmed: \"bg-gray-200 text-gray-600\",\n};\n\nconst STATUS_ICONS: Record = {\n ordered: \"📋\",\n shipped: \"🚚\",\n out_for_delivery: \"📦\",\n delivered: \"📬\",\n confirmed: \"✅\",\n};\n\nexport function Header({ stats, gmailStatus, onScan, scanning, scanResult, view, onViewChange }: HeaderProps) {\n return (\n

\n {/* Title row */}\n

\n 📦 Order Tracker\n

\n \n {scanning ? \"🔄 Scanning...\" : \"🔍 Scan Now\"}\n \n

\n\n {/* Scan result */}\n {scanResult && (\n

\n {scanResult}\n

\n )}\n\n {/* Stats bar */}\n {stats && (\n

\n \n \n \n \n \n {stats.pendingConfirmations > 0 && (\n \n )}\n

\n )}\n\n {/* Gmail status + view toggle */}\n

\n {gmailStatus?.connected ? (\n \n \n Gmail: {gmailStatus.email}\n \n ) : (\n \n \n Gmail: Not connected\n \n )}\n {gmailStatus?.lastScan && (\n \n Last scan: {new Date(gmailStatus.lastScan).toLocaleDateString()}\n \n )}\n

\n\n

\n onViewChange(\"calendar\")}\n class={`px-4 py-1.5 rounded-md text-sm font-medium transition-colors cursor-pointer ${\n view === \"calendar\" ? \"bg-white text-indigo-600 shadow-sm\" : \"text-gray-500 hover:text-gray-700\"\n }`}\n >\n 📅 Calendar\n \n onViewChange(\"orders\")}\n class={`px-4 py-1.5 rounded-md text-sm font-medium transition-colors cursor-pointer ${\n view === \"orders\" ? \"bg-white text-indigo-600 shadow-sm\" : \"text-gray-500 hover:text-gray-700\"\n }`}\n >\n 📋 Orders\n \n

\n );\n}\n\nfunction StatCard({ label, value, icon, color = \"indigo\" }: { label: string; value: number; icon: string; color?: string }) {\n const colors: Record = {\n indigo: \"bg-indigo-50 text-indigo-700 border-indigo-200\",\n blue: \"bg-blue-50 text-blue-700 border-blue-200\",\n purple: \"bg-purple-50 text-purple-700 border-purple-200\",\n green: \"bg-green-50 text-green-700 border-green-200\",\n gray: \"bg-gray-50 text-gray-700 border-gray-200\",\n amber: \"bg-amber-50 text-amber-700 border-amber-200\",\n };\n return (\n

{icon} {label}

{value}

\n );\n}\n",[],[80,167,185],"6ceb10a1-2a32-4b8d-a352-31cf7bbae9cb","Calendar.tsx","e4323d8a-7d6a-11f1-9710-1607ee4eb77e",13,["D",1783803347166],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Order {\n id: number;\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}\n\ninterface CalendarProps {\n orders: Order[];\n onConfirm: (id: number) => void;\n confirmedId: number | null;\n}\n\nconst STATUS_COLORS: Record = {\n ordered: \"bg-blue-500\",\n shipped: \"bg-purple-500\",\n out_for_delivery: \"bg-orange-500\",\n delivered: \"bg-green-500\",\n confirmed: \"bg-gray-400\",\n};\n\nconst STATUS_DOT: Record = {\n ordered: \"bg-blue-500\",\n shipped: \"bg-purple-500\",\n out_for_delivery: \"bg-orange-500\",\n delivered: \"bg-green-500\",\n confirmed: \"bg-gray-400\",\n};\n\nconst MONTHS = [\"January\", \"February\", \"March\", \"April\", \"May\", \"June\", \"July\", \"August\", \"September\", \"October\", \"November\", \"December\"];\nconst DAYS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n\nexport function Calendar({ orders, onConfirm, confirmedId }: CalendarProps) {\n const [currentMonth, setCurrentMonth] = useState(new Date());\n const [selectedDate, setSelectedDate] = useState(null);\n\n // Group orders by date\n const ordersByDate: Record = {};\n for (const order of orders) {\n const dateKey = order.estimated_arrival ?? order.email_date?.split(\"T\")[0];\n if (dateKey) {\n if (!ordersByDate[dateKey]) ordersByDate[dateKey] = [];\n ordersByDate[dateKey].push(order);\n }\n }\n\n const year = currentMonth.getFullYear();\n const month = currentMonth.getMonth();\n const firstDay = new Date(year, month, 1).getDay();\n const daysInMonth = new Date(year, month + 1, 0).getDate();\n const today = new Date().toISOString().split(\"T\")[0];\n\n const cells: (number | null)[] = [];\n for (let i = 0; i < firstDay; i++) cells.push(null);\n for (let d = 1; d <= daysInMonth; d++) cells.push(d);\n while (cells.length % 7 !== 0) cells.push(null);\n\n const prevMonth = () => setCurrentMonth(new Date(year, month - 1, 1));\n const nextMonth = () => setCurrentMonth(new Date(year, month + 1, 1));\n const goToday = () => {\n setCurrentMonth(new Date());\n setSelectedDate(today);\n };\n\n const selectedOrders = selectedDate ? ordersByDate[selectedDate] || [] : [];\n\n return (\n

\n {/* Calendar grid */}\n

{MONTHS[month]} {year}

\n \n \n \n

\n\n

\n {DAYS.map(d => (\n

{d}

\n ))}\n {cells.map((day, i) => {\n if (day === null) return

;\n const dateStr = `${year}-${String(month + 1).padStart(2, \"0\")}-${String(day).padStart(2, \"0\")}`;\n const dayOrders = ordersByDate[dateStr] || [];\n const isToday = dateStr === today;\n const isSelected = dateStr === selectedDate;\n const hasPending = dayOrders.some(o => o.status === \"delivered\" || o.status === \"shipped\");\n\n return (\n setSelectedDate(dateStr)}\n class={`min-h-20 p-1.5 rounded-lg border cursor-pointer transition-all ${\n isSelected ? \"border-indigo-400 bg-indigo-50\" : \"border-gray-100 hover:border-gray-300 hover:bg-gray-50\"\n } ${isToday ? \"ring-2 ring-indigo-300\" : \"\"}`}\n >\n

\n {day}\n

\n {dayOrders.slice(0, 3).map(o => (\n

\n {o.retailer}\n

\n ))}\n {dayOrders.length > 3 && (\n

+{dayOrders.length - 3} more

\n )}\n

\n {hasPending && dayOrders.length > 0 && (\n

⏳ Confirm

\n )}\n

\n );\n })}\n

\n\n {/* Side panel: selected date details */}\n

\n {selectedDate ? (\n <>\n

\n {new Date(selectedDate + \"T00:00:00\").toLocaleDateString(\"en-US\", { weekday: \"long\", month: \"long\", day: \"numeric\" })}\n

\n {selectedOrders.length === 0 ? (\n

No orders for this date.

\n ) : (\n

\n {selectedOrders.map(order => (\n \n ))}\n

\n )}\n \n ) : (\n

📅

Click a date to see order details

\n )}\n

\n );\n}\n\nfunction OrderDetail({ order, onConfirm, confirmed }: { order: Order; onConfirm: (id: number) => void; confirmed: boolean }) {\n const needsConfirm = order.status === \"delivered\" || (order.status === \"shipped\" && order.estimated_arrival);\n const canConfirm = order.status !== \"confirmed\";\n\n return (\n

{order.retailer}

{order.subject}

\n \n {order.status.replace(/_/g, \" \")}\n \n

\n {order.tracking_number && (\n

\n 🚚 {order.carrier}: {order.tracking_number}\n

\n )}\n {order.order_total && (\n

💰 {order.order_total}

\n )}\n {needsConfirm && canConfirm && (\n onConfirm(order.id)}\n class=\"mt-2 w-full px-3 py-1.5 rounded-lg bg-green-600 text-white text-sm font-medium hover:bg-green-700 transition-colors cursor-pointer\"\n >\n {confirmed ? \"✅ Confirmed!\" : \"✅ Confirm Received\"}\n \n )}\n {order.status === \"confirmed\" && (\n

✅ You confirmed receipt

\n )}\n

\n );\n}\n",[],[80,167,193],"61999adc-f781-4ad5-b11d-f52573d946af","App.tsx","019f52f4-2036-751f-8749-0c3647c2c90b",10,["D",1783803308895],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { Header } from \"./Header.tsx\";\nimport { Calendar } from \"./Calendar.tsx\";\nimport { OrderList } from \"./OrderList.tsx\";\n\ninterface 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\ninterface Stats {\n total: number;\n byStatus: Record;\n pendingConfirmations: number;\n}\n\ninterface GmailStatus {\n connected: boolean;\n email: string | null;\n lastScan: string | null;\n}\n\ntype View = \"calendar\" | \"orders\";\n\nexport function App() {\n const [orders, setOrders] = useState([]);\n const [stats, setStats] = useState(null);\n const [gmailStatus, setGmailStatus] = useState(null);\n const [view, setView] = useState(\"calendar\");\n const [loading, setLoading] = useState(true);\n const [scanning, setScanning] = useState(false);\n const [scanResult, setScanResult] = useState(null);\n const [confirmedId, setConfirmedId] = useState(null);\n\n const fetchData = useCallback(async () => {\n try {\n const [ordersRes, statsRes, gmailRes] = await Promise.all([\n fetch(\"/api/orders\"),\n fetch(\"/api/stats\"),\n fetch(\"/api/gmail/status\"),\n ]);\n const ordersData = await ordersRes.json();\n const statsData = await statsRes.json();\n const gmailData = await gmailRes.json();\n setOrders(ordersData.orders || []);\n setStats(statsData);\n setGmailStatus(gmailData);\n } catch (err) {\n console.error(\"Failed to fetch data:\", err);\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n // Check for confirmation redirect\n const params = new URLSearchParams(window.location.search);\n const confirmed = params.get(\"confirmed\");\n if (confirmed) {\n setConfirmedId(Number(confirmed));\n setTimeout(() => setConfirmedId(null), 5000);\n window.history.replaceState({}, \"\", \"/\");\n }\n fetchData();\n }, [fetchData]);\n\n const handleScan = async () => {\n setScanning(true);\n setScanResult(null);\n try {\n const res = await fetch(\"/api/scan\", { method: \"POST\" });\n const data = await res.json();\n if (data.error) {\n setScanResult(`❌ Error: ${data.error}`);\n } else {\n setScanResult(`✅ Scanned ${data.scanned} emails — ${data.newOrders} new, ${data.updated} updated`);\n await fetchData();\n }\n } catch (err) {\n setScanResult(`❌ Scan failed: ${String(err)}`);\n } finally {\n setScanning(false);\n }\n };\n\n const handleConfirm = async (id: number) => {\n try {\n await fetch(`/api/orders/${id}/confirm`, { method: \"POST\" });\n await fetchData();\n setConfirmedId(id);\n setTimeout(() => setConfirmedId(null), 3000);\n } catch (err) {\n console.error(\"Failed to confirm:\", err);\n }\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n return (\n

\n \n\n {confirmedId !== null && (\n

\n ✅ Package confirmed! Marked as received.\n

\n )}\n\n {!gmailStatus?.connected && (\n

⚠️ Gmail Not Connected

\n Set GMAIL_USER and{\" \"}\n GMAIL_PASS environment variables to start tracking orders.\n See the setup instructions below.\n

\n )}\n\n {view === \"calendar\" ? (\n \n ) : (\n \n )}\n\n \n

\n );\n}\n",[],[80,167,201],"b59279da-d98a-4e6c-8850-d4254db64611",["D",1783803158516],"legacyEnvVars","httpPrivacy","description","Track orders, shipping, arrival dates in a calendar","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789567199&sig=be2da3e537d6269cefeedcb88843ac66f83d7a4623f50e71633938e44918ec3c","userId","bf338674-fda8-4a0e-8fad-7b37cb5cc983","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_257":253},"org",{"_11":12,"_250":251,"_252":253,"_216":217,"_254":255,"_256":51},"branch",{"_17":135,"_13":16,"_36":67,"_42":208,"_45":37,"_46":246,"_247":53,"_248":43,"_249":57,"_58":14,"_54":12},89,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Adora N","avatar","https://lh3.googleusercontent.com/a/ACg8ocLX491kPKV6up_39D9RfH3dFN86Q-HlPoXrfwv86VqwOhgDlQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":208,"_13":14,"_38":339,"_49":-5,"_210":51,"_52":53,"_211":53,"_212":213,"_214":215,"_216":217,"_218":109,"_219":71,"_220":-5,"_221":-5,"_222":121,"_56":223,"_224":225,"_226":227,"_228":340,"_230":-5,"_231":232,"_233":232,"_234":235,"_236":235,"_237":235,"_238":232,"_239":232,"_240":341,"_242":342,"_244":343,"_50":51},[294,303,304,305,306,307,308],"files",[294,295,296,297,298,299,300,301,302,303,304,305,306,307,308],"counts",{"_285":121,"_286":73,"_287":121,"_35":288,"_289":290},[],{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_18":284},"upstreamProject",{"_36":43,"_13":59,"_212":281,"_214":215,"_52":53,"_240":282},"upstreamBranch",{"_36":37,"_38":279,"_40":280,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"Starter template with client-side React & Hono server",{"_11":55,"_257":283},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789567199&sig=d8af4f1d5d6ef07a152f6225f86a0227f22fe92650a7f9572d94a5f64256bba9",[80,61],"pulls","branches","forks",{"_291":121,"_293":121},"connections",{"_291":121,"_292":121},"count","unfilledCount","emptyCount",{"_36":140,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":73,"_70":71,"_38":141,"_17":121,"_74":142,"_75":-5,"_77":51,"_78":-5,"_95":337,"_18":338},{"_36":166,"_13":167,"_62":168,"_64":65,"_66":67,"_68":73,"_70":71,"_38":169,"_17":121,"_74":142,"_75":-5,"_77":51,"_78":-5,"_95":335,"_18":336},{"_36":200,"_13":201,"_62":202,"_64":168,"_66":67,"_68":203,"_70":71,"_38":204,"_17":73,"_74":93,"_75":205,"_77":51,"_78":-5,"_95":333,"_18":334},{"_36":192,"_13":193,"_62":194,"_64":168,"_66":67,"_68":195,"_70":71,"_38":196,"_17":121,"_74":93,"_75":197,"_77":51,"_78":-5,"_95":331,"_18":332},{"_36":184,"_13":185,"_62":186,"_64":168,"_66":67,"_68":187,"_70":71,"_38":188,"_17":121,"_74":93,"_75":189,"_77":51,"_78":-5,"_95":329,"_18":330},{"_36":176,"_13":177,"_62":178,"_64":168,"_66":67,"_68":179,"_70":71,"_38":180,"_17":121,"_74":93,"_75":181,"_77":51,"_78":-5,"_95":327,"_18":328},{"_36":159,"_13":160,"_62":161,"_64":65,"_66":67,"_68":73,"_70":71,"_38":162,"_17":121,"_74":24,"_75":163,"_77":51,"_78":-5,"_95":325,"_18":326},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":156,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_95":323,"_18":324},{"_36":149,"_13":150,"_62":151,"_64":65,"_66":67,"_68":73,"_70":71,"_38":152,"_17":121,"_74":93,"_75":153,"_77":51,"_78":-5,"_95":321,"_18":322},{"_36":132,"_13":133,"_62":134,"_64":-5,"_66":67,"_68":135,"_70":71,"_38":136,"_17":73,"_74":24,"_75":137,"_77":51,"_78":-5,"_95":319,"_18":320},{"_36":125,"_13":126,"_62":127,"_64":-5,"_66":67,"_68":34,"_70":71,"_38":128,"_17":121,"_74":93,"_75":129,"_77":51,"_78":-5,"_95":317,"_18":318},{"_36":116,"_13":117,"_62":118,"_64":-5,"_66":67,"_68":119,"_70":71,"_38":120,"_17":121,"_74":93,"_75":122,"_77":51,"_78":-5,"_95":315,"_18":316},{"_36":107,"_13":108,"_62":109,"_64":-5,"_66":67,"_68":110,"_70":71,"_38":111,"_17":73,"_74":112,"_75":113,"_77":51,"_78":-5,"_95":313,"_18":314},{"_36":98,"_13":99,"_62":100,"_64":-5,"_66":67,"_68":101,"_70":71,"_38":102,"_17":73,"_74":103,"_75":104,"_77":51,"_78":-5,"_95":311,"_18":312},{"_36":88,"_13":89,"_62":90,"_64":-5,"_66":67,"_68":91,"_70":71,"_38":92,"_17":73,"_74":93,"_75":94,"_77":51,"_78":-5,"_95":309,"_18":310},[],[89],[],[99],[],[108],[],[117],[],[126],[],[133],[],[80,150],[],[80,61],[],[80,160],[],[80,167,177],[],[80,167,185],[],[80,167,193],[],[80,167,201],[296,297,298,299],[80,167],[295,300,301,302],[80],["D",1783803158516],["D",1789526460011],{"_11":12,"_257":253},{"_11":12,"_250":251,"_252":253,"_216":217,"_254":255,"_256":51},{"_17":135,"_13":16,"_36":67,"_42":208,"_45":37,"_46":246,"_247":53,"_248":43,"_249":57,"_58":14,"_54":12},"ctx",{"_240":-5,"_276":377,"_378":379,"_380":381,"_382":51,"_383":51,"_384":51,"_385":71,"_386":-5,"_387":-7,"_388":-7,"_389":121,"_390":51,"_391":51,"_392":-5,"_393":51,"_394":51,"_395":51,"_396":-5},"ENV",{"_348":349,"_350":351,"_352":16,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376},"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"]