\n \n \n \n\n",[119,110],"10949b220d657f989b8e8c782efbc86970cb5beaadad9bb89f2e74552ec8f998","frontend","5c059140-3996-11f1-a04c-42b51c65c3df","5404b440-f52b-11ef-99f0-569c3dd06744","a59cbf44-f528-11ef-ae42-569c3dd06744",74,["D",1776345337676],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[119,110],"1ea8b3da4e18d579298229ba24af91b14b14ae02565f57c996f9acaa1f8333bc","frontend/components/App.tsx",{"_32":142,"_13":132,"_81":143,"_83":144,"_84":33,"_85":145,"_87":26,"_34":146,"_40":147,"_90":137,"_92":148,"_66":48,"_94":-5,"_95":-7,"_74":149,"_97":150},{"_32":131,"_13":132,"_81":133,"_83":134,"_84":58,"_85":135,"_87":26,"_34":136,"_40":89,"_90":137,"_92":138,"_66":48,"_94":-5,"_95":-7,"_74":139,"_97":140},"61999adc-f781-4ad5-b11d-f52573d946af","App.tsx","019f52f4-2036-751f-8749-0c3647c2c90b","019f52f4-2036-751f-8749-15c69b12f487",10,["D",1783803308895],"script","/** @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",[119,141,132],"1abead428cfb190c345b3d4d9d8716caf3bd9b0fc0b63fc37e913bc432f49feb","components","5d7e5e30-3996-11f1-bbdd-42b51c65c3df","6e585892-f52b-11ef-a8e1-569c3dd06744","69ed66bc-f52b-11ef-9dac-569c3dd06744",75,["D",1776345339930],5,"/** @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",[119,141,132],"de0a7e5fc76c6fd6135aff964af1a5835e04e2758b23f3d0c7d9fabffe514df7","README.md",{"_32":160,"_13":151,"_81":161,"_83":-5,"_84":33,"_85":60,"_87":48,"_34":162,"_40":163,"_90":115,"_92":164,"_66":48,"_94":-5,"_95":-7,"_74":165,"_97":166},{"_32":154,"_13":151,"_81":155,"_83":-5,"_84":58,"_85":57,"_87":26,"_34":156,"_40":89,"_90":115,"_92":157,"_66":48,"_94":-5,"_95":-7,"_74":158,"_97":159},"ff861358-a854-4d51-8131-2f05dda88185","019f52f4-2036-751f-8749-2951064acbc7",["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",[151],"960549a414d2eb844dec238726543644b32893b5c41ce8aff2ff7f1620f6a7bb","b9c749c0-59e1-11f1-bb5f-ee650bb23af1","a50c3760-f53e-11ef-bd6d-569c3dd06744",["D",1779896144390],31,"# 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",[151],"aaa4f5cc8e5bd01528335cdd2066e164bf95353ce2fe37c616b3e6406f49331e",{"_74":168,"_76":169,"_78":-7},"frontend/components/Counter.tsx",{"_32":170,"_13":171,"_81":172,"_83":144,"_84":33,"_85":173,"_87":26,"_34":174,"_40":175,"_90":137,"_92":176,"_66":48,"_94":-5,"_95":-7,"_74":177,"_97":178},"57a8cc52-3996-11f1-8db6-42b51c65c3df","Counter.tsx","57a8cd2e-3996-11f1-8db6-42b51c65c3df",73,["D",1776345330366],0,"/** @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",[119,141,171],"10ce4fbd7e41af337e504c3877201698031249b437d941845f0f7cdc52a79e66",{"_74":244,"_76":-7,"_78":245},{"_74":234,"_76":-7,"_78":235},{"_74":224,"_76":-7,"_78":225},{"_74":214,"_76":-7,"_78":215},{"_74":205,"_76":-7,"_78":206},{"_74":195,"_76":-7,"_78":196},{"_74":186,"_76":-7,"_78":187},"send-confirmation-email.ts",{"_32":188,"_13":186,"_81":189,"_83":-5,"_84":58,"_85":190,"_87":26,"_34":191,"_40":89,"_90":137,"_92":192,"_66":48,"_94":-5,"_95":-7,"_74":193,"_97":194},"d7b13da3-e59a-4621-9476-5777c8132213","a504a22e-7d6a-11f1-946e-1607ee4eb77e",7,["D",1783803269182],"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",[186],"fc52f203365953b4c347fed54322218624eb3c645be2abeccc53d04e4336c0a6","scan-gmail.ts",{"_32":197,"_13":195,"_81":198,"_83":-5,"_84":58,"_85":199,"_87":26,"_34":200,"_40":89,"_90":201,"_92":202,"_66":48,"_94":-5,"_95":-7,"_74":203,"_97":204},"79d3b1c2-04c6-49fb-aa02-0d52323cb4bc","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",[195],"d1cb20af5902bfee9cbc780583c3358c1621c833c420094bf667cab89d89a92b","gmail.ts",{"_32":207,"_13":205,"_81":208,"_83":-5,"_84":58,"_85":209,"_87":26,"_34":210,"_40":175,"_90":137,"_92":211,"_66":48,"_94":-5,"_95":-7,"_74":212,"_97":213},"be66b4da-33c3-472d-9ddc-18286bec8bb3","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",[205],"5793b9b2dd27081945e11d75867d7a7a7b0c8ea3463d3a7708f2d4fa66c685f7","frontend/components/OrderList.tsx",{"_32":216,"_13":217,"_81":218,"_83":134,"_84":58,"_85":219,"_87":26,"_34":220,"_40":175,"_90":137,"_92":221,"_66":48,"_94":-5,"_95":-7,"_74":222,"_97":223},"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",[119,141,217],"aa9f3afb1ea03d7656e1210a63549767bc416372e414747366359a9d70b2251f","frontend/components/Header.tsx",{"_32":226,"_13":227,"_81":228,"_83":134,"_84":58,"_85":229,"_87":26,"_34":230,"_40":175,"_90":137,"_92":231,"_66":48,"_94":-5,"_95":-7,"_74":232,"_97":233},"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",[119,141,227],"a26efbd1d242449c25e2afbe95584eccf7bcad6ac8b7b11ff657cc0f096d62d5","frontend/components/Calendar.tsx",{"_32":236,"_13":237,"_81":238,"_83":134,"_84":58,"_85":239,"_87":26,"_34":240,"_40":175,"_90":137,"_92":241,"_66":48,"_94":-5,"_95":-7,"_74":242,"_97":243},"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",[119,141,237],"adeb6af36295c91c0c4a7fb2639616e6e0f6ee35bb3fdd8531d542c2106518c3","db.ts",{"_32":246,"_13":244,"_81":247,"_83":-5,"_84":58,"_85":22,"_87":26,"_34":248,"_40":175,"_90":137,"_92":249,"_66":48,"_94":-5,"_95":-7,"_74":250,"_97":251},"99438914-13a8-41d2-a7ca-df3dad4f5f72","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",[244],"8a9163b0ff8cb9992198086d64d7a7e44dd11606548bf5aee2d8d781ce3fef6f",["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,"_295":291},"org",{"_11":12,"_288":289,"_290":291,"_259":260,"_292":293,"_294":48},"branch","displayName","Adora N","avatar","https://lh3.googleusercontent.com/a/ACg8ocLX491kPKV6up_39D9RfH3dFN86Q-HlPoXrfwv86VqwOhgDlQ=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":59,"_13":14,"_34":415,"_46":-5,"_253":48,"_49":50,"_254":50,"_255":256,"_257":258,"_259":260,"_261":82,"_262":26,"_263":-5,"_264":-5,"_265":175,"_53":266,"_267":268,"_269":270,"_271":416,"_273":-5,"_274":275,"_276":275,"_277":278,"_279":278,"_280":278,"_281":275,"_282":275,"_283":417,"_285":418,"_287":419,"_47":48},"tree",[357,366,367,368,369,370,371],"files",[357,358,359,360,361,362,363,364,365,366,367,368,369,370,371],"counts",{"_347":175,"_348":89,"_349":175,"_350":351,"_352":353},"contents",[324,325,326,327,328,329,330],"upstreamProject",{"_32":39,"_13":56,"_255":321,"_257":258,"_49":50,"_283":322},"upstreamBranch",{"_32":33,"_34":319,"_36":320,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"Starter template with client-side React & Hono server",{"_11":52,"_295":323},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789567199&sig=d8af4f1d5d6ef07a152f6225f86a0227f22fe92650a7f9572d94a5f64256bba9",{"_32":343,"_13":119,"_81":112,"_83":-5,"_84":58,"_85":89,"_87":26,"_34":344,"_40":175,"_90":345,"_92":-5,"_66":48,"_94":-5,"_74":346},{"_32":154,"_13":151,"_81":155,"_83":-5,"_84":58,"_85":57,"_87":26,"_34":341,"_40":89,"_90":115,"_92":157,"_66":48,"_94":-5,"_74":342},{"_32":246,"_13":244,"_81":247,"_83":-5,"_84":58,"_85":22,"_87":26,"_34":339,"_40":175,"_90":137,"_92":249,"_66":48,"_94":-5,"_74":340},{"_32":207,"_13":205,"_81":208,"_83":-5,"_84":58,"_85":209,"_87":26,"_34":337,"_40":175,"_90":137,"_92":211,"_66":48,"_94":-5,"_74":338},{"_32":80,"_13":75,"_81":82,"_83":-5,"_84":58,"_85":86,"_87":26,"_34":335,"_40":89,"_90":91,"_92":93,"_66":48,"_94":-5,"_74":336},{"_32":197,"_13":195,"_81":198,"_83":-5,"_84":58,"_85":199,"_87":26,"_34":333,"_40":89,"_90":201,"_92":202,"_66":48,"_94":-5,"_74":334},{"_32":188,"_13":186,"_81":189,"_83":-5,"_84":58,"_85":190,"_87":26,"_34":331,"_40":89,"_90":137,"_92":192,"_66":48,"_94":-5,"_74":332},["D",1783803269182],[186],["D",1783803269182],[195],["D",1783803282701],[75],["D",1783803222305],[205],["D",1783803222304],[244],["D",1783803389109],[151],"f22c9242-5c2c-44d1-9f97-ac07e49a8df8",["D",1783803158516],"directory",[119],"pulls","branches","forks","envVars",{"_354":175,"_356":175},"connections",{"_354":175,"_355":175},"count","unfilledCount","emptyCount",{"_32":343,"_13":119,"_81":112,"_83":-5,"_84":58,"_85":89,"_87":26,"_34":412,"_40":175,"_90":345,"_92":-5,"_66":48,"_94":-5,"_95":413,"_74":414},{"_32":408,"_13":141,"_81":134,"_83":112,"_84":58,"_85":89,"_87":26,"_34":409,"_40":175,"_90":345,"_92":-5,"_66":48,"_94":-5,"_95":410,"_74":411},{"_32":131,"_13":132,"_81":133,"_83":134,"_84":58,"_85":135,"_87":26,"_34":136,"_40":89,"_90":137,"_92":138,"_66":48,"_94":-5,"_95":406,"_74":407},{"_32":236,"_13":237,"_81":238,"_83":134,"_84":58,"_85":239,"_87":26,"_34":240,"_40":175,"_90":137,"_92":241,"_66":48,"_94":-5,"_95":404,"_74":405},{"_32":226,"_13":227,"_81":228,"_83":134,"_84":58,"_85":229,"_87":26,"_34":230,"_40":175,"_90":137,"_92":231,"_66":48,"_94":-5,"_95":402,"_74":403},{"_32":216,"_13":217,"_81":218,"_83":134,"_84":58,"_85":219,"_87":26,"_34":220,"_40":175,"_90":137,"_92":221,"_66":48,"_94":-5,"_95":400,"_74":401},{"_32":393,"_13":394,"_81":395,"_83":112,"_84":58,"_85":89,"_87":26,"_34":396,"_40":175,"_90":115,"_92":397,"_66":48,"_94":-5,"_95":398,"_74":399},{"_32":109,"_13":110,"_81":111,"_83":112,"_84":58,"_85":113,"_87":26,"_34":114,"_40":89,"_90":115,"_92":116,"_66":48,"_94":-5,"_95":391,"_74":392},{"_32":384,"_13":385,"_81":386,"_83":112,"_84":58,"_85":89,"_87":26,"_34":387,"_40":175,"_90":137,"_92":388,"_66":48,"_94":-5,"_95":389,"_74":390},{"_32":154,"_13":151,"_81":155,"_83":-5,"_84":58,"_85":57,"_87":26,"_34":156,"_40":89,"_90":115,"_92":157,"_66":48,"_94":-5,"_95":382,"_74":383},{"_32":246,"_13":244,"_81":247,"_83":-5,"_84":58,"_85":22,"_87":26,"_34":248,"_40":175,"_90":137,"_92":249,"_66":48,"_94":-5,"_95":380,"_74":381},{"_32":207,"_13":205,"_81":208,"_83":-5,"_84":58,"_85":209,"_87":26,"_34":210,"_40":175,"_90":137,"_92":211,"_66":48,"_94":-5,"_95":378,"_74":379},{"_32":80,"_13":75,"_81":82,"_83":-5,"_84":58,"_85":86,"_87":26,"_34":88,"_40":89,"_90":91,"_92":93,"_66":48,"_94":-5,"_95":376,"_74":377},{"_32":197,"_13":195,"_81":198,"_83":-5,"_84":58,"_85":199,"_87":26,"_34":200,"_40":89,"_90":201,"_92":202,"_66":48,"_94":-5,"_95":374,"_74":375},{"_32":188,"_13":186,"_81":189,"_83":-5,"_84":58,"_85":190,"_87":26,"_34":191,"_40":89,"_90":137,"_92":192,"_66":48,"_94":-5,"_95":372,"_74":373},[],[186],[],[195],[],[75],[],[205],[],[244],[],[151],"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();",[],[119,385],[],[119,110],"37e43383-6683-406c-9c25-7b1bb3916a38","favicon.svg","019f52f4-2036-751f-8749-1b3fd97bdbce",["D",1783803158516],"\n",[],[119,394],[],[119,141,217],[],[119,141,227],[],[119,141,237],[],[119,141,132],"0f8df77e-fb68-4181-a220-8242a8cf2ba6",["D",1783803158516],[359,360,361,362],[119,141],["D",1783803158516],[358,363,364,365],[119],["D",1783803158516],["D",1789526460011],{"_11":12,"_295":291},{"_11":12,"_288":289,"_290":291,"_259":260,"_292":293,"_294":48},{"_40":57,"_13":16,"_32":58,"_38":59,"_42":33,"_43":60,"_61":50,"_62":39,"_63":54,"_55":14,"_51":12},"ctx",{"_283":-5,"_316":453,"_454":455,"_456":457,"_458":48,"_459":48,"_460":48,"_461":26,"_462":-5,"_463":-7,"_464":-7,"_465":175,"_466":48,"_467":48,"_468":-5,"_469":48,"_470":48,"_471":48,"_472":-5},"ENV",{"_424":425,"_426":427,"_428":16,"_429":430,"_431":432,"_433":434,"_435":436,"_437":438,"_439":440,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452},"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"]

Compare

Mergeadoran/mainintotemplates/main

README.md+70-46

frontend/components/App.tsx+151-7

frontend/index.html+3-3

Hindex.ts+114-11

db.ts+199-0

frontend/components/Calendar.tsx+195-0

frontend/components/Header.tsx+138-0

frontend/components/OrderList.tsx+155-0

gmail.ts+217-0

Cscan-gmail.ts+27-0

send-confirmation-email.ts+66-0

frontend/components/Counter.tsx+0-18