${l}

${v}

${s}

`;\n}\nfunction bars(today: any[], ref: any[], refLabel: string, upto: number) {\n const hours = [];\n for (let h = 8; h <= Math.max(upto, 8) && h < 24; h++) hours.push(h);\n const mx = Math.max(\n 1,\n ...today.map((x) => x.orders),\n ...ref.map((x) => x.orders),\n );\n const rows = hours.map((h) =>\n `${\n String(h).padStart(2, \"0\")\n }:00

${\n today[h].orders\n } / ${ref[h].orders}`\n ).join(\"\");\n return `

Orders by hour: ■ today ■ ${\n esc(refLabel)\n }

${rows}

`;\n}\nfunction topTable(items: any[]) {\n if (!items?.length) return \"\";\n return `

Top sellers

${\n items.slice(0, 8).map((x) =>\n ``\n ).join(\"\")\n }

${\n esc(x.name)\n } (${\n esc(x.category)\n })

${x.qty}

${\n inr(x.revenue)\n }

`;\n}\nexport function renderCombined(\n p: any,\n others: any[],\n summary: string,\n engine: string,\n) {\n const t = p.today;\n const delayed = p.delayed\n ? `

Delayed: this is the ${\n esc(p.slot_label)\n }, sent at ${esc(p.as_of_human)}.

`\n : \"\";\n const box =\n `

${\n summary.split(\"\\n\").map(esc).join(\"
\")\n }

`;\n let title: string, kpis: string, barsHtml: string, top: string;\n if (p.is_digest) {\n const y = p.closed, lw = p.closed_lw;\n title = `${esc(p.outlet)} — ${esc(p.closed_day_human)} closed`;\n kpis = `${\n kpi(\n \"Orders\",\n `${y.orders}`,\n `vs same weekday last week ${lw.orders} (${\n delta(y.orders, lw.orders)\n })`,\n )\n }${\n kpi(\n \"Net revenue\",\n inr(y.revenue),\n `last week ${inr(lw.revenue)} (${delta(y.revenue, lw.revenue, true)})`,\n )\n }${kpi(\"AOV\", inr(y.aov), `items/order ${y.items_per_order}`)}${\n kpi(\n \"Returning share\",\n pct(p.closed_nr.returning_share),\n `${p.closed_nr.returning} returning · ${p.closed_nr.new} new`,\n )\n }${\n kpi(\n \"Food attach\",\n pct(y.food_attach),\n `${y.food} food items · ${y.beverages} drinks`,\n )\n }${\n kpi(\n \"FIRST69 share\",\n pct(y.first69_share),\n `discount depth ${pct(y.discount_depth)} · kiosk ${pct(y.kiosk_share)}`,\n )\n }

`;\n barsHtml = bars(\n p.closed_hourly,\n p.closed_lw_hourly,\n \"same weekday last week\",\n 23,\n );\n top = topTable(p.closed_top);\n } else {\n const ys = p.yesterday_same_hour,\n lws = p.last_week_same_hour,\n s = p.since_last;\n title = `${esc(p.outlet)} — ${esc(p.slot_label)}`;\n kpis = `${\n kpi(\n \"Orders today\",\n `${t.orders}`,\n `yesterday by now ${ys.orders} (${delta(t.orders, ys.orders)}) · last ${\n esc(p.dow)\n } ${lws.orders}`,\n )\n }${\n kpi(\n \"Net revenue today\",\n inr(t.revenue),\n `yesterday by now ${inr(ys.revenue)} (${\n delta(t.revenue, ys.revenue, true)\n })`,\n )\n }${\n kpi(\n \"AOV\",\n inr(t.aov),\n `items/order ${t.items_per_order} · last order ${\n esc((t.last_order_time ?? \"—\").slice(0, 5))\n }`,\n )\n }${\n kpi(`Since ${esc(s.from_label)}`, `+${s.orders}`, `+${inr(s.revenue)}`)\n }${\n kpi(\n \"Returning share today\",\n pct(p.nr.returning_share),\n `${p.nr.returning} returning · ${p.nr.new} new customers`,\n )\n }${\n kpi(\n \"Mix today\",\n `F69 ${pct(t.first69_share)}`,\n `food attach ${pct(t.food_attach)} · kiosk ${pct(t.kiosk_share)}`,\n )\n }

`;\n barsHtml = bars(p.hourly_today, p.hourly_yesterday, \"yesterday\", p.hour);\n top = topTable(p.top_today);\n }\n const m = p.mtd;\n const pace =\n `${\n kpi(\n \"Month to date\",\n inr(m.revenue),\n `${m.orders} orders · AOV ${inr(m.aov)}`,\n )\n }${\n kpi(\n \"Projected month\",\n inr(m.projection),\n `${m.days_elapsed} of ${m.days_in_month} days · ${inr(m.per_day)}/day`,\n )\n }${\n kpi(\n \"Target ₹20 L\",\n pct(m.projection / m.target) + \" of target\",\n `need ${inr(m.needed_per_day)}/day for the rest of the month`,\n )\n }

`;\n const oth = others.length\n ? `

Other outlets

${\n others.map((o) =>\n ``\n ).join(\"\")\n }

	${\n p.is_digest ? \"Closed day\" : \"Today\"\n }	Yday by now	Yday full	MTD
${\n esc(o.outlet)\n }	${o.today.orders} · ${\n inr(o.today.revenue)\n }	${o.yesterday_same_hour.orders} · ${\n inr(o.yesterday_same_hour.revenue)\n }	${o.yesterday.orders} · ${\n inr(o.yesterday.revenue)\n }	${o.mtd.orders} · ${\n inr(o.mtd.revenue)\n }

`\n : \"\";\n const foot =\n `

Summary by ${\n esc(engine)\n } · live order list from franchise.xpansecafe.com · reports at 9am, 12pm, 3pm, 6pm, 9pm and midnight IST · Val Town

`;\n return `

${title}

as of ${\n esc(p.as_of_human)\n }

${delayed}${box}${kpis}${barsHtml}${top}${pace}${oth}${foot}

`;\n}\n\n// ---------- config ----------\nexport function outletsFromEnv(): {\n name: string;\n username: string;\n password: string;\n}[] {\n const raw = Deno.env.get(\"OUTLETS\") ?? \"[]\";\n let arr: any = JSON.parse(raw);\n if (typeof arr === \"string\") arr = JSON.parse(arr);\n return arr;\n}\nexport const target = () => +(Deno.env.get(\"MONTHLY_TARGET\") ?? \"2000000\");\nexport const salt = () => Deno.env.get(\"PHONE_SALT\") ?? \"xpanse\";\n\n// ---------- dashboard data (used by dashboardHttp.ts and the local test) ----------\nexport function periodBlock(\n days: Days,\n from: string,\n to: string,\n first: Record,\n) {\n const dates = Object.keys(days).filter((d) => d >= from && d <= to).sort();\n const orders = dates.flatMap((d) => days[d]);\n const h = Array(24).fill(0), r = Array(24).fill(0);\n let nw = 0, ret = 0, nrev = 0, rrev = 0;\n for (const d of dates) {\n for (const o of days[d]) {\n if (!isLive(o)) continue;\n h[hourOf(o)]++;\n r[hourOf(o)] += net(o);\n if (o.userPhone && (first[o.userPhone] ?? d) < d) {\n ret++;\n rrev += net(o);\n } else {\n nw++;\n nrev += net(o);\n }\n }\n }\n const t = nw + ret;\n return {\n from,\n to,\n days: dates.length,\n summary: summarizeDay(orders),\n hourly: h.map((orders, hour) => ({\n hour,\n orders,\n revenue: +r[hour].toFixed(2),\n })),\n nr: {\n new: nw,\n returning: ret,\n returning_share: t ? ret / t : 0,\n new_aov: nw ? +(nrev / nw).toFixed(2) : 0,\n returning_aov: ret ? +(rrev / ret).toFixed(2) : 0,\n },\n top: topItems(orders, 10),\n coupons: couponMix(orders).slice(0, 10),\n daily: dates.map((d) => ({\n date: d,\n dow: dow(d),\n ...summarizeDay(days[d]),\n })),\n };\n}\n\nexport async function buildDashboard(\n slug: string,\n ndays: number,\n store: Store,\n panelFor: (slug: string) => Promise,\n from?: string,\n to?: string,\n mode = \"period\",\n) {\n const now = istNow(),\n today = now.date,\n yday = shift(today, -1),\n lw = shift(today, -7);\n const outlets = outletsFromEnv();\n const name = outlets.find((o) => slugify(o.name) === slug)?.name ?? slug;\n if (!from || !to || mode === \"today\") {\n from = today;\n to = today;\n mode = \"today\";\n }\n if (to > today) to = today;\n if (from > to) from = to;\n const len =\n Math.round(\n (new Date(to + \"T00:00:00Z\").getTime() -\n new Date(from + \"T00:00:00Z\").getTime()) / 864e5,\n ) + 1;\n // analysis window: the selected period, or 30 days of context ending on the selected day\n const winTo = to, winFrom = len >= 2 ? from : shift(to, -29);\n const prevFrom = shift(from, -len), prevTo = shift(from, -1);\n const start = [winFrom, prevFrom, monthFirst(today)].sort()[0];\n const days = await loadDays(\n await panelFor(slug),\n slug,\n start,\n today,\n today,\n salt(),\n store,\n );\n const window: Days = Object.fromEntries(\n Object.entries(days).filter(([d]) => d >= winFrom && d <= winTo),\n );\n const first = customerHistory(days);\n const t = days[today] ?? [], y = days[yday] ?? [], w = days[lw] ?? [];\n const all = Object.values(window).flat();\n const others = [];\n for (const o of outlets) {\n const s2 = slugify(o.name);\n if (s2 === slug) continue;\n const d2 = await loadDays(\n await panelFor(s2),\n s2,\n shift(monthFirst(today), -1),\n today,\n today,\n salt(),\n store,\n );\n const y2 = d2[yday] ?? [];\n others.push({\n outlet: o.name,\n slug: s2,\n today: summarizeDay(d2[today] ?? []),\n yesterday_same_hour: summarizeDay(y2, now.hour),\n yesterday: summarizeDay(y2),\n mtd: mtdBlock(d2, today, true, target()),\n });\n }\n return {\n outlet: name,\n slug,\n generated_at: now.human,\n live: true,\n hour: now.hour,\n today: {\n summary: summarizeDay(t),\n hourly: hourly(t),\n top: topItems(t, 10),\n nr: newVsReturning(t, first, today),\n coupons: couponMix(t),\n },\n yesterday: {\n summary: summarizeDay(y),\n same_hour: summarizeDay(y, now.hour),\n hourly: hourly(y),\n },\n last_week: {\n summary: summarizeDay(w),\n same_hour: summarizeDay(w, now.hour),\n hourly: hourly(w),\n },\n daily: dailySeries(window),\n cohorts: cohorts(days),\n customers: customerStats(window),\n heatmap: heatmap(\n Object.fromEntries(Object.entries(window).filter(([d]) => d < today)),\n ),\n categories: categoryMix(all),\n top: topItems(all, 15),\n coupons: couponMix(all).slice(0, 14),\n pairs: pairs(all, 8),\n window_summary: summarizeDay(all),\n window: {\n from: winFrom,\n to: winTo,\n days: Object.keys(window).length,\n context: len < 2,\n },\n mtd: mtdBlock(days, today, true, target()),\n others,\n outlets: outlets.map((o) => ({ name: o.name, slug: slugify(o.name) })),\n period: mode === \"today\"\n ? null\n : {\n ...periodBlock(days, from, to, first),\n prev: periodBlock(days, prevFrom, prevTo, first),\n },\n };\n}","label",[18],"pulls","branches",1,"forks","envVars",{"_219":221,"_222":26},"connections",{"_219":26,"_220":26},"count","unfilledCount",10,"emptyCount",{"_39":203,"_13":18,"_68":69,"_49":-5,"_41":42,"_204":124,"_205":144,"_43":283,"_45":93,"_71":72,"_207":208,"_73":24,"_209":-5,"_237":284,"_17":285},{"_39":274,"_13":275,"_68":276,"_49":-5,"_41":42,"_204":277,"_205":144,"_43":278,"_45":245,"_71":279,"_207":280,"_73":24,"_209":-5,"_237":281,"_17":282},{"_39":265,"_13":266,"_68":142,"_49":-5,"_41":42,"_204":267,"_205":144,"_43":268,"_45":269,"_71":235,"_207":270,"_73":24,"_209":271,"_237":272,"_17":273},{"_39":257,"_13":258,"_68":259,"_49":-5,"_41":42,"_204":260,"_205":144,"_43":261,"_45":46,"_71":72,"_207":262,"_73":24,"_209":-5,"_237":263,"_17":264},{"_39":249,"_13":250,"_68":251,"_49":-5,"_41":42,"_204":252,"_205":144,"_43":253,"_45":26,"_71":21,"_207":254,"_73":24,"_209":-5,"_237":255,"_17":256},{"_39":240,"_13":241,"_68":242,"_49":-5,"_41":42,"_204":243,"_205":144,"_43":244,"_45":245,"_71":72,"_207":246,"_73":24,"_209":-5,"_237":247,"_17":248},{"_39":230,"_13":231,"_68":232,"_49":-5,"_41":42,"_204":233,"_205":144,"_43":234,"_45":26,"_71":235,"_207":236,"_73":24,"_209":-5,"_237":238,"_17":239},"065f1a3c-1769-443b-b623-655ea8269831","weekly-metrics.ts","c1023258-af7d-11f1-829b-1607ee4eb77e",49,["D",1789309006852],"http","// Weekly KN metrics for hypothesis tracking. Reads cached daily data, refreshes recent days.\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { isLive, loadDays, outletsFromEnv, Panel, salt, shift, slugify } from \"./lib.ts\";\n\nconst store = {\n get: (k: string) => blob.getJSON(k),\n set: (k: string, v: unknown) => blob.setJSON(k, v),\n};\n\nexport default async function (req: Request) {\n const o = outletsFromEnv()[0]; // Kamla Nagar\n const slug = slugify(o.name);\n const panel = new Panel(o.username, o.password);\n await panel.login();\n const now = new Date();\n const ist = new Date(now.getTime() + 5.5 * 3600 * 1000);\n const today = ist.toISOString().slice(0, 10);\n const yday = shift(today, -1);\n const days = await loadDays(panel, slug, \"2026-09-01\", yday, today, salt(), store);\n\n const cust: Record = {};\n const daily: Record = {};\n for (const d of Object.keys(days).sort()) {\n const arr = (days[d] ?? []).filter(isLive);\n let rev = 0, f69o = 0, f69rev = 0, freshO = 0, repO = 0, repRev = 0;\n for (const ord of arr) {\n const g = +ord.grandTotal || 0;\n rev += g;\n if ((ord.coupon ?? \"\").toUpperCase().trim() === \"FIRST69\") { f69o++; f69rev += g; }\n const c = ord.userPhone ?? \"anon\";\n let cu = cust[c];\n if (!cu) cu = cust[c] = { first: d, second: null, days: 0, orders: 0, spend: 0, lastDay: \"\" };\n if (cu.lastDay !== d) { cu.days++; if (cu.days === 2) cu.second = d; cu.lastDay = d; }\n cu.orders++; cu.spend += g;\n if (cu.first === d) freshO++; else { repO++; repRev += g; }\n }\n daily[d] = { o: arr.length, rev: +rev.toFixed(2), f69o, f69rev: +f69rev.toFixed(2), freshO, repO, repRev: +repRev.toFixed(2) };\n }\n const last7: string[] = [];\n for (let d = shift(yday, -6); d <= yday; d = shift(d, 1)) last7.push(d);\n let o7 = 0, r7 = 0, f7 = 0, fr7 = 0, rpO7 = 0, rpR7 = 0;\n for (const d of last7) {\n const v = daily[d]; if (!v) continue;\n o7 += v.o; r7 += v.rev; f7 += v.f69o; fr7 += v.f69rev; rpO7 += v.repO; rpR7 += v.repRev;\n }\n // Sep cohort 30-day return\n let cohort = 0, returned = 0, ret30 = 0;\n for (const cu of Object.values(cust)) {\n if (cu.first < \"2026-09-01\" || cu.first > \"2026-09-30\") continue;\n cohort++;\n if (cu.days > 1) {\n returned++;\n const lag = (new Date(cu.second!).getTime() - new Date(cu.first).getTime()) / 86400000;\n if (lag <= 30) ret30++;\n }\n }\n return Response.json({\n outlet: o.name, through: yday,\n last7: {\n range: [last7[0], last7[6]], orders: o7, rev: +r7.toFixed(2),\n aov: o7 ? +(r7 / o7).toFixed(2) : 0,\n f69share: o7 ? +(f7 / o7 * 100).toFixed(1) : 0,\n exF69AOV: o7 - f7 ? +((r7 - fr7) / (o7 - f7)).toFixed(2) : 0,\n repeatShare: o7 ? +(rpO7 / o7 * 100).toFixed(1) : 0,\n repeatAOV: rpO7 ? +(rpR7 / rpO7).toFixed(2) : 0,\n },\n sepCohort: { customers: cohort, returnedPct: cohort ? +(returned / cohort * 100).toFixed(1) : 0, returned30dPct: cohort ? +(ret30 / cohort * 100).toFixed(1) : 0 },\n daily,\n });\n}","children",[],[231],"3144c56d-c6d6-4810-a382-7809e5947ed1","template.ts","1184eb28-ae28-11f1-899d-1607ee4eb77e",51,["D",1789332871807],5,"// generated by the dashboard build; HTML for the Xpanse dashboard UI\nexport const TEMPLATE = \"\\n\\n\\n\\n\\nXpanse Live\\n\\n\\n\\n\\n\\n\\n

\\n

Xpanse

\\n

\\n \\n

\\n

loading\\u2026

\\n

\\n \\n From to \\n

\\n

Today

\\n

\\n\\n

Month against the \\u20b920 lakh target

\\n

\\n\\n

Live

\\n

Orders by hour today vs yesterday vs same weekday last week

\\n

Top sellers today

\\n

\\n\\n

Trend

\\n

Orders and net revenue per day

\\n

AOV and discount depth

\\n

New vs returning orders per day returning share on the right axis

\\n

Food attach, kiosk share, FIRST69 share

\\n

\\n\\n

Customers

\\n

Weekly cohorts share of new customers who ordered again within 7 / 14 / 30 days

\\n

Orders per customer

\\n

\\n\\n

Mix

\\n

Coupons orders \\u00b7 net AOV

\\n

Categories items

\\n

Top items quantity

\\n

Average orders by weekday and hour closed days in window

\\n

Bought together

\\n

\\n\\n

Other outlets

\\n

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

\\n\\n\\n\\n\";\n",[],[241],"8fa3c193-09c3-4b4a-8e4b-c4b1c21aac99","smtp.ts","911d8ce0-aeba-11f1-9863-1607ee4eb77e",33,["D",1789225174687],"// Minimal SMTP client for Gmail app-password auth.\n// Implicit TLS when SMTP_PORT=465, otherwise plain connect + STARTTLS.\nconst enc = new TextEncoder();\nconst dec = new TextDecoder();\n\nfunction b64(s: string): string {\n const bytes = enc.encode(s);\n let bin = \"\";\n for (const b of bytes) bin += String.fromCharCode(b);\n return btoa(bin);\n}\n\nfunction b64Wrapped(s: string): string {\n const b = b64(s);\n const lines: string[] = [];\n for (let i = 0; i < b.length; i += 76) lines.push(b.slice(i, i + 76));\n return lines.join(\"\\r\\n\");\n}\n\nclass Smtp {\n conn: any;\n buf = new Uint8Array(65536);\n filled = 0;\n constructor(conn: any) { this.conn = conn; }\n async readLine(): Promise {\n for (;;) {\n const idx = this.buf.subarray(0, this.filled).indexOf(10);\n if (idx >= 0) {\n const line = dec.decode(this.buf.subarray(0, idx + 1));\n this.buf.copyWithin(0, idx + 1, this.filled);\n this.filled -= idx + 1;\n return line;\n }\n const n = await this.conn.read(this.buf.subarray(this.filled));\n if (n === null) throw new Error(\"smtp: connection closed\");\n this.filled += n;\n }\n }\n async reply(): Promise {\n let out = \"\";\n for (;;) {\n const line = await this.readLine();\n out += line;\n if (/^\\d{3} /.test(line)) return out;\n if (!/^\\d{3}-/.test(line)) return out;\n }\n }\n async cmd(c: string): Promise {\n await this.conn.write(enc.encode(c + \"\\r\\n\"));\n return await this.reply();\n }\n close() { try { this.conn.close(); } catch { /* ignore */ } }\n}\n\nexport interface Mail { from: string; to: string[]; subject: string; text: string; }\n\nexport async function sendMail(m: Mail): Promise {\n const host = Deno.env.get(\"SMTP_HOST\") ?? \"smtp.gmail.com\";\n const port = +(Deno.env.get(\"SMTP_PORT\") ?? \"587\");\n const user = Deno.env.get(\"SMTP_USER\") ?? \"\";\n const pass = (Deno.env.get(\"SMTP_PASSWORD\") ?? \"\").replace(/\\s+/g, \"\");\n if (!user || !pass) throw new Error(\"smtp: SMTP_USER/SMTP_PASSWORD missing\");\n const s = new Smtp(port === 465\n ? await Deno.connectTls({ hostname: host, port })\n : await Deno.connect({ hostname: host, port }));\n const expect = (r: string, ok: number[], what: string) => {\n const code = +(r.slice(0, 3) || 0);\n if (!ok.includes(code)) throw new Error(`smtp ${what}: ${r.trim().slice(0, 200)}`);\n };\n try {\n expect(await s.reply(), [220], \"banner\");\n expect(await s.cmd(\"EHLO val-town\"), [250], \"ehlo\");\n if (port !== 465) {\n expect(await s.cmd(\"STARTTLS\"), [220], \"starttls\");\n s.conn = await Deno.startTls(s.conn, { hostname: host });\n s.filled = 0;\n expect(await s.cmd(\"EHLO val-town\"), [250], \"ehlo-tls\");\n }\n expect(await s.cmd(\"AUTH LOGIN\"), [334], \"auth\");\n expect(await s.cmd(b64(user)), [334], \"user\");\n expect(await s.cmd(b64(pass)), [235], \"pass\");\n expect(await s.cmd(`MAIL FROM:<${m.from}>`), [250], \"mail-from\");\n for (const rcpt of m.to) expect(await s.cmd(`RCPT TO:<${rcpt}>`), [250, 251], \"rcpt\");\n expect(await s.cmd(\"DATA\"), [354], \"data\");\n const headers = [\n `From: ${m.from}`,\n `To: ${m.to.join(\", \")}`,\n `Subject: =?UTF-8?B?${b64(m.subject)}?=`,\n `Date: ${new Date().toUTCString()}`,\n \"MIME-Version: 1.0\",\n 'Content-Type: text/plain; charset=\"UTF-8\"',\n \"Content-Transfer-Encoding: base64\",\n ].join(\"\\r\\n\");\n expect(await s.cmd(headers + \"\\r\\n\\r\\n\" + b64Wrapped(m.text) + \"\\r\\n.\"), [250], \"body\");\n await s.cmd(\"QUIT\").catch(() => \"\");\n } finally {\n s.close();\n }\n}",[],[250],"2854138b-399d-48fa-8cad-8f840c9120d7","report.ts","914ea44c-aeba-11f1-a7cf-1607ee4eb77e",53,["D",1789383399494],"// Xpanse hourly + close report builder/sender (replaces the Mac Python client).\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport {\n customerHistory,\n ddmmyyyy,\n hourOf,\n inr,\n isLive,\n loadDays,\n monthFirst,\n net,\n newVsReturning,\n Panel,\n pct,\n salt,\n sha,\n shift,\n slim,\n slugify,\n summarizeDay,\n topItems,\n} from \"./lib.ts\";\nimport { sendMail } from \"./smtp.ts\";\n\nconst store = {\n get: (k: string) => blob.getJSON(k),\n set: (k: string, v: unknown) => blob.setJSON(k, v),\n};\n\nexport interface RunOpts {\n mode?: \"auto\" | \"hourly\" | \"close\";\n toOverride?: string[];\n subjectPrefix?: string;\n dateOverride?: string; // test harness only\n}\n\n// ONE shared closing-date variable: prose and the trailing JSON both read this.\nexport function closingDateFor(now: any, isClose: boolean): string {\n return isClose ? shift(now.date, -1) : now.date;\n}\n\nexport async function runOutlet(o: any, now: any, opts: RunOpts = {}) {\n const isClose = opts.mode === \"close\" ? true : opts.mode === \"hourly\" ? false : now.hour === 0;\n const closingDate = opts.dateOverride ?? closingDateFor(now, isClose);\n const slug = slugify(o.name);\n const panel = new Panel(o.username, o.password);\n await panel.login();\n\n // Hard-fail guard: check the panel's raw status for the closing date before composing anything.\n const raw = await panel.get(\"summary/orders/get\", { date: ddmmyyyy(closingDate) });\n if (!raw.status) {\n if (isClose) {\n throw new Error(\n `guard: panel returned status:false for closing date ${closingDate} (${raw?.data?.title ?? \"unknown\"}) - close report skipped, no zeroed payload sent`,\n );\n }\n // Hourly on today's date: status:false can simply mean \"no orders yet\". Verify the API is\n // healthy by checking yesterday before treating zeros as truthful.\n const y = await panel.get(\"summary/orders/get\", { date: ddmmyyyy(shift(now.date, -1)) });\n if (!y.status) {\n throw new Error(`guard: panel unhealthy - ${closingDate} and ${shift(now.date, -1)} both status:false - report skipped`);\n }\n }\n const rawList = raw.status ? (raw?.data?.list ?? []) : [];\n const closingOrders = await Promise.all(\n rawList.map(async (x: any) => slim(x, await sha(salt() + (x.userPhone ?? \"\")))),\n );\n if (isClose && closingOrders.length === 0) {\n throw new Error(`guard: closing date ${closingDate} has zero orders - refusing to send a zeroed close report`);\n }\n\n const winStart = [monthFirst(closingDate), shift(closingDate, -7)].sort()[0];\n const days = await loadDays(panel, slug, winStart, closingDate, now.date, salt(), store);\n days[closingDate] = closingOrders; // fresh guarded data wins over any cached copy\n if (closingDate < now.date) {\n try {\n await store.set(`xp:${slug}:${closingDate}`, closingOrders);\n } catch { /* cache best-effort */ }\n }\n\n const d = summarizeDay(closingOrders);\n const lw = summarizeDay(days[shift(closingDate, -7)] ?? []);\n let mtdOrders = 0, mtdRevenue = 0;\n for (let dd = monthFirst(closingDate); dd <= closingDate; dd = shift(dd, 1)) {\n const s = summarizeDay(days[dd] ?? []);\n mtdOrders += s.orders;\n mtdRevenue += s.revenue;\n }\n mtdRevenue = +mtdRevenue.toFixed(2);\n const tops = topItems(closingOrders, 3);\n const topStr = tops.length ? tops.map((t: any) => `${t.name} (${t.qty})`).join(\", \") : \"none yet\";\n\n let subject: string;\n const lines: string[] = [];\n if (isClose) {\n const diff = +(d.revenue - lw.revenue).toFixed(2);\n subject = `${o.name} — day closed: ${d.orders} orders · ${inr(d.revenue)}`;\n lines.push(\n `Day closed: ${d.orders} orders, ${inr(d.revenue)} revenue, AOV ${inr(d.aov)}.`,\n `- ${inr(Math.abs(diff))} ${diff >= 0 ? \"ahead of\" : \"behind\"} same weekday last week (${lw.orders} orders).`,\n `- Month to date: ${mtdOrders} orders, ${inr(mtdRevenue)}.`,\n `- Top sellers: ${topStr}.`,\n );\n } else {\n const h = now.hour;\n const hh = ((h + 11) % 12) + 1, ap = h < 12 ? \"AM\" : \"PM\";\n const lh = closingOrders.filter((x: any) => isLive(x) && hourOf(x) === (h + 23) % 24);\n const lhRev = +lh.reduce((a: number, x: any) => a + net(x), 0).toFixed(2);\n subject = `${o.name}: ${d.orders} orders · ${inr(d.revenue)} · ${hh} ${ap} (+${lh.length} last hr)`;\n lines.push(\n `Today so far: ${d.orders} orders, ${inr(d.revenue)} revenue, AOV ${inr(d.aov)}.`,\n `- Month to date: ${mtdOrders} orders, ${inr(mtdRevenue)}.`,\n `- Last hour: +${lh.length} orders, +${inr(lhRev)}.`,\n `- Same weekday last week closed at ${lw.orders} orders / ${inr(lw.revenue)}.`,\n `- Top sellers: ${topStr}.`,\n );\n }\n\n // Prose and JSON both come from closingDate + d; they can never disagree.\n const json = `{\"start\": \"${closingDate}\", \"end\": \"${closingDate}\", \"orders\": ${d.orders}, \"revenue\": ${d.revenue}, \"cancelled\": ${d.cancelled}, \"beverages\": ${d.beverages}, \"food\": ${d.food}, \"aov\": ${d.aov}, \"ok\": true}`;\n const text = lines.join(\"\\n\") + \"\\n\\n\" + json;\n\n const to = opts.toOverride ??\n (Deno.env.get(\"EMAIL_TO\") ?? \"\").split(/[,;]/).map((x) => x.trim()).filter(Boolean);\n if (!to.length) throw new Error(\"EMAIL_TO is empty\");\n const from = Deno.env.get(\"EMAIL_FROM\") ?? Deno.env.get(\"SMTP_USER\") ?? \"\";\n const finalSubject = (opts.subjectPrefix ?? \"\") + subject;\n await sendMail({ from, to, subject: finalSubject, text });\n return { outlet: o.name, mode: isClose ? \"close\" : \"hourly\", closingDate, subject: finalSubject, orders: d.orders, revenue: d.revenue, recipients: to.length };\n}\n\n// ---------- combined KN-centric report (one email per run) ----------\n\n// Guarded fetch of the closing date plus the MTD window. Hard-fails per the\n// close-report rules: never compose an email from a status:false or zeroed close.\nasync function guardedDay(o: any, now: any, closingDate: string, isClose: boolean) {\n const slug = slugify(o.name);\n const panel = new Panel(o.username, o.password);\n await panel.login();\n const raw = await panel.get(\"summary/orders/get\", { date: ddmmyyyy(closingDate) });\n if (!raw.status) {\n if (isClose) {\n throw new Error(\n `guard: panel returned status:false for closing date ${closingDate} (${raw?.data?.title ?? \"unknown\"}) - close report skipped, no zeroed payload sent`,\n );\n }\n const y = await panel.get(\"summary/orders/get\", { date: ddmmyyyy(shift(now.date, -1)) });\n if (!y.status) {\n throw new Error(`guard: panel unhealthy - ${closingDate} and ${shift(now.date, -1)} both status:false - report skipped`);\n }\n }\n const rawList = raw.status ? (raw?.data?.list ?? []) : [];\n const orders = await Promise.all(\n rawList.map(async (x: any) => slim(x, await sha(salt() + (x.userPhone ?? \"\")))),\n );\n if (isClose && orders.length === 0) {\n throw new Error(`guard: closing date ${closingDate} has zero orders - refusing to send a zeroed close report`);\n }\n const winStart = [monthFirst(closingDate), shift(closingDate, -7)].sort()[0];\n const days = await loadDays(panel, slug, winStart, closingDate, now.date, salt(), store);\n days[closingDate] = orders;\n if (closingDate < now.date) {\n try { await store.set(`xp:${slug}:${closingDate}`, orders); } catch { /* best-effort */ }\n }\n return { days, orders };\n}\n\nfunction mtdOf(days: any, closingDate: string) {\n let mtdOrders = 0, mtdRevenue = 0;\n for (let dd = monthFirst(closingDate); dd <= closingDate; dd = shift(dd, 1)) {\n const s = summarizeDay(days[dd] ?? []);\n mtdOrders += s.orders;\n mtdRevenue += s.revenue;\n }\n return { mtdOrders, mtdRevenue: +mtdRevenue.toFixed(2) };\n}\n\nconst hr12 = (h: number) => `${((h + 11) % 12) + 1} ${h < 12 || h === 24 ? \"AM\" : \"PM\"}`;\n\n// One combined email: Kamla Nagar (outlets[0]) in full detail, the other\n// outlets as one-line benchmark/guardrail numbers for the same window.\nexport async function runCombined(outlets: any[], now: any, opts: RunOpts = {}) {\n const isClose = opts.mode === \"close\" ? true : opts.mode === \"hourly\" ? false : now.hour === 0;\n const closingDate = opts.dateOverride ?? closingDateFor(now, isClose);\n const primary = outlets[0];\n const others = outlets.slice(1);\n\n // --- primary (KN): hard guards, full detail ---\n const { days, orders } = await guardedDay(primary, now, closingDate, isClose);\n const d = summarizeDay(orders);\n const lwFull = summarizeDay(days[shift(closingDate, -7)] ?? []);\n const lwSameHour = summarizeDay(days[shift(closingDate, -7)] ?? [], now.hour);\n const { mtdOrders, mtdRevenue } = mtdOf(days, closingDate);\n const first = customerHistory(days);\n const nr = newVsReturning(orders, first, closingDate);\n const tops = topItems(orders, 3);\n const topStr = tops.length ? tops.map((t: any) => `${t.name} (${t.qty})`).join(\", \") : \"none yet\";\n\n // --- benchmarks: soft-fail, one line each ---\n const bench: string[] = [];\n for (const o of others) {\n try {\n const g = await guardedDay(o, now, closingDate, isClose);\n const s = summarizeDay(g.orders);\n const lwB = isClose\n ? summarizeDay(g.days[shift(closingDate, -7)] ?? [])\n : summarizeDay(g.days[shift(closingDate, -7)] ?? [], now.hour);\n const short = o.name.replace(\"Xpanse \", \"\");\n bench.push(\n `- ${short}: ${s.orders} orders, ${inr(s.revenue)}, AOV ${inr(s.aov)} · F69 ${pct(s.first69_share)} · food ${pct(s.food_attach)} (last wk ${isClose ? \"same day\" : \"by now\"}: ${lwB.orders} / ${inr(lwB.revenue)})`,\n );\n } catch (e: any) {\n bench.push(`- ${o.name.replace(\"Xpanse \", \"\")}: unavailable this run (${String(e?.message ?? e).slice(0, 80)})`);\n }\n }\n\n const lines: string[] = [];\n let subject: string;\n if (isClose) {\n const diff = +(d.revenue - lwFull.revenue).toFixed(2);\n subject = `KN closed: ${d.orders} orders · ${inr(d.revenue)} · AOV ${inr(d.aov)}`;\n lines.push(\n `KAMLA NAGAR - day closed (${closingDate}): ${d.orders} orders, ${inr(d.revenue)}, AOV ${inr(d.aov)}.`,\n `- ${inr(Math.abs(diff))} ${diff >= 0 ? \"ahead of\" : \"behind\"} same weekday last week (${lwFull.orders} orders, ${inr(lwFull.revenue)}).`,\n `- Returning share ${pct(nr.returning_share)} (${nr.returning} returning, ${nr.new} new). FIRST69 ${pct(d.first69_share)}, food attach ${pct(d.food_attach)}.`,\n `- Month to date: ${mtdOrders} orders, ${inr(mtdRevenue)}.`,\n `- Top sellers: ${topStr}.`,\n );\n } else {\n const fromHour = (now.hour - 3 + 24) % 24;\n const since = orders.filter((x: any) => isLive(x) && hourOf(x) >= fromHour);\n const sinceRev = +since.reduce((a: number, x: any) => a + net(x), 0).toFixed(2);\n subject = `KN: ${d.orders} orders · ${inr(d.revenue)} by ${hr12(now.hour)} (+${since.length} since ${hr12(fromHour)})`;\n lines.push(\n `KAMLA NAGAR - today so far (as of ${hr12(now.hour)}): ${d.orders} orders, ${inr(d.revenue)}, AOV ${inr(d.aov)}.`,\n `- Since ${hr12(fromHour)}: +${since.length} orders, +${inr(sinceRev)}.`,\n `- Same weekday last week by now: ${lwSameHour.orders} orders / ${inr(lwSameHour.revenue)} (closed ${lwFull.orders} / ${inr(lwFull.revenue)}).`,\n `- Returning share ${pct(nr.returning_share)} (${nr.returning} of ${d.orders}). FIRST69 ${pct(d.first69_share)}, food attach ${pct(d.food_attach)}.`,\n `- Month to date: ${mtdOrders} orders, ${inr(mtdRevenue)}.`,\n `- Top sellers: ${topStr}.`,\n );\n }\n lines.push(\"\", \"Benchmarks (same window):\", ...bench);\n\n // Prose and JSON both come from closingDate + d; they can never disagree.\n const json = `{\"start\": \"${closingDate}\", \"end\": \"${closingDate}\", \"orders\": ${d.orders}, \"revenue\": ${d.revenue}, \"cancelled\": ${d.cancelled}, \"beverages\": ${d.beverages}, \"food\": ${d.food}, \"aov\": ${d.aov}, \"ok\": true}`;\n const text = lines.join(\"\\n\") + \"\\n\\n\" + json;\n\n const to = opts.toOverride ??\n (Deno.env.get(\"EMAIL_TO\") ?? \"\").split(/[,;]/).map((x) => x.trim()).filter(Boolean);\n if (!to.length) throw new Error(\"EMAIL_TO is empty\");\n const from = Deno.env.get(\"EMAIL_FROM\") ?? Deno.env.get(\"SMTP_USER\") ?? \"\";\n const finalSubject = (opts.subjectPrefix ?? \"\") + subject;\n await sendMail({ from, to, subject: finalSubject, text });\n return { mode: isClose ? \"close\" : \"hourly\", closingDate, subject: finalSubject, orders: d.orders, revenue: d.revenue, recipients: to.length, to };\n}\n",[],[258],"d122e261-3ac8-49e6-b567-5888516fbec1","new-file-5192.ts",52,["D",1789332872449],6,"// Val Town HTTP val: Xpanse live dashboard + full-history analytics.\n// GET / dashboard UI (key-gated; DASH_KEY env)\n// GET /api/data?... live + selected-period view (unchanged behaviour)\n// GET /api/agg?outlet= full-history per-day aggregates (incremental blob cache)\n// GET /api/items?outlet= per-item totals with realised unit prices\n// Closed days are cached in blob forever; today is fetched live (memoised 60 s).\n// Self-contained: only reads stable primitives from lib.ts and never writes its keys,\n// so the hourly/close-report cron (main.ts) and weekly-metrics.ts are unaffected.\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport {\n buildDashboard,\n customerHistory,\n hourly,\n istNow,\n isLive,\n loadDays,\n net,\n newVsReturning,\n outletsFromEnv,\n Panel,\n salt,\n shift,\n slugify,\n summarizeDay,\n topItems,\n} from \"./lib.ts\";\nimport { TEMPLATE } from \"./template.ts\";\n\nconst store = {\n get: (k: string) => blob.getJSON(k),\n set: (k: string, v: unknown) => blob.setJSON(k, v),\n};\nconst panels = new Map();\nconst cache = new Map();\nconst AGG_V = \"v1\";\nconst CHUNK = 40; // closed days processed per request; client polls until done\n\n// ---- config (env-overridable) ----\nfunction jsonEnv(name: string, fallback: Record) {\n try {\n const raw = Deno.env.get(name);\n if (!raw) return fallback;\n const v = JSON.parse(raw);\n return v && typeof v === \"object\" ? v : fallback;\n } catch {\n return fallback;\n }\n}\nconst OPEN_DEFAULT: Record = {\n \"Xpanse Kamla Nagar\": \"2026-09-01\",\n \"Xpanse Gogol\": \"2025-07-08\",\n \"Xpanse Rajarampuri\": \"2025-10-25\",\n};\nconst RENT_DEFAULT: Record = {\n \"Xpanse Kamla Nagar\": 300000,\n \"Xpanse Gogol\": 45000,\n};\nconst openDates = () =>\n ({ ...OPEN_DEFAULT, ...(jsonEnv(\"OPEN_JSON\", {}) as Record) });\nconst rents = () =>\n ({ ...RENT_DEFAULT, ...(jsonEnv(\"RENT_JSON\", {}) as Record) });\n\nasync function panelFor(slug: string) {\n if (!panels.has(slug)) {\n const o = outletsFromEnv().find((x) => slugify(x?.name ?? \"\") === slug);\n if (!o) throw new Error(`unknown outlet slug: ${slug}`);\n const p = new Panel(o.username, o.password);\n await p.login();\n panels.set(slug, p);\n }\n return panels.get(slug)!;\n}\n\nfunction keyOk(given: string) {\n const key = Deno.env.get(\"DASH_KEY\") ?? \"\";\n if (!key) return true;\n if (given.length !== key.length) return false;\n let diff = 0;\n for (let i = 0; i < key.length; i++) {\n diff |= given.charCodeAt(i) ^ key.charCodeAt(i);\n }\n return diff === 0;\n}\n\nconst isF69 = (c: unknown) =>\n String(c ?? \"\").toUpperCase().trim() === \"FIRST69\";\n\ninterface DayAgg {\n o: number; rev: number; f69o: number; f69rev: number;\n repO: number; repRev: number; newC: number; can: number;\n}\ninterface CustRec { f: string; s: string | null }\ninterface AggState {\n daily: Record;\n cust: Record;\n items: Record;\n}\n\nconst emptyState = (): AggState => ({ daily: {}, cust: {}, items: {} });\n\nasync function readState(slug: string): Promise {\n try {\n const s = await store.get(`xp2:agg:${AGG_V}:${slug}`);\n if (s && s.daily && s.cust && s.items) return s as AggState;\n } catch { /* rebuild */ }\n return emptyState();\n}\n\n// Fold one closed day of raw orders into the aggregate state.\n// Guards every nested access: a malformed order or item can never throw here.\nfunction foldDay(st: AggState, d: string, orders: unknown) {\n const list = Array.isArray(orders) ? orders : [];\n const agg: DayAgg = {\n o: 0, rev: 0, f69o: 0, f69rev: 0, repO: 0, repRev: 0, newC: 0, can: 0,\n };\n const firstToday = new Set();\n for (const ord of list) {\n if (!ord || typeof ord !== \"object\") continue;\n if (!isLive(ord)) { agg.can++; continue; }\n const g = net(ord);\n agg.o++; agg.rev += g;\n if (isF69((ord as any).coupon)) { agg.f69o++; agg.f69rev += g; }\n const c = (ord as any).userPhone;\n if (c) {\n const cu = st.cust[c];\n if (cu) {\n if (cu.f < d) { agg.repO++; agg.repRev += g; }\n if (!cu.s && cu.f < d) cu.s = d;\n } else {\n firstToday.add(c);\n }\n }\n const items = (ord as any).orderItems;\n if (Array.isArray(items)) {\n for (const it of items) {\n if (!it || typeof it !== \"object\") continue;\n const nm = String((it as any).name ?? \"\").trim() || \"Unknown item\";\n const q = +(it as any).quantity || 1;\n const e = st.items[nm] ??= {\n qty: 0,\n rev: 0,\n cat: String((it as any).category ?? \"\"),\n };\n e.qty += q;\n e.rev += +(it as any).grandTotal || 0;\n }\n }\n }\n for (const c of firstToday) {\n if (!st.cust[c]) { st.cust[c] = { f: d, s: null }; agg.newC++; }\n }\n agg.rev = +agg.rev.toFixed(2);\n agg.f69rev = +agg.f69rev.toFixed(2);\n agg.repRev = +agg.repRev.toFixed(2);\n st.daily[d] = agg;\n}\n\n// Process up to CHUNK missing closed days; returns true when history is complete.\nasync function buildChunk(slug: string, force = false): Promise<{ done: boolean; remaining: number; through: string | null }> {\n const today = istNow().date;\n const yday = shift(today, -1);\n const outlet = outletsFromEnv().find((x) => slugify(x?.name ?? \"\") === slug);\n const open = openDates()[outlet?.name ?? \"\"] ?? \"2026-09-01\";\n const st = force ? emptyState() : await readState(slug);\n const missing: string[] = [];\n for (let d = open; d <= yday; d = shift(d, 1)) {\n if (!st.daily[d]) missing.push(d);\n }\n const todo = missing.slice(0, CHUNK);\n if (todo.length) {\n const panel = await panelFor(slug);\n const days = await loadDays(\n panel, slug, todo[0], todo[todo.length - 1], today, salt(), store,\n );\n for (const d of todo) foldDay(st, d, days[d] ?? []);\n await store.set(`xp2:agg:${AGG_V}:${slug}`, st);\n }\n const remaining = Math.max(0, missing.length - todo.length);\n return {\n done: remaining === 0,\n remaining,\n through: todo.length ? todo[todo.length - 1] : null,\n };\n}\n\nfunction weekKey(iso: string) { // Monday-start week label = the Monday's date\n const t = new Date(iso + \"T00:00:00Z\");\n t.setUTCDate(t.getUTCDate() - ((t.getUTCDay() + 6) % 7));\n return t.toISOString().slice(0, 10);\n}\n\nfunction aggResponse(slug: string, st: AggState, done: boolean, remaining: number) {\n const today = istNow().date;\n const dates = Object.keys(st.daily).sort();\n const daily = dates.map((d) => {\n const a = st.daily[d];\n const ex = a.o - a.f69o;\n return {\n d, o: a.o, rev: a.rev,\n aov: a.o ? +(a.rev / a.o).toFixed(2) : 0,\n f69s: a.o ? +(a.f69o / a.o * 100).toFixed(1) : 0,\n f69rev: a.f69rev,\n exAOV: ex ? +((a.rev - a.f69rev) / ex).toFixed(2) : 0,\n repS: a.o ? +(a.repO / a.o * 100).toFixed(1) : 0,\n repO: a.repO, newC: a.newC, can: a.can,\n };\n });\n // weekly rollup (Mon-Sun)\n const wk: Record = {};\n for (const d of dates) {\n const a = st.daily[d];\n const k = weekKey(d);\n const w = wk[k] ??= { o: 0, rev: 0, f69o: 0, f69rev: 0, repO: 0 };\n w.o += a.o; w.rev += a.rev; w.f69o += a.f69o; w.f69rev += a.f69rev; w.repO += a.repO;\n }\n const weekly = Object.keys(wk).sort().map((k) => {\n const w = wk[k];\n const ex = w.o - w.f69o;\n return {\n wk: k, o: w.o, rev: +w.rev.toFixed(2),\n aov: w.o ? +(w.rev / w.o).toFixed(2) : 0,\n f69s: w.o ? +(w.f69o / w.o * 100).toFixed(1) : 0,\n exAOV: ex ? +((w.rev - w.f69rev) / ex).toFixed(2) : 0,\n repS: w.o ? +(w.repO / w.o * 100).toFixed(1) : 0,\n };\n });\n // monthly cohorts from the customer map\n const co: Record = {};\n let sepC = 0, sepR7 = 0, sepR30 = 0;\n for (const cu of Object.values(st.cust)) {\n if (!cu?.f) continue;\n const m = cu.f.slice(0, 7);\n const c = co[m] ??= { customers: 0, r7: 0, r30: 0 };\n c.customers++;\n if (cu.s) {\n const gap = (Date.parse(cu.s) - Date.parse(cu.f)) / 864e5;\n if (gap <= 7) c.r7++;\n if (gap <= 30) c.r30++;\n if (m === \"2026-09\") {\n if (gap <= 7) sepR7++;\n if (gap <= 30) sepR30++;\n }\n }\n if (m === \"2026-09\") sepC++;\n }\n const cohorts = Object.keys(co).sort().map((m) => ({\n month: m,\n customers: co[m].customers,\n r7: +(co[m].r7 / co[m].customers * 100).toFixed(1),\n r30: +(co[m].r30 / co[m].customers * 100).toFixed(1),\n }));\n const totO = dates.reduce((s, d) => s + st.daily[d].o, 0);\n const totRev = dates.reduce((s, d) => s + st.daily[d].rev, 0);\n const totRep = dates.reduce((s, d) => s + st.daily[d].repO, 0);\n const open = dates.find((d) => st.daily[d].o > 0) ?? dates[0] ?? null;\n return {\n slug,\n open,\n built_through: dates[dates.length - 1] ?? null,\n done,\n remaining,\n generated: istNow().human,\n daily,\n weekly,\n cohorts,\n sepCohort: {\n customers: sepC,\n r7: sepC ? +(sepR7 / sepC * 100).toFixed(1) : 0,\n r30: sepC ? +(sepR30 / sepC * 100).toFixed(1) : 0,\n },\n totals: {\n orders: totO,\n revenue: +totRev.toFixed(2),\n customers: Object.keys(st.cust).length,\n aov: totO ? +(totRev / totO).toFixed(2) : 0,\n repeatShare: totO ? +(totRep / totO * 100).toFixed(1) : 0,\n },\n today, // client treats this date as \"live, fetch from /api/data\"\n };\n}\n\nfunction outletsMeta() {\n const opens = openDates(), rnts = rents();\n return outletsFromEnv().map((o) => ({\n name: o.name,\n slug: slugify(o?.name ?? \"\"),\n open: opens[o.name] ?? null,\n rent: rnts[o.name] ?? null,\n }));\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const given = url.searchParams.get(\"key\") ?? req.headers.get(\"x-dash-key\") ?? \"\";\n if (!keyOk(given)) {\n const api = url.pathname.startsWith(\"/api/\");\n return new Response(\n api ? JSON.stringify({ error: \"unauthorised\" }) : \"Add ?key=YOUR_KEY to the address.\",\n { status: 401, headers: { \"content-type\": api ? \"application/json\" : \"text/plain\" } },\n );\n }\n const json = (v: unknown, status = 200) =>\n new Response(JSON.stringify(v), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\", \"cache-control\": \"no-store\" },\n });\n\n if (url.pathname === \"/api/agg\" || url.pathname === \"/api/items\") {\n const meta = outletsMeta();\n const slug = url.searchParams.get(\"outlet\") || meta[0]?.slug || \"\";\n const force = url.searchParams.get(\"reset\") === \"1\";\n if (!meta.some((m) => m.slug === slug)) return json({ error: \"unknown outlet\" }, 404);\n const ck = `agg:${slug}:${url.pathname}`;\n if (!force) {\n const hit = cache.get(ck);\n if (hit && Date.now() - hit.at < 60_000) return json(hit.data);\n }\n try {\n const r = await buildChunk(slug, force);\n const st = await readState(slug);\n if (url.pathname === \"/api/items\") {\n const items = Object.entries(st.items)\n .map(([name, v]) => ({\n name,\n cat: v?.cat ?? \"\",\n qty: v?.qty ?? 0,\n rev: +(+((v?.rev ?? 0).toFixed?.(2) ?? 0)).valueOf(),\n unit: v?.qty ? +((v.rev ?? 0) / v.qty).toFixed(2) : 0,\n }))\n .sort((a, b) => b.qty - a.qty);\n const out = { slug, done: r.done, remaining: r.remaining, items, outlets: meta };\n if (r.done) cache.set(ck, { at: Date.now(), data: out });\n return json(out);\n }\n const out = { ...aggResponse(slug, st, r.done, r.remaining), outlets: meta };\n if (r.done) cache.set(ck, { at: Date.now(), data: out });\n return json(out);\n } catch (e) {\n return json({ error: `${(e as Error)?.name ?? \"Error\"}: ${(e as Error)?.message ?? e}` }, 500);\n }\n }\n\n if (url.pathname === \"/api/data\") {\n const outlets = outletsFromEnv();\n const slug = url.searchParams.get(\"outlet\") || slugify(outlets[0]?.name ?? \"\");\n const ndays = Math.max(7, Math.min(120, +(url.searchParams.get(\"days\") ?? 30)));\n const iso = (v: string | null) => v && /^\\d{4}-\\d{2}-\\d{2}$/.test(v) ? v : undefined;\n const from = iso(url.searchParams.get(\"from\")), to = iso(url.searchParams.get(\"to\"));\n const mode = url.searchParams.get(\"mode\") === \"today\" ? \"today\" : \"period\";\n const ck = `${slug}:${mode}:${from ?? \"\"}:${to ?? \"\"}`;\n const hit = cache.get(ck);\n let data = hit && Date.now() - hit.at < 60_000 ? hit.data : null;\n if (!data) {\n try {\n data = await buildDashboard(slug, ndays, store, panelFor, from, to, mode);\n cache.set(ck, { at: Date.now(), data });\n } catch (e) {\n return json({ error: `${(e as Error)?.name ?? \"Error\"}: ${(e as Error)?.message ?? e}` }, 500);\n }\n }\n return json(data);\n }\n\n return new Response(TEMPLATE, {\n headers: { \"content-type\": \"text/html; charset=utf-8\", \"cache-control\": \"no-store\" },\n });\n}\n","xpanse-dashboard",[],[266],"ff2cedd6-2915-4395-96fa-ea823f30bac4","main.ts","ab88dccc-ae26-11f1-88d3-1607ee4eb77e",54,["D",1789383399818],"interval","// Xpanse combined sales reports (one email per run, Kamla Nagar-centric).\n// Schedule (Val Town cron UI): 35 3,6,9,12,15,18 * * * UTC =\n// 9:05 AM, 12:05 PM, 3:05 PM, 6:05 PM, 9:05 PM IST so-far-today + 12:05 AM IST day-close.\nimport { email as alertEmail } from \"https://esm.town/v/std/email\";\nimport { istNow, outletsFromEnv } from \"./lib.ts\";\nimport { runCombined } from \"./report.ts\";\n\nexport default async function () {\n const now = istNow();\n try {\n const r = await runCombined(outletsFromEnv(), now);\n console.log(\"sent:\", r.subject);\n } catch (e: any) {\n console.error(\"FAILED combined report:\", e?.stack ?? e);\n try {\n await alertEmail({\n subject: `Xpanse monitor: combined report skipped on ${now.date} ${now.hour}:05 IST`,\n text:\n \"The combined report was NOT sent (data guard tripped or fetch/send failed). No zeroed payload was sent.\\n\\n\" +\n (e?.message ?? String(e)),\n });\n } catch (e2) {\n console.error(\"alert email failed\", e2);\n }\n }\n}\n",[],[275],["D",1789225171018],[],[18],["D",1789161653473],{"_11":12,"_181":76},{"_11":12,"_176":177,"_75":76,"_30":74,"_178":179,"_180":24},{"_45":167,"_13":16,"_39":42,"_168":131,"_169":-5,"_170":-5,"_171":-5,"_172":-5,"_173":-5,"_174":14,"_175":12},"ctx",{"_58":-5,"_200":323,"_324":325,"_326":327,"_328":24,"_329":24,"_330":24,"_331":144,"_332":-5,"_333":-7,"_334":-7,"_335":26,"_336":24,"_337":24,"_338":-5,"_339":24,"_340":24,"_341":24,"_342":-5},"ENV",{"_294":295,"_296":297,"_298":16,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322},"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"]

Top sellers

Other outlets

${title}

Xpanse

Today

Month against the \\u20b920 lakh target

Live

Orders by hour today vs yesterday vs same weekday last week

Top sellers today

Trend

Orders and net revenue per day

AOV and discount depth

New vs returning orders per day returning share on the right axis

Food attach, kiosk share, FIRST69 share

Customers

Weekly cohorts share of new customers who ordered again within 7 / 14 / 30 days

Orders per customer

Mix

Coupons orders \\u00b7 net AOV

Categories items

Top items quantity

Average orders by weekday and hour closed days in window

Bought together

Other outlets

Outlets side by side

Net revenue per month

Daily net revenue last 120 days

Repeat share 7-day rolling, orders from returning customers

FIRST69 share 7-day rolling

Launch benchmark each outlet aligned to its own day 1; KN vs how GG and RR launched

Cumulative net revenue by day since opening

Orders per day 7-day average since opening

FIRST69 share decay 7-day average since opening

Repeat share build 7-day average since opening

Kamla Nagar hypothesis tracker

Weekly revenue and repeat share

Weekly FIRST69 share and ex-FIRST69 AOV

Monthly cohorts share of new customers who returned within 7 / 30 days

Item economics realised price per unit (amount actually paid, sizes aggregated); full history through yesterday

History · lib.ts