[{"_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/community2.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/community2.ts","extension","id","1671320f-d6a7-4b5a-845f-c1aa06bfab55","community2.ts","fileId","1ccab384-a232-11f1-8072-1607ee4eb77e","parentId","0c5122a9-bcd5-498b-89dd-adb72a9f617b","branchId","dfaf1e7a-f8eb-4419-ac1e-aa00e1193983","branchVersion",30,"latest",true,"createdAt",["D",1787847154008],"version",0,"fileType","script","content","// Reviews + Promotions systems.\n// Reviews attach to completed orders (verified), update customer profile.\n// Promotions auto-expire and persist.\n\nimport { reply, replyEmbed, UI } from \"./embeds.ts\";\nimport type { CmdCtx } from \"./shop.ts\";\nimport { getCustomer, getOrder, generateCode } from \"./db.ts\";\n\nexport async function review(ctx: CmdCtx, sub: string): Promise> {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n switch (sub) {\n case \"add\": {\n const orderId = String(ctx.options[\"order\"] ?? \"\").toUpperCase();\n const rating = Math.min(5, Math.max(1, Math.floor(Number(ctx.options[\"rating\"] ?? 5))));\n const text = String(ctx.options[\"text\"] ?? \"\");\n const order = await getOrder(orderId);\n if (!order) return reply(\"No such order.\");\n if (order.customerId !== ctx.userId) return reply(\"You can only review your own orders.\");\n if (order.orderStatus !== \"completed\") return reply(\"You can only review completed orders.\");\n const dup = await sqlite.execute({ sql: \"SELECT * FROM reviews WHERE orderId = ?\", args: [orderId] });\n if (dup.rows.length) return reply(\"You already reviewed this order.\");\n const reviewId = \"R-\" + generateCode(6);\n await sqlite.execute({\n sql: \"INSERT INTO reviews (reviewId, userId, username, orderId, rating, text, verified, createdAt) VALUES (?, ?, ?, ?, ?, ?, 1, ?)\",\n args: [reviewId, ctx.userId, ctx.username, orderId, rating, text, new Date().toISOString()],\n });\n const cust = await getCustomer(ctx.userId);\n const newCount = (cust?.reviewsSubmitted ?? 0) + 1;\n const newAvg = cust && cust.avgRating\n ? Number((((cust.avgRating * cust.reviewsSubmitted) + rating) / newCount).toFixed(2))\n : rating;\n await sqlite.execute({\n sql: \"UPDATE customers SET reviewsSubmitted = reviewsSubmitted + 1, avgRating = ? WHERE userId = ?\",\n args: [newAvg, ctx.userId],\n });\n return replyEmbed(UI.success({\n title: \"⭐ Review Submitted\",\n description: `${\"⭐\".repeat(rating)} · ${orderId}`,\n fields: text ? [{ name: \"Review\", value: text, inline: false }] : undefined,\n }));\n }\n default:\n return reply(\"Unknown review command.\");\n }\n}\n\nexport async function promotion(ctx: CmdCtx, sub: string): Promise> {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n switch (sub) {\n case \"create\": {\n if (!ctx.isStaff && !ctx.isOwner) return reply(\"You don't have permission to create promotions.\");\n const target = (ctx.options[\"user\"] as string) ?? \"\";\n const userId = target.trim().replace(/[<@!>]/g, \"\");\n const pkg = String(ctx.options[\"package\"] ?? \"Standard\");\n const price = Math.max(0, Number(ctx.options[\"price\"] ?? 0));\n const days = Math.max(1, Math.floor(Number(ctx.options[\"days\"] ?? 7)));\n const promoId = \"PR-\" + generateCode(5);\n const now = new Date().toISOString();\n const end = new Date(Date.now() + days * 86400000).toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO promotions (promoId, userId, username, package, price, startTime, endTime, status, createdAt) VALUES (?, ?, ?, ?, ?, ?, ?, 'active', ?)\",\n args: [promoId, userId, ctx.username, pkg, price, now, end, now],\n });\n return replyEmbed(UI.success({\n title: \"📢 Promotion Created\",\n description: `**${promoId}** · ${pkg}`,\n fields: [\n { name: \"User\", value: `<@${userId}>`, inline: true },\n { name: \"Price\", value: `$${price.toFixed(2)}`, inline: true },\n { name: \"Expires\", value: ``, inline: true },\n ],\n }));\n }\n case \"status\": {\n const target = (ctx.options[\"user\"] as string) ?? \"\";\n const userId = target.trim().replace(/[<@!>]/g, \"\");\n const res = await sqlite.execute({ sql: \"SELECT * FROM promotions WHERE userId = ? ORDER BY createdAt DESC LIMIT 5\", args: [userId] });\n const rows = res.rows as any[];\n if (!rows.length) return reply(\"No promotions found for that user.\");\n const lines = rows.map((p) => `\\`${p.promoId}\\` · ${p.package} · ${p.status} · `).join(\"\\n\");\n return replyEmbed(UI.info({ title: \"📢 Promotions\", description: `<@${userId}>`, fields: [{ name: \"History\", value: lines, inline: false }] }));\n }\n default:\n return reply(\"Unknown promotion command.\");\n }\n}\n\n// Called by the scheduler to expire promotions.\nexport async function sweepExpiredPromotions(): Promise {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const res = await sqlite.execute(\"SELECT promoId, endTime, status FROM promotions WHERE status = 'active'\");\n const now = Date.now();\n let n = 0;\n for (const p of res.rows as any[]) {\n if (new Date(p.endTime).getTime() <= now) {\n await sqlite.execute({ sql: \"UPDATE promotions SET status='expired' WHERE promoId=?\", args: [p.promoId] });\n n++;\n }\n }\n return 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"]