[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_506":507,"_508":509},"routes/_app.x.$handle.$name",{"_109":108,"_37":50,"_117":95,"_32":118,"_13":14,"_119":-5,"_11":120,"_121":122,"_123":124,"_125":126,"_127":128,"_26":-5,"_129":130,"_131":132,"_133":30,"_134":135,"_136":64,"_137":-5,"_138":-5,"_139":140},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",30,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","ff1db7b4-3bbf-4162-827b-aae8849b61f1","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/pages/ProductsPage.tsx","latestPath","fileId","38406b4c-55eb-11f1-a8d0-ee650bb23af1","name","ProductsPage.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n useEffect,\n useMemo,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport { useSearchParams } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Category, Product } from \"../../shared/types.ts\";\nimport { api } from \"../api/client.ts\";\nimport { ProductCard } from \"../components/ProductCard.tsx\";\nimport { ProductCardSkeleton } from \"../components/ui/Skeleton.tsx\";\nimport { EmptyState } from \"../components/ui/EmptyState.tsx\";\n\nexport function ProductsPage() {\n const [params, setParams] = useSearchParams();\n const search = params.get(\"search\") ?? \"\";\n const category = params.get(\"category\") ?? \"\";\n const sort = params.get(\"sort\") ?? \"newest\";\n\n const [products, setProducts] = useState([]);\n const [categories, setCategories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [aiSuggestions, setAiSuggestions] = useState([]);\n\n useEffect(() => {\n api.get(\"/api/categories\").then(setCategories);\n }, []);\n\n useEffect(() => {\n setLoading(true);\n const q = new URLSearchParams();\n if (search) q.set(\"search\", search);\n if (category) q.set(\"category\", category);\n if (sort) q.set(\"sort\", sort);\n api.get(`/api/products?${q.toString()}`)\n .then(setProducts)\n .finally(() => setLoading(false));\n }, [search, category, sort]);\n\n useEffect(() => {\n if (search.length < 3) {\n setAiSuggestions([]);\n return;\n }\n const t = setTimeout(() => {\n api.post<{ suggestions: string[] }>(\"/api/ai/search-suggest\", {\n query: search,\n })\n .then((r) => setAiSuggestions(r.suggestions))\n .catch(() => setAiSuggestions([]));\n }, 800);\n return () => clearTimeout(t);\n }, [search]);\n\n function update(key: string, value: string) {\n const next = new URLSearchParams(params);\n if (value) next.set(key, value);\n else next.delete(key);\n setParams(next);\n }\n\n const title = useMemo(() => {\n if (search) return `Results for \"${search}\"`;\n if (category) {\n const c = categories.find((c) => c.slug === category);\n return c ? `${c.icon} ${c.name}` : \"Products\";\n }\n return \"All Products\";\n }, [search, category, categories]);\n\n return (\n

{title}

