[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_277":278,"_279":280},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_207":-5,"_20":208,"_22":209,"_210":211,"_212":213,"_26":214,"_24":215,"_216":217,"_218":219,"_220":51,"_221":222,"_223":71,"_224":-5,"_225":-5,"_226":227},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","rfh6au2","name","clearance-api","branchName","main","version","path","frontend/index.html","project",{"_36":162,"_13":14,"_38":163,"_49":-5,"_164":51,"_52":53,"_165":53,"_166":167,"_168":-5,"_169":170,"_171":139,"_172":71,"_173":-5,"_174":-5,"_175":73,"_56":176,"_177":-5,"_178":-5,"_179":-5,"_180":-5,"_181":182,"_183":182,"_184":185,"_186":185,"_187":185,"_188":182,"_189":182,"_190":191,"_192":193,"_194":195,"_50":51},"tree",[81,82,83],"file",{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_18":79},"contents",[],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",6,"behind",25,"envVars","id","cc99243c-5cb2-11f1-b5a8-1607ee4eb77e","createdAt",["D",1780205843171],"updatedAt",["D",1780207481423],"projectId","cc98120e-5cb2-11f1-b5a8-1607ee4eb77e",36,"forkedBranchId","forkedBranchVersion","lockfileKey","1780207522848-esm.town_v_pre1_hi@36-main","deletedAt","isOwned",false,"privacy","public","userHandle","pre1","orgId","019e7c89-3d62-74d5-810c-c0c87a78f26f","projectName","hi","f591c2b2-5cb3-11f1-859d-1607ee4eb77e","index.html","fileId","019e7c91-0d08-7570-a7d2-2664eb068abd","parentId","019e7c91-0d08-7570-a7d2-2ebd8fa47e56","branchId","f58c5f02-5cb3-11f1-859d-1607ee4eb77e","branchVersion",1,"latest",true,["D",1780206341289],0,"fileType","content","\n\n \n \n \n Hidden Clearances 🔎\n 🏷️\" />\n \n \n \n \n

