[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":58,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","dashboard.ts","latestPath","fileId","95c2446e-ac50-11f1-af77-1607ee4eb77e","name","fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n if (url.searchParams.get(\"t\") !== Deno.env.get(\"DASHBOARD_TOKEN\")) {\n return new Response(\"Nope\", { status: 401 });\n }\n const data = await blob.getJSON(\"morbau_profit_snapshot\");\n if (!data) return new Response(\"Ingen data ännu – kör cron.ts först.\");\n\n const html = `\n\n\n\nMorbau Profit\n\n

Morbau

\n`;\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}","import { blob } from \"https://esm.town/v/std/blob\";\n\n// ===== FULFILLMENT-KOSTNADER (SEK per order) =====\nconst FULFILLMENT: Record = {\n \"Sweden\": 80,\n};\nconst FULFILLMENT_DEFAULT = 100; // alla andra länder\n// =================================================\n\nconst KEY = Deno.env.get(\"WINDSOR_API_KEY\");\nconst fmt = (d: Date) => d.toISOString().slice(0, 10);\nconst num = (v: any) => Number(v) || 0;\n\nasync function windsor(\n connector: string,\n fields: string,\n from: string,\n to: string,\n) {\n const url =\n `https://connectors.windsor.ai/${connector}?api_key=${KEY}&fields=${fields}&date_from=${from}&date_to=${to}`;\n const r = await fetch(url);\n if (!r.ok) {\n throw new Error(\n `${connector} [${fields.slice(0, 40)}...]: ${r.status} ${await r.text()}`,\n );\n }\n return (await r.json()).data as any[];\n}\n\nexport default async function () {\n const today = new Date();\n const yesterday = new Date(today);\n yesterday.setUTCDate(today.getUTCDate() - 1);\n const start30 = new Date(today);\n start30.setUTCDate(today.getUTCDate() - 30);\n const start45 = new Date(today);\n start45.setUTCDate(today.getUTCDate() - 45);\n const from = fmt(start30), to = fmt(yesterday);\n\n const [fb, ga, orders, txns] = await Promise.all([\n windsor(\"facebook\", \"date,spend,action_values_omni_purchase\", from, to),\n windsor(\"google_ads\", \"date,spend\", from, to),\n windsor(\n \"shopify\",\n \"order_id,order_created_at,order_current_total_price,order_current_total_tax,order_current_shipping_price,order_count,order_cost_of_goods_sold,order_shipping_address_country\",\n from,\n to,\n ),\n // bredare fönster: avgiften bokförs vid utbetalning, några dagar efter ordern\n windsor(\n \"shopify\",\n \"balance_transaction_order_id,balance_transaction_fee,balance_transaction_type\",\n fmt(start45),\n fmt(today),\n ),\n ]);\n\n // order_id -> summerad avgift\n const feeByOrder: Record = {};\n for (const t of txns) {\n const id = t.balance_transaction_order_id;\n if (!id) continue;\n feeByOrder[id] = (feeByOrder[id] || 0) +\n Math.abs(num(t.balance_transaction_fee));\n }\n\n const days: Record = {};\n const day = (\n d: string,\n ) => (days[d] ??= {\n sales: 0,\n vat: 0,\n ship: 0,\n orders: 0,\n cogs: 0,\n fees: 0,\n fulfillment: 0,\n fb: 0,\n fbVal: 0,\n ga: 0,\n });\n\n for (const o of orders) {\n if (!o.order_created_at) continue;\n const x = day(o.order_created_at.slice(0, 10));\n x.sales += num(o.order_current_total_price);\n x.vat += num(o.order_current_total_tax);\n x.ship += num(o.order_current_shipping_price);\n x.orders += num(o.order_count);\n x.cogs += num(o.order_cost_of_goods_sold);\n x.fees += feeByOrder[o.order_id] || 0;\n const land = o.order_shipping_address_country;\n x.fulfillment += (FULFILLMENT[land] ?? FULFILLMENT_DEFAULT) *\n (num(o.order_count) || 1);\n }\n for (const r of fb) {\n if (!r.date) continue;\n const x = day(r.date.slice(0, 10));\n x.fb += num(r.spend);\n x.fbVal += num(r.action_values_omni_purchase);\n }\n for (const r of ga) {\n if (!r.date) continue;\n const x = day(r.date.slice(0, 10));\n x.ga += num(r.spend);\n }\n\n function win(n: number) {\n const s = {\n sales: 0,\n vat: 0,\n ship: 0,\n orders: 0,\n cogs: 0,\n fees: 0,\n fulfillment: 0,\n fb: 0,\n fbVal: 0,\n ga: 0,\n };\n for (let i = 1; i <= n; i++) {\n const d = new Date(today);\n d.setUTCDate(today.getUTCDate() - i);\n const x = days[fmt(d)];\n if (!x) continue;\n for (const k in s) (s as any)[k] += x[k];\n }\n const netSales = s.sales - s.vat - s.ship;\n const gross = netSales - s.cogs;\n const contribution = gross - s.fulfillment - s.fees - s.fb - s.ga;\n return {\n totalSales: s.sales,\n vat: s.vat,\n shipping: s.ship,\n netSales,\n cogs: s.cogs,\n grossProfit: gross,\n fulfillment: s.fulfillment,\n transactionFees: s.fees,\n fbSpend: s.fb,\n gaSpend: s.ga,\n contributionProfit: contribution,\n orders: s.orders,\n netMargin: netSales ? contribution / netSales : 0,\n blendedMER: (s.fb + s.ga) ? s.sales / (s.fb + s.ga) : 0,\n metaROAS: s.fb ? s.fbVal / s.fb : 0,\n };\n }\n\n const snapshot = {\n updatedAt: new Date().toISOString(),\n yesterday: win(1),\n d7: win(7),\n d30: win(30),\n };\n await blob.setJSON(\"morbau_profit_snapshot\", snapshot);\n console.log(\"Klart:\", JSON.stringify(snapshot.yesterday));\n}","createdAt",["D",1788961637618],"branchVersion","branchId","50810d2a-f71b-410f-9c21-3314c8ddf646","id","7a44b39e-38ca-4c74-9e8b-6c81b5342af0","Morbau-profit",["D",1788959753473],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Profit dashboard","imageUrl","ac31039a-d9bb-492f-9301-5a07b8edcd0a","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019ecb56-6a2f-729e-add7-36fda18ceb0d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Morbau","handle","displayName","Vidar Sjöqvist","avatar","https://lh3.googleusercontent.com/a/ACg8ocJqAE1OCOvrDT6kM8CwE7ZimW0u2dVgwLxZIGTEi5YjYAsg-A=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":166,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":167,"_80":168,"_82":169,"_84":25},"tree",[157,158],"files",[157,158],"counts",{"_145":62,"_146":147,"_148":62,"_149":150,"_151":152},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":140,"_13":141,"_33":142,"_35":143,"_24":25,"_134":-5,"_27":144},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"69e6ab58-3469-4e89-8b5c-443f94a5cbc9","parentId","latest",["D",1788961637618],8,"label",[28],"c86a9e22-3df8-4162-973b-a9e3f509d7b6","cron.ts","5466d50e-ac53-11f1-a462-1607ee4eb77e",11,["D",1788961019644],3,"interval","import { blob } from \"https://esm.town/v/std/blob\";\n\n// ===== JUSTERA DESSA =====\nconst FULFILLMENT_PER_ORDER = 45; // SEK per order\nconst TXN_FEE_PCT = 0.0175; // Shopify Payments %\nconst TXN_FEE_FIXED = 1.8; // SEK per transaktion\n// =========================\n\nconst FB_FIELDS = \"date,spend,action_values_omni_purchase\";\nconst GA_FIELDS = \"date,spend\";\nconst SHOP_FIELDS =\n \"order_created_at,order_current_total_price,order_current_total_tax,order_current_shipping_price,order_count,order_cost_of_goods_sold\";\n\nconst KEY = Deno.env.get(\"WINDSOR_API_KEY\");\nconst fmt = (d: Date) => d.toISOString().slice(0, 10);\nconst num = (v: any) => Number(v) || 0;\n\nasync function windsor(\n connector: string,\n fields: string,\n from: string,\n to: string,\n) {\n const url =\n `https://connectors.windsor.ai/${connector}?api_key=${KEY}&fields=${fields}&date_from=${from}&date_to=${to}`;\n const r = await fetch(url);\n if (!r.ok) throw new Error(`${connector}: ${r.status} ${await r.text()}`);\n return (await r.json()).data as any[];\n}\n\nexport default async function () {\n const today = new Date();\n const yesterday = new Date(today);\n yesterday.setUTCDate(today.getUTCDate() - 1);\n const start30 = new Date(today);\n start30.setUTCDate(today.getUTCDate() - 30);\n const from = fmt(start30), to = fmt(yesterday);\n\n const [fb, ga, orders] = await Promise.all([\n windsor(\"facebook\", FB_FIELDS, from, to),\n windsor(\"google_ads\", GA_FIELDS, from, to),\n windsor(\"shopify\", SHOP_FIELDS, from, to),\n ]);\n\n const days: Record = {};\n const day = (\n d: string,\n ) => (days[d] ??= {\n sales: 0,\n vat: 0,\n ship: 0,\n orders: 0,\n cogs: 0,\n fb: 0,\n fbVal: 0,\n ga: 0,\n });\n\n for (const o of orders) {\n if (!o.order_created_at) continue;\n const x = day(o.order_created_at.slice(0, 10));\n x.sales += num(o.order_current_total_price);\n x.vat += num(o.order_current_total_tax);\n x.ship += num(o.order_current_shipping_price);\n x.orders += num(o.order_count);\n x.cogs += num(o.order_cost_of_goods_sold);\n }\n for (const r of fb) {\n if (!r.date) continue;\n const x = day(r.date.slice(0, 10));\n x.fb += num(r.spend);\n x.fbVal += num(r.action_values_omni_purchase);\n }\n for (const r of ga) {\n if (!r.date) continue;\n const x = day(r.date.slice(0, 10));\n x.ga += num(r.spend);\n }\n\n function win(n: number) {\n const s = {\n sales: 0,\n vat: 0,\n ship: 0,\n orders: 0,\n cogs: 0,\n fb: 0,\n fbVal: 0,\n ga: 0,\n };\n for (let i = 1; i <= n; i++) {\n const d = new Date(today);\n d.setUTCDate(today.getUTCDate() - i);\n const x = days[fmt(d)];\n if (!x) continue;\n for (const k in s) (s as any)[k] += x[k];\n }\n const netSales = s.sales - s.vat - s.ship;\n const gross = netSales - s.cogs;\n const fulfillment = s.orders * FULFILLMENT_PER_ORDER;\n const fees = s.sales * TXN_FEE_PCT + s.orders * TXN_FEE_FIXED;\n const contribution = gross - fulfillment - fees - s.fb - s.ga;\n return {\n totalSales: s.sales,\n vat: s.vat,\n shipping: s.ship,\n netSales,\n cogs: s.cogs,\n grossProfit: gross,\n fulfillment,\n transactionFees: fees,\n fbSpend: s.fb,\n gaSpend: s.ga,\n contributionProfit: contribution,\n orders: s.orders,\n netMargin: netSales ? contribution / netSales : 0,\n blendedMER: (s.fb + s.ga) ? s.sales / (s.fb + s.ga) : 0,\n metaROAS: s.fb ? s.fbVal / s.fb : 0,\n };\n }\n\n const snapshot = {\n updatedAt: new Date().toISOString(),\n yesterday: win(1),\n d7: win(7),\n d30: win(30),\n };\n await blob.setJSON(\"morbau_profit_snapshot\", snapshot);\n console.log(\"Klart:\", JSON.stringify(snapshot.yesterday));\n}",[137],"pulls","branches",1,"forks","envVars",{"_153":155,"_156":62},"connections",{"_153":62,"_154":62},"count","unfilledCount",2,"emptyCount",{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":163,"_13":141,"_33":142,"_35":143,"_24":25,"_134":-5,"_160":164,"_27":165},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":159,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_160":161,"_27":162},["D",1788961637618],"children",[],[28],["D",1788961019644],[],[137],["D",1788959753473],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_124":203,"_204":205,"_206":207,"_208":25,"_209":25,"_210":25,"_211":58,"_212":-5,"_213":-7,"_214":-7,"_215":62,"_216":25,"_217":25,"_218":-5,"_219":25,"_220":25,"_221":25,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":86,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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"]

Diff · v13