\n {loading ? \"Loading…\" : `${products.length} products`}\n

\n\n {aiSuggestions.length > 0 && (\n

\n ✨ AI Search suggestions\n

\n {aiSuggestions.map((s) => (\n update(\"search\", s)}\n class=\"px-3 py-1 bg-white border border-purple-200 rounded-full text-sm text-purple-700 hover:bg-purple-100\"\n >\n {s}\n \n ))}\n

\n )}\n\n

\n Categories\n

\n update(\"category\", \"\")}\n class={`block w-full text-left px-3 py-2 rounded-lg text-sm ${\n !category\n ? \"bg-indigo-50 text-indigo-700 font-medium\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n All\n \n {categories.map((c) => (\n update(\"category\", c.slug)}\n class={`block w-full text-left px-3 py-2 rounded-lg text-sm ${\n category === c.slug\n ? \"bg-indigo-50 text-indigo-700 font-medium\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n {c.icon} {c.name}\n \n ))}\n

\n Sort\n

\n update(\"sort\", e.target.value)}\n class=\"w-full px-3 py-2 bg-white border border-gray-200 rounded-lg text-sm\"\n >\n \n \n \n \n \n

\n\n

\n {loading\n ? (\n

\n {Array.from({ length: 9 }).map((_, i) => (\n \n ))}\n

\n )\n : products.length === 0\n ? (\n \n )\n : (\n

\n {products.map((p) => )}\n

\n )}\n

\n );\n}\n","createdAt",["D",1779460417436],"branchVersion","branchId","1153de52-55ea-11f1-9899-ee650bb23af1","id","114abd18-55ea-11f1-9899-ee650bb23af1","smart-gadgets-store",["D",1779459922585],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","4b701ef0-5af2-11f0-b0a0-21ea95346041","pinnedFileId","019e5013-9af2-7410-b348-21fb8edf74bc","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","4b701ef1-5af2-11f0-b0a0-21ea95346041","tursoName","114abd1855ea11f19899ee650bb23af1","tursoHostname","114abd1855ea11f19899ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_109":108,"_116":112},"org",{"_109":108,"_110":-5,"_111":112,"_19":60,"_113":114,"_115":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"isOwned",39,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","COBRA","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ6WDdqYXdodVpHVnBkN2pxakozbWM5M2tDNSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":501,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":502,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":503,"_89":504,"_91":505,"_93":30},"tree",[202,206,236,238,239],"files",[202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239],"counts",{"_192":68,"_193":163,"_194":68,"_195":196,"_197":198},"contents",[152,153,154,155,156],"upstreamProject",{"_48":103,"_37":148,"_57":58,"_59":149,"_54":55,"_87":150},"upstreamBranch",{"_48":98,"_43":141,"_142":143,"_37":95,"_96":103,"_13":144,"_97":-5,"_99":-5,"_145":146,"_52":-5,"_93":30,"_54":55,"_107":147,"_69":105,"_106":148},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789588799&sig=cc8cae5a3b06d460bba0e0803182f7ba2bd6e8f6e4c645b92fb51aa03192ad01",{"_109":147,"_116":151},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789588799&sig=6ce4a653b65ad390b6349a1b0a383cb839cc380a1beaf91551581c108538875d",{"_48":186,"_37":187,"_35":188,"_159":-5,"_46":47,"_45":189,"_161":64,"_43":190,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":191},{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":184,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":185},{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":177,"_161":64,"_43":178,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":180},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":171,"_13":68,"_39":26,"_41":172,"_29":30,"_166":-5,"_32":173},{"_48":157,"_37":158,"_35":62,"_159":-5,"_46":47,"_45":160,"_161":64,"_43":162,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_32":167},"b0c7d83a-55ea-11f1-9ebd-ee650bb23af1","index.ts","parentId",8,"latest",["D",1779460190161],1,"http","// Main HTTP entrypoint — serves frontend + API + OAuth.\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Hono } from \"npm:hono\";\nimport { HttpError, getCurrentUser, requireRole, requireUser } from \"./backend/auth.ts\";\nimport * as db from \"./backend/db.ts\";\nimport * as ai from \"./backend/ai.ts\";\n\nconst app = new Hono();\n\n// --- Error handling: turn HttpError into proper responses ---\napp.onError((err, c) => {\n if (err instanceof HttpError) {\n return c.json({ error: err.message }, err.status as 401 | 403 | 400);\n }\n // Re-throw so Val Town logs the full stack\n return Promise.reject(err);\n});\n\n// --- Frontend routes ---\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/favicon.ico\", () => serveFile(\"/frontend/favicon.svg\"));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// SPA fallback — let React Router handle client-side routes.\nconst spaPaths = [\n \"/products\",\n \"/products/*\",\n \"/cart\",\n \"/checkout\",\n \"/orders\",\n \"/orders/*\",\n \"/wishlist\",\n \"/dashboard\",\n \"/dashboard/*\",\n \"/seller\",\n \"/seller/*\",\n \"/admin\",\n \"/admin/*\",\n \"/ai\",\n \"/profile\",\n \"/compare\",\n];\nfor (const p of spaPaths) {\n app.get(p, () => serveFile(\"/frontend/index.html\"));\n}\n\n// =========================\n// API\n// =========================\n\n// --- Session ---\napp.get(\"/api/session\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n return c.json({ user, loggedIn: !!user });\n});\n\n// Switch role (demo helper — in production this would be admin-gated).\n// Allows the logged-in user to upgrade themselves to seller or admin so the\n// project is fully explorable end-to-end.\napp.post(\"/api/me/role\", async (c) => {\n const user = await requireUser(c.req.raw);\n const body = await c.req.json().catch(() => ({}));\n const role = body.role;\n if (![\"customer\", \"seller\", \"admin\"].includes(role)) {\n return c.json({ error: \"Invalid role\" }, 400);\n }\n await db.setUserRole(user.id, role);\n return c.json({ ok: true, role });\n});\n\n// --- Categories ---\napp.get(\"/api/categories\", async (c) => {\n const cats = await db.listCategories();\n return c.json(cats);\n});\n\n// --- Products ---\napp.get(\"/api/products\", async (c) => {\n const q = c.req.query();\n const products = await db.listProducts({\n search: q.search || undefined,\n category: q.category || undefined,\n minPrice: q.minPrice ? Number(q.minPrice) : undefined,\n maxPrice: q.maxPrice ? Number(q.maxPrice) : undefined,\n sort: (q.sort as never) || \"newest\",\n limit: q.limit ? Number(q.limit) : 60,\n offset: q.offset ? Number(q.offset) : 0,\n });\n return c.json(products);\n});\n\napp.get(\"/api/products/:slug\", async (c) => {\n const slug = c.req.param(\"slug\");\n const product = await db.getProductBySlug(slug);\n if (!product) return c.json({ error: \"Not found\" }, 404);\n // Track view\n const user = await getCurrentUser(c.req.raw);\n if (user) await db.trackView(user.id, product.id);\n const reviews = await db.listReviews(product.id);\n return c.json({ product, reviews });\n});\n\n// Compare two products\napp.get(\"/api/compare\", async (c) => {\n const a = Number(c.req.query(\"a\"));\n const b = Number(c.req.query(\"b\"));\n const [pa, pb] = await Promise.all([db.getProduct(a), db.getProduct(b)]);\n return c.json({ a: pa, b: pb });\n});\n\n// --- Cart ---\napp.get(\"/api/cart\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.getCart(user.id));\n});\n\napp.post(\"/api/cart\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { productId, quantity } = await c.req.json();\n if (!productId || !quantity) return c.json({ error: \"Bad request\" }, 400);\n await db.addToCart(user.id, Number(productId), Number(quantity));\n return c.json(await db.getCart(user.id));\n});\n\napp.patch(\"/api/cart/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n const id = Number(c.req.param(\"id\"));\n const { quantity } = await c.req.json();\n await db.updateCartItem(user.id, id, Number(quantity));\n return c.json(await db.getCart(user.id));\n});\n\napp.delete(\"/api/cart/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n await db.removeCartItem(user.id, Number(c.req.param(\"id\")));\n return c.json(await db.getCart(user.id));\n});\n\n// --- Wishlist ---\napp.get(\"/api/wishlist\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.getWishlist(user.id));\n});\n\napp.post(\"/api/wishlist/toggle\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { productId } = await c.req.json();\n const added = await db.toggleWishlist(user.id, Number(productId));\n return c.json({ added });\n});\n\n// --- Reviews ---\napp.post(\"/api/products/:id/reviews\", async (c) => {\n const user = await requireUser(c.req.raw);\n const productId = Number(c.req.param(\"id\"));\n const { rating, title, body } = await c.req.json();\n if (!rating || rating < 1 || rating > 5) {\n return c.json({ error: \"Invalid rating\" }, 400);\n }\n await db.upsertReview({\n product_id: productId,\n user_id: user.id,\n rating: Number(rating),\n title: title || null,\n body: body || null,\n });\n return c.json({ ok: true });\n});\n\n// --- Addresses ---\napp.get(\"/api/addresses\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listAddresses(user.id));\n});\n\napp.post(\"/api/addresses\", async (c) => {\n const user = await requireUser(c.req.raw);\n const body = await c.req.json();\n const a = await db.createAddress(user.id, {\n label: body.label || null,\n full_name: body.full_name,\n line1: body.line1,\n line2: body.line2 || null,\n city: body.city,\n state: body.state || null,\n postal_code: body.postal_code,\n country: body.country || \"IN\",\n phone: body.phone || null,\n is_default: body.is_default ? 1 : 0,\n });\n return c.json(a);\n});\n\napp.delete(\"/api/addresses/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n await db.deleteAddress(user.id, Number(c.req.param(\"id\")));\n return c.json({ ok: true });\n});\n\n// --- Orders / Checkout ---\napp.post(\"/api/checkout\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { address } = await c.req.json();\n if (!address || !address.full_name || !address.line1) {\n return c.json({ error: \"Address required\" }, 400);\n }\n const order = await db.createOrder(user.id, address);\n return c.json(order);\n});\n\napp.get(\"/api/orders\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listUserOrders(user.id));\n});\n\napp.get(\"/api/orders/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n const order = await db.getOrder(Number(c.req.param(\"id\")), user.id);\n if (!order) return c.json({ error: \"Not found\" }, 404);\n return c.json(order);\n});\n\n// --- Recently viewed ---\napp.get(\"/api/recently-viewed\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listRecentlyViewed(user.id));\n});\n\n// --- AI Endpoints ---\napp.get(\"/api/ai/logs\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listUserAILogs(user.id));\n});\n\napp.post(\"/api/ai/recommend\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { interest } = await c.req.json();\n if (!interest) return c.json({ error: \"Interest required\" }, 400);\n const catalog = await db.listProducts({ limit: 40 });\n const recs = await ai.recommendGadgets(interest, catalog);\n // Hydrate with product objects\n const byId = new Map(catalog.map((p) => [p.id, p]));\n const enriched = recs\n .filter((r) => byId.has(r.productId))\n .map((r) => ({ ...r, product: byId.get(r.productId) }));\n await db.logAI(user?.id ?? null, \"recommend\", interest, JSON.stringify(recs));\n return c.json(enriched);\n});\n\napp.post(\"/api/ai/summarize/:id\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const id = Number(c.req.param(\"id\"));\n const product = await db.getProduct(id);\n if (!product) return c.json({ error: \"Not found\" }, 404);\n const summary = await ai.summarizeProduct(product);\n await db.logAI(user?.id ?? null, \"summary\", String(id), summary);\n return c.json({ summary });\n});\n\napp.post(\"/api/ai/compare\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { a, b } = await c.req.json();\n const [pa, pb] = await Promise.all([\n db.getProduct(Number(a)),\n db.getProduct(Number(b)),\n ]);\n if (!pa || !pb) return c.json({ error: \"Not found\" }, 404);\n const result = await ai.compareProducts(pa, pb);\n await db.logAI(user?.id ?? null, \"compare\", `${a} vs ${b}`, result);\n return c.json({ result });\n});\n\napp.post(\"/api/ai/chat\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { message, history } = await c.req.json();\n if (!message) return c.json({ error: \"Message required\" }, 400);\n const catalog = await db.listProducts({ limit: 20 });\n const reply = await ai.shoppingAssistant(message, history ?? [], catalog);\n await db.logAI(user?.id ?? null, \"chat\", message, reply);\n return c.json({ reply });\n});\n\napp.post(\"/api/ai/search-suggest\", async (c) => {\n const { query } = await c.req.json();\n const suggestions = await ai.searchSuggestions(query ?? \"\");\n return c.json({ suggestions });\n});\n\n// --- Seller routes ---\napp.get(\"/api/seller/products\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(\n await db.listProducts({\n sellerId: user.id,\n status: \"all\",\n limit: 200,\n }),\n );\n});\n\napp.post(\"/api/seller/products\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n const body = await c.req.json();\n if (!body.name || !body.price_cents || !body.category_id) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n const p = await db.createProduct({\n seller_id: user.id,\n category_id: Number(body.category_id),\n name: body.name,\n brand: body.brand || null,\n description: body.description || null,\n price_cents: Number(body.price_cents),\n stock: Number(body.stock ?? 0),\n image_url: body.image_url || null,\n specs_json: body.specs_json || null,\n });\n return c.json(p);\n});\n\napp.patch(\"/api/seller/products/:id\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n const updated = await db.updateProduct(\n id,\n user.role === \"admin\" ? null : user.id,\n body,\n );\n return c.json(updated);\n});\n\napp.delete(\"/api/seller/products/:id\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n await db.deleteProduct(\n Number(c.req.param(\"id\")),\n user.role === \"admin\" ? null : user.id,\n );\n return c.json({ ok: true });\n});\n\napp.get(\"/api/seller/orders\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(await db.listSellerOrders(user.id));\n});\n\napp.get(\"/api/seller/analytics\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(await db.sellerAnalytics(user.id));\n});\n\n// --- Admin routes ---\napp.get(\"/api/admin/analytics\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.adminAnalytics());\n});\n\napp.get(\"/api/admin/users\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listUsers());\n});\n\napp.patch(\"/api/admin/users/:id/role\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { role } = await c.req.json();\n await db.setUserRole(c.req.param(\"id\"), role);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/admin/products\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listProducts({ status: \"all\", limit: 200 }));\n});\n\napp.patch(\"/api/admin/products/:id/status\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { status } = await c.req.json();\n const updated = await db.updateProduct(Number(c.req.param(\"id\")), null, {\n status,\n });\n return c.json(updated);\n});\n\napp.get(\"/api/admin/orders\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listAllOrders());\n});\n\napp.patch(\"/api/admin/orders/:id/status\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { status } = await c.req.json();\n await db.updateOrderStatus(Number(c.req.param(\"id\")), status);\n return c.json({ ok: true });\n});\n\n// Wrap with OAuth middleware (adds /auth/login, /auth/callback, /auth/logout)\nexport default oauthMiddleware(app.fetch);\n","label",[158],"11599612-55ea-11f1-9899-ee650bb23af1","README.md","019e5013-9af2-7410-b348-1d302973472a",["D",1779459922585],"# 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**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",[169],"46e509ce-55ea-11f1-b10b-ee650bb23af1","shared","46e50aa0-55ea-11f1-b10b-ee650bb23af1",3,["D",1779460012519],"directory",[175],"115994c8-55ea-11f1-9899-ee650bb23af1","frontend","019e5013-9af2-7410-b348-192e420bc803",["D",1779459922585],[182],"46c2fe92-55ea-11f1-b10b-ee650bb23af1","backend","46c2ff50-55ea-11f1-b10b-ee650bb23af1",2,["D",1779460012296],[187],"pulls","branches","forks","envVars",{"_199":189,"_201":68},"connections",{"_199":68,"_200":68},"count","unfilledCount","emptyCount",{"_48":186,"_37":187,"_35":188,"_159":-5,"_46":47,"_45":189,"_161":64,"_43":498,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":499,"_32":500},{"_48":490,"_37":491,"_35":492,"_159":188,"_46":47,"_45":493,"_161":64,"_43":494,"_13":68,"_39":40,"_41":495,"_29":30,"_166":-5,"_241":496,"_32":497},{"_48":482,"_37":483,"_35":484,"_159":188,"_46":47,"_45":485,"_161":64,"_43":486,"_13":68,"_39":40,"_41":487,"_29":30,"_166":-5,"_241":488,"_32":489},{"_48":474,"_37":475,"_35":476,"_159":188,"_46":47,"_45":477,"_161":64,"_43":478,"_13":68,"_39":40,"_41":479,"_29":30,"_166":-5,"_241":480,"_32":481},{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":471,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":472,"_32":473},{"_48":466,"_37":465,"_35":459,"_159":183,"_46":47,"_45":467,"_161":64,"_43":468,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":469,"_32":470},{"_48":456,"_37":457,"_35":458,"_159":459,"_46":47,"_45":460,"_161":64,"_43":461,"_13":68,"_39":40,"_41":462,"_29":30,"_166":-5,"_241":463,"_32":464},{"_48":452,"_37":375,"_35":369,"_159":183,"_46":47,"_45":163,"_161":64,"_43":453,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":454,"_32":455},{"_48":448,"_37":431,"_35":425,"_159":369,"_46":47,"_45":426,"_161":64,"_43":449,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":450,"_32":451},{"_48":440,"_37":441,"_35":442,"_159":425,"_46":47,"_45":443,"_161":64,"_43":444,"_13":68,"_39":40,"_41":445,"_29":30,"_166":-5,"_241":446,"_32":447},{"_48":432,"_37":433,"_35":434,"_159":425,"_46":47,"_45":435,"_161":64,"_43":436,"_13":68,"_39":40,"_41":437,"_29":30,"_166":-5,"_241":438,"_32":439},{"_48":422,"_37":423,"_35":424,"_159":425,"_46":47,"_45":426,"_161":64,"_43":427,"_13":68,"_39":40,"_41":428,"_29":30,"_166":-5,"_241":429,"_32":430},{"_48":414,"_37":415,"_35":416,"_159":369,"_46":47,"_45":417,"_161":64,"_43":418,"_13":68,"_39":40,"_41":419,"_29":30,"_166":-5,"_241":420,"_32":421},{"_48":407,"_37":408,"_35":409,"_159":369,"_46":47,"_45":163,"_161":64,"_43":410,"_13":68,"_39":40,"_41":411,"_29":30,"_166":-5,"_241":412,"_32":413},{"_48":400,"_37":401,"_35":402,"_159":369,"_46":47,"_45":163,"_161":64,"_43":403,"_13":68,"_39":40,"_41":404,"_29":30,"_166":-5,"_241":405,"_32":406},{"_48":392,"_37":393,"_35":394,"_159":369,"_46":47,"_45":395,"_161":64,"_43":396,"_13":68,"_39":40,"_41":397,"_29":30,"_166":-5,"_241":398,"_32":399},{"_48":384,"_37":385,"_35":386,"_159":369,"_46":47,"_45":387,"_161":64,"_43":388,"_13":68,"_39":40,"_41":389,"_29":30,"_166":-5,"_241":390,"_32":391},{"_48":376,"_37":377,"_35":378,"_159":369,"_46":47,"_45":379,"_161":64,"_43":380,"_13":68,"_39":40,"_41":381,"_29":30,"_166":-5,"_241":382,"_32":383},{"_48":366,"_37":367,"_35":368,"_159":369,"_46":47,"_45":370,"_161":64,"_43":371,"_13":68,"_39":40,"_41":372,"_29":30,"_166":-5,"_241":373,"_32":374},{"_48":361,"_37":344,"_35":338,"_159":183,"_46":47,"_45":362,"_161":64,"_43":363,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":364,"_32":365},{"_48":353,"_37":354,"_35":355,"_159":338,"_46":47,"_45":356,"_161":64,"_43":357,"_13":68,"_39":40,"_41":358,"_29":30,"_166":-5,"_241":359,"_32":360},{"_48":345,"_37":346,"_35":347,"_159":338,"_46":47,"_45":348,"_161":64,"_43":349,"_13":68,"_39":40,"_41":350,"_29":30,"_166":-5,"_241":351,"_32":352},{"_48":335,"_37":336,"_35":337,"_159":338,"_46":47,"_45":339,"_161":64,"_43":340,"_13":68,"_39":40,"_41":341,"_29":30,"_166":-5,"_241":342,"_32":343},{"_48":328,"_37":329,"_35":330,"_159":183,"_46":47,"_45":331,"_161":64,"_43":332,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":333,"_32":334},{"_48":323,"_37":322,"_35":316,"_159":183,"_46":47,"_45":324,"_161":64,"_43":325,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":326,"_32":327},{"_48":313,"_37":314,"_35":315,"_159":316,"_46":47,"_45":317,"_161":64,"_43":318,"_13":68,"_39":40,"_41":319,"_29":30,"_166":-5,"_241":320,"_32":321},{"_48":308,"_37":299,"_35":295,"_159":183,"_46":47,"_45":309,"_161":64,"_43":310,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":311,"_32":312},{"_48":300,"_37":301,"_35":302,"_159":295,"_46":47,"_45":303,"_161":64,"_43":304,"_13":68,"_39":40,"_41":305,"_29":30,"_166":-5,"_241":306,"_32":307},{"_48":294,"_37":38,"_35":36,"_159":295,"_46":47,"_45":14,"_161":64,"_43":296,"_13":68,"_39":40,"_41":42,"_29":30,"_166":-5,"_241":297,"_32":298},{"_48":289,"_37":288,"_35":282,"_159":183,"_46":47,"_45":290,"_161":64,"_43":291,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":292,"_32":293},{"_48":279,"_37":280,"_35":281,"_159":282,"_46":47,"_45":283,"_161":64,"_43":284,"_13":68,"_39":40,"_41":285,"_29":30,"_166":-5,"_241":286,"_32":287},{"_48":272,"_37":273,"_35":274,"_159":183,"_46":47,"_45":163,"_161":64,"_43":275,"_13":68,"_39":26,"_41":276,"_29":30,"_166":-5,"_241":277,"_32":278},{"_48":265,"_37":266,"_35":267,"_159":183,"_46":47,"_45":163,"_161":64,"_43":268,"_13":68,"_39":26,"_41":269,"_29":30,"_166":-5,"_241":270,"_32":271},{"_48":258,"_37":259,"_35":260,"_159":183,"_46":47,"_45":163,"_161":64,"_43":261,"_13":68,"_39":40,"_41":262,"_29":30,"_166":-5,"_241":263,"_32":264},{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":177,"_161":64,"_43":255,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_241":256,"_32":257},{"_48":247,"_37":248,"_35":249,"_159":176,"_46":47,"_45":250,"_161":64,"_43":251,"_13":68,"_39":40,"_41":252,"_29":30,"_166":-5,"_241":253,"_32":254},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":244,"_13":68,"_39":26,"_41":172,"_29":30,"_166":-5,"_241":245,"_32":246},{"_48":157,"_37":158,"_35":62,"_159":-5,"_46":47,"_45":160,"_161":64,"_43":240,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_241":242,"_32":243},["D",1779460190161],"children",[],[158],["D",1779459922585],[],[169],"4dad08e2-55ea-11f1-b10b-ee650bb23af1","types.ts","4dad09b4-55ea-11f1-b10b-ee650bb23af1",4,["D",1779460023898],"// Shared TypeScript types used by both frontend and backend.\n\nexport type Role = \"customer\" | \"seller\" | \"admin\";\n\nexport interface User {\n id: string;\n handle: string;\n display_name: string | null;\n avatar_url: string | null;\n role: Role;\n created_at: string;\n}\n\nexport interface Category {\n id: number;\n slug: string;\n name: string;\n icon: string | null;\n}\n\nexport interface Product {\n id: number;\n seller_id: string;\n category_id: number | null;\n name: string;\n slug: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n status: \"pending\" | \"approved\" | \"rejected\";\n avg_rating: number;\n review_count: number;\n created_at: string;\n // Joined fields (optional, populated by queries)\n category_name?: string;\n category_slug?: string;\n seller_handle?: string;\n seller_name?: string;\n}\n\nexport interface CartItem {\n id: number;\n user_id: string;\n product_id: number;\n quantity: number;\n // joined\n product?: Product;\n}\n\nexport interface WishlistItem {\n id: number;\n user_id: string;\n product_id: number;\n product?: Product;\n}\n\nexport interface Review {\n id: number;\n product_id: number;\n user_id: string;\n rating: number;\n title: string | null;\n body: string | null;\n created_at: string;\n user_handle?: string;\n user_name?: string;\n}\n\nexport interface Address {\n id: number;\n user_id: string;\n label: string | null;\n full_name: string;\n line1: string;\n line2: string | null;\n city: string;\n state: string | null;\n postal_code: string;\n country: string;\n phone: string | null;\n is_default: number;\n}\n\nexport interface OrderItem {\n id: number;\n order_id: number;\n product_id: number;\n seller_id: string;\n quantity: number;\n unit_price_cents: number;\n product_snapshot_json: string | null;\n product?: Product;\n}\n\nexport interface Order {\n id: number;\n user_id: string;\n total_cents: number;\n status: \"pending\" | \"paid\" | \"shipped\" | \"delivered\" | \"cancelled\";\n address_json: string;\n created_at: string;\n items?: OrderItem[];\n}\n\nexport interface SessionInfo {\n user: User | null;\n loggedIn: boolean;\n}\n\nexport interface AIRecommendation {\n productId: number;\n reason: string;\n}\n",[],[175,248],["D",1779460012519],[237],[175],"1159913a-55ea-11f1-9899-ee650bb23af1","index.tsx","019e5013-9af2-7410-b348-145eb1a119fb",["D",1779459922585],"/** @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();",[],[182,259],"11598ca8-55ea-11f1-9899-ee650bb23af1","index.html","019e5013-9af2-7410-b348-10ee0c72fc8c",["D",1779459922585],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[182,266],"11598834-55ea-11f1-9899-ee650bb23af1","favicon.svg","019e5013-9af2-7410-b348-0d76706a1ef9",["D",1779459922585],"\n",[],[182,273],"c488c9e2-55ea-11f1-a4f1-ee650bb23af1","format.ts","c488cab4-55ea-11f1-a4f1-ee650bb23af1","ba17f064-55ea-11f1-8cff-ee650bb23af1",16,["D",1779460223300],"// Formatting helpers (price, dates, etc.).\n\nexport function formatPrice(cents: number): string {\n const rupees = cents / 100;\n return new Intl.NumberFormat(\"en-IN\", {\n style: \"currency\",\n currency: \"INR\",\n maximumFractionDigits: 0,\n }).format(rupees);\n}\n\nexport function formatDate(iso: string): string {\n try {\n return new Date(iso).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n } catch {\n return iso;\n }\n}\n\nexport function formatDateTime(iso: string): string {\n try {\n return new Date(iso).toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n } catch {\n return iso;\n }\n}\n\nexport function parseSpecs(json: string | null): Record {\n if (!json) return {};\n try {\n return JSON.parse(json);\n } catch {\n return {};\n }\n}\n",[],[182,288,280],"utils","ba17ef9c-55ea-11f1-8cff-ee650bb23af1",14,["D",1779460205795],[232],[182,288],"38406976-55eb-11f1-a8d0-ee650bb23af1","b827d5c6-55ea-11f1-a8d0-ee650bb23af1",["D",1779460417436],[],[182,299,38],"pages","28b10c0e-55eb-11f1-a2d2-ee650bb23af1","HomePage.tsx","28b10cfe-55eb-11f1-a2d2-ee650bb23af1",29,["D",1779460391344],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n useEffect,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Category, Product } from \"../../shared/types.ts\";\nimport { api } from \"../api/client.ts\";\nimport { ProductCard } from \"../components/ProductCard.tsx\";\nimport { ProductCardSkeleton } from \"../components/ui/Skeleton.tsx\";\nimport { Spinner } from \"../components/ui/Spinner.tsx\";\n\nexport function HomePage() {\n const [products, setProducts] = useState([]);\n const [categories, setCategories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [interest, setInterest] = useState(\"\");\n const [recs, setRecs] = useState<\n { product: Product; reason: string }[] | null\n >(null);\n const [recLoading, setRecLoading] = useState(false);\n const [recError, setRecError] = useState(null);\n\n useEffect(() => {\n Promise.all([\n api.get(\"/api/products?sort=rating&limit=8\"),\n api.get(\"/api/categories\"),\n ])\n .then(([p, c]) => {\n setProducts(p);\n setCategories(c);\n })\n .finally(() => setLoading(false));\n }, []);\n\n async function askAI() {\n if (!interest.trim()) return;\n setRecLoading(true);\n setRecError(null);\n try {\n const data = await api.post<{ product: Product; reason: string }[]>(\n \"/api/ai/recommend\",\n { interest },\n );\n setRecs(data);\n } catch (e) {\n setRecError((e as Error).message);\n } finally {\n setRecLoading(false);\n }\n }\n\n return (\n

\n {/* Hero */}\n

\n \n ✨ AI-powered shopping\n \n

\n The smartest way to{\" \"}\n \n shop gadgets\n \n

\n Discover, compare and buy the latest smart gadgets with personalized AI recommendations from our shopping genie.\n

\n\n {/* AI prompt box */}\n

\n \n Tell me what you need and I'll find the perfect gadgets:\n \n

\n setInterest(e.target.value)}\n onKeyDown={(e: any) => e.key === \"Enter\" && askAI()}\n placeholder='e.g. \"lightweight laptop for college student\"'\n class=\"flex-1 px-4 py-3 rounded-xl bg-white text-gray-900 placeholder-gray-400 outline-none focus:ring-2 focus:ring-yellow-200\"\n />\n \n {recLoading ? : \"✨\"} Ask AI\n \n

\n {recError && (\n

\n {recError}\n

\n )}\n

\n\n

\n {/* AI Recommendations */}\n {recs && (\n

\n ✨ AI Picks for You\n

\n setRecs(null)}\n class=\"text-sm text-gray-500 hover:text-gray-900\"\n >\n Clear\n \n

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

\n No matches found in our catalog for that query.\n

\n )\n : (\n

\n {recs.map((r) => (\n \n \n

\n ✨ {r.reason}\n

\n ))}\n

\n )}\n \n )}\n\n {/* Categories */}\n

\n Shop by category\n

\n {categories.map((c) => (\n \n

{c.icon}

{c.name}

\n \n ))}\n

\n\n {/* Top rated */}\n

\n ⭐ Top rated gadgets\n

\n \n View all →\n \n

\n {loading\n ? Array.from({ length: 8 }).map((_, i) => (\n \n ))\n : products.map((p) => )}\n

\n\n {/* Features strip */}\n

\n \n \n \n

\n \n );\n}\n\nfunction FeatureCard(\n { icon, title, description }: {\n icon: string;\n title: string;\n description: string;\n },\n) {\n return (\n

{icon}

{title}

{description}

\n );\n}\n",[],[182,299,301],"b827d526-55ea-11f1-a8d0-ee650bb23af1",9,["D",1779460202532],[229,230],[182,299],"0e816d24-55eb-11f1-96c2-ee650bb23af1","MainLayout.tsx","0e816dd8-55eb-11f1-96c2-ee650bb23af1","b9b7a768-55ea-11f1-8cff-ee650bb23af1",27,["D",1779460347412],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Navbar } from \"../components/Navbar.tsx\";\nimport { Footer } from \"../components/Footer.tsx\";\nimport { AIChat } from \"../components/AIChat.tsx\";\n\nexport function MainLayout() {\n return (\n

