[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_108":109,"_110":111},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","eixixddizca","name","discord-shop-bot","path","lib/orders.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/eixixddizca/discord-shop-bot/code/lib/orders.ts","extension","id","01a30cf0-db71-477c-83c7-420ff034e276","orders.ts","fileId","20fbe168-a231-11f1-a3ba-1607ee4eb77e","parentId","0c5122a9-bcd5-498b-89dd-adb72a9f617b","branchId","dfaf1e7a-f8eb-4419-ac1e-aa00e1193983","branchVersion",11,"latest",true,"createdAt",["D",1787846731533],"version",0,"fileType","script","content","// Order system: buy flow, order view/history, receipts.\n// When an order is placed it also updates the customer profile, spending,\n// and last-purchase — the start of the system integration chain.\n\nimport { reply, replyEmbed, UI, type EmbedField } from \"./embeds.ts\";\nimport type { CmdCtx } from \"./shop.ts\";\nimport {\n createOrder,\n ensureCustomer,\n getCustomer,\n getOrder,\n getProduct,\n listOrdersByCustomer,\n money,\n} from \"./db.ts\";\nimport { setStock } from \"./shop.ts\";\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\n\n// ----- /shop buy -----\nexport async function buy(ctx: CmdCtx): Promise> {\n const productId = (ctx.options[\"product\"] as string) ?? \"\";\n const qty = Math.max(1, Math.floor(Number(ctx.options[\"quantity\"] ?? 1)));\n const product = await getProduct(productId);\n if (!product) return reply(\"That product doesn't exist.\");\n if (product.status !== \"active\" || product.stock < qty) {\n return reply(\"That product is unavailable or out of stock.\");\n }\n\n const customer = await ensureCustomer(ctx.userId, ctx.username);\n if (customer.blacklisted) {\n return reply(\"You are restricted from using the shop. Contact staff for details.\");\n }\n\n // One atomic decrement is enough for the single-customer click path.\n await setStock(product.productId, product.stock - qty);\n const order = await createOrder(customer, product, qty, null);\n\n // Integrated bookkeeping: customer profile ← this order.\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: `UPDATE customers SET\n totalOrders = totalOrders + 1,\n totalSpent = totalSpent + ?,\n lastPurchase = ?,\n lastActivity = ?\n WHERE userId = ?`,\n args: [order.finalAmount, now, now, customer.userId],\n });\n await queueChannelMessage(ctx.guildId, order.orderId); // staff fulfillment channel notice\n\n return { type: 4, data: { embeds: [receiptEmbed(order)], flags: 64, content: \"✅ Order placed!\" } };\n}\n\n// ----- /order view -----\nexport async function viewOrder(ctx: CmdCtx): Promise> {\n const orderId = (ctx.options[\"order\"] as string) ?? \"\";\n const order = await getOrder(orderId.toUpperCase());\n if (!order) return reply(\"That order doesn't exist.\");\n // customers see only their own; staff/owner see any\n if (order.customerId !== ctx.userId && !ctx.isStaff && !ctx.isOwner) {\n return reply(\"You can only view your own orders.\");\n }\n return replyEmbed(receiptEmbed(order));\n}\n\n// ----- /order history -----\nexport async function orderHistory(ctx: CmdCtx): Promise> {\n const customerId = (ctx.options[\"customer\"] as string) ?? ctx.userId;\n const rows = await listOrdersByCustomer(customerId, 10);\n if (rows.length === 0) return reply(\"No orders found for this customer.\");\n const fields: EmbedField[] = rows.map((o) => ({\n name: `${o.orderId} · ${o.productName}`,\n value: `${o.quantity} × ${money(o.unitPrice, \"USD\")} = **${money(o.finalAmount, \"USD\")}** · ${o.orderStatus}`,\n inline: false,\n }));\n return replyEmbed(\n UI.info({ title: \"📜 Order History\", description: `Last ${rows.length} orders`, fields }),\n );\n}\n\n// ----- receipt (shared by /order view and purchase confirmation) -----\nimport type { OrderRow } from \"./db.ts\";\nexport function receiptEmbed(order: OrderRow) {\n const statusEmoji: Record = {\n pending: \"🕐\", payment_pending: \"💳\", paid: \"✅\", processing: \"⚙️\",\n completed: \"🏁\", cancelled: \"❌\", refunded: \"↩️\",\n };\n return UI.info({\n title: \"🧾 Receipt\",\n description: `**${order.orderId}**`,\n fields: [\n { name: \"Customer\", value: `${order.customerName}`, inline: true },\n { name: \"Product\", value: order.productName, inline: true },\n { name: \"Quantity\", value: `${order.quantity}`, inline: true },\n { name: \"Unit Price\", value: money(order.unitPrice, \"USD\"), inline: true },\n { name: \"Discount\", value: money(order.discount, \"USD\"), inline: true },\n { name: \"Total\", value: `**${money(order.finalAmount, \"USD\")}**`, inline: true },\n { name: \"Status\", value: `${statusEmoji[order.orderStatus] ?? \"🕐\"} ${order.orderStatus}`, inline: true },\n { name: \"Placed\", value: ``, inline: true },\n ],\n });\n}\n\n// ----- staff /order fulfill -----\nexport async function updateOrder(ctx: CmdCtx): Promise> {\n if (!ctx.isStaff && !ctx.isOwner) return reply(\"You don't have permission to update orders.\");\n const order = await getOrder(String(ctx.options[\"order\"] ?? \"\").toUpperCase());\n if (!order) return reply(\"That order doesn't exist.\");\n const status = String(ctx.options[\"status\"] ?? \"\");\n if (!status) return reply(\"Specify a status.\");\n const now = new Date().toISOString();\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const completedAt = [\"completed\", \"cancelled\", \"refunded\"].includes(status) ? now : order.completedAt;\n await sqlite.execute({\n sql: \"UPDATE orders SET orderStatus = ?, completedAt = ?, staffId = ? WHERE orderId = ?\",\n args: [status, completedAt, ctx.userId, order.orderId],\n });\n if (status === \"completed\") {\n await sqlite.execute({\n sql: `UPDATE customers SET completedOrders = completedOrders + 1 WHERE userId = ?`,\n args: [order.customerId],\n });\n }\n return reply(`**${order.orderId}** → \\`${status}\\``);\n}\n\n// Best-effort staff notification for new orders (uses configured channel).\nasync function queueChannelMessage(guildId: string, orderId: string): Promise {\n const token = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n if (!token || !guildId) return;\n try {\n // Harness reads guild channel config from project config (added in panel phase).\n const cfg = (await import(\"./config.ts\")).getConfig;\n const c = await cfg();\n const channelId = c.channels[\"orders\"];\n if (!channelId) return;\n await fetch(`${DISCORD_API}/channels/${channelId}/messages`, {\n method: \"POST\",\n headers: { authorization: `Bot ${token}`, \"content-type\": \"application/json\" },\n body: JSON.stringify({ content: `🆕 New order \\`${orderId}\\` placed.` }),\n });\n } catch (e) {\n console.error(\"order notify failed:\", e);\n }\n}\n","deleted",false,"label",[47,24],"lib","438fe6a4-2424-4e5d-9feb-81f46ecbe799",["D",1787846270953],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Modular Discord shop & community bot","imageUrl","userId","6b376f3a-5347-4c3a-b4ec-787b333560af","pinnedFileId","27082d74-a230-11f1-8efc-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a043e6-75ad-74fe-b7a7-17e3786f5114","tursoName","438fe6a424244e5d9feb81f46ecbe799","tursoHostname","438fe6a424244e5d9feb81f46ecbe799-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_107":102},"org",{"_9":10,"_101":102,"_103":102,"_58":59,"_104":105,"_106":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",61,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_84":-5,"_141":142,"_143":144,"_145":146,"_147":44,"_148":44,"_149":44,"_150":34,"_151":-5,"_152":-7,"_153":-7,"_154":38,"_155":44,"_156":44,"_157":-5,"_158":44,"_159":44,"_160":44,"_161":-5},"ENV",{"_112":113,"_114":115,"_116":92,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]