\n \n \n\n","deleted","label",[80,61],"frontend",{"_36":128,"_13":129,"_62":130,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":131,"_17":73,"_74":95,"_75":-5,"_77":51,"_78":-5,"_90":132,"_18":133},{"_36":93,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":94,"_17":73,"_74":95,"_75":-5,"_77":51,"_78":-5,"_90":96,"_18":97},{"_36":84,"_13":85,"_62":86,"_64":-5,"_66":67,"_68":87,"_70":71,"_38":88,"_17":69,"_74":24,"_75":89,"_77":51,"_78":-5,"_90":91,"_18":92},"3c6cbc00-5cb4-11f1-8cd7-1607ee4eb77e","README.md","019e7c91-0d09-70e7-bce3-7ee2504e1f5d",7,["D",1780206460259],"# 🏷️ Clearance API\n\nA **smart JSON API** (plus a browsable UI) for clearance deals and live per-store\nstock, proxying [hiddenclearances.com](https://www.hiddenclearances.com). Built to be\ndropped straight into a **Discord bot** — there's even a Discord-embed-ready endpoint.\n\nBase URL: `https://rfh6au2--019e7c910d087570a7d215d88e70638c.web.val.run`\n\n## ⚠️ First: set your token (required)\n\nThe upstream API needs a **Supabase JWT Bearer token** that expires (~1 hour). Grab the\n`authorization:` header value from a logged-in request on hiddenclearances.com and save it.\n\n👉 Add HC_TOKEN here: https://www.val.town/x/rfh6au2/clearance-api/environment-variables?key=HC_TOKEN\n\nCheck `GET /api/health` — when `tokenConfigured` is `true` and stock calls return data,\nyou're good. If calls start returning `token_expired`, refresh the token at the link above.\n\n## Response envelope\n\nEvery endpoint returns a consistent shape, so error handling in your bot is trivial:\n\n```jsonc\n{ \"ok\": true, /* ...payload... */ }\n{ \"ok\": false, \"error\": { \"code\": \"token_expired\", \"message\": \"...\" } }\n```\n\nCommon error codes: `missing_params`, `missing_query`, `missing_zip`, `missing_token`,\n`token_expired`, `upstream_error`, `not_found`, `internal_error`.\n\n## Endpoints\n\n| Route | Description |\n| --- | --- |\n| `GET /api/health` | Service + token status, supported retailers. No auth/params. |\n| `GET /api/retailers` | Supported retailer slugs and their accepted aliases. |\n| `GET /api/leads?limit=24&page=1&sort=newest&retailer=` | Paginated deals feed. `sort` = `newest`/`oldest`/`discount`/`price`. |\n| `GET /api/leads/search?q=dewalt&pages=3&limit=24` | Keyword search across the first N feed pages. |\n| `GET /api/stock?retailer=home_depot&sku=336764660&zip=80019` | Per-store stock + a smart summary + raw stores. |\n| `GET /api/deal/:retailer/:sku?zip=80019` | Path-style stock lookup (same payload as `/api/stock`). |\n| `GET /api/discord/stock?retailer=home_depot&sku=336764660&zip=80019` | **Discord-embed-ready** `{ content, embeds }` you can post directly. |\n\n`retailer` accepts `home_depot` / `homedepot` / `hd`, `lowes` / `lowe's`, `walmart` / `wm`.\n\n### `/api/stock` payload\n\n```jsonc\n{\n \"ok\": true,\n \"retailer\": \"homedepot\",\n \"sku\": \"336764660\",\n \"zip\": \"80019\",\n \"item\": { /* upstream item info, incl. retailPrice */ },\n \"summary\": {\n \"storesChecked\": 32,\n \"inStockCount\": 4,\n \"totalQuantity\": 11,\n \"nearest\": { \"storeName\": \"...\", \"distanceMiles\": 6.2, \"quantity\": 3, \"price\": 4.99, \"itemLocation\": \"Aisle 12, Bay 4\" }\n },\n \"inStockStores\": [ /* only stores with stock, nearest first */ ],\n \"stores\": [ /* full raw list, every store */ ]\n}\n```\n\n## Using it from a Discord bot\n\nThe `/api/discord/stock` route already returns a valid Discord message payload, so a\nslash command is basically a passthrough:\n\n```ts\n// /stock [retailer]\nconst API = \"https://rfh6au2--019e7c910d087570a7d215d88e70638c.web.val.run\";\n\nasync function handleStock(sku: string, zip: string, retailer = \"home_depot\") {\n const r = await fetch(`${API}/api/discord/stock?retailer=${retailer}&sku=${sku}&zip=${zip}`);\n const data = await r.json();\n if (!data.ok) {\n return { content: `❌ ${data.error.message}` };\n }\n return { content: data.content, embeds: data.embeds }; // post straight to Discord\n}\n```\n\nFor a custom layout, hit `/api/stock` instead and build your own embed from `summary`\nand `inStockStores`.\n\n## UI\n\nVisit `/` for a browsable grid of deals with a \"Check stock\" modal. The frontend calls\nthe same `/api/*` endpoints.\n\n## Structure\n\n```mermaid\ngraph TD\n UI[\"frontend/App.tsx + StockModal.tsx\"] -->|/api/leads, /api/stock| R[\"backend/index.ts (Hono router)\"]\n BOT[\"your Discord bot\"] -->|/api/discord/stock, /api/stock, /api/leads| R\n R -->|mounts /api| A[\"backend/api.ts (smart API)\"]\n A -->|Bearer HC_TOKEN + cache| H[\"backend/hc.ts\"]\n H -->|fetch| UP[\"api.hiddenclearances.com\"]\n```\n","children",[],[85],"f591cbea-5cb3-11f1-859d-1607ee4eb77e",["D",1780206341289],"directory",[98,99,100,101],[80],{"_36":120,"_13":121,"_62":122,"_64":65,"_66":67,"_68":123,"_70":71,"_38":124,"_17":69,"_74":106,"_75":125,"_77":51,"_78":-5,"_90":126,"_18":127},{"_36":113,"_13":114,"_62":115,"_64":65,"_66":67,"_68":32,"_70":71,"_38":116,"_17":69,"_74":106,"_75":117,"_77":51,"_78":-5,"_90":118,"_18":119},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":110,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_90":111,"_18":112},{"_36":102,"_13":103,"_62":104,"_64":65,"_66":67,"_68":69,"_70":71,"_38":105,"_17":73,"_74":106,"_75":107,"_77":51,"_78":-5,"_90":108,"_18":109},"f591c802-5cb3-11f1-859d-1607ee4eb77e","main.tsx","019e7c91-0d08-7570-a7d2-2a9358515cad",["D",1780206341289],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\nimport { App } from \"./App.tsx\";\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[80,103],["D",1780206341289],[],[80,61],"279855a0-5cb4-11f1-8cd7-1607ee4eb77e","StockModal.tsx","019e7c91-0d08-7570-a7d2-22c6701d0fa7",["D",1780206425323],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Store {\n storeId: string;\n storeName: string;\n address: string;\n city: string;\n state: string;\n zip: string;\n quantity: number;\n inStock: boolean;\n price: number;\n itemLocation: string;\n distance: number;\n}\n\nexport function StockModal(\n { sku, retailer, title, onClose }: {\n sku: string;\n retailer: string;\n title: string;\n onClose: () => void;\n },\n) {\n const [zip, setZip] = useState(localStorage.getItem(\"hc_zip\") || \"80019\");\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [item, setItem] = useState(null);\n const [stores, setStores] = useState([]);\n const [onlyInStock, setOnlyInStock] = useState(false);\n\n async function check(e?: React.FormEvent) {\n e?.preventDefault();\n setLoading(true);\n setError(null);\n localStorage.setItem(\"hc_zip\", zip);\n try {\n const r = await fetch(\n `/api/stock?retailer=${encodeURIComponent(retailer)}&sku=${encodeURIComponent(sku)}&zip=${encodeURIComponent(zip)}`,\n );\n const data = await r.json();\n if (!data.ok) throw new Error(data.error?.message || \"Lookup failed\");\n setItem(data.item);\n setStores(data.stores || []);\n } catch (err) {\n setError(String(err));\n setStores([]);\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n check();\n // eslint-disable-next-line\n }, []);\n\n const shown = (onlyInStock ? stores.filter((s) => s.inStock) : stores)\n .slice()\n .sort((a, b) => Number(b.inStock) - Number(a.inStock) || a.distance - b.distance);\n const inStockCount = stores.filter((s) => s.inStock).length;\n\n return (\n \n e.stopPropagation()}\n >\n

{title}

SKU {sku} · {retailer.replace(/_/g, \" \")}

\n \n ×\n \n

\n\n

\n ZIP\n setZip(e.target.value)}\n className=\"border border-gray-300 rounded-lg px-3 py-1.5 w-28 text-sm\"\n placeholder=\"80019\"\n />\n \n {loading ? \"Checking…\" : \"Check stock\"}\n \n {stores.length > 0 && (\n \n setOnlyInStock(e.target.checked)}\n />\n In stock only\n \n )}\n \n\n

\n {error && (\n

{error}

\n )}\n\n {!error && item && (\n

\n {inStockCount} of{\" \"}\n {stores.length} stores in stock · retail ${item.retailPrice}\n

\n )}\n\n

\n {shown.map((s) => (\n

\n \n

\n {s.storeName}{\" \"}\n · {s.distance.toFixed(1)} mi\n

\n {s.address}, {s.city} {s.zip}\n {s.itemLocation && · {s.itemLocation}}\n

\n {s.inStock\n ? (\n <>\n

{s.quantity} in stock

${s.price}

\n \n )\n :

Out

}\n

\n ))}\n {!loading && shown.length === 0 && !error && (\n

No stores to show.

\n )}\n

\n \n \n );\n}\n",[],[80,114],"26c27d72-5cb4-11f1-8cd7-1607ee4eb77e","App.tsx","019e7c91-0d08-7570-a7d2-1cdd7a20a5a7",5,["D",1780206423915],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { StockModal } from \"./StockModal.tsx\";\n\ninterface Lead {\n id: string;\n retailer: string;\n sku: string;\n title: string;\n imageUrl: string | null;\n originalPrice: string;\n clearancePrice: string;\n discountPercent: number;\n productUrl: string | null;\n createdAt: string;\n}\n\nconst RETAILER_BADGE: Record = {\n home_depot: \"bg-orange-100 text-orange-700\",\n lowes: \"bg-blue-100 text-blue-700\",\n walmart: \"bg-sky-100 text-sky-700\",\n};\n\nfunction DealCard({ lead, onCheck }: { lead: Lead; onCheck: (l: Lead) => void }) {\n return (\n

\n {lead.imageUrl\n ? {lead.title}

\n : 📦}\n \n -{lead.discountPercent}%\n \n

\n \n {lead.retailer.replace(/_/g, \" \")}\n \n

{lead.title}

\n ${lead.clearancePrice}\n ${lead.originalPrice}\n

\n onCheck(lead)}\n className=\"flex-1 bg-emerald-600 hover:bg-emerald-700 text-white text-xs font-semibold py-1.5 rounded-lg\"\n >\n 📍 Check stock\n \n {lead.productUrl && (\n \n ↗\n \n )}\n

SKU {lead.sku}

\n );\n}\n\nexport function App() {\n const [leads, setLeads] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [page, setPage] = useState(1);\n const [sort, setSort] = useState(\"newest\");\n const [total, setTotal] = useState(0);\n const [totalPages, setTotalPages] = useState(1);\n const [query, setQuery] = useState(\"\");\n const [active, setActive] = useState(null);\n\n const limit = 24;\n\n async function load() {\n setLoading(true);\n setError(null);\n try {\n const r = await fetch(`/api/leads?limit=${limit}&page=${page}&sort=${sort}`);\n const data = await r.json();\n if (!data.ok) throw new Error(data.error?.message || \"Failed to load\");\n setLeads(data.deals);\n setTotal(data.pagination?.total ?? data.deals.length);\n setTotalPages(data.pagination?.totalPages ?? 1);\n } catch (err) {\n setError(String(err));\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n load();\n // eslint-disable-next-line\n }, [page, sort]);\n\n const filtered = query.trim()\n ? leads.filter((l) =>\n (l.title + \" \" + l.sku).toLowerCase().includes(query.toLowerCase())\n )\n : leads;\n\n return (\n

🏷️ Hidden Clearances

\n setQuery(e.target.value)}\n placeholder=\"Filter this page…\"\n className=\"border border-gray-300 rounded-lg px-3 py-1.5 text-sm w-44\"\n />\n { setPage(1); setSort(e.target.value); }}\n className=\"border border-gray-300 rounded-lg px-3 py-1.5 text-sm bg-white\"\n >\n \n \n \n \n \n

\n\n {error && (\n

\n {error}\n

\n If this is an auth error, the HC_TOKEN env var likely expired — refresh it.\n

\n )}\n\n {loading\n ?

Loading deals…

\n : (\n

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

\n )}\n\n {!loading && (\n

\n setPage((p) => p - 1)}\n className=\"px-4 py-1.5 border rounded-lg text-sm disabled:opacity-40 bg-white\"\n >\n ← Prev\n \n \n Page {page} / {totalPages} · {total.toLocaleString()} deals\n \n = totalPages}\n onClick={() => setPage((p) => p + 1)}\n className=\"px-4 py-1.5 border rounded-lg text-sm disabled:opacity-40 bg-white\"\n >\n Next →\n \n

\n )}\n\n \n\n {active && (\n setActive(null)}\n />\n )}\n