\n \n

\n );\n}\n",[],[182,322,314],"layouts","b9b7a6aa-55ea-11f1-8cff-ee650bb23af1",13,["D",1779460205163],[227],[182,322],"b917a434-55ea-11f1-a4f1-ee650bb23af1","hooks","b917a4f2-55ea-11f1-a4f1-ee650bb23af1",11,["D",1779460204113],[],[182,329],"d5394f28-55ea-11f1-8f09-ee650bb23af1","ToastContext.tsx","d5394ff0-55ea-11f1-8f09-ee650bb23af1","b877d198-55ea-11f1-a4f1-ee650bb23af1",19,["D",1779460251300],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n createContext,\n useCallback,\n useContext,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\n\ntype ToastKind = \"success\" | \"error\" | \"info\";\ninterface ToastItem {\n id: number;\n message: string;\n kind: ToastKind;\n}\n\ninterface ToastState {\n toast: (message: string, kind?: ToastKind) => void;\n items: ToastItem[];\n dismiss: (id: number) => void;\n}\n\nconst ToastContext = createContext(null);\n\nexport function ToastProvider({ children }: { children: any }) {\n const [items, setItems] = useState([]);\n\n const dismiss = useCallback((id: number) => {\n setItems((prev) => prev.filter((t) => t.id !== id));\n }, []);\n\n const toast = useCallback((message: string, kind: ToastKind = \"info\") => {\n const id = Date.now() + Math.random();\n setItems((prev) => [...prev, { id, message, kind }]);\n setTimeout(() => dismiss(id), 3500);\n }, [dismiss]);\n\n return (\n \n {children}\n \n \n );\n}\n\nfunction ToastViewport() {\n const ctx = useContext(ToastContext);\n if (!ctx) return null;\n return (\n

\n {ctx.items.map((t) => (\n ctx.dismiss(t.id)}\n >\n {t.message}\n

\n ))}\n \n );\n}\n\nexport function useToast(): ToastState {\n const ctx = useContext(ToastContext);\n if (!ctx) throw new Error(\"useToast must be used within ToastProvider\");\n return ctx;\n}\n",[],[182,344,336],"contexts","d00da8b4-55ea-11f1-8f09-ee650bb23af1","CartContext.tsx","d00da9a4-55ea-11f1-8f09-ee650bb23af1",18,["D",1779460242633],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n createContext,\n useCallback,\n useContext,\n useEffect,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport type { CartItem } from \"../../shared/types.ts\";\nimport { api } from \"../api/client.ts\";\nimport { useAuth } from \"./AuthContext.tsx\";\nimport { useToast } from \"./ToastContext.tsx\";\n\ninterface CartState {\n items: CartItem[];\n count: number;\n totalCents: number;\n loading: boolean;\n refresh: () => Promise;\n add: (productId: number, quantity?: number) => Promise;\n update: (itemId: number, quantity: number) => Promise;\n remove: (itemId: number) => Promise;\n}\n\nconst CartContext = createContext(null);\n\nexport function CartProvider({ children }: { children: any }) {\n const { user } = useAuth();\n const { toast } = useToast();\n const [items, setItems] = useState([]);\n const [loading, setLoading] = useState(false);\n\n const refresh = useCallback(async () => {\n if (!user) {\n setItems([]);\n return;\n }\n setLoading(true);\n try {\n const data = await api.get(\"/api/cart\");\n setItems(data);\n } catch {\n setItems([]);\n } finally {\n setLoading(false);\n }\n }, [user]);\n\n useEffect(() => {\n refresh();\n }, [refresh]);\n\n const add = useCallback(async (productId: number, quantity = 1) => {\n if (!user) {\n toast(\"Please log in to add to cart\", \"error\");\n return;\n }\n try {\n const data = await api.post(\"/api/cart\", {\n productId,\n quantity,\n });\n setItems(data);\n toast(\"Added to cart\", \"success\");\n } catch (e) {\n toast((e as Error).message, \"error\");\n }\n }, [user, toast]);\n\n const update = useCallback(async (itemId: number, quantity: number) => {\n const data = await api.patch(`/api/cart/${itemId}`, {\n quantity,\n });\n setItems(data);\n }, []);\n\n const remove = useCallback(async (itemId: number) => {\n const data = await api.del(`/api/cart/${itemId}`);\n setItems(data);\n }, []);\n\n const count = items.reduce((s, it) => s + it.quantity, 0);\n const totalCents = items.reduce(\n (s, it) => s + (it.product?.price_cents ?? 0) * it.quantity,\n 0,\n );\n\n return (\n \n {children}\n \n );\n}\n\nexport function useCart(): CartState {\n const ctx = useContext(CartContext);\n if (!ctx) throw new Error(\"useCart must be used within CartProvider\");\n return ctx;\n}\n",[],[182,344,346],"c9ddf52a-55ea-11f1-a4f1-ee650bb23af1","AuthContext.tsx","c9ddf5d4-55ea-11f1-a4f1-ee650bb23af1",17,["D",1779460232247],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n createContext,\n useCallback,\n useContext,\n useEffect,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport type { User } from \"../../shared/types.ts\";\nimport { api } from \"../api/client.ts\";\n\ninterface AuthState {\n user: User | null;\n loading: boolean;\n refresh: () => Promise;\n setRole: (role: \"customer\" | \"seller\" | \"admin\") => Promise;\n}\n\nconst AuthContext = createContext(null);\n\nexport function AuthProvider({ children }: { children: any }) {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const refresh = useCallback(async () => {\n try {\n const { user } = await api.get<{ user: User | null }>(\"/api/session\");\n setUser(user);\n } catch {\n setUser(null);\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n refresh();\n }, [refresh]);\n\n const setRole = useCallback(async (role: \"customer\" | \"seller\" | \"admin\") => {\n await api.post(\"/api/me/role\", { role });\n await refresh();\n }, [refresh]);\n\n return (\n \n {children}\n \n );\n}\n\nexport function useAuth(): AuthState {\n const ctx = useContext(AuthContext);\n if (!ctx) throw new Error(\"useAuth must be used within AuthProvider\");\n return ctx;\n}\n",[],[182,344,354],"b877d09e-55ea-11f1-a4f1-ee650bb23af1",10,["D",1779460203060],[222,223,224],[182,344],"1297b030-55eb-11f1-96c2-ee650bb23af1","RequireAuth.tsx","1297b0f8-55eb-11f1-96c2-ee650bb23af1","019e5013-9af2-7410-b348-081fa6ae7764",28,["D",1779460354269],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useAuth } from \"../contexts/AuthContext.tsx\";\nimport { FullPageSpinner } from \"./ui/Spinner.tsx\";\nimport { EmptyState } from \"./ui/EmptyState.tsx\";\n\nexport function RequireAuth(\n { children, roles }: {\n children: any;\n roles?: (\"customer\" | \"seller\" | \"admin\")[];\n },\n) {\n const { user, loading } = useAuth();\n if (loading) return ;\n if (!user) {\n return (\n

\n \n Log in\n \n }\n />\n