\n );\n}\n",[],[80,121],"f591726c-5cb3-11f1-859d-1607ee4eb77e","backend","019e7c91-0d08-7570-a7d2-196939099e7d",["D",1780206341289],[134,135,136],[129],{"_36":154,"_13":155,"_62":156,"_64":130,"_66":67,"_68":157,"_70":71,"_38":158,"_17":73,"_74":106,"_75":159,"_77":51,"_78":-5,"_90":160,"_18":161},{"_36":146,"_13":147,"_62":148,"_64":130,"_66":67,"_68":149,"_70":71,"_38":150,"_17":69,"_74":106,"_75":151,"_77":51,"_78":-5,"_90":152,"_18":153},{"_36":137,"_13":138,"_62":139,"_64":130,"_66":67,"_68":140,"_70":71,"_38":141,"_17":69,"_74":142,"_75":143,"_77":51,"_78":-5,"_90":144,"_18":145},"231433f0-5cb4-11f1-b425-1607ee4eb77e","index.ts","019e7c91-0d08-7570-a7d2-15d88e70638c",4,["D",1780206417732],"http","import { Hono } from \"npm:hono\";\nimport { parseVal, readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { api } from \"./api.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// --- Smart JSON API (Discord-bot friendly) ---\napp.route(\"/api\", api);\n\n// --- Frontend ---\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/frontend/*\", (c) => serveFile(new URL(c.req.url).pathname, import.meta.url));\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;\n",[],[129,138],"06150cb6-5cb4-11f1-888c-1607ee4eb77e","hc.ts","019e7c91-0d08-7570-a7d2-115588af4f17",2,["D",1780206369078],"// Thin client for the HiddenClearances upstream API.\n// The Bearer token is a Supabase JWT that EXPIRES (~1hr). When deals stop loading,\n// refresh HC_TOKEN with a fresh token (copy the `authorization` Bearer value from a\n// logged-in request on https://www.hiddenclearances.com).\n\nconst BASE = \"https://api.hiddenclearances.com/api/v1\";\n\n// retailer aliases -> upstream path slug (no underscores)\nconst RETAILER_ALIASES: Record = {\n home_depot: \"homedepot\",\n homedepot: \"homedepot\",\n hd: \"homedepot\",\n \"home depot\": \"homedepot\",\n lowes: \"lowes\",\n \"lowe's\": \"lowes\",\n lowe: \"lowes\",\n walmart: \"walmart\",\n wm: \"walmart\",\n};\n\nexport const KNOWN_RETAILERS = [\"homedepot\", \"lowes\", \"walmart\"] as const;\n\nexport function normalizeRetailer(input?: string | null): string {\n if (!input) return \"homedepot\";\n const key = input.trim().toLowerCase();\n return RETAILER_ALIASES[key] ?? key.replace(/[_\\s]/g, \"\");\n}\n\nfunction token(): string {\n const t = Deno.env.get(\"HC_TOKEN\");\n if (!t) {\n throw new HCError(\n \"Missing HC_TOKEN env var. Set a fresh Supabase Bearer token from hiddenclearances.com.\",\n 503,\n \"missing_token\",\n );\n }\n return t.replace(/^Bearer\\s+/i, \"\").trim();\n}\n\nexport class HCError extends Error {\n status: number;\n code: string;\n constructor(message: string, status = 502, code = \"upstream_error\") {\n super(message);\n this.name = \"HCError\";\n this.status = status;\n this.code = code;\n }\n}\n\nasync function hcFetch(path: string): Promise {\n const r = await fetch(`${BASE}${path}`, {\n headers: {\n \"authorization\": `Bearer ${token()}`,\n \"accept\": \"*/*\",\n \"origin\": \"https://www.hiddenclearances.com\",\n \"referer\": \"https://www.hiddenclearances.com/\",\n \"user-agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36\",\n },\n });\n if (!r.ok) {\n const body = await r.text().catch(() => \"\");\n if (r.status === 401 || r.status === 403) {\n throw new HCError(\n `Upstream auth failed (${r.status}). HC_TOKEN has likely expired — refresh it.`,\n 401,\n \"token_expired\",\n );\n }\n throw new HCError(`Upstream ${r.status}: ${body.slice(0, 300)}`, 502, \"upstream_error\");\n }\n return r;\n}\n\nexport interface Lead {\n id: string;\n retailer: string;\n sku: string;\n title: string;\n imageUrl: string | null;\n originalPrice: string;\n clearancePrice: string;\n discountPercent: number;\n productUrl: string | null;\n createdAt: string;\n expiresAt: string;\n}\n\n// --- tiny in-memory cache (per warm isolate) ---\ntype CacheEntry = { at: number; value: unknown };\nconst cache = new Map();\n\nasync function cached(key: string, ttlMs: number, fn: () => Promise): Promise {\n const hit = cache.get(key);\n if (hit && Date.now() - hit.at < ttlMs) return hit.value as T;\n const value = await fn();\n cache.set(key, { at: Date.now(), value });\n return value;\n}\n\nexport async function getLeads(\n { limit = 24, page = 1, sort = \"newest\", retailer }: {\n limit?: number;\n page?: number;\n sort?: string;\n retailer?: string;\n },\n) {\n const qs = new URLSearchParams({ limit: String(limit), page: String(page), sort });\n if (retailer) qs.set(\"retailer\", normalizeRetailer(retailer));\n const key = `leads:${qs}`;\n return cached(key, 60_000, async () => {\n const r = await hcFetch(`/leads?${qs}`);\n return r.json();\n });\n}\n\n// retailer is normalized to the upstream slug (\"homedepot\" | \"lowes\" | \"walmart\")\nexport async function getStock(retailer: string, sku: string, zip: string) {\n const slug = normalizeRetailer(retailer);\n const qs = new URLSearchParams({ sku, zip });\n const key = `stock:${slug}:${sku}:${zip}`;\n return cached(key, 120_000, async () => {\n const r = await hcFetch(`/${slug}/stock?${qs}`);\n return r.json();\n });\n}\n",[],[129,147],"1f0415e6-5cb4-11f1-a8b6-1607ee4eb77e","api.ts","1f041686-5cb4-11f1-a8b6-1607ee4eb77e",3,["D",1780206410931],"// Smart JSON API for clearance deals + per-store stock.\n// Designed to be easy to consume from a Discord bot (or anything else).\n//\n// All responses share a consistent envelope:\n// { ok: true, ...data }\n// { ok: false, error: { code, message } }\n//\n// Routes (all under /api):\n// GET /api/health -> token + service status\n// GET /api/retailers -> supported retailer slugs\n// GET /api/leads -> paginated deals feed\n// GET /api/leads/search?q=... -> search/filter deals across pages\n// GET /api/stock -> per-store stock for a sku+zip\n// GET /api/deal/:retailer/:sku -> deal-style summary + best stores near a zip\n// GET /api/discord/stock -> Discord-embed-ready stock summary\n\nimport { Hono } from \"npm:hono\";\nimport { getLeads, getStock, HCError, KNOWN_RETAILERS, normalizeRetailer } from \"./hc.ts\";\n\nexport const api = new Hono();\n\n// ---- helpers -------------------------------------------------------------\n\nfunction fail(c: any, err: unknown) {\n if (err instanceof HCError) {\n return c.json({ ok: false, error: { code: err.code, message: err.message } }, err.status);\n }\n return c.json(\n { ok: false, error: { code: \"internal_error\", message: String(err) } },\n 500,\n );\n}\n\nfunction clampInt(v: string | undefined, def: number, min: number, max: number) {\n const n = Number(v);\n if (!Number.isFinite(n)) return def;\n return Math.max(min, Math.min(max, Math.trunc(n)));\n}\n\nconst SORTS = new Set([\"newest\", \"oldest\", \"discount\", \"price\"]);\n\ninterface StoreLike {\n storeId: string;\n storeName: string;\n address: string;\n city: string;\n state: string;\n zip: string;\n quantity: number;\n inStock: boolean;\n price: number;\n itemLocation: string;\n distance: number;\n}\n\nfunction summarizeStock(raw: any) {\n const stores: StoreLike[] = Array.isArray(raw?.stores) ? raw.stores : [];\n const inStock = stores\n .filter((s) => s.inStock)\n .sort((a, b) => a.distance - b.distance);\n const best = inStock[0] ?? null;\n return {\n item: raw?.item ?? null,\n summary: {\n storesChecked: stores.length,\n inStockCount: inStock.length,\n totalQuantity: inStock.reduce((sum, s) => sum + (s.quantity || 0), 0),\n nearest: best\n ? {\n storeName: best.storeName,\n city: best.city,\n state: best.state,\n distanceMiles: Number(best.distance?.toFixed?.(1) ?? best.distance),\n quantity: best.quantity,\n price: best.price,\n itemLocation: best.itemLocation || null,\n }\n : null,\n },\n inStockStores: inStock.map((s) => ({\n storeName: s.storeName,\n address: s.address,\n city: s.city,\n state: s.state,\n zip: s.zip,\n distanceMiles: Number(s.distance?.toFixed?.(1) ?? s.distance),\n quantity: s.quantity,\n price: s.price,\n itemLocation: s.itemLocation || null,\n })),\n stores,\n };\n}\n\n// ---- routes --------------------------------------------------------------\n\napi.get(\"/health\", (c) => {\n const hasToken = !!Deno.env.get(\"HC_TOKEN\");\n return c.json({\n ok: true,\n service: \"clearance-api\",\n time: new Date().toISOString(),\n tokenConfigured: hasToken,\n retailers: [...KNOWN_RETAILERS],\n });\n});\n\napi.get(\"/retailers\", (c) =>\n c.json({\n ok: true,\n retailers: [...KNOWN_RETAILERS],\n aliases: {\n homedepot: [\"home_depot\", \"hd\", \"home depot\"],\n lowes: [\"lowe's\", \"lowe\"],\n walmart: [\"wm\"],\n },\n }));\n\n// Paginated deals feed.\napi.get(\"/leads\", async (c) => {\n try {\n const limit = clampInt(c.req.query(\"limit\"), 24, 1, 100);\n const page = clampInt(c.req.query(\"page\"), 1, 1, 10_000);\n const sortRaw = (c.req.query(\"sort\") ?? \"newest\").toLowerCase();\n const sort = SORTS.has(sortRaw) ? sortRaw : \"newest\";\n const retailer = c.req.query(\"retailer\");\n\n const upstream = await getLeads({ limit, page, sort, retailer });\n return c.json({\n ok: true,\n sort,\n retailer: retailer ? normalizeRetailer(retailer) : null,\n pagination: upstream.pagination ?? null,\n count: Array.isArray(upstream.data) ? upstream.data.length : 0,\n deals: upstream.data ?? [],\n });\n } catch (e) {\n return fail(c, e);\n }\n});\n\n// Search/filter deals by keyword across a few pages of the feed.\napi.get(\"/leads/search\", async (c) => {\n try {\n const q = (c.req.query(\"q\") ?? \"\").trim().toLowerCase();\n if (!q) {\n return c.json({ ok: false, error: { code: \"missing_query\", message: \"q is required\" } }, 400);\n }\n const sortRaw = (c.req.query(\"sort\") ?? \"newest\").toLowerCase();\n const sort = SORTS.has(sortRaw) ? sortRaw : \"newest\";\n const retailer = c.req.query(\"retailer\");\n const pages = clampInt(c.req.query(\"pages\"), 3, 1, 10); // how many feed pages to scan\n const max = clampInt(c.req.query(\"limit\"), 24, 1, 100);\n\n const matches: any[] = [];\n for (let page = 1; page <= pages && matches.length < max; page++) {\n const upstream = await getLeads({ limit: 100, page, sort, retailer });\n const data: any[] = upstream.data ?? [];\n for (const lead of data) {\n const hay = `${lead.title ?? \"\"} ${lead.sku ?? \"\"} ${lead.retailer ?? \"\"}`.toLowerCase();\n if (hay.includes(q)) matches.push(lead);\n if (matches.length >= max) break;\n }\n if (!data.length) break; // ran out of results\n }\n\n return c.json({\n ok: true,\n query: q,\n pagesScanned: pages,\n count: matches.length,\n deals: matches.slice(0, max),\n });\n } catch (e) {\n return fail(c, e);\n }\n});\n\n// Per-store stock for a sku+zip. Returns both a smart summary and raw stores.\napi.get(\"/stock\", async (c) => {\n try {\n const sku = c.req.query(\"sku\");\n const zip = c.req.query(\"zip\");\n if (!sku || !zip) {\n return c.json(\n { ok: false, error: { code: \"missing_params\", message: \"sku and zip are required\" } },\n 400,\n );\n }\n const retailer = c.req.query(\"retailer\") ?? \"home_depot\";\n const raw = await getStock(retailer, sku, zip);\n const s = summarizeStock(raw);\n return c.json({ ok: true, retailer: normalizeRetailer(retailer), sku, zip, ...s });\n } catch (e) {\n return fail(c, e);\n }\n});\n\n// Path-style lookup: /api/deal/home_depot/336764660?zip=80019\napi.get(\"/deal/:retailer/:sku\", async (c) => {\n try {\n const retailer = c.req.param(\"retailer\");\n const sku = c.req.param(\"sku\");\n const zip = c.req.query(\"zip\");\n if (!zip) {\n return c.json({ ok: false, error: { code: \"missing_zip\", message: \"zip is required\" } }, 400);\n }\n const raw = await getStock(retailer, sku, zip);\n const s = summarizeStock(raw);\n return c.json({ ok: true, retailer: normalizeRetailer(retailer), sku, zip, ...s });\n } catch (e) {\n return fail(c, e);\n }\n});\n\n// Discord-embed-ready stock summary. Drop straight into an interaction response.\napi.get(\"/discord/stock\", async (c) => {\n try {\n const sku = c.req.query(\"sku\");\n const zip = c.req.query(\"zip\");\n if (!sku || !zip) {\n return c.json(\n { ok: false, error: { code: \"missing_params\", message: \"sku and zip are required\" } },\n 400,\n );\n }\n const retailer = normalizeRetailer(c.req.query(\"retailer\") ?? \"home_depot\");\n const raw = await getStock(retailer, sku, zip);\n const { item, summary, inStockStores } = summarizeStock(raw);\n\n const title = item?.title ?? `SKU ${sku}`;\n const color = summary.inStockCount > 0 ? 0x10b981 : 0x9ca3af; // emerald / gray\n const fields = inStockStores.slice(0, 8).map((s) => ({\n name: `${s.storeName} · ${s.distanceMiles} mi`,\n value: `**${s.quantity}** in stock · $${s.price}${s.itemLocation ? ` · ${s.itemLocation}` : \"\"}\\n${s.city}, ${s.state} ${s.zip}`,\n inline: false,\n }));\n\n const embed = {\n title: title.slice(0, 256),\n description: `**${summary.inStockCount}** of **${summary.storesChecked}** stores in stock near ${zip}` +\n (item?.retailPrice ? ` · retail $${item.retailPrice}` : \"\"),\n color,\n footer: { text: `${retailer} · SKU ${sku}` },\n fields: fields.length ? fields : [{ name: \"No stock nearby\", value: \"Try a different ZIP.\", inline: false }],\n };\n\n return c.json({ ok: true, content: null, embeds: [embed] });\n } catch (e) {\n return fail(c, e);\n }\n});\n\napi.notFound((c) =>\n c.json({ ok: false, error: { code: \"not_found\", message: `No API route for ${c.req.path}` } }, 404)\n);\n",[],[129,155],"f582a34a-5cb3-11f1-859d-1607ee4eb77e",["D",1780206341289],"legacyEnvVars","httpPrivacy","description","Hidden Clearances browser — deals feed + per-store stock lookup","imageUrl","userId","1f17f902-04c7-4a60-985f-f237ceab2e3d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019e7c90-4c60-7279-8cc3-e42941be1450","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_206":201},"org",{"_11":12,"_200":201,"_202":201,"_169":170,"_203":204,"_205":51},"branch",{"_17":87,"_13":16,"_36":67,"_42":162,"_45":37,"_46":196,"_197":53,"_198":43,"_199":57,"_58":14,"_54":12},11,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":162,"_13":14,"_38":273,"_49":-5,"_164":51,"_52":53,"_165":53,"_166":167,"_168":-5,"_169":170,"_171":139,"_172":71,"_173":-5,"_174":-5,"_175":73,"_56":176,"_177":-5,"_178":-5,"_179":-5,"_180":-5,"_181":182,"_183":182,"_184":185,"_186":185,"_187":185,"_188":182,"_189":182,"_190":274,"_192":275,"_194":276,"_50":51},[243,247,252],"files",[243,244,245,246,247,248,249,250,251,252],"counts",{"_234":73,"_235":69,"_236":73,"_35":237,"_238":239},[],{"_36":60,"_66":67,"_62":63,"_13":61,"_75":76,"_74":24,"_17":73,"_64":65,"_38":232,"_68":69,"_78":-5,"_18":233},"upstreamProject",{"_36":43,"_13":59,"_166":167,"_168":-5,"_52":53,"_190":230},"upstreamBranch",{"_36":37,"_38":228,"_40":229,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1780205843171],["D",1780207481423],{"_11":55,"_206":231},"https://lh3.googleusercontent.com/a/ACg8ocJubKqnf6LcCHjbjbyg1QcKZydw4_Ni7P97uQ61Oa5pcazlmQ=s96-c",["D",1780206341289],[80,61],"pulls","branches","forks",{"_240":69,"_242":69},"connections",{"_240":73,"_241":73},"count","unfilledCount","emptyCount",{"_36":128,"_13":129,"_62":130,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":131,"_17":73,"_74":95,"_75":-5,"_77":51,"_78":-5,"_90":271,"_18":272},{"_36":154,"_13":155,"_62":156,"_64":130,"_66":67,"_68":157,"_70":71,"_38":158,"_17":73,"_74":106,"_75":159,"_77":51,"_78":-5,"_90":269,"_18":270},{"_36":146,"_13":147,"_62":148,"_64":130,"_66":67,"_68":149,"_70":71,"_38":150,"_17":69,"_74":106,"_75":151,"_77":51,"_78":-5,"_90":267,"_18":268},{"_36":137,"_13":138,"_62":139,"_64":130,"_66":67,"_68":140,"_70":71,"_38":141,"_17":69,"_74":142,"_75":143,"_77":51,"_78":-5,"_90":265,"_18":266},{"_36":93,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":94,"_17":73,"_74":95,"_75":-5,"_77":51,"_78":-5,"_90":263,"_18":264},{"_36":120,"_13":121,"_62":122,"_64":65,"_66":67,"_68":123,"_70":71,"_38":124,"_17":69,"_74":106,"_75":125,"_77":51,"_78":-5,"_90":261,"_18":262},{"_36":113,"_13":114,"_62":115,"_64":65,"_66":67,"_68":32,"_70":71,"_38":116,"_17":69,"_74":106,"_75":117,"_77":51,"_78":-5,"_90":259,"_18":260},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":110,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_90":257,"_18":258},{"_36":102,"_13":103,"_62":104,"_64":65,"_66":67,"_68":69,"_70":71,"_38":105,"_17":73,"_74":106,"_75":107,"_77":51,"_78":-5,"_90":255,"_18":256},{"_36":84,"_13":85,"_62":86,"_64":-5,"_66":67,"_68":87,"_70":71,"_38":88,"_17":69,"_74":24,"_75":89,"_77":51,"_78":-5,"_90":253,"_18":254},[],[85],[],[80,103],[],[80,61],[],[80,114],[],[80,121],[248,249,250,251],[80],[],[129,138],[],[129,147],[],[129,155],[244,245,246],[129],["D",1780206341289],{"_11":12,"_206":201},{"_11":12,"_200":201,"_202":201,"_169":170,"_203":204,"_205":51},{"_17":87,"_13":16,"_36":67,"_42":162,"_45":37,"_46":196,"_197":53,"_198":43,"_199":57,"_58":14,"_54":12},"ctx",{"_190":-5,"_225":310,"_311":312,"_313":314,"_315":51,"_316":51,"_317":51,"_318":71,"_319":-5,"_320":-7,"_321":-7,"_322":73,"_323":51,"_324":51,"_325":-5,"_326":51,"_327":51,"_328":51,"_329":-5},"ENV",{"_281":282,"_283":284,"_285":16,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309},"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"]