\n );\n }\n if (roles && !roles.includes(user.role)) {\n return (\n

\n \n Go to Profile\n \n }\n />\n

\n );\n }\n return children;\n}\n",[],[182,375,367],"components","e5395f3a-55ea-11f1-9ebd-ee650bb23af1","ProductCard.tsx","e539602a-55ea-11f1-9ebd-ee650bb23af1",23,["D",1779460278149],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Product } from \"../../shared/types.ts\";\nimport { formatPrice } from \"../utils/format.ts\";\nimport { useCart } from \"../contexts/CartContext.tsx\";\n\nexport function ProductCard({ product }: { product: Product }) {\n const { add } = useCart();\n\n return (\n

\n \n {product.image_url\n ? (\n \n )\n : (\n

\n 📦\n

\n )}\n {product.stock <= 5 && product.stock > 0 && (\n \n Only {product.stock} left\n \n )}\n {product.stock === 0 && (\n \n Out of stock\n \n )}\n \n

\n {product.brand}\n

\n \n {product.name}\n \n

\n ★\n {product.avg_rating.toFixed(1)}\n ({product.review_count})\n

\n {formatPrice(product.price_cents)}\n

\n add(product.id, 1)}\n disabled={product.stock === 0}\n class=\"px-3 py-1.5 bg-indigo-600 text-white text-sm font-medium rounded-lg hover:bg-indigo-700 disabled:bg-gray-300 disabled:cursor-not-allowed transition-colors\"\n >\n Add\n \n

\n );\n}\n",[],[182,375,377],"f861c6e2-55ea-11f1-96c2-ee650bb23af1","Navbar.tsx","f861c7fa-55ea-11f1-96c2-ee650bb23af1",24,["D",1779460310293],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Link,\n NavLink,\n useNavigate,\n} from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { useAuth } from \"../contexts/AuthContext.tsx\";\nimport { useCart } from \"../contexts/CartContext.tsx\";\n\nexport function Navbar() {\n const { user, loading } = useAuth();\n const { count } = useCart();\n const [search, setSearch] = useState(\"\");\n const [menuOpen, setMenuOpen] = useState(false);\n const navigate = useNavigate();\n\n function onSearch(e: any) {\n e.preventDefault();\n if (!search.trim()) return;\n navigate(`/products?search=${encodeURIComponent(search.trim())}`);\n }\n\n async function logout() {\n await fetch(\"/auth/logout\", { method: \"POST\" });\n location.href = \"/\";\n }\n\n return (\n

\n \n ⚡\n \n SmartGadgets\n \n \n\n \n\n

\n \n `px-3 py-1.5 rounded-lg font-medium transition-colors ${\n isActive\n ? \"bg-indigo-50 text-indigo-700\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n Shop\n \n \n `px-3 py-1.5 rounded-lg font-medium transition-colors flex items-center gap-1 ${\n isActive\n ? \"bg-purple-50 text-purple-700\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n ✨ AI Assistant\n \n {user?.role === \"seller\" && (\n \n `px-3 py-1.5 rounded-lg font-medium transition-colors ${\n isActive\n ? \"bg-green-50 text-green-700\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n Seller\n \n )}\n {user?.role === \"admin\" && (\n \n `px-3 py-1.5 rounded-lg font-medium transition-colors ${\n isActive\n ? \"bg-red-50 text-red-700\"\n : \"text-gray-700 hover:bg-gray-100\"\n }`}\n >\n Admin\n \n )}\n

\n\n

\n {/* mobile search */}\n

\n );\n}\n\nfunction MenuLink(\n { to, children, onClick }: { to: string; children: any; onClick: () => void },\n) {\n return (\n \n {children}\n \n );\n}\n\nexport function RoleBadge({ role }: { role: string }) {\n const styles: Record = {\n customer: \"bg-blue-100 text-blue-700\",\n seller: \"bg-green-100 text-green-700\",\n admin: \"bg-red-100 text-red-700\",\n };\n return (\n \n {role}\n \n );\n}\n",[],[182,375,385],"fec4a8ba-55ea-11f1-a2d2-ee650bb23af1","Footer.tsx","fec4a950-55ea-11f1-a2d2-ee650bb23af1",25,["D",1779460321007],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0,react-dom@18.2.0\";\n\nexport function Footer() {\n return (\n \n );\n}\n\nfunction FooterCol(\n { title, links }: {\n title: string;\n links: { to: string; label: string; external?: boolean }[];\n },\n) {\n return (\n

{title}

\n {l.label}\n
\n {l.label}\n

\n );\n}\n",[],[182,375,393],"11597e0c-55ea-11f1-9899-ee650bb23af1","Counter.tsx","019e5013-9af2-7410-b348-0417e0c0ad1c",["D",1779459922585],"/** @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",[],[182,375,401],"11595e04-55ea-11f1-9899-ee650bb23af1","App.tsx","019e5013-9af2-7410-b348-01a6c13d4f00",["D",1779459922585],"/** @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",[],[182,375,408],"0c4d59d2-55eb-11f1-b2ca-ee650bb23af1","AIChat.tsx","0c4d5aa4-55eb-11f1-b2ca-ee650bb23af1",26,["D",1779460343714],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n useEffect,\n useRef,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api/client.ts\";\n\ninterface Msg {\n role: \"user\" | \"assistant\";\n content: string;\n}\n\nexport function AIChat() {\n const [open, setOpen] = useState(false);\n const [messages, setMessages] = useState([\n {\n role: \"assistant\",\n content:\n \"Hi! I'm GadgetGenie ✨ I can recommend gadgets, compare specs, or answer shopping questions. What are you looking for?\",\n },\n ]);\n const [input, setInput] = useState(\"\");\n const [sending, setSending] = useState(false);\n const scrollRef = useRef(null);\n\n useEffect(() => {\n if (scrollRef.current) {\n scrollRef.current.scrollTop = scrollRef.current.scrollHeight;\n }\n }, [messages, open]);\n\n async function send() {\n const text = input.trim();\n if (!text || sending) return;\n setInput(\"\");\n const next = [...messages, { role: \"user\" as const, content: text }];\n setMessages(next);\n setSending(true);\n try {\n const { reply } = await api.post<{ reply: string }>(\"/api/ai/chat\", {\n message: text,\n history: messages.slice(-6),\n });\n setMessages([...next, { role: \"assistant\", content: reply }]);\n } catch (e) {\n setMessages([\n ...next,\n {\n role: \"assistant\",\n content: `⚠️ ${\n (e as Error).message\n }. Make sure GEMINI_API_KEY is set on the val.`,\n },\n ]);\n } finally {\n setSending(false);\n }\n }\n\n return (\n <>\n setOpen((v) => !v)}\n class=\"fixed bottom-6 right-6 z-40 w-14 h-14 rounded-full bg-gradient-to-br from-purple-600 to-indigo-600 text-white shadow-xl hover:shadow-2xl hover:scale-105 transition-all flex items-center justify-center\"\n title=\"AI Shopping Assistant\"\n >\n {open ? \"×\" : \"✨\"}\n \n\n {open && (\n

GadgetGenie ✨

\n Your AI shopping assistant — powered by Gemini\n

\n {messages.map((m, i) => (\n \n \n {m.content}\n

\n ))}\n {sending && (\n

\n \n \n \n \n \n

\n )}\n \n {\n e.preventDefault();\n send();\n }}\n class=\"p-3 border-t border-gray-100 flex gap-2\"\n >\n setInput(e.target.value)}\n placeholder=\"Ask me anything…\"\n class=\"flex-1 px-3 py-2 bg-gray-100 rounded-full text-sm outline-none focus:ring-2 focus:ring-indigo-200\"\n />\n \n Send\n \n \n \n )}\n \n );\n}\n",[],[182,375,415],"d902b64e-55ea-11f1-be79-ee650bb23af1","Spinner.tsx","d902b70c-55ea-11f1-be79-ee650bb23af1","2f928722-477e-41be-adc1-9eade4ff903b",20,["D",1779460257661],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nexport function Spinner({ size = \"md\" }: { size?: \"sm\" | \"md\" | \"lg\" }) {\n const cls = size === \"sm\" ? \"w-4 h-4\" : size === \"lg\" ? \"w-10 h-10\" : \"w-6 h-6\";\n return (\n \n );\n}\n\nexport function FullPageSpinner() {\n return (\n

\n \n

\n );\n}\n",[],[182,375,431,423],"ui","db4256f8-55ea-11f1-a4f1-ee650bb23af1","Skeleton.tsx","db4257ca-55ea-11f1-a4f1-ee650bb23af1",21,["D",1779460261416],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nexport function Skeleton({ class: className = \"\" }: { class?: string }) {\n return

;\n}\n\nexport function ProductCardSkeleton() {\n return (\n

\n \n

\n \n \n \n \n

\n );\n}\n",[],[182,375,431,433],"dd0f18f4-55ea-11f1-a4f1-ee650bb23af1","EmptyState.tsx","dd0f19b2-55ea-11f1-a4f1-ee650bb23af1",22,["D",1779460264454],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nexport function EmptyState({\n icon = \"📭\",\n title,\n description,\n action,\n}: {\n icon?: string;\n title: string;\n description?: string;\n action?: any;\n}) {\n return (\n

{icon}

{title}

\n {description &&

{description}

}\n {action}\n

\n );\n}\n",[],[182,375,431,441],"d902e402-55ea-11f1-be79-ee650bb23af1",["D",1779460257661],[211,212,213],[182,375,431],"11598596-55ea-11f1-9899-ee650bb23af1",["D",1779459922585],[210,214,215,216,217,218,219,220],[182,375],"c1d73364-55ea-11f1-a8d0-ee650bb23af1","client.ts","c1d73422-55ea-11f1-a8d0-ee650bb23af1","b96dca9e-55ea-11f1-a8d0-ee650bb23af1",15,["D",1779460218789],"// Typed fetch wrapper for the API.\n\nasync function request(\n path: string,\n options: RequestInit = {},\n): Promise {\n const res = await fetch(path, {\n ...options,\n headers: {\n \"Content-Type\": \"application/json\",\n ...(options.headers ?? {}),\n },\n });\n const text = await res.text();\n let data: unknown = null;\n try {\n data = text ? JSON.parse(text) : null;\n } catch {\n data = text;\n }\n if (!res.ok) {\n const message = (data as { error?: string })?.error ?? `HTTP ${res.status}`;\n throw new ApiError(res.status, message);\n }\n return data as T;\n}\n\nexport class ApiError extends Error {\n constructor(public status: number, message: string) {\n super(message);\n }\n}\n\nexport const api = {\n get: (path: string) => request(path),\n post: (path: string, body?: unknown) =>\n request(path, { method: \"POST\", body: JSON.stringify(body ?? {}) }),\n patch: (path: string, body?: unknown) =>\n request(path, { method: \"PATCH\", body: JSON.stringify(body ?? {}) }),\n del: (path: string) => request(path, { method: \"DELETE\" }),\n};\n",[],[182,465,457],"api","b96dc9cc-55ea-11f1-a8d0-ee650bb23af1",12,["D",1779460204674],[208],[182,465],["D",1779459922585],[207,209,221,225,226,228,231,233,234,235],[182],"7c6c1290-55ea-11f1-972f-ee650bb23af1","db.ts","7c6c1358-55ea-11f1-972f-ee650bb23af1",5,["D",1779460102303],"// Project-scoped SQLite helpers. All queries go through here.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type {\n Address,\n CartItem,\n Category,\n Order,\n OrderItem,\n Product,\n Review,\n User,\n} from \"../shared/types.ts\";\n\ntype Row = Record;\n\n// --- Users ---\n\nexport async function getUser(id: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as User | undefined) ?? null;\n}\n\nexport async function upsertUser(u: {\n id: string;\n handle: string;\n display_name?: string | null;\n avatar_url?: string | null;\n}): Promise {\n const existing = await getUser(u.id);\n if (existing) {\n await sqlite.execute({\n sql: \"UPDATE users SET handle = ?, display_name = ?, avatar_url = ? WHERE id = ?\",\n args: [u.handle, u.display_name ?? null, u.avatar_url ?? null, u.id],\n });\n return (await getUser(u.id))!;\n }\n await sqlite.execute({\n sql:\n \"INSERT INTO users (id, handle, display_name, avatar_url, role) VALUES (?, ?, ?, ?, 'customer')\",\n args: [u.id, u.handle, u.display_name ?? null, u.avatar_url ?? null],\n });\n return (await getUser(u.id))!;\n}\n\nexport async function setUserRole(\n id: string,\n role: \"customer\" | \"seller\" | \"admin\",\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE users SET role = ? WHERE id = ?\",\n args: [role, id],\n });\n}\n\nexport async function listUsers(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM users ORDER BY created_at DESC\",\n );\n return r.rows as unknown as User[];\n}\n\n// --- Categories ---\n\nexport async function listCategories(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM categories ORDER BY name ASC\",\n );\n return r.rows as unknown as Category[];\n}\n\n// --- Products ---\n\nconst PRODUCT_SELECT = `\n SELECT p.*,\n c.name AS category_name,\n c.slug AS category_slug,\n u.handle AS seller_handle,\n u.display_name AS seller_name\n FROM products p\n LEFT JOIN categories c ON c.id = p.category_id\n LEFT JOIN users u ON u.id = p.seller_id\n`;\n\nexport interface ProductQuery {\n search?: string;\n category?: string;\n minPrice?: number;\n maxPrice?: number;\n sort?: \"newest\" | \"price_asc\" | \"price_desc\" | \"rating\";\n status?: \"pending\" | \"approved\" | \"rejected\" | \"all\";\n sellerId?: string;\n limit?: number;\n offset?: number;\n}\n\nexport async function listProducts(q: ProductQuery = {}): Promise {\n const where: string[] = [];\n const args: unknown[] = [];\n if (q.status && q.status !== \"all\") {\n where.push(\"p.status = ?\");\n args.push(q.status);\n } else if (!q.status) {\n where.push(\"p.status = 'approved'\");\n }\n if (q.search) {\n where.push(\"(p.name LIKE ? OR p.brand LIKE ? OR p.description LIKE ?)\");\n const term = `%${q.search}%`;\n args.push(term, term, term);\n }\n if (q.category) {\n where.push(\"c.slug = ?\");\n args.push(q.category);\n }\n if (q.minPrice != null) {\n where.push(\"p.price_cents >= ?\");\n args.push(q.minPrice);\n }\n if (q.maxPrice != null) {\n where.push(\"p.price_cents <= ?\");\n args.push(q.maxPrice);\n }\n if (q.sellerId) {\n where.push(\"p.seller_id = ?\");\n args.push(q.sellerId);\n }\n\n let order = \"p.created_at DESC\";\n if (q.sort === \"price_asc\") order = \"p.price_cents ASC\";\n else if (q.sort === \"price_desc\") order = \"p.price_cents DESC\";\n else if (q.sort === \"rating\") order = \"p.avg_rating DESC, p.review_count DESC\";\n\n const limit = Math.min(q.limit ?? 100, 200);\n const offset = q.offset ?? 0;\n\n const sql = `${PRODUCT_SELECT} ${\n where.length ? \"WHERE \" + where.join(\" AND \") : \"\"\n } ORDER BY ${order} LIMIT ? OFFSET ?`;\n args.push(limit, offset);\n\n const r = await sqlite.execute({ sql, args });\n return r.rows as unknown as Product[];\n}\n\nexport async function getProduct(id: number): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT} WHERE p.id = ?`,\n args: [id],\n });\n return (r.rows[0] as Product | undefined) ?? null;\n}\n\nexport async function getProductBySlug(slug: string): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT} WHERE p.slug = ?`,\n args: [slug],\n });\n return (r.rows[0] as Product | undefined) ?? null;\n}\n\nexport async function createProduct(p: {\n seller_id: string;\n category_id: number;\n name: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n}): Promise {\n const slug = p.name\n .toLowerCase()\n .replace(/[^a-z0-9]+/g, \"-\")\n .replace(/^-+|-+$/g, \"\") +\n \"-\" +\n Math.random().toString(36).slice(2, 6);\n const r = await sqlite.execute({\n sql:\n \"INSERT INTO products (seller_id, category_id, name, slug, brand, description, price_cents, stock, image_url, specs_json, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending')\",\n args: [\n p.seller_id,\n p.category_id,\n p.name,\n slug,\n p.brand,\n p.description,\n p.price_cents,\n p.stock,\n p.image_url,\n p.specs_json,\n ],\n });\n return (await getProduct(Number(r.lastInsertRowid)))!;\n}\n\nexport async function updateProduct(\n id: number,\n sellerId: string | null,\n patch: Partial<{\n name: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n category_id: number;\n status: \"pending\" | \"approved\" | \"rejected\";\n }>,\n): Promise {\n const fields: string[] = [];\n const args: unknown[] = [];\n for (const [k, v] of Object.entries(patch)) {\n fields.push(`${k} = ?`);\n args.push(v);\n }\n if (!fields.length) return getProduct(id);\n let sql = `UPDATE products SET ${fields.join(\", \")} WHERE id = ?`;\n args.push(id);\n if (sellerId) {\n sql += \" AND seller_id = ?\";\n args.push(sellerId);\n }\n await sqlite.execute({ sql, args });\n return getProduct(id);\n}\n\nexport async function deleteProduct(\n id: number,\n sellerId: string | null,\n): Promise {\n if (sellerId) {\n await sqlite.execute({\n sql: \"DELETE FROM products WHERE id = ? AND seller_id = ?\",\n args: [id, sellerId],\n });\n } else {\n await sqlite.execute({\n sql: \"DELETE FROM products WHERE id = ?\",\n args: [id],\n });\n }\n}\n\n// --- Cart ---\n\nexport async function getCart(userId: string): Promise {\n const r = await sqlite.execute({\n sql: `SELECT ci.*, p.name AS p_name, p.slug AS p_slug, p.price_cents AS p_price_cents,\n p.image_url AS p_image_url, p.stock AS p_stock, p.brand AS p_brand\n FROM cart_items ci\n JOIN products p ON p.id = ci.product_id\n WHERE ci.user_id = ?\n ORDER BY ci.created_at DESC`,\n args: [userId],\n });\n return (r.rows as Row[]).map((row) => ({\n id: row.id as number,\n user_id: row.user_id as string,\n product_id: row.product_id as number,\n quantity: row.quantity as number,\n product: {\n id: row.product_id as number,\n name: row.p_name as string,\n slug: row.p_slug as string,\n price_cents: row.p_price_cents as number,\n image_url: (row.p_image_url as string) ?? null,\n stock: row.p_stock as number,\n brand: (row.p_brand as string) ?? null,\n } as Product,\n }));\n}\n\nexport async function addToCart(\n userId: string,\n productId: number,\n quantity: number,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO cart_items (user_id, product_id, quantity) VALUES (?, ?, ?)\n ON CONFLICT(user_id, product_id) DO UPDATE SET quantity = quantity + excluded.quantity`,\n args: [userId, productId, quantity],\n });\n}\n\nexport async function updateCartItem(\n userId: string,\n itemId: number,\n quantity: number,\n): Promise {\n if (quantity <= 0) {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE id = ? AND user_id = ?\",\n args: [itemId, userId],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE cart_items SET quantity = ? WHERE id = ? AND user_id = ?\",\n args: [quantity, itemId, userId],\n });\n }\n}\n\nexport async function removeCartItem(\n userId: string,\n itemId: number,\n): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE id = ? AND user_id = ?\",\n args: [itemId, userId],\n });\n}\n\nexport async function clearCart(userId: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE user_id = ?\",\n args: [userId],\n });\n}\n\n// --- Wishlist ---\n\nexport async function getWishlist(userId: string) {\n const r = await sqlite.execute({\n sql: `SELECT w.id, w.user_id, w.product_id, p.*\n FROM wishlists w\n JOIN products p ON p.id = w.product_id\n WHERE w.user_id = ?\n ORDER BY w.created_at DESC`,\n args: [userId],\n });\n return r.rows as unknown as (Product & { user_id: string })[];\n}\n\nexport async function toggleWishlist(\n userId: string,\n productId: number,\n): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM wishlists WHERE user_id = ? AND product_id = ?\",\n args: [userId, productId],\n });\n if (existing.rows.length) {\n await sqlite.execute({\n sql: \"DELETE FROM wishlists WHERE user_id = ? AND product_id = ?\",\n args: [userId, productId],\n });\n return false;\n }\n await sqlite.execute({\n sql: \"INSERT INTO wishlists (user_id, product_id) VALUES (?, ?)\",\n args: [userId, productId],\n });\n return true;\n}\n\n// --- Reviews ---\n\nexport async function listReviews(productId: number): Promise {\n const r = await sqlite.execute({\n sql: `SELECT r.*, u.handle AS user_handle, u.display_name AS user_name\n FROM reviews r\n JOIN users u ON u.id = r.user_id\n WHERE r.product_id = ?\n ORDER BY r.created_at DESC`,\n args: [productId],\n });\n return r.rows as unknown as Review[];\n}\n\nexport async function upsertReview(r: {\n product_id: number;\n user_id: string;\n rating: number;\n title: string | null;\n body: string | null;\n}): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO reviews (product_id, user_id, rating, title, body) VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(product_id, user_id) DO UPDATE SET rating=excluded.rating, title=excluded.title, body=excluded.body`,\n args: [r.product_id, r.user_id, r.rating, r.title, r.body],\n });\n await recomputeProductRating(r.product_id);\n}\n\nasync function recomputeProductRating(productId: number): Promise {\n const r = await sqlite.execute({\n sql:\n \"SELECT AVG(rating) AS avg, COUNT(*) AS cnt FROM reviews WHERE product_id = ?\",\n args: [productId],\n });\n const row = r.rows[0] as { avg: number | null; cnt: number };\n await sqlite.execute({\n sql:\n \"UPDATE products SET avg_rating = ?, review_count = ? WHERE id = ?\",\n args: [row.avg ?? 0, row.cnt ?? 0, productId],\n });\n}\n\n// --- Addresses ---\n\nexport async function listAddresses(userId: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM addresses WHERE user_id = ? ORDER BY is_default DESC, id DESC\",\n args: [userId],\n });\n return r.rows as unknown as Address[];\n}\n\nexport async function createAddress(\n userId: string,\n a: Omit,\n): Promise

{\n if (a.is_default) {\n await sqlite.execute({\n sql: \"UPDATE addresses SET is_default = 0 WHERE user_id = ?\",\n args: [userId],\n });\n }\n const r = await sqlite.execute({\n sql:\n \"INSERT INTO addresses (user_id, label, full_name, line1, line2, city, state, postal_code, country, phone, is_default) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [\n userId,\n a.label,\n a.full_name,\n a.line1,\n a.line2,\n a.city,\n a.state,\n a.postal_code,\n a.country,\n a.phone,\n a.is_default ? 1 : 0,\n ],\n });\n const created = await sqlite.execute({\n sql: \"SELECT * FROM addresses WHERE id = ?\",\n args: [Number(r.lastInsertRowid)],\n });\n return created.rows[0] as unknown as Address;\n}\n\nexport async function deleteAddress(\n userId: string,\n addressId: number,\n): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM addresses WHERE id = ? AND user_id = ?\",\n args: [addressId, userId],\n });\n}\n\n// --- Orders ---\n\nexport async function createOrder(\n userId: string,\n address: Record,\n): Promise {\n const cart = await getCart(userId);\n if (!cart.length) throw new Error(\"Cart is empty\");\n\n // Verify stock\n for (const item of cart) {\n if (!item.product || item.product.stock < item.quantity) {\n throw new Error(`Insufficient stock for ${item.product?.name}`);\n }\n }\n\n const total = cart.reduce(\n (sum, it) => sum + (it.product?.price_cents ?? 0) * it.quantity,\n 0,\n );\n\n const orderResult = await sqlite.execute({\n sql:\n \"INSERT INTO orders (user_id, total_cents, status, address_json) VALUES (?, ?, 'paid', ?)\",\n args: [userId, total, JSON.stringify(address)],\n });\n const orderId = Number(orderResult.lastInsertRowid);\n\n // Insert items + decrement stock\n for (const item of cart) {\n const p = item.product!;\n await sqlite.execute({\n sql:\n \"INSERT INTO order_items (order_id, product_id, seller_id, quantity, unit_price_cents, product_snapshot_json) VALUES (?, ?, (SELECT seller_id FROM products WHERE id = ?), ?, ?, ?)\",\n args: [\n orderId,\n p.id,\n p.id,\n item.quantity,\n p.price_cents,\n JSON.stringify(p),\n ],\n });\n await sqlite.execute({\n sql: \"UPDATE products SET stock = stock - ? WHERE id = ?\",\n args: [item.quantity, p.id],\n });\n }\n\n await clearCart(userId);\n return (await getOrder(orderId, userId))!;\n}\n\nexport async function getOrder(\n orderId: number,\n userId: string | null,\n): Promise {\n const sql = userId\n ? \"SELECT * FROM orders WHERE id = ? AND user_id = ?\"\n : \"SELECT * FROM orders WHERE id = ?\";\n const args = userId ? [orderId, userId] : [orderId];\n const r = await sqlite.execute({ sql, args });\n const order = r.rows[0] as Order | undefined;\n if (!order) return null;\n const items = await sqlite.execute({\n sql: \"SELECT * FROM order_items WHERE order_id = ?\",\n args: [orderId],\n });\n order.items = items.rows as unknown as OrderItem[];\n return order;\n}\n\nexport async function listUserOrders(userId: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC\",\n args: [userId],\n });\n return r.rows as unknown as Order[];\n}\n\nexport async function listSellerOrders(sellerId: string): Promise {\n const r = await sqlite.execute({\n sql: `SELECT DISTINCT o.* FROM orders o\n JOIN order_items oi ON oi.order_id = o.id\n WHERE oi.seller_id = ?\n ORDER BY o.created_at DESC`,\n args: [sellerId],\n });\n const orders = r.rows as unknown as Order[];\n for (const o of orders) {\n const items = await sqlite.execute({\n sql: \"SELECT * FROM order_items WHERE order_id = ? AND seller_id = ?\",\n args: [o.id, sellerId],\n });\n o.items = items.rows as unknown as OrderItem[];\n }\n return orders;\n}\n\nexport async function listAllOrders(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM orders ORDER BY created_at DESC LIMIT 200\",\n );\n return r.rows as unknown as Order[];\n}\n\nexport async function updateOrderStatus(\n orderId: number,\n status: Order[\"status\"],\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE orders SET status = ? WHERE id = ?\",\n args: [status, orderId],\n });\n}\n\n// --- Recently viewed ---\n\nexport async function trackView(\n userId: string,\n productId: number,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO recently_viewed (user_id, product_id) VALUES (?, ?)\n ON CONFLICT(user_id, product_id) DO UPDATE SET viewed_at = CURRENT_TIMESTAMP`,\n args: [userId, productId],\n });\n}\n\nexport async function listRecentlyViewed(userId: string): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT}\n JOIN recently_viewed rv ON rv.product_id = p.id\n WHERE rv.user_id = ?\n ORDER BY rv.viewed_at DESC\n LIMIT 12`,\n args: [userId],\n });\n return r.rows as unknown as Product[];\n}\n\n// --- Analytics ---\n\nexport async function adminAnalytics() {\n const [users, products, orders, revenue, topProducts, recentOrders] =\n await Promise.all([\n sqlite.execute(\n \"SELECT role, COUNT(*) AS n FROM users GROUP BY role\",\n ),\n sqlite.execute(\n \"SELECT status, COUNT(*) AS n FROM products GROUP BY status\",\n ),\n sqlite.execute(\"SELECT COUNT(*) AS n FROM orders\"),\n sqlite.execute(\n \"SELECT COALESCE(SUM(total_cents),0) AS revenue FROM orders WHERE status != 'cancelled'\",\n ),\n sqlite.execute(\n `SELECT p.id, p.name, p.image_url, SUM(oi.quantity) AS units, SUM(oi.unit_price_cents * oi.quantity) AS revenue\n FROM order_items oi\n JOIN products p ON p.id = oi.product_id\n GROUP BY p.id\n ORDER BY units DESC\n LIMIT 5`,\n ),\n sqlite.execute(\n `SELECT DATE(created_at) AS day, COUNT(*) AS orders, SUM(total_cents) AS revenue\n FROM orders\n GROUP BY DATE(created_at)\n ORDER BY day DESC\n LIMIT 14`,\n ),\n ]);\n return {\n userCounts: users.rows,\n productCounts: products.rows,\n orderCount: (orders.rows[0] as { n: number }).n,\n revenueCents: (revenue.rows[0] as { revenue: number }).revenue,\n topProducts: topProducts.rows,\n dailyOrders: recentOrders.rows,\n };\n}\n\nexport async function sellerAnalytics(sellerId: string) {\n const [products, orders, revenue, top] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT COUNT(*) AS n FROM products WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n \"SELECT COUNT(DISTINCT order_id) AS n FROM order_items WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n \"SELECT COALESCE(SUM(unit_price_cents * quantity),0) AS revenue FROM order_items WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n `SELECT p.id, p.name, p.image_url, SUM(oi.quantity) AS units, SUM(oi.unit_price_cents * oi.quantity) AS revenue\n FROM order_items oi\n JOIN products p ON p.id = oi.product_id\n WHERE oi.seller_id = ?\n GROUP BY p.id\n ORDER BY units DESC\n LIMIT 5`,\n args: [sellerId],\n }),\n ]);\n return {\n productCount: (products.rows[0] as { n: number }).n,\n orderCount: (orders.rows[0] as { n: number }).n,\n revenueCents: (revenue.rows[0] as { revenue: number }).revenue,\n topProducts: top.rows,\n };\n}\n\n// --- AI Logs ---\n\nexport async function logAI(\n userId: string | null,\n kind: string,\n prompt: string,\n response: string,\n): Promise {\n await sqlite.execute({\n sql:\n \"INSERT INTO ai_logs (user_id, kind, prompt, response) VALUES (?, ?, ?, ?)\",\n args: [userId, kind, prompt, response],\n });\n}\n\nexport async function listUserAILogs(userId: string) {\n const r = await sqlite.execute({\n sql:\n \"SELECT id, kind, prompt, response, created_at FROM ai_logs WHERE user_id = ? ORDER BY id DESC LIMIT 30\",\n args: [userId],\n });\n return r.rows;\n}\n",[],[187,475],"915117fa-55ea-11f1-bdf4-ee650bb23af1","auth.ts","915118b8-55ea-11f1-bdf4-ee650bb23af1",7,["D",1779460137352],"// Auth helpers: read OAuth session, sync to local users table, enforce roles.\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { getUser, upsertUser } from \"./db.ts\";\nimport type { User } from \"../shared/types.ts\";\n\nexport async function getCurrentUser(req: Request): Promise {\n const session = await getOAuthUserData(req);\n if (!session?.user) return null;\n const handle = session.user.username || `user-${session.user.id.slice(0, 6)}`;\n // Upsert into local users table so we have role + linkable data.\n const u = await upsertUser({\n id: session.user.id,\n handle,\n display_name: session.user.username,\n avatar_url: session.user.links?.profileImageUrl ?? null,\n });\n return u;\n}\n\nexport async function requireUser(req: Request): Promise {\n const u = await getCurrentUser(req);\n if (!u) throw new HttpError(401, \"Login required\");\n return u;\n}\n\nexport async function requireRole(\n req: Request,\n roles: (\"customer\" | \"seller\" | \"admin\")[],\n): Promise {\n const u = await requireUser(req);\n if (!roles.includes(u.role)) {\n throw new HttpError(403, `Requires role: ${roles.join(\" or \")}`);\n }\n return u;\n}\n\nexport class HttpError extends Error {\n constructor(public status: number, message: string) {\n super(message);\n }\n}\n\nexport { getUser };\n",[],[187,483],"8d071e10-55ea-11f1-b744-ee650bb23af1","ai.ts","8d071eec-55ea-11f1-b744-ee650bb23af1",6,["D",1779460130185],"// Gemini AI service — all calls happen server-side; the API key never leaves the server.\nimport type { Product } from \"../shared/types.ts\";\n\nconst MODEL = \"gemini-2.0-flash\";\nconst ENDPOINT =\n `https://generativelanguage.googleapis.com/v1beta/models/${MODEL}:generateContent`;\n\nfunction getKey(): string {\n const k = Deno.env.get(\"GEMINI_API_KEY\");\n if (!k || k === \"REPLACE_WITH_YOUR_GEMINI_API_KEY\") {\n throw new Error(\n \"GEMINI_API_KEY is not set. Add it in the val's Environment Variables.\",\n );\n }\n return k;\n}\n\nasync function callGemini(\n prompt: string,\n opts: { json?: boolean; system?: string } = {},\n): Promise {\n const key = getKey();\n const body: Record = {\n contents: [{ role: \"user\", parts: [{ text: prompt }] }],\n generationConfig: {\n temperature: 0.7,\n maxOutputTokens: 1024,\n ...(opts.json ? { responseMimeType: \"application/json\" } : {}),\n },\n };\n if (opts.system) {\n body.systemInstruction = { parts: [{ text: opts.system }] };\n }\n const res = await fetch(`${ENDPOINT}?key=${key}`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Gemini API error ${res.status}: ${text.slice(0, 200)}`);\n }\n const data = await res.json();\n const text = data?.candidates?.[0]?.content?.parts?.[0]?.text;\n if (typeof text !== \"string\") {\n throw new Error(\"Gemini returned no text\");\n }\n return text;\n}\n\nfunction productSummary(p: Product): string {\n return `#${p.id} ${p.brand ?? \"\"} ${p.name} — ₹${\n (p.price_cents / 100).toFixed(0)\n } — ${(p.description ?? \"\").slice(0, 140)}`;\n}\n\n// --- 1. Smart recommendations based on user interests + catalog ---\n\nexport async function recommendGadgets(\n interest: string,\n catalog: Product[],\n): Promise<{ productId: number; reason: string }[]> {\n const lines = catalog.slice(0, 40).map(productSummary).join(\"\\n\");\n const prompt = `User interest: \"${interest}\"\n\nCatalog:\n${lines}\n\nPick the 4 most relevant products and explain WHY each fits the user's interest.\nReturn ONLY JSON array with this exact shape:\n[{\"productId\": number, \"reason\": \"one sentence reason\"}]`;\n const text = await callGemini(prompt, { json: true });\n try {\n const parsed = JSON.parse(text);\n if (Array.isArray(parsed)) return parsed.slice(0, 4);\n } catch {\n // try to extract JSON from text\n const m = text.match(/\\[[\\s\\S]*\\]/);\n if (m) return JSON.parse(m[0]).slice(0, 4);\n }\n return [];\n}\n\n// --- 2. Product summary ---\n\nexport async function summarizeProduct(p: Product): Promise {\n const prompt =\n `Write a clear, friendly 3-sentence summary of this gadget for a shopper. Highlight what makes it special and who would love it. Avoid marketing fluff.\n\nProduct: ${p.brand} ${p.name}\nPrice: ₹${(p.price_cents / 100).toFixed(0)}\nDescription: ${p.description ?? \"\"}\nSpecs: ${p.specs_json ?? \"n/a\"}`;\n return await callGemini(prompt);\n}\n\n// --- 3. Smart comparison ---\n\nexport async function compareProducts(a: Product, b: Product): Promise {\n const prompt = `Compare these two gadgets honestly. Use markdown with:\n- A short verdict (which is better for whom)\n- A bullet list of key differences\n- One recommendation paragraph\n\nProduct A: ${a.brand} ${a.name} — ₹${(a.price_cents / 100).toFixed(0)}\n${a.description}\nSpecs: ${a.specs_json}\n\nProduct B: ${b.brand} ${b.name} — ₹${(b.price_cents / 100).toFixed(0)}\n${b.description}\nSpecs: ${b.specs_json}`;\n return await callGemini(prompt);\n}\n\n// --- 4. Shopping assistant chat ---\n\nexport async function shoppingAssistant(\n message: string,\n history: { role: \"user\" | \"assistant\"; content: string }[],\n catalog: Product[],\n): Promise {\n const ctx = catalog.slice(0, 20).map(productSummary).join(\"\\n\");\n const system =\n `You are GadgetGenie, a helpful AI shopping assistant for an online smart-gadgets store.\nYou can reference the catalog below to recommend specific products by name.\nKeep replies concise (2-4 sentences), friendly, and practical. If the user asks about something outside gadgets, gently steer back to shopping.\n\nCatalog:\n${ctx}`;\n const historyText = history.slice(-6).map((m) =>\n `${m.role === \"user\" ? \"User\" : \"Assistant\"}: ${m.content}`\n ).join(\"\\n\");\n const prompt = `${historyText}\\nUser: ${message}\\nAssistant:`;\n return await callGemini(prompt, { system });\n}\n\n// --- 5. Search suggestions ---\n\nexport async function searchSuggestions(query: string): Promise {\n if (!query.trim()) return [];\n const prompt = `A user is searching for smart gadgets and typed: \"${query}\"\nSuggest 5 short, useful related search queries (under 6 words each).\nReturn ONLY a JSON array of strings, no prose.`;\n const text = await callGemini(prompt, { json: true });\n try {\n const parsed = JSON.parse(text);\n if (Array.isArray(parsed)) return parsed.slice(0, 5).map(String);\n } catch {\n const m = text.match(/\\[[\\s\\S]*\\]/);\n if (m) return JSON.parse(m[0]).slice(0, 5).map(String);\n }\n return [];\n}\n",[],[187,491],["D",1779460012296],[203,204,205],[187],["D",1779459922585],["D",1789494036282],{"_109":108,"_116":112},{"_109":108,"_110":-5,"_111":112,"_19":60,"_113":114,"_115":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"ctx",{"_87":-5,"_138":539,"_540":541,"_542":543,"_544":30,"_545":30,"_546":30,"_547":64,"_548":-5,"_549":-7,"_550":-7,"_551":68,"_552":30,"_553":30,"_554":-5,"_555":30,"_556":30,"_557":30,"_558":-5},"ENV",{"_510":511,"_512":513,"_514":95,"_515":516,"_517":518,"_519":520,"_521":522,"_523":524,"_525":526,"_527":528,"_529":530,"_531":532,"_533":534,"_535":536,"_537":538},